Yeah it is sorta.
But here's why I'm doing it. The company that provides the software are a bunch of ass hats. As you can see by that select statement.
When the people who work where I work want to do any kind of math on that database their answer is dumbing it into excel. Fuck that. All we get done doing is typing shit into excel. It's in the database, why the fuck should I have to do that?
So I am going to automate the processes, and really using PHP might be temporary, I just want to see what I am able to farm out of it and how hard it is going to be.
I'll have to take a look at the sql server. I can get a list of the tables (all 1000 or so of them) but there isn't any logical order to them and I don't know what goes where.
Hmmm, I wouldn't be surprised if there aren't any foreign keys setup then. :/
Anyway, this is a rather long-winded video that explains how to create a diagram, if you're able to connect via Management Studio.
http://www.youtube.com/watch?v=wMbPRHeYvMU#t=40s
Peter my ad was for a PHP wizard, not for going back to school to learn to be a php wizard! :-O
Just messin. I appreciate you looking at it. I can access the Management Studio.
Oh and speaking of that, sorta. Would you do what I'm trying in PHP or in the SSRS? I haven't been too fond of the reporting services but it could probably do what I wanted as well.
I love ColdFusion and would prefer using it but the Developer version only allows 2 connections and if this works I'll need more than that.
You know what you should do. Develop a program that converts php to cf and vice versa. You could probably make some good money.
So the tags are the same? Is it free? That could be a sweet deal there!
I bet you could make a few dollars if you made a converter. I've needed to do it from time to time and a few dollars for software to do it over me would have been a no brainer.
%-)
It's funny that you have considered it.
<Host name="domain.com" appBase="webapps"> <Alias>www.domain.com</Alias> <Context path="" docBase="/path/to/webroot"/> </Host>
It does and I'll mess with it when I am ready to roll this out.
As of right now I have this fucker spitting out exactly what I am after!
Thanks so much man, this is just what I was looking for without the $thousands in costs!
ta!
Now to figure out how this math is being applied and get this shit working!
I really enjoy coding, but don't get to do it very often anymore. I'm sure glad I held on to my CF books. I bet it's been 5 years since I've coded any CF. But it's kind of like riding a bike.
I don't know about you, but I think it's a very easy language and it just makes sense to me. PHP is kinda like it, but I have more trouble with it for some reason.