CF7 ENT = CF8, CFReport Font size issues
Hi there, yesterday, I updated a customer's CF7ENT / Linux Server to CF8 Trial and ran into several issues regarding CFReport: They generate pretty complex Flash Paper reports based on cfr files. When generated via CF7, all reports look as they're supposed to (all font sizes and margins are correct). As soon as the same template is processed by CF8 on the same machine, all fonts appear too large, all fields containing text have a constant offset. Looks to me as if someone ;) adds constant values to font-size, padding-top and padding-left... Additionally, the report generation runs awfully slow (about 30x slower!) if a report contains the font Arial Unicode MS. I got around that by symlinking arialuni.ttf to arial.ttf, but this can't be the solution... besides, that does not solve the size issues. System: SLES10, apache 2.x CF7 Version: Latest CF7 CF8 Version: Latest CF8 trial (downloaded a few days ago) Ideas, anyone? ;) bye, marcus ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Javascript in CFC
Hrm...
You're right. That doesn't make any sense though.
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2008 10:12 PM
To: CF-Talk
Subject: Re: Javascript in CFC
- Original Message -
From: Andy Matthews [EMAIL PROTECTED]
That's irrelevant.
The ColdFusion code would completely process before ANY JavaScript code
would even make it to the browser.
Andy, I don't think you understand how cflocation works. Even though it is a
CF tag, the relocation does NOT happen on the server side. If you make a
test file and place the following code in it:
script LANGUAGE=JavaScript TYPE=text/JavaScript
alert('test');
/script
cflocation url=http://www.yahoo.com;
. and then hit that page, your browser will make two requests. The first
request for your test page will come back looking much like this HTTP
response:
=
HTTP/1.1 302 Moved Temporarily
Date: Fri, 05 Sep 2008 03:04:33 GMT
Server: Apache/2.2.4 (Win32) JRun/4.0
location: http://www.yahoo.com
Keep-Alive: timeout=5, max=100
Connection: Keep-Alive
Content-Type: text/html; charset=UTF-8
Content-Length: 6551
script LANGUAGE=JavaScript TYPE=text/javascript
alert('test');
/script
=
Notice that the output of your page (the JavaScript) DOES get passed out to
the browser. However, your browser (Internet Explorer at least) will ignore
the body of the response and send out a second request for
http://www.yahoo.com.
So whether or not the code is in a CFC or not, the browser is who actually
does the redirect. Of course, if one wants the JavaScript to execute BEFORE
the redirect, you want to send back a 200 response like so:
script LANGUAGE=JavaScript TYPE=text/JavaScript
alert('test');
document.location.href = 'http://www.yahoo.com';
/script
~Brad
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312062
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Setting a default value
In the scenerio below, how would I set a default value - 99 maybe - for form.group_sort_#gpIDX# - if the form field was left blank? cfloop index=idx list=#FORM.GROUPid# cfquery name=update UPDATE MyTable SET group_sort = #evaluate(form.group_sort_#gpIDX#)# where link_group = '#evaluate(form.thisGROUP_#gpIDX#)#' /cfquery /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting a default value
- Original Message - From: Les Mizzell [EMAIL PROTECTED] In the scenerio below, how would I set a default value - 99 maybe - for form.group_sort_#gpIDX# - if the form field was left blank? I'm sure there are many ways, but this should work. Also, don't forget to secure those queries against SQL Injection ;- cfloop index=idx list=#FORM.GROUPid# cfset this_group_sort = form[group_sort_#gpIDX#] cfquery name=update UPDATE MyTable SET group_sort = #iif(len(trim(this_group_sort)),this_group_sort,99)# where link_group = '#evaluate(form.thisGROUP_#gpIDX#)#' /cfquery /cfloop ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting a default value
You could do this, it assumes the form element would always be passed but might be blank. If the form element may not get passed then you could do a cfparam but that would not handle if it passed and blank. Also I assumed #gpIDX# was really supposed to be #idx# cfloop index=idx list=#FORM.GROUPid# cfif Trim(Form[group_sort_#idx#]) IS cfset Form[group_sort_#idx#] = 99 / /cfif cfquery name=update UPDATE MyTable SET group_sort = #Form[group_sort_#idx#]# where link_group = 'Form[thisGROUP_#idx#]' /cfquery /cfloop On Fri, Sep 5, 2008 at 10:25 AM, Les Mizzell [EMAIL PROTECTED] wrote: In the scenerio below, how would I set a default value - 99 maybe - for form.group_sort_#gpIDX# - if the form field was left blank? cfloop index=idx list=#FORM.GROUPid# cfquery name=update UPDATE MyTable SET group_sort = #evaluate(form.group_sort_#gpIDX#)# where link_group = '#evaluate(form.thisGROUP_#gpIDX#)#' /cfquery /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting a default value
Erf, I left off some pound signs on the where clause where link_group = '#Form[thisGROUP_#idx#]#' On Fri, Sep 5, 2008 at 10:32 AM, Aaron Rouse [EMAIL PROTECTED] wrote: You could do this, it assumes the form element would always be passed but might be blank. If the form element may not get passed then you could do a cfparam but that would not handle if it passed and blank. Also I assumed #gpIDX# was really supposed to be #idx# cfloop index=idx list=#FORM.GROUPid# cfif Trim(Form[group_sort_#idx#]) IS cfset Form[group_sort_#idx#] = 99 / /cfif cfquery name=update UPDATE MyTable SET group_sort = #Form[group_sort_#idx#]# where link_group = 'Form[thisGROUP_#idx#]' /cfquery /cfloop On Fri, Sep 5, 2008 at 10:25 AM, Les Mizzell [EMAIL PROTECTED]wrote: In the scenerio below, how would I set a default value - 99 maybe - for form.group_sort_#gpIDX# - if the form field was left blank? cfloop index=idx list=#FORM.GROUPid# cfquery name=update UPDATE MyTable SET group_sort = #evaluate(form.group_sort_#gpIDX#)# where link_group = '#evaluate(form.thisGROUP_#gpIDX#)#' /cfquery /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query of Queries error
I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server 2005. Below is the query block. There error comes in the select statement. if (NOT IsDefined(URL.sOrderBy)) URL.sOrderBy = dtStartDate; if (NOT IsDefined(URL.sOrderType)) URL.sOrderType = DESC; /cfscript cftry !--- Query of a query --- cfquery name=Variables.qSearchProjects dbtype=query SELECT * FROMqCombinedProjects ORDER BY #URL.sOrderBy# #URL.sOrderType#; /cfquery cfcatch !--- Order the projects by start date --- cfquery name=Variables.qSearchProjects dbtype=query SELECT * FROMqCombinedProjects ORDER BY dtStartDate DESC; /cfquery /cfcatch /cftry dtstartdate is in date format. Please help as this really urgent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form slowness inexplicable
Okay... I've had ONE user complain about the slowness of this form: http://www.it.dev.duke.edu/public/formtest.html The problem they're having is that when the resize the window or scroll or move it, it's slow. Very slow. I don't have this problem. My coworker experiences the problem to a lesser extent than the user, but he's got a super powerful machine (more powerful than mine.. faster processor, more RAM, etc). The difference is that both he and the user are on laptops and I'm on a desktop. I'm running IE7, Firefox 3, and Chrome and experience no problems. He's running IE6, Firefox 3, and Chrome.. only problem in IE6. He upgraded to IE7 and still noticed the slowness. The user was also using IE but I'm not sure if it was 6 or 7. He says when he scrolls, it's spiking his CPU usage. Anyone got any ideas on this? -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Form slowness inexplicable
Okay... I've had ONE user complain about the slowness of this form: http://www.it.dev.duke.edu/public/formtest.html The problem they're having is that when the resize the window or scroll or move it, it's slow. Very slow. I don't have this problem. My coworker experiences the problem to a lesser extent than the user, but he's got a super powerful machine (more powerful than mine.. faster processor, more RAM, etc). The difference is that both he and the user are on laptops and I'm on a desktop. I'm running IE7, Firefox 3, and Chrome and experience no problems. He's running IE6, Firefox 3, and Chrome.. only problem in IE6. He upgraded to IE7 and still noticed the slowness. The user was also using IE but I'm not sure if it was 6 or 7. He says when he scrolls, it's spiking his CPU usage. Anyone got any ideas on this? It works fine for me with IE7 on my tiny, underpowered UMPC. I suspect he has some ActiveX control installled that's interfering with things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: fusebox vs model glue
hi, apologies for the delayed thanks! - but thanks very much there are some excellent points here and really made me understand. seeing as we are doing everything to understand OO and change our applications into OO it sounds like we should stick with it - it is really helping us understand it further thanks again for your comments hi we have just reviewed model glue, and have also looked into fusebox very briefly is fusebox similiar to model glue? and if so is it a case of using one or the other? and if so then what are your feelings on which one is better? thanks for your help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form slowness inexplicable
If 1 user out of however many ever used the form (since it's a edu site, I suppose it's ALLOT) complains about something that hasn't changed... It's a PEBCAK error or a ID-Ten-T Error. Dave Watts wrote: Okay... I've had ONE user complain about the slowness of this form: http://www.it.dev.duke.edu/public/formtest.html The problem they're having is that when the resize the window or scroll or move it, it's slow. Very slow. I don't have this problem. My coworker experiences the problem to a lesser extent than the user, but he's got a super powerful machine (more powerful than mine.. faster processor, more RAM, etc). The difference is that both he and the user are on laptops and I'm on a desktop. I'm running IE7, Firefox 3, and Chrome and experience no problems. He's running IE6, Firefox 3, and Chrome.. only problem in IE6. He upgraded to IE7 and still noticed the slowness. The user was also using IE but I'm not sure if it was 6 or 7. He says when he scrolls, it's spiking his CPU usage. Anyone got any ideas on this? It works fine for me with IE7 on my tiny, underpowered UMPC. I suspect he has some ActiveX control installled that's interfering with things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form slowness inexplicable
Rick Root wrote: Anyone got any ideas on this? I read a review of Chrome a couple of days ago that discussed a general 'Flash' problem with current browsers. The reviewer discussed how greedy Flash player could get with client resources, particularly CPU. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
making functions global in model glue
hi i am making my first model glue application and just want to know if i have got the following right: i want to make my reusable functions (e.g. cflib functions arrayconcat etc...) global to all of my cfc's so that i can access them at any time. am i right in thinking that i would create a cfc that contains all these functions then setup a bean in the coldspring.xml file for this cfc. Then every other cfc that i need to be able to use these functions i would need to create a reference to that bean in the init function of the cfc thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Form slowness inexplicable
I read a review of Chrome a couple of days ago that discussed a general 'Flash' problem with current browsers. The reviewer discussed how greedy Flash player could get with client resources, particularly CPU. His form isn't using Flash, it's using DHTML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form slowness inexplicable
On Fri, Sep 5, 2008 at 1:07 PM, Ian Skinner [EMAIL PROTECTED] wrote: Rick Root wrote: Anyone got any ideas on this? I read a review of Chrome a couple of days ago that discussed a general 'Flash' problem with current browsers. The reviewer discussed how greedy Flash player could get with client resources, particularly CPU. That's interesting but... this form isn't flash, and it works fabulously in Chrome (and Firefox.. and IE on my computer) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form slowness inexplicable
On Fri, Sep 5, 2008 at 1:06 PM, Phillip M. Vector [EMAIL PROTECTED] wrote: If 1 user out of however many ever used the form (since it's a edu site, I suppose it's ALLOT) complains about something that hasn't changed... It's a PEBCAK error or a ID-Ten-T Error. One user has complained .. out of several hundred. But the problem exists on my cohorts computer as well just not as significantly. and he doesn't use IE at all.. no weird toolbars installed or anything. The only commonality between the two users is they're both using laptops.. but one was an older laptop. Both running Windows XP. rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form slowness inexplicable
Is this user local? Your only real hope is to take a look at their computer. Have them clear their cache and restart. Take a look at what is running in the background. How much memory is installed? Available? What toolbars are installed? Take the test page, and start removing pieces of the code until the problem goes away. What was the last part you removed? Stuff like that is where I would start. If you don't have access to your user's computer, it is going to be a lot harder, but it helps that you can at least reproduce the problem in part on your coworker's computer. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form slowness inexplicable
On Fri, Sep 5, 2008 at 1:30 PM, Brad Wood [EMAIL PROTECTED] wrote: Is this user local? Your only real hope is to take a look at their computer. Yup, already did that. Have them clear their cache and restart. Take a look at what is running in the background. How much memory is installed? Available? What toolbars are installed? Well, Nate's computer (my web programmer cohort here) is a Dell Precision laptop with 4gb of RAM, etc.. no toolbars installed.. Take the test page, and start removing pieces of the code until the problem goes away. What was the last part you removed? Good idea.. Stuff like that is where I would start. If you don't have access to your user's computer, it is going to be a lot harder, but it helps that you can at least reproduce the problem in part on your coworker's computer. Well luckily as I mentioned, another user (our other CF programmer) is experiencing the same problem on a less significant scale... he's gonna try removing stuff and see if he can figure out what might be causing it. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
form collection
Hello, I am using argumentCollection=form to dump all of the form fields into a CFC. I would like to add to the form collection one more variable called Alias. I tried this but the variable FORM.Alias does not appear to actually be in the collection. cfset FORM.Alias = application.page.makeAlias(form.Name) cfset application.page.savePage(argumentCollection=form) / How do I append one more form field to the collection? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: making functions global in model glue
Joe added a helpers scope in MG 3 to make it easier to work with UDF libraries. Ray posted a blog about this a little while ago: http://www.coldfusionjedi.com/index.cfm/2008/5/2/ModelGlue-3--The-New-Frakin-Awesomeness Of course, I have no idea which version you're using. :) But that gives you another option, and I must admit, I'm all about the options. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
multiple select drop down box and oracle dates
Hi Folks,
I ran into an issue with a multiple select drop down box that has a list of
dates i.e. mm/dd/.
On my action page I have a cfquery that I would like to pass the list of dates
to like:
Mydates IN ('08/01/2008','08/02/2008',â¦)
In oracle I need to do something like: TO_DATE('08/01/2008','mm/dd/'), ect
Any ideas how to do this passing the values from a multiple select box?
Thanks in advance!
-Jim
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form collection
On Fri, Sep 5, 2008 at 11:20 AM, Chad Gray [EMAIL PROTECTED] wrote: Hello, I am using argumentCollection=form to dump all of the form fields into a CFC. I would like to add to the form collection one more variable called Alias. I tried this but the variable FORM.Alias does not appear to actually be in the collection. cfset FORM.Alias = application.page.makeAlias(form.Name) cfset application.page.savePage(argumentCollection=form) / How do I append one more form field to the collection? why not just use a hidden form field in the form itself? input type=hidden name=alias value=... / ? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: form collection
I need to take what they type into the form Name field and remove illegal characters and then that becomes the Alias variable I need to insert into the database. I suppose I could run my MakeAlias function inside of the savePage function. I will give that a try. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 2:33 PM To: CF-Talk Subject: Re: form collection On Fri, Sep 5, 2008 at 11:20 AM, Chad Gray [EMAIL PROTECTED] wrote: Hello, I am using argumentCollection=form to dump all of the form fields into a CFC. I would like to add to the form collection one more variable called Alias. I tried this but the variable FORM.Alias does not appear to actually be in the collection. cfset FORM.Alias = application.page.makeAlias(form.Name) cfset application.page.savePage(argumentCollection=form) / How do I append one more form field to the collection? why not just use a hidden form field in the form itself? input type=hidden name=alias value=... / ? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: form collection
Hmm never mind. I had an error in my code that made me think Alias was not being added to the collection. It appears to work now that I found my real bug. Chad -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 2:37 PM To: CF-Talk Subject: RE: form collection I need to take what they type into the form Name field and remove illegal characters and then that becomes the Alias variable I need to insert into the database. I suppose I could run my MakeAlias function inside of the savePage function. I will give that a try. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 2:33 PM To: CF-Talk Subject: Re: form collection On Fri, Sep 5, 2008 at 11:20 AM, Chad Gray [EMAIL PROTECTED] wrote: Hello, I am using argumentCollection=form to dump all of the form fields into a CFC. I would like to add to the form collection one more variable called Alias. I tried this but the variable FORM.Alias does not appear to actually be in the collection. cfset FORM.Alias = application.page.makeAlias(form.Name) cfset application.page.savePage(argumentCollection=form) / How do I append one more form field to the collection? why not just use a hidden form field in the form itself? input type=hidden name=alias value=... / ? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: making functions global in model glue
thanks very much, i am actually using model glue 2, yet we are only just starting to use it - would you recommend that we start leaning model glue 3 - is there many changes and also benefits? thanks for your help richard Joe added a helpers scope in MG 3 to make it easier to work with UDF libraries. Ray posted a blog about this a little while ago: http://www.coldfusionjedi.com/index. cfm/2008/5/2/ModelGlue-3--The-New-Frakin-Awesomeness Of course, I have no idea which version you're using. :) But that gives you another option, and I must admit, I'm all about the options. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: making functions global in model glue
MG3 is amazing... but it's also an alpha, and a changing product. I launched CFLib with it, but that's because CFLib is my person little site, and not some multi-billion dollar business. If MG3 had crashed and burned, no one would be hurt. On Fri, Sep 5, 2008 at 1:42 PM, Richard White [EMAIL PROTECTED] wrote: thanks very much, i am actually using model glue 2, yet we are only just starting to use it - would you recommend that we start leaning model glue 3 - is there many changes and also benefits? -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
FTP GETFILE Read Timed Out Error
Hi everyone, I'm getting a timed out error when using cfftp action=GETFILE. I've tried and done the following: 1). Set IIS website and FTP site timeout time to 900 seconds 2). Used the attribute of timeout=900 in code shown below 3). Added ?timeout='900' in the URL 4). Tried adding timeout value on scheduled task and running that Any thoughts, directions, etc. would be greatly appreciated. * ERROR ** An error occurred during the FTP GETFILE operation. Error: Read timed out. * CODE ** cfftp action=GETFILE connection=*** remotefile=\inetpub\wwwroot\jbs\#name# localfile=d:\saprepository\w1\#name# failifexists=No timeout=900 stoponerror=yes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I need some help figuring this out...
*bump*... anyone? Thoughts? Thanks, Chris On Fri, Aug 29, 2008 at 3:17 PM, Chris Jordan [EMAIL PROTECTED]wrote: Hi folks, I need some help figuring something out, and after searching the web a bit on my own, and posting this question to my local CFUG, I thought I'd pose the problem to everyone here on CFTalk to see what came of it. Okay, so I need to write a program that checks an email account which will be receiving emails with PDF attachments. That part is no problem. The program then needs to embed an image onto the PDF in a specific physical location on the document. Technically speaking this will be an image of someone's signature, but for the sake of discussion it can be any image I want. Once the signature (image) has been affixed to the PDF, it is then saved and reprinted and then someone faxes that final printing to the end recipient. I don't have too much control (*read: basically none*) over the PDF before it gets to me. The reason being is that it starts life out as an *actual paper document* which is then faxed to a service (efax corporate, I think). That faxed image is turned into a PDF file and emailed to a predetermined email address. Is this going to be possible for me to do programmatically? The idea is that the person who needs to sign the document logs into the web based app., selects the document they want to sign, and the program takes care of putting the right signature in the right place on the document and re-saving it. My client currently accomplishes this by carrying around a tablet PC. They then check their email, save the attachment, open the PDF with Adobe Acrobat Pro, and sign using the touch screen. They want to be able to do this from a Treo 755p instead. That's where the web based app. with passwords and pre-captured signatures comes in. I got a suggestion from my boss that I try to use the CF Report Builder to build a report that would contain two generic objects: A PDF (to be passed in) and a signature (to be passed in). This generic report would allow me to position each of the generic objects as I want, and then I'd call the report passing it an original PDF and a signature image. He has apparently done this sort of thing before in FoxPro's in-built report writer. I've played around with that last idea a bit this afternoon, but I can't seem to figure out a way to get CF Report Builder to do what I want. I'm wondering if something like Crystal Reports would allow me to do what I'm wanting. The problem there is that I've never used Crystal, and my client would have to purchase a copy even though I don't know that it would allow me to do what I'm wanting to do any more than CF Report Builder. Attached is an image of one of these signed PDF files with some sensitive information blurred out. Any and all help is much appreciated. Cheers! Chris -- http://cjordan.us -- http://cjordan.us ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I need some help figuring this out...
*bump*... anyone? Thoughts? Based on the workflow, it sounds as though it might almost be easier to have a stamp made for the appropriate signatures and have whoever prints/faxes them stamp the signature before they're faxed out. I'll disclaim that I don't know how many users or documents you're working with or the legal issues that you might run into, but it's basically a low-tech method of doing the same thing you're trying to do in code. Unfortunately I don't have a lot of experience with the PDF or report builder functions, so I don't have any advice to offer there. -- Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: making functions global in model glue
thanks Ray, this is a good tip - we are building something that needs to be released commercially next month so i suppose we should get it up and running in MG2 and then when MG3 is officially released then we can make the migration thanks for the advice. in the meantime do you think my original scenario of making functions global is the right way to go in MG2 thanks MG3 is amazing... but it's also an alpha, and a changing product. I launched CFLib with it, but that's because CFLib is my person little site, and not some multi-billion dollar business. If MG3 had crashed and burned, no one would be hurt. On Fri, Sep 5, 2008 at 1:42 PM, Richard White [EMAIL PROTECTED] wrote: thanks very much, i am actually using model glue 2, yet we are only just starting to use it - would you recommend that we start leaning model glue 3 - is there many changes and also benefits? -- == = Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers. org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form slowness inexplicable
No slowness for me, IE6/WinXP/3-yr-old laptop. -- Josh - Original Message - From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 05, 2008 9:54 AM Subject: Form slowness inexplicable Okay... I've had ONE user complain about the slowness of this form: http://www.it.dev.duke.edu/public/formtest.html The problem they're having is that when the resize the window or scroll or move it, it's slow. Very slow. I don't have this problem. My coworker experiences the problem to a lesser extent than the user, but he's got a super powerful machine (more powerful than mine.. faster processor, more RAM, etc). The difference is that both he and the user are on laptops and I'm on a desktop. I'm running IE7, Firefox 3, and Chrome and experience no problems. He's running IE6, Firefox 3, and Chrome.. only problem in IE6. He upgraded to IE7 and still noticed the slowness. The user was also using IE but I'm not sure if it was 6 or 7. He says when he scrolls, it's spiking his CPU usage. Anyone got any ideas on this? -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Hi everyone
Hi everyone, After what seems like 100 years reading the archives, I just joined the mailing list and wanted to introduce myself. My name is Philip Kaplan and I've been a ColdFusion programmer since around 1996. I'm sure others discovered CF this way -- IIS hadn't yet been invented so I was using a web server called Orielly Website Pro, which happened to come with ColdFusion built-in. I was in college on a summer internship (at Booz Allen Hamilton) and my employer (thank goodness) told me to learn it. I've built a lot of sites in ColdFusion since then. The most well-known was a site called Fuckedcompany.com that tracked the collapse of the (first?) dot-com bust. One of the newer CF sites I built is a photo-sharing social network at www.mobog.com. It's the first CF site I've load balanced across multiple servers, which is fun. Incidentally it's hosted on www.gogrid.comwhich is a could-hosting thingamajig. Happy to share my (mostly positive, some negative) experiences with it. For a living, I'm the founder and president of an ad network called AdBrite. AdBrite was initially developed by my business partner, a PHP guy, so no CF there. We have about 115 employees and are based in San Francisco. I still get to use CF at the day-job to prototype stuff and build some internal reporting tools. Anyway, hello everyone! Philip ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I need some help figuring this out...
Chris, Since you are working with faxes you are not really working with a PDF. In reallity you are working with a TIFF file or JPG that is embedded in the PDF - one tiff or jpg for each page of the PDF. If you know the page you need to work on you can do the following: Extract the page as an image. Overlay your signature image in the proper position on the extracted image. Reassemble the PDF as a new PDF File (this might mean extracting each image and stringing them together again). CF 8's new image libraries are excellent for this sort of thing. Some things to keep in mind. The image qualify of the fax will vary greatly so getting this right might be a bit of a crap shoot. Also, you can't predict how the pages come in in your fax document. For example, if someone faxes correctly the first page is the cover page, but what if they fax backwards? What if they get pages upside down? There are a good number possible human errors that can be introduced using FAX. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Chris Jordan [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2008 10:35 AM To: CF-Talk Subject: Re: I need some help figuring this out... *bump*... anyone? Thoughts? Thanks, Chris On Fri, Aug 29, 2008 at 3:17 PM, Chris Jordan [EMAIL PROTECTED]wrote: Hi folks, I need some help figuring something out, and after searching the web a bit on my own, and posting this question to my local CFUG, I thought I'd pose the problem to everyone here on CFTalk to see what came of it. Okay, so I need to write a program that checks an email account which will be receiving emails with PDF attachments. That part is no problem. The program then needs to embed an image onto the PDF in a specific physical location on the document. Technically speaking this will be an image of someone's signature, but for the sake of discussion it can be any image I want. Once the signature (image) has been affixed to the PDF, it is then saved and reprinted and then someone faxes that final printing to the end recipient. I don't have too much control (*read: basically none*) over the PDF before it gets to me. The reason being is that it starts life out as an *actual paper document* which is then faxed to a service (efax corporate, I think). That faxed image is turned into a PDF file and emailed to a predetermined email address. Is this going to be possible for me to do programmatically? The idea is that the person who needs to sign the document logs into the web based app., selects the document they want to sign, and the program takes care of putting the right signature in the right place on the document and re-saving it. My client currently accomplishes this by carrying around a tablet PC. They then check their email, save the attachment, open the PDF with Adobe Acrobat Pro, and sign using the touch screen. They want to be able to do this from a Treo 755p instead. That's where the web based app. with passwords and pre-captured signatures comes in. I got a suggestion from my boss that I try to use the CF Report Builder to build a report that would contain two generic objects: A PDF (to be passed in) and a signature (to be passed in). This generic report would allow me to position each of the generic objects as I want, and then I'd call the report passing it an original PDF and a signature image. He has apparently done this sort of thing before in FoxPro's in-built report writer. I've played around with that last idea a bit this afternoon, but I can't seem to figure out a way to get CF Report Builder to do what I want. I'm wondering if something like Crystal Reports would allow me to do what I'm wanting. The problem there is that I've never used Crystal, and my client would have to purchase a copy even though I don't know that it would allow me to do what I'm wanting to do any more than CF Report Builder. Attached is an image of one of these signed PDF files with some sensitive information blurred out. Any and all help is much appreciated. Cheers! Chris -- http://cjordan.us -- http://cjordan.us ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfc scenario help
Hi, we have been doing alot of work on understanding OO development using CFC's and model glue. we have one issue that we don't quite understand and hope someone can help to simplify the problem: we have 2 objects: projects, and tests we have ensured that each of these objects have a DAO cfc for single db record access. and a GW for multiple db record access. we also have a service cfc for each of these objects. this is good as projects can be created, removed, searched etc... and the same with tests however tests can be linked to projects. there is a table in the database that is called projecttests and contains the projectID and testID as primary keys and foreign keys. the problem comes when understanding how to link this in the cfc's - where exactly will this fit in? would it fit into the projects cfc - so it could appear as project.linktest(#testobject#) - but then i would also need functions such as project.getAllTests(#projectobject#) etc... i am a little confused and would really appreciate any help in understanding how to best achieve this thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: making functions global in model glue
Sure, I've done that before. I'll have a util.cfc that others CFCs use for misc crap. On Fri, Sep 5, 2008 at 4:35 PM, Richard White [EMAIL PROTECTED] wrote: thanks Ray, this is a good tip - we are building something that needs to be released commercially next month so i suppose we should get it up and running in MG2 and then when MG3 is officially released then we can make the migration thanks for the advice. in the meantime do you think my original scenario of making functions global is the right way to go in MG2 thanks MG3 is amazing... but it's also an alpha, and a changing product. I launched CFLib with it, but that's because CFLib is my person little site, and not some multi-billion dollar business. If MG3 had crashed and burned, no one would be hurt. On Fri, Sep 5, 2008 at 1:42 PM, Richard White [EMAIL PROTECTED] wrote: thanks very much, i am actually using model glue 2, yet we are only just starting to use it - would you recommend that we start leaning model glue 3 - is there many changes and also benefits? -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hi everyone
After what seems like 100 years reading the archives, I just joined the mailing list and wanted to introduce myself. I thought that name looked familiar. Welcome to the list! -- Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query of Queries error
i had a similar problem and turned out to be that one of the values in the order by clause was empty - cf seems to mistake it for a empty string and therefore was producing the same error you are experiencing... check all values in the problem column to ensure there are no empty values i also get around alot of query of query problems by using cast() hope this helps I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server 2005. Below is the query block. There error comes in the select statement. if (NOT IsDefined(URL.sOrderBy)) URL.sOrderBy = dtStartDate; if (NOT IsDefined(URL.sOrderType)) URL.sOrderType = DESC; /cfscript cftry !--- Query of a query --- cfquery name=Variables.qSearchProjects dbtype=query SELECT * FROMqCombinedProjects ORDER BY #URL.sOrderBy# #URL.sOrderType#; /cfquery cfcatch !--- Order the projects by start date --- cfquery name=Variables.qSearchProjects dbtype=query SELECT * FROMqCombinedProjects ORDER BY dtStartDate DESC; /cfquery /cfcatch /cftry dtstartdate is in date format. Please help as this really urgent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I need some help figuring this out...
Mark is right about the fax really being an image (most likely a TIFF). I've had to do some rather ugly things like this before and what I did was use ImageMagick to convert the pdf to a tiff, place the second image atop it in the correct spot, then merge the layers and save it out as a another image (or pdf in this case). If you can change your process, you might take a look at Adobe's LiveCycle products. They are designed to do document (including paper) management and workflow things. I don't have much experience with the tools, but I investigated it a little bit when I was looking at the possibility of taking paper forms and turning them into pdf forms that users could fill out online. And lastly you might take a look at Apache's FOP project.It uses style sheets and XML to programmatically create PDFs (and other formats). You could create an XSL:FO style sheet to take two source images (the pdf of the fax and the image of the signature), place them through CSS, then output the resultant document to PDF. I've had to do this before and it takes a bit to wrap your head around but in the end, its just XML and CSS. Cheers, Judah On Fri, Sep 5, 2008 at 2:43 PM, Mark Kruger [EMAIL PROTECTED] wrote: Chris, Since you are working with faxes you are not really working with a PDF. In reallity you are working with a TIFF file or JPG that is embedded in the PDF - one tiff or jpg for each page of the PDF. If you know the page you need to work on you can do the following: Extract the page as an image. Overlay your signature image in the proper position on the extracted image. Reassemble the PDF as a new PDF File (this might mean extracting each image and stringing them together again). CF 8's new image libraries are excellent for this sort of thing. Some things to keep in mind. The image qualify of the fax will vary greatly so getting this right might be a bit of a crap shoot. Also, you can't predict how the pages come in in your fax document. For example, if someone faxes correctly the first page is the cover page, but what if they fax backwards? What if they get pages upside down? There are a good number possible human errors that can be introduced using FAX. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Chris Jordan [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2008 10:35 AM To: CF-Talk Subject: Re: I need some help figuring this out... *bump*... anyone? Thoughts? Thanks, Chris On Fri, Aug 29, 2008 at 3:17 PM, Chris Jordan [EMAIL PROTECTED]wrote: Hi folks, I need some help figuring something out, and after searching the web a bit on my own, and posting this question to my local CFUG, I thought I'd pose the problem to everyone here on CFTalk to see what came of it. Okay, so I need to write a program that checks an email account which will be receiving emails with PDF attachments. That part is no problem. The program then needs to embed an image onto the PDF in a specific physical location on the document. Technically speaking this will be an image of someone's signature, but for the sake of discussion it can be any image I want. Once the signature (image) has been affixed to the PDF, it is then saved and reprinted and then someone faxes that final printing to the end recipient. I don't have too much control (*read: basically none*) over the PDF before it gets to me. The reason being is that it starts life out as an *actual paper document* which is then faxed to a service (efax corporate, I think). That faxed image is turned into a PDF file and emailed to a predetermined email address. Is this going to be possible for me to do programmatically? The idea is that the person who needs to sign the document logs into the web based app., selects the document they want to sign, and the program takes care of putting the right signature in the right place on the document and re-saving it. My client currently accomplishes this by carrying around a tablet PC. They then check their email, save the attachment, open the PDF with Adobe Acrobat Pro, and sign using the touch screen. They want to be able to do this from a Treo 755p instead. That's where the web based app. with passwords and pre-captured signatures comes in. I got a suggestion from my boss that I try to use the CF Report Builder to build a report that would contain two generic objects: A PDF (to be passed in) and a signature (to be passed in). This generic report would allow me to position each of the generic objects as I want, and then I'd call the report passing it an original PDF and a signature image. He has apparently done this sort of thing before in FoxPro's in-built report writer. I've played around with that last idea a bit this afternoon, but I can't seem to figure out a way to get CF Report Builder to do what I
Re: making functions global in model glue
excellent, thanks for your help ray richard Sure, I've done that before. I'll have a util.cfc that others CFCs use for misc crap. -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hi everyone
On Fri, Sep 5, 2008 at 5:42 PM, Philip Kaplan [EMAIL PROTECTED] wrote: Hi everyone, After what seems like 100 years reading the archives, I just joined the mailing list and wanted to introduce myself. My name is Philip Kaplan and I've been a ColdFusion programmer since around 1996. I'm sure others discovered CF this way -- IIS hadn't yet been invented so I was using a web server called Orielly Website Pro, which happened to come with ColdFusion built-in. I was in college on a summer internship (at Booz Allen Hamilton) and my employer (thank goodness) told me to learn it. I've built a lot of sites in ColdFusion since then. The most well-known was a site called Fuckedcompany.com that tracked the collapse of the (first?) dot-com bust. One of the newer CF sites I built is a photo-sharing social network at www.mobog.com. It's the first CF site I've load balanced across multiple servers, which is fun. Incidentally it's hosted on www.gogrid.comwhich is a could-hosting thingamajig. Happy to share my (mostly positive, some negative) experiences with it. For a living, I'm the founder and president of an ad network called AdBrite. AdBrite was initially developed by my business partner, a PHP guy, so no CF there. We have about 115 employees and are based in San Francisco. I still get to use CF at the day-job to prototype stuff and build some internal reporting tools. Anyway, hello everyone! Philip Nice one Philip! I use to check out FC all the time. What a great site that was. And of course I stumble on some of the Ask Pud blog entries ;-) Welcome to the list. Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hi everyone
all_together_in_a_sing_song_voiceHi Philip/all_together_in_a_sing_song_voice ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 05, 2008 4:42 PM Subject: Hi everyone Hi everyone, After what seems like 100 years reading the archives, I just joined the mailing list and wanted to introduce myself. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hi everyone
you eq funny :) On Fri, Sep 5, 2008 at 3:35 PM, Brad Wood [EMAIL PROTECTED] wrote: all_together_in_a_sing_song_voiceHi Philip/all_together_in_a_sing_song_voice ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 05, 2008 4:42 PM Subject: Hi everyone Hi everyone, After what seems like 100 years reading the archives, I just joined the mailing list and wanted to introduce myself. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTP GETFILE Read Timed Out Error
Hi, Patrick... I've been working with cfftp recently and noticed it's been throwing an error (hanging and timing out) on a particular file. I tried downloading it with a third-party ftp program (FileZilla) just to make sure the file wasn't corrupted. It wasn't, so I'm not sure what the problem is. Perhaps downloading with FileZilla or something else like that will give some clues... Rick -Original Message- From: patrick buch [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 5:01 PM To: CF-Talk Subject: FTP GETFILE Read Timed Out Error Hi everyone, I'm getting a timed out error when using cfftp action=GETFILE. I've tried and done the following: 1). Set IIS website and FTP site timeout time to 900 seconds 2). Used the attribute of timeout=900 in code shown below 3). Added ?timeout='900' in the URL 4). Tried adding timeout value on scheduled task and running that Any thoughts, directions, etc. would be greatly appreciated. * ERROR ** An error occurred during the FTP GETFILE operation. Error: Read timed out. * CODE ** cfftp action=GETFILE connection=*** remotefile=\inetpub\wwwroot\jbs\#name# localfile=d:\saprepository\w1\#name# failifexists=No timeout=900 stoponerror=yes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTP GETFILE Read Timed Out Error
This may seem really silly to ask, but how much time is elapsing before the timeout error? 900 seconds should be giving you 15 minutes. What happens when you try to download it with a regular FTP utility? If you check the server's network usage during the download, does it show incoming traffic? If you look at a stack trace, what is it doing while it downloads? Do you have any firewall settings that might be timing out TCP sessions? Are you using passive FTP? If you run netstat on the server while it is transferring, what ports do you see in use, and what is the status of the connection? If cfftp uses a temp directory to write files to, can you watch it and see if your temp file is growing during the transfer? (cf_root/runtime/servers/default/SERVER-INF/temp/wwwroot-tmp/ might be the location of the temp dir, but it's a guess) ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTP GETFILE Read Timed Out Error
Maybe it took longer than 900 seconds? How big is the file? -- Josh - Original Message - From: patrick buch [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 05, 2008 2:00 PM Subject: FTP GETFILE Read Timed Out Error Hi everyone, I'm getting a timed out error when using cfftp action=GETFILE. I've tried and done the following: 1). Set IIS website and FTP site timeout time to 900 seconds 2). Used the attribute of timeout=900 in code shown below 3). Added ?timeout='900' in the URL 4). Tried adding timeout value on scheduled task and running that Any thoughts, directions, etc. would be greatly appreciated. * ERROR ** An error occurred during the FTP GETFILE operation. Error: Read timed out. * CODE ** cfftp action=GETFILE connection=*** remotefile=\inetpub\wwwroot\jbs\#name# localfile=d:\saprepository\w1\#name# failifexists=No timeout=900 stoponerror=yes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hi everyone
all_together_in_a_sing_song_voice H Philip /all_together_in_a_sing_song_voice Philip Hi everyone... I am a...aa... Dammit!! I am a.ColdFusion Programmer. /Philip Philip There I said it!! Are you HAPPY NOW/Philip Philip Look!! I TRIED to give it up. Lord knows I tried. /Phili Philip But DAMMIT!! I just can't do it!!! It just makes me so so... (long sigh) PRODUCTIVE. /Philip Sorry folk... Happy hour you know ;) ~G~ On Fri, Sep 5, 2008 at 6:35 PM, Brad Wood [EMAIL PROTECTED] wrote: all_together_in_a_sing_song_voiceHi Philip/all_together_in_a_sing_song_voice ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 05, 2008 4:42 PM Subject: Hi everyone Hi everyone, After what seems like 100 years reading the archives, I just joined the mailing list and wanted to introduce myself. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hi everyone
God... That's what I get for reading messages from most recent to oldest. I was like, WTF?!?!? Gerald Guido wrote: all_together_in_a_sing_song_voice H Philip /all_together_in_a_sing_song_voice Philip Hi everyone... I am a...aa... Dammit!! I am a.ColdFusion Programmer. /Philip Philip There I said it!! Are you HAPPY NOW/Philip Philip Look!! I TRIED to give it up. Lord knows I tried. /Phili Philip But DAMMIT!! I just can't do it!!! It just makes me so so... (long sigh) PRODUCTIVE. /Philip Sorry folk... Happy hour you know ;) ~G~ On Fri, Sep 5, 2008 at 6:35 PM, Brad Wood [EMAIL PROTECTED] wrote: all_together_in_a_sing_song_voiceHi Philip/all_together_in_a_sing_song_voice ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 05, 2008 4:42 PM Subject: Hi everyone Hi everyone, After what seems like 100 years reading the archives, I just joined the mailing list and wanted to introduce myself. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Trying to use cfexecute to run batch file...
I'm trying to use cfexecute to run this bath file content: ftp -s:getfiles.txt The batch file reads its commands from getfiles.txt, which has the following code: open datalink.interealty.com [username] [password] cd /DataLinkOutput/SAV/SAV_119201 prompt mget *.* bye I can run the batch file manually and all is well. However, I can't get any results except a timeout when I use cfexecute to run the batch file. I've googled and tried everything I can think of, but obviously something's not right. Here's the cfexecute code: cfexecute name=e:\adobe_site\getfiles.bat timeout=60 But that's not working. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
