INSERT INTO from another table
Was just reading how to do an INSERT INTO from another table in SQL Server 2000 (like SELECT INTO, but without creating a new table) like this: INSERT INTO tablename (the table you want to copy into) SELECT * from tablename (the table you want to copy from) WHERE Field = (some condition) and wanted to know if I could add a field (like a date/time stamp) of when this data was inserted as part the same query? If not, is there an equivalent in CF7 for result_name.IDENTITYCOL type of variable after an insert? Something at the Java level perhaps? My ultimate goal is to backup a row of data from one table to another, and also add a datestamp of when it was backed up to that table. I'd like to have an extra field in the target backup table that can hold the datestamp, but it appears INSERT INTO won't work unless the target table has the exact same fields (and no extra fields - not sure why it cares about that). Is there a better way to do this? I was hoping to keep the copy in the database instead of selecting fields into CF variables, and then inserting those, but I'll do that if necessary. Thanks, Dan ~| 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:316238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: INSERT INTO from another table
Sure, just explicitly list your columns. In fact, I would recommend ALWAYS doing that since if you script a table and the columns get into an different order it will really screw up your insert into table select * stuff. Just do this: INSERT INTO backup_name (col1,col2,col3,timestamp) (SELECT col1,col2,col3,getdate() FROM source_table WHERE col1 = 'filtervalue') ~Brad - Original Message - From: Dan LeGate [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, December 04, 2008 2:50 AM Subject: INSERT INTO from another table Was just reading how to do an INSERT INTO from another table in SQL Server 2000 (like SELECT INTO, but without creating a new table) like this: ~| 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:316239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advertisment Content Management - problem with random image
Yea you're right Ike. Story of my life - I relax for once and make a smart-alec comment and it whips around and bites me. But in my own defence, mine takes less typing! LOL . Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 4, 2008 at 5:50 PM, s. isaac dealey [EMAIL PROTECTED] wrote: Mike Kear said: Ike, your query will still attempt to select records that have been deleted The original problem was that the keys werent sequential if some records have been deleted. That's going to happen as ads are removed. Using the technique I use, it selects a random record from the records that exist in the table, whether sequential or not. Umm... nope... non-sequential keys won't be an issue with the solution I posted because I used a randrange against the number of records in the query and then fetched the ID from that record using array-notation, so the ID is guaranteed to be in that query when it performs the 2nd fetch. Ike, your solution requires two trips to the database, mine requires one. So . my dad can beat your dad . nyah nyah nyah !! g Heh... you need to get your eyes checked. The 2nd query is a query of query. :) The only real issue he might have with it is that he might want to see ads removed immediately when he deletes them in his app and that code won't remove them right away, it'll wait until the following day. And that actually means that my code would be making a LOT fewer trips to the database in total (1 per day instead of 1 per request). ;) But he could of course reduce the cache duration and have the changes show up every hour or so if he didn't want to either throw away all the cache or produce a more complicated solution for invalidating the cache. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Create PDF from hyperlink
Put this on the page you are working on. Put the content that you want in the pdf in the cfsavecontent block. cfoutput a href=#Script_Name#?action=gimmie/a /cfoutput cfsavecontent variable=MyContent Your content goes here /cfsavecontent cfoutput #MyContent# /cfoutput cfif URL.Action EQ gimmie cfdocument format = PDF overwrite = yes encryption = none fontembed = yes backgroundvisible = no margintop =0.20 marginleft=0.20 marginright=0.20 #MyContent# /cfdocument /cfif On Wed, Dec 3, 2008 at 11:11 PM, Steve Sequenzia [EMAIL PROTECTED] wrote: I am looking for some help getting on creating a pdf from a hyperlink. I need to it to use content on the same page for the pdf. I do not want the entire page created as a pdf just a section of the page. Can someone please point me in the right direction for this. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument with small images has large filesize
Thanks, Jayesh. Hi Brad, This is a known issue to us. We already have a bug logged for the same. Thanks Jayesh Viradiya Adobe CF Team I am having an issue with large file sizes on pdf documents created with cfdocument. I have narrowed the issue down to images as the file size culprit (or at least the only difference I can tell). The content being fed to cfdocument is otherwise unremarkable html. The images (jpeg's, all) are roughly 30kb each and size appropriately after the pdf is created, so no problems there. The html file is small, around 2 or 3kb, excluding the references images. The issue comes in when the cfdocument constructs the pdf file. pdf file size without images is around 15 - 30kb. Adding 1 image to the html increases the pdf file size to about 250kb... adding 5 pushes it to around 1.5Mb - About 150 - 160k is increased in size 10-fold. If I use some other external pdf writer to manually do the same thing, the file size is (in my mind) a more appropriate 175kb. I haven't found very much in the way of a possible solution or the root of the problem by trawlling around. I wonder if anyone has encountered this or has any insight? Thanks! ~Brad ~| 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:316242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Adobe's CF IDE, Bolt
So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( Rick ~| 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:316243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
I signed up for the beta. No word from the mothership yet. On Thu, Dec 4, 2008 at 8:36 AM, Rick Faircloth [EMAIL PROTECTED]wrote: So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( Rick ~| 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:316244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
On Thu, Dec 4, 2008 at 2:39 PM, John M Bliss [EMAIL PROTECTED] wrote: I signed up for the beta. No word from the mothership yet. Ditto. -- mac jordan www.webhorus.net | www.reactivecooking.com | www.nibblous.com | www.jordan-cats.org ~| 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:316245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe's CF IDE, Bolt
Had there been word, Adobe's normal NDA would prevent you from saying so. -Original Message- From: mac jordan [mailto:[EMAIL PROTECTED] Sent: Thu 12/4/2008 14:47 To: cf-talk Subject: Re: Adobe's CF IDE, Bolt On Thu, Dec 4, 2008 at 2:39 PM, John M Bliss [EMAIL PROTECTED] wrote: I signed up for the beta. No word from the mothership yet. Ditto. -- mac jordan www.webhorus.net | www.reactivecooking.com | www.nibblous.com | www.jordan-cats.org ~| 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:316246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( I'm not - not even sure if I'm going to until I see a good reason to change from CFEclipse and Notepad. ~| 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:316247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe's CF IDE, Bolt
+1 -Original Message- From: John M Bliss [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 6:39 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I signed up for the beta. No word from the mothership yet. On Thu, Dec 4, 2008 at 8:36 AM, Rick Faircloth [EMAIL PROTECTED]wrote: So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( Rick ~| 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:316248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe's CF IDE, Bolt
I'm not saying anything. ;^) -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 8:49 AM To: cf-talk Subject: RE: Adobe's CF IDE, Bolt Had there been word, Adobe's normal NDA would prevent you from saying so. ~| 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:316249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
uploading file on a different server using cffile
HI everybody Is there a way of uploading file on a different server other than what i'm using.. if i try to upload it locally with a cffile it works but my plan is uploading it to another one because of space problems.. thanks for any help ~| 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:316250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Named arguments, UDFs, Request scope
There is/was a problem in CF7 regarding using named arguments to call UDFs that were in the request scope (also mentioned here, for reference http://www.coldfusionjedi.com/index.cfm/2005/10/27/CFMX-7-and-Super-Fixes). The function produces this error, Cannot invoke method [x] on an object of type coldfusion.runtime.Struct with named arguments. Does anyone know if a fix was ever produced for it? Or must I use ordered arguments? Michael ~| 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:316251 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
And ditto ... ~| 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:316252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Named arguments, UDFs, Request scope
There is/was a problem in CF7 regarding using named arguments to call UDFs that were in the request scope (also mentioned here, for reference http://www.coldfusionjedi.com/index.cfm/2005/10/27/CFMX-7-and-Super-Fixes). The function produces this error, Cannot invoke method [x] on an object of type coldfusion.runtime.Struct with named arguments. Does anyone know if a fix was ever produced for it? Or must I use ordered arguments? Michael ~| 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:316253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: uploading file on a different server using cffile
Is there a way of uploading file on a different server other than what i'm using.. if i try to upload it locally with a cffile it works but my plan is uploading it to another one because of space problems.. Well, the file will initially be uploaded to your server, because that's where the form post is going. However, you could then save the uploaded file to another server; when you use CFFILE ACTION=UPLOAD, you're actually just saving the file that's already been uploaded. For this to work, the CF server will need to have permission to write to a remote share. For CF to have this permission, you will have to run it with a user account that has that permission. 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:316254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
Well, if there's a lot who say they haven't gotten the beta... Tom Chiverton wrote: Had there been word, Adobe's normal NDA would prevent you from saying so. -Original Message- From: mac jordan [mailto:[EMAIL PROTECTED] Sent: Thu 12/4/2008 14:47 To: cf-talk Subject: Re: Adobe's CF IDE, Bolt On Thu, Dec 4, 2008 at 2:39 PM, John M Bliss [EMAIL PROTECTED] wrote: I signed up for the beta. No word from the mothership yet. Ditto. ~| 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:316256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Named arguments, UDFs, Request scope
Oops, browser was set to auto-refresh, hence the double post. Sorry 'bout that... ~| 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:316257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe's CF IDE, Bolt
Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 8:37 AM To: cf-talk Subject: Adobe's CF IDE, Bolt So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( Rick ~| 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:316258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
i was under the impression that at MAX they announced an alpha/beta wouldn't be available 'til early 2009. On Thu, Dec 4, 2008 at 7:49 AM, Rick Faircloth [EMAIL PROTECTED]wrote: Well, if there's a lot who say they haven't gotten the beta... Tom Chiverton wrote: Had there been word, Adobe's normal NDA would prevent you from saying so. -Original Message- From: mac jordan [mailto:[EMAIL PROTECTED] Sent: Thu 12/4/2008 14:47 To: cf-talk Subject: Re: Adobe's CF IDE, Bolt On Thu, Dec 4, 2008 at 2:39 PM, John M Bliss [EMAIL PROTECTED] wrote: I signed up for the beta. No word from the mothership yet. Ditto. ~| 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:316259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Named arguments, UDFs, Request scope
@Dominic Nice idea! Same result though :-( ~| 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:316260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? It's an Eclipse plugin, so I'd guess the former. Altho I'm sure anyone would be welcome to use it :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
from what I understand, from reading the little bit of internet scuttlebutt that's out there,.. it's supposed to be the CF Studio Replacement What that means... who knows? Billy Cox wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 8:37 AM To: cf-talk Subject: Adobe's CF IDE, Bolt So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( Rick ~| 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:316262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to me... Charlie Griefer wrote: On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? It's an Eclipse plugin, so I'd guess the former. Altho I'm sure anyone would be welcome to use 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:316263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe's CF IDE, Bolt
Bolt is only the code name, I guess, so the clash doesn't matter. -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Thu 12/4/2008 15:52 To: cf-talk Subject: RE: Adobe's CF IDE, Bolt Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. 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 together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Named arguments, UDFs, Request scope
I'm not sure, but have you tried something like: cfset args = StructNew() / cfset args.foo = bar / cfset args.bar = foo / cfset result = request.myUdf( argumentCollection=args ) / Quite possibly brings out the same result but worth a shot... Dominic ~| 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:316255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Apache Roller on JRun
Has anyone deployed Apache Roller http://roller.apache.org/ on a ColdFusion installation? I'm wondering how to install and configure it for JRun but I've found no luck with a google search on the topic. ~| 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:316265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe's CF IDE, Bolt
I wouldn't want *my* IDE to share a name with a stupid movie. It wasn't a stupid movie. IMHO it was actually rather good... and it was about BOLT having superpowers, as I hope the new BOLT IDE does. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:316266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
inserting null values
I have a form which is throwing the following error upon submit: Element NAME is undefined in FORM The field is set to allow nulls in the database. Is there something else I should be doing to allow a null value to be passed? Thanks ~| 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:316267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: inserting null values
that's got nothing to do with your database. you're referencing a form field (#form.name#) that doesn't exist. according to the error, you have no form field with the name name. if there is one and it's a checkbox or radio group (and none are checked or selected), they don't get passed into the form scope. you'll need to param them in the form's action: cfparam name=form.name default= type=string / bear in mind that this is not a NULL value. it's an empty string. if you want to insert a true NULL into the database, you'll need to do: cfqueryparam value=#form.name# cfsqltype=cf_sql_char null=#not len(trim(form.name))# / On Thu, Dec 4, 2008 at 8:17 AM, John P [EMAIL PROTECTED] wrote: I have a form which is throwing the following error upon submit: Element NAME is undefined in FORM The field is set to allow nulls in the database. Is there something else I should be doing to allow a null value to be passed? Thanks ~| 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:316268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe's CF IDE, Bolt
So, then it would be called EF Studio? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to 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:316269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: inserting null values
Thanks Charlie, it was a group of radio buttons. cfparam name=form.name default= type=string / did the trick. that's got nothing to do with your database. you're referencing a form field (#form.name#) that doesn't exist. according to the error, you have no form field with the name name. if there is one and it's a checkbox or radio group (and none are checked or selected), they don't get passed into the form scope. you'll need to param them in the form's action: cfparam name=form.name default= type=string / bear in mind that this is not a NULL value. it's an empty string. if you want to insert a true NULL into the database, you'll need to do: cfqueryparam value=#form.name# cfsqltype=cf_sql_char null=#not len(trim(form.name))# / On Thu, Dec 4, 2008 at 8:17 AM, John P [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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfloop to list
I have a form that is using a cfloop query to produce a input field for productid quantity. It can produce several input fields depending on the query. Example - tdinput type=text size=3 name=QTY_cfoutput#prodid#/cfoutput/td In the submit processing page I need to take the productid's that have a value to insert into the database. I have created a list (Plist) from the form submitted, Plist===QTY_101,QTY_102,QTY_103 Then I loop through to take out only the fields that have a value, cfloop list=#plist# index=z cfif evaluate(form.qty_#z#) GTE 1 cfoutput#z#-#evaluate(form.qty_#z#)# br //cfoutput cfset zlist = #evaluate(form.qty_#z#)# cfset zlist = ListAppend(zlist, #z#) /cfif /cfloop The problem I am having is how do I make a list so when i do the update query I can insert the product id and the quantity. ~| 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:316272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cfcontent MS Excel 2007 errors?
I'm using cfcontent to generate reports in MS Excel. Previously the useres had MS Excel 2003 to open the files, but now, some have upgraded to MS excel 2007 and they are getting error messages. They are along the lines of The xxx.cfm file you are attempting to download is incompatible with 2007. The file may be corrupt. After the user clicks okay, the spreadsheet opens up fine. Has anyone else run into issues with CFcontent and Excell 2007? Thanks ~| 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:316271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
Sounds good to me... hopefully, short for Everyone's Favorite Studio... Dawson, Michael wrote: So, then it would be called EF Studio? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to 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:316273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFDIV won't bind hidden elements in IE
I am using a CFDiv to bind a cfselect in a form. Some of the form fields are hidden when the page loads. For Firefox, Chrome and Opera this isn't a problem. In IE, all the binds fail because it can't find the hidden cfdivs. I tried setting bindonload=false which did remove half of the errors but then the cfdivs didn't work at all. Any work arounds for this? If you want to see how this should be working, go through our checkout process at www.aquinasandmore.com using a non-IE browser. I have temporarily disabled the gift wrap display option in IE. ~| 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:316274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe's CF IDE, Bolt
You realize that Eclipse has code folding right? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to me... Charlie Griefer wrote: On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? It's an Eclipse plugin, so I'd guess the former. Altho I'm sure anyone would be welcome to use 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:316275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
he wants it to remember the stuff he folded (e.g. select code, collapse, close IDE, take a nap, walk the dog, open IDE, open file, and the folded code will still be folded). he's mentioned it on the cfeclipse mailing list once or twice :) On Thu, Dec 4, 2008 at 9:57 AM, Andy Matthews [EMAIL PROTECTED]wrote: You realize that Eclipse has code folding right? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to me... Charlie Griefer wrote: On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? It's an Eclipse plugin, so I'd guess the former. Altho I'm sure anyone would be welcome to use 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:316276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
1) 'Bolt' was a good movie. 2) 'Bolt' (the IDE codename) is probably a reference to the logo that ColdFusion had in the Allaire days. I'm hoping the keep the codename, and start 'branding' ColdFusion again. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Billy Cox wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 8:37 AM To: cf-talk Subject: Adobe's CF IDE, Bolt So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( Rick ~| 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:316277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
No abbreviations. Flat out: Elmer Fudd Studio I'd buy that for a dollar. In the spirit of Blue Monster Reserve http://www.gapingvoid.com/Moveable_Type/archives/004170.html G! On Thu, Dec 4, 2008 at 11:40 AM, Dawson, Michael [EMAIL PROTECTED]wrote: So, then it would be called EF Studio? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to 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:316278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
While it does offer manual folding, it doesn't maintain the folds when a file is closed...that's worthless... Andy Matthews wrote: You realize that Eclipse has code folding right? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to me... Charlie Griefer wrote: On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? It's an Eclipse plugin, so I'd guess the former. Altho I'm sure anyone would be welcome to use 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:316279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Microsoft SQL Server JDBC Driver and Authentication
I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service login which is an Active Directory account). I'm trying to run a cfquery passing a specific user's credentials to the query, like this (I've changed username and password to protect the innocent ;) ): cfquery datasource=MyDSN name=testQuery username=MyDomain\UserName password=MyPassword I have the SQL Server Profiler open running a trace on the target database. When I run the CFM page and execute the query, the trace shows that ColdFusion is still using the ColdFusion service login to run the query, instead of the user I passed to CFQUERY. Is there something else I need to do to make this work? Thanks, Carl ~| 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:316280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
Bolt would be an okay name...but I still like Elmer Fudd Studio. :o) Cutter (CFRelated) wrote: 1) 'Bolt' was a good movie. 2) 'Bolt' (the IDE codename) is probably a reference to the logo that ColdFusion had in the Allaire days. I'm hoping the keep the codename, and start 'branding' ColdFusion again. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Billy Cox wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 8:37 AM To: cf-talk Subject: Adobe's CF IDE, Bolt So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( Rick ~| 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:316281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
Worthless to have persistent folding? While I never have used it, even though it does exist in DW which I do use, I could see how some people might like it after having it. If perhaps they are working on something that they cannot finish in one day and they do not leave their machine in stand by mode over night or over a weekend. I know I routinely work in files where I end up folding some large chunks of code so I can reference things in different sections, like a split window I suppose. But I always put my work laptop in stand by mode so never really cared if the folding stayed after closing a file since if I close it then I am done with whatever task I was trying to accomplish at that time. On Thu, Dec 4, 2008 at 12:19 PM, Rick Faircloth [EMAIL PROTECTED]wrote: While it does offer manual folding, it doesn't maintain the folds when a file is closed...that's worthless... Andy Matthews wrote: You realize that Eclipse has code folding right? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to me... Charlie Griefer wrote: On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? It's an Eclipse plugin, so I'd guess the former. Altho I'm sure anyone would be welcome to use 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:316282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
Well, I mean it's worthless in the manner I want to use it, not that it's worthless to everyone else... I use to organize, quickly scan, and navigate sections of code, especially when I first open a file. Aaron Rouse wrote: Worthless to have persistent folding? While I never have used it, even though it does exist in DW which I do use, I could see how some people might like it after having it. If perhaps they are working on something that they cannot finish in one day and they do not leave their machine in stand by mode over night or over a weekend. I know I routinely work in files where I end up folding some large chunks of code so I can reference things in different sections, like a split window I suppose. But I always put my work laptop in stand by mode so never really cared if the folding stayed after closing a file since if I close it then I am done with whatever task I was trying to accomplish at that time. On Thu, Dec 4, 2008 at 12:19 PM, Rick Faircloth [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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft SQL Server JDBC Driver and Authentication
I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service login which is an Active Directory account). I'm trying to run a cfquery passing a specific user's credentials to the query, like this (I've changed username and password to protect the innocent ;) ): cfquery datasource=MyDSN name=testQuery username=MyDomain\UserName password=MyPassword I have the SQL Server Profiler open running a trace on the target database. When I run the CFM page and execute the query, the trace shows that ColdFusion is still using the ColdFusion service login to run the query, instead of the user I passed to CFQUERY. Is there something else I need to do to make this work? I don't think CF will pass the username and password attributes to the database if you're using Windows authentication via JDBC. I don't think you can specify a user account other than the service account when using Windows authentication via JDBC. I think that the only way you can do this is to set up an ODBC datasource that uses Windows authentication, then use CF to connect to that using the SequeLink JDBC-ODBC bridg (ODBC Socket in the CF Administrator). All that said, even if you can pass user credentials to the database, that may cause a serious degradation in performance, as database connections can no longer be shared across requests unless those requests come from the same user. 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:316284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem reading in XML
http://sph.umd.edu/news/blog2.cfm I am recreating a blog. I am able to read in several xml files and populate the content. To do this, I copied code from other functionality and it's using CFHTTP. In the blog's functionality, I'm supposed to be able to click on the title of a posting to bring it up by itself, instead of with all the other posts. I am having a problem only for that bit of functionality. When I load a page the first time and click on a posting, I receive the error: Error An error occured while Parsing an XML document. Content is not allowed in prolog. If I then refresh the page that gave the error, it then loads fine - just not the first time. The other times that I read in content, this doesn't happen. I can go to other pages to find this error too by clicking on one of the archive months to the right. That allows me to reproduce the error more often. Here's the code that I'm using cfhttp url=http://sphumd.blogspot.com/feeds/posts/default/ #url.postID# resolveurl=no timeout=120 / cfset XMLText = cfhttp.fileContent / cfset nodeToReplace = mid(XMLText, 1, evaluate(find(?, XMLText) + 1)) cfset XMLText = replaceNoCase(XMLText, nodeToReplace, , ALL) cfset parsed = XMLParse(XMLText) The error is stating that it's having problems with the last line. This code is the same code that works on all the other times that I read in the data. -- Daniel Kessler University of Maryland College Park School of Public Health 3302E SPH 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Microsoft SQL Server JDBC Driver and Authentication
I tested a little bit further by going into SQL Server Management Studio and removing permissions to the database for the ColdFusion service login account. When I attempt to run the query, it does attempt to use the username I'm passing, but then gives me an error: Cannot open database GDI requested by the login. The login failed. The only reason I was even trying this was to ensure secure access to a particular database that only certain users have permissions to write to. I guess I'll have to manage the permissions through my CF application, rather than at the SQL Server level. Is this how most developers deal with data security? Carl I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service login which is an Active Directory account). I'm trying to run a cfquery passing a specific user's credentials to the query, like this (I've changed username and password to protect the innocent ;) ): cfquery datasource=MyDSN name=testQuery username=MyDomain\UserName password=MyPassword I have the SQL Server Profiler open running a trace on the target database. When I run the CFM page and execute the query, the trace shows that ColdFusion is still using the ColdFusion service login to run the query, instead of the user I passed to CFQUERY. Is there something else I need to do to make this work? I don't think CF will pass the username and password attributes to the database if you're using Windows authentication via JDBC. I don't think you can specify a user account other than the service account when using Windows authentication via JDBC. I think that the only way you can do this is to set up an ODBC datasource that uses Windows authentication, then use CF to connect to that using the SequeLink JDBC-ODBC bridg (ODBC Socket in the CF Administrator). All that said, even if you can pass user credentials to the database, that may cause a serious degradation in performance, as database connections can no longer be shared across requests unless those requests come from the same user. 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:316286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Microsoft SQL Server JDBC Driver and Authentication
You can use Windows authentication with JDBC. In the Advanced Settings Connection String box, enter in: AuthenticationMethod=Type2 Then, clear any username/password from that DSN. (Just to be sure.) Confirm that your CF service account can access SQL Server's databases. Then, Bob's your uncle! (This was confirmed with Windows Server 2003, SQL Server 2005, CF 8 Standard/Enterprise and the JDBC drivers that came with CF.) Mike -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 12:47 PM To: cf-talk Subject: Re: Microsoft SQL Server JDBC Driver and Authentication I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service login which is an Active Directory account). I'm trying to run a cfquery passing a specific user's credentials to the query, like this (I've changed username and password to protect the innocent ;) ): cfquery datasource=MyDSN name=testQuery username=MyDomain\UserName password=MyPassword I have the SQL Server Profiler open running a trace on the target database. When I run the CFM page and execute the query, the trace shows that ColdFusion is still using the ColdFusion service login to run the query, instead of the user I passed to CFQUERY. Is there something else I need to do to make this work? I don't think CF will pass the username and password attributes to the database if you're using Windows authentication via JDBC. I don't think you can specify a user account other than the service account when using Windows authentication via JDBC. I think that the only way you can do this is to set up an ODBC datasource that uses Windows authentication, then use CF to connect to that using the SequeLink JDBC-ODBC bridg (ODBC Socket in the CF Administrator). All that said, even if you can pass user credentials to the database, that may cause a serious degradation in performance, as database connections can no longer be shared across requests unless those requests come from the same user. 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:316287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Microsoft SQL Server JDBC Driver and Authentication
Ooops. I missed a critical part of your message. You said you did get Windows Authentication to work, but you want to specify individual credentials, per query. Sorry for the confusion. However, one thing you may try is create a domain group, then grant database access to that group. In that group, add your users. Then, try to connect using your method. If domain\user doesn't work, try the userPrincipalName ([EMAIL PROTECTED]). Also, if you are saying the DSN is still using the CF service's credentials, you should break it so that it never works, such as specifying an incorrect username/password, in the DSN settings. Then, your CF code should override, if it works. Mike -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 1:03 PM To: cf-talk Subject: RE: Microsoft SQL Server JDBC Driver and Authentication You can use Windows authentication with JDBC. In the Advanced Settings Connection String box, enter in: AuthenticationMethod=Type2 Then, clear any username/password from that DSN. (Just to be sure.) Confirm that your CF service account can access SQL Server's databases. Then, Bob's your uncle! (This was confirmed with Windows Server 2003, SQL Server 2005, CF 8 Standard/Enterprise and the JDBC drivers that came with CF.) Mike -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 12:47 PM To: cf-talk Subject: Re: Microsoft SQL Server JDBC Driver and Authentication I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service login which is an Active Directory account). I'm trying to run a cfquery passing a specific user's credentials to the query, like this (I've changed username and password to protect the innocent ;) ): cfquery datasource=MyDSN name=testQuery username=MyDomain\UserName password=MyPassword I have the SQL Server Profiler open running a trace on the target database. When I run the CFM page and execute the query, the trace shows that ColdFusion is still using the ColdFusion service login to run the query, instead of the user I passed to CFQUERY. Is there something else I need to do to make this 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:316288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Microsoft SQL Server JDBC Driver and Authentication
If you have not created each user's SQL login, it won't work. However, I wouldn't want to have to manage all those SQL logins (and database permissions), in addition to their AD accounts. As I mentioned in another message, you may try adding a domain group as a SQL login/DB user. That said... I think most people use a single DSN user account to connect to their databases. That is how I operate. The good news is since you are on an Active Directory domain, you can leverage the strengths of AD to control access to your CF application. Create/organize domain groups that equate to the secured areas of your CF application. Then, use CFLDAP to retrieve the group membership and allow, or deny, the user when they attempt to access a secured area. ColdFusion and Active Directory can make a very-powerful alliance! Mike -Original Message- From: Carl Von Stetten [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 12:54 PM To: cf-talk Subject: Re: Microsoft SQL Server JDBC Driver and Authentication I tested a little bit further by going into SQL Server Management Studio and removing permissions to the database for the ColdFusion service login account. When I attempt to run the query, it does attempt to use the username I'm passing, but then gives me an error: Cannot open database GDI requested by the login. The login failed. The only reason I was even trying this was to ensure secure access to a particular database that only certain users have permissions to write to. I guess I'll have to manage the permissions through my CF application, rather than at the SQL Server level. Is this how most developers deal with data security? Carl ~| 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:316289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem reading in XML
May I ask why you are ditching the xml declaration before parsing the xml? Ie. these lines: cfset nodeToReplace = mid(XMLText, 1, evaluate(find(?, XMLText) + 1)) cfset XMLText = replaceNoCase(XMLText, nodeToReplace, , ALL) If you are on CF7 or greater, and there isn't a good reason to parse out the xml declaration, you can do this: cfset parsed= XmlParse(http://sphumd.blogspot.com/feeds/posts/default/#url.postId#;) / This never generates an error for me. HTH Dominic ~| 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:316290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Microsoft SQL Server JDBC Driver and Authentication
Ooops. I missed a critical part of your message. You said you did get Windows Authentication to work, but you want to specify individual credentials, per query. Sorry for the confusion. However, one thing you may try is create a domain group, then grant database access to that group. In that group, add your users. Then, try to connect using your method. If domain\user doesn't work, try the userPrincipalName ([EMAIL PROTECTED]). Also, if you are saying the DSN is still using the CF service's credentials, you should break it so that it never works, such as specifying an incorrect username/password, in the DSN settings. Then, your CF code should override, if it works. Mike You can use Windows authentication with JDBC. In the Advanced Settings Connection String box, enter in: AuthenticationMethod=Type2 Then, clear any username/password from that DSN. (Just to be sure.) Confirm that your CF service account can access SQL Server's databases. Then, Bob's your uncle! (This was confirmed with Windows Server 2003, SQL Server 2005, CF 8 Standard/Enterprise and the JDBC drivers that came with CF.) Mike I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service login which is an Active Directory account). I'm trying to run a cfquery passing a specific user's credentials to the query, like this (I've changed username and password to protect the innocent ;) ): cfquery datasource=MyDSN name=testQuery username=MyDomain\UserName password=MyPassword I have the SQL Server Profiler open running a trace on the target database. When I run the CFM page and execute the query, the trace shows that ColdFusion is still using the ColdFusion service login to run the query, instead of the user I passed to CFQUERY. Is there something else I need to do to make this work? Michael, The trick was passing the username as [EMAIL PROTECTED] rather than domain\user. I think, however, that your suggestion in the other post to use CF/LDAP within my application to enforce security will be a better option for me. Thanks for your help, Carl ~| 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:316291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
I wouldn't want *my* IDE to share a name with a stupid movie. It wasn't a stupid movie. IMHO it was actually rather good... and it was about BOLT having superpowers, as I hope the new BOLT IDE does. I thought it was about Bolt being deluded and only thinking he had superpowers. ;) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
Yea you're right Ike. Story of my life - I relax for once and make a smart-alec comment and it whips around and bites me. Yer lucky you added the my dad can beat up your dad comment at the end, otherwise I might not have picked up on the fact that you were jokin' around. :) But in my own defence, mine takes less typing! LOL . Works for me. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
Part of the larger WB Studio suite. :) So, then it would be called EF Studio? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to me... -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316294 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
sql query help
I have a MySQL query to pull all products from the database, no problem. I am trying to get it to only display prodcuts that are in stock, the value should be sold p.quantity in the following query. however, when sold appears as null (very often) it removes the full record, which I don't want. there has to be an easy way to do this... Here is my current query: cfquery name=rsproducts datasource=#application.db# SELECT SUM(o.qty) as sold, p.sku, p.name, p.points, p.short_description, p.quantity, p.image FROM tblproducts as p LEFT JOIN tblorder_list as o ON p.sku=o.sku #can_afford# GROUP BY p.sku /cfquery Thanks ~| 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:316295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
In the spirit of Blue Monster Reserve http://www.gapingvoid.com/Moveable_Type/archives/004170.html I think it's hilariously ironic that Microsoft employees are trying to change the world and convince the corporate suits to become more open and stop maintaining their monopoly-esque practices... and so this new spirit of openness is celebrated with a wine offering... that you can't have, nya nya! ;) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
coldfusion 8 line debugger freezes
Hello, Im new to this mailing list, so please go easy on me. :) I am having trouble running the coldfusion 8 line debugger against my application. After following the livedocs instructions and some instructions on forta.com, I got it up and running. The RDS connection tests fine, and in some cases the debugger has done what its supposed to. The problem I'm having is that in most instances the debugger seemingly freezes up on me before it reaches my breakpoint, and it sits and tries loading the page in the browser indefinitely. Im sure the fact that Im running a mach-ii application should be of no consequence. Has anyone here ran into the problem before? Any help would be greatly appreciated. -- Brian Pickens | Web Developer Phone: (701) 241-5759 Email: [EMAIL PROTECTED] --- A.A.S. - ECommerce Web Design --- Interactive Media Group Forum Communications Company 101 5th St. N. Fargo, ND 48102 ~| 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:316297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
coldfusion 8 line debugger freezing
Hello, Im new to this mailing list, so please go easy on me. :) I am having trouble running the coldfusion 8 line debugger against my application. After following the livedocs instructions and some instructions on forta.com, I got it up and running. The RDS connection tests fine, and in some cases the debugger has done what its supposed to. The problem I'm having is that in most instances the debugger seemingly freezes up on me before it reaches my breakpoint, and it sits and tries loading the page in the browser indefinitely. Im sure the fact that Im running a mach-ii application should be of no consequence. Has anyone here ran into the problem before? Any help would be greatly appreciated. ~| 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:316298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft SQL Server JDBC Driver and Authentication
The only reason I was even trying this was to ensure secure access to a particular database that only certain users have permissions to write to. I guess I'll have to manage the permissions through my CF application, rather than at the SQL Server level. Is this how most developers deal with data security? Yes, because of the database connection pooling issues I mentioned earlier. 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:316299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql query help
Try this, I think it's what you're looking for: SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points, p.short_description, p.quantity, p.image FROM tblproducts as p LEFT JOIN tblorder_list as o ON p.sku = o.sku #can_afford# WHERE SUM(ISNULL(o.qty, 0)) p.quantity GROUP BY p.sku ~| 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:316300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFEXCHANGECALENDAR Duplicate UID Values
In Exchange 2003, recurring events produce the same UID for each instance of the event. Even though each instance's start time is different, the UID is still the same. Therefore, it is impossible to uniquely identify a calendar item using only the UID. An example of the UID is: 04008200E00074C5B7101A82E00800C87FBB1756C901 10005DC8DACAED81684E92730F6ED8C598BD I created a sample, recurring event and this is the data that is returned from Exchange, via CFEXCHANGECALENDAR: UID: 04008200snip6ED8C598BD - STARTTIME: 2008-12-05 12:00:00.000 UID: 04008200snip6ED8C598BD - STARTTIME: 2008-12-12 12:00:00.000 UID: 04008200snip6ED8C598BD - STARTTIME: 2008-12-19 12:00:00.000 Given this example, how would I refer to the item on 2008-12-12? From my testing, the natural key would be a combination of UID + STARTTIME. Has anyone else run into this issue? If so, what did you do to workaround it? Thanks 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:316301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Open BlueDragon and Railo - ready?
Does anyone have experience or know if Open BlueDragon or Railo are suitable for use in a high traffic e-commerce site? During the busiest times there are about 100,000 visitors between 8 AM and 7 PM during a day. The highest concentration is between 10 AM and 2 PM. There are lots of graphics, SSL sessions, and some image manipulations (cropping, etc). I would like to use one of them due to the savings, but do not want to risk problems with some critical sites if they need more time to develop. I have not heard of either being used in this type of context, but may have missed hearing about that if it was posted. Thank you, David ~| 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:316302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe's CF IDE, Bolt
The formal Bolt beta has not yet started, so the fact that you've heard nothing yet does not mean that you won't be. Hang in there ... --- Ben -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 9:52 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( I'm not - not even sure if I'm going to until I see a good reason to change from CFEclipse and Notepad. ~| 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:316303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excel Workbook Creators
If you're interested, I've got some code for JExcelAPI that does stuff like take a structure of queries and turns them into sheets in a workbook, and vice versa. :Denny -- You will never do anything in this world without courage. It is the greatest quality of the mind next to honor. Aristotle On Tue, Dec 2, 2008 at 8:11 PM, Craigsell wrote: We currently have a CFMX7 application that uses Jakarta POI HSSF to create excel spreadsheets from a query. We initially chose POI because we wanted a higher degree of control over cell formatting (currency, date, etc) than what we could get in CFReport. The problem is that POI is eating memory. A two thousand row 24 column spreadsheet which saves out at 771kb takes over 120mb of memory during creation and is bringing our server down when we get multiple requests. We were looking for alternatives to POI. I found JExcel but I couldn't find any data to see if it was better on memory usage than POI. I suspect it won't be but I am also contemplating creating XML spreadsheets which I can send to the user zipped to compensate for the bigger size. I've done that before but I just would prefer the user to get an xls workbook rather than an xml one. Anyone have any experience with JExcel and how it compares to POI HSSF? Or another alternative I hadn't considered? Thanks! ~| 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:316304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFEXCHANGECALENDAR Duplicate UID Values
Dunno if it will help, but I've done some stuff with ical4j, and had a similar deal: http://m2.modularity.net.au/projects/ical4j/apidocs/index.html The text you're after may be: The full range of calendar components specified by a recurrence set is referenced by referring to just the UID property value corresponding to the calendar component. The RECURRENCE-ID property allows the reference to an individual instance within the recurrence set. HIH, :Denny -- Any commander who fails to exceed his authority is not of much use to his subordinates. Arleigh Burke On Thu, Dec 4, 2008 at 2:42 PM, Dawson, Michael wrote: In Exchange 2003, recurring events produce the same UID for each instance of the event. Even though each instance's start time is different, the UID is still the same. Therefore, it is impossible to uniquely identify a calendar item using only the UID. An example of the UID is: 04008200E00074C5B7101A82E00800C87FBB1756C901 10005DC8DACAED81684E92730F6ED8C598BD I created a sample, recurring event and this is the data that is returned from Exchange, via CFEXCHANGECALENDAR: UID: 04008200snip6ED8C598BD - STARTTIME: 2008-12-05 12:00:00.000 UID: 04008200snip6ED8C598BD - STARTTIME: 2008-12-12 12:00:00.000 UID: 04008200snip6ED8C598BD - STARTTIME: 2008-12-19 12:00:00.000 Given this example, how would I refer to the item on 2008-12-12? From my testing, the natural key would be a combination of UID + STARTTIME. Has anyone else run into this issue? If so, what did you do to workaround it? Thanks 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:316305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
onTap Framework - Soliciting Feedback
Hi all, So I'm getting ready to publish the results any my thoughts on the results of the framework survey that I posted a little while ago. I'd like to take a moment before I do however to solicit some more casual (less structured) feedback from the community. From those of you familiar with the onTap framework, I'd like to know in a general sense what your experience of it has been to date, including the technical aspects like does the Quick Start guide answer the right questions, etc. but also I'd like to know what your experience has been of the way I've presented it in the community. If there are particular things you liked or disliked about the way I've presented it, when and where I've presented it, etc. I'd like to hear your thoughts. Having a better understanding of the things that have either intrigued you or turned you off will help me both to improve the framework technically as well as to improve my communication skills and grow the community. :) And while I don't mind responses being posted to cf-talk (as long as Mike doesn't mind), feel free to email your response to me directly if you'd prefer to share your thoughts privately. Thanks, :) ike p.s. here's some info about the survey: http://ontap.riaforge.org/blog/index.cfm/2008/9/14/Framework-Survey -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe's CF IDE, Bolt
Thanks for the info, Ben! Rick -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 6:59 PM To: cf-talk Subject: RE: Adobe's CF IDE, Bolt The formal Bolt beta has not yet started, so the fact that you've heard nothing yet does not mean that you won't be. Hang in there ... --- Ben ~| 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:316307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDIV won't bind hidden elements in IE
care to post a code sample or a simple test case? i do not recall having a problem in any browser with binding hidden elements... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Ian Rutherford wrote: I am using a CFDiv to bind a cfselect in a form. Some of the form fields are hidden when the page loads. For Firefox, Chrome and Opera this isn't a problem. In IE, all the binds fail because it can't find the hidden cfdivs. I tried setting bindonload=false which did remove half of the errors but then the cfdivs didn't work at all. Any work arounds for this? If you want to see how this should be working, go through our checkout process at www.aquinasandmore.com using a non-IE browser. I have temporarily disabled the gift wrap display option in IE. ~| 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:316308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop to list
in the form's action page, loop through #form.fieldnames#, if the fieldname starts with qty_ and has a value - get the prodid from field name using removechars() or listlast() and update the db. something like this: cfloop list=#form.filednames# index=field cfif left(field, 4) is QTY_ AND int(val(form[field])) GTE 1 cfquery datasource=... INSERT INTO yourtable (product_id , quantity) VALUES ( cfqueryparam cfsqltype=cf_sql_integer value=#listlast(field, _)# , cfqueryparam cfsqltype=cf_sql_integer value=#form[field]# ) /cfquery /cfif /cfloop Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Sham Rock wrote: I have a form that is using a cfloop query to produce a input field for productid quantity. It can produce several input fields depending on the query. Example - tdinput type=text size=3 name=QTY_cfoutput#prodid#/cfoutput/td In the submit processing page I need to take the productid's that have a value to insert into the database. I have created a list (Plist) from the form submitted, Plist===QTY_101,QTY_102,QTY_103 Then I loop through to take out only the fields that have a value, cfloop list=#plist# index=z cfif evaluate(form.qty_#z#) GTE 1 cfoutput#z#-#evaluate(form.qty_#z#)# br //cfoutput cfset zlist = #evaluate(form.qty_#z#)# cfset zlist = ListAppend(zlist, #z#) /cfif /cfloop The problem I am having is how do I make a list so when i do the update query I can insert the product id and the quantity. ~| 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:316309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: uploading file on a different server using cffile
or, if possible, you could use CFFTP to put the uploaded file to another server... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dave Watts wrote: Is there a way of uploading file on a different server other than what i'm using.. if i try to upload it locally with a cffile it works but my plan is uploading it to another one because of space problems.. Well, the file will initially be uploaded to your server, because that's where the form post is going. However, you could then save the uploaded file to another server; when you use CFFILE ACTION=UPLOAD, you're actually just saving the file that's already been uploaded. For this to work, the CF server will need to have permission to write to a remote share. For CF to have this permission, you will have to run it with a user account that has that permission. 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:316310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql query help
i believe the correct function to use is IFNULL(), not ISNULL()... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Fisher wrote: Try this, I think it's what you're looking for: SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points, p.short_description, p.quantity, p.image FROM tblproducts as p LEFT JOIN tblorder_list as o ON p.sku = o.sku #can_afford# WHERE SUM(ISNULL(o.qty, 0)) p.quantity GROUP BY p.sku ~| 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:316311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open BlueDragon and Railo - ready?
I am part of the OpenBD project so I will try to keep my opionions out of it when it comes to OpenBD. They are both suitable for high traffic websites. BlueDragon powers CarFax.com, as well as blog-city both of which are high traffic. I am not sure what sites Railo runs but from my personal experience it seems well against a couple of users I can't imagine it would have problems holding up to the spec you presented. Speaking of which I'm not sure 100,000 users in a 11 hour period is that high of capacity, is it? What would be a more interesting stat would be max concurrent users and the length of time a user is on the site. Adam On Thu, Dec 4, 2008 at 6:36 PM, David McCan [EMAIL PROTECTED] wrote: Does anyone have experience or know if Open BlueDragon or Railo are suitable for use in a high traffic e-commerce site? During the busiest times there are about 100,000 visitors between 8 AM and 7 PM during a day. The highest concentration is between 10 AM and 2 PM. There are lots of graphics, SSL sessions, and some image manipulations (cropping, etc). I would like to use one of them due to the savings, but do not want to risk problems with some critical sites if they need more time to develop. I have not heard of either being used in this type of context, but may have missed hearing about that if it was posted. Thank you, David ~| 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:316312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF and web services best practices
I need to gather information about CF and web services. Could anybody point me to some resources about best practices when implementing web services in CF? Any lessons learned, gotchas from your own experience are even better. I know already a bit about the complex data types and their problems in SOAP/ WSDL. I'm also aware about the proscons of handcoding XML/SOAP and pushing it through CFHTTP vs using the CFinvoke and the built-in Apache Axis engine. Any extra info on these issues would be very useful too. I'm interested in more advanced WS features support in CF like all the standards (WS-Security, WS-Transaction, and other WS-*). The security aspects are also of special interest (including the encryption and digital certificates) Thanks, Michal ~| 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:316313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe's CF IDE, Bolt
Couple of thoughts rick. You could take a stab at adding the feature. There is mechanism in eclipse to do this, and I can't imagine it would be overly difficult. Also, have you considered using the outline view? It is very nice and allows one to scan a file rather quickly. I was jut talking about this 2 days ago with a coworker. Outline view really is very nice, check it out. Adam On Thu, Dec 4, 2008 at 1:19 PM, Rick Faircloth [EMAIL PROTECTED]wrote: While it does offer manual folding, it doesn't maintain the folds when a file is closed...that's worthless... Andy Matthews wrote: You realize that Eclipse has code folding right? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 10:02 AM To: cf-talk Subject: Re: Adobe's CF IDE, Bolt I don't care if they call it Elmer Fudd as long as it works well and has code folding...that feature alone is worth $100 at least to me... Charlie Griefer wrote: On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote: Maybe they have to rebrand since Disney's latest non-Pixar movie is named 'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie. But on a technical note... Is this IDE targeted to current Eclipse users, or is Adobe trying to convert programmers who are using Dreamweaver? It's an Eclipse plugin, so I'd guess the former. Altho I'm sure anyone would be welcome to use 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:316314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Posting for Sr. Web Applications Developer - ColdFusion in Patuxent River, MD.
Contract to hire position for a Sr. Web Applications Developer - ColdFusion in Patuxent River, MD. If interested in applying for this position, please contact Aru Valecha at 1800 - 216 - 1904 or [EMAIL PROTECTED] Thank you! Aru Valecha Sr. Technical Recruiter Acro Service Corporation 1800 - 216 - 1904 513 - 234 - 0808 e-mail - [EMAIL PROTECTED] www.acrocorp.com Provide full life-cycle Web application development to the Web Applications Team in developing Information Technology solutions to meet customer requirements. Work with customers to develop project requirements, develop design, code, test, implement and support the required solution. Provide life-cycle documentation throughout the development cycle. Assist customers with technical support and maintenance issues after delivering the necessary solution. Minimum Qualifications: - High school diploma or equivalent - 10 years of related experience in performing similar functions. - Strong proficiency in ColdFusion, HTML/XML, SQLServer and JavaScript. - Experience with Fusebox design methodologies. - Experience using web development tools such as DreamWeaver, Homesite+, Eclipse, and/or Visual Studio. - Experience with requirements gathering and customer interfacing. - Knowledge of structured Software Development Lifecycle methodologies. - Familiarity with the use of a software change management systems. - Strong verbal and written communications. - US Citizenship is required. - Ability to obtain and maintain a Position of Public Trust is required. Preferred Qualifications: - Bachelorâs degree in computer science, mathematics, statistics, or engineering from an accredited college or university. - 7 years relevant experience. - Experience with MS Office including Viso and Project. - Experience with .NET (ASP and C#) a plus. - Experience in SOAP, WSDL, UDDI, XML-RPC. - Understanding of Earned Value Management (EVM) principles, - Object Oriented design methodologies, as well as general understanding of networking security helpful. - Experience with STARTEAM. ~| 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-jobs-talk/message.cfm/messageid:4132 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11