Please help: error on page

Results 1 to 2 of 2

Thread: Please help: error on page

  1. #1
    Shayla Guest

    Default Please help: error on page

    I spended couple hours but the error still there. Please take a look to see where my mistake is.<BR>-----<BR><BR>Here is the code:<BR>------------------------------------<BR>ElseIf Request.Form("FormAction") = "Step3" Then<BR>Response.write ("hello")<BR>&#039;Build the update string<BR> strSQL = "Update tblCategory Set " & _<BR> <BR> "Category_Code = " & _<BR> CLng(Request.Form("txtCategory_Code")) & ", " & _<BR> "Category_Name = " & _<BR> CLng(Request.Form("txtCategory_Name")) & ", " & _<BR><BR> "Where Category_Name = &#039;" & _<BR> CStr(Request.Form("txtCategory_Name")) & "&#039;"<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>vCS1 = "Provider= Microsoft.Jet.OLEDB.4.0"<BR>vCS1 = vCS1 & "; Data Source=D:InetPubconstructionPFRC.mdb"<BR>objConn.c onnectionstring = vCS1<BR>objConn.Open objConn.connectionstring<BR><BR><BR> &#039;Create and open the database object<BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.Open oConn1.connectionstring<BR><BR> &#039;Create the command object<BR> Set objCmd = Server.CreateObject("ADODB.Command")<BR><BR> &#039;Set the command object properties<BR> Set objCmd.ActiveConnection = objConn<BR> objCmd.CommandText = strSQL<BR> objCmd.CommandType = adCmdText<BR><BR> &#039;Execute the command<BR> objCmd.Execute<BR><BR> &#039;Display the update string<BR> Response.Write "The following update string was executed and " & _<BR> "the values updated in the tblCategory table.&#060;P&#062;"<BR> Response.Write strSQL<BR><BR> &#039;Close and dereference database objects<BR> Set objCmd = Nothing<BR> objConn.Close<BR> Set objConn = Nothing<BR><BR>End If &#039;End If for step processing<BR>

  2. #2
    Kentium Guest

    Default RE: Please help: error on page

    It would be nice to know what error you&#039;re getting...

Posting Permissions

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