Data assist 2.06 times out

Im trying to use data assist 2.0.6 to multiple update records but it just times out.
I have only one field i want to update. i believe ive got it all set up correctly. what would cause this?? I also have dataassist search on the page. The idea being, first search for the records i want to update and then update them all at once.

The other strange thing is that in firefox the textfield that is repeated that updates the database field does not allow me to type anything in it. but in Explorer it does.

Do you have to map every column in the database even if your not updating it?

not sure what it was. i rebuild the page and now it works fine except that in firefox the repeat field will not let me edit the value to update??? The cursor dissapears when in click on any of the fields. Anyone else seen this with firefox. works great in opera and explorer

Sounds like a css issue. try disabling all css on the page to confirm.

if it works with all css disabled, slowly add back the css to pinpoint which rule is causing the problem.

works now in firefox it must have been CSS. Rebuilt page and it worked.

but now i cant seem to update more than a 10 or so records at at time without it timing out. what is the max records this can update??? Seems kind of pointless if i can do them all in one click.

If my return record set is larger than around 10 records it will time out. If i narrow my search results so that the record set is small then it will update the few multiple records. Anyone have any help for me? Seems like this product should be able to filter through big record sets without timing out the browser.

If you have a large database, it can take a bit to update many records. By default, php will only let a script run for 30 seconds before it times out. If you need your script to run longer before it is timed out, you can increase the max_execution_time.


try adding the following at line 1 of your update page:

<?php

ini_set("max_execution_time", "120");

?>

this will set php to allow the script to run for 120 seconds. If you need it to run longer, you can increase the number of seconds.

Im not exactly sure what was the problem but i rebuilt the page. Then i made sure i ONLY selected the fields in the database that i needed to update and NOT all of them in the recordset. This made a big differance i think! Now its fast and i can update over 100 records a at time.