J.R. I'm sorry if it seemed like I didn't appreciate what you said the other
day & in all likelyhood they probably do work but at this stage I'm lost and
confused when it comes to sorting this out - my problem: I CAN'T FOR THE
LIFE OF ME FIGURE OUT WHERE TO PUT THE "SELECT" OR "WHERE" STATEMENTS & THEN
HOW TO USE IT SO THAT I CAN GET THE DATA I WANT FROM THE DB TO APPEAR WHERE
I WANT IT TO.
so fed up with this.
I've got so much information & help but I don't know what to do with it -
going round in circles.
I might understand it better if someone could show me the code to do what I
want:
DB table is called page_edits
4 columns in that table called Number (Auto Number) UserName, Password,
Details
30 rows in the table.
Now, say you have a HTML page with two HTML tables on it - if you wanted to
have the "Details" for row 12 appear in the first HTML table & then in the
other HTML table have the "Details" of row 26 - how would you code that?
I've more than likely been given the code already by good people like
yourself J.R. but I don't know how to use it.
I've been reading ASP for Dummies (how apt!) & SAMS Teach Yourself ASP in 21
days but although I know how to display the whole table from the DB I can't
display selected bits (like the "Details" for any row I choose).
My sincerest apologies for dragging the arse out of this but I just don't
get it & still need help with it.
best regards
jac.
---------------------
DatabaseConnect.asp SSI
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=project"
objConn.Open
%>
---------------------------
index.asp
<%@ Language=VBScript %>
<%Option Explicit %>
<!--#include file="adovbs.inc"-->
<!--#include file="DatabaseConnect.asp"-->
<html>
<head>
<title>CMS Demo</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="cms.css" type="text/css">
<script id="chromeless" src="pz_chromeless_2.1.js"></script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
Dim objRS
Set objRS=Server.CreateObject("ADODB.Recordset")
objRS.Open "page_edits", objConn, , adLockOptimistic, adCmdTable
%>
<table width="98%" border="0" cellspacing="0" cellpadding="0"
align="center">
<tr>
<td class="main" align="center" valign="top" bgcolor="#E4E4F1">
<p>Page Header - Logo, etc...</p>
<p> </p>
</td>
</tr>
<tr>
<td align="center" valign="top" height="220">
<table width="100%" border="0" cellspacing="0" cellpadding="0"
align="center">
<tr>
<td align="center" valign="top" width="25%">
<table width="99%" cellspacing="0" cellpadding="4" align="left"
bordercolor="#666699">
<tr align="left" valign="top">
<td width="2%" bgcolor="#B7B7D0"><img src="images/cube.gif"
width="8" height="8"></td>
<td width="98%" class="main" bgcolor="#B7B7D0"
height="200"><%=objRS("Details of Row1")%></td>
</tr>
</table>
</td>
<td align="center" valign="top" width="50%">
<table width="100%" border="0" cellspacing="0" cellpadding="4"
align="center" bordercolor="#666699">
<tr align="left" valign="top">
<td width="2%" bgcolor="#B7B7D0"><img src="images/cube.gif"
width="8" height="8"></td>
<td width="98%" class="main" bgcolor="#B7B7D0"
height="200"><%=objRS("Details of Row 2")%></td>
</tr>
</table>
</td>
<td align="center" width="25%" valign="top">
<table width="99%" border="0" cellspacing="0" cellpadding="4"
align="right" bordercolor="#666699">
<tr align="left" valign="top">
<td width="2%" bgcolor="#B7B7D0"><img src="images/cube.gif"
width="8" height="8"></td>
<td width="98%" class="main" bgcolor="#B7B7D0"
height="200"><%=objRS("Details of Row 3")%></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" valign="top" class="main" bgcolor="#E4E4F1">
<p>Footer - Links, etc...</p>
<p> </p>
</td>
</tr>
<tr>
<td align="center" valign="top" class="main"><img src="images/cube.gif"
width="8" height="8" ></td>
</tr>
</table>
<%
objRS.Close
Set objRS=Nothing
objConn.Close
Set objConn=Nothing
%>
</body>
</html>
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
