Search results for query: *

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

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

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

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

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

I have a stored procedure that takes a value out of the database (eg. A001UD7) and recursively increments it. If the value is a 9, the next should be A, and if the value is Z the next is 0. Here is the stored procedure: SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER PROCEDURE...

I am using the Spreadsheet::WriteExcel module for the first time. I create a spreadsheet in a directory. If I ftp to that server I can download the spreadsheet and read it just fine. So I decided to mail it using MIME::Lite. It appears to come through OK to my email client (Outlook), but...

I have an odd character named file,and I cannot open it. I am using: open(SUBJECT,'/var/www/cgi-bin/dargalbroadcast/Fri\ Dec\ 13\ 13\:45\:09\ 2002subject'); or I actually put teh filename in a variable and call: open(SUBJECT,"$filename"); The file won't open, any ideas?

I've been working with MIME Lite to do some HTML formatted email. Ih ave it working great, except for one thing. The return-path. Although I specify replyto, from, errorsto all to a valid email address, the return-path in the message headers is always different. Generally it relates to the...

I'm experimenting with LDAP, and my limited knowledge of LDAP itself it causing the limitations. I have been able to connect, but only as an anonymous user. And when I use select * , I get no results (but no errors). Has anyone else played around with this? I thought it would be much easier...

I have a form which calls upon an ASP script which actually processes the payment through our bank. Then based on a variable located on the first form redirect to a different page (a custom receipt more or less). What I need is to access the transaction object and its properties on the receipt...

I have a perl script that securely transfers a file from the machine that is runnign the script to another. I am using the linux scp command. I have secure keys generated on both machines and via command line the scp command works, within the script it doesn't. Here is what the script is...

Hi there. I have a website with cookies created when a user is logged on. Some pages should only be viewable to those logged in. Here's what I've got, but it's not working: <? if (isset ($cookie)) { return false; //do nothign } else{ header(&quot;Location...

After having this discussion with a colleage I'm looking for more opinions. From a programming standpoint, why would on always use a stored procedure over a sql select statement. What are the pros and cons of each? If the point of writing the procedure is to only select a field or two from...