I am very new to vbscript and need help handling single quote marks that show up in strings.
ex)
insert into Table1(id, desc) values('NO893','plastic 3/4' tube.')
As you can see, the single quote mark after 3/4 is causing problems. If I were using java, I'd use a prepared statement to handle quotation formatting for me, but with vbscript, I have no idea how to do this. Any suggestions would be very helpfull.
Thanks,
Greg
ex)
insert into Table1(id, desc) values('NO893','plastic 3/4' tube.')
As you can see, the single quote mark after 3/4 is causing problems. If I were using java, I'd use a prepared statement to handle quotation formatting for me, but with vbscript, I have no idea how to do this. Any suggestions would be very helpfull.
Thanks,
Greg