Platform/Vendors Survey and ColdFusion Features Survey
Hi, As part of the research for Centaur (next major version of ColdFusion aka ColdFusion 9), we need your feedback on ColdFusion 8 features, what enhancements do you need in them, what new features you want in the new release etc. http://www.surveymonkey.com/s.aspx?sm=yLcENFTqjkIn6gqoFpRiUQ_3d_3d We would also like your inputs on platform and vendor support for upcoming ColdFusion release. http://www.surveymonkey.com/s.aspx?sm=_2fJgulePMz_2f1GM6FGV6uMUQ_3d_3d Please do take some time to take these surveys. This would really help us shape the new features in the upcoming version. THIS is YOUR chance to get your favorite features in! Thanks & Regards, Manjukiran Adobe ColdFusion Team ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: exporting from a CF Application to MYOB
There is a connector you can get to allow direct ODBC connection between MYOB and a SQLServer (and other ) database. I'm currently building an application where there is going to be nightly transfers of data between a web site (customer supplied info going into MYOB) and MYOB (updated credit limits going up to customer records in the web site) I'm not at my office for another 10 days but if you want i can send you details of how to do it then. If you cant wait that long, contact support at MYOB and ask about a subscription to the connection key for ODBC. (You have to pay something each year to keep the key working). Hope this helps. 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 Jan 16, 2008 1:04 AM, Rob Parkhill <[EMAIL PROTECTED]> wrote: > Toby, > > I have done this, but it depends on the version of MYOB that you are running > on. My solution works on V 11, and since it has been removed from the > shelves here in Canada, I can't confirm that it would work with any other > verions. > > If that column order will help, I can get this to you. > > Rob > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLdap
Forgot to include the code, here ya go: > Thanks in advance... > > Trying to use CFLdap with AD to modify a users distribution group, > basically have the ability to move someone in and out of different > groups, getting this error: > > coldfusion.tagext.net.LdapTagException: An error has occured while > trying to execute modify :[LDAP: error code 53 - 200A: SvcErr: > DSID-031A0B56, problem 5003 (WILL_NOT_PERFORM) > > > Any help would be much appreciated! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLdap
Thanks in advance... Trying to use CFLdap with AD to modify a users distribution group, basically have the ability to move someone in and out of different groups, getting this error: coldfusion.tagext.net.LdapTagException: An error has occured while trying to execute modify :[LDAP: error code 53 - 200A: SvcErr: DSID-031A0B56, problem 5003 (WILL_NOT_PERFORM) Any help would be much appreciated! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
> I used to think that people do not care to see the primary key so in > my last big application I did not display them(unique numeric IDs) in > most places. After about 6-8 months it was found that the users want > to see those keys and that they use them to reference things. For > example they rather say property ID 2806 instead of the Wireline > property located in Rosharon, Tx on 22 Acatia Avenue. Sure... However... What you're talking about here is complicated by the fact that you work in an environment where you've got a bunch of business users in this corporate environment who've all become accustomed to handling their data that way. And part of the reason that they've become accustomed to handling their data that way is likely a result of poor user interface being left poor and having people simply "cope" with it rather than make it good UI. For any given employee (programmers excepted), the likelyhood is that they pretty much work with and share a very small set of actual data (or aggregated reports on larger sets). These very small sets of data however are stored in very massive tables containing the data sets for all the other employees as well, but when they go work on them, the system doesn't make any distinction between "stuff Bob works with most of the time" and "stuff Jim works with most of the time". It just tosses the whole gigantic list at them unceremoniously and says "you tell me what you want". So they've become accustomed to referencing things by number because they're accustomed to searching for things in haystack-needle fashion. Whereas if from the beginning they'd been given "learning" systems that remembered that "Bob uses this property a lot, maybe we shouldn't force him to search through 4-million records (3.9 million of which he's never touched), for a property he uses every other day". Then Bob likely might have acquired a habit of thinking about it as "Wireline" rather than either "property 58" or "Wireline in Richardson, TX on 22 Acatia Avenue". Either of the latter are rather cryptic and given the choice, "property 58" is probably the lesser of evils. But I'd bet that given a system that learns about his habits and predicts them, he and the coworkers in his team would be a lot happier thinking of the property as just "Wireline". So that's my rant and I'm sticking to it. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
> > But if you had 10 records and then deleted the 10th and then created a new > record, > you had a much greater risk of that record being contaminated with > information from the previous record that had been there .. Excellent point :) I used to think it odd how dbs don't fill in the gaps with their auto ids. So bleedin obvious ain't it! Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
> I think reading the article will make your mind up either way about > the wisdom of not using 'auto increments' / surrogate pks (I realise > they are not the same thing). This in particular === 2) The definite possibility of historical data contamination. If you leave your company, and somebody else comes in and is assigned your old LAN ID, what will HR do with all of your old employee data, or anything in the database that references your LAN ID? === Is an often overlooked but very important point. It used to be common in ColdFusion (I think possibly before there were easy ways to fetch inserted autonumber values), to determine the id of a record you're about to insert by fetching the current max() of the primary key column and adding 1 to it. Which although it worked, produces a negative-scaling curve (i.e. the bigger your data set, the less it scales). Most of the time the scaling wouldn't be an issue -- even with millions of records you can get the max back reasonably quickly. If you deleted any record in the middle of the stack you were fine too, since it would just create a "hole" say between records 8 and 10. But if you had 10 records and then deleted the 10th and then created a new record, you had a much greater risk of that record being contaminated with information from the previous record that had been there. And it might not even be anything in your system - it might be something as simple as a user having bookmarked a page with that id in the url. They hit their bookmark and viola! Instead of "sorry this record has been deleted" they get different data, and depending on the display, they may not realize until after they'd done something tragic that they were editing the wrong data. Imo poor handling of historical information is pretty pandemic in software in general, I think mostly because we're kind of trained to focus mostly on other contexts where the needs of the domain are somewhat antithetical to the needs of a historical problem domain. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
I used to think that people do not care to see the primary key so in my last big application I did not display them(unique numeric IDs) in most places. After about 6-8 months it was found that the users want to see those keys and that they use them to reference things. For example they rather say property ID 2806 instead of the Wireline property located in Rosharon, Tx on 22 Acatia Avenue. On Jan 16, 2008 9:49 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > > http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=1 > > Heh... read the article... Had never heard anyone complain before about > arbitrary primary keys... and honestly, it strikes me as being rather > odd... I've only ever heard people complain about meaningful keys > actually. But it just seems really odd to complain that "hey, it's a > challenge to figure out who a person's boss is by looking at the primary > key in this table directly" when I always thought it was sort of > contrary to the notion of software for people to be looking at those > primary keys. People don't want to see the key anyway, they want to see > human values -- so why would it be a problem that something they don't > want or need to see is confusing to look at? > > > -- > s. isaac dealey ^ new epoch > isn't it time for a change? > ph: 503.236.3691 > > 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
> > Heh... read the article... Had never heard anyone complain before about > arbitrary primary keys... and honestly, it strikes me as being rather > odd... I've only ever heard people complain about meaningful keys > actually. But it just seems really odd to complain that "hey, it's a > challenge to figure out who a person's boss is by looking at the primary > key in this table directly" when I always thought it was sort of > contrary to the notion of software for people to be looking at those > primary keys. People don't want to see the key anyway, they want to see > human values -- so why would it be a problem that something they don't > want or need to see is confusing to look at? Agreed! This is exactly what the 'respected' Joe Celko preaches and it is clearly dangerous. It can creep up more subtly though as with the situation of the OPer. I have found myself doing these things half by mistake and now conscious of the issue am rectifying where possible. One example is writing facebook applications; I store all my facebook users that interact with my app in a user table and have been using the Facebook userID as the PK, a bigint. Seemed ok enough until I wondered what happens when Facebook change their userIDs from bigints to UUIDs... oops. I have corrected that one since reading the article already. Obvious really, just needed going back to school. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
> > > ACK i was missing my # signs!!! new wife must have stolen them! > > > > I hear that's a common problem with newlyweds. :) > > hmmm... you think she only married him for his # signs? :) Yeah, gotta be careful. She might be a # digger. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=1 Heh... read the article... Had never heard anyone complain before about arbitrary primary keys... and honestly, it strikes me as being rather odd... I've only ever heard people complain about meaningful keys actually. But it just seems really odd to complain that "hey, it's a challenge to figure out who a person's boss is by looking at the primary key in this table directly" when I always thought it was sort of contrary to the notion of software for people to be looking at those primary keys. People don't want to see the key anyway, they want to see human values -- so why would it be a problem that something they don't want or need to see is confusing to look at? -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
On Jan 16, 2008 6:52 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > > ACK i was missing my # signs!!! new wife must have stolen them! > > I hear that's a common problem with newlyweds. :) hmmm... you think she only married him for his # signs? :) -- "Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter." - Dave Barry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
> ACK i was missing my # signs!!! new wife must have stolen them! I hear that's a common problem with newlyweds. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Training a new programmer
We sent a guy (former PHP) to one of Charlie Arehart's bootcamp courses. He's not looking back;) Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Ian Rutherford wrote: > I have an employee who has tinkered around with CF and Javascript and is > familiar with HTML basics. > > He has expressed interest in learning more and getting more involved in the > actual programming for the company. > > Any suggestions on how best to go about training him? I've got books galore > but I'm not sure how best to introduce him to frameworks, OOP and CF as a > cohesive whole. > > Thanks, > Ian > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
Ok, so I did some googling because I wanted to know WHY it was 'best practice' to add a surrogate key to the table and why to rail against the idea of using 'natural keys' as primary keys. I stumbled across perhaps the longest thread I have ever read completely, it starts in November 2001 and the last post was january 2007. I was tempted to post but thought better of it :p It references an article advocating the use of natural primary keys and produced the most entertaining rant and informative series of posts I have read in a long time. The rant starts at the end of page 2 and is by 'quazibubble' who later becomes QB after he gets banned. I think anyone considering using natural keys should read his rants, they are both entertainingly rude and contain the gems of wisdom that the likes of me need: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=1 I think reading the article will make your mind up either way about the wisdom of not using 'auto increments' / surrogate pks (I realise they are not the same thing). Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Barcode Question
Mario- We're working on a project here that creates barcodes embedded in a PDF created with cfdocument. However, you could use cfimage in a similar way. We ended up purchasing a collection of fonts from MyFonts.com (http://www.myfonts.com/info/fontware-code39) but ID Automation has a free Code 39 Barcode Font allows the ability to print letters, numbers and some symbols (http://www.idautomation.com/fonts/free). Hope this helps. Thanks! Ryan Ciliotta, Mario wrote: > Hi, > > I was wondering if anyone could assist me with an issue. I am currently > using the custom tag barcode39.cfm to produce 3 of 9 barcodes from a CF > page. I am have a few issues with the fact that the tag and/or the 3 of > 9 barcode specification does not support certain characters like the " , > " and the "@". Does anyone know if there is an update to this tag or is > there possibly a CFC or something else that I could use to produce the > barcode. I do not have to use 3 of 9, I can use a different format. > > I am using BlueDragon 6.2 on Weblogic. > > Thanks > Mario > > == > Please access the attached hyperlink for an important electronic > communications disclaimer: > > http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html > == > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Image function - get size of text written
You may want to try using TextLayout instead of FontMetrics getStringBounds() for a more accurate measurement. The Font API mentions "The logical bounds does not always enclose all the text. For example, in some languages and in some fonts, accent marks can be positioned above the ascent or below the descent. To obtain a visual bounding box, which encloses all the text, use the getBounds method of TextLayout." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Barcode Question
I've used barbecue to generate barcodes in the past: http://www.bifrost.com.au/blog/index.cfm/2006/8/24/Generating-Barcodes-with-Barbecue-and-Coldfusion On Jan 17, 2008 5:34 AM, Ciliotta, Mario <[EMAIL PROTECTED]> wrote: > Hi, > > I was wondering if anyone could assist me with an issue. I am currently > using the custom tag barcode39.cfm to produce 3 of 9 barcodes from a CF > page. I am have a few issues with the fact that the tag and/or the 3 of > 9 barcode specification does not support certain characters like the " , > " and the "@". Does anyone know if there is an update to this tag or is > there possibly a CFC or something else that I could use to produce the > barcode. I do not have to use 3 of 9, I can use a different format. > > I am using BlueDragon 6.2 on Weblogic. > > Thanks > Mario > > == > Please access the attached hyperlink for an important electronic > communications disclaimer: > > http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html > == > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Training a new programmer
> He has expressed interest in learning more and getting more involved in the > actual programming for the company. > Any suggestions on how best to go about training him? I've got books galore > but I'm not sure how best to introduce him to frameworks, OOP and CF as a > cohesive whole. I've helped a few HTML/PHP people get up to speed with CF (in fact I'm doing it now) and I've found that often people learn best by example, but preferably real world code. So to start with I give them something like a mostly-finished Fusebox circuit for a CRUD app - say, maintaining one type of record - and get them to produce the same for a different type of record. Or I'll write the CFC for grabbing records, and give them an output page with just a CFDUMP so they can see visually see how the data is structured and lay it out (good for HTML peeps). CFDUMP always impresses people used to PHP or ASP too :) Once they've actually generated something that's actually useful - and not a hello world page - they're usually encouraged to expand on what they've done. Of course, I'm talking about people that I'm actively working with. Cheers, K. -- kay.smoljak.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
Mark Kruger wrote: > I tried the DBCC FREEPROCCACHE routine after making a schema change - but it > does not prevent the 'invalid data type" error that sometimes occurs. Any > other useful routines you can think of? No, but I just realized where there is an error in my logic. I was assuming that once you flush the execution plan cache it would solve the problem. But that is only true if automatic recompilation is supported. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The CRUD thread reminds me of something I 'played' around a few years ago...
ok, just brought the dead horse back alive now :) some may say user friendly enough, so, it's not for the general public... thanks. > oops, sorry, accesssing my old version cf admin on the same box is a > pain in ??? but hang on... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam, cached execution plans, and changing table structure
Jochem, I tried the DBCC FREEPROCCACHE routine after making a schema change - but it does not prevent the 'invalid data type" error that sometimes occurs. Any other useful routines you can think of? -mark -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 1:49 PM To: CF-Talk Subject: RE: cfqueryparam, cached execution plans, and changing table structure Jochem, So... If I ran the DBCC operation on the SQL server to flush the execution plan cache immediatley after a shema change - I would not have to fiddle with the queries or restarts or other techniques to draw it over to CF? If so - that's a great tip. -Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 1:33 PM To: CF-Talk Subject: Re: cfqueryparam, cached execution plans, and changing table structure Ben Mueller wrote: > It sounds like the only time this is a problem is under the following circumstance: alterations to an existing DB table where a related execution plan is stored in memory. Correct. > I'm mostly annoyed that this doesn't "just work". Maybe that's unrealistic of me, but I don't think it's unreasonable of me. It is a MS SQL Server issue. Oracle, PostgreSQL etc. do not have this problem, they flush their cache on schema changes. So I agree that it is not unrealistic to expect that it would be handled automatically. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
> > No, it's not sarcasm. Joe Celko is very well known and respected in that > community. Yeh, I see! Just googled "primary keys" "business logic" (cos I'm interested) and his name came up straight away: http://www.codinghorror.com/blog/archives/000817.html Some varying and strong opinions of him; I quote my favourite: 'he's really a troll who doesn't even use ANSI 92/99-standard join syntax' ;) -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Barcode Question
I'm not sure if this will work for you but I'll mention it. We recently did a project that handled faxes with 2D bar codes. We used a java library from Java4Less to create a 2D "data matrix" code on a fax cover sheet. The idea was that user would fax documents into our fax number (on an Asteisk server). They would be stored on the drive as PDFs. Using CF8 and the CFPDF tag we created thumbs of the cover page from the fax and then extracted the bar code - passing it to the java4Less library for decoding. The result worked really well. Ryan Stille (the CF Webtools guru who came up with the solution) posted a CFC to use in conjunction with the library. Here's my post on the topic: http://www.coldfusionmuse.com/index.cfm/2007/12/12/fax.2D.barcode.Coldfusion ..8 And here is ryans post: http://www.stillnetstudios.com/2007/12/15/2d-barcodes-coldfusion/ That includes a link to the riaforge project. -Mark -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 2:34 PM To: CF-Talk Subject: Barcode Question Hi, I was wondering if anyone could assist me with an issue. I am currently using the custom tag barcode39.cfm to produce 3 of 9 barcodes from a CF page. I am have a few issues with the fact that the tag and/or the 3 of 9 barcode specification does not support certain characters like the " , " and the "@". Does anyone know if there is an update to this tag or is there possibly a CFC or something else that I could use to produce the barcode. I do not have to use 3 of 9, I can use a different format. I am using BlueDragon 6.2 on Weblogic. Thanks Mario == Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html == ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The CRUD thread reminds me of something I 'played' around a few years ago...
oops, sorry, accesssing my old version cf admin on the same box is a pain in ??? but hang on... >You tried to access the Developer Edition from a disallowed IP ... >oops got a live server you can toss it on? > >On Jan 16, 2008 3:19 PM, D > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CRUD Creation
> > Joe Ceiko holds that theory and considering he's so > > influential in the relational db world... > > I assume that's sarcasm; not being a mover in the relational > db world I wouldn't know :P No, it's not sarcasm. Joe Celko is very well known and respected in that community. 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
> > Joe Ceiko holds that theory and considering he's so influential in the > relational db world... I assume that's sarcasm; not being a mover in the relational db world I wouldn't know :P I'd opt for the new primary key and unique constraint on the columns everytime. Zero headache. The unique constraint is absolutely imprtant of course, let the db tell you when your code sucks ;) Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
The situations I've seen it most is when doing a SELECT * FROM table, and not getting a newly added column in the query result. I've had issues when changing the column order as well. On Jan 16, 2008 3:01 PM, Ben Mueller <[EMAIL PROTECTED]> wrote: > Now that I would *almost* understand and forgive. But we seem to have > gotten the error when we added a column that was *not* referenced in the > query. So, all we did was add a column--we didn't alter the query at all. > Of course, I can't recreate on my laptop (running CF8 and SQL2005 locally), > but I'll try to get it to happen again. > > Thanks again, > Ben > -- Edward A Savage Jr - "Sonny" Senior Software Engineer Creditdiscovery, LLC ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The CRUD thread reminds me of something I 'played' around a few years ago...
You tried to access the Developer Edition from a disallowed IP ... oops got a live server you can toss it on? On Jan 16, 2008 3:19 PM, Don L <[EMAIL PROTECTED]> wrote: > http://24.254.1.94:8000/snap823/DataMan.cfm > (Have not re-test it thoroughly) > Who could use something like that? > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Training a new programmer
I agree. When one of my employers decided to go from CF to .NET, I was given 90 days to get up to speed to beginner/intermediate level. So they told me to pick some light-weight apps that I did in CF then convert them to .NET. It worked. In about four months I was doing some high level .NET stuff. Bruce -- Throttle Jockey - Why golf courses should be motocross tracks Ben Doom wrote: > I'd pick something non-time-critical and non-mission-critical and, as it > were, throw him in the shallow end. Give him all the help he asks for. > Do a code review. Pick something more important, wash, rinse, repeat. > > --Ben Doom > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Training a new programmer
I'd pick something non-time-critical and non-mission-critical and, as it were, throw him in the shallow end. Give him all the help he asks for. Do a code review. Pick something more important, wash, rinse, repeat. --Ben Doom Ian Rutherford wrote: > I have an employee who has tinkered around with CF and Javascript and is > familiar with HTML basics. > > He has expressed interest in learning more and getting more involved in the > actual programming for the company. > > Any suggestions on how best to go about training him? I've got books galore > but I'm not sure how best to introduce him to frameworks, OOP and CF as a > cohesive whole. > > Thanks, > Ian > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Image function - get size of text written
Interesting stuff. I've been wanting to do something like this for a while now, but a bit different. Given the string X, and an image Canvas, put X so that is centered horiz and vert. If you had the W/H of a set of text, it would be trivial. On Jan 16, 2008 10:46 AM, Ben Nadel <[EMAIL PROTECTED]> wrote: > John, > > I did something that was inspired by Barney Boisvert. An image function > that draws text areas rather than just a line of text: > > http://www.bennadel.com/blog/977-ColdFusion-8-ImageDrawTextArea-Inspired > -By-Barney-Boisvert-.htm > > In order to do this, I had to figure out the dimensions of the text > itself. Take a look at the innards. > > -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Barcode Question
Hi, I was wondering if anyone could assist me with an issue. I am currently using the custom tag barcode39.cfm to produce 3 of 9 barcodes from a CF page. I am have a few issues with the fact that the tag and/or the 3 of 9 barcode specification does not support certain characters like the " , " and the "@". Does anyone know if there is an update to this tag or is there possibly a CFC or something else that I could use to produce the barcode. I do not have to use 3 of 9, I can use a different format. I am using BlueDragon 6.2 on Weblogic. Thanks Mario == Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html == ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
The CRUD thread reminds me of something I 'played' around a few years ago...
http://24.254.1.94:8000/snap823/DataMan.cfm (Have not re-test it thoroughly) Who could use something like that? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Training a new programmer
I have an employee who has tinkered around with CF and Javascript and is familiar with HTML basics. He has expressed interest in learning more and getting more involved in the actual programming for the company. Any suggestions on how best to go about training him? I've got books galore but I'm not sure how best to introduce him to frameworks, OOP and CF as a cohesive whole. Thanks, Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296686 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
On "For some reason a former employer drilled it into the team that Auto incrementing PK's were dead weight if you could composite a key with existing data" Joe Ceiko holds that theory and considering he's so influential in the relational db world... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
Now that I would *almost* understand and forgive. But we seem to have gotten the error when we added a column that was *not* referenced in the query. So, all we did was add a column--we didn't alter the query at all. Of course, I can't recreate on my laptop (running CF8 and SQL2005 locally), but I'll try to get it to happen again. Thanks again, Ben > Ben Mueller wrote: > > > > SELECT firstname > > FROM user > > WHERE email = email#> > > > > > > MS SQL Server caches the execution plan. Then, I add a "lastname" > column to the user table. I don't change the query at all. I re-hit > the query while the execution plan is cached. It breaks? > > Probably not if you add a column, only if you delete one and keep > referencing it: > > CREATE TABLE user (A, B, C) > > > > > > > > ALTER TABLE user DROP COLUMN C > > > > Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
ACK i was missing my # signs!!! new wife must have stolen them! IF NOT EXISTS (SELECT ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk FROM user_provider_services WHERE ups_provider_fk = AND ups_client_fk = AND ups_service_fk = ) INSERT INTO user_provider_services (ups_provider_fk,ups_client_fk,ups_service_fk) VALUES ( , ,) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
Ben Mueller wrote: > > SELECT firstname > FROM user > WHERE email = > > > MS SQL Server caches the execution plan. Then, I add a "lastname" column to > the user table. I don't change the query at all. I re-hit the query while > the execution plan is cached. It breaks? Probably not if you add a column, only if you delete one and keep referencing it: CREATE TABLE user (A, B, C) ALTER TABLE user DROP COLUMN C Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
Sorry stepped away from the computer a couple days to get married WOOT! now back to work What I've come up with is: IF NOT EXISTS (SELECT ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk FROM user_provider_services WHERE ups_provider_fk = AND ups_client_fk = AND ups_service_fk = ) INSERT INTO user_provider_services (ups_provider_fk,ups_client_fk,ups_service_fk) VALUES ( , ,) Thanks for the input guys. For some reason a former employer drilled it into the team that Auto incrementing PK's were dead weight if you could composite a key with existing data, and I'm finding old habits die hard. OK back to the honeymooning! On Jan 14, 2008 12:22 PM, Dave Watts <[EMAIL PROTECTED] > wrote: > > > An auto Incrementing PK just makes it easier to insert a > > > duplicate. > > > > Not if the column is marked as a PK. > > I think that Richard means, it's easier to insert duplicate data values > with > a surrogate key. This is certainly true, unless you place constraints on > the > natural key as well. > > 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam, cached execution plans, and changing table structure
Jochem, So... If I ran the DBCC operation on the SQL server to flush the execution plan cache immediatley after a shema change - I would not have to fiddle with the queries or restarts or other techniques to draw it over to CF? If so - that's a great tip. -Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 1:33 PM To: CF-Talk Subject: Re: cfqueryparam, cached execution plans, and changing table structure Ben Mueller wrote: > It sounds like the only time this is a problem is under the following circumstance: alterations to an existing DB table where a related execution plan is stored in memory. Correct. > I'm mostly annoyed that this doesn't "just work". Maybe that's unrealistic of me, but I don't think it's unreasonable of me. It is a MS SQL Server issue. Oracle, PostgreSQL etc. do not have this problem, they flush their cache on schema changes. So I agree that it is not unrealistic to expect that it would be handled automatically. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problems with CFDOCUMENT and load balancing
> Sticky sessions? Yes. J2EE sessions are enabled. It's been working well for the past year or so. > How about CSS and Javascript? Anyplace where we can see the HTML? There's one block of inline CSS, and no javascript. It seems to mostly be the images tanking this. I'm looking to get permission to include the HTML. Bloody hell... Well, consider this solved. The images directory (which exists in the staging area) does not exist in production. And it's timing out looking for them. Moved in the images, and problem solved. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
God, so annoying. So, let me see if I really have this straight. Let's pretend I have a table called "user" that has two columns: firstname and email. I write a query like this (shortened syntax): SELECT firstname FROM user WHERE email = MS SQL Server caches the execution plan. Then, I add a "lastname" column to the user table. I don't change the query at all. I re-hit the query while the execution plan is cached. It breaks? Thanks again. > > It sounds like the only time this is a problem is under the > following circumstance: alterations to an existing DB table where a > related execution plan is stored in memory. > > Correct. > > > > I'm mostly annoyed that this doesn't "just work". Maybe that's > unrealistic of me, but I don't think it's unreasonable of me. > > It is a MS SQL Server issue. Oracle, PostgreSQL etc. do not have this > > problem, they flush their cache on schema changes. So I agree that it > is > not unrealistic to expect that it would be handled automatically. > Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
Ben Mueller wrote: > It sounds like the only time this is a problem is under the following > circumstance: alterations to an existing DB table where a related execution > plan is stored in memory. Correct. > I'm mostly annoyed that this doesn't "just work". Maybe that's unrealistic > of me, but I don't think it's unreasonable of me. It is a MS SQL Server issue. Oracle, PostgreSQL etc. do not have this problem, they flush their cache on schema changes. So I agree that it is not unrealistic to expect that it would be handled automatically. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT:_Adobe?_Dreamweaver?_Developer_Toolbox
Has anyone tried this add-on to dreamweaver? Worth the $300? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
> > Thanks, Jochem, for the reply. I glanced at that call just briefly; > does it clear *all* stored execution plans, or just a specified one? > It seems like the only way it would be useful in this context is if it > cleared them all, since we have no way of knowing which plans are > cached. > > I don't know, you might evenneed one of the other DBCC FREE. > commands. Try it :) Yeah, I'll try it all right. Just was hoping you might know off the top of your head. > > A larger question is this: isn't this a huge headache for > everybody? We update our site a lot--sometimes several times a day > > If by update you mean a schema change I think you are the exception > rather then the rule. Well, it's a mix. Sometimes, we just make CF code changes, but we do make changes to our database with some regularity. It sounds like the only time this is a problem is under the following circumstance: alterations to an existing DB table where a related execution plan is stored in memory. If we create a new table, or if (by luck) no referencing execution plan isn't stored in memory, then we're okay. I'd say we make changes like that as often as a few times a week? There might be a week or so that goes by where we don't make a change like that, and then a week will come along where we make a host of such changes. Is this really the exception rather than the rule? I would think that most sites are under constant evolution, database included. I suppose I'm trying to get a sense of how the community at large deals with these issues. Do people take databases offline when making structural changes, or make a habit of cycling the SQL service (which would probably clear the cache, but I'm not sure), or do people routinely call the SQL procedure you highlighted above? I'm mostly annoyed that this doesn't "just work". Maybe that's unrealistic of me, but I don't think it's unreasonable of me. Thanks again, Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
Even when we have updated a schema in the past the execution plan is trashed and a new one is prepared and we do not experience any problems. Why would a schema change multiple times in a day, there is agile and there is ridiculous that seems to be treading on ridiculous. I've never experienced an issue with local development either which I could see the schema going through rapid changes during spikes. Adam Haskell On Jan 16, 2008 1:21 PM, Ben Mueller <[EMAIL PROTECTED]> wrote: > Thanks, Jochem, for the reply. I glanced at that call just briefly; does > it clear *all* stored execution plans, or just a specified one? It seems > like the only way it would be useful in this context is if it cleared them > all, since we have no way of knowing which plans are cached. > > A larger question is this: isn't this a huge headache for everybody? We > update our site a lot--sometimes several times a day--and if having > around means we need to add an extra step to our process of getting stuff > out to our production servers, that just seems like a big pain. Maybe I'm > asking for too much here, but I suppose I would expect that if a cached > execution plan bombed in SQL Server, it would automatically attempt to > re-compile, under the assumption that the cached plan is out of date. > > Thanks again, > Ben > > > > The execution plan is cached in the database so there is no way CF > > could > > possible know it is cached, let alone the cache needs to be flushed. > > > > > > > and it seems the only solutions are to cycle the CF service or > > change any query (in some minor way) to force CF to create a new > > execution plan. > > > > What you need is to flush the cache in the database server. Look into > > > > DBCC FREEPROCCACHE and its cousins. > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296674 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
Ben Mueller wrote: > Thanks, Jochem, for the reply. I glanced at that call just briefly; does it > clear *all* stored execution plans, or just a specified one? It seems like > the only way it would be useful in this context is if it cleared them all, > since we have no way of knowing which plans are cached. I don't know, you might evenneed one of the other DBCC FREE. commands. Try it :) > A larger question is this: isn't this a huge headache for everybody? We > update our site a lot--sometimes several times a day If by update you mean a schema change I think you are the exception rather then the rule. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
Thanks, Jochem, for the reply. I glanced at that call just briefly; does it clear *all* stored execution plans, or just a specified one? It seems like the only way it would be useful in this context is if it cleared them all, since we have no way of knowing which plans are cached. A larger question is this: isn't this a huge headache for everybody? We update our site a lot--sometimes several times a day--and if having around means we need to add an extra step to our process of getting stuff out to our production servers, that just seems like a big pain. Maybe I'm asking for too much here, but I suppose I would expect that if a cached execution plan bombed in SQL Server, it would automatically attempt to re-compile, under the assumption that the cached plan is out of date. Thanks again, Ben > The execution plan is cached in the database so there is no way CF > could > possible know it is cached, let alone the cache needs to be flushed. > > > > and it seems the only solutions are to cycle the CF service or > change any query (in some minor way) to force CF to create a new > execution plan. > > What you need is to flush the cache in the database server. Look into > > DBCC FREEPROCCACHE and its cousins. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problems with CFDOCUMENT and load balancing
Matthew Williams wrote: > The situation stands as such. I have an application hosted in my environment > that uses the cfdocument tag. Our servers are clustered at the JRun level. Sticky sessions? > We also have a hardware load balancer in front of the servers. When calling > the page containing the cfdocument through the load balanced URL, the process > fails 99% of the time. Looking at the stack trace in FusionReactor, it looks > like it times out at about 60 seconds and gives up (we time out requests in > the admin at the 60 second mark). However, if you go directly to the machine > (bypassing the load balancer), the page request returns correctly. Has > anyone else run into this? Yes. If the document has assets it will try to download them using the servername and path from the HTTP headers. If the server can not resolve them correctly, for instance because the DNS for the site points to an IP address on the loadbalancer, it will timeout. > I've removed all calls to image tags from within the page, and it's still > failing. How about CSS and Javascript? Anyplace where we can see the HTML? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problems with CFDOCUMENT and load balancing
The situation stands as such. I have an application hosted in my environment that uses the cfdocument tag. Our servers are clustered at the JRun level. We also have a hardware load balancer in front of the servers. When calling the page containing the cfdocument through the load balanced URL, the process fails 99% of the time. Looking at the stack trace in FusionReactor, it looks like it times out at about 60 seconds and gives up (we time out requests in the admin at the 60 second mark). However, if you go directly to the machine (bypassing the load balancer), the page request returns correctly. Has anyone else run into this? I've removed all calls to image tags from within the page, and it's still failing. I'm starting to not like CFDOCUMENT. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
Hi Ben, In the ColdFusion administration there is an option for caching or keeping the connection open... I can't remember what it's called. If you disable this option and then re-run the query you can re-enable the option. I've seen other query errors caused by ColdFusion caching the data structures as well. -- Edward A Savage Jr - "Sonny" Senior Software Engineer Creditdiscovery, LLC ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with lyla captcha
Getting the following error, Element CAPTCHA is undefined in a Java object of type class [Ljava.lang.String; referenced as The error occurred in C:\Program Files\Apache Group\Apache\htdocs\art\students\undergraduate\accomplish\add.cfm: line 499 499 : Could anybody help me with this thanks Prasath ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam, cached execution plans, and changing table structure
Have a look at this: But, I think the last I left it, it wasn't working. It was timing out if I remember rightly. Also, you might not need to pass in that much data, but instead glean it from the datasource. Just an idea. Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Adrian Lynch Sent: 16 January 2008 16:33 To: CF-Talk Subject: RE: cfqueryparam, cached execution plans, and changing table structure You should be able to do it with code. Using the Admin API you can switch a flag (can't remember which one) off and on again for a given datasource. This should clear the cached plan. I had a function to do it but it's at home. If you wait about 5 hours! :OD I also didn't get around to testing it so I was never 100% sure it worked. Adrian -Original Message- From: Ben Mueller Sent: 16 January 2008 16:17 To: CF-Talk Subject: cfqueryparam, cached execution plans, and changing table structure We hit a problem with morning relating to cfqueryparam. A query using cfqueryparam referenced a table whose structure had been changed (we added a column). It appears the execution plan had been cached, and either CF7 or SQL Server 2000 wasn't smart enough to figure out that the table had changed, and so the query bombed. I found an old post on it here: http://www.coldfusionjedi.com/index.cfm?mode=entry&entry=7D417738-DF64-B270- 3056B422E2F6FCAB ..and it seems the only solutions are to cycle the CF service or change any query (in some minor way) to force CF to create a new execution plan. Frankly, both of those solutions blow. We're constantly updating our site, and if we have to cycle the CF service on our production servers every time we make a database change, we'll simply be forced to abandon cfqueryparam entirely. Somebody please tell me there's some other solution here. Thanks in advance, Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
Ben Mueller wrote: > We hit a problem with morning relating to cfqueryparam. A query using > cfqueryparam referenced a table whose structure had been changed (we added a > column). It appears the execution plan had been cached, and either CF7 or > SQL Server 2000 wasn't smart enough to figure out that the table had changed, > and so the query bombed. The execution plan is cached in the database so there is no way CF could possible know it is cached, let alone the cache needs to be flushed. > and it seems the only solutions are to cycle the CF service or change any > query (in some minor way) to force CF to create a new execution plan. What you need is to flush the cache in the database server. Look into DBCC FREEPROCCACHE and its cousins. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:29 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Image function - get size of text written
John, I did something that was inspired by Barney Boisvert. An image function that draws text areas rather than just a line of text: http://www.bennadel.com/blog/977-ColdFusion-8-ImageDrawTextArea-Inspired -By-Barney-Boisvert-.htm In order to do this, I had to figure out the dimensions of the text itself. Take a look at the innards. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Monday, January 14, 2008 3:08 PM To: CF-Talk Subject: CF8 Image function - get size of text written Does anyone know a way for getting the size of the text written to an image? For example. Lets say that I have an image that is 50 pixels high and 400 pixels wide and I write some text on the image starting at the first pixel and the text only takes a width of 212 pixels. How can I tell that the text only took up 212 pixels? I am looking for something like the getdimensions() method from cfx_imageflare http://efflare.com/products/cfx_imageflare/documentation/font.html ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
Tom, Thanks for the reply, but I don't think that would solve the problem. The issue is that the execution plan itself is cached, and so it doesn't know about the underlying database changes. If I run a different query, it won't affect this execution plan. And even if it did, that's still not a solution I would run with. That would mean that for every database change I make, I would have to be the first one to hit the associated cached query. Our site has enough traffic that it's very likely a user would hit one of these queries before me, and would therefore see an error. Ben > If all you need to is run a query against the new table, why not just > do that > from a plain old CFML page ? > > -- > Tom Chiverton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
fckeditor
Has anyone encountered an issue with fckeditor where it inserts a style property into the divs (style="margin 0pt 0pt 0pt 0pt") that causes the ext within the div to form a tight column on the left instead of the text populating the entire td? I didn't see anything specifically about his on their forums (and I did leave a message there). This happens when it is used by any browser. This is on CF7 win 2k with the latest version of fckeditor. Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam, cached execution plans, and changing table structure
You should be able to do it with code. Using the Admin API you can switch a flag (can't remember which one) off and on again for a given datasource. This should clear the cached plan. I had a function to do it but it's at home. If you wait about 5 hours! :OD I also didn't get around to testing it so I was never 100% sure it worked. Adrian -Original Message- From: Ben Mueller Sent: 16 January 2008 16:17 To: CF-Talk Subject: cfqueryparam, cached execution plans, and changing table structure We hit a problem with morning relating to cfqueryparam. A query using cfqueryparam referenced a table whose structure had been changed (we added a column). It appears the execution plan had been cached, and either CF7 or SQL Server 2000 wasn't smart enough to figure out that the table had changed, and so the query bombed. I found an old post on it here: http://www.coldfusionjedi.com/index.cfm?mode=entry&entry=7D417738-DF64-B270- 3056B422E2F6FCAB .and it seems the only solutions are to cycle the CF service or change any query (in some minor way) to force CF to create a new execution plan. Frankly, both of those solutions blow. We're constantly updating our site, and if we have to cycle the CF service on our production servers every time we make a database change, we'll simply be forced to abandon cfqueryparam entirely. Somebody please tell me there's some other solution here. Thanks in advance, Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
And, in addition to what Tom is saying, I don't think you have to do this all the time. Just one time? That's what I'm gathering from all the comments on Ray's page. On Jan 16, 2008 11:30 AM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Wednesday 16 Jan 2008, Ben Mueller wrote: > > and if we have to cycle the CF service on our production servers every > time > > we make a database change, we'll simply be forced to abandon > cfqueryparam > > entirely. > > If all you need to is run a query against the new table, why not just do > that > from a plain old CFML page ? > > -- > Tom Chiverton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam, cached execution plans, and changing table structure
On Wednesday 16 Jan 2008, Ben Mueller wrote: > and if we have to cycle the CF service on our production servers every time > we make a database change, we'll simply be forced to abandon cfqueryparam > entirely. If all you need to is run a query against the new table, why not just do that from a plain old CFML page ? -- Tom Chiverton Helping to autoschediastically entrench leading-edge information on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfqueryparam, cached execution plans, and changing table structure
We hit a problem with morning relating to cfqueryparam. A query using cfqueryparam referenced a table whose structure had been changed (we added a column). It appears the execution plan had been cached, and either CF7 or SQL Server 2000 wasn't smart enough to figure out that the table had changed, and so the query bombed. I found an old post on it here: http://www.coldfusionjedi.com/index.cfm?mode=entry&entry=7D417738-DF64-B270-3056B422E2F6FCAB and it seems the only solutions are to cycle the CF service or change any query (in some minor way) to force CF to create a new execution plan. Frankly, both of those solutions blow. We're constantly updating our site, and if we have to cycle the CF service on our production servers every time we make a database change, we'll simply be forced to abandon cfqueryparam entirely. Somebody please tell me there's some other solution here. Thanks in advance, Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ajax CFgrid in cf8 help
OK, you have your grid object, 'mygrid', now you can do a bit more before your .reconfigure(). Create your paging Toolbar. First you need to get your grid footer: var gridFoot = mygrid.getView().getFooterPanel(true); After this you create a new PagingToolbar: var paging = new Ext.PagingToolbar(gridFoot,ds,{ pageSize:25, //number of records displayed in grid displayInfo:true, displayMsg:'Displaying records {0} - {1} of {2}', emptyMsg:"No records to display" }); Somewhere after this is your mygrid.reconfigure(ds,cm), which will reload the grid with the changes. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Paul Stewart wrote: > Hi, I have been using the CFgrid tag in CF8 (format HTML, bound to a > cfc), and i have got it do almost all that i need it do (see below). > Except that i don't know how to get access to the TOTALROWCOUNT figure > that i can see in the debugger returned from the CFC , and also be able > to display that figure either on the bottom of the grid itself (using > ext.toolbar???), or even above it on the page using another ajax method??. > > I need to do this show the user amount of records returned from his/her > search. i.e 'your search returned x number of records.' From reading Ray > Camden's blog I know i have to use the underlying Ext library that the > cfgrid tag is based on, and i have used his solution to format some > columns in the grid (nice one Ray). But i am not really getting anywhere > (hopelessly bamboozled) with the records returned figure. > > If any kind person would like to me help me i would be indebted to them. > > > > > > > myf = function(data,cellmd,record,row,col,store) { > return "£ " + data; > > } > formatgrid = function() { >mygrid = ColdFusion.Grid.getGridObject('ad'); > >cm = mygrid.getColumnModel(); >cm.setRenderer(3,myf); >cm.setRenderer(5,myf); > >mygrid.reconfigure(mygrid.getDataSource(),cm); > } > > > > > bind="cfc:search.doFranchiseSearch({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},{form2:regionId},{form2:countyId},{form2:franchiseTypeDescription},{form2:cat2},{form2:IndustrySectorName},{form2:cat})" > > format="html"> > > hrefkey="Id" display=true header="Franchise" /> > > header="MTI - £" /> > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF7 and Axis 1.4
Has anybody upgraded CF7 to Axis 1.3 or even version 1.4? Any pointers greatly received. Stewart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IP Address to Country API
On 1/15/08, Coldfusion Monkey <[EMAIL PROTECTED]> wrote: > Just wondering if you guys are aware of any negatives in using this service > like updates to db, uptime,speed etc. I've had some issues with coverage and accuracy with hostip...when I was first testing it, I had a friend in New Bern, NC test the app. It didn't know where they were. But since it is a community populated database, this person just input their information, and the next query returned the correct location. Of course, that also points out that there isn't much checking on the validity of the data that is input. Right now it puts my IP as Charlotte, NC, while I am 150+ miles away in Raleigh, NC. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Ajax CFgrid in cf8 help
Hi, I have been using the CFgrid tag in CF8 (format HTML, bound to a cfc), and i have got it do almost all that i need it do (see below). Except that i don't know how to get access to the TOTALROWCOUNT figure that i can see in the debugger returned from the CFC , and also be able to display that figure either on the bottom of the grid itself (using ext.toolbar???), or even above it on the page using another ajax method??. I need to do this show the user amount of records returned from his/her search. i.e 'your search returned x number of records.' From reading Ray Camden's blog I know i have to use the underlying Ext library that the cfgrid tag is based on, and i have used his solution to format some columns in the grid (nice one Ray). But i am not really getting anywhere (hopelessly bamboozled) with the records returned figure. If any kind person would like to me help me i would be indebted to them. myf = function(data,cellmd,record,row,col,store) { return "£ " + data; } formatgrid = function() { mygrid = ColdFusion.Grid.getGridObject('ad'); cm = mygrid.getColumnModel(); cm.setRenderer(3,myf); cm.setRenderer(5,myf); mygrid.reconfigure(mygrid.getDataSource(),cm); } -- Paul Stewart Developer www.whichfranchise.com The information contained in this message is confidential and is intended for the addressee only. If you have received this message in error or there are any problems please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. whichfranchise will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on. Unless expressly stated to the contrary, this email and its contents shall not have any contractually binding effect on whichfranchise or its clients and any writings which are or could form the basis of any agreement are subject to contract. www.whichfranchise.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CGI parameters
Well before that i had CF8 (developper) installed as a war app above tomcat (apache wasn't involved) and it was already giving me this problem. I read something about a proxy redirecting the requests - i don't think that it's the case. It's very strange. If anyone has something to suggest? :) Ben On Jan 16, 2008 8:05 AM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Wednesday 16 Jan 2008, benjamin schwartz wrote: > > No. :) I thought of that. > > And it's a normal CF8 install via Apache ? Maybe (on Macs) CF sees this as > Apache requesting the files, not the end user ? > > -- > Tom Chiverton > Helping to elementarily promote low-risk platforms > on: http://thefalken.livejournal.com > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England > and Wales under registered number OC307980 whose registered office address > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. > A list of members is available for inspection at the registered office. Any > reference to a partner in relation to Halliwells LLP means a member of > Halliwells LLP. Regulated by The Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and > may be confidential or legally privileged. If you are not the addressee you > must not read it and must not use any information contained in nor copy it > nor inform any person other than Halliwells LLP or the addressee of its > existence or contents. If you have received this email in error please > delete it and notify Halliwells LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CGI parameters
On Wednesday 16 Jan 2008, benjamin schwartz wrote: > No. :) I thought of that. And it's a normal CF8 install via Apache ? Maybe (on Macs) CF sees this as Apache requesting the files, not the end user ? -- Tom Chiverton Helping to elementarily promote low-risk platforms on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CGI parameters
No. :) I thought of that. On Jan 16, 2008 7:29 AM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Wednesday 16 Jan 2008, Ben S wrote: > > Here is the problem when i try to get a client IP address using > > #cgi.REMOTE_ADDR# i get the ip address of the server. > > Are you running the web browser on the same host as the web server ? > > -- > Tom Chiverton > Helping to revolutionarily scale dot-com meta-services > on: http://thefalken.livejournal.com > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England > and Wales under registered number OC307980 whose registered office address > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. > A list of members is available for inspection at the registered office. Any > reference to a partner in relation to Halliwells LLP means a member of > Halliwells LLP. Regulated by The Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and > may be confidential or legally privileged. If you are not the addressee you > must not read it and must not use any information contained in nor copy it > nor inform any person other than Halliwells LLP or the addressee of its > existence or contents. If you have received this email in error please > delete it and notify Halliwells LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296652 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CGI parameters
On Wednesday 16 Jan 2008, Ben S wrote: > Here is the problem when i try to get a client IP address using > #cgi.REMOTE_ADDR# i get the ip address of the server. Are you running the web browser on the same host as the web server ? -- Tom Chiverton Helping to revolutionarily scale dot-com meta-services on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296651 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CGI parameters
Hi, I just installed CF 8 Standard (running on os X - with apache serving the files). Here is the problem when i try to get a client IP address using #cgi.REMOTE_ADDR# i get the ip address of the server. I was reading a thread on here about a similar problem and someone suggested using #CGI.HTTP_X_FORWARDED_FOR# #CGI.HTTP_X_FORWARDED# #CGI.HTTP_FORWARDED_FOR# or #CGI.HTTP_FORWARDED# but they don't come back with anything and indeed if i do a cfdump for CGI i don't get those variables. Would anyone know why my server is behaving like that? Thanks in advance Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: beat a dead horse?
Glad to be of help. -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: 15 January 2008 16:32 To: CF-Talk Subject: Re: beat a dead horse? Many thanks, Will, this is exactly what caused the problem which initially I did not expect, I wished I checked this thread first 45 minutes ago. One problem with FF2 remains though, that is, the following code would return a full window instead of current window (what size it may be) To everyone else, many thanks as well. Don >Make sure you've nested your cfform tags properly: > > > > > > > > > > > >Will prevent the content from displaying. > > > > > > > > > > >Will display the content. > >I ran into this the other day. Might be your problem. > >You could also try using a plain instead and see if that works. > >Cheers > >Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296649 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 Report Builder on Vista Home Premium
Hi, I would like to know if anyone had encountered this same problem on Vista when using CF 8 Report Builder: - cannot import/export styles. On the Report Styles window, click "Export Report Styles", the save dialog window will be displayed, then enter the filename and click save button. The problem would be that the file you had just created cannot be found in that directory! I'm not sure if Vista is preventing the Report Builder in creating files. But then, even the import functionality is not behaving properly. The new styles are not present in the report. BTW, my account is an administrator, though i'm not using the administrator account itself when i'm using Report builder. I wil have to try that later, but I have to report now my experience regarding this matter just in case someone can lead me to a fix for that. 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: calendar event
>OK, I feel like an ass now. I'm sorry. From his other thread I see that he >had already put in some up-front work. I guess I'm personally annoyed by >people who don't do any research or attempts before asking for help. Again, >I'm sorry Ravi. > >Sonny. > >P.S. Are you related to the musician with the same name? I searched google and also the following site http://www.bennadel.com/blog/877-ColdFusion-Calendar-Event-Scripting-Inspired-By-Peter-Bell-.htm This site is really good but doesn't cover the part which I am looking for. My approach is following - PatternbaseTable --- Pattern Id--> 0,1,2,3 Pattern value --> daily,weekly,monthly,yearly EventTable - Pattern Id, Start time end time start date end date isRecurence --> which indicates if it is recur event or not. no_of_occurence counter --> to keep track on number of recurrences which are over EventPattern Patternid Primary value secondary value -- 0 [ Daily ] 2NULL --> This row means event is daily and will recur every 2 days 0 [ Daily ] NULL 1 --> This row means recur every weekday 1 [ weekly ] 2 MTW --> this row indicates recur every 2 weeks and the days are M [ monday] T [ tuesday ] and [wednesday] 2 [ Monthly ] xxx --> I am not clear on how to fill for monthly 3 [Yearly ] xxx --> Not clear So i want to know if my approach is clear.If yes then what values should I fill for monthly and yearly. For monthly I am having the options like "The first sunday of every 3 months" For yearly I am having the options like "The first week of march" The values "first" "sunday" are shown in the drop down list. So any expert suggestions. Thanks Ravi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: designing db tables for calendar events
> >what are you ideas so far? what design have you come up with on your > own? > > > >--- > >Azadi Saryev > >Sabai-dee.com > >http://www.sabai-dee.com > > > > > > > >Ravi Shankar wrote: > >> Ravi > > My approach is following > - > PatternbaseTable > --- > Pattern Id--> 0,1,2,3 > Pattern value --> daily,weekly,monthly,yearly > > EventTable > - > Pattern Id, > Start time > end time > start date > end date > isRecurence --> which indicates if it is recur event or not. > no_of_occurence > counter --> to keep track on number of recurrences which are over > > EventPattern > > Patternid Primary value secondary value > -- > 0 [ Daily ] 2NULL --> This row means > event is daily > and will recur every 2 days > 0 [ Daily ] NULL 1 --> This row means recur > every > weekday > 1 [ weekly ] 2 MTW --> this row indicates > recur every > 2 weeks and the days are M > [ monday] T [ tuesday ] and > [wednesday] > 2 [ Monthly ] xxx --> I am not clear on > how to fill for > monthly > 3 [Yearly ] xxx --> Not clear > > So i want to know if my approach is clear.If yes then what values > should I fill for monthly and yearly. > To get a clear incite of what I am taking about,open outlook express > and try to configure a meeting and in the recurrence choose monthly > and yearly. > > Thanks > Ravi > > > I am not clear on how to represent the following The first tuesday of every 3 month. The first tuesday of january In the approach which i have taken. Any suggesstions are welcome. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4