|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|