Ask a Question related to ASP Database, Design and Development.
-
Tim Midgett #1
Placement
Hi I am using the following page to display my data when it is entered
into an access database. It is working great the only problem is now
that I have the <table> in there it adds the new record in the middle of
the table not on the end.(only in display, It is at the end of the
access database). Any ideals what I am doing wrong?
<html>
<head>
<title>Customer Calls</title>
</head>
<body bgcolor="white" text="black">
<table background="images/frbk014.jpeg" border="1" style="border-style:
solid"
bordercolor="#808080"><th>Date</th><th>Time</th><th>Operator</th><th>Fir
st Name</th><th>Middle Initial</th><th>Last
Name</th><th>Account</th><th>SSN</th><th>Deposit From</th><th>Amount
Deposit</th><th>Phone</th><th>Address</th><th>Reason</th>
<%
Dim adoCon
Dim rsaddccalls
Dim strSQL
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&
Server.MapPath("ccalls.mdb")
Set rsccalls = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT calltable.date, calltable.time, calltable.operator,
calltable.fname, calltable.initial, calltable.lname, calltable.account,
calltable.ssn, calltable.direct, calltable.deposit, calltable.phone,
calltable.address, calltable.reason FROM calltable;"
rsccalls.Open strSQL, adoCon
Do While not rsccalls.EOF
Response.Write "<tr>"
Response.Write "<td>" & rsccalls("date") & "</td>"
Response.Write "<td>" & rsccalls("time") & "</td>"
Response.Write "<td>" & rsccalls("operator")& "</td>"
Response.Write "<td>" & rsccalls("fname") & "</td>"
Response.Write "<td>" & rsccalls("initial") & "</td>"
Response.Write "<td>" & rsccalls("lname") & "</td>"
Response.Write "<td>" & rsccalls("account") & "</td>"
Response.Write "<td>" & rsccalls("ssn") & "</td>"
Response.Write "<td>" & rsccalls("direct") & "</td>"
Response.Write "<td>" & rsccalls("deposit") & "</td>"
Response.Write "<td>" & rsccalls("phone") & "</td>"
Response.Write "<td>" & rsccalls("address") & "</td>"
Response.Write "<td>" & rsccalls("reason") & "</td>"
Response.Write "</tr>"
rsccalls.MoveNext
Loop
rsccalls.Close
Set rsccalls = Nothing
Set adoCon = Nothing
%>
</table>
</body>
</html>
Thanks Tim
*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!
Tim Midgett Guest
-
my.cnf placement
I am told that creating a my.cnf file, with the client's user id and password, and placing it it the user's home directory will provide some... -
Forum placement
Hi all, I'm new to this web designing and wish to add a forum into my website, but I'd like to be in context with the site and not one that I... -
Placement of Controls
I have placed 3 web user controls on a page, a header, a navigation and a products control. Each control is contained in a row and cell in a table.... -
MIAW Placement
I am trying to place a MIAW on the stage by calculating the center of the stage and then positioning the MIAW. This way it will be in the same place... -
Popup placement
Hi all, how can place a popup window relative to the assigned button instead of relative to the documents body? I'm using:... -
Aaron Bertrand - MVP #2 Re: Placement
I don't understand what you mean by middle and end of the table. This looks
like a table with only two rows... however you need to troubleshoot your
HTML. Your header row (the row with <th> tags) doesn't have a surrounding
<tr></tr>!
"Tim Midgett" <tmidgett@unitedfidelity.com> wrote in message
news:ejWx5NiSDHA.1868@TK2MSFTNGP11.phx.gbl...> Hi I am using the following page to display my data when it is entered
> into an access database. It is working great the only problem is now
> that I have the <table> in there it adds the new record in the middle of
> the table not on the end.(only in display, It is at the end of the
> access database). Any ideals what I am doing wrong?
> <html>
> <head>
> <title>Customer Calls</title>
> </head>
> <body bgcolor="white" text="black">
> <table background="images/frbk014.jpeg" border="1" style="border-style:
> solid"
> bordercolor="#808080"><th>Date</th><th>Time</th><th>Operator</th><th>Fir
> st Name</th><th>Middle Initial</th><th>Last
> Name</th><th>Account</th><th>SSN</th><th>Deposit From</th><th>Amount
> Deposit</th><th>Phone</th><th>Address</th><th>Reason</th>
> <%
> Dim adoCon
> Dim rsaddccalls
> Dim strSQL
>
> Set adoCon = Server.CreateObject("ADODB.Connection")
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&
> Server.MapPath("ccalls.mdb")
>
> Set rsccalls = Server.CreateObject("ADODB.Recordset")
>
> strSQL = "SELECT calltable.date, calltable.time, calltable.operator,
> calltable.fname, calltable.initial, calltable.lname, calltable.account,
> calltable.ssn, calltable.direct, calltable.deposit, calltable.phone,
> calltable.address, calltable.reason FROM calltable;"
>
> rsccalls.Open strSQL, adoCon
>
> Do While not rsccalls.EOF
>
> Response.Write "<tr>"
> Response.Write "<td>" & rsccalls("date") & "</td>"
> Response.Write "<td>" & rsccalls("time") & "</td>"
> Response.Write "<td>" & rsccalls("operator")& "</td>"
> Response.Write "<td>" & rsccalls("fname") & "</td>"
> Response.Write "<td>" & rsccalls("initial") & "</td>"
> Response.Write "<td>" & rsccalls("lname") & "</td>"
> Response.Write "<td>" & rsccalls("account") & "</td>"
> Response.Write "<td>" & rsccalls("ssn") & "</td>"
> Response.Write "<td>" & rsccalls("direct") & "</td>"
> Response.Write "<td>" & rsccalls("deposit") & "</td>"
> Response.Write "<td>" & rsccalls("phone") & "</td>"
> Response.Write "<td>" & rsccalls("address") & "</td>"
> Response.Write "<td>" & rsccalls("reason") & "</td>"
> Response.Write "</tr>"
> rsccalls.MoveNext
>
> Loop
>
> rsccalls.Close
> Set rsccalls = Nothing
> Set adoCon = Nothing
> %>
> </table>
> </body>
> </html>
>
> Thanks Tim
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!
Aaron Bertrand - MVP Guest
-
Mark Schupp #3 Re: Placement
If you want your records to be in a specific order then you will need to add
an "order by" clause to the SQL statement.
--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17
"Tim Midgett" <tmidgett@unitedfidelity.com> wrote in message
news:ejWx5NiSDHA.1868@TK2MSFTNGP11.phx.gbl...> Hi I am using the following page to display my data when it is entered
> into an access database. It is working great the only problem is now
> that I have the <table> in there it adds the new record in the middle of
> the table not on the end.(only in display, It is at the end of the
> access database). Any ideals what I am doing wrong?
> <html>
> <head>
> <title>Customer Calls</title>
> </head>
> <body bgcolor="white" text="black">
> <table background="images/frbk014.jpeg" border="1" style="border-style:
> solid"
> bordercolor="#808080"><th>Date</th><th>Time</th><th>Operator</th><th>Fir
> st Name</th><th>Middle Initial</th><th>Last
> Name</th><th>Account</th><th>SSN</th><th>Deposit From</th><th>Amount
> Deposit</th><th>Phone</th><th>Address</th><th>Reason</th>
> <%
> Dim adoCon
> Dim rsaddccalls
> Dim strSQL
>
> Set adoCon = Server.CreateObject("ADODB.Connection")
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&
> Server.MapPath("ccalls.mdb")
>
> Set rsccalls = Server.CreateObject("ADODB.Recordset")
>
> strSQL = "SELECT calltable.date, calltable.time, calltable.operator,
> calltable.fname, calltable.initial, calltable.lname, calltable.account,
> calltable.ssn, calltable.direct, calltable.deposit, calltable.phone,
> calltable.address, calltable.reason FROM calltable;"
>
> rsccalls.Open strSQL, adoCon
>
> Do While not rsccalls.EOF
>
> Response.Write "<tr>"
> Response.Write "<td>" & rsccalls("date") & "</td>"
> Response.Write "<td>" & rsccalls("time") & "</td>"
> Response.Write "<td>" & rsccalls("operator")& "</td>"
> Response.Write "<td>" & rsccalls("fname") & "</td>"
> Response.Write "<td>" & rsccalls("initial") & "</td>"
> Response.Write "<td>" & rsccalls("lname") & "</td>"
> Response.Write "<td>" & rsccalls("account") & "</td>"
> Response.Write "<td>" & rsccalls("ssn") & "</td>"
> Response.Write "<td>" & rsccalls("direct") & "</td>"
> Response.Write "<td>" & rsccalls("deposit") & "</td>"
> Response.Write "<td>" & rsccalls("phone") & "</td>"
> Response.Write "<td>" & rsccalls("address") & "</td>"
> Response.Write "<td>" & rsccalls("reason") & "</td>"
> Response.Write "</tr>"
> rsccalls.MoveNext
>
> Loop
>
> rsccalls.Close
> Set rsccalls = Nothing
> Set adoCon = Nothing
> %>
> </table>
> </body>
> </html>
>
> Thanks Tim
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!
Mark Schupp Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
