RE: missing template handler

2005-09-19 Thread Dave Watts
I created a mapping that points to the directory where my page is and then set the page via /mapping/page.cfm and that worked. Any idea why it needs a two step process in mx7 but not in 5.0? If I recall correctly, in CF 5 a filesystem path was used. In CFMX, the path depends on a mapping,

RE: Site-wide error handler?

2005-09-19 Thread Andy McShane
Thanks for sharing that code Matt, it is exactly what I have been looking for so I will continue to search for what I have done wrong to stop it working. I do have the other templates inside of the same directory so I think that I must be triggering another error apart from my intended one and so

RE: Site-wide error handler?

2005-09-19 Thread Andy McShane
Good call, I will try that also. -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: 19 September 2005 00:49 To: CF-Talk Subject: Re: Site-wide error handler? The problem is my pretty error page does not get display, the egenric ugly coldfusion page always

RE: Site-wide error handler?

2005-09-19 Thread Andy McShane
OK, a follow-up. This just confuses me even more. Did I mention that I was using Coldfusion 7? Anyway, trying to debug DumpMonger as you suggested. Do not understand why this is happening but if I comment out the cfsavecontent tags then all of the relevant structures are output to the screen and

NON Technical CF overview

2005-09-19 Thread Michael Traher
Can you guys point me to some good online sources that give a non-technical overview of what CF can do? I have a colleague who is working closely with the team, helping with documentation and testing and he has expressed the need to know just a little more about CF to make him more effective.

RE: Site-wide error handler?

2005-09-19 Thread Andy McShane
More info, tries it on an MX server, same result. I am forcing an error by trying to output a variable from a query that does not exist. If my only have my standard error page that I use now in the ErrorHandler directory everything is displayed correctly, it only goes wrong when I try to use the

RE: NON Technical CF overview

2005-09-19 Thread Mark Fuqua
I would think, from your description of his role, a generic dicussion of what an application server does, is what you need. Maybe the opening chapter of Ben Forta's WACK book, along with the opening chapters of a relational database book. I would think, as far a documentation and testing goes,

cfdocument and dynamic page breaks

2005-09-19 Thread Rick Root
Hi folks... I've got an application where I'm developing a document that will be printed two sides. Parts of the document need to be forced to be front facing pages (ie, an odd number). Unfortunately, it appears (according to the documentation) that I'm not allowed to do something like this:

ActiveScan or Similar

2005-09-19 Thread E C list
Does anyone know what happened to ActiveScan? I may have need for something with its functionality, and when I went to check it out, I noticed they stopped selling it. I am talking to a customer who may want to be able to scan documents with a TWAIN device and have them automatically upload to

Re: using an xml file for cfc settingsray style

2005-09-19 Thread Ryan Guill
Im not sure what your questions/problems are? I have used an xml config file for a while now and its not difficult. Are you asking how to work with xml or is it more of an architecture question? If you have one set of datasources and other resources that multiple sites and systems will be using,

ColdFusion: Survey on Platform, Application Server, Database support.

2005-09-19 Thread Jacob George
All, We are currently conducting a survey to understand the platform and application server support for ColdFusion MX. We value your feedback, and would appreciate if you take a few moments to respond to some questions at ColdFusion survey http://www.surveymonkey.com/s.asp?u=299931348825 .

Re: ColdFusion: Survey on Platform, Application Server, Database support.

2005-09-19 Thread Rick Root
Jacob George wrote: All, We are currently conducting a survey to understand the platform and application server support for ColdFusion MX. We value your feedback, and would appreciate if you take a few moments to respond to some questions at ColdFusion survey

STILL NEEDING HELP HERE Re: Login page dropping www and not allowing to enter area

2005-09-19 Thread Larry Juncker
Good morning I am writing code for a secure area of my site at the following address http://www.bvesa.org/Admin/ If you happen to type the address without the trailing backslash, and proceed with the login, the site is returned to http://bvesa.org/Admin/ and makes

RE: Jrun Update and cflocation

2005-09-19 Thread Justin Hansen
So, are you saying JRun4 Updater 6, fixed your 'cflocation/302 blank response' issues? We have been seeing it too. It seems to pop up randomly on different sites. We're running CFMX 6.1 and are moving to 7 in production next month. Justin -Original Message- From: Adrocknaphobia

