Argh. I've got the following:


To throw the contents of one row into a hash %ref. However, I can't seem to be able to access that hash? I've tried:


But that doesn't seem to work. Any help would be appreciated? How do I loop through my hash :-\

- wil

Its a hashref so you can't use:

foreach $row_ref (keys %ref}) {

....because that's for a normal hash ....also you have an unmatched bracket

Try:

Hi Paul

Thanks for your reply. I've now got the following:


And I want to be able to do this:


Is there any way that can be done? I guess I need to retireve the values from the database in a different way if I want to do this?

- wil

I don't understand what you are trying to do. You only have one row in $ref so you don't need to loop through anything.

Just..

$ref->{Column};

Hi Paul

I need to get all colums in a row into a hash or something. Because I need to assign every column value to it's column name for my Template parser to pick them up. :-)

I was thinking of something like:


Which doesn't want to work. Do you understand what I'm trying to do? Any way you know I can do it?

- wil

Hi Paul

At the moment, I've got the following code...


But I don't want to explicitly name every one, I want to be able to use a loop to automate this process.

See my above message.

I must be reading the data in from the DB incorrectly ?

- wil

How about:

Does nothing or prints nothing? hmm.

- wil

Stop quoting perl code grrrr

I just tested and it works fine.


Maybe you aren't selecting anything from mysql. Thats why you should use $DBI::errstr

Yes, that code works fine. But it still doesn't want to assign them to their variable name.

How do I find the variable names used then?

- wil

Hi Paul

Yes! Thanks for your help. I've now got the following which is what I was looking for:


Sorry if I was unclear in previous messages.

Cheers

- wil

Oh crap. It obviousl grabs every single param. How can I ask it not to parse a few params. I've got the following in an array:


How can I tell:


to leave the params in the array alone? :-\

Thanks

- wil

Sorry you've lost me again.

Why are you using:

$$db_input_values_k

Hi Paul

I'm assigning the variable $db_input_values_v to $db_input_values_k.

If you're assigning the value of one scalar to another you need to use double $$.

What I'm trying to do is to omit some from the hash? Do you know how to do that?

Cheers


- wil

>>If you're assigning the value of one scalar to another you need to use double $$.
<<

No you don't. $$ is for referencing.

To skip some hash keys just use something like:

next if $db_input_values_k eq 'whatever';

I still don't get what you are doing. What part does the array play in this and why are you assigning the key to the value?

Ah. Of course. How can I do something like...

next foreach $db_col_value (@db_col_values);

is that possible?

- wil

next if grep { /$db_input_values_v/ } @db_col_values;

Hi

It's OK. I've thrown it inside a my foreach loop which I'm using earlier in the script. That snippet didn't work however?

- wil

I probably used the wrong variable. I just edited it to:

next if grep { /$db_input_values_v/ } @db_col_values;

Yes, great. Thanks for all your help.

I ended up putting the next; inside a foreach loop in the end because I had opened a foreach loop already and might as well make use of it.

Cheers

- wil

Just out of interest, the above didn't work. But the following did:


Cheers

- wil