Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › There is an error in hou sql SYNTAX - ECART

There is an error in hou sql SYNTAX - ECART

Thread began 9/20/2022 10:52 am by QuiruNet | Last modified 9/22/2022 9:05 am by QuiruNet | 615 views | 14 replies

9/20/2022 12:02 pmRay BorduinWebAssist

n_pedido is set as a unique column in your database but you are attempting to insert a value that already exists in the table.

I don't even see an <input> field named "numero" which you are using to do the update. Your trigger for the database insert is "before page load" which runs before any form is posted, so something is wrong with that logic.

Did this help? Tips are appreciated...

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.