Re: cfslider vgalue and onchange event

To note, the mxajax system acutally uses script.aculo.us. "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential an

Re: latest server version

7,0,2,142559 over here. Isn't that info avialible via the Adobe site? On 9/20/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > Can someone that has updated CFMX 7 up to the latest updater fire me the > server version number as reported in CF Admin > > Thanks

RE: cf [-] search varchar

Ok first of all you don't need hashes when doing Secondly, you need to split the string, if the string rRefereAgencyNo contains 1994-5668-273749-2 it will only ever find one record using Like '%#rReferAgencyNo#' Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 867

Re: Cfquery in Javascript

Thank you very much for responding. Mullai ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fus

RE: Option Explicit - CF?

No Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Charles Sheehan-Miles [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 September 2006 9:51 AM To: CF-Talk Subject: Option Explicit - CF? Hello all,

Re: cfslider vgalue and onchange event

You could consider replacing it if it doesn't do what you want: http://wiki.script.aculo.us/scriptaculous/show/SliderDemo and the MXAJAX implementation (the demo page below is broken in IE but the downloadable version works. FF works regardless): http://www.indiankey.com/mxajax/examples/mxSlider

Re: cfe & aptana

I guess I missed the plugin and only sw the whole ide but as it turns out I tend to like the ide a lil bit better, so im good, I did try to drop in the cfe nightly build and it didnt seem to work and I did want the new menu bar but when i did the reg find plugin way it found the stable versions

Re: CFInput text and onclick functionality

On 9/20/06, Jon Clausen <[EMAIL PROTECTED]> wrote: > Scott, > As Dave said, if you're using a Flash/Flex form you will need to use > Actionscript to control any form elements. The .swf file which is Sorta OT, but: Anyone had any luck with the "bridge"? It's supposed to let the swf access the D

Re: Webservice Session Authentication

On 9/20/06, Greg Luce <[EMAIL PROTECTED]> wrote: > Maybe I'm way off base trying to authenticate the user and start the session > via webservice. If the SSL is enough with an encrypted url var that would > make my life alot easier! That's pretty much how it all works anyways, right folks? Maybe k

Re: How to get these query results

On 9/20/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > SELECT * > FROMdates_table, > events_table > WHERE dates_table.EventID = events_table.EventID > > But, my question concerning it being "bad code" was, really, how > much slower for probably a small

Re: What if....

Thanks nathan! To be sure, I just changed it to init() in onAppStart(). Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door

Re: What if....

You just overwrote it the second time. Probably not a big deal unless you had some important instance data in there. To greatly oversimplify, it's like this: a="hello"; a="hello"; now what is the value of a? haha. Technically, what it does, with objects that pass by reference (cfcs, structs), i

Option Explicit - CF?

Hello all, Is there a CF variant of "Option Explicit", that REQUIRES variables to be declared inside your component before using them? Something that would cause an undeclared variable to crash the page instead of executing it? Thanks, Charles

latest server version

Can someone that has updated CFMX 7 up to the latest updater fire me the server version number as reported in CF Admin Thanks Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL P

What if....

You already had an object created in application scope, then it was created again from somwhere else? So you create it twice. I just ran a test and it didn't do anything bad. I have a mail notifier cfc that sends out mail. The way I had set it up was to create it from a paypal IPN page. Now I

RE: Flash Forms and sending a grid to a cfc

In all my flash forms I use, I bind the data from the grid to input fields in the form. When the user clicks save you acutally send the data in the input fields as opposed to the grid. Make sense... -Original Message- From: DURETTE, STEVEN J (ASI-AIT) [mailto:[EMAIL PROTECTED] Sent: We

cf [-] search varchar

i am having a bit of a problem with this i have this search i am working on every thing works fine, except the column that stores numbers like 1994-5668-273749-2 it is a varchar field in the db in my query i can do this AND ReferAgencyNo = '#fReferAgencyNo#' to get an exact match of the field: 1

Re: How to get these query results - Take 2

The easiest way I've seen to do this is to have a "most recent update" date field in the "events" or "documents" table. An insert/update trigger on the "updates" table can guarantee that the "most recent update" field will always be accurate. Then, all you need is a query something like this:

RE: New SQL 2005 Install

I am running SQL 2005 in 2003 Enterprise. No problems. Running MX 7.0.1 on 2003 Standard. No problems. SQL 2005 kicks butt. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:13 PM To: CF-Talk Subject: New SQL 2005 Install Just che

Re: New SQL 2005 Install

I don't know of any - we have been using it for a while. "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may

RE: CFchart scaleFrom and scaleTo

Thanks Josh I had thought about multiplying the results to make them simple integers. Unfortunately I'm working from what is currently done in Excel and with a client base that is very finicky. It could be a bit of a sell to show them a chart that shows values of 8, 15, 37 instead of what is

New SQL 2005 Install

Just checking with the community for any know issues with SQL Server 2005 on 2003 OS and ColdFusion MX7 Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu

Re: CFInput text and onclick functionality

Scott, As Dave said, if you're using a Flash/Flex form you will need to use Actionscript to control any form elements. The .swf file which is generated to create the form cannot be accessed through the javascript DOM. For what you want to do, you can just include the AS function in the f

cfslider vgalue and onchange event

I am having difficulties with the cfslider. I want to have a text box that displays the value of the slider rather than having the label displayed in the slider. I would like to know firstly if this is possible and secondly if the cfslider can be programmed to respond to the user changing the

cfslider vgalue and onchange event

I am having difficulties with the cfslider. I want to have a text box that displays the value of the slider rather than having the label displayed in the slider. I would like to know firstly if this is possible and secondly if the cfslider can be programmed to respond to the user changing the

RE: CFInput text and onclick functionality

> I can't because all of the controls are rendered as > flash/flex components. I don't think you can include Javascript at all, then. You will have to use ActionScript instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-autho

Re: CFInput text and onclick functionality

so is the script validation a javascript that should be placed outside of the form in a ? Then I need to reference it correctly? >On 9/20/06, Dave Watts <[EMAIL PROTECTED]> wrote: > >d'oH! i hadn't noticed that. i just assumed that he used what i gave him :) > >-- >Charlie Griefer > >

Re: CFInput text and onclick functionality

You may also want to use onFocus to call this function, as that will get cases where someone tabs into the field as well as cases where they click in. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hittin

matching phrases with verity simple search

We are having problems making Verity search like the documentation says. Using CFSERACH with type=simple (and case-insensitive), we find the following: - searching for the phrase, american painting, returns all records with either american or painting - searching for american AND painting return

RE: Validation is being ignored

> Not sure - but can't I place these two files in a "scripts" > directory on the site and add a mapping in the application > file or something? Not 100% sure how to do that though... You can specify this within the SCRIPTSRC attribute of the CFFORM tag, or you can change the default location for

RE: CFInput text and onclick functionality

> and i'm totally not familiar with the . can > you not just do a

Re: Validation is being ignored

Jon Clausen wrote: > Are "/CFIDE/scripts/cfform.js" and "/CFIDE/scripts/masks.js" > available from the root of the site? Whoops - included the files in a "scripts" folder and it's working now. Still, I'll contact the host about the mapping... ~~~

Re: CFInput text and onclick functionality

On 9/20/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > I tried the following and it did not work. In the > > documentation of Coldfusion it did not include cfinput text > > fields as an object that coul do onClick. The following > > example did not work. > > > > > > > > function doFunction(ff

Re: CFInput text and onclick functionality

I can't because all of the controls are rendered as flash/flex components. >i don't use cfform...so not really sure what's going on. can you view >the source of the page in the browser and see that the onclick is >still there in the rendered tag? > >...and i'm totally not familiar with the . ca

Re: Validation is being ignored

Jon Clausen wrote: > Are "/CFIDE/scripts/cfform.js" and "/CFIDE/scripts/masks.js" > available from the root of the site? Not sure - but can't I place these two files in a "scripts" directory on the site and add a mapping in the application file or something? Not 100% sure how to do that thou

RE: CFInput text and onclick functionality

> I tried the following and it did not work. In the > documentation of Coldfusion it did not include cfinput text > fields as an object that coul do onClick. The following > example did not work. > > > > function doFunction(ff) { > if (ff == "00-00-") { >ff

RE: cfe & aptana

The only configuration I've found that doesn't work is trying to install the CFEclipse 1.3 Beta plugin on the Aptana IDE. However, installing the Aptana Plugin and CFEclipse 1.3 Plugin in an Eclipse IDE works fine. -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Wedn

Re: CFInput text and onclick functionality

i don't use cfform...so not really sure what's going on. can you view the source of the page in the browser and see that the onclick is still there in the rendered tag? and i'm totally not familiar with the . can you not just do a

Re: CFInput text and onclick functionality

I tried the following and it did not work. In the documentation of Coldfusion it did not include cfinput text fields as an object that coul do onClick. The following example did not work. function doFunction(ff) { if (ff == "00-00-") { ff.value = "";

Re: CFInput text and onclick functionality

does just adding an onclick="doFunction();" not work? function doFunction(ff, ffvalue) { if (ffvalue == "default") { ff.value = ""; } } ? On 9/20/06, Scott Hoff <[EMAIL PROTECTED]> wrote: > I have a text input box and I want to clear out the defau

CFInput text and onclick functionality

I have a text input box and I want to clear out the default values in the event that somoene clicks on it and the default values are still entered in that text box. Is there anyway I can recreate the onclick functionality? The onchange works, but I really need to clear the box when users cli

CFInput text and onclick functionality

I have a text input box and I want to clear out the default values in the event that somoene clicks on it and the default values are still entered in that text box. Is there anyway I can recreate the onclick functionality? The onchange works, but I really need to clear the box when users cli

Re: CF error handler

Something is wrong as you should have no problem with CF code in your missing template handler. HOWEVER you cannot put a cfinclude into it (or there are restrictions to its ability to find included files... I forget which but we had a long thread on it here when I discovered the problem). Rather

Placing a pointer in cfchart

Hi, I am very new in coldfusion but getting the hang of it slowly. The latest thing i am stuck on is wondering if i can place a point in a cfchart. The graph i am displaying is much like a horizontal temperature guage. For example, the chart may have 3 different colours, cool, warm, and hot, a

CF error handler

Hi. I am trying to set up a error handler page/ missing template handler template in the Coldfusion Administrator Settings. My file is errorpage.cfm. If I try to put any cfml into that code, even a cfinclude tag, it generates hte regular file not found error when trying to access a missing template

Re: CFForm inside HTML form

Jake, I'm not sure I understand. Why can't you contain all of your data you want submitted inside your ? You can use the and still use HTML form elements inside without having to convert them to ,, etc. Unless you want to write a bunch of javascript to create inner form fields to pass

Re: Webservice Session Authentication

Maybe I'm way off base trying to authenticate the user and start the session via webservice. If the SSL is enough with an encrypted url var that would make my life alot easier! I'm open to any ideas! Greg On 9/20/06, Greg Luce <[EMAIL PROTECTED]> wrote: > > OK, are you saying just sending their

RE: Table Rename

You were correct; I recreated the datasource and all works fine now. Guess I've spent to much time looking at this computer screen. Thanks. -- Sam -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 10:42 AM To: CF-Talk Subject: RE: Table

RE: NFL Player Stats Service

I asked about this a week or so ago, and got no answer. Also did some googling, and unless you want to pay exorbitant fees (I seem to remember $1000 p/mo), or scrape screens (I would think this would be virtually impossible with player stats) illegally and risk getting caught, no. Would be nice t

RE: Table Rename

That sounds like a connectivity issue rather than syntax. -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:36 PM To: CF-Talk Subject: Table Rename Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005.

CFForm inside HTML form

I have an HTML form but would like to put a cfgrid inside it. In order to do this I have to surround the cfgrid with cfform tags. All fine, it looks great. However, it doesn't work. When the main form is submitted, the data inside the cfform (which is inside the main form) is not submitted

Re: Table Rename

ALTER TABLE #old_tablename# RENAME TO #new_tablename# On 9/20/06, Sam Roach <[EMAIL PROTECTED]> wrote: > Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL > Server 2005. > > Here is what I am trying. > > > sp_rename '#old_tablename#',

Re: CFchart scaleFrom and scaleTo

Hi Ian, I notice folks aren't much responding to your cfchart inquiries. I've struggled with some of the cfchart implementations as well -- I think because they're fairly new, there are still some small details that don't function 100% as expected, plus I think not too many people are using th

Table Rename

Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005. Here is what I am trying. sp_rename '#old_tablename#', '#new_tablename#' I am receiving this error. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Er

NFL Player Stats Service

Anyone know of a site or service that is free or relatively cheap that will supply real time NFL players data via xml feed or feed into a SQL database? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hittin

Re: Validation is being ignored

Are "/CFIDE/scripts/cfform.js" and "/CFIDE/scripts/masks.js" available from the root of the site? If the CFIDE virtual directory is missing and those two scripts are 404'ing, that's usually a common cause. If the form fields are critical, you should consider adding some server-side validati

flash forms and unix

I was having issues trying to populate a tree component with remoting. The data was returning prior to the flash form completing its rendering. I added an eventListener with the forms onLoad event, the function call to populate the tree occurs when the eventListener is fired. This worked perfe

Validation is being ignored

Validation is being ignored. Any ideas why? .. Level: Enterprise Name ColdFusion Server Version 7,0,2,142559 View source on the page in question shows the appropriate javascript being generated ~| Introducing the F

Re: Branch target offset too large for short?

>Anyone seen this before? Im simply working with a CFC that has worked >fine, until some changes ive just added, but nothing too crazy just >some cfset statements, and some cfparams were added to it. > >thanks! >tony > >-- >'Never have anything in your life that you can't walk out on in thirty >s

Re: Webservice Session Authentication

OK, are you saying just sending their credentials via url over SSL is best? On 9/20/06, Jim <[EMAIL PROTECTED]> wrote: > > 1) an idea: > > they send their credentials to you ws > > if okay, you generate a really long (say, 256 characters) random string > > you update their user record, and put tha

Re: Flash Form stalls at PreLoad

I beleive that is in fact an issue of me constantly refreshing the browser. I don't experience any issues the first time I load and I've bounced around the office making sure that it runs fine on the initial download and found that it was. I appreciate everyone's help and thanks again. >Scot

CFchart scaleFrom and scaleTo

I'm built some logic to figure out how to scale charts containing dynamic data to help highlight the variations instead of show a series of relatively flat values with large bars. But I'm finding many times the CFchart tag is ignoring my scaleFrom and scaleTo values. Particularly the scaleFrom

Re: Flash Form stalls at PreLoad

Scott - it took about 6-7 seconds to load for me. Not bad at all. Then I hit refresh and it loaded immediately. I think you could be having issues from refreshing a bunch of times. Are you developing on your local box, or are you using a remote server? That will also give you different res

Re: cfe & aptana

Aptana does not give code insight to inline JS or CSS, only in dedicated .js or .css files. On 9/20/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > Are you getting Aptana tag insight in a CF perspective (CF/JS etc)? > > > > > > -Original Message- > From: Larry Lyons [mailto:[EMA

RE: Flash Forms and sending a grid to a cfc

Well, since the grid is small (4 to 5 rows, with 7 items per row), I figured that it would be easier to send the grid. I don't know how I would send just the changes. -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 12:24 PM To: CF-Talk

Re: Flash Form stalls at PreLoad

Thanks a lot for going and checking it out. What do you think might be causing it to lock up every once in a while? Is the pre-load affected at all by the overall stress on the computer that you are using? I also usually don't have that many problems usually... however, sometimes I think that

Re: Webservice Session Authentication

1) an idea: they send their credentials to you ws if okay, you generate a really long (say, 256 characters) random string you update their user record, and put that string into a field e.g. authkey you send that string back to them they then send that string to the report for auth, which check

RE: Flash Forms and sending a grid to a cfc

Instead of sending the whole grid, just send what's changed. Why send a whole grid of data if you don't have to? Cheers, !k -Original Message- From: DURETTE, STEVEN J (ASI-AIT) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: CF-Talk Subject: Flash Forms and se

RE: Flash Form stalls at PreLoad

That worked really fast for me. It took maybe 3 or 4 secs to load, than another 2 to initialize. Considering how much it needs to load, I think it's doing extremely well. !k -Original Message- From: Scott Hoff [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 10:05 AM To: CF

Flash Form stalls at PreLoad

I'm currently working on setting up my a fairly complex flash forms with a lot of tabs and validation. I have to say that it really only loads smoothly one out of 4 times. The other times, I run into issues when it says "initializing" or "Loading library". Furthermore, it almost always stops at

Webservice Session Authentication

OK, this has kicked my butt for 2 days now. I have a CF application (SSL) with a certain report a client wants to serve up inside their C#.NET app frameset. They have credentials they can provide. I've been trying to use a webservice to authenticate these credentials (username/pw) and if good creat

RE: cfe & aptana

Are you getting Aptana tag insight in a CF perspective (CF/JS etc)? -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: 20 September 2006 15:23 To: CF-Talk Subject: Re: cfe & aptana > does anyone know if cfe will work in aptana? > I would just try it but everytime i

Flash Forms and sending a grid to a cfc

Hi all, I have a flash forms question! I have a flash form with a grid that uses remoting to get the data to display in the grid. That part works fine. The problem is I want to let the user edit the grid and submit the changes back to the cfc through remoting. I tried using the suggestion

RE: Javascript - Refresh a window

Dave Francis wrote: > I have a window from which I open pop-up with JS > window.open();. When I > close this pop-up - self.close(); - is there any way to force a refresh of > the "parent" window? Dave: When a window creates a pop-up, it creates within the pop-up a reference back to the open

SQL Server Upgrade and Coldfusion

We're getting ready to migrate from SQL Server 2000 to SQL Server 2005. We're running CFMX 7.0.2 on our web server. We do not have ANY stored procedures or triggers... Is there anything I should be concerned about, any "gotchyas" with Coldfusion and the database upgrade? rick ~

Re: Could not perform Web service invocation

I tried that try/catch with the [coldfusion.server.ServiceFactory] "refreshWebService" call and still can't get it to work. The problem occurs right after we restart our coldFusion servers. This is the error message that I get when I call refreshWebService: coldfusion.jsp.CompilationFailedExcept

Re: How to get these query results - Take 2

On 9/20/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > But why would you separate the dates from the documents? > > Are you keeping a version archive or update history? > Yes, it's an update history. One document has many updates. It's actually comments about the document, not changes to the docu

RE: How to get these query results - Take 2

But why would you separate the dates from the documents? Are you keeping a version archive or update history? Rick -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 10:56 AM To: CF-Talk Subject: Re: How to get these query results - Ta

RE: OT: Javascript - Refresh a window

Make sure the refresh line goes before the self.close line or else it won't work. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 8:43 AM To: CF-Talk Subject: Re: OT: Javascript - Refresh a window Dave Francis wrote: > Hi, > I hav

Re: How to get these query results - Take 2

On 9/20/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I'll let the experts "enjoin" the fight about > > the coding...but, I'm curious as to > what type of application your coding for...a calendar and recurring events, > or > something else? Rick, the actual data has nothing to do with events. I

Re: How to get these query results - Take 2

On 9/20/06, Jim Wright <[EMAIL PROTECTED]> wrote: > This could be done with a subquery in the ORDER BY... > > SELECT a.EventName,b.EventDates > FROM Events a INNER JOIN EventsDate b ON a.EventID = b.EventID > ORDER BY (SELECT max(eventdates) FROM EventsDate WHERE eventid = > a.eventid) DESC,a.Event

Re: cfe & aptana

> does anyone know if cfe will work in aptana? > I would just try it but everytime i add a non compatible plugin to > eclipse is seems to take a big shit and i gotta start over. And I > really like a lot of the features in Aptana, especially the css > support, way better than myeclipse. > > tia

Re: How to get these query results - Take 2

Matt Something like this may help you then (results at http://www.fclounge.cfdeveloper.co.uk/test.cfm ) select * from tblEventName evName inner join tblEventDate evDate on evName.eventID = evDate.eventID select eventname,tbleventdate.eventid, max(eve

Re: Is anyone minding the store at Adobe?

I fully agree. It took a day and a 1/2 - but my issue was eventually forwarded to an appropriate support member at adobe. He is being extremely helpful - and committed - my last email from him yesterday was sent @ 23:59 - and he has responded to all my emails very quickly. The issue I had was th

RE: How to get these query results

Thanks for the answer...that's just the explanation I was looking for... Rick -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 8:54 AM To: CF-Talk Subject: Re: How to get these query results Rick Faircloth wrote: > You're saying that the

Re: How to get these query results - Take 2

On 9/20/06, Kris Jones <[EMAIL PROTECTED]> wrote: > You need to order by both, first the item on which you want to group, > then the item that you want sorted within that group. I've used a left > outer join just incase you have events that do not have dates entered. > > Hopefully, I've not flubbed

Re: How to get these query results - Take 2

Matt Williams wrote: > Rich, you are right in that I want the event with the furthest/newest > date to show first. But if there is another date associated with that > newest event, it should also show under its title. Your solution looks > like it will work. I'll give it a try and let you know. >

RE: How to get these query results - Take 2

The test page works OK with a "www." added: http://www.fclounge.cfdeveloper.co.uk/test.cfm > -Original Message- > From: Matt Williams [mailto:[EMAIL PROTECTED] > Sent: 20 September 2006 14:59 > To: CF-Talk > Subject: Re: How to get these query results - Take 2 > > Rich, you are right in

Re: How to get these query results - Take 2

Rich, you are right in that I want the event with the furthest/newest date to show first. But if there is another date associated with that newest event, it should also show under its title. Your solution looks like it will work. I'll give it a try and let you know. I am hoping to find a "bit more

RE: OT: Javascript - Refresh a window

Well, that was quick. Thanks Jim -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:43 AM To: CF-Talk Subject: Re: OT: Javascript - Refresh a window Dave Francis wrote: > Hi, > I have a window from which I open pop-up with JS window.

Re: OT: Javascript - Refresh a window

Dave Francis wrote: > Hi, > I have a window from which I open pop-up with JS window.open();. When I > close this pop-up - self.close(); - is there any way to force a refresh of > the "parent" window? > opener.window.location.reload()

Re: How to get these query results - Take 2

I presume the design is based on one table for the event names and a separate for instances of those events on a given date which seems sensible. Matt if you need the output based on the event names alphabetically and then the dates desc in them then Jim/Kris code is great... my assumption was th

cf-talk@houseoffusion.com

Luckily, my IIS guy got back to me and changed the permissions on the folder, which I didn't have the rights to do. Thanks for the thought, though. On 9/19/06, Gert Franz <[EMAIL PROTECTED]> wrote: > > Write them in a CFM file and then it should be OK... > so you will have something like this: >

OT: Javascript - Refresh a window

Hi, I have a window from which I open pop-up with JS window.open();. When I close this pop-up - self.close(); - is there any way to force a refresh of the "parent" window? Thanks in advance for any and all help, Dave ~~

Re: How to get these query results - Take 2

Matt You can try the following. It seems to work... my gut feeling tells me there may be an easier way with less queries but I can't think of anything right now. You may want to consider caching queries for speed depending on how much the data is changing. select * from tblEvent

Re: cfe & aptana

I have been running Aptana on Eclipse 3.2.0 for months without any issues. Just as a side note, it should have little or nothing to do with the CFEclipse plugin. I am running Win XP Pro. -- - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis

RE: cfe & aptana

I run the Aptana plugin and CFEclipse (beta) at home on Ubuntu with no problems - use Aptana mainly for CSS... Works very well... Jim ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date Col

RE: How to get these query results - Take 2

I'll let the experts "enjoin" the fight about the coding...but, I'm curious as to what type of application your coding for...a calendar and recurring events, or something else? I always put my event dates in the same table as the event ID, event name, etcI was just wondering if I'm missing s

RE: How to get these query results

Indeed.. "ROM table1,table2 WHERE table1.foo = table2.foo (Is NOT ANSI compliant SQL)" This should be avoided. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 20 September 2006 13:54 To: CF-Talk Subject: Re: How to get these query results Rick Faircloth wrote: > Y

Re: How to get these query results - Take 2

Sort on both SELECT a.EventName,b.EventDates FROM Events a INNER JOIN EventsDate b ON a.EventID = b.EventID ORDER BY a.EventName,b.EventDates Then cfoutout grouping on EventName. Matt Williams wrote: > I'm gonna try this again as while I slept last night my previous post > turned into a disc

  1   2   >