Ajax Event Calendar Support Product Page
This topic is locked
sql error
Asked 27 Jan 2011 23:15:08
1
has this question
27 Jan 2011 23:15:08 Web Master posted:
trying to connect the data to my calendar but get this errorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Title_Column] AS title, [Start_Column] AS start, [stop_Column] AS stop , [Descr' at line 1
below is the feed file:
<?php /* table="[Calendar]" title="[Title_Column]" start="[Start_Column]" stop="[stop_Column]" description="[Description_Column]" type="[Type_Column]" link="[[Link_Column] AS link]" event_id="[ID_Column]" db_type="mssql" */ require_once('../ScriptLibrary/xmlrpc.inc'); require_once('../ScriptLibrary/jsonrpc.inc'); require_once('../ScriptLibrary/json_extension_api.inc'); require_once('../Connections/wgncetv.php'); if (!isset($_GET['start'])) { header("HTTP/1.0 400 Bad Request"); echo "Start is required"; exit(); } else if (!is_numeric($_GET['start'])) { header("HTTP/1.0 400 Bad Request"); echo "Start should be a numeric value"; exit(); } else if (!isset($_GET['stop'])) { header("HTTP/1.0 400 Bad Request"); echo "Stop is required"; exit(); } else if (!is_numeric($_GET['stop'])) { header("HTTP/1.0 400 Bad Request"); echo "Stop should be a numeric value"; exit(); } else { $query_start = intval($_GET['start']); $query_stop = intval($_GET['stop']); mysql_select_db($database_wgncetv, $wgncetv); $query_events = sprintf('SELECT [Title_Column] AS title, [Start_Column] AS start, [stop_Column] AS stop , [Description_Column] AS description, [Type_Column] AS type, [ID_Column] AS event_id FROM [Calendar] WHERE [Start_Column] <= %1$d AND ([stop_Column] >= %2$d OR (ISNULL([stop_Column]) AND [Start_Column] >= %2$d))',$query_stop, $query_start); $events_set = mysql_query($query_events, $wgncetv) or die(mysql_error()); $result_array = array(); while ($row = mysql_fetch_assoc($events_set)) { $result_array[] = $row; } header("Cache-Control: no-cache"); if(isset($_GET['callback'])) { echo $_GET['callback']."(".json_encode($result_array).");"; } else { echo json_encode($result_array); } } ?>
Replies
Replied 28 Jan 2011 15:43:47
28 Jan 2011 15:43:47 Web Master replied:
Code the extension is generating is wrong says db_type = "mssql" when clearly from the query itself below the DB type is Mysql
Think you have a bug here:
Think you have a bug here:
<?php /* table="[Calendar]" title="[Title_Column]" start="[Start_Column]" stop="[stop_Column]" description="[Description_Column]" type="[Type_Column]" link="[[Link_Column] AS link]" event_id="[ID_Column]" db_type="mssql" */
Replied 31 Jan 2011 11:14:06
31 Jan 2011 11:14:06 Teodor Kuduschiev replied:
This problem was resolved in a Live Chat session by clearing Dreamweaver cache file.