Option one is definitely the way to go. If you use a delimited list
you lose the speed and flexibility of indexed SQL, as the list forces
you to do a hierarchical search for the user id each time.
On Mon, Aug 1, 2011 at 6:46 AM, Robert Harrison
wrote:
>
> Curious as to what you all think is the
I'm not sure how your religious prejudices come into this, but whatever.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 2 August 2011 08:08, <> wrote:
>
> I just hate ayatollahs
~|
Order the Adobe Co
>>a delimited list is a great idea
Did I say that?
I said "may be an option"
I just hate ayatollahs and "never do" and "always do"
Good practice is a harmonious combination of common sense and intelligence,
both being the fruit of experience, not just a set of black or white rules.
~
Or someone spoofed it. Let me know if you need any details from them.
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Rick Colman [mailto:rcol...@cox.net]
Sent: Monday, August 01, 2011 5:44 PM
To: cf-talk
Subject: Re: Rick
And I was almost going to say, "but Claude will post that a delimited list
is a great idea" to save you the trouble.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 2 August 2011 02:43, <> wrote:
>
> A cross table is definitely THE standard way to do it.
>
> Although it
I am not doing anything ... so there may be a virus problem on my end.
will fix. apologies.
On 8/1/2011 2:39 PM, Bobby Hartsfield wrote:
> Anyone else getting tons of empty emails from rick colman? Not to the list
> but directly to my email address... If you sit next to rick pinch his nipple
> f
Anyone else getting tons of empty emails from rick colman? Not to the list
but directly to my email address... If you sit next to rick pinch his nipple
for that, then twist it for whatever he may be planning to do with my email
address
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acodersl
Tried that (specifying XML in filenme attribute of cfheader tag) but Excel
2010 appends ".xls" to the filename, which then results in the "extension"
prompt. No such problem prior to MS-Office 2007. But thanks Bill, appreciate
the input.
~~
Are you opening the file as *.xml, or *.xls? I open mine as *.xml...it knows
to open it as Excel.
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Monday, August 01, 2011 2:12 PM
To: cf-talk
Subject: RE: cf9 multiple sheet excel
> "The file you are trying to open i
Ah, thanks Leigh.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346435
> "The file you are trying to open is in a different format
> than specified by
> the extension..."
That is Excel's extension hardening. It can only be disabled on the client
computer.
http://support.microsoft.com/kb/948615
~|
I guess so...I only get the message saying "Do you want to Open or Save this
file?"
Try including this and don't output anything in the code that isn't inside the
cfsavecontent...
-Original Message-
From: Captain Obvious [mailto:mr.happ...@gmail.com]
Sent: Monday, August 01, 2011 12
A cross table is definitely THE standard way to do it.
Although it is not considered "good practice" by database ayatollah,
a delimited list may be an option when a "reasonable" number of possible values
is involved.
there are several advantages:
1º it is simpler to update in the database in cas
Me too. Have you figured a way to avoid Excel 2010 from producing the
message below when opening files generated in this manner?
"The file you are trying to open is in a different format than specified by
the extension..."
On Mon, Aug 1, 2011 at 1:07 PM, Bill Franklin wrote:
> The way we have
Extend it if the data in main.cfc doesn't need to be manipulated in some unique
way by the API call.
On Aug 1, 2011, at 10:55 AM, "Eric Cobb" wrote:
>
> I'm creating an API (if you can call it that) for one of our applications.
> It's nothing big or fancy, actually just 1 cfc with 1 method
I would take a look at using the MINUS union operator, and a table of poll/user
IDs that have completed the poll. MINUS should return only the records in the
first part of the query that are not in the second part of the querythe
first part being the list of candidates and the second part
The way we have always handled excel spreadsheet generation (CF8), has been to
take a formatted spreadsheet, save it as and XML sheet, open that XML in
Notepad, copy the XML code and paste it inside a tag...then edit the code to make it dynamic (e.g. Rows,
Columns, sheets, etc.). Then we run
Agree... we did that for years and we realized that using delimited lists
was a bad approach. Sent some time to undo all that. What a pain.
-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com]
Sent: Monday, August 01, 2011 7:57 AM
To: cf-talk
Subject: Re: Method Opinio
Also - you might want to check out this project from Adam Tuttle:
http://fusiongrokker.com/post/taffy-a-restful-framework-for-coldfusion
-Cameron
On Mon, Aug 1, 2011 at 11:55 AM, Eric Cobb wrote:
>
> I'm creating an API (if you can call it that) for one of our applications.
> It's nothing big
Have it extend the primary component, then calls to other methods of the
primary are 'native', and you can create ajax proxy methods that are
override methods, if necessary.
Steve 'Cutter' Blades
Adobe Community Professional
Adobe Certified Expert
Advanced Macromedia ColdFusion MX 7 Developer
_
Thanks. Delimited list nixed.
Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100
Hauppauge NY 11788
P : 631.231.6600 Ext. 119
F : 631.434.7022
http://www.austin-williams.com
Great advertising can't be either/or. It must be &.
Plug in to our
I'm creating an API (if you can call it that) for one of our applications.
It's nothing big or fancy, actually just 1 cfc with 1 method in it that's
going to be a front-facing component for AJAX calls to hit. All it's going
to do is take an ID, call our main cfc to do some processing, then re
>>>Avoid the delimited list idea; it always bites you on the arse
eventually.
Yeah, what James said. Been there, did that, and arse was summarily bitten.
G!
On Mon, Aug 1, 2011 at 10:57 AM, James Holmes wrote:
>
> Avoid the delimited list idea; it always bites you on the arse eventually.
> Use
This isn't ColdFusion specific but I figure it's worth asking here -
I have two SQL 2005 servers that I am synchronizing data between using
stored procedures. On one server, MAIN, I have 5 databases with identical
structure that feed a database of UNION based views. On the other server,
WEB, th
Hi All -
I am trying to generate a multiple tabs excel sheet. I have the following code.
The excel code is copied from coldfusionjedi.com
Avoid the delimited list idea; it always bites you on the arse eventually.
Use the first option.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 1 August 2011 21:46, Robert Harrison wrote:
>
> Curious as to what you all think is the best method for something. I have
>
Robert:
Personally, I would use a "Many to Many" lookup table, such as your
suggestion # 1 below.
This lookup table (e.g. userPolls ) would contain two (2) columns that are
Foreign Keys. The columns "userID" and "pollID" hold the Primary Keys of
the Users table and Polls table, respectively.
S
Curious as to what you all think is the best method for something. I have a
table that contains a list of polls. I have a user table that contains a list
of possible persons who may complete the poll (it requires log-in access). I
want to present a poll only one time so users can't complete a
I'll put in my $.02 about Alurium.
Railo Hosting, $6.75/ month, responsive to support queries, relaible
Alurium is one of those cases where you get alot more than what you pay for
http://alurium.com/clients/aff.php?aff=011
On Mon, Aug 1, 2011 at 4:11 AM, Russ Michaels wrote:
>
> try this
>
> h
try this
http://www.forta.com/cf/isp/
On Mon, Aug 1, 2011 at 8:34 AM, Anene Isioma Wealth wrote:
>
> i use hostek, but i have had reasons to move to www.indichosts.net ($3.00
> hosting)
>
>
>
>
>
> >
> >From: Chad Baloga
> >To: cf-talk
> >Sent: Monday, Augus
i use hostek, but i have had reasons to move to www.indichosts.net ($3.00
hosting)
>
>From: Chad Baloga
>To: cf-talk
>Sent: Monday, August 1, 2011 2:22 AM
>Subject: Cheap CF9 Hosting
>
>
>I am looking for a cheap place to host a site with CF9. This is jus
31 matches
Mail list logo