Re^20: CGI Action call

[tultalk]

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

[poj]

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

[tultalk]

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