Announcement

Collapse
No announcement yet.

Problem with the calendar application

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with the calendar application


    Although I have built a calendar application, which is exactly the tutorial, this does not work. When creating an appointment, although this is created in the table but not shown in the calendar. Does anyone have a similar problem, or even a solution?

  • #2
    Re: Problem with the calendar application

    Which browser do you use ?
    Try to clean the cache from your browser, cookies, history.

    Comment


    • #3
      Re: Problem with the calendar application

      I deleted the Browserhistory, cookies and all other local Browseritems, but the calendarapp is not running correctly, It saves new Items but it displays no Items...

      Comment


      • #4
        Re: Problem with the calendar application

        Oh sorry, I forgot: Mozilla Firefox actual Version, I try IE7, IE8. All Browsers have the same Problem

        Comment


        • #5
          Re: Problem with the calendar application

          Which database do you use ? Did you check in your database if the register exist ?

          Comment


          • #6
            Re: Problem with the calendar application

            This is the code from the example of the tutorial.

            CREATE TABLE `calendario` (
            `chave` int(11) NOT NULL default '0',
            `titulo` varchar(50) default NULL,
            `descricao` text,
            `inicio` datetime default NULL,
            `final_data` date default NULL,
            `final_hora` time default NULL,
            `recorrencia` char(1) default NULL,
            `periodo` char(1) default NULL,
            PRIMARY KEY (`chave`)
            ) ENGINE=MyISAM DEFAULT CHARSET=latin1;


            If you use this and SC5.2 it will create
            a messy form, that does not work if you fill it out
            compleately. It´s easy to tweak and to get it to work - but
            a baaad example is this throuh and through

            Use english also in your examplecode or even try to use englich like i do




            another bad example, cause i did not correct the language
            thats what my code looks rigt now:

            CREATE TABLE IF NOT EXISTS `calendario` (
            `chave` int(11) NOT NULL AUTO_INCREMENT,
            `titulo` varchar(50) DEFAULT NULL,
            `descricao` date DEFAULT NULL,
            `inicio` time DEFAULT NULL,
            `final_data` date DEFAULT NULL,
            `final_hora` time DEFAULT NULL,
            `recorrencia` char(1) DEFAULT NULL,
            `periodo` char(1) DEFAULT NULL,
            PRIMARY KEY (`chave`)
            ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=345634586 ;

            chears

            Comment


            • #7
              Re: Problem with the calendar application

              [quote author=Max Veras link=topic=1835.msg6236#msg6236 date=1286284525]
              Which database do you use ? Did you check in your database if the register exist ?
              [/quote]
              MySQL 5 or Access2007 via ODBC

              This is the DDL for the Table
              CREATE TABLE sds.calendar.t_items (
              `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
              `title` varchar(50) NOT NULL,
              `descript` text,
              `date_begin` datetime DEFAULT NULL,
              `date_end` date DEFAULT NULL,
              `period` char(1) DEFAULT NULL,
              `recorr` char(1) DEFAULT NULL,
              `series_id` bigint(30) unsigned DEFAULT NULL,
              `calendar_id` bigint(30) unsigned DEFAULT NULL,
              PRIMARY KEY (`id`)
              ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

              The INSERT INTO Statement works correct and stored the Dataset in the table. But it is not diplaed in the Calendarview of SC.

              Latest Research Results:
              I have a Where clause in the SQL Statement:
              calendar_id = 0
              or Calendar_id = [calendar_id]
              or calendar_id = [defaultcalendar_id]

              I wish it to display the default calendar, and the user calendars.
              It always provides a blank calendar.
              Now I have deleted the WHERE CLAUSE.
              The calendar now shows all messages.
              After I installed the Where Clause again, the calendar all the entries again.
              Now I had a new appointment. default for the calendar.
              Now appear Wieers no dates. Even if the WHERE clause is deleted, the obese empty calendar.

              I'm going crazy. The beast is not easy to grasp

              Comment

              Working...
              X