Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-03-12 : 11:28:03
|
<html><head><META NAME="Robots" CONTENT="noindex"> <title>Deeptree</title> <link rel="stylesheet" type="text/css" href="/library/shared/deeptree/css/deeptree.css"><!--TOOLBAR_START--><!--TOOLBAR_EXEMPT--><!--TOOLBAR_END--></head><script> if (top.location == self.location) { top.location.href = "/"; } function selectstart() { window.event.cancelBubble = true; window.event.returnValue = false; return false; }</script><body onselectstart="selectstart();" topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" bgcolor="#F1F1F1" text="#000000"><nobr><div id="deeptree" class="deeptree" CfgXMLSrc="/library/deeptreeconfig.xml"></div></nobr></body></html>This is just a tip of the iceburg but my gut says it is the solution I need.What this is is the source from the left frame table of contents for the msdn library.Why I'm interested in this is I like the way the little plus signs branch down gather a new little branch then display almost without refreshing. How is this done. Any examples. I have dug around some of microsofts include/.src files to see how they do it but everytime I get on a roll and start investigating I get called away to do something else. Then it's back to square one. How can I impliment this drill down method on .asp pages without doing things the old fashioned way. Here is an another example at it's most basic[url]http://www.microsoft.com/windowsserver2003/evaluation/overview/strategy/deployfaq.mspx[/url]The main SQL server here is 7.0 so the full range of XML approaches is not open to me right now. But for some reason I think client side XML strategies are the key here. Why because even the native non .xsl IE display of .xml documents has this functionality built right in.An example of what I want the page to do would be show a page that might compare quoted price vs actual price. Now the quote may not take into account a certain internal purchasing category so the actual price may be derived from categories distinct from what one might use for quoting. Therefore if someone was to see the whole picture they would need to drill down from the actual price to see what purchasing categories were involved.Example:To build a widgit you need parts from the category widgitparts The quote would say $500 in widgitparts.But purchasing may say $500 in widgitparts + $5 for widgetpolishingSo the guy who quoted the widgit screwed up by not including the polish. The quote and actual need to line up or folks are going to start asking questions. So they need to drill down immediately and find out why they differ by $5. Then everyone can tell the quoter. "Smarten up, we never sell unpolished widjits, so always include a choice from the widgitpolishing category."Anyways I need to develop this drill down display method/model. Any ideas, examples, components, or even what to call these techniques.Voted best SQL forum nickname...."Tutorial-D" |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-08-19 : 14:30:30
|
| Anybody use this server control, where does it fall short.http://www.obout.comPossessing a wide range of watered down skills. |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-08-19 : 15:27:35
|
| Thanks Seventhnight.dtree or similar I have used on occasion.What's funny about this is the date of the original post.I had no luck back then getting a dynamic tree like the MSDN one to work much beyond a pure ADO.Datashaping (yuck) approach. Went with a dtree type for the static stuff when needed; then eveybody and their dog has a treeview server control for sale. Pays to be patient, as they are now free.Possessing a wide range of watered down skills. |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-08-19 : 15:33:01
|
| Ahh.... not paying attention to the dates... oh well.Corey |
 |
|
|
|
|
|