Recent content by Quimbly

Thanks, guys. That did it!

Sorry, I'm new to SQL and MySQL. I can't seem to get this to work. The table name is: quote The column name is: quote_display I've tried running several different versions: REPLACE (`quote_display`, '- ', '-'); REPLACE ('quote_display', '- ', '-'); REPLACE ("quote_display", '- ', '-')...

Ok, here's the deal. I'm running a MySQL DB for my website. In the database, I have a table for quotes with two columns: id and quote_text. For all rows in that table, I want to replace any instance of the substring "- " with "-", in the quote_text column. So, here's a sample from the...

I want to make a string replacement (and update) to all strings in a column of a table. In other words, for every string in a column of a table of my MySQL DB, I want to replace a substring in those strings with a new value. I've found the REPLACE SQL function, but I don't know the syntax to...

Solution: There was an extra (and funny) value in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run registry key which was launching the bogus process. The executable name was masquerading as svchost.exe.

I recently installed some crappy software that I suspect was somewhat malicious. Now, whenever I boot my system, I get a run-time error '13' popup window. The title of the window is "CPP Change" -- real helpful. I'm trying to figure out how to remove it from my system, permanently. I have run...

Hi everyone, I've been trying to get this query to run quicker. Currently it just takes too long. Does anyone have any suggestions about optimizing it? SELECT DISTINCT outerquery.name, "group" FROM analog outerquery WHERE EXISTS (SELECT * FROM analog innerquery WHERE innerquery."group" =...

Hi everyone, I've been trying to get this query to run quicker. Currently it just takes too long. Does anyone have any suggestions about optimizing it? SELECT DISTINCT outerquery.name, "group" FROM analog outerquery WHERE EXISTS (SELECT * FROM analog innerquery WHERE innerquery."group" =...

The problem with using Val() is that it returns 0 when the input string is non-numeric. So, from my example, Val(fieldA) where fieldA is "X" or "N/A" will be returned in the results set for the expression: blah blah blah WHERE Val(fieldA) < 5 ..which is not good. I want the records with...

Hello, I'm no expert when it comes to SQL, so go easy on me. I'm a novice. Here's the situation: My VB6 code is constructing an SQL query string which will eventually be passed to my Access DB. There is a field in the DB which is text, but which also contains numeric values. Here are some...

Hello, I'm no expert when it comes to SQL, so go easy on me. I'm a novice. Here's the situation: My VB6 code is constructing an SQL query string which will eventually be passed to my Access DB. There is a field in the DB which is text, but which also contains numeric values. Here are some...

I'm using Ghost 2004, and it doesn't appear to be doing what you suggest. What the heck?!

How do you do it?!

Hi, Here's what I'm trying to do: make a compressed image of my slave drive and put (write) it onto my master drive. To make it clear, I don't want to clone the slave drive onto the master drive (i.e. replace what is on the master drive with what's on the slave drive). The master drive is...

Thanks for the replies... It seems to me that the disk is spinning, Micker. As you suggested, I held the drive in my hand as I started it up. I feel it vibrating, and it seems that the platters are spinning. What next?