Ask a Question related to ASP Database, Design and Development.
-
Tim Williams #1
Re: Response.write tables
There are no "table commands".
If you're going to be doing any ASP at all, the first thing you should do is
find out about HTML.
<table>
<%
do while not rscalls.eof
response.write "<tr>"
response.write "<td>" & rscalls("fld1") & "</td>"
response.write "<td>" & rscalls("fld2") & "</td>"
response.write "</tr>"
rscalls.movenext
loop
%>
</table>
tim
"Tim Midgett" <tmidgett@unitedfidelity.com> wrote in message
news:797741630997176@Asp.ForumsZone.com...table when it is added. It list all the info on the screen. I would like to> When I add a record to my access database I have it display the access
have the output in a table but I am not sure how to add the table commands
to my response.write on my asp output page. The following is the page that I
am using now.Server.MapPath("ccalls.mdb")> <html>
> <head>
> <title>Customer Calls</title>
> </head>
> <body bgcolor="white" text="black">
> <%
> Dim adoCon
> Dim rsaddccalls
> Dim strSQL
>
> Set adoCon = Server.CreateObject("ADODB.Connection")
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&calltable.fname, calltable.initial, calltable.lname, calltable.account,>
> Set rsccalls = Server.CreateObject("ADODB.Recordset")
>
> strSQL = "SELECT calltable.date, calltable.time, calltable.operator,
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 ("<br>")
> Response.Write (rsccalls("date"))
> Response.Write ("<br>")
> Response.Write (rsccalls("time"))
> Response.Write ("<br>")
> Response.Write (rsccalls("operator"))
> Response.Write ("<br>")
> Response.Write (rsccalls("fname"))
> Response.Write ("<br>")
> Response.Write (rsccalls("initial"))
> Response.Write ("<br>")
> Response.Write (rsccalls("lname"))
> Response.Write ("<br>")
> Response.Write (rsccalls("account"))
> Response.Write ("<br>")
> Response.Write (rsccalls("ssn"))
> Response.Write ("<br>")
> Response.Write (rsccalls("direct"))
> Response.Write ("<br>")
> Response.Write (rsccalls("deposit"))
> Response.Write ("<br>")
> Response.Write (rsccalls("phone"))
> Response.Write ("<br>")
> Response.Write (rsccalls("address"))
> Response.Write ("<br>")
> Response.Write (rsccalls("reason"))
> Response.Write ("<br>")
> rsccalls.MoveNext
>
> Loop
>
> rsccalls.Close
> Set rsccalls = Nothing
> Set adoCon = Nothing
> %>
> </body>
> </html>
>
> Thanks Tim
>
> -----------------------------
> This message is posted by [url]http://Asp.ForumsZone.com[/url]
>
Tim Williams Guest
-
response.write URL
I have a page which lists conferences and events which the company for which I coded the site attends or hosts themselves. They want to be able to... -
Response.Write doesn't work
And why doesn't my swedish characters (هنِ) show up in the email correctly? <% Namn = Request.form("namn") Adress = Request.form("adress")... -
If response.write help
Hi, I am trying to code my asp page so that if you are on page Y, the link to page Y in the nav, is in the over state to help users identify where... -
Response.Write not working
Hello, in my ASP.NET c# project I can ouput text using response.write from the code behind class. It works in the aspx file using <asp:TextBox>... -
Response.Write and Response.Redirect
On my Page_Load event, i need to do some validation and then either let them proceed, or display a error message and boot them back to the previous... -
Tim Midgett #2 Re: Response.write tables
Thanks Guys help alot.
Thanks Tim
*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!
Tim Midgett 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
