I'm trying to find a fairly clean solution for sending a single print job to the "printer" and simultaneously send the same print job to either email or a PDF file on the server. Anyone ever had to do this and/or know the best way to do it? There are program out there, but surely there's a way...
Thanks for the input - but it didn't help. I've got a 1200 series - and the link was for a 1300 series - I'm specifically missing the ap-root option. Anyway, I have looked at the manuals - and is says to to a no station-role root - but it reponds with a cannot delete. The mode button (I...
Ok... I feel like an idiot, but I've put a Cisco 1231 access point into bridge mode - and I can't get it out. I've got console - but it's somehow stuck in bridge mode. I can't find squat on cisco's web-site other than the manual which speaks nothing of disabling the bridge! Any ideas anyone...
r937,
That works great! It never ceases to amaze me how seemingly little innocuous syntax variations can have such a profound effect on a project! Is the key to this subquery the "expr1 from " component?
Thanks,
Chris
It's the code I posted above (on the first post). I launch the query directly to view the data - and I can sort by column 3 - and it remembers how I sorted the 'view'. I can change the SQL to say sort by 1 and the launching SQL directly still bring up the previous view settings. Thoughts...
PHV,
Thanks for the response - but that code gives me an aggregation error with PNAME. Only problem I'm really having at this point is getting the order by to work. - using ORDER BY "Expr1" ASC;
but it's not ordering the results...
Thanks,
Chris
Could anyone critique this syntax for me?
SELECT dpch.pname, dpch.pnum, (select count(*) from proquick where proquick.rph=dpch.pname) as expr1 from dpch;
Anyone see any problem with this? I'm trying to get a count of proquick instances per pname's in dpch.
Thanks,
Chris
TomThumbKP,
Thanks for the pointer... that's was the way I was beginning to lean (global variables). However, you mention 'dictionary' - but this is new to me... is it designed use as a variable type operation? I'll have to dig some more here.
Chris
AceMan1,
The problem is this... I'm using several stub counters and flags as I step my way through this text file and passing and keeping track of this and additionally, reporting back the HAM, if you will, makes structuring such a function that's expecting a position and returning the data...
I'm in the process of writing some extensive logic algorithms (lots of if-then-else) to interrogate poorly formatted text data files. What I'd like to do is streamline the code such that I can create a function to call into my main sub but have access to all the main subs variables (without...
I have two domains (A and B) running in live environment.
I have a W2k/Ex2k/DC machine in domainA and I want to move the machine to domainB. I'm not sure about the message store impact among any other issues that may arise. I've seen most people creating a new EX2k machine and doing a SWING...
Thanks fishi - I can see how that would be a problem. I tried them originally, but I think I was not completing it right or something. Anyway, I'll probably go back to it!
Thanks,
Chris
BTW - I love your Maurice quote. Dang if that doesn't personify ALL of IT.
Actually, I figured it out. The where clause was using = and comparing the exact length of the field. When I changed the where comparison to use LIKE it started working.
Thanks!
Chris
I'm fairly new to PERL and DBI, but from the standard examples I've been able to follow, this should work:
$dbh=DBI->connect($dbName, $dbUsername, $dbPassword);
$sql="UPDATE vs SET dc2='$fcriteria2' where dc2='$fcriterian'";
$Updaterecord=$dbh->do($sql)
# note: $fcriteria2 and $fcriteria are...
Dude, you have now idea how POWERFUL this is!!!! THANK YOU!
Wow... very cool!
YEEESS!!!
At first I thought the dcount was returning something that was incompatible with the count'd value (like instead of a zero a null, or somesuch) but, as usual, it make perfect sense!
Thanks!
Chris
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.