CFGRID Select Row

Anyone know how to programmatically select a row in a grid. Sometimes you want to refresh the grid and then upon refresh select a specific row. Regards Dale Fraser http://learncf.com ~| Get involved in the

Re: Set Coldfusion Variable using AJAX

Whats the code look like Aaron? You should be able to make a Ajax call and pass a param as part of the query string to your CF page. Rey Aaron Bodell wrote: I have a javascript variable set to the current selected row of a table (can't use cfgrid for this one). I need to pass that

Re: Set Coldfusion Variable using AJAX

Whats the code look like Aaron? You should be able to make a Ajax call and pass a param as part of the query string to your CF page. Thanks for your suggestion, Rey. I finally restarted the page using the example from the cfajaxproxy page in the CF8 documentation. I discovered that I had

Re: How to create a SQL query above 2 tablespaces?

Stivn .. wrote: i want to create a SQL query above 2 tablespaces. A tablespace is an implementation detail of your SQL server that does not influence the logical database stucture so you would query it the same way as you would a single tablespace. Jochem

Re: Can cfqueryparam cfprocparam dodge all known SQL Injection attack?

henry ho wrote: After reading the following pages... The Unexpected SQL Injection - When Escaping Is Not Enough http://webappsec.org/projects/articles/091007.shtml SQL Injection Cheat Sheet http://ferruh.mavituna.com/makale/sql-injection-cheatsheet/ I wonder if our beloved

Re: CF Coding Standards

Gaulin, Mark wrote: What I would find more interesting is something approaching a coding style validator for important things, like varing local variables in functions and always scoping variables properly (to the degree that I would want), checking for cfparam tags for url, form, and

RE: Invoking component

Jeez, Sorry chaps, It would appear that my British Telecom SMTP server was playing up yesterday and duplicating the damn things, it 'appears' to be much better this morning. Sorry for all the trouble. Rob -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 10

Re: CF Coding Standards / validation

On Wednesday 10 Oct 2007, [EMAIL PROTECTED] wrote: It's always on topic to show how much better ColdFusion is :-) Not better. Just different. It is never better to have humans do garbage collection and memory allocation. Studies have been done, and compilers are much, much quicker at it and

Re: Coldfusion Security / Vulnerabilities

On Thursday 11 Oct 2007, [EMAIL PROTECTED] wrote: Looking through my logs I came across these strange things. Some of which I know a are vulnerabilities some I had to google to figure out, but some just leave me baffled like FN1rFWvfUWgo.cfm and wzryve7i.cfm. Anyone shed any light on these?

Re: CFGRID Select Row

i am working on the same issue... will post my findings [if any...] later... Azadi Dale Fraser wrote: Anyone know how to programmatically select a row in a grid. Sometimes you want to refresh the grid and then upon refresh select a specific row. Regards Dale Fraser

OOP Coldfusion

Hi All, I'm working on an OOP project and am having a bit of a problem with objects referencing each other. My folder structure is /siteRoot/ /siteRoot/core (Where all my classes are) /siteRoot/core/valueObjects I'm quite early on in the build so I'm just setting up my value classes.

Re: CFGRID Select Row

Dale, Should read my blog more then:-) If you followon from my Grid example, and use the extJS docs you would get the following. var grid = ColdFusion.Grid.getGridObject('NameOfGrid'); grid.getSelectionModel().getSelected() Will return the record store of the selected row. btw if you use

Re: CFGRID Select Row

well, that's all good and all, but how about pre-selecting a specific row??? your code will return record store of the selected row... how about when no row is yet selected??? Azadi Andrew Scott wrote: Dale, Should read my blog more then:-) If you followon from my Grid example, and use

RE: Why does this code disable styling? / Regex needed...

Any Regex gurus care to lend a hand with this one? Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 9:53 PM To: CF-Talk Subject: Re: Why does this code disable styling? use REReplace() with a regex to replace spaces only

Re: CFGRID Select Row

simple as everything ajax seems to be: refreshgrid = function(){ ColdFusion.Grid.getGridObject('yourgridname').getSelectionModel().selectRow(rownumber); } NOTE: rownumbers seem to be 0-based you can also use: selectRows() selectRange() clearSelections() and a lot more... more info @

RE: CF Coding Standards / validation / CFML pasring

I've been thinking about what a CFML parser has to do and man, it isn't all that easy... I'm not sure any .cfm file could be parsed properly without knowing the state of cfoutput before the file is (potentially) cfincluded. In other words, if you see some text like this is text#hi# and some more,

Re: OOP Coldfusion

The quick way to fix this issue is to just set the argument type to any. Coldfusion is dynamic and can handle that just fine. However, this can make debugging the app more difficult because instead of getting a helpful type-casting error, you may get something like tthe method cannot be found,

