[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] ASP like Perl
On Wed, Dec 05, 2001 at 10:32:37AM +0100, Steffen Dettmer wrote:
> * Korey Gozman wrote on Fri, Nov 30, 2001 at 15:12 -0800:
> > I want to pull all the fields that match the criteria
> > but it only displays the last entry in tha table.
> > any suggestions?
>
"All the fields?" You probably mean "all records"?
> For postgres, you could order reverse and give a limit 1, i.e.:
>
> select sku from products where ... order by ... limit 1
>
> But in standard-SQL it's not really possible I think, usually SQL
> is deterministic :)
What is "last entry"? Most recent timestamp? Last by
some counter? etc... Bet you can answer the question yourself
when you get it clear.
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users