Re: Cheap CF9 Hosting

2011-08-01 Thread Anene Isioma Wealth
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

Re: Cheap CF9 Hosting

2011-08-01 Thread Russ Michaels
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:

Re: Cheap CF9 Hosting

2011-08-01 Thread Scott Stewart
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

Method Opinion

2011-08-01 Thread Robert Harrison
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

RE: Method Opinion

2011-08-01 Thread Christian N. Abad
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

Re: Method Opinion

2011-08-01 Thread James Holmes
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

cf9 multiple sheet excel

2011-08-01 Thread fun and learning
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

Data synchronization question

2011-08-01 Thread C. Hatton Humphrey
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,

Re: Method Opinion

2011-08-01 Thread Gerald Guido
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

API Question

2011-08-01 Thread Eric Cobb
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: Method Opinion

2011-08-01 Thread Robert Harrison
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

Re: API Question

2011-08-01 Thread Steve 'Cutter' Blades
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

Re: API Question

2011-08-01 Thread Cameron Childress
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.

RE: Method Opinion

2011-08-01 Thread Jacob
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

RE: cf9 multiple sheet excel

2011-08-01 Thread Bill Franklin
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,

RE: Method Opinion

2011-08-01 Thread Bill Franklin
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

Re: API Question

2011-08-01 Thread Lists
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

Re: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious
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

Re: Method Opinion

2011-08-01 Thread Claude Schnéegans
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

RE: cf9 multiple sheet excel

2011-08-01 Thread Bill Franklin
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]

RE: cf9 multiple sheet excel

2011-08-01 Thread Leigh
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 ~|

RE: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious
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

RE: cf9 multiple sheet excel

2011-08-01 Thread Bill Franklin
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

RE: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious
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.

Rick Colman...

2011-08-01 Thread Bobby Hartsfield
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

Re: Rick Colman...

2011-08-01 Thread 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

Re: Method Opinion

2011-08-01 Thread James Holmes
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

RE: Rick Colman...

2011-08-01 Thread Bobby Hartsfield
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

Re: Method Opinion

2011-08-01 Thread Claude Schnéegans
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.

Re: Method Opinion

2011-08-01 Thread James Holmes
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

Re: Method Opinion

2011-08-01 Thread Maureen
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