 |
Grumpy
Beginner
Joined: 24 May 2004
Posts: 10
|
 Posted: Thu Sep 28, 2006 2:09 pm
Problem inserting into Database
|
I current insert into my database (SQL Server) through the use of recordsets, like:
| Code: |
#VAR rs("Name").Value @item.name
#CALL @rs.Update |
but whenever the item name contains special characters like / or ' etc. I get an sql error. I can enter the information manually fine so it is not a type mismatch. Does anyone know how to fix this problem? |
|
|
|
|
Vijilante
SubAdmin
Joined: 18 Nov 2001
Posts: 5182
|
Posted: Thu Sep 28, 2006 11:06 pm
|
You have to add an escape character before those special characters. You can do this with %replace.
|
|
_________________
The only good questions are the ones we have never answered before.
Search the Forums |
 |
|
|
|
|
|
