This content has been marked as final. Show 4 replies
The output of query "get_data" is probably the query BEFORE the insert. The one you show running after the insert is "get_position", therefore:
Sorry the "data" versus "position" was a translation problem when I was paring down the code for presentation.
What I found was the database takes almost 5 seconds to update versus near instantaneous before the software upgrade. I placed a pause betweent the insert and the query and the code performs as before.
You should find out why it's suddenly taking 5 seconds to insert a record. Maybe you are no longer using the most appropriate driver.
You might try changing from cfinsert to an actual query with an insert statement (Dan, who posted above, had suggested that and it "smoothed" alot of my forms right out).