Search results for query: *

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 =...

Well, that didn't change anything, so as a work around I have altered the spreadsheet so that there is a quote before the formula, making the formula the text value of a cell. This will do. My next problem is that when I have a link in that Excel spreadsheet that links to other sheets in the...

I'm working with a template excel file on a linux machine. I read from this file, use sql to gather a few bits of info, and then write this file again with the info filled in. The reason Excel is being used is because the management created this file and will frequently change it, but will...

my $sql = "SELECT ACCOUNTID " . "FROM sysdba.ACCOUNT " . "WHERE (TYPE = 'Agent')"; $agentarray = $dbh->selectall_arrayref($sql); my $index = rand @agentarray; $parentid = $agentarray[$index]; I'm trying this but, $parentid is always blank.

I'm wondering if there is a way to fetch the results of a query into an array. Not the row results in an array, but the whole result set. The SQL query is only pulling one field. The reason I want to do this is I want to get all the ID fields and then put that into an array to then be able to...

Even on a return of @key, the value is still the same.