DonB
|
| Posted: 03/08/2004, 11:25 AM |
|
I hope I've documented it well enough for everyone to figure out how to use
it. I was a bit stumped in the XSL portion trying to make it fully
parameterized, so there are a few things that have to be hand-edited. I've
tried to make that as straightforward as possible.
There's a sample page included and about 6 pages of documentation - all on
one ZIP file.
It's at my site, look for the "downloads" link'. I'm calling this
"click-ware", no cost to you. Let me know if there are any problems or
things I may have overlooked in documenting it.
An example of it in action is at
http://www.gotodon.com/ccbth/tree/showtree.asp
thanks,
--
DonB
http://www.gotodon.com/ccbth
|
|
|
 |
miron
|
| Posted: 05/25/2004, 9:59 AM |
|
Great idea DonB, but I just can't get it to work. Keep gettin' this error: "Operation is not allowed when the object is closed.
/test/clsCCbthTreeView.inc, line 165",
Any idea? What am I doing wrong?
|
|
|
|
DonB
|
| Posted: 05/25/2004, 3:02 PM |
|
Usually, this is an indication that the datasource was invalid (possibly a
bad query that can't execute?) or perhaps empty. I did find one error in
the .inc file in Function BeforeBuildSelect - the line:
Dim strNodeList, varNodeList, strSQL, i
omitted the variable "i" Make sure yours looks like the line above.
If it still doesn't work, check your line 165 and see what it is - mine is
blank so I don't know why you have an error reported at that line number.
--
DonB
http://www.gotodon.com/ccbth
"miron" <miron@forum.codecharge> wrote in message
news:640b37b6344a36@news.codecharge.com...
> Great idea DonB, but I just can't get it to work. Keep gettin' this error:
> "Operation is not allowed when the object is closed.
> /test/clsCCbthTreeView.inc, line 165",
> Any idea? What am I doing wrong?
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
miron
|
| Posted: 05/26/2004, 12:09 PM |
|
Thanks for your quick reply..
Well actualy the first error occured was:
Variable is undefined: 'strTemplate'
/test/uha-treeetest/clsCCbthTreeView.inc, line 109
So I've added it to the Dim tag, then I bumped to the other one you have mentioned / Dim i / so I've did just like you had sed.
But this is the point that I just can't understand:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/test/uha-treeetest/clsCCbthTreeView.inc, line 165
The line it refers to is :
ccsForm.datasource.recordset.recordset.save xml1, 1
In original clsCCbthTreeview.inc it was line 162.
What am I doing wrong?
I've recreated access db from the enclosed tutorial.
Miron
miron@orbister.com
|
|
|
|
DonB
|
| Posted: 05/28/2004, 9:46 AM |
|
You can uncomment the two lines marked "DEBUG" and the intermediate data
gets written to files (1.xml and 2.xml). In this case, 1.xml can be
examined. It may be empty or for some reason inconsistent with the columns
referenced by the MSXML XSL transform.
--
DonB
http://www.gotodon.com/ccbth
"miron" <miron@forum.codecharge> wrote in message
news:640b4eb6d1ba7f@news.codecharge.com...
> Thanks for your quick reply..
> Well actualy the first error occured was:
>
> Variable is undefined: 'strTemplate'
> /test/uha-treeetest/clsCCbthTreeView.inc, line 109
>
> So I've added it to the Dim tag, then I bumped to the other one you have
> mentioned / Dim i / so I've did just like you had sed.
>
> But this is the point that I just can't understand:
>
> ADODB.Recordset (0x800A0E78)
> Operation is not allowed when the object is closed.
> /test/uha-treeetest/clsCCbthTreeView.inc, line 165
>
> The line it refers to is :
>
> ccsForm.datasource.recordset.recordset.save xml1, 1
>
> In original clsCCbthTreeview.inc it was line 162.
>
> What am I doing wrong?
> I've recreated access db from the enclosed tutorial.
>
> Miron
>miron@orbister.com
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
dekalaked
|
| Posted: 01/31/2005, 5:53 PM |
|
Is there a fix for this error message?
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/test/uha-treeetest/clsCCbthTreeView.inc, line 165
I have uncommented the DEBUG lines but can't find the output files. Where are the debug files (1.xml and 2.xml) located?
|
|
|
|
dekalaked
|
| Posted: 01/31/2005, 9:01 PM |
|
Env: ASP & MySQL
The Treeview was displayed correctly with this SQL statement :
SQL:SELECT ID, ParentID, BlogSubject AS Subject, DateCreated, Hide, Keywords, 'Joe Blow' as Name, 'Joe@example.com' as Email FROM vGUIBlog
WHERE:ParentID = 0 OR (ID=0 OR ParentID = 0) OR (ID=1 OR ParentID = 1) OR (ID=2 OR ParentID = 2)
|
|
|
|
Dean Covey
|
| Posted: 03/09/2005, 9:30 AM |
|
http://www.gotodon.com/ccbth/tree/showtree.asp = Unable to establish connection to database.
Let me know when you get this working. I am very interested in this.
|
|
|
|
navneet
|
| Posted: 03/19/2005, 5:54 AM |
|
DON
still not corrected, two files missing
one is tree.inc and other the blog.mdb
once corrected, please let me know i am interested.
|
|
|
|
|
