2. ASPRunnerPro General questions
  3. View Option?
This topic is locked

View Option?

 		5/14/2004 4:07:07 PM
ASPRunnerPro General questions
B
 berga@alpenacc.net author

I am new to ASP and quite impressed with the ASPrunner program. It workes great, but I can't seem to achieve exactly what I am looking for. I have a database that I want the public to have access to. but, I don't want any changes made, nothing added, edited...etc. I tried the Guest login, but only the information on the list page are they able to see. (I have my pages set up where only some of the info is on the list page, but if you were to "edit" it, you would see all the fields, there is too much informaiton 30 fields, for everything on the list page) So, I want useres to search for info, find the record they are interested in, then click on "view" or something, and have a detail page of all the fields relating to that record. I have no problem with a guest login and guest password, but the link then says "edit", and they can edit the information....this will work (assuming I find out how to make the information NOT save) but I would prefer the link to say VIEW instead of EDIT, also prefer when on the edit page not to have people even able to type over info, even if it don't change.
Others thing....don't ever need to add, change, edit, or anything. Only a viewing database. The information only changes annually, and all at one time, so it's a annual update for me, I would just replace the datasource (excel).
Any help would be great!
Sergey Kornilov admin 5/14/2004

Hi,
I guess whay you are looking for is a View page that available in ASPRunner Pro. I would recommend to take a look at this program. To turn on View page proceed to Key column page in ASPRunner Pro and check off View Page checkbox.
B
 		berga@alpenacc.net author 5/14/2004

Thanks for the fast reply...I determined I might need the PRO version, but I also have an additional questions about the pro version. I would ike to know if you can put information on one page from multiple tables. For example:
I have a record in one table that has a key field, say key field is 001-00

Info in this table is address, name, and other info.
Then in a seperate table I have multiple entries with the key 001-00, say three times. Info in this table is multiple, there may be more than one occurance.
Can I Click on the record with asprunner, record 001-00 and have the data displayed on one page, but pull the data (address, name, etc) from table 1, and also the data from table 2? Currently, my data is in excel.
Thanks.
Sergey Kornilov admin 5/15/2004

Hi,
I guess you need to utilize master-details relationships feature in ASPRunnerPro. This feature allows you to create a link between a record in the first table (master table) and several records in the second table (details table).
To get more info I would recommend to take a look at ASPRunnerPro live demo and ASPRunnerPro tutorial . This can help you to get an idea how to use this feature.
B
 		berga@alpenacc.net author 5/15/2004

Thanks....I've downloaded the trial, and worked good for the first database (after I figured it out!) But, I have a question about an error I'm having on all my consequtive projects....I'll post on the main forum. Thanks again!