smalloy
Posts: 107
|
| Posted: 03/29/2005, 10:29 AM |
|
I have a hierarchical table that is set up like this (it populates a tree)
ID Parent
1 0
2 1
3 1
4 2
5 0
So if the parent is 0 it’s the root. I have a set of stored procs that return the entire tree or limit the user to the part of the tree that they are restricted to. My problem is that I don’t know how to get the temp table to the CCS form. I noted that a user used a stored proc to populate a listbox (http://forums.codecharge.com/posts.php?post_id=48800) But without the OUTPUT parameter I’m failing at every turn.
Any ideas? I’d be glad to post the stored procs if you’d like (they come in handy for message threads too with the caveat that they are limited to 32 threads deep).
Thanks!
_________________
Anything can be done, just give me time and money. |
 |
 |
smalloy
Posts: 107
|
| Posted: 03/31/2005, 10:02 AM |
|
Figured it out, I am an idiot.
Simply change the datasource to SQL, in the SQL window that appears enter the stored proc and pass any needed parameters and poof, your done.
Here's my SQL Statement:
sp_Get_Building_Hirearchy {pyr_ID}
As an asside it the parameters portion I set the pyr_ID to a URL parameter source.
Big problem resolved!
_________________
Anything can be done, just give me time and money. |
|
|
|
|
