Hi
I have been trying to post from a form to a SQL dab=tabase for a couple of
hours. I've done it before, but i must be having memory problems.
I have 2 files, one with a form, and one to do the INSERTing.
These two files are below (only small as they are only test) - can you see
what's wrong with them?
Thanks
Phil
items.asp (the form)
--------
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>itemName</title>
</head>
<body>
<p> </p>
<p> </p>
<form method="POST" action="writeitems.asp">
<table border="1" width="100%" id="table1">
<tr>
<td>itemName</td>
<td><input type="text" name="fld_itemName" size="25"></td>
</tr>
<tr>
<td>itemDescription</td>
<td><input type="text" name="fld_itemDescription" size="50"></td>
</tr>
</table>
<p> </p>
<p><input type="submit" value="Submit" name="B1"><input type="reset"
value="Reset" name="B2"></p>
</form>
</body>
</html>
writeitems.asp (to write the database)
--------------
<%
Dim Connect5
Dim LogFileQuery
Dim strConn
Dim LogFileAction
Dim sstrIPAddress
Dim sstrReferer
Dim sstrPlatform
Dim myConnection As SqlConnection
'Set Connect5 = Server.CreateObject("ADODB.Connection")
myConnection = New SqlConnection("Data Source=server;" _
& "Database=database;" _
& "User Id=username;Password=password;")
MyConnection.Open
LogFileQuery = "INSERT into tbl_house_items(id, fld_itemName,
fld_itemDescription) VALUES (NULL, '"& Request.Form("fld_itemName") & "','"&
Request.Form("fld_itemDescription") & "')"
Set LogFileAction = Connect5.Execute(LogFileQuery)
' Close database connection and dispose of the object
set sstrPage = Nothing
set sstrIPAddress = Nothing
set sstrReferer = Nothing
set sstrPlatform = Nothing
set strConn = Nothing
Set LogFileAction=Nothing
set Connect5 = Nothing
%>
