My name is Andrew Flerchinger and I live in Chattanooga, TN, USA working with SQL Server, VB.NET, and TFS.
Email: lorax3@gmail.com
AIM: Lorax3
Cell: I have gratefully managed not to have one :)
I'm not much on the beer drinking (queue shock), but my current major non-computer hobby is...
You're right, execution plan says dropping the derived table has 20% lower cost. They're puny tables and will always be, so in practice, it shouldn't matter, but always good to know. Thanks.
I've never really understood execution plans, past the whole % relative cost numbers, which sometimes...
...completely unable to formulate the SQL syntax for doing it. I need more sleep.
Thank you for the quick response. It works great.
-- Users
SELECT * FROM tblUsers
-- Reports Available
SELECT * FROM tblReports R JOIN tblUserReportAccess A ON R.ReportID = A.ReportID
-- Reports Unavailable
SELECT...
Thank you. Cross join is what my brain was missing.
- Andrew
Text::Highlight - A language-neutral syntax highlighting module in Perl
also on SourceForge including demo
I have a UsersTable with a UserID and a ReportsTable with a ReportID. I also have an AccessTable with UserID and ReportID for the reports each user has access to.
It's quite simple to get a list of reports users have access to, but how do I get a list of reports users don't have access to? I'm...
You can't take three words out of one book and try and make that kind of chaining argument. Even if God is love, that doesn't mean that all love is God. Even assuming that, I'm not sure where the link between love and thought came from.
But that does kind of sound like the movie Dogma: prove...
Absence of proof is not proof of absence. Everything else is semantics.
If something exists out of time, how does it observe something constrained by time? Does it have to subject itself to time for the observation?
- Andrew
Text::Highlight - A language-neutral syntax highlighting module in...
I'm not sure there is a definite line. I'd call a framework something that has all the basic functionality written, and has a specific structure of an application to utilize it. Sorry, that's a terrible definition. I consider it a question of how many independent, unrelated tools are packaged...
FYI, embedding code in HTML is only the default option in PHP. It's like claiming Perl sucks because you have to use print statement to output HTML. Yes, the default framework makes it much easier for newcomers, but I think there are more templating libraries for PHP than Perl. And PHP has PEAR...
I haven't heard of anything that would do that. Might be something in the PAR package, but I don't think so.
- Andrew
Text::Highlight - A language-neutral syntax highlighting module in Perl
also on SourceForge including demo
or if you're not using ODBC and are using one of the TDS/Sybase DBD's, check out pages four and five in this tutorial, the relevant part being:
use DBI;
my $server = "ibmxp";
my $db = "pubs2";
my $username = "sa";
my $password = "";
my $dbh = DBI->connect("dbi:Sybase:$server", $username...
Yeah, in the *nix world, you almost always have a compiler & environment set up so CPAN sources work great. It actually doesn't work too bad in Windows, if you've got all the tools available. Unfortunately, most people don't.
Downloading nmake will let CPAN install all the pure-perl modules...
...many modules, and dealing with compilation issues is a pain on any platform, and especially horrific on Windows when the module might have some *nix specific hook.
If ActiveState has a ppm binary, it's far easier to just use it instead. They don't have all the modules, or the latest...
heh, jump across the pool for the weekend. Tuesday next week, we celebrate the day we politely asked your countrymen (or was it your neighbors?) to go home. :-)
uhh...can't post without content, so here's another way. I've always liked the list operators.
my $flag = 0;
for my $id (grep...
how about just "ppm3 install Text-CSV" from the command line. I think he had you use the shell to show you how to search for modules when you don't know the exact name. If you know specifically what the module is called, you can skip the ppm shell and install it directly.
- Andrew...
Good information, even if it's not something I see myself using (though maybe if I find the time to work through something like this SDL guide, but then I'd be using SDL and not Tk).
You should write a FAQ for it, drop it into the existing GUI category so mine doesn't feel so lonely.
- Andrew...
Does running the following work?
/exlibris/aleph/product/perl-5.8.2/bin/perl -MCPAN -e shell
I don't remember whether CPAN looks at compile-time set directories for install paths, or whether it checks environment variables. I'd guess the former.
- Andrew
Text::Highlight - A language-neutral...
2 is easy, 1 all I can really say is check the FAQ's here and in the CGI forum for a few pointers. Others may chime in with their debugging preferences, but I haven't done much complex stuff with it to be of any help.
You can't print a standard Content-type mime if you're doing a redirect. The...
Right above make test should be make. Are there errors reported there?
- Andrew
Text::Highlight - A language-neutral syntax highlighting module in Perl
also on SourceForge including demo
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.