php-windows Digest 5 Apr 2001 22:23:11 -0000 Issue 529

Topics (messages 6527 through 6540):

Re: OT e-mail virus "snowhite ... ha,ha,ha"
        6527 by: David Elliott

Re: getmxrr() problems
        6528 by: Yasuo Ohgaki

Re: something wrong w/ ereg() ?
        6529 by: Yasuo Ohgaki
        6537 by: ~~~i LeoNid ~~
        6538 by: Asendorf, John

Re: Exec() In Windows
        6530 by: Dale Heil

Re: Oracle record counting
        6531 by: Asendorf, John

Re: Apache no see PHP - solved!
        6532 by: Marco Bleeker

Antwort: RE: [PHP-WIN] Oracle record counting
        6533 by: clever.ukl.uni-freiburg.de

COM
        6534 by: Conover, Ryan
        6540 by: alain samoun

Excel Manipulation
        6535 by: Conover, Ryan

Failed opening for inclusion
        6536 by: George Rae

Error on new install on IIS 5.0
        6539 by: Conover, Ryan

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------


Dear Wolfgang

On 05 April 2001 at 12:14:34 +0200 (which was 11:14 where I live) Wolfgang
Schneider potrebbe scrivere

> It seems to me that perhaps some list members' computer may be infected
> and is sending out these mails.

==========8<=============================================================
Scientists at the Centers for Disease Control today confirmed that
foot-and-mouth disease cannot be spread by Microsoft's Outlook email
application, believed to be the first time the program has ever failed to
propagate a major virus. See; http://satirewire.com/news/0103/outlook.shtml
==========8<=============================================================

-- 
 Thanks,                   _______________________________________________
  David                   |    David  Elliott    |   Software Engineer    |
 _________________________|  [EMAIL PROTECTED] | PGP Key ID 0x650F4534  |
| I wish I could come up with an original tagline.                        |






I guess it's not supported under windows. getmxrr(), getdnsrr() does not work for me neither. You can take a look at FUNCTION_LIST.txt in PHP source dist. but it seems outdated. If you find any better source that list functions supported under Windows, let me know to. Regards, -- Yasuo Ohgaki ""Vlad"" <[EMAIL PROTECTED]> wrote in message 9ae9ua$59h$[EMAIL PROTECTED]">news:9ae9ua$59h$[EMAIL PROTECTED]... > Hi all > > Is any solution to get MX records from windows? > As I expierenced getmxrr() function dont works in windows. > > Thanks, Vlad > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] >



ereg*() have more restrictions than preg*(). for example, ereg('(A){1,1000}',$str,$regs); I think it does work with current PHP. You might find something if you search BugDB. Regards, -- Yasuo Ohgaki ""~~~i LeoNid ~~"" <[EMAIL PROTECTED]> wrote in message 3acc1b57.6416043@localhost">news:3acc1b57.6416043@localhost... > Are people here aware of specifics for implementation of all ereg~() functions? > It seemed, they didn't work for relatively complex comparisons (with long > strings) at least on Windows95. > > Some of thier calls complain about about reg_expressions, like "?" > qualifiers, etc, some expressions - are not interpreted, as intended, and > for some - script even goes into stall without warning (never returns from > it nor crash!) > > When I replace ereg~() with matching preg~() everything works, as > designed. I now even replace ereg~() for simple calls, where it works, > just in case. > > Anybody has the same experience? > -- > LeoN to e-mail: cut "auto_no." if present. > (.$B%"(B.) ` to think - is to speak quietly, to speak - is to think aloud` > \~/ > My posted articles archive: http://leo.portland.co.uk/doc00.htm > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] >



Are people here aware of specific implementation of all ereg~() functions?
It seemed, they didn't work for relatively complex comparisons (with long
strings) at least on Windows95. 

Some of thier calls complain about about reg_expressions, like "?"
qualifiers, etc, some expressions - are not interpreted, as intended, and
for some - script even goes into stall without warning (never returns from
it nor crash!)

When I replace ereg~() with matching preg~() everything works, as
designed. I now even replace ereg~() for simple calls, where it works,
just in case.

Anybody has the same experience?
--
LeoN     to  e-mail: cut  "auto_no." if present. 
(.±.)  ` to think - is to speak quietly,  to speak - is to think aloud`
 \~/     
My posted articles archive: http://leo.portland.co.uk/doc00.htm





