xdhtml scheduler not loading mssql

Discontinued products Uncategorized discussions
#1

i have xdhtml setup with an mssql database. it writes new data into the database, and submits changes, but on refresh, nothing shows. its not loading no matter what i do, but loads xmls.



php/event.php:

<?php

    include (’…/…/…/codebase/connector/scheduler_connector.php’);

    include (’…/…/…/codebase/connector/db_mssql.php’);

    

    

    $res = mssql_connect(‘’,'’, '**’);

    mssql_select_db(‘aworkingdatabase’);

    

    $scheduler = new schedulerConnector($res, “MSSQL”);



    $scheduler->enable_log(“log.txt”,true);

    $scheduler->render_table(“events”,“event_id”,“start_date,end_date,event_name,details”);

?>



and the main file:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>



    

    



    

    



    



    html, body{

        margin:0px;

        padding:0px;

        height:100%;

        overflow:hidden;

    }    











    



        


            
 


            
 


            


            


            


            


            


        


        


        


        


        
        

    






and the log:





====================================

Log started, 04/10/2009 09:10:58

====================================



SELECT event_id,start_date,end_date,event_name,details FROM events



Done in 0.0010170936584473s







====================================

Log started, 04/10/2009 09:10:03

====================================



DataProcessor object initialized

1254705178022_start_date => 2009-10-1 00:00

1254705178022_end_date => 2009-10-1 00:05

1254705178022_text => New event

1254705178022_id => 1254705178022

1254705178022_details =>

1254705178022_!nativeeditor_status => inserted

ids => 1254705178022



Row data [1254705178022]

start_date => 2009-10-1 00:00

end_date => 2009-10-1 00:05

event_name => New event

id => 1254705178022

details =>

!nativeeditor_status => inserted



INSERT INTO events(start_date,end_date,event_name,details) VALUES (‘2009-10-1 00:00’,‘2009-10-1 00:05’,‘New event’,’’);SELECT @@IDENTITY AS dhx_id



mysql_free_result(): supplied resource is not a valid MySQL result resource at C:\Inetpub\wwwroot\calendar\codebase\connector\db_mssql.php line 15



Edit operation finished

0 => action:inserted; sid:1254705178022; tid:34;



Done in 0.0017879009246826s







====================================

Log started, 04/10/2009 09:10:03

====================================



SELECT event_id,start_date,end_date,event_name,details FROM events



Done in 0.0011329650878906s



#2

$scheduler = new schedulerConnector($res, “MSSQL”);
Must be
$scheduler = new SchedulerConnector($res, “MSSQL”);

Also there was small problem with mssql connector, you can update existing php file with the attached one, but those problems are minor and not related to the main problem in your case.

Please provide an XML snippet, which is generated during data loading ( result of events.php call )

db_mssql.zip (917 Bytes)

#3

Hi,

I am facing the exact same problem. I havent been able to get the events onto the calendar, though they get saved to the database in MSSQL.

Here is a snippet of the XML data which i get back. Please see this issue.

Regards
Raagi

events.xml.zip (356 Bytes)

#4

You are using non-default format for dates , so scheduler need to have next line before loading

scheduler.config.xml_date = “%M %d %Y %H:%i%A”;

Also, the existing version has a known issue with parsing “AM|PM” in dates. You need to update js file to latest build ( dhtmlx.com/docs/products/kb/inde … nt&q=12216 )

#5

I  followed  the instructions you showed. I changed the date format  to    scheduler.config.xml_date = “%M %d %Y %H:%i%A”;    and also replaced the js file but still facing the same problem.
Any further help from your side is awaited…

#6

Please try to use the attached version of js file instead of the original one.
dhtmlxscheduler_df.zip (28.5 KB)