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.

Well, I would do what you're trying to do in CFML, because it's way better than PHP. ;P

I've never used SSRS, but all similar report-generating software I've tried has been a bunch of crap, so ... *shrug*

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.

That's one of the reason I don't use ColdFusion any more, I use Railo which is way better. :)


I have very seriously considered writing a PHP -> CFML converter.
I'm not convinced it would actually make money though?

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.

Yep. LGPL Free Software and Open Source.

Anything from ACF8 and below will almost certainly work on the Railo 3.2, with a few deliberate exceptions.

You can even download a 50MB express version and give it a try without even sitting through a stupidly long install process.

Dude I'm all over that. Thanks for letting me know about it! I'm much more fluent in CF than PHP.

Thing is, if I made a converter, I couldn't not give it away, so any money would only come through donations, and I don't know if that would be enough to cover the effort spent on it.

Also, whilst a direct port is do-able, and might even be relatively straight-forward, it wouldn't necessarily produce good code.


Damn it, you're making that conundrum I have even more complicated! :'(

%-)

 

It's funny that you have considered it.

No problem, I've been a huge fan of Railo for ages. It's really awesome! (bounce)

If you do have any problems getting going, there's a mailing list where you'll find lots of friendly helpful people. :)

I can't seem to get it connected to IIS, which isn't a big deal. But can you tell me where I should put my cfm files so Tomcat can parse them? I can't seem to find a wwwroot or anything like that.

Nevermind. I took the time to read the debug info and found the path I needed! :-((

Hmm, the installer should do the IIS connection automatically.
(Since you've mentioned Tomcat I assume you went for the version with the installer?)


You can change the path in server.xml

<Host name="domain.com" appBase="webapps">
        <Alias>www.domain.com</Alias>
        <Context path="" docBase="/path/to/webroot"/>
</Host>

The server.xml is inside tomcat's conf directory.
For Windows/IIS, the docBase would be "c:/inetpub/wwroot" by default, I think?
The appBase setting you can leave alone (even if it's different), but it should be there, or you get WEB-INF directories all over the place (you'll get just one in your webroot if it's working normally).

I guess you've probably only got one Host record so far, (for localhost), you can either add/modify the Context tag for that, or go ahead and add a new one at the same level, (and you can use IP address if you don't have a domain).

Make sense?

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!

Woohoo! (woot)

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.

SHIELDSIT and Peeb sitting in a tree...

C O D... I N G :C