Re: REMOVE NOW THIS IS THE SECOND TIME
On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor located on U.S soil. Tõnu BTW, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REMOVE NOW THIS IS THE SECOND TIME
;-) and can't read either ;) c'mon guys... lets keep the ethnic humour down... i'm sure it does not do any good to business, although it sure, well, tingles sometimes... we all have our natures, cultures, surroundings, and, understanding and respecting, clears boundaries and improve overall communicability. my warmest regards to all mauricio portasio [EMAIL PROTECTED] sao paulo - brazil - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: Mourad de Riche [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 9:11 AM Subject: Re: REMOVE NOW THIS IS THE SECOND TIME On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor located on U.S soil. Tõnu BTW, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REMOVE NOW THIS IS THE SECOND TIME
Tonu Samuel wrote: On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor located on U.S soil. Tõnu BTW, sql Tõnu: Without regard to his/her mental state the original message was a response to a very valid (probably somewhat useful) technical discussion responded to by Jeremy Z. I.e. (doesn't always stand for Internet Exploder): it was a flame. It's unfortunate those M$ mailers still don't let people view the unsubscribe instructions and that particular company is beyond the jurisdiction of the U.S. DOJ. Clearly the reach of that company's software extends beyond U.S. borders or this thread would never have started. mysqladmin create db SSSCA mysql use mysql; mysql delete citizen from db; mysql quit; mysqladmin -u Bush reload Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REMOVE NOW THIS IS THE SECOND TIME
Good words, Mauricio. /Rob Toronto, Ontario, Canada Ob. MySQL: database, sql, query, table ;-) and can't read either ;) c'mon guys... lets keep the ethnic humour down... i'm sure it does not do any good to business, although it sure, well, tingles sometimes... we all have our natures, cultures, surroundings, and, understanding and respecting, clears boundaries and improve overall communicability. my warmest regards to all mauricio portasio [EMAIL PROTECTED] sao paulo - brazil ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
REMOVE NOW THIS IS THE SECOND TIME
I will have you served for a violation of federal law if you do not remove
immediately!!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Philip Mak [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:48 PM
Subject: Re: Perl DBI: Same column name in different tables problem
On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
Let's say I performed the following query using Perl DBI:
$row = $dbh-selectrow_hashref(~);
SELECT fanfics.handle, authors.handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
~
I won't be able to access both fanfics.handle and authors.handle
this way, because they're called handle. I would like to be able
to access them e.g. by doing $row-{fanfics.handle} and
$row-{authors.handle}, or something like that.
What workarounds have people found for this problem?
Use a column alias:
SELECT fanfics.handle as f_handle, authors.handle as a_handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
Then refer to them as $row-{a_handle} or $row-{f_handle}.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 2 days, processed 42,300,526 queries (237/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REMOVE NOW THIS IS THE SECOND TIME
Umm, Is he drunk or something? Report to a federal law? It's like a mail from a mailing list, i mean... whats wrong with these people. On Sun, 9 Sep 2001, Nev and Emel Gokcen wrote: I will have you served for a violation of federal law if you do not remove immediately!! - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Philip Mak [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 07, 2001 10:48 PM Subject: Re: Perl DBI: Same column name in different tables problem -- Regards, Mourad de Riche Omnix Resources Online Org. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: REMOVE NOW THIS IS THE SECOND TIME
Nev and emel,
Stop being an asshole and take your name out of the mailing list. It
does work you know
-Original Message-
From: Nev and Emel Gokcen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 09, 2001 2:05 PM
To: [EMAIL PROTECTED]
Subject: REMOVE NOW THIS IS THE SECOND TIME
I will have you served for a violation of federal law if you do not
remove immediately!!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Philip Mak [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:48 PM
Subject: Re: Perl DBI: Same column name in different tables problem
On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
Let's say I performed the following query using Perl DBI:
$row = $dbh-selectrow_hashref(~);
SELECT fanfics.handle, authors.handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
~
I won't be able to access both fanfics.handle and authors.handle
this way, because they're called handle. I would like to be able
to access them e.g. by doing $row-{fanfics.handle} and
$row-{authors.handle}, or something like that.
What workarounds have people found for this problem?
Use a column alias:
SELECT fanfics.handle as f_handle, authors.handle as a_handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
Then refer to them as $row-{a_handle} or $row-{f_handle}.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 2 days, processed 42,300,526 queries (237/sec.
avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
