RE: How to Form variables from: request.servletEvent.getValue('fieldName')
Yes, it would post to myCF then return to Sava -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: 2009-02-26 21:17 To: cf-talk Subject: Re: How to Form variables from: request.servletEvent.getValue('fieldName') That still isn't answering the question. Is your Sava form going to perform a POST to your CF page or not? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/27 cfcom : > > It would start from a Sava Form, > Pass variables to my CF actions > Then do a confirmation page back with in Sava Framework > > -Original Message- > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: 2009-02-26 12:35 > To: cf-talk > Subject: Re: How to Form variables from: > request.servletEvent.getValue('fieldName') > > >> I need to pass the variables from a third party application form to my own >> cfmail. The third party app states them as (3fname, lname, address, state, >> city, zip, email') >> >> The form variables are accessible in the request scope or in the >> request.serlvetEvent.getValue('fieldName') > > I'm not sure exactly what you mean. Is this third-party form posting > to the URL of one of your CF pages? If so, you'll just get a bunch of > form variables - no need to use request.yaddaYaddaYadda. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319897 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server slowly dying - Possibly a memory leak --- CF7, MS SQL Server 2005 Express
> > Have you considered migrating SQL Server to a > > dedicated machine? > > I'd like to avoid that for cost reasons. I've been running > the site nobosh.com on the one sever for over a year > without issue, only recently due to product updates and > increased traffic has the server started to have > issues. Well, if you have more traffic, and performance goes down, that's a sign that you may need to invest in more hardware. That said, you might want to monitor CPU usage and maybe even disk usage during slow performance times; if either of those go up significantly, you may see a benefit by moving your database to a dedicated database server. > Good point, the memory usage for JRUN and MSSQL > is reaching a plateau. I haven't increased the maximum > heap size for CF, what do you recommend? If you're not reaching the maxinum heap size now, I wouldn't recommend increasing it at all. The default setting for max heap size in CF 8 is 512MB. You're not anywhere near that, so I wouldn't worry about this. I don't think your problems have anything to do with memory consumption. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Multi Server Config Help
> Dave, what would you recommend? > Clean up old mappings > Establish a naming > convention for the new stuff to avoid conflicts > when > complete, clean house and remove old mappings All of those sound good. Any documentation process you can use going forward to keep track of settings would probably be helpful. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS - XML Rates: Connection Failure
> To ensure that the name resolution works, would you > suggest just opening the URL in a browser on the > server?? Yes, that would work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319894 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inner, Left and Right joins returning the same records AKA Tough SQL relationship part deux
>FROM >tableA p LEFT OUTER JOIN > tableB e ON (p.use_no = e.use_no AND p.year = e.year and >e.duplicate_set is not null) LEFT OUTER JOIN >tableB d ON (e.duplicate_set = d.duplicate_set AND e.year = >d.year) Yes, I think that would work. There is probably a more elegant method, but you could try joining back to the counts to get both totals. SELECT m.county, m.rec_type, m.records, dup.records_with_dupes FROM ( SELECT county, rec_type, count(*) as records FROMtableA GROUP BY county, rec_type ) m LEFT JOIN ( SELECT p.county, p.rec_type, count(*) AS records_with_dupes FROMtableA p LEFT JOIN tableB e ON (p.use_no = e.use_no AND p.year = e.year and e.dup_set is not null) LEFT JOIN tableB d ON (e.dup_set = d.dup_set AND e.year = d.year) GROUP BY p.county, p.rec_type ) dup ON m.county = dup.county AND m.rec_type = dup.rec_type ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert Image to Binary
Is all you need when the datatype is image or varbinary on MSSQL you don't need the tobase64 that will teach me for responding to fast. Thanks james You also need to check : -- Enable binary large object retrieval (BLOB). in CF admin. On Thu, Feb 26, 2009 at 9:14 PM, James Holmes wrote: > > That would mean you're entering base64 text into a binary field. > > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com.au/blog/ > > > > 2009/2/27 Paul Kukiel : > > > > Managing images on disk is a better way but if you must use the data base > > make sure you are using > > > > > vale="#toBase64(FinalMergedDisclosure)# /> > > > > Which should work for you. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: connecting to sql server datasource in CF8
Try this setup: http://www.fusioncube.net/index.php/coldfusion-sql-server-express On Thu, Feb 26, 2009 at 9:37 PM, Mike Little wrote: > > hey guys, i have recently installed coldfusion 8. everything going sweet > except creating a datasource to connnect to a remote ms sql server. > > i get the following... > > Connection verification failed for data source: xyz123 > java.sql.SQLException: Timed out trying to establish connection > The root cause was that: java.sql.SQLException: Timed out trying to > establish connection > > this worked fine in seven. i have used the exact settings used for the > existing connection. i have also made sure all relevant ports are open. > > any help would be appreciated. > mike > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: connecting to sql server datasource in CF8
i am not totally following your question, but if it helps - i can connect to the db with enterprise manager. >Did you check with th TCP/IP enadled, port number and you should not use >windows password but the database password. > > > >On Thu, Feb 26, 2009 at 9:37 PM, Mike Little wrote: > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319890 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: connecting to sql server datasource in CF8
Did you check with th TCP/IP enadled, port number and you should not use windows password but the database password. On Thu, Feb 26, 2009 at 9:37 PM, Mike Little wrote: > > hey guys, i have recently installed coldfusion 8. everything going sweet > except creating a datasource to connnect to a remote ms sql server. > > i get the following... > > Connection verification failed for data source: xyz123 > java.sql.SQLException: Timed out trying to establish connection > The root cause was that: java.sql.SQLException: Timed out trying to > establish connection > > this worked fine in seven. i have used the exact settings used for the > existing connection. i have also made sure all relevant ports are open. > > any help would be appreciated. > mike > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319889 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
connecting to sql server datasource in CF8
hey guys, i have recently installed coldfusion 8. everything going sweet except creating a datasource to connnect to a remote ms sql server. i get the following... Connection verification failed for data source: xyz123 java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection this worked fine in seven. i have used the exact settings used for the existing connection. i have also made sure all relevant ports are open. any help would be appreciated. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to Form variables from: request.servletEvent.getValue('fieldName')
That still isn't answering the question. Is your Sava form going to perform a POST to your CF page or not? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/27 cfcom : > > It would start from a Sava Form, > Pass variables to my CF actions > Then do a confirmation page back with in Sava Framework > > -Original Message- > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: 2009-02-26 12:35 > To: cf-talk > Subject: Re: How to Form variables from: > request.servletEvent.getValue('fieldName') > > >> I need to pass the variables from a third party application form to my own >> cfmail. The third party app states them as (3fname, lname, address, state, >> city, zip, email') >> >> The form variables are accessible in the request scope or in the >> request.serlvetEvent.getValue('fieldName') > > I'm not sure exactly what you mean. Is this third-party form posting > to the URL of one of your CF pages? If so, you'll just get a bunch of > form variables - no need to use request.yaddaYaddaYadda. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert Image to Binary
That would mean you're entering base64 text into a binary field. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/27 Paul Kukiel : > > Managing images on disk is a better way but if you must use the data base > make sure you are using > > vale="#toBase64(FinalMergedDisclosure)# /> > > Which should work for you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFTOOLTIP Not Working
No errors either during load or mouse over. I'm wondering if some recent IIS security upgrade is blocking it... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFTOOLTIP Not Working
Are you seeing any errors in Firebug when the page loads, or during the mouseover action? Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Ron Gruner wrote: > has stopped working on my local test server (IIS, CF8) after a > year but the same pages work fine on the production server. Nothing's > changed that I can think of and all other JS and Spry functions continue to > work fine both locally and remotely. What would cause just to > not work? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Session Variable not being set - variable created during processing
>Where are you setting this variable ' >SESSION.consumerProduct.Cnsmr_ProductID ' prior to this block of code? > >William > > >I am trying to assign the value generated for the variable filename to a >session variable, but when I process the page, Coldfusion reports that: > >"The form field SESSION.consumerProductExtraImg.Img1 did not contain a >file." yet I had uploaded files. > >What am I doing wrong? TIA > > > >enctype="multipart/form-data"> > > >/> > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Session Variable not being set - variable created during processing
Hi, That variable (SESSION.consumerProduct.Cnsmr_ProductID) is being set when the session first starts and the customers enters initial details. So it is on a different page, that links to the page with the code I posted. >Where are you setting this variable ' >SESSION.consumerProduct.Cnsmr_ProductID ' prior to this block of code? > >William > > >I am trying to assign the value generated for the variable filename to a >session variable, but when I process the page, Coldfusion reports that: > >"The form field SESSION.consumerProductExtraImg.Img1 did not contain a >file." yet I had uploaded files. > >What am I doing wrong? TIA > > > >enctype="multipart/form-data"> > > >/> > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Inner, Left and Right joins returning the same records AKA Tough SQL relationship part deux
Not quite I sure I follow (sorry, almost out the door here), but I think you just want your aggregate to an entry for every A regardless of B, right? Try making your joins LEFT, and I think you'll have it: ... FROM tableA p LEFT OUTER JOIN tableB e ON (p.use_no = e.use_no AND p.year = e.year and e.duplicate_set is not null) LEFT OUTER JOIN tableB d ON (e.duplicate_set = d.duplicate_set AND e.year = d.year) ... That should get your aggregate COUNT() to still return "1" where there is only the one record in TableA, like 2009 3. Cheers, Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFTOOLTIP Not Working
has stopped working on my local test server (IIS, CF8) after a year but the same pages work fine on the production server. Nothing's changed that I can think of and all other JS and Spry functions continue to work fine both locally and remotely. What would cause just to not work? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inner, Left and Right joins returning the same records AKA Tough SQL relationship part deux
This is a follow on request to yesterday's post: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319832. To review I have two tables something like this. TableA year use_no county rec_type 2009 1 1 X 2009 3 1 X 2009 4 1 Y 2009 5 2 X 2009 6 2 X 2009 7 2 Y 2009 10 2 Y TableB year use_no dup_set 2009 1 A 2009 2 A 2009 7 B 2009 8 B 2009 9 B The year and use_no fields combine to be the unique key for both tables and records that share the same key in each table are related to each other. TableB records sets of records that are considered duplicates and all the records of a set are related by sharing the same dup_set key value. The goal of my task is to create report that counts the number of records in TableA grouped by county and rec_type and counts the number of records if all the duplicate records recorded in TableB are taken into account. So using the above simplified data, the report would produce results something like this. county rec_type records records_with_dups 1 X 23 1 Y 11 2 X 22 2 Y 24 With some tinkering I have gotten part of the way there. The following set of table joins will produce a record set of records that are duplicated and how many duplicates their are. SELECT p.year, p.use_no, count(*) AS duplicates FROM tableA p INNER JOIN tableB e ON (p.use_no = e.use_no AND p.year = e.year and e.duplicate_set is not null) INNER JOIN tableB d ON (e.duplicate_set = d.duplicate_set AND e.year = d.year) GROUP BY p.year, p.use_no This returns results something like: year use_no duplicates 2009 1 2 2009 7 3 Now if I can just combine this back into the rest of the tableA data so I can get something that looks like this, I would be good to go. year use_no duplicates 2009 1 2 2009 3 1 2009 4 1 2009 5 1 2009 6 1 2009 7 3 2009 10 1 I tried a UNION but I got this result. Note that records from the duplicate set are duplicated. year use_no duplicates 2009 1 2 2009 1 1 2009 3 1 2009 4 1 2009 5 1 2009 6 1 2009 7 3 2009 7 1 2009 10 1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Disable ScriptProtect on a per page basis.
Great! Thanks for the clarification Dave. > > Application properties, like this.scriptProtect, are evaluated on > each > page request. This is kind of counterintuitive, but it's the way it > works. Application properties are not the same as Application > variables. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert Image to Binary
Managing images on disk is a better way but if you must use the data base make sure you are using > > result="fileUpload" >nameconflict="overwrite"> > > name="myImage"> > variable="FinalImage"> > variable > > > update table1 set Logo='#FinalImage#' where Name='John' > > > I am getting an error: ByteArray objects cannot be converted to strings. > I tried with tostring etc.. but didnt work > Datatype for this column is varBinary(MAX). > > Any sugestions > > Thanks, > Priya. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Disable ScriptProtect on a per page basis.
> Won't this alter the setting for the entire application? Or is this not part > of the application > scope? I guess I just assumed it was. But since it is being defined using > this.scriptprotect, > does this mean that is is evaluated on every page request? Application properties, like this.scriptProtect, are evaluated on each page request. This is kind of counterintuitive, but it's the way it works. Application properties are not the same as Application variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Disable ScriptProtect on a per page basis.
Dave, Won't this alter the setting for the entire application? Or is this not part of the application scope? I guess I just assumed it was. But since it is being defined using this.scriptprotect, does this mean that is is evaluated on every page request? Thanks, Dean > You can make any changes to an application on a single page. If > you're > using CFAPPLICATION within Application.cfm, just use CFAPPLICATION > again within the page in question. If you're using Application.cfc, > just put conditional logic within Application.cfc to check for the > page in question, then set the Application property accordingly. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Disable ScriptProtect on a per page basis.
> Does anyone know if this is possible? I know you can do it at the server and > application level, > but I couldn't find anything that would allow me to selectively turn it off > for a single > administrative page. You can make any changes to an application on a single page. If you're using CFAPPLICATION within Application.cfm, just use CFAPPLICATION again within the page in question. If you're using Application.cfc, just put conditional logic within Application.cfc to check for the page in question, then set the Application property accordingly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Disable ScriptProtect on a per page basis.
Does anyone know if this is possible? I know you can do it at the server and application level, but I couldn't find anything that would allow me to selectively turn it off for a single administrative page. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Convert Image to Binary
>>Any sugestions Yes, store only the image characteristics like file name, size, title, etc in the database, and use the system file management to handle the image storage. It is generally more efficient than increasing the size of the database for nothing. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Form variables from: request.servletEvent.getValue('fieldName')
It would start from a Sava Form, Pass variables to my CF actions Then do a confirmation page back with in Sava Framework -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 2009-02-26 12:35 To: cf-talk Subject: Re: How to Form variables from: request.servletEvent.getValue('fieldName') > I need to pass the variables from a third party application form to my own > cfmail. The third party app states them as (3fname, lname, address, state, > city, zip, email') > > The form variables are accessible in the request scope or in the > request.serlvetEvent.getValue('fieldName') I'm not sure exactly what you mean. Is this third-party form posting to the URL of one of your CF pages? If so, you'll just get a bunch of form variables - no need to use request.yaddaYaddaYadda. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to Form variables from: request.servletEvent.getValue('fieldName')
> I need to pass the variables from a third party application form to my own > cfmail. The third party app states them as (3fname, lname, address, state, > city, zip, email') > > The form variables are accessible in the request scope or in the > request.serlvetEvent.getValue('fieldName') I'm not sure exactly what you mean. Is this third-party form posting to the URL of one of your CF pages? If so, you'll just get a bunch of form variables - no need to use request.yaddaYaddaYadda. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Convert Image to Binary
Hi All, I am trying to store the image file into sql database in a binary form. I can sucessfully browse image, read it and display in the browser but unable to convert it into binary. This is wat I did variable update table1 set Logo='#FinalImage#' where Name='John' but I am unable to save into the database and when I am trying to save it pops up say: ByteArray objects cannot be converted to strings. I tried using toString etc.. Datatype for this column is varBinary(MAX). Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Convert Image to Binary
variable update table1 set Logo='#FinalImage#' where Name='John' I am getting an error: ByteArray objects cannot be converted to strings. I tried with tostring etc.. but didnt work Datatype for this column is varBinary(MAX). Any sugestions Thanks, Priya. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Session Variable not being set - variable created during processing
Where are you setting this variable ' SESSION.consumerProduct.Cnsmr_ProductID ' prior to this block of code? William -Original Message- From: Fawzi Amadu [mailto:abd...@gmail.com] Sent: Thursday, February 26, 2009 6:43 AM To: cf-talk Subject: Session Variable not being set - variable created during processing I am trying to assign the value generated for the variable filename to a session variable, but when I process the page, Coldfusion reports that: "The form field SESSION.consumerProductExtraImg.Img1 did not contain a file." yet I had uploaded files. What am I doing wrong? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cfchart and cfdocument
The problem I have is that when I move the code to my live server, it doesn't show the graph, I just get the little red arrow symbol. It works fine in the dev enviroment The only difference is my production environment is running https My guess is that. Therefore, there's a difference between the two environment, but I can find no documentation on the matter. Does anyone have any thoughts on this? -- View this message in context: http://www.nabble.com/Cfchart-and-cfdocument-tp8098p8098.html Sent from the Cold Fusion - Technical mailing list archive at Nabble.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajax and special characters
thanks to both of you for your comments we will look into these in relation to the client side - when we want to send data to coldfusion do you only use the escape function in Javascript or do you use some other means? thanks >In addition to Cutter's points about JSON encoding, look into the >URLEncodedFormat and URLDecode. > >If, when making your Ajax calls, you pass the returnFormat = "JSON" >attribute to your CFC method, then CF will automatically encode the result >when creating the JSON output. When passing a JSON value to ColdFusion, >inside your CFC method you can use the DeserializeJson() method to decode >the value. > >Steve "Cutter" Blades >Adobe Certified Professional >Advanced Macromedia ColdFusion MX 7 Developer > >Co-Author of "Learning Ext JS" >http://www.packtpub.com/learning-ext-js/book >_ >http://blog.cutterscrossing.com > >Richard White wrote: >> hi >> >> we are developing an Ajax based system using JavaScript and Coldfusion. >> >> we have only just started to realise the need for escaping / encoding >special characters. how do you guys deal with this, e.g: >there may be to understand this. >> >> thanks >> >> richard >> >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Session Variable not being set - variable created during processing
I am trying to assign the value generated for the variable filename to a session variable, but when I process the page, Coldfusion reports that: "The form field SESSION.consumerProductExtraImg.Img1 did not contain a file." yet I had uploaded files. What am I doing wrong? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query of Queries Functions
Cool. The help is really appreciated. What a great resource. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query of Queries Functions
Although you can't DELETE a record from a QoQ, you can SELECT all other records and save them into the same QoQ variable. In other words, instead of removing the unwanted records, just select all of the wanted records. Thanks, Mike -Original Message- From: Ron Gruner [mailto:webmas...@gruner.com] Sent: Thursday, February 26, 2009 8:23 AM To: cf-talk Subject: Re: Query of Queries Functions There's no obvious way to delete a QofQ row. Am I missing something? 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query of Queries Functions
There's no obvious way to delete a QofQ row. Am I missing something? 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to Form variables from: request.servletEvent.getValue('fieldName')
I need to pass the variables from a third party application form to my own cfmail. The third party app states them as (3fname, lname, address, state, city, zip, email') The form variables are accessible in the request scope or in the request.serlvetEvent.getValue('fieldName') Would they be accessible if you used this way? #request.serlvetEvent.getValue('fname')# #request.serlvetEvent.getValue('lname')# SELECT * FROM recipients Dear #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# , This is my written note. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# 2. I need to pass the ', is there a specific method I need to use to call up the sava form variables in my own cfmail? All of your form variables are accessible in the request scope or in the request.serlvetEvent.getValue('fieldName') ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query of Queries Functions
On Thu, Feb 26, 2009 at 6:35 AM, Ron Gruner wrote: > > Thanks Matt. Is there some other way to build a small and temporary database > that resides in RAM and can be manipulated with all, or most, SQL functions? > I suppose Structures is the best approach but they're new for me. > Yes, you could do structures or an array of structures. If temporary is all you need and not actual database persistence, you can work with the query result set also. You can manipulate data in that with QuerySetCell. You can also add rows and columsn with QueryAddRow and QueryAddColumn. Check the docs for actual usage and examples. -- Matt Williams "It's the question that drives us ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query of Queries Functions
Thanks Matt. Is there some other way to build a small and temporary database that resides in RAM and can be manipulated with all, or most, SQL functions? I suppose Structures is the best approach but they're new for me. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query of Queries Functions
On Thu, Feb 26, 2009 at 5:56 AM, Ron Gruner wrote: > > Is there a way to do SQL Updates and Deletes on record sets organized as > Query of Queries? It seems that only SELECT works. I'm using CF8. > A query of queries does not make a connection to the actual database. It is only a way to further filter previously retrieved record sets. So no, you cannot do updates or deletes. -- Matt Williams "It's the question that drives us ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query of Queries Functions
Is there a way to do SQL Updates and Deletes on record sets organized as Query of Queries? It seems that only SELECT works. I'm using CF8. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Beginning Flex
I've just started working through Flex 3 in Action, which looks good so far. The From the Source books are usually good too. You might also want to delve into AS - I've been reading Essential ActionScript 3.0. BTW, playing around last night I discovered if you have Adobe media player, you can watch all the flex in a week vids offline, as well as all the adobe tv stuff. Lot's of Flex sessions from Max on there. Cheers Will -Original Message- From: Jen Perkins [mailto:snarkmeis...@gmail.com] Sent: 26 February 2009 00:55 To: cf-talk Subject: RE: Beginning Flex Thanks everyone! I'm running through the Flex in a week videos now (thanks a bunch, Will!) and planning on buying a book or two on Amazon. Unfortunately I don't think in-person training will work at this time (small company, small budget, bad economy...plus, surprisingly few training options in the bay area, apparently). Can anyone recommend a good book for n00bs? I'm thinking of picking up the Flex for Dummies; I love the format of those books. Any other strong recommendations? Jen Perkins Adobe Certified ColdFusion Developer Senior Developer, iArchitects http://www.iarchitects.com iArchitects :: Your Internet Solutions Team Architecting Internet Solutions since 1999 -Original Message- From: Will Swain [mailto:w...@hothorse.com] Sent: Wednesday, February 25, 2009 2:01 PM To: cf-talk Subject: RE: Beginning Flex Before shelling out for lynda check out the Flex in a week videos: http://www.adobe.com/devnet/flex/videotraining/ And the adobe tv videos: http://tv.adobe.com/#pd+Flex The lynda training does seem to be very good, and it's probably still worth paying for, but I'd suggest running through those Adobe videos first - why look a gift horse in the mouth? Cheers Will -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: 25 February 2009 19:51 To: cf-talk Subject: Re: Beginning Flex I'm with Dave and Gerald... As a Lifelong CF developer moving into Flex was extremely odd. Lynda.com has EXCELLENT training videos, but alot of your questions aren't really going to be answered there. I would recommend either paid instructor led training or joining your local Flex/Flash/Adobe User Group and try to pick some brains there. These mailing lists can be helpful, but it doesn't compare to the one on one interaction you need to get you over many of the early hurdles you will likely encounter in learning Flex. http://www.lynda.com http://groups.adobe.com =] On Wed, Feb 25, 2009 at 12:43 PM, Gerald Guido wrote: > > >> I'm just.lost. Can y'all pretend I am a total idiot & explain this > >> to > me > with very small words, pretty please? > > Can do ;) > > >>get started with Flex > > I would HIGHLY recommend the Lynda.com Flex 3 Essential Training and > Beyond the Basics (BTB) series. > http://www.lynda.com/home/DisplayCourse.aspx?lpk2=438 > http://www.lynda.com/home/DisplayCourse.aspx?lpk2=437 > > I am in the middle of Flex Essential Training right now and it will > get you up to speed quickly using (to the best of my knowledge) best > practices. I have been going through Lynda's CF8 BTB and it is spot > on. High quality stuff delivered in manageable chunks. All I can say > is that I wish I had known about it when I started off using CFC's and learning OO CF. > > For $25 per month you really can't beat the online training library in > terms of "bang for the buck" (Provided you have a high speed > connection). > > HTH > > G! > > On Wed, Feb 25, 2009 at 2:12 PM, Jen Perkins > wrote: > > > I'm just.lost. Can y'all pretend I am a total idiot & explain this > > to me with very small words, pretty please? > > > > > > -- > Gerald Guido > http://www.myinternetisbroken.com > > > "To invent, you need a good imagination and a pile of junk." > -- Thomas A. Edison > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4