%-)

 

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

P R O Gramm I N G?

G E E K I N G (dance)

:D

Or..

TEACHING HIM ABOUT PHP

:$

I think that actually works better :$

Well I started with PHP so it's a bit different - actually, I think I started with ASP but gave up on that almost straight away - but yeah, when I stumbled upon CF in 2002, after a couple of years of doing PHP, I switched over pretty quickly. It's just makes more sense and is easier to get on with.

 

Railo goes a step further, adding cool improvements, and (as a company) being far more interactive with the community than Adobe (which isn't surprising; Adobe only really cares about Photoshop/Flash/PDFs/etc, and mostly treats CF as a big cash cow).

 

Anyway... (kiss)

You guys are terrible!
:-O

(flower)

 

I am so pumped. I have the first form automated. That will save so much time it's unreal. There is so much room for process improvement here and this is going to be a big part of it!

 

Using CF I was able to grab the variables I needed that somehow eluded me using PHP.

 

Thanks Pete for making me aware of Railo!

You think that first one was bad? This is the one I'm working on now! Un-Fucking-Real!

SELECT * FROM ProductionHeader WHERE ruhID='041811BD'; SELECT ID=rudID, Category=rudCategory, Seq=rudSeq, Type=rudType, [Product ID]=rudProductID, Description=rudDescrip, 
PcsPerPkg=rudPcsPerPkg, Tally=rudTally, UOM=rudBaseUnitID, Pieces=rudPieces, Volume=rudVolume, NetVolume=rudNetVolume, Cost=rudCost, AddedCost= rudAddedCost, MktValue=rudMarketValue, 
Total=rudTotal, NetThick=rudNetThick, NetWidth=rudNetWidth, NetLength=rudNetLength, NetType=rudVolType, LocationID=rudLocationID,rudFIFOVolume,rudForceCost,rudBoomID,prdLengthID=(SELECT prdLengthID FROM ProductMaster 
WHERE prdID=rudProductID) FROM ProductionDetail WHERE rudID='041811BD' AND rudCategory='Consumed' ORDER BY Seq; SELECT ID=rudID, Category=rudCategory, Seq=rudSeq, Type=rudType, [Product ID]=rudProductID, Description=rudDescrip, 
PcsPerPkg=rudPcsPerPkg, Tally=rudTally, UOM=rudBaseUnitID, Pieces=rudPieces, Volume=rudVolume, NetVolume=rudNetVolume, Cost=rudCost, AddedCost= rudAddedCost, MktValue=rudMarketValue, Total=rudTotal, NetThick=rudNetThick, 
NetWidth=rudNetWidth, NetLength=rudNetLength, NetType=rudVolType, LocationID=rudLocationID,rudFIFOVolume,rudForceCost,rudBoomID,prdLengthID=(SELECT prdLengthID FROM ProductMaster WHERE prdID=rudProductID) 
FROM ProductionDetail WHERE rudID='041811BD' AND rudCategory='Produced' ORDER BY Seq; SELECT uft.uftDocId, uft.uftFieldType, uft.uftValidation, Description = uft.uftCaption, Value = duf.dufValue FROM UserFieldTemplate uft 
LEFT JOIN DocumentUserFields duf ON duf.dufDocType = uft.uftDocType AND duf.dufSeq = uft.uftDocId AND duf.dufDocId='041811BD' WHERE uft.uftDocType='PRODUCTION' ORDER BY uft.uftDocId; SELECT ufvDocId, ufvSeq, Value=ufvValue, 
Description=ufvDescrip FROM UserFieldValues WHERE ufvDocType='PRODUCTION' ORDER BY ufvDocId, ufvSeq; SELECT dufDocType, dufDocID, dufSeq, dufValue FROM DocumentUserFields WHERE 1=0; SELECT *  
,tagParentProdID=ISNULL((SELECT MAX(p2.prdID) FROM ProductMaster p2 WHERE p1.prdThickID=p2.prdThickID AND ((isnull(p2.prdWidthID,'')='' AND isnull(tagHdrWidthID,'')='') or isnull(p2.prdWidthID,'')=tagHdrWidthID) 
AND ISNULL(p2.prdLengthID,'') = ISNULL(p1.prdLengthID,'') AND p1.prdSpeciesID=p2.prdSpeciesID AND p1.prdGradeID=p2.prdGradeID AND p1.prdSurfacingID=p2.prdSurfacingID  AND p1.prdStateID=p2.prdStateID 
AND ISNULL(p1.prdUsrAttribID,'')=ISNULL(p2.prdUsrAttribID,'') AND ISNULL(p1.prdUsrAttribID2,'')=ISNULL(p2.prdUsrAttribID2,'') AND ISNULL(p1.prdUsrAttribID3,'')=ISNULL(p2.prdUsrAttribID3,'')  
AND ISNULL(p1.prdUsrAttribID4,'')=ISNULL(p2.prdUsrAttribID4,'') AND ISNULL(p1.prdUsrAttribID5,'')=ISNULL(p2.prdUsrAttribID5,'')  AND ISNULL(p1.prdUsrAttribID6,'')=ISNULL(p2.prdUsrAttribID6,'') 
AND ISNULL(p1.prdUsrAttribID7,'')=ISNULL(p2.prdUsrAttribID7,'')  AND ISNULL(p1.prdUsrAttribID8,'')=ISNULL(p2.prdUsrAttribID8,'') AND ISNULL(p1.prdUsrAttribID9,'')=ISNULL(p2.prdUsrAttribID9,'')  
AND p1.prdHidden=1),p1.prdID) FROM TagMaster INNER JOIN ProductMaster p1 ON p1.prdID=tagProductID WHERE tagSourceID='041811BD' AND tagSourceType='PRODUCTION' ORDER BY tagID,tagLineSeq; 
SELECT ProductID=rudProductID, LocationID=rudLocationID, Volume=SUM(rudVolume), Type=rudType FROM ProductionDetail WHERE rudID='041811BD' AND rudProductID<>'' AND rudCategory='Produced' 
AND rudType='Vol' GROUP BY rudProductID, rudLocationID, rudType; SELECT ProductID=rudProductID, LocationID=rudLocationID, Value=SUM(rudTotal), Type=rudType, rudCategory FROM ProductionDetail 
WHERE rudID='041811BD' AND rudProductID<>'' GROUP BY rudProductID, rudLocationID, rudType, rudCategory; SELECT 1 FROM DocumentNotesMaster WHERE dnmDocType='PRODUCTION' AND dnmDocID='041811BD'; 
SELECT DocType=dcmDocType, DocID=dcmDocID, Seq=dcmSeq, Type=dcmCostTypeID, Description=dcmDescrip, MachineID=dcmMachineID, SuppID=dcmSuppID,FundsID=dcmFundsTypeID, FundsRate=dcmFundsRate, Qty=dcmQty, 
CostRate=dcmRateID, Total=dcmTotal, Prorate=dcmProrate, ProductID=dcmProductID, [LineNo]=dcmLineNo FROM DocumentCostMaster WHERE dcmDocType='PRODUCTION' AND dcmDocID='041811BD' ORDER BY dcmSeq

Any idea how their software does the above SELECT Statement and it's what I captured on the SQL Server but when I try to execute it outside of their software it tells me these aren't defined?

=ISNULL(p2.prdUsrAttribID,'') AND ISNULL(p1.prdUsrAttribID2,'')=ISNULL(p2.prdUsrAttribID2,'') AND ISNULL(p1.prdUsrAttribID3,'')=ISNULL(p2.prdUsrAttribID3,'')  
AND ISNULL(p1.prdUsrAttribID4,'')=ISNULL(p2.prdUsrAttribID4,'') AND ISNULL(p1.prdUsrAttribID5,'')=ISNULL(p2.prdUsrAttribID5,'')  AND ISNULL(p1.prdUsrAttribID6,'')=ISNULL(p2.prdUsrAttribID6,'') 
AND ISNULL(p1.prdUsrAttribID7,'')=ISNULL(p2.prdUsrAttribID7,'')  AND ISNULL(p1.prdUsrAttribID8,'')=ISNULL(p2.prdUsrAttribID8,'') AND ISNULL(p1.prdUsrAttribID9,'')=ISNULL(p2.prdUsrAttribID9,'')