Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DBD::Sybase and TDS for SQL 2000
...using the functions as described anywhere else. A simple insert statement was inserting the images/files, first it had to be unpacked. For anyone's future reference here is what worked: $heximg=unpack('H*',$image); $q = "INSERT INTO IMAGES (image) VALUES (0x$heximg)"; That was it! -
DBD::Sybase and TDS for SQL 2000
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... -
if (undef and 1)
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; -
matches and regexp
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? -
Join on a stored procedure
I rewrote the stored procedure to a function and I have exactly what I need. Functions are very handy.- CherylD
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Join on a stored procedure
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...- CherylD
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
HTML::Parser and Cookies
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(... -
TWO DBIs ONE SQL Statement...Possible?
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... -
Stored Proc to list stored procs
You can find one in the master database: exec sp_stored_procedures- CherylD
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Can anyone tell me how to parse HTML for anchor tag info
The HTML::Parser works too. -
mail with several attachments
To attach with MIME::Lite, here's some sample code: $msg->attach(Type => 'image/gif', Id => 'myimage.gif', Path > '/path/to/file.gif', ); -
escape single quotes in a hash
...($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; #THIS DOENS'T SEEM TO BE DOING ANYTHIGN $text =~ s/\%$key\%/$dict{$key}/g; } Any suggestions? -
running cgi from unix prompt
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 -
Retrieve URL of current page
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... -
WHERE with wildcards
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 =...- CherylD
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Perl and Excel - reading and writing formulas
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... -
Perl and Excel - reading and writing formulas
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... -
Fetch DB results into an array, not a row array
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. -
Fetch DB results into an array, not a row array
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... -
Stored procedure to loop and increment ints and varchars
Even on a return of @key, the value is still the same.- CherylD
- Post #6
- Forum: Microsoft SQL Server: Programming
