|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
please help update sql
Hi i am trying to build an updatable profile area for members
but am getting Microsoft VBScript runtime error '800a01a8' Object required: '[string: "utown"]' /myspace/edit_userloc.asp, line 31 when i run this bit of code : username = Request.cookies("isLoggedInAs")("username") town = cstr(Request.form("utown")) postcode = cstr(Request.form("upostcode")) alerts = cstr(Request.form("alerts")) set racDB = Server.CreateObject("ADODB.Connection") racDB.Open "rac" set insertset = Server.CreateObject("ADODB.RecordSet") insertset.Open "memb_loc", racdb, _ adOpenstatic, adCmdTable if p_existing = "" then insertset.AddNew else updateset.Find "username =" &p_existing end if set town = "utown" set postcode = upostcode set("alerts") = alerts updateset.Update updateset.Close set insertset = Nothing racDB.Close set racDB = Nothing Response.Clear this is the form action i am using <FORM ACTION="edit_userloc.asp" METHOD = "post"> <TABLE> Town: <INPUT TYPE="text" NAME="utown" size = "30" VALUE="<%=town%>"><BR> Postcode: <INPUT TYPE="text" NAME="upostcode" size = "8" VALUE="<%=postcode%>"><BR> <div align="left">Send me <select name="distance" size="1"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7" selected>7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> </select> text alerts per week</div> </TABLE> <Input TYPE="submit" value = "Update"> </FORM> please help steve |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > please help update sql |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|