asp_databases thread: "double quote"
Message #1 by "Asami O.Meyers" <asamio@w...> on Mon, 17 Sep 2001 19:06:36
|
|
Hi, I have problem inserting text containing "double quote" into Access
database. Any text starting with double quote doen't get processed by SQL
statement.
I have tried replacing it with all the following:
Name = Replace(Name, Chr(34), "''")
Name = Replace(Name, """, "''")
Name = Replace(Name, "”", "''")
Name = Replace(Name, """, "''")
Nothing works, and I'm quite frustrated.
Thanks for anybody who could help me with this!
Message #2 by Ludwig Brandon-FBL017C <Brandon.Ludwig@m...> on Mon, 17 Sep 2001 15:25:14 -0400
|
|
Replace(Name, "'", "''") will work. (Those are apostrophes between the
quotes)
Brandon Ludwig
Brandon.Ludwig@M...
-----Original Message-----
From: Asami O.Meyers [mailto:asamio@w...]
Sent: Monday, September 17, 2001 3:07 PM
To: ASP Databases
Subject: [asp_databases] "double quote"
Hi, I have problem inserting text containing "double quote" into Access
database. Any text starting with double quote doen't get processed by SQL
statement.
I have tried replacing it with all the following:
Name = Replace(Name, Chr(34), "''")
Name = Replace(Name, """, "''")
Name = Replace(Name, "”", "''")
Name = Replace(Name, """, "''")
Nothing works, and I'm quite frustrated.
Thanks for anybody who could help me with this!
Message #3 by Steve Carter <Steve.Carter@t...> on Tue, 18 Sep 2001 09:29:01 +0100
|
|
Bit puzzled by your prob. Try
Name = Replace(Name, chr(34), chr(34) & chr(34))
or
Name = Replace(Name,"""","""""")
For more help, please post your code that creates your SQL string.
> -----Original Message-----
> From: Asami O.Meyers [mailto:asamio@w...]
> Sent: 17 September 2001 20:07
> To: ASP Databases
> Subject: [asp_databases] "double quote"
>
>
> Hi, I have problem inserting text containing "double quote"
> into Access
> database. Any text starting with double quote doen't get
> processed by SQL
> statement.
>
> I have tried replacing it with all the following:
> Name = Replace(Name, Chr(34), "''")
> Name = Replace(Name, """, "''")
> Name = Replace(Name, "”", "''")
> Name = Replace(Name, """, "''")
> Nothing works, and I'm quite frustrated.
> Thanks for anybody who could help me with this!
>
>
|
View Cart
