Results 1 to 2 of 2

Thread: Tornado - Quick Start Example Error

  1. #1
    Join Date
    Dec 2002
    Location
    Albany, NY
    Posts
    115

    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>+

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    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
  •