help writing a multiple table query

[markrawlingson]

That seemed to do the trick.. only, there is other files inside this directory... I guess I should have thought of that before. It throws off the result.. these files are brought in via ftp and the script is run on a scheduler to do it every hour.. I simply added the destination to my folder in my root IIS directory that will now hold these text files. So problem is solved, they are being copied in there every hour now.


Everything seems to be working just great.. This could have never happened without all of your guys' help. So seriously thank you

this had made me realize I should really learn ASP. I have a general question.. Could this same stuff be done using php? I have told myself I REALLY need to learn one of these languages.. any input on which one you guys feel is the better of the two?

Ok well I guess that answers the questions I just posted. haha! Thanks for sharing Mike. I'm glad it's working for you!

Ah, it's probably not a good idea to ask people which is better - asp/php. Generally you start fights that way haha.

Seriously though, there's always been quabbles between developers about whether PHP is better than ASP. The answer you'll get to that question generally depends on who you ask, but it's fairly widely accepted that PHP is superior. Almost all PHP developers I've talk to think that ASP has an 'ugly' syntax - I tend to disagree with that for many reasons, but that's a whole different story.

Part of the problem in answering the question of whether asp is better than php or visa versa is that almost no one knows both - generally either you know ASP, or you know PHP - so I've found that most people comment on either language more or less from the standpoint of ignorance, bashing a language they know nothing about. As far as I am concerned I will admit that when it comes to PHP my knowledge is indeed limited - I am in the process actually of learning it. So far, I'd say I'm quite enjoying a few aspects of PHP which eliminate annoying syntactical problems within ASP - but at the same time it also generates a few problems itself which you wouldn't get with ASP. For instance, ASP is not a Case-Sensitive language, PHP is - or at least the variables are. EG: $sName is not the same as $sname - and of course, you have to end each statement with a semicolon or the whole page bombs on you - in ASP you don't. I'm a little nitpicky when it comes to things like that.

Generally there are more cons to ASP than there are for PHP.

For instance, try running ASP on Linux, or on any other operating system other than Windows for that matter.

A LAMP (Linux Apache MySQL PHP) setup is much faster than a windows based environment, and is a completely open source stack - Free, and constantly improved with bug fixes and other changes to make development easier, and faster.

Sincerely,
Mark

[mbatestblrock]

Ok well I guess that answers the questions I just posted. haha! Thanks for sharing Mike. I'm glad it's working for you!

Ah, it's probably not a good idea to ask people which is better - asp/php. Generally you start fights that way haha.

Seriously though, there's always been quabbles between developers about whether PHP is better than ASP. The answer you'll get to that question generally depends on who you ask, but it's fairly widely accepted that PHP is superior. Almost all PHP developers I've talk to think that ASP has an 'ugly' syntax - I tend to disagree with that for many reasons, but that's a whole different story.

Part of the problem in answering the question of whether asp is better than php or visa versa is that almost no one knows both - generally either you know ASP, or you know PHP - so I've found that most people comment on either language more or less from the standpoint of ignorance, bashing a language they know nothing about. As far as I am concerned I will admit that when it comes to PHP my knowledge is indeed limited - I am in the process actually of learning it. So far, I'd say I'm quite enjoying a few aspects of PHP which eliminate annoying syntactical problems within ASP - but at the same time it also generates a few problems itself which you wouldn't get with ASP. For instance, ASP is not a Case-Sensitive language, PHP is - or at least the variables are. EG: $sName is not the same as $sname

Generally there are more cons to ASP than there are for PHP.

For instance, try running ASP on Linux, or on any other operating system other than Windows for that matter.

That all makes really good sense. So what you had wrote for me in ASP, the same outcome could have been done writing a scrip t in php?

[markrawlingson]

It most certainly can. As one PHP developer once put it to me.. "That and about a billion other things that ASP couldn't hope to do"

Sincerely,
Mark

[mbatestblrock]

As one PHP developer once put it to me.. "That and about a billion other things that ASP couldn't hope to do"

hahahaha.

thanks again for everything guys! you rock.

[RedSon]

Except in situations where the default security is mucked up (people do because they find the whole concept so confusing) these files are only available to a user via the windows based interfaces. The web interface is generally set as a "current machine only" system. This is supporting what you're saying RedSon if I understand you correctly ;)

Yea, so I apologize. Normally when I am trying to work something out, I open up everything so that I have no problems other then the problems that my own code produces. Then I go back later and start locking stuff down and testing the results. So if this is something that is going to be used on a live server then going about it in a more secure fashion would be best.

[MMcCarthy]

I just wanted to say thanks to everyone for participating in this thread.

Its nice to get these cross forum threads going occasionally (not too often mind - it did get a bit long) :)

Great work by everyone to a successful conclusion. Thats what I like to see.

Mary

[NeoPa]

Yea, so I apologize. Normally when I am trying to work something out, I open up everything so that I have no problems other then the problems that my own code produces. Then I go back later and start locking stuff down and testing the results. So if this is something that is going to be used on a live server then going about it in a more secure fashion would be best.

I'm not sure why the apology. Your input added to the whole. That's how I saw it :)

[mbatestblrock]

Thats how I saw it too!