: Friday, April 18, 2008 4:05 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] QoQ question
This will be a process where the client will upload the SS weekly to the
site and may use a different file name. Yes I am allowing for a LOT of
latitude on their part but this will work if I can
Of Scott
Councill
Sent: Thursday, April 17, 2008 4:25 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] QoQ question
I am writing a query of query where the result set in the original
query has spaces in the field names. I know when you are querying a
database, you use [Field Name
Discuss] QoQ question
I am writing a query of query where the result
set in the original query
has spaces in the field names. I know when you
are querying a database, you
use [Field Name] as the syntax but CF is throwing
an error when I do this
with the QoQ. Any ideas how I can call
How would Trim() remove an embedded space?
- Original Message
From: McTure, Greg [EMAIL PROTECTED]
To: discussion@acfug.org
Sent: Friday, April 18, 2008 8:54:51 AM
Subject: RE: [ACFUG Discuss] QoQ question
!--a:link
{}
span.MSOHYPERLINK
{}
a:visited
Also, Trim() will operate on the content of the column, not the column name
itself.
-Cameron
2008/4/18 shawn gorrell [EMAIL PROTECTED]:
How would Trim() remove an embedded space?
--
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell: 678.637.5072
aim: cameroncf
email:
] [mailto:[EMAIL PROTECTED] On Behalf Of shawn gorrell
Sent: Friday, April 18, 2008 9:07 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] QoQ question
How would Trim() remove an embedded space?
- Original Message
From: McTure, Greg [EMAIL PROTECTED]
To: discussion@acfug.org
Sent
To be fair, QoQ solves an entirely different problem than Stored Procs. QoQ
was also not designed to be an entire DB server, and hopefully never will
be.
QoQ is quirky as hell, yes, but for the newbies out there on the list it
would be wrong (IMHO) to make a blanket recommendation about using
' )
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of shawn gorrell
Sent: Friday, April 18, 2008 9:07 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] QoQ question
How would Trim() remove an embedded space?
- Original Message
@acfug.org
Subject: RE: [ACFUG Discuss] QoQ question
Hi Scott:
Couldn't you use a TRIM function in the original query to eliminate the
spaces?
In SQL Server, it would actually be something like: SELECT
RTRIM(LTRIM(col_with_spaces)) FROM TABLE.
From
would offer that.
Dusty
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill
Sent: 04/17/2008 4:25 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] QoQ question
I am writing a query of query where the result set in the original query
has spaces
Spunlogic's Blog for a
look inside the minds of a leading interactive agency.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron
Childress
Sent: Friday, April 18, 2008 9:19 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] QoQ question
To be fair, QoQ solves an entirely
Scott,
Have you thought about using the POI stuff to read the Excel sheet? There's
a lot of info on a CFC implementation at
http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm.
True, that info then comes in as a struct but you could loop over
Subject: RE: [ACFUG Discuss] QoQ question
Thanks to all for comments. I should have been more detailed. Yes, spaces in
field names is very bad. I am working with a process that uploads an Excel
Spreadsheet that is created by a client. Yes, I could go back to them and tell
them no spaces, but I
ok, not sure if this is what you need, but can you use the Replace()
function?
On Fri, Apr 18, 2008 at 2:52 PM, Howard Fore [EMAIL PROTECTED] wrote:
Scott,
Have you thought about using the POI stuff to read the Excel sheet?
There's a lot of info on a CFC implementation at
Hey,
When you say field name in your email, are you referring to the column? Or
is it some calculated, not really a column value in the spreadsheet?
And secondly, what are you using to create the JDBC connection. I ask not
out of concern that it is the flaw in your process, but out of morbid
cfdump var=#qryTest#
cfdump var=#newQuery#
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Fore
Sent: Friday, April 18, 2008 2:52 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] QoQ question
Scott,
Have you thought about using
General defense of QofQ:
Keep in mind the main strength it has - which is it resides in memory. So
you can pull the main data with one SQL statement and then play with it all
you want using QofQ's which saves trips to the database and is MUCH faster
when dealing with large numbers of records.
running with VMware technology
Now offering ColdFusion 8 Enterprise hosting
FREE Subversion hosting
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shane Heasley
Sent: Friday, April 18, 2008 4:51 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] QoQ question
I am writing a query of query where the result set in the original query
has spaces in the field names. I know when you are querying a database, you
use [Field Name] as the syntax but CF is throwing an error when I do this
with the QoQ. Any ideas how I can call the fieldname with spaces in a
To: discussion@acfug.org
Subject: [ACFUG Discuss] QoQ question
I am writing a query of query where the result set in the original query
has spaces in the field names. I know when you are querying a database, you
use [Field Name] as the syntax but CF is throwing an error when I do this
with the QoQ. Any
*To:* discussion@acfug.org
*Subject:* [ACFUG Discuss] QoQ question
I am writing a query of query where the result set in the original query
has spaces in the field names. I know when you are querying a database, you
use [Field Name] as the syntax but CF is throwing an error when I do
21 matches
Mail list logo
