Results 1 to 2 of 2

Thread: Tornado - checkbox error with SQL

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Tornado - checkbox error with SQL

    Hello,
    We use Tornado.dll Ver 4.6.11.10
    Tornado gives an error when the checkbox is checked.

    Error:
    Edit SQL = UPDATE Products SET Productname='Alice Mutton',discontinued=on WHERE (Productname='Alice Mutton')
    --------------------------------
    System.Data.OleDb.OleDbException: Incorrect syntax near the keyword 'on'.

    Sample code:
    <%@ Page Language="vb" Debug="true" %>

    <script language="vb" runat="server">
    Sub Page_Load(Source as Object, E as EventArgs)

    Dim GD As New Tornado.Getdata()
    Dim NWTest As New Tornado.Z()
    With NWTest
    .dbUnit = "627"
    .dbSkin = "12"
    .dbPageSize = "10"
    .dbDBType="SQL"
    .dbMode = "type=Grid|sysindex=true|classic=true"
    .dbDSN="localhost;Northwind;xxx;xxx"
    .dbSQL="Select Productname, discontinued from Products order by Productname"
    .dbBoolText="DropTrue=1|DropFalse=0"
    .dbSortFlds = "Productname"
    .dbNavigationItem = "gridupdate,cancel,prev,next"
    .dbGridDisplayFlds = "Productname,discontinued"
    .dbEditUpdateFlds = "fi=Productname|tag=size=40|ty=text,fi=discontinue d|ty=checkbox"
    .dbBookMark = "Products;0"
    .ASPdbNET()
    End With
    End Sub
    </script>

    Thank you
    Thomas

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    Grid Edit Boolean did not use booldrop values. Problem confirmed and fixed. Send me you ID file and I'll give you the patched DLL.


    Frank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •