<br> mysteriously appears in custom query

A

Augie Dawg

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.
 
J

Jim Buyens

-----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?
Click to expand...

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)
|/---------------------------------------------------
*----------------------------------------------------
 
A

Augie Dawg

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.
 
J

Jim Buyens

-----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.
Click to expand...

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

Character Characters
In Data Send to Browser
< &lt;
&gt;
Click to expand...
" &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)
|/---------------------------------------------------
*----------------------------------------------------
 
Top