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

Have you ever seen this from My SQL manual ?
The HANDLER ... OPEN statement opens a table, making it accessible using subsequent HANDLER ... READ statements. This table object is not shared by other sessions and is not closed until the session calls HANDLER ... CLOSE or the session terminates.

Replies are listed 'Best First'.
Re^20: CGI Action call
by tultalk (Monk) on Apr 01, 2018 at 01:16 UTC

    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

[reply]

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

      Read more... (3 kB)

      HTML form to test it.

      Read more... (3 kB)
      poj
[reply]
[d/l]
[select]

        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

[reply]
Re^20: CGI Action call
by tultalk (Monk) on Mar 30, 2018 at 23:19 UTC

    But you can lock the table while open correect?

[reply]

In Section Seekers of Perl Wisdom