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 PROTECTED]
Hello,
I want to automatically generate a select 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
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 only
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
often
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
often
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 the problem?
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/)
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)
Hi!
You should use
having c2
instead of
where c2.
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
doh !
thanks
Mikhail U. Petrov wrote:
Hi!
You should use
having c2
instead of
where c2.
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
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, job_stat,
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,
Think
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
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
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
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
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
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 cursors
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
19 matches
Mail list logo