Case Sensitive QofQ and Operators

2013-04-09 Thread Brian Thornton
/WSc3ff6d0ea77859461172e0811cbec0e4fd-7ff0.html ) Unlike the rest of ColdFusion, Query of Queries is case-sensitive. However, Query of Queries supports two string functions, UPPER() and LOWER(), which you can use to achieve case-insensitive matching. The cf error using UPPER is Invalid Operator upper SQL

Re: Case Sensitive QofQ and Operators

2013-04-09 Thread Captain Obvious
is case-sensitive. However, Query of Queries supports two string functions, UPPER() and LOWER(), which you can use to achieve case-insensitive matching. The cf error using UPPER is Invalid Operator upper SQL = select * from this table where upper(columnname) = ' -- Brian Thornton (260) 267

Re: CFCOOKIE mystery -- mixed case cookies returning as lowercase?

2012-12-06 Thread Tony Green
Yes, my tracing code shows the client hitting the cookie set page, and having the cookie set with all caps.Then on the next page the entire CGI.HTTP_COOKIE is being seen by the server as being lower case. HTTP_COOKIE: cfid=296838408; cftoken=af55396400; thecookie=abcdefg Note

Re: CFCOOKIE mystery -- mixed case cookies returning as lowercase?

2012-12-06 Thread Byron Mann
If code and the environment hasn't changed, then it would maybe point to the client side of things. Any commonlaity to browsers? Maybe a particular recent release of a browser has a bug that is causing this. ~| Order the Adobe

CFCOOKIE mystery -- mixed case cookies returning as lowercase?

2012-12-05 Thread Tony Green
Hi CFTALK - I have a really weird mystery that Im trying to solve.I have an app that has run fine for about 5 years. All of a sudden, about a week ago, I'm starting to get cookies created by my own CFCOOKIE returning from random clients all in lower case. For example. Template A sets

Re: CFCOOKIE mystery -- mixed case cookies returning as lowercase?

2012-12-05 Thread Byron Mann
in lower case. For example. Template A sets: cfcookie name=mycookie value=AbCdEfG expires= domain=. mydomain.com They then visit template B which returns: CFDUMP OF COOKIE SCOPE: mycookieabcdefg For some reason, while I'm setting AbCdEfG, when I read it back I'm getting

RE: Case statement inside cached query

2012-11-08 Thread Nathan Chen
Matt, sorry I wasn't clear. I got a query of queries syntax error like this: Query Of Queries syntax error. Encountered sum ( case. Incorrect Select List, Nathan -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Wednesday, November 07, 2012 4:27 PM To: cf

Re: Case statement inside cached query

2012-11-08 Thread Matt Quackenbush
Database-specific functions do not work in a Query of Queries. On Thu, Nov 8, 2012 at 10:07 AM, Nathan Chen nathan.c...@cu.edu wrote: Matt, sorry I wasn't clear. I got a query of queries syntax error like this: Query Of Queries syntax error. Encountered sum ( case. Incorrect Select List

Re: Case statement inside cached query

