Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › Solution Recipe for adding Hashed Password causes Incorrect table name ''

View all replies to this thread

Solution Recipe for adding Hashed Password causes Incorrect table name ''

Thread began 8/30/2010 10:28 pm by Jim376112 | Last modified 9/10/2010 8:10 pm by Jim376112 | 3815 views | 7 replies

9/10/2010 7:45 amJason ByrnesWebAssist

the problem is that our code is being a little too protective of reserved words, it is a bug that has been logged.

the code to create the sql automatically places the "`" character around the table name.

There is also a reserved words list that is checked, if the table name you are using is on this list, then the $WA_table variable gets set with the "`" character as well.

This results in the SQL being created as:

SELECT ``user`` ....

so it's doubling up the "`" character causing the error.

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.