Write back to Access memo field

[andersfr]

Hi. I have not managed to find out what the problem is.
I am trying to update a memofield from a form.
My file.. sign_midi.asp has this partial code.

First I pick up the record I want to update.
And then present it in a form.
"
<tr>
<td align="right" height=10 valign="top"><b>Beskrivning :</b></td>
<td align="left" height=10 valign="top" width=250><TEXTAREA WRAP="soft" name="M1" cols="65" rows="8"><% = rs("text")%></TEXTAREA></td>
</tr>

And then I want to save the new input.

sql_updat = "UPDATE PRODUCTS SET text='"& beskrivning &"' WHERE code_no='"& artikelnummer &"'"
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
con.Execute sql_updat

Please have someone got an answer that could help me? All the other fields are working fine, if I exclude the memo field.

Anders

 

[MarkK]

You haven't said what error you are getting, but "text" in Jet SQL is a data type, probably a reserved word, so try amending your SQL as follows . . .

sql_updat = "UPDATE PRODUCTS SET [COLOR="Red"][text][/COLOR]='"& beskrivning &"' WHERE code_no='"& artikelnummer &"'"

. . . so put square brackets around the word "text".

 

[andersfr]

You haven't said what error you are getting, but "text" in Jet SQL is a data type, probably a reserved word, so try amending your SQL as follows . . .

sql_updat = "UPDATE PRODUCTS SET [COLOR=Red][text][/COLOR]='"& beskrivning &"' WHERE code_no='"& artikelnummer &"'"

. . . so put square brackets around the word "text".

AND that worked soooooo good. Perfect, it's hard to tell how happy I am. Many thanks to Mark...