Dummy ASP Problem, but no help on web?

[mcchristie]

hi all,

i've never used ASP before, but am proficient with html / css

all i want to do is add a feedback form to a site. i have the form all set up as follows:

[html]
<form method="post" action="confirm .asp">
<table class="register ">
<tr>
<td class="label">F ull Name:</td>
<td class="data"><i nput type="text" name="name" /></td>
</tr>
<tr>
<td class="label">E-mail address:</td>
<td><input type="text" name="email" /></td>
</tr>
<tr>
<td class="label">C ontact Number:</td>
<td><input type="text" name="number" /></td>
</tr>
<tr>
<td class="label">P ostcode</td>
<td><input type="text" name="postcode" /></td>
</tr>
</table>
<p>Further Information: </p>
<p><textarea name="comments" rows="5" cols="70">Pleas e leave your comments here - we will respond as quickly as possible.</textarea></p>
<p> <input type="submit" name="submit" value="Submit Contact Form" />
</p>
</form>
[/html]

simple eh?

however, i can't for the life of me get this into the database using ASP!

at the start of all my ASP pages i have:

<%
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.Recordset")
objConn.Provider = "Microsoft.Jet.OLEDB.4.0"
objConn.Open "\\localhost/isproject/group_03.mdb"
%>
 

but i'm TOTALLY stuck as to how to start the ASP on confirm.asp

so far i have:

<% 
obj.RS Open "contact", obj.Conn %>
<% objRS.AddNew
objRS("name") = Request.Form("name")
objRS("email") = Request.Form("email")
objRS("number") = Request.Form("number")
objRS("postcode") = Request.Form("postcode")
objRS("comments") = Request.Form("comments")
objRS("datecontacted") = Date()
objRS.Update
%>
 

but it doesn't like the first line at all - what am i doing wrong here?

all the things i've seen on the web talk about defining DSNs and connections and so forth... i don't want any of that, i just want to connect to the database and add some records!

i should add - i have the database table "contact" set up already with the fields.... i just can't seem to enter data into it

can anyone help ??

Cheers
McChristie

[jhardman]

hi all,

...

<% 
obj.RS Open "contact", obj.Conn %>
 
%>
 

...

don't you mean:

<%
objRS.Open "contact", objConn %>
 

anyway, you can open the db to read but not write? please confirm.

[mcchristie]

that's correct, yes.

for whatever reason, i simply can't open the database to edit it. i get errors to do with that line, such as:

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/isproject/confirm.asp, line 74

OR

Type mismatch.

with an error "type mismatch", here's the code i have:

<% 
objRS.Open "contact", adLockOptimistic, objConn
 
objRS.AddNew 
objRS("name") = Request.Form("name")
objRS("email") = Request.Form("email")
objRS("number") = Request.Form("number")
objRS("postcode") = Request.Form("postcode")
objRS("comments") = Request.Form("comments")
objRS("datecontacted") = Date()
objRS.Update
%>
 

i simply don't understand why... i think i'm saying, "open the contact table, allow it to be edited, using the connection...

then add new record sets according to the values from the form"

[jhardman]

If your code is as stated above, you might just have arguments out of order.

objRS.Open "contact", objConn, adOpenDynamic, adLockOptimistic
 

Also, throw in the constant "adOpenDynamic" . This just means that you can scroll through the records in multiple directions, but it seems to me that some systems need this as well in order to modify records.

Jared