Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Help with the ' in an sql statement

Feb 26, 2003, 7:01 AM
MessiahBob
New User (2 posts)
Feb 26, 2003, 7:01 AM
Post #1 of 2
Views: 5014
Shortcut
Quote Reply
Help with the ' in an sql statement
Here is my statement for adding new data to my MS access DB.

rstDBEdit("options") = request.form("options")

Ive looked through some of the other forums but cannot figure out how to get the sql to pass the ' to the DB. Any help would me most apreciated! Thank You!

-MessiahBob Laugh
Mar 2, 2003, 1:36 PM
WoSkI
User (57 posts)
Mar 2, 2003, 1:36 PM
Post #2 of 2
Views: 4537
Shortcut
Quote Reply
Re: [MessiahBob] Help with the ' in an sql statement In reply to
try

rstDBEdit("options") = " & request.form("options") & "


i cant beleive theres been over 55 views and no replies.

Last edited by:

WoSkI: Mar 2, 2003, 1:36 PM