Adding Records at Start

[Mark Maslowski]

> Is your ID field a string or a number? If it is sorted as you write then it
> is sorting in alpha order which will sort all records beginning with 1
> (including 10, 11, etc.), then 2. To get it to sort in numerical order the
> field needs to be set as short or another numerical field.
> 
> Hope that helps.


Yes, that did help the ordering. However, I still need to find out why the
DISTINCT is not working with an ORDER BY in the SQL query.

Thanks.

- Mark

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Mark D. Maslowski
Partner/Designer/Programmer

MAJICo - The Mark and June Interactive Company
Serving Northern California - from Napa to Monterey!
www.majico.com

831-336-3343 voice       831-336-3353 fax

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*