Help with Access/Frontpage

[Guest]

I have a database in Access that I am feeding to my website via the Database
Wizard in Frontpage. I am using Access 2003 and Frontpage 2003.

I have a field in an Access database that represents an address. The address
is in the database in one field as:

1234 Stillwater Rd Stamford, CT 06904 (999) 111-2222

When it gets to the web site I want it to display as

1234 Stillwater Rd
Stamford, CT 06904
(999) 111-2222

I have tried to put chr(13) and chr(10) after each line to indicate a break
as follows:

"1234 Stillwater Rd" & chr(13) & chr(10)

That doesn't work.

I have tried to put a <p> and a </p> at the beginning and end of each line
break. That doesn't work. The website simply shows <p>1234 Stillwater Rd</p>

I would sincerely appreciate any guidance on what character(s) to put within
the field to force a carriage return/line feed when the field gets over to
Frontpage.

Thanks in advance.

 

[Alex Dybenko]

Hi,
in order to add a new line - you can use <br>
then look at asp code wizard generated - perhaps it added HTMLEncode
method - then all html tags will be ignored

 

[Peter R. Fletcher]

Redesign your database!!

Any solution for parsing the mishmash of disparate data you have put
in the single "address" field for display will predictably fail
eventually, almost certainly at the worst possible time. You need to
separate out (at least), Street Address, Town, State, Zip, and Phone.
Once everything is normalised in the database, displaying it how you
want to see it should be trivial.

I have a database in Access that I am feeding to my website via the Database
Wizard in Frontpage. I am using Access 2003 and Frontpage 2003.

I have a field in an Access database that represents an address. The address
is in the database in one field as:

1234 Stillwater Rd Stamford, CT 06904 (999) 111-2222

When it gets to the web site I want it to display as

1234 Stillwater Rd
Stamford, CT 06904
(999) 111-2222

I have tried to put chr(13) and chr(10) after each line to indicate a break
as follows:

"1234 Stillwater Rd" & chr(13) & chr(10)

That doesn't work.

I have tried to put a <p> and a </p> at the beginning and end of each line
break. That doesn't work. The website simply shows <p>1234 Stillwater Rd</p>

I would sincerely appreciate any guidance on what character(s) to put within
the field to force a carriage return/line feed when the field gets over to
Frontpage.

Thanks in advance.

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Guest]

The data is already contained in separate fields. I combine it into one field
with a query. The purpose is to eliminate blank lines on the page if, for
instance, I don't have any address information. Otherwise the web page might
look like....


ABC
232 Wiget Lane
WC, CA 94598

DEF

WC, CA 94598


232 Wiget Lane
WC, CA 94598

If you know of a better way to eliminate the blank lines that might occur I
would appreciate hearing it.

 

[Guest]

I'll give this a try this afternoon. But it's my belief that <br> will print
out in the cell as text.

 

[Alex Dybenko]

Then look at output procedure - perhaps HTMLEncode used there.

 

[Tim Ferguson]

If you know of a better way to eliminate the blank lines that might
occur I would appreciate hearing it.

If Len(rs!MyField) > 0 Then
OutputField(rs!MyField)

Else
' dont'

End If

Hope that helps


Tim F