related sites: <FREE Help> <ASP> <Asp.net> <worldwide> feedback: <lovethat> <hatethat> <thanks> <credits> <contact us>
single quotes ' In DB Updates <Next>
From: Paulo Antunes Veras <paveras@tesla.com.br> To: asp@mail.mailexperts.com <asp@mail.mailexperts.com> Date: 15 April 1998 12:51 Subject: [asp advanced] How to insert pipe (|) in Access mdb?
Hi, does anybody know how to insert the pipe character "|" in a MDB Database through ASP? Thanks in Advance,
Paulo Antunes Veras Tesla Tecnologia paveras@tesla.com.br CEP 04542-050 http://www.tesla.com.br R. Urussui, 71 cj.112 fone/fax 55 11 866-2090 Sao Paulo, SP - Brasil
From: "Steve Nicholls" <Big.Steve@btinternet.com> Subject: Re: [asp advanced] How to insert pipe (|) in Access mdb? Date: Wed, 15 Apr 1998 13:06:02 +0100
Paulo, Check MS knowledgebase article Q178070 (HOWTO : Handle Quotes and Pipes in Concatenated SQL Literals) which suggests all pipe characters be replaced with chr(124)
The article can be found at http://support.microsoft.com/support/kb/articles/q178/0/70.asp regards, Steve