losing Form values from option boxes


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: losing Form values from option boxes

  1. #1
    Paul Klanderud Guest

    losing Form values from option boxes


    We have a problem losing the values in option boxes (drop-down lists) on pages
    submitted ONLY by users outside our firewall (all internal tests show nothing
    wrong).

    There are about 8 fields -- 4 text boxes and 4 drop-downs. The form reposts
    to the same page and validates that there's something in the text boxes,
    and that the drop-downs' values <> the default value (for example: <option
    value="XX" selected>Please choose a state </option> ).

    The validation works fine. All the values are plugged into an sql string
    and sent on their way.

    Internal tests always show all the form values as present. But, despite the
    validation which requires values in all fields, a great number of the sql
    strings, when we get them on the back end, are missing the values JUST FROM
    THE DROP-DOWNS!

    Any thoughts would be appreciated.

    TIA,
    Paul

  2. #2
    simon Guest

    Re: losing Form values from option boxes


    Hi Paul,
    This sounds like the firewall is filtering out something on the way in.
    Where is the SQL server? inside or outside?
    Is the web server trying to make SQL calls across the firewall?
    If so try opening 1433 in the firewall just to test.

    Some firewalls (depending on configuration) will allow all traffic to pass
    through provided that the session was initialized from the correct place
    (ie inside the firewall). This could explain why it is only external surfers
    who experience these problems.

    Hope this helps

    /Simon


    "Paul Klanderud" <pklanderud@chumbo.com> wrote:
    >
    >We have a problem losing the values in option boxes (drop-down lists) on

    pages
    >submitted ONLY by users outside our firewall (all internal tests show nothing
    >wrong).
    >
    >There are about 8 fields -- 4 text boxes and 4 drop-downs. The form reposts
    >to the same page and validates that there's something in the text boxes,
    >and that the drop-downs' values <> the default value (for example: <option
    >value="XX" selected>Please choose a state </option> ).
    >
    >The validation works fine. All the values are plugged into an sql string
    >and sent on their way.
    >
    >Internal tests always show all the form values as present. But, despite

    the
    >validation which requires values in all fields, a great number of the sql
    >strings, when we get them on the back end, are missing the values JUST FROM
    >THE DROP-DOWNS!
    >
    >Any thoughts would be appreciated.
    >
    >TIA,
    >Paul



  3. #3
    Paul Klanderud Guest

    Re: losing Form values from option boxes


    Simon:

    Thanks for your reply, but I don't think this is the issue. When I said an
    sql statement, actually it's a statement to execute a stored proc, along
    with the parameters.

    For example, here's how it should look (more or less): "EXEC sp_DoStuff 'Fred'
    'Flintstone' 1, 33, 'MN' '123 North Lane' 12, 15, 5 "

    But here's how it often looks "EXEC sp_DoStuff 'Fred' 'Flintstone' 1, 33,
    '' '123 North Lane', , , "
    (The missing parameters are those from drop-downs. But when we do a response.write
    on the variable holding the statement -- at least on OUR end -- they all
    show up in the statement.)

    This entire message is sent to our back end in a MSMQ message, where it's
    pulled off by an app with permissions to execute it. For some very strange
    reason, the values from the drop downs are not making it into the message
    (although sometimes they do, which makes it even harder to figure out).

    Thanks for your help, though.
    Paul

    "simon" <simon.walsh@adcore.com> wrote:
    >
    >Hi Paul,
    >This sounds like the firewall is filtering out something on the way in.
    >Where is the SQL server? inside or outside?
    >Is the web server trying to make SQL calls across the firewall?
    >If so try opening 1433 in the firewall just to test.
    >
    >Some firewalls (depending on configuration) will allow all traffic to pass
    >through provided that the session was initialized from the correct place
    >(ie inside the firewall). This could explain why it is only external surfers
    >who experience these problems.
    >
    >Hope this helps
    >
    >/Simon
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center