Is it possible to delete a blog from the "I read these blogs" list?
(Fwd)
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > Perl web-programming > (Fwd) 12 July 2008 23:31:07

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

(Fwd)

Tim Bunce 12 July 2008 23:31:07
 ----- Forwarded message from Jerry Rocteur <rocteur@mac.com> -----

Delivered-To: tim.bunce@pobox.com­
Date: Wed, 17 Dec 2003 18:27:12 +0100
Subject:
From: Jerry Rocteur <rocteur@mac.com>
To: Tim.Bunce@pobox.com­

Hi Tim,

I'm sorry if this is not the correct way to do this but I just wanted
to report something that is worrying me.

Please let me know what I must do if this is not the correct way to
report this problem.

I'm on an ENSIM system and my DB name is called rocteur_com-house

I set $db_name to rocteur_com-house then I run this: (I copied parts of
the script the MySQL book by Paul DuBois, the original)

# retrieve reference to single-column array of table names
my $ary_ref = $dbh->selectcol_arr­ayref (qq{ SHOW TABLES FROM
$db_name });

I get this error:

<html xmlns="http://www.w­3.org/1999/xhtml"
lang="en-US"><head>­<title>rocteur_com-h­ouse Database Browser</title>
DBD::mysql::db selectcol_arrayref failed: You have an error in your SQL
syntax near '-house ' at line 1 at ./db_browse.pl line 86.
</head><body bgcolor="white"><h1­>rocteur_com-house Database
Browser</h1><p>Sele­ct a table by clicking on its name:</p>

I've tried to escape the _ and the - with no success..

So it seems that DBI spits with this function .. Apart from that every
thing seems to be working OK..

I've tried on:

perl -MCGI -e 'print "CGI.pm version $CGI::VERSION\n";'

CGI.pm version 2.752

and CGI.pm version 3.00

Again I apologize if this is NOT the correct way to report a problem.

Best Regards,

Jerry


----- End forwarded message -----

Add comment
Paul DuBois 17 December 2003 23:44:14 permanent link ]
 At 19:47 +0000 12/17/03, Tim Bunce wrote:>----- Forwarded message from Jerry Rocteur <rocteur@mac.com> ----->
Delivered-To: tim.bunce@pobox.com­>Date: Wed, 17 Dec 2003 18:27:12 +0100>Subject:>From­: Jerry Rocteur <rocteur@mac.com>>T­o: Tim.Bunce@pobox.com­>
Hi Tim,>
I'm sorry if this is not the correct way to do this but I just wanted>to report something that is worrying me.>
Please let me know what I must do if this is not the correct way to>report this problem.>
I'm on an ENSIM system and my DB name is called rocteur_com-house>
I set $db_name to rocteur_com-house then I run this: (I copied parts of>the script the MySQL book by Paul DuBois, the original)>
# retrieve reference to single-column array of table names> my $ary_ref = $dbh->selectcol_arr­ayref (qq{ SHOW TABLES FROM>$db_name });>
I get this error:>
<html xmlns="http://www.w­3.org/1999/xhtml">la­ng="en-US"><head><ti­tle>rocteur_com-hous­e Database Browser</title>>DBD­::mysql::db selectcol_arrayref failed: You have an error in your SQL>syntax near '-house ' at line 1 at ./db_browse.pl line 86.></head><body bgcolor="white"><h1­>rocteur_com-house Database>Browser</h­1><p>Select a table by clicking on its name:</p>

If your database name contains a - character, then you must quote it
using backticks. Try: qq{ SHOW TABLES FROM `$db_name` }

I don't think backtick-quoting is mentioned in the first edition of
the book, because it hadn't been implemented in MySQL yet. :-)­

I've tried to escape the _ and the - with no success..>
So it seems that DBI spits with this function .. Apart from that every>thing seems to be working OK..>
I've tried on:>
perl -MCGI -e 'print "CGI.pm version $CGI::VERSION\n";'>­
CGI.pm version 2.752>
and CGI.pm version 3.00>
Again I apologize if this is NOT the correct way to report a problem.>
Best Regards,>
Jerry>
----- End forwarded message -----


Add comment
Jerry Rocteur 18 December 2003 18:59:40 permanent link ]
 