Re: STILL NEEDING HELP HERE Re: Login page dropping www and not allowing to enter area

2005-09-19 Thread Thomas Chiverton
On Monday 19 September 2005 14:38, Larry Juncker wrote: ANY expeditious help on this would be greatly appreciated. Without more details of your code, it's hard to say anything. -- Tom Chiverton Advanced ColdFusion Programmer

Error with Query of Query in a CFC

2005-09-19 Thread Sandy Clark
I'm getting an error while trying to execute a q of q in a CFC. The error I am getting is Complex object types cannot be converted to simple values. which seems to be coming from the From statement. cffunction name=qry_orgsubset access=remote returntype=query cfargument

Re: Error with Query of Query in a CFC

2005-09-19 Thread Qasim Rasheed
Sandy, Try this cffunction name=qry_orgsubset access=remote returntype=query cfargument name=recordset type=query required=true cfset var local=structnew() cfset var temp = arguments.recordset cfquery dbtype=query name=local.rs_subset

Re: Error with Query of Query in a CFC

2005-09-19 Thread Brian Kotek
Couple things Sandy, first shouldn't you have this: cfset var local=structNew() / (you're setting it to the string structnew()). And second, try using just from arguments.recordset instead of from #arguments.recordset#. Note that recordset could well be a reserved work in QofQ so you might

RE: Error with Query of Query in a CFC

2005-09-19 Thread Sandy Clark
That did it Brian, thanks Changed to vRecordset and no problems. Also took the out of the structnew() thanks for catching that as well (don't know how that happened) -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 10:06 AM To: CF-Talk

Re: using an xml file for cfc settingsray style

2005-09-19 Thread Brian Kotek
We create a Config object that wraps up all these sorts of settings (DSN name, table aliases, application settings, etc.) and then just pass that Config object into whatever other CFCs need access to them. On 9/18/05, Andy [EMAIL PROTECTED] wrote: I SET some of the application variables in each

Re: Configuration problem - CFMX7

2005-09-19 Thread Tom McNeer
Claude, On 9/16/05, Claude Schneegans [EMAIL PROTECTED] wrote: Try the solution I found in this link: http://software.groupbrowser.com/The_request_is_not_supported-t181789.html Thanks very much for the suggestion. Unfortunately, this isn't the problem. The symptoms are not as in the

Re: STILL NEEDING HELP HERE Re: Login page dropping www and not allowing to enter area

2005-09-19 Thread Rick Root
Thomas Chiverton wrote: On Monday 19 September 2005 14:38, Larry Juncker wrote: ANY expeditious help on this would be greatly appreciated. Without more details of your code, it's hard to say anything. Unless you've had this problem before. =) It very likely has NOTHING to do with

RE: STILL NEEDING HELP HERE Re: Login page dropping www and not allowing to enter area

2005-09-19 Thread Larry Juncker
Thank You so very much.That took care of it. I knew it would be something simple Larry Juncker President CEO ALJ Computer Services, LLC 1445 So 27th Street Fort Dodge, IA Phone: (515) 576-0885 Fax: (515) 576-8510 [EMAIL PROTECTED]

Re: using an xml file for cfc settingsray style

2005-09-19 Thread Deanna Schneider
You can also have a settings CFC that's accessible to both apps. You can hard code the needed vars in the settings cfc as variables, but allow them to be overwritten on initialization and then require an instance of the settings cfc for each of your other cfcs. When I do this, I place the

International email address causing an issue.

2005-09-19 Thread Rey Bango
We've been having a consistent issue in which certain international emails causes CF to choke. In this case, CFPOP threw the following error when finding this email address [EMAIL PROTECTED]: sun.io.ByteToCharBig5.getIndex1()[S I know its the email address because I've checked the body and

Re: Jrun Update and cflocation

2005-09-19 Thread Adrocknaphobia
No, I'm saying that I could not reproduce this problem. The original poster implied that the problems were caused _by_ updater 6. I applied updater 6 and do not see this issue. (Win2K3 and Win2K Server) -Adam On 9/19/05, Justin Hansen [EMAIL PROTECTED] wrote: So, are you saying JRun4 Updater

