Re: SOT: Problems with CF9 Mac Install W/Mamp

2010-12-17 Thread Stefan Richter
FWIW I am running CF9 on OSX with MAMP so maybe my post will help: http://www.flashcomguru.com/index.cfm/2009/11/2/cf9-mamp-snowleopard Cheers Stefan On Dec 16, 2010, at 9:15 PM, Gerald Guido gerald.gu...@gmail.com wrote: I have a nice shiny Mac Pro and CF9 and/or Apache is being

SOT: FireFTP - Upload appends files instead of overwrites?

2010-12-17 Thread Will Tomlinson
I ran into a bizarre issue last night where FireFTP wouldn't overwrite my Application.cfc. The site started erroring with invalid tokens. When I viewed the code on the live server, I noticed the Application.cfc had been appended to with as many cfcomponent tags as I had uploaded the files. I

Database query - match 1 or more zeros

2010-12-17 Thread Ian Skinner
I have a varchar field that can (shouldn't, but can) contain a variable number of zero[0] characters. I want to return all rows where this field only contains zeros, no matter how many zeros it may contain. Due to too much holiday potluck, my lethargic brain can not produce even a glimmer

Re: CF to Salesforce.com API?

2010-12-17 Thread greg h
Hi Dave, I am following up on your post from May 2009http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:59366where you wrote: Code samples will follow soon Is there a link where code samples can be downloaded? Thank you for the

Installing CF9

2010-12-17 Thread Chad Baloga
We are upgrading our web servers with new 64bit Win2k8 Machines. We only run 1 instance of Coldfusion. Is it best to stay with the standard install or install CF with the multi instance install. We have no plans to have multiple instances but was wondering if there were any advantages.

Re: Database query - match 1 or more zeros

2010-12-17 Thread David McGraw
Can you cast is as a numeric value, all entries with '' should turn into 0, while anything with number becomes Null? then you simply check WHERE CAST() = 0 Regards, David McGraw Oyova Software, LLC - http://www.oyova.com On Fri, Dec 17, 2010 at 2:18 PM, Ian Skinner h...@ilsweb.com wrote:

Re: The INSERT statement conflicted with the FOREIGN KEY constraint

2010-12-17 Thread Pete Freitag
This error probably means that the value you are trying to insert into a foreign key column does not correspond to an actual row, I am guessing that it is this line: cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=intMemberIDUpdate value=0

Re: Database query - match 1 or more zeros

2010-12-17 Thread Michael Grant
I think regex is the way to go for you. WHERE field = [0]* I think would work. On Fri, Dec 17, 2010 at 2:18 PM, Ian Skinner h...@ilsweb.com wrote: I have a varchar field that can (shouldn't, but can) contain a variable number of zero[0] characters. I want to return all rows where this

Re: Database query - match 1 or more zeros

2010-12-17 Thread Ian Skinner
On 12/17/2010 11:41 AM, Michael Grant wrote: I think regex is the way to go for you. WHERE field = [0]* I think would work. Thanks, that was the seed of the idea I needed. WHERE REGEXP_LIKE(grower_id, '0+') I just changed it to 0+ because I wanted to match one or more zeros NOT zero or more

Re: Database query - match 1 or more zeros

2010-12-17 Thread Michael Grant
Perfect! Yeah I suck at regex. On Fri, Dec 17, 2010 at 2:55 PM, Ian Skinner h...@ilsweb.com wrote: On 12/17/2010 11:41 AM, Michael Grant wrote: I think regex is the way to go for you. WHERE field = [0]* I think would work. Thanks, that was the seed of the idea I needed. WHERE

question for jquery experts here

2010-12-17 Thread fun and learning
hi All - I am using the following jquery script to hover and click on table rows: $(.simplehighlight).click(function() { $(this).children().addClass('clicked'); $(this).siblings().children().removeClass('clicked'); }); $(.simplehighlight).hover(function() {

Re: mySQL administration

2010-12-17 Thread Russ Michaels
Well you can of course us the free mysql admin tools provided by mysql, or there arenumerous alternatives. Navicat is very good Sqlyog is very popular but quite basic Numerous others if you google the subject Russ On 10 Dec 2010 03:53, Rob Voyle robvo...@voyle.com wrote: Hi Folks I have

Re: CFDOCUMENT and Images

2010-12-17 Thread Russ Michaels
The problem often is so many other people using cfdocument or cfimage on a shared host and it causes problems. Too much memory gets used and cf never seems to recover, maybe a gc problem, who knows, but it is a common problem and the host cannot tune cf or java to any specific app as there are

Re: Files Management Question

2010-12-17 Thread Russ Michaels
That looks very nice, good find On 9 Dec 2010 19:14, Rick Root rick.r...@gmail.com wrote: What about this? http://coldfusionfilemanager.riaforge.org/ http://coldfusionfilemanager.riaforge.org/Again, you'd probably have to make some mods, I'm not familiar with this project. Rick On Thu,

Re: CF8 / Windows 7 - ODBC services not starting

2010-12-17 Thread David Moore
Mathew, Did uninstalling and reinstalling the ODBC Drivers fix the issue? I am having the same problem. ~| Order the Adobe Coldfusion Anthology now!

Re: ColdFusion 8 ODBC Server Errors

2010-12-17 Thread David Moore
Meghna, I am getting the same error message and CF is locking up so badly all I can do is reboot my server. What did you find, if any, is the solution? ~| Order the Adobe Coldfusion Anthology now!

Re: ColdFusion 8 ODBC Server Errors

2010-12-17 Thread David Moore
Meghna, I am getting the same error message and CF is locking up so badly all I can do is reboot my server. What did you find, if any, is the solution? ~| Order the Adobe Coldfusion Anthology now!

Re: Installing CF9

2010-12-17 Thread Wil Genovese
As long as you have the Enterprise version you are best off installing in multi-instance mode. This leaves you the most flexible for future needs. Wil Genovese Sr. Web Application Developer/ Systems Administrator 651-894-4238 wilg...@trunkful.com www.trunkful.com On Dec 17, 2010, at 9:57 AM,

Re: Tutorial on creating this pagination?

2010-12-17 Thread Adam Parker
Please excuse my ignorance as I've never used a CFC either. My cfm page is: !---Get poems--- cfquery name=qGetPoems datasource=myDSN SELECT id, poemTitle, average FROM PoetryContest2010 order by id asc /cfquery cfset pagination = createObject(component, Pagination).init() / cfset

Re: Tutorial on creating this pagination?

2010-12-17 Thread Michael Grant
You need to wrap this #pagination.getRenderedHTML()# in this cfoutput/cfoutput On Fri, Dec 17, 2010 at 3:54 PM, Adam Parker adgpa...@iupui.edu wrote: Please excuse my ignorance as I've never used a CFC either. My cfm page is: !---Get poems--- cfquery name=qGetPoems datasource=myDSN

Re: Tutorial on creating this pagination?

2010-12-17 Thread Ian Skinner
On 12/17/2010 12:54 PM, Adam Parker wrote: What am I doing wrong? You need to put them inside of foutput blocks. cfoutput#pagination.getRenderedHTML()#/cfoutput ... cfoutput#pagination.getRenderedHTML()#/cfoutput ~|

RE: question for jquery experts here

2010-12-17 Thread Rick Faircloth
Send some of your table over, so I can set up a test... Rick -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Friday, December 17, 2010 3:00 PM To: cf-talk Subject: question for jquery experts here hi All - I am using the following jquery script to

Re: ColdFusion 8 ODBC Server Errors

2010-12-17 Thread Dave Watts
I am getting the same error message and CF is locking up so badly all I can do is reboot my server. What did you find, if any, is the solution? It's quite possible that these things are completely unrelated. Did you check your older logs to see if you have the same error? Are you actually

Re: question for jquery experts here

2010-12-17 Thread Lists
Without seeing your code I'd wager that the problem is you're assigning too many event handlers with your selector. Rather than putting a class on every row of a table, put an I'd on the table and use this instead. $('#myTable tr') I'll bet that you'll get better performance. On Dec 17,

Re: Database query - match 1 or more zeros

2010-12-17 Thread Lists
Consider adding a caret to the start of the regex or you'll match multiple zeros anywhere in the cell. Would match 00 000 123000 12345670 On Dec 17, 2010, at 1:55 PM, Ian Skinner h...@ilsweb.com wrote: On 12/17/2010 11:41 AM, Michael Grant wrote: I think regex is the way to go for

Re: Database query - match 1 or more zeros

2010-12-17 Thread Michael Grant
you'll match multiple zeros anywhere in the cell. I don't think that's what Ian's looking for though. ~| Order the Adobe Coldfusion Anthology now!