DaniWeb IT Discussion Community - Unable to insert form data into a database

Hey all,

Heres the code of an ASP I'm working on...

------------------------------------begin ASP-------------------------------------

<%@ Language=VBScript%>
<%
artist=Request("artist")
album=Request("album")

Set con1 = server.CreateObject ("ADODB.Connection")
Set rs1 = server.CreateObject ("ADODB.Recordset")

con1.Provider="Microsoft.Jet.OLEDB.4.0"
con1.Open (server.MapPath ("\databasecore\mediaguide.mdb"))

sql = "UPDATE artistinfo SET UserAlbumReview='"&TRIM(Request.Form("AlbumReview"))&"' where artist ='"&artist&"' and album =

'"&album&"'"
rs1.Open sql,con1
%>

<html>

<head>
<title>Add Album Review</title>
<meta name="Microsoft Theme" content="profile 111, default">
</head>

<body>
<form name=review method="POST" action="review.asp?done=1">
<p align="center">
<textarea rows="8" name="AlbumReview" cols="31"></textarea></p>
<p align="center">
 <input type="submit" value="Submit"><input type="reset" value="Reset"></p>
</form>
 </body></html>

--------------------------------------------end ASP---------------------------------

What I want is that when a user enters text in the textarea, the same should be inserted in the field named UserAlbumReview

in the database. However, this isnt happening. Nothing is inserted in the database. However, if I bubstitue a phrase in the

SQL query instead of the Request.Form statement, the string is inserted properly.ie, if I change the SQL query to

sql = "UPDATE artistinfo SET UserAlbumReview='Test Review' where artist ='"&artist&"' and album = '"&album&"'"

then the phrase "Test Review" is inserted in the database. The values for artist and album are passed as parameters. Can any of you guys please help me? Thanks in advance.