Re: Developing a CFX tag in Java

2005-09-19 Thread Claude Schneegans
Thanks Douglas, I tried it, but it looks like about all links refer to adding reloadTRUE/reload in file [cfmx_home]\wwwroot\WEB-INF\jrun-web.xml It may work for servlets or other components, but it does not for CFX classes. IMO this is really a flaw in the design of the Administrator. For C

RE: ColdFusion: Survey on Platform, Application Server, Database support.

2005-09-19 Thread Jim Davis
-Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 8:38 AM To: CF-Talk Subject: Re: ColdFusion: Survey on Platform, Application Server, Database support. Jacob George wrote: All, We are currently conducting a survey to understand

Re: Developing a CFX tag in Java

2005-09-19 Thread Douglas Knudsen
yeah, AFIK, this is common in J2EE development. Seems you use testing, JUnit etc, of teh Java code before testing on the app server. So, in short, use a local JRE to do all your development. Guy Rish's post looks like a good one for this with CFX tags. As kewl as CFX is, I don't recall ever

Re: Site-wide error handler?

2005-09-19 Thread Matt Robertson
Since you can reproduce the problem on different servers and vers it sounds very much like you have something funky in the code. If CF detects an error in your error handler it will default to raw handling. I've never thought to try it before, but maybe you can wrap your error handler in the

Re: International email address causing an issue.

2005-09-19 Thread Paul Hastings
Rey Bango wrote: We've been having a consistent issue in which certain international emails causes CF to choke. In this case, CFPOP threw the following error when finding this email address [EMAIL PROTECTED]: sun.io.ByteToCharBig5.getIndex1()[S not seeing the whole error but this appears

CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread M
Help!! This is not going well. Need to run a query returning all events that happened during the 0405 fiscal year (1 August 2004 - 31 July 2005). Realdate is the column in the events table storing the eventdate (format: dd-mmm-) in a date field in Oracle. Keep getting the error: Variable

RE: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread Ben Forta
Looks like you are mixing CF and Oracle processing. CreateODBCDate() is a CFML function, it is processed by CF so the data you pass to it must exist within CF, it can't be a database column. For this filtering you need to use Oracle date functions, not CF ones. --- Ben -Original

Re: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread M
Nooo. . . . though I know the answer is yes. . . I was just hoping that the fact that my head hurts over this was just a function of it being Monday morning! Thank you! So sad. . . I really needed to do the conversion/comparison within the query so that I could create

Re: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread Deanna Schneider
You can do it in the query. You just need to use Oracle date functions to do it. Try this: cfquery name=findlastyear datasource=enrichment select * from mydevelopmentevents where realdate Between cfqueryparam cfsqltype=cf_sql_timestamp value=#CreateODBCDate(begin)# and cfqueryparam

Re: cfdocument and dynamic page breaks

2005-09-19 Thread Rick Root
Anyone? Rick Root wrote: Hi folks... I've got an application where I'm developing a document that will be printed two sides. Parts of the document need to be forced to be front facing pages (ie, an odd number). Unfortunately, it appears (according to the documentation) that I'm not

RE: SOLVED - SORT OF: Is there a way to see webservice request generated by CFMX?

2005-09-19 Thread Stacy Young
I changed the location of my JAR to {cfroot}/lib and all is fine with CF7. :) As for WSDL2CFML...that's exactly what I was getting at...a tool that would outline the required CF data format required to pass into a web service. Exactly how dreamweaver does it now with the web service and the

Re: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread Molly Abraham
D: You are a rockstar!! Thank you!!! You turned it around. . taught me something new. . .and completely saved a day that looked like it was terminally tanking!! Cannot wait to use cfqueryparam again. . . M

Re: International email address causing an issue.

2005-09-19 Thread Rey Bango
Thanks for the heads up Paul. Its CFMX 6.1 Standard. Does that change anything in terms of what I should be looking for? Rey... Paul Hastings wrote: Rey Bango wrote: We've been having a consistent issue in which certain international emails causes CF to choke. In this case, CFPOP threw the

RE: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread Ian Skinner
Cannot wait to use cfqueryparam again. . . M For many reasons, one should almost always use cfqueryparam. There are, unfortunately, a few times when you can not. But otherwise use them. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C

