Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Add record in access table

by MZSanford (Curate)
on Feb 08, 2002 at 16:55 UTC ( #144142=note: print w/ replies, xml ) Need Help??


in reply to Add record in access table

When using DBD::ODBC you need to use ODBC Standard SQL. I have used this for accessing diffrent ODBC databases, and i believe the following will work (but it is untested) :

my $query = q! INSERT INTO logfile ("Date Send","Certificate file") VALUES ({d '2002-01-01'},'junk') !; # other code here
Sorry, but on my current machine i dont have the ability to test this code :/. Win32 Perl Programming : The Standard Extensions covers some of the ODBC specific SQL stuff.
from the frivolous to the serious


Comment on Re: Add record in access table
Download Code
Re: Re: Add record in access table
by Anonymous Monk on Feb 08, 2002 at 17:52 UTC
    Thanks that worked. Appreciate it.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (4)
As of 2015-07-06 03:00 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 (69 votes), past polls