RE: There is still problem, Gordon Hsu, 07-23-2006
Need to replace those in the variable
by Roger Harris, July 23, 2006 08:42
In SQL, any apostrophes inside an apostrophe-quoted value need to be replaced with a pair of apostrophes. ODBscript normally does that for you automatically when you use a variable in an SQL statement such as Column='$var$' (or your SQL StoredProcName '$Var$' statement). However, in this case, it seems the $IF(...) with a quoted apostrophe followed by a variable is confusing that special processing, and it isn't happening. So, you will need to explicitly replace any apostrophes in the value with a pair of apostrophes, which can be done with the $repl(...) function:<!--SQL StoredProcName $IF($Var$,"'"$repl($Var$,"'"="''")"'",NULL) -->That's a bit obtuse, but it works. Perhaps it would be nice to add a new special function that knows how to return either NULL or a properly quoted value for use in SQL statements.
Name E-mail optional TopicMessage:
HTTP Link: Link text: