-
Tree question
I am trying to use a Tree option in Tornado. I used the eg from the site.
But I connected to sql server instead of mdb.
When I run this I get the error
(765 : 999) Error
Error - Invalid SQL
(765 : 999) Error
Error - Invalid SQL
I ran the trace and checked out to see what it the sql it is running and
here it is
SELECT COUNT(1) FROM (Select Employeeid, Orderid, customerid From orders
group by Employeeid, Orderid, Customerid)
For some reason it is running the code replacing the table name with the
full select statement ?
Any help is greatly appreciated...
Thanks
Mani
PS here is the code I am executing
<!--T_ShowTree_3.aspx-->
<%@ Page Language="vb" Debug="true" %>
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim tree As New Tornado.Z()
With tree
.dbPageSize = -1
.dbDbType="sql"
.dbDSN = "gmserver;NORTHWIND;nwind;nwind"
'.dbCommonTables = "index=EID,FullName|sql=Select Employeeid,
Firstname & ' ' & Lastname from employees"
'.dbLookUpFlds = "field=Employeeid|keyindex=EID|lookupindex=FullNam e"
.dbSQL = "Select Employeeid, Orderid, customerid From orders group by
Employeeid, Orderid, Customerid"
'... DB data source defined - use tree to present
.dbTreeParams = "wi=200| he=500|mst=5| mbg=ffffff|
mifp=aspdbmenuicons1.gif| sifp=aspdbmenuscroll.gif| fontsize2=11|
fontname0=Verdana| fontname1=Verdana| fontname2=Verdana| fontname3=Verdana|
textstyle2=1| xoffset0=4| xoffset1=4| xoffset2=4| xoffset3=3|
hovercolor0=6E6E6E| hovercolor1=6E6E6E |hovercolor2=6E6E6E
|hovercolor3=6E6E6E| opencolor0=FF0000| opencolor1=FF0000|
opencolor2=FF0000| visitedcolor0=a5a5a5| Visitedcolor1=a5a5a5|
visitedcolor2=a5a5a5| visitedcolor3=a5a5a5| nodeheight=1| Type=DB|
defaultAction=javascript:alert('Employee = [[0]] : Order ID = [[1]] :
CustomerID = [[2]]')"
Response.Write(.ASPdbTree())
End With
End Sub
</script>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|