Kathleen
Mon Apr 18 05:26:47 CDT 2005
You would make this change to your SQL statement. Open the page, switch to
Code View, and find the statement that starts with s-sql="SELECT and copy
and paste here.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
blog:
http://msmvps.com/spiderwebwoman/category/321.aspx
"Jalb_k" <Jalbk@discussions.microsoft.com> wrote in message
news:3827DDCB-D290-4927-9185-BAEC19456973@microsoft.com...
> Thanks for the quick response Kathleen... I had actually already been
> through
> your site after a Google on my question before posting here but, as an
> ASP/SQL n00b I have no idea where to put the FORMAT statement. Perhaps I
> should have phrased my question differently or tried an SQL Forum.
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>>
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>>
http://www.spiderwebwoman.com/resources/
>>
>>
>>
>> "Jalb_k" <Jalb_k@discussions.microsoft.com> wrote in message
>> news:E5E7286F-D4C9-4633-B7D2-C2802DC7637F@microsoft.com...
>> > I'm making my first foray into ASP creating a webpage for my hobby
>> > business
>> > (www.webhedz.com.au). I'm able to get results from my Access database
>> > (using
>> > MySQL) but I'm unable to get the 'Item_Price' column to format as
>> > currency,
>> > or apply formatting to any of the columns for that matter. Is this a
>> > minor
>> > task or do I need to learn more on the database/SQL side?
>>
>>
>>