Re: Dynamic SQL Column Names

2010-04-15 Thread Brian Thornton
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

RE: Dynamic SQL Column Names

2010-04-15 Thread Paul Alkema
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

RE: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread Jason Durham
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

CF9 64-bit fails requiring reinstall

2010-04-15 Thread Kris Jones
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

Re: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread Brandon
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:

Re: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread morgan l
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

RE: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread Will Swain
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

RE: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread Roger Austin
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

Re: CF9 64-bit fails requiring reinstall

2010-04-15 Thread Dave Watts
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

Re: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread Wil Genovese
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

Re: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread Wil Genovese
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

Re: Dynamic SQL Column Names

2010-04-15 Thread Doug Ford
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

Re: Dynamic SQL Column Names

2010-04-15 Thread Doug Ford
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

Re: cffunction and webservice call question

2010-04-15 Thread Ken Willis
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

Re: Dynamic SQL Column Names

2010-04-15 Thread denstar
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

Re: Dynamic SQL Column Names

2010-04-15 Thread Brian Thornton
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

Re: cffunction and webservice call question

2010-04-15 Thread Dave Watts
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

(ot) Just FYI - Assembla Repository Offerings

2010-04-15 Thread Rick Faircloth
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 -

Re: (ot) Just FYI - Assembla Repository Offerings

2010-04-15 Thread Gerald Guido
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

Re: Dynamic SQL Column Names

2010-04-15 Thread Jason Fisher
@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

Re: cffunction and webservice call question

2010-04-15 Thread Matt Williams
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

Re: Dynamic SQL Column Names

2010-04-15 Thread Dave Watts
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))

Re: Dynamic SQL Column Names

2010-04-15 Thread Jason Fisher
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.

what is wrong with this code

2010-04-15 Thread fun and learning
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

Re: what is wrong with this code

2010-04-15 Thread morgan l
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;

Re: what is wrong with this code

2010-04-15 Thread Jason Fisher
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

Re: what is wrong with this code

2010-04-15 Thread fun and learning
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;

Re: what is wrong with this code

2010-04-15 Thread fun and learning
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

Re: what is wrong with this code

2010-04-15 Thread morgan l
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

Re: what is wrong with this code

2010-04-15 Thread Jason Fisher
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);

Re: what is wrong with this code

2010-04-15 Thread fun and learning
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

Re: what is wrong with this code

2010-04-15 Thread funand learning
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(.));

RE: what is wrong with this code

2010-04-15 Thread Bobby Hartsfield
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

Re: what is wrong with this code

2010-04-15 Thread morgan l
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

Re: cfchart and bar colors

2010-04-15 Thread Leigh
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