Is there anything wrong w/ my code?? please help..

Results 1 to 3 of 3

Thread: Is there anything wrong w/ my code?? please help..

  1. #1
    LL Guest

    Default Is there anything wrong w/ my code?? please help..

    This is an insert page and the insert works fine. But this source code is messing up my other pages... can someone please take a look to see if there&#039;s a syntax error on this page?? Greatly appreciated!!<BR><BR>set cn=Server.CreateObject("ADODB.connection")<BR>set rs=Server.CreateObject("ADODB.Recordset")<BR>cn.Op en "DSN=PROGRESS"<BR><BR>qty = Request.QueryString("qty_form")<BR>itemnum= Request.QueryString("itemnum_form")<BR>custnum = Request.QueryString("custnum_form")<BR>po = Request.QueryString("PO_form")<BR>shipment = Request.QueryString("shipment_form")<BR>src="Photo "<BR>stts = "N"<BR>line= 1<BR>today=Date()<BR><BR>Application.Lock<BR><BR>c n.Execute("UPDATE pennaux.ordh-control SET ordh-next-ord# = ordh-next-ord# + 1") <BR><BR>rs.Open "SELECT ordh-next-ord# FROM pennaux.ordh-control", cn <BR><BR>ordernum = CLng(rs(0)) <BR><BR>Application.Unlock <BR>rs.Close <BR><BR>rs.Open "pennaux.ordh", cn, adOpenKeySet, adLockPessimistic, adCmdTable <BR><BR>rs.AddNew<BR>rs("ord#") = ordernum<BR>rs("cust#") = custnum<BR>rs("custord") = po<BR>rs("priority") = shipment<BR>rs("src") = src<BR>rs("stts") = stts<BR>rs("update-on") = today<BR>rs.Update<BR><BR>rs.Close<BR><BR>rs.Open "pennaux.ordd", cn, adOpenKeySet, adLockPessimistic, adCmdTable <BR><BR>rs.AddNew<BR>rs("ord#") = ordernum<BR>rs("line#") = line<BR>rs("item") = itemnum<BR>rs("qty-ord") = qty<BR>rs("stts") = stts<BR>rs("added-on") = today<BR>rs.Update<BR><BR>rs.Close<BR>Set rs=nothing<BR>cn.Close<BR>Set cn=nothing<BR><BR>Response.Redirect("thankyou_ext. asp?ordernum_form=" & ordernum & "&custnum_form=" & custnum) <BR>%&#062;<BR>

  2. #2
    Join Date
    Dec 1969

    Default How can we possibly tell?

    You don&#039;t even give a *HINT* as to what is not working.<BR><BR>And, no, you don&#039;t have a syntax error. If you had a syntax error then the VBScript compiler would *tell* you so.<BR><BR>

  3. #3
    brother love Guest

    Default RE: Is there anything wrong w/ my code?? please he

Posting Permissions

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