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

Re^4: DBI and mysql query formatting

by afoken (Monsignor)
on Dec 08, 2013 at 14:37 UTC ( #1066214=note: print w/replies, xml ) Need Help??

in reply to Re^3: DBI and mysql query formatting
in thread DBI and mysql query formatting

But the goal of the OP is to have the same order for the $str and $val, not for every run.

That's what values guarantees:

[...] So long as a given hash is unmodified you may rely on keys, values and each to repeatedly return the same order as each other. [...]


Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Replies are listed 'Best First'.
Re^5: DBI and mysql query formatting
by tangent (Priest) on Dec 08, 2013 at 18:38 UTC
    Ah, like the OP I was never sure about that and had not come across the guarantee you quote.

    I would go with the more complete code you have posted below.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1066214]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2017-04-26 16:38 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (484 votes). Check out past polls.