RE: SQL Query Help

2007-04-04 Thread Rafael Marquez
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

chart images distorted when creating PDF

2007-04-03 Thread Rafael Marquez
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?

RE: chart images distorted when creating PDF

2007-04-03 Thread Rafael Marquez
[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

RE: chart images distorted when creating PDF

2007-04-03 Thread Rafael Marquez
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

RE: chart images distorted when creating PDF

2007-04-03 Thread Rafael Marquez
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

RE: chart images distorted when creating PDF

2007-04-03 Thread Rafael Marquez
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

RE: chart images distorted when creating PDF

2007-04-03 Thread Rafael Marquez
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