in reply to Re: SPOPS compared with Alzabo
in thread Save MP3 Tag's to Database with SPOPS

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.