Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 28th, 2006, 05:34 AM
Registered User
 
Join Date: Dec 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default filtering results?

hi there,
I am new to ASP so please bear with me. I am using a generic loop to retrieve a result set form an MS Acess database - no problem. What I need to do now is differeniate betweeen the data in the table. for eaxmple one column is called year with data of 2004, 2005 and 2006, is there a way but I now need to take the tabulated table data and transfer it to another ASP based page and covert the results to XML. I can do this with hard coded variables but can't seem to be able to work out how to do it with data from a table. Any help greatly appreciated.

chris
 
Old June 30th, 2006, 03:30 PM
Friend of Wrox
 
Join Date: Nov 2005
Posts: 223
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Could you explain the problem a little bit more understandable.

Things I get from your post so.
1. You have a ms acces database
2. you have a asp page that retrieves database data.
3. You want to put data in a xml file.

Things I don't get is what do you mean with the table. Is this a table on your page that is generated in your asp file like this
Code:
<table><tr><td></td></tr></table>
or are you refering to a table from your database.

__________________________________________________ ________
This is my junk I'm gona eat it
 
Old July 4th, 2006, 09:41 AM
Authorized User
 
Join Date: Jun 2003
Posts: 79
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to erobb Send a message via Yahoo to erobb
Default

> I am using a generic loop to retrieve a result set form an MS Acess database - no problem.
>What I need to do now is differeniate betweeen the data in the table.

Why not just create the xml file based on the query you used to build the table? Its sounds like to me they are both using the same data from the db query only one is html & one is xml.

If thats the case instead of DB-->Table-->XML use Table<--DB-->XML


Earl
www.jhdesigninc.com







Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use OR during filtering..... raaj81 Reporting Services 0 July 30th, 2008 05:34 AM
filtering with dates pettrer ASP.NET 2.0 Basics 1 September 13th, 2007 01:19 PM
Edit Query Results in Results Grid druid2112 SQL Server 2005 1 June 28th, 2007 08:49 AM
Filtering FSO results nancy Classic ASP Components 3 October 3rd, 2005 10:15 PM
Filtering My Inbox steve-o General .NET 0 September 22nd, 2004 08:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.