I've created my database and I have no problem running queries or even adding records from ASP, The problem I do have is when I try to add a record that contains characters such as comma's. I can write a full sentence to the database but as soon as I add a Comma to what I'm trying to Add it fails. Any Idea's
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ASP - Writing to a Access Database
- Thread starter jward
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
jward,
This is a common problem if you don't enclose your string in single quotes.
"SELECT * FROM my table WHERE varname = '" & x & "'"
fengshui1998
This is a common problem if you don't enclose your string in single quotes.
"SELECT * FROM my table WHERE varname = '" & x & "'"
fengshui1998
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question