> The query below doesn't work... the first clause in the > CFIF works fine, but it gives me the error: Error while > executing the query (non-fatal); ERROR: Relation "form" > does not exist for the CFELSE portion.
Incedentally, this _sounds_ to me like a bug. The syntax of the query certainly looks good -- I can't imagine it not working on CF 3.0-5.0 for Windows. What OS / CF version are you using? You might try removing the # symbols in your <cfif> statement -- they're not necessary within cf tags and I suppose theoretically could be causing a problem. That's pure conjecture tho. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.