Forum Moderators: open
<tr>
<td>
Event Byline:</td>
<td> <input type="text" name="remarks"></td>
<td> </td>
</tr>
<tr>
<td>Full Description:</td>
<td><textarea name="knowledge" cols="23" rows="5"></textarea></td>
<td> </td>
</tr>
<tr>
<td>DVDs Available:</td>
<td><input type="text" name="dvdAvail"></td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Submit a New Production"></td>
<td> </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> </td>
<td> </td>
</tr>
<tr>
<td> </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
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.
<%
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")
%>
