ItemID out of Sync
Hi,
I am using DA and UE to insert a record into a MySQL DB.
I am using UE to upload an image with the insert form.
The image uploads and the DB updates fine.
My problem is... I am using the ItemID to rename the uploaded image. (WADA_Insert_items).
This is not working as I would expect.
1) If I launch a new browser session and preform an insert, I get a file name of '.jpg'
2) On a secondary attempt, in the same session, I get a file name of (e.x. '99.jpg'). This is exactly one count of the actual ItemID of 100.
How can I correct this so that it work for the start of a new session and names the files accordingly.
The following is a SQL and session DUMP from the Detal page following an insert.
SQL: SELECT VisitorID, VisitorGroupID, CompanyID, ItemID, ItemCatID, ItemName, ItemShortDesc, ItemLongDesc, helixNumber, CustomerPartNumber, PONumber, OrderQTY, QTYProduced, release1, QTYOnHand FROM items WHERE ItemID = -1 OR ( -1= -1 AND ItemID= 100)
array(17) {
["WAENCRYPTEDRETURNUSED"]=>
bool(false)
["WAENCRYPTEDRETURNSUCCESS"]=>
bool(false)
["SecurityAssist_VisitorID"]=>
string(1) "1"
["VisitorGroupID"]=>
string(1) "3"
["VisitorEmail"]=>
string(28) "support@heliximpressions.com"
["VisitorBillName"]=>
string(22) "Helix Impressions Inc."
["VisitorID"]=>
string(1) "1"
["userID"]=>
string(5) "helix"
["UserName"]=>
string(5) "helix"
["CompanyID"]=>
string(1) "1"
["CompanyName"]=>
string(22) "Helix Impressions Inc."
["GroupName"]=>
string(20) "Helix Administrators"
["showContent"]=>
int(1)
["editContent"]=>
int(1)
["WADA_OrderClause_index"]=>
string(0) ""
["Insert_ImageName"]=>
string(12) "99_thumb.jpg"
["WADA_Insert_items"]=>
int(100)
}