2. ASPRunnerPro General questions
  3. Display only certain data in page
This topic is locked

Display only certain data in page

 		12/19/2004 5:42:33 AM
ASPRunnerPro General questions
J
 jeremyb author

I've downloaded your software and been able to build the system I want to a point.
I run a web site for a Rugby team and I want to build a player/team database. This I have done BUT the web site I have has pages for each team. I want to therefore only show the respective team details on the associated team page, I don't want to be showing everything.

There is a field call Team, that distinguishes each players team, so I can catagorise/group by that field, but seem unable to find where I can put this in the code.
I also want to do the same with each player. I plan to produce a graphic that displays 15 players (maybe with some subs) and when you hover over the player it brings up the players details (as per the ...._view.asp page) by selecting the players Player_Id number which is also in the database. How could this be done?
Any advice much appreciated
Jeremy
Sergey Kornilov admin 12/19/2004

Jeremy,
I guess you need to use security mode Users can view and edit their own data only. In this case each team will be able to see data that belong to this team only. Field named Team will be an OwnerID field in your example.
ASPRunner cannot build hover functionality howeever you can use More ... feature to display full info about player on the list page.
J
 		jeremyb author 12/21/2004

Sergey
Thanks for the response but not really what I am after.

I have another asp application for news items, and within this you can select catagories and qualify the code which will select specific articles or sections.
I want to be able to place code within other pages of my site to call data from the database. I specifically want to be able to use the ..._view.asp page your system creates to speciifically call one team member.

I can see that there is code available somewhere.

If I run just the player_view.asp page, I get sql query error:

select [PlayerID], [FullName], [Position], [Team], [Pld], [Tries], [Convs], [Pens], [Total], [Previous Clubs], [Player Resume], [Photograph] from [Players] where [PlayerID]=

Where is this select statement called, as I could then hard code the PlayerID for ech player in my pages. Can this be manually coded.
Best Regards
Jeremy
Sergey Kornilov admin 12/22/2004

Jeremy,
here is what you can do:

  1. Open ..._view.asp page in text editor and replace all occuriencies of request.form("editid") with request("editid").
  2. To display any specific player info use <tablename>_view.asp?editid=333

    Just replace 333 with real PlayerID.
    I hope this helps.