Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Inserting file into a database

by rbc (Curate)
on Jan 09, 2003 at 18:24 UTC ( #225596=note: print w/ replies, xml ) Need Help??


in reply to Inserting file into a database

Hi Anony,

I don't use Access very much. I usually use Oracle and
Oracle comes with a utility called sqlldr which is
used to load files into database tables. I bet Access
has similar functionality.

If not or if you just feel like it you can go with
the roll-your-own approach. But I would suggest using
"place holders" in your SQL ...

my $statement = "Insert into tableOne (filename, letter) values (?, ?) +"; ... $sth->execute($filename, $letter);


Comment on Re: Inserting file into a database
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://225596]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (15)
As of 2015-07-06 15:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (77 votes), past polls