many thanks for your reply Chanan On Sun, Oct 31, 2010 at 2:42 PM, Meir Guttman <[email protected]> wrote: > My dear shlomi, > > OK, and how would you use placeholders to pass the following (My)SQL query? > > LOAD DATA INFILE myLDIfile.tsv > > INTO TABLE tbl_name > > COLUMNS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY "'" ESCAPED BY '\\' > > LINES TERMINATED BY '\r\n' > > Meir > > > > -----Original Message----- > From: Shlomi Fish [mailto:[email protected]] > Sent: Sunday, October 31, 2010 1:59 PM > To: [email protected] > Cc: Meir Guttman; Chanan Berler > Subject: Re: [Israel.pm] DBI > > > > On Sunday 31 October 2010 13:44:00 Meir Guttman wrote: > >> Dear Chanan, > >> > >> I think the answer is DBI's 'quote' method. Please lookup > >> http://search.cpan.org/~timb/DBI-1.615/DBI.pm#quote > >> > > > > Placeholders are normally preferable over $dbh->quote() (as Jaime noted). > > > > Regards, > > > > Shlomi Fish > > > > -- > > ----------------------------------------------------------------- > > Shlomi Fish http://www.shlomifish.org/ > > http://www.shlomifish.org/humour/ways_to_do_it.html > > > > <rindolf> She's a hot chick. But she smokes. > > <go|dfish> She can smoke as long as she's smokin'. > > > > Please reply to list if it's a mailing list post - http://shlom.in/reply .
-- =================== ---- Chanan Berler ---- =================== _______________________________________________ Perl mailing list [email protected] http://mail.perl.org.il/mailman/listinfo/perl
