The debug output says you got 14 rows back with the CFQUERYPARAM tag in there, not zero, so something's screwy.
cheers, barneyb On Thu, 6 Jan 2005 15:09:47 +1100, Duncan I Loxton <[EMAIL PROTECTED]> wrote: > 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. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 9 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:189475 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
