Vivek, You ask a very broad question. I wouldn't know where to begin with code samples. If you were to ask for some specific, "how do I do...?" questions, I'm sure you'd get some code examples.
You'll need to get the DBI modules installed, and the DBD-SQLite driver module installed into Perl. What you describe is pretty basic variable manipulation, and file I/O with some DBI thrown-in for good measure. IMO, Perl is very good at this kind of thing. You'll need some basic understanding of Perl references, too. If you're not already familiar with the Perl DBI, you should read-up on it. You can start at http://search.cpan.org/~timb/ with the DBI-1.54 (http://search.cpan.org/~timb/DBI-1.54/), where you'll find the module's docs. Also on the list page there is a link to "DBI Advanced Talk 2004" (http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index.htm), a PowerPoint presentation where DBI's author talks about some best practices, how to get best performance, and how to detect and deal with errors. It's been very useful for me. I didn't quite follow it all in the beginning, but as I learn more, I return to it, from time to time, and it makes more sense. -Clark ----- Original Message ---- From: Vivek Rajan <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, April 3, 2007 2:20:31 PM Subject: Re: [sqlite] sqlite and generate dynamic html I need to generate dynamic HTML from contents in the SQLite database. Display some text/tables and related. Upon clicking on the web-page, the web-page can generate another query and display subsequent queries as HTML on the web. On 4/3/07, John Stanton <[EMAIL PROTECTED]> wrote: > > What does the HTML have to do? > > Vivek Rajan wrote: > > Hello SQLite Community- > > > > For a personal project, I need to dynamically create HTML pages from an > > on-disk SQLite database. I don't need cross-network capability, I just > need > > the ability to query and dynamically generate HTML from an on-disk > SQLite > > database on a localhost (stand-alone unix machine). I am using PERL as > the > > API for accessing/querying SQLite. > > > > Has someone done something like this? Could you please post any code > > snippets, suggestions and/or pointers for how to do this? > > > > Thanks in advance. > > > > Rajan > > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > -- Vivek Rajan (503) 646-3985 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
