Well, this is not River City but I do have a problem.

Given:

Operating System: Windows NT 4.0
Development tool: Visual Studio 6.0
ADO 2.6
ASP 2.0
Backend SQL Server 7.0

Statement
Using I.E. 5.0 the representative code below functions correctly.

Problem
Using I.E. 5.5 or 6.0 with the latest service packs, when the cmdSave button is selected the end result is all data is deleted from the record. The record is not deleted. This is not desirable behavior. Is there a way to resolve this problem?

Thank you in advance.

Data Entry form

<form method=”post” name=”frmTallyDetail” > 

<label style="HEIGHT: 20px; 
		LEFT: 5px; 
		POSITION: absolute; 
		TOP: 215px; 
		WIDTH: 150px" 
		id=”lblComments”>
	Comments: 
</label>

<input style="HEIGHT: 20px; 
		LEFT: 90px; 
		POSITION: absolute; 
		TOP: 215px; 
		WIDTH: 315px;
		FONT-SIZE: 9pt;" 
		id=”txtComments1”
		name=”txtComments1”
		value="<%=trim(oRS("Comments1"))%>"
		readonly
		maxlength="<%=oRS.fields("Comments1").definedsize%>">

<INPUT  id=”cmdSave” name=”cmdSave” type=”button” value="  Save  "
		style="position:absolute;
		left:100;
		top:275;”>

</form>

<script Language=vbScript>

Sub cmdSave_OnClick()

frmLineDetail.Submit()	
location.href = "LCResponseE.asp?pid=" & sEditID

End Sub

</script>

Data Save Form

<%

Dim sComment1
sComment1 = Request.Form("txtComments1”)


Dim projid
projid = Request.QueryString("pid") 
Dim oTallyRS

Set oRS = Server.CreateObject("ADODB.Recordset")
oRS.Open "Select * from Tally where TallyPK = '" & projid & "'",strConn,3,3

oRS("Comment1") = sComment1

oRS.Update

%>

Tom