2. ASPRunnerPro General questions
  3. [SOLVED]  Lookup Values for List
This topic is locked
[SOLVED]

 Lookup Values for List

 		5/21/2004 4:47:50 PM
ASPRunnerPro General questions
D
 dan_vt author

The following link shows the problem I have. Notice that in the LIST view, the VENDOR field is displayed as the numeric key values stored in the table being read by ASPRunner.
Notice that in the EDIT view, VENDOR NAMES display, not the numeric keys. VENDOR NAMES are stored in a separate table, with VENDOR KEY being a foreign key in the Projects table (the one displayed).
The EDIT WITH LOOKUP WIZARD works great for edit view.
Is there a way to make the VENDOR NAMES appear in the list (as they do in EDIT), instead of the key values?
Here is the demo link:
http://citrix.cabotcheese.com/dev_02/05_21...ojects_list.asp
As always, any assistance in resolving this problem will be appreciated immensely.
-Dan
Sergey Kornilov admin 5/24/2004

Dan,
you need to modify SQL query that ASPRunner built for you. You need to use INNER JOIN to pull data from a joined table.
Here is the sample syntax:

select ..., Vendors.VendorName

from cbtData_Projects

inner join Vendors

on Vendors.Vendor = cbtData_Projects.Vendor
D
 		dan_vt author 5/24/2004

As usual Serg, you had the direct answer. Thank you again.
I think your company should know that your presence on this message board adds immense value to ASP Runner.
Question: How is the company doing? I hope ASP Runner support never goes away.
Another Question: How come nobody else has figured out to make something like ASP Runner? To me, it is an obvious application that M$ should have built. However, as near as I can tell, no one else even tries doing what ASP Runner does.
Sergey Kornilov admin 5/24/2004

Dan,
I appreciate your kind comments!
Company is doing very good and you can expect the same quality support in the future.
In my understanding MS thinks this market niche is too small for them. Though it's enough room for several companies like mine.