Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^8: SQL query using dynamic array

by cocl04 (Sexton)
on Nov 18, 2008 at 21:28 UTC ( [id://724393]=note: print w/replies, xml ) Need Help??


in reply to Re^7: SQL query using dynamic array
in thread SQL query using dynamic array

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re^9: SQL query using dynamic array
by Corion (Patriarch) on Nov 18, 2008 at 21:38 UTC

    Why did you repost your complete post another program, with the comments that do not help anything, and with code parts that you still fail to explain, which I told you do nothing, but which you still keep in your program?

    What reaction do you expect from me?

    When you fetch data and put it into an array. It does not index it. It is all placed in array index 0. I want to index the data. In terms of a data dump my code already does that....The data trace(2) says that it is keeping the first array. The emailed data says it is keeping the first array.

    Until you use Data::Dumper, I won't believe that you output your complete datastructure.

    Can you pass an array index to a sql statement via a loop to get more specific data? That is all I want to know. Can sql passed an array indexed value with each iteration? That is my only question. If it can't be done that is fine... but The data structure has been dumped and validated. I know how to dump data and create and entance to view the data structure.

    Whatever you mean by "index". You get all your data back as an array of arrays (AoA). The Perl documentation I already referred you to, perldsc and perlreftut, describe what that is. If you have "dumped and validated" the data structure, then I wonder why you feel the need to ask for the rest of your data.

    Update: Please see brian's Guide to Solving Any Perl Problem for further help in debugging your problems.

      Thank you!!!!!!! I fixed it. The data::dumper confirmed my thoughts. But some of the other error handling tools helped me fine tone the process!!! It works! That is really all I need. I can figure out how to solve the problem. I needed more tools. You where also correct about $row. It did nothing. The data was already in $row. I just had to reference it correctly to get the data...Anyway...sorry for being a pain...Thanks again for helping me think through the process.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2024-03-28 17:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found