Re: Dynamic SQL Column Names
Or go runa query on the table with 1 record using a select * and loop through the columnlist returned. On Wed, Apr 14, 2010 at 8:39 PM, Doug Ford doug.e.f...@gmail.com wrote: Hi Folks - I am wracking my brain trying to figure out how to get the results I am looking for. Here's the background - I am dealing with dynamic environment allowing losers, I mean users, to enter in field names. This is a business product so anything is possible. When a user of the product creates the columns, they have no knowledge of coldfusion or sql, so if a person enters in VIN # as a piece of information they wish to capture, VIN # becomes a column header. Now then, on any given random form my system would be creating, I won't know how many fields or their names. If a person creates 5 or 500 fields, I have no clue, and I won't know what column names they could ultimately create. I have been toying with getColumnList() to display the column titles, but how would I get the actual data out of it? I have tried using evaluate on the field names, but when it comes across VIN #, the system blows up. Any and info is appreciated. Thanks, Doug ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Dynamic SQL Column Names
You could create one table that will store dynamic columns and another to store the dynamic columns data. Then if you're using MSSQL 2005+ than you can use SQL Pivots to extract the data dynamically.. if your using anything less than MSSQL 2005 than you could use dynamic SQL and build a temp table. Pivots http://www.sqlprof.com/blogs/sqldev/archive/2008/04/12/pivots-with-dynamic-c olumns-in-sql-server-2005-2008.aspx Regards, Paul Alkema -Original Message- From: Brian Thornton [mailto:vegasthorn...@gmail.com] Sent: Thursday, April 15, 2010 5:21 AM To: cf-talk Subject: Re: Dynamic SQL Column Names Or go runa query on the table with 1 record using a select * and loop through the columnlist returned. On Wed, Apr 14, 2010 at 8:39 PM, Doug Ford doug.e.f...@gmail.com wrote: Hi Folks - I am wracking my brain trying to figure out how to get the results I am looking for. Here's the background - I am dealing with dynamic environment allowing losers, I mean users, to enter in field names. This is a business product so anything is possible. When a user of the product creates the columns, they have no knowledge of coldfusion or sql, so if a person enters in VIN # as a piece of information they wish to capture, VIN # becomes a column header. Now then, on any given random form my system would be creating, I won't know how many fields or their names. If a person creates 5 or 500 fields, I have no clue, and I won't know what column names they could ultimately create. I have been toying with getColumnList() to display the column titles, but how would I get the actual data out of it? I have tried using evaluate on the field names, but when it comes across VIN #, the system blows up. Any and info is appreciated. Thanks, Doug ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Anyone else have the latest CFBuilder crashing constantly?
I'm having the same problem on Win7 64-bit. Build date of CFB shows Feb 27, 2010. -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Friday, March 12, 2010 2:59 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? Cutting and pasting chews through memory very quickly, it was raised as a bug and Adobe just closed it straight away. Now that either means it is fixed or they are not going to fix it so let's see. But as I described to Adobe, I went from 77mb of heap space and after copying and pasting about 5 to 10 times from another file my heap space had grown out to 250mb before ColdFusion Builder then crashed. There are a lot of memory leaks with ColdFusion Builder, that just ends up chewing through memory way to fast. -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, 12 March 2010 2:51 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? For me, CFB beta 3 has been unstable to a point where I went back to text editors to get work done. There is a problem when I cut and paste a lot. Every paste would set off something in CFB which seemed to need to time out before it came back to life. Also, there were problems when I would type a double quote and CFB would go numb on me for a while. I definitely had to watch the screen as I typed since I had no idea when it would go mental on me. I ended up turning off all the helpers in the system which turns it into a fancy text editor and allows me to get work done. I sure hope they fix all these problems before it goes into production. I assumed that there would be another beta, but that may not happen. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 64-bit fails requiring reinstall
Anyone having this problem? We've got 2 developers on Windows 7, with CF9 64-bit installed (not multi-instance), who have each had CF server kack on them after a day of working in it. The service stops (sometimes in the middle of the night when no one is working). In one case this was after a Windows update ran. The system log shows: The ColdFusion 9 Application Server service terminated with service-specific error The system cannot find the file specified. (We suspect a rights issue on this?) The CF log suggests that jvm.config is corrupt. Incidentally, CF9 32-bit has been running flawlessly, but we want to be running 64-bit in production so need to have this resolved. Any and all suggestions are appreciated. Cheers, Kris ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone else have the latest CFBuilder crashing constantly?
I am also having the same problem on Win7 64-bit. It eventually caused me to go back to CFEcilpse. On Thu, Apr 15, 2010 at 9:41 AM, Jason Durham jdur...@cti-stl.com wrote: I'm having the same problem on Win7 64-bit. Build date of CFB shows Feb 27, 2010. -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Friday, March 12, 2010 2:59 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? Cutting and pasting chews through memory very quickly, it was raised as a bug and Adobe just closed it straight away. Now that either means it is fixed or they are not going to fix it so let's see. But as I described to Adobe, I went from 77mb of heap space and after copying and pasting about 5 to 10 times from another file my heap space had grown out to 250mb before ColdFusion Builder then crashed. There are a lot of memory leaks with ColdFusion Builder, that just ends up chewing through memory way to fast. -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, 12 March 2010 2:51 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? For me, CFB beta 3 has been unstable to a point where I went back to text editors to get work done. There is a problem when I cut and paste a lot. Every paste would set off something in CFB which seemed to need to time out before it came back to life. Also, there were problems when I would type a double quote and CFB would go numb on me for a while. I definitely had to watch the screen as I typed since I had no idea when it would go mental on me. I ended up turning off all the helpers in the system which turns it into a fancy text editor and allows me to get work done. I sure hope they fix all these problems before it goes into production. I assumed that there would be another beta, but that may not happen. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone else have the latest CFBuilder crashing constantly?
Same problem here, also on Win 7 64 bit. Went back to CFEclipse less than 2 weeks after CFBuilder was officially released with no fix to this or the page jumping while editing long lines problem. On Thu, Apr 15, 2010 at 10:03 AM, Brandon brandonregis...@gmail.com wrote: I am also having the same problem on Win7 64-bit. It eventually caused me to go back to CFEcilpse. On Thu, Apr 15, 2010 at 9:41 AM, Jason Durham jdur...@cti-stl.com wrote: I'm having the same problem on Win7 64-bit. Build date of CFB shows Feb 27, 2010. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Anyone else have the latest CFBuilder crashing constantly?
Mine crashes 3-4 times a day. Often after a fair amount of copying and pasting it seems. It's quite annoying. Win7 64bit -Original Message- From: Brandon [mailto:brandonregis...@gmail.com] Sent: 15 April 2010 16:04 To: cf-talk Subject: Re: Anyone else have the latest CFBuilder crashing constantly? I am also having the same problem on Win7 64-bit. It eventually caused me to go back to CFEcilpse. On Thu, Apr 15, 2010 at 9:41 AM, Jason Durham jdur...@cti-stl.com wrote: I'm having the same problem on Win7 64-bit. Build date of CFB shows Feb 27, 2010. -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Friday, March 12, 2010 2:59 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? Cutting and pasting chews through memory very quickly, it was raised as a bug and Adobe just closed it straight away. Now that either means it is fixed or they are not going to fix it so let's see. But as I described to Adobe, I went from 77mb of heap space and after copying and pasting about 5 to 10 times from another file my heap space had grown out to 250mb before ColdFusion Builder then crashed. There are a lot of memory leaks with ColdFusion Builder, that just ends up chewing through memory way to fast. -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, 12 March 2010 2:51 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? For me, CFB beta 3 has been unstable to a point where I went back to text editors to get work done. There is a problem when I cut and paste a lot. Every paste would set off something in CFB which seemed to need to time out before it came back to life. Also, there were problems when I would type a double quote and CFB would go numb on me for a while. I definitely had to watch the screen as I typed since I had no idea when it would go mental on me. I ended up turning off all the helpers in the system which turns it into a fancy text editor and allows me to get work done. I sure hope they fix all these problems before it goes into production. I assumed that there would be another beta, but that may not happen. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Anyone else have the latest CFBuilder crashing constantly?
I have the same cut-n-paste memory issues in the production version. I am giving it my 60 day trial before deciding on CFB vs CFE. This cut-n-paste lockup bug is very annoying. I find that I am retyping things rather than cut-n-paste frequently due to the bug. Jason Durham jdur...@cti-stl.com wrote: I'm having the same problem on Win7 64-bit. Build date of CFB shows Feb 27, 2010. -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Friday, March 12, 2010 2:59 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? Cutting and pasting chews through memory very quickly, it was raised as a bug and Adobe just closed it straight away. Now that either means it is fixed or they are not going to fix it so let's see. But as I described to Adobe, I went from 77mb of heap space and after copying and pasting about 5 to 10 times from another file my heap space had grown out to 250mb before ColdFusion Builder then crashed. There are a lot of memory leaks with ColdFusion Builder, that just ends up chewing through memory way to fast. -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, 12 March 2010 2:51 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? For me, CFB beta 3 has been unstable to a point where I went back to text editors to get work done. There is a problem when I cut and paste a lot. Every paste would set off something in CFB which seemed to need to time out before it came back to life. Also, there were problems when I would type a double quote and CFB would go numb on me for a while. I definitely had to watch the screen as I typed since I had no idea when it would go mental on me. I ended up turning off all the helpers in the system which turns it into a fancy text editor and allows me to get work done. I sure hope they fix all these problems before it goes into production. I assumed that there would be another beta, but that may not happen. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 64-bit fails requiring reinstall
Incidentally, CF9 32-bit has been running flawlessly, but we want to be running 64-bit in production so need to have this resolved. But you're not going to be using Windows 7 in production, right? Could you try running it in a VM with your production OS (Windows Server 2008?) I realize that's kind of a pain, but we've been running CF 9 64-bit on Windows Server 2008 with no problems. 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. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone else have the latest CFBuilder crashing constantly?
Have any of you reported this as a bug in the bug tracker? I just received notice from them that a bug I submitted is fixed and planned for updater 1. They are using the bug tracker and they do send out notifications. Wil Genovese http://www.trunkful.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone else have the latest CFBuilder crashing constantly?
And incase someone does not know about or where the bug tracker is located, here it the link. http://cfbugs.adobe.com/bugreport/flexbugui/cfbugtracker/main.html# Wil Genovese http://www.trunkful.com On Thu, Apr 15, 2010 at 10:38 AM, Wil Genovese jugg...@visi.com wrote: Have any of you reported this as a bug in the bug tracker? I just received notice from them that a bug I submitted is fixed and planned for updater 1. They are using the bug tracker and they do send out notifications. Wil Genovese http://www.trunkful.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL Column Names
Hi Leigh - When I was saying System, I meant the CF Server/ web page was producing an error screen. I don't think that having the [col name] will work since a field name might contain a # sign within it. And that would again cause the CF page to fail. Thanks. Doug I am not really clear on your system... But to answer the part I do understand, you can use array notation. #queryName[colName][rowNumber]# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL Column Names
Hi Jason - Thanks for the idea, but I also thought about evaluate, and when CF tries to evaluate the field of Vin #, the server produces an error page. Invalid CFML construct Thanks Also, to address the first example you gave, if this is blowing up on Vin #: #evaluate(columnName)# Then try this: #evaluate(de(columnName))# (if I recall correctly) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cffunction and webservice call question
I am trying to hook up with an ATS vendor for one of my clients that is going to use the ATS (Applicant Tracking System). Here is what the prerequisits say for the ATS vendor regarding the webservice functionality. The vendor must support the post of HR-XML data via HTTPS both to and from their service. We are currently unable to provide other data transfer means, such as FTP or SOAP. How does this change things regarding your SOAP comment? Are they just sending a string of data through url parameters? I think I need to get a better spec sheet from them. Any Feedback? Ken Willis ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL Column Names
Did you actually try it? Leigh's solution is generally the best way to do what you're after (you don't need evaluate). If it really doesn't, you could try (untested): cfset colname = replace(colName,##,,all) / #queryName[colname][rowNumber]# But I'd be surprised if you really need to go that far. :den -- Dolores: I would have been here right after you called, but I had to shake the weasels. On Thu, Apr 15, 2010 at 10:49 AM, Doug Ford wrote: Hi Leigh - When I was saying System, I meant the CF Server/ web page was producing an error screen. I don't think that having the [col name] will work since a field name might contain a # sign within it. And that would again cause the CF page to fail. Thanks. Doug I am not really clear on your system... But to answer the part I do understand, you can use array notation. #queryName[colName][rowNumber]# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL Column Names
You should do some filtering before they go in for script issues and #s unless that's something you absolutely don't want to do.. It's a security thing On Thu, Apr 15, 2010 at 1:29 PM, denstar valliants...@gmail.com wrote: Did you actually try it? Leigh's solution is generally the best way to do what you're after (you don't need evaluate). If it really doesn't, you could try (untested): cfset colname = replace(colName,##,,all) / #queryName[colname][rowNumber]# But I'd be surprised if you really need to go that far. :den -- Dolores: I would have been here right after you called, but I had to shake the weasels. On Thu, Apr 15, 2010 at 10:49 AM, Doug Ford wrote: Hi Leigh - When I was saying System, I meant the CF Server/ web page was producing an error screen. I don't think that having the [col name] will work since a field name might contain a # sign within it. And that would again cause the CF page to fail. Thanks. Doug I am not really clear on your system... But to answer the part I do understand, you can use array notation. #queryName[colName][rowNumber]# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cffunction and webservice call question
I am trying to hook up with an ATS vendor for one of my clients that is going to use the ATS (Applicant Tracking System). Here is what the prerequisits say for the ATS vendor regarding the webservice functionality. The vendor must support the post of HR-XML data via HTTPS both to and from their service. We are currently unable to provide other data transfer means, such as FTP or SOAP. Your ATS vendor sux. How does this change things regarding your SOAP comment? Are they just sending a string of data through url parameters? I think I need to get a better spec sheet from them. Any Feedback? Well, at that point, we're simply talking about accepting HTTP requests and generating responses. There's nothing CFC-specific going on there. They may be sending data via the URL, but they may also be sending it as form variables or even via custom HTTP headers. You need to find out more about what they're doing exactly. 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 ons ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Just FYI - Assembla Repository Offerings
Just wanted to let everyone know about the new Assembla Repository offerings. (And, no, I'm not affiliated, just a satisfied customer) Assembla is offering *free* SVN and GIT Repositories. Here are the specs: - Commercial quality - Unlimited Users - Unlimited spaces - 2 GB storage - Private - Encryption Enabled This is repository only, not tools, but great for backup needs, like mine! Here are the details and rationale: http://blog.assembla.com/assemblablog/tabid/12618/bid/12217/April-14-Repo-Bl itz-Free-unlimited-SVN-and-GIT-and-much-more.aspx No better time to start learning to use SVN! Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Just FYI - Assembla Repository Offerings
2 GB storage Encryption Enabled Private Sweet! Thanx for the heads up Rick. Good call. G! On Thu, Apr 15, 2010 at 2:24 PM, Rick Faircloth r...@whitestonemedia.comwrote: Just wanted to let everyone know about the new Assembla Repository offerings. (And, no, I'm not affiliated, just a satisfied customer) Assembla is offering *free* SVN and GIT Repositories. Here are the specs: - Commercial quality - Unlimited Users - Unlimited spaces - 2 GB storage - Private - Encryption Enabled -- Gerald Guido http://www.myinternetisbroken.com Wait. We can't stop here. This is bat country. -- HST ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL Column Names
@Doug, Did you try evaluate(de(yourVariable)) ? The Dynamic Evaluation [DE()] method should cover you there. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cffunction and webservice call question
Hey Ken, I work with HR-XML some too. I see a lot of companies that do HTTP Post instead of web services. If they are posting straight XML, there is probably not a form field name, so instead you will use getHttpRequestData().content to pull whatever was posted into a variable. -Matt I am trying to hook up with an ATS vendor for one of my clients that is going to use the ATS (Applicant Tracking System). Here is what the prerequisits say for the ATS vendor regarding the webservice functionality. The vendor must support the post of HR-XML data via HTTPS both to and from their service. We are currently unable to provide other data transfer means, such as FTP or SOAP. How does this change things regarding your SOAP comment? Are they just sending a string of data through url parameters? I think I need to get a better spec sheet from them. Any Feedback? Ken Willis ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL Column Names
Did you try evaluate(de(yourVariable)) ? The Dynamic Evaluation [DE()] method should cover you there. That approach doesn't seem to make any sense to me. DE prevents a string from being evaluated in places where evaluation happens automatically (Iif, Evaluate). So evaluate(de(yourVariable)) should be identical to yourVariable. 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL Column Names
Ah, yeah, true. Just used to using the Evaluate(DE()) combo back in the day when outputting blocks of dynamic content, because otherwise the double-quotes in content killed the Evaluate() function. With something like 'Vin #', the DE() adds nothing to the party. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
what is wrong with this code
Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make the fileName get within quotes in javascript. I am getting everything right except in callURL, the fileName is sent as argument, but the real value is not enclosed within quotes. I tried different combinations but its not working. the actual callURL value when outputted should be a href='##' onClick='javascript:return parent.frames[1].XYZ(screen)'Link1/a but the value I am getting right now is a href='##' onClick='javascript:return parent.frames[1].XYZ(screen)'Link1/a Below is the code: function jscript1(){ var theString = 'screen1.cfm' var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a; } ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
I think this'll work: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\fileName\)'Link1/a; On Thu, Apr 15, 2010 at 3:58 PM, fun and learning funandlrnn...@gmail.comwrote: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a; ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On 4/15/2010 4:58 PM, fun and learning wrote: Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make the fileName get within quotes in javascript. I am getting everything right except in callURL, the fileName is sent as argument, but the real value is not enclosed within quotes. I tried different combinations but its not working. the actual callURL value when outputted should be a href='##' onClick='javascript:return parent.frames[1].XYZ(screen)'Link1/a but the value I am getting right now is a href='##' onClick='javascript:return parent.frames[1].XYZ(screen)'Link1/a Below is the code: function jscript1(){ var theString = 'screen1.cfm' var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a; } ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
I think this'll work: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\fileName\)'Link1/a; On Thu, Apr 15, 2010 at 3:58 PM, fun and learning funandlrnn...@gmail.comwrote: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a; Well, it does not display the value, it displays the variable name.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ(\ + fileName + \)'Link1/a; Does not work..Shows syntax error. On 4/15/2010 4:58 PM, fun and learning wrote: Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make the fileName get within quotes in javascript. I am getting everything right except in callURL, the fileName is sent as argument, but the real value is not enclosed within quotes. I tried different combinations but its not working. the actual callURL value when outputted should be a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a but the value I am getting right now is a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a Below is the code: function jscript1(){ var theString = 'screen1.cfm' var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ( + fileName + )'Link1/a; } ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
Oops, put the +'s back in: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at 4:07 PM, fun and learning funandlrnn...@gmail.comwrote: I think this'll work: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\fileName\)'Link1/a; On Thu, Apr 15, 2010 at 3:58 PM, fun and learning funandlrnn...@gmail.comwrote: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a; Well, it does not display the value, it displays the variable name.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
This works for me: function jscript1(){ var theString = screen1.cfm; var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href=\##\ onclick=\javascript:return parent.frames[1].XYZ(\' + fileName + \')\Link1/a; alert(callURL); } On 4/15/2010 5:14 PM, fun and learning wrote: callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ(\ + fileName + \)'Link1/a; Does not work..Shows syntax error. On 4/15/2010 4:58 PM, fun and learning wrote: Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make the fileName get within quotes in javascript. I am getting everything right except in callURL, the fileName is sent as argument, but the real value is not enclosed within quotes. I tried different combinations but its not working. the actual callURL value when outputted should be a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a but the value I am getting right now is a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a Below is the code: function jscript1(){ var theString = 'screen1.cfm' var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ( + fileName + )'Link1/a; } ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
Oops, put the +'s back in: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at 4:07 PM, fun and learning funandlrnn...@gmail.comwrote: Nope, it displays the following a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
Hey Jason, It works for me too...Thanks a lot... On Thu, Apr 15, 2010 at 5:29 PM, Jason Fisher ja...@wanax.com wrote: This works for me: function jscript1(){ var theString = screen1.cfm; var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href=\##\ onclick=\javascript:return parent.frames[1].XYZ(\' + fileName + \')\Link1/a; alert(callURL); } On 4/15/2010 5:14 PM, fun and learning wrote: callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ(\ + fileName + \)'Link1/a; Does not work..Shows syntax error. On 4/15/2010 4:58 PM, fun and learning wrote: Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make the fileName get within quotes in javascript. I am getting everything right except in callURL, the fileName is sent as argument, but the real value is not enclosed within quotes. I tried different combinations but its not working. the actual callURL value when outputted should be a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a but the value I am getting right now is a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a Below is the code: function jscript1(){ var theString = 'screen1.cfm' var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ( + fileName + )'Link1/a; } ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: what is wrong with this code
jsStringFormat() the callURL. It will take care of escaping everything correctly. -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Thursday, April 15, 2010 5:26 PM To: cf-talk Subject: Re: what is wrong with this code Oops, put the +'s back in: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at 4:07 PM, fun and learning funandlrnn...@gmail.comwrote: Nope, it displays the following a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
My brain is fried, it's late. I needed to escape the quotes, then terminate the string, then insert the variables, then restart the string, then escape the closing quotes: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at 4:26 PM, fun and learning funandlrnn...@gmail.comwrote: Oops, put the +'s back in: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at 4:07 PM, fun and learning funandlrnn...@gmail.comwrote: Nope, it displays the following a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfchart and bar colors
The cfChartSeries attribute colorlist will allow a series of colors, but in this case the X axis is ordered by department name rather than by response percentage. Just sifting through a ton of old mailing list items .. I am sure you figured this out already. But for the archives, you could calculate the colorlist dynamically. A simple approach is using a CASE statement in your db query to determine the colors for each value. SELECT Department, ResponseValue, CASE WHEN ResponseValue BETWEEN 0 AND 49 THEN 'Red' -- in hex ... WHEN ResponseValue BETWEEN 50 AND 74 THEN 'Orange' ... etc... END AS BarColor ... or store the color range information in a db table and use a JOIN. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm