>>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" <haydartuna@xxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Monday, March 12, 2007 2:53 PM Subject: 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"" <landavia81@xxxxxxxxx> wrote in message > news:018401c76462$2524cd90$670b1e0a@xxxxxxxx > > > > ----- 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
