>>SELECT PA_PatMas.PAPMI_Name FROM PA_Adm, PA_PatMas where
PAADM_PAPMI_DR=PAPMI_RowId1 and PAADM_ADMNo = "O0002694"

i add something from previous
the problem because i show all table and it make error!!
if i just point what i wanted to show.. is not error..

repair for odbc sql.. (if anyone have account for php-help-chm plz info
this)
the max of row odbc can show was "268", more than that.. u will receive
error like
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Caché
ODBC][State:S1000]


----- Original Message -----
From: "Haydar Tuna" <[EMAIL PROTECTED]>
To: <php-db@lists.php.net>
Sent: Monday, March 12, 2007 2:53 PM
Subject: [PHP-DB] Re: odbc problem


> Hello,
>       I faced same problems. My table had many rows but I couldn't run
> odbc_num_fields. It return -1 result. I looked PHP help file. But I get
rows
> with odbc_fetch_row() function. My operating system was Windows 2003. I
> think, there is a bug odbc_num_fields function in Windows 2003 operating
> systems becuase in Windows 2003 , when I run PHP with IIS I faced many
> problems. :)
>
>
> --
> Haydar TUNA
> Republic Of Turkey - Ministry of National Education
> Education Technology Department Ankara / TURKEY
> Web: http://www.haydartuna.net
>
>
> ""bedul"" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> >
> > ----- Original Message -----
> > From: "gunawan" <[EMAIL PROTECTED]>
> > To: <php-db@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
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to