Search results for query: *

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, 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 all, Not been programming for a few years now and starting to lose my mind with this one. It should be easy but I just can't get my head round it. The table consists of a number of fields with the following being the only ones relating to this issue: id - multipleslot -...

Hi all, We are currently going through a rebranding of our company and as such, have a new site just launched. Any comments/suggestions are very welcome. If you don't like something, please tell me why and don't hold back. :) www.yetihost.com Thanks in advance, Wullie Fresh Look - Quality...

Hi, Over the last 48 hours, we have one server with the following error happening randomly. It might go 10 hours without happening, then happens twice within an hour. (There is no obvious pattern) Logon Failure: Reason: An error occurred during logon User Name: Domain: Logon Type...

Hi all, I just want to take a few minutes to wish everyone a Merry Christmas and a Happy New year! (Or any alternative holidays you may celebrate) I realise this may be a little early for all you US folks, but it is Christmas eve here afterall. [smile] Wullie Fresh Look - Quality Coldfusion...

Hi all, I'm trying to loop through multiple MySQL databases to get the names of every table in them and I'm hitting a problem that probably has a simply solution but I need another set of eyes to check. I have more code than below however this is the stripped down version of where I am hitting...

Hi All, Strange problem we have here and I'm looking for some insight on it. On one of our MySQL machines, everything was working fine until we rebooted a few days ago. Immediately after the reboot, some database connections were failing with: "1016 - Can't open file: 'xyz.ibd' (errno: 1)"...

Hi all, This is the first time I've ever needed to do anything with XML using Coldfusion and I'm getting a little stuck here. The XML file I am parsing is the following: (This is a cut down version) <?xml version="1.0" ?> <Results> <ResultCode>0</ResultCode>...

Hi all, We are having a problem with a machine and we can't figure out the cause, so I'm hoping that someone here can possibly shed some light on it. We are getting the following stop error randomly: 0x000000c2 (0x00000007, 0x00001153, 0x02060002, 0x86c76408) There is no obvious pattern for...

Hi all, I've just had our site redesigned to make room for new services and looking for any and all feedback. [smile] http://www.freshlookhosting.com I'm aware of a few small things (mainly design problems during the signup process) and these are being worked on. Thanks in advance, Wullie...

Hi all, Does anyone know of a quick way to round a price upwards to the nearest 99 or 49? For example: 12.23 would become 12.49 12.52 would become 12.99 Thanks in advance, Wullie Fresh Look - Quality Coldfusion Hosting www.tutorial-world.com The pessimist complains about the wind. The...

Hi all, Put a redesign of our site up a few months ago, just looking for any comments, good or bad. www.freshlookhosting.com Be honest! [smile] Wullie Fresh Look - Quality Coldfusion Hosting www.tutorial-world.com The pessimist complains about the wind. The optimist expects it to change...

Ok guys/gals, This is really puzzling me and I've tried everything I can think of. I know some may think this is a PHP issue, but it seems to me to be Apache causing the problem. (You will see why I think this in the following) Specs: Windows 2003 Apache 2.0.50 PHP 4.3.8 The following is in...

Hi all, A while back there was a post asking for opinions on a freelancing site for graphic design. The owner posted answering the questions we had about the site but now that thread seems to have disappeared. Anyone know the site in question? Thanks in advance, Wullie...

Hi all, I've just started getting an error on a site but have no idea what is causing it. unexpected constant #140 -1 Now, the strange thing about this error is that only this one site is affected, and none of the others are. The error still appears no matter whether the file is blank or...

Hi all, I'm nearly complete with this site and just want to get some comments on it, good or bad. Before anyone views it, the content may be offensive to some people, this is an adult site. (In no way a porn site though) If you have read the above and still want to see it, it can be found at...

Hi all, I'm building a new control panel for hosting and attempting to setup a section that allows users to manage their own dsn's. I have managed to set this up so that I can dynamically add dsn's that show up in ODBC admin but cannot get it to add them to cf admin. Because cf admin doesn't...

Hi all, This is an unusual request but a client asked me today if it was possible to download the whole Internet so that he could surf without a connection. My thinking was to download the whole thing, zip and burn it onto a few CD's and then he could just insert CD1 for half and CD2 for the...

Hi all, I have encountered a serious problem with CF MX and was hoping that someone on here knows a fix for it or can point out a stupid mistake that I have made. I have 5 virtualhosts on an Apache server using Coldfusion and noticed that some of the domains were overlapping and showing pages...