Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jan 2012
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is it possible to re-enter form values from second table?

    In (asp classic) i have a form(one), a user access it by login-- then some values are pre-filled by session variables --- after that if user selects [add contacts] from add button then from pop up window he chooses one contact from contacts list ,,,is it possible to refill these values to form(a). I think I have cleared my point.

    I did this in that way….
    As user is logged in on form(one) he selects one contact from pop up window
    And if I populate these values to form(two) its working fine, and if I cut query from form(two) and paste to form(one) it gives error.

    So after putting query in form(one) when user clicks on send package,,,,,, page generate error, Because query is trying to find requested contacts_id and that’s why page generate error..
    I don’t know how to resolve this.
    And the error is
    Error Type:
    Microsoft JET Database Engine (0x80040E14)
    Syntax error (missing operator) in query expression 'contacts_id='.

    For more understanding……….
    Login page>>member area>>send package>>form(one)—select contacts---if successful it goes to form(one) other wise it generates error.

    In member area page -send package- link is open by this…
    Code:
    <a href="send_package.asp?client_id=<%=session("mem_id")%>">Send Package</a>
    so logically it is working fine,,, until I paste query from form(two)…

    I am new to asp so that’s why I need help,,, thanks to all

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,893
    Thanks
    79
    Thanked 4,421 Times in 4,386 Posts
    Once again, we can't help you if you don't show your code.

    For starters, show the code where you generate the SQL query that gives the error.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •