Prev: Front Page 2003 Registry Keys Reg Edit
Next: SOLVED can't associate FrontPage with htm and html files
From: MickB Tenerife on 25 Mar 2010 08:50
Hi Kathleen and Stefan,
That was the perfect joint answer, I just could not see it myself. Many
thanks to you both, problem solved, my sincere thanks to you both, Mick


"Stefan B Rusynko" wrote:

> Plus you don't have your newvariable in the correct place
> - and the FP DBRW doesn't write Select *
> (it enumerates the variables in the Select statement as a coma separated list)
> You have
> SELECT * FROM Apmt1bed ORDER BY PriceEuros ASC
> And should have say
> SELECT PriceEuros, otherfield FROM Apmt1bed ORDER BY PriceEuros ASC
> where , otherfield would be your other DB fieldname or fieldnames required as a coma separated list
> And you would add your custom variable in the Select part as say
> SELECT Format(PriceEuros,'#,##0.00') as fmtamount, otherfield FROM Apmt1bed ORDER BY PriceEuros ASC
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "Kathleen Anderson" <kanderson(a)remove.mvps.org> wrote in message news:u8lmn3qyKHA.3264(a)TK2MSFTNGP06.phx.gbl...
> Hi Mick:
>
> Where did you make your changes? You should find the SQL in the gray-colored
> code and make your changes. Save the changes while still in Code view. You
> will notice that once you've saved your changes they are also made to the
> maroon colored code - that is by design. The maroon colored code should
> never be touched; it's generated by the gray code at save time.
>
> What kind of errors are you getting?
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - Expression Web
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> Expression Web Wiki: http://expression-web-wiki.com/
> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> Please reply to the newsgroup for the benefit of others
>
>
> "MickB Tenerife" <MickBTenerife(a)discussions.microsoft.com> wrote in message
> news:0A57DEA7-026A-4675-8056-8054300AC314(a)microsoft.com...
> > Hi Stefan thank you for the reply, howeve from a novice, where do i insert
> > the format code please.
> > If I go to page 2 of the DBRW I get
> >
> > SELECT * FROM Apmt1bed ORDER BY PriceEuros ASC
> >
> > if I try to change it to
> >
> > SELECT * FROM Apmt1bed,
> > format([priceeuros],'Currency') as fmtamount,
> > ORDER BY PriceEuros ASC
> > I get errors, any ideas please?
> >
> > "Stefan B Rusynko" wrote:
> >
> >> See
> >> http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency
> >> If you don't want the $ format, just use
> >>
> >> Format(priceeuros,'#,##0.00') as fmtamount
> >>
> >> --
> >>
> >> _____________________________________________
> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> "Warning - Using the F1 Key will not break anything!" (-;
> >> _____________________________________________
> >>
> >>
> >> "MickB Tenerife" <MickBTenerife(a)discussions.microsoft.com> wrote in
> >> message
> >> news:296E2AF7-623E-480F-B371-6ADD83FA2EBC(a)microsoft.com...
> >> Hi I have an issue with a field [priceeuros] that reports out as a sinle
> >> interger, no commas, can someone help please
> >> This is the second page of the DBRW I am experimenting with, but there is
> >> a
> >> syntax problem
> >> SELECT * FROM Apmt1bed,
> >> format([priceeuros],'Currency') as fmtamount,
> >> ORDER BY PriceEuros ASC
> >>
> >> I have 1234567 and want 1,234,567
> >>
> >> thank you for your help
> >>
> >>
> >> .
> >>
>
>
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Front Page 2003 Registry Keys Reg Edit
Next: SOLVED can't associate FrontPage with htm and html files