How about something like this:
cfquery name=qryGetOtherProperties datasource=#appDSN#
SELECT f.AssetID, f.name, i.text, i.amount
FROM FixedAssets f
INNER JOIN InvoicesWork i ON i.AssetID = f.AssetID
WHERE f.JobID = #qryGetInvoice.JobID#
AND f.AssetID IN (select AssetID FROM InvoiceWork WHERE
How about something like this:
cfquery name=qryGetOtherProperties datasource=#appDSN#
SELECT f.AssetID, f.name, i.text, i.amount
FROM FixedAssets f
INNER JOIN InvoicesWork i ON i.AssetID = f.AssetID
WHERE f.JobID = #qryGetInvoice.JobID#
AND f.AssetID IN (select AssetID FROM InvoiceWork WHERE
If a qry a couple of tables:
!---get Job Property details ---
CFQUERY Name=qryGetJobProperties datasource=#appDSN#
SELECT AssetID, Name
FROM FixedAssets
WHERE FixedAssets.JobID=#qryGetInvoice.JobID#
/CFQUERY
cfset PropertyFieldID = ValueList(qryGetJobProperties.AssetID)
!---get invoice Property
I retrieve a bunch of dynamic DateFroms and DateTos that a user has input into
a form.
!--- Loop through the dateField IDs to get the Dates ranges---
cfloop list=#form.DatefieldID# index=id
!--- Get the dates---
cfset DateFrom = form[dateFrom_ id]
cfset DateTo = form[dateTo_
I retrieve a bunch of dynamic DateFroms and DateTos that a user has input into
a form.
!--- Loop through the dateField IDs to get the Dates ranges---
cfloop list=#form.DatefieldID# index=id
!--- Get the dates---
cfset DateFrom = form[dateFrom_ id]
cfset DateTo = form[dateTo_
I retrieve a bunch of dynamic DateFroms and DateTos that a user has input into
a form.
!--- Loop through the dateField IDs to get the Dates ranges---
cfloop list=#form.DatefieldID# index=id
!--- Get the dates---
cfset DateFrom = form[dateFrom_ id]
cfset DateTo = form[dateTo_
Line 91 is:
XMLSignatureInput result = transforms.performTransforms(input);
10 from the end.
A+
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
I got a bit further on using Mark Mandels Javaloader.
The coldfusion code is:
cfscript
loadPaths = ArrayNew(1);
loadPaths[1] = expandPath(irmarkjars);
loadPaths[2] = expandPath(irmarkjars\jce-jdk13-114.jar);
loadPaths[3] = expandPath(irmarkjars\style-apachexml.jar);
loadPaths[4] =
I am using 1.4.2
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
I got Russ's code working but if I do this:
public class IRMark {
protected String filename;
public IRMark (String filename) throws Exception
{
this.filename=filename;
// Init the Apache XML security library
Init.init();
}
Dave's right on the different log4j version. What version of the
security library are you using? I had to go back to 1.2 and
xmlsec-1.2.96.jar to get my signature validation to work with CF's JRE,
Phil
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13,
Thanks for all the help but still no joy.
I have been compiling the class file in the classes library and not moving it.
All the jars are in the class path.
I have been calling the method using:
cfobject action=create type=Java class=IRMark name=myObj
cfset ret=myObj.main(input.xml)
And
Andrew,
My 1.2 referred to version 1.2 of the Apache XML Security Library:
http://xml.apache.org/security/dist/java-library/old/xml-security-bin-1_
2_0.zip. I did have to upgrade to the 1.2.96 version of the xmlsec.jar
file:
http://xml.apache.org/security/dist/java-library/old/xmlsec-1.2.96.jar.
I tried that and it's still the same error message so presumably the array is
problematic but should work see:
http://weblogs.macromedia.com/cantrell/archives/2003/06/passing_coldfus.cfm
I put the blank constructor in the code thus:
public class IRMark {
/**
* Generate and print the
I have some java code which I want to kick in from a coldfusion page
e.g. cfobject type=Java class=IRMark name=myObj
cfset ret=myObj.init(input.xml)
It ought to be simple enough, pass the file name to the class and get the
base64 number back.
The Coldfusion documentation states:
Note:
15 matches
Mail list logo