Hi PJ ... sounds to me like a bug in the CF Server... try restarting the cfserver if possible -- then use <cfqueryparam> ... either of those hopefully will fix your problem... if neither of them do, then you've got a bug for MM ... you can call tech support -- they'll ask for a credit card # but my understanding is that they won't charge the card for the call if it's a bug. I'f you're really concerned about the cost of the tech support call you could also try reinstalling CF server before calling.
hth s. isaac dealey 972-490-6624 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap > 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 ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
