Are you sure request.departmentTable is a valid table? ======================================================================== === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
Email : [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 6:46 PM > To: CF-Talk > Subject: cfquery question??? > > > SELECT > title,template,layout,meta_description,short_description,keywo > rds,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
