Build your SQL statement in a cfset like <cfset sql = "Select * From " & #variable# & " Where ID = " & #id#> and then use your new variable in the cfquery like: <cfquery name="" datasource=""> #sql# </cfquery> I have done this and it works... HTH ---------- Original Message ---------------------------------- From: Sim Graves <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 21:21:14 -0400 Dear Friends, I need to have the table in my SQL query created dynamically. Every syntax scheme that I've tried has failed. SELECT * FROM #variable# WHERE ID=#ID# etc. etc. Any clues on how to phrase this so CFQUERY likes it would be greatly appreciated. Sincerely, Sim Graves ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
