ColdFusion Developer Opportunity - Raleigh/Durham, NC
Piper Enterprise Solutions is seeking a ColdFusion Developer for a contract opportunity in Chapel Hill, North Carolina (NC). The ColdFusion developer responsibilities will include developing and supporting applications to improve the Office of Research. Using different applications, the ColdFusion Developer will aid in research compliance and clinical trials. On the office environment side, the ColdFusion Developer must be a self starter and will work with a team of 12 developers and an IT group of 25. Requirement and qualifications for the ColdFusion Developer include the following: 3+ years of ColdFusion experience 3+ years of experience with SQL Server and the ability to write queries, understand database schemas and structures 3+ years of experience with HTML, CSS, JavaScript, JQuery ColdBox experience a plus, but not required This is a long term contract opportunity. Compensation: $38-$48 per hour. Total Compensation package will be determined by recent salary history and relevant work experience. Please email ONLY qualified resumes to Chloe Smith at csm...@piperes.com ~| 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:359199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
AJAX request returning 304
I have an ajax request calling a ColdFusion template. Each time the ajax function is called, the ColdFusion template should return the next 20 rows of a query. I am running into an issue where the browser thinks the ColdFusion template hasn't changed since a 304 http status code is returned. I don't have an html or head tag in the CF template, so I don't believe a cfheader tag will work. Does anyone know how to prevent a CF template from returning a 304 http status code? Thanks, Donnie Carvajal ~| 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:359200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Querying a comma separated list
Your query should be: select * from pgallery where gtype = 1 if you only want items with a gtype of 1 or select * from pgallery where gtype IN (1,2,3,4) if you want multiple types. You can also set a variable of such as gtypelist =1,2,3,4) then do select * from pgallery where gtype IN (#gtypelist) On Tue, Aug 26, 2014 at 8:13 PM, te...@it-werks.com te...@it-werks.com te...@it-werks.com wrote: I haven't done this is ages and could use some help, please. Now here's where I screw up: cfquery name=getslides datasource=#dsn# select * from pgallery where listContains(gtype, 1) /cfquery ~| 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:359201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Querying a comma separated list
I assume from the example you are storing the a comma delimited list in the Field gtype and need to query all records that match one or more items from the stored list. Here are some ways to accomplish what you want to do plus some other tricks. http://www.sommarskog.se/arrays-in-sql-2005.html Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.com -Original Message- From: te...@it-werks.com te...@it-werks.com [mailto:te...@it-werks.com] Sent: Tuesday, August 26, 2014 8:13 PM To: cf-talk Subject: Querying a comma separated list I haven't done this is ages and could use some help, please. Here I define a list of checkboxes of picture types: input type=checkbox name=tt value=1 cfif gtype contains '1'checked/cfifSolidbr input type=checkbox name=tt value=2 cfif gtype contains '2'checked/cfifOpenbr input type=checkbox name=tt value=3 cfif gtype contains '3'checked/cfifInsulatedbr input type=checkbox name=tt value=4 cfif gtype contains '4'checked/cfifCombinationbr At form submit I update the record: cfquery name=upcontent datasource=#dsn# maxrows=1 update pgallery set gtype = '#tt#' where id = #picid# /cfquery Now here's where I screw up: cfquery name=getslides datasource=#dsn# select * from pgallery where listContains(gtype, 1) /cfquery Here;s the error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'listContains' in expression. Terry ~| 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:359203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: AJAX request returning 304
Donnie, I don't see a reason why a cfheader tag wouldn't work, and if it fails it's easy enough to add in the missing tags. Personally, I would convert it to a function in a cfc. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: Donnie Carvajal donnie.carva...@transformyx.com Sent: Wednesday, August 27, 2014 1:00 PM To: cf-talk Subject: AJAX request returning 304 I have an ajax request calling a ColdFusion template. Each time the ajax function is called, the ColdFusion template should return the next 20 rows of a query. I am running into an issue where the browser thinks the ColdFusion template hasn't changed since a 304 http status code is returned. I don't have an html or head tag in the CF template, so I don't believe a cfheader tag will work. Does anyone know how to prevent a CF template from returning a 304 http status code? Thanks, Donnie Carvajal ~| 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:359202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Querying a comma separated list
What I have seen done in these situations is to search where = the value or one of several like statements. where field = 'value' or field like 'value,%' or field like '%,value,%' or field like '%,value' David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: UXB denn...@uxbinternet.com Sent: Wednesday, August 27, 2014 1:46 PM To: cf-talk Subject: RE: Querying a comma separated list I assume from the example you are storing the a comma delimited list in the Field gtype and need to query all records that match one or more items from the stored list. Here are some ways to accomplish what you want to do plus some other tricks. http://www.sommarskog.se/arrays-in-sql-2005.html Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.com -Original Message- From: te...@it-werks.com te...@it-werks.com [mailto:te...@it-werks.com] Sent: Tuesday, August 26, 2014 8:13 PM To: cf-talk Subject: Querying a comma separated list I haven't done this is ages and could use some help, please. Here I define a list of checkboxes of picture types: input type=checkbox name=tt value=1 cfif gtype contains '1'checked/cfifSolidbr input type=checkbox name=tt value=2 cfif gtype contains '2'checked/cfifOpenbr input type=checkbox name=tt value=3 cfif gtype contains '3'checked/cfifInsulatedbr input type=checkbox name=tt value=4 cfif gtype contains '4'checked/cfifCombinationbr At form submit I update the record: cfquery name=upcontent datasource=#dsn# maxrows=1 update pgallery set gtype = '#tt#' where id = #picid# /cfquery Now here's where I screw up: cfquery name=getslides datasource=#dsn# select * from pgallery where listContains(gtype, 1) /cfquery Here;s the error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'listContains' in expression. Terry ~| 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:359204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
isvalid(url) issue
ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value -- John Bliss - http://www.linkedin.com/in/jbliss ~| 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:359205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isvalid(url) issue
you are better off using your own regex to define what you consider to be valid. you may find something specific on cflib.org or riaforge.org or there is always http://www.validatethis.org/ On Wed, Aug 27, 2014 at 7:02 PM, John M Bliss bliss.j...@gmail.com wrote: ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value -- John Bliss - http://www.linkedin.com/in/jbliss ~| 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:359206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isvalid(url) issue
This seems better: http://cflib.org/udf/isURL On Wed, Aug 27, 2014 at 2:19 PM, Russ Michaels r...@michaels.me.uk wrote: you are better off using your own regex to define what you consider to be valid. you may find something specific on cflib.org or riaforge.org or there is always http://www.validatethis.org/ On Wed, Aug 27, 2014 at 7:02 PM, John M Bliss bliss.j...@gmail.com wrote: ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value -- John Bliss - http://www.linkedin.com/in/jbliss ~| 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:359207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isvalid(url) issue
Wonder if encoding your query string values would result in a positive response. Byron Mann Lead Engineer Architect HostMySite.com On Aug 27, 2014 2:03 PM, John M Bliss bliss.j...@gmail.com wrote: ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value -- John Bliss - http://www.linkedin.com/in/jbliss ~| 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:359208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isvalid(url) issue
anyhting is probably better, isValid() seems to be quite unreliable judging by the number of posts I have seen saying it doesn't work. it would be interesting to see what it thinks about itself :-) IsValid( IsValid() ) On Wed, Aug 27, 2014 at 7:21 PM, John M Bliss bliss.j...@gmail.com wrote: This seems better: http://cflib.org/udf/isURL On Wed, Aug 27, 2014 at 2:19 PM, Russ Michaels r...@michaels.me.uk wrote: you are better off using your own regex to define what you consider to be valid. you may find something specific on cflib.org or riaforge.org or there is always http://www.validatethis.org/ On Wed, Aug 27, 2014 at 7:02 PM, John M Bliss bliss.j...@gmail.com wrote: ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value -- John Bliss - http://www.linkedin.com/in/jbliss ~| 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:359209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isvalid(url) issue
ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value Just to be clear... it's saying it's not a valid URL because it's *not* a valid URL. You need to encode some of the characters in http://www.domain.com/path/page.htm http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value for it to be a valid value in a URL query string. The RFC is pretty clear on this (http://tools.ietf.org/html/rfc3986#appendix-A). Once you deal with that, then the URL passes validation. Interestingly (stretching the definition a bit) ColdFusion 11 has a regression here: it passes your dodgy string as a valid URL. Railo does too. -- Adam ~| 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:359210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Excel Problem...
You might also try saving the output as CSV and opening it in excel that way. Its an annoying workaround but may work. AS for CF8, ask about Railo then - its FOSS, and is faster than ACF. So what is the specific error? Is it in CF or Excel. If Excel are you getting this message? Excel actually opens. So, it's an Excel error. However, it just says There's an error with no further information. I *wish* it was the error below, because then I'd have something to go on. The file you are trying to open, '[filename]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? (Yes | No | Help) At this moment in time, upgrading the site in question to a new server isn't an option. I'll review the other options suggested though. Thanks! If so there's a new security feature in Excel According to this MSDN blog: http://blogs.msdn. c om/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning. aspx http://devblog.grinn.net/2008/06/file-you-are-trying-to-open-is-in. html http://stackoverflow. com/questi ons/940045/how-to-suppress-the-file-corrupt-warning-at-excel-download ~| 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:359211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SECS/GEM and ColdFusion
Hi guys, Hello to all. I am looking for help getting SECS/GEM capability to work with a ColdFusion application. Wondering if anyone on this forum has any experience doing this or knows of someone who has. Want to integrate the capability with my manufacturing application. SECS/GEM is a communication standard used in the semiconductor wafer manufacturing industry to connect software with a wide range of equipment. Talk to it, listen to it, program it, download recipes to it. Quite useful in a semiconductor fab. http://en.wikipedia.org/wiki/SECS/GEM Thank you for anything you might be able to offer up. ~Gonzo ~| 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:359213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Could not initialize class coldfusion.security.ESAPIUtils
I have had this a few times and it seems to have been caused by making sandbox changes, specifically when adding createobject(java) to a sandbox. The only solution was to rollback changes. The last occurrence I had was luckily resolved by restarting cf. -Original Message- From: Adam Parker adgpa...@iupui.edu Sent: â27/â08/â2014 21:01 To: cf-talk cf-talk@houseoffusion.com Subject: Re: Could not initialize class coldfusion.security.ESAPIUtils I am currently experiencing this with the following error: Error,ajp-bio-8015-exec-2,08/27/14,19:15:26,cfadmin,Could not initialize class coldfusion.security.ESAPIUtils The specific sequence of files included or processed is: C:\ColdFusion10\cfusion3\wwwroot\CFIDE\administrator\navserver.cfm, line: 248 What was your fix to correct this? Restarting the JVM alleviates the issue, but does not correct the problem. Thank you. ~| 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:359214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm