Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › MySQL syntax error

View all replies to this thread

MySQL syntax error

Thread began 5/09/2011 4:31 am by info425534 | Last modified 5/09/2011 2:21 pm by info425534 | 1487 views | 3 replies

5/09/2011 2:19 pminfo425534

Originally Said By: Jason Byrnes

it looks like while running the wizard, you selected the email column as the ID column.

the ID column should be the primary key column for the users table, this is a numeric column, not a text column.

to fix the error, double click the WAATKusers recordset. go to advanced view, and edit the ParamUserEmail parameter, change the Type from integer to text.

Thanks Jason,

You kinda confused me there when you said "change the type from integer to text". But I see that you meant change the type from text to integer. Everything seems to be working now - thanks!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.