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 Chriss Miller 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: Quimbly
  • Order by date
  1. Quimbly

    Making string replacements on all strings in a column

    Thanks, guys. That did it!
  2. Quimbly

    Making string replacements on all strings in a column

    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", '- ', '-')...
  3. Quimbly

    Making string replacements on all strings in a column

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

    Making string replacements on all strings in a column

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

    Error at XP Start-up

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

    Error at XP Start-up

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

    Please help optimize this query

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

    Query takes too long to run - help me optimize

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

    safe conversion from string to integer

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

    safe conversion from string to integer

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

    String to integer conversion -- mid query

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

    Ghosting an image on a single PC

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

    Ghosting an image on a single PC

    How do you do it?!
  14. Quimbly

    Ghosting an image on a single PC

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

    Recovering data from a dead hard drive

    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?
  16. Quimbly

    Manually entering hard drive specs in BIOS

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

    Manually entering hard drive specs in BIOS

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

    Recovering data from a dead hard drive

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

    FormatNumber problem

    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")...
  20. Quimbly

    Determining system regional settings in VBA code

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

Part and Inventory Search

Back
Top