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...
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
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...
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]
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...
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]...
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";
}
?>
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...
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!
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...
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!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.