Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Universal Email › ItemID out of Sync

ItemID out of Sync

Thread began 9/25/2011 8:46 am by doug.lemesurier305760 | Last modified 9/26/2011 8:05 am by doug.lemesurier305760 | 2129 views | 3 replies

9/26/2011 7:45 amdoug.lemesurier305760

ItemID out of Sync - solved?

I think I figured this one out.

The ItemID's were out of sync because there is no way - that I can find - to get the next MySQL, auto-increment id without inserting a record first. So I was unable to generate the proper file name to be inserted into the record before the actual record insert.

The solution was kind of simple. In a nut shell I...
1. saved my update.php as insert.php
2. modified new insert.php to execute a INSERT query, before page load, to create a blank row. (I just gave one of the numeric fields a zero value)
3. grabbed the 'mysql_insert_id();' value and used it to generate an UPDATE query.

Granted, it's not perfect. If the user changes their mind after loading the insert.php, it will leave a blank record behind. I've got to figure that one out.

If anyone has a better way or any suggestions, please let me know.

Cheers
Doug

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.