Looking for a good explanation of select function in perl dbi

Well, I've figured out how to put data into a sqlite database. I can
extract data from the command line, however, for the life of me, I just
can't find any good documentation on using Select.

What I'm trying to do:

SELECT name, size FROM filelist where uid=<given value>

This works from the command line:

sqlite3 data.dbl "SELECT name, uid from filelist where UID=\"1000\""

I'd like to pop this into an array, where I could manipulate it, where each
element of the array would contain name,size.

Are there any good web pages on using the SELECT function? I took a look
at:

http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html

But it kind of lost me.

Scott Mohnkern

Relevant Pages

  • SUMMARY: Help! Self Induced 6540 Catastrophe
    ... firmware command for a StorageTek 6540 to revert a 'reset array' ... rather than manually recreating the LUNs. ... I've finally caught up after losing everything on this array. ...
    (SunManagers)
  • Re: Referencing Korn Shell Array Names as a Variable
    ... Your idea worked for displaying the output from the command. ... $ echo $ ... # Attempt to use variable array name and index to reference array value ... The issue is with this line of the script ...
    (comp.unix.shell)
  • Re: command line arguments and processing of the arguments
    ... Another possibility for writing the parser would be to have an array of the ... Then you'll have your actual dispatch table. ... I would guess that in your program the motor to which the command affects ... might be another parameter for the handler function, ...
    (comp.programming)
  • array element count (was: Re: problem with whitespace not splitting on split. -SOLVED - with
    ... #$arrayname that has the count of array elements. ... @ARGV The array @ARGV contains the command-line arguments intended ... See $0 for the command name. ... assignment to $[can be seen from outer lexical scopes ...
    (perl.beginners)
  • Re: Editable input from the console windows
    ... I learning the syntax and build upon a previously working script. ... My case, read, and history statements are mucked up. ... # The code block that the populate the array with id3tag data has been remove. ... You are passing the entire contents of $VAR as a command name (by ...
    (comp.unix.shell)