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 wOOdy-Soft 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 icrf
-
icrf
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...- icrf
- Forum: Round Table
-
Automatic click link/button
I'm trying to automate clicking a link, but it seems IE/Firefox only runs the onclick event handlers, but doesn't actually follow the href. Opera and Safari do both, which is what I'm after. Here's a test page with code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"...- icrf
- Thread
- Replies: 0
- Forum: Javascript
-
The inverse of a relationship table
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...- icrf
- Post #7
- Forum: Microsoft SQL Server: Programming
-
The inverse of a relationship table
Thanks, but that's the exact method I was thinking of doing, but found myself 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...- icrf
- Post #5
- Forum: Microsoft SQL Server: Programming
-
The inverse of a relationship table
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- icrf
- Post #3
- Forum: Microsoft SQL Server: Programming
-
The inverse of a relationship table
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...- icrf
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
riddle picture
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...- icrf
- Post #37
- Forum: Puzzles for Programmers
-
riddle picture
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...- icrf
- Post #33
- Forum: Puzzles for Programmers
-
Understanding Terminology
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... -
Is PERL dying?
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... -
Is it possible to change perl files to dll
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 -
Perl and SQL Server
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... -
Parsing CSV files
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... -
Parsing CSV files
I'm going to have to disagree, it takes a lot more than a make utility to make 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... -
searching a hash
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...
