Searching multiple db's from within a form

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kf4pfw@gmail.com
    #1

    Searching multiple db's from within a form

    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

    Tags: None
    • Simon Stienen
      #2
      Re: Searching multiple db's from within a form

      "kf4pfw@gmail.c om" <kf4pfw@gmail.c om> wrote:[color=blue]
      > 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[/color]

      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.ne t> <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

        Comment

        • Geoff Berrow
          #3
          Re: Searching multiple db's from within a form

          I noticed that Message-ID:
          <1096551880.066 755.177520@h37g 2000oda.googleg roups.com> from
          kf4pfw@gmail.co m contained the following:
          [color=blue]
          >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....[/color]

          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/

            Comment

            • redneck_kiwi
              #4
              Re: Searching multiple db's from within a form

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

              Thanks

              rk

                Comment

                Previous template Next
                Working...