and this is plain wrong. PreserveSingleQuotes does exactly the opposite
of what you are trying to achieve. It stops cf from escaping single
quotes in vars within a cfquery.
Pascal
> -----Original Message-----
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 23 april 2004 16:21
> To: CF-Talk
> Subject: RE: Inserting Comma in DB
>
> PreserveSingleQuotes() ?
>
> Mike
>
> > -----Original Message-----
> > From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
> > Sent: Friday, April 23, 2004 10:18 AM
> > To: CF-Talk
> > Subject: Inserting Comma in DB
> >
> > Hi
> >
> >
> >
> > <CFSet myComments = "It wasn't the best solution">
> >
> >
> >
> > INSERT INTO tb_JQoS_Results
> >
> > (Comments)
> >
> >
> >
> > Values (' #myComments# ')
> >
> >
> >
> > It gives error because of the comma. How can we make it working?
> >
> >
> >
> >
> >
> > Thanks
> >
> > Shaz
> >
> >
> >
> >
> **********************************************************************
> > This email and any files transmitted with it are confidential and
> > intended solely for use by the individual or entity to whom it is
> > addressed. If you have received this e-mail in error, kindly notify
> > [EMAIL PROTECTED] or call
> > +44 1992 701 704. Unless stated otherwise, please note
> > that any views or opinions expressed in this e-mail are
> solely that of
> > the author and are not necessarily of JJ Fast Food Distribution
> > Limited. The company can not assure that the integrity of this
> > communication has been maintained nor that it is free of errors,
> > virus, interception or interference. The company accepts no
> liability
> > for any damage caused by this email. JJ Fast Food
> Distribution Limited
> > reserves the right to monitor and or record e-mail without prior
> > notification.
> >
> **********************************************************************
> >
> >
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
