Ask a Question related to ASP Database, Design and Development.
-
Adam Knight #1
Help With SQL Statement !!
Is their a way i can group a bunch of records by their 'Type' And Order
these records within each group by their category. I am using Jet Sql
"Access".
This is what i have so far..
rs.Open "SELECT
Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type FROM
seminar Group By
Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type",cn
'Want to order by category within each group.
Thanx to all those who view this post.
AK
Adam Knight Guest
-
If Statement???
guys i was wondering if anybody here could help me. I have a page done up with all dynamic text and attributes on it that come from a management... -
Use of FOR statement
I am reading through a book on Objects and References and I don't understand this statement: $sum += $_ for split //; I thought a FOR... -
AW: if-else-statement
--On Wednesday, September 03, 2003 11:56 PM +0200 "B. Fongo" <mygrps@fongo.de> wrote: Look at the docs for CGI.pm under pragmas, the -nosticky... -
if statement
I'm trying to write an if statement i have two field, Status and Attendance. "status" value can be active or inactive "Attendance" value is active... -
IIF statement
Assuming the data is being entered via a form, then use the AfterUpdate event of the control that is bound to the signature field. The code you need... -
Ken Schaefer #2 Re: Help With SQL Statement !!
ORDER BY field1 [ASC | DESC]
Use ASC for ascending (the default) or DESC for descending. ORDER BY goes
after GROUP BY ...
Cheers
Ken
"Adam Knight" <aj.knight@optusnet.com.au> wrote in message
news:eFDft8YhDHA.452@TK2MSFTNGP12.phx.gbl...
: Is their a way i can group a bunch of records by their 'Type' And Order
: these records within each group by their category. I am using Jet Sql
: "Access".
:
: This is what i have so far..
:
: rs.Open "SELECT
: Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type FROM
: seminar Group By
: Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type",cn
:
: 'Want to order by category within each group.
:
:
: Thanx to all those who view this post.
:
: AK
:
:
Ken Schaefer Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
