|List:||General Discussion||« Previous MessageNext Message »|
|From:||Steve Pugh||Date:||May 4 2004 10:30pm|
|Subject:||Re: "INSERT INTO" dropping slashes from strings|
|View as plain text|
Err...what I meant to say here was "ascii code equivalent (chr(39)" (I tried single *and* double quotes). Sorry about that. Steve Pugh wrote: > Hi Daniel, > > I tried that to no avail (I had actually had the code set initially to > use single quotes thusly: > > sqlstr = "INSERT INTO Jobs VALUES("' & _ > txtSceneFile & "')" > > but it generated the same erroneous string. Using the ascii-code > equivalent (Chr(34) does the same.