email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Need help configuring the program? Have any questions regarding its use?
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
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 allUPDATE 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.