[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Hi i am getting error like the below, can any one help me in this....
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/railwaysproject/local/bangalore/deletetn.asp, line
<%@LANGUAGE="VBSCRIPT"%>
<%
const action_add="add"
const action_view="view"
const action_delete="del"
const action_edit="edit"
const validate_yes="y"
const norecordselected=-9999
%>
<html>
<LINK rel=stylesheet href=menu.css type=text/css>
<script language=JavaScript src=content1.js></script>
<script language=JavaScript src=menu.js></script>
<!--#include file="database.asp"-->
<!--#include file="adovbs.inc"-->
<%
'Main Processing loop
sub main()
dim straction
dim blnisvalidation
dim stn
%>
<body>
<%
tn=request("tn")
set objrs=server.CreateObject("adodb.recordset")
strsql="select * from sbcswrtds where tn=" & tn
objrs.open strsql,objconn,3,3
%>
<table align="center">
<tr><td height="25"><font size=3 face="Verdana, Arial, Helvetica, sans-serif" color="blue"><b>Are you sure to delete "<%=objrs("tn")%>"</b></font></td></tr>
</table>
<form name="form1" method=post action="deletetn1.asp" onSubmit="return validate();" >
<p>
<table align="center">
<tr>
<td></td>
<td height="80">
<input type="submit" name="submit1" value="Delete" ></td></tr>
</table>
</p>
</form>
</body>
</html>
<%
end sub
'Code begins executing here
call main
%>
Regards,
Thirulok..
| DevX Home | Today's Headlines Articles Archive Tip Bank Forums |
Reply With Quote
Bookmarks