georgy
-
Posts
3 -
Joined
-
Last visited
georgy's Achievements
Newbie (1/7)
0
Reputation
-
only the syntax of my add script r showing after i click the add button......what shall i do???????
-
only the syntaxof add script r showing after i click the add button......what shall i do???????
-
this r d codes on html...<body> <form action="Add.asp" method="POST"> name: <input type="Text" name="txtname"size="20"><br> idno: <input type="Text" name="txtidno" size="20"><br> <input type="Submit" name="" value="Add"> </form> </body> and the another one from asp......<% if request("submitted") thendim conn,rst,bidno,bnamebidno=request("txtname") bname=request("txtidno") If idno="" or name="" then%><p>Empty fields not allowed</p><%Set conn = Server.CreateObject("ADODB.Connection") conn.Provider ="Microsoft.Jet.OLEDB.4.0"conn.Open(DataSource("/documents/project.mdb"))Set rs = Server.CreateObject("ADODB.Recordset") rs open "select * from project", where idno="" '"& bidno&"'") if rst.eof then conn.execute "insert into project (idno,name)values ('"&bidno&"','"&bname&"')"%><p>Record was successfully save</p> <a href= "addScript.asp">Add</a><br><%else%><p>Cannot Add Record with Duplicate IdNo</p> <a href= "add.asp">Add</a><br<p><a title="click to add" href="Add.html">ADD</a></p><%end ifconn.closeset conn = nothingset rst = nothingend ifend if%>when i click the add button only the syntax of my asp are showing?????what shall i do?????ples help me to this simple problem...............