-
single quotes inside stings in SQL inserts in VB ADO
cmd1.commandtext = "Insert table_bug(name, address, phone, comment) Values('" & name & "','" & address & "','" & phone & "'," & ",'" comment & "'"
from VB ADO where comment contains single qoutes like 'don't'.
Insert fails. Please help!
-
single quotes inside stings in SQL inserts in VB ADO (reply)
Please repy to salem@wauknet.com evenings or schmidtrj@ems.com days.
Bob
------------
BobS at 5/18/99 9:09:47 PM
cmd1.commandtext = "Insert table_bug(name, address, phone, comment) Values('" & name & "','" & address & "','" & phone & "'," & ",'" comment & "'"
from VB ADO where comment contains single qoutes like 'don't'.
Insert fails. Please help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|