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:
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
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
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 +
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
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
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
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
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,
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
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
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
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/)
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
>>"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)
"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
> >
> 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
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
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
19 matches
Mail list logo
