in reply to Re^19: CGI Action call
in thread CGI Action call

Worse yet it does not maintain the state during subsequent calls

Each subsequent all to NEXT returns the same record, the first one

I guess the table closes after the sub completes executing

I had hoped it was open until an explicit call to close or "program" termination but them as with always, each call to a sub is separate

Back to working on maintaining state as I was trying before. My only problem there was skipping same last names.

Re-invent wheel again

Replies are listed 'Best First'.
Re^21: CGI Action call
by poj (Abbot) on Apr 01, 2018 at 19:06 UTC

    Example demo cgi of how you could combine the 2 subs into 1 and use OFFSET

    HTML form to test it.

    poj

      Got it working with the handler. Works perfectly so far. Went to town, inside outside upside down!! (Kids verse).

      Very pleased. Used unique (searchterm & record id) as suggested in MySQL forum. Table stays open and accessible throughout repeated calls which I had questioned.

      Happy camper. Thanks