Professional Web Applications Themes

Placement - ASP Database

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 ...

  1. #1

    Default 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

  2. #2

    Default 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" <tmidgettunitedfidelity.com> wrote in message
    news:ejWx5NiSDHA.1868TK2MSFTNGP11.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

  3. #3

    Default 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]mschuppielearning.com[/email]
    [url]http://www.ielearning.com[/url]
    714.637.9480 x17


    "Tim Midgett" <tmidgettunitedfidelity.com> wrote in message
    news:ejWx5NiSDHA.1868TK2MSFTNGP11.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

Similar Threads

  1. my.cnf placement
    By Ted in forum MySQL
    Replies: 0
    Last Post: July 18th, 08:42 PM
  2. Forum placement
    By matthobson1 in forum Macromedia Dynamic HTML
    Replies: 3
    Last Post: October 11th, 01:21 AM
  3. Placement of Controls
    By et in forum ASP.NET Building Controls
    Replies: 2
    Last Post: September 27th, 05:46 PM
  4. MIAW Placement
    By Center Line webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 1
    Last Post: September 17th, 05:41 AM
  5. Popup placement
    By Jenny in forum ASP.NET General
    Replies: 2
    Last Post: August 15th, 11:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139