2012-11-08 Thread Carl Von Stetten
I don't think the CASE function is supported in Query-of-Query statements. -Carl V. On 11/8/2012 8:07 AM, Nathan Chen wrote: Matt, sorry I wasn't clear. I got a query of queries syntax error like this: Query Of Queries syntax error. Encountered sum ( case. Incorrect Select List, Nathan

Re: Case statement inside cached query

2012-11-08 Thread Russ Michaels
. Or simply run your query directly against the database instead of using QofQ On Thu, Nov 8, 2012 at 4:07 PM, Nathan Chen nathan.c...@cu.edu wrote: Matt, sorry I wasn't clear. I got a query of queries syntax error like this: Query Of Queries syntax error. Encountered sum ( case. Incorrect Select

Case statement inside cached query

2012-11-07 Thread Nathan Chen
All: Do cached queries allow SQL case statement at all or is there a way to get around it? I am trying to put this inside a cached query such as : Sum( case when A = 'B' then C else 0 end) as D ( C is numeric field). It wouldn't work. I am on CF 8 and Oracle 11g. Thanks. Nathan Chen

Re: Case statement inside cached query

2012-11-07 Thread Matt Quackenbush
What does wouldn't work mean? Get results you didn't expect? If yes, what did you get and what did you expect? Get an exception? If yes, where's the stack trace? On Wed, Nov 7, 2012 at 5:22 PM, Nathan Chen nathan.c...@cu.edu wrote: All: Do cached queries allow SQL case statement at all

Re: CF10 Tomcat case sensitivity

2012-06-01 Thread Byron Mann
Believe, it was specifically jsp code that was at risk. IMHO and based off of experience, all lower case in the URI is the way to go. Fully realizing this is a matter of personal preferance, but It just makes all your linking and such easier and more consistent when it comes to things like SEO

CF10 Tomcat case sensitivity

2012-05-31 Thread Chad Baloga
Does anyone know how to turn off the file case sensitivity on CF10/Tomcat? That is the first thing I noticed today after installing some of my images which has different cases did not show up. EX: It is saying that Image.jpg is not the same as image.jpg, and a red X appears

Re: CF10 Tomcat case sensitivity

2012-05-31 Thread Chad Baloga
Found out how.. look for context.xml under {drive}\ColdFusion10\cfusion\runtime\conf Change the context tag to look like: Context AllowLinking=true caseSensitive=true Restart the CF service ~| Order the Adobe Coldfusion

Re: CF10 Tomcat case sensitivity

2012-05-31 Thread Nathan Strutz
Baloga cbal...@gmail.com wrote: Does anyone know how to turn off the file case sensitivity on CF10/Tomcat? That is the first thing I noticed today after installing some of my images which has different cases did not show up. EX: It is saying that Image.jpg is not the same as image.jpg, and a red

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-19 Thread Kris Jones
Hi Dave, That's what I'm saying -- I'm normalizing the case -- I'm explicitly setting the image name to lcase(imagepathname) in the cfimage tag. If however -- and this was definitely an edge case happening in testing -- there is an image already at that path with the same name except for case

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-19 Thread Dave Watts
That's what I'm saying -- I'm normalizing the case -- I'm explicitly setting the image name to lcase(imagepathname) in the cfimage tag. If however -- and this was definitely an edge case happening in testing -- there is an image already at that path with the same name except for case, cfimage

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-18 Thread Kris Jones
The issue was not whether the overwrite was happening -- it definitely was -- the new image was written. There was no ftp involved -- this was all cffile from a form post. What I noted was that the original file -- the one being overwritten (with the same name, but different case), did not use

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-18 Thread Dave Watts
The issue was not whether the overwrite was happening -- it definitely was -- the new image was written. There was no ftp involved -- this was all cffile from a form post. What I noted was that the original file -- the one being overwritten (with the same name, but different case), did

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Kris Jones
on overwrite. Should this be the expected behavior? Just curious what others think. Cheers, Kris Wondering if anyone has run into this with CFImage under CF9. I'm writing a file on my local developer version 9.0. I am explicitly writing the filename as lower-case doing a resize operation

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Matt Quackenbush
I would file a bug report. 'Overwrite' should always overwrite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

RE: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Rick Faircloth
To: cf-talk Subject: Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01 Figured out what the issue was here (was not related to difference in version). There was a file with the same name (but uppercase) already in the directory. The code specified to overwrite on name conflict

RE: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Robert Harrison
It's possible the file you were trying to overwrite had a file lock left on it from some other program that opened it (for example, an FTP session). Nothing will overwrite a locked file. I've seen it happen on Windows machines now and again. Robert B. Harrison Director of Interactive

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Matt Quackenbush
Oh. Yeah. What he said. :-) On Mon, Jan 17, 2011 at 2:30 PM, Robert Harrison wrote: It's possible the file you were trying to overwrite had a file lock left on it from some other program that opened it (for example, an FTP session). Nothing will overwrite a locked file. I've seen it

RE: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Andrew Scott
I don't think he said it was not written, if I read it right he said it was written but in upper case. This is where I will point out that ColdFusion leverages of Java libraries here, and as it is case sensitive one has to convert to a specific case to do a comparison to begin with and Adobe

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Dave Watts
I would file a bug report.  'Overwrite' should always overwrite. But that's exactly what it's doing. It's overwriting the file. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Matt Quackenbush
said that the file was being renamed, as opposed to overwritten. You are stating that it is indeed being overwritten. I'm not sure which the case is, but as Robert pointed out, it might be a file lock issue. shrug ~| Order

Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-17 Thread Dave Watts
One of us apparently misunderstood the OP's issue.  :-)  I thought he said that the file was being renamed, as opposed to overwritten.  You are stating that it is indeed being overwritten.  I'm not sure which the case is, but as Robert pointed out, it might be a file lock issue.  shrug

CFIMAGE - case sensitivity on filename - CF9 vs CF9.01

2011-01-16 Thread Kris Jones
Hi all, Wondering if anyone has run into this with CFImage under CF9. I'm writing a file on my local developer version 9.0. I am explicitly writing the filename as lower-case doing a resize operation. In development environment, enterprise version 9.0.1, the file is always written

issues preserving the case of the key

2010-07-01 Thread Glyn Jackson
Hi Having more issues with a JSON request. the page calling the service is case sensitive, this was solved using the bracket structure syntax: i.e. response['hotspots'] = []; to preserve the case of the key. however I have an array I have tried added the array different ways to the struct

RE: issues preserving the case of the key

2010-07-01 Thread andy matthews
less if the variables are uppercase, lowercase, or some mixture. andy -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Thursday, July 01, 2010 5:11 AM To: cf-talk Subject: issues preserving the case of the key Hi Having more issues with a JSON request

Re: issues preserving the case of the key

2010-07-01 Thread Glyn Jackson
does not matter about this now this seems to work... obj['actions']= []; arrayAppend(obj.actions, 'some value'); ~| Order the Adobe Coldfusion Anthology now!

Cfgid in cf9 sorting case sensitive

2010-02-12 Thread Frederick Valone
All my html cfgrids are sorting case sensitive. I added the type=string_noCase parameter but still am getting the same results with strings starting with uppercase chars displaying first and lower case strings displayed alphabetically after the uppercase strings. Thanks

Re: ARGUMENT scope case

2009-11-26 Thread Matt Quackenbush
case? something[ThisThenLooksLikeThis] vs something.THISTHENLOOKSLIKETHIS I could be mixed up tho. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists

Re: ARGUMENT scope case

2009-11-26 Thread Dominic Watson
Kevan Stannard ke...@stannard.net.au The struct key name case should be retained with the following syntax: cfset retStruct[success] = 1 2009/11/26 Bryan Stevenson br...@electricedgesystems.com Hey All, I just bumped into an interesting/annoying potential difference between

Re: ARGUMENT scope case

2009-11-26 Thread Bryan Stevenson
...and Dominic wins the prize!! Thanks all for the info. Dominic's collection loop solves the CF variable scope structure key case problem (although a PITA whenn it needs to be done). Of course since posting I have realized that in most cases I do NOT need to return CF variable scopes via AJAX

ARGUMENT scope case

