LAST agregate function !!!
From: Adam Knight (adam.jknight_at_optusnet.com.au)
Date: 06/06/04
- Next message: sam: "asp fonts problems (chinese fonts become ??????)"
- Previous message: Atrax: "Re: ASP performance issues"
- Next in thread: Ken Schaefer: "Re: LAST agregate function !!!"
- Reply: Ken Schaefer: "Re: LAST agregate function !!!"
- Maybe reply: Evertjan.: "Re: LAST agregate function !!!"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 6 Jun 2004 16:12:20 +1000
Set rs2 = cn.execute("select LAST(invoice_date) from invoice where
invoice_registration='0003' and invoice_member_id=" & CInt(rs(0)) & " Order
By invoice_date asc")
You tried to execute a query that does not include the specified expression
'invoice_date' as part of an aggregate function.
/connect/admin/reminder/reminder.asp, line 14
Could someone be kind enough to give me a resolution to the problem above.
How do i accomplish this using JET SQL.
AK
- Next message: sam: "asp fonts problems (chinese fonts become ??????)"
- Previous message: Atrax: "Re: ASP performance issues"
- Next in thread: Ken Schaefer: "Re: LAST agregate function !!!"
- Reply: Ken Schaefer: "Re: LAST agregate function !!!"
- Maybe reply: Evertjan.: "Re: LAST agregate function !!!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
