table display

[Robert Mann]

Not sure what you are asking for?
I am using a valentina 2 database
The SQL works fine with the mysql database

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bart Pietercil
Sent: Saturday, May 05, 2007 9:40 AM
To: Valentina Developers
Subject: Re: table display

And your table schema is what exactly ?

Bart

On 5-mei-07, at 15:27, Robert Mann wrote:

> Have a table with the following in it
>
> 2002 CR 85
>
> 2002 CR 125
>
> 2004 CR 125
>
> 2002 CR 250
>
>
>
>
>
> And I would like to be able to display it for highest to lowest
>
> Like this
>
> 2004 CR 125
>
> 2002 CR 250
>
> 2002 CR 125
>
> 2002 CR 85
>
>
>
> But using the following SQL
>
> put "SELECT Year_Model FROM yearmodelsize WHERE yearmodelsize.BID='" &
> gbrandid & "' and yearmodelsize.stock_specs_complete='no' ORDER BY
> Year_Model DESC" into theSQL
>
>
>
> does not do this? What do I have to change with the table settings?
>
> It displays like this
>
> 2002 CR 85
>
> 2002 CR 125
>
> 2004 CR 125
>
> 2002 CR 250
>
>
>
>
>
>
>
> Thanks
>
> Rob
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina