FP2002 has the annoying habit of changing all occurances of a carriage
return to "<br>" whenever I use a literal in the query, e.g. SELECT
FirstName & ' ' & LastName AS Name. Is there any way to get around this
behavior?

Thanks,
A.D.

>-----Original Message-----
>FP2002 has the annoying habit of changing all occurances
>of a carriage return to "<br>" whenever I use a literal
>in the query, e.g. SELECT FirstName & ' ' & LastName AS
>Name. Is there any way to get around this behavior?

This is typical in the northern states this time of year,
especially when the query goes outside without an overcoat.

Seriously, try this:

1. Right-click the column value in the finished
Database Results Region
2. Choose Database Column Value Properties from
the shortcut menu.
3. Select the Column Value Contains HTML checkbox.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

Thanks, that worked! To be honest, I really thought you misread my
question, because I saw no relationship between my problem and your
solution. I'd be very interested in knowing what was happening to cause the
substitutions of "<br>", and how your suggestion fixed it.

Regards,
A.D.



"Jim Buyens" <(E-Mail Removed)> wrote in message
news:0d7401c3d936$ff8985d0$(E-Mail Removed)...
> >-----Original Message-----
> >FP2002 has the annoying habit of changing all occurances
> >of a carriage return to "<br>" whenever I use a literal
> >in the query, e.g. SELECT FirstName & ' ' & LastName AS
> >Name. Is there any way to get around this behavior?
>
> This is typical in the northern states this time of year,
> especially when the query goes outside without an overcoat.
>
> Seriously, try this:
>
> 1. Right-click the column value in the finished
> Database Results Region
> 2. Choose Database Column Value Properties from
> the shortcut menu.
> 3. Select the Column Value Contains HTML checkbox.
>
> Jim Buyens
> Microsoft FrontPage MVP
> http://www.interlacken.com
> Author of:
> *----------------------------------------------------
> |\---------------------------------------------------
> || Microsoft Office FrontPage 2003 Inside Out
> ||---------------------------------------------------
> || Web Database Development Step by Step .NET Edition
> || Microsoft FrontPage Version 2002 Inside Out
> || Faster Smarter Beginning Programming
> || (All from Microsoft Press)
> |/---------------------------------------------------
> *----------------------------------------------------
>

>-----Original Message-----
>Thanks, that worked! To be honest, I really thought you
>misread my question, because I saw no relationship
>between my problem and your solution. I'd be very
>interested in knowing what was happening to cause the
>substitutions of "<br>", and how your suggestion
>fixed it.

When displaying database results, FrontPage creates code
that translates characters like:

Character Characters
In Data Send to Browser
< &lt;
> &gt;
" &quot;

This is so the browser doesn't try to interpret the data
as HTML. Well, the same translation changes carriage
returns to their HTML equivalent: <br>.

Spooky, eh?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------