ASP/ADODB - Memo fields and richtext format

[Jahren]

Hi! i'm new here.
this place looks nice so i would like to try my luck here!

I've a question :
How can I insert multiline richtext into MSACCESS database?
at first I thought I could store it into a memo field, but it seems that i'm doing something wrong since it's crashing with the exception : INSERT INTO sql syntax is invalid.

(The DB, tables and fields name were double-checked)

Here's the dreaded code :

Set con = Server.CreateObject("ADODB.Connection")
 
        con.Open logins
 
        msg_id = 1 'for testing purpose only
 
        SQL_query = "INSERT INTO msg_inbox VALUES(" & msg_id & ", '" & request("destinataire") & "', '" & Session("username") & "', '" & date() & "', '" & request("message") & "'"
 
        Set RS = Server.CreateObject("ADODB.Recordset")
 
        RS.Open SQL_query, con, 0, 3
 

-=-=-=-=-
In the SQL query :
values -> msg_id, as the message id (Daahh) numeric value
request("destinataire") as a string
Session("username") as string
Date() as string (didn't want to bother with formatting)
request("message") as MEMO in ACCESS and as textarea in HTML

thanks for your help guys!
rs.Close()
con.Close()

[MMcCarthy]

You forgot the closing bracket on your insert statement.

        SQL_query = "INSERT INTO msg_inbox VALUES (" & msg_id & ", '" & request("destinataire") & "', '" & Session("username") & "', '" & date() & "', '" & request("message") & "')" 
 

[Jahren]

god... How can I be so dumb lol
i'll try and retrieve the data FROM the DB now and see what happens

[MMcCarthy]

god... How can I be so dumb lol
i'll try and retrieve the data FROM the DB now and see what happens

LOL!

We've all been caught. Its very easy to notice it in someone elses code but difficult to see in your own.

[Jahren]

read works llike a charm.
My new internal PM system is up and running, thanks alot

[MMcCarthy]

read works llike a charm.
My new internal PM system is up and running, thanks alot

You're welcome!