I'm taking a string from a textbox and inserting it into an Oracle DB. If the user puts double quotes in the textbox, it messes up my string and the DB returns an error. Does someone have an example on how to deal with this...thanks
Printable View
I'm taking a string from a textbox and inserting it into an Oracle DB. If the user puts double quotes in the textbox, it messes up my string and the DB returns an error. Does someone have an example on how to deal with this...thanks
Give us an example of how you are inserting the data. It may be the method you are using.
I resolved this...I just used the VBReplace funtion and replaced the double quotes with single quotes...thanks