Hello all,
I get this error when compiling:
Object file format error in: /usr/sw: read_cur_obj_info: File is not a
regular file
I have the same thing in /usr/sw as you'd find in /usr/local
I'm using gcc 4.0.2 and the tru64 native compiler.
I tried taking off a few configure directives, such as
Menachem,
> SUM(check_applications.namountapplied IF checks.lvoid=0)
Close. Try SUM(IF(checks.lvoid=0,0,check_applications.namountapplied))
PB
-
Menachem Bazian wrote:
Hi,
I was wondering if anyone can help me with this syntax. I have three
tables, INVOICES, CHECKS and CHECK_APPLICATIO
Hi,
I was wondering if anyone can help me with this syntax. I have three
tables, INVOICES, CHECKS and CHECK_APPLICATIONS. I need to SUM the
amounts in CHECK_APPLICATIONS for each invoice IF the check it is
related to has not been voided. Something like this (in SQL and pseudocode)
SELECT inv
I've got a master-master set up and I'm trying to figure out the best
way to add new databases to the cluster. I've not set anything for
the replica-do-db which my understanding means it will sync everything
correct?
So if I create a new DB is the create command supposed to replicated
as well? (i
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:48:31 PM
Subject: Re: need help with query...
Hi,
>
> Hi Andy,
> the reason I can't use this because fields (columns) in select statement
> (p.first_name, p.last_
Hi,
Hi Andy,
the reason I can't use this because fields (columns) in select
statement (p.first_name, p.last_name,...) are actually dynamically
created. In my project different client will select different fields
to be shown. 99% will select first_name, and last_name, but some don't
care abo
Jerry Schwartz wrote:
-Original Message-
From: Andy Shellam [mailto:andy-li...@networkmail.eu]
Sent: Wednesday, December 17, 2008 3:29 PM
To: Lamp Lists
Cc: mysql@lists.mysql.com
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:29:08 PM
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
p.first_name AS person_first_name,
p.last_nam
>-Original Message-
>From: Andy Shellam [mailto:andy-li...@networkmail.eu]
>Sent: Wednesday, December 17, 2008 3:29 PM
>To: Lamp Lists
>Cc: mysql@lists.mysql.com
>Subject: Re: need help with query...
>
>Hi Afan
>
>Why not prefix your field names with the table name?
>
>select
> p.first_nam
>-Original Message-
>From: Lamp Lists [mailto:lamp.li...@yahoo.com]
>Sent: Wednesday, December 17, 2008 2:57 PM
>To: mysql@lists.mysql.com
>Subject: need help with query...
...snip...
>I have let say 3 tables people, organization, addresses. and they are
>linked to each other with colum
Hi Afan
Why not prefix your field names with the table name?
select
p.first_name AS person_first_name,
p.last_name AS person_last_name,
p.status AS person_status,
p.date_registered AS person_date_registered,
o.org_id AS organization_org_id,
o.org_name AS organization_org_name,
o.org_depar
On Dec 17, 2008, at 2:56 PM, Lamp Lists wrote:
I hate when somebody put in Subject line something like I just did
but after 15 minutes to try to be specific just with one short
sentence - I gave up. So, you can hate me - I understand (though,
help with my problem too) :-)
I have let say
I hate when somebody put in Subject line something like I just did but after 15
minutes to try to be specific just with one short sentence - I gave up. So, you
can hate me - I understand (though, help with my problem too) :-)
I have let say 3 tables people, organization, addresses. and they are
Three solutions, the first one is not recommended I just showed it for
fun -- I think the last one is the most efficient:
mysql> show create table job \G
*** 1. row ***
Table: job
Create Table: CREATE TABLE `job` (
`job_id` int(10) unsigned
Perhaps pass in a "separator" string arg, default to '' and do:
GROUP_CONCAT(DISTINCT h.hostid, separator)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Sorry i replied from a different address. Heres the reply with some editing:
Got it to work perfectly, thanks, although it takes some time (CILS has
>150.000 records). There was no need for unique since all the results are
already surprisingly unique.
Thank you, it was a different way of doing th
I have a function that I built that returns a string that is really a
comma separated list of values (below). I would like to use that
returned value in an IN clause in sql. :
select * from hosts where hostid in (getHosts(10014));
The function:
CREATE FUNCTION getUserHosts(userID BIGINT(2
I have a few questions about the parameters for SslOption/mysql_ssl_set
( C++/C ) and about SSL in general between the server and the client.
I do understand what a certificate, a private key, and a public key is
in general but I am having trouble understandng how they work in MySql.
1) Are the
Got it to work perfectly, thanks, although it takes some time (CILS has
>150.000 records). There was no need for unique since all the results are
already surprisingly unique.
Thank you, it was a different way of doing things. Well, different to me, at
least. :-)
In the meantime, i found an altern
Hopefully your CILS table is not too many rows...
select * from JOB, CILS as cyan, CILS as magenta
where cyan.num_of = JOB.num_of
and magenta.num_of = cyan.num_of
and cyan.color = 'cyan'
and magenta.color = 'magenta'
or something not unlike that...
You may want UNIQUE JOB.id_enc
Greetings,
Microolap Technologies is happy to announce that the version 1.9.8 of
MicroOLAP Database Designer for MySQL is immediately available.
This release introduces completely new View Parser. Placing of objects
pasted from clipboard significantly improved. Russian localization
added (experim
Hi,
I use mysql 5.0 (Centos 5.2) , I have a database, say called opfilter
with 2 tables (say aliases and hosts) and I want that slave only
replicate tabla aliases and only records from table hosts that match a
given criteria, how can i do that?
My current file my.conf on slave is as follows:
[
Due to illness, the MySQL University session "Using DTrace with MySQL"
has been moved to February 12th, 2009. Sorry for the short notice (blame
it on the flu which came on short notice, too.)
**
Hi,
I am trying to solve a problem that i have been stuck for a few days, i hope
you guys can shed some light on this.
I have two tables: enc and cils
JOB:
id_enc
num_of
name
CILS:
id_cil
num_of
color
each "JOB" is composed of severals "CILS" (i know i should link tables using
id_enc, but for
24 matches
Mail list logo
