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...
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...
Thanks Ygor-
First script did the trick. It inserted extra newlines at the end of each row ( \r\n\n ) but it got the job done and I cleaned that up with excel
Thanks
-Kevin
The trouble is, you now have 5 tab-separated fields instead of 4."
That actually is what I'm seeking. The ODB has the info in 4 fields. The SDB has it in 5 fields, the address is two fields instead of one.
"123 cherry way" should be field address1
"Apt 21" should be field address2
The way...
Also,
I can pull out this one field and organize the data that way if will be easier,
123 cherry way\nApt 21\n\r234 apple way\napt 23
If that will make it easier
Hello-
I have an interesting problem. We are extracting data from one DB (Oracle) and need to insert it into another DB (MSSQL). Data transformation is not possible in this manner. B/c of the situation, we will need to dump the data to a spreadsheet/text file and load it into the MSSQL...
Hi RealShea-
Unfortunately no it is not promoted. I also finally heard back from the head developer for theis integration, the company guru, and he informed of the same thing you did. I suppose I'll just have to use HAT for this one. Thanks for your help though.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.