parameterbinding

Dynamically set the DefaultValue of a ParameterBinding in a DataFormWebPart

In my custom aspx page in WSS I am using a DataFormWebPart with an xsl file to render some data. In order to pass values to the xsl I use parameter bindings. Specifically, I need to pass in the server host url like this: <ParameterBinding Name="HttpHost" Location="CAMLVariable" DefaultValue="http://hardcoded.com" /> Thi...

Mysqli parameter binding issue

I need an extra set of eyes on this one. Any help will be greatly appreciated. This is a very simple search query, but for whatever reason I cannot find the bug. Well, I know where the bug is. I just can't get past it. Anyway..... I am taking a search value from a POST variable, setting that variable and then setting a column variable a...

Parameter binding fails where concatenation works

I am trying to execute the following sql from php using pdo: SELECT * FROM my_table WHERE name=?. When I do this: $sql = 'SELECT * FROM my__table WHERE name=?' ; $stmt = $dbconn->prepare($sql); $stmt->bindValue(1, $_POST['name'], PDO::PARAM_STR); $stmt->execute(); I get an empty result set. When I do this: $sql = 'SELECT ...