Here is a real braintickler from a client. The project has several modules
where new records are added to tables. When any one of the standard form pages
loads, it reads the correct data table, finds the highest value for the
existing ID numbers and increments the ID variable automatically (hidden
variable...no user input). When the user completes the form, the new data gets
posted to the table and the user gets a verification screen with a choice to
"Add Another." Here is where it gets interesting.
In both Firefox and IE, the form page acts properly at this point: it queries
the table, finds the highest ID number anbd automatically increments the ID
variable and loads the form page. You can go through this process all day
long...no problems. However, a "plain vanilla" installation of Opera fails to
query the data table (apparently) and fails to increment the ID number. When
the user goes to add the second entry, they get a duplicate key error on the ID
variable. since the previous ID value is being used.
Any insights on what may be causing Opera to NOT query the data table and
perform the increment of the ID number? I am using CF MX; MySQL and Windows
XPon the test machine; the server uses the same settup.
Thanks for any assistance.