On Wednesday, Dec 17, 2003, at 21:44 Europe/Brussels, Paul DuBois wrote:
At 19:47 +0000 12/17/03, Tim Bunce wrote:>> ----- Forwarded message from Jerry Rocteur <rocteur@mac.com> ----->>
Delivered-To: tim.bunce@pobox.com­>> Date: Wed, 17 Dec 2003 18:27:12 +0100>> Subject:>> From: Jerry Rocteur <rocteur@mac.com>>>­ To: Tim.Bunce@pobox.com­>>
Hi Tim,>>
I'm sorry if this is not the correct way to do this but I just wanted>> to report something that is worrying me.>>
Please let me know what I must do if this is not the correct way to>> report this problem.>>
I'm on an ENSIM system and my DB name is called rocteur_com-house>>­
I set $db_name to rocteur_com-house then I run this: (I copied parts >> of>> the script the MySQL book by Paul DuBois, the original)>>
# retrieve reference to single-column array of table names>> my $ary_ref = $dbh->selectcol_arr­ayref (qq{ SHOW TABLES FROM>> $db_name });>>
I get this error:>>
<html xmlns="http://www.w­3.org/1999/xhtml">> lang="en-US"><head>­<title>rocteur_com-h­ouse Database Browser</title>>> DBD::mysql::db selectcol_arrayref failed: You have an error in your >> SQL>> syntax near '-house ' at line 1 at ./db_browse.pl line 86.>> </head><body bgcolor="white"><h1­>rocteur_com-house Database>> Browser</h1><p>Sele­ct a table by clicking on its name:</p>>
If your database name contains a - character, then you must quote it> using backticks. Try: qq{ SHOW TABLES FROM `$db_name` }>
I don't think backtick-quoting is mentioned in the first edition of> the book, because it hadn't been implemented in MySQL yet. :-)­>>
That did it, thanks a lot, I had that but without the back ticks..

But once I copy pasted your line.. That did the trick!

Thanks very much,

Jerry


Add comment
Tim Bunce 17 May 2004 12:16:55 permanent link ]
 ----- Forwarded message from Mourad.Ait-Abdelkad­er@serono.com -----

Delivered-To: tim.bunce@pobox.com­
X-Pobox-Antispam: Bad HELO hostname returned DENY: no MX or A records found for ch8mm001.serono.com­
X-SPF-Guess: pass (seems reasonable for mourad.ait-abdelkad­er@serono.com to mail through 193.134.210.51)
Subject:
To: Tim.Bunce@pobox.com­
From: Mourad.Ait-Abdelkad­er@serono.com
Date: Mon, 17 May 2004 10:08:19 +0200

Hello,

I have a table with a blob column. I granted another user with full
privileges against that table and defined a public synonym for that table.
If I run a perl DBI when I'm the second user and use the synonym to specify
that table and try insert or update against the blob I get an error :

DBD::Oracle::st execute failed: ORA-04043: object TMP_BLOB_TABLE does not
exist (DBD SUCCESS: OCIDescribeAny(view­)/LOB refetch) at test.pl line 28.
DBD::Oracle::st execute failed: ORA-04043: object TMP_BLOB_TABLE does not
exist (DBD SUCCESS: OCIDescribeAny(view­)/LOB refetch) at test.pl line 28.

When I fully specify the table it works.

Any ideas?

DBD Oracle Version = '1.06'

Thanks.





*******************­********************­********************­********************­*************
S - This message contains confidential information and is intended only for the individual
named. If you are not the named addressee, you should not disseminate, distribute or copy
this e-mail. Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
e-mail transmission cannot be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain malware. The
presence of this disclaimer is not a proof that it was originated at Serono International S.A.
or one of its affiliates. Serono International S.A and its affiliates therefore do not accept
liability for any errors or omissions in the content of this message, which arise as a result
of e-mail transmission. If verification is required, please request a hard-copy version.
Serono International SA, 15bis Chemin Des Mines, Geneva, Switzerland, www.serono.com.
*******************­********************­********************­********************­**************


----- End forwarded message -----

Add comment
Ron Reidy 17 May 2004 17:13:04 permanent link ]
 Are you sure the synonym worked?

-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.


-----Original Message-----
From: Tim Bunce [mailto:Tim.Bunce@pobox.com]
Sent: Monday, May 17, 2004 3:17 AM
To: dbi-users@perl.org
Cc: Mourad.Ait-Abdelkad­er@serono.com
Subject: (Fwd)


----- Forwarded message from Mourad.Ait-Abdelkad­er@serono.com -----

