Re: CF vs. Java Web Developer
We brought a java dev over to CF. Worked a treat. Basically no training required and when we need some java we have an expert. Same as java to flex and easy transition. We also use java through out our app and try to use it especialy with lots of string operations as java os sop much faster. They really do go hand in hand. Paul http://blog.kukiel.net On Tue, Jun 21, 2011 at 3:18 AM, scott bloodworth sbloodwo...@rinovelty.com wrote: Have heard that these two skill sets work hand in hand. One can easily learn the other environment fairly easy, is this true? is there a benefit in looking for one or the other in employment? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Resources in New England Area
Try contact Dave: http://www.cfugitives.com/ or Jeff: http://www.ctcfug.com/ There are quite a few CF devs in New England. I was in New Haven for 18 months and went to both CF usergroups. Paul http://blog.kukiel.net On Tue, Jun 21, 2011 at 3:19 AM, scott bloodworth sbloodwo...@rinovelty.com wrote: Looing for any resources in the New England area that maybe searching for employment. Any information would be helpful. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF vs. Java Web Developer
FWIW, I don't think it's that easy to become a good CF developer, either. Yes, it's very easy to learn the language and it's easy to become competent at it (i.e., being able to build something that works). But to actually be good (best practices, advanced topics, etc.) isn't necessarily simple. In fact, because it's so easy to get up and running, in some ways, that might make it harder to become really good, because you don't need to in order to get things done. Java is definitely much more complex -- especially for people just getting started -- and more powerful. But, I believe that if you're someone who is actually good at CF (i.e., you're actually a developer rather than a coder), you can learn Java. Scott On Mon, Jun 20, 2011 at 3:57 PM, Mike Chabot mcha...@gmail.com wrote: I was saying the original statement is false since I would never trivialize the effort needed to become proficient in Java. Becoming a good Java programmer is not easy, as the original statement was implying. -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CGI Variables - CGI.cert_subject won't display
I'm not familiar with that particular CGI variable, but did something change on the IIS side? On Mon, Jun 20, 2011 at 9:04 AM, Bern Weed bernadette.w...@us.army.milwrote: I'm have an application that has been using CGI variables and working fine. It stopped working and I'm not sure why of course. I am using IIS 7 and ColdFusion 9. I can get it to return cgi.auth_user but not the cgi.cert_subject and it was working for both. Anyone have any ideas or know of any patches, settings that would affect this. Thanks. cfif CGI.auth_user IS NOT cfoutput#CGI.cert_subject#/cfoutput cfdump var=#cgi# cfelse CGI variable does not exist /cfif -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CGI Variables - CGI.cert_subject won't display
From the Adobe CF documentation on CGI variables (http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Expressions_8.html): In ColdFusion, these variables are referred to as /CGI environment variables/. CGI Environment variables contain data about the transaction between the browser and the server, such as the IP Address, browser type, and authenticated username. The available CGI variables depend on the browser and server software... Because the available variables depend on the server, browser, and the types of interactions between the two, not all variables are normally available... Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 6/21/2011 5:47 AM, Scott Brady wrote: I'm not familiar with that particular CGI variable, but did something change on the IIS side? On Mon, Jun 20, 2011 at 9:04 AM, Bern Weedbernadette.w...@us.army.milwrote: I'm have an application that has been using CGI variables and working fine. It stopped working and I'm not sure why of course. I am using IIS 7 and ColdFusion 9. I can get it to return cgi.auth_user but not the cgi.cert_subject and it was working for both. Anyone have any ideas or know of any patches, settings that would affect this. Thanks. cfif CGI.auth_user IS NOT cfoutput#CGI.cert_subject#/cfoutput cfdump var=#cgi# cfelse CGI variable does not exist /cfif ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF vs. Java Web Developer
Paul, It goes without saying that string manipulation, whether adding to it or removing it etc., is so much slower in ColdFusion. Something I am guessing a lot of people still are not aware off. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Paul Kukiel [mailto:pkuk...@gmail.com] Sent: Tuesday, 21 June 2011 7:41 PM To: cf-talk Subject: Re: CF vs. Java Web Developer We brought a java dev over to CF. Worked a treat. Basically no training required and when we need some java we have an expert. Same as java to flex and easy transition. We also use java through out our app and try to use it especialy with lots of string operations as java os sop much faster. They really do go hand in hand. Paul http://blog.kukiel.net ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF vs. Java Web Developer
Not really hand in hand both ways... It goes the way you're talking about yes but take a CF programmer and throw them to a Java project and it won't be so graceful a move... The learning curve on the Java side FAR exceeds ColdFusion.. as someone learning Java, I can attest to this. You have to know the basics of Java before you can even get started with web programming in Java. And if the shop you're working with is using a framework, Struts, Spring, etc.. adds more work. So yes, a Java programmer can add a lot to a CF shop, but a ColdFusion programmer adds nothing but headache to a Java shop (at least at first ;) On Tue, Jun 21, 2011 at 4:40 AM, Paul Kukiel pkuk...@gmail.com wrote: We brought a java dev over to CF. Worked a treat. Basically no training required and when we need some java we have an expert. Same as java to flex and easy transition. We also use java through out our app and try to use it especialy with lots of string operations as java os sop much faster. They really do go hand in hand. Paul http://blog.kukiel.net On Tue, Jun 21, 2011 at 3:18 AM, scott bloodworth sbloodwo...@rinovelty.com wrote: Have heard that these two skill sets work hand in hand. One can easily learn the other environment fairly easy, is this true? is there a benefit in looking for one or the other in employment? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
dbvarname mssql cf8?
hi guys and gals. what experience if any does anyone have with this and sql server 2000? it would really help if this worked with sprocs. thanks! tony Tony Weeg Sr. Web Applications Architect Developer Navtrak, Inc. Smart Companies Drive Navtrak www.navtrakgps.com 800.787.2337 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
Hi, MSSQL 2000 does indeed support stored procedures. Russ On Tue, Jun 21, 2011 at 2:54 PM, Tony tonyw...@gmail.com wrote: hi guys and gals. what experience if any does anyone have with this and sql server 2000? it would really help if this worked with sprocs. thanks! tony Tony Weeg Sr. Web Applications Architect Developer Navtrak, Inc. Smart Companies Drive Navtrak www.navtrakgps.com 800.787.2337 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mail processing problems w/ CF 7
On 6/20/2011 5:59 PM, Justin Scott wrote: I started noticing a problem with mail processing on our CF server. I'm seeing a lot of the following in the exception.log file: Is the port number (25) being appended to the mail server hostname in your CF code or in the mail server specification in the CF administrator? What version of the JVM? I have the server port defined as 25 in the Server Settings...Mail admin area. It's not on the mail server itself, nor is it specified in the cfmail tag. It looks like I have the following JVM version: VM version = 1.4.2_09-b05. --Ben -- Ben Conner b...@webworldinc.com Web World, Inc. 888-206-6486 or PO Box 1122 480-704-2000 Queen Creek, AZ 85142 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
wow, thanks. i had no idea :) lol, the subject was more indicative of what my question was... whats up with dbvarname and named parameters in cf8/9? doesnt seem to work (out of the box)... is there a work around? tw On Tue, Jun 21, 2011 at 10:09 AM, Russ Michaels r...@michaels.me.uk wrote: Hi, MSSQL 2000 does indeed support stored procedures. Russ On Tue, Jun 21, 2011 at 2:54 PM, Tony tonyw...@gmail.com wrote: hi guys and gals. what experience if any does anyone have with this and sql server 2000? it would really help if this worked with sprocs. thanks! tony Tony Weeg Sr. Web Applications Architect Developer Navtrak, Inc. Smart Companies Drive Navtrak www.navtrakgps.com 800.787.2337 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF vs. Java Web Developer
Scott, I agree with what you wrote. The original poster seemed to be asking the question from an employment standpoint. As I wrote earlier, anyone is capable of learning anything, but having the ability to learn a skill and actually possessing that skill are different states and have different values to an employer. Most employers want someone who can be productive in their first week, not someone who needs to be sent off to a training class shortly after being hired. Based on his other recent posts, I don't believe the original poster is a computer programmer looking to learn a skill. I believe he is looking for programmers to hire. If this is the case, as others have already suggested, hiring a Java programmer, sending that person to a couple Fig Leaf classes to learn CF, then pairing that person with an experienced CF developer for their first project would be a good way to address the current shortage of good CF programmers in various regions. Rhode Island (where the OP is), is not a hotbed of CF talent, but it is surrounded by some of the world's best universities that pump out a fresh crop of Java programmers every year. -Mike Chabot On Tue, Jun 21, 2011 at 5:46 AM, Scott Brady dsbr...@gmail.com wrote: FWIW, I don't think it's that easy to become a good CF developer, either. Yes, it's very easy to learn the language and it's easy to become competent at it (i.e., being able to build something that works). But to actually be good (best practices, advanced topics, etc.) isn't necessarily simple. In fact, because it's so easy to get up and running, in some ways, that might make it harder to become really good, because you don't need to in order to get things done. Java is definitely much more complex -- especially for people just getting started -- and more powerful. But, I believe that if you're someone who is actually good at CF (i.e., you're actually a developer rather than a coder), you can learn Java. Scott On Mon, Jun 20, 2011 at 3:57 PM, Mike Chabot mcha...@gmail.com wrote: I was saying the original statement is false since I would never trivialize the effort needed to become proficient in Java. Becoming a good Java programmer is not easy, as the original statement was implying. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
I have been using stored procs with SQL 2000 for many years on CF versions 5-9. dbvarnames are ignored in the java versions of ColdFusion. If you pass all the procparams to the stored procedure in the order that they are defined int the stored proc, it works fine. Dean On Tue, Jun 21, 2011 at 10:15 AM, Ras Tafari rastaf...@gmail.com wrote: wow, thanks. i had no idea :) lol, the subject was more indicative of what my question was... whats up with dbvarname and named parameters in cf8/9? doesnt seem to work (out of the box)... is there a work around? tw ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrieve data in groups
Hi All. Is there a way for me to retrieve records from a db in groups? I have a query that selects over 200,000 records and it times out on the cf output. Thanks In relation to this post, what does java heap space mean? I see this message is the log files. I looked this up on google and it appears that I am out of memory (?) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrieve data in groups
Others can address specifics. Meanwhile, you may want to Google coldfusion jvm tuning On Tue, Jun 21, 2011 at 9:47 AM, Torrent Girl moniqueb...@gmail.com wrote: Hi All. Is there a way for me to retrieve records from a db in groups? I have a query that selects over 200,000 records and it times out on the cf output. Thanks In relation to this post, what does java heap space mean? I see this message is the log files. I looked this up on google and it appears that I am out of memory (?) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
sorry, its a poorly constructed question.. are you referring to passing parameters on the cfstoredproc tag? then see this http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:49286 On Tue, Jun 21, 2011 at 3:15 PM, Ras Tafari rastaf...@gmail.com wrote: wow, thanks. i had no idea :) lol, the subject was more indicative of what my question was... whats up with dbvarname and named parameters in cf8/9? doesnt seem to work (out of the box)... is there a work around? tw On Tue, Jun 21, 2011 at 10:09 AM, Russ Michaels r...@michaels.me.uk wrote: Hi, MSSQL 2000 does indeed support stored procedures. Russ On Tue, Jun 21, 2011 at 2:54 PM, Tony tonyw...@gmail.com wrote: hi guys and gals. what experience if any does anyone have with this and sql server 2000? it would really help if this worked with sprocs. thanks! tony Tony Weeg Sr. Web Applications Architect Developer Navtrak, Inc. Smart Companies Drive Navtrak www.navtrakgps.com 800.787.2337 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrieve data in groups
Yes, it means you are likely out of memory, probably because you are loading too much database data into the server's RAM. You can reduce the amount of RAM used by reducing the number of database columns or database rows retrieved by the Web page that is running out of RAM. -Mike Chabot On Tue, Jun 21, 2011 at 10:47 AM, Torrent Girl moniqueb...@gmail.comwrote: Hi All. Is there a way for me to retrieve records from a db in groups? I have a query that selects over 200,000 records and it times out on the cf output. Thanks In relation to this post, what does java heap space mean? I see this message is the log files. I looked this up on google and it appears that I am out of memory (?) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
If you look at the history portion of the docs (http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_14.html#1102102) it states Changed the dbvarname attribute behavior: it is now ignored for all drivers. ColdFusion uses JDBC 2.2 and does not support named parameters. You need to pass the procparams in the the order that they are defined in the stored proc. On Tue, Jun 21, 2011 at 10:53 AM, Russ Michaels r...@michaels.me.uk wrote: sorry, its a poorly constructed question.. are you referring to passing parameters on the cfstoredproc tag? then see this http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:49286 On Tue, Jun 21, 2011 at 3:15 PM, Ras Tafari rastaf...@gmail.com wrote: wow, thanks. i had no idea :) lol, the subject was more indicative of what my question was... whats up with dbvarname and named parameters in cf8/9? doesnt seem to work (out of the box)... is there a work around? tw On Tue, Jun 21, 2011 at 10:09 AM, Russ Michaels r...@michaels.me.uk wrote: Hi, MSSQL 2000 does indeed support stored procedures. Russ On Tue, Jun 21, 2011 at 2:54 PM, Tony tonyw...@gmail.com wrote: hi guys and gals. what experience if any does anyone have with this and sql server 2000? it would really help if this worked with sprocs. thanks! tony Tony Weeg Sr. Web Applications Architect Developer Navtrak, Inc. Smart Companies Drive Navtrak www.navtrakgps.com 800.787.2337 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
i know, i checked that too, this was my last hope... i did say work-around :( all good, not using cfstoredproc anymore, we are just going to use straight sql. i wonder why this was put to no longer supported status On Tue, Jun 21, 2011 at 11:19 AM, Dean Lawrence dean...@gmail.com wrote: If you look at the history portion of the docs (http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_14.html#1102102) it states Changed the dbvarname attribute behavior: it is now ignored for all drivers. ColdFusion uses JDBC 2.2 and does not support named parameters. You need to pass the procparams in the the order that they are defined in the stored proc. On Tue, Jun 21, 2011 at 10:53 AM, Russ Michaels r...@michaels.me.uk wrote: sorry, its a poorly constructed question.. are you referring to passing parameters on the cfstoredproc tag? then see this http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:49286 On Tue, Jun 21, 2011 at 3:15 PM, Ras Tafari rastaf...@gmail.com wrote: wow, thanks. i had no idea :) lol, the subject was more indicative of what my question was... whats up with dbvarname and named parameters in cf8/9? doesnt seem to work (out of the box)... is there a work around? tw On Tue, Jun 21, 2011 at 10:09 AM, Russ Michaels r...@michaels.me.uk wrote: Hi, MSSQL 2000 does indeed support stored procedures. Russ On Tue, Jun 21, 2011 at 2:54 PM, Tony tonyw...@gmail.com wrote: hi guys and gals. what experience if any does anyone have with this and sql server 2000? it would really help if this worked with sprocs. thanks! tony Tony Weeg Sr. Web Applications Architect Developer Navtrak, Inc. Smart Companies Drive Navtrak www.navtrakgps.com 800.787.2337 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
Ras, I don't understand why you would abandon your stored procs. All you need to do is remove the dbvarname attribute and pass the cfprocparam tags in the order that the parameters are defined in the stored proc itself and it works. As for the change in status, if you look at the history comment, it is the JDBC drive that no longer supports named parameters, not just a random decision to stop supporting them. On Tue, Jun 21, 2011 at 11:24 AM, Ras Tafari rastaf...@gmail.com wrote: i know, i checked that too, this was my last hope... i did say work-around :( all good, not using cfstoredproc anymore, we are just going to use straight sql. i wonder why this was put to no longer supported status -- --- Dean M. Lawrence INTERNET DATA TECHNOLOGY p // 888.438.4381 ext. 701 w // www.idatatech.com f // www.facebook.com/idatatech t // www.twitter.com/idatatech Social Marketing | SEO | Design | Internet Development ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
my dba needs me to be able to pass those in like that, so that he can have parameters that i may not use, that our .net guys are using. they have the ability to do this, cf is lacking :( On Tue, Jun 21, 2011 at 11:42 AM, Dean Lawrence dean...@gmail.com wrote: Ras, I don't understand why you would abandon your stored procs. All you need to do is remove the dbvarname attribute and pass the cfprocparam tags in the order that the parameters are defined in the stored proc itself and it works. As for the change in status, if you look at the history comment, it is the JDBC drive that no longer supports named parameters, not just a random decision to stop supporting them. On Tue, Jun 21, 2011 at 11:24 AM, Ras Tafari rastaf...@gmail.com wrote: i know, i checked that too, this was my last hope... i did say work-around :( all good, not using cfstoredproc anymore, we are just going to use straight sql. i wonder why this was put to no longer supported status -- --- Dean M. Lawrence INTERNET DATA TECHNOLOGY p // 888.438.4381 ext. 701 w // www.idatatech.com f // www.facebook.com/idatatech t // www.twitter.com/idatatech Social Marketing | SEO | Design | Internet Development ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
Ah, I see. That makes sense, though it's not a CF issue, it is a JDBC issue. Another option would be for your dba to create an additional sp which calls the original sp and contains just the params that you need. Just a thought. On Tue, Jun 21, 2011 at 11:43 AM, Ras Tafari rastaf...@gmail.com wrote: my dba needs me to be able to pass those in like that, so that he can have parameters that i may not use, that our .net guys are using. they have the ability to do this, cf is lacking :( On Tue, Jun 21, 2011 at 11:42 AM, Dean Lawrence dean...@gmail.com wrote: Ras, I don't understand why you would abandon your stored procs. All you need to do is remove the dbvarname attribute and pass the cfprocparam tags in the order that the parameters are defined in the stored proc itself and it works. As for the change in status, if you look at the history comment, it is the JDBC drive that no longer supports named parameters, not just a random decision to stop supporting them. On Tue, Jun 21, 2011 at 11:24 AM, Ras Tafari rastaf...@gmail.com wrote: i know, i checked that too, this was my last hope... i did say work-around :( all good, not using cfstoredproc anymore, we are just going to use straight sql. i wonder why this was put to no longer supported status -- --- Dean M. Lawrence INTERNET DATA TECHNOLOGY p // 888.438.4381 ext. 701 w // www.idatatech.com f // www.facebook.com/idatatech t // www.twitter.com/idatatech Social Marketing | SEO | Design | Internet Development ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: dbvarname mssql cf8?
Do all JDBC drivers ignore @dbvarname? If not (and if CF actually passes it) then maybe you can get the MS (or another company's) JDBC drivers and use them instead. Steve -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Tuesday, June 21, 2011 11:53 AM To: cf-talk Subject: Re: dbvarname mssql cf8? Ah, I see. That makes sense, though it's not a CF issue, it is a JDBC issue. Another option would be for your dba to create an additional sp which calls the original sp and contains just the params that you need. Just a thought. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL Query Problem
Two tables each containing a shared primary key ID. I am trying to create a query that lists records from table B that are not in table A. Many thanks, Jenny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
select * from b where id not in (select id from a) On Tue, Jun 21, 2011 at 12:37 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Two tables each containing a shared primary key ID. I am trying to create a query that lists records from table B that are not in table A. Many thanks, Jenny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
if your tables are large, you'll probably see a better performance from select id from TableA a where not exists (select 1 from TableB b where a.id = b.id) On Tue, Jun 21, 2011 at 12:41 PM, John M Bliss bliss.j...@gmail.com wrote: select * from b where id not in (select id from a) On Tue, Jun 21, 2011 at 12:37 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Two tables each containing a shared primary key ID. I am trying to create a query that lists records from table B that are not in table A. Many thanks, Jenny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Query Problem
Thanks John and Greg :) -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: 21 June 2011 18:45 To: cf-talk Subject: Re: SQL Query Problem if your tables are large, you'll probably see a better performance from select id from TableA a where not exists (select 1 from TableB b where a.id = b.id) On Tue, Jun 21, 2011 at 12:41 PM, John M Bliss bliss.j...@gmail.com wrote: select * from b where id not in (select id from a) On Tue, Jun 21, 2011 at 12:37 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Two tables each containing a shared primary key ID. I am trying to create a query that lists records from table B that are not in table A. Many thanks, Jenny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
How about: select b.* from b left outer join a on b.id = a.id where a.id is null Carl On 6/21/2011 10:37 AM, Jenny Gavin-Wear wrote: Two tables each containing a shared primary key ID. I am trying to create a query that lists records from table B that are not in table A. Many thanks, Jenny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
I would do it this way : select b.* from b where b.id not in (select a.id from a) How about: select b.* from b left outer join a on b.id = a.id where a.id is null Carl On 6/21/2011 10:37 AM, Jenny Gavin-Wear wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
That looks familiar! :-) On Tue, Jun 21, 2011 at 1:09 PM, Stephane Vantroyen s...@emakina.com wrote: I would do it this way : select b.* from b where b.id not in (select a.id from a) How about: select b.* from b left outer join a on b.id = a.id where a.id is null Carl On 6/21/2011 10:37 AM, Jenny Gavin-Wear wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Query Problem
Looks like I went with the vote, lol Many thanks for all replies, and fast too :) Some payments from Paypal transactions, some manually entered on profiles. Legacy code :/ Jenny select * from tbl_members where (datepart(m,paid) = #session.month# and datepart(,paid) = #session.year# AND memberID not in (select memberID from tbl_paypal where datepart(m, payment_date) = #session.month# and datepart(,payment_date) = #session.year# )) order by paid ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
Off topic, but the Select * made me shudder. On Tue, Jun 21, 2011 at 2:25 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Looks like I went with the vote, lol Many thanks for all replies, and fast too :) Some payments from Paypal transactions, some manually entered on profiles. Legacy code :/ Jenny select * from tbl_members where (datepart(m,paid) = #session.month# and datepart(,paid) = #session.year# AND memberID not in (select memberID from tbl_paypal where datepart(m, payment_date) = #session.month# and datepart(,payment_date) = #session.year# )) order by paid ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
+420 On Tue, Jun 21, 2011 at 2:45 PM, Michael Grant mgr...@modus.bz wrote: Off topic, but the Select * made me shudder. On Tue, Jun 21, 2011 at 2:25 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Looks like I went with the vote, lol Many thanks for all replies, and fast too :) Some payments from Paypal transactions, some manually entered on profiles. Legacy code :/ Jenny select * from tbl_members where (datepart(m,paid) = #session.month# and datepart(,paid) = #session.year# AND memberID not in (select memberID from tbl_paypal where datepart(m, payment_date) = #session.month# and datepart(,payment_date) = #session.year# )) order by paid ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
She didn't provide column names... On Tue, Jun 21, 2011 at 1:45 PM, Michael Grant mgr...@modus.bz wrote: Off topic, but the Select * made me shudder. On Tue, Jun 21, 2011 at 2:25 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Looks like I went with the vote, lol Many thanks for all replies, and fast too :) Some payments from Paypal transactions, some manually entered on profiles. Legacy code :/ Jenny select * from tbl_members where (datepart(m,paid) = #session.month# and datepart(,paid) = #session.year# AND memberID not in (select memberID from tbl_paypal where datepart(m, payment_date) = #session.month# and datepart(,payment_date) = #session.year# )) order by paid ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
my dba needs me to be able to pass those in like that, so that he can have parameters that i may not use, that our .net guys are using. Pass in nulls or defaults for those values. they have the ability to do this, cf is lacking :( This is a Java thing, not a CF thing. JDBC simply doesn't do named parameters. There are various workarounds for that in the Java world, but they're kind of a pain even there. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dbvarname mssql cf8?
Do all JDBC drivers ignore @dbvarname? Yes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrieve data in groups
In relation to this post, what does java heap space mean? I see this message is the log files. I looked this up on google and it appears that I am out of memory (?) Yes, the Java heap is roughly analogous to the amount of memory available to the JVM. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Query Problem
I was waiting for a comment on that. It's a very small table :) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 21 June 2011 19:46 To: cf-talk Subject: Re: SQL Query Problem Off topic, but the Select * made me shudder. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Retrieve data in groups
My thought was that by using a stored procedure to make your database changes you wouldn't need to carry out the operations against sub-sets of the data because having SQL server carry out the operations would be so much faster. Jenny -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: 20 June 2011 14:55 To: cf-talk Subject: Re: Retrieve data in groups Hi Torrent, Perhaps by running the query on the server using a stored proceedure? Take a look at this guide: http://www.adobe.com/devnet/coldfusion/articles/stored_procs.html It looks so good I'll be using it myself, lol Jenny Gavin-Wear Fast Track eCommerce +44 (0) 1262 602013 http://www.ftol-ecommerce.com/ Great. Checking it out now. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF and Microsoft Team Server
I believe that TFS has a one off source control product and tickling the back of my brain is a web client for it. yup http://SERVERNAME:8080/tfs/web Though you can't do integrated stuff with it. On Wed, Jun 15, 2011 at 2:42 PM, Larry Lyons larrycly...@gmail.com wrote: Hi All, We're in a mixed CF and .Net shop. The Powers-That-Be have decided to go with MS Team Foundation Server for our versioning and revision control system. I've never worked with TFS and was wondering how difficult or easy it is to work with it, given that we really do not use Visual Studio - mostly CFBuilder or Dreamweaver. Are there any other ways of committing, branching, merging, and checking out from TFS other than using Visual Studio. Any suggestions would be most appreciated. many thanks, larry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
Right, but if that table grows and columns are added, the overhead on your query will grow. Having a small table makes it even easier to define the columns in your select list. And, if you have any dynamic code that relies on your column list it will likely break if you end up adding columns to the table. Or if you have to hand off your code to another developer they can't simply look at your query statement and glean what's being returned without having access to the db or without dumping the query.columnList. There's just so many reasons why defining your column list is a good idea, and none where not defining it is. Not trying to preach, but this bit of convenience is just so unnecessary and has such potential for problems that it's not even worth considering in my opinion. It's just such a horrible habit. Anyway, as you were. :) /soapbox On Tue, Jun 21, 2011 at 5:15 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I was waiting for a comment on that. It's a very small table :) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 21 June 2011 19:46 To: cf-talk Subject: Re: SQL Query Problem Off topic, but the Select * made me shudder. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Query Problem
Hi Michael, The (very old) web site is about to be completely redeveloped, so I'm really not too worried. Appreciate your concern though :) Jenny -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 21 June 2011 23:27 To: cf-talk Subject: Re: SQL Query Problem Right, but if that table grows and columns are added, the overhead on your query will grow. Having a small table makes it even easier to define the columns in your select list. And, if you have any dynamic code that relies on your column list it will likely break if you end up adding columns to the table. Or if you have to hand off your code to another developer they can't simply look at your query statement and glean what's being returned without having access to the db or without dumping the query.columnList. There's just so many reasons why defining your column list is a good idea, and none where not defining it is. Not trying to preach, but this bit of convenience is just so unnecessary and has such potential for problems that it's not even worth considering in my opinion. It's just such a horrible habit. Anyway, as you were. :) /soapbox On Tue, Jun 21, 2011 at 5:15 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I was waiting for a comment on that. It's a very small table :) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 21 June 2011 19:46 To: cf-talk Subject: Re: SQL Query Problem Off topic, but the Select * made me shudder. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
*thumbs up* On Tue, Jun 21, 2011 at 7:27 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Michael, The (very old) web site is about to be completely redeveloped, so I'm really not too worried. Appreciate your concern though :) Jenny -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 21 June 2011 23:27 To: cf-talk Subject: Re: SQL Query Problem Right, but if that table grows and columns are added, the overhead on your query will grow. Having a small table makes it even easier to define the columns in your select list. And, if you have any dynamic code that relies on your column list it will likely break if you end up adding columns to the table. Or if you have to hand off your code to another developer they can't simply look at your query statement and glean what's being returned without having access to the db or without dumping the query.columnList. There's just so many reasons why defining your column list is a good idea, and none where not defining it is. Not trying to preach, but this bit of convenience is just so unnecessary and has such potential for problems that it's not even worth considering in my opinion. It's just such a horrible habit. Anyway, as you were. :) /soapbox On Tue, Jun 21, 2011 at 5:15 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I was waiting for a comment on that. It's a very small table :) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 21 June 2011 19:46 To: cf-talk Subject: Re: SQL Query Problem Off topic, but the Select * made me shudder. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF vs. Java Web Developer
I agree. My perspective came as one sided as we take on people new to CF and commign from java is fine. ( we don't hire CF people to train them in java ) If we took one of our younger devs from CF and tried to teach them java it would be alot harder if you didn't have a CS background or OO experience in another language. Paul. On Tue, Jun 21, 2011 at 10:51 PM, Greg Morphis gmorp...@gmail.com wrote: Not really hand in hand both ways... It goes the way you're talking about yes but take a CF programmer and throw them to a Java project and it won't be so graceful a move... The learning curve on the Java side FAR exceeds ColdFusion.. as someone learning Java, I can attest to this. You have to know the basics of Java before you can even get started with web programming in Java. And if the shop you're working with is using a framework, Struts, Spring, etc.. adds more work. So yes, a Java programmer can add a lot to a CF shop, but a ColdFusion programmer adds nothing but headache to a Java shop (at least at first ;) On Tue, Jun 21, 2011 at 4:40 AM, Paul Kukiel pkuk...@gmail.com wrote: We brought a java dev over to CF. Worked a treat. Basically no training required and when we need some java we have an expert. Same as java to flex and easy transition. We also use java through out our app and try to use it especialy with lots of string operations as java os sop much faster. They really do go hand in hand. Paul http://blog.kukiel.net On Tue, Jun 21, 2011 at 3:18 AM, scott bloodworth sbloodwo...@rinovelty.com wrote: Have heard that these two skill sets work hand in hand. One can easily learn the other environment fairly easy, is this true? is there a benefit in looking for one or the other in employment? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfinclude on a flash form not working with Chrome
Having difficulties trying to get this to work with Chrome. This is inside a Flash Form on CF8. Works great on IE, FF and Safari, but won't come up on Chrome. Seems there are a lot of Flash Form issues with Chrome when I Googled the problem, but nothing specific on the CFINCLUDE. Can anyone help me out here on how to solve this problem? cfformitem type=text width=720cfinclude template=../uploads/agreement_section1.txt/cfformitem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfinclude on a flash form not working with Chrome
but nothing specific on the CFINCLUDE. Since cfinclude is processed server side and chrome is your client side browser, I would think you could likely eliminate the cfinclude as part of the problem. If you paste the contents of agreement_section1.txt between the cfformitem tags does it work in Chrome? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
