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!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sonnysavage

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

Part and Inventory Search

Back
Top