[PHP-DB] Oracle 8i Client URL

2001-02-20 Thread Randall Barber
client, etc..) It may ask you for a log on and password. Apparently the membership is free, just sign up and you will have no troubles. Hope this helps, Randall Barber P.S. - I previously posted that the client was under the 8i personal edition, that is false, it was found under the 8i

[PHP-DB] 2-Table query

2001-04-09 Thread Randall Barber
I would like to update two tables at the same time. Currently I update each one separately, like so, $qryStr = "INSERT INTO table1 etc"; odbc_exec($dbConn, $qryStr); $qryStr = "INSERT INTO table2 etc"; odbc_exec($dbConn, $qryStr); Now, the problem there is if the first one passes, but

[PHP-DB] Only part of a field SQL

2001-04-11 Thread Randall Barber
Our Xerox production printers export a log in ':' delimited format. No big deal, except that each field has a tag like so: Job ID = 99 Job ID = 98 Job ID = 97 See what I mean? I have simply imported the whole CSV file into Access and was now wondering if I could do the

[PHP-DB] Uploading Files

2001-05-24 Thread Randall Barber
I have a NAGGING file upload problem. Details: Win2k, IIS5, PHP v4.0.4 As I understand this system, PHP uploads all files to a temporary place on disk. From there you can move them anywhere you want to. Well here's the scenario: Users are allowed to upload PRN files. Once uploaded I have

[PHP-DB] Images from database

2001-07-10 Thread Randall Barber
I have seen in several places the following line: img src='myScript.php' etc..etc.. Will this tag work in both IE and Netscape? What does myScript.php do? Does it find an image and pass the binary data back? Something like this-- ?php // Code to find get a path from a database $fp =

[PHP-DB] Persistent Connections

2001-11-20 Thread Randall Barber
Howdy--I have a question about persistent connections and their behavior: Apache 1.3.2 / PHP 4.0.6 - as a module Win2k I call the following function: odbc_pconnect(dsn, user, pass); At the end of the script I do NOT call odbc_close($dbConn); I was doing some testing and ran into a: Maximum

[PHP-DB] OCI8 Function Clarification

2002-01-09 Thread Randall Barber
I have a simple SELECT statement that returns more than one row. When I do something like this: do { . } while (OCIFetch($qryResult) != false); I get an Out of sequence error on OCIFetch. So then I tried this: $numRows = OCIRowCount($qryResult); for($i = 0; $i $numRows; $i++) {