Ana asked 11 years ago
Hi, i have problems whit odbc database, this is the code i use
<?
// include and create object
include("phpgrid/lib/inc/jqgrid_dist.php");
$db_conf = array();
$db_conf["type"] = "odbc"; // mysql,oci8(for oracle),mssql,postgres,sybase
$db_conf["server"] = "213.98.68.56";
$db_conf["user"] = "webanamalagacar";
$db_conf["password"] = "Lacasito49";
$db_conf["database"] = "carplus";
$db_conf["driver"] = "DB";
$g = new jqgrid($db_conf);
$g->table = "Agrupaciones";
$out = $g->render("list1");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
<!– these css and js files are required by php grid –>
<link rel="stylesheet" href="phpgrid/lib/js/themes/redmond/jquery-ui.custom.css"></link>
<link rel="stylesheet" href="phpgrid/lib/js/jqgrid/css/ui.jqgrid.css"></link>
<script src="phpgrid/lib/js/jquery.min.js" type="text/javascript"></script>
<script src="phpgrid/lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="phpgrid/lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="phpgrid/lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
<!– these css and js files are required by php grid –>
</head>
<body>
<div style="margin:10px">
<!– display grid here –>
<?php echo $out?>
<!– display grid here –>
</div>
</body>
</html>
and this is the message for problem
Couldn't execute query. [unixODBC][FreeTDS][SQL Server]Incorrect syntax near 'LIMIT'. – SELECT * FROM Agrupaciones WHERE 1=1 LIMIT 1 OFFSET 0
can you help me?? thanks
