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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Killing processes
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... -
Editing an XML file
Hi there, What's the easiest way for me to edit a couple of attribute values of an XML file using Perl? Thanks! -
Date comparing
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)... -
Regular expression help
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? -
Looping between dates
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... -
Using a column name in the select
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...- Zippeh
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Hash->Hash->Array!
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... -
Incrementing a string??
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... -
error '80020009' with DatePart
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")) & "/" &...- Zippeh
- Thread
- Replies: 8
- Forum: Microsoft: ASP (Active Server Pages)
-
Perl SAX - reading attributes
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 =... -
Best way to process XML?
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... -
DBI killing IIS
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? ... -
Playing with XML::Simple
Is there any way of getting XML::Simple to retrieve a remote XML document over HTTPS? -
Reading XML over HTTPS into DOM
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... -
Multiple rows in one column
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...- Zippeh
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
Weekday ordering...
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...- Zippeh
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
IIF question
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...- Zippeh
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Regular expression fun :)
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... -
Perl DBI Insert Problems
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... -
Execute permissions on a table?
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...- Zippeh
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
