Recent content by kb2001

I had an odd setup come to me, and I'm having trouble getting it working correctly We have an apache instance running to serve 3 instances of an application, each with a different context app.domain.com/app1a/ app.domain.com/app1b/ app.domain.com/app1c/ Each of these is forwarded to tomcat...

I have the piece to split the data out into an array, to put single quotes around the strings, though not eloquently. That was easier than I thought, but I have no idea where to begin on how to put them into the SQL statement in order replacing the ? #!/usr/bin/perl open(DATAFILE...

I am new to perl and am looking for a starting point or approach to my problem. We have an application that generates a SQL statement to run a data extract. The SQL has multiple ? throughout. These are replaced by a list of values that are comma delimited. I am looking for a way to take the...

Thanks for the suggestions guys. I appreciate it, and still welcome more. Stretchwickster- I checked out the monoslideshow. It costs money, so for me that one is not really a viable option. Although it looks to have some great functionality that I could take advantage of down the road when...

I am building a site to host pictures. These are pictures of my family for the past 60 years and everything is password protected. The website is written in PHP, and the data is served up from a MySQL database. I am looking to add a slideshow feature. The idea is that people will be able to...

Hi Vragabond- I feel dumb now, I didn't even look at the FAQ's. I just began searching the forum for different things that might trigger a result that would be useful to me. I even went so far as to just start manually going back and looking at every thread title to see if I found a relevant...

I am working on a web page that displays pictures from a search that queries a mysql DB. I would like to display them 30 at a time and just have links, "next" "prev" and pages 1, 2, 3, 4, ... etc to limit the number of pics that are displayed if the user gets a lot of results. Standard search...

jpadie- Just got the time to try this tonight. It works like a charm. I deleted my pic_align columns now and am just using the getImagesize function to discover the aspect. Works perfectly with a little concatenation to get the path/file down. Also, I changed my audio field from BIT to...

I didn't see your last post until now, but I ran the first example and here a couple of the result sets (one for each value of pic_align) pic_id 26 string year 1952 string event Madison, Conn string audio string comments NULL dir1 box1 string subdir 1C string filename BX1_1_C_03...

jpadie- Thanks for your help with this. I'm at work now, but will try this when I get home and post the results back. I checked the type of that field yesterday using is_* functions and found it to be a string. The values returned escape me right now, but it was a strange character for...

jpadie- Thanks for the reply. I already went ahead and made another column, pic_align2 CHAR(1), so I could move forward. I'd still like to use a bit field, though (it's more preferable with 20,000+ photos). The (bool) addition you recommended didn't work. Maybe I'm missing a library or...

Almost forgot. I'm using: MySQL 5.0.22 Apache 2.0.58 PHP 5.1.4 mysqli functions are being used for my queries.

Forgive me if this has been covered, my searches gave me no answer. I have a database storing info about pictures. I'm building a website using PHP that queries this DB and returns pics along with some info about the pics. The problem starts with the picture aspect. Some pictures are...

vipergg- Thanks for replying. I'll try to provide some more insight into this. The sites are either fibered, or tunnel through the backbone. But, they are "directly" connected (as far as config goes). Each site just has a L3 switch and a handful of machines. I don't why spanning tree was...

We have a problem. We have multiple devices deployed across 500 miles that are running spanning tree protocol. We need to get this disabled. The obvious problem when you disable it on one, the others go into infinite loops and we can't access them remotely anymore. I don't really want to...