hey guys, im a newbie in asp. im pretty bad in the part that connects the webpage to the mssql database using asp connection.
ive tried ways after ways to retrive the information from the database and i still cant get it right
dont even know if im on the right track. hope u guys can help me out
info in mssql -(table name : cust), (database name : silverstone )
-----------
-------------------------------
custid | custname |
----------------------------- |
A0123 | Joel Dumb dumb |
A0122 | Emous Bim Boe |
-------------------------------
coding
------
<%
Set SysConn = Server.CreateObject("ADODB.Connection")
SysConn.Open "silverstone", "sa", ""
%>
<html>
<body>
<%
CustID = Session(mstrSessionPrefix & "CustDlg-CustUserID"CustID = Request.QueryString("CustID")
' Set sql.
strSQL = "SELECT * "
strSQL = strSQL & "FROM cust "
%>
<tr>
<tr>
<td> Car Registration Number : </td>
<form name="form4" method="post" action="">
<td>
<input name="text_regno" type="text" id="text_regno">
</td>
</form>
</tr>
<tr>
<td> Car Registration Number : </td>
<form name="form4" method="post" action="">
<td>
<input name="text_regno" type="text" id="text_regno">
</td>
</form>
</tr>
</tr>
</body>
</html>
<%
SysConn.Close
set SysConn = nothing
%>
pls help me out. thankx in advance !
dBforums
>
problem retriving information from database
06-23-06, 04:17
problem retriving information from database
Linear Mode
