2. ASPRunnerPro General questions
  3. Advanced Search w/ Master Table
This topic is locked

Advanced Search w/ Master Table

 		11/7/2006 17:06:52
ASPRunnerPro General questions
C
 carleydc author

I have a series of master/detail relationships that I am creating in ASPRunner 4.1 and when I am on a detail page below a master my Advanced Search errors
Page Cannot be displayed
Error Type:

Microsoft VBScript runtime (0x800A01A8)

Object required: 'session(...)'

/NTC_DC/Via_Qry_new_search.asp, line 101
What am I doing wrong
If I go to the menu and pick it while not below a Master table the advanced Search works fine.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3783&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Sergey Kornilov admin 11/10/2006

Was fixed in build 164.
http://www.asprunner.com/files/asprunnerpro-setup.exe
D
 		dunga 11/16/2006

Alexey, and admins,
please read my message carefully.
I am devoted to ASP runner client, however it is my concern that most of your replies are looking like:

"send us a zipped version" and that severela OBVIOUS requests are not dealt with at all.
secondly,
the issue with the Advanced search exists, and here is how.

  1. I have created ( and actually ziiped and sent it to suppor@xlinesoft.com) a database with the following structure:
    table 1: accomplishments

    table2: logins

    table 3: status
    table accomplishments; has Id, NameID, Notes

    table: Logins has NameID, Logins, Passwords

    table: Status: has statusID, Status
    in the login table NameID values are IDENTICAL to Login values, passwords are paswords

    and NameID is a primary key.
    in the accomplishments table Id is Autonumber, NameID is Lookup from the Login table NameID

    Id here is a primary key
    in the Status table, Status ID is autonumber, Stauts has various text values

    StatusID is a primary key.
    Objective:
    users can see and edit their own data only.
    the following set up has been implemented.(according to the screens of the ASP runner)
    Step 3 of 12 and te rest







what do I do wrong?
the problem is as follows:

in the normal Search search is not working
in the advanced search while selecting NameID to search for the owner of the records all records are displayed, or sometimes( 1out of 2) no records displayed.
Sergey Kornilov admin 11/16/2006

Dear dunga,
thanks for taking your time and explaining this issue with great details.
I got your files and everything looks good. I replied to your personal email.