2009-11-25 Thread Bryan Stevenson
Hey All, I just bumped into an interesting/annoying potential difference between Adobe CF 8 and OpenBD. When I run the following code in a CFFUNCTION: !--- define the structure--- cfset var retStruct = StructNew() cfset structInsert(retStruct, success, 1) cfset structInsert(retStruct,

Re: ARGUMENT scope case CORRECTION

2009-11-25 Thread Bryan Stevenson
I said: Adobe CF 8: each ARGUMENT key is uppercase (along with values) should have said: Adobe CF 8: each ARGUMENT key is uppercase (values are lowercase) Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax:

Re: ARGUMENT scope case

2009-11-25 Thread Matt Quackenbush
Love it or hate it, ColdFusion has, for as long as I can remember (v. 3?), UPPERCASED variable names and struct keys. Since this is a known thing, you can work around it by using either Lcase() or Ucase() where appropriate. ~|

Re: ARGUMENT scope case

2009-11-25 Thread denstar
I thought that using the bracket notation would keep case? something[ThisThenLooksLikeThis] vs something.THISTHENLOOKSLIKETHIS I could be mixed up tho. -- If you think in terms of a year, plant a seed; if in terms of ten years, plant trees; if in terms of 100 years, teach the people

Re: ARGUMENT scope case

2009-11-25 Thread Eric Roberts
I may be wrong, but that could be on linux implementations...I don't recall any case sensitivity on Windows. Eric -- From: denstar valliants...@gmail.com Sent: Wednesday, November 25, 2009 9:14 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re

Re: ARGUMENT scope case

2009-11-25 Thread Kevan Stannard
The struct key name case should be retained with the following syntax: cfset retStruct[success] = 1 2009/11/26 Bryan Stevenson br...@electricedgesystems.com Hey All, I just bumped into an interesting/annoying potential difference between Adobe CF 8 and OpenBD. When I run the following

Comparing upper case and lower case

2009-10-23 Thread Phillip Vector
care about case. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327612

Re: Comparing upper case and lower case

2009-10-23 Thread Charlie Griefer
compare() is a case-sensitive comparison of strings. On Fri, Oct 23, 2009 at 1:39 PM, Phillip Vector vec...@mostdeadlygame.comwrote: I got a confusion issue here... session.sRep.PassWord NEQ password session.sRep.Password is 'AAA' (The old password) password is 'aaa' (The new password

Re: Comparing upper case and lower case

2009-10-23 Thread Claude Schneegans
It seems that NEQ or is not doesn't care about case. Exact. Use the Compare () function for case sensitive comparison. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion

Re: Comparing upper case and lower case

2009-10-23 Thread Phillip Vector
Yeah.. Found out after I hit send.. Thanks. :) On Fri, Oct 23, 2009 at 1:44 PM, Charlie Griefer charlie.grie...@gmail.com wrote: compare() is a case-sensitive comparison of strings. On Fri, Oct 23, 2009 at 1:39 PM, Phillip Vector vec...@mostdeadlygame.comwrote: I got a confusion issue

Re: Comparing upper case and lower case

2009-10-23 Thread Eric Cobb
check out the compare() function, it's case sensitive. http://livedocs.adobe.com/coldfusion/8/htmldocs/functions_c-d_06.html#1101820 Thanks, Eric Cobb http://www.cfgears.com Phillip Vector wrote: I got a confusion issue here... session.sRep.PassWord NEQ password session.sRep.Password

Re: Case Sensitive SQL

2009-06-15 Thread Arsalan Tariq Keen
: Peter Boughton bought...@gmail.com Sent: Monday, June 15, 2009 11:02 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Case Sensitive SQL Probably a little over-the-top, but the point still stands. MS Access is fine for basic office use, but for web apps you're better off picking Derby

Re: Case Sensitive SQL

2009-06-15 Thread Jason Fisher
What are the data types of the columns you're trying to GROUP BY? I'm sure it will barf on a memo field, for instance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of

Re: Case Sensitive SQL

2009-06-15 Thread Claude Schneegans
MS Access is fine for basic office use, but for web apps you're better off picking Derby, H2, MySQL, Postgres, etc - or one of the free 'Express' editions of Oracle or MS SQL Server. Legend, pure urban legend ! Access applications have a bad reputation, but do not forget that accessing an

Re: Case Sensitive SQL

2009-06-15 Thread Phillip Vector
On Mon, Jun 15, 2009 at 7:33 AM, Claude Schneegansschneeg...@internetique.com wrote:  MS Access is fine for basic office use, but for web apps you're better off picking Derby, H2, MySQL, Postgres, etc - or one of the free 'Express' editions of Oracle or MS SQL Server. Legend, pure urban

Re: Case Sensitive SQL

2009-06-15 Thread Arsalan Tariq Keen
. The cluster field is Integer. Regards, Arsalan -- From: Phillip Vector vec...@mostdeadlygame.com Sent: Monday, June 15, 2009 8:40 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Case Sensitive SQL On Mon, Jun 15, 2009 at 7:33 AM, Claude

Re: Case Sensitive SQL

2009-06-15 Thread Claude Schneegans
There is very few reasons why you would want a Web App with Access. None of them that I can think of would be useful in a web app that is worked on by 2 or more people (which most web apps are). 1. Access is not sensitive to SQL injection. 2. Only one file for the whole database, the whole

Re: Case Sensitive SQL

2009-06-15 Thread Claude Schneegans
now if I add 'GROUP BY clust' then it gives an error. Where do yo add the GROUP BY clause ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: Case Sensitive SQL

2009-06-15 Thread Arsalan Tariq Keen
: Monday, June 15, 2009 9:10 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Case Sensitive SQL now if I add 'GROUP BY clust' then it gives an error. Where do yo add the GROUP BY clause ? ~| Want to reach

Re: Case Sensitive SQL

2009-06-15 Thread Claude Schneegans
now if I add 'GROUP BY clust' then it gives an error. In a GROUP BY clause, you must enumerate all fields in your SELECT See : http://msdn.microsoft.com/en-us/library/aa259187(SQL.80).aspx#_group_by_clause ~| Want to reach

Re: Case Sensitive SQL

2009-06-15 Thread Jochem van Dieten
On Mon, Jun 15, 2009 at 4:56 PM, Arsalan Tariq Keen wrote: cfquery name=sites_data datasource=data        SELECT id, site, far_end, site_type, phase, lat, long, cluster AS clust, city, region, sites_status        FROM sites        ORDER BY region /cfquery now if I add 'GROUP BY clust'

Re: Case Sensitive SQL

2009-06-15 Thread Jason Fisher
From: Jochem van Dieten joch...@gmail.com Sent: Monday, June 15, 2009 12:15 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Case Sensitive SQL On Mon, Jun 15, 2009 at 4:56 PM, Arsalan Tariq Keen wrote: � � � �SELECT id, site, far_end

Re: Case Sensitive SQL

2009-06-15 Thread Arsalan Tariq Keen
data management project :)) (That is why it has to be so mismanaged ;)... lolz!) -- From: Jason Fisher ja...@wanax.com Sent: Monday, June 15, 2009 11:08 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Case Sensitive SQL Right, include all

