Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^3: Concrete SQL from SQL::Abstract?

by benizi (Hermit)
on May 13, 2010 at 21:44 UTC ( #839909=note: print w/replies, xml ) Need Help??


in reply to Re^2: Concrete SQL from SQL::Abstract?
in thread Concrete SQL from SQL::Abstract?

Dang. In addition to not noticing the slightly odd insert into X set field=value, field2=value2 syntax (as opposed to the 'insert' method's more standard insert into (fields) values (values)), I didn't realize there's weirdness with question marks:

my %data = ( url => "http://foo/bar?baz", asdf => 1, thing => \'now()' + ); $_ = (ref) ? $_ : $dbh->quote($_) for values %data; print scalar $sqlgen->generate('insert into',\'atable',\%data); __END__ Use of uninitialized value in substitution iterator at /usr/lib/perl5/ +vendor_perl/5.10.0/SQL/Abstract.pm line 1290. INSERT INTO atable SET asdf = '1', thing = now(), url = 'http://foo/ba +rbaz'

Seems this simply isn't the general use-case for 'generate'.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://839909]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (2)
As of 2022-08-14 16:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?