Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-15 : 09:18:31
|
Neelam writes "Hi,
How do I insert the values in the database if the user adds an apostrophe in a string.
I read one way to do this in your site that is with replace function,it is a good way to do that but i have to add 46 fields in a particular table,so any other simple way to do it.
Can I attach the replace function to an Objects method when we call it to update the table?
Like
rst as recordset
obj as server.createobject()
rst=obj.updatetable replace((field1,field2,field3),"'","''")
Thanks,
Neelam" |
|
|
|
|
|
Apostrophe in insert statement