Try using the query:
$db-query(update SERVER set Token = '$intoken' where IPAddress
='192.168.1.100');
You are trying to update all rows with $intoken, where the column Token is
unique.
Regards,
Neil Morgan
-Original Message-
From: Prashant Prabhudesai [mailto:pprab...@cisco.com]
Guys,
Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5.
The following piece of code works with a CLOB, but not with an NCLOB. Can
anyone shed any light please?
$SQL =
UPDATE $d_sid.srs_spd SET spd_fuld = EMPTY_CLOB()
WHERE spd_stuc = :stuc AND spd_seqn = :seqn
Lester,
Thanks for the advice, I tried to run this on a 5.2.17 install as well with the
same results.
Thanks anyway,
Neil
-Original Message-
From: Lester Caine [mailto:les...@lsces.co.uk]
Sent: 05 August 2011 17:08
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Oracle NClobs
I find that using single quotes rather than double quotes prevents
variable substitution.
I don't know if this is an undocumented feature, as the documentation
says that both have the same functionality.
Regards,
Neil
-Original Message-
From: Mark Casson [mailto:confu...@icube.co.uk]
Adam,
Have you tried oci_pconnect() instead of ocilogon()?
Also, I have encountered some issues on Win32 with the instant client
and PHP5.
Try installing the full client and testing again.
Neil Morgan
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: 24 November
Ritesh,
Don't know of a suitable XML database to use with PHP, but I could
recommend using Oracle 10g. There are built in XML services that should
help with your project. Furthermore, PHP has a well documented Oracle
interface (OCI8) just for this. To handle the XML though, you would
probably
You may want to check the max_execution_time directive in php.ini
Neil
-Original Message-
From: Iulian Manea [mailto:[EMAIL PROTECTED]
Sent: 21 April 2006 01:33
To: php-db@lists.php.net
Subject: [PHP-DB] Php in the twilight zone!
Hey everybody,
For about the last 7 hours I am
From the manual:
ORA-00600 internal error code, arguments: [string], [string], [string],
[string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program
exceptions. It indicates that a process has encountered a low-level,
unexpected
Hi All,
Does anyone out there run PHP5 on Solaris 9 with Instant Client 10.1 for
Oracle? Are there any known issues with compiling OCI support?
Regards,
Neil Morgan MSc
Analyst Programmer
Admin Computing
University of Brighton
T: +44 (0) 1273 64 3930
F: +44 (0) 1273 64 2666
Try sprintf().
-Original Message-
From: mayo [mailto:[EMAIL PROTECTED]
Sent: 27 May 2005 14:02
To: php-db@lists.php.net
Subject: [PHP-DB] printf() in a variable, or alternative to
I need to be able to format data.
Printf() is perfect because I need a certain amount of characters
Sorry, trigger happy. Also try :postalcode in uppercase.
Neil
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 12:18
To: 'php-db@lists.php.net'
Subject: [PHP-DB] OCI Binding problem
Hi,
Imagine this code:
?php
$database_connection =
Jos,
This may or may not sort out the problem, but OCI_ASSOC |
OCI_FETCHSTATEMENT_BY_ROW should be OCI_ASSOC+OCI_FETCHSTATEMENT_BY_ROW.
Neil
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 12:18
To: 'php-db@lists.php.net'
Subject: [PHP-DB] OCI
http://www.fpdf.org
I swear by it as well.
Neil Morgan
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: 06 April 2004 03:39
To: PHP-DB Mailing List
Subject: Re: [PHP-DB] PDFLib
I LOVE FPDF. I don't know where I found it, but I can insert images, it
wraps text
I have had similar problems before. I have just created your table in
MySQL. Seems you can't have an AUTO_INCREMENT column that is UNSIGNED.
Doesn't mention this in the manual though.
Neil Morgan
-Original Message-
From: js [mailto:[EMAIL PROTECTED]
Sent: 21 January 2004 22:34
To:
You could try sqlite. http://www.sqlite.com/ would give you more details on
sqlite, http://hu.php.net/sqlite is the PHP manual pages for the sqlite
extension (PHP4). You can download the php_sqlite.dll extension for windows
here as well.
Neil Morgan
-Original Message-
From: GUIRAUDOU
You could try ODBC instead.
Neil Morgan
-Original Message-
From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED]
Sent: 16 December 2003 05:45
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Max DB as Database for PHP
Hello,
Has anyone tried to connect to MaxDB with PHP ?
is register_globals set to off in php.ini?
this may be the issue if it is set to on.
-Original Message-
From: Jas [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 22:50
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sql errors?
I have checked and rechecked my code on these php to mysql
put the schema name before the sequence object you need to increment, i.e.
$sql = select SCHEMA.TEAM_SEQ.NEXTVAL as \nextval\ from sys.dual;
Regards,
Neil Morgan
-Original Message-
From: Paul Miller [mailto:[EMAIL PROTECTED]
Sent: 12 December 2003 00:05
To: [EMAIL PROTECTED]
Subject:
$keywords = str_replace(' ','%',$keywords);
select * from table where data like %keywords%;
-Original Message-
From: Hadi [mailto:[EMAIL PROTECTED]
Sent: 12 December 2003 13:21
To: [EMAIL PROTECTED]
Subject: [PHP-DB] anyone trickier than 'LIKE' ?
Hi all,
I have this data (eg.)
A simple thing, but do you have wrte permission on your drive F: from the
web server?
-Original Message-
From: Karen Resplendo [mailto:[EMAIL PROTECTED]
Sent: 23 October 2003 22:18
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Can't copy file to another server
Nope.
Hi,
Has anyone out there using PHP and Oracle come across this problem? I have
a text area that allows free-form text that I store in a varchar2 column. I
have problems with apostrophes in the free-form text. When users put in an
apostrophe the SQL fails. If I force 3 apostrophes (the usual
21 matches
Mail list logo