I don't use mySQL but I remember someone saying \ is an escape character... <cfqeuryparam> will allow you to put \ in a varchar field in mySQL however. It's in one of the threads in the cf-talk archive.
> doesn't mySQL use \ for something internally? I had a problem with it ages > back.... can't remember what it was though! > -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: 03 December 2002 15:45 > To: CF-Talk > Subject: RE: CF and mySQL > Yes, the "FORM.destination" but thats the reason for the "<cfqueryparam > value="#FORM.destination#" cfsqltype="CF_SQL_LONGVARCHAR">" > Yet the "?" are being inserted. > On Tue, 3 Dec 2002 15:26:18 -0000, Robertson-Ravo, Neil (RX) wrote: >> do any of the variables contain "\" >> -----Original Message----- >> From: FlashGuy [mailto:[EMAIL PROTECTED]] >> Sent: 03 December 2002 15:17 >> To: CF-Talk >> Subject: CF and mySQL >> >> >> There is something wrong with my syntax. I just converted my Access > database >> over to mySQL. Whats wrong with the <cfqueryparam>? >> I get "?" question marks inserted into the database when I execute the >> updated code. >> >> Before: >> --------- >> <cfquery name="update_alias" DATASOURCE="Alias"> >> Insert into alias >> (env_var, destination) >> VALUES >> ('#FORM.env_var#', '#FORM.destination#') >> </cfquery> >> >> >> >> After: >> ------- >> <cfquery name="update_alias" DATASOURCE="Alias"> >> Insert into alias >> (env_var, destination) >> VALUES >> ('<cfqueryparam value="#FORM.env_var#" cfsqltype="CF_SQL_LONGVARCHAR">', >> '<cfqueryparam value="#FORM.destination#" > cfsqltype="CF_SQL_LONGVARCHAR">') >> </cfquery> >> >> >> >> >> --------------------------------------------------- >> Colonel Nathan R. Jessop >> Commanding Officer >> Marine Ground Forces >> Guatanamo Bay, Cuba >> --------------------------------------------------- >> >> >> >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
