RE: SQL Query Help
Well, it's not a brain fart. That query is kinda kinky. Use this as an example, replacing your tables and fields, it should work BASED ON DATE! SELECT DISTINCT T.CustomerID, T.TransactionDate, T.ID AS InvoiceID FROM dbo.Transactions T INNER JOIN (SELECT MAX(TransactionDate) AS maxdate, CustomerID FROM Transactions WHERE deleted = 0 GROUP BY CustomerID) maxresults ON T.CustomerID = maxresults.CustomerID AND T.TransactionDate = maxresults.maxdate WHERE (T.Deleted = 0) AND (T.Status 'Pending') AND (T.AccountType = 'Customer') GROUP BY T.CustomerID, T.TransactionDate, T.ID Hope this helps. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 3:39 PM To: CF-Talk Subject: RE: SQL Query Help Need more info: What would the query be to return the last invoice for a single customer? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 8:58 AM To: CF-Talk Subject: SQL Query Help having brain fart here ... ughh scenario: customer table, invoice table I'd like to do a query to list the last invoice for each customer. Can someone point me in the right direction please? TIA, Jenny ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
chart images distorted when creating PDF
When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: chart images distorted when creating PDF
Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any trouble on the updgrade? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:01 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274486 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
Mark:
This is my jvm.config:
-
#
# VM configuration
#
# Where to find JVM, if {java.home}/jre exists then that JVM is used
# if not then it must be the path to the JRE itself
java.home=C:/CFusionMX7/runtime/jre
#
# If no java.home is specified a VM is located by looking in these places in
this
# order:
#
# 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix)
# 2) ../jre
# 3) registry (windows only)
# 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre)
#
# Arguments to VM
java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xmx512m
-Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC
-Dcoldfusion.classPath={application.home}/../../classes,{application.home}/.
../lib/updates,{application.home}/../lib/,{application.home}/../gateway/lib/,
{application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\\CustomTags
\\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar
#
# commas will be converted to platform specific separator and the result
will be passed
# as -Djava.ext.dirs= to the VM
java.ext.dirs={jre.home}/lib/ext
#
# where to find shared libraries
java.library.path={application.home}/../lib,{application.home}/../jintegra/b
in,{application.home}/../jintegra/bin/international
system.path.first=false
#
# set the current working directory - useful for Windows to control
# the default search path used when loading DLLs since it comes
# before system directory, windows directory and PATH
java.user.dir={application.home}/../../lib
# JVM classpath
java.class.path={application.home}/servers/lib,{application.home}/../lib/mac
romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar,{application.home}
/lib
-
it doesn't look wrong...
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 6:29 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Rafael,
Why don't you post the contents of the /runtime/bin/jvm.config file. It
might have a clue or 2.
-mark
-Original Message-
From: Rafael Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 5:12 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Mark:
I did not have any troubles doing uploading the jar.
I do have a backup, but it's for the whole server This is what I read in the
out log:
Thanks
Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4
(Build 84683), coldfusion server
04/03 18:07:23 warning Unable to open
C:\CFusionMX7\runtime/lib/license.properties
04/03 18:07:24 info JRun Naming Service listening on *:2920
04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml.
Installing a self generated sessionSecret.
04/03 18:07:24 info No JDBC data sources have been configured for this
server (see jrun-resources.xml)
04/03 18:07:25 info JRun Proxy Server listening on *:51011
04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion
MX from: file:/C:/CFusionMX7/
04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX
from: file:/C:/CFusionMX7/
04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled
04/03 18:07:26 INFO Starting Flex 1.5 CF Edition
04/03 18:07:26 user JSPServlet: init
04/03 18:07:27 user CFMxmlServlet: init
04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646
04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646
04/03 18:07:28 user ColdFusionStartUpServlet: init
04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting
application services
04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version =
1.4.2_05-b04
04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet
04/03 18:07:28 user CFSwfServlet: init
04/03 18:07:28 user CFCServlet: init
04/03 18:07:28 user FlashGateway: init
04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet
04/03 18:07:28 user CFFormGateway: init
04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet
04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup
time: 7 seconds)
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 6:08 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Rafael,
Is there a message in the /runtime/logs/ directoryin the *.out file It
should show the startup progress and may show where the exception
occurred.
Did you back up the cfusionmx7 directory befor beginning.
Did you have any trouble on the updgrade?
-mark
-Original Message-
From: Rafael Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 5:01 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Thanks for your reply.
I went and downloaded the update, I
RE: chart images distorted when creating PDF
Mark:
Yes, it's right there in red
R
-Original Message-
From: Rafael Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 5:49 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Mark:
This is my jvm.config:
-
#
# VM configuration
#
# Where to find JVM, if {java.home}/jre exists then that JVM is used # if
not then it must be the path to the JRE itself
java.home=C:/CFusionMX7/runtime/jre
#
# If no java.home is specified a VM is located by looking in these places in
this # order:
#
# 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix) #
2) ../jre # 3) registry (windows only) # 4) JAVA_HOME env var plus jre (ie
$JAVA_HOME/jre) #
# Arguments to VM
java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xmx512m
-Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC
-Dcoldfusion.classPath={application.home}/../../classes,{application.home}/.
/lib/updates,{application.home}/../lib/,{application.home}/../gateway/lib
/
,
{application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\\CustomTags
\\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar
#
# commas will be converted to platform specific separator and the result
will be passed # as -Djava.ext.dirs= to the VM
java.ext.dirs={jre.home}/lib/ext
#
# where to find shared libraries
java.library.path={application.home}/../lib,{application.home}/../jintegra/b
in,{application.home}/../jintegra/bin/international
system.path.first=false
#
# set the current working directory - useful for Windows to control # the
default search path used when loading DLLs since it comes # before system
directory, windows directory and PATH
java.user.dir={application.home}/../../lib
# JVM classpath
java.class.path={application.home}/servers/lib,{application.home}/../lib/mac
romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar,{application.home}
/lib
-
it doesn't look wrong...
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 6:29 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Rafael,
Why don't you post the contents of the /runtime/bin/jvm.config file. It
might have a clue or 2.
-mark
-Original Message-
From: Rafael Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 5:12 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Mark:
I did not have any troubles doing uploading the jar.
I do have a backup, but it's for the whole server This is what I read in the
out log:
Thanks
Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4
(Build 84683), coldfusion server
04/03 18:07:23 warning Unable to open
C:\CFusionMX7\runtime/lib/license.properties
04/03 18:07:24 info JRun Naming Service listening on *:2920
04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml.
Installing a self generated sessionSecret.
04/03 18:07:24 info No JDBC data sources have been configured for this
server (see jrun-resources.xml)
04/03 18:07:25 info JRun Proxy Server listening on *:51011
04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion
MX from: file:/C:/CFusionMX7/
04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX
from: file:/C:/CFusionMX7/
04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled
04/03 18:07:26 INFO Starting Flex 1.5 CF Edition
04/03 18:07:26 user JSPServlet: init
04/03 18:07:27 user CFMxmlServlet: init
04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646
04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646
04/03 18:07:28 user ColdFusionStartUpServlet: init
04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting
application services
04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version =
1.4.2_05-b04
04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet
04/03 18:07:28 user CFSwfServlet: init
04/03 18:07:28 user CFCServlet: init
04/03 18:07:28 user FlashGateway: init
04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet
04/03 18:07:28 user CFFormGateway: init
04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet
04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup
time: 7 seconds)
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 6:08 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Rafael,
Is there a message in the /runtime/logs/ directoryin the *.out file It
should show the startup progress and may show where
RE: chart images distorted when creating PDF
Thanks!
I can breathe again!
I still have the issue with the broken chart images, though..
How did you fix that problem?
RM
-Original Message-
From: Jon Clausen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 7:00 PM
To: CF-Talk
Subject: Re: chart images distorted when creating PDF
Rafael,
If you installed the hotfix by uploading the .jar through the
CFAdmin, you can revert by deleting (or moving) the .jar file. On a
windows machine this is usually located at: C:\CFusionMX7\lib\updates
I had a similar problem with the charting hotfix when I installed it,
but it wasn't a critical update for me so I skipped trying it again
until the next cumulative hotfix.
Once you delete the file, you should be able to restart and go.
HTH,
Jon
On Apr 3, 2007, at 6:49 PM, Rafael Marquez wrote:
Mark:
This is my jvm.config:
-
#
# VM configuration
#
# Where to find JVM, if {java.home}/jre exists then that JVM is used
# if not then it must be the path to the JRE itself
java.home=C:/CFusionMX7/runtime/jre
#
# If no java.home is specified a VM is located by looking in these
places in
this
# order:
#
# 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so
(unix)
# 2) ../jre
# 3) registry (windows only)
# 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre)
#
# Arguments to VM
java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -
Xmx512m
-Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC
-Dcoldfusion.classPath={application.home}/../../classes,
{application.home}/.
../lib/updates,{application.home}/../lib/,{application.home}/../
gateway/lib/,
{application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\
\CustomTags
\\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar
#
# commas will be converted to platform specific separator and the
result
will be passed
# as -Djava.ext.dirs= to the VM
java.ext.dirs={jre.home}/lib/ext
#
# where to find shared libraries
java.library.path={application.home}/../lib,{application.home}/../
jintegra/b
in,{application.home}/../jintegra/bin/international
system.path.first=false
#
# set the current working directory - useful for Windows to control
# the default search path used when loading DLLs since it comes
# before system directory, windows directory and PATH
java.user.dir={application.home}/../../lib
# JVM classpath
java.class.path={application.home}/servers/lib,
{application.home}/../lib/mac
romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar,
{application.home}
/lib
-
it doesn't look wrong...
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 6:29 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Rafael,
Why don't you post the contents of the /runtime/bin/jvm.config
file. It
might have a clue or 2.
-mark
-Original Message-
From: Rafael Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 5:12 PM
To: CF-Talk
Subject: RE: chart images distorted when creating PDF
Mark:
I did not have any troubles doing uploading the jar.
I do have a backup, but it's for the whole server This is what I
read in the
out log:
Thanks
Server coldfusion ready (startup time: 5 seconds) Starting
Macromedia JRun 4
(Build 84683), coldfusion server
04/03 18:07:23 warning Unable to open
C:\CFusionMX7\runtime/lib/license.properties
04/03 18:07:24 info JRun Naming Service listening on *:2920
04/03 18:07:24 warning No sessionSecret has been specified in
jrun.xml.
Installing a self generated sessionSecret.
04/03 18:07:24 info No JDBC data sources have been configured for this
server (see jrun-resources.xml)
04/03 18:07:25 info JRun Proxy Server listening on *:51011
04/03 18:07:25 info Deploying enterprise application Macromedia
ColdFusion
MX from: file:/C:/CFusionMX7/
04/03 18:07:25 info Deploying web application Macromedia
Coldfusion MX
from: file:/C:/CFusionMX7/
04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled
04/03 18:07:26 INFO Starting Flex 1.5 CF Edition
04/03 18:07:26 user JSPServlet: init
04/03 18:07:27 user CFMxmlServlet: init
04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646
04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646
04/03 18:07:28 user ColdFusionStartUpServlet: init
04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting
application services
04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM
version =
1.4.2_05-b04
04/03 18:07:28 user failed to load:
coldfusion.server.j2ee.CFStartUpServlet
04/03 18:07:28 user CFSwfServlet: init
04/03 18:07:28 user CFCServlet: init
04/03 18:07:28 user FlashGateway: init
04/03 18
