This topic is locked

Master Detail No Data

4/22/2004 3:44:12 PM
ASPRunnerPro General questions
author

Hi,
I am using ASPRunner Pro and when I come to my master detail page it is blank. Yet when I click on the one blank line that has view next to it, I get data for the first record. All additional pages are blank as I click on page 1 or page 2 or page 3 etc... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=543&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Any ideas?
Thanks,
Mark S.

Sergey Kornilov admin 4/22/2004

Mark,
I guess some data error happens on the page that prevents data from displaying. To see exact error message you can the following:
Open ..._list.asp file in any text editor and change the following line

On Error Resume Next


to

'On Error Resume Next


and test this page again.

500098 4/22/2004

Yeah that helps.
Error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/chemicals/mls/ASPRunner/minmax/Worksheet_list.asp, line 1032
It points to this section fo the code:
<td align=center>

<% if IfNeedQuotes(rsData("ITEM").Type)="True" then strQuote="'" else strQuote="" end if %>

<a href="Tracking_list.asp" onClick = "document.forms.details.action='Tracking_list.asp';document.forms.details.masterkey.value='<%=EscapeQuotes(strQuote & rsData("ITEM") & strQuote)%>'; document.forms.details.submit();return false;">

Tracking

</a>

</td>
My master page is Worksheet_list.asp and it should link field [Part Number] on the Tracking_list.asp page [ITEM]
This is purely how it was generated form ASPRunner Pro. I seem to be having this problem when using ASPRunner Pro with other db's also.
What next?
Thanks,
Mark S.

500099 4/22/2004

Ok,
I changed the ITEM field to Part Number and it works now!
However I get an error now when I try to connect to the detail page.
First Error:
document.frmadmin.SearchFor is Null or not an Object
Then the second error for the form is displayed which is this:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
SQL = select [SuppNum], [ITEM], [Qty1], [Ship_Date1], [Tracking1], [Qty2], [Ship_Date2], [Tracking2], [Supplier_Part_Num], [Supplier_Job_Num] From [Tracking] where (SuppNum = '029630') and ITEM = 'BACC65AK211P'
Thanks,
Mark S.

500100 4/23/2004

Hello again,
It turns out that the strMasterSQL on the detail page Tracking_list.asp, had the wrong field name in the WHERE clause as well. It was trying to use the field from the detail table [ITEM] when it should have been using [Part Number]. So apparently the key fields were not correct. maybe since they were not the same field name this caused a problem?
WAS:

strMasterSQL = "select [Status], [Active], [Supplier Name], [Supplier Code], [Part Number], [Metric Effective Date], [Code Type], [PO], [O_QTY], [D_QTY], [OnO_QTY], [AMD], [Inv Min], [Total Labinal Inv], [Inv Max], [Trigger], [Status Req], [Comments], [Buyer] From [Worksheet] where [ITEM]=" & Request.Form("masterkey")
Should be:
strMasterSQL = "select [Status], [Active], [Supplier Name], [Supplier Code], [Part Number], [Metric Effective Date], [Code Type], [PO], [O_QTY], [D_QTY], [OnO_QTY], [AMD], [Inv Min], [Total Labinal Inv], [Inv Max], [Trigger], [Status Req], [Comments], [Buyer] From [Worksheet] where [Part Number]=" & Request.Form("masterkey")
It now works!
Thanks,
Mark S.

Sergey Kornilov admin 4/23/2004

Mark,
thank you for pointing me to this!
This problem is fixed in the latest update which can be downloaded here