RE: Viewing table data in a webpage using ASP

["G r e g L a w r i e" <greg.lawrie@xxxxxxxxxxxxxxxxxxx>]

Nick,

If you are able to add records, then your connection string is correct, at
least for viewing the table.

Need to see the code where you actually loop through and display each
record.

Greg



> -----Original Message-----
> From: Nick Boldt [mailto:nick@xxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, 4 December 2001 7:49
> To: mysql@xxxxxxxxxxxxxxx
> Subject: RE: Viewing table data in a webpage using ASP
>
>
> Here is the connection code I use to view record information from a
> table.  I'm using Dreamweaver Ultradev 4 to help with some of the basic
> coding.  I am using MyODBC.
>
> <%
> MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;"
>
> set ship_address = Server.CreateObject("ADODB.Recordset")
> ship_address.ActiveConnection = MM_TrackoftheWolf_STRING
> ship_address.Source = "SELECT * FROM customershipping"
> ship_address.CursorType = 0
> ship_address.CursorLocation = 1
> ship_address.LockType = 3
> ship_address.Open()
> ship_address_numRows = 0
> %>
> <%
> Dim Repeat1__numRows
> Repeat1__numRows = -1
> Dim Repeat1__index
> Repeat1__index = 0
> ship_address_numRows = ship_address_numRows + Repeat1__numRows
> %>
>
> Nick Boldt
> Computer Network Administrator
> Track of the Wolf
> Elk River, MN 55330
> Tel: 763-633-2500  Fax: 763-633-2550
> nick@xxxxxxxxxxxxxxxxxx
>
> -----Original Message-----
> From: Christopher R. Jones [mailto:cj@xxxxxxxxx]
> Sent: Monday, December 03, 2001 3:07 PM
> To: Nick Boldt
> Subject: Re: Viewing table data in a webpage using ASP
>
> If you have MyODBC installed and working you should be able to view the
> records.  I have a number of WEB pages that display MySQL data using
> ASP/ADO. You should send an example of you ASP script to the group to
> help
> clarify your problem.
>
>
>
> >Hi,
> >
> >I'm trying to view the records of a table in on a webpage, but nothing
> >is showing up.  I can add records to the table from the page but cannot
> >view, update or delete them.
> >
> >I'm using Windows 2000 and IIS 5.0
> >
> >I'm new to MySql and would greatly appreciate any help anyone can give
> >me.
> >
> >Nick Boldt
> >Computer Network Administrator
> >Track of the Wolf
> >Elk River, MN 55330
> >Tel: 763-633-2500  Fax: 763-633-2550
> >
> >
> >---------------------------------------------------------------------
> >Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> >To request this thread, e-mail <mysql-thread92925@xxxxxxxxxxxxxxx>
> >To unsubscribe, e-mail <mysql-unsubscribe-cj=cr-jay.ca@xxxxxxxxxxxxxxx>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> Christopher R. Jones, P.Eng.
> 14 Oneida Avenue
> Toronto, Ontario M5J 2E3
> Tel. 416 203-7465
> Fax. 416 203-8249
> Email cj@xxxxxxxxx
>
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread92927@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
> <mysql-unsubscribe-greg.lawrie=netadvantage.com.au@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92929@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php