Recent content by kiperez

I found some article saying to use whatever the DBMS says to use... in this case it's $TIMESTAMP$... that doesn't work and I get an error saying "Driver]Data types are not appropriate for relatinoal operation" ugh! I get that error for pretty much everything I try.

oh yeah... I tried that too... still no luck. thanks for the suggestion though.

I'm having difficulty filtering on the current date in my MS Query from Excel. The ODBC driver for Remedy has a $TIMESTAMP$ feature but I keep getting errors. I've tried Now(), Currdate(), Current_Date, Today everything I can think of even sysdate (like in Oracle) but nothing seems to please the...

Yes. I do ... use Net::Pop3; # Constructors my $conn = Net::POP3->new("mylotusnotes" , Debug=>1) or die "[err] There was a problem connecting to the server mailhost.noc.duncllc.com\n"; ... and it bombs!! Of course that's a Lotus Notes Server... I'm trying to get access to another Pop3...

Look for this module and it'll show you everything you need to know to send emails with attachments: dbgmailr-2.0.zip I"m wokring on the grabbing emails w/ attachments now.

We have a Lotus Notes server and I am trying to use the Pop3 module to access it to grab a message and save off an attachment. Unfortunately, I'm stuck at steo on - Connecting. I'm using the same server as I do for the SMTP connection to send messages. Do I need to setup something on the...

missbarbell. I can imagine many instances where a cross-platform environment would wish to not just create, but also to open an existing spreadsheet (to preserve those formulas, of course), modify some cell values and save it off to a different filename. as of yet, there is only one way to do...

I tried using MIME::Entity before and I couldn't get it to send the message. I keep getting "Connection not established". Attaching File: N:/Mercury-Topaz/HotelSearch-Reports/Response Times - Friday 02- 11-2005.xls Failed to send the message: Connection not established in your send_mail...

I'm using SMTP on a Lotus Notes network and for some reason when I use MIME::Lite, the address of the person I'm sending it to doesn't get resolved. If I use NET::SMTP or MIME::Entity or MIME::Base64 I get the message but there is no attachment. If I use those last lines that are commented out...

I need to send an attachment programatically using Perl... I tried MIME Base64 but the file isn't really an attachment -- it's part of the message body. how do I do this?

I need to have a chart of the top 25 rows returned from a query. Doing this with the group expert breaks it out by the group and I want this for the whole report. I am counting number of records per the field eventtype. Can I get there from here?