2. ASPRunnerPro General questions
  3. Difference in Dependant Drop Downs 3.2 - 4B
This topic is locked

Difference in Dependant Drop Downs 3.2 - 4B

 		1/13/2006 4:23:30 PM
ASPRunnerPro General questions
C
 clig author

I have a column [SYS Type] and a column [Project] for example.
[Project] is dependant on [SYS Type] - This works in 3.2 when you select a [SYS Type] the dropdown list for [Project] is appropriately populated even at nearly 40,000 records...
Edit the project with the latest build (79) and any prior to that the form looks the same however the dependancy is lost on the published pages... Templates are all defaults from installation - The only custom code during this testing has been a quick grab of some vars defined in *aspfunctions.asp:
Dim strUserID

strUserID = Request.ServerVariables("AUTH_USER")

strUserID = Mid(strUserID,(instr(1,strUserID,"\")+1),len(strUserID))

Dim strUserDate

strUserDate = cstr(Now())

Dim strUserMod

strUserMod = strUserID & " " & strUserDate

Dim strStartTime

strStartTime = Now()

  • The primary drop list works [SYS Type] - the dependant list is empty [Project]
  • Spaces in the name are not an issue as I've tested with a columns with no spaces
  • Is this by design or am I missing something?
    thanks for your time
Sergey Kornilov admin 1/13/2006

Does it work when you click "Test it" button in ASPRunnerPro?
You can zip and send me your project file, generated ASP files and script that creates database tables for investigation.
C
 		clig author 1/13/2006

Does it work when you click "Test it" button in ASPRunnerPro?

You can zip and send me your project file, generated ASP files and script that creates database tables for investigation.


Yes it does work when I click "Test it"
The backend is SQL Server 2000 there are no scripts to create tables - files are based only on existing tables and views...
Files coming...
Thanks!
C
 		clig author 1/13/2006

Does it work when you click "Test it" button in ASPRunnerPro?

You can zip and send me your project file, generated ASP files and script that creates database tables for investigation.


Files sent - If you need a db I can detach and send a smaller version of it... The original is about a gig.
Sergey Kornilov admin 1/14/2006

I cannot test it without your database. Please send me smaller version of deatched database or SQL script that creates tables in database.
C
 		clig author 1/14/2006

I cannot test it without your database. Please send me smaller version of deatched database or SQL script that creates tables in database.


Will do when I get to the office
Thanks!
C
 		clig author 1/19/2006

Found the problem - in 3.2 It did not care about nulls in any of the fields in a drop down that is dependant on another...
In 4B - this errors out with:
Microsoft VBScript runtime (0x800A005E)

Invalid use of Null: 'Replace'

/ASPRunnerPro/include/commonfunctions.asp, line 284
on IIS 5.1
and
Line 68

Char 1

Error 'arr_Project' is undefined

Code 0
on IIS 6
So adding a check in the query for any null values enables the dependant dropdown to auto-populate based on a selection in the first dropdown...
Another thing - the table to which the dependant dropdown contains just under 40,000 records so in 3.2 I had to add <% Response.buffer = false %> otherwise the page would error out with:
Response object error 'ASP 0251 : 80004005'

Response Buffer Limit Exceeded

/TechSupport/MyTickets/CSRRecordsWeb_add.asp, line 0

Execution of the ASP page caused the Response Buffer to exceed its configured limit.
regardless of config changes on IIS6 OR 5.1

  • Setting this to false significantly slows data download BUT for the same dataset in 4 this setting is not required on the same server increasing dataset return is no more than a few seconds even over VPN...
    Thank you
Sergey Kornilov admin 1/20/2006

Probalem: Response Buffer Limit Exceeded
Using IIS 6: If you get the above error when you click on an attachment, the attachment is larger than IIS is configured to allow. Change the AspBufferingLimit setting in Metabase.xml to a larger size. The default value is 4194304, which is about 4 MB. Change this to whatever limit is reasonable for the types of files your users will be attaching.
This change does not require stopping IIS, but to make the Metabase.xml file write-able, you need to go to the IIS control panel, right click the server, select properties, and check off the box that says "allow changes to MetaBase configuration while IIS is running".
C
 		clig author 1/21/2006

Probalem: Response Buffer Limit Exceeded

Using IIS 6: If you get the above error when you click on an attachment, the attachment is larger than IIS is configured to allow. Change the AspBufferingLimit setting in Metabase.xml to a larger size. The default value is 4194304, which is about 4 MB. Change this to whatever limit is reasonable for the types of files your users will be attaching.
This change does not require stopping IIS, but to make the Metabase.xml file write-able, you need to go to the IIS control panel, right click the server, select properties, and check off the box that says "allow changes to MetaBase configuration while IIS is running".


It's already set to ~100MB... - It's not attachments that's the issue and usually setting "AspMaxRequestEntityAllowed" to something a little more desirable than 200K will allow you to upload larger attachments - It is the sheer # of records... The idea was to pull a sys type then a project with the intention of not having to D/L the entire project table at once... This is not the case looking at the code we are always going for EOF... (Here I would want to pass a parameter (SYS Type) from the first drop down to a Stored Procedure and push a result back to the client as the recordset available in "Project") But, as it stands, for a ticket history table for example that contains ~100,000 records per year will always error out even with the buffer setting or blanking first page then doing a search... With something like:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ']'.

/ASPRunnerPro/Repair_list.asp, line 1201
I'm a novice ASP guy mostly VBA/SQL/CTI and I am trying viable ways to port my ticketing backend to a web front end...