>For some reason when the UT interface was re-vamped I could not get logged in so I had to create a new account. In doing this I lost access to all of my previous posts.
>
>I have asked this question already and got a solution, I just cannot remember what is was.
>
>I am needing to pass a string of strings with SPT(db2 database).
>
>myString = "'56230','62323'"
>spt = "Update myRemoteTable Set myfield = '" + myString + "' where myfield2 = whatever"
>
>I cannot get the syntax right to get this to work.
Are you going to store 'Val1','Val2' in one field in a database?
You always need to double the single quote, but it may be a better way to use parameters, e.g.
myString = "Something with single quote (,) inside"
myField2 = "Something Else"
spt ="update myRemoteTable Set myField = ?m.myString where myField2 = ?m.myField2"
If it's not broken, fix it until it is.
My Blog