|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-24 : 19:52:08
|
Henric writes "Example:
I need to save the string: '3','86','5','101','10','127','15','149','20','169','23','124'
In my database. I just can't get it to do it. It always reports an error.
My code: SQLStmt = "UPDATE Portotabell SET Portotabell.arraydata = ("&""""&"'3','86','5','101','10','127','15','149','20','169','23','124'"&""""&") WHERE (((Portotabell.ID)="& Request.Form("ID") &"))"
Connection.Execute(SQLStmt)
Converted to pure SQL it becomes:UPDATE Portotabell SET Portotabell.arraydata = ("'3','86','5','101','10','127','15','149','20','169','23','124'") WHERE (((Portotabell.ID)=5))"
|
|
Saving ' with a UPDATE-statement