ASP Grouping

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an ASP page that displays records in a table format. How can I make
the records group by a field. I would like to see the data group together my
results by say invoice number and a space and the next set records and so on.

Thanks.
 
Not sure I fully understand your question, however;

Is this your own ASP code or the DRW code? In which case the wizard has an
option to "sort by" or within your SQL query use the command "Sort by" - I
don't know what the actual syntax is, but it can be done.

e.g.

"Select * from Table INVOICES Where [%Invoice%] > 000001 AND [%Invoice%] <
000010 Sort by [INVOICE_NUM] ASCENDING"

etc.

If you're not familiar with ASP as such, using the Database Results Wizard
in Frontpage can achieve all you want on a basic level. My ASP and
programming expertise is virtually nil so I use the DRW all the time, and
that's all I need for my web sites.

You'll find some tutorials on the web showing how to display results from a
database and how to make the results repeat etc etc. Google for "ASP
tutorial".

For starters, www.webwizguide.info has a tutorial on this.

http://www.webwizguide.info/asp/tutorials/connecting_to_a_database.asp might
be of some help; it specifically deals with a guest book but the concept is
the same - Adding, Deleting, modifying records in an Access database.

Hope this helps
 
Back
Top