I've had a lot of good luck using ereg* functions....  As a book learning
kind of person, I read Mastering Regular Expressions by Jeffrey Friedl and
have yet to have a major problem.

Then again, I haven't had any experience with other implementations of regex
so I may be missing something.

---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aut insanit homo, aut versus facit


> -----Original Message-----
> From: ~~~i LeoNid ~~ [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 8:18 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] something wrong w/ ereg() ?
> 
> 
> Are people here aware of specific implementation of all 
> ereg~() functions?
> It seemed, they didn't work for relatively complex 
> comparisons (with long
> strings) at least on Windows95. 
> 
> Some of thier calls complain about about reg_expressions, like "?"
> qualifiers, etc, some expressions - are not interpreted, as 
> intended, and
> for some - script even goes into stall without warning (never 
> returns from
> it nor crash!)
> 
> When I replace ereg~() with matching preg~() everything works, as
> designed. I now even replace ereg~() for simple calls, where it works,
> just in case.
> 
> Anybody has the same experience?
> --
> LeoN     to  e-mail: cut  "auto_no." if present. 
> (.±.)  ` to think - is to speak quietly,  to speak - is to 
> think aloud`
>  \~/     
> My posted articles archive: http://leo.portland.co.uk/doc00.htm
> 
> 
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 




Hello,
        I went through the same problems but got some help from a coworker.  Oliver 
was right about the user ID.  what you can do is change the .exe to an ActiveX.dll COM 
object.  Then add it to
a MTS package component.  MTS can be installed off the NT4 Option Pack (downloadable 
from MS).
then just expand the computers folder, expand computer icon, right click and add a 
package, set the package to run under a given UserID.  then expand the package icon, 
expand components folder, and drag and drop (copy and paste does not work) the .dll to 
the component folder.  MTS will then register the .dll on the server.  then 
createobject the desired Class using php and you're on your way.  MTS will run the 
object under your specified UserID.

When building the .dll, make sure you set the MTSTransaction property to NEW 
TRANSACTION and
set the .dll property in MTS to NEW TRANSACTION.  This creates a new process for the 
COM object
on the server using your specified UserID.

I am using NT4.0 and IIS and VB6.0. I'm pretty sure MTS can run on its own and does 
not require IIS.

Why did I do this?  I am pulling appointments out of Outlook calendars which requires 
vb or c++ 
to access Outlook. 

Hope this helps.

