Search results for query: *

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

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

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

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

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

How do you do it? In other words, at run-time, I want to determine the system regional settings and be able to test against the returned info. Of course, using something like MonthName(1), it would give me either an English name for January, or the word in some other language. But there's got...

I'm working with the VBA code behind an Excel report. The report has two entry points: Auto_open and another subroutine which is called by an application. Both entry points are basically indentical. In one of the date data fields, we're using a Numberformat of "ddd dd". Oddly, sometimes instead...

I come from the C-code world, where everything is 0-indexed: arrays, strings, DB records, etc. I've seen VB code that starts indexes collection objects from both 0 and 1. Which is it?! Or is it different from object to object? For instance, the first character in a string object is numbered...

Hello, I'm new to VB coding. Please take a look at the code below and tell me if you spot any problems. The purpose of this function is to take a string as input and to remove extraneous spaces -- that is, replace multiple instances of space characters with a single space character. The...

I'm developing a firewall log monitoring application in C# with the .NET framework, and I can't figure out something. I'm trying to do a reverse lookup on an IP address. I don't mean reverse lookup to a DNS entry. I'm looking to find out the computer-name behind the IP address. The only...