RE: STILL NEEDING HELP HERE Re: Login page dropping www and not allowing to enter area

2005-09-19 Thread Damien McKenna
VirtualHost 70.96.191.74 DocumentRoot /home/wwwroot/bvesa ServerName bvesa.org ServerAlias www.bvesa.org ServerAlias ftp.bvesa.org This is the problem. Apache considers ServerName to be the primary hostname for a site and changes all other alias hostnames to it when

Cfadmin API

2005-09-19 Thread Snake
Just wondering if anyone has done much with the Admin API and has documented it better than Macromedia have. It seems to be total guesswork to figure out the methods and what values should be passed to them. Russ ~| Discover

Re: International email address causing an issue.

2005-09-19 Thread Paul Hastings
Rey Bango wrote: Thanks for the heads up Paul. Its CFMX 6.1 Standard. Does that change anything in terms of what I should be looking for? if you upgraded over 6.0 i'd hunt for that jar first, then fiddle w/the JDK. run that charset CFC to verify the JDK supports big5, etc.

Nested side by side table

2005-09-19 Thread Lee
I have something like the following. tabletrtd Left table with a couple of dynamic rows /tdtd Right table with 25 or so dynamic rows /td/tr/table When the left table only has a few rows and the right has many rows, how do I get the left table to display at the top? It is currently ending up in

Re: Nested side by side table

2005-09-19 Thread Stephen Moretti
Lee wrote: I have something like the following. tabletrtd Left table with a couple of dynamic rows /tdtd Right table with 25 or so dynamic rows /td/tr/table When the left table only has a few rows and the right has many rows, how do I get the left table to display at the top? It is currently

Re: Cfadmin API

2005-09-19 Thread Michael Dinowitz
Sarge mentioned that the CFWACK 7 advanced book has better docs. Not a lot, but better. Just wondering if anyone has done much with the Admin API and has documented it better than Macromedia have. It seems to be total guesswork to figure out the methods and what values should be passed to them.

RE: Nested side by side table

2005-09-19 Thread Ian Skinner
tabletrtd valign=top Left table with a couple of dynamic rows /tdtd valign=top Right table with 25 or so dynamic rows /td/tr/table Or the slightly less code table tr valign=top td Left table with a couple of dynamic rows /td td Right table with 25 or so dynamic rows

Re: using an xml file for cfc settingsray style

2005-09-19 Thread Will Tomlinson
(So, if we had a cfc that needed username, dsn, etc, we'd require that it be passed into an init function - the cfc doesn't know that the application scope exists.) Make sense? Yes this makes good sense, but I think what would help most is if you could show us some *REALLY* basic example

Treo and CFLocation?

2005-09-19 Thread Kenton Gray
Does anyone have any idea why the Blazer web browser on the Treo 650 would say unknown redirect format to any cflocation tag? I figure I can get around this by using the old style meta tags, but just find it a bit odd. Kenton

RE: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread Mark Fuqua
I hate to sound as ignorant as I am, but I don't use cfqueryparam. Where should I use it and why. Is it just for selects? Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 2:56 PM To: CF-Talk Subject: RE: CreateOdbcDate(column - not

RE: Treo and CFLocation?

2005-09-19 Thread Dawson, Michael
Maybe it can't handle the temporary redirect that is issued by the cflocation tag. There is a Blazer reference guide out there somewhere. You might check it for a better answer. (I still have a Treo 300 and there was a guide for that version of Blazer. I only assume they updated it for the

RE: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread Dawson, Michael
You should strive to use cfqueryparam *anywhere* you currently use a CF variable in any SQL statement, not just a select statement. I add the disclaimer in that I don't use cfqueryparam for values that are created in my CF pages. I use them anywhere I accept user-supplied values. * They reduce

RE: CreateOdbcDate(column - not variable) within a CFQuery

2005-09-19 Thread Ian Skinner
I hate to sound as ignorant as I am, but I don't use cfqueryparam. Where should I use it and why. Is it just for selects? Mark You should use cfqueryparam in any SQL statement that uses dynamic, especially user provided values, for security and performance. It is not just for selects but

Re: using an xml file for cfc settingsray style

