2. ASPRunnerPro General questions
  3. Multi Table Data
This topic is locked

Multi Table Data

 		9/7/2010 2:03:24 PM
ASPRunnerPro General questions
R
 Roger author

I have an ASPrunner 6.1 form that displays Parent and Child data. I need to also display data from several other tables on the same form. I can retrieve the data, but it doesn't seem to want to display on the page.
I am using several tables to display the data and am using correct ASP syntax to display (populate the table cells). Yet the cells remain empty. I've debugged and used resonse.write to ensure the data is available and it is.
What am I missing here?
Also, while still on this question, how can I place a table on an ASPrunner generated page so that it actually looks good. When I place a table on a page, it moves everything around and it takes so much time to re-align everything. I even followed the tutorial on the web site that creates a "Credit Card Form Entry" and yet it gets all foobarred up.
I know I've done this before and i's worked but I've been awary form ASPR for some time and can't seem to get either of these to work.
Thanks,
Roger
Sergey Kornilov admin 9/7/2010

Too many questions arise.
Are those additional tables related to main one?

Where do you want to display those additional tables?
As a general advice you can follow this example that shows how to display data in table form anywhere on the page:

http://xlinesoft.com/asprunnerpro/docs/show_customer_orders.htm
R
 		Roger author 9/8/2010

Thanks for the link to display the records - and it annoys me because I knew this. Shows what taking time away can do for one - thanks for this.
As for the relationships, yes all required tables are related to the Parent Table by an ID (bigint) column. I think where I am getting myself all foobarred up is this.
In the GUI, ASPR creates the list (or add/edit) pages. In the list page (for example), I want to add the snippet that you pointed out in your supplied link, but I need to put it above the Child data that ASPR lists on the page (almost like a Sub Heading). Perhaps some kind of description may help, please bear with me (I can provide a jpeg of a snapshot if that would help).
Here goes: Table A contains user account stuff. Table B holds data for that user account (about 60 columns). When the user logs in, I need to place at the top of the List Form for the Child Records some other data from the Child Table (that actually is for referrence purposes), then the details of Table B (the Child table) data that is liked to the Parent, Kinda like this (data with [] around them represent the data from table B that will appear only once for each client):
Table A: Header Data (Parent Account info etc), below this:

Table B: (displayed at the left) Messages sent: [221/1456], (displayed at the right) Next Message Run: [Sept 22, 2010] at [23:00]

Table B: Rest of related data which may span many pages.
For the first set of data from Table B (the Sub Heading if you will) I would like to be in a table so that I can apply styles etc. Also, it would provide me proper page positioning of the data.
I hope this helps to clear things up, if not I can upload a Jpeg of the page layout that is being used in a PHP site that we are converting.
Thanks.
Sergey Kornilov admin 9/8/2010

Roger,
I guess you need to contact support team directly at http://support.xlinesoft.com sending URLs or screenshots of what you have right now and what you need to implement.