Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
01-09-2012, 02:05 PM #1
- Join Date
- Jan 2012
- 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
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…
<a href="send_package.asp?client_id=<%=session("mem_id")%>">Send Package</a>
I am new to asp so that’s why I need help,,, thanks to all
01-09-2012, 10:08 PM #2
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.