Terrence, you neglected to mention that 'sql_lookup' bit in your example actually requires some setup in advance.
Right you are, sql_lookup is a function in SQL::Catalog and SQL::Catalog archives all SQL for a project to a database for later use. Thus, the first step in designing a SQL-oriented database app is to create all your SQL along with labels and store it. then, you can retrieve it using SQL::Catalog.

and then use any DBI shortcut interface to execute the SQL for the desired results.


In reply to more on MP3 data to database by princepawn
in thread Save MP3 Tag's to Database with SPOPS by jeffa

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":