By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,825 Members | 1,364 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,825 IT Pros & Developers. It's quick & easy.

Searching multiple db's from within a form

P: n/a
I have a form I am developing for my company that will be used to begin
our quoting process. I have normalized my data and have an interesting
problem that I am trying to solve. So far, I am drawing blanks and I
hope someone can nudge me in the right direction:

My form has numerous input fields and my logic is that IF the submit
flag is TRUE, submit the data to the db, otherwise, display the form.
One of the fields is for a Part Number (pn). All my Part Number data is
stored in a seperate db from my primary one.

How (or can I) can I search the pn db when the user enters a pn in the
pn field BEFORE the submit button is pressed? I have tried using the
ONCHANGE flag with the input tag....

TIA

Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"kf****@gmail.com" <kf****@gmail.com> wrote:
I have a form I am developing for my company that will be used to begin
our quoting process. I have normalized my data and have an interesting
problem that I am trying to solve. So far, I am drawing blanks and I
hope someone can nudge me in the right direction:

My form has numerous input fields and my logic is that IF the submit
flag is TRUE, submit the data to the db, otherwise, display the form.
One of the fields is for a Part Number (pn). All my Part Number data is
stored in a seperate db from my primary one.

How (or can I) can I search the pn db when the user enters a pn in the
pn field BEFORE the submit button is pressed? I have tried using the
ONCHANGE flag with the input tag....

TIA


onchange= in the input tag or onsubmit= in the form. No matter which way
you choose, you have to store every single part number in a java script and
check the input field against the js array with the numbers.

However, you *have* to check the value server side, too, since people might
have no java script (or it is deactivated) or maybe the data is not even
entered in a browser but in a client written for your script. Wrong data
injection can be done a lot of ways, most of them are not even offensive
attempts, but a mistake.
--
Simon Stienen <http://dangerouscat.net> <http://slashlife.de>
»What you do in this world is a matter of no consequence,
The question is, what can you make people believe that you have done.«
-- Sherlock Holmes in "A Study in Scarlet" by Sir Arthur Conan Doyle
Jul 17 '05 #2

P: n/a
I noticed that Message-ID:
<10**********************@h37g2000oda.googlegroups .com> from
kf****@gmail.com contained the following:
How (or can I) can I search the pn db when the user enters a pn in the
pn field BEFORE the submit button is pressed? I have tried using the
ONCHANGE flag with the input tag....


You could make it a two stage process.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Jul 17 '05 #3

P: n/a
Thought of that, however it seems a little "clunky", however looks like
the way I'll have to do this.

Thanks

rk

Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.