Transposed Dates - Second Request
No hair left... Recap: 1. Main website hosted in Guernsey - (small island off the coast of France). 2. Using webservices to read/write to a HostMySite database in the US 3. Couple of forms with date entry (three fields day, month, year) and then using createdate to put them together before saving. When dates are entered into the Guernsey forms, they're getting transformed before being saved: 04/20/1965 becomes 04/19/1965 It doesn't do it *all* the time - only *most* of the time. I discovered this after writing a function to take the dates and *add* a day before saving - which then saved as what was entered into the form. Except, something it saves as the correct date, and sometime one day in the future. I can find NOTHING to cause this - except it *has* to do with the time difference between Guernsey and wherever the HostMySite server is. I say *has to*, because I simply can't think of anything else. Since I don't know why it's happening, have ZERO ideas for a solution. Anybody? Help! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Transposed Dates - Second Request
Just a guess, but Guernsey is about 7 hours in the future (HMS in is EST time zone). That means that entries during 7 hours of the day would be a day behind. You will need to account for this and add a day during those 7 hours only. HTH, -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert Les Mizzell wrote: No hair left... Recap: 1. Main website hosted in Guernsey - (small island off the coast of France). 2. Using webservices to read/write to a HostMySite database in the US 3. Couple of forms with date entry (three fields day, month, year) and then using createdate to put them together before saving. When dates are entered into the Guernsey forms, they're getting transformed before being saved: 04/20/1965 becomes 04/19/1965 It doesn't do it *all* the time - only *most* of the time. I discovered this after writing a function to take the dates and *add* a day before saving - which then saved as what was entered into the form. Except, something it saves as the correct date, and sometime one day in the future. I can find NOTHING to cause this - except it *has* to do with the time difference between Guernsey and wherever the HostMySite server is. I say *has to*, because I simply can't think of anything else. Since I don't know why it's happening, have ZERO ideas for a solution. Anybody? Help! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: xmlParse
Thank you for your replies, the xml is from an external source however i have some control over the formatting and will see if we can do the CDATA. Thank you ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Transposed Dates - Second Request
What is the code that you are using to generate the dates? If you are using a server function for it then all dates should be generated based on the date of the server. If you are sending the date via the form, then it will depend on how the date is generated... javascript? William -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Have you ever read a book that changed your life? Go to: a href=www.winninginthemargins.comwww.winninginthemargins.com/a Use PassKey: GoldenGrove You'll be glad you did. ::-Original Message- ::From: Les Mizzell [mailto:[EMAIL PROTECTED] ::Sent: Monday, April 14, 2008 11:14 PM ::To: CF-Talk ::Subject: Transposed Dates - Second Request :: ::No hair left... :: ::Recap: :: ::1. Main website hosted in Guernsey - (small island off the coast ::of France). :: ::2. Using webservices to read/write to a HostMySite database ::in the US :: ::3. Couple of forms with date entry (three fields day, month, year) ::and then using createdate to put them together before saving. :: :: ::When dates are entered into the Guernsey forms, they're getting ::transformed before being saved: :: ::04/20/1965 becomes 04/19/1965 :: ::It doesn't do it *all* the time - only *most* of the time. I discovered ::this after writing a function to take the dates and *add* a day before ::saving - which then saved as what was entered into the form. Except, ::something it saves as the correct date, and sometime one day in the ::future. :: ::I can find NOTHING to cause this - except it *has* to do with the time ::difference between Guernsey and wherever the HostMySite server is. I say ::*has to*, because I simply can't think of anything else. :: ::Since I don't know why it's happening, have ZERO ideas for a solution. :: ::Anybody? Help! :: :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What...
It's as if all of my messages to all of the hof lists have suddenly been resent. Sorry for the 'spamish' issue. -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com http://william.seiter.com Have you ever read a book that changed your life? Go to: a href= http://www.winninginthemargins.com/ www.winninginthemargins.com http://www.winninginthemargins.com/ www.winninginthemargins.com/a Use PassKey: GoldenGrove You'll be glad you did. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using addSOAPResponseHeader fails generation of WSDL
Hi I am working on a web service exposed for use in an .Net application. ..Net guys are telling me that they can not send just any header to me in their request to the WS. Any soap-header must be defined in the WSDL. If it were a .net web service they would have used a line similar to this: [SoapHeader (Credentials)] In ColdFusion, I believe (which may not be the case) we have addSOAPResponseHeader method to achieve the same result. When I use it I can access the page directly MyService.cfc but it throws error while viewing the wsdl MyService.cfc?wsdl. :( = AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.NullPointerException : null] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.NullPointerException : null] faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}hostname:WI040 === Here's my code: cfscript if(IsSOAPRequest()) { // this.soapResponseHeaderXml = XmlParse('IDSResponseHeaderApplicationID/ApplicationIDSignature/Signature/IDSResponseHeader'); AddSOAPResponseHeader(http://www.ids.com/IntouchDataService/;, ApplicationID, , false); AddSOAPResponseHeader(http://www.ids.com/IntouchDataService/;, Signature, , false); } /cfscript I have also tried giving default values, as well as using the XML. Thanks Sameer Gupta ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using addSOAPResponseHeader fails generation of WSDL
I am working on a web service exposed for use in an .Net application. ..Net guys are telling me that they can not send just any header to me in their request to the WS. Any soap-header must be defined in the WSDL. If it were a .net web service they would have used a line similar to this: [SoapHeader (Credentials)] In ColdFusion, I believe (which may not be the case) we have addSOAPResponseHeader method to achieve the same result. When I use it I can access the page directly MyService.cfc but it throws error while viewing the wsdl MyService.cfc?wsdl. :( Can you post the entire code of your CFC method? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Transposed Dates - Second Request [heur SPAMTRAP]
Les Mizzell wrote: 1. Main website hosted in Guernsey - (small island off the coast of France). what locale (just in case you're having date part order problems too) what timezone for this server? output from this will do: thisLocale=getLocale(); tz=createObject(java,java.util.TimeZone).getDefault(); tzName=tz.getDisplayName(true,tz.LONG); writeoutput(locale: #thisLocale#brtz:#tzName#); When dates are entered into the Guernsey forms, they're getting transformed before being saved: ?? where are they being saved? where is this happening? I can find NOTHING to cause this - except it *has* to do with the time difference between Guernsey and wherever the HostMySite server is. I say *has to*, because I simply can't think of anything else. as well as maybe DST differences between servers' tz of course timezone hell. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: whats the best way of doing this
SELECT ct.* FROM tbl_clients cl INNER JOIN tbl_clientConsultants cc ON cc.clientId = cl.clientId INNER JOIN tbl_consultants ct ON ct.consultantId = cc.consultantId Where cl.active = 1 Woops, that's slightly out, that will get all consultants that are assigned to active clients - but hopefully you get the jist and will be able to mold that to your needs. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: whats the best way of doing this
Can't really help without more information... How are you storing consultantid in the tbl_clients table, specifically for when you have added multiples? I suspect what you really need here is a many-to-many relationship for which you will need a linking table in between your current two. -- Jay On Tue, Apr 15, 2008 at 10:11 AM, Toby King [EMAIL PROTECTED] wrote: Hi there I have an application almost complete and I'm stuck on this last part. In summary the application has been developed to allocate consultant in a management consulting company to different client jobs. i.e. I can add Consultant A to job 1 (this is being done already without any troubl). I was requested then to allow for more than 1 consultant to be allocated to a client job (this is also done - I have a drop down list where by a user can make multiple selections). In the client/job file I have a information in this table. I have a clientid, clientjobid and also staffid fields etc. If I have only added one staff member everything is OK. Where I have added more than 1 staff members I am coming unstuck. I have a query SELECT * FROM tbl_clients cl, tbl_consultants ct Where cl.active = 1 AND ct.consultantid = cl.consultantid Basically the problem that I have got is that because there is more than one id in the consultantid field I am not picking up the record. Just wondering if there is a better way to do this or what people recommend. Thanks in advance. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
whats the best way of doing this
Hi there I have an application almost complete and I'm stuck on this last part. In summary the application has been developed to allocate consultant in a management consulting company to different client jobs. i.e. I can add Consultant A to job 1 (this is being done already without any troubl). I was requested then to allow for more than 1 consultant to be allocated to a client job (this is also done - I have a drop down list where by a user can make multiple selections). In the client/job file I have a information in this table. I have a clientid, clientjobid and also staffid fields etc. If I have only added one staff member everything is OK. Where I have added more than 1 staff members I am coming unstuck. I have a query SELECT * FROM tbl_clients cl, tbl_consultants ct Where cl.active = 1 AND ct.consultantid = cl.consultantid Basically the problem that I have got is that because there is more than one id in the consultantid field I am not picking up the record. Just wondering if there is a better way to do this or what people recommend. Thanks in advance. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: whats the best way of doing this
You need a third table to setup the many to many relationship between clients and consultants. A quick summary of the tables will look like this: tbl_consultant - PK consultantId tbl_client -- PK clientId tbl_clientConsultants -- PK clientConsultantId FK consultantId FK clientId + unique constraint/index on consultantId clientId Then the SQL to select all of a client's constultants could look like this: SELECT ct.* FROM tbl_clients cl INNER JOIN tbl_clientConsultants cc ON cc.clientId = cl.clientId INNER JOIN tbl_consultants ct ON ct.consultantId = cc.consultantId Where cl.active = 1 HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Transposed Dates - Second Request
With regards to the issue you describe, it certainly looks like a time zone issue that should be able to be sorted using a time zone offset being applied to the dates. Storing all dates relative to GMT is probably best. Having said all that, I would be concerned that you may have a more serious underlying date/time issue that you will need to test given that you are having time zone issues, it's worth testing this second scenario too... The SQL server in the US is most likely to have its date format as mm/dd/ and the CF server in Guernsey is most likely to have the date format of dd/mm/. The DB drivers can resolve this issue for dates over the 12th of the month 13/12/2008 and 12/13/2008 can only be one date but for dates up to the 12th of the month there can be issues... e.g. 07/12/2008 and 12/07/2008 could be two completely different dates or the same date depending on where you are in the world. To get around this second issue, you can either set your locales to the same *OR* do some sort of conversion before you send to the database or format the date in an unambiguous way e.g. dd/mmm/. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using addSOAPResponseHeader fails generation of WSDL
I am working on a web service exposed for use in an .Net application. Can you post the entire code of your CFC method? I have tried this piece of code just inside cfcomponent as well as have tried placing it inside a CFC method. cfscript if(IsSOAPRequest()) { AddSOAPResponseHeader(http://www.ids.com/IDS/;, ApplicationID, , false); AddSOAPResponseHeader(http://www.ids.com/IDS/;, Signature, , false); } /cfscript Here's the complete code: cfcomponent displayname=IDS namespace=http://www.ids.com/IDS/; access=remote bindingname=IDS cfprocessingdirective pageencoding = utf-8 / cfsetting showdebugoutput=no enablecfoutputonly=yes / cffunction name=getApplicationName access=remote returntype=string output=no cfreturn Application.$APPLICATION_NAME / /cffunction cffunction name=getWhatsNew access=remote returntype=string cfargument name=sUserLdapAlias type=string required=yes displayname=User LDAP / cfset var iBusinessId = 0 / cfset var iSegmentId = 0 / cfscript if(IsSOAPRequest()) { AddSOAPResponseHeader(http://www.ids.com/IDS/;, ApplicationID, , false); AddSOAPResponseHeader(http://www.ids.com/IDS/;, Signature, , false); } /cfscript /cffunction /cfcomponent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Transposed Dates - Second Request
William Seiter wrote: What is the code that you are using to generate the dates? On the Guernsey side: WSdepDATE=#form.depMONTH#/#form.depDAY#/#form.depYEAR# On the HostMySite side (webservice): departDATE = cfqueryparam value=#WSdepDATE# cfsqltype=CF_SQL_DATE null=false / ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfscript loop versus cfloop
I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Restricting page access if not from cf8 interface
On Monday 14 Apr 2008, Michael Brennan-White wrote: I have a cfpod in the main layout bound to links.cfm. Is there code I can place in links.cfm which will redirect the user to index.cfm unless the page is being viewed through the cfpod. Nothing bullet proof springs to mind. You could check the referer but that might not be present, you could look for an URL value you append in the cfpod, but again, a user could just do that themselves. -- Tom Chiverton Helping to biannually reintermediate proactive meta-services on: http://thefalken.livejournal.com 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. 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 Solicitors Regulation Authority. 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 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript loop versus cfloop
I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? Not quite, the cfscript loop should look like this: for (i=1; i LTE qNav.recordCount; i=i+1) { . } Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: deleting all files in a directory with code
Glad I could help... -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 5:29 PM To: CF-Talk Subject: Re: deleting all files in a directory with code that worked fine, thanks che Try the cfdirectory tag to get the files and cffile to delete them. hi is there a way to delete all files in a directory through code, tag or function thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript loop versus cfloop
you need to declare i via the script approach. cfloop does a basic declaration for you. the for loop does not. NOTE: if this loop is within a cffunction then ensure you have scoped i correctly (place var i = 1 above the loop) or (i = 1; i LTE qNav.recordCount; i=i+1) { . } -Pat http://patweb99.avatu.com On Tue, Apr 15, 2008 at 6:08 AM, Jason Durham [EMAIL PROTECTED] wrote: I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: deleting all files in a directory with code
look at cfdirectory On Mon, Apr 14, 2008 at 1:47 PM, Richard White [EMAIL PROTECTED] wrote: hi is there a way to delete all files in a directory through code, tag or function thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript loop versus cfloop
Thank you Dominic and Patrick for your suggestions. In both cases, i is var scoped just before the loops. The version with cfloop is the one that's giving me trouble. Perhaps it's not in the loop syntax. I've gone character by character comparing the rest of the code in each function and they appear identical. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:18 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop you need to declare i via the script approach. cfloop does a basic declaration for you. the for loop does not. NOTE: if this loop is within a cffunction then ensure you have scoped i correctly (place var i = 1 above the loop) or (i = 1; i LTE qNav.recordCount; i=i+1) { . } -Pat http://patweb99.avatu.com On Tue, Apr 15, 2008 at 6:08 AM, Jason Durham [EMAIL PROTECTED] wrote: I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript loop versus cfloop
The version with cfloop is the one that's giving me trouble. Is that an 'L' for the cfloop index or an uppercase 'i'? Other than that I'd say we'd need to see more (nothing wrong with the cfloop or scripted loop if i is set before it). Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript loop versus cfloop
The syntax looks correct, what is the error you are getting? On Tue, Apr 15, 2008 at 6:22 AM, Jason Durham [EMAIL PROTECTED] wrote: Thank you Dominic and Patrick for your suggestions. In both cases, i is var scoped just before the loops. The version with cfloop is the one that's giving me trouble. Perhaps it's not in the loop syntax. I've gone character by character comparing the rest of the code in each function and they appear identical. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:18 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop you need to declare i via the script approach. cfloop does a basic declaration for you. the for loop does not. NOTE: if this loop is within a cffunction then ensure you have scoped i correctly (place var i = 1 above the loop) or (i = 1; i LTE qNav.recordCount; i=i+1) { . } -Pat http://patweb99.avatu.com On Tue, Apr 15, 2008 at 6:08 AM, Jason Durham [EMAIL PROTECTED] wrote: I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfscript loop versus cfloop
Provided that i is set to 1 before the for loop (var i = 1;), then yes, the loops are identical ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 9:08 AM To: CF-Talk Subject: cfscript loop versus cfloop I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript loop versus cfloop
just an observation but the index in the cfloop doesnt look like an 'i' my eyes may be playing me up though!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript loop versus cfloop
I thought that too, but after copying the code from the thread and pasting it into my local environment showed it is being a capital i. On Tue, Apr 15, 2008 at 6:32 AM, Richard White [EMAIL PROTECTED] wrote: just an observation but the index in the cfloop doesnt look like an 'i' my eyes may be playing me up though!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript loop versus cfloop
I would check to see what the argument value for CHILDID is prior to using getDepth and make sure it is numeric. Your answer might be there. I believe the variable you want to verify is qNav[getChildOfField()][i]. On Tue, Apr 15, 2008 at 6:39 AM, Jason Durham [EMAIL PROTECTED] wrote: The variable used in the cfloop is an i, Outlook changed the case of it automagically. Here is a copy of the function using cfscript syntax that works flawlessly (written by Matt Quackenbush)... http://cfm.pastebin.com/d7595c18e Here is a copy of my re-write using cfloop... http://cfm.pastebin.com/m24328359 The error the cfloop version results in The CHILDID argument passed to the getDepth function is not of type numeric. I've verified that the function works for several iterations but fails on the 4th or 5th time through. They are both using the same external methods [getDepth(),getParent(),getSubs()]. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:30 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop The syntax looks correct, what is the error you are getting? On Tue, Apr 15, 2008 at 6:22 AM, Jason Durham [EMAIL PROTECTED] wrote: Thank you Dominic and Patrick for your suggestions. In both cases, i is var scoped just before the loops. The version with cfloop is the one that's giving me trouble. Perhaps it's not in the loop syntax. I've gone character by character comparing the rest of the code in each function and they appear identical. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:18 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop you need to declare i via the script approach. cfloop does a basic declaration for you. the for loop does not. NOTE: if this loop is within a cffunction then ensure you have scoped i correctly (place var i = 1 above the loop) or (i = 1; i LTE qNav.recordCount; i=i+1) { . } -Pat http://patweb99.avatu.com On Tue, Apr 15, 2008 at 6:08 AM, Jason Durham [EMAIL PROTECTED] wrote: I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfscript loop versus cfloop
I'll have to check again to be 100% sure, but I believe the value is . -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:45 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop I would check to see what the argument value for CHILDID is prior to using getDepth and make sure it is numeric. Your answer might be there. I believe the variable you want to verify is qNav[getChildOfField()][i]. On Tue, Apr 15, 2008 at 6:39 AM, Jason Durham [EMAIL PROTECTED] wrote: The variable used in the cfloop is an i, Outlook changed the case of it automagically. Here is a copy of the function using cfscript syntax that works flawlessly (written by Matt Quackenbush)... http://cfm.pastebin.com/d7595c18e Here is a copy of my re-write using cfloop... http://cfm.pastebin.com/m24328359 The error the cfloop version results in The CHILDID argument passed to the getDepth function is not of type numeric. I've verified that the function works for several iterations but fails on the 4th or 5th time through. They are both using the same external methods [getDepth(),getParent(),getSubs()]. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:30 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop The syntax looks correct, what is the error you are getting? On Tue, Apr 15, 2008 at 6:22 AM, Jason Durham [EMAIL PROTECTED] wrote: Thank you Dominic and Patrick for your suggestions. In both cases, i is var scoped just before the loops. The version with cfloop is the one that's giving me trouble. Perhaps it's not in the loop syntax. I've gone character by character comparing the rest of the code in each function and they appear identical. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:18 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop you need to declare i via the script approach. cfloop does a basic declaration for you. the for loop does not. NOTE: if this loop is within a cffunction then ensure you have scoped i correctly (place var i = 1 above the loop) or (i = 1; i LTE qNav.recordCount; i=i+1) { . } -Pat http://patweb99.avatu.com On Tue, Apr 15, 2008 at 6:08 AM, Jason Durham [EMAIL PROTECTED] wrote: I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript loop versus cfloop
Could it be that qNav is not var scoped? i.e. cfset qNav = getSubs(ARGUMENTS.ParentID) / If this a recursive function, that should break it. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query2excel
Hi, i downloaded a cfx called query2excel and just wondering if either anyone else has used it and has come up with the same error, or whether i am doing something fundamentally wrong in coldfusion to get the following error: the code i am using is as follows: cfx_query2excel query=finalQuery templateFile=#expandPath('.')#\template_query_results.xls outputFile=#expandPath('.')#\Excel_Downloads\#filePath# startRow=1 maxRows=#finalQuery.recordcount+1# columnHeaderRow=1 appendOverwrites=true the error is on the maxrows attribute, it tells me that it must be numeric (maxRows=#finalQuery.recordcount+1#) however if i take out the +1 then it accepts it fine. i have even tried to setting variable to the recordcount + 1 then using that variable. it essentially works fine until i try to add 1 to it, no matter what way i try to add the 1. am i missing something simple or is there a bug with this cfx? thanks very much ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript loop versus cfloop
That was it!! Thanks a bunch! -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:50 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop Could it be that qNav is not var scoped? i.e. cfset qNav = getSubs(ARGUMENTS.ParentID) / If this a recursive function, that should break it. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cffile ZIP mime type problem
I created an empty text file, zipped it with Windows XP's compression utility and attempted to run it through a form which uses cffile. I've also tried 3 other zip files from various sources (not sure of the compression utility used). As you can see from the error below, I specified application/zip and application/x-zip-compressed. Is that correct? Is that all I need? __ The MIME type of the uploaded file application/unknown was not accepted by the server. Only files of type application/vnd.ms-excel,application/msword,application/pdf,application/ zip,application/x-zip-compressed can be uploaded. Verify that you are uploading a file of the appropriate type. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript loop versus cfloop
That was it!! Thanks a bunch! Hoorah! No worries ;) D -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript loop versus cfloop
Oh good catch Dominic! On Tue, Apr 15, 2008 at 6:50 AM, Dominic Watson [EMAIL PROTECTED] wrote: Could it be that qNav is not var scoped? i.e. cfset qNav = getSubs(ARGUMENTS.ParentID) / If this a recursive function, that should break it. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript loop versus cfloop
The variable used in the cfloop is an i, Outlook changed the case of it automagically. Here is a copy of the function using cfscript syntax that works flawlessly (written by Matt Quackenbush)... http://cfm.pastebin.com/d7595c18e Here is a copy of my re-write using cfloop... http://cfm.pastebin.com/m24328359 The error the cfloop version results in The CHILDID argument passed to the getDepth function is not of type numeric. I've verified that the function works for several iterations but fails on the 4th or 5th time through. They are both using the same external methods [getDepth(),getParent(),getSubs()]. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:30 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop The syntax looks correct, what is the error you are getting? On Tue, Apr 15, 2008 at 6:22 AM, Jason Durham [EMAIL PROTECTED] wrote: Thank you Dominic and Patrick for your suggestions. In both cases, i is var scoped just before the loops. The version with cfloop is the one that's giving me trouble. Perhaps it's not in the loop syntax. I've gone character by character comparing the rest of the code in each function and they appear identical. -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:18 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop you need to declare i via the script approach. cfloop does a basic declaration for you. the for loop does not. NOTE: if this loop is within a cffunction then ensure you have scoped i correctly (place var i = 1 above the loop) or (i = 1; i LTE qNav.recordCount; i=i+1) { . } -Pat http://patweb99.avatu.com On Tue, Apr 15, 2008 at 6:08 AM, Jason Durham [EMAIL PROTECTED] wrote: I'm having a hard time tracking down the source of an error I'm receiving from a recursive function. Are these loops identical? cfloop from=1 to=#qNav.recordCount# index=I /cfloop for (; i LTE qNav.recordCount; i=i+1) { . } ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript loop versus cfloop
didnt think of doing that :) I thought that too, but after copying the code from the thread and pasting it into my local environment showed it is being a capital i. On Tue, Apr 15, 2008 at 6:32 AM, Richard White [EMAIL PROTECTED] wrote: just an observation but the index in the cfloop doesnt look like an 'i' my eyes may be playing me up though!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript loop versus cfloop
I spent 5-6 hours trying to find the solution to this problem on my own. *embarrassed* I *hope* not to make that mistake again! Var first... ask questions later. :) -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:59 AM To: CF-Talk Subject: Re: cfscript loop versus cfloop Oh good catch Dominic! On Tue, Apr 15, 2008 at 6:50 AM, Dominic Watson [EMAIL PROTECTED] wrote: Could it be that qNav is not var scoped? i.e. cfset qNav = getSubs(ARGUMENTS.ParentID) / If this a recursive function, that should break it. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 508 Accessability
1. Start by learning as much as you can here http://www.w3.org/WAI/ 2. review the tutorial over at Jim Thatcher's website http://www.jimthatcher.com/webcourse1.htm 3. post further questions somewhere else (CF-Talk is for ColdFusion questions) - Chris [EMAIL PROTECTED] On Wed, Apr 9, 2008 at 8:50 AM, Stone, Lori [EMAIL PROTECTED] wrote: I have to look into making a site 508 accessible that has a ton of javascript in it (such as hidden div's, etc) Of course, I know someone on here has had to deal with this. Can I get some information on resources, comments on any tool/services used, and any other info I can on 508 accessibility would be great! -Lori ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303417 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 forms on same page and client side data validation
Unfortunately multi-tab form is parallel (I believe) while my case is sequential processing There is no sequential processing of multiple forms possible in HTML. You can have several forms in a page, but only one can submit. Tab forms is a solution to temporarily hide parts of a form, but only one form is needed. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Defining a cf cluster in apache
How do I find the jrun port to mount the defined coldfusion cluster instance to apache? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cftransaction and user/pass in DSN
I cannot find this documented anywhere although I see mention of it on blogs and forums. A developer here uses the macromedia driver for stored proc support. In her application she also uses cftransaction. I have asked that she supply the database username and password in either her cftransaction tags or in the dsn since I have read that cftransaction bypasses the username and password stored there. Although the transaction appears to commit and rollback, errors occur repeatedly in her logs: application.log:Warning,jrpp-14881,04/09/08,18:20:37,,[Macromedia][Oracle JDBC Driver]OS Authentication was requested, but is not supported by this Oracle Server. Do any of you know of other implications caused by not supplying username and pass in the DSN as far as cftransaction goes? I am thinking it could increase response time in her application if it does not. Also can anyone point me to any official documentation that states this is the case since all I can find is on blogs and message boards? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open Source CMS?
Well I decided to give FarCry a try. I have to say it looks great but I cant get the thing installed. No matter what I do I end up with this error: There is already an object named 'ruleHandpicked_aObjects' in the database I know it has to be some thing simple but I cant figure it out. Can any of you give me a hand? I really want to give FarCry a chance. Thanks Phil On Mon, Apr 14, 2008 at 9:42 PM, Geoff Bowers [EMAIL PROTECTED] wrote: On 15/04/2008, Phill B [EMAIL PROTECTED] wrote: I'm thinking about using an open source CMS for our intranet admin tools. Any suggestions? I need some thing that has roll based security and is easy to use. I have the majority of the CFCs written so I just need an empty shell to start filling with tools. Couple of great resources if you are considering FarCry: Geoff Bowers on the FarCry Framework http://www.sitepoint.com/article/geoff-bowers-farcry-framework This is an interview I did just this month for Sitepoint on FarCry Core, the CMS and the open source community in general. Plenty of great links to places to get started, the developer guide, our forums and more. FarCry 5.0 (Fortress) eSeminar Recording http://blog.daemon.com.au/go/blog-post/farcry-5-0-fortress-eseminar-recording And you can literally watch FarCry in action through this recorded seminar. The demo went off without a hitch, so its not too bad to sit through -- as long as you can put up with the Aussie accent :) Hope that helps, -- geoff http://www.daemon.com.au/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OutofMemoryError
In my application, I am attempting to 1.) Query table (50,000 + records) 2.) Create XML variable from query 3.) Zip file and push to user Unfortunately, when I do this, I get the following error: 500 ROOT CAUSE: java.lang.OutOfMemoryError: Java heap space javax.servlet.ServletException: ROOT CAUSE: java.lang.OutOfMemoryError: Java heap space at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:70) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) As far as I can tell, the problem occurs when I try to specify the xml variable as the the cfzipparam, as so: cfzipparam content=#toString(xRawFacilityReports)# entrypath=facilityreports.xml Obviously, the amount of data I am attempting to write is large, so is this a matter of reaching a limit on cfzipparam, or am I approaching this the wrong way? Thanks in advance for any help that you can provide. Joel Watson http://singularityconcepts.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OutofMemoryError
How are you creating the XML variable? Becuase if you are building it up manually by concatenating strings together this is common. This is because every time you concatenate a string it creates a new Java String instance, which means you have (depending on how many columns you have) hundreds of thousands or even millions of String instances that won't be garbage collected until after the request is over and all references to them are gone. Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to build up the XML string, as these are specifically for building up large strings without constantly creating new instances. You can find easy CFC wrappers for these and other Java classes at http://www.informationsavvy.com/coldfusion/. On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson [EMAIL PROTECTED] wrote: In my application, I am attempting to 1.) Query table (50,000 + records) 2.) Create XML variable from query 3.) Zip file and push to user Unfortunately, when I do this, I get the following error: 500 ROOT CAUSE: java.lang.OutOfMemoryError: Java heap space javax.servlet.ServletException: ROOT CAUSE: java.lang.OutOfMemoryError: Java heap space at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:70) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) As far as I can tell, the problem occurs when I try to specify the xml variable as the the cfzipparam, as so: cfzipparam content=#toString(xRawFacilityReports)# entrypath=facilityreports.xml Obviously, the amount of data I am attempting to write is large, so is this a matter of reaching a limit on cfzipparam, or am I approaching this the wrong way? Thanks in advance for any help that you can provide. Joel Watson http://singularityconcepts.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cffile ZIP mime type problem
After doing some googling, it appears that Firefox handles MIME types differently than IE. I don't like allowing application/unknown files to be uploaded. Anybody have any work-arounds? -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:42 AM To: CF-Talk Subject: cffile ZIP mime type problem I created an empty text file, zipped it with Windows XP's compression utility and attempted to run it through a form which uses cffile. I've also tried 3 other zip files from various sources (not sure of the compression utility used). As you can see from the error below, I specified application/zip and application/x-zip-compressed. Is that correct? Is that all I need? __ The MIME type of the uploaded file application/unknown was not accepted by the server. Only files of type application/vnd.ms-excel,application/msword,application/pdf,application/ zip,application/x-zip-compressed can be uploaded. Verify that you are uploading a file of the appropriate type. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Disable Image Button in IE
Should be as simple as an onclick=this.disabled = true : input type=image src=/images/buttons/button_save.gif onclick=this.disabled=true / Works for me in IE7 in my quick test. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OutofMemoryError
Brian-- Thanks for your quick response. Currently, I am building the XML variable with cfxml, looping over the query for the appropriate nodes. I will definitely check out the links you suggested. Thanks again! Joel Watson http://singularityconcepts.com How are you creating the XML variable? Becuase if you are building it up manually by concatenating strings together this is common. This is because every time you concatenate a string it creates a new Java String instance, which means you have (depending on how many columns you have) hundreds of thousands or even millions of String instances that won't be garbage collected until after the request is over and all references to them are gone. Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to build up the XML string, as these are specifically for building up large strings without constantly creating new instances. You can find easy CFC wrappers for these and other Java classes at http://www.informationsavvy.com/coldfusion/. On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Best practices with cfmenu/ajax stuff
I have a site I was working on in CF8. I'm getting ready to deploy it and moved it to the production server after installing CF 8.0.1. My Cfmenus seem to be borked now. I've seen other mention of the issues on this list. Mine were the correct size and the drop downs were right-aligned and now the menus wrap around the page and the dropdowns are centered. Are the online docs for CF 8.0.1 updated? Anyway, my question really relates to deploying the CSS and ajax stuff in production. The necessary css and js are in /cfide/scripts or whatever. Are people putting just what they need from this into their application directories or using mapping to access them? It seems like this shouldn't be necessary - perhaps I broke something? Obviously I don't want the full contents of the CFIDE directories inside my site. I don't know if it makes any difference, but the site was developed on Linux/Apache and is being moved to Windows/IIS for production. Thanks for pointers. -Nate ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OutofMemoryError
Don't forget, if you are using MS SQL 2000 or 2005 you can have the database create the XML for you. I'll let you decide if it is really easier or proper to do it that way, but it is possible. Can't help you much with the zipparam part. How long is this xml string? Also, why are you parsing the XML into an object and then tostringing it? Do you need it in object form to manipulate it before you write it? What would happen if you wrote the xml out to a temp file first and then zipped it ~Brad -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 10:01 AM To: CF-Talk Subject: Re: OutofMemoryError ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OutofMemoryError
Brian-- These links look great! The ExportDbToXml.cfc is actually just what I needed. Unfortunately, I am still receiving an error when performing this function: Stream closed: The error occurred in \com\FileWriter.cfc: line 118 Called from \com\ExportDbToXml.cfc: line 272 Called from \com\ExportDbToXml.cfc: line 55 Called from \reports\alldata.cfm: line 5 Called from \reports.cfm: line 173 Called from \reports.cfm: line 1 116 : cfargument name=strIn type=string required=No default= hint=a string to write to the file / 117 : 118 : cfset variables.joBufferedWriter.write(javaCast(string, arguments.strIn)) / 119 : cfset variables.joBufferedWriter.newLine() / 120 : /cffunction Now into Java, I am completely out of my knowledge set, so your continuing help would be greatly appreciated! Thanks! Joel Watson How are you creating the XML variable? Becuase if you are building it up manually by concatenating strings together this is common. This is because every time you concatenate a string it creates a new Java String instance, which means you have (depending on how many columns you have) hundreds of thousands or even millions of String instances that won't be garbage collected until after the request is over and all references to them are gone. Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to build up the XML string, as these are specifically for building up large strings without constantly creating new instances. You can find easy CFC wrappers for these and other Java classes at http://www.informationsavvy.com/coldfusion/. On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303429 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 forms on same page and client side data validation
Unfortunately multi-tab form is parallel (I believe) while my case is sequential processing There is no sequential processing of multiple forms possible in HTML. You can have several forms in a page, but only one can submit. Tab forms is a solution to temporarily hide parts of a form, but only one form is needed. Are you an expert in, say, DOM? To my knowledge, each and all web/script page, be it written in cf, jsp, asp, php, would be rendered by a UA (browser here), and the underlying technology for that is DOM, so, it does not matter how many HTML forms on a 'page'/script the web server sends to the browser, the UI would do it its rendering. I could write client side javascript for data validation for each form, however, that approach/technique defeats the purpose of using CFFORM (which does data validation among others), why reinvest the wheel? Or am I not thinking straight? But if you're saying, cf-supported data validation can only support one form on a page/script then its design is totally yester-year, and I hope Adobe engineers can step up the challenge, thks. I hope you see that I have a fairly strong business case for this... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query2excel
Sorry, I can't help you with this particular bug, but if you cannot find a solution let me suggest using Ben Nadels POI CFC. it's an amazing interface into creating Excel files from darn near any CF object. http://www.bennadel.com/projects/poi-utility.htm http://www.bennadel.com/blog/469-Creating-Microsoft-Excel-Files-Using-ColdFusion-And-POI.htm It works amazingly well. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OutofMemoryError
I would second Brad's comment about using DB's mechanism to build XML. We use Oracle at work here and with various XML function available in 10g release, most of our XML is generated from SQL queries. Thanks Qasim On Tue, Apr 15, 2008 at 11:24 AM, Joel Watson [EMAIL PROTECTED] wrote: Brian-- These links look great! The ExportDbToXml.cfc is actually just what I needed. Unfortunately, I am still receiving an error when performing this function: Stream closed: The error occurred in \com\FileWriter.cfc: line 118 Called from \com\ExportDbToXml.cfc: line 272 Called from \com\ExportDbToXml.cfc: line 55 Called from \reports\alldata.cfm: line 5 Called from \reports.cfm: line 173 Called from \reports.cfm: line 1 116 : cfargument name=strIn type=string required=No default= hint=a string to write to the file / 117 : 118 : cfset variables.joBufferedWriter.write(javaCast(string, arguments.strIn)) / 119 : cfset variables.joBufferedWriter.newLine() / 120 : /cffunction Now into Java, I am completely out of my knowledge set, so your continuing help would be greatly appreciated! Thanks! Joel Watson How are you creating the XML variable? Becuase if you are building it up manually by concatenating strings together this is common. This is because every time you concatenate a string it creates a new Java String instance, which means you have (depending on how many columns you have) hundreds of thousands or even millions of String instances that won't be garbage collected until after the request is over and all references to them are gone. Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to build up the XML string, as these are specifically for building up large strings without constantly creating new instances. You can find easy CFC wrappers for these and other Java classes at http://www.informationsavvy.com/coldfusion/. On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query2excel
Does it work without the hashes (they are unnecessary)? i.e. maxRows=finalQuery.recordcount+1 OR maxRows=#finalQuery.recordcount+1# Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303433 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 forms on same page and client side data validation
Unless I'm missing something, or you're doing something you've not mentioned (eg an Ajax call to handle the data of each 'step'), what he's saying is, when your final step gets submitted, all the data from the prior steps is lost. Only the submitted form's data is available to the action page. On Tue, Apr 15, 2008 at 10:35 AM, Don L [EMAIL PROTECTED] wrote: Unfortunately multi-tab form is parallel (I believe) while my case is sequential processing There is no sequential processing of multiple forms possible in HTML. You can have several forms in a page, but only one can submit. Tab forms is a solution to temporarily hide parts of a form, but only one form is needed. Are you an expert in, say, DOM? To my knowledge, each and all web/script page, be it written in cf, jsp, asp, php, would be rendered by a UA (browser here), and the underlying technology for that is DOM, so, it does not matter how many HTML forms on a 'page'/script the web server sends to the browser, the UI would do it its rendering. I could write client side javascript for data validation for each form, however, that approach/technique defeats the purpose of using CFFORM (which does data validation among others), why reinvest the wheel? Or am I not thinking straight? But if you're saying, cf-supported data validation can only support one form on a page/script then its design is totally yester-year, and I hope Adobe engineers can step up the challenge, thks. I hope you see that I have a fairly strong business case for this... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query2excel
thanks i will look into this as i do need more flexibility thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query2excel
hi dominic its really strange as maxRows=#finalQuery.recordcount# works but maxRows=#finalQuery.recordcount+1# doesnt work i have also tried it both ways as you suggested below but it keeps saying maxrows must be numeric thanks Does it work without the hashes (they are unnecessary)? i.e. maxRows=finalQuery.recordcount+1 OR maxRows=#finalQuery.recordcount+1# Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query2excel
Shouldn't that be maxRows=#finalQuery.recordcount# + 1 -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 11:49 AM To: CF-Talk Subject: Re: query2excel Does it work without the hashes (they are unnecessary)? i.e. maxRows=finalQuery.recordcount+1 OR maxRows=#finalQuery.recordcount+1# Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query2excel
If you copied that exactly...you have the +1 inside the pound signs... /*-Original Message- /*From: Richard White [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, April 15, 2008 8:42 AM /*To: CF-Talk /*Subject: query2excel /* /*Hi, i downloaded a cfx called query2excel and just wondering if either /*anyone else has used it and has come up with the same error, or whether i /*am doing something fundamentally wrong in coldfusion to get the following /*error: /* /*the code i am using is as follows: /* /*cfx_query2excel /* query=finalQuery /* templateFile=#expandPath('.')#\template_query_results.xls /* outputFile=#expandPath('.')#\Excel_Downloads\#filePath# /*startRow=1 /* maxRows=#finalQuery.recordcount+1# /* columnHeaderRow=1 /* appendOverwrites=true /* /*the error is on the maxrows attribute, it tells me that it must be numeric /*(maxRows=#finalQuery.recordcount+1#) however if i take out the +1 then it /*accepts it fine. /* /*i have even tried to setting variable to the recordcount + 1 then using /*that variable. it essentially works fine until i try to add 1 to it, no /*matter what way i try to add the 1. /* /*am i missing something simple or is there a bug with this cfx? /* /*thanks very much /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open Source CMS?
I really like TinyMCE for the HTML editor piece (free) and just building the CMS myself. Really very simple. Have built a custom CMS for each client with this marvelous little device which is very easy to install and configure, and it WORKS...even on IE! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query2excel
tanks dave tried that but also unsuccessful, i think i will have to use the other component suggested here as this must be a bug in the cfx thanks Shouldn't that be maxRows=#finalQuery.recordcount# + 1 Does it work without the hashes (they are unnecessary)? i.e. maxRows=finalQuery.recordcount+1 OR maxRows=#finalQuery.recordcount+1# Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303440 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 forms on same page and client side data validation
Unless I'm missing something, or you're doing something you've not mentioned (eg an Ajax call to handle the data of each 'step'), what he's saying is, when your final step gets submitted, all the data from the prior steps is lost. Only the submitted form's data is available to the action page. On Tue, Apr 15, 2008 at 10:35 AM, D I think probably you're right. Readers are not supposed to infer my comment of // ignore data capture, which means, I've already taken care of validation data capture after validation at each interval/form sending via ajax call. Also, the idea of not using the exising form group with tabs is to further eliminate error/misundertanding possibility (when you have only one form in front of you/user at any given point of time). Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfform format=flash onload
All, Does anyone know the action script to setFocus and have the user be able to start typing into a cfinput text field? -Jim cfsavecontent variable=preSelect _root.UserID.setFocus(); /cfsavecontent cfform format=flash skin=haloblue onload=#preSelect# cfformgroup type=horizontal id=myUID cfinput name=UserID width=200 maxlength=50 required=yes value= type=text /cfformgroup /cfform ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303442 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 forms on same page and client side data validation
Are you an expert in, say, DOM? Yes. To my knowledge, each and all web/script page, be it written in cf, jsp, asp, php, would be rendered by a UA (browser here), and the underlying technology for that is DOM, so, it does not matter how many HTML forms on a 'page'/script the web server sends to the browser, the UI would do it its rendering. You may have as many forms in a page as you want, but only one can be submitted, and only the fields in that one form will be transmitted to the server. For the same reason, you don't need to validate fields in forms that will not submit. I could write client side javascript for data validation for each form, Sure, but again, only ONE form needs to be validated, the one that will be submitted. however, that approach/technique defeats the purpose of using CFFORM (which does data validation among others), why reinvest the wheel? Well, in the case of CFFORM, believe me, it is worth ;-) But if you're saying, cf-supported data validation can only support one form on a page/script then its design is totally yester-year, I never use CFFORM, because there are many things I need which are not available with CFFORM. May be it got more developed now, but I've designed my own system, and I'm happy with it. However, I'd be surprised you cannot have several CFFORM in the same page. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query2excel
One last thing, then I'll shut up - have you tried taking the calculation outside? ie cfset x = finalQuery.recordcount + 1 maxRows=x, (or maxRows=#x#) -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 12:58 PM To: CF-Talk Subject: Re: query2excel tanks dave tried that but also unsuccessful, i think i will have to use the other component suggested here as this must be a bug in the cfx thanks Shouldn't that be maxRows=#finalQuery.recordcount# + 1 Does it work without the hashes (they are unnecessary)? i.e. maxRows=finalQuery.recordcount+1 OR maxRows=#finalQuery.recordcount+1# Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLdap and CF8
We had LDAP code that was working in CF7 now it is not working in CF8. Has something changed? We are adding a user to LDAP and get this error: An error has occured while trying to execute add :[LDAP: error code 19 - 2081: AtrErr: DSID-03151122, #1: 0: 2081: DSID-03151122, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 3 (cn) ]. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query2excel
Have you tried putting the calculation in brackets first so that it calculates and then inserts the sum? maxRows=#(finalQuery.recordcount+1)# -- Daniel Kessler University of Maryland College Park School of Public Health 3302E HHP Building College Park, MD 20742-2611 Phone: 301-405-2545 http://sph.umd.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303446 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 format=flash onload
I had this in the onload attribute of the form. cfformitem type=script function setupForm() { Selection.setFocus(userLogin); } /cfformitem This creates a soft glow around the input as if it's selected but you still have to click on it to type. From the testing/research I did... I don't think it's possible. If you figure it out, I'd love to know the solution. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 12:13 PM To: CF-Talk Subject: cfform format=flash onload All, Does anyone know the action script to setFocus and have the user be able to start typing into a cfinput text field? -Jim cfsavecontent variable=preSelect _root.UserID.setFocus(); /cfsavecontent cfform format=flash skin=haloblue onload=#preSelect# cfformgroup type=horizontal id=myUID cfinput name=UserID width=200 maxlength=50 required=yes value= type=text /cfformgroup /cfform ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303447 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 format=flash onload
James you might have to use creationComplete. Something like: cfsavecontent variable=onLoad var myListener = {}; myListener.creationComplete = function() { _root.UserID.setFocus(); } /cfsavecontent Greg On Tue, Apr 15, 2008 at 1:13 PM, James Blaha [EMAIL PROTECTED] wrote: All, Does anyone know the action script to setFocus and have the user be able to start typing into a cfinput text field? -Jim cfsavecontent variable=preSelect _root.UserID.setFocus(); /cfsavecontent cfform format=flash skin=haloblue onload=#preSelect# cfformgroup type=horizontal id=myUID cfinput name=UserID width=200 maxlength=50 required=yes value= type=text /cfformgroup /cfform ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303448 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 format=flash onload
Hi Jason, Thanks I'm trying to get the dream option to work where you can just start typing. I've been googling but no luck yet. I'll post a solution if I get it working. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303449 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 format=flash onload
Yes, it was kinda tricky. I forgot earlier to say you'll need a hidden input to trigger it like this: cfsavecontent variable=onLoad var myListener = {}; myListener.creationComplete = function() { _root.UserID.setFocus(); } /cfsavecontent cfsavecontent variable=triggerSetup {triggerLoad.dispatchEvent({type:'change'})} /cfsavecontent cfinput type=hidden name=trigger bind=#triggerSetup# Greg On Tue, Apr 15, 2008 at 2:21 PM, Jason Durham [EMAIL PROTECTED] wrote: I had this in the onload attribute of the form. cfformitem type=script function setupForm() { Selection.setFocus(userLogin); } /cfformitem This creates a soft glow around the input as if it's selected but you still have to click on it to type. From the testing/research I did... I don't think it's possible. If you figure it out, I'd love to know the solution. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 12:13 PM To: CF-Talk Subject: cfform format=flash onload All, Does anyone know the action script to setFocus and have the user be able to start typing into a cfinput text field? -Jim cfsavecontent variable=preSelect _root.UserID.setFocus(); /cfsavecontent cfform format=flash skin=haloblue onload=#preSelect# cfformgroup type=horizontal id=myUID cfinput name=UserID width=200 maxlength=50 required=yes value= type=text /cfformgroup /cfform ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Forcing a CFC to refresh...
Boy I hate developing with CFCs.. Make an edit, test, make another edit - the darned thing doesn't refresh. The only way I've found around this is to keep saving it under a new name, and retest using the new name each time cfset request.cfcLOCATION=https://mysite.com/version1.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version2.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version3.cfc?wsdl; and so forth. What a PITA!! Is there any way (on a shared server that I've very little access to beyond FTP) to *force* a CFC to refresh, or is this just the nature of the beast? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303451 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 format=flash onload
Hi Greg, So close: onload=_root.UserID.setFocus(); this just highlights the box. I couldnt get what you sent to work. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303452 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 forms on same page and client side data validation
Are you an expert in, say, DOM? Yes. To my knowledge, each and all web/script page, be it written in cf, jsp, asp, php, would be rendered by a UA (browser here), and the underlying technology for that is DOM, so, it does not matter how many HTML forms on a 'page'/script the web server sends to the browser, the UI would do it its rendering. however, that approach/technique defeats the purpose of using CFFORM (which does data validation among others), why reinvest the wheel? Well, in the case of CFFORM, believe me, it is worth ;-) But if you're saying, cf-supported data validation can only support one form on a page/script then its design is totally yester-year, I never use CFFORM, because there are many things I need which are not available with CFFORM. May be it got more developed now, but I've designed my own system, and I'm happy with it. However, I'd be surprised you cannot have several CFFORM in the same page. My key point was, to re-use cfform's built-in client data validation capability for my case if that's possible, for one thing, it saves time of reventing wheel, for instance, do you build you own credit card validation schema? or borrow algo for it? If it can I think Adobe would help and save a lot of developers' time, to say the least. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Forcing a CFC to refresh...
Develop locally? There's a reason CF Enterprise is free for development. On Tue, Apr 15, 2008 at 11:42 AM, Les Mizzell [EMAIL PROTECTED] wrote: Boy I hate developing with CFCs.. Make an edit, test, make another edit - the darned thing doesn't refresh. The only way I've found around this is to keep saving it under a new name, and retest using the new name each time cfset request.cfcLOCATION=https://mysite.com/version1.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version2.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version3.cfc?wsdl; and so forth. What a PITA!! Is there any way (on a shared server that I've very little access to beyond FTP) to *force* a CFC to refresh, or is this just the nature of the beast? -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLdap and CF8
I don't recall anything changing with LDAP in CF8. However, I don't use CFLDAP to create LDAP objects. Have you changed the underlying JVM version with the upgrade to CF8? m!ke -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 1:18 PM To: CF-Talk Subject: CFLdap and CF8 We had LDAP code that was working in CF7 now it is not working in CF8. Has something changed? We are adding a user to LDAP and get this error: An error has occured while trying to execute add :[LDAP: error code 19 - 2081: AtrErr: DSID-03151122, #1: 0: 2081: DSID-03151122, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 3 (cn) ]. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Forcing a CFC to refresh...
If you have access to the CF Admin, turn off all of the template options for your dev environment. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 2:42 PM To: CF-Talk Subject: Forcing a CFC to refresh... Boy I hate developing with CFCs.. Make an edit, test, make another edit - the darned thing doesn't refresh. The only way I've found around this is to keep saving it under a new name, and retest using the new name each time cfset request.cfcLOCATION=https://mysite.com/version1.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version2.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version3.cfc?wsdl; . and so forth. What a PITA!! Is there any way (on a shared server that I've very little access to beyond FTP) to *force* a CFC to refresh, or is this just the nature of the beast? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Forcing a CFC to refresh...
In Application.cfc, just have an if statement that checks for the existence of a url variable. if the url variable exists, call onApplicationStart() and onSessionStart() explicitly. This will reload all scoped CFCs. Nic Barney Boisvert wrote: Develop locally? There's a reason CF Enterprise is free for development. On Tue, Apr 15, 2008 at 11:42 AM, Les Mizzell [EMAIL PROTECTED] wrote: Boy I hate developing with CFCs.. Make an edit, test, make another edit - the darned thing doesn't refresh. The only way I've found around this is to keep saving it under a new name, and retest using the new name each time cfset request.cfcLOCATION=https://mysite.com/version1.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version2.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version3.cfc?wsdl; and so forth. What a PITA!! Is there any way (on a shared server that I've very little access to beyond FTP) to *force* a CFC to refresh, or is this just the nature of the beast? -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303457 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 format=flash onload
Greg, Could please post a small working example? Thanks for your post! -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cftry/catch error report question
Hi, I've set up a cftry/catch around a piece of code that I am having problems with and the resulting error report I'm not sure about the interpretation. What came back was: The value cannot be converted to a number coldfusion.runtime.Cast$NumberConversionException: The value cannot be converted to a number at coldfusion.runtime.Cast._double(Cast.java:384) at coldfusion.runtime.Cast._double(Cast.java:522) at cfstorecart2ecfm68181532.runPage(D:\sites\adrenalinebikes.com\htdocs\storecart.cfm:156) at Is this telling me the problem was on line #156 in the storecart.cfm program? If so, on that line I find: cfset LineShip = Session.Basket.Quantity * Product.ShipBase Both fields are numeric, although shipbase could be null. ?? --Ben +---+ + Ben Conner[EMAIL PROTECTED] + + Web World, Inc. 888-206-6486+ + PO Box 1122 480-704-2000+ + Queen Creek, AZ 85242 + +---+ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLdap and CF8
We did an upgrade from 7 to 8. Nothing special. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 2:46 PM To: CF-Talk Subject: RE: CFLdap and CF8 I don't recall anything changing with LDAP in CF8. However, I don't use CFLDAP to create LDAP objects. Have you changed the underlying JVM version with the upgrade to CF8? m!ke -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 1:18 PM To: CF-Talk Subject: CFLdap and CF8 We had LDAP code that was working in CF7 now it is not working in CF8. Has something changed? We are adding a user to LDAP and get this error: An error has occured while trying to execute add :[LDAP: error code 19 - 2081: AtrErr: DSID-03151122, #1: 0: 2081: DSID-03151122, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 3 (cn) ]. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Forcing a CFC to refresh...
It doesn't have anything to do with CFCs. ColdFusion has always cached web services so it doesn't have to keep re-requesting and re-parsing the WSDL. Please, do some research before you run out to a list and condemn something that actually has nothing to do with your problem. And as Barney said, doing development on a shared server is just silly when you can (and should) be doing it locally. On Tue, Apr 15, 2008 at 2:42 PM, Les Mizzell [EMAIL PROTECTED] wrote: Boy I hate developing with CFCs.. Make an edit, test, make another edit - the darned thing doesn't refresh. The only way I've found around this is to keep saving it under a new name, and retest using the new name each time cfset request.cfcLOCATION=https://mysite.com/version1.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version2.cfc?wsdl; cfset request.cfcLOCATION=https://mysite.com/version3.cfc?wsdl; and so forth. What a PITA!! Is there any way (on a shared server that I've very little access to beyond FTP) to *force* a CFC to refresh, or is this just the nature of the beast? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftry/catch error report question
I get that error when I am fixing a friends code. The null will cause that as it is not a numeric value. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OutofMemoryError
No idea really, maybe it's timing out? Or are you flushing content to the browser before it is finished? On Tue, Apr 15, 2008 at 11:24 AM, Joel Watson [EMAIL PROTECTED] wrote: Brian-- These links look great! The ExportDbToXml.cfc is actually just what I needed. Unfortunately, I am still receiving an error when performing this function: Stream closed: The error occurred in \com\FileWriter.cfc: line 118 Called from \com\ExportDbToXml.cfc: line 272 Called from \com\ExportDbToXml.cfc: line 55 Called from \reports\alldata.cfm: line 5 Called from \reports.cfm: line 173 Called from \reports.cfm: line 1 116 : cfargument name=strIn type=string required=No default= hint=a string to write to the file / 117 : 118 : cfset variables.joBufferedWriter.write(javaCast(string, arguments.strIn)) / 119 : cfset variables.joBufferedWriter.newLine() / 120 : /cffunction Now into Java, I am completely out of my knowledge set, so your continuing help would be greatly appreciated! Thanks! Joel Watson How are you creating the XML variable? Becuase if you are building it up manually by concatenating strings together this is common. This is because every time you concatenate a string it creates a new Java String instance, which means you have (depending on how many columns you have) hundreds of thousands or even millions of String instances that won't be garbage collected until after the request is over and all references to them are gone. Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to build up the XML string, as these are specifically for building up large strings without constantly creating new instances. You can find easy CFC wrappers for these and other Java classes at http://www.informationsavvy.com/coldfusion/. On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cftry/catch error report question
An empty string is not a number. You need to default it to 1 or do a conditional check and only perform the multiplication if the value is numeric. On Tue, Apr 15, 2008 at 2:52 PM, Ben Conner [EMAIL PROTECTED] wrote: Hi, I've set up a cftry/catch around a piece of code that I am having problems with and the resulting error report I'm not sure about the interpretation. What came back was: The value cannot be converted to a number coldfusion.runtime.Cast$NumberConversionException: The value cannot be converted to a number at coldfusion.runtime.Cast._double(Cast.java:384) at coldfusion.runtime.Cast._double(Cast.java:522) at cfstorecart2ecfm68181532.runPage(D:\sites\adrenalinebikes.com\htdocs\storecart.cfm:156) at Is this telling me the problem was on line #156 in the storecart.cfm program? If so, on that line I find: cfset LineShip = Session.Basket.Quantity * Product.ShipBase Both fields are numeric, although shipbase could be null. ?? --Ben +---+ + Ben Conner[EMAIL PROTECTED] + + Web World, Inc. 888-206-6486+ + PO Box 1122 480-704-2000+ + Queen Creek, AZ 85242 + +---+ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLdap and CF8
WOW... it was a case sensitive thing. Maybe our code always was broken and we just never stumbled upon it. We use to do this: attributes=cn=#arguments.FIRSTNAME# #arguments.LASTNAME#; We had to change cn into CN and now it works. attributes=CN=#arguments.FIRSTNAME# #arguments.LASTNAME#; -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 3:00 PM To: CF-Talk Subject: RE: CFLdap and CF8 We did an upgrade from 7 to 8. Nothing special. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 2:46 PM To: CF-Talk Subject: RE: CFLdap and CF8 I don't recall anything changing with LDAP in CF8. However, I don't use CFLDAP to create LDAP objects. Have you changed the underlying JVM version with the upgrade to CF8? m!ke -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 1:18 PM To: CF-Talk Subject: CFLdap and CF8 We had LDAP code that was working in CF7 now it is not working in CF8. Has something changed? We are adding a user to LDAP and get this error: An error has occured while trying to execute add :[LDAP: error code 19 - 2081: AtrErr: DSID-03151122, #1: 0: 2081: DSID-03151122, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 3 (cn) ]. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Newly acquired domain being blocked by some firewalls.
Recently, I purchased a domain from a domain auction site. Long story short, I developed a new site for that domain. Well, it seems that some friends can't view the site from their workplace because firewalls mark the site as being Adult in nature. There is nothing seedy about my new site. My question is: what can be done to rectify this? I know sites get blacklisted and firewalls subscribe to those lists. Are there any sites out there where I can clear my sites good name? Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303466 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 format=flash onload
James, I've never done the focus onLoad, but I have done other functions in the onLoad event. Try this: cfsavecontent variable=onLoad UserID.setFocus(); /cfsavecontent cfsavecontent variable=binding {(trigger.text != '') ? trigger.dispatchEvent({type:'change'}) : 'init'} /cfsavecontent cfform format=flash skin=haloblue cfformgroup type=horizontal id=myUID cfinput name=UserID width=200 maxlength=50 required=yes value= type=text cfinput type=text visible=false height='0' width=0 name=trigger value=init onchange=#onLoad# bind=#binding# /cfformgroup /cfform Greg On Tue, Apr 15, 2008 at 2:52 PM, James Blaha [EMAIL PROTECTED] wrote: Greg, Could please post a small working example? Thanks for your post! -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303467 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 format=flash onload
The key is to set the selection in the text box as well... than the cursor will be there. !k -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 12:43 PM To: CF-Talk Subject: Re: cfform format=flash onload Hi Greg, So close: onload=_root.UserID.setFocus(); this just highlights the box. I couldnt get what you sent to work. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Forcing a CFC to refresh...
Besides deleting the web service from ColdFusion administrator, there is some Admin API functionality that will do it programmatically but you will obviously need the CF Admin password to use it. ~Brad Is there any way (on a shared server that I've very little access to beyond FTP) to *force* a CFC to refresh, or is this just the nature of the beast? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303469 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 forms on same page and client side data validation
My key point was, to re-use cfform's built-in client data validation capability for my case if that's possible, Well, if you use CFFORM, it should be possible for sure, or do you mean you want to use CFFORM validation WITHOUT using CFFORM? for instance, do you build you own credit card validation schema? If I needed to, yes, I would, no problem. On the other hand, CFFORM has no validation scheme to check if some user's identifier is unique by AJAX (at least not the last time I look at it), so I built my own. CFFORM has plenty of thing I don't need, and is missing a couple I need, so I designed my own. Another problem with CFFORM is when you must provide error message text, because your app is not in English: You must provide messages for all CFINPUT field, a PITA. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Forcing a CFC to refresh...
And as Barney said, doing development on a shared server is just silly when you can (and should) be doing it locally. I know I can develop locally - but a several specific functions I'm working on must come from a *specific* https address, or any incoming cfhttp is rejected. This address is already defined and I don't have access to change it, so I've no choice but to develop as much as I can locally, and test from the actual server using the real address for the submitting pages in question. I think Nic has my solution though. Off to see what happens... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Forcing a CFC to refresh...
Develop locally but if you want to force to refresh a webservice try cfset ws = createObject('webservice', someUrl, { refreshWSDL=yes } ) -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query2excel
hi dave, thanks yes i have tried this as well :( still no joy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query2excel
Hi Daniel, just tried this to no success :( thanks though Have you tried putting the calculation in brackets first so that it calculates and then inserts the sum? maxRows=#(finalQuery.recordcount+1)# -- Daniel Kessler University of Maryland College Park School of Public Health 3302E HHP Building College Park, MD 20742-2611 Phone: 301-405-2545 http://sph.umd.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: need an opinion
My apology for OT. Need an opinion, when you see the following icon, http://24.254.1.94:8000/test/logo_idea.bmp what do you make of it? Also, it's boring, clearly I lack creativity. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query2excel
GOT IT!!! i managed to fool it seeing as the + 1 wasn't working i added an empty row into the query cfset queryaddrow(finalQuery) and it then had the same affect as finalQuery.recordcount+1 and it went through fine :) thanks for all your help and suggestions, this must be a bug in this component and i will def look at the other component suggested on here for enhanced flexibility thanks again ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303476 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 forms on same page and client side data validation
My key point was, to re-use cfform's built-in client data validation capability for my case if that's possible, Well, if you use CFFORM, it should be possible for sure, or do you mean you want to use CFFORM validation WITHOUT using CFFORM? Did you have a chance to copy/paste and try the code in my OP? Tks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need an opinion
Don-- Honestly, I don't think it's bad at all. If I came across it, I would be confused about the meaning of B T V, but would probably assume that the icon represented something to do with community or something similar to that. My $.02~ My apology for OT. Need an opinion, when you see the following icon, http://24.254.1.94:8000/test/logo_idea.bmp what do you make of it? Also, it's boring, clearly I lack creativity. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4