Re: cfloginuser attribute roles question
Sorry, forget about this question.. I think I know why... I will hard code a difficult role for harker to detect. - Original Message - From: Stéphane_Bisson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:04 PM Subject: Re: cfloginuser attribute roles question That's bad also... I cannot put like this... cffunction name=BouquetList access=remote returnType=query roles=#request.user_role# Any suggestion! - Original Message - From: Stéphane_Bisson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 04, 2003 10:53 PM Subject: cfloginuser attribute roles question I'm just questionning about the cf tag cfloginuser attribute roles. Roles has a s meaning that I can put many roles for a user. I try to put myseft this set of roles in the user table... user_tbl.nickname ='stef' user_tbl.role1 = 'user, user2' 2= 'user; user2' 3= 'user user2' the login.cfc is doing... cflogin idletimeout=#request.Session_Elapsed_TimeSS# cfloginuser name=#user_tbl.nickname# password=#user_tbl.password# roles=#user_tbl.role# and when I try to call the method below... cffunction name=MailList access=remote returnType=query roles=user2 and CF gives me... Current user was not authorized to invoke this method How can I make a user has many roles! and be able to execute the CFC methods that belongs to these roles.. I don't want to have to create many user ids to go everywhere in our site... Stef has an user... StefAdmin has an Administration of our site... etc.. Thanks Stephane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFC instances with cffunction roles=!!! problem!
This is pretty hard to explain my problem... but I will try my best to explain it... so I start with this.. 1- I have a facade CFC call PictureServiceFacade.cfm that Flash is calling 2- I have the real CFC instantiated into an Application scope like PictureService.cfc 3- The Flash Movie is calling the GetSlides in the PictureService.cfc service facade 4- The real PictureService.cfc method GetSlides mention this... cffunction name=GetSlides access=remote returnType=query roles=guest_role,member_role 5- The timeout for a cflogin is 10 sec 6- The timeout of Application var is 10 sec So here's my problem... I'm being waiting for 60 second.. and I do this... 1- Logon as a guest... role=guest_role 2- Execute the cfinvoke to test the GetSlides method 3- It's working fine for the guest... I get the slide slow 4- 5 sec later I login as member Stef role=member_role... (I'm doing a cflogout before the cflogin) 5- Execute the cfinvoke to test the GetSlides method 5- I got this error... Current user was not authorized to invoke this method If I wait of 60 sec again... and I do this opposite.. like this... 1- Logon as a Member Stef... role=member_role 2- Execute the cfinvoke to test the GetSlides method 3- It's working fine for the Member.. I get the slide slow 4- 5 sec later I login with Guest role=guest_role...(I'm doing a cflogout before the cflogin) 5- I got this error... Current user was not authorized to invoke this method How come it's working like this with instances of CFC... I should probably test it with a static CFC that I instantiate every time to see the difference... I just understand that the roles is at their beginning in ColdFusion... By the way, I just test it with static CFC instance... I just try to instantiate my PictureService.cfc every time the facade is being called into a variables scope and it's working fine... the guest and the member can access my GetSlides method... but when I store them into a shared scope... it's seems to be lost...I would like to know why! because when I store my CFC in shared scope... it's seems to recognize only the user role identify in my method the first time is being called! Stephane - Original Message - From: Stéphane_Bisson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 12:37 AM Subject: Another question about cfloginuser attribute roles. New question about cfloginuser attribute roles. I try something tonight and it seems that I cannot make it to work. So I will explain... I have a user members role and I have a user guest role. They both login with their role... I want them both to be able to call my CFC methods which is... cffunction name=GetSlides access=remote returnType=query roles=member_role,guest_role It does not seems to work and I did not put any space between them! I just hope that two different users like member and guest can be able to execute my methods with their own role! I'm always getting the error that is not authorized... It's only the first CFC role that is valid... So in this case the member can get the GetSlides... but the guest is unauthorized... I'm missing something! Thanks Stephane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Can Coldfusion MX connect to a Univers Database ?
Does anybody on the list know how to set up a datasource to an IBM Univers database in Coldfusion MX Administrator. As you may know there is know defualt driver when adding a datasource for Univers, so does anybody have any idea on how to connect to this ? I have installed the latest Univers ODBC driver on the IIS server and set it up via the control panel, and created a Local System Account, which I then set up in the administrator as ODBC socket data datasource. But when running the cfm page I am recieving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Any ideas on how to get around this please? Ian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another question about cfloginuser attribute roles.
On Monday, Aug 4, 2003, at 21:49 US/Pacific, Raymond Camden wrote: When you pass 2-N roles to access, or to isUserInRoles(), CF treats it as an AND list - i.e., the user must be in ALL roles. To get around this, you don't use access=, instead you write your own code: An alternative is to have a pseudo-role, e.g., member_or_guest and then in your cfloginuser tag, you don't just set members or guest , you set members,member_or_guest or guest,member_or_guest... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX 6.1 Where are the tools? RE: Macromedia release ColdFusion MX 6.1 (previously RedSky)
oi Sandy!! http://www.macromedia.com/software/coldfusion/downloads/ Tuesday, August 5, 2003, 6:50:20 AM, you wrote: SC Anyone know where the VTM's or DWMX extensions are for this upgrade? I SC can't find them SC Sandy SC -Original Message- SC From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] SC Sent: Tuesday, August 05, 2003 1:24 AM SC To: CF-Talk SC Subject: Macromedia release ColdFusion MX 6.1 (previously RedSky) SC http://www.macromedia.com/software/coldfusion/productinfo/upgrade/ SC FREE to existing MX customers and available for Windows, Linux, AIX, SC Solaris, HP Unix, AIX and Mac OS X. SC ** SC The information contained in this e-mail, and any attachments to it, is SC intended for the use of the addressee and is confidential. If you are not SC the intended recipient you must not use, disclose, read, forward, copy or SC retain any of the information. If you have received this e-mail in SC error, please delete it and notify the sender by return e-mail or telephone. SC The Commonwealth does not warrant that any attachments are free from viruses SC or any other defects. You assume all liability for any loss, damage or other SC consequences which may arise from opening or using the attachments. SC SC *** SC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No more ColdFusion Professional?
Just be aware that each instance of CFMX will use at least 100Mb of RAM as (source the, er, July edition of CFDJ). For hosting this is a very nice change, instead of just Sandboxes in Enterprise Edition, I can now both run multiple instances and use Sandboxes inside those instances. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No more ColdFusion Professional?
Peter Tilbrook wrote: Just be aware that each instance of CFMX will use at least 100Mb of RAM as (source the, er, July edition of CFDJ). I have instances running on as little as 43 MB (JMC instance and my own server monitoring instance). The rest starts at that number, but increases as they are being used. RAM is cheap if you don't intent to run dozens of instances. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia release ColdFusion MX 6.1 (previously RedSky)
Peter Tilbrook wrote: Yeah! But hey the first beta of RedSky was about 180Mb! That was not the problem. The problem was that download speed was limited at 50 kB/s. Downloading a complete FreeBSD ISO from the other side of the world was faster as getting a beta. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: alter table question
thanks tody, sounds like you habba cold :) tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 11:25 AM To: CF-Talk Subject: RE: alter table question Tody, Create a new column column2 varchar(25) --- or whatever then -- update myTable SET column2 = CAST(column1 AS varchar(25)) -- where column1 is your text data type. -Mark -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 10:07 AM To: CF-Talk Subject: RE: alter table question but I can do it now :) the table doesn't get data until tonight :) how would the data get into the new column the fastest? some sort of dts? some sort of cfqueries? I can do either, what would be fastest you think? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 11:04 AM To: CF-Talk Subject: RE: alter table question is there a query analyzer way to alter the column datatype? I have some text columns that should been varchar, and I need to change them...i don't care about losing data, since its only 10-25 characters per cell... I don't think SQL Server allows you to convert from a Text to a Varchar because of the truncation If it won't, the simplest way is to add a new column, UPDATE from one field to the other, then remove/rename the Text field and rename the new Varchar field That should do what you want, but it can't be live for updates as it could screw up the updates ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to compute this DAY (not Date) last year?
Tony Schreiber wrote: For a sales report, I need to figure out what the date is for this DAY last year. So for today, 8/5/2003 Tuesday, I need to figure out what the date was for this Tuesday last year (which was 8/6/2002). What is the definition of this day last year? Is that this day of the week during this week of the year? I think so. Stated that way, it shouldn't be too hard to figure out. Hmm. I is usually a mater of breaking it down into small pieces. Just be carefull, ISO week numbers are different from US week numbers and there might be an issue with some years having a week 53 and others not. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 6.1 Not Installing
Are these server machines or developer desktops? If server boxes, make sure you are in 256 color mode or greater as the installer requires it. -Original Message- From: Harold Brauer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 11:27 AM To: CF-Talk Subject: 6.1 Not Installing I have tired several times to install 6.1 Every time I do it starts to unpack and then nothing happens no screen, nothing. I check the Task Manager and it is running in there but the screen remains blank. Can anyone help me with this ASAP? I have several sites that are not running due to the inability to install any updates. TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: alter table question
ok ok ok :) you did tooobut, his had code...he gets 5 more bonus points for the day :) and the american reference was a jab at the thread last week, talking about the difference between millions/billions/zaptillions between the two continentsor usa vs. the world probably. there is a difference, I didn't know itbut now I do :) tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 2:04 PM To: CF-Talk Subject: RE: alter table question so, I will most likely use the suggestion that mark kruger suggested Erm, that's exactly what I suggested, but without the code :-P ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: alter table question
that's 18 (american)million rows ;) That's a lot of fistfights there, mate. ;) - Jim Tony Weeg wrote: yeah that's all well and good, but the table I need to do this one onis a wee 18 million rows. and that's 18 (american)million rows ;) so, I will most likely use the suggestion that mark kruger suggested Create a new column column2 varchar(25) --- or whatever then -- update myTable SET column2 = CAST(column1 AS varchar(25)) -- where column1 is your text data type. tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:00 PM To: CF-Talk Subject: Re: alter table question This is because EM will create a temporary table, copy your data over, and then drop the original table, recreate it, and then insert the old data into there and drop the temp table. - Original Message - From: Stan Winchester [EMAIL PROTECTED] Date: Tuesday, August 5, 2003 10:45 am Subject: alter table question I just tried to convert a column from text to varchar in query analyzer using ALTER TABLE dbo.tbl_Items ALTER COLUMN Item varchar(50)ALTER TABLE [table name] ALTER COLUMN [column name] [datatype] The above example threw the following error: Server: Msg 4928, Level 16, State 1, Line 1 Cannot alter column 'Item' because it is 'text'. However, I could change the datatype in Enterprise Manager from text to varchar with no problems. NOTE: You will need to remove any Contraints on the affected field before changing the datatype, and then reapply any contraints as needed. It seems the alter statement works fine between varchar and int, but not from text. There may be other datatypes that cannot be converted through query analyzer, but might be alterable in enterprise manager. Maybe some SQL guru might enlighten us all. Stan Winchester is there a query analyzer way to alter the column datatype? I have some text columns that should been varchar, and I need to changethem...i don't care about losing data, since its only 10-25 charactersper cell... thanks! tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia release ColdFusion MX 6.1 (previously RedSky)
50148 The cfselect tag's required attribute did not work. Wow. It only took six years, but they finally fixed this :) - Original Message - From: Tilbrook, Peter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:24 PM Subject: Macromedia release ColdFusion MX 6.1 (previously RedSky) http://www.macromedia.com/software/coldfusion/productinfo/upgrade/ FREE to existing MX customers and available for Windows, Linux, AIX, Solaris, HP Unix, AIX and Mac OS X. ** The information contained in this e-mail, and any attachments to it, is intended for the use of the addressee and is confidential. If you are not the intended recipient you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage or other consequences which may arise from opening or using the attachments. *** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: alter table question
so, I will most likely use the suggestion that mark kruger suggested Erm, that's exactly what I suggested, but without the code :-P ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX 6.1 Where are the tools? RE: Macromedia release ColdFusion MX 6.1 (previously RedSky)
Anyone know where the VTM's or DWMX extensions are for this upgrade? I can't find them Sandy -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:24 AM To: CF-Talk Subject: Macromedia release ColdFusion MX 6.1 (previously RedSky) http://www.macromedia.com/software/coldfusion/productinfo/upgrade/ FREE to existing MX customers and available for Windows, Linux, AIX, Solaris, HP Unix, AIX and Mac OS X. ** The information contained in this e-mail, and any attachments to it, is intended for the use of the addressee and is confidential. If you are not the intended recipient you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage or other consequences which may arise from opening or using the attachments. *** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Shared Windows Hosting - Licensing
I think this is the best thing MS has done with licensing. My company 'Kchost.net' is joining this program now. I have 2 Dual Processor 2400 servers. The Web Edition of Server 2003 is $10/processor/mo and does not require any CAL's. If I want FrontPage extensions it is $5.00/month per user. The SQL Server processor License is $169/processor/mo + $18/processor Windows License and $5.00/m for each CAL. It also cost $27 for the media, you can install it on as many box's you want just report the production box's to the SPLA program. The Microsoft Rep I spoke with said Kchost.net can join now but will have to have the 2 MCP's within 6 months. The cost of the tests (last I checked) are about $100 each. Here is a list of MCP's http://www.microsoft.com/traincert/mcp/officespecialist/default.asp I think that some of the potential clients we speak too will like seeing that logo on our cards and in our media kits. Rick Eidson -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 2:30 PM To: CF-Talk Subject: OT: Shared Windows Hosting - Licensing Sorry for the OT, but there are probably a number of people on the list offering shared Windows hosting, most likely with CF. I know there are a lot of small and medium sized developers who, like ourselves, own a couple of Windows boxes that they host client web site on. What is your interpretation of Windows operating system licensing for service providers offering hosting services? http://microsoft.com/serviceproviders/licensing/compare.asp My reading of Microsoft licensing now leads me to believe that the _only_ valid licensing model of any Windows OS used by service providers for web hosting is via the SPLA (Service Provider Licensing Agreement). I'm not sure when (or how) this happened, but I'm certain that at one time this was licensing was not required. For a small provider, the main difficulty with the SPLA is the requirement that your company _must_ first be a Microsoft Certified Partner. And to be a Microsoft Certified Partner, you need to have two certified Microsoft Professionals on staff. From what I'm reading, I can't see how many one and two person shops and small developers would even qualify to be an MCP (let alone why they would want to). I can't imagine how many are completely ignorant of the need for SPLA licensing, nor could I begin to imagine how many servers are in violation of Microsofts licensing. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: alter table question
This is because EM will create a temporary table, copy your data over, and then drop the original table, recreate it, and then insert the old data into there and drop the temp table. - Original Message - From: Stan Winchester [EMAIL PROTECTED] Date: Tuesday, August 5, 2003 10:45 am Subject: alter table question I just tried to convert a column from text to varchar in query analyzer using ALTER TABLE dbo.tbl_Items ALTER COLUMN Item varchar(50)ALTER TABLE [table name] ALTER COLUMN [column name] [datatype] The above example threw the following error: Server: Msg 4928, Level 16, State 1, Line 1 Cannot alter column 'Item' because it is 'text'. However, I could change the datatype in Enterprise Manager from text to varchar with no problems. NOTE: You will need to remove any Contraints on the affected field before changing the datatype, and then reapply any contraints as needed. It seems the alter statement works fine between varchar and int, but not from text. There may be other datatypes that cannot be converted through query analyzer, but might be alterable in enterprise manager. Maybe some SQL guru might enlighten us all. Stan Winchester is there a query analyzer way to alter the column datatype? I have some text columns that should been varchar, and I need to changethem...i don't care about losing data, since its only 10-25 charactersper cell... thanks! tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Installing MX on WIN2K and Not Getting IIS
Tried that. Shut down the service and ran the connectors. Still went to the 8500 port. Hopefully a reboot will work. If you install CFMX to use the built-in JRun web server, then later use the IIS connector, the JRun web server will still be running, and you should be able to access your files through either one - hopefully, they both use the same web root directory! If you want to disable the built-in JRun web server, you can do that by following these instructions: http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_ webserver/ If you already have CF 5 running on IIS, you won't be able to use both CF 5 and CFMX with the same virtual server; if you create multiple virtual servers, you can have one (or more) using CF 5 and one (or more) using CFMX. If you've uninstalled CF 5, but had manually configured any IIS virtual server to use CF 5, you may need to remove the ISAPI extension for CF 5 from the IIS management console. You can do this by going to the Home Directory tab of the Global Web Site properties dialog or the properties dialog for a specific virtual server, clicking the Configuration button, and seeing if you have mappings for .cfm that look like c:\cfusion\bin\iscf.dll instead of something like c:\cfusionmx\runtime\lib\wsconfig\1\jrun.dll. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cheesy IIS question
is the 6.1 built-in server better than the last version? It was slow as molasses -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 5:17 PM To: CF-Talk Subject: Re: Cheesy IIS question Jack Poe wrote: great - I'd have to un-install CFMX again? that's three times today...g Do you use IIS functionality? Why not just shut down IIS and have the CF MX build in webserver run on port 80? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF Question
Janine, Thanks for the response, that's exactly what I was looking for! Thanks again. Mark -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 4:03 PM To: CF-Talk Subject: RE: PDF Question Mark, What I did with something similar was to add them together for the ouput and set a character return between each paragraph.(in fact yours sounds a bit simpler since you have 3 distinct paragraphs- I had a multitude of various paragraphs with variable length! So do this: CFSET ParagraphAll=#Paragraph1# #chr(10)##Paragraph2##chr(10)##Paragraph3# CFSET ParagraphAll =Tlkt.SetFormFieldData(ParagraphAll, #ParagraphAll#, 0) i think chr(10) is what works for carriage return... hope this helps. j -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:43 PM To: CF-Talk Subject: PDF Question I currently use ActivePDF and It's been working great except for one problem... Example: I have a pdf with 3 paragraphs in it, the second paragraph being variable text that a user would enter through a textarea. The second paragraph in the pdf is a form field that I will populate through the ActivePDF api. So, the first paragraph is fixed height, the second is variable and the third is also fixed height. How would I make it so the area for the second paragraph would shrink, or grow, depending upon the amount of text in the second paragraph. I'm trying to eliminate the large gap between paragraph 2 and 3 if the user happened to enter something like, Hello World!, for the second paragraph. If there is another product other than ActivePDF, I would be open to that. Thanks in advance for any help. Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf 5 verity collection question
I'm pretty sure mp3 is NOT a format Verity (at least the version in CF) supports. However, you can find _numerous_ Java classes out there that parse mp3s files. Do what I did - parse em all and store the results in a db. That's how I found out I have over 700 hours of music. -shudder- === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Xavier Vanvlasselaer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:22 PM To: CF-Talk Subject: cf 5 verity collection question does anyone know if verity can index mp3 files? I've tried adding .mp3 in CFSET IndexExtensions = .doc,.mp3,.wav, but it only indexes the .doc. What am I doing wrong? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cheesy IIS question
You're kidding!!! Leave it to Microsoft to put the stranglehold on me maybe I can get Deerfield to cough up a new CFMX connector thanks! -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 4:31 PM To: CF-Talk Subject: Re: Cheesy IIS question Jack Poe wrote: BlankWhy oh why am I seeing broken images when I visit a site from the machine it is being hosted onin IIS 5.0 on Win2000 Pro The offending site is www.cfdayton.com I got the following error: The page cannot be displayed There are too many people accessing the Web site at this time. Please try the following: * Click the Refresh button, or try again later. * Open the jackpoe.no-ip.com home page, and then look for links to the information you want. HTTP 403.9 - Access Forbidden: Too many users are connected Internet Information Services Technical Information (for support personnel) * Background: This error can occur if the Web server is busy and cannot process your request due to heavy traffic. * More information: Microsoft Support Windows Pro is limited to only handle 10 TCP/IP connections at a time. That would give this error to some requests, and if that request is for an image would result in the behaviour you are experiencing. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cheesy IIS question
Jochem van Dieten wrote: Jack Poe wrote: You're kidding!!! Leave it to Microsoft to put the stranglehold on me maybe I can get Deerfield to cough up a new CFMX connector I don't think that would help with the number of concurrent TCP/IP connections. You might have more luck with something like timing them out faster (page 45) http://www.microsoft.com/windows2000/docs/tcpip2000.doc On second thought, it is probably an IIS limit. I wouldn't be geting a 403 if it were at the IP layer. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL: Brain Teaser
Perhaps this is easy for someone so I figured I'd ask. Here's the scenario: USERS TABLE - USER_ID USERNAME etc... COMMENTS TABLE - COMMENT_ID USER_ID COMMENT etc... I know I can query USERS and then loop through the results fetching the comments... but I'd rather not do that. Here's the results I'm trying to get... in a SINGLE query if possible: USER_ID,USERNAME,MERGED_COMMENTS 1,joe,comment1brcomment2brcomment3 2,sam,comment 3,sue,commentbranother commentbretc. Any ideas? -Novak ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SES dummy file names
why use a dummy file name for the url after the SES info. It's not needed and adds more information to be parsed out. I'm told that it acts as another source of keywords that the search engines include in their ranking of the page. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to compute this DAY (not Date) last year? (SOLVED)
Ok, using this code: CFLOOP FROM=1990 TO=2010 INDEX=year CFLOOP FROM=1 TO=12 INDEX=month CFLOOP FROM=1 TO=#DaysInMonth('#year#-#month#-01')# INDEX=day CFSET Today = CreateODBCDate('#year#-#month#-#day#') CFSET thisDOW = DayOfWeek(today) CFSET thisdaylastyear = DateAdd('ww',-52,today) CFSET lastDOW = DayOfWeek(thisdaylastyear) CFIF thisDOW NEQ lastDOW CFOUTPUT PFONT COLOR=red[*NO MATCH*]/FONTBR #Today# #DayOfWeekAsString(DayOfWeek(today))#BR #ThisDayLastYear# #DayOfWeekAsString(DayOfWeek(ThisDayLastYear))#/P /CFOUTPUT /CFIF /CFLOOP /CFLOOP /CFLOOP I've concluded that CFSET thisdaylastyear = DateAdd('ww',-52,today) produces the correct day every single time... Works for me! Did I miss something? -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 10:59 AM To: CF-Talk Subject: RE: How to compute this DAY (not Date) last year? For a sales report, I need to figure out what the date is for this DAY last year. So for today, 8/5/2003 Tuesday, I need to figure out what the date was for this Tuesday last year (which was 8/6/2002). It's not as simple as today-364 days right? You've got leap years of course and probably some other wrenches in there as well. It's actually probably simple, but my brain is fried right now. ;) Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 * PARTS STORE NOW OPEN * http://www.is300.net/store/ http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MM engineers thin on the ground?
That sounds like you afre trying to get us to ask what's next! -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 7:27 AM To: CF-Talk Subject: MM engineers thin on the ground? We're rotating some folks through some down time this next few weeks, cuz I need them fully recharged when they come back for what's next :) Not to worry, though, we've always got proper coverage. Enjoy the bits! I've been getting some out of office responders from Macromedia lads. Poor buggers must have been given some leave after delivering RedSky to the masses. They deserve it of course! Thanks MM! Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 6.1 upgrade causes sitewide 500 error!! Pain!
Okay - hearing about all the great new stability enhancements in 6.1. I immediately upgraded to eliminate a problem where the cold fusion service would stop responding until reboot about once a day at random times. Now immediately after upgrade, all sites on this multsite server are returning an Internal Error 500 to the browser. I am so sad about this and I can see no way to revert back to the orginal MX - with all its problems at least it worked for most of the day. Looked in the event log and I can see that a Coldfusion SQL agent is GPFing Log folows: Reporting queued error: faulting application swagent.exe, version 1.93.0.0, faulting module unknown, version 0.0.0.0, fault address 0x. however I am not sure if the 500 problem is related because it even happens when I access non-database related pages. I would try to change the driver but I cannot access the web server without getting the 500 error - not even the CF Administrator! No other interesting entries in the event log. Everything worked before. Environment is: Windows 2003 Server SQL Server 2000 Latest SP CFMX 6.1 Help if you can please!!! Macromedia says they won't help me unless I pay $500 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sandbox permissions denied!!!
Hi, I decided to put a sandbox for my site and now I cannot do anything... I'm stock... When I want to Enable the CF Tag cfregistry that I disable... I disable it because I'm not using it, but I know now that cfapplication tag is using it... that's why I wanted to put it back... it gives me this error when I want to Enable it!!!... Anything I want to do in the Sandbox it gives this error Error: []java.security.AccessControlException: access denied (java.io.FilePermission C:\CFusionMX\lib\password.properties write) ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsystem. Please try the following: Check the CFML Reference Manual to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address 127.0.0.1 Referrer http://localhost:8500/CFIDE/administrator/security/sandbox.cfm Date/Time 03-Aug-03 10:34 PM Stack Trace (click to expand) I put Files/Dirs security only under the wwwroot/mydomain/* of read... is it because of this that I don't have anymore the permission to change something in my Sandbox... when it gives me this error, but I go back the tab cf tags and I see it enable... but when I reboot my win2k system it comes back as disable!... I even try to remove the check box in Enable ColdFusion Security and it gives me the same error.. Unable to toggle security. []java.security.AccessControlException: access denied (java.io.FilePermission C:\CFusionMX\lib\password.properties write) I guest I need to re-install ColdFusion MX:( Any help will be really appreciated. Thanks Stephane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [cftalk] calculating the date and time.
That should have read Yesterday and not LastWeek but you know what i mean CFIF LookingAt IS Day CFSET Today = CreateDateTime(Year(Now()),Month(Now()),Day(Now()),9,59,0) CFSET Yesterday = DateAdd(N,1,DateAdd(D,-1,Today)) /CFIF - Original Message - From: Allan Cliff To: CF-Talk Sent: Wednesday, July 30, 2003 12:53 PM Subject: Re: [cftalk] calculating the date and time. CFIF LookingAt IS Day CFSET Today = CreateDateTime(Year(Now()),Month(Now()),Day(Now()),9,59,0) CFSET LastWeek = DateAdd(N,1,DateAdd(D,-1,Today)) /CFIF - Original Message - From: ColdFusion Programmer To: CF-Talk Sent: Wednesday, July 30, 2003 12:48 PM Subject: [cftalk] calculating the date and time. Spot on Allan, this is what I was trying to do. Can you show me how to calclulate the from-to date time in the last 24 hours In the last 24 hours (29 Jul 2003 10:00 - 30 Jul 2003 09:59) Many Thanks Allan CFIF LookingAt IS Week CFSET Today = CreateDateTime(Year(Now()),Month(Now()),Day(Now()),0,59, 0) CFSET LastWeek = DateAdd(N,1,DateAdd(D,-7,Today)) /CFIF I haven't tested this so there maybe small errors but something like this?? - Original Message - From: ColdFusion Programmer To: CF-Talk Sent: Wednesday, July 30, 2003 12:24 PM Subject: [cftalk] calculating the date and time. How do I get the calculate the from time to start at 01:00 am and the to time to end at 00:59 am. Can you please show me how to get the date and time in the format mentioned below In the last 7 days (23 Jul 2003 01:00 - 30 Jul 2003 00:59) I was hoping somebody could help me. I'm trying to display the date and time. This is how I want to display it: If the current time is 10:05, I want to display the time in this format: In the last hour (09:05 - 10:04) If the current time is 10:05 and the date is 30.July, I want to display the date time in this format: In the last 24 hours (29 Jul 2003 10:00 - 30 Jul 2003 09:59) If the current time is 10:05 and the date is 30.July, I want to display the date time in this format: In the last 7 days (23 Jul 2003 01:00 - 30 Jul 2003 00:59) If the current time is 10:05 and the date is 30.July, I want to display the date time in this format: In the last 30 days (30 Jun 2003 01:00 - 30 Jul 2003 00:59) Look into DateAdd() - you can add any amount of time to a date, from seconds to years If you want to remove 7 days, you can just do DateAdd(d, -7, Now()) Hope this helps ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 6.1 upgrade causes sitewide 500 error!! Pain!
Chris Kief wrote: The migration wizard manages the installation of the ODBC services. There should be no need to change files like you're suggesting. This was a bug that caused a fair amount of trouble during the beta cycle. It was reported in the bug tracker as eradicated but may not have been; especially from the sound of things. The bug only affected upgrade installs as I recall. I certainly caught some sort of jdbc/odbc-killing bug after RC1, which I'm still running on as a result. Crossing fingers and hoping the next install of the final doesn't bite me. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [cftalk] calculating the date and time.
It is just a matter of paying with the individual time values to get what you need. The hour is always 59 minutes past the current hour minus 1. CFIF LookingAt IS Day CFSET Today = CreateDateTime(Year(Now()),Month(Now()),Day(Now()),Hour(DateAdd(H,-1,Now(,59,0) CFSET LastWeek = DateAdd(N,1,DateAdd(D,-1,Today)) /CFIF - Original Message - From: ColdFusion Programmer To: CF-Talk Sent: Wednesday, July 30, 2003 1:00 PM Subject: [cftalk] calculating the date and time. not quite as I was expecting. Take the current time, its 11:55 am GMT, I want the result to be (29 Jul 2003 11:00 - 30 Jul 2003 10:59) CFIF LookingAt IS Day CFSET Today = CreateDateTime(Year(Now()),Month(Now()),Day(Now()),9,59, 0) CFSET LastWeek = DateAdd(N,1,DateAdd(D,-1,Today)) /CFIF - Original Message - From: ColdFusion Programmer To: CF-Talk Sent: Wednesday, July 30, 2003 12:48 PM Subject: [cftalk] calculating the date and time. Spot on Allan, this is what I was trying to do. Can you show me how to calclulate the from-to date time in the last 24 hours In the last 24 hours (29 Jul 2003 10:00 - 30 Jul 2003 09:59) Many Thanks Allan CFIF LookingAt IS Week CFSET Today = CreateDateTime(Year(Now()),Month(Now()),Day(Now()),0, 59, 0) CFSET LastWeek = DateAdd(N,1,DateAdd(D,-7,Today)) /CFIF I haven't tested this so there maybe small errors but something like this?? - Original Message - From: ColdFusion Programmer To: CF-Talk Sent: Wednesday, July 30, 2003 12:24 PM Subject: [cftalk] calculating the date and time. How do I get the calculate the from time to start at 01:00 am and the to time to end at 00:59 am. Can you please show me how to get the date and time in the format mentioned below In the last 7 days (23 Jul 2003 01:00 - 30 Jul 2003 00:59) I was hoping somebody could help me. I'm trying to display the date and time. This is how I want to display it: If the current time is 10:05, I want to display the time in this format: In the last hour (09:05 - 10:04) If the current time is 10:05 and the date is 30.July, I want to display the date time in this format: In the last 24 hours (29 Jul 2003 10:00 - 30 Jul 2003 09:59) If the current time is 10:05 and the date is 30.July, I want to display the date time in this format: In the last 7 days (23 Jul 2003 01:00 - 30 Jul 2003 00:59) If the current time is 10:05 and the date is 30.July, I want to display the date time in this format: In the last 30 days (30 Jun 2003 01:00 - 30 Jul 2003 00:59) Look into DateAdd() - you can add any amount of time to a date, from seconds to years If you want to remove 7 days, you can just do DateAdd(d, -7, Now()) Hope this helps ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX 6.1 and WebDAV
So according to Ben Forta's DevNet article and other info on the 6.1 enhancements, we learn the following... The CFHTTP tag now supports all HTTP operations (GET, POST, HEAD, PUT, DELETE, TRACE, OPTIONS). Okay, that sounds great and it just happens to coincide with my search for information on getting WebDAV to work with ColdFusion. Has anyone out there attempted to integrate WebDAV and CF yet? Any luck? I kinda expected to find some info on the forums or lists but I haven't yet seen anything yet. .. .joe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Erratic CF/IIS issues
i think this email should make its way to every coldfusion using it firm, business, webshop...etcdoes mm have a record of email addressesthis is just too prevalent...way too prevalent... an idea? tony -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:06 PM To: CF-Talk Subject: RE: Erratic CF/IIS issues http://www.macromedia.com/support/coldfusion/ts/documents/tn18258.htm -Original Message- From: Jeff Lucido [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:02 PM To: CF-Talk Subject: Erratic CF/IIS issues I am experiencing the strangest problem I have ever seen with hosting CF apps. on an IIS box. Specifically, I have several virtual websites configured in IIS (not virtual directories). The erratic issue is occasionally one of the virtual websites will be displayed on top of the virtual website a user makes a request for. Specifically, a user wants xyz.com but abc.com is displayed on top of xyz.com. Nothing displays in the site abc.com except for broken links since the images do not exist in xyz.com. This is very odd and extremely annoying. I tried the MS knowledge base, but those efforts were fruitless (at least for me). I tried deleting both virtual websites, renaming their source directories, kicked the box and then re-created the virtual websites using new names. No luck, still happens. I cannot find anything in the log files and it does not occur at any regular frequency. It may go several weeks working properly and then, bam site not available. The only way I can get the sites to serve up properly after this has happened is to kick the WWW publishing service and CF MX. Server specifics: -W2K Server, SP3 -CFMX, updater 3 Any ideas and more importantly any way to correct this problem? Thanks! -JSLucido ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Installing MX on WIN2K and Not Getting IIS
-Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 11:46 AM To: CF-Talk Subject: RE: Installing MX on WIN2K and Not Getting IIS If you already have CF 5 running on IIS, you won't be able to use both CF 5 and CFMX with the same virtual server; if you create multiple virtual servers, you can have one (or more) using CF 5 and one (or more) using CFMX. Actually, you can. You just have to create a separate Application for each directory you want configured to run the non-default ISAPI filter. Then adjust the configuration as you would each virtual server. I have it running fine here. Works like a charm! - j james curran technical director nylon technology [EMAIL PROTECTED] 212-691-1134 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFC Addressing
Does anyone happen to know whether one's calling template and one's CFCs can reside in separate security sandboxes? For instance, could an ISP put all client sites in one default security sandbox with few permissions/tags/etc, but then allow them to tie into CFCs in another sandbox that does have all permissions. This would make security, availability and code reuse realitic goals! The obvious answer is to try it. Am struggling with installation problems right now (locked out of CFAdmin by some strange java.lang.NullPointerException) - but saw this discussion and thought I would throw in a related question. Thanks! That's not totally true. You can only sort of address CFCs relatively. You can't for example go up a directory, i.e. ../CFCs/ Which frankly, is rather annoying. ** You can access CFCs just like you would access custom tags. They can be put in the customtags directory of the ColdFusion installation. Or they can be in a directory that you can access via a ColdFusion mapping. Or they can be in the same directory as the page that invokes it. ( Or a relative directory to the page that invokes it ) At 10:52 AM 11/25/2002 -0600, you wrote: I have just finished Hal Helm's CFC book for the second time and this stuff is looking pretty nice. (of course I started programming in OO, so I knew it would be useful). My question is with regards to addressing a CFC. All of Hal's examples were directly under the MX wwwroot directory. How do you address a CFC if it is not under the wwwroot? For example, on my laptop, I have a virtual directory setup in IIS to point to d:\sandbox for my testing/play area. How would I invoke a cfc here? Would this also not be a problem for shared/virtual hosting where you might or might not know where the wwwroot folder is? This does not sound real portable if you have to have a 'physical' path to the wwwroot? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX 6.1 upgrade - 'smooth as butter'
I did an install on a server using an old MX app, it had an error blow up on the very first page. As it turned out this was from the early days and I had included the strlib from cflib.org and wrap() is now a built in function of CFML (this is documented), so it was no surprise. I commented out the function and everything worked great! Excellent job for the team! So then I uninstalled, removed all references to cfmx from the server and am going to give the jrun/cfmx combo a shot :) Wish me luck! - Calvin - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:31 PM Subject: CFMX 6.1 upgrade - 'smooth as butter' Nice. That is the expected behavior! :) m, butter. WIN2K -- IIS -- SQL Server Smooth upgrade. Nice speed gain! Thanks MM Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Convert number to Hex numbers??
from cflib.org decToHEx() cfscript /** * Converts from decimal(base10) to hexadecimal (base16). * * @param strDecimal number to convert to hexadecimal. * @return Returns a string. * @author Rob Brooks-Bilson ([EMAIL PROTECTED]) * @version 1, November 6, 2001 */ function DecToHex(str){ return Ucase(FormatBaseN(str, 16)); } /cfscript hth tony -Original Message- From: Troy Montour [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 10:29 PM To: CF-Talk Subject: Convert number to Hex numbers?? Hello, trying to generate a registry file for something so I don't have to type all the information. I need to convert a number to the hex value. example 2 = 02 or something like that. anyone made something to do this or know how to point me in the right direction would be great? Thank you Troy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dreamweaver MX RDS Backward-Compatibility
What about ftp? Greetings all.. I am the client Dave is talking about. We are using FTP to send files back and forth. We only need RDS access so that we can use Dreamweaver's built-in database connectivity. While we develop on MacOS X, I have tried setting up the account on a PC with the same Unable to authenticate.. result. I second Dave's thanks for any advice. Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFStoredproc is giving incorrect value in CFMX version. but getti ng correct value in cf4.5 version.. --- URGENT
Hi Here I am giving the testcode which I executed in cfmx version and CF4.5.1 version. But I am expecting value '4' from following code. I will be getting that value in only CF4.5.1 but not in CFMX. Is it unknown cfmx bug or do we need to change any attributes kind of things when we use cfstoreproc in cfmx. Really I would appreciate even if you give your suggestions.. = cfstoredproc procedure=pkg_security.sp_check_security datasource=#defaults.dsn# username=#client.user_name# password=#client.password# !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=user_id_in value=100023 !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=object_id_in value=1 null=yes !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=function_name_in value=patient !--- Replaced the deprecated attribute 'cfvarname' by 'variable' attribute --- cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable =access_key_out dbvarname=access_key_out /cfstoredproc cfset test = #access_key_out# cfoutput#test#/cfoutput test value is 4 in cf4.5.1 and test value is 0 in cfmx .. why it is so like that.. ? Thanks in advance.. Best regards Sachin. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Potential new Cold Fusion hosting center
The Kotter Group is considering adding Cold Fusion Hosting to its network operation center. If we did this we would add experienced Cold Fusion developers and database administrators to our staff. However, before we invest in the staff and upgrades we are trying to judge the interest in top shelf Cold Fusion specific hosting. Pricing would start around $49/month and go up depending on the services offered. Would you be interested in something like this and what would you like to see or not see in a Cold Fusion host? Please take our poll at http://kotter.net/?page=Polls ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple instances - licensing
The pricing is per processor pair, I believe. Thus if it is on one machine, it will require one license, == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If you are not satisfied with my service, my job isn't done! - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 10:05 PM Subject: Multiple instances - licensing | Do you need multiple licenses of Enterprise to use multiple instances of CF | or is the one license sufficient? | | Peter Tilbrook | ColdFusion Applications Developer | ColdGen Internet Solutions | 4/73 Tharwa Road | Queanbeyan, NSW, 2620 | AUSTRALIA | | Telephone: +61-2-6284-2727 | Mobile: +61-0439-401-823 | E-mail: [EMAIL PROTECTED] | | World Wide Web: http:/www.coldgen.com/ | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - SQL Firehose mode??
This often happens when you open a table that has a large amount of records in the enterprise manager. The enterprise manager, to save resources will not return all the records at once and throws this error when you try to insert a record. There are several things you could do, one of them might be to return only the top 1 record before entering a new one. Jeff -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 1:42 PM To: CF-Talk Subject: OT - SQL Firehose mode?? Why do I get this strange error when I try to add text to a column in SQL while in open table mode? Transaction cannot start while in firehose mode I'm adding text to a nvarchar column with 255 chars. Thanks. Robert O. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RTF and MIME types Addendum
I believe that \page is an RTF page break. --- Ben -Original Message- From: Den Melton [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:07 PM To: CF-Talk Subject: RTF and MIME types Addendum There's a great example of RTF at: http://tech.irt.org/articles/js154/index.htm. It works well for single as multiple record sets. Does anyone know how to put a page break in so each record shows on a seperate page within the document? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4