See the below AIR CODE FRAGMENT.
You said you wanted the records in different tables, which I took literally.
If you actually wanted them in different cells of the same table, then move
the <table> and <tr> tags outside the loop.
This won't take care of the left or right alignment. I ignored that,
figuring it was really part of what you needed help on.
HTH,
J.R.
<%
dim strDBProvider
dim strDSN
strDBProvider="Microsoft.Jet.OLEDB.4.0" ' you said Access earlier, if not,
change this.
strDSN="project"
const adOpenForwardOnly = 0 '# (Default)
const adUseServer = 2 '# (Default)
const adLockReadOnly = 1
Set adRST = Server.CreateObject("ADODB.Recordset")
adRST.ActiveConnection = "Provider=" + strDBProvider + ";Data Source="
+
strDSN +";"
adRST.CursorType = adOpenForwardOnly
adRST.CursorLocation = adUseServer
adRST.LockType = adLockReadOnly
adRST.Source = "SELECT details FROM page_edits" 'option where, such as
WHERE username=box1 AND password=box1pass
adRST.Open()
while NOT adRST.eof
response.Write("<table><tr><td>")
response.Write(adRST.fields.Item("details").value) 'can be
shortcutted
to adRST("details")
response.Write("</td></tr></table>")
adRST.movenext
wend
adRST.close()
%>
-----Original Message-----
From: Ingentus [mailto:ingentus@;eircom.net]
Sent: Monday, November 11, 2002 8:21 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: ACCESS & ASP problem
Hi J.R.
Thanks for trying to help but I'm still unsure as to what I'm supposed to
do...
This is the situation so far:
I have a DB with a table in it called page_edits
In this table there are 2 rows of info, as below:
Number | UserName | Password | Details
1 | Box1 | box1pass | blah blah blah blah...
2 | Box2 | box2pass | here here here here here...
What I need to do is to make the "Details" field of row 1 appear say at the
top lefthand side of the page &
the "Details" field of row 2 appear at, say, the bottom right of the same
page (in different HTML tables).
Any idea how I would code this? what SELECT statement would I use to
determine which "Details" field would appear where?
I was using <%=objRS("Details")%> in the <td> of the HTML table to make the
"Details" field appear & it works fine if I have only one row of info in the
DB table but I need to have many more than just one row in the DB table.
Hope I'm making sense
thanks for your help so far,
jac.
____ � 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.unsub%%
____ � 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]
