Recent content by Wullie

You have posted this in the Coldfusion forum. You need forum333 Wullie The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell Domestic Appliance Repairs

Hi, What are you actually trying to do? Are you passing this from a form when the user clicks submit or are you doing it in the background? From a form, you would simply write your form to pass either GET or POST variables and your receiving page would pull in those variables, or if you are...

Thanks guys. Much appreciated. :) Wullie The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell Story Choices - Your Story, Your Way

Hi Chris, Thanks for your response. Good to see some of the usual members are still here and posting on a regular basis. :) I originally went the same route as you but then was told that a postcode can technically within the rules cover more than one street in some unusual instances, so cannot...

Hi, You need to supply more details for us to provide a meaningful answer to your question. What are the specs of the machine? How much traffic are you getting at peak times? Are there any background processes running at the time it drops? What type of content are you serving? Dynamic/Static...

Hi all, Been quite a few years since I've had to deal with duplicates in MySQL and have a large database that I need to remove duplicate records from, so looking for the least resource intensive/easiest way to do it. I've got the following setup: id, postcode, street_address, postal_town...

Hi, What do you mean by "cannot get it to work"? Going by your current set-up checking the SSL certificates on the domains you provided, you have it set-up right and it is working. The https://www.site will through an error that it is an invalid certificate, which is correct as your...

Depending on how quickly you need to be notified of the entry and assuming you can't alter the scripts inserting the data, you could write a simple script to check the database on a schedule and notify you of any records matching -555. Hope this helps, Wullie The pessimist complains about the...

Can you post the exact code you are uncommenting? Wullie The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

Hi mate, Do you have data that is updated in real time and needs to be transferred over? By this I mean if you had the 2 sites live and people were hitting the old server, would there be any database inserts or any files written to the old server that would need to be transferred over or is...

Hi mate, Thanks, your query worked and is much quicker to run than the old one. Just curious though why the old code would have worked on the older mysql version but not the new one, anyone have any ideas? Thanks again, much appreciated. Wullie The pessimist complains about the wind. The...

Hi, I've just migrated a site between servers and now I'm getting a problem where the following query is just hanging. SELECT * FROM jobs AS Main WHERE id = (SELECT MAX(Sub.ID) FROM jobs AS Sub WHERE Sub.multiplejob = Main.multiplejob) AND daysuntilflag <= -1 AND currentstatus !=...

Hi, I use custom software to send lists so I personally don't have any experience with external mailing list software. However as nobody else has offered any suggestions, phpList are offering a hosted trial: http://www.phplist.com/hosted Hope this helps, Wullie The pessimist complains...

Hi Rudy, I posted in the Coldfusion forum because I had a few windows open and chose the wrong one to start the thread. TT doesn't give me an option to move the thread so it's stuck here unfortunately. :) I'll give that query a try later and see how it fairs. Thanks. Wullie The pessimist...

I think I have finially figured this out. SELECT currentstatus, daysuntilflag, multipleslot FROM jobs AS Main WHERE id = (SELECT MAX(Sub.ID) FROM jobs AS Sub WHERE Sub.multiplejob = Main.multiplejob) If anyone knows a less intensive way, feel free to point it out. :) Wullie The pessimist...