RE: Viewing table data in a webpage using ASP

["Nick Boldt" <nick@xxxxxxxxxxxxxxxxxx>]

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-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php