Dreamweaver - Problems writing to memo fields

Author

Problems writing to memo fields

joe ruggeri

2004-04-28, 10:30 pm

Using: DWMX, Win2k, ASP/VBscript, Access 200 db

I have a rather complex insert query, stored in a DW command, that reads data
from one table (let's call it "Table A"), presents it in a form for editing, and
upon submission, inserts this data into a new table, "Table B". The reason it's
in a command is that I needed to update a single field in "Table B" from the
same form at the same time. So I have two commands being executed from the same
form submission.

I actually got this to work, sort of ...

Among the 20-plus fields being read and then (supposedly) inserted are 10 memo
fields from Table A; their counterparts in Table B are also memo fields.

When I do the submit, however, only the data in the text fields, is carried over
to Table B None of the memo fields are inserted in the new record in Table B.

Any ideas why? I'm stumped.

- jr

-----------------------------------------------------
joe ruggeri
web designer
JFmedia newport, ri
www.jfmedia.com
-----------------------------------------------------

Daniel Short

2004-04-29, 4:29 am

Hi Joe,

I've had occassion to reuse memo fields, and if you pull them out of the
database, and want to do any manipulation, you need to ensure that you store
them in a variable before doing that manipulation. I can't remember what
driver it is, but basically you can only make a call to the memo field
recordset object once.

So basically, assign your memo field to a variable, and then do whatever you
need through that variable. This would fail:

<% If rs("memo") <> "" Then
Response.write(rs("memo"))
End If %>

This would not:

<%
Dim myVar : myVar = rs("memo")
If myVar <> "" Then
Response.write myVar
End If
%>

Hope that does the trick.

--
:: Dan Short :: Take out the witty remark to reply.
Cartweaver: http://www.cartweaver.com/
Bloggin': http://blog.web-shorts.com/
Get it at da store: http://www.dwfaq.com/store/
Team Macromedia DW Volunteer: http://www.macromedia.com/go/team
Design: http://www.web-shorts.com
"joe ruggeri" <joerugg@nospam.cox.net> wrote in message
news:c6pkhg$2u7$1@forums.macromedia.com...
> Using: DWMX, Win2k, ASP/VBscript, Access 200 db
>
> I have a rather complex insert query, stored in a DW command, that reads
data
> from one table (let's call it "Table A"), presents it in a form for
editing, and
> upon submission, inserts this data into a new table, "Table B". The reason
it's
> in a command is that I needed to update a single field in "Table B" from
the
> same form at the same time. So I have two commands being executed from the
same
> form submission.
>
> I actually got this to work, sort of ...
>
> Among the 20-plus fields being read and then (supposedly) inserted are 10
memo
> fields from Table A; their counterparts in Table B are also memo fields.
>
> When I do the submit, however, only the data in the text fields, is
carried over
> to Table B None of the memo fields are inserted in the new record in Table
B.
>
> Any ideas why? I'm stumped.
>
> - jr
>
> -----------------------------------------------------
> joe ruggeri
> web designer
> JFmedia newport, ri
> www.jfmedia.com
> -----------------------------------------------------
>
>