Search results for query: *

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?

Thanks for the response. Yes, my board works fine, as I can put in other drives and have them properly detected. I haven't yet tried the drive on another computer yet, but I will give it a try.

My hard drive (Western Digital WD800JB Caviar 80 GB) crashed and is now not being recognized by my BIOS. It just doesn't even acknowledge that it exists. So, I'm trying to enter the values in manually in the BIOS. I went to the WesternDigital site and got the following information about my...

Hi everyone, First off, I'll get this out of the way... Yes, I know I SHOULD have backed up! I'm really sad that I didn't do it more frequently. Hind sight is 20/20. Now, I have a hard drive which crashed, and I need to recover data off of it. Here's how it crashed: For a long time, when...

xlbo- I've tried out some different code, but am now getting the following results: What I see in the cell: ggg gg What I see in the format string from the spreadsheet: \g\g\g \g\g What I see in the formula bar: 30634,12 So, it makes sense why I'm seeing what I'm seeing (i.e. "ggg gg")...

Well, I found this code: Declare Function GetLocaleInfo Lib "kernel32" Alias "GetLocaleInfoA" (ByVal Locale As Long, ByVal LCType As Long, ByVal lpLCData As String, ByVal cchData As Long) As Long Public Function ReadLocaleInfo(ByVal lInfo As Long) As String Dim sBuffer As String...