Re: CFGRID Select Row

Well I thought the hint was in the using of firefox and its plugin fireDebug, use the console to type the var name of the grid and you get to see all methods and properties. How much more does one need to spell it out, when all the docs are also on extJS:-) And the reverse of get is set is it

Re: Memory Issue

Anyone got any ideas here? On 10/10/07, Rick Root [EMAIL PROTECTED] wrote: I'm trying to discover why a piece of code that I run causes my JVM memory usage to go up about 400MB. I'm using CF8... I'm not sure how to debug this. Basically I've got an event gateway request that generates an

RE: Memory Issue

Just a stab here, but maybe instead of using cfset's you can re-write into a cfscript block? Also, if this is in a cfc, be sure you have var-scoped every variable (even temp ones) Just some idea's off the cuff =) You could always post the entire pertinent code to some place like cfm.pastebin.com

Re: Request timeout

In the coldfusion administrator all the event gateways are defaulted to timeout after 30 seconds additionally in CF8 if you use the flex messaging gateway the default is NOT to kill the thread on a timeout... I believe that cfsetting only works within .cfm pages. You could bump up the timeout on

RE: CF8 Dev running very slow

Hi Bill, We need more info on this to debug the problem: What is the JDK you are using? What is the max JVM memory(Xmx)? When you run the CF file (which runs as slow as 20s), can you collect multiple thread dumps when the request is getting processed and send the thread dumps to me?

Re: flash form and spry tabs

Will, Did you set the timeout value on the cfform tag? It defaults to 0 which would probably result in you receiving that error. cfform name=myform format=flash timeout=300 Regards, -- Gary Gilbert http://www.garyrgilbert.com/blog

Re: OOP Coldfusion

Tim, I am not 100% sure, but I have come across this before and I think it has to do with loading the cfc from the current directory. Others like Sean might give a better explanation, but my fix has been to create a mapping for core or to use /core.package.component. On 10/11/07, Tim

ANN: Introducing Validat - A Data Validation Engine for ColdFusion

I would like to introduce Validat, an open source data validation engine for ColdFusion being developed by Alagad http://www.alagad.com/ . The code is currently available and marked as Alpha until I can get some more documentation written (the bane of every open source project!). Once the

Can a ColdFusion application see what processes are scheduled?

I can see the current scheduled processes through the administrator, but is there a way for my application to see what scheduled processes are active, and when they will next run? Thanks, Bob Mack ~| Get the answers you are

RE: OOP Coldfusion

Thanks for the reply Matt, I have to confess I'm not particularly looking forward to learning a framework. I was sort of hoping that defining class paths to cfcs would be a setting somewhere.. I ColdSpring sounds cool tho, I'll check it out. Thanks again Tim -Original Message-

Re: OOP Coldfusion

Also, as Matt said, this sort of thing screams ColdSpring: cfset page = CreateObject(component,core.valueObjects.Page).init() cfset head = CreateObject(component,core.valueObjects.Head).init(title:This is a new title) cfset page.setHead(head) Trust me, if you're serious about building OO

Re: OOP Coldfusion

You can try clearing the template cache in the CF administrator. Sometimes the way CF stores CFCs in its cache can screw things up when it comes to typing if you have moved things around, changed names, or instantiated the same component from multiple folders. It thinks the type is pointing

Re: OOP Coldfusion

Tim Did you try and set up a mapping to the top level of your components directory? Frame works are a good thing, they take a lot of these types of questions away from you so you can concentrate on what it is you need to concentrate on, that being the solution to the problem. Whether its

Re: OOP Coldfusion

Just to be clear though, ColdSpring is a dependency injection framework for your model and has nothing to do with the front controller frameworks like Mach-II or Fusebox. They do totally different things (ColdSpring works with any of the front-controller frameworks, or with no framework at all).

Re: Why does this code disable styling?

#replace(replace(get_events.event_description, #chr(13)#, br, All), #chr(32)#, nbsp;, All)# You are using unnecessary # in this expression, use instead: #replace(replace(get_events.event_description, chr(13), br, All), chr(32), nbsp;, All)# But it is not the source of your problem Anyway, the

RE: OOP Coldfusion

