Search results for query: *

thanks a lot for everyone's help. i couldn't get anything to work for me so i did it at the coldfusion level, which works great: SELECT *, Format(isize,'General Number') As FormattedPrice FROM tbl_options and then display the number as #FormattedPrice# Thanks again to everyone who helped

thanks for the replies. Jebry: I wouldn't know how to do that sort of thing with the Order By. RJoubert: I did that, but my prob is this now: If the number is 5, it is showing it as 5.0. I only wanted to show the decimal if there is infact a decimal number. any suggestions on that?

I have numbers in my Access 2k db that may be either a single digit (4) or a decimal (4.5). Since i am trying to do an ORDER BY in coldfusion, i guess i have to change this Datatype from Memo to Number, but i am not sure what the FieldSize, Format or Decimal Settings should be. I have played...

for some reason, my flash movie isn't reading the first line of XML. any help would be greatly appreciated my xml looks like this:<?xml version="1.0" encoding="iso-8859-1"?> <xml> <gallery path="images2"/> <disk artist="none" title="none" label="CASABLANCA RECORDS" credit="none"...