[Tutor] Formatting String for SQL Insert

[Lloyd Kvam]

hcohen2 wrote:
(snipped)
> Lloyd,
>(snipped) 
> I do have a question, why other than say a web application would one 
> resort to using python and/or perl to process database data when one 
> could call stored procedures?
> 
> Herschel
> 

Well, you call those stored procedures from some application (maybe
Access?).  It's a matter of embedding those calls in the application
of your choice.  Some DB's (such as MySQL) do not have stored procedures.

You face the need to load data into the DB and the need to do something
with the data that you retrieve from the DB.  Python is an ideal language
for this kind of processing.  It can organize various sources of input
data into INDSERT and UPDATE commands.  It can also take the stream
of data returned by SELECT, transform it, and pass it on to
other processes.

-- 
Lloyd Kvam
Venix Corp.
1 Court Street, Suite 378
Lebanon, NH 03766-1358

voice:	603-653-8139
fax:	801-459-9582