Hi Gary et al, Thanks for everyone's help. I managed to solve the problem, I assumed my mapping was working when it wasn't :( After changing the mapping all sorted. I'm going to look into Coldspring and the other frameworks in more detail, but as I'm still nowhere near being a CF nerd yet, and

RE: flash form and spry tabs

Ah. There we go. Thanks Gary, worked a treat. will -Original Message- From: gary gilbert [mailto:[EMAIL PROTECTED] Sent: 11 October 2007 15:32 To: CF-Talk Subject: Re: flash form and spry tabs Will, Did you set the timeout value on the cfform tag? It defaults to 0 which would

RE: CF8 Dev running very slow

Hi Bill, You could also consider using Server Monitoring feature to track down your requests, especially sort of things like, which part of your code taking what amount of time. Is it the case that your requests are slow only for the first request to the template and then it runs smoother? If

Re: Splitting UI and Data

Yes, I'm glad that all of you convinced me to carry on with Fusebox. I have just seen the light. it was a hard start. Maybe because I had install Fusebox 5.1 and the tutorial was written for Fusebox4. But when I got it to work it was very nice. I very much like the way that the fuse action is

RE: Why does this code disable styling?

Of course, you are also replacing the space in b style=color:red; by bnbsp;style=color:red; which is an illegal tag. Yeah, I figured that out after reviewing source. Azadi suggested I need an regex to change all the spaces to nbsp; except those within the and so the code is untouched. Know

Dates with Query of Query

I am trying to do a query of a SQL Server query with ColdFusion 8 but I am having trouble getting it to filter on dates. I have tried a few different things, but nothing seems to work. It doesn't throw an error, it just doesn't select records that I think it should find. I want it to get

Re: OOP Coldfusion

On 10/11/07, Matt Williams [EMAIL PROTECTED] wrote: On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Having said that tho - which is the best framework? ColdMachTransfer-ReactorFuseGlue But be sure to get the BER from SVN or CVS or Walgreens, or something. :P -- Matt Williams It's the

Re: OOP Coldfusion

On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Having said that tho - which is the best framework? ColdMachTransfer-ReactorFuseGlue -- Matt Williams It's the question that drives us. ~| ColdFusion 8 - Build next

Returns the value, 16,16?? Please help!

cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex# cfelseif parameterexists(URL.startindex) cfset startnum = #URL.startindex# cfelse cfset startnum=1 /cfif cfset count = 0 cfoutput query=getdocs cfset count=#count#+1 /cfoutput cfoutput cfset endnum = #startnum# +14 cfif

Re: Returns the value, 16,16?? Please help!

honestly, I haven't read the code posted, but I can say with certainty that you get a comma-delimited list in a single form field if you are submitting it twice. You'll get smarter answers if you say some words in your post. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com

Value concatenation

I'm unable to locate where the values concatenate. When I click on the button twice, I get the following error msg, Returns the value, 16,16. I'm not sure what I'm doing wrong?? Can someone please help? Thanks! cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex#

Question about getHttpRequestData() function

Does anyone know the underlying Java functions used for this? I've got someone asking me how they can get Java to do the same thing CF does when it receives a 'form' submission. How could I execute this same functionality for example if I created a java object? Thanks, Dave

Re: Why does this code disable styling?

Know how to regex that, Claude? Must not be simple. I'm too lazy, this is why I made CF_REextract. If I had to do it, I would use CF_REextract for sure. 1º get all strings outside tags and their location, 2 loop on the query backward and replace spaces in these strings See CF_REextract:

Query Question

I have a simple select query: Select parentID, title, body, status, hierarchy From pages Where status='A' Order by hierarchy The hierarchy field looks like this: 1 1~7 1~8 1~9 1~10 1~12 1~12~13 1~12~14 and so on. The problem is that when I run this query, it orders them like this: 1 1~10

Re: Memory Issue

Maybe replace the cfset fileOutput.delete(0,fileOutput.length()) With: cfset fileOutput.setLength(0) It would probably take less processing. Mark On 10/11/07, Rick Root [EMAIL PROTECTED] wrote: I'm trying to discover why a piece of code that I run causes my JVM memory usage to go up about

RE: Why does this code disable styling?

CF4.5 compatible 4.5... who still uses that? ;o) I'm on CF 8 now! :o) I saw the CF_REextract tag... I didn't work with it much because I couldn't see how to use it. I'll check it out again. Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent:

RE: Query Question

You can't really. Your DB is badly designed if you have one field called hierarchy that contains multiple elements. Its not normalised. Normally the hierarchy would be in a different table. But if you want to persist with this and you can change the hierarchy field you would need to store it

RE: CFGRID Select Row

Thanks, That seems to select, but not highlight the row. Regards Dale Fraser http://learncf.com -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 October 2007 10:40 PM To: CF-Talk Subject: Re: CFGRID Select Row simple as everything ajax seems to be:

RE: CFGRID Select Row

I think the problem is that I'm doing a refresh followed by a grid. And perhaps the grid hasn't finished refreshing when i'm doing the select. Is there some event that you can add to the refresh such as an onSuccess or onComplete to then select the row. Regards Dale Fraser http://learncf.com

RE: Why does this code disable styling?

Hmmm... CF_REextract looks useful, but the problem is that I'd have to know enough regex to tell it what RE1 and RE2 should be. If I knew that, I could probably write the regex. This shouldn't be too hard... I can look up a regex reference and probably set it up. It's just a matter of

Fire and forget CFTHREADs / CF8

So here's a question. I execute a cfthread on application startup, and it finishes its work. There is no terminate because the page context it was called from is long gone, and I've just discovered that a thread can't terminate itself. it leaves the thread running, basically forever.

RE: CFGRID Select Row

That link to the docs is great, I've looked at the Ext docs previously, and im doing something dumb as I have no idea how you managed to navigate to get that page. The previous page has that getSelectionModel, but there doesn't appear to be any links taking you to the objects' page that you

RE: Query Question

Yeah, I see what you are talking about. I think that I need to look at redoing this table for sure. This was my first stab at a CMS and I am discovering some issues with it. This band-aid solution will work for the interim though. Thanks, Bruce -Original Message- From: Dale Fraser

How to write this regex?

Hi, all. I thought I could figure this out, but apparently not. at least so far. But how would I write a regex that would find all spaces and change them to nbsp; except those inside a or ? REreplace(string, all spaces not in between and , nbsp;, All) And I'd rather not have an unbreakable

Exporting from ColdFuion to a Excel file

Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Enterprise web applications, build robust, secure scalable

Re: Exporting from ColdFuion to a Excel file

cfcontent type=application/vnd.ms-excel cfheader name=Content-Disposition value=filename=#filename#.xls cfoutput#pageContent#/cfoutput I assume this will still work on 8 Jerry On 10/11/07, Steve Sequenzia [EMAIL PROTECTED] wrote: Can someone please give me some insight into exporting data to

Re: Fire and forget CFTHREADs / CF8

Charles, What makes you think that a Thread doesn't end when the code stops processing? Mark On 10/12/07, Charles Sheehan-Miles [EMAIL PROTECTED] wrote: So here's a question. I execute a cfthread on application startup, and it finishes its work. There is no terminate because the page

Re: Fire and forget CFTHREADs / CF8

I'm pretty sure that's not actually the case. I'd wager that CF has an internal thread pool, so that thread, once it's finished with it's assigned task, just remains in the pool to be reused as needed. This is similar to how CF page requests work: there is a pool of sleeping request processing

RE: Exporting from ColdFuion to a Excel file

Or, if the data is query data, use cfreport which can output to Excel. --- Ben -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:26 PM To: CF-Talk Subject: Re: Exporting from ColdFuion to a Excel file cfcontent

RE: Exporting from ColdFuion to a Excel file

Steve, Like skinning a cat, there are several ways to have a web document end up in Excel. Can you describe your scenario? What are you trying to accomplish? William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey:

RE: Exporting from ColdFuion to a Excel file

@Jerry - I have been trying that way but I am getting an error when the file opens. It says The file you are trying to open, 'dataFile.xls' is in a different format than specified by the file extension. For some reason it is trying to use the .cfm file. @Ben - Thanks for the help. I did not

RE: Exporting from ColdFuion to a Excel file

William, Sorry for not being more descriptive. I just need to export a really basic query from SQL to Excel. It only has like for fields and no formulas. Thanks __ Steve Sequenzia Thinksys Incorporated 1613 E Livingston St Orlando, FL 32803 866.633.3000 x305

Re: Can a ColdFusion application see what processes are scheduled?

have a look at cfschedule http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0328.htm On 10/11/07, Robert Mack [EMAIL PROTECTED] wrote: I can see the current scheduled processes through the administrator, but is there

Re: Memory Issue

Also, I am almost positive that Replace() is creating another string variable under the hood, which means in this nested loop that could be a huge number of new CF string variables, depending on how many iterations you're doing. cfset fileOutput.append

Re: Dates with Query of Query

Have you tried ...? cfset today = createODBCDate(now()) cfset tomorrow = createODBCDate(dateAdd('d', 1, now())) WHERE reminderDate = cfqueryparam cfsqltype=cf_sql_date value=#today# AND reminderDate cfqueryparam cfsqltype=cf_sql_date value=#tomorrow# You might also try CAST'ing the

Re: Returns the value, quot;16,16quot;?? Please help!

You'll get smarter answers if you say some words in your post. While I have to agree, I suspect you problem is your form uses method=get and you're appending #CGI.QUERY_STRING# to the action page. That will duplicate your parameter values. cfform

I seek PT/FT CF developer Bethesda MD

I need someone to help me out with a health care related application that is really unique. Has a MS SQL database behind the CF. Will Pay $35/hr and need you PT or FT or temp, flexi hrs but need at least two days a week. 301-332-2686 or [EMAIL PROTECTED] call me we'll talk. Good English