Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Dave Ferguson / Dave Ferguson (Dave Ferguson)
Created: 08/12/2014
Components: Mobile Support
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Major / All users will encounter
Locale/System: ALL / Other
Vote Count: 27
Params only in an array work. Any params in a struct appear to not work at all. With the code below in a client cfc only the last query works. The others return no results or errors. However, based on the documentation all are valid.
public function testQueryParams( myId ){
qry = queryExecute("SELECT * FROM test where id = :id", {id=myId}, {"datasource"="myDB"});
console.log(qry);
qry = queryExecute("SELECT * FROM test where id = :id", {id={value=myId}}, {"datasource"="myDB"});
console.log(qry);
qry = queryExecute("SELECT * FROM test where id = :id", {id:myId}, {"datasource"="myDB"});
console.log(qry);
qry = queryExecute("SELECT * FROM test where id = ?", {id=myId}, {"datasource"="myDB"});
console.log(qry);
qry = queryExecute("SELECT * FROM test where id = ?", {id='#myId#'}, {"datasource"="myDB"});
console.log(qry);
qry = queryExecute("SELECT * FROM test where id = ?", {id='myId'}, {"datasource"="myDB"});
console.log(qry);
qry = queryExecute("SELECT * FROM test where id = ?", [edid], {"datasource"="myDB"});
console.log(qry);
return;
}
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3804384
External Customer Info:
External Company:
External Customer Name: fergusondj
External Customer Email:
Attachments:
Comments: