Hi, I don't know how your access database was built but it seams your problem come from encoding.
Access is Unicode compatible and MySql doesn't I use the same couple of techno - Flash - CFMX - MySql I have had to insert each special with urlFncodedFormat function Best regards Eric -----Message d'origine----- De�: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Envoy�: mardi 3 d�cembre 2002 16:26 ��: CF-Talk Objet�: RE: CF and mySQL 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
