|
|
|
|
|
| | |
|
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)

|
|
Subject: |
Re: How to remove single quote ? |
From: |
Paul Simpson |
Date: |
4/21/1999 12:03:13 PM |
IP: |
207.207.47.5 |
But you CAN use single quotes in a case like Lisa's. I use them when looking for a text field's value, as in the following example:
strSQL = "SELECT * FROM People WHERE PersonID ='" & PersonID & "'"
PersonID is a text fieldtype. If it were a number fieldtype, I would have left out the single quotes.
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|