Results 1 to 2 of 2

Thread: Problem dbCalendar in Tornado

  1. #1
    Join Date
    Apr 2003
    Posts
    4

    Problem dbCalendar in Tornado

    Hello,

    using dbCalendar in Tornado EP. Couldn't format date in German dd.mm.yyyy. No Properties at dbcalendar are functional. All Tests with Options doesn't affect.

    Below Code used

    <script language="vb" runat="server">
    Sub Page_Load(Source as Object, E as EventArgs)
    Dim XL As New Tornado.Z()
    With XL
    .dbQP = "S=10|M=G!sys=t!Rowedit=t|Ni=b5,Update,GridUpdate, Add,GridAdd,Delete,search|egu=t|ega=t|Th=Ti=Bearbe itung Wochenendarbeitsanmeldungen"
    .dbUnit = "29"
    .dbMode="Ty=Grid|sysindex=false|Indexfld=0"
    .dbSuppressMsg = True
    .dbPageSize = 100
    .dbProvider = "ODBC"
    .dbDSN = "DSN=mysqlmeister"
    .dbDBType = "MYSQL"
    .dbSQL = "SELECT * FROM uebantrag"
    .dbSQLDateFormat = "yyyy-MM-dd"
    .dbEditDateFormat = "yyyy-MM-dd"
    .dbCalendar = "Mask=yyyy-MM-dd| IsUSADateFormat=False"
    .dbBookMark = "uebantrag;lfd"
    .dbGridDisplayFlds= "0,1,2,3,4,5,6,7,8,9"
    .dbSkin = 25
    .dbEditUpdateFlds = "0,1,2,3,fi=Arbeitstag|ty=TextCalendar,5,6,7,9,fi= lfd|ty=RNOUPDATE"
    .dbBoolText = "DisplayTrue=Ja|DisplayFalse=Nein"
    .dbMagicCell = "fi=Arbeitstag|mac=#Arbeitstag::dd.MMM.yyyy#,fi=Vo rarbeit|mac=(#Vorarbeit#|EQ|0||nein~|EL|||ja)"
    .dbDebug = "FilterSetup, FilterAction, EditSetup, EditAction, ActiveSQL, Fields, Request"
    .ASPdbNET()
    End With
    End Sub
    </script>

    That is the last code tested. Have tested many more options and syntax. Nothing runs on dbcalendar.

    Writing date in correct format for mysql yyyy-mm-dd in field Arbeitstag all ok an ist saved good. But I need to input as dd.mm.yyyy or get this format from dbcalendar.

    Please help.

    Hartmut Rudorf

  2. #2
    Join Date
    Oct 2002
    Posts
    933

    dbCalendar is a GOLD ersion function

    It is because dbCalendar is a GOLD version function. Check the online manual and also the product matrix.


    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
  •