ok
i am facing this strange problem.....

i have developed this data-entry software with the provision for report generation as well. MS-SQL Server back end & ASP 3.0 front-end

now i am generating a form_id for every 'form' (the basic entity in my software)
& then showing a confirmation page that displays all the datails of the form being submitted. following is the code:-

RS.Open "Select * from FORM1",Conn,_
adOpenKeyset,adLockOptimistic

cat=session("CAT")
pqr=session("form_id")

form= variable & "/" & pqr

RS4.Open "select * from agency where agency='"& agency_name & "'",conn

RS.ADDNEW
RS("form_no")= form
RS("date_case")= now
RS("acc_no")=request.form("ACCOUNT_NUMBER")
RS("mdn_no")=request.form("MDN_NUMBER")
RS("due_amt")= request.form("DUE_AMT")
RS("paid_amt")= request.form("PAID_AMT")
RS("behavior")=request.Form("A")
RS("capacity")= request.Form("B")
RS("ownership")= request.Form("C1")
RS("place")= request.Form("C2")
RS("status")= request.Form("D")
RS("agency_reco")= Request.Form("AGENCY_RECOMMENDATIONS")
RS("case_closure_date")=Request.Form("case_closure _date")
RS("risk_category")= RS1("case_category")
RS("case_desc_code")=RS1("case_desc_code")
RS("case_desc")= RS1("case_desc")
RS("agency_name")=request.Form("AGENCY_NAME")
RS("RIC_coordinator")=request.Form("AGENCY_COORDIN ATOR")
RS("zonal_head")=rs4("zonal_head")

RS.Update




there are 22 cases for 'case_desc_code' out of which 8 can be categorised together
after the RS.update, the page is being redirected to a "done.asp" wherein all the columns are being displayed.


my problem starts here.....
every time 1 of the 8 'case_desc_code' values is selected, a static page with a different form_id is displayed. the values in the database are being passed correctly. but it is being displayed in internet explorer as a static page. also, out of the 22 'case_desc_code' options, only 8 case codes give this problem............is it a cache problem (although we have cleared the cache & cookies etc) or
something else???

all help will be greatly appreciated ...........this software is working on live-data & this problem has cropped-up only 2 days ago......it was working fine before that......i have to fix it really soon............

Can you post the code that you use for selecting any of those 8 case_desc_code and displaying them? I hope the problem should be there.

Cheers!

_________________________
-Vijay G
Strive for Perfection

those 8 options are just values of a group of radio buttons

request.Form("R1")

i dont think it lies there vijay, cos the software was working fine till day before........

think of something else :)

May be I am not understanding this part. Can you explain on that?

_________________________
-Vijay G
Strive for Perfection

ok, i'll try that!

now, there 8 options in the S category, 8 in T & 6 in U..........clear till here?
now when when a user selects an S4 case (a case_code in the S category) & hits the submit button, instead of teh form_id being displayed as S4/1236, it is displaying T3/16888, which was a T3 case ( in the T category). in the backend however, the form_id being reflected as S4/1236 which is the right form_id, but displays a wrong id in the front end. so this problem is arising only for S1, S2, S3, S4, S5, S6, S7, S8 cases. is the picture any clearer?

Yes, I can understand that now. But without having atleast a glimpse at the code, I am not in a position to suggest you on that. As you say it was working fine till a couple days back, only thing I can think off is the data should have got altered so that it gets the wrong values. But this is a guess, I dont think guesses can get you a solution to this.:)

Cheers!

_________________________
-Vijay G
Strive for Perfection