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"
I was able to move next step. It didnt give any error but it did not show anything on the screen. So after drilling down I found that we have to have a folder called 'tree' inside tornado\db and there should be gif files inside it which I filled in.
But I still miss the "defaultaction". Nothing happens when I click on the last node. I was just thinking I should have missed some step like the folder or something required in the class file.Also I dont see the html tags.
After it displays the tree and click on the first item I get the second item being called as output...
Do I have to do anything special to call the right one?
Thanks
Mani
<% @ 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
.dbDSN = "gmserver;MPFFU;mpf;mpf"
.dbSkin="Cappuccino"
.dbSQL = "Select PelCol1,PelCol2 From gPermissionList group by PelCol1,PelCol2"
.dbCountSQL = "SELECT COUNT (1) From gPermissionList"
'... DB data source defined - use tree to present