see reply to ray. of course i checked all that, this is on my dev box @ home... :) i can see all that !!!
see my reply! tw -----Original Message----- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 8:54 PM To: CF-Talk Subject: RE: cfquery question??? Best bet is to activate debugging and see what the actual query being executed is. That'll let you know for sure what each variable is equal to at the time of query execution. Also, are you sure that the table name is correct? -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 8:46 PM > To: CF-Talk > Subject: cfquery question??? > > > SELECT > title,template,layout,meta_description,short_description,keywords,conten > t,image_a,image_b,image_c, > build_date,state > FROM #request.departmentTable# > WHERE id = #url.id# > > how could this query above possibly bomb > when in cfquery tag, yet not in query analyzer > when i know that url.id = 175 and that the > column type is int? > > thanks > > ....tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
