asp dynamic new/edit page

[tuneman202002]

I have a new form page and an edit page
Here is the way I coded my form for my new page:

<tr>
<td>
Event Byline:</td>
<td> <input type="text" name="remarks"></td>
<td>&nbsp</td>
</tr>

<tr>
<td>Full Description:</td>
<td><textarea name="knowledge" cols="23" rows="5"></textarea></td>
<td>&nbsp</td>
</tr>
<tr>

<td>DVDs Available:</td>
<td><input type="text" name="dvdAvail"></td>
<td>&nbsp</td>
</tr>

</table>
</td>
</tr>

<tr>
<td></td>
<td><input type="submit" value="Submit a New Production"></td>
<td>&nbsp</td>
</tr>

And here's the same section on the edit page:

<tr>
<td>Full Description:</td>
<td><textarea name="knowledge" cols="23" rows="5"><%=knowledge%></textarea></td>
</tr>
<tr>

<td>DVDs Available:</td>
<td><input type="text" name="dvdAvail" value="<%=dvdAvail%>"></td>
</tr>

<tr>
<tr>
<tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="hidden" name="EID" value="<%=EID%>" />
<input type="submit" value="Save User Changes" /></td>
</tr>
</table>

Here's the problem when it put information into the text area "knowledge" on the new form it doesn't save the information, but when I put it in on the edit form it is saved.

Any help would be appreciated.

Thank you

[mattur]

Your code snippets show the display of the form, but not how the form is processed(!)

To debug any ASP problem like this use response.write() to display inputs, variables etc.

It seems your add new record code is either not picking up the "knowledge" input, or your SQL does not correctly include the input. Response.write them out so you can see what is happening.

Post a snippet of the database update code if you're still having problems.

BTW: you seems to be mixing HTML and XHTML syntax on the same page. Choose one (the one defined by your doctype!) and stick to it.

[tuneman202002]

This is my processing script

<%
Dim sql, rs
'Set up connection to the DSN, which will talk to the database

sql="select * from events where EID=" & request.form("EID")
set rs=server.createobject("adodb.recordset")
rs.cursortype=3
rs.locktype=3
rs.Open sql, Conn
rs("production")=request.form("production")
rs("startDate")=request.form("startDate")
rs("endDate")=request.form("endDate")
rs("companyName")=request.form("companyName")
rs("curtainTime")=request.form("curtainTime")
rs("playwrightFirstName")=request.form("playwrightFirstName")
rs("playwrightLastName")=request.form("playwrightLastName")
rs("stage")=request.form("stage")
rs("remarks")=request.form("remarks")
rs("knowledge")=request.form("knowledge")
rs("dvdAvail")=request.form("dvdAvail")

rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect("prodmaster.asp")
%>

[mattur]

You need to use rs.AddNew (or SQL) to add a new record.