>Hi,
>I am using ASP as my web application tool and access VFP database. As usual, once I need to insert record using ADO, I may do:
>
>ASP
>
>lcSQl = "INSERT INTO mytable (f1, f2, f3) VALUES (" & _
>request.querystring("F1") & "," & request.querystring("F2") & "," & _
>request.querystring("f3") & ")"
>
>myconn.execute lcSQL
>
>
>
>If one of these 3 fields contain
, I will get error msg. Any ideas?
>
>Thank you
John,
Why don't you get a recordset object and add to it. With above way you're sending something like :insert into mytable (f1,f2,f3) values ("value1","value2","memo with CR
in it")
Cetin