Wrox Programmer Forums
|
ASP Pro Code Clinic As of Oct 5, 2005, this forum is now locked. No posts have been deleted. Please use "Classic ASP Professional" at: http://p2p.wrox.com/forum.asp?FORUM_ID=56 for discussions similar to the old ASP Pro Code Clinic or one of the other many remaining ASP and ASP.NET forums here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP Pro Code Clinic section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 24th, 2004, 05:30 AM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default urgent problem

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............
 
Old June 24th, 2004, 05:41 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
 
Old June 24th, 2004, 05:48 AM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 :)
 
Old June 24th, 2004, 05:54 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote: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???
May be I am not understanding this part. Can you explain on that?

_________________________
-Vijay G
Strive for Perfection
 
Old June 24th, 2004, 06:05 AM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?
 
Old June 24th, 2004, 06:40 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Tabpanel problem (Urgent) NEO1976 Java GUI 0 January 20th, 2008 06:24 PM
filesystemwatcher problem (very urgent) shailendra_shail Visual Studio 2005 1 June 29th, 2007 03:56 AM
database problem[urgent] sunanda_chowdary Servlets 0 February 21st, 2006 03:50 AM
Problem with Codebehind - urgent sunny76 ASP.NET 2.0 Basics 1 February 17th, 2006 09:18 AM
Inner Join problem: Urgent DB Access ASP 1 April 30th, 2004 03:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.