Search results for query: *

Hi there! I'm writing a script that is supposed to kill a single process if the memory usage gets too big. I'm using the Win32::OLE library to do it. Thing is, the process I want to kill is running as a different user to what the script will be running as. Is there any way I can kill this...

Hi there, What's the easiest way for me to edit a couple of attribute values of an XML file using Perl? Thanks!

I need to find all the files in a directory that havent been modified in the past 7 days. I've got my script to so far find the last modified time using the following: use File::Find; my $age; @ARGV = qw(.) unless @ARGV; #Darllen o'r current directory os dim paramedr find(\&nolFfeil, @ARGV)...

Hey! I want to write a small regular expression to replace "&" with "&" in URLs. Some of the URLs already contain the "&" so I want to skip these ones. So I need a regular expression that will ignore any "&" followed by "amp;". Any idea how I'd get about this?

Hi! I want to be able to loop between two dates. Say the two date are 2006/01/01 and 2006/02/01. What I want is to be able to access each day in the range so I can pass that day, and the day before it into a function. Hmm that doesn't make sense... My function is defined as follows...

Here is the SQL I need to use and I'll explain the problem underneath it! SELECT a.attachment_id, '"' + a.description + '"' as teitl_atodiad, '"' + d.title + '"' as teitl_dogfen, '"' + a.filetype + '"' as math_atodiad, 'http://www.gwynedd.gov.uk/' + a.filename as cyswllt_atodiad...

I've got this XML file that I'm trying to parse to take out some values to put into a CSV file. One part of the file is some "tax_lines" that are associated with some invoices. I need to take out the tax_lines so that I can put them with the invoice lines in the CSV. To do this I have decided to...

Hi there :) I have a reference that I read from a file that I want to increment. The reference is of the form: xx0001 where xx are letters and 0001 is a number between 0001 and 9999. What I want is to increment this number. I'm not concerned about what happens after 9999 at this moment in...

Hi there, I get the following error message when executing my ASP: error '80020009' /corystadegauelk/includes/ffwythiannau.asp, line 90 and line 90 is as follows: datAmserFynu = DatePart("YYYY", rstAmserFynu("test_time")) & "/" & DatePart("M", rstAmserFynu("test_time")) & "/" &...

Hi there, Trying to use SAX now to process my XML Document, but having some difficulties reading the attributes of an element. What I have is this: sub start_element { my ($self, $data) = @_; if ($data->{Name} eq 'batch') { print Dumper($data); my $batch_company =...

Hi, I got an XML file. The basic structure is something liek this: batches batch transactions transaction allocations allocation allocation allocation transaction allocations allocation transaction...

I have some code that executes an Insert to a database using DBI. When this exectue fails, I would like it to die gracefuly reversing the inserts that have taken place. Unfortunately, it dies a miserable death and takes IIS with it! Has anybody else come across anything like this? ...

Is there any way of getting XML::Simple to retrieve a remote XML document over HTTPS?

Hi there :) I'm trying to read a remote XML file over HTTPS into the DOM in my VBScript. Here is what I have so far... 'Set objXMLDoc = CreateObject("Microsoft.XMLDOM") Set objXMLDoc = CreateObject("Msxml2.DomDocument") objXMLDoc.async = False objXMLDoc.setProperty "ServerHTTPRequest", true...

Slightly odd question here... I have three tables, a USER table, a CENTRE table and a link table on user_id and centre_id. What I want to do is use ASP to print out the users along with the centres they work in. So i can have something like: Fred Centre1, Centre2, Centre3 Joe Centre1...

Bit of a long shot this. I have a column that contains either Monday-Sunday and would want these ordered by the order they are in the week starting with Monday. Is it possible to do this in SQL server without introducing a number column for each day, e.g. 1 for Monday, 2 for Tuesday and...

Hi, I'm trying to run a query that will look at the value in two columns and put it into another column. I have two columns, policy_number and map_number. If there is a policy number, then there isn't a map_number and vice_versa. I now have a third column called display_number. What I want is...

Hi there, I'm reading from a logfile and trying to pull out some querystring data. The querystring could be as follows: cat=xxx&doc=yyy&anyotherdata cat=xxx&anyotherdata doc=yyy&anyotherdata I need to pull out the cat and doc numbers. The regular expression I have so far works with the...

I'm trying to get some "INSERT" statements running on Perl but for some reason, the insert is executed twice! Here's a snippet of the code: Code: if(Encode::is_utf8("$line")) { $sqlstatement= qq{ insert into items...

Im having problems adding new data to a table using ASP with SQL Server 6.5 Even though im doing exactly the same thing as I have done with another ASP file with another table in the same database, i get the: [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on...