i have a page where a user can type freely whatever he or she desires and it gets written to an access database via the Microsoft.Jet.OLEDB.4.0 connection using the following sql statement
Expand|Select|Wrap|Line Numbers
- sSQLB = "Update Profile SET txt1 = '" & txt1 & "', txt2 =' " & txt2 & "', txt3 = '" & txt3 & "', txt4 = '" & txt4 & "', txt5 = '" & txt5 & "' where USER_ID = " & USER_ID & ""
i havnt come up with any idea of how to counteract this and im hoping someone here will.
i can see why the problem occurs its just on how to fix it i am lost.
Thanks