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

asad_ahmad · January 9th, 2012, 08:35 AM

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â¦
<a href="send_package.asp?client_id=<%=session("mem_i d")%>">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 :)

Imar · January 9th, 2012, 08:43 AM

Looks like an error in your SQL statement. Can you post the code that builds up the SQL statement, along with the final SQL statement before it gets sent to the database?

Cheers,

Imar

asad_ahmad · January 9th, 2012, 09:37 AM

In member area -send_package.asp- is open by this at the moment i m not inserting query…

Code:

<a href="send_package.asp?client_id=<%=session("mem_id")%>">Send Package</a>

send_package.asp contains form with in a html table
suppose it has 6 values 3 are filled by session variables and other 3 by user selection
from contacts

and i used this query to chk on form(two) on seperate pg and it works fine

Code:

<%
contacts_id=request("contacts_id")
Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1 = "select * from add_contacts where contacts_id="&contacts_id&"" 
rs1.Open sql1, conn
While Not rs1.EOF
%>
some html....
<%
rs1.MoveNext
Wend
%>

and when i put this on send_package.asp then this pg generate errors

Imar · January 9th, 2012, 09:53 AM

Quote:

and i used this query to chk on form(two) on seperate pg and it works fine

It would be better if you posted the code that *doesn't* work.

Also, use Response.Write to write out the problematic SQL statement and post it here. I think your statement is wrong somehow because of missing values.

Cheers,

Imar