2005-09-19 Thread Raymond Camden
I won't say this is best by any means - however, what I like to do lately (and you may not see this in Galleon, or BlogCFC), is simply pass a struct to all my CFCs. The struct contains all my settings. So my init functions in the CFCs will take one arg, a structure. That data is copied to the

Re: Cfadmin API

2005-09-19 Thread Andy Allan
Instantiate whatever Admin CFC you're interested in and run it through getMetaData() ... it'll tell you everything you need to know. Andy On 19/09/05, Snake [EMAIL PROTECTED] wrote: Just wondering if anyone has done much with the Admin API and has documented it better than Macromedia have. It

RE: Nested side by side table

2005-09-19 Thread Bobby Hartsfield
td valign=top ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 3:45 PM To: CF-Talk Subject: Nested side by side table I have something like the following. tabletrtd Left

Re: Treo and CFLocation?

2005-09-19 Thread Kenton Gray
I checked around for a blazer reference with no avail, but maybe my googling skills aren't up to it. I also tried a meta refresh tag and it tried to download the cfm file. Is there any way to do a redirect to a page in a friendly manner that should be supported on all platforms? Somehow I

Re: using an xml file for cfc settingsray style

2005-09-19 Thread Will Tomlinson
a! Now we're gettin' somewhere! I was just thinking about doing it like this because I'm looping through and creating separate app variables with the settings' values. But if I build a settings struct that can be passed into the cfc, it would be mucho better. The problem I have

OT: Mail server

2005-09-19 Thread Cedric Villat
What do you guys recommend as a good Windows-based mail server? Preferably open-source, but paid solution will work too. I checked on sourceforge, but really didn't have much luck finding a Windows server. I just need a basic mail server, that allows for multiple users and webmail, at a

Re: OT: Mail server

2005-09-19 Thread Alan Rother
Smartermail. http://www.smartertools.com/Products/SmarterMail/Default.aspx It's not free, but it is pretty cheap and it works really well. On 9/19/05, Cedric Villat [EMAIL PROTECTED] wrote: What do you guys recommend as a good Windows-based mail server? Preferably open-source, but paid

RE: Treo and CFLocation?

2005-09-19 Thread Dawson, Michael
I googled and could not find anything for the 650 either. You might try using CF's server-side redirect. I forget the actual term but I think it's something like getPageContext().forward(url). If you keep it server-side, it may work. Also, have you tried a CFINCLUDE rather than a CFLOCATION?

looping over the fields of a one record query

2005-09-19 Thread Mark Fuqua
I have a query that returns one record with 30 fields. I would like to loop over all the fields and set session variables. Is there an easy way to do this? Mark ~| Discover CFTicket - The leading ColdFusion Help Desk and

RE: looping over the fields of a one record query

2005-09-19 Thread Dawson, Michael
CFLOOP over queryName.columnList. columnList contains every column name that was returned from the query. M!ke -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 6:55 PM To: CF-Talk Subject: looping over the fields of a one record query I

RE: looping over the fields of a one record query

2005-09-19 Thread Mark Fuqua
I am a little green, do you mean like so... cfloop index=listelement list=#areaJobInfo.columnList# cfset session.#areaJobInfo.columnList# = #listElement# /cfloop That doesn't seem like it would work. What am I missing. Thanks, Mark -Original Message- From: Dawson, Michael

RE: looping over the fields of a one record query

2005-09-19 Thread Dawson, Michael
Close, but try this. (It assumes there is only one record returned from the query.) You can treat the query, and session scope, as structures. The query is also treated as an array to get the first element. cfloop index=thisOne list=#areaJobInfo.columnList# cfset session[thisOne] =

Re: looping over the fields of a one record query

2005-09-19 Thread Will Tomlinson
Just tested this and it looks like what you want. cfquery name=getallprods datasource=test SELECT prodID, prod_MerchID, prodname, prodshortdescription FROM tblproducts /cfquery cfloop list=getallprods.columnlist index=thiscolumn cfset SESSION[thiscolumn] = thiscolumn /cfloop cfdump

RE: OT: Mail server

2005-09-19 Thread Russ
Personally, I kind of dislike smartermail... granted I'm not using the latest version, but we've switched over from smartermail to sendmail (on linux). There are just too many issues in the implementation of Sendmail. For one thing, the administrator can go and view everyone's passwords. Not

