I “assume” that the “…” is more of the comma delimited list of fields to be updated???
Please post the ENTIRE SQL statement
And the error is not “Impossible”… it is just not obvious to you… yet… but SQLite probably has a really good reason, and I bet when we figure it out… you will utter a “Doh!”
Hmm =\ that’s a good way of alienating people on the forum.
It might be that your code is creating a string with a + in which is a string concatenation character so you’ll need to use \+
As the error is coming from a javascript alert I’m assuming that you’re creating the query as javascript, if this isn’t the case then strip the query down into smaller parts as Jeff suggests and try each part until you find the problem but my first guess would be to try it on a teamName that doesn’t contain a + and see if it works.
Mr.Scanlan… please be advised that this is a VOLUNTEER effort… .and to be honest… .your recent responses make it unlikely that I will be bothering to look any further into your issue… to quote you… "Have Fun
At the risk of being berated, have you tried the same SQL statement without the WHERE clause? I’ve honestly been in these situations and always find that the error was leading me in the right direction, but I just wasn’t looking at it close enough.
If it works without the where clause, I’d try to substitute a different WHERE clause and see if that works.
What I’m leading to is verifying that “teamName” is relative to the table you’re trying to do the update in. I’d be curious to know the answer when you finally uncover it.
I feel your frustration, but we are only trying to look at the obvious with limited information.
Have you tried 's suggestion to escape the plus sign? That’s first caught my eye.
Regarding an UPDATE without a WHERE, you can just make a copy of the database and perform the query there without an UPDATE clause. It will, of course, update all records in the database, but at least you can see if the problem is isolated to your WHERE clause. Most SQLite managers like Tadpole let you perform queries in a dedicated window.
First thing I would do is try the same statement a select if you want to validate the where clause. I think you’ll find the problem with the plus as others already mentioned.