Escape single quotes to SQL with \'
-Original Message-
From: Dixon, Aidan [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 7:08 AM
To: CF-Talk
Subject: Escaping quotes in Replace function for SQL Server 7
We have a classified ads section on our intranet currently runni
Not sure if this would work, but you could convert it to Chr(34)..
--
Billy Cravens
[EMAIL PROTECTED]
"Dixon, Aidan" wrote:
>
> We have a classified ads section on our intranet currently running on MS
> Access. I'm trying to upgrade it to use MS SQL Server 7. Testing threw up
> one problem.
k" <[EMAIL PROTECTED]>
Sent: Monday, November 06, 2000 10:07 AM
Subject: Escaping quotes in Replace function for SQL Server 7
> We have a classified ads section on our intranet currently running on MS
> Access. I'm trying to upgrade it to use MS SQL Server 7. Testing threw
quotes in Replace function for SQL Server 7
We have a classified ads section on our intranet currently running on MS
Access. I'm trying to upgrade it to use MS SQL Server 7. Testing threw up
one problem. Data entry is via a standard HTML form, using a textbox for
the body of the ad. Un
f you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Dixon, Aidan [mailto:[EMAIL PROTECTED]]
Sent: 06 November 2000 15:08
To: CF-Talk
Subject: Escaping quotes i
We have a classified ads section on our intranet currently running on MS
Access. I'm trying to upgrade it to use MS SQL Server 7. Testing threw up
one problem. Data entry is via a standard HTML form, using a textbox for
the body of the ad. Unfortunately, if anybody uses a double quote mark
any
6 matches
Mail list logo