Sounds great, here's the error that generated ...
Undefined function 'LPAD' in expression.
SQL = "SELECT LPAD(SortOrder,3,'0'), OrdPgCategory
FROM Catalog
ORDER BY SortOrder
Since this is a very simple query, perhaps I can do some ColdFusion
manipulation of the original results??
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
CONFIDENTIALITY NOTICE: This email message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Laire Josh
Sent: Thursday, June 28, 2001 9:24 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Ordering numbers from SQL
You can try to do an LPAD to Three characters with 0. This should place
them in the correct order.
> -----Original Message-----
> From: Keith Purtell [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 9:07 AM
> To: KCFusion
> Subject: [KCFusion] Ordering numbers from SQL
>
> I've seen this somewhere but now I can't find the solution. I have a query
> where the SQL uses a standard ORDER BY option. It's not recognizing the
> difference between two and three-digit numbers. How can I overcome this
> problem? Sample results from CFOUTPUT ...
>
> 11 12 30 300 303 31 312 356 361 40 45 50
>
> Keith Purtell, Web/Network Administrator
> VantageMed Operations (Kansas City)
> http://www.vmdc.net/
>
> CONFIDENTIALITY NOTICE: This email message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply email and destroy all copies of the original
> message.
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
