1 2 3 4 5 Not 1 10 11 12 13 14 15

[Clukey]

Hy, I have created a recordset and have numbered the enteries in a specific
column, and I want the records to show in order (i.e. 1, 2, 3, 4, 5 ... 8, 9,
10, 11, 12), but when I sort the recordset it shows like this 1, 10, 11, 12,
13, ... 18, 19, 2, 20, 21, 22, ect. How do I get it to show the records in the
correct order, Thanks.

[Chris In Madison]

I'm betting that your numbers are being stored in a text field in the
database... Am I right? If so, can you change the datatype to INT?

Best regards,
Chris

[darrel]

> Hy, I have created a recordset and have numbered the enteries in a
specific

> column, and I want the records to show in order (i.e. 1, 2, 3, 4, 5 ... 8,

9,

> 10, 11, 12), but when I sort the recordset it shows like this 1, 10, 11,

12,

> 13, ... 18, 19, 2, 20, 21, 22, ect. How do I get it to show the records in

the

> correct order, Thanks.

Use integers instead of text strings.

-Darrel

[Tom Muck]

"Clukey" <webforumsuser@macromedia.com> wrote in message
news:d6aqpl$nml$1@forums.macromedia.com...

> Hy, I have created a recordset and have numbered the enteries in a

specific

> column, and I want the records to show in order (i.e. 1, 2, 3, 4, 5 ... 8,

9,

> 10, 11, 12), but when I sort the recordset it shows like this 1, 10, 11,

12,

> 13, ... 18, 19, 2, 20, 21, 22, ect. How do I get it to show the records in

the

> correct order, Thanks.

Your fields are stored as text instead of numbers, as was pointed out, but
if you can't change the data type for whatever reason you can order it by
using a sql keyword. You didn't say what kind of database, but here is code
for two of them:

SQL Server:

SELECT ID, blah from MyTable
ORDER BY CAST(ID as int)

Access:

SELECT ID, blah
FROM MyTable
GROUP BY id, blah
ORDER BY sum(ID);


--
--
Tom Muck
co-author Dreamweaver MX 2004: The Complete Reference
[url]http://www.tom-muck.com/[/url]

Extending Knowledge Daily
[url]http://www.communitymx.com/[/url]

[Clukey]

Hey, I changed the field to INT and it fixed it. Thanks