i think you need to put quotes around newAuthorName, ie:
UPDATE tableName SET authorNameColumn = ' " + newAuthorName + " ' WHERE authorNameColumn =" + oldAuthorName
(spaces between ' and " just for clarity so remove those). also you dont have a space before WHERE
Hey, thanks for your response.
I tried this, taking out all the spaces:
(where newAuthorName = Dusty and oldAuthorName = Kristin)
var sql:String = "UPDATE combined SET authorNameColumn ='"+newAuthorName+"'WHERE authorNameColumn ="+oldAuthorName;
I got this:
SELECT error: SQLError: 'Error #3115: SQL Error.', details:'no such column: 'Kristin'', operation:'execute', detailID:'2036'
and if I take out the single quotes you mentioned:
SELECT error: SQLError: 'Error #3115: SQL Error.', details:'near 'authorNameColumn': syntax error', operation:'execute', detailID:'2003'
put ' ' around oldAuthorName too
a better solution would be to use parameters - then you dont have to worry about adding quotes
Hi again Lee;
perhaps you could tell me where those quotes should go around oldAuthorName.
I've tried so many variations now and none seem to work. I usually get an error that says there is no such column oldAuthorName.
I did have parameters in my code earlier, but the function still didn't work so deleted them to reduce clutter.
This is making me insane I tell ya.
Thanks for your help.
I'm relatively new to this Flex stuff.
I've been trying to fix this problem for hours and you know how it is when you keep looking at the same thing for too long.
The article you linked to helped. I finally just copied the text from it and changed the variable name to my own.
FINALLY!! I can go do something else now.