I've been experimenting a lot with QueryRun() recently (which I absolutely
love--see blog post here for one cool trick I discovered:
http://bit.ly/cHH8dD), but I think there may be an issue with the null
parameter in the array of structs that are used in lieu of CFQUERYPARAM.
Dumb example, but illustrates the problem:
userParams = [{value = 1, cfsqltype = "cf_sql_integer", null = true}];
userSQL = "select * from user where id = ?";
users = QueryRun("test", userSQL, userParams);
When I run that I get a Bad File Execption:
TypeTemplateMessageBadly formatted tagPositionLine=3; Column=58DetailProblem
occurred while parsing: Encountered invalid token after "NULL"Source
1: <cfscript>
2: userSQL = "select * from user where id = ?";
3: userParams = [{value = 1, cfsqltype = "cf_sql_integer", NULL = true}];
4: users = QueryRun("test", userSQL, userParams);
5: </cfscript>
Maybe a conflict due to the null keyword also being available?
--
Matthew Woodward
m...@mattwoodward.com
http://blog.mattwoodward.com
identi.ca/Twitter: @mpwoodward
Please do not send me proprietary file formats such as Word, PowerPoint,
etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html
|
