I have just started to adopt something that I have seen on this list
cfqueryparam, amongst a host of other best practices that I have been
picking up whilst reading here.
My query looks like this:
<cfquery name="getChildren" dataSource="#Application.DataSource#"
userName="#Application.DBUserName#"
password="#Application.DBUserPwd#">
select con_id, con_title
FROM wwwContent
WHERE cot_id = <cfqueryparam cfsqltype="cf_sql_integer"
value="#attributes.cotid#">
</cfquery>
with cotid coming in from the URL.
but I get no results and the debug looks like this:
getChildren (Datasource=MPlus_dev, Time=0ms, Records=14) in
C:\Development\mars.mcgrath.com.au\live\content\model\qry_getChildren.cfm
@ 14:50:12.012
select con_id, con_title
FROM wwwContent
WHERE cot_id = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 63
If I remove the cfqueryparam it works fine and I get one row returned. WTF??
I am using FuseBox 4, CFMX, and SQL server 2000.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189473
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
