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:[EMAIL PROTECTED]] > Sent: Tuesday, 4 December 2001 7:49 > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > > -----Original Message----- > From: Christopher R. Jones [mailto:[EMAIL PROTECTED]] > 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 <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >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 [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
