Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

kcott's scratchpad

by kcott (Canon)
on Sep 22, 2010 at 21:42 UTC ( #861372=scratchpad: print w/ replies, xml ) Need Help??

<img src="http://www.perlmonksflair.com/kcott.jpg" alt="PerlMonks Badge: kcott" title="PerlMonks Badge: kcott. See http://www.perlmonksflair.com/." />

For Tux:

#!/usr/bin/env perl -l use strict; use warnings; use Text::CSV; my $csv = Text::CSV::->new(); my $cols = @{ $csv->getline(\*DATA) }; my $query = 'INSERT INTO table (' . join(',' => map { "col$_" } 1 .. $ +cols) . ') VALUES (' . join(',' => ('?') x $cols) . ')'; print $query; __DATA__ a,b,c,d

Output:

INSERT INTO table (col1,col2,col3,col4) VALUES (?,?,?,?)

Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (1)
As of 2016-07-30 02:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What is your favorite alternate name for a (specific) keyboard key?


















    Results (264 votes). Check out past polls.