Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Wullie
  • Content: Threads
  • Order by date
  1. Wullie

    Removing duplicates from large amount of records

    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...
  2. Wullie

    Query hanging

    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 !=...
  3. Wullie

    MySQL Query

    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 -...
  4. Wullie

    Site Review

    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...
  5. Wullie

    Event ID 537

    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...
  6. Wullie

    Merry Christmas!

    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...
  7. Wullie

    Dynamically Getting MySQL Table Names

    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...
  8. Wullie

    Disappearing Database Files

    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)"...
  9. Wullie

    Parsing XML

    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>...
  10. Wullie

    Stop Error

    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...
  11. Wullie

    Site Review

    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...
  12. Wullie

    Round number upwards to nearest 49 / 99.

    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...
  13. Wullie

    Site Review

    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...
  14. Wullie

    Open_Basedir Issue

    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...
  15. Wullie

    Freelancing Sites

    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...
  16. Wullie

    Unexpected constant #140 -1 Error

    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...
  17. Wullie

    Website Review, ;-)

    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...
  18. Wullie

    Dynamically Adding DSNs.

    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...
  19. Wullie

    Internet Download

    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...
  20. Wullie

    Serious problem with VHosts &amp; CF

    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...

Part and Inventory Search

Back
Top