Recent content by tbohon

I am working on an AIX v5 box and the SAs are unwilling to load any of the 'cool' Perl modules for me. What I need to do is send files to customers using an existing script called mail_files (it can be found at http://personal.ecu.edu/spraguem/mail_files.txt Everything I've tried has failed...

Paul: Yes, we went back and double-checked all of the settings, etc. when this problem first occurred. We're sorting on the first two columns - acctnr and facilitycode - and doing the merge join on acctnr to pull the facilitycode over to the result set. Tnx. Tom "My mind is like a steel...

We're fairly new to SSIS (SQL Server 2005) and, in our first team effort, we've run into a problem we just can't figure out. Two sources are sorted in two separate Sort operations, sent through a Merge Join to pull a facility code out of one file and insert it into the second one and the output...

That is what I needed - well, that plus a night's sleep to ponder the problem ... <g> Thanks all - it's working great now. Best, Tom "My mind is like a steel whatchamacallit ...

I need to read through a text file and examine each line. If the leading and/or trailing character is a double-quote I need to truncate those characters. However, there are double-quotes within the line which are valid and can't be changed. I'm not looking for a solution, only some pointers -...

Annihilannic: Thanks - I'll give that a shot. We just added a third facility to the mix so I'm getting lots and lots and LOTS of messages every hour now. Appreciate it. Tom "My mind is like a steel whatchamacallit ...

PHV: Works as advertised! One more question on this general topic if I may ... This same script failed this morning with this error: rm -f /interface/ftp/prod/hpf/files_out/hci/* ksh: /bin/rm: 0403-027 The parameter list is too long. I've been told by a 'casual' Unix user that I could...

I'll give that a shot - haven't tried this particular combination :) Thanks! Tom "My mind is like a steel whatchamacallit ...

Here is the entire script that creates the file - it has ls -ltr in this latest attempt: #!/usr/bin/ksh cd /u/live/ftptemp ls -ltr ../filesin/*.ps > files.list And here is the error message I get when the number of files exceeds some value (not sure exactly what that is, unfortunately)...

I have a .ksh script on our AIX 5.x box which goes to a specific directory every hour and pulls the files to process and send to another server via ftp. However, when the number of files becomes large (tonight there were almost 6000 of them, other times there are zero or just a couple of dozen)...

I run a series of ftp scripts on an AIX box, connecting to both Unix and Windows servers for the drops. I'm occasionally having a problem with being unable to connect to the other server - 'ftp connection refused' type messages (although there are variations) - which, because the users aren't...

Is there a way in HTML to specify that a certain field is the default and to give it focus when the page loads? I have a login screen and would like the user ID field to have focus with the cursor sitting there when the page loads --- but I'm unable to figure out how to do it (or even if it can...

Miros: Error checks you suggested showed no database opened. Eventually traced it back to my config file - one silly little character off in the database name ... obviously the "do what I meant not what I said" flag hasn't been turned on here ... [wink] On the positive side, the debugging was...

r937: Yes, it was a php problem ... or, rather, a fat-finger-in-the-config-file problem caused by the loose nut in front of the keyboard. Problem was a one character typo in the config file ... fixed, works ... On the other hand, it was really good for me to work through the mysql and php...

Follow-on information: Here is the table structure of the categories table: id tinyint(4) name varchar(20) Here is a query and results from that query to show what is in the table: SELECT COUNT( * ) AS `Rows` , `name` FROM `categories` GROUP BY `name` ORDER BY `name` LIMIT 0 , 30...