Re: another net.data question

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

a few options, of the top of my head..

1.  When you build your page, you can load your possible db2 choices into a
java script array, and build the array code, on the fly (this only works if
you db2 data is small, a few hundred records.)

2.  Resubmit the page, and pull the db2 data, and then reshow the page with
the pulled db2 data.

3.  Us an ajax call, to request the data, and then compare the results
within your javascript.

I'm sure there are others..

Tim

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of rick baird
Sent: Monday, July 24, 2006 9:45 AM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] another net.data question

hey all,

I'm working on a simple form for transaction input where I need to
verify several different items entered, most of which I can do using
simple javascript functions on an "onblur" event, but one in which I
need to verify the field against a 400 db2 file.

I can do the verification via an SQL statement, but I'm having brain
lock on how to embed a net.data function in javascript function.

My goal is to verify the item and throw up an alert() before
submitting the form to the next %html block, and to not have it behave
differently than the javascript alert() edits.

any ideas would be greatly appreciated.

Thanks,

Rick