Re: Case Sensitive SQL

2009-06-15 Thread Jason Fisher
Okay, that makes sense, but I'm thinking that you won't be able to do the grouping at the SQL level in that case. As Jochem noted, GROUP BY can only put records together where all the grouped fields match, and the assumption is that all other columns are summarized or otherwise aggregated

Re: Case Sensitive SQL

2009-06-15 Thread Claude Schneegans
ID and SITE will always have unique values no duplicates allowed. Ok, but you still have to list all columns in your SELECT list, it is a matter of SQL syntax, not logic. In pure logic, a GROUP clause should be enough, since one has no choice, but this is the way SQL has been designed.

RE: Case Sensitive SQL

2009-06-15 Thread Bobby Hartsfield
Lol you said MS Access and GREAT in the same sentence. .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Claude Schneegans [mailto:schneeg...@internetique.com] Sent: Saturday, June 13, 2009 1:15 PM To: cf-talk Subject: Re: Case

Re: Case Sensitive SQL

2009-06-14 Thread Peter Boughton
Probably a little over-the-top, but the point still stands. MS Access is fine for basic office use, but for web apps you're better off picking Derby, H2, MySQL, Postgres, etc - or one of the free 'Express' editions of Oracle or MS SQL Server. More importantly though, I just noticed this is

Case Sensitive SQL

2009-06-13 Thread Arsalan Tariq Keen
Dear Experts, I am an amateur with CF and have restarted using CF after quite a long break. I am having trouble with a query in which I am comparing password entered in a form field to that stored in my MS Access DB. The problem is that the comparison is case-insensitive. How can I make

Re: Case Sensitive SQL

2009-06-13 Thread Peter Boughton
Microsoft Access is terrible. I recommend switching to *any* other database engine. You should then be able to use the COLLATE SQL command to enforce case-sensitivity on a column. ~| Want to reach the ColdFusion community

Re: Case Sensitive SQL

2009-06-13 Thread Shane Larrabee
the COMPARE function should do the trick for you. http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt138.htm http://www.scandicweb.com/coldfusion/tutorials/tutorial90.cfm ~| Want to reach the ColdFusion

Re: Case Sensitive SQL

2009-06-13 Thread Claude Schneegans
Microsoft Access is terrible. Well, yet another legendary Access database bashing :-( Access database are GREAT for any small/medium web application. Most databases implement the string comparison to be case insensitive by default. They also have provisions to change it either globally

Re: Case Sensitive SQL

2009-06-13 Thread Claude Schneegans
the COMPARE function should do the trick for you. The COMPARE function is a CF function. What is needed here is an SQL function. ~| Want to reach the ColdFusion community with something they want? Let them know on the House

Re: Case Sensitive SQL

2009-06-13 Thread Roger Austin
Claude Schneegans wrote: Microsoft Access is terrible. Well, yet another legendary Access database bashing :-( Access database are GREAT for any small/medium web application. Most databases implement the string comparison to be case insensitive by default. They also have provisions

Case of Table Names in Queries (MySQL / Linux / CFMX7)

2009-06-08 Thread Chris Montgomery
I moved a site from one linux server to another linux server over the weekend. The CF server is MX7. The database for this site is MySQL 5.x and was replicated from the old server to the new server. All database table names are lower case. When running a cfquery on the site after the move, I

SQL CASE STATEMENTS

2009-01-19 Thread Torrent Girl
Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http

Re: SQL CASE STATEMENTS

2009-01-19 Thread John M Bliss
...@gmail.com wrote: Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http

Re: SQL CASE STATEMENTS

2009-01-19 Thread Brian Kotek
If you mean SQL case statements, no. On Mon, Jan 19, 2009 at 9:19 AM, Torrent Girl torrentg...@gmail.com wrote: Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

RE: SQL CASE STATEMENTS

2009-01-19 Thread Andy Matthews
I don't believe you can use T-SQL case statements in a QofQ. -Original Message- From: Torrent Girl [mailto:torrentg...@gmail.com] Sent: Monday, January 19, 2009 8:19 AM To: cf-talk Subject: SQL CASE STATEMENTS Can I use case statements within a QoQ

Re: SQL CASE STATEMENTS

2009-01-19 Thread Barney Boisvert
CASE is part of core SQL, not an MS extension in T-SQL. But not supported by QofQ either way. Write to your local Adobe rep today!! cheers, barneyb On 1/19/09, Andy Matthews li...@commadelimited.com wrote: I don't believe you can use T-SQL case statements in a QofQ. -Original Message

Re: Case Sensitive Form Field Names

2008-06-16 Thread Sonny Savage
I just wanted to chime in with a related issue with CF and struct nodes. I was writing an AJAX form handler that used JSON when I discovered that case was not preserved when using dot notation on struct elements. The solution is to use quoted node names like this: structName[caseSensitiveNode

Re: Case Sensitive Form Field Names

2008-06-16 Thread Sonny Savage
I just realized that my example wasn't very clear. Hope this is a little better: cfset structName = structNew() cfset structName[caseSensitiveNode] = Node name will retain case cfset structName.caseInsensitiveNode = Node name will be all uppercase ul cfloop collection=structName item=nodeName

RE: Case Sensitive Form Field Names

2008-06-16 Thread Brad Wood
Man, you're killing all kinds of birds with that stone! :) ~Brad -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, June 15, 2008 4:23 PM To: CF-Talk Subject: RE: Case Sensitive Form Field Names Probably a lost cause but does anyone know of any method(s

RE: Case Sensitive Form Field Names

2008-06-16 Thread Dave Watts
Man, you're killing all kinds of birds with that stone! :) If you're working with any web application development language, it always is very handy to know how to access raw HTTP request data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest

RE: Case Sensitive Form Field Names

2008-06-15 Thread Dave Watts
Probably a lost cause but does anyone know of any method(s) to preserve the case of form field names through a POST? I know you already got a useful answer, but you can probably do this using the CF function GetHttpRequestData. Dave Watts, CTO, Fig Leaf Software

Re: Case Sensitive Form Field Names

2008-06-15 Thread Barney Boisvert
, Dave Watts [EMAIL PROTECTED] wrote: Probably a lost cause but does anyone know of any method(s) to preserve the case of form field names through a POST? I know you already got a useful answer, but you can probably do this using the CF function GetHttpRequestData. Dave Watts, CTO, Fig Leaf

Case Sensitive Form Field Names

2008-06-14 Thread Bobby Hartsfield
Probably a lost cause but does anyone know of any method(s) to preserve the case of form field names through a POST? I'm submitting a form to capture the input and generate some XML to pass to a remote web service. The form field names correspond with the required XML node names since the plan

Re: Case Sensitive Form Field Names

2008-06-14 Thread Barney Boisvert
You can use the HttpServletRequest object (getPageContext().getRequest()) to pull an enumeration of case-sensitive parameter names. cheers, barneyb On Sat, Jun 14, 2008 at 9:13 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: Probably a lost cause but does anyone know of any method(s) to preserve

RE: Case Sensitive Form Field Names

2008-06-14 Thread Bobby Hartsfield
Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Saturday, June 14, 2008 12:46 PM To: CF-Talk Subject: Re: Case Sensitive Form Field Names You can use the HttpServletRequest object (getPageContext().getRequest()) to pull an enumeration of case-sensitive parameter names. cheers

RE: Case Sensitive Form Field Names

2008-06-14 Thread Mark Kruger
To: CF-Talk Subject: RE: Case Sensitive Form Field Names Barney to the rescue again! Thanks man, works like a champ. For the sake of the archives, here is a working example: cfif cgi.request_method is post cfset paramNames = getPageContext().getRequest().getHttpRequest

TOT, but very cool...geek alert...mineral oil cooled case using fishtank

2008-06-09 Thread Eric Roberts
http://www.youtube.com/watch?v=ZOgptvjwng8 This is too cool...especially since I used to do a lot of overclocking...thought I would share... Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release

RE: TOT, but very cool...geek alert...mineral oil cooled case using fishtank

2008-06-09 Thread Mark Kruger
:11 AM To: CF-Talk Subject: TOT, but very cool...geek alert...mineral oil cooled case using fishtank http://www.youtube.com/watch?v=ZOgptvjwng8 This is too cool...especially since I used to do a lot of overclocking...thought I would share... Eric

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Richard White
thanks steve we will give this a go then if you are funding it useful thanks again richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Richard White
Since UML is a software-independent specification for modeling components, I would be surprised if you found one geared specifically to ColdFusion or Flex. hi steve sorry i should have been more specific what i mean by this is code generation... i was wondering whether there was a uml tool

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Larry Lyons
At work I use Magic Draw, along with the Team Server. Its very good, very powerful, but too powerful for a lot of my development work. But it has some very nice round trip features if you're moving back and forth between your diagrams and test code. Recently I used it to help me reverse

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Larry Lyons
I think I mentioned this previously but have you looked at CFC Stub Generator? http://cfcstub.riaforge.org/ From the web site: -- Code generator that takes a simple text file and generates CFC stubs, unit tests (either CFUnit or CFCUnit), mock objects, ColdSpring.xml, ANT unit test build

Re: open source ColdFusion UML CASE tool

2008-03-20 Thread Richard White
ArgoUML or Poseidon are two. there are quite a few, just do a google search on it. hi, thanks we have done a Google search in the pass which led to us using argouml. it needs alot of improvement before it can be of any serious use. so what we are after is not google search results but

RE: open source ColdFusion UML CASE tool

2008-03-20 Thread Steve Brownlee
functionality for advanced users. -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 1:05 PM To: CF-Talk Subject: Re: open source ColdFusion UML CASE tool ArgoUML or Poseidon are two. there are quite a few, just do a google search on it. hi, thanks we

Re: Voodoo programming case one

2008-03-20 Thread s. isaac dealey
Thanks. You're right, using class is a standard approach, however, the new CFWINDOW tag is nice but quite picky and I have more than one cfwindow on the same page, so, inline js tends to work better for my case... Shouldn't matter in this case because you're changing the class

Re: Voodoo programming case one

2008-03-20 Thread s. isaac dealey
Thanks. You're right, using class is a standard approach, however, the new CFWINDOW tag is nice but quite picky and I have more than one cfwindow on the same page, so, inline js tends to work better for my case... Shouldn't matter in this case because you're changing the class of the parent

Voodoo programming case one

2008-03-19 Thread Don L
Hi, I got this a table with multiple rows, one column contained lengthy data, so, it is assigned td width=40%. Now, I want to give users the flexibility to temporarily close a column or two by a simple click (very trival js to implement) but I'd like all the TDs for this BIG column to expand

Re: Voodoo programming case one

2008-03-19 Thread s. isaac dealey
imo put a class on each of the td cells in that column and a separate class or id on the table - when they hit the button to expand/collapse the other column, change the class name(s) of the parent table, i.e. style type=text/css #mytable td.bigtd { width: 40%; } #mytable.more td.bigtd {

Re: Voodoo programming case one

2008-03-19 Thread Don L
Thanks. You're right, using class is a standard approach, however, the new CFWINDOW tag is nice but quite picky and I have more than one cfwindow on the same page, so, inline js tends to work better for my case... Since we're at it, I was wondering if there are other techniques to achieve

RE: Voodoo programming case one

2008-03-19 Thread Jim Davis
-Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 7:38 PM To: CF-Talk Subject: Re: Voodoo programming case one Thanks. You're right, using class is a standard approach, however, the new CFWINDOW tag is nice but quite picky and I have more

  1   2   3   4   5   6   7   >