Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: perl DBI question

by bassplayer (Monsignor)
on Jun 22, 2004 at 13:31 UTC ( #368710=note: print w/replies, xml ) Need Help??


in reply to perl DBI question

I think the problem is that DECIMAL is a keyword in MySQL. Here is a link that explains it better than I can.

bassplayer

Replies are listed 'Best First'.
Re^2: perl DBI question
by Anonymous Monk on Jun 22, 2004 at 13:35 UTC
    D'oh!

    you're exactly right, I changed the name of the field and everything worked fine.
    Valuable lesson learned, and thanks for the swift response
    Jonathan
      Single quoting the field names in the field list ala ('DECIMAL','SOANDSO','BLAHABLAH') might work as well.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://368710]
help
Chatterbox?
[Lady_Aleena]: shmem, I already have the plugin installed, just not active.
[shmem]: if you have 1 optional argument, place that at the end of the list. If you have more, go for named parameters.
[Lady_Aleena]: 1 manditory, 2 optional.
[Discipulus]: my ($need,$opta,$optb ) = @_; .. if $opta..
[shmem]: all else leads to trouble, even if the third argument depends on the existence of the second. That may become brittle.
[Discipulus]: but if have case like subname(15,undef,3 ) maybe bettere named parameters
[Lady_Aleena]: I don't want to have to do: alpha_menu($hash, undef, $type);
[Lady_Aleena]: Or what Discipulus said.
[shmem]: Lady_Aleena: geany supports ctags.
[Discipulus]: a good compromise can be my ($need, $opts_ref) = @_ a scalar and an hash reference

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (8)
As of 2017-04-27 12:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (506 votes). Check out past polls.