RE: [PHP-DB] Re: CSV update Mysql feature

2004-06-01 Thread Kenny
Well the problem is how would I create the query? -Original Message- From: Uzi Klein [mailto:[EMAIL PROTECTED] Sent: 01 June 2004 07:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: CSV update Mysql feature It's kinda clear. What isn't clear is what the problem? "Kenny" <[EMAIL PROTECTE

[PHP-DB] big/small letters with oracle

2004-06-01 Thread Torsten Lange
Hello, I want to automatically generate a list, where a user can select all measurement parameter, lets say Na, Mg, Cl and Si as (s)he likes. For instance I have a specific spring and all chemistry parameter are saved in one table. For our Oracle9iDB, this parameter select list can be easily p

[PHP-DB] big/small letters with oracle No2

2004-06-01 Thread Torsten Lange
> But when using queries on the USER_... data dictionary, Oracle delivers always big letters, which is for > chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs. Alice Springs) and location codes > often uncomfortable to read. It happend in the heat of the moment... The above is on

[PHP-DB] Re: big/small letters with oracle No2

2004-06-01 Thread Torsten Roehr
"Torsten Lange" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > But when using queries on the USER_... data dictionary, Oracle > delivers always big letters, which is for > > chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs. > Alice Springs) and location codes > >

[PHP-DB] Re: big/small letters with oracle No2

2004-06-01 Thread Torsten Roehr
>>"Torsten Lange" <[EMAIL PROTECTED]> wrote in message >>news:[EMAIL PROTECTED] >> >> But when using queries on the USER_... data dictionary, Oracle >>>delivers always big letters, which is for >>> > chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs. >>>Alice Springs)

RE: [PHP-DB] Re: CSV update Mysql feature

2004-06-01 Thread David Robley
Kenny wrote: > Well the problem is how would I create the query? > > > > -Original Message- > From: Uzi Klein [mailto:[EMAIL PROTECTED] > Sent: 01 June 2004 07:36 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: CSV update Mysql feature > > It's kinda clear. > What isn't clear is what t

[PHP-DB] Using Cursors

2004-06-01 Thread Gerard Samuel
A bit off topic, but lately I've been running into situations, where I have to know about using cursors with databases, like sql server, ibm db2 Can anyone point me to online resources that explains (to a practical newbie) "cursors" Thanks -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] strange query

2004-06-01 Thread pete M
I'm running this query agains a mysql database, its a list of statuses with a joined table that shows the number of job in that status with more than 2. However I get the error Unknown column 'c' in 'where clause' select job_stats.job_stat_id, job_stat, job_stat_code, count(works.job_stat_id) a

Re: [PHP-DB] strange query

2004-06-01 Thread Mikhail U. Petrov
Hi! You should use having c>2 instead of where c>2. Tuesday, June 1, 2004, 7:09:29 PM, pete wrote: pM> I'm running this query agains a mysql database, its a list of statuses pM> with a joined table that shows the number of job in that status with pM> more than 2. However I get the error pM> U

Re: [PHP-DB] strange query

2004-06-01 Thread pete M
doh ! thanks Mikhail U. Petrov wrote: Hi! You should use having c>2 instead of where c>2. Tuesday, June 1, 2004, 7:09:29 PM, pete wrote: pM> I'm running this query agains a mysql database, its a list of statuses pM> with a joined table that shows the number of job in that status with pM> more

Re: [PHP-DB] strange query

2004-06-01 Thread John W. Holmes
From: "pete M" <[EMAIL PROTECTED]> > I'm running this query agains a mysql database, its a list of statuses > with a joined table that shows the number of job in that status with > more than 2. However I get the error > > Unknown column 'c' in 'where clause' > > select job_stats.job_stat_id,

Re: [PHP-DB] Using Cursors

2004-06-01 Thread Miles Thompson
At 11:12 AM 6/1/2004, Gerard Samuel wrote: A bit off topic, but lately I've been running into situations, where I have to know about using cursors with databases, like sql server, ibm db2 Can anyone point me to online resources that explains (to a practical newbie) "cursors" Thanks Gerard, Thin

Re: [PHP-DB] Using Cursors

2004-06-01 Thread Robert Twitty
Hi I am not aware of a website that talks about cursors. However, I do know that they should be avoided whenever possible. They tend to require a lot of resources. I mostly use them in stored procedures when I need to loop through a result set. If you like, I can provide you with MS SQL Server sy

[PHP-DB] Re: $_Session vs $_Cookie

2004-06-01 Thread Justin Patrin
Ng Hwee Hwee wrote: Hi all, I have a problem: my $_SESSION variables and $_COOKIE variables get destroyed very often, even though my clients are actively browsing the site (that means, the variables should not be garbage collected). Our guess is that the network connections are weak. My server is

[PHP-DB] How to identify primary key

2004-06-01 Thread Scot L. Harris
Using PHP 4.2.2 and postgresql 7.2.4. Trying to find a way to identify the primary key of a table given just the tables name. Been looking through the system tables but have not figured out some of the relationships between pg_attribute, pg_class and some of the others. Found a reference to a pg

[PHP-DB] Re:Subject: big/small letters with oracle No2

2004-06-01 Thread Neil Smith [MVP, Digital media]
You can just use the PHP function ucwords(strtolower()) on the results as you loop through them to create the Select list ;-) So, this would convert NA to Na, and MG to Mg (as well as mG to Mg and MG to Mg ;-) Cheers - Neil At 10:41 01/06/2004 +, you wrote: Date: Tue, 01 Jun 2004 12:41:11 +

Re: [PHP-DB] How to identify primary key

2004-06-01 Thread Ross Honniball
May not be of any use as I know nothing about postgresql, but if it happens to be remotely related to mysql then this may help. In Mysql : SHOW COLUMNS FROM table-name Regards .. Ross At 05:04 AM 2/06/2004, you wrote: Using PHP 4.2.2 and postgresql 7.2.4. Trying to find a way to identify the prim

[PHP-DB] Re: Using Cursors

2004-06-01 Thread Frank Flynn
On 6/1/04 4:06 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > From: Gerard Samuel <[EMAIL PROTECTED]> > Date: Tue, 1 Jun 2004 10:12:22 -0400 > To: [EMAIL PROTECTED] > Subject: Using Cursors > > A bit off topic, but lately I've been running into situations, where I have > to know about using

[PHP-DB] Re: How to identify primary key

2004-06-01 Thread Hans Lellelid
Hi, Scot L. Harris wrote: Using PHP 4.2.2 and postgresql 7.2.4. Trying to find a way to identify the primary key of a table given just the tables name. I don't have a quick answer but can point you to where you can hopefully find what you are looking for. Try looking at the queries in this class: