FreeAgent Progress - cross-framework applications

2009-12-04 Thread s. isaac dealey
Hello everyone. A couple weeks ago we started work on a community project called FreeAgent, that allows MVC applications to be designed in such a way that they can be installed directly into any of the popular MVC frameworks for ColdFusion. We selected six frameworks to support initially and

Re: FreeAgent Progress - cross-framework applications

2009-12-04 Thread s. isaac dealey
Forgot to include the main site for the project. ;) http://freeagent.riaforge.org -- access to the SVN repository and the blog are both there. -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301

Compare a Record and insert null values

2009-12-04 Thread Jason Congerton
Hi I am storing measurement info for a product, each product has numerous parts, and each part has numerous measurements. Once the product has been created with all its part numbers and measurements i need to loop through the measurements and make sure each part has the exact same amount of

RE: FreeAgent Progress - cross-framework applications

2009-12-04 Thread Andy Matthews
That's 7 FWIW. -Original Message- From: s. isaac dealey [mailto:i...@turnkey.to] Sent: Friday, December 04, 2009 2:16 AM To: cf-talk Subject: FreeAgent Progress - cross-framework applications Hello everyone. A couple weeks ago we started work on a community project called FreeAgent,

UNICODE with cfqueryparam tag

2009-12-04 Thread Paul Alkema
Hi, I've been having an issue. I am currently using CF8 and would like to insert UNICODE into a table while using the cfqueryparam tag. Upon some research[1] I found many articles that said if you enable the setting High ASCII characters and Unicode for data sources configured for non-Latin

fusebox layout adding to csv?

2009-12-04 Thread Glyn Jackson
Hi I have an old fusebox app i am working on. it outputs a csv file with data however the html (layout) is also getting added to the csv? anyone know why. cfsetting enablecfoutputonly=yes cfscript function cleanField(sField){ sField = (replace(sField,,,;,All));

RE: fusebox layout adding to csv?

2009-12-04 Thread LRS Scout
What version of fusebox is it? You should be able to swap or suppress the layout around the csv content. -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Friday, December 04, 2009 9:12 AM To: cf-talk Subject: fusebox layout adding to csv? Hi I have an

Find city/state by IP Address?

2009-12-04 Thread Jason Durham
Anybody know of a web service that provides a city/state based upon an IP address? I found many sites that perform the service, but none of them will allow me to use their tools remotely. Jason Confidentiality Warning: This e-mail contains information

RE: Accordion - How do you?

2009-12-04 Thread Jason Durham
HAHA -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Thursday, December 03, 2009 6:09 PM To: cf-talk Subject: Re: Accordion - How do you? My bad in advance what is jquery? http://tinyurl.com/mbteqj G! On Thu, Dec 3, 2009 at 6:53 PM, Kim Hoopingarner

Re: Compare a Record and insert null values

2009-12-04 Thread Raj Vijay
So you want to have 'n/a' as default if there is no measurement?. T-SQL has a COALESCE function which can be used to check whether the column is NULL and have a default value. Example: COALESCE(table.columnName,n/a) as anyName. if table.columnName is NULL, then n/a will be substituted. Hope

Re: Compare a Record and insert null values

2009-12-04 Thread Raj Vijay
So you want to have 'n/a' as default if there is no measurement?. T-SQL has a COALESCE function which can be used to check whether the column is NULL and have a default value. Example: COALESCE(table.columnName,n/a) as anyName. if table.columnName is NULL, then n/a will be substituted. Hope

RE: Find city/state by IP Address?

2009-12-04 Thread Andy Matthews
Found this: http://askville.amazon.com/Free-IP-address-Location-API-country-state-provin ce/AnswerViewer.do?requestId=56161316 -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: Friday, December 04, 2009 10:05 AM To: cf-talk Subject: Find city/state by IP

RE: Find city/state by IP Address?

2009-12-04 Thread Jason Durham
Thanks for the link. I'm in the same boat as that person. This is a low traffic site, so I'm looking for something dirty cheap, or free. I should have specified that initially. :) -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Friday, December 04,

RE: Find city/state by IP Address?

2009-12-04 Thread Andy Matthews
That's fine, although that link seems to indicate that MaxMind is free at the city level (which it sounds like you want). -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: Friday, December 04, 2009 10:20 AM To: cf-talk Subject: RE: Find city/state by IP Address?

RE: Find city/state by IP Address?

2009-12-04 Thread Jason Durham
Thanks again for the reply. My eyes were moving faster than my brain when I read that site. The online demo seems to return my ISP's home office, rather than my location. I'll keep digging though. -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Friday,

Re: ColdFusion and Linux

2009-12-04 Thread Kris Sisk
Does anyone know the solution of this? Also, what would be the recommended chmod to use? seems like 777 is the only one that will allow me to write to the folder I'm not sure about your accents and whatnot. Being embarrassingly unilingual I don't use them very much. But your chmod should

Setting Static Image Expire

2009-12-04 Thread Jessica Kennedy
I'm having some issues with the classic flickering images on rollover in IE for one of my sites. here is a link to one of the pages: directfighter.com/http://www.directfighter.com/calendar.cfm?tmonth=10tyear=2009pmtr=srchst= I have tried caching the css page. this helped some on the gigantic

Re: Find city/state by IP Address?

2009-12-04 Thread Jason Todd
We have regularly refreshed data in SQL and have considered opening up a web server to it as our internal systems will be moving to accessing via web services instead of ODBC. Are you looking to pay by transaction or flat fee? Also, what volume of requests are you looking at? If you're just

Re: Find city/state by IP Address?

2009-12-04 Thread Jason Todd
Maxmind stands out in my memory as one with very poor / lots of missing data, in my experience. Thanks again for the reply. My eyes were moving faster than my brain when I read that site. The online demo seems to return my ISP's home office, rather than my location. I'll keep digging

RE: Find city/state by IP Address?

2009-12-04 Thread Jason Durham
The client requesting this would probably not pay enough to make it worth your effort. Maybe $100-150 _a year_. Of course, that's just my instinct. I'd have to clear it with them. -Original Message- From: Jason Todd [mailto:ja...@alpinehomeair.com] Sent: Friday, December 04, 2009

Re: Find city/state by IP Address?

2009-12-04 Thread Jason Todd
Found our db provider who we've had good success with. Accuracy/inclusion is significantly higher than maxmind. http://www.ip2location.com Only option is to download the data to db, though. Anybody know of a web service that provides a city/state based upon an IP address? I found many

RE: Find city/state by IP Address?

2009-12-04 Thread Jason Durham
Thanks for the link. I ran across them via Google. Their pages are s busy but I found what I needed there. http://www.ip2location.com/XXX.XXX.XXX.XXX is enough for this client. They'll just have to click a link. -Original Message- From: Jason Todd

Re: UNICODE with cfqueryparam tag

2009-12-04 Thread Paul Hastings
On 12/4/2009 9:17 PM, Paul Alkema wrote: administrator that it will allow this. However, upon doing so my MSSQL server crashed every time. I have researched this over and over and havn't seen any other people having this issue. never heard of this happening. what do you mean by crash? if you

Re: FreeAgent Progress - cross-framework applications

2009-12-04 Thread s. isaac dealey
That's 7 FWIW. Thanks Andy. Yeah, I copy-pasted part of the announcement and had originally forgotten to include FW/1 in the list and then when I added it back int I neglected to edit the paragraph. ;) -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism

Re: ColdFusion and Linux

2009-12-04 Thread Ravi Gehlot
Hello Raul, I run Linux on my box. I am not sure what your problem is. My cffile writes without a problem with or without accents. Can you send your code through or paste it on pastebin.com? Regards, Ravi. On Fri, 2009-12-04 at 00:34 -0500, Raul Riera wrote: rierar...@gmail.com

Re: Find city/state by IP Address?

2009-12-04 Thread Nathan Strutz
The classic http://javainetlocator.sourceforge.net/ works. It's a Jar you add to your java classpath, but I think they ship with a CFC... It's been a few years so I don't remember precisely. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/]

How to vary the size of the JVMs in CF8 multiserver?

2009-12-04 Thread Jim Martin
I'm running ColdFusion 8 multiserver on several servers where I work. Any time I vary a JVM size in the JRun management console I get the warning that This change will affect all JVMs on the server. I need to be able to change the size of a single JVM without affecting the others. Is there

Re: How to vary the size of the JVMs in CF8 multiserver?

2009-12-04 Thread Dave Watts
I'm running ColdFusion 8 multiserver on several servers where I work.  Any time I vary a JVM size in the JRun management console I get the warning that This change will affect all JVMs on the server.  I need to be able to change the size of a single JVM without affecting the others.  Is

Re: How to vary the size of the JVMs in CF8 multiserver?

2009-12-04 Thread Maureen Barger
Each instance has to use its own jvm.config. You should uniquely name them, and inside can point to different jvms, classpaths, parameters etc. You will have to use a wrapper script and can no longer restart them from the web admin pages. On Fri, Dec 4, 2009 at 12:05, Jim Martin

Re: Find city/state by IP Address?

2009-12-04 Thread Tony Bentley
http://ipinfodb.com/ip_query.php?ip= cfhttp method=get URL=http://ipinfodb.com/ip_query.php?ip=#cgi.REMOTE_ADDR#; result=test / cfset xmmm = xmlparse(test.filecontent) cfset countrycode = xmmm.response.countrycode.xmltext

