On Thu, 31 Oct 2002 11:54:02 -0600, dennis baldwin wrote:
> Generally "\" is recognized as an escape character in MySQL so you
> should escape your escape character, ie:
>
> D:\\data\\book1
>
> Are you inserting data from CF or the command line?
Yes, from CF.
<cfquery name="update_alias" DATASOURCE="Alias">
INSERT alias
SET env_var = '<cfqueryparam value="#ListGetAt(Line,1,'|')#"
cfsqltype="CF_SQL_VARCHAR">',
destination = '<cfqueryparam value="#ListGetAt(Line,2,'|')#"
cfsqltype="CF_SQL_VARCHAR">'
</cfquery>
I'm getting "?" inserted into the fields of my SQL database. Must be the syntax above.
> Regards,
> Dennis
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:list-request@;dfwcfug.org] On
> Behalf Of FlashGuy
> Sent: Thursday, October 31, 2002 11:46 AM
> To: FlashMX
> Subject: OT: MySQL & CF
>
>
>
> OT: MySQL & CF
>
> Hi,
>
> Something weird is happening. Before I switched my databases from Access
> to MySQL my app was working OK. Now when I insert data into my SQL
> database one of the fields is getting mucked up and I don't know why?
> Here is an example of a entry how is *should* appear in the
> database:
>
> Should be:
>
> env_var = book1
> destination = D:\data\book1
>
> This is what getting input into my SQL database:
>
> env_var = book1
> destination = D:|ata|ook1
>
> Its like the "\b" is getting interpreted into a wacko ASCII character?
>
> Both fields in my table are varchar(255) types
>
>
>
>
> ---------------------------------------------------
> Colonel Nathan R. Jessop
> Commanding Officer
> Marine Ground Forces
> Guatanamo Bay, Cuba
> ---------------------------------------------------
>
>
>
>
> ------------------------------------------------------------------------
> -
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info:
> www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
>
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
