Database
petro...@my-deja.com
write/test code written in PerlScript. The language is very new to me,
but with some experience I think it will be very useful.
Creating static HTML/JavaScript code is boring. ASP/PerlScript offers
what I've been looking for -- creating HTML/JavaScript on the fly using
information from other files. The read/write restrictions imposed for
security reasons on the Internet do not allow client side programming
of any value. I've never programmed server side applications, but this
looks very promising.
I'm looking for an example for dealing with information in a database.
Does anyone have a sample PerlScript for any type database? In the case
of ASCII? Binary? or SQL?
Sent via Deja.com http://www.deja.com/
Before you buy.
Tobias Martinsson
> I'm looking for an example for dealing with information in a database.
> Does anyone have a sample PerlScript for any type database? In the > case of ASCII? Binary? or SQL?
It's an in-depth topic, but the ActiveX Data Objects (ADO) are used in Active
Server Pages environments when accessing databases. You do not have to use
them, but it's kind of the industry standard and real useful. ADO can read
ASCII-files. although I'd say Perl/PerlScript latently is more suited for
this. ADO, however, proves its real strength with databases such as MS
Access, SQL Server, Oracle, or any other ODBC data source such as an Excel
spreadsheet.
The easiest way to access a database, but also the one not to prefer, is to
create a DSN and then access the database. A quick description on that is at
http://www.perlscripters.com/SQL/default.asp?Which=SystemDSN and doing some
minor works with it can be seen at
http://www.perlscripters.com/PerlScript/Database/open.asp?Which=DB_Connection
It is the basic stuff. What you essentially wants to do is to use the native
data provider for the connection instead of a System DSN or other type of
DSN's since the DSN takes a reroute to the data store/database. However, it
is useful for getting started if it is the first time around. Visit also
http://msdn.microsoft.com and their library where you can find the whitedocs
on ADO in the library.
When you get started with this and have more specific questions, I can give
more specific answers. :) ADO is just a very large subject-matter, and it
takes some general experimenting at first to see why something is better than
something else.
--
Tobias