RE: [PHP-DB] Oracle CLOBs and carriage returns

[Brian Dunworth]

On Thursday, August 09, 2001 at 2:09 PM, Tom Tsongas said: 
 Here is the code I am using:
 
 $sql_comments = OCIParse($connection,SELECT COMMENTS FROM INCIDENT
 WHERE INCIDENT='$incident');
 OCIExecute($sql_comments);
 while ( OCIFetchInto($sql_comments, $row, 
 OCI_ASSOC+OCI_RETURN_NULLS)) {
 
 $lob_data = $row[COMMENTS]-load();
 echo $lob_data;
 }
 
 I know the information is stored correctly since a SQL query from the
 command line works properly and all formatting is displayed.
 
 Any thoughts?

echo nl2br($lob_data);


 - Brian

 --- 
  Brian S. Dunworth
  Sr. Software Development Engineer
  Oracle Database Administrator
  The Printing House, Ltd.
  (850) 875-1500 x225
 --- 

-- 
PHP Database 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]

RE: [PHP-DB] PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)

[Brian Dunworth]

 On Thursday, July 26, 2001 at 9:48 PM, Sommai Fongnamthip said:

 I have oracle 8i in Linux server.  How could I 
 connect it with PHP (on other server)?

  Install the Oracle Client software (on the other server).



 --- 
  Brian S. Dunworth
  Sr. Software Development Engineer
  Oracle Database Administrator
  The Printing House, Ltd.
  (850) 875-1500 x225
 --- 


-- 
PHP Database 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]

RE: [PHP-DB] Counting Number of Instances in a One2Many Relationships

[Brian Dunworth]

On Monday, July 23, 2001 at 9:54 PM (ahem, set your clock!), Mike Gifford
said:

 I'd like a simple query to determine how MANY books in a
 database are released by A publisher.
 [...]
 The relevant table's here:

 CREATE TABLE WLPbib (
   bibID mediumint(9) NOT NULL,
   languageID varchar(5),
   publisherID mediumint(9),
   categoryID smallint(6),
   type varchar(55),
   title varchar(255),
   pageNumber varchar(55),
   source_bibID varchar(55),
   publicationDate varchar(5),
   dateAdded date,
   publishedLanguage varchar(5),
   URL varchar(100),
   status varchar(5),
   PRIMARY KEY (bibID)
 );

 Suggestions are appreciated!

   SELECT publisherID,count(*) FROM WLPbib GROUP BY publisherID;


 - Brian

 ---
  Brian S. Dunworth
  Sr. Software Development Engineer
  Oracle Database Administrator
  The Printing House, Ltd.
  (850) 875-1500 x225
 ---


-- 
PHP Database 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]