|
| |
|
|
excaliburdotcom
Posts: 2
Joined: 10/19/2004
Status: offline
 |
database query - 10/19/2004 4:00:32
hi to all im a newbie in asp javascript programming i would like to ask how to make q query using the select statement...will somebody fix these code...my problem is that i cant execute or look up a record with this code...need need help big help please....
<%@Language=JavaScript%>
<!--#include file="adojavas.inc"-->
<%Response.Buffer=true%>
<html>
<title>Adding Record Server 1</title>
<body>
<%
var vidno,vname,connect,rset,holder;
vidno=Request.Form("idno");
connect=Server.CreateObject("ADODB.Connection");
connect.Open("FILEDSN=passing.dsn");
rset = Server.CreateObject("ADODB.Recordset");
var Querystring="select * from stud2 where idno== " + Request.Form("idno") + ";"
var myquery=connect.execute(Querystring);
%>
<table border="1">
<tr>
<td><%=(Querystring("idno"))%></td>
<td><%=(Querystring("name"))%></td>
</tr>
</table>
<%
connect.Close();
%>
</body>
</html>
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
