[PHP-DB] Trouble with Phakt and Select statements

2004-08-31 Thread Seader, Cameron
ht be. Thanks, Cameron Seader Also some more information from my error_log for apache.= Undefined property: table in /srv/www/htdocs/ORS/_mmServerScripts/ADO= DB.php on line 403 [Tue Aug 31 12:27:10 2004] [error] PHP Notice: Undefined property: numeric in /srv/www/htdocs/ORS/_mmServerSc

RE: [PHP-DB] Re: ODBC_Connect error message

2004-08-29 Thread Seader, Cameron
My Problem ended up being that i was compileing a 64 bit php with 32 bit libraries for DB2, once i was able to get the 64 bit libraries for DB2 and compile php it worked just fine after that. -Cameron -Original Message- From: Anni Hienola [mailto:[EMAIL PROTECTED] Sent: Thursday, August

[PHP-DB] ODBC_Connect error message

2004-08-18 Thread Seader, Cameron
-db2=/home/db2admin/sqllib --enable-bcmath --with-zlib=yes So i have DB2 support with DB2 Connect installed on SUSE. It has worked before on a RedHat 7.2 OS on s390x platform. Does anyone have any idea what the SQL state ÿÿÿþ means? TIA, Cameron Seader [INFO] -- Access Manager: This

[PHP-DB] multiple queries

2003-12-01 Thread Cameron Showalter
get it pull from the db, it does what it is suppose to do and decrement/increments $flash/$date. I guess my question is, how do I get $minusX, etc. to reflect what is in my db. thanks, cameron

[PHP-DB] To slash or not to slash....

2003-09-02 Thread Craig Cameron
Ok simple problem I hope. Have the following code, used to store the location and a few details about meeting minutes. $connection = mssql_connect("server","user","password"); mssql_select_db("DocumentManager",$connection); $AlteredMinu

[PHP-DB] undefined function: mysql_pconnect()

2003-03-01 Thread Cameron
I'm new to this stuff, so you have to excuse me if I seem dense. I can't get MySQL base operation from PHP 4.22 under RedHat Linux 8.0. I get the following error when trying to use mysql_connect(). "Call to undefined function: mysql_pconnect()" I don't have any other PHP running on the box, oth

Re: [PHP-DB] Sybase_Connect

2003-01-21 Thread Cameron
ry and is named exactly as it is up above AHH!!! WHAT DO I DO!? - Original Message - From: "Buics" <[EMAIL PROTECTED]> To: "Cameron Powell" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 5:52 PM Subject: Re: [PHP-DB] Syba

[PHP-DB] Sybase_Connect

2003-01-20 Thread Cameron Powell
Im trying to figure out Sybase and I cant even seem to get past the first step of connecting Heres my code: Heres the error: Fatal error: Call to undefined function: sybase_connect() in F:\Program Files\Apache Group\Apache\htdocs\index.php on line 8 -- PHP Database Mailing List (http://www.php

[PHP-DB] Replacing records

2002-04-07 Thread Andrew Cameron
on is making the DB side of things a bit tricky. Can anyone help be with some more specific instructions on what I need to do? I'm on PHP 4.0.5 if that helps. Thanks in advance, Andrew Cameron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Ordering titles in MySQL (long)

2001-11-01 Thread Cameron Metcalf
days learning BASIC on 2K radio shack computers. be assured though, the following does work for me. I came up with this solution thanks to olinux who forwarded me the URL for this article: http://phpbuilder.com/columns/clay19990421.php3 which even includes a list of "noisewords" for yo

[PHP-DB] Re: MySQL: alphabetizing, skipping "the ", "a "

2001-06-25 Thread Cameron Metcalf
script above? the above query was built on a coding solution I found at http://www.bitmechanic.com/mail-archives/mysql/May1998/0713.html *mysql: select statements that ignore "the "* Cameron -- 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] do table alias's work in PHP?

2001-05-16 Thread cameron walker
Since it works for you then it MUST be a version thing. How odd that it works from the command line. It would have been a pain to do an upgrade just to find out the problem didnt go away. I appreciate your taking the time to test it for me. Thanks again Johannes Janson wrote: > I'm not

Re: [PHP-DB] do table alias's work in PHP?

2001-05-16 Thread cameron walker
[EMAIL PROTECTED] (cameron walker) wrote: > > > Now I am using a shareware version which, perhaps, is buggy: > > 3.22.24-shareware-debug > > Given that MySQL is currently well into the 3.23.* series, getting an > upgrade would certainly be a good place to sart. As fo

Re: [PHP-DB] do table alias's work in PHP?

2001-05-16 Thread cameron walker
My specific return is Couldnt execute query : select dtype, dloc, iprice from descriptions d, items i where d.iid = i.iid ; If I reduce this to select dtype, dloc, iprice from descriptions d, items where descriptions.iid = items.iid; I

[PHP-DB] do table alias's work in PHP?

2001-05-16 Thread cameron walker
The following statement will not work: $sql = "select * from sometable t1, sometable t2 where t1.field1 = t2.field2"; Reason being that the PHP doesnt appear to be able to handle the table alias's t1 and t2. Since I have to do a self-join to make my real code work properly I really need for this

Re: [PHP-DB] MySQL database transfer

2001-02-22 Thread Cameron Metcalf
open up the database in the Linux environment.. any suggestions? Cameron > To contact the list administrators, e-mail: [EMAIL PROTECTED] Andrew Apold wrote: > > At 03:24 AM 2/22/01 -, Sridhar Ranganathan wrote: > >Hi > > > >I have mysql on linux and windo

[PHP-DB] Suppressing NULL values in search results

2001-02-19 Thread Cameron Metcalf
. Direct solutions would be appreciated or even if you could suggest a name/terminology for this problem, because I've been unable to turn anything up in the archives/printed literature. Thanks for your time. Cameron Search Results $base[0]Date Range: $base[1]Access

[PHP-DB] case insensitive search

2001-02-10 Thread Cameron
im trying to do a case insensitive search in pgsql with a "WHERE blah LIKE '%blah%'" the problem is that currently if something contains Blah not just blah it wont return that. suggestion? i know i can suck out every row and then eregi them but that is majorly slow and ineff

[PHP-DB] pgsql performance

2001-02-05 Thread Cameron
little and played with things to make it faster, i was wondering if there are any tips to pgsql? i didnt think pgsql was that slow :( Cameron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

[PHP-DB] mysql to pgsql

2001-02-03 Thread Cameron
into that field contact_date datetime DEFAULT '-00-00 00:00:00' NOT NULL Cameron -- 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]

[PHP-DB] mysql database replication

2001-01-19 Thread Cameron Harr
newer versions of mysql allow for database replication. However the client (php in this case) needs to be aware that all read requests can go to slaves or masters. However all write request must go to the master. is there a way to set this up in PHP? thanks nate -- PHP Database Mailing List (ht