<h1 align ="center"> <Input type="submit" value =AddNew onclick="javascript:Hello();" >
        <script language = javascript>
             function Hello(){
              thisForm.action='EditPage.asp';
           thisForm.submit();
         }
               </script>

I want to call 'EditPage.asp from my first page which is my second page. If the person doesnot find the name in the data base, then he click add new button it should take him in the second page where all the text boxes are cleared and types in the names then. When i hit add button the error it gives
objRST.Open strNumber,objConn,3,3
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/EditPage.asp, line 23. I will appreciate if any body can help me. ThanksCa

Hi,

  Can you post that line where u got error?


------------
Rajani

CAN U TRY WITH FORM - ACTION TAG
<form name="hello" action="EditPage.asp" method="POST">


Gokulan Ethiraj

could u post the code of "EditPage.asp"

Charul Shukla

Yes if you post the code of "EditPage.asp" it will be helpful to trace out your problem.
 Check your Query statement in EditPage.asp page.Check whether you had missed out apostrophe character in the query.
Check whether you had done similar like this "where name='"&fname&"'".