Http Header....argh, Help Help pls... ?

vanjamier · December 23rd, 2004, 11:08 PM

Hello i dun understand why it doesnt work...

[code]
<form name="form1" action="" method="post" LANGUAGE=javascript onsubmit="return form1_onsubmit()">
</CENTER>

<%
on error goto 0
Set rs = Server.CreateObject("ADODB.RecordSet")

'QueryStrings
strId = Request.QueryString("ID")

'get the selected software info
sqlstr = "SELECT " & _
        " Filename,Filesize,FileType,SwName,SwVersion,SwComp any,LicenseNumber" & _
        " ,LicenseDate,LicenseEndDate,LicenseAmount,siasid,O wnername,Owneremail" & _
        " from LicenseTab where id = '" & strID & "' "

rs.Open sqlstr, connStr

        owname = Request.Form("txtname")
          owemail = Request.Form("txtemail")
          softname = Request.Form("txtswname")
          softver = Request.Form("txtswver")
          company = Request.Form("txtcom")
          number = Request.Form("txtnum")
          serial = Request.Form("txtserial")
          date1 = Request.Form("txtdate")
          date2 = Request.Form("txtldate")

          If Request.Form("btnEdit") = "Update" Then

          Set rs2 = Server.CreateObject("ADODB.RecordSet")

              'update record
              sqlstr2 = "Update LicenseTab set" _
                      & " Ownername = '" & owname & "', " _
                      & " Owneremail = '" & owemail & "', " _
                     & " SwName = '" & softname & "', " _
                      & " SwVersion = '" & softver & "', " _
                      & " SwCompany = '" & company & "', " _
                      & " LicenseAmount = '" & number & "', " _
                      & " LicenseNumber = '" & serial & "', " _
                      & " LicenseDate = '" & date1 & "', " _
                      & " LicenseEndDate = '" & date2 & "' " _
                       & " Where id = '" & strID & "'"

               rs2.Open sqlstr2, connStr

               Response.Buffer = True
            Response.Clear
            Response.Redirect("updated.htm")
                Response.End
        End If
%>

CAN SOMEONE PLEASE HELP... ???

om_prakash · December 24th, 2004, 12:43 AM

Please also check for following:

1. Are u getting data in the first recordset?
2. Instead of opening second recordset, you can use connStr.execute (where connStr is connection object).

Om Prakash

vanjamier · December 24th, 2004, 01:31 AM

Response object error 'ASP 0156 : 80004005'
Header Error

/itls/slid/license_mod.asp, line 85

The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.

This is the error im getting

I tried ur suggestions but still get the same error...
Anyway yesh, im getting data from the first recordset

om_prakash · December 24th, 2004, 04:46 AM

Please remove the following code:

Response.Buffer = True
Response.Clear

Om Prakash

Imar · December 24th, 2004, 04:59 AM

Hi there,

Take a look at this thread: http://p2p.wrox.com/topic.asp?TOPIC_ID=1797

I think in your code you're turning on buffering too late; You have already sent the <form> tag etc to the browser, so you can no longer turn on buffering at that point.

If I were you, I'd move all the ASP code to the top of the page, before the <html> and other tags.

Cheers and a Merry Christmas everyone,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Vadivel · December 24th, 2004, 02:35 PM

oh yeah Imar is right. You are turning on the buffer too late in your code. I guess it might work when you put the response.buffer = true above the html tag!

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

muralinagasuri · January 12th, 2005, 01:02 AM

hai,

i think we cannot use on error goto x in asp.

bye.

Imar · January 12th, 2005, 02:53 PM

On Error Goto 0 works fine in ASP; it resets the effects of On Error Resume Next.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Hey by Pixies (Track 13 from the album: Doolittle) What's This?