Is odbc_num_fields return any value ?
You can disable the warnings in php.ini file.
Please let me know if that helps...
----- Original Message -----
From: ""bedul"" <landavia81@xxxxxxxxx>
Newsgroups: php.db
To: <php-db@xxxxxxxxxxxxx>
Sent: Monday, March 12, 2007 10:21 AM
Subject: Fw: odbc problem
>
> ----- Original Message -----
> From: "gunawan" <wibisonog@xxxxxxxxxxxxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> Sent: Monday, March 12, 2007 11:46 AM
> Subject: odbc problem
>
>
> > i have this warning.. i don't know what the meaning
> > ----------------------------------------
> > Using odbc_num_fields
> >
> > Warning: odbc_exec() [function.odbc-exec]: SQL error: [Caché ODBC][State
:
> > S1000][Native Code 400] [C:\ProgramFiles\xampp\apache\bin\apache.exe]
> > General server error, SQL state S1000 in SQLExecDirect in
> > C:\dokumen_php\tes\odbc\c-6.php on line 12
> > ---------------------------------------------
> >
> > this is my script.. i know this is simple..
> > ----------------
> > <h1>Using odbc_num_fields</h1> <?
> >
> > //include "c-config.php";
> > $DBname = 'medtrak2'; //'MSAccessDriver'
> > $DBuser = "_system";
> > $DBpass = "sys";
> >
> > $con = odbc_connect($DBname, $DBuser, $DBPass);
> > if ($con)
> > {
> > $txt.= "odbc connected
> > ";
> > $sql = "select * from PA_Adm";
> > //this function will execute the sql satametn in
> > //correspondance to the table in the db
> > $exec = odbc_exec($con, $sql);
> > //int odbc_num_fields ( resource result_id )
> > $n= odbc_num_fields($exec); //$Query_ID);
> >
> > $txt.="<br>\ntotal column=".$n;
> > }
> >
> > //$txt.= readThisFile($filename);
> >
> > print $txt;
> > ?>
> >
> > -------------------
> >
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