RE: looping over the fields of a one record query

2005-09-19 Thread Mark Fuqua
Worked like a charm. Why [thisone][1]? What does the [1] do? It seems like it would be cfset session[thisOne] = areaJobInfo[thisOne] Also, how does cf know the variable name and value? Thanks for the lesson, Mark -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED]

Treo Blazer: Random characters with CFM - WAS: Treo and CFLocation?

2005-09-19 Thread Kenton Gray
I worked through the redirect issue, thanks for your help Michael. However I've stumbled upon a new issue which I think is caused by IIS? I'm getting weird characters at the beginning of any page with a .cfm extension. Usually something like 2b, but I can refresh the page and it changes. The

Re: OT: Mail server

2005-09-19 Thread Cedric Villat
I'm using Windows, because it's the only machine I have here to play with :) Cedric Personally, I kind of dislike smartermail... granted I'm not using the latest version, but we've switched over from smartermail to sendmail (on linux). There are just too many issues in the implementation of

RE: using an xml file for cfc settingsray style

2005-09-19 Thread Andy
Brian, I've done that as well, but don't see the benefit of the overhead of the call to config versus loading once as application or session variables. Andy -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 9:11 AM To: CF-Talk Subject: Re:

Win 2003

2005-09-19 Thread Parker, Kevin
Can any one advise quickly if CF 5 and CF MX 6 will run on Win 2003 Server TIA ++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++

ListQualify problem

2005-09-19 Thread sp
I am having difficulties outputting a ListQualify in a query. Here is the query cfset TodayDate = DateFormat(Now(), mm/dd/) !--- get the groupid of movement classes --- cfquery name=GroupOne datasource=#dsn# SELECT Distinct(GroupID), EventName FROM Calendar WHERE EventType = 'Movement

RE: ListQualify problem

2005-09-19 Thread Mike Nicholls
The PreserveSingleQuotes function stops ColdFusion from automatically escaping the apostrophes for you. Try this: cfquery name=MovementClasses datasource=#dsn# SELECT MIN(CalendarDate) as MinDate, MAX(CalendarDate) as MaxDate, EventName, GroupID FROM Calendar WHERE GroupID IN

Re: ListQualify problem

2005-09-19 Thread HOFLee _
BUT when i put the MovementList in the following query I get the following error. For some reason the list becomes qualified with double quotes. Here is the error CF automatically escapes single quotes (ie. converts one single quote to two). Either use the PreserveSingleQuotes() function

Re: Win 2003

2005-09-19 Thread HOFLee _
Can any one advise quickly if CF 5 and CF MX 6 will run on Win 2003 Server Did you see this technote? http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18689 ~| Logware (www.logware.us): a new and convenient

Re: Win 2003

2005-09-19 Thread Kym Kovan
Parker, Kevin wrote: Can any one advise quickly if CF 5 and CF MX 6 will run on Win 2003 Server yes and yes but CF5 does not recognise IIS6 so you have to put the IIS mappings in manually. HTH, Kym K ~| Logware

Re: ListQualify problem

2005-09-19 Thread sp
The PreserveSingleQuotes function stops ColdFusion from automatically escaping the apostrophes for you. Try this: cfquery name=MovementClasses datasource=#dsn# SELECT MIN(CalendarDate) as MinDate, MAX(CalendarDate) as MaxDate, EventName, GroupID FROM Calendar WHERE GroupID IN

Re: Win 2003

2005-09-19 Thread Roger Benningfield
Can any one advise quickly if CF 5 and CF MX 6 will run on Win 2003 Server Kevin: MX definitely does. Someone with CF5/Win2k3 experience will have to speak to that particular combo. -- Roger Benningfield JournURL http://admin.support.journurl.com/ http://admin.mxblogspace.journurl.com/

Re: ListQualify problem

2005-09-19 Thread Marlon Moyer
You could simplify it by doing this: cfquery name=MovementClasses datasource=#dsn# SELECT MIN(CalendarDate) as MinDate, MAX(CalendarDate) as MaxDate, EventName, GroupID FROM Calendar WHERE GroupID IN ( cfqueryparam cfsqltype=cf_sql_varchar value=#ValueList(GroupOne.GroupID,',')# list=true/ )