Recent content by CherylD

Well storing the filenames was not something I could do as another system was storing blobs and I hadt o be able to tie into that one. Good news though, a solution was found. And it didn't even involve using the functions as described anywhere else. A simple insert statement was inserting the...

I've been using this combination of things for sometime with no problems until now. The problem now is that I've started to work with BLOB type data (images). I've found examples of this working and have replicated only to get a syntax error. Here is my error, which occurs at...

I'm looking over a colleague's code and they start off a script with: if (undef and 1) { } Does anyone have an idea about what this represents? Nothing occurs in this script before this point besides a few use statements: use strict; use Dargal::Web; use File::Find; use Data::Dumper;

Say I have a string: " This is a sting 123-456" I want to pull out the item at the end of the string which will always contain the charcter "-" with characters before and after it. I need some help with the regexp on this....Any suggestions on where to start?

I rewrote the stored procedure to a function and I have exactly what I need. Functions are very handy.

I have a large query that I've been building into pieces. I need to select one row for each product. But a join on the itinerary for each product would return multiple rows. What I have done for the itinerary is written a stored procedure to concatenate each of the itinerarys into one item...

I'm using the HTML::Parser module and everything is the way that I want it. What I want to do is set a temporary cookie before parsing the html page. Any suggestions on how to do this? Here is what I am trying to do (which doesn't work): print header(...

I am wondering if anyone here has ever had the instance of using 2 diffent DBIs, one connects to a Postgres table and one to a SQL 2000, but has written one sql statement. I am interested in joining the 2 different tables in a sql statement. Now I can still manage to do what I want, but...

You can find one in the master database: exec sp_stored_procedures

The HTML::Parser works too.

To attach with MIME::Lite, here's some sample code: $msg->attach(Type => 'image/gif', Id => 'myimage.gif', Path > '/path/to/file.gif', );

I have a hash of values that replace holders within an rtf document. when one of the hash values ($dict{COMMENTS}) contains a single quote the whole value is not placed on the document. This is what is being done: foreach $key(%dict) { $dict{$key}=~ s/\*/\\\*/g; $dict{$key}=~ s/\'/\\\'/g...

Or if you know what name value pairs you are using you can leave the script as is and run via command line like: perl script.cgi name=value name=value name=value

Does anyone know how to retrieve the URL of the current page? I've got an .shtml file which includes a perl script. Within that perl script I want to dynamically determine what text to show. To do this I would need to know the URL that I am on and based on what is in that URL would decide...

I'm using a where clause that checks a description field, and selects where that description is NOT like something. For some reason, this excludes all records whose description field is null. EG. WHERE sysdba.SALESORDERDETAIL.DESCRIPTION NOT LIKE '%Membership%' If description =...