----- Original Message -----
From: "IMRAN" <imran@xxxxxxxxxxxxxx>
To: ""bedul"" <landavia81@xxxxxxxxx>
Cc: "php.db" <php-db@xxxxxxxxxxxxx>
Sent: Monday, March 12, 2007 1:03 PM
Subject: Re: odbc problem
> Is odbc_num_fields return any value ?
> You can disable the warnings in php.ini file.
>
> Please let me know if that helps...
nope.. no value has been return.. but it kind strange
Using odbc_field_len
No rows found
odbc connected
total column=268
it return the column but not the value inside?? strange??
the more strange was it should return 300++??
i'm curious about this warning line
====================================
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Caché ODBC][State :
S1000][Native Code 400] [D:\Aplikasi\xampp\apache\bin\apache.exe] General
server error, SQL state S1000 in SQLExecDirect in
D:\Aplikasi\xampp\htdocs\tes\odbc\c-4.php on line 11
===========================================
"General server error, SQL "
any clue anyone.. i believe this the problem begin..
fyi.. i already close after open the database. but nothing good happen.
thx to anyone reply..
> ----- 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
