ASP & Access

[phillip6653]

I am trying to take a access database that has a memo field and populate a text
box on my site with the information in access. I know how to do this normaly
but I think the memo field in access is causing the problem. Is there anyway to
have a field in access that can hold more than 255 caractors and be able to
display it dynamicly on my web page. Please help

Terrence McCLeary

[hedem]

Dear,

Define your field name in access as data type = Memo.
To display the text dynamically you can preformatted the text between the
tag <pre></pre>.
When you enter several lines in the memo field in access, this translates
exactly the same to your asp file.
By the way you can also using the most asp tag codes in your field name
(example <br>, <b>, <font>, etc...)

Kind regards,
hedem


"phillip6653" <webforumsuser@macromedia.com> schreef in bericht
news:dcopa7$hqa$1@forums.macromedia.com...

>I am trying to take a access database that has a memo field and populate a
>text
> box on my site with the information in access. I know how to do this
> normaly
> but I think the memo field in access is causing the problem. Is there
> anyway to
> have a field in access that can hold more than 255 caractors and be able
> to
> display it dynamicly on my web page. Please help
>
> Terrence McCLeary
>

[Singularity.co.uk]

Phillip

There is a problem when displaying information from an Access database Memo
field, in that in your SQL code you have to call the Memo field last or it
wont display.

Brendan

"phillip6653" <webforumsuser@macromedia.com> wrote in message
news:dcopa7$hqa$1@forums.macromedia.com...

> I am trying to take a access database that has a memo field and populate a

text

> box on my site with the information in access. I know how to do this

normaly

> but I think the memo field in access is causing the problem. Is there

anyway to

> have a field in access that can hold more than 255 caractors and be able

to

> display it dynamicly on my web page. Please help
>
> Terrence McCLeary
>

[phillip6653]

How do you make sure that the memo Sql code is being called last. I don't know alot about the code.

[Singularity.co.uk]

When your selecting your fields to be included in a recordset, select the
one that is a memo field last.


"phillip6653" <webforumsuser@macromedia.com> wrote in message
news:dcr3jb$6mj$1@forums.macromedia.com...

> How do you make sure that the memo Sql code is being called last. I don't

know alot about the code.

[phillip6653]

Here is the new problem that I found. You can't put a memo field in a multi-line textbox. Do you know the solution to that?

[phillip6653]

Thank you for all of your help. I did get it to work if I used the record update form from the insert menu.

Thanks again

[hedem]

Hello,

You don't need to put the memo field in a multi-line textbox.
Maybe you can try this
<pre><%=(rsMemo.Fields.Item("txtMemo").Value)%></pre>.
or when want it in a box:
<table>
<tr>
<td><pre><%=(rsMemo.Fields.Item("txtMemo").Value)% ></pre></td>
</tr>
</table>

Kind regards
Hedem

"phillip6653" <webforumsuser@macromedia.com> schreef in bericht
news:dct891$ena$1@forums.macromedia.com...

> Thank you for all of your help. I did get it to work if I used the record
> update form from the insert menu.
>
> Thanks again

[Singularity.co.uk]

Phillip

You should have no problem placing text from a memo field into a multi-line
textbox.

Are you getting an error, or is it that the data won't display?

Brendan


"phillip6653" <webforumsuser@macromedia.com> wrote in message
news:dct7hs$dii$1@forums.macromedia.com...

> Here is the new problem that I found. You can't put a memo field in a

multi-line textbox. Do you know the solution to that?