Prev: array field type
Next: PHP + PostgreSQL: invalid byte sequence for encoding"UTF8"
From: "bedul" on 12 Mar 2007 20:47
are u indonesian?
----- Original Message -----
From: "IMRAN" <imran(a)perfecture.com>
To: "bedul" <landavia81(a)gmail.com>
Cc: "php.db" <php-db(a)lists.php.net>
Sent: Monday, March 12, 2007 8:04 PM
Subject: [PHP-DB] Re: odbc problem


> Send me your code, I'll fix it for you...
nooo.. that's would not necesarry.. i think u miss my lastest posting.. it
already solved
the problem not on code but on.. "SQL".

there are more than 300++ field on that table.. and there i should not try
use
"select * from table"
but should describe what i was going to show like
"select patientName from patient"

> ----- Original Message -----
> From: "bedul" <landavia81(a)gmail.com>
> To: "IMRAN" <imran(a)perfecture.com>
> Cc: "php.db" <php-db(a)lists.php.net>
> Sent: Monday, March 12, 2007 12:15 PM
> Subject: Re: odbc problem
>
>
>
> ----- Original Message -----
> From: "IMRAN" <imran(a)perfecture.com>
> To: ""bedul"" <landavia81(a)gmail.com>
> Cc: "php.db" <php-db(a)lists.php.net>
> 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(a)gmail.com>
> > Newsgroups: php.db
> > To: <php-db(a)lists.php.net>
> > Sent: Monday, March 12, 2007 10:21 AM
> > Subject: Fw: odbc problem
> >
> >
> > >
> > > ----- Original Message -----
> > > From: "gunawan" <wibisonog(a)ramsayhealth.co.id>
> > > To: <php-db(a)lists.php.net>
> > > 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
>
First  |  Prev  | 
Pages: 1 2
Prev: array field type
Next: PHP + PostgreSQL: invalid byte sequence for encoding"UTF8"