Re: Mock Objects for ColdFusion
On Monday 04 December 2006 17:24, Jeff Chastain wrote: I am looking to test the data access layer object that talks to Reactor. So, said object would take in some data from a form for example, then call Reactor for a record object, stuff the data in, then save it. Given that I want to test my data access object only, how do you simulate the Reactor communications? Looks like you'd just create an empty record, populate it, save it, load it and check the fields match. This will exercise your data layer, no ? -- Tom Chiverton Helping to efficiently industrialize cross-media clusters This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Safely selecting last inserted ID
Thanks, I completely missed the last_inserted_id part of that blog post :O I ended up using LAST_INSERTED_ID() for MySQL and SCOPE_IDENTITY() for SQL Server. / Per On 12/4/06, Matt Robertson [EMAIL PROTECTED] wrote: On 12/4/06, Per Djurner [EMAIL PROTECTED] wrote: I'm trying to find a good solution that works for me when it comes to the classic problem of selecting the last inserted ID in a database table and making sure it's thread safe. http://mysecretbase.com/get_the_last_id.cfm -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MSSQL Function (Div 0)?
I have a query that will ocasionally throw a divide by 0 error. I know why, and for my purposes it will do to make the 0 a 0.01 In the following SQL... SELECT col1/col2 AS result FROM aTable What is the simplest way to make col2 0.01 if it is 0. Is there an equivelent of the CF max() function, max(col2,0.01) would work for example, or an equivalent of the isNull() function for is0() ;-) -- Jay ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Images and Watermarks?
I am curious as how you can add a watermark to an image without having to create a new image. Like some of the photo sites have images and when they are enlarged, you see the watermark but if you purchase it is gone. Any pointers? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Images and Watermarks?
I did find imagecfc and can work, just looking for something more robust. Ability to add copyright notice diagonally to an image. There are some CFX_ tags but I am on a shared hosting so I am not positive about If we are able to load it or not. Any other solutions I may have missed? TIA! -Original Message- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 5:35 AM To: CF-Talk Subject: Images and Watermarks? I am curious as how you can add a watermark to an image without having to create a new image. Like some of the photo sites have images and when they are enlarged, you see the watermark but if you purchase it is gone. Any pointers? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MSSQL Function (Div 0)?
Not in MSSQL 2000 or earlier. Create your own: CREATE FUNCTION MAX_INT ( @int1 INT, @int2 INT ) RETURNS INT AS BEGIN DECLARE @highestInt INT IF ( @int2 @int1 ) SELECT @highestInt = @int1 ELSE SELECT @highestInt = @int2 RETURN @highestInt END GO Adrian -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 10:26 To: CF-Talk Subject: MSSQL Function (Div 0)? I have a query that will ocasionally throw a divide by 0 error. I know why, and for my purposes it will do to make the 0 a 0.01 In the following SQL... SELECT col1/col2 AS result FROM aTable What is the simplest way to make col2 0.01 if it is 0. Is there an equivelent of the CF max() function, max(col2,0.01) would work for example, or an equivalent of the isNull() function for is0() ;-) -- Jay ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF7 on Solaris - using MS Excel as a data source
We are migrating to CF7 on Solaris 10. In our Windows environment we have a number of applications that use MS Excel as data sources for read only. We access these using ODBC socket after the server admin creates system ODBC data sources to each of the excel files on the server. How is this handled on Solaris? How do we set up a data source to an Excel file? Thanks! George ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple Sites on IIS 5 on XP?
Hi all, Is there a way to define multiple websites on Windows XP IIS 5? Obviously, on the server edition, one can right click in IIS config and create a new website easily, but my dev box is running XP pro and doesn't seem to have the functionality. http://localhost/foo/ is fine, but I want the site with it's own site root - http://foo/ per example. I'm getting fed up with having to second guess all the site relative links :) Thanks T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple Sites on IIS 5 on XP?
Yes, you cannot create multiple sites in XP. There are several tools to do this.. Search for tools such as IISAdmin. HTH -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 11:30 To: CF-Talk Subject: Multiple Sites on IIS 5 on XP? Hi all, Is there a way to define multiple websites on Windows XP IIS 5? Obviously, on the server edition, one can right click in IIS config and create a new website easily, but my dev box is running XP pro and doesn't seem to have the functionality. http://localhost/foo/ is fine, but I want the site with it's own site root - http://foo/ per example. I'm getting fed up with having to second guess all the site relative links :) Thanks T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiple Sites on IIS 5 on XP?
awesome, that's done the job. Ta muchly T On 5 Dec 2006, at 11:32, Robertson-Ravo, Neil (RX) wrote: Yes, you cannot create multiple sites in XP. There are several tools to do this.. Search for tools such as IISAdmin. HTH -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 11:30 To: CF-Talk Subject: Multiple Sites on IIS 5 on XP? Hi all, Is there a way to define multiple websites on Windows XP IIS 5? Obviously, on the server edition, one can right click in IIS config and create a new website easily, but my dev box is running XP pro and doesn't seem to have the functionality. http://localhost/foo/ is fine, but I want the site with it's own site root - http://foo/ per example. I'm getting fed up with having to second guess all the site relative links :) Thanks T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
On Tuesday 05 December 2006 10:42, Coldfusion wrote: I am curious as how you can add a watermark to an image without having to create a new image. Can't be done reliably- you have to create a watermarked version and keep the original. -- Tom Chiverton Helping to assertively brand second-generation convergence This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Images and Watermarks?
The only company I've seen which can do this is http://www.photags.com/activewatermarks.htm -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 7:20 AM To: CF-Talk Subject: Re: Images and Watermarks? On Tuesday 05 December 2006 10:42, Coldfusion wrote: I am curious as how you can add a watermark to an image without having to create a new image. Can't be done reliably- you have to create a watermarked version and keep the original. -- Tom Chiverton Helping to assertively brand second-generation convergence This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
onSessionEnd function not getting called
Hi, I'm having problems trying to get the onSessionEnd function to work in the Application.cfc file. I can confirm that the sessions are being created and that they are also dropping after the specified time. However, no further action is taken when the session is ended. I've tested the code within the onsessionend function and that seems to work, it just doens't appear to be called? Here's the code: [code] cfcomponent output=false !--- Global Application Settings --- cfset setEncoding(url,utf-8) cfset setEncoding(form,utf-8) cfcontent type=text/html; charset=utf-8 cfset THIS.name = PomAdminzone cfset THIS.sessionManagement = true cfset THIS.sessiontimeout = createtimespan(0,0,0,20) cfset This.applicationtimeout= createtimespan(5,0,0,0) cffunction name=onRequestStart output=true !--- Global Site Settings --- cfset THIS.scriptProtect = all cfinclude template=../_company-info.cfm cfinclude template=_login-check.cfm cfset REQUEST.theDirection = 'ltr' cfset REQUEST.theLingo = 'en' cfset REQUEST.theLayout = 'layout-admin2.cfm' cfset REQUEST.theStyle = 'layout-admin2.css' cfset REQUEST.useContent = 'yes' /cffunction cffunction name=onSessionStart cfinclude template=../_company-info.cfm cfset SESSION.created = now() cfquery name=changeStatus datasource=#REQUEST.theDatabase# UPDATE companyDetails SET status = 'ONLINE' WHERE companyID = cfqueryparam value=#REQUEST.companyID# cfsqltype=cf_sql_integer / /cfquery /cffunction cffunction name=onSessionEnd cfinclude template=../../../customtags/getSessionList.cfm cfif StructIsEmpty(getSessionList(application.applicationname)) cfquery name=changeStatus datasource=#REQUEST.theDatabase# UPDATE companyDetails SET status = 'INTERMITTANT' WHERE companyID = cfqueryparam value=#REQUEST.companyID# cfsqltype=cf_sql_integer / /cfquery /cfif /cffunction /cfcomponent [/code] Any ideas how to resolve this? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MSSQL Function (Div 0)?
James Smith wrote: SELECT col1/col2 AS result FROM aTable What is the simplest way to make col2 0.01 if it is 0. You also could do it with a CASE statement... SELECT col1/CASE col2 WHEN 0 THEN 0.01 ELSE col2 END AS result OR SELECT CASE col2 WHEN 0 THEN -1 ELSE col1/col2 END AS result (if you really just want some predetermined value in there if col2 is 0) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: getSessionList.cfm UDF
Just a general warning that you can do things like this on a shared host, as most people don't realise, and yes to say that find a host that has CF properly secured (yes like us). A Lot of people want everything enabled and don't really consider the consequences. And even with a secured server, some things (like CFDUMP) will still work and allow you to do things like the below. Personally I now store all my private data in request scope and not application variables for this reason. Russ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 00:48 To: CF-Talk Subject: RE: getSessionList.cfm UDF Another reason not to use shared hosting and another example of how CFMX is just not suitable for shared hosting. In any case, can't you disable CreateObject(java,...) with security sandboxes? Yes you can, and we do, but some hosts don't, so I'm just giving a word of warning to thos eon a shared host who do have CreateObject(java) enabled. I'm confused; is your word of warning that people should only use hosts that have properly configured their servers (like you), or that they shouldn't use you either? Because most people would likely take the latter meaning from your first response. It's fine with me either way, since I don't use shared hosting. Also, you can still CFDUMP the application scope with no application name and see all the application vars. How else would you use CFDUMP to see the application scope? Or are you saying you can use CFDUMP to see the application scope of other applications? 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
On Tuesday 05 December 2006 12:26, Katz, Dov B (IT) wrote: The only company I've seen which can do this is http://www.photags.com/activewatermarks.htm Way to not be cross platform. I guess they're making use of the fact JPEG can contain meta data regions. The system is still weak because I can pay once and then distribute the no-watermark version for free (I can screen shot it to bypass the embedded account details, if they aren't removable meta data, or just plain use an account I don't care about). -- Tom Chiverton Helping to confidentially extend interdependent systems This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: path outside webroot
In the case of using / to mean the root of your site, this works if you have no / mapping (e.g. cfinclude template=/includes/myfile.cfm). Which implies that CF does know about your IIS settings, otherwise how would it know the root of your site ? Russ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 05:59 To: CF-Talk Subject: RE: path outside webroot I indeed can, but I don't get why expandpath('/') returns something completely different than expandpath('.') especially if, like you said, CF doesn't know anything about my IIS setup... Slashes are resolved using mappings, as per the docs. Dots are resolved using the current location on the filesystem. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Any way to limit file upload size?
Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
On Tuesday 05 December 2006 10:42, Coldfusion wrote: I am curious as how you can add a watermark to an image without having to create a new image. I'm sure you could, but why would you want to? Watermarking an image with every request would not scale very well. You could cache watermark images... ie.. watermark.cfm --- cfparam name=img type=string cfset wm_img = wm_#img# cfif fileExists(#getTempDirectory()#/#wm_img#) !--- create watermarked image using image.cfc --- !--- or alagad or whatever --- /cfif cfcontent file=#getTempDirectory()#/#wm_img# type=image/jpeg reset=yes deletefile=no end watermark.cfm --- You'd just have to be careful about making sure you delete the old watermark when you update the original image. but I'm not sure why you wouldn't just create a separate watermark image up front. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any way to limit file upload size?
Gaulin, Mark wrote: Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I'm pretty sure there's a setting in apache that allows you to limit the size of POST content, but I don't recall ever seeing such a thing in IIS. CF won't help, because CF doesn't really know what's going on until the request is sent.. I'm not even sure CF *GETS* the request until the browser has sent the complete request to the web server. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any way to limit file upload size?
Without some outside help like activeX controls, there's really no way to know the file size before it is uploaded in all browsers. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 8:29 AM To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
ImageMagic does this just brilliantly. I've done it on a fairly large scale. I'm curious Rick, why would it not scale well? Greg On 12/5/06, Rick Root [EMAIL PROTECTED] wrote: On Tuesday 05 December 2006 10:42, Coldfusion wrote: I am curious as how you can add a watermark to an image without having to create a new image. I'm sure you could, but why would you want to? Watermarking an image with every request would not scale very well. You could cache watermark images... ie.. watermark.cfm --- cfparam name=img type=string cfset wm_img = wm_#img# cfif fileExists(#getTempDirectory()#/#wm_img#) !--- create watermarked image using image.cfc --- !--- or alagad or whatever --- /cfif cfcontent file=#getTempDirectory()#/#wm_img# type=image/jpeg reset=yes deletefile=no end watermark.cfm --- You'd just have to be careful about making sure you delete the old watermark when you update the original image. but I'm not sure why you wouldn't just create a separate watermark image up front. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: onSessionEnd function not getting called
Richard, While I am not 100% sure of this, I believe that OnSessionEnd doesn't have access to the Application scope direction (or the session scope). I think both scopes are passed in AS arguments to the method and can only be accessed in that fashion: cffunction name=OnSessionEnd access=public returntype=void output=true hint=Fires when the session is terminated. !--- Define arguments. --- cfargument name=SessionScope type=struct required=true / cfargument name=ApplicationScope type=struct required=false default=#StructNew()# / cffile action=APPEND file=#ExpandPath( './trace.txt' )# output=OnSessionEnd : [ID - #ARGUMENTS.SessionScope.CFID#] [TOKEN - #ARGUMENTS.SessionScope.CFTOKEN#] addnewline=true / !--- Return out. --- cfreturn / /cffunction Hope that helps. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 6:23 AM To: CF-Talk Subject: onSessionEnd function not getting called Hi, I'm having problems trying to get the onSessionEnd function to work in the Application.cfc file. I can confirm that the sessions are being created and that they are also dropping after the specified time. However, no further action is taken when the session is ended. I've tested the code within the onsessionend function and that seems to work, it just doens't appear to be called? Here's the code: [code] cfcomponent output=false !--- Global Application Settings --- cfset setEncoding(url,utf-8) cfset setEncoding(form,utf-8) cfcontent type=text/html; charset=utf-8 cfset THIS.name = PomAdminzone cfset THIS.sessionManagement = true cfset THIS.sessiontimeout = createtimespan(0,0,0,20) cfset This.applicationtimeout= createtimespan(5,0,0,0) cffunction name=onRequestStart output=true !--- Global Site Settings --- cfset THIS.scriptProtect = all cfinclude template=../_company-info.cfm cfinclude template=_login-check.cfm cfset REQUEST.theDirection = 'ltr' cfset REQUEST.theLingo = 'en' cfset REQUEST.theLayout = 'layout-admin2.cfm' cfset REQUEST.theStyle = 'layout-admin2.css' cfset REQUEST.useContent = 'yes' /cffunction cffunction name=onSessionStart cfinclude template=../_company-info.cfm cfset SESSION.created = now() cfquery name=changeStatus datasource=#REQUEST.theDatabase# UPDATE companyDetails SET status = 'ONLINE' WHERE companyID = cfqueryparam value=#REQUEST.companyID# cfsqltype=cf_sql_integer / /cfquery /cffunction cffunction name=onSessionEnd cfinclude template=../../../customtags/getSessionList.cfm cfif StructIsEmpty(getSessionList(application.applicationname)) cfquery name=changeStatus datasource=#REQUEST.theDatabase# UPDATE companyDetails SET status = 'INTERMITTANT' WHERE companyID = cfqueryparam value=#REQUEST.companyID# cfsqltype=cf_sql_integer / /cfquery /cfif /cffunction /cfcomponent [/code] Any ideas how to resolve this? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 7.02 cumulative hotfix 1 problems with stored procedures?
I think that hotfix added support for named parameters in cfprocparam back in. Previously the dbvarname would be ignored. Make sure your parameter names are correct. (And, depending on your database settings, check the case as well.) Cheers, Kris Anybody getting errors with the hotfix? I've instaled in one of my servers today and the website went down after a few hours of running. The error is very wierd and does not says anything to me: Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near '='. The specific sequence of files included or processed is: C:\Inetpub\wwwroot\LocalUser\amazonia\index.cfm, line: 4 The stored proceedure wasn't change, nor the index.cfm file that calls it. Sintax is 1 : CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_INTEGER DBVARNAME=IDidioma VALUE=5 2 : CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_INTEGER DBVARNAME=IDsite VALUE=2 3 : CFPROCRESULT NAME=noticias_home MAXROWS=5 4 : /CFSTOREDPROC ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
Greg Luce wrote: ImageMagic does this just brilliantly. I've done it on a fairly large scale. I'm curious Rick, why would it not scale well? Watermarking an image is a lot more CPU intensive than just pullling an existing image off the file system. so if you were on a busy web site, watermarking the images on the fly *ALL* the time... you'd be doing a lot of completely unnecessary work. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any way to limit file upload size?
Can you use the CGI.CONTENT_LENGTH ? Doug B. - Original Message - From: Gaulin, Mark [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 6:28 AM Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any way to limit file upload size?
Hi Rick Yeah, that was my thought too. It looks like IIS does have MaxRequestEntityAllowed, which sounds like the same thing that you describe for Apache. I guess there is a php extension (or something like that) for Apache that allows per-request setting of limits, which is pretty cool. I was hoping that maybe something like that would turn up for CF/IIS. Oh well! Thanks Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 8:36 AM To: CF-Talk Subject: Re: Any way to limit file upload size? Gaulin, Mark wrote: Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I'm pretty sure there's a setting in apache that allows you to limit the size of POST content, but I don't recall ever seeing such a thing in IIS. CF won't help, because CF doesn't really know what's going on until the request is sent.. I'm not even sure CF *GETS* the request until the browser has sent the complete request to the web server. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any way to limit file upload size?
Doug Brown wrote: Can you use the CGI.CONTENT_LENGTH ? Not until after the web server has accepted the post content... so that wouldn't help with eliminating the bandwidth. I'm not sure how reliable that is anyway. rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any way to limit file upload size?
This requires flash, but may work very well for you. (I am not related in any way) http://labb.dev.mammon.se/swfupload/ From the site: * Only display chosen filetypes in dialog * Upload multiple files at once by ctrl/shift-selecting in dialog * Trigger javascript functions on start, cancel, progress and complete * Get file information/size before upload starts * Style upload buttons any way you want * Do progress-bars/information using valid XHTML and CSS * No page reloads, display uploaded files as they are finished * Works on all platforms/browsers that has Flash support. * Degrades gracefully to a normal html upload form if Flash or javascript isn't available * New! Control filesize before upload starts * New! Won't give the script is causing slow playback-error anymore * New! The swf won't do anything with not-allowed filetypes - Original Message - From: Gaulin, Mark [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 6:28 AM Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any way to limit file upload size?
There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SPRY and CFAJAX conflict
I am using some cfajax code and also using spry and seem to have a conflict. Here is how I call them. SCRIPT type='text/javascript' src='Ajax/core/prototype.js'/SCRIPT SCRIPT type='text/javascript' src='Ajax/core/suggest.js'/SCRIPT SCRIPT type='text/javascript' src='Ajax/core/engine.js'/SCRIPT SCRIPT type='text/javascript' src='Ajax/core/util.js'/SCRIPT SCRIPT type='text/javascript' src='Ajax/core/settings.js'/SCRIPT CFOUTPUT script language=JavaScript type=text/javascript src=#Request.webroot#Spry/xpath.js/script script language=JavaScript type=text/javascript src=#Request.webroot#Spry/SpryData.js/script /CFOUTPUT When my page loads I receive this SPRY error Spry.Data.updateRegion(extend) caught an exception: TypeError: Spry.Data.regionsArray[regionName].updateContent is not a function When I remove this line SCRIPT type='text/javascript' src='Ajax/core/prototype.js'/SCRIPT then the spry will work but my ajax Suggest does not work. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spry.Utils.loadURL(..., failure - But works ok in local
On Monday 04 December 2006 22:27, Walter Conti wrote: I get the following error: Exception caught while loading Invalid token 'e' found on line 1 at column 13. pThe CFML compiler was processing:ullia cfsetting tag beginning on line 1, column 2./ul The error occurred in D: \Inetpub\wwwroot\WWW73\web\Petitions\client\Remote\authenticate.cfm: line 1 1 : cfsetting enablecfoutputonly=true showdebugoutput=false 2 : cfset q = application.blog.authenticate(left(trim(url.username),50),left(trim(url.password),50)) 3 : cfcookie name = userId value = #q.userId# Next time, try cut and pasting the problematic URL into a browser yourself :-) -- Tom Chiverton Helping to biannually cultivate best-of-breed appliances This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images and Watermarks?
On Tuesday 05 December 2006 13:53, Rick Root wrote: so if you were on a busy web site, watermarking the images on the fly *ALL* the time... you'd be doing a lot of completely unnecessary work. Well, yes, you'd cache them somewhere :-) -- Tom Chiverton Helping to appropriately maximize turn-key synergies This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Full-Text Query Help
On Tuesday 05 December 2006 01:19, Russ wrote: Basically I have 2 tables that have no relationship. I want to search a single field in table2 (somefield) by using every value from the someotherfield field of the table1 table. I can't seem to get the syntax quite right. Is this even possible without looping? select s,t,u,f,f from table2, table 1 where singleField=condition and table2.linkFieled in ( select linkField from table2 ) would be one way. 'where exists' may be useful too. -- Tom Chiverton Helping to paradigmatically architect front-end initiatives This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SPRY and CFAJAX conflict
Are you using the latest version of Spry? I know they had some conflicts with prototype, but I thought they had fixed or minimized that in later releases. -Ryan ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SPRY and CFAJAX conflict
I have the pre-release 1.3 version and have this problem -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:26 AM To: CF-Talk Subject: Re: SPRY and CFAJAX conflict Are you using the latest version of Spry? I know they had some conflicts with prototype, but I thought they had fixed or minimized that in later releases. -Ryan ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Images and Watermarks?
But then they're no longer new for each request. You can't have it both ways. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 8:17 AM To: CF-Talk Subject: Re: Images and Watermarks? On Tuesday 05 December 2006 13:53, Rick Root wrote: so if you were on a busy web site, watermarking the images on the fly *ALL* the time... you'd be doing a lot of completely unnecessary work. Well, yes, you'd cache them somewhere :-) -- Tom Chiverton ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sftp plugin for eclipse?
Does anyone know of an SFTP plugin for eclipse that I could use for site management? Cfeclipse has a nifty little FTP extension but it doesn¹t support SFTP (that I can see). Thanks. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with chr() and Linux?
On 11/29/06, Markus Weber [EMAIL PROTECTED] wrote: Hi guys, i have the following simple code: cfsavecontent variable=sTmpMailContent À Á á ý ò ë Ç /cfsavecontent cfscript sTmpMailContent = Replace(sTmpMailContent,chr(192),'Agrave;','all'); sTmpMailContent = Replace(sTmpMailContent,chr(193),'Aacute;','all'); /cfscript cfoutput#sTmpMailContent#/cfoutput It works fine on Windows but can´t find the characters on Linux. What´s the problem? The server's most likely storing the accented characters as something other than chr(192), chr(193), etc., so CF can't match them correctly. I encountered a similar problem with one of our Spanish language sites. It turned out that the accented characters were being totally stripped out or encoded wrongly during file transfer to the (SLES 9.1) server (using Dreamweaver's SFTP feature). We ran into several other odd issues with this type of character, depending on how we set the doctype and character encoding, and eventually just used ...; encoding. Our solution probably isn't what you need, but this may give you an idea where to look. -- Those who would give up essential liberty to purchase a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SPRY and CFAJAX conflict
Are you using the latest version of Spry? I know they had some conflicts with prototype, but I thought they had fixed or minimized that in later releases. As far as I remember, you still need Prototype 1.5. Any previous version of Prototype break the ability to run a simple for in loop causing this kind of conflicts with many other libraries. Massimo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spry.Utils.loadURL(..., failure - But works ok in local
And while we are at it - the fact that this error a) showed up and b) showed the full path represents 2 security issues you should fix asap. :) On 12/5/06, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 04 December 2006 22:27, Walter Conti wrote: I get the following error: Exception caught while loading Invalid token 'e' found on line 1 at column 13. pThe CFML compiler was processing:ullia cfsetting tag beginning on line 1, column 2./ul The error occurred in D: \Inetpub\wwwroot\WWW73\web\Petitions\client\Remote\authenticate.cfm: line 1 1 : cfsetting enablecfoutputonly=true showdebugoutput=false 2 : cfset q = application.blog.authenticate(left(trim(url.username),50),left(trim(url.password),50)) 3 : cfcookie name = userId value = #q.userId# Next time, try cut and pasting the problematic URL into a browser yourself :-) -- Tom Chiverton Helping to biannually cultivate best-of-breed appliances This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SPRY and CFAJAX conflict
Anyone know where I can download ProtoType 1.5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:51 AM To: CF-Talk Subject: Re: SPRY and CFAJAX conflict Are you using the latest version of Spry? I know they had some conflicts with prototype, but I thought they had fixed or minimized that in later releases. As far as I remember, you still need Prototype 1.5. Any previous version of Prototype break the ability to run a simple for in loop causing this kind of conflicts with many other libraries. Massimo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images and Watermarks?
On Tuesday 05 December 2006 14:36, Andy Matthews wrote: But then they're no longer new for each request. You can't have it both ways. You'd only want them 'new' if you wanted the current time stamped on them, and I can't see a use case for that right now. -- Tom Chiverton Helping to heterogeneously supply cross-media communities This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SPRY and CFAJAX conflict
Google is great... http://prototype.conio.net -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:01 To: CF-Talk Subject: RE: SPRY and CFAJAX conflict Anyone know where I can download ProtoType 1.5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:51 AM To: CF-Talk Subject: Re: SPRY and CFAJAX conflict Are you using the latest version of Spry? I know they had some conflicts with prototype, but I thought they had fixed or minimized that in later releases. As far as I remember, you still need Prototype 1.5. Any previous version of Prototype break the ability to run a simple for in loop causing this kind of conflicts with many other libraries. Massimo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Replace content between tags (REReplaceNoCase)
Hello guys, i have a problem with the following regex: REReplaceNoCase(inputxml,text[^]*(.*)\/text,) The regex should replace the tag text with all the content inside (even other tags). It works fine if only one text.../text is in the whole string. But if theres a second or a third the replace works wrong. Example String that works right: bla bla bla textbla bla bbla/bbla/text bla bla bla Example String that works false: bla bla bla textbla bla bbla/bbla/text bla bla bla textbla bla bbla/bbla/text The replace will start at the first text and does end at the very last /text at the end of the string. Does anyone have a idea how i have to optimize my expression? Greets ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Full-Text Query Help
Does nobody have an idea on this? I'm basically trying to do something like this: select * from table1, table2 where table2.id=1 and table2.somefield like '%' + table1.someotherfield + '%' This works fine, although it's a bit slow for my taste... is there a way to optimize it, using full text search of verity? Somefield is a text field, and someotherfield is a varchar. Russ -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, December 04, 2006 8:20 PM To: CF-Talk Subject: Full-Text Query Help I'm trying to do something like the following Select table1Id from table1, table2 where talbe2.tableId=1 and contains(table2.somefield, table1.someotherfield) Basically I have 2 tables that have no relationship. I want to search a single field in table2 (somefield) by using every value from the someotherfield field of the table1 table. I can't seem to get the syntax quite right. Is this even possible without looping? Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
Oh I see what you're saying. I've never run into a reason to watermark an image on each request. Just when a user uploads an image, store the original, create a thumbnail, and create a resized version for use on the site and apply a watermark to it. ImageMagic works wonderfully for that. Greg On 12/5/06, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 05 December 2006 14:36, Andy Matthews wrote: But then they're no longer new for each request. You can't have it both ways. You'd only want them 'new' if you wanted the current time stamped on them, and I can't see a use case for that right now. -- Tom Chiverton Helping to heterogeneously supply cross-media communities This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Replace content between tags (REReplaceNoCase)
Hmm... CF regex is known for being greedy, and I believe you need to append a ? to make it not greedy. So try something like this REReplaceNoCase(inputxml,text[^]*?(.*?)\/text,) Russ -Original Message- From: Markus Weber [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:21 AM To: CF-Talk Subject: Replace content between tags (REReplaceNoCase) Hello guys, i have a problem with the following regex: REReplaceNoCase(inputxml,text[^]*(.*)\/text,) The regex should replace the tag text with all the content inside (even other tags). It works fine if only one text.../text is in the whole string. But if theres a second or a third the replace works wrong. Example String that works right: bla bla bla textbla bla bbla/bbla/text bla bla bla Example String that works false: bla bla bla textbla bla bbla/bbla/text bla bla bla textbla bla bbla/bbla/text The replace will start at the first text and does end at the very last /text at the end of the string. Does anyone have a idea how i have to optimize my expression? Greets ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Replace content between tags (REReplaceNoCase)
Try doing a NON-greedy search by putting a ? After your selector: REReplaceNoCase( inputxml, text[^]*(.*?)\/text, , ONE ) Notice, (.*?) this should match the shortest possible string. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Markus Weber [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:21 AM To: CF-Talk Subject: Replace content between tags (REReplaceNoCase) Hello guys, i have a problem with the following regex: REReplaceNoCase(inputxml,text[^]*(.*)\/text,) The regex should replace the tag text with all the content inside (even other tags). It works fine if only one text.../text is in the whole string. But if theres a second or a third the replace works wrong. Example String that works right: bla bla bla textbla bla bbla/bbla/text bla bla bla Example String that works false: bla bla bla textbla bla bbla/bbla/text bla bla bla textbla bla bbla/bbla/text The replace will start at the first text and does end at the very last /text at the end of the string. Does anyone have a idea how i have to optimize my expression? Greets ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any way to limit file upload size?
What about something like so. Am I way off? It checks before the image is uploaded. page_1.cfm !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 titleUntitled Document/title /head body form action=page_1.cfm method=post enctype=multipart/form-data input type=file name=test1 input type=submit name=submitThis /form cfset allowedFileSize = 1000 cfif isDefined(form.submitThis) cfoutput cfif cgi.content_length gt #Val(allowedFileSize)# Error your file is way to bigbr /cfif Your file size was: #cgi.CONTENT_LENGTH# and the allowed size was #allowedFileSize# /cfoutput /cfif /body /html Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 7:06 AM Subject: RE: Any way to limit file upload size? There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Full-Text Query Help
If you use CONTAINS, then full-text search will be used. Russ -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:31 To: CF-Talk Subject: RE: Full-Text Query Help Does nobody have an idea on this? I'm basically trying to do something like this: select * from table1, table2 where table2.id=1 and table2.somefield like '%' + table1.someotherfield + '%' This works fine, although it's a bit slow for my taste... is there a way to optimize it, using full text search of verity? Somefield is a text field, and someotherfield is a varchar. Russ -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, December 04, 2006 8:20 PM To: CF-Talk Subject: Full-Text Query Help I'm trying to do something like the following Select table1Id from table1, table2 where talbe2.tableId=1 and contains(table2.somefield, table1.someotherfield) Basically I have 2 tables that have no relationship. I want to search a single field in table2 (somefield) by using every value from the someotherfield field of the table1 table. I can't seem to get the syntax quite right. Is this even possible without looping? Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any way to limit file upload size?
As CFML runs on the server, that code will not execute until after the file has been uploaded. Russ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:39 To: CF-Talk Subject: Re: Any way to limit file upload size? What about something like so. Am I way off? It checks before the image is uploaded. page_1.cfm !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 titleUntitled Document/title /head body form action=page_1.cfm method=post enctype=multipart/form-data input type=file name=test1 input type=submit name=submitThis /form cfset allowedFileSize = 1000 cfif isDefined(form.submitThis) cfoutput cfif cgi.content_length gt #Val(allowedFileSize)# Error your file is way to bigbr /cfif Your file size was: #cgi.CONTENT_LENGTH# and the allowed size was #allowedFileSize# /cfoutput /cfif /body /html Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 7:06 AM Subject: RE: Any way to limit file upload size? There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any way to limit file upload size?
I am not sure if the content_length is available until the file is actually uploaded. I could be wrong on that though. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:39 AM To: CF-Talk Subject: Re: Any way to limit file upload size? What about something like so. Am I way off? It checks before the image is uploaded. page_1.cfm !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 titleUntitled Document/title /head body form action=page_1.cfm method=post enctype=multipart/form-data input type=file name=test1 input type=submit name=submitThis /form cfset allowedFileSize = 1000 cfif isDefined(form.submitThis) cfoutput cfif cgi.content_length gt #Val(allowedFileSize)# Error your file is way to bigbr /cfif Your file size was: #cgi.CONTENT_LENGTH# and the allowed size was #allowedFileSize# /cfoutput /cfif /body /html Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 7:06 AM Subject: RE: Any way to limit file upload size? There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
I am curious as how you can add a watermark to an image without having to create a new image. See CFX_StampImage here : http://www.contentbox.com/claude/customtags/stampImage/testStamp.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images and Watermarks?
On Tuesday 05 December 2006 15:33, Greg Luce wrote: image on each request. Just when a user uploads an image, store the original, create a thumbnail, and create a resized version for use on the site and apply a watermark to it. ImageMagic works wonderfully for that. For instance, aye. -- Tom Chiverton Helping to paradigmatically orchestrate fine-grained patterns This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: onSessionEnd function not getting called
Still not working :( I've tried including the new code such that the onsession end now looks like: cffunction name=OnSessionEnd access=public returntype=void output=true hint=Fires when the session is terminated. cfargument name=SessionScope type=struct required=true / cfargument name=ApplicationScope type=struct required=false / cfinclude template=../../../customtags/getSessionList.cfm cfif StructIsEmpty(getSessionList(Arguments.ApplicationScope.applicationname)) cfquery name=changeStatus datasource=#REQUEST.theDatabase# UPDATE companyDetails SET status = 'INTERMITTANT' WHERE companyID = cfqueryparam value=#REQUEST.companyID# cfsqltype=cf_sql_integer / /cfquery /cfif /cffunction I didn't change any other code within the file. I had a look at the adobe docs for this and it used AppScope which I also tried but still no joy. Do I need to make amendments elsewhere in the doc to get this to work? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any way to limit file upload size?
Well, if that is so, then there should not be a way of checking. Even in IIS you would have to submit the form before any checking is done. You cannot simply select the file and have something check the size of it. At least this way the file is not processed and uploaded to the server. Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 8:42 AM Subject: RE: Any way to limit file upload size? As CFML runs on the server, that code will not execute until after the file has been uploaded. Russ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:39 To: CF-Talk Subject: Re: Any way to limit file upload size? What about something like so. Am I way off? It checks before the image is uploaded. page_1.cfm !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 titleUntitled Document/title /head body form action=page_1.cfm method=post enctype=multipart/form-data input type=file name=test1 input type=submit name=submitThis /form cfset allowedFileSize = 1000 cfif isDefined(form.submitThis) cfoutput cfif cgi.content_length gt #Val(allowedFileSize)# Error your file is way to bigbr /cfif Your file size was: #cgi.CONTENT_LENGTH# and the allowed size was #allowedFileSize# /cfoutput /cfif /body /html Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 7:06 AM Subject: RE: Any way to limit file upload size? There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any way to limit file upload size?
Well, This is what I have in my image upload and it works fine. The file does not get uploaded until it passes certain checks. cfset Valid = True cfset VaildSZ = True cfset Error = cfif Not IsDefined(form.AdPhoto) or Len(form.AdPhoto) lt 3 cfset Valid = False cfset VaildSZ = False cfset Error = Error liThe Upload Photo field is required./liBR /cfif cfif cgi.content_length gt #Val(APPLICATION.ALLOWEDCLADSSIZE)# cfset Valid = False cfset VaildSZ = False cfset Error = Error liThe uploaded photo is too large. Maximum allowed size is #Val(APPLICATION.ALLOWEDCLADSSIZE)#K and yours is #cgi.content_length#K./liBR /cfif cfif VaildSZ cftry !--- UPLOAD GRAPHIC TO SERVER --- cffile action=upload filefield=AdPhoto accept=#APPLICATION.ATTACHTYPE# destination=#APPLICATION.IMAGEPATH#images-ads\cats#Val(ClassAdForPhotos.SCa tegoryID)#\ nameconflict=makeunique cfset RenamePhoto = #Val(adid)#-#DateFormat(Now(), mmdd)##TimeFormat(now(), HHmmss)#.#File.serverFileExt# cffile action=rename source=#APPLICATION.IMAGEPATH#images-ads\cats#Val(ClassAdForPhotos.SCategor yID)#\#File.ServerFile# destination=#APPLICATION.IMAGEPATH#images-ads\cats#Val(ClassAdForPhotos.SCa tegoryID)#\#Trim(RenamePhoto)# cfset AdPhoto = #Trim(RenamePhoto)# cfcatch cfset Valid = False cfset Error = Error liThe uploaded photo is not in an acceptable format. Please try again./liBR /cfcatch /cftry /cfif - Original Message - From: Ben Nadel [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 8:42 AM Subject: RE: Any way to limit file upload size? I am not sure if the content_length is available until the file is actually uploaded. I could be wrong on that though. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:39 AM To: CF-Talk Subject: Re: Any way to limit file upload size? What about something like so. Am I way off? It checks before the image is uploaded. page_1.cfm !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 titleUntitled Document/title /head body form action=page_1.cfm method=post enctype=multipart/form-data input type=file name=test1 input type=submit name=submitThis /form cfset allowedFileSize = 1000 cfif isDefined(form.submitThis) cfoutput cfif cgi.content_length gt #Val(allowedFileSize)# Error your file is way to bigbr /cfif Your file size was: #cgi.CONTENT_LENGTH# and the allowed size was #allowedFileSize# /cfoutput /cfif /body /html Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 7:06 AM Subject: RE: Any way to limit file upload size? There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: onSessionEnd function not getting called
You query might be breaking? Try removing the query and just write something to a file, something really simple like SESSION ENDED. That way at least you will know that the session ended and was not erroring out. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:41 AM To: CF-Talk Subject: Re: onSessionEnd function not getting called Still not working :( I've tried including the new code such that the onsession end now looks like: cffunction name=OnSessionEnd access=public returntype=void output=true hint=Fires when the session is terminated. cfargument name=SessionScope type=struct required=true / cfargument name=ApplicationScope type=struct required=false / cfinclude template=../../../customtags/getSessionList.cfm cfif StructIsEmpty(getSessionList(Arguments.ApplicationScope.applicationname) ) cfquery name=changeStatus datasource=#REQUEST.theDatabase# UPDATE companyDetails SET status = 'INTERMITTANT' WHERE companyID = cfqueryparam value=#REQUEST.companyID# cfsqltype=cf_sql_integer / /cfquery /cfif /cffunction I didn't change any other code within the file. I had a look at the adobe docs for this and it used AppScope which I also tried but still no joy. Do I need to make amendments elsewhere in the doc to get this to work? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262897 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any way to limit file upload size?
At least this way the file is not processed and uploaded to the server. Doug No, the file IS uploaded to the server by the web server to the temp directory. This just stops CF from moving the file from the temp directory to another directory on the server, which is all CFFILE really does. If you want to see this in action output and #form.uploadField# used in a cffile tag, and you will see that it is referencing a file in the temp directory of the web server and thus already uploaded. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Full-Text Query Help
That is true, but I can't use contains... either that or I haven't figured out the syntax for it. With contains, you can only specify a string or a variable for the keywords part. Either way I think like will be faster, since contains means a full trip to the FTS service, which slows down things a lot. Is there a way to optimize SQL server to make like faster? Russ -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:40 AM To: CF-Talk Subject: RE: Full-Text Query Help If you use CONTAINS, then full-text search will be used. Russ -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:31 To: CF-Talk Subject: RE: Full-Text Query Help Does nobody have an idea on this? I'm basically trying to do something like this: select * from table1, table2 where table2.id=1 and table2.somefield like '%' + table1.someotherfield + '%' This works fine, although it's a bit slow for my taste... is there a way to optimize it, using full text search of verity? Somefield is a text field, and someotherfield is a varchar. Russ -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, December 04, 2006 8:20 PM To: CF-Talk Subject: Full-Text Query Help I'm trying to do something like the following Select table1Id from table1, table2 where talbe2.tableId=1 and contains(table2.somefield, table1.someotherfield) Basically I have 2 tables that have no relationship. I want to search a single field in table2 (somefield) by using every value from the someotherfield field of the table1 table. I can't seem to get the syntax quite right. Is this even possible without looping? Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any way to limit file upload size?
I see what you are saying. I must have misunderstood the question entirely. I thought he was just wanting to not allow the images to get posted to the final spot on the server. But bandwidth wise as far as uploading, is that not on the client side anyway or is this for an intranet application? Doug - Original Message - From: Ian Skinner [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 8:54 AM Subject: RE: Any way to limit file upload size? At least this way the file is not processed and uploaded to the server. Doug No, the file IS uploaded to the server by the web server to the temp directory. This just stops CF from moving the file from the temp directory to another directory on the server, which is all CFFILE really does. If you want to see this in action output and #form.uploadField# used in a cffile tag, and you will see that it is referencing a file in the temp directory of the web server and thus already uploaded. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSSQL Function (Div 0)?
Both excellent solutions thanks guys, in the end I went with... isNull(m.ListPrice,0) + 0.01 This will produce slightly inacurate results but since this is a percentage calculation that gets truncated to an INT anyway the minor inacuracy caused by the extra penny doesn't matter in this case. I will however be using that function in other places, cheers. -- Jay ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: path outside webroot
Go to command prompt and type CD . And then CD / And you will se ethe difference No you won't :-) C:\WINDOWScd . C:\WINDOWScd / C:\WINDOWS I know what [.] [..] and [/] are as far as their meanings in a directory structure go... which is why I didn't get that ExpandPath('.') gave me the current directory path but ExpandPath('/') didn't give me the path of the main webroot (relative to the site). I saw the same thing in the docs Dave, but it still seems that it does something other than it should or at least something other than what anyone would want it to do even though it takes 1 option... a RELATIVE path, the docs claim the slash is read from a mapping... but, if the path returned by ExpandPath('/') was from a mapping, wouldnt a mapping for / need to exist? It doesn't. Also, if ExpandPath could read a directory from a mapping, why wouldn't something like... ExpandPath('/acoderslife') return the correct path for the mapping called '/acoderslife'. I know you might not have all the answers to this, I'm more or less thinking/talking out loud here... Apparently someone commented on the same thing at the bottom of the livedocs as well. Here are some others I dont get... GetDirectoryFromPath(.) and GetDirectoryFromPath(\) return \ no matter where they are called from. GetDirectoryFromPath(ExpandPath(.)) returns the parent directory of the directory that the command was executed from. GetDirectoryFromPath(ExpandPath(..)) returns TWO directories above the calling dir but as it is, apparently you will always need to know where you are calling any of the above from to 'dynamically' get the root of the site or you could create a template that contains: cfset request.rootpath = GetDirectoryFromPath(GetCurrentTemplatePath()) / and ALWAYS put it in the root of a site then cfinclude it anytime you want to know what the rootpath is. I know it's all somewhat moot. I have no problem setting a global configuration file and adjusting things between servers (which I dont normally have to do) everything basically sets itself in my configs based on the server but the actual directory paths are dependent on me keeping the same directory structure like I mentioned in a previous email. If my config file is not inside of a folder just off the root called '\include\', then the config file would need to change so the 'root path' is set correctly. But if ExpandPath('/') did what most people would expect it to do, that directory structure would never matter again. Oh well I suppose :-) ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.15.6/568 - Release Date: 12/4/2006 3:20 PM ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSSQL Function (Div 0)?
I have a place for the extra penny. Let me give you my bank routing number ~Brad -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:05 AM To: CF-Talk Subject: RE: MSSQL Function (Div 0)? Both excellent solutions thanks guys, in the end I went with... isNull(m.ListPrice,0) + 0.01 This will produce slightly inacurate results but since this is a percentage calculation that gets truncated to an INT anyway the minor inacuracy caused by the extra penny doesn't matter in this case. I will however be using that function in other places, cheers. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any way to limit file upload size?
IIS will read the headers first. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:49 To: CF-Talk Subject: Re: Any way to limit file upload size? Well, if that is so, then there should not be a way of checking. Even in IIS you would have to submit the form before any checking is done. You cannot simply select the file and have something check the size of it. At least this way the file is not processed and uploaded to the server. Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 8:42 AM Subject: RE: Any way to limit file upload size? As CFML runs on the server, that code will not execute until after the file has been uploaded. Russ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:39 To: CF-Talk Subject: Re: Any way to limit file upload size? What about something like so. Am I way off? It checks before the image is uploaded. page_1.cfm !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 titleUntitled Document/title /head body form action=page_1.cfm method=post enctype=multipart/form-data input type=file name=test1 input type=submit name=submitThis /form cfset allowedFileSize = 1000 cfif isDefined(form.submitThis) cfoutput cfif cgi.content_length gt #Val(allowedFileSize)# Error your file is way to bigbr /cfif Your file size was: #cgi.CONTENT_LENGTH# and the allowed size was #allowedFileSize# /cfoutput /cfif /body /html Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 7:06 AM Subject: RE: Any way to limit file upload size? There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any way to limit file upload size?
But bandwidth wise as far as uploading, is that not on the client side anyway or is this for an intranet application? Doug Yes, that is the fine point. Your code example works fine to prevent the storing of undesired files, but if one is concerned about bandwidth there is nothing that can be by CF to prevent the uploading of a file to the server. This has already been completed by the time ColdFusion become involved in the process. For this - checking would have to be done on the client side with something like JavaScript (which I do not think has the capabilities), Active X controls or Flash. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any way to limit file upload size?
If you try and upload a large file, something that would normally take a minute or 2, you will find that your code will not run until that file has fully uploaded to the server. Russ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 15:52 To: CF-Talk Subject: Re: Any way to limit file upload size? Well, This is what I have in my image upload and it works fine. The file does not get uploaded until it passes certain checks. cfset Valid = True cfset VaildSZ = True cfset Error = cfif Not IsDefined(form.AdPhoto) or Len(form.AdPhoto) lt 3 cfset Valid = False cfset VaildSZ = False cfset Error = Error liThe Upload Photo field is required./liBR /cfif cfif cgi.content_length gt #Val(APPLICATION.ALLOWEDCLADSSIZE)# cfset Valid = False cfset VaildSZ = False cfset Error = Error liThe uploaded photo is too large. Maximum allowed size is #Val(APPLICATION.ALLOWEDCLADSSIZE)#K and yours is #cgi.content_length#K./liBR /cfif cfif VaildSZ cftry !--- UPLOAD GRAPHIC TO SERVER --- cffile action=upload filefield=AdPhoto accept=#APPLICATION.ATTACHTYPE# destination=#APPLICATION.IMAGEPATH#images-ads\cats#Val(ClassAdForPhotos.SCa tegoryID)#\ nameconflict=makeunique cfset RenamePhoto = #Val(adid)#-#DateFormat(Now(), mmdd)##TimeFormat(now(), HHmmss)#.#File.serverFileExt# cffile action=rename source=#APPLICATION.IMAGEPATH#images-ads\cats#Val(ClassAdForPhotos.SCategor yID)#\#File.ServerFile# destination=#APPLICATION.IMAGEPATH#images-ads\cats#Val(ClassAdForPhotos.SCa tegoryID)#\#Trim(RenamePhoto)# cfset AdPhoto = #Trim(RenamePhoto)# cfcatch cfset Valid = False cfset Error = Error liThe uploaded photo is not in an acceptable format. Please try again./liBR /cfcatch /cftry /cfif - Original Message - From: Ben Nadel [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 8:42 AM Subject: RE: Any way to limit file upload size? I am not sure if the content_length is available until the file is actually uploaded. I could be wrong on that though. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:39 AM To: CF-Talk Subject: Re: Any way to limit file upload size? What about something like so. Am I way off? It checks before the image is uploaded. page_1.cfm !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 titleUntitled Document/title /head body form action=page_1.cfm method=post enctype=multipart/form-data input type=file name=test1 input type=submit name=submitThis /form cfset allowedFileSize = 1000 cfif isDefined(form.submitThis) cfoutput cfif cgi.content_length gt #Val(allowedFileSize)# Error your file is way to bigbr /cfif Your file size was: #cgi.CONTENT_LENGTH# and the allowed size was #allowedFileSize# /cfoutput /cfif /body /html Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 05, 2006 7:06 AM Subject: RE: Any way to limit file upload size? There is a setting in IIS to limit the size of form posts. But I can't find it for the life of me. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 13:29 To: CF-Talk Subject: Any way to limit file upload size? Hi Is there any way in CF or IIS to limit the allowed file size for a form with a file attached? I have a situation where someone might accidentally upload a huge file when all we want is a sample file. I would want to avoid not only creating a huge temp file but also all of the bandwidth needed to send the file to the server. Thanks Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: path outside webroot
I'm pretty sure the / mapping rule doesn't apply when using expand path. As I said before, with this rule, if you have a mapping called / this mapping will be used, if you do not, the relative root of your website will be used instead. Russ -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 16:11 To: CF-Talk Subject: RE: path outside webroot Go to command prompt and type CD . And then CD / And you will se ethe difference No you won't :-) C:\WINDOWScd . C:\WINDOWScd / C:\WINDOWS I know what [.] [..] and [/] are as far as their meanings in a directory structure go... which is why I didn't get that ExpandPath('.') gave me the current directory path but ExpandPath('/') didn't give me the path of the main webroot (relative to the site). I saw the same thing in the docs Dave, but it still seems that it does something other than it should or at least something other than what anyone would want it to do even though it takes 1 option... a RELATIVE path, the docs claim the slash is read from a mapping... but, if the path returned by ExpandPath('/') was from a mapping, wouldn't a mapping for / need to exist? It doesn't. Also, if ExpandPath could read a directory from a mapping, why wouldn't something like... ExpandPath('/acoderslife') return the correct path for the mapping called '/acoderslife'. I know you might not have all the answers to this, I'm more or less thinking/talking out loud here... Apparently someone commented on the same thing at the bottom of the livedocs as well. Here are some others I don't get... GetDirectoryFromPath(.) and GetDirectoryFromPath(\) return \ no matter where they are called from. GetDirectoryFromPath(ExpandPath(.)) returns the parent directory of the directory that the command was executed from. GetDirectoryFromPath(ExpandPath(..)) returns TWO directories above the calling dir .but as it is, apparently you will always need to know where you are calling any of the above from to 'dynamically' get the root of the site or you could create a template that contains: cfset request.rootpath = GetDirectoryFromPath(GetCurrentTemplatePath()) / and ALWAYS put it in the root of a site then cfinclude it anytime you want to know what the rootpath is. I know it's all somewhat moot. I have no problem setting a global configuration file and adjusting things between servers (which I don't normally have to do) everything basically sets itself in my configs based on the server but the actual directory paths are dependent on me keeping the same directory structure like I mentioned in a previous email. If my config file is not inside of a folder just off the root called '\include\', then the config file would need to change so the 'root path' is set correctly. But if ExpandPath('/') did what most people would expect it to do, that directory structure would never matter again. Oh well I suppose :-) ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.15.6/568 - Release Date: 12/4/2006 3:20 PM ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any way to limit file upload size?
It's true. ALL the files get uploaded and stored in a temp dir on the server. coldfusionmx7\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp I think. When you do the cffile, I believe you are just copying it a new location. The bandwidth is used regardless. ~Brad -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:17 AM To: CF-Talk Subject: RE: Any way to limit file upload size? If you try and upload a large file, something that would normally take a minute or 2, you will find that your code will not run until that file has fully uploaded to the server. Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flash CFGRID and Date Sorting
Is it just me or is Flash CFGRID's date sorting all screwed up? Here's my code: cfgridcolumn name=date_modified header=Date Modified type=STRING_NOCASE mask=MM/DD/YY LL:NNAA width=130 It does work -- eventually. I have to click on the heading three times -- after the third, it sorts correctly every time I click on it (ascending and descending). I have similar issues with sorting checkboxes (BOOLEAN). I just upgraded to 7.0.2, but it hasn't helped. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: path outside webroot
The wwwroot of the cf install directory is returned either way. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 11:21 AM To: CF-Talk Subject: RE: path outside webroot I'm pretty sure the / mapping rule doesn't apply when using expand path. As I said before, with this rule, if you have a mapping called / this mapping will be used, if you do not, the relative root of your website will be used instead. Russ -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 16:11 To: CF-Talk Subject: RE: path outside webroot Go to command prompt and type CD . And then CD / And you will se ethe difference No you won't :-) C:\WINDOWScd . C:\WINDOWScd / C:\WINDOWS I know what [.] [..] and [/] are as far as their meanings in a directory structure go... which is why I didn't get that ExpandPath('.') gave me the current directory path but ExpandPath('/') didn't give me the path of the main webroot (relative to the site). I saw the same thing in the docs Dave, but it still seems that it does something other than it should or at least something other than what anyone would want it to do even though it takes 1 option... a RELATIVE path, the docs claim the slash is read from a mapping... but, if the path returned by ExpandPath('/') was from a mapping, wouldn't a mapping for / need to exist? It doesn't. Also, if ExpandPath could read a directory from a mapping, why wouldn't something like... ExpandPath('/acoderslife') return the correct path for the mapping called '/acoderslife'. I know you might not have all the answers to this, I'm more or less thinking/talking out loud here... Apparently someone commented on the same thing at the bottom of the livedocs as well. Here are some others I don't get... GetDirectoryFromPath(.) and GetDirectoryFromPath(\) return \ no matter where they are called from. GetDirectoryFromPath(ExpandPath(.)) returns the parent directory of the directory that the command was executed from. GetDirectoryFromPath(ExpandPath(..)) returns TWO directories above the calling dir ..but as it is, apparently you will always need to know where you are calling any of the above from to 'dynamically' get the root of the site or you could create a template that contains: cfset request.rootpath = GetDirectoryFromPath(GetCurrentTemplatePath()) / and ALWAYS put it in the root of a site then cfinclude it anytime you want to know what the rootpath is. I know it's all somewhat moot. I have no problem setting a global configuration file and adjusting things between servers (which I don't normally have to do) everything basically sets itself in my configs based on the server but the actual directory paths are dependent on me keeping the same directory structure like I mentioned in a previous email. If my config file is not inside of a folder just off the root called '\include\', then the config file would need to change so the 'root path' is set correctly. But if ExpandPath('/') did what most people would expect it to do, that directory structure would never matter again. Oh well I suppose :-) :.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.15.6/568 - Release Date: 12/4/2006 3:20 PM ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: combining two types of JS-related validation
Hey gang, Got a bit of a stumper here. Nothing I've tried has quite done the trick. For a particular form, I've got your stereotypical email address field (named - here it comes - email). I'm using qForms, making sure that this field is required and running the validateEmail() function on it, to ensure there's content in the field and that it's structured correctly. What I've also done is, using CFAjax, rolled my own email validator code, that gets triggered by an onBlur tag on the email input field. Whenever someone clicks off that email field, it checks to see if the value is the same as it was (stored in a JS value) and if it's different since the last check, runs it through some validation and throws up an alert if there's a problem, all prior to any form submittals. The issue I'm running across is the combination of the two. I want to work it so that if the form is submitted, the JS/Ajax function does NOT get tripped, just the qForms function - OR - if I can rig the JS/Ajax to work both ways - to do its stuff via onBlur, AND to do its stuff when the form is submitted and to interrupt the submission if there's an issue, and ditch the use of qForms in this case - that would work as well. My main issue is crafting the JS/Ajax code to work different based on whether the form is submitted or not. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: onSessionEnd function not getting called
Ditto what Ben said. 9 times out of 10 the issue is an error in the method. You may also try using onError and see if it fires off. p.s. Add some var scoping to your query name. Or just remove the name. Also - you are including a template that has getSessionList? Did I see that right? You can't cfinclude a UDF inside a method. On 12/5/06, Ben Nadel [EMAIL PROTECTED] wrote: You query might be breaking? Try removing the query and just write something to a file, something really simple like SESSION ENDED. That way at least you will know that the session ended and was not erroring out. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:41 AM To: CF-Talk Subject: Re: onSessionEnd function not getting called Still not working :( I've tried including the new code such that the onsession end now looks like: cffunction name=OnSessionEnd access=public returntype=void output=true hint=Fires when the session is terminated. cfargument name=SessionScope type=struct required=true / cfargument name=ApplicationScope type=struct required=false / cfinclude template=../../../customtags/getSessionList.cfm cfif StructIsEmpty(getSessionList(Arguments.ApplicationScope.applicationname) ) cfquery name=changeStatus datasource=#REQUEST.theDatabase# UPDATE companyDetails SET status = 'INTERMITTANT' WHERE companyID = cfqueryparam value=#REQUEST.companyID# cfsqltype=cf_sql_integer / /cfquery /cfif /cffunction I didn't change any other code within the file. I had a look at the adobe docs for this and it used AppScope which I also tried but still no joy. Do I need to make amendments elsewhere in the doc to get this to work? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfform - bad hosting company
Doesn't cfform work by defualt when CFV7 is installed? Is there something in the cf admin that needs to be enabled? I sent an email to the Web hosting company saying that cfform wasn't work based on sample code from the documentation and they want me to tell them if there's something they need to enable in order to get it working. 8-) Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfform - bad hosting company
cfform works by default. maybe you can elaborate on how it's not working On 12/5/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Doesn't cfform work by defualt when CFV7 is installed? Is there something in the cf admin that needs to be enabled? I sent an email to the Web hosting company saying that cfform wasn't work based on sample code from the documentation and they want me to tell them if there's something they need to enable in order to get it working. 8-) Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform - bad hosting company
Doesn't cfform work by defualt when CFV7 is installed? Is there something in the cf admin that needs to be enabled? It does work in a default installation, but cfform does require access to parts of the CFIDE directory. Some administrators like to move, remove and|or lock down the CFIDE directory which would prevent the proper functioning of cfform and a few other elements of ColdFusion. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform - bad hosting company
They would have had to disable the tag in order for it to not be working. What error do you get when u try and use CFFORM? Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 16:50 To: CF-Talk Subject: cfform - bad hosting company Doesn't cfform work by defualt when CFV7 is installed? Is there something in the cf admin that needs to be enabled? I sent an email to the Web hosting company saying that cfform wasn't work based on sample code from the documentation and they want me to tell them if there's something they need to enable in order to get it working. 8-) Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform - bad hosting company
Chances are it can't find the cfide/scripts/ folder. ~Brad -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:50 AM To: CF-Talk Subject: cfform - bad hosting company Doesn't cfform work by defualt when CFV7 is installed? Is there something in the cf admin that needs to be enabled? I sent an email to the Web hosting company saying that cfform wasn't work based on sample code from the documentation and they want me to tell them if there's something they need to enable in order to get it working. 8-) Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform - bad hosting company
If you're using CFFORM you are probably looking for the validation routines that come with the form. They are java script and need the parameter ScriptSRC pointing to the directory where the cfform scripts are kept. Example: cfform method=post action=myaction.cfm ScriptSRC=mypath/cfform.js Contact the hosting company and ask where they are keeping cfform.js and masks.js and point there in scriptsrc or find them in your CFLIB and put them in a location on your own site. That should do it... Robert Harrison -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 11:50 AM To: CF-Talk Subject: cfform - bad hosting company Doesn't cfform work by defualt when CFV7 is installed? Is there something in the cf admin that needs to be enabled? I sent an email to the Web hosting company saying that cfform wasn't work based on sample code from the documentation and they want me to tell them if there's something they need to enable in order to get it working. 8-) Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262918 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 Query Timeout
Has anyone ever experienced a query of query timeout? I have a Query of Query that I am running against a result set that has several thousand records in it (no more than 8,192). From time to time (more often than not) the page fails on a 'The request has exceeded the allowable time limit Tag: CFQUERY' error. This is a Q of Q that is basically filtering out some records in the original result set. It uses a LIKE search (which I know is a no-no on databases, but haven't had trouble before on QofQ's). Any thoughts? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sftp plugin for eclipse?
On 12/5/06 9:44 AM, Damien McKenna wrote: Does anyone know of an SFTP plugin for eclipse In a very obvious GFS (Google First, Silly) move, I found it myself. http://www.jcraft.com/eclipse-sftp/ -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262920 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 Query Timeout
I've seen that same error quite a few times but I only get it in emails sent by error handling templates. I've never been able to recreate it myself. When I get 1 though, I get many right behind it. It's as if the server just had gas for a second then let out a big one. Everything goes right back to normal before I can catch it. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 10:57 AM To: CF-Talk Subject: Query of Query Timeout Has anyone ever experienced a query of query timeout? I have a Query of Query that I am running against a result set that has several thousand records in it (no more than 8,192). From time to time (more often than not) the page fails on a 'The request has exceeded the allowable time limit Tag: CFQUERY' error. This is a Q of Q that is basically filtering out some records in the original result set. It uses a LIKE search (which I know is a no-no on databases, but haven't had trouble before on QofQ's). Any thoughts? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sftp plugin for eclipse?
Aptana also can connect to SFTP sites. Man, do I love me some Aptana. -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 12:10 PM To: CF-Talk Subject: Re: Sftp plugin for eclipse? On 12/5/06 9:44 AM, Damien McKenna wrote: Does anyone know of an SFTP plugin for eclipse In a very obvious GFS (Google First, Silly) move, I found it myself. http://www.jcraft.com/eclipse-sftp/ -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262922 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 Query Timeout
The amount of time that ColdFusion will allow for a tag to complete is a setting in the administrator that defaults to 60 seconds. You can bump this up if required. Alternately you can replace your QofQ with potentially better performing logic. At a conference a couple of months ago, a CF engineer pointed out that CF is NOT a database management system and it will never be as efficient as an enterprise DBMS at query parsing and processing. He suggested, if one is working with large record sets, to either pass the heavy lifting back to the DBMS to have it return the desired results or turn the large record set into a structure and do any desired filtering and processing on the structure. ColdFusion is much more efficient at working with structures. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SPRY and CFAJAX conflict
Go to: http://script.aculo.us/ and get the whole package. The prototype main site only has v1.40. Scriptaculous uses 1.50. Rey Chad McCue wrote: Anyone know where I can download ProtoType 1.5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:51 AM To: CF-Talk Subject: Re: SPRY and CFAJAX conflict Are you using the latest version of Spry? I know they had some conflicts with prototype, but I thought they had fixed or minimized that in later releases. As far as I remember, you still need Prototype 1.5. Any previous version of Prototype break the ability to run a simple for in loop causing this kind of conflicts with many other libraries. Massimo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query of Query Timeout
It would be an array of strutures. Each array being one row, and containing a struture key for each column Russ -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 17:30 To: CF-Talk Subject: RE: Query of Query Timeout Interesting. In this case, the query result is actually coming from a CFSEARCH, so I'm not even getting it from the DBMS. How would that work converting the query into a structure? Is that basically an array of structures or a structure of arrays? Or a structure of structures? Dave -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 11:20 AM To: CF-Talk Subject: RE: Query of Query Timeout The amount of time that ColdFusion will allow for a tag to complete is a setting in the administrator that defaults to 60 seconds. You can bump this up if required. Alternately you can replace your QofQ with potentially better performing logic. At a conference a couple of months ago, a CF engineer pointed out that CF is NOT a database management system and it will never be as efficient as an enterprise DBMS at query parsing and processing. He suggested, if one is working with large record sets, to either pass the heavy lifting back to the DBMS to have it return the desired results or turn the large record set into a structure and do any desired filtering and processing on the structure. ColdFusion is much more efficient at working with structures. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query of Query Timeout
Is that basically an array of structures or a structure of arrays? Or a structure of structures? Any of the above, you would just output the query into a structure of your design and then use that structure for future filtering and processing. This is apparently one of those 9 out of 10 kind of thing where a well designed structure is usually better performing then running QofQ's on a record set. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
oo application
Does anyone know of an application that I could look at that uses 1.)beans 2.)dao's 3.)gateways 4.)coldspring So I can see how all of them tie together. -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with lists and arrays: WAS list / array problems, scheduling problem
I'm having a hell of a time building an employee scheduling calendar. The problem must be in my understanding of lists and arrays. I can put data into the lists/arrays, but pulling them out and displaying it correctly - now that's another story. Building the calendar was easy. - Employer has several locations, employees may work at more than one location. - There will usually be more than one employee per location. - Employer is looking for a scheduling calendar that can show the month and list the employees per location in the day slots and then get more and more granular. I have the granular aspects done. Example: employee A is working at store 1 for a series of days and at store 2 for another series of days. I'm having trouble displaying the general monthly view where there are multiple employees and multiple locations. The calendar itself works well but I have problems culling the information from the arrays and have gone around in circles and tied myself into knots. DATABASE tlbSCHEDULE scheduleID employeeID storeID scheduleMonth scheduleDay scheduleHour // if 99 show the day as covered. If the data is scheduleID --- employeeID --- storeID --- scheduleMonth --- scheduleDay --- scheduleHour 1- 1--1 -- 12-- 1 -- 99 2-- 1--- 1 --- 12-- 2 --- 99 3-- 2-- 1 12-- 2 --- 99 4--21 12 3 -- 99 5--3-- 1 12--- 3 99 The employeeID should be in the correct day along with the storeID. (Example 1/1: Employee 1 and Store 1 ) (In the live product it would have the first and last name pulled from the employee table and it would be color coded with little boxes under the name distinguishing hours, etc. It looks great now if only I can get it to work. :-] ) DECEMBER ---1-234- + -- + -- + -- + -- + |1/1 |1/1 | 2/1 | | | |2/1 | 3/1 | | | || | | + -- + -- + -- + -- + Instead I get results such all employees listed for each day one of them works. ---1-234- + -- + -- + -- + -- + |1/1 |1/1 | 1/1 | | |2/1 |2/1 | 2/1 | | |3/1 | 3/1 | 3/1 | | + -- + -- + -- + -- + Thanks, hope I made myself clear. -- gil ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query of Query Timeout
It sounds like getting a stack trace during execution might help you prove what the offending line of code is. I know I've sung this song a lot, but SeeFusion is an excellent resource for this and I love it. www.seefusion.com ~Brad -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 11:05 AM To: CF-Talk Subject: Re: Query of Query Timeout Here's another question. I added a cfoutput#getTickCount()#/cfoutputbr line directly after my CFSEARCH tag (and before my QofQ) and now the timeout is happening on that CFOUTPUT tag. Taht seems very strange. It is almost as if the CFSEARCH tag is the one timing out, but CF is reporting it on the next available tag. Is it possible that if the CFSEARCH takes longer than the 60 second limit, that as soon as Verity has returned handling to CF, the request then terminates because it has exceeded the 60 seconds? If so, what accounts for the fact that some searches actually finish and report in the server log as taking longer than the 60 seconds? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfform - bad hosting company
Yes I'm talking about the form validation. On my localhost install, it worked without knowinig where the these scripts are located. I'm guessing because we're on a shared server, that you have to ppoint to these scripts. Thanks. That gives me the lead I was looking for. D If you're using CFFORM you are probably looking for the validation routines that come with the form. They are java script and need the parameter ScriptSRC pointing to the directory where the cfform scripts are kept. Example: cfform method=post action=myaction.cfm ScriptSRC=mypath/cfform.js Contact the hosting company and ask where they are keeping cfform.js and masks.js and point there in scriptsrc or find them in your CFLIB and put them in a location on your own site. That should do it... Robert Harrison -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 11:50 AM To: CF-Talk Subject: cfform - bad hosting company Doesn't cfform work by defualt when CFV7 is installed? Is there something in the cf admin that needs to be enabled? I sent an email to the Web hosting company saying that cfform wasn't work based on sample code from the documentation and they want me to tell them if there's something they need to enable in order to get it working. 8-) Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFSEARCH hanging
I had this originally under another subject because I thought the problem was something else, but I have determined that the problem is that my CFSEARCH is not returning results. I have a very large collection (it is nearly 3 gigabytes on the disk) and any search I try to do on the collection times out. Here is my CFSEARCH line: cfsearch collection=sMyCollection name=getAllResults criteria=#UCase(url.criteria)# maxrows=1 Yes, even with maxrows=1 my search still times out. I originally had maxrows=8192. FYI - I am running on MX 6.1 Enterprise (cannot upgrade at this time). I need a solution to this! Is the collection too large? According to MX documentation, the Verity engine bundled with MX Enterprise should handle 250,000 documents. Any suggestions? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSSQL Function (Div 0)?
Both excellent solutions thanks guys, in the end I went with... isNull(m.ListPrice,0) + 0.01 Most people don't care, but I always have to point out that isNull is a proprietary Microsoft function, while Coalesce() is ANSI standard and has the same basic syntax. EMF idahopower.com made the following annotations. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(Admin) Fusion Authority Quarterly Update issue 2 shipped
The Fusion Authority Quarterly Update issue 2 (FAQU 2) is here and has been shipped to subscribers. This issue is dedicated to Object Oriented Programming (OOP) in ColdFusion and ColdFusion frameworks. It doesn't matter what lever developer you are, the issue has something for you. I'm particularly proud of my article which will take you from knowing nothing about User Defined Functions (UDFs) and move you up to knowing almost everything about them as well as ColdFusion Components (CFCs). To order this issue, subscribe, and/or order the first issue (ColdFusion MX 7 features you need to know), visit: http://www.fusionauthority.com/quarterly/ Table of Contents Editorial OOP in Your Toolbox by Judith Dinowitz Columns What's Hot? What's Not? by Raymond Camden, Simeon Bateman, Charlie Arehart, Kurt Wiersma, Michael Dinowitz Tipical Charlie - How do I Call Thee (CFC)? Let Me Count the Ways! by Charlie Arehart Features Object-Oriented Programming: Why Bother? by Brian Kotek The Object-Oriented Lexicon by Hal Helms Design Pattern Safari by Peter J. Farrell From User-Defined Functions to ColdFusion Components by Michael Dinowitz Base Classes: Better Than You Knew! by Peter Bell Concepts Introduction to Frameworks by Jared Rypka-Hauer Fusebox 5 Fundamentals by Sean Corfield Mach-II Fundamentals by Matt Woodward Model-Glue Fundamentals by Joe Rinehart Lessons I Learned from My First Model-Glue Application by Jeffry Houser ColdSpring Fundamentals by Chris Scott Reactor Fundamentals by Doug Hughes Tools FusionDebug Explained: Interactive Step Debugging for CFML by Charlie Arehart Michael Dinowitz President: House of Fusion http://www.houseoffusion.com Publisher: Fusion Authority http://www.fusionauthority.com Adobe Community Expert ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sftp plugin for eclipse?
Aptana also can connect to SFTP sites. Man, do I love me some Aptana. Me too. :) EMF idahopower.com made the following annotations. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any way to limit file upload size?
Doug Brown wrote: What about something like so. Am I way off? It checks before the image is uploaded. No amount of CFML code can prevent the BANDWIDTH from being used, because the CFML code in your .cfm page doesn't get executed until *AFTER* the web server receives the complete request headers and the request body (ie, the form post). *THEN* the CFML starts to execute. If the goal is to prevent the bandwidth use then you have to have the web server SEVER the connection when the post data reaches a certain point. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any way to limit file upload size?
Snake wrote: If you try and upload a large file, something that would normally take a minute or 2, you will find that your code will not run until that file has fully uploaded to the server. Snake is absolutely right. CFFILE doesn't actually perform the upload. the web server puts the form post in memory, and all CFFILE does is copy it from memory to the file system in a place that you specify. By the time CFFILE runs (or any CFML code) the whole file has already been uploaded. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
unit test custom tags?
Hi, Is there a way to do unit test custom tags? Johnny Open-Source CfTagLib http://code.google.com/p/cfttaglib/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Finding Java invocations (createObject) in CFML code at Java comp ile time in Eclipse.
Hey all! I'm looking for input or advice on a problem we're seeing develop. We have a large quantity of java code which we invoke in CF through createObject. Some of this is in CFC's, some in CFM templates, and it's been done over the course of a few years, so there's a variable methodology in how it's done. We are currently going through and cleaning up/refactoring the java code, and we're having a hard time determining if we're going to break anything in the CFML when we do it. What I'm looking/hoping for is some way of checking the CFML code when the java code compiles in eclipse. Then, any method signatures or anything that might have been changed/refactored are flagged and the developer is warned. Does anybody have any advice on how to go about doing this? I've thought about scripts that run at compile time that go and grep our CFML repositories and look for the createObject calls, and try to find method signatures after that. Many of the developers don't have CFMX installed on their workstations, and some have no access to our environment data, so it would have to be something that didn't require running the CFML through a CF server. I've got to believe that other people out there are having similar challenges. Thanks in advance! Edward Smith Internet Broadcasting. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4