18 messages in com.mysql.lists.perlRe: placeholder funny w msql-mysql-mo...
FromSent OnAttachments
col...@news.sift.co.uk06 Oct 1999 09:29 
Yoichi Takayama06 Oct 1999 17:01 
col...@news.sift.co.uk07 Oct 1999 03:20 
Jochen Wiedmann07 Oct 1999 04:59 
Yoichi Takayama07 Oct 1999 06:09 
Rob Huffstedtler07 Oct 1999 06:23 
col...@news.sift.co.uk07 Oct 1999 06:36 
Hugo07 Oct 1999 06:42 
Jochen Wiedmann07 Oct 1999 07:22 
Jochen Wiedmann07 Oct 1999 07:27 
col...@news.sift.co.uk07 Oct 1999 07:34 
col...@news.sift.co.uk07 Oct 1999 07:47 
Hugo07 Oct 1999 08:36 
Yoichi Takayama07 Oct 1999 18:35 
Jochen Wiedmann08 Oct 1999 02:03 
Jochen Wiedmann08 Oct 1999 05:10 
col...@sift.co.uk08 Oct 1999 06:36 
Yoichi Takayama08 Oct 1999 18:18 
Subject:Re: placeholder funny w msql-mysql-modules-1.2207
From:Rob Huffstedtler (ro@bagpipe.com)
Date:10/07/1999 06:23:50 AM
List:com.mysql.lists.perl

You are correct. To the original poster: the reference for this is the perlop manpage. Search for the qq operator, which is the alternate name for the quoting operator.

On Thu, 7 Oct 1999 col@news.sift.co.uk wrote:

Yoichi Takayama wrote:

I thought that we are rather meant to write like:

$myStr = 'Hello World?'; $EscStr = $dbh->quote( $myStr ); $qst = "SELECT name from table WHERE name = $EscStr";

Is Perl really supposed to handle nested quotes?

Yoichi

I think perl handles quoting much like the Unix shell - double quotes allow variable expansion - singles don't. Any nesting of quotes is allowed as long as you properly escape metacharacters such as quotes that would normally terminate your string i.e '"' is equivalent to "\"";

$dbh->quote I think is just for conviently formating strings which may contain awkward values , I must admit I don't tend to use it. However my test code still breaks if I use $dbh->quote unless my patch is applied.

Sorry If I'm going completely up the wrong tree, I'm very new to perl DBI and MySQL ( but have plenty of experience w UNIX, C and databases however, so not a totally clueless newbie ).

On a slightly related question, is this list the right place to report bug/ send in patches ?. My posting doesn't seem to have garnered much response.

-- Regards, Colin M Strickland

"Tape my beatworm !"

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail
msql@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail msql@lists.mysql.com instead.

+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= = Rob Huffstedtler | We now return to our regularly + + (931) 596-3560 | scheduled programming = =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+