Re: CFLog4j

2006-09-19 Thread Dan Plesse
Qasim, I am getting this with my app log4j:ERROR The class org.apache.log4j.Appender was loaded by log4j:ERROR [EMAIL PROTECTED] whereas object of type log4j:ERROR org.apache.log4j.RollingFileAppender was loaded by [ [EMAIL PROTECTED] log4j:ERROR Could not

Re: Is anyone minding the store at Adobe?

2006-09-19 Thread Robertson-Ravo, Neil (RX)
Reckon the best thing you can do is email them direct not via web form (or contact someone direct). They will undoubtedly have problems with integrating two massive sites. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a

Re: Cross-server CFC/WS implementation.

2006-09-19 Thread Tom Chiverton
On Monday 18 September 2006 17:04, Peter Boughton wrote: Do you have a simple* example of a ColdSpring XML config? (*but not too simple) The ColdSpring config includes the following, which creates a user manager that needs access to the database (via Reactor) and a logger: bean

Re: Session.UrlToken on form post in CF7

2006-09-19 Thread James Holmes
Awesome. Have I said recently how much I love this list? On 9/19/06, Ashwin Mathew [EMAIL PROTECTED] wrote: James - Rupesh blogged about this very issue recently: http://coldfused.blogspot.com/2006/09/handling-j2ee-session-with-cookies _12.html -Original Message- From: James Holmes

CFMX 6.1 and FC5?

2006-09-19 Thread Jerky San Pedro
Has anyone tried installing ColdFusion MX 6.1 on FC5? I tried installing one, and got past the installation procedures, but when I tried running CFMX 6.1, I got troubles already. It was looking for a certain libc.so.5 (or was it libcrypto.so.5) and libssl.so.5, both found on FC4. I am thinking

Re: Use CFMX with SAP

2006-09-19 Thread marc --
tanguyr thanks. I tried the POJO link but got an 404 (page not found). I know about the concept of consuming and publishing webservices from CFMX. But how do I find which services are offered by the owner of my particular SAP inplementation? Simply calling uddi.sap.com (the public uddi

Re: Use CFMX with SAP

2006-09-19 Thread tanguyr
Marc, Check the link again, and watch out for wrapping - it should take you to a page entitled SAP Java Connector (SAP Library - Development Manual). Secondly, this is *not* a webservice approach, it's a straight call an ABAP function from java solution (in your case - it can also be used to

RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash

2006-09-19 Thread Ken Ferguson
It might possibly have been an option before the money was spent, but I'm not a fan of doubling up on costs. I'd rather try to fix or get a fix for what I've already spent money to buy. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Vince Bonfanti [mailto:[EMAIL

XMLValidate() and ENTITY declarations

2006-09-19 Thread Rob Wilkerson
Does anyone know whether XMLValidate() handles declared entities correctly? I have what I think is a proper use and yet it's being returned as invalid with the following error: The attribute type is required in the declaration of attribute dialog for element icon. The DTD includes: !ENTITY %

RE: Viaklix

2006-09-19 Thread Stephens, Larry V
On 9/18/06, Jesse Kuhn [EMAIL PROTECTED] wrote: I am looking to use viaklix as well. Has anyone done this successfully yet... their developers guide only supports asp development. I am putting together my first shopping cart and am new to CF so if anyone has been able to get viaklix to work

RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash

2006-09-19 Thread Ken Ferguson
You're right, so I looked around at the rest of our servers. They're all Win2k3/ CF7 and none have SQL Server. RAM usage for the jrun service seems to hover between 85,500K and about 188,000K. All but one of those has traffic which is really quite heavy in relation to the one trouble machine.

RE: MySQL Front

2006-09-19 Thread Ken Ferguson
Chad, Thanks for that link - this looks really good. I'm a Mac user and I've struggled to find something to use which runs on OS X *AND* that I like *AND* works with more than just MySQL or SQL Server... This looks like it was made just for me. I'm downloading it now to check it out. Thanks,

Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE

Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash

2006-09-19 Thread Ken Smith
The latest Macromedia drivers for cfmx are version 3.5 and available here: http://www.adobe.com/go/42dcb10a. Also, Microsoft has a new JDBC driver of their own. It might be worth testing with it to see if there is a change in behavior.

RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Robertson-Ravo, Neil (RX)
Hasn't this always been possible? Didn't you wrap a structure around the array? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 13:34 To: CF-Talk Subject: Passing ColdFusion Arrays By Reference Hey all, I was fooling around with some code last

Re: MySQL Front

2006-09-19 Thread Michael Traher
for us so far the mysql administrator (free download from mysql) seems solid and does everything we need. for add hoc queries I use sqlexplorer which is an eclipse plugin. you could also use the RDS plugin for eclipse. On 9/18/06, Matt Robertson [EMAIL PROTECTED] wrote: A conditional vote for

RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
No, I am NOT wrapping a structure around an array. I am making a pass-by-reference VERSION of an array. If you wrap something in a structure. Then you need to grab it out of a structure when referencing it: cfset objStructure[ array ] = ArrayNew( 1 )/ !--- Update it. --- cfset ArrayAppend(

RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Robertson-Ravo, Neil (RX)
Lol...do you have to comment any references to it as Pure sexyness. ? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 14:10 To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference No, I am NOT wrapping a structure around an array. I am

Re: CFLog4j

2006-09-19 Thread Qasim Rasheed
Dan, Do you have another property file which has this appender 'myAppen' in it? Thanks, Qasim On 9/19/06, Dan Plesse [EMAIL PROTECTED] wrote: Qasim, I am getting this with my app log4j:ERROR The class org.apache.log4j.Appender was loaded by log4j:ERROR [EMAIL

Re: MySQL Front

2006-09-19 Thread Casey Dougall
On 9/19/06, Michael Traher [EMAIL PROTECTED] wrote: for us so far the mysql administrator (free download from mysql) seems solid and does everything we need. Try resorting table column. Casey ~| Introducing the Fusion

Re: CFLog4j

2006-09-19 Thread Brian Rinaldi
Qasim, Just an FYI, I added this to the open-source list ( http://www.remotesynthesis.com/cfopensourcelist) and highlighted in in this weeks open source update at - http://www.remotesynthesis.com/blog/index.cfm/2006/9/18/ColdFusion-OpenSource-Update--September-18 -- - Brian Rinaldi blog -

Re: MySQL Front

2006-09-19 Thread Michael Traher
I hadn't tried that before - you're right no way to do in GUI however you can call the command line from the gui and do alter table tablename modify column columntype after othercol; thats what us tough guys do :-) On 9/19/06, Casey Dougall [EMAIL PROTECTED] wrote: On 9/19/06, Michael Traher

OT: scrolling table

2006-09-19 Thread Chad Gray
Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze panes you can make the header row with the column descriptions stay on the page, but you can scroll down into the data. I am trying to use

RE: MySQL Front

2006-09-19 Thread Pete
Hi there all A couple of products that are available and seem OK - DBQwikEdit from www.thedevshop.com http://www.thedevshop.com/ . And also DBTools from http://www.dbtools.com.br http://www.dbtools.com.br/ These are tools I use regularly. There is one more that I know of Toad

Re: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Rob Wilkerson
On 9/19/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Lol...do you have to comment any references to it as Pure sexyness.? You don't *have* to, but it's strongly encouraged. ~| Introducing the Fusion Authority

Timeout requests after XX seconds . . .

2006-09-19 Thread Earl, George
I'm confused. If the 'Timeout requests after XX seconds' setting in CFAdmin is set to 60 seconds and a request (for us almost always a database request) takes longer than 60 seconds I get a message in the CF logs that 'The unresponsive thread count is up to X.' When the request completes I get a

RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
Sometimes I find it makes the code run faster ;) ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19,

RE: Timeout requests after XX seconds . . .

2006-09-19 Thread Ben Nadel
George, While I have no info on this... I am fairly certain that I have read that the timeout for the page is different than the timeout for a CFQuery tag, hence the issue you are having. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help?

Re: CFMX 6.1 and FC5?

2006-09-19 Thread Tom Chiverton
On Tuesday 19 September 2006 09:38, Jerky San Pedro wrote: Has anyone tried installing ColdFusion MX 6.1 on FC5? I tried installing one, and got past the installation procedures, but when I tried running CFMX 6.1, I got troubles already. It was looking for a certain libc.so.5 (or was it

Re: MySQL Front

2006-09-19 Thread Casey Dougall
alter table tablename modify column columntype after othercol; Yeah why don't I just go back to Informix and dbaccess, oh the good ol days of CRT ;-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

Re: OT: scrolling table

2006-09-19 Thread Larry Lyons
Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze panes you can make the header row with the column descriptions stay on the page, but you can scroll down into the data. I am trying

Re: OT: scrolling table

2006-09-19 Thread Jim Wright
Chad Gray wrote: Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze panes you can make the header row with the column descriptions stay on the page, but you can scroll down into the data.

RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Tom Kitta
I just run the following test: cfset javaArray = CreateObject(java, java.util.ArrayList).Init()/ cfset regArray = arrayNew(1) cfset arrayResize(regArray,10) !--- cfset arrayResize(javaArray,10) --- cftimer label=Test Java Array type=outline cfloop index=m from=1 to=10 step=1

RE: CFMX 6.1 and FC5?

2006-09-19 Thread Steven Erat
Please confirm the name of the missing library. I believe it may be libc.so.6 not .5. Using the rpm command it can be determined which package should have installed a file. Try rpm --query --redhatprovides filename (ref 1). On a RHEL4 system, /lib/libc.so.6 is installed by the glibc-2.3.4

Re: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Gert Franz
Hi Ben, i was quite astonished when I read that CF passes arrays as clones. Railo for instance does not. So Arrays (which are not simple values) are much faster than in MX. And Structures are up to 20 times faster then with MX. But you allways have to live with the fact that a passed variable

RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
Tom, Excellent catch. I did not think to test the ArrayResize() method. Hmmm, that may hinder the use a lot, for the very reason you are saying. I don't want people to have to test for type. Dang! ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer

RE: Timeout requests after XX seconds . . .

2006-09-19 Thread Steven Erat
This has been a common topic over the years. Per the general CFAdmin timeout setting, ColdFusion will not timeout a request while the request is waiting to receive all the data. The general ColdFusion timeout governs most everything else. However, SQL Server and Oracle drivers should support a

Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash

2006-09-19 Thread Vince Bonfanti
Hi Ken, I certainly understand your position. But there are other issues to consider when calculating costs. For example, earlier this year HealthGrades (www.healthgrades.com) was suffering from similar performance and reliability issues. Then they replaced 14 CFMX7 servers with 4

Re: OT: scrolling table

2006-09-19 Thread Larry Lyons
Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Try this one: http://kryogenix.org/code/browser/sorttable/ Its about the best one I've run across so far, and the simplest to implement. You include the javascript

Re: OT: scrolling table

2006-09-19 Thread Peter Boughton
Couldn't see if Jim's link had a solution on it, so here's one that definitely is: http://www.imaputz.com/cssStuff/bigFourVersion.html Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze

Re: OT: scrolling table

2006-09-19 Thread Jim Wright
Peter Boughton wrote: Couldn't see if Jim's link had a solution on it, so here's one that definitely is: The scrolling one was called Grayed Out, which is the one I linked to (for examples, that site just reloads the same table and applies the current style). Sorry, should have pointed

Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash

2006-09-19 Thread Jon Clausen
Ken, I had the same problem with almost exactly the same setup. Since I didn't know it was a known issue, I installed Fusion Reactor to see if I could diagnose the problem after looking through the IIS and Coldfusion logs with no result. While I was in the Fusion Reactor admin, I enabled

Re: OT: scrolling table

2006-09-19 Thread Terry Schmitt
This is my favorite: http://webfx.eae.net/dhtml/collist/columnlist.html -static headers -sortable -draggable columns It's called a ColumnList, but don't let that confuse you. It's a very nice table/grid. It works well in Firefox and IE. Terry

Re: OT: scrolling table

2006-09-19 Thread Peter Boughton
Ah, I see. Still doesn't hurt to have two options. :) Peter Boughton wrote: Couldn't see if Jim's link had a solution on it, so here's one that definitely is: The scrolling one was called Grayed Out, which is the one I linked to (for examples, that site just reloads the same table and

duplicate name output

2006-09-19 Thread Steve LaBadie
I have a form and recording the info in a database. The functionality works great, even send confirmation email. The issue I am having is the output page duplicates same names. My output page basically says Thank you #form_name# Your email has be sent to #to_name Etc. If the from_name

Re: duplicate name output

2006-09-19 Thread Daniels, Gwendelyn
It looks like your query is returning multiple records and then your cfoutput is looping through the query, so for each record it is displaying the from_name. You can either change the query to Select DISTINCT from_name (which should return 1 record) OR you can change your cfoutput to just

RE: duplicate name output

2006-09-19 Thread Brad Wood
Sounds like you do not have a unique primary key, or you are not using it in your select. You may have 100 Janes in your database, but if you want to get this particular Jane's info, you need to select her by the primary key of that table. Just a guess... ~Brad -Original Message- From:

need some help with event gateways

2006-09-19 Thread Phill B
I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Thanks -- Phil ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,

Re: need some help with event gateways

2006-09-19 Thread Michael Dinowitz
What issues are you having? I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Thanks -- Phil ~| Introducing the Fusion Authority Quarterly Update. 80

Re: need some help with event gateways

2006-09-19 Thread Dave Carabetta
On 9/19/06, Michael Dinowitz [EMAIL PROTECTED] wrote: What issues are you having? I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Hi Phil, Jeff Peters recently published an article in the CFDJ specifically on the

Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash

2006-09-19 Thread Dan Plesse
I wonder if this issue has to do with Microsoft undermining Java (again) only this time its with the JDBC driver? I would switch up the driver and start over and see if the problem comes back. If this is a fix please tell everyone about it. Thanks Dan

CFchart format=flash and DHTML

2006-09-19 Thread Ian Skinner
I'm working on a proof of concept page that displays 16 charts using the cfchart format=flash tag. This works just fine, their simple charts and they display fine if I display them all at once. But to add a bit of control to this, I created a bit of DHTML code that allows the user to see the

Re: CFLog4j

2006-09-19 Thread Dan Plesse
Qasim, Your code works, so I tested this outside the view of the CFC's and inside a two liner and I don't get an error mesage but strange [] - output in my log file. Do you know why? cfset PropertyConfigurator = createObject(java, org.apache.log4j.PropertyConfigurator

Branch target offset too large for short?

2006-09-19 Thread Tony
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 seconds

RE: Branch target offset too large for short?

2006-09-19 Thread Matt Quackenbush
See if this helps... http://www.easycfm.com/forums/viewmessages.cfm?Forum=12Topic=9444 Thanks, Matt -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 2:51 PM To: CF-Talk Subject: Branch target offset too large for short? Anyone seen this

Re: need some help with event gateways

2006-09-19 Thread Phill B
I took the examples I've found and made a cfc that watches a directory for changes. I then tried to start my new gateway and it fails. I looked in the logs and I cant find any real error message. Just that it tried to start it. I tried to start the ones that came with MX7 and those fail to start

Re: Branch target offset too large for short?

2006-09-19 Thread Alan Rother
Do you have any cftransaction tags? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by

Re: Branch target offset too large for short?

2006-09-19 Thread Tony
not a single on in the ENTIRE cfc. i already tried google :) but thanks! any other ideas? i mean, literally i added maybe 30 lines to it... and they were pairs of these: cfparam name = session.eventStruct.switchOne default=0 and then this... cfset session.eventStruct.switchOne =

How to check the status of a checkbox in a array

2006-09-19 Thread Web Master
I am creating an array of records in a single query. I want the user to be able to select the records the wish to update, input the new values for each record they with to update, then update. I have my form which diplayes the infomation with the folloing checkbox. There may be one record for

Re: need some help with event gateways

2006-09-19 Thread Michael Dinowitz
One of the problems with gateways is that they operate in a different 'space' than a standard CF application and if an error is thrown, the site wide error handler does not handle it. What I do is have a separate gateway directory with my gateways in it (actually gateway stubs) along with an

RE: How to check the status of a checkbox in a array

2006-09-19 Thread Doug Bezona
If a checkbox is not checked, it doesn't exist in the form scope when submitted, so you'll need to handle that, e.g. cfif isDefined('form.myCheckbox') use the checkbox cfelse Something else /cfif Note that this is different behavior from most other fields, where even if it has

Re: How to check the status of a checkbox in a array

2006-09-19 Thread Will Tomlinson
cfparam the checkboxes. Will ~| 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.

Re: need some help with event gateways

2006-09-19 Thread Phill B
Thanks Michael. I got it working now and ready to have some fun. WooWho! On 9/19/06, Michael Dinowitz [EMAIL PROTECTED] wrote: One of the problems with gateways is that they operate in a different 'space' than a standard CF application and if an error is thrown, the site wide error handler

CFMX 7 - Oracle CLOB / cfstoredproc

2006-09-19 Thread Mike Garner
I have been messing with this issue all day - searched around without much success. Here's the issue, we are on Oracle 10g R2. We upgraded our JDBC driver to 3.5. I am now trying to get the following test code to work (test.xml is a simple xml file): **

Re: Scheduled Tasks Not Running

2006-09-19 Thread Stephen Kingston
Hello, having the same problem, and have changed the FILE security in IIS and still no luck... can you confirm what you did? I have: right click on 'test.cfm'in IIS, choose Properties click FILE SECURITY tab click Authentication and access Control EDIT button ??Leave enable anonymous access

Re: Use CFMX with SAP

2006-09-19 Thread Jochem van Dieten
marc -- wrote: Having an online timesheetmodule connected directly to SAP should makes things easier: the employee fills in the sheet (a form) and submits the timesheet to SAP. SAP validates the timesheetdata using it's validationrules and generates error messages if something's wrong.

a bit OT...people counters and CF

2006-09-19 Thread Douglas Knudsen
anyone work with people counters from ProdCo before? Wondering if we can right our own stuff to nab the data from them. -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| Introducing the Fusion

trouble with permissions IISCSS

2006-09-19 Thread Crow T. Robot
I am finishing up a project for Alpha presentation tomorrow on a client's server. Today, I FTP'ed all the files up to their server, but I am having trouble with my css files. My .cfm files are showing up fine, but all my layout files are not being processed, which throws off my whole

Re: Use CFMX with SAP

2006-09-19 Thread Douglas Knudsen
I built a Flex front end schedule tool in my company to get them off that 1980's Excel solution. Used Java on the back side. Coupled with the below...bamm! With the new Flex 2, could even proxy through CFCs to Java Pojos or go direct with WebServices. DK On 9/18/06, tanguyr [EMAIL PROTECTED]

Re: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Mark Mandel
Ben - See my comment on making your Collections syncronised - its something i hope you haven't overlooked. Mark On 9/20/06, Gert Franz [EMAIL PROTECTED] wrote: Hi Ben, i was quite astonished when I read that CF passes arrays as clones. Railo for instance does not. So Arrays (which are not

cfe aptana

2006-09-19 Thread Dave Lyons
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 dave

Re: cfe aptana

2006-09-19 Thread Dave Lyons
n/m, i went ahead and tried it and it does work and the ftp actually kinda works too :) personally, i like this ide better so far. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date

Re: CFMX 6.1 and FC5?

2006-09-19 Thread Jerky San Pedro
Thanks, Tom and Steven. Steven, it is really so.5 that my CFMX 6.1 is looking for. I've read the tip on checking which rpm provides which on some other forum, and the libs I need comes from the openssl package. The openssql-9.7f which comes with FC4 has the so.5 libs, the openssl that comes

Re: cfe aptana

2006-09-19 Thread Kris Jones
Maybe it was the Aptana version I had installed, but I experienced bad memory leaks with it. After Aptana install Eclipse would run away with my resources requiring a fresh boot at least once a day, often more. I uninstalled Aptana, and the problem disappeared. Cheers, Kris n/m, i went ahead

CFDEVCON - UK coldFusion developer conference

2006-09-19 Thread Snake
Yes finally a UK ColdFusion developer conference (well a mini one at least), which will be taking place In November this year.. For more information please visit www.cfdevcon.com. -- Russ Michaels CFDeveloper - ColdFusion Developer Community www.cfdeveloper.co.uk

How to get these query results

2006-09-19 Thread Matt Williams
So I have 2 tables. Example data and desire results below. EventID, EventName 1 | TestEventOne 2 | TestEventTwo EventID | EventDates 1 | 9/10/2006 1 | 9/20/2006 2 | 9/15/2006 !--- Desired results --- TestEventOne 9/20/2006 9/10/2006 TestEventTwo 9/15/2006 So basically I want to order

RE: How to get these query results

2006-09-19 Thread Andrew Scott
Select * from Table1 Inner join Table2 on table1.EventId = table2.eventId You might need a left or right outer join though Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Matt Williams

RE: How to get these query results

2006-09-19 Thread Andrew Scott
Oops Sorry then you can cfoutput query=QueryName group=EventId Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Introducing the Fusion Authority Quarterly

RE: How to get these query results

2006-09-19 Thread Michael E. Carluen
cfquery name=your_query SELECT * FROMdates_table, events_table WHERE dates_table.EventID = events_table.EventID /cfquery cfoutput query=your_query group=EventID #EventName#br cfoutput group=EventDate #EventDate#br /cfoutput br

RE: How to get these query results

2006-09-19 Thread Andrew Scott
Michael, You really need to learn inner joins, sorry but that is bad sql code without it. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday,

RE: How to get these query results

2006-09-19 Thread Michael E. Carluen
Andrew, The sql with cfoutput I sent Matt would do what he needed, as he stated- period. I know how to do inner/outer joins, but wont do it just for the sake of doing it. But thanks for your good advise. Michael -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent:

RE: How to get these query results

2006-09-19 Thread Andrew Scott
That's ok, but for anyone else reading this. Although the sql is ok, it does end up being translated at the SQL server level with an inner join anyway. And in this case a left outer join might be better, because the results might not be what you would normally expect. Just for the newbies

Re: trouble with permissions IISCSS

2006-09-19 Thread Gert Franz
Write them in a CFM file and then it should be OK... so you will have something like this: link href=mycss.cfm type=text/css rel=stylesheet and in the mycss.cfm you have your styles and everything else... or you use style tags in your topmost cfm file. It's just a workaround until you can reach

RE: How to get these query results

2006-09-19 Thread Michael E. Carluen
And in this case a left outer join might be better, because the results might not be what you would normally expect. Andrew, pls explain what you meant by might not be what you normally expect? by a simple SELECT * query with a simple cfoutput grouping. And how using joins for this purpose will

RE: How to get these query results

2006-09-19 Thread Michael E. Carluen
Btw, Andrew, can you also send your idea on how it should be done on the SQL query with joins, but this time include your CF tags to output the results? I truly want to see how much better it is from a simple select with a simple cfoutput grouping. Thanks. -Original Message- From:

Re: cfe aptana

2006-09-19 Thread Dave Lyons
on windows or mac? i've had it on all day in osx with nothing but smooth sailing, even with 3 browsers, mail, yahoo, aim, photoshop, illustrator, transmit, navicat, textedit, imageviewer itunes, eclise, flash 8 dw8 open Maybe it was the Aptana version I had installed, but I experienced

RE: How to get these query results

2006-09-19 Thread Andrew Scott
Michael, I was under the impression you know what inner and outer joins are? But lets take your SQL Code. SELECT * FROMdates_table, events_table WHERE dates_table.EventID = events_table.EventID This is how the database will see that code SELECT * FROM

RE: How to get these query results

2006-09-19 Thread Andrew Scott
Michael, You still use the cfoutput as I sent through before in another message, just that your sql query is preaching bad standards that's all:-) Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From:

RE: cfe aptana

2006-09-19 Thread Andrew Scott
Hmm, have you tried using cfeclipse with the aptana plugin? Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Introducing the Fusion Authority Quarterly Update. 80

Re: CFMX 7 - Oracle CLOB / cfstoredproc

2006-09-19 Thread Gert Franz
Did you check whether Oracle executes the storedproc? You could use the monitorin tool for that while cfm executes. what happens if you call the function directly inside a cfquery tag and dump the result? Just try to fill a variable without . notation eg myXMLOutput. After that, i have no

RE: How to get these query results

2006-09-19 Thread Matt Quackenbush
AMEN! -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 12:48 AM To: CF-Talk Subject: RE: How to get these query results Michael, I was under the impression you know what inner and outer joins are? But lets take your SQL Code.

Awesome ColdFusion Developer needed in Auckland or Christchurch, New Zealand!

2006-09-19 Thread Julian Stone
ProActive Software Ltd ( www.proactivesoftware.com ) is a fast growing global, innovative web-based software provider. It has developed a project and time-tracking solution that services thousands of users globally. PAS is looking for the right person, with the right attitude and skill set to

Sr. ColdFusion Developer NYC

2006-09-19 Thread Amar Gautam
JOB PURPOSE/OBJECTIVE: Web application development / programming for the Reis.com ecommerce portal and customer applications. ESSENTIAL DUTIES AND RESPONSIBLITIES: You will work in small to mid-size teams with other project managers to develop Web-based, mission-critical applications using

RE: Not a jobs list

2006-09-19 Thread Shiva Adli
Thank you Michael for informing us. Shiva -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 8:23 AM To: CF-Jobs-Talk Subject: Not a jobs list The CF-Jobs-Talk list is for discussion about jobs, the job market and related concepts.