Is it possible to update a row in an SQL Server database as i get an error with
Update Tablename
Set Column=value
statement - i get incorrect syntax in 'column'
I am inserting rows into the database without problem but i need to update a status flag and would like to automate this.
Am i missing something simple?
Thanks in advance
Update Tablename
Set Column=value
statement - i get incorrect syntax in 'column'
I am inserting rows into the database without problem but i need to update a status flag and would like to automate this.
Am i missing something simple?
Thanks in advance
sorted, was just being a bit stupid.
Thanks for the update.
Just in case anyone visits this topic searching for a SQL update statement in Email Parser I post an example:
Code: Select all
UPDATE leads SET firstName = '<%firstname%>', lastName='<%lastname%>' WHERE id=5;<%firstname%> and <%lastname%> are placeholders and EmailParser will replace them with the actual captured text before running the SQL sentence.
