please help

Results 1 to 2 of 2

Thread: please help

  1. #1
    Join Date
    Dec 1969

    Default please help

    can anyone please tell me why the last statement rst.update is sowing an error?<BR><BR>&#039Create a connection to our database using a fileless dsn<BR>Response.Buffer = true<BR>dim cnn,rst<BR>set cnn = Server.CreateObject("ADODB.Connection")<BR>set rst = Server.CreateObject("ADODB.RecordSet")<BR>cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=c:/webshare/webpub/all/custom.mdb;"<BR>sqltext = "SELECT * FROM custom"<BR>rst.Open sqltext,cnn,3,3<BR><BR>SQLupdate = "Update tblData Set custom = &#039"&remarks&"&#039 WHERE login = "&login&""<BR><BR>&#039Server Side form validation to keep our database clean<BR>dim login,replied<BR><BR><BR>remarks = Request.Form("remarks")<BR><BR>&#039If we pass through validation then store the information in the db<BR><BR>rst.AddNew<BR>rst("remarks") = remarks<BR>rst.update<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: please help

    You might try setting up an ODBC connection rather than using <BR>cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=c:/webshare/webpub/all/custom.mdb;"<BR><BR>I have always had problems when using that.<BR>You might also want to try executing an Update SQL statement rather than "rst.update". It is faster and is a little more stable.<BR><BR>Also, try only posting on message for 1 question. Not 6 for the same.<BR>

Posting Permissions

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