It seems that when I change the field from text to int it wont INSERT the
data correctly. It gives me errors. Welp, thanks for pointing that out
though.. gonna go mess with it s'more ;)
-Tiffany
----- Original Message -----
From: Top-Link Tech (John Ceci) <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 19, 2000 8:37 PM
Subject: RE: Silly question from a novice
> Tiffany,
>
> You are storing the data in your table as character data not numeric...
>
> John
>
> -----Original Message-----
> From: Tiffany - Tech Support [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 19, 2000 6:34 PM
> To: [EMAIL PROTECTED]
> Subject: Silly question from a novice
>
>
> This is probably the most lame question:
>
> When you do an ORDER BY in a query with a variable that will display
> numbers, of course it lists all the numbers like this:
>
> 1
> 12
> 20
> 6
> 70
> 9
>
> Instead of 1, 6, 9, 12, 20, 70 Why does it do that? And how can I get it
> to order them correctly?
>
> Thanks!
> _____________________________
> Tiffany
> Technical Support
> the spa! online services
> [EMAIL PROTECTED] (413)539-9818
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
