I'm running a script which was working fine, and now instead of recognizing a variable set prior to a query, it -- well it doesn't NOT recognize it (there's an error saying it can't find a variable in that case), it's that it just doesn't seem to grok what a variable is! Here's the (rev/excerpt) snippet it's choking on (from the error page):
SQL = "select id from table where id = 3 and (csid = #variables.csid# or csid = 0) " And here's the error: The column prefix '#variables' does not match with a table name or alias name used in the query. Well... duh! Since the variable DOES exist for usage, I don't know what I'm supposed to do to 'make' a cfquery recognize it's a variable and not a table name... What am I missing here? Something really obvious I bet. This is what I get for working all through my bleepin holiday. ;-) PJ --- [This E-mail scanned for viruses by Declude Virus] ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
