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 strongm 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: *

  1. sonnysavage

    Query Table Not Indexable By...

    Well, it seems the the List I was using to access the column had a special, non-printing character at the end.
  2. sonnysavage

    Replicate CONNECT_BY_ROOT 10g Functionality

    Well, looks like no-one else is knowledgeable on this issue. I found another method of this. I can't detect a performance difference between the two. SELECT * FROM ( SELECT id, type FROM grp_groups START WITH id = 31 CONNECT BY PRIOR parent_id = id ORDER BY LEVEL DESC ) WHERE...
  3. sonnysavage

    Replicate CONNECT_BY_ROOT 10g Functionality

    Here's what I've found so far, and it works. Am I doing this the best way? SELECT id, type FROM grp_groups WHERE LEVEL = ( SELECT MAX ( LEVEL ) FROM grp_groups START WITH id = 31 CONNECT BY PRIOR parent_id = id ) START WITH id = 31 CONNECT BY PRIOR parent_id = id
  4. sonnysavage

    Replicate CONNECT_BY_ROOT 10g Functionality

    1) I am new to using hierarchical queries, so bear with my ignorance. 2) I need to be able to find the root node for any given node. There aren't any cyclical heirarchies, so the solution can ignore this possibility. The primary key column is labeled 'ID' and the hierarchical column name is...
  5. sonnysavage

    Regular Expression help

    Hmm... looking back, I see that bombboy already gave the answer: He simply had put forward slashes (/) instead of backslashes (\). Good job bombboy! I gave you a star. [2thumbsup]
  6. sonnysavage

    Regular Expression help

    I think you'll find this regex pretty slick. It will find ANYTHING that is not on the approved list... <!--- Regex tests ---> <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html...
  7. sonnysavage

    Query Table Not Indexable By...

    Bump
  8. sonnysavage

    Query Table Not Indexable By...

    This one is driving me nuts. I am accessing a query result like a struct, and getting this error: [Table (rows 8 columns ROW_INDEX, ORD, GROUP_TYPE, ITEM, CARD_TYPE, CARD_SUBTYPE, AVERAGE, CARD_MONTH_CNT, CARD_MONTH_AMT, YTD_CNT, YTD_AMT): [ROW_INDEX: coldfusion.sql.QueryColumn@157ed14]...
  9. sonnysavage

    preg_match question

    I believe this is what you're looking for <?php $thispage = $_SERVER['REQUEST_URI']; if (preg_match ("/(apple)|(banana)/i", $thispage)) { print ""; } else { echo "not an apple of banana"; } ?>
  10. sonnysavage

    PHP Editors

    I've just started using Notepad++, and I'm thoroughly impressed with it. http://notepad-plus.sourceforge.net/uk/site.htm One thing I noticed instantly is that it is fast. The default syntax colorings are nice, and easily editable. The Brace and Indent guideline Highlighting feature is...
  11. sonnysavage

    This USB device...

    Thanks bcastner! That fixed it! I'll have to make sure to uncheck those when I install a USB 2.0 card. Re: bankboysb, XP's notifications don't annoy me in general, it was just that this notification was completely useless in my situation. Thanks for all the input!
  12. sonnysavage

    This USB device...

    Yes, it does remove the balloon, but it does it wholesale: It also doesn't stop the icon that was appearing with the balloon from showing up. It just seems like a stupid programming mistake. Why would you display an alert on a system that doesn't even have USB 2.0 ports? Does anyone else...
  13. sonnysavage

    This USB device...

    I have a USB 2.0 Flash (thumb) drive, and my computer only has USB 1.1 ports. Every time I plug in the drive, I get this message in my system tray: Now I plan on buying a USB 2.0 card very soon, but this message is annoying in the meantime. Does anyone know of a way to get rid of it? Thanks!
  14. sonnysavage

    System Temperature Question

    Update: I found CPU Burn, and ran it for 10 minutes. My processor temp went up to 42C, and my case temp stayed at 38C.
  15. sonnysavage

    System Temperature Question

    My heatsink is a ThermalTake SilentCool. It's a pretty impressive all-copper cooler with a fairly large, yet quiet, fan. My guess is that the case temp is off (reading high), and that my HD and Proc temps are good. HD temps come from the S.M.A.R.T. capabilities of the hard drive, and I'm...
  16. sonnysavage

    System Temperature Question

    I set up an Athlon XP 2200+ (Thoroughbred), and have been running MBM 5 (http://mbm.livewiredev.com/) to keep an eye on my temperatures. My processor is consistantly staying at 2 or 3 degrees Celcius above the case temperature, and my hard drive is staying 2 or 3 degrees below. My case...
  17. sonnysavage

    Stopped Recognizing My USB Pen Drive

    No, it wasn't listed in the device manager. I did find the answer however. Mine is a unique situation. [greedo] I have two front-access USB ports on my case. The center "pin" of one of them broke off a while back. I had pushed the USB mass storage drive into the broken port, and then...
  18. sonnysavage

    Stopped Recognizing My USB Pen Drive

    I have a 512 MB USB flash drive. The first time I plugged it in, it was recognized, it installed, and I was able to transfer files to it. The second time I plugged it in, an error message came up (and I didn't write it down - d'oh!) about some device error or malfunction. Now when I plug it...
  19. sonnysavage

    focus() and highlight

    Jeff, you freakin' rock! Thanks! (a pink star for you [2thumbsup])
  20. sonnysavage

    Please Help!!

    What is your browser name and version? This info can generally be found under &quot;Help&quot; and &quot;About&quot; sections of the browser's menu.

Part and Inventory Search

Back
Top