Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^3: DBI problem on fetchrow

by Jenda (Abbot)
on Nov 15, 2007 at 17:55 UTC ( #651042=note: print w/ replies, xml ) Need Help??


in reply to Re^2: DBI problem on fetchrow
in thread DBI problem on fetchrow

As a matter of style I would recomend using the "as" consistently. It reads better.

BTW, "Regions as M"? Maybe there is a reason to use M for the Regions table, but I would expect R or (in case the table was used several times in the query) something like R_old, R_new, R1, R2, .... In either case I do not see why would you use an alias in a query that only includes one table. I guess a matter of style again :-)


Comment on Re^3: DBI problem on fetchrow
Replies are listed 'Best First'.
Re^4: DBI problem on fetchrow
by jZed (Prior) on Nov 15, 2007 at 18:15 UTC
    I agree. I always use AS.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (12)
As of 2015-07-31 19:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (280 votes), past polls