-
Tornado - Quick Start Example Error
There is a syntax error in the Quick Start (Lookup) code which can't possibly work. There is a + operator following FirstName, a & should be there. See the code below.
<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim Grid1 As New Tornado.Z()
with Grid1
.dbQP = "s=12|m=g|d=nwind|th=Title=Lookup Any Fields/sub=With only 2 Lines of Code|sql=Select * from Employees| gdf=0,ReportsTo"
.dbCommonTables = "index=ID,NAME | SQL=SELECT Employeeid, FirstName + ' ' & Lastname from employees"
.dbLookUpFlds = "field=0| Key=ID| Lookup=NAME, Field=ReportsTo| Key=ID| Lookup=NAME"
.ASPdbNet
end with
End Sub
</script>+
-
I tried both + / & and they both work?... My DSN is Nwind.mdb
FK
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
|
|