Re: Cheap CF9 Hosting
i use hostek, but i have had reasons to move to www.indichosts.net ($3.00 hosting) From: Chad Baloga cbal...@gmail.com To: cf-talk cf-talk@houseoffusion.com 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 just a site I am making for my family. Has anyone has any problems with http://hostek.com? Thanks ~| 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:346414 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Cheap CF9 Hosting
try this http://www.forta.com/cf/isp/ On Mon, Aug 1, 2011 at 8:34 AM, Anene Isioma Wealth anene.quor...@yahoo.com wrote: i use hostek, but i have had reasons to move to www.indichosts.net ($3.00 hosting) From: Chad Baloga cbal...@gmail.com To: cf-talk cf-talk@houseoffusion.com 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 just a site I am making for my family. Has anyone has any problems with http://hostek.com? Thanks ~| 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:346415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Cheap CF9 Hosting
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 r...@michaels.me.uk wrote: try this http://www.forta.com/cf/isp/ On Mon, Aug 1, 2011 at 8:34 AM, Anene Isioma Wealth anene.quor...@yahoo.com wrote: i use hostek, but i have had reasons to move to www.indichosts.net ($3.00 hosting) From: Chad Baloga cbal...@gmail.com To: cf-talk cf-talk@houseoffusion.com 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 just a site I am making for my family. Has anyone has any problems with http://hostek.com? Thanks ~| 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:346416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Method Opinion
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 poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, why? Should I use a delimited list in the POLL record, or should I use a cross-reference table with a join and NOT IN select... or should I do something different. Thanks 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 blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Method Opinion
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. Some additional information can be found here: http://msdn.microsoft.com/en-us/library/ms190651.aspx Again, this is my approach; I would be interested in hearing what other folks suggest Cheers! Christian N. Abad - President Accessible Computing, Inc. 1210 McLaughlin Drive Charlotte, NC 28212 http://www.AccessibleComputing.com 704.900.1825 (Direct Line) christ...@accessiblecomputing.com -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, August 01, 2011 9:47 AM To: cf-talk Subject: Method Opinion 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 poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, why? Should I use a delimited list in the POLL record, or should I use a cross-reference table with a join and NOT IN select... or should I do something different. Thanks 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 blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Method Opinion
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 rob...@austin-williams.com wrote: 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 poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, why? Should I use a delimited list in the POLL record, or should I use a cross-reference table with a join and NOT IN select... or should I do something different. Thanks 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 blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf9 multiple sheet excel
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
cfset q = queryNew(Name,Beers,Vegetables,Fruits,Meats,
cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer)
cfloop index=x from=1 to=10
cfset queryAddRow(q)
cfset querySetCell(q, Name, Name1)
cfset querySetCell(q, Beers, 2)
cfset querySetCell(q, Vegetables, 15)
cfset querySetCell(q, Fruits, 33)
cfset querySetCell(q, Meats, 3)
/cfloop
cfset filename = expandPath(./myexcel.xls)
!---
cfspreadsheet action=write query=q filename=#filename#
overwrite=true
---
!--- Make a spreadsheet object ---
cfset s = spreadsheetNew()
!--- Add header row ---
cfset spreadsheetAddRow(s, Name,Beers,Vegetables,Fruits,Meats)
!--- format header ---
cfset spreadsheetFormatRow(s,
{
bold=true,
fgcolor=lemon_chiffon,
fontsize=14
},
1)
!--- Add query ---
cfset spreadsheetAddRows(s, q)
cfset SpreadsheetCreateSheet (s, EvaluationSheet)
cfheader name=content-disposition value=attachment;
filename=myexcel.xls
cfcontent type=application/msexcel
variable=#spreadsheetReadBinary(s)# reset=true
So the first sheet displays fine. To create a new sheet, I am using
spreadsheetCreateSheet. How can I add data to the sheet? I mean I can use
cfspreadsheet with action write, but I do not want to save the excel, rather
have the user save it.
~|
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:346420
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Data synchronization question
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, there is one database that, for about 30 of the almost 1500 tables (I didn't create the data schema nor do I have any ability to change it, it's a Microsoft product that we're reporting on) in the MAIN db structure have a similarly named table, something along these lines: MAIN table - UPR00100 WEB table dUPR00100 Every 6 hours a stored procedure on WEB fires off that does the following: TRUNCATE TABLE dUPR00100 INSERT INTO dUPR00100 (column list) SELECT (column list) FROM MAIN.Reporting.dbo.UPR00100 I'm wondering two things: 1. Is there a better way to do this data sync outside of using the stored procedure approach? The rule for the sync is that all data on MAIN wins... and there is no code on WEB that modifies the tables on WEB. 2. Would there be any kind of time and process savings to rewrite the procedures to perform and insert/update/delete process instead of always wiping and reloading? My limitations are this - I can't upgrade the database server and I can't change any of the table structures. I can only work with the synchronization functionality. Thanks! Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com No trees were killed in the sending of this message, but a large number of electrons were terribly inconvenienced. ~| 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:346421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Method Opinion
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 james.hol...@gmail.comwrote: 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 rob...@austin-williams.com wrote: 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 poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, why? Should I use a delimited list in the POLL record, or should I use a cross-reference table with a join and NOT IN select... or should I do something different. Thanks 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 blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
API Question
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 return the results. My question is, is it better to have my API cfc just extend the main component, or should create the connection to the main component in the API cfc? What is the standard or preferred method for doing this? Thanks, Eric http://www.cfgears.com ~| 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:346423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Method Opinion
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 blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: API Question
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 http://blog.cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 8/1/2011 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 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 return the results. My question is, is it better to have my API cfc just extend the main component, or should create the connection to the main component in the API cfc? What is the standard or preferred method for doing this? Thanks, Eric http://www.cfgears.com ~| 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:346425 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: API Question
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 cft...@ecartech.com 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 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 return the results. My question is, is it better to have my API cfc just extend the main component, or should create the connection to the main component in the API cfc? What is the standard or preferred method for doing this? Thanks, Eric http://www.cfgears.com ~| 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:346426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Method Opinion
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 Opinion 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 rob...@austin-williams.com wrote: 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 poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, why? Should I use a delimited list in the POLL record, or should I use a cross-reference table with a join and NOT IN select... or should I do something different. Thanks 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 blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
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 cfsavecontent
variable=strXmlData tag...then edit the code to make it dynamic (e.g. Rows,
Columns, sheets, etc.). Then we run the following code to have it open in
Excel...
cfheader name=content-disposition value=attachment; filename=#fileName#/
cfcontent type=application/vnd.ms-excel variable=#ToBinary( ToBase64(
strXmlData.Trim().ReplaceAll( '\s+', '' ).ReplaceAll( '\s+', '' ) ) )#/
When we upgrade to CF9 next quarter, the only use I really have for the new
office functionality, is to modify existing sheets
Anyways, that's just my $0.02
-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com]
Sent: Monday, August 01, 2011 10:30 AM
To: cf-talk
Subject: cf9 multiple sheet excel
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
cfset q = queryNew(Name,Beers,Vegetables,Fruits,Meats,
cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer)
cfloop index=x from=1 to=10
cfset queryAddRow(q)
cfset querySetCell(q, Name, Name1)
cfset querySetCell(q, Beers, 2)
cfset querySetCell(q, Vegetables, 15)
cfset querySetCell(q, Fruits, 33)
cfset querySetCell(q, Meats, 3)
/cfloop
cfset filename = expandPath(./myexcel.xls)
!---
cfspreadsheet action=write query=q filename=#filename#
overwrite=true
---
!--- Make a spreadsheet object ---
cfset s = spreadsheetNew()
!--- Add header row ---
cfset spreadsheetAddRow(s, Name,Beers,Vegetables,Fruits,Meats)
!--- format header ---
cfset spreadsheetFormatRow(s,
{
bold=true,
fgcolor=lemon_chiffon,
fontsize=14
},
1)
!--- Add query ---
cfset spreadsheetAddRows(s, q)
cfset SpreadsheetCreateSheet (s, EvaluationSheet)
cfheader name=content-disposition value=attachment;
filename=myexcel.xls
cfcontent type=application/msexcel
variable=#spreadsheetReadBinary(s)# reset=true
So the first sheet displays fine. To create a new sheet, I am using
spreadsheetCreateSheet. How can I add data to the sheet? I mean I can use
cfspreadsheet with action write, but I do not want to save the excel, rather
have the user save it.
~|
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:346428
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Method Opinion
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 being the list of completed candidates. Alternately, you could have a table that lists the candidates also include a status or completion date...and exclude those from an joined table. My $0.02... -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, August 01, 2011 8:47 AM To: cf-talk Subject: Method Opinion 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 poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, why? Should I use a delimited list in the POLL record, or should I use a cross-reference table with a join and NOT IN select... or should I do something different. Thanks 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 blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: API Question
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 cft...@ecartech.com 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 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 return the results. My question is, is it better to have my API cfc just extend the main component, or should create the connection to the main component in the API cfc? What is the standard or preferred method for doing this? Thanks, Eric http://www.cfgears.com ~| 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:346430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 multiple sheet excel
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 bill.frank...@bayer.comwrote: 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 cfsavecontent variable=strXmlData tag... ~| 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:346431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Method Opinion
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 case of modifications (only one field in one query); 2º the list is return directly in a list of checkbox input fields. 3º the select query returns directly a list, I'm still looking for a way to get directly a list in a query using a cross table. 4º CF is especially well equiped for list manipulation. However you have to make sure that the number of possible values cannot get too large in the future. For instance I use this technique for registration to activities in a convention. Participants will never attend thousands of activities, even in a 15 days convention. ~| 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:346432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
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... cfsetting showdebugoutput=false -Original Message- From: Captain Obvious [mailto:mr.happ...@gmail.com] Sent: Monday, August 01, 2011 12:58 PM To: cf-talk Subject: Re: cf9 multiple sheet excel 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 bill.frank...@bayer.comwrote: 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 cfsavecontent variable=strXmlData tag... ~| 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:346433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
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 ~| 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:346434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
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 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
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 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 ~| 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:346436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
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. ~| 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:346437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Rick Colman...
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://acoderslife.com http://cf4em.com ~| 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:346438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Rick Colman...
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 for that, then twist it for whatever he may be planning to do with my email address .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| 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:346439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Method Opinion
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 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 case of modifications (only one field in one query); 2º the list is return directly in a list of checkbox input fields. 3º the select query returns directly a list, I'm still looking for a way to get directly a list in a query using a cross table. 4º CF is especially well equiped for list manipulation. However you have to make sure that the number of possible values cannot get too large in the future. For instance I use this technique for registration to activities in a convention. Participants will never attend thousands of activities, even in a 15 days convention. ~| 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:346440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Rick Colman...
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 Colman... 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 for that, then twist it for whatever he may be planning to do with my email address .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| 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:346441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Method Opinion
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. ~| 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:346442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Method Opinion
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 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:346443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Method Opinion
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 rob...@austin-williams.com wrote: 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 poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, w ~| 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:346444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