Re: Find city/state by IP Address?

2009-12-04 Thread Cameron Childress
I see several people have replied to this already. I wanted to add that any company maintaining a list of IPs and locations has to do quite a bit of maintenance to keep them up to date and accurate. Because of the effort required, generally speaking the more you are willing to pay, the more

ColdFusion 8.0.1 cumulative hot fix 4

2009-12-04 Thread John M Bliss
Warning: Before installing ColdFusion 8.0.1 cumulative hot fix 4, my FuseBox 5.5 site was working fine. After installing ColdFusion 8.0.1 cumulative hot fix 4, it was broken with this error: Could not find the ColdFusion Component or Interface website.controller.MyFuse. Ensure that the name is

Re: UNICODE with cfqueryparam tag

2009-12-04 Thread Jason Fisher
First check that the necessary columns are set to ntext or nvarchar, not text or varchar. If that's not the issue then put the N in front of each, as Paul mentioned. If that doesn't work, then what version of SQL Server are you on ... older versions may not support 8-bit entries ... never

Re: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-04 Thread John M Bliss
P.S. C:\inetpub\wwwroot\mysite_com\website is the webroot (aka C:\inetpub\wwwroot\mysite_com\website is equivalent to http://www.mysite.com/ ) On Fri, Dec 4, 2009 at 12:11 PM, John M Bliss bliss.j...@gmail.com wrote: Warning: Before installing ColdFusion 8.0.1 cumulative hot fix 4, my

Re: ColdFusion and Linux

2009-12-04 Thread Raul Riera
Hello Raul, I run Linux on my box. I am not sure what your problem is. My cffile writes without a problem with or without accents. Can you send your code through or paste it on pastebin.com? Hi, sure here it is http://pastebin.com/m4ed72d7f the file gets written alright, it just the

RPC server is unavailable

2009-12-04 Thread Andrew Peterson
Hi, We're getting an RPC server is unavailable error when I try to authenticate a user using NT Authentication. Always worked - now it does not. The issue affects multiple servers on our network - and both CF9 and CF8. While I'm certain it is not a CF issue, I want our network dept to be

RE: Find city/state by IP Address?

2009-12-04 Thread Jason Durham
Thanks Tony! That works like a champ. -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Friday, December 04, 2009 11:47 AM To: cf-talk Subject: Re: Find city/state by IP Address? http://ipinfodb.com/ip_query.php?ip= cfhttp method=get

RE: RPC server is unavailable

2009-12-04 Thread Jason Durham
Assuming the DCs are online, it's almost always (in my experience) related to DNS. -Original Message- From: Andrew Peterson [mailto:webmas...@mail.ioc.state.il.us] Sent: Friday, December 04, 2009 12:40 PM To: cf-talk Subject: RPC server is unavailable Hi, We're getting an RPC server

Re: RPC server is unavailable

2009-12-04 Thread Dave Watts
Assuming the DCs are online, it's almost always (in my experience) related to DNS. My own experience has been a little different. You can test this by immediately rebooting the Windows machine running CF, and see if that solves the problem, if that's possible in your environment. Dave Watts,

OT - Problems with CF code in Adminprotools

2009-12-04 Thread cfcom
Sorry for the off topic - but am having some trouble with cfml code from Adminprotools. If anyone knows how to contact Jared or Isaac from Adminprotools please contact me off-list. Thank you in advance. ~| Want to reach the

Re: Find city/state by IP Address?

2009-12-04 Thread Eric Roberts
Here's an article on tech republic they put out today on the very subject ;-) http://blogs.techrepublic.com.com/networking/?p=2279tag=nl.e132 Eric -- From: Jason Durham jdur...@cti-stl.com Sent: Friday, December 04, 2009 10:05 AM To: cf-talk

RE: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-04 Thread brad
Hmm, I see that CHF 4 includes Bug 77508 which has to do with mappings (for web services). I wonder if that is related. If I'm following correctly, the component path website.controller.MyFuse shouldn't have ever worked, right? If website is your web root (one of the places CF checks) I would

Re: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-04 Thread John M Bliss
If I'm following correctly, the component path website.controller.MyFuse shouldn't have ever worked, right? Not sure. But it **did** work. On Fri, Dec 4, 2009 at 1:15 PM, b...@bradwood.com wrote: Hmm, I see that CHF 4 includes Bug 77508 which has to do with mappings (for web

Re: Compare a Record and insert null values

2009-12-04 Thread Jason Congerton
Thanks for you response raj, however the column would not have been created at that point. If a user enters the first part no. with say three measurements a=1,b=2,c=4 that accounts for three rows against the specific part no., when he enters a second part no. with four measurements i.e.

cflocation tag

2009-12-04 Thread Mike Stromme
Anyone ever have cflocation stop working. It is happening on our MX7 test server but works fine on our production MX7 server. I created a test page with just the cflocation tag with and without the addToken attribute and it just stays on the test page. Thanks, Mike

Re: cflocation tag

2009-12-04 Thread Barney Boisvert
Do you have CFFLUSH above the CFLOCATION tag anywhere (like another template or Application.cfm)? Once you flush the page, you can no longer do a CFLOCATION (or CFHEADER, CFCONTENT, etc.). cheers, barneyb On Fri, Dec 4, 2009 at 11:27 AM, Mike Stromme gtrplayer5...@gmail.com wrote: Anyone

Re: cflocation tag

2009-12-04 Thread Mike Stromme
Barney, Thank you, thank you, thank you I had a cfflush in the application.cfm file. thanks, Mike Do you have CFFLUSH above the CFLOCATION tag anywhere (like another template or Application.cfm)? Once you flush the page, you can no longer do a CFLOCATION (or CFHEADER,

Re: RPC server is unavailable

2009-12-04 Thread Andrew Peterson
Assuming the DCs are online, it's almost always (in my experience) related to DNS. My own experience has been a little different. You can test this by immediately rebooting the Windows machine running CF, and see if that solves the problem, if that's possible in your environment. Hmm. I may

Re: Accordion - How do you?

2009-12-04 Thread Tony Bentley
Okay, you need to explain what you want it to do a little more. The code I gave you starts with one div open and the other closed. I am not sure if spry is going to be necessary with this. Start with just the divs and no spry. Use the same CSS if you want the style to be the same. If you want

Re: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-04 Thread John M Bliss
Another one broke: before the CFH, I had this mapping: Logical Path: /mysite_com_model Directory Path: C:\inetpub\wwwroot\mysite_com\website\model ...so that http://www.mysite.com/mysite_com_model/.../MyCFC.cfc would work. (Don't ask...was a semi-kludge having to do with binding CFC's to

Re: ColdFusion and Linux

2009-12-04 Thread Jordan Michaels
Actually 666 would give read-write permissions to everyone as well. Here's the break down: First number = owner rights Second number = group rights Third number = world rights From there, each number is determined from the following values: Read = 4 Write = 2 Execute = 1 If I want to give

Consuming Webservice

2009-12-04 Thread Agha Mehdi
Hi Guys, 1. I am trying to consume this webservice http://testservices.hubcast.com/CypressCustomer/OrderAC.svc?wsdl 2. Here is my code: cfset dcc = OCA / cfset hm = 279.4 / cfset hc = 1SS4RQ- / cfset q = ArrayNew(1) / cfset ArrayAppend(q, 100) / cfset ArrayAppend(q, 200) / cfset

Re: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-04 Thread Dave Watts
Another one broke: before the CFH, I had this mapping: Logical Path: /mysite_com_model Directory Path: C:\inetpub\wwwroot\mysite_com\website\model ...so that http://www.mysite.com/mysite_com_model/.../MyCFC.cfc would work. (Don't ask...was a semi-kludge having to do with binding CFC's to

Re: Consuming Webservice

2009-12-04 Thread deepa makkar
The format in which you are sending the parameters may not be right. Also check the required datatypes for the parameters and compare them to what you are sending. On Fri, Dec 4, 2009 at 4:42 PM, Agha Mehdi aghaime...@gmail.com wrote: Hi Guys, 1. I am trying to consume this webservice

Re: Consuming Webservice

2009-12-04 Thread Tony Bentley
You can also just send it via cfhttp: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/remotes6.htm ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists

Re: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-04 Thread John M Bliss
Not disagreeing with you...but I still think it's notable (strange?) that CHF 4 changed this behavior. Hopefully, this thread will make people aware of this phenomenon just in case they have stuff set up like I did... On Fri, Dec 4, 2009 at 5:15 PM, Dave Watts dwa...@figleaf.com wrote:

Re: Consuming Webservice

2009-12-04 Thread Leigh
What am I doing wrong? That web service uses arrays (sort of). See these two entries for a good explanation of the issues and how to work around them. http://www.coldfusionmuse.com/index.cfm/2009/4/27/array.CF.to.NET

RE: Error consuming Fedex webservices

2009-12-04 Thread Leigh
Have you tried Float instead of string with javaCast() on those dates? I know the OP switched to SOAP/CFHTTP. But the Invalid positiveInteger error seems related to the ServiceType (perhaps indirectly). Because it works if you use a different type like cfset

Re: Compare a Record and insert null values

2009-12-04 Thread Jason Congerton
Hi I managed to acheive what i'm after, however its a seems bit intensive due to the loop factor, if there are any better ways i would love to hear them. !//Step 1: Get the product in question--- cfquery name=get_products datasource=#application.dsn# SELECT products.productID,