Hello friends,
I am a new ASP user and a have a problem.
I have a data base with a lot of compan names which can appear more
than one time.
Example:
company: ABC
category: A
product: TV
company: ABC
category: A
product: Radio
company: Bosch
category: B
product: LED
company: Simens
category: A
product: TV
Now I want to list this records by "category" ( company ABC should
then appear only one time ).
I try:
Rs.Open "select * from TblCompany where category= '" & Request.Form
("category") group by category", Con
but I allways receive an error message.
How do I correctly use
- Order by
- Compue Sum
Thanks a lot
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
