Re: [PHP-DB] Easy reg expression problem

2004-07-16 Thread Tim Van Wassenhove
In article [EMAIL PROTECTED], Jason Wong wrote: On Friday 16 July 2004 08:05, Justin Patrin wrote: If you're simply trying to get '@email.com' then use strstr(). Of courseI'm just so used to pregs... Well the advantage of using a regex is that you can perform some form of

[PHP-DB] oracle error ORA-12154

2004-07-16 Thread Adam Williams
Hi, I'm trying to connect to an oracle 9.20 database using: $conn = OCILOGON(dah50,dah50,zed2.aleph0); but I get the error ORA-12154 Searching on google says my listener.ora or tnsnames.ora may have problems, but I think mine are correct. Can someone take a look and see if they are ok?

[PHP-DB] PHP and RedBack COM objects

2004-07-16 Thread Brian E
Hello. I'm trying to access RedBack COM objects (Redback is a garbage DB that one of my clients has purchased) through PHP rather than documented ASP. I can Create the objects just fine and make the initial Calls to the methods... but when I try to view the String results, I get Object types

[PHP-DB] Database design for calendar

2004-07-16 Thread Arnout Boks
Hi, I'm currently working on a php-based community website for my school class. Part of that website is a calendar function that includes the dates of all testpapers, birthdays, school parties and so on... Of course, a testpaper has got other properties than a birthday, so they should go into

Re: [PHP-DB] oracle error ORA-12154

2004-07-16 Thread Peter Beckman
The biggest problem with oci8 is having these four variables set: $ORACLE_SID=SOMESID $ORACLE_HOME=/home/beckman/oracle $ORACLE_BASE=/home/beckman/oracle $TNS_ADMIN=/home/beckman/oracle/network/admin If those aren't set, then things won't work. Please confirm that those environment variables

[PHP-DB] Postgres Issues

2004-07-16 Thread Jake Stride
I am having some problems with postgresql/adodb. I keep getting the following error with some of my queries that use bigserial: Warning: pg_exec(): Query failed: ERROR: operator does not exist: bigint =? HINT: No operator matches the given name and argument type(s). You may need to add explicit

[PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Galbreath, Mark A
Alls, My division at State is trying to get PHP 5.0 approved for use by developers in the Department, and the Powers That Be are requesting evidence that other Federal agencies/military are using PHP, and the extent of it's use. Anybody have a clue about this? I sure would appreciate some help!

Re: [PHP-DB] oracle error ORA-12154

2004-07-16 Thread Adam Williams
yeah I got it to work, i had to do putenv() with my oracle home dir and then my scripts started working. thanks Peter Beckman wrote: The biggest problem with oci8 is having these four variables set: $ORACLE_SID=SOMESID $ORACLE_HOME=/home/beckman/oracle $ORACLE_BASE=/home/beckman/oracle

Re: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread David Orlovich
Mark, a Google search with .php .gov turns up web pages in US government sites that use php. It's trial and error, but I see government agencies appearing here and there. HTH. David. On 17/07/2004, at 7:57 AM, Galbreath, Mark A wrote: Alls, My division at State is trying to get PHP 5.0

Re: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Larry E . Ullman
My division at State is trying to get PHP 5.0 approved for use by developers in the Department, and the Powers That Be are requesting evidence that other Federal agencies/military are using PHP, and the extent of it's use. Anybody have a clue about this? I sure would appreciate some help! I've

Re: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Karen Resplendo
http://170.104.158.16/inventory.php3 enter 00100 to get to Bend, OR water system info Galbreath, Mark A [EMAIL PROTECTED] wrote: Alls, My division at State is trying to get PHP 5.0 approved for use by developers in the Department, and the Powers That Be are requesting evidence that other

RE: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Galbreath, Mark A
Thanks, David - I'm doing that at this moment :-) -Original Message- From: David Orlovich [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 4:05 PM To: Galbreath, Mark A Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] PHP use in Federal Govt Mark, a Google search with .php .gov

Re: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread John W. Holmes
Galbreath, Mark A wrote: My division at State is trying to get PHP 5.0 approved for use by developers in the Department, and the Powers That Be are requesting evidence that other Federal agencies/military are using PHP, and the extent of it's use. Anybody have a clue about this? I sure would

Re: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Peter Beckman
I wrote an application in PHP that the Department of Housing and Urban Development uses for its Grant programs. PHP + MySQL They love it. On Fri, 16 Jul 2004, Galbreath, Mark A wrote: Alls, My division at State is trying to get PHP 5.0 approved for use by developers in the Department, and

[PHP-DB] Temporary table name

2004-07-16 Thread Rosen
Hi, I need to create temporary table in mysql. And I generate random name - i.e. TMP21567. How can I check is this name already exist in database ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Temporary table name

2004-07-16 Thread Tim Van Wassenhove
In article [EMAIL PROTECTED], Rosen wrote: Hi, I need to create temporary table in mysql. And I generate random name - i.e. TMP21567. How can I check is this name already exist in database ? SELECT COUNT(*) AS count FROM temporary_table WHERE name='TMP21567'; Probably you'll want to make the

Re: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Cole Ashcraft
The National Weather Service (Department of Commerce) uses php for many of their needs. Their main page (http://weather.gov/index.php). All warning maps are either done by PHP or perl. On Fri, 16 Jul 2004, Galbreath, Mark A wrote: Alls, My division at State is trying to get PHP 5.0

[PHP-DB] Re: Temporary table name

2004-07-16 Thread Rosen
Thanks, But is there a way to do this without additional table in which to store the names of created temporary tables ? Thanks, Rosen Tim Van Wassenhove [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], Rosen wrote: Hi, I need to create temporary table

Re: [PHP-DB] Temporary table name

2004-07-16 Thread John W. Holmes
Rosen wrote: I need to create temporary table in mysql. And I generate random name - i.e. TMP21567. How can I check is this name already exist in database ? If you're creating a true temporary table, then you don't need to worry about the name being unique. CREATE TEMPORARY TABLE tmp21567 ...

Re: [PHP-DB] Temporary table name

2004-07-16 Thread Rosen
Yes, I'm creating temporary table to store temporary data and after thath I delete this temporary table. What is the longest table name (in chars) fo MySQL table name ? Thanks in advance Rosen John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: I need to

Re: [PHP-DB] Temporary table name

2004-07-16 Thread John W. Holmes
Rosen wrote: Yes, I'm creating temporary table to store temporary data and after thath I delete this temporary table. What is the longest table name (in chars) fo MySQL table name ? How long does it exist for? If it's only used during the life of the script, then use TEMPORARY when you create it

Re: [PHP-DB] Temporary table name

2004-07-16 Thread Rosen
No, I don't use it only in range of one script - it must be as normal table - several scripts to work with this table and after the last script finish - it delete the table. This may take a time about 20-30 minutes ( until user enter data ) John W. Holmes [EMAIL PROTECTED] wrote in message

Re: [PHP-DB] Temporary table name

2004-07-16 Thread John W. Holmes
Rosen wrote: No, I don't use it only in range of one script - it must be as normal table - several scripts to work with this table and after the last script finish - it delete the table. This may take a time about 20-30 minutes ( until user enter data ) Okay. Use uniqid() to create a string for

Re: [PHP-DB] Temporary table name

2004-07-16 Thread Rosen
Thanks, I'll try it. John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: No, I don't use it only in range of one script - it must be as normal table - several scripts to work with this table and after the last script finish - it delete the table. This may

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-16 Thread Jason Wong
On Saturday 17 July 2004 09:31, Ross Honniball wrote: Attention all Sql gurus, Is there a way to FORCE mysql resolve specific conditions within a query before wasting it's time trying to resolve other conditions? www.mysql.com -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP-DB] Easy reg expression problem

2004-07-16 Thread Jason Wong
On Friday 16 July 2004 16:01, Tim Van Wassenhove wrote: In article [EMAIL PROTECTED], Jason Wong wrote: On Friday 16 July 2004 08:05, Justin Patrin wrote: If you're simply trying to get '@email.com' then use strstr(). Of courseI'm just so used to pregs... Well the advantage of