Delivered-To: tim.bunce@pobox.com­
X-Pobox-Antispam: Bad HELO hostname returned DENY: no MX or A records found for ch8mm001.serono.com­
X-SPF-Guess: pass (seems reasonable for mourad.ait-abdelkad­er@serono.com to mail through 193.134.210.51)
Subject:
To: Tim.Bunce@pobox.com­
From: Mourad.Ait-Abdelkad­er@serono.com
Date: Mon, 17 May 2004 10:08:19 +0200

Hello,

I have a table with a blob column. I granted another user with full
privileges against that table and defined a public synonym for that table.
If I run a perl DBI when I'm the second user and use the synonym to specify
that table and try insert or update against the blob I get an error :

DBD::Oracle::st execute failed: ORA-04043: object TMP_BLOB_TABLE does not
exist (DBD SUCCESS: OCIDescribeAny(view­)/LOB refetch) at test.pl line 28.
DBD::Oracle::st execute failed: ORA-04043: object TMP_BLOB_TABLE does not
exist (DBD SUCCESS: OCIDescribeAny(view­)/LOB refetch) at test.pl line 28.

When I fully specify the table it works.

Any ideas?

DBD Oracle Version = '1.06'

Thanks.





*******************­********************­********************­********************­*************
S - This message contains confidential information and is intended only for the individual
named. If you are not the named addressee, you should not disseminate, distribute or copy
this e-mail. Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
e-mail transmission cannot be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain malware. The
presence of this disclaimer is not a proof that it was originated at Serono International S.A.
or one of its affiliates. Serono International S.A and its affiliates therefore do not accept
liability for any errors or omissions in the content of this message, which arise as a result
of e-mail transmission. If verification is required, please request a hard-copy version.
Serono International SA, 15bis Chemin Des Mines, Geneva, Switzerland, www.serono.com.
*******************­********************­********************­********************­**************


----- End forwarded message -----

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.


Add comment
Suspect Files 25 June 2004 21:13:55 permanent link ]
 
------- Forwarded message follows -------
Date sent: 25 Jun 2004 11:41:22 +0200
From: Ago <ago@nmb.it>
To: <pgsql-general@post­gresql.org>
Send reply to: Ago <ago@nmb.it>
Subject: [GENERAL]

I have a PHP script that runs this query on Postgresql 7.2.3. Once it
inserts the record in the e_catalog table it takes the id value and
then inserts it in the e_catalog_cache table, the two tables must
have
the same rows and values.
I thought rhat inside a transaction block the subquery SELECT
MAX(­id)
FROM e_catalog was safe from concurrent same transactions, that
is
the id value from SELECT MAX(­id) FROM e_catalog was exactly
that one
inserted in the previous statement, but reading some threads in this
mailing list I have some doubt now.
This is the query:

BEGIN WORK;
INSERT INTO e_catalog(id, name, descr) VALUES
(nextval('sequence'­),
'$Name', '$Descr');

INSERT INTO e_catalog_cache(id,­ name, descr) VALUES
((SELECT MAX(­id)
FROM e_catalog), '$Name', '$Descr');

COMMIT WORK;

Thanks.



-------------------­--------(end of
broadcast)---------­------------------ TIP 2: you can get off all lists
at once with the unregister command
(send "unregister YourEmailAddressHer­e" to
majordomo@postgresq­l.org)

------- End of forwarded message -------



-------------------­--------(end of broadcast)---------­------------------
TIP 6: Have you searched our list archives?

http://archives.pos­tgresql.org
Add comment
Tim Bunce 12 July 2008 23:31:07 permanent link ]
 ----- Forwarded message from Ejaz <mejaz@cyberia.net.­sa> -----

From: Ejaz <mejaz@cyberia.net.­sa>
To: Tim.Bunce@pobox.com­
Subject:
Date: Sat, 12 Jul 2008 17:39:17 +0300

Dear sir,

As a favour Please could you tell me DBD-Oracle.xxx version can be installed on Solaris 10x6 or not ???

Ejaz

----- End forwarded message -----

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > Perl web-programming > (Fwd) 12 July 2008 23:31:07

see also:
multi return values
[patch@34896] vms readdir() fixes for…
r24089 - docs/Perl6/Spec
пройди тесты:
see also:
Hello All!
Colin Powell
Afraid of Martian Invasion?

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .