PDA

Click to See Complete Forum and Search --> : Escape Character for Double Quote

david2105
09-24-2003, 09:41 AM
Hey guys,

On the following line I need to replace the single quotes with double quotes any ideas?

ItemString = ItemString & "'" & RSTool2("ToolID") & " - " & RSTool2("ToolGroup") & "','" & RSTool2("ToolID") & "'"

Cheers
gil davis
09-24-2003, 11:07 AM
Chr(34)
Ribeyed
09-24-2003, 11:36 AM
hi,
your code doesn't look right.



ItemString = ItemString & "'" & RSTool2("ToolID") & " - " & RSTool2("ToolGroup") & "','" & RSTool2("ToolID") & "'"


why do you need all them quotes?????
something like this should work


ItemString = ItemString & RSTool2("ToolID") & " - " & RSTool2("ToolGroup") & RSTool2("ToolID")

Hope this helps