Thanks to all of you for answering my question.
Regards
Oracle Monk
Hello
I have written a few report programs where I separate the SQL from the
code by using HTML::Template to access the SQL files.I used
HTML::Template mainly because I was already familiar with it from CGI
uses and it did the trick ( handling ASCII files ( SQL statements ) and
outputting
To: "'Oracle Monk'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject:RE: including sql files in a main perl script.
>
> Hi all,
>
> I want to know is it possible to include .sql files in a main
> perl scr
If you want to run the program from any machine then you
Should look at DBD::Proxy as an alternative way of connecting to
The database.
In this case you would only need perl,DBI,DBD::Proxy on the "client"
side of things. I agree with the other chap who responded in that
Storing the sql in packag
7;; [EMAIL PROTECTED]
Subject: RE: including sql files in a main perl script.
>
> Hi all,
>
> I want to know is it possible to include .sql files in a main
> perl script?
Sure.
>
> I don't want write sql statements inside a perl script,
> rather i want to keep
>
> Hi all,
>
> I want to know is it possible to include .sql files in a main
> perl script?
Sure.
>
> I don't want write sql statements inside a perl script,
> rather i want to keep the sql files in a seperate folder and
> then use a perl script to read those sql files, prepare them
> an
tions instead. i.e. ban raw SQL.
Regards
Chris
- Original Message -
From: "Oracle Monk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 27, 2004 7:27 AM
Subject: including sql files in a main perl script.
Hi all,
I want to know is it possible t
Hi all,
I want to know is it possible to include .sql files in a main perl script?
I don't want write sql statements inside a perl script, rather i want to keep the sql
files in a seperate folder and then use a perl script to read those sql files, prepare
them and then execute them as we can d
