Welcome Guest, Not a member yet? Register   Sign In
Profiler Enabled Fixes Database SQL Update
#1

Hi,
  I've got a hyperlink in a view that downloads a generated PDF (a lab badge).  Each generated PDF receives a successive number for individual badge tracking (autoincrement), different from their user id.  I do a db->update to set previous badges to inactive and THEN an insert for the new badge information.

However, I'm finding that the update and insert never happens unless attempted several minutes later.  BUT, if I enable the profiler in the badge generating controller, everything flows like it should.

Any ideas?

Thanks.
Reply
#2

Could it be that the update will be done after the pdf is generated or the download is forced? in this case the update will be done after the download is finished and i could be a gap on big generated files and the following sql function.

Reply




Theme © iAndrew 2016 - Forum software by © MyBB