-----Original Message-----
From: zugut [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 5:28 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Exec() In Windows


Hi,

I have the same problem, I don't understand the problem.



"Keith Stevenson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> Im having a Problem running an application from a PHP page using the
> Exec() function (as well as all the other program execution fuctions) on a
> Windows NT Server running Apache.
>
> The code I attempt to run is : $ReturnVal = exec("Application.exe");
>
> It returns with Unable to Fork....
>
> Does any body have any idea on how to fix this or an alternative so I can
> just run the damm application....
>
> Cheers
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




It's a bit long... and it's bastardized in that there are a number of lines
commented out because I'm experimenting.  The following code gives me a list
of customers to choose from.  It works now, but I wanted to make sure I get
at least ONE result.  If not I want to kick back an error.  If there is a
better IF statement I can use to make sure I have at least one result, that
would be fine too.



        //start our SQL
        
        $sql_search = "SELECT CUSTID_NUM, CUST_NAME, CUST_ADDR1, CUST_ADDR2,
CUST_CITY, CUST_PHONE FROM cfull2.tbl_dl_customers ";
        
        //determine what kind of search we're doing with an if, elseif and
else 

    if ( $input_cust_name && $input_address ) {  //SEARCH using both name
and address
        
            if ( $debug ) {                           //DEBUG
                        echo "\n<br />DEBUG: Searching using both name and
address<br />\n";
                }
                
                $sql_search .= "WHERE UPPER(CUST_NAME) LIKE
UPPER('%$input_cust_name%') AND UPPER(CUST_ADDR1) LIKE
UPPER('%$input_address%')";
        
        }
        
        
        elseif ( $input_cust_name )  {               //SEARCH using only
customer name

            if ( $debug ) {                          //DEBUG
                        echo "\n<br />DEBUG: Searching using just name<br
/>\n";
                }
                
                $sql_search .= "WHERE UPPER(CUST_NAME) LIKE
UPPER('%$input_cust_name%')";
        
        }
        
        
        else {                                       //SEARCH using address

            if ( $debug ) {                          //DEBUG
                        echo "\n<br />DEBUG: Searching using just address<br
/>\n";
                }
                
                $sql_search .= "WHERE UPPER(CUST_ADDR1) LIKE
UPPER('%$input_address%')";
        
        }
        
        
        $sql_search .= " ORDER BY CUST_NAME";
        
        
        // $stmt_search will now contain a statement handle which is ready
to execute
      $stmt_search = OCIParse ( $connection , $sql_search );
        
        OCIDefineByName( $stmt_search , "CUSTID_NUM" , $CUSTID_NUM );
        OCIDefineByName( $stmt_search , "CUST_NAME" , $CUST_NAME );
        OCIDefineByName( $stmt_search , "CUST_ADDR1" , $CUST_ADDR1 );
        OCIDefineByName( $stmt_search , "CUST_ADDR2" , $CUST_ADDR2 );
        OCIDefineByName( $stmt_search , "CUST_CITY" , $CUST_CITY );
        OCIDefineByName( $stmt_search , "CUST_PHONE" , $CUST_PHONE );


      OCIExecute ( $stmt_search , OCI_DEFAULT );


        //$nrows = OCIFetchStatement( $stmt_search , $results );
        //echo "<P>There are $nrows records containing your criteria.</P>";

        
      //if ( $nrows > 0 ) {
        echo "<TABLE BORDER=\"0\" width=\"100%\">\n";
        echo "<TR>\n";
        echo "<TD>Name</TD><TD>Address</TD><TD>City</TD><TD>Phone</TD>\n";
        echo "</TR>\n";

        //for ( $i = 0; $i < $nrows; $i++ ) {
          //reset($results);
                        while ( OCIFetchInto ( $stmt_search , $results ) ) {

                        
                        //format the phone number
                                $CUST_PHONE = format_phone ( $CUST_PHONE );
                        
                echo "<TR>\n";
              
                //$data = $column['value'];
                echo "<TD><a
href=\"dl_post_2.php?input_customer=$CUSTID_NUM\">";
                                echo "$CUST_NAME</a></TD>";
                                echo "\n<TD>$CUST_ADDR1 <br>
$CUST_ADDR2</TD> \n";
                                echo
"<TD>$CUST_CITY</TD>\n<TD>$CUST_PHONE</TD>\n";
            
                        echo "</TR>\n";
                        }
        //}
     echo "</TABLE>\n";
     //}  

     //else {
      //   echo "<h2>Unable to locate any customers with that search
criteria.</h2><BR>\n";
     //}
          
          
          //free resources
      OCIFreeStatement ( $stmt_search );



---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aut insanit homo, aut versus facit


> -----Original Message-----
> From: Florian Clever [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 2:21 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-WIN] Oracle record counting
> 
> 
> Hi John,
> 
> your first example looks right. Can you send us the code you 
> use to list
> the records. I would expect the problem in there, because in 
> your second
> example basically the FetchStatement is not doing anything as the
> statement has not been executed.
> You need to loop through the result set array differntly after the
> FetchStatement, then looping through the results without exec.
> 
> BTW: I had performance drops with the FetchStatement.
> 
> Florian
> 
> 
> Von: 
>         "Asendorf, John" <[EMAIL PROTECTED]>
>                                                               
>         Mi
> 20:35
> 
>  Betreff: 
>         Oracle record counting
>      An: 
>         "Php-Windows (E-mail)" <[EMAIL PROTECTED]>
> 
> 
> 
> I'm attempting to work on a little oracle search...
> 
> My problem is that if I put the OCIExecute BEFORE the 
> OCIFetchStatement
> line, I get one error ( Warning: OCIFetchInto: ORA-01002: fetch out of
> sequence in d:\InetPub\wwwroot\etc. ) but if I put OCIExecute 
> AFTER the
> OCIFetchStatement I get a different error (Warning: OCIFetchStatement:
> ORA-24338: statement handle not executed in ).
> 
> In this order:
> 
> OCIExecute ( $stmt_search , OCI_DEFAULT );
> $nrows = OCIFetchStatement( $stmt_search , $results );
> echo "<P>There are $nrows records containing your criteria.</P>";
> 
> I get the number of records, but the I don't get the reords listed.
> 
> 
> 
> In this order:
> 
> $nrows = OCIFetchStatement( $stmt_search , $results );
> echo "<P>There are $nrows records containing your criteria.</P>";
> OCIExecute ( $stmt_search , OCI_DEFAULT );
> 
> I get the list of records, but no amount of records...  I 
> tried running
> a
> reset( $results); on it but that didn't seem to help...
> 
> Can someone help?  Oracle 8.1.6 client (7.3.4 server) NT4 
> IIS4 PHP 4.0.4
> CGI
> 
> Thanks,
> 
> John
>         
> 
> ---------------------
> John Asendorf - [EMAIL PROTECTED]
> Web Applications Developer
> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> Licking County, Ohio, USA
> 740-349-3631
> Aut insanit homo, aut versus facit
> -- 
> 
> Florian Clever
> 
> [EMAIL PROTECTED]
> http://www.Clever-Software-Solutions.de/
> 
> PGP Key @ ldap://certserver.pgp.net/
> 
> "Always listen to experts. They'll tell you what can't be 
> done, and why.
> Then do it. " -- Robert A. Heinlein
> 
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 




Problem solved! Thank you for pointing me to error.log!

It read
[Wed Apr 04 17:11:55 2001] [error] [client 127.0.0.1] File does not exist: 
c:/program files/apache group/apache/htdocs/php4/php.exe/test1.php

Note the peculiar path.

Now I looked in httpd.conf:

ScriptAlias /php4/ "C:/PHP4/"
AddType application/x-httpd-php4 .php
Action application/x-httpd-php4 "/PHP4/php.exe"

I made PHP4 in the last line lower case and that did the trick!

Thanks again, Marco

At 10:33 5-4-01 +0900, Yasuo wrote:
>Hello Marco,
>
>How about post again with following info.
>
>- your OS and Version
>- your Apache version
>- exact error messages you've got in apache error log.
>- your PHP version and its API (CGI or SAPI)
>- your httpd.conf that relates to PHP (See PHP Manual what configuration
>directives are related to PHP.)
>
>I might be able to help you as well as others might.
>
>Regards,
>--
>Yasuo Ohgaki

At 21:26 4-4-01 -0500, Gaylen wrote:
>It sounds like you may not have associated the php extension with PHP in
>Apache.  Have you?


>----- Original Message -----
>From: "Marco Bleeker" <[EMAIL PROTECTED]>
>To: "Yasuo Ohgaki" <[EMAIL PROTECTED]>
>Sent: Thursday, April 05, 2001 12:14 AM
>Subject: Re: [PHP-WIN] Apache no see PHP
>
>
> > At 10:23 4-4-01 +0900, you wrote:
> > >Do you have
> > >
> > >DirectoryIndex index.html index.php
> > >
> > >in your httpd.conf?
> >
> > It did not list index.php, just index.html. I have put index.php in it now,
> > but that did not help much. Now I get the not found (404) error
> > immediately, instead of the directory listing. Problem is not just with
> > index.php but with all .php files. None of them are found in MSIE 5.5
> >
> > Marco
> >

|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
| Attachments only after prior notice please.
| Don't put me on any kind of mailing list.
|
| I am now receiving the Snowhite virus 4x a day
| - some of you must be infected, please check !
| (No, you did not get it from me, I use Eudora)
|     __@
|   _`\<,_
|__(*)/ (*)________________Ah, op DIE fiets !






Hi John,

I see in your code that currently you are using 
while ( OCIFetchInto ( $stmt_search , $results ) ) {
and 
        //for ( $i = 0; $i < $nrows; $i++ ) {
          //reset($results);
                //$data = $column['value'];
is not being used.
But you are actually using the variables for which you did a 
OCIDefineByName to print out the data. I would say that a 
FetchIntoStatement will not be able fill these variables as it operates on 
the complete result set. Thus you have to pull the data from the array.
When you use FetchInto the defined variables can be filled as PHP and 
Oracle then do actually know which row you are currently pointing to, as 
FetchInto moves to the next record.
FetchIntoStatement fetches all rows, thus it is not pointing to a specific 
row.

Let me know what you get. Maybe it would be good to add a note about this 
to the Manual

Florian






"Asendorf, John" <[EMAIL PROTECTED]>
05.04.01 14:19

 
        An:     Florian Clever <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
        Kopie: 
        Thema:  RE: [PHP-WIN] Oracle record counting


It's a bit long... and it's bastardized in that there are a number of 
lines
commented out because I'm experimenting.  The following code gives me a 
list
of customers to choose from.  It works now, but I wanted to make sure I 
get
at least ONE result.  If not I want to kick back an error.  If there is a
better IF statement I can use to make sure I have at least one result, 
that
would be fine too.



                 //start our SQL
 
                 $sql_search = "SELECT CUSTID_NUM, CUST_NAME, CUST_ADDR1, 
CUST_ADDR2,
CUST_CITY, CUST_PHONE FROM cfull2.tbl_dl_customers ";
 
                 //determine what kind of search we're doing with an if, 
elseif and
else 

    if ( $input_cust_name && $input_address ) {  //SEARCH using both name
and address
 
                     if ( $debug ) {                           //DEBUG
                                                 echo "\n<br />DEBUG: 
Searching using both name and
address<br />\n";
                                 }
 
                                 $sql_search .= "WHERE UPPER(CUST_NAME) 
LIKE
UPPER('%$input_cust_name%') AND UPPER(CUST_ADDR1) LIKE
UPPER('%$input_address%')";
 
                 }
 
 
                 elseif ( $input_cust_name )  {               //SEARCH 
using only
customer name

                     if ( $debug ) {                          //DEBUG
                                                 echo "\n<br />DEBUG: 
Searching using just name<br
/>\n";
                                 }
 
                                 $sql_search .= "WHERE UPPER(CUST_NAME) 
LIKE
UPPER('%$input_cust_name%')";
 
                 }
 
 
                 else {                                       //SEARCH 
using address

                     if ( $debug ) {                          //DEBUG
                                                 echo "\n<br />DEBUG: 
Searching using just address<br
/>\n";
                                 }
 
                                 $sql_search .= "WHERE UPPER(CUST_ADDR1) 
LIKE
UPPER('%$input_address%')";
 
                 }
 
 
                 $sql_search .= " ORDER BY CUST_NAME";
 
 
                 // $stmt_search will now contain a statement handle which 
is ready
to execute
      $stmt_search = OCIParse ( $connection , $sql_search );
 
                 OCIDefineByName( $stmt_search , "CUSTID_NUM" , 
$CUSTID_NUM );
                 OCIDefineByName( $stmt_search , "CUST_NAME" , $CUST_NAME 
);
                 OCIDefineByName( $stmt_search , "CUST_ADDR1" , 
$CUST_ADDR1 );
                 OCIDefineByName( $stmt_search , "CUST_ADDR2" , 
$CUST_ADDR2 );
                 OCIDefineByName( $stmt_search , "CUST_CITY" , $CUST_CITY 
);
                 OCIDefineByName( $stmt_search , "CUST_PHONE" , 
$CUST_PHONE );


      OCIExecute ( $stmt_search , OCI_DEFAULT );


                 //$nrows = OCIFetchStatement( $stmt_search , $results );
                 //echo "<P>There are $nrows records containing your 
criteria.</P>";

 
      //if ( $nrows > 0 ) {
        echo "<TABLE BORDER=\"0\" width=\"100%\">\n";
        echo "<TR>\n";
        echo "<TD>Name</TD><TD>Address</TD><TD>City</TD><TD>Phone</TD>\n";
        echo "</TR>\n";

        //for ( $i = 0; $i < $nrows; $i++ ) {
          //reset($results);
                                                 while ( OCIFetchInto ( 
$stmt_search , $results ) ) {

 
                                                 //format the phone number
 $CUST_PHONE = format_phone ( $CUST_PHONE );
 
                         echo "<TR>\n";
 
                //$data = $column['value'];
                echo "<TD><a
href=\"dl_post_2.php?input_customer=$CUSTID_NUM\">";
                                                                 echo 
"$CUST_NAME</a></TD>";
                                                                 echo 
"\n<TD>$CUST_ADDR1 <br>
$CUST_ADDR2</TD> \n";
                                                                 echo
"<TD>$CUST_CITY</TD>\n<TD>$CUST_PHONE</TD>\n";
 
                                         echo "</TR>\n";
                                                 }
        //}
     echo "</TABLE>\n";
     //} 

     //else {
      //   echo "<h2>Unable to locate any customers with that search
criteria.</h2><BR>\n";
     //}
 
 
                   //free resources
      OCIFreeStatement ( $stmt_search );



---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aut insanit homo, aut versus facit


> -----Original Message-----
> From: Florian Clever [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 2:21 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-WIN] Oracle record counting
> 
> 
> Hi John,
> 
> your first example looks right. Can you send us the code you 
> use to list
> the records. I would expect the problem in there, because in 
> your second
> example basically the FetchStatement is not doing anything as the
> statement has not been executed.
> You need to loop through the result set array differntly after the
> FetchStatement, then looping through the results without exec.
> 
> BTW: I had performance drops with the FetchStatement.
> 
> Florian
> 
> 
> Von: 
>         "Asendorf, John" <[EMAIL PROTECTED]>
> 
>         Mi
> 20:35
> 
>  Betreff: 
>         Oracle record counting
>      An: 
>         "Php-Windows (E-mail)" <[EMAIL PROTECTED]>
> 
> 
> 
> I'm attempting to work on a little oracle search...
> 
> My problem is that if I put the OCIExecute BEFORE the 
> OCIFetchStatement
> line, I get one error ( Warning: OCIFetchInto: ORA-01002: fetch out of
> sequence in d:\InetPub\wwwroot\etc. ) but if I put OCIExecute 
> AFTER the
> OCIFetchStatement I get a different error (Warning: OCIFetchStatement:
> ORA-24338: statement handle not executed in ).
> 
> In this order:
> 
> OCIExecute ( $stmt_search , OCI_DEFAULT );
> $nrows = OCIFetchStatement( $stmt_search , $results );
> echo "<P>There are $nrows records containing your criteria.</P>";
> 
> I get the number of records, but the I don't get the reords listed.
> 
> 
> 
> In this order:
> 
> $nrows = OCIFetchStatement( $stmt_search , $results );
> echo "<P>There are $nrows records containing your criteria.</P>";
> OCIExecute ( $stmt_search , OCI_DEFAULT );
> 
> I get the list of records, but no amount of records...  I 
> tried running
> a
> reset( $results); on it but that didn't seem to help...
> 
> Can someone help?  Oracle 8.1.6 client (7.3.4 server) NT4 
> IIS4 PHP 4.0.4
> CGI
> 
> Thanks,
> 
> John
> 
> 
> ---------------------
> John Asendorf - [EMAIL PROTECTED]
> Web Applications Developer
> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> Licking County, Ohio, USA
> 740-349-3631
> Aut insanit homo, aut versus facit
> -- 
> 
> Florian Clever
> 
> [EMAIL PROTECTED]
> http://www.Clever-Software-Solutions.de/
> 
> PGP Key @ ldap://certserver.pgp.net/
> 
> "Always listen to experts. They'll tell you what can't be 
> done, and why.
> Then do it. " -- Robert A. Heinlein
> 
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 






What needs to be installed for COM say Office COMS to work.  What external
programs you need installed for say excel and word.  Anything in the
php.ini.  Anything else please let me know.

Ryan




Check:
http://www.phpbuilder.com/columns/alain20001003.php3
and for Excel:
http://phpclasses.upperdesign.com/browse.html?package=86

One thing, to remember is that since PHP is server side only, you can't
expect it to open a COM object on the client side...
Also, multiple errors may fill up the process list  because for every time
the script crashes
you have an instance of the COM object sitting there. You need to clean-up
before any new try.

 Message from Alain Samoun
[EMAIL PROTECTED]

-----Original Message-----
From: Conover, Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 6:31 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] COM


What needs to be installed for COM say Office COMS to work.  What external
programs you need installed for say excel and word.  Anything in the
php.ini.  Anything else please let me know.

Ryan

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]





If I have an excel document I created dynamically and after every 8 records
I want it to automatically want to print.  Is there a way to do this in PHP
or some other language.

Ryan Conover




I receive the following error on my NT 4.0 srerver box
with NTFS.

Warning: Failed opening 'index1.htm' for inclusion (include_path='') in
E:\users\cstone\index.php on line 47

Any ideas why I cannot create a new file, but can read an existing one. I
have tried different perms settings.


Regards

George





I get the following error on everypage of 

X-Powered-By: PHP/4.0.4pl1 Content-type: text/html 
and PHP Warning: Cannot open './browscap/browscap.ini' for reading in
Unknown on line 0 
Please help.

ryan Conover



Reply via email to