2. ASPRunnerPro General questions
  3. List page not displaying records
This topic is locked

List page not displaying records

 		5/27/2004 3:23:35 PM
ASPRunnerPro General questions
S
 stevejebson author

Hi,
Very happy recent purchaser of ASPRunner Pro, good work, however I have built a project that has severlal Tables, the highest level Table is Client. I have a master detail with Contract which is defined at the Contract level. This then drills down to Sites, then Lifts, then Reports. Shouldn't be any problems so far. In fact, it all hangs together quite well... except
The Client list page displays no records although it does say that there are 647 records found over 33 pages. Actualy, that's not quite true, it does display 1 line (no actual data) just the edit link and delete checkbox. I can't seem to get the records to appear, even specifying search keys etc... any ideas ?
Steve
p.s. a Copy/Duplicate record facility would be nice
Sergey Kornilov admin 6/1/2004

Steve,
usually this happens due to some data problem like empty or NULL key column value.
To see exact error message open ..._list.asp file in any text editor

and change the following line:

On Error Resume Next


to

'On Error Resume Next


After that you can run this page again and see error message which you can post here.
S
 		stevejebson author 6/2/2004

Sergey,
thanks for reply, here's the error and code...
ADODB.Recordset (0x800A0CC1)

Unknown runtime error

/htdocs/guideline/admin/Client_list.asp, line 1049
line 1049 & 1050 read...
.

.

.

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

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

.

.

.
Thanks
Steve
S
 		stevejebson author 6/2/2004

Sergey,
Having spotted the "<None>" in the code I have investigated further... The Master/Detail relationship is being corrupted. I have tried several versions of new projects trying to resolve it with no luck. The tables are Client, Contract & Sites where the relationships are as follows :
Client (master key - "Reference") to Contract (detail key - "ClientID")

Contract (master key - "ContractID") to Sites (detail key - "ContractID")
I work thru ASPRunner Pro as in examples, i.e.
Define Client etc..

Define Contract, including master/detail relationship

define Sites, including master/detail relationship
If I highlight the Contract Table on Page 3 the Master key keeps displaying <None>.
I know this is a bit long winded but i think there may be a bug, if you would like me to send you the databse (minus data !) let me know...
Steve
Sergey Kornilov admin 6/3/2004

Steve,
please send me your project file along with your sample database for investigation.

Send it to support AT xlinesoft.com.