CFSNIPPETS Datasource
I am trying to run some example code that I have had for a while that requires the cfsnippets datasource to be defined in CF. I cannot remember which version of CF the cfsnippets.mdb came with as CF7 has no mention of that datasource. Can anybody hook me up with a copy of cfsnippets.mdb? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: REGEX File Extention
You could just use ListFirst/ListLast? i.e. cfset ext = ListLast(filename, '.') -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: 19 June 2007 10:33 To: CF-Talk Subject: REGEX File Extention Hello Guys, My REGEX skills are pretty horrible. I'm looking for a way to get the file extension from a string, examples of the strings are: Somthing.gif Thisone.jpg Ooh.mp3 Nice.fla What's the best way to achieve this? Effectively I want everything to the right of the dot. Thanks guys, Rob ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281497 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: need help with updating date field
You are missing a comma after Fax = '#form.Fax#' Should read Fax = '#form.Fax#', -Original Message- From: Imperial, Robert [mailto:[EMAIL PROTECTED] Sent: 30 May 2007 17:21 To: CF-Talk Subject: need help with updating date field I know this is probably obvious to most of you here, but I have an error on an update statement that I need some enlightenment on please. I'm using MSSQL2k, CFMX7 and I have an insert statement that works fine using #createODBCdate(Now())# but my update bombs on it?? Here's my update: UPDATE AdminPersonnel SET First_Name = '#form.First_Name#', Last_Name = '#form.Last_Name#', MI = '#form.MI#', Division = '#form.division#', Degree = '#form.Degree#', Title = '#form.Title#', Email = '#form.Email#', Phone = '#form.Phone#', Fax = '#form.Fax#' Date = '#createODBCdate(Now())#', IPAddress = '#CGI.REMOTE_ADDR#' WHERE ID = #form.ID# And here is the error Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Date'. The error occurred in D:\WebNew\domis\admin\actUpdateAdminPersonnel.cfm: line 16: line 1 Called from D:\WebNew\index.cfm: line 17 14 : Date = '#createODBCdate(Now())#', 15 : IPAddress = '#CGI.REMOTE_ADDR#' 16 :WHERE ID = #form.ID# 17 : /cfquery Awaiting your enlightenment ;) Bob ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MS SQL 2000 and ntext
I also seem to reember that there is some kind of restriction on the database drivers that restricts the size of a string that can be returned? I will try to remember how I dealt this though it was a long time ago! -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: 25 May 2007 15:14 To: CF-Talk Subject: RE: MS SQL 2000 and ntext Check this link, I think this is the same as the problem you are having, I had the same thing in the past. http://www.cfcdeveloper.com/index.cfm/2007/1/9/XML-from-SQL -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: 25 May 2007 15:00 To: CF-Talk Subject: MS SQL 2000 and ntext Hi there, I'm running CF7 and MS SQL 2000 on this project I'm working on. I'm using a simple cfquery to get a row of data. cfquery datasource=DB name=Data SELECT * FROM datatable WHERE id = 439 /cfquery Very, very simple query Now, one of these fields is of type ntext. It contains xml data. What I'm trying to do is to retrieve the xml data from this field... what seems to happen, is that the xml isn't returned in it's entirety. It's cut off at a certain point. Any ideas? This table is actually used by (and created with) a .NET program my employer purchased, and the data is used in this program without a problem. I know this is slightly vague Thanks, -- Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL 2000 and ntext
Check this link, I think this is the same as the problem you are having, I had the same thing in the past. http://www.cfcdeveloper.com/index.cfm/2007/1/9/XML-from-SQL -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: 25 May 2007 15:00 To: CF-Talk Subject: MS SQL 2000 and ntext Hi there, I'm running CF7 and MS SQL 2000 on this project I'm working on. I'm using a simple cfquery to get a row of data. cfquery datasource=DB name=Data SELECT * FROM datatable WHERE id = 439 /cfquery Very, very simple query Now, one of these fields is of type ntext. It contains xml data. What I'm trying to do is to retrieve the xml data from this field... what seems to happen, is that the xml isn't returned in it's entirety. It's cut off at a certain point. Any ideas? This table is actually used by (and created with) a .NET program my employer purchased, and the data is used in this program without a problem. I know this is slightly vague Thanks, -- Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Tools for converting videos to FLV?
I use this 'Alive Video to Flash Converter' it is extremely easy to use. http://www.alivemedia.net/video-to-flash-converter.htm -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: 21 May 2007 14:13 To: CF-Talk Subject: OT: Tools for converting videos to FLV? Does anyone have a recommendation for a tool to convert videos to FLV? It can be either OSX or Windows-based, any license, OSS or commercial. Our main criteria is ease of use. Thanks. Damien McKenna Web Developer The LIMU Company Making a Difference 610 Crescent Executive Court, Suite 110 Lake Mary, FL 32746 P 407.548.3800 F 407.333.0419 http://www.thelimucompany.com/ ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ThreeSelectsRelated Default Values
I have googled this all morning and have found no answer but many articles with the same problem and as my JS is limited I thought I would ask the question before diving into the unknown! I am using the ThreeSelectsRelated tag that I downloaded from somewhere, can't remember right now so I apologise to the author, and it works fine when selecting options and posting the form. My problem is that when I try to reload the posted data for editing I cannot set the default values to be selected correctly in the ThreeSelectsRelated tag. The first select box is selected correctly but the following 2 are not. Now the strange thing is that when I view the source code for the page I can clearly see that all 3 items are flagged as being selected correctly which is why I am thinking that it is JS related. Has anybody come across any solution or modified tag for this problem? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
LightHousePro JSMX?
Hi All, has anybody been able to sucessfully integrate JSMX into Ray Camdens excellent LightHousePro? I need to make a small change to see if this great utility will service our development teams requirements but I need to be able to use an existing JSMX setup that I have for a 4-selects related utility. Any ideas? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dynamicaly Building CFSTOREDPROC tag, can it be done?
Before I spend a load of time that I really do not have available at present experimenting with this I thought that I would ask the question here. I was wondering if anybody has ever dynamically built a cfstoredproc tag and then executed it. The situation I have is that I have ben asked if it is possible to dynamically build a cfstoredproc tag on the fly when you only know the number and type of parameters and SQL stored procedure name at run time. Has anybody ever done anything like this before? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Accessing application variables between 2 different applications?
Not really but I did not want the additional overhead of making round trips to the database. I think in this instance I will use the server scope. Thanks for all the help everyone. From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Fri 18/08/2006 17:37 To: CF-Talk Subject: Re: Accessing application variables between 2 different applications? I have 2 apps running on the same server, one of the apps is an admin center for inputting data to be displayed from within the second app. What I want to be able to do is track exactly who is logged on and where in the second app they are and display this information from within my admin app. Hence the cross application issue. Does this make sense? Hhm, is there some reason you can't just keep the data in a database table accessible to both applications? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Accessing application variables between 2 different applications?
I have 2 apps running on the same server, one of the apps is an admin center for inputting data to be displayed from within the second app. What I want to be able to do is track exactly who is logged on and where in the second app they are and display this information from within my admin app. Hence the cross application issue. Does this make sense? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Accessing application variables between 2 different applications?
I know this is probably a stupid question, as it most likely has security inplications, but I have 2 applications running on the same server and I was wondering if it is possible to access an application variables in one application from the other application, is this possible and if it is what would be the reasons against doing such a thing? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Compare 2 structures or arrays
On my site I have an area where up to 40 individual records consisting of several fields each are displayed and are able to be edited by the user. My customer insists that there be only one submit button on this page, not individual submits for each record. What I am trying to do is to minimise the number of database calls for updating records by only submitting records that have actually changed. What I have thought of doing is as follows, when the page is first loaded I concatanate all of the fields for each record into a string and build a structure/array of all of these strings. When the user has updated the records and submits the page I will build another structure/array in the same way. What I then need to do is to compare both structures/arrays to identify which records have actually changed and return those records only to be updated. Has anybody done anything similar to this? Do you know of any custom tags that will do the same? Is there a better way of doing this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Compare 2 structures or arrays
Thanks. Not quite I am after but at least it gives me a starting point for rolling my own. :-) This may be what you're looking for... http://cflib.org/udf.cfm?id=1136enable=1 On 5/31/06, Andy Mcshane [EMAIL PROTECTED] wrote: On my site I have an area where up to 40 individual records consisting of several fields each are displayed and are able to be edited by the user. My customer insists that there be only one submit button on this page, not individual submits for each record. What I am trying to do is to minimise the number of database calls for updating records by only submitting records that have actually changed. What I have thought of doing is as follows, when the page is first loaded I concatanate all of the fields for each record into a string and build a structure/array of all of these strings. When the user has updated the records and submits the page I will build another structure/array in the same way. What I then need to do is to compare both structures/arrays to identify which records have actually changed and return those records only to be updated. Has anybody done anything similar to this? Do you know of any custom tags that will do the same? Is there a better way of doing this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Only update DB if data has changed?
Hi all, does anybody have any ideas how I could best implement the following; I have a page that loads anything up to about 30 individual records at a time. Each record consists of 17 fields of data. All the records are displayed on the page to give the user the option of editing any individual field. When the user then submits the page I need to be able to work out which records have had data changed and only do database updates for those specific records. Having an individual submit for each record is not an option, the whole page must be submitted as one but only records that have changed should be updated. Can anybody suggest a method for doing this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241542 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Only update DB if data has changed?
Yes, I was thinking about using a structure but I am unsure of the best way to do a comparison. Wouldn't this mean having to a field by field comarison or is there a better way? I was wondering if anybody had created a custom tag to do just this sort of thing. Should be easy enough and no doubt several way s to achieve thisboth in CF Code and in SQL. One way would be to load the records at page load into a structure and then on submit comparing both the pre-edited and post edited form struct to see what has changed etc... -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 26 May 2006 10:25 To: CF-Talk Subject: Only update DB if data has changed? Hi all, does anybody have any ideas how I could best implement the following; I have a page that loads anything up to about 30 individual records at a time. Each record consists of 17 fields of data. All the records are displayed on the page to give the user the option of editing any individual field. When the user then submits the page I need to be able to work out which records have had data changed and only do database updates for those specific records. Having an individual submit for each record is not an option, the whole page must be submitted as one but only records that have changed should be updated. Can anybody suggest a method for doing this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Only update DB if data has changed?
The problem is related to running too many queries which do an awful lot of work in themselves and also the fact that the client refuses to have the option of being able to edit each record individually. Is the problem you are trying to solve related to performance of running too many queries, or from updating some sort of LastUpdated column unnecessarily. On 5/26/06, Andy Mcshane [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241547 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: I think I'm in love!
Ditto! But if I keep on about it my wife will also leave the room! Great way to get the remote control from her though! :-) Funny, any time I talk about my work, my wife's eyes glaze over... ;) thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Sunday, May 07, 2006 10:33 AM To: CF-Talk Subject: Re: I think I'm in love! Well im kinda running along the same lines. My GF is the financial person for the Adoption program I've been rambeling on about reciently. Their company just bought a new Webserver and Coldfusion. She is just now starting to learn it. She says, Its SO much easier to make a report this way! I'm waiting on her to start asking how to Integrate the reports with Quickbooks. On 5/7/06, Snake [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Sql Server Temp Table
I thought that you had to explicitly drop any temporary tables created with the hash syntax as soon as you had finished using it. Personally when ever I used to have to use this type of temporary table I always made sure that it was dropped as soon as I finished using it. If you are using SQL2000 or above you could always use the @table variable which is a much better performer and you do not have to worry about dropping it after you have finished using it. The only thing I can think of is that you've got this table being created somewhere else in your code, or maybe the create statement is in a loop. Running it from QA doesn't tell you anything because it's a different user/session, and temp tables are specific to the session. -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 09, 2006 10:52 AM To: CF-Talk Subject: Sql Server Temp Table Today I just started to get an error: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#temp_reports' in the database. If I take the query from coldfusion and run in analyzer it works as expected, it is just inside CF that I have the issue. I recycled the CF services in hopes to break any connections, I also recycled the SQL Server service and still no luck. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: if not exists (SQL) question
You could do the following (I am assuming you are using SQL server?) declare @Avariable INT SELECT @Avariable = ISNULL(YourId, 0) FROM Atable WHERE something = something IF @Avariable 0 BEGIN do something END ELSE BEGIN do somethign else END just my 2 cents worth. - Original Message - From: Russ [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, February 17, 2006 3:15 PM Subject: RE: if not exists (SQL) question So there's no way to get it to return the id from inside that statement? Maybe assign it to a variable in there? -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 7:46 PM To: CF-Talk Subject: RE: if not exists (SQL) question My guess would be that because the first SELECT is part on the condition, IF NOT EXISTS(SELECT...), it doesn't return a result set. Move the SELECT out of the condition and do some different logic. Adrian -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 17 February 2006 00:37 To: CF-Talk Subject: if not exists (SQL) question I have a query similar to the following: declare @emailLinkID int if not exists ( select emailLinkID from emailLinks where linkURL='https://www.someurl.com' ) begin insert into emailLinks ( linkURL ) values ( 'https://www.someurl.com, ) set @emailLinkID = @@IDENTITY select @emailLinkID as emailLinkID end This works fine when the record doesn't exist. But it doesn't return the id if the record does exist. What am I doing wrong? Russ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232705 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free third party DNS hosting from godaddy
I use www.zoneedit.com. -Original Message- From: Owner, Three Ravens Consulting [mailto:[EMAIL PROTECTED] Sent: 12 January 2006 18:55 To: CF-Talk Subject: Re: Free third party DNS hosting from godaddy I use registerfly.com Eric On Thu, 12 Jan 2006 09:21:12 -0500 Katz, Dov B \(IT\) [EMAIL PROTECTED] wrote: has anyone tried using the free DNS management from godaddy? They apparently let you manage dns records of outside domains without transferring them there (just pointing the nameserver to godaddy). I'm looking for a place that I could set up and manage domains at and my hosting company doesnt offer that Thanks NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229425 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Happy New Year to One and All!
That is excellent, gave me quite a chuckle. I think I will include this in my company email next year! :-) -Original Message- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 13 January 2006 10:56 To: CF-Talk Subject: OT: Happy New Year to One and All! (please excuse the OT, promises never to do it again ...) Please accept with no obligation, implicit or explicit, my best wishes for an environmentally conscious, socially responsible, low stress, non-addictive, gender neutral celebration of the winter solstice holiday, practiced within the most enjoyable traditions of the religious persuasion or secular practices of your choice, with total respect for the religious / secular persuasions and/or traditions of others, and their choice not to practice religious or secular traditions at all... and a fiscally successful, personally fulfilling and medically uncomplicated recognition of the onset of the generally accepted calendar year 2006, but not without due respect for the calendars of choice of other cultures whose contributions to society have helped make Britain great (not to imply the Britain is necessarily greater than any other country nor is it the only BRITAIN in the northern hemisphere), and without regard to the race, creed, colour, age, physical ability, religious faith, sexual orientation and choice of computer platform of the wishee. By accepting this greeting, you are accepting these terms. This greeting is subject to clarification or withdrawal. It is freely transferable with no alteration to the original greeting. It implies no promise by the wishee actually to implement any of the wishes for her/himself or others, and is void where prohibited by law and is revocable at the sole discretion of the wisher. Issued subject to the Conditions of Carriage of National Rail. This wish is warranted to perform as expected within the usual application of good tidings for a period of one year, or until the issuance of a subsequent holiday greeting, whichever comes first, and warranty is limited to replacement of this wish or issuance of a new wish at the sole discretion of the wisher. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229429 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Calculate schedule timeslots
I am sure that I saw something a while back that may address the issue I have. I have a scheduler that has time slots in increments of 15 minutes. What I need to do is to be able to exclude time slots that have already been allocated. For example I have start and end time dropdown lists so a user can select a time slot as follows; Start time : 11:45 AM Finish Time : 12:45PM Once this time slot has been allocated I need to be able to exclude this range from both of dropdown list i.e. Start time will now look as follows 11:30AM 01:00PM End time will be same. I already have the logic to ensure that the start and end time are not the same and also that the end time is after the start time but I am struggling to figure out how edit my dropdowns on the fly as time slots are allocated. Anybody help? Maybe a more simple method would be to only initially populate the start time dropdown and use the onchange method to populate the end time box? Would this be easier do you think? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Custome Message Box?
Not sure if I have posted this to the correct forum, so I apologise if I have not. The problem that I have is that I need to be able to display a customised pop-up message box on one of my CF pages. I have looked at Javscript (not enough options), VBScript (cannot change the default button text) and I am now thinking whether CSS is what I need. I need to be able to provide the user with a pop-up that gives the following options 'Edit', 'Delete' 'cancel'. The user cannot navigate from the page until an option is chosen so we are talking modal also. Can anyone make any suggestions on the best way to achieve this, if at all possible? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229138 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Custome Message Box?
Forgot to mention that this pop-up only appears as the result of an 'onClick' event. Not sure if I have posted this to the correct forum, so I apologise if I have not. The problem that I have is that I need to be able to display a customised pop-up message box on one of my CF pages. I have looked at Javscript (not enough options), VBScript (cannot change the default button text) and I am now thinking whether CSS is what I need. I need to be able to provide the user with a pop-up that gives the following options 'Edit', 'Delete' 'cancel'. The user cannot navigate from the page until an option is chosen so we are talking modal also. Can anyone make any suggestions on the best way to achieve this, if at all possible? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229139 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Custome Message Box?
Thanks for your help so far guy's. My instructions for this have now changed. I think that the following can be achieved by using a DIV and some Javascript maybe? You have a table cell, when the user hovers over the table cell a small sub-menu appears immediately below it that lists the following options 'Edit', Delete' some additional text as a description of the item being hovered over. When the user moves the mouse off the cell the menu disappears. Is this something that is better suited to DIV's and javascript and if so do I need to be asking in the CSS forum? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFSCRIPT Question
Thanks all for your feedback, this has definitely made me think again about the use of cfscript. I just suppose it is a comfort thing so while it is not detrimental I shall still use it. Thanks again. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 02 January 2006 19:51 To: CF-Talk Subject: RE: CFSCRIPT Question I was under the impression that there was a performance gain with cfscript, is that not the case? Is there no benefit to using cfscript? I haven't been able to determine any significant performance change one way or the other with CFMX. There may have been performance differences in prior versions of CF, and UDFs in CF 5 were generally much faster than similar CFML custom tags, but none of that applies to CFMX. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228173 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFSCRIPT Question
I was under the impression that there was a performance gain with cfscript, is that not the case? Is there no benefit to using cfscript? -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: 30 December 2005 19:03 To: CF-Talk Subject: Re: CFSCRIPT Question Probably not, could be debated that it was on older versions of CF. I personally am a cfscript nazi, use it a lot more than I really should. On 12/30/05, Ben Doom [EMAIL PROTECTED] wrote: Is it ever actually necessary? :-) --Ben ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228124 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFSCRIPT Question
I have a large block of cfscript that I now have to add a stored procedure call into the middle of. I normally use cfstoredproc elsewhere but how do I call a stored procedure from within cfscript? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFSCRIPT Question
how do I call a stored procedure from within cfscript? Wrap it in a cffunction tag and call it as a function. Paul Now I feel stupid, knew it would be something simple! Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227978 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Running a DTS package with CF
The following link should solve your problem for you. I found it extremely useful for executing DTS packages from CFM pages. http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS provides the scripts that you need. No credit to me but I hope it helps. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 29 December 2005 14:58 To: CF-Talk Subject: RE: Running a DTS package with CF There are ways to run DTS packages using a stored procedure. You may need to Google execute DTS package with stored procedure. I remember a past issue of CFDJ had an article about this. M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227862 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Rendering CFML extracted from a DB
Hi all, this is curious one for me. I am playing with app that needs to stores CFML strings in an SQL database like so, #translate('PageTwo','Nav','Report')# There is a query that returns these strings from the database and output's them to the page. Now this is where it goes wrong. The actual text output is #translate('PageTwo','Nav','Report')# - This is what appears on screen. This does not surprise me, what I need to know is whether it is possible to get this to work. What I would have to do to retrieve the data from the database, output the query AND makle sure that the 'translate' function gets called in order to display the correct text on screen? This is not a big deal if it is not possible, just curious if there some sort of render function for this type of thing similar to what is apparently available in BD. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225675 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rendering CFML extracted from a DB
Doh! Thanks both, why didn't I think of that? (skulks away sheepishly!) I'm not sure if this will help or not, but did you try CF's evaluate function? -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 6:35 AM To: CF-Talk Subject: Rendering CFML extracted from a DB Hi all, this is curious one for me. I am playing with app that needs to stores CFML strings in an SQL database like so, #translate('PageTwo','Nav','Report')# There is a query that returns these strings from the database and output's them to the page. Now this is where it goes wrong. The actual text output is #translate('PageTwo','Nav','Report')# - This is what appears on screen. This does not surprise me, what I need to know is whether it is possible to get this to work. What I would have to do to retrieve the data from the database, output the query AND makle sure that the 'translate' function gets called in order to display the correct text on screen? This is not a big deal if it is not possible, just curious if there some sort of render function for this type of thing similar to what is apparently available in BD. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225679 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rendering CFML extracted from a DB
I totally agree but in this instance it is not a risk as I have total control over what is or is not entered into the database. This is just to simplify life for me a little. I don't think this is possible - it would be security risk. Imagine if I could go into a CMS tool and upload my CFM which would then be parsed?! Not good. -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 30 November 2005 13:35 To: CF-Talk Subject: Rendering CFML extracted from a DB Hi all, this is curious one for me. I am playing with app that needs to stores CFML strings in an SQL database like so, #translate('PageTwo','Nav','Report')# There is a query that returns these strings from the database and output's them to the page. Now this is where it goes wrong. The actual text output is #translate('PageTwo','Nav','Report')# - This is what appears on screen. This does not surprise me, what I need to know is whether it is possible to get this to work. What I would have to do to retrieve the data from the database, output the query AND makle sure that the 'translate' function gets called in order to display the correct text on screen? This is not a big deal if it is not possible, just curious if there some sort of render function for this type of thing similar to what is apparently available in BD. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rendering CFML extracted from a DB
Yes, it most certainly did. Many thanks all. Did evaluate work? -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 30 November 2005 13:47 To: CF-Talk Subject: Re: Rendering CFML extracted from a DB I totally agree but in this instance it is not a risk as I have total control over what is or is not entered into the database. This is just to simplify life for me a little. I don't think this is possible - it would be security risk. Imagine if I could go into a CMS tool and upload my CFM which would then be parsed?! Not is #translate('PageTwo','Nav','Report')# - This is what appears on screen. This does not surprise me, what I need to know is whether it is possible to get this to work. What I would have to do to retrieve the data from the database, output the query AND makle sure that the 'translate' function gets called in order to display the correct text on screen? This is not a big deal if it is not possible, just curious if there some sort of render function for this type of thing similar to what is apparently available in BD. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225687 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Accented Characters
I use XML files all the time with accented characters. At the top of my XML file I have the following line ?xml version=1.0 encoding=iso-8859-1? The accented characters will be handled correctly. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 25 November 2005 10:41 To: CF-Talk Subject: Accented Characters Is there a simple way to replace accented characters with their un-accented counterpart? For example some titles in our database may contain a 'á' character and this works fine in the database and on the intranet, however it screws up XML files with invalid character errors so needs replacing with a simple 'a' in the XML. I could do this with a series of replace() actions but with 5 vowels, 3-4 different accents and two cases this would mean up to 40 replaces being performed and I can't help thinking there must be an easier way. -- Jay ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Yet another RegEx problem (But I nearly have it!)
Hi all, I have to need to do the following; Change all instances of cfprocparam type=IN value=#whatever# cfsqltype=CF_SQL_WHATEVER [EMAIL PROTECTED] to become cfprocparam type=IN value=#whatever# cfsqltype=CF_SQL_WHATEVER In dreamweaver I am trying to use the find replace using a regular expression, this is what I have come up with so far [EMAIL PROTECTED] this works to a point but it gives me this cfprocparam type=IN value=#whatever# cfsqltype=CF_SQL_WHATEVER Notice the closing chevron is still on the original line. How do I get rid of the carriage return and all of the whitespace as well to get the chevron to appear at the end of cfsqltype statement? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Yet another RegEx problem (But I nearly have it!)
No, I did not know this! I will have see if I can find where it is, thanks. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 25 November 2005 17:16 To: CF-Talk Subject: RE: Yet another RegEx problem (But I nearly have it!) Hi all, I have to need to do the following; Change all instances of cfprocparam type=IN value=#whatever# cfsqltype=CF_SQL_WHATEVER [EMAIL PROTECTED] to become cfprocparam type=IN value=#whatever# cfsqltype=CF_SQL_WHATEVER In dreamweaver I am trying to use the find replace using a regular expression, this is what I have come up with so far [EMAIL PROTECTED] this works to a point but it gives me this cfprocparam type=IN value=#whatever# cfsqltype=CF_SQL_WHATEVER Notice the closing chevron is still on the original line. How do I get rid of the carriage return and all of the whitespace as well to get the chevron to appear at the end of cfsqltype statement? You do know that Dreamweaver will allow you to remove specific attributes of specific tags directly within Find Replace, right? You don't have to write a regex to do this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: Rumors from Max...
From my personal experience I have to say that the help support offered by Bluedragon is second to none, the willingness and eagerness to help is a total breath of fresh air. Regardless of whether Coldfusion goes open source or not I for one prefer to know that there is someone 'from the company' available for help. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Blue Dragon and Fusebox
Thanks Charlie, sorry about the posting thing but I was getting desperate to get answers due to pressure from above. If I cannot prove that I can easily port an existing fusebox application (or any other existing coldfusion app for that matter) over to Bluedragon by end of play this week then I will have to abandon my testing and take the Coldfusion 7 upgrade, just getting a little frustrated with losing time on what are essentially little problems. By the way, you mention that there is a fix to come out in BD but what I need to confirm is whether my work around is considered an acceptable practice or should I just remove the locks? -Original Message- From: charles arehart [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 22:24 To: CF-Talk Subject: Re: Blue Dragon and Fusebox Andy, the problem isn't with duplicating sessions, per se, and it's not a ..NET issue. There is a bug (fixed in the upcoming 6.2.1 release) in both Java and .NET editions, and it only appeared if you were using a CFLOCK around the code attempting to duplicate the session. Now, someone may say but shouldn't you ALWAYS lock access to session variables?, and the answer is no, as discussed in a technote from mm at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18235. While that was written for CFMX, it applies to BD as well. You still want to lock, but only for race conditions. Anyway, as of 6.2.1 (due out in beta soon), you can continue to lock and duplicate to your heart's content. :-) Finally, let me plead that you please bring up such issues on the BlueDragon Interest list. We don't always get to monitor all the traffic on CF-talk, but our engineers always watch and respond to issues brought up on our list. Not meaning to prevent discussion here, just saying that if you have an urgent need for support, you're MUCH better asking there, and of course, it's free. /charlie OK, I think I have figured this out by using 'StructCopy' instead of 'Duplicate'. Do we have any Bluedragon guru's on this forum who could help me out with a number of issues that I have with trying to migrate to Bluedragon? -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 17:38 To: CF-Talk Subject: Re: Blue Dragon and Fusebox Did you ever get a solution to this? I too am having the same problem with a fusebox 4.1 app running on Bluedragon 6.2 .NET that is choking when trying to execute the following code cfset request.session = duplicate(session) It just seems to be a problem with the 'duplicate' function? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222819 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Happy Halloween - Lighthouse Pro released
Would it just be a question of converting application.cfc back to application.cfm to get this to work in 6.1 or is there more to it? -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: 01 November 2005 12:10 To: CF-Talk Subject: Re: Happy Halloween - Lighthouse Pro released I just read that it's MX7 so I won't be using it for awhile yet, but when we do upgrade, I'd like to use it. And if I update the queries, I'll forward them. All of the SQL is contained within the CFCs - so it should be rather trivial. Only a few queries, if I remember right, do anything complex. So it's probably 2-3 queries you would need to update. On 11/1/05, daniel kessler [EMAIL PROTECTED] wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222823 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Blue Dragon and Fusebox
Did you ever get a solution to this? I too am having the same problem with a fusebox 4.1 app running on Bluedragon 6.2 .NET that is choking when trying to execute the following code cfset request.session = duplicate(session) It just seems to be a problem with the 'duplicate' function? Okay, we have made some progress on this BlueDragon issue. When we try to call just the index.cfm without a fuseaction, the error changes. The new error we are running into is listed below, and the code causing the error is listed below that. I could be wrong, but it appears BlueDragon does not treat the CF application scope as a structure, at least not when it is in a CFLOCK. Is anyone else copying the application scope to a request variable in BlueDragon? Anyways: Error - Request /web/index.cfm File Trace C:/Program Files/New Atlanta/BlueDragon_Server/wwwroot/web/index.cfm | +-- C:/Program Files/New Atlanta/BlueDragon_Server/wwwroot/web/fbx_fusebox30_CF50.cfm | +-- C:/Program Files/New Atlanta/BlueDragon_Server/wwwroot/web/fbx_Settings.cfm Type Application Message General Runtime Error Tag Context CFPROCESSINGDIRECTIVE: Line=22; Column=7 | +-- CFINCLUDE: Line=26; Column=1 | +-- CFPROCESSINGDIRECTIVE: Line=1; Column=37 | +-- CFTRY: Line=158; Column=1 | +-- CFINCLUDE: Line=159; Column=2 | +-- CFSILENT: Line=10; Column=1 | +-- CFLOCK: Line=23; Column=1 | +-- CFSCRIPT: Line=24; Column=2 Detail Could not duplicate this variable. Check the variable does not contain references to complex types such as Java objects Extended Info Source 21: } 22: /cfscript 23: cflock scope=application timeout=20 type=READONLY 24: cfscript 25: if(isdefined(application)){ ^ Snippet from underlying CFML source - Code - cfscript if(isdefined(frm_logout_user)){ structdelete(session,'user'); request.deleted_userinfo = 1; } if(isdefined(session)){ structinsert(request, session, duplicate(session)); } if(not isdefined(attributes.fuseaction)){ structinsert(attributes, fuseaction, home.main); } /cfscript cflock scope=application timeout=20 type=READONLY cfscript if(isdefined(application)){ structinsert(request, application, duplicate(application)); } /cfscript /cflock - End Error and Code - M Vince - Thanks for the response. I think the problem is more complicated than that, createObject() is not used anywhere in the code. M ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Blue Dragon and Fusebox
Did you ever get a solution to this? I too am having the same problem with a fusebox 4.1 app running on Bluedragon 6.2 .NET that is choking when trying to execute the following code cfset request.session = duplicate(session) It just seems to be a problem with the 'duplicate' function? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Blue Dragon and Fusebox
OK, I think I have figured this out by using 'StructCopy' instead of 'Duplicate'. Do we have any Bluedragon guru's on this forum who could help me out with a number of issues that I have with trying to migrate to Bluedragon? -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 17:38 To: CF-Talk Subject: Re: Blue Dragon and Fusebox Did you ever get a solution to this? I too am having the same problem with a fusebox 4.1 app running on Bluedragon 6.2 .NET that is choking when trying to execute the following code cfset request.session = duplicate(session) It just seems to be a problem with the 'duplicate' function? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222761 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Source Control Theory.....
I have used VSS virtually from day one and have never yet had any problems with it, not a single corruption. I can confirm that what Neil states below is correct in so far as if you have access to the admin login you can easily checkin/checkout files checked out by another user and have multiple checkouts. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 27 October 2005 12:00 To: CF-Talk Subject: RE: Source Control Theory. Well, logging in as Admin would have solved the first problem of checking in a file checked out by another user (all depends on client/server setup I suppose) - but you can certainly check an on vacation users file yourself. VSS,does support multiple checkouts - so I am not sure where your problem their was? Corrupt code, I have never had but I hear it can happen with certain file types. Hopefully VSS 7 will sort that out ;-) -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: 27 October 2005 11:58 To: CF-Talk Subject: Re: Source Control Theory. I have also had some very bad experiences with VSS. Two specific problems that I've had: A developer checked out some code and didn't check it back in before going on holiday. This caused us a lot of headaches because we didn't have the password for his machine and he'd checked out stuff that a lot of other people needed to work with. VSS completely corrupted the source code for a project I was working on a few years ago. Again, this caused us a lot of headaches because we had lost the complete change history for the project. The VSS workflow doesn't work well for me either because it requires that you organize yourselves in such a way that two people never have the same code checked out. My experience has been that allowing multiple developers to check out and work on the same code is much more productive. Spike On 10/27/05, Massimo Foti [EMAIL PROTECTED] wrote: What does SVN give you that VSS does not? http://svnbook.red-bean.com/en/1.1/ch02s02.html VSS use Lock-Modify-Unlock, SVN can use both Copy-Modify-Merge and Lock-Modify-Unlock. I very much prefer the Copy-Modify-Merge approach, but it's a matter of personal preferences. Multiple languages binding and WEBDAV integration could also be a plus. Personally I also had some very bad experiences with VSS corrupting data, but this doesn't necessarely apply to others. Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222412 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any Interest in a Completely Free CFML Calendar?
I would definately be interested as I am just about to start a project that would require me to write my own calendar and this would be a great help! The downloads don't work on the site though, is it not yet available? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221922 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFC - separate or all in one?
This thread caught my eye and I would like to add a question of my own if I may. I am relatively new to CFC's and am still getting my head around them. I have written CFC's that only contain database calls in individual functions that are all relative to specific areas of my site, so I have a CFC called matchreport.cfc that handles all select, insert, update delete database calls, this is all that the CFC does, is there anything fundamentally wrong with doing this or is there a better way to handle this? -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: 21 October 2005 01:46 To: CF-Talk Subject: RE: CFC - separate or all in one? They can be good for both, can't they? ;^) Fair enough -- I guess I meant that always using them as a library of functions is the trap many new users (e.g. me) fall into when first using CFCs. You can create utility CFCs that don't maintain state and are effectively just a collection of related methods. CFCs for manipulating images are often like this. In JavaScript, the Math class is a good example. I would suggest that as a general guideline, very few of your CFCs should be written like this. I'd also recommend you keep them in a separate folder, so you know you don't have to initialise them. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: WHAT'S WRONG WITH THIS QUERY?
You just need to rewrite the query, here is an example from SQL BOL CREATE TABLE s (ColA INT, ColB DECIMAL(10,3)) GO CREATE TABLE t (ColA INT PRIMARY KEY, ColB DECIMAL(10,3)) GO INSERT INTO s VALUES(1, 10.0) INSERT INTO s VALUES(1, 20.0) INSERT INTO t VALUES(1, 0.0) GO UPDATE t SET t.ColB = t.ColB + s.ColB FROM t INNER JOIN s ON (t.ColA = s.ColA) GO So your code should look something like UPDATE NewProduct np SET np.details = op.details FROM np INNER JOIN op ON np.dealerpartno = op.dealerpartno Have not tested, just written it here based upon the example, hope it helps. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 20 October 2005 14:17 To: CF-Talk Subject: RE: WHAT'S WRONG WITH THIS QUERY? I was always under the impression that you couldn't join tables in anything other than a SELECT query. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Nomad [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 6:04 PM To: CF-Talk Subject: WHAT'S WRONG WITH THIS QUERY? Hello, This query works fine with Access. With SQL server it creates an error. Here's the query: UPDATE NewProduct INNER JOIN OldProduct ON NewProduct.dealerpartno = OldProduct.dealerpartno SET NewProduct.details = OldProduct.details Much appreciate any help in debuging. Thanks in advance. Ben ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221634 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Coldfusion 7 CFTREE
Can anybody point me to a source of any examples of using CFTREE in Coldfusion 7? I am following the documentation but I cannot for the life of me get it to apear correctly on my page, I have set the height to 400 and the width to 200 but I still get an awful lot of space below my control which is pushing my other code down the page. I cannot seem to get it to position correctly, any ideas what I am doing wrong? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221666 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Loop through a structure of structures
Nice tidy Alex, thanks, I'll use this. :-) -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 20:05 To: CF-Talk Subject: Re: Loop through a structure of structures Try this: [CFLOOP collection=RSStructure item=itm] [cfset thisQuery =RSStructure[itm]] [cfoutput query =thisQuery] .. query output code here [/cfoutput] [/CFLOOP] Hope this helps. -- Alex Andy Mcshane wrote: Hi all, I think I have been looking at this for too long and cannot figure out how to loop through and output a structure of query results. I have a CFC that will return multiple recordsets. I figured that the only way that I could return multiple recordsets from a CFC was to return them within a structure. My query runs inside my CFC and returns 17 individual recordsets. I create a structure and add each of these recordsets to it so my structure now looks like this; RSStructure RS1 query - Rows 2 AGE ID NAME 1 221 Wibble 2 212 Wobble RS2 query - Rows 3 AGE ID NAME 1 223 Wibble 2 214 Wobble 3 305 Woo RS3 query - Rows 3 AGE ID NAME 1 346 Wibble 2 237 Wobble 3 338 Woo This continues until I have 17 recordsets within my structure. I then return this structure to my calling page. Now I must be having a really brain dead day because for the life of me I cannot remeber how to reference each of my recordsets within this structure so that I can output the data, it must be simple but then again so must I be at the moment! Can anybody help this flagging programmer? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220876 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFC Lifecycle
Just a quick question to help clear, hopefully, the last of the muddy waters with regards to how CFC's work. A CFC that is initialized and stored within the application/session scope is then available to use everywhere as required. Now I just want clarification on CFC's created at page level. If I create an instance of a CFC on my page, carry out some processing and then do cflocate to another page am I correct in assuming that my CFC instance is now gone and if I wish to re-use it I must create another instance of it? I am just a little confused on the whole lifecycle bit of CFC's, can anyone provide some clarity? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220877 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFC Lifecycle
Thanks all, this clears things up and re-enforces what I thought was correct. ;-) ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220893 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Loop through a structure of structures
Hi all, I think I have been looking at this for too long and cannot figure out how to loop through and output a structure of query results. I have a CFC that will return multiple recordsets. I figured that the only way that I could return multiple recordsets from a CFC was to return them within a structure. My query runs inside my CFC and returns 17 individual recordsets. I create a structure and add each of these recordsets to it so my structure now looks like this; RSStructure RS1 query - Rows 2 AGE ID NAME 1 221 Wibble 2 212 Wobble RS2 query - Rows 3 AGE ID NAME 1 223 Wibble 2 214 Wobble 3 305 Woo RS3 query - Rows 3 AGE ID NAME 1 346 Wibble 2 237 Wobble 3 338 Woo This continues until I have 17 recordsets within my structure. I then return this structure to my calling page. Now I must be having a really brain dead day because for the life of me I cannot remeber how to reference each of my recordsets within this structure so that I can output the data, it must be simple but then again so must I be at the moment! Can anybody help this flagging programmer? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220801 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Loop through a structure of structures
I really am having a bad day, as soon as I clicked submit I solved my own problem! I feel like a total waste of bandwidth today! Nurse! Hi all, I think I have been looking at this for too long and cannot figure out how to loop through and output a structure of query results. I have a CFC that will return multiple recordsets. I figured that the only way that I could return multiple recordsets from a CFC was to return them within a structure. My query runs inside my CFC and returns 17 individual recordsets. I create a structure and add each of these recordsets to it so my structure now looks like this; RSStructure RS1 query - Rows 2 AGE ID NAME 1 221 Wibble 2 212 Wobble RS2 query - Rows 3 AGE ID NAME 1 223 Wibble 2 214 Wobble 3 305 Woo RS3 query - Rows 3 AGE ID NAME 1 346 Wibble 2 237 Wobble 3 338 Woo This continues until I have 17 recordsets within my structure. I then return this structure to my calling page. Now I must be having a really brain dead day because for the life of me I cannot remeber how to reference each of my recordsets within this structure so that I can output the data, it must be simple but then again so must I be at the moment! Can anybody help this flagging programmer? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220805 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Loop through a structure of structures
Thanks, I just realised that before I posted again, God alone knows what I thought I was trying to do with it earlier! The 17 recordsets are all returned via one stored procedure call within the CFC so there really is only DB call, couldn't do it any other way as the data that is returned is keyed on a position on screen so I have to get all top row, middle row, etc data. Reference each query through the structure perhaps? Does this work? cfoutput query=structurename.RS1 /cfoutput cfoutput query=structurename.RS2 /cfoutput But this begs the question, why are there 17 recordsets? Might a single query do the job? Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220806 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: i18n problem - utf-8 chars not displaying correctly
In SQL2000 you can actually change the collation of individual columns within individual tables. I am not sure exactly which collation you would need but if you can open SQL enterprise manager, find the table that you are storing this data into, right-click on the table and select 'Design table'. Once the table is open in design mode, select the column that you wish to change the collation for and at the bottom of the design view the 'collation' box should become active. Click inside the collation box and a button should appear next it. Click this button to access a list of available collations. You will have to look in BOL to check which collation type is suitable for which character sets but that is how easy in SQL2000 it is to change collation. Hope this helps! P.S different collation types on table columns can cause errors when using those columns in a table join. -Original Message- From: Duncan [mailto:[EMAIL PROTECTED] Sent: 04 October 2005 10:03 To: CF-Talk Subject: i18n problem - utf-8 chars not displaying correctly We are converting our site to 16 different languages and are having problems with a few odd characters. The only way we can get the chars to display correctly is by entering them in to SQL Server 2000 using th N'string in here' notation. But that means you cant do a select * from x where lang like '%dodgy char here%' on the field. An example with this would be Hungarian megfelel#337; megfelel#337; is inserted as megfelelo, however on doing select hungarian from languages where hungarian like '%megfelel#337;%' we can match the word. If we enter it as( using the N' notation ) N'A megadott kritériumok alapján nem találtunk megfelel#337;' we cant match on it however it displays correctly on web pages. We would like to not use the N' notation - how can this be acheived? the db collation is SQL_Latin_General at the moment - I have a bad feeling this is the problem and its not easy to change? the page encoding is set in cf with utf-8 - but I am at a loss to other ideas. Any help greatly appreciated -- Duncan I Loxton www.sixfive.co.uk http://www.sixfive.co.uk [EMAIL PROTECTED] I can only please one person per day. Today is not looking good. Tomorrow isn't looking much better. Dilbert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219994 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: i18n problem - utf-8 chars not displaying correctly
I currently run a site that uses English, French, German, Italian Spanish. The collation setting that I use, for the applicable columns, is 'Modern_Spanish_CI_AI', everything else uses the database default. This has so far covered all of my problems that I encountered whilst performing searches, i.e. making sure that a search for '%sire' returns both 'Desire' and 'Desiré', treating the 'e' and 'é' the same. I do not think that you will have to use different encoding for every language, as I said the above encoding works for my 5 languages, but you may have to use different ones for Chinese characters, I am not sure as I have never explored storing that language in the database. I found this link gave me a clearer understanding, http://www.itworld.com/AppDev/136/ITW3856/ Type 'SQL 2000 Collation' in Google. There is tons of info about SQL 2000 collation settings, including the pitfalls which you must be aware of to try and avoid issues later on!. I am sorry I can't be of more help but I think it should be a straight forward issue to resolve for you. :-) -Original Message- From: Duncan [mailto:[EMAIL PROTECTED] Sent: 04 October 2005 10:28 To: CF-Talk Subject: Re: i18n problem - utf-8 chars not displaying correctly Nice one Andy thats certainly an option. I suppose it would fit well to because we will be doing everything from French to Traditional Chinese, so I guess we would want chinese to use Big5 and an encoding relevant to that. Having said that I thought UTF-8 would cover all possible characters due to its triple byte storage method? Would it be necessary to use individual encodings for each language? On 10/4/05, Andy McShane [EMAIL PROTECTED] wrote: In SQL2000 you can actually change the collation of individual columns within individual tables. I am not sure exactly which collation you would need but if you can open SQL enterprise manager, find the table that you are storing this data into, right-click on the table and select 'Design table'. Once the table is open in design mode, select the column that you wish to change the collation for and at the bottom of the design view the 'collation' box should become active. Click inside the collation box and a button should appear next it. Click this button to access a list of available collations. You will have to look in BOL to check which collation type is suitable for which character sets but that is how easy in SQL2000 it is to change collation. Hope this helps! P.S different collation types on table columns can cause errors when using those columns in a table join. -Original Message- From: Duncan [mailto:[EMAIL PROTECTED] Sent: 04 October 2005 10:03 To: CF-Talk Subject: i18n problem - utf-8 chars not displaying correctly We are converting our site to 16 different languages and are having problems with a few odd characters. The only way we can get the chars to display correctly is by entering them in to SQL Server 2000 using th N'string in here' notation. But that means you cant do a select * from x where lang like '%dodgy char here%' on the field. An example with this would be Hungarian megfelel#337; megfelel#337; is inserted as megfelelo, however on doing select hungarian from languages where hungarian like '%megfelel#337;%' we can match the word. If we enter it as( using the N' notation ) N'A megadott kritériumok alapján nem találtunk megfelel#337;' we cant match on it however it displays correctly on web pages. We would like to not use the N' notation - how can this be acheived? the db collation is SQL_Latin_General at the moment - I have a bad feeling this is the problem and its not easy to change? the page encoding is set in cf with utf-8 - but I am at a loss to other ideas. Any help greatly appreciated -- Duncan I Loxton www.sixfive.co.uk http://www.sixfive.co.uk http://www.sixfive.co.uk [EMAIL PROTECTED] I can only please one person per day. Today is not looking good. Tomorrow isn't looking much better. Dilbert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
Thanks all for your help so far. Now I have been looking at the documentation for encrypt/decrypt and I would like to use one of the more secure encryption algorithms, such as BLOWFISH or DES. I notice that the more secure algorithms use the function GenerateSecretKey. Now do this mean that when the text is encrypted it is a one way process? I assume that the GenerateSecretKey function will always return a different key so does this mean that I cannot then decrypt my data when I retrieve it from the database? I am getting somewhat confused here. :-( ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: product name
Yahoo, Pub Crawl When do we start -Original Message- From: Webmaster at FastTrack On Line [mailto:[EMAIL PROTECTED] Sent: 27 September 2005 13:00 To: CF-Talk Subject: Re: product name And ... go on the biggest pub/brewery crawl in history? - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 26, 2005 11:21 PM Subject: RE: product name -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 24, 2005 1:01 PM To: CF-Talk Subject: RE: product name [snip] Personally I'd try to stick with your broader convention... so right now that means something onTap. Personally, I'm waiting for the Beer onTap application to come out. C'mon, Isaac! Well once we have a system for storing international contact information, we can amass a huge database of all the contact information for breweries and microbreweries the world over and... :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: product name
Sorry, too drunk, meant where do we start -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: 27 September 2005 14:15 To: CF-Talk Subject: Re: product name Whaddayamean, when??? With the way my project is going lately, I try to get started on my way to work!!! --Ferg Andy McShane wrote: Yahoo, Pub Crawl When do we start -Original Message- From: Webmaster at FastTrack On Line [mailto:[EMAIL PROTECTED] Sent: 27 September 2005 13:00 To: CF-Talk Subject: Re: product name And ... go on the biggest pub/brewery crawl in history? - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 26, 2005 11:21 PM Subject: RE: product name -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 24, 2005 1:01 PM To: CF-Talk Subject: RE: product name [snip] Personally I'd try to stick with your broader convention... so right now that means something onTap. Personally, I'm waiting for the Beer onTap application to come out. C'mon, Isaac! Well once we have a system for storing international contact information, we can amass a huge database of all the contact information for breweries and microbreweries the world over and... :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Weird Encrypt/Decrypt problem!
Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219225 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
Checked that, both the variable in my stored procedure and the column in my DB table are set to nvarchar(100). I did originally think that this may be it but when I tried different length strings, strings that were longer shorter than 10 characters worked fine, that is what is so weird. If you use my example data you can easily replicate the issue. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 26 September 2005 12:57 To: CF-Talk Subject: RE: Weird Encrypt/Decrypt problem! From: Andy Mcshane [mailto:[EMAIL PROTECTED] This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? Check to ensure that the length of the column in your database is large enough to hold the encrypted string since the length of the encrypted string does not always equal the length of the original string. HTH, Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
I am glad at least that somebody else has managed to replicate it and I am not going mad! Probably just my luck that it only affected the 10 character strings that I tried. I will have to look into a more robust encryption method. -Original Message- From: Fabio Terracini [mailto:[EMAIL PROTECTED] Sent: 26 September 2005 14:45 To: CF-Talk Subject: Re: Weird Encrypt/Decrypt problem! Whoa. So weird I also tested here, and the encoded johnmurray was decoded to johnmurrax! It's not with all 10 charcs. string, by the way. I think this is a CF default algorithm (CFMX_COMPAT, which is compatible do earlier versions of CF) implementation bug. You should use a more secure and standard algorithm, like TripleDES. Check out the Encrypt() documentation. -- Fabio Terracini Andy Mcshane wrote: Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt/Decrypt Suggestions (WAS Weird Encrypt/Decrypt problem!)
OK, follow up to this, can anybody suggest ways that they currently encrypt/decrypt sensitive data? I need to encrypt the data to save into the database and then at a later date retrieve that data, decrypt it and let the user edit it. I have looked at using the various algorithms excluding CFMX_COMPAT but I notice that uses the GenerateSecretKey function. I am assuming that the key that is generated is different every time therefore once I have encrypted the data, if I do not save the original key then when I come to decrypt the data it will use a different key and so fail? Or am I completely wrong here? Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Passing a query result to a CFC?
Hi all, I have one CFC that executes a database call and returns a recordset, I need to process that recordset using a different CFC. I am not sure how best to do this. Can I pass the results fo a query between CFC's or can I just reference the recordset from my other CFC as they are called from the same page? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Site-wide error handler?
Thanks for sharing that code Matt, it is exactly what I have been looking for so I will continue to search for what I have done wrong to stop it working. I do have the other templates inside of the same directory so I think that I must be triggering another error apart from my intended one and so I will try to locate that. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 16 September 2005 21:59 To: CF-Talk Subject: Re: Site-wide error handler? Hi Andy, I wrote that handler, and it runs on a bunch of CF 6.1 servers and on some others I manage that are on CF5. I just looked at my own server's code and it follows that model pretty much exactly. Are you putting your included display pages in the same folder as the site-wide error handler? Or are you putting them in with the domain? If the site-wide handler is in c:/cfusionmx/wwwroot/myerrors/ then all of your include files have to be there as well if you are calling them as you are in that code. There's no problem with cfsavecontent. I've been using it in this context for ages. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218591 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Site-wide error handler?
Good call, I will try that also. -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: 19 September 2005 00:49 To: CF-Talk Subject: Re: Site-wide error handler? The problem is my pretty error page does not get display, the egenric ugly coldfusion page always appears and I do not know why. Have you tried using a cferror tag in your application.cfm page? That will also help isolate whether the problem is the error handler, or the call to it. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Site-wide error handler?
OK, a follow-up. This just confuses me even more. Did I mention that I was using Coldfusion 7? Anyway, trying to debug DumpMonger as you suggested. Do not understand why this is happening but if I comment out the cfsavecontent tags then all of the relevant structures are output to the screen and the ugly standard coldfusion error message is displayed at the bottom of the page still. If I leave the cfsavecontent tags in and then try to dump the cfsavecontent variable nothing is displayed except the ugly standard coldfusion error. I cannot see what I am doing wrong here, using those immortal words that we all use at somepoint 'this code should work!'. Does anyone know of any problem with Coldfusion 7 and site-wide error handling, I do not have a development CFMX box to try it on at the moment? -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: 19 September 2005 10:10 To: CF-Talk Subject: RE: Site-wide error handler? Thanks for sharing that code Matt, it is exactly what I have been looking for so I will continue to search for what I have done wrong to stop it working. I do have the other templates inside of the same directory so I think that I must be triggering another error apart from my intended one and so I will try to locate that. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 16 September 2005 21:59 To: CF-Talk Subject: Re: Site-wide error handler? Hi Andy, I wrote that handler, and it runs on a bunch of CF 6.1 servers and on some others I manage that are on CF5. I just looked at my own server's code and it follows that model pretty much exactly. Are you putting your included display pages in the same folder as the site-wide error handler? Or are you putting them in with the domain? If the site-wide handler is in c:/cfusionmx/wwwroot/myerrors/ then all of your include files have to be there as well if you are calling them as you are in that code. There's no problem with cfsavecontent. I've been using it in this context for ages. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Site-wide error handler?
More info, tries it on an MX server, same result. I am forcing an error by trying to output a variable from a query that does not exist. If my only have my standard error page that I use now in the ErrorHandler directory everything is displayed correctly, it only goes wrong when I try to use the DataMonger page, go figure? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Your experience of Bluedragon.net?
Just got caught out with something that I didn't expect. I am testing one of our older sites on Bluedragon and the original coder of this site used dbvarname in all of the stored procedure calls. Now I knew that this was deprecated in CF but Bluedragon, I assume because of the .NET framework, was actually matching this fields with the parameter names in the stored procedures, which as you guess, didn't match! Small problem that a find replace with a regular expression won't fix. :-) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 16 September 2005 10:43 To: CF-Talk Subject: Re: Your experience of Bluedragon.net? On Thursday 15 September 2005 17:01, Matt Robertson wrote: I have done that, but they have to be running on different ports. The J2EE version's will run in the same container, but at different context roots though, I would guess. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Site-wide error handler?
Hi I am trying to implement a site-wide error handler for a dedicated server running only 2 related aplications on a Coldfusion 7/Win2k3 setup. I have been trying to use the code I found at 'http://mysecretbase.com/building_a_coldfusion_error_handler.cfm'. All works fine up to a point. This error handler basically executes a generic error.cfm page which in turn includes a datadump page, that has options for handling the error data, and then includes my pretty looking error page informaing the user that an error has occurred. The problem is my pretty error page does not get display, the egenric ugly coldfusion page always appears and I do not know why. My error.cfm page has the following code; cfswitch expression=#cgi.Server_Name# cfcase value=mydomain.com,anotherdomain.com cfparam name=request.dumpMode default=STANDARD type=string cfscript request.emailTo=[EMAIL PROTECTED]; request.emailFrom=[EMAIL PROTECTED]; request.emailServer=mail.mydomain.com; /cfscript cfinclude template=dumpmonger.cfm cfinclude template=error_dsp01.cfm /cfcase cfcase value=yetanotherdomain.com cfparam name=request.dumpMode default=ONSCREEN type=string /cfcase cfdefaultcase cfparam name=request.dumpMode default=SECURE type=string cfscript request.emailTo=[EMAIL PROTECTED]; request.emailFrom=[EMAIL PROTECTED]; request.emailServer=mail.foohbar.gov; /cfscript cfinclude template=dumpmonger.cfm cfinclude template=error_dsp02.cfm /cfdefaultcase /cfswitch My datadump page has the following code; cfparam name=request.dumpMode default= type=string cfparam name=request.emailTo default= type=string cfparam name=request.emailFrom default= type=string cfparam name=request.emailServer default= type=string cflock scope=SERVER type=READONLY timeout=10 cfset variables.CFVer=Left(server.coldfusion.ProductVersion,1) /cflock cfscript request.vars=CFCATCH,ERROR,APPLICATION,ATTRIBUTES,CALLER,CGI, CLIENT,FORM,REQUEST,SESSION,THIS,THISTAG,URL,VARIABLES; request.theFileName=Replace(CreateUUID(),-,,all); request.errorDirectory=c:/cfusionmx/wwwroot/myerrors/; request.errorDomain=https://www.mydomain.com/errors/;; /cfscript cfsavecontent variable=variables.dataDump cfloop list=#request.vars# index=loopItem cfif IsDefined(#loopItem#) cfif Compare(variables.CFVer,6) OR Compare(variables.CFVer,7) brbrcfoutputb#loopItem#/b/cfoutput /cfif cfdump var=#Evaluate(loopItem)# label=#loopItem# /cfif /cfloop /cfsavecontent cffile action=write file=#request.errorDirectory##request.theFileName#.html output=#variables.dataDump# cfswitch expression=#request.dumpMode# cfcase value=STANDARD cfmail to=#request.emailTo# from=#request.emailFrom# subject=#cgi.server_name# Error server=#request.emailServer# type=HTML mimeattach=#request.errorDirectory##request.theFileName#.html p a href=#request.errorDomain#list.cfm See complete error list /a /p /cfmail /cfcase cfcase value=SECURE cfmail to=#request.emailTo# from=#request.emailFrom# subject=#cgi.server_name# Error server=#request.emailServer# type=HTML p a href=#request.errorDomain##request.theFileName#.html See It /a /p p a href=#request.errorDomain#list.cfm See complete error list /a /p /cfmail /cfcase cfcase value=ONSCREEN cfoutput #variables.dataDump# /cfoutput /cfcase /cfswitch After this my error_dsp01.cfm page should be displayed but never is. If I remove all of the code from my datadump page from the start of the cfsavecontent tage to the end then the pretty error page is displayed. Is there a problem using cfsavecontent in this page? This is driving my nuts! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf_twoselectsrelated
I have sent you one off list, hope it is what you are looking for. -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 20:43 To: CF-Talk Subject: cf_twoselectsrelated Does anyone have a version of cf_twoselectsrelated (or something similar) that accepts a parameter to 'preselect' records in the second select depending upon what is selected in the first? Thanks. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218386 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your experience of Bluedragon.net?
This is good stuff guy's, thanks. If I understand correctly Bluedragon can be configured on a per site basis so my next question is has anyone had Bluedragon Coldfusion running on the same server or have I completely got the wrong end of the stick? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Do Not Include CFID CFTOKEN in URL?
Hi all, I have searched the archives and although I see many questions answers with regards to my question I have not found a definitive one. I do not want to display the CFID CFTOKEN in my URL string. I am running both Coldfusion MX Coldfusion 7. Here is a snipet of my application settings; clientmanagement = true clientstorage = mydatabase setclientcookies = true I am also using the following code to ensure that my tokens are renewed if the browser is closed cfif isdefined(cookie.CFID) AND isdefined(cookie.CFTOKEN) cfset localcfid = cookie.CFID cfset localtoken = cookie.CFTOKEN cfcookie name=CFID value=#localcfid# cfcookie name=CFTOKEN value=#localtoken# /cfif Now I think I may be confused on exactly what happens here and where my tokens are being stored. I thought that my server side tokens are held within my database and my client side tokens are held within cookies. If this is the case why are CFID CFTYOKEN included in my URL? Would this behaviour be characteristic if cookies were disabled on the client machine (even though they are enabled on my test machine)? If I cannot remove these from my URL can anybody suggest ways of masking them in the URL or even better a good method for encrypting the entire URL so nothing can be tampered with? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218162 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When to use Application var?
Personally, if your information is unlikely to change on any regular basis then I would use the application scope. As for having too much in the app.scope I suppose it really depends on the machine and how much memory you have to play with. If what you have below is all that have in the app scope then there should be no problem at all. -Original Message- From: Andy Jarrett [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 10:08 To: CF-Talk Subject: When to use Application var? I have a bit of code on a smallish, low hit site cfset thisSiteName = ListGetAt(cgi.script_name, 1, /)/ cfif NOT application.init OR structKeyExists(url, reinit) cfquery datasource=#variables.dsn# name=thisCompany SELECT * FROM companydetails c WHERE c.company_folder = '#thisSiteName#' /cfquery cfset application.companyName = thisCompany.company_name / cfset application.companyWebsite = thisCompany.company_website / cfset application.companyEmail = thisCompany.company_email / cfset application.companyId = thisCompany.company_uid / cfset application.companyfolder = thisCompany.company_folder / cfset application.company_prerefix = thisCompany.company_prefix / cfset application.init = 1 /cfif It just sets up some basic site wide vars - nothing special. What im thinking though is that this is just a bad use of the application scope? Surely i could just use cfquery datasource=#variables.dsn# name=thisCompany cachedWithin=#createTimeSpan(2,0,0,0)# SELECT * FROM companydetails c WHERE c.company_folder = '#thisSiteName#' /cfquery cfset request.companyName = thisCompany.company_name / cfset request.companyWebsite = thisCompany.company_website / cfset request.companyEmail = thisCompany.company_email / cfset request.companyId = thisCompany.company_uid / cfset request.companyfolder = thisCompany.company_folder / cfset request.company_prerefix = thisCompany.company_prefix / Which would save the having too much in the app.scope? Am i missing something obvious? What would/does everyone else do? Andy J www.andyjarrett.co.uk ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218164 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Do Not Include CFID CFTOKEN in URL?
All the places that I am using cflocation have addtoken=no. The CFID CFTOKEN are appearing in the URL regardless of whether I use cflocation or not :-( I am getting real hassle from a customer who for some reason is insisting that they are visible in the URL and I cannot get rid of them, please help! Oh, by the way, cookies will always be on, they cannot access the site without them being switched on. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 11:56 To: CF-Talk Subject: RE: Do Not Include CFID CFTOKEN in URL? If your CFID CFToken are in the url then you have used cflocation without the attribute addtoken=False. On a side note these are normally used in the url for people who have cookies disabled, so if your not worried about this then set all your addtoken=false in your code. Otherwise you will need to look at a way of handling people who have cookies switched off as well. Regards, Andrew Scott Quote of the Day: If the colleges were better, if they really had it, you would need to get the police at the gates to keep order in the inrushing multitude. See in college how we thwart the natural love of learning by leaving the natural method of teaching what each wishes to learn, and insisting that you shall learn what you have no taste or capacity for. The college, which should be a place of delightful labour, is made odious and unhealthy, and the young men are tempted to frivolous amusements to rally their jaded spirits. I would have the studies elective. Scholarship is to be created not by compulsion, but by awakening a pure interest in knowledge. The wise instructor accomplishes this by opening to his pupils precisely the attractions the study has for himself. The marking is a system for schools, not for the college; for boys, not for men; and it is an ungracious work to put on a professor. - Ralph Waldo Emerson -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Wednesday, 14 September 2005 6:51 PM To: CF-Talk Subject: Do Not Include CFID CFTOKEN in URL? Hi all, I have searched the archives and although I see many questions answers with regards to my question I have not found a definitive one. I do not want to display the CFID CFTOKEN in my URL string. I am running both Coldfusion MX Coldfusion 7. Here is a snipet of my application settings; clientmanagement = true clientstorage = mydatabase setclientcookies = true I am also using the following code to ensure that my tokens are renewed if the browser is closed cfif isdefined(cookie.CFID) AND isdefined(cookie.CFTOKEN) cfset localcfid = cookie.CFID cfset localtoken = cookie.CFTOKEN cfcookie name=CFID value=#localcfid# cfcookie name=CFTOKEN value=#localtoken# /cfif Now I think I may be confused on exactly what happens here and where my tokens are being stored. I thought that my server side tokens are held within my database and my client side tokens are held within cookies. If this is the case why are CFID CFTYOKEN included in my URL? Would this behaviour be characteristic if cookies were disabled on the client machine (even though they are enabled on my test machine)? If I cannot remove these from my URL can anybody suggest ways of masking them in the URL or even better a good method for encrypting the entire URL so nothing can be tampered with? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218179 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Do Not Include CFID CFTOKEN in URL?
Sorry type, should have read ' All the places that I am using cflocation have addtoken=no. The CFID CFTOKEN are appearing in the URL regardless of whether I use cflocation or not :-( I am getting real hassle from a customer who for some reason is insisting that they are NOT visible in the URL and I cannot get rid of them, please help! Oh, by the way, cookies will always be on, they cannot access the site without them being switched on.' ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218183 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Do Not Include CFID CFTOKEN in URL?
Thanks for all your replies guy's. Now I think I have found the cause of why my CFID CFTOKEN are always in the URL but it also raises another issue. Oh, and I should have said that I am using Fusebox4.1, sorry! In my fusebox.init.cfm file I have the following code; cfset request.self = index.cfm cfset request.myself = #URLSessionFormat( '#request.self'#) It is the ' URLSessionFormat' that is including the CFID CFTOKEN in the URL string. The next problem is that this is only supposed to happen if cookies are disabled on the client machine. In my case cookies are enabled, I have changed the code to cfset request.myself = #request.self#) and everything works fine but it would appear that the check for cookies being active is failing. Can anyone confirm if the following code is causing the cookie check fail? cfif isdefined(cookie.CFID) AND isdefined(cookie.CFTOKEN) cfset localcfid = cookie.CFID cfset localtoken = cookie.CFTOKEN cfcookie name=CFID value=#localcfid# cfcookie name=CFTOKEN value=#localtoken# /cfif -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 13:56 To: CF-Talk Subject: RE: Do Not Include CFID CFTOKEN in URL? Sorry type, should have read ' All the places that I am using cflocation have addtoken=no. The CFID CFTOKEN are appearing in the URL regardless of whether I use cflocation or not :-( I am getting real hassle from a customer who for some reason is insisting that they are NOT visible in the URL and I cannot get rid of them, please help! Oh, by the way, cookies will always be on, they cannot access the site without them being switched on.' I have some vague recollection of this happening with one of my projects... iirc in my case it was sometimes automatically appended to the cgi.query_string variable (which was then being used to simply forward all the url variables from the current page to another page in a cflocation tag). So even when I specified addtoken=false in the cflocation tag, I still got that behavior. Try a whole-project search in CF Studio / Dreamweaver / etc. for this regular expression (cfid|cftoken|urltoken|addtoken|cgi\.query_string) Any of those could theoretically contain / cause references to cfid/cftoken. UrlToken specifically is the combination of cfid cftoken variables in url-encoded form, i.e. cfid=xxxcftoken=. At the time I think I used a replace() to remove it from the url, i.e. cflocation url=newpage.cfm?#rereplacenocase(cgi.query_string,urltoken,'')# addtoken=false hth s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218208 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Your experience of Bluedragon.net?
Hi all, I am in the process of setting up a development machine to evaluate Bluedragon .Net edition. The intention is to merge 2 of our .Net Coldfusion MX 7 servers into 1 server (for reasons unknown to me, hey-ho!). I would like to hear of anybody's experience, good bad, of using Bluedragon.net, specifically any tags not suported, tags that work differently, any Coldfusion 7 functionality, ease of integration/problems etc. This is not meant to cause any flame war as to which is better as there is no intention of moving from one specific version to another, we will still be running Coldfusion .Net servers anyway. I would just like to keep my options open and have experience of multitple environments. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple Regular Expression?
Thanks Michael, that did the trick just fine. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 09 September 2005 18:19 To: CF-Talk Subject: RE: Simple Regular Expression? I'm not sure if someone already answered this, but you should anchor the start and end of the strings. This pattern might do it, but it's not tested: ^(0|5|10|15|20|25|30|35|40|45|50)$ M!ke I am using the cfinput tag, validate=regular_expression and I am totally confusing myself on trying to work out what the pattern should equal. Basically I want the user to only be allowed to enter one of the following values 0,5,10,15,20,25,30,35,40,45,50 They cannot enter anything else i.e. 55 I tried using the following pattern (0|5|10|15|20|25|30|35|40|45|50) but I do not think I an fully understanding this as part of the validation works but it also allows 55 to be entered, I think that is because the individual value 5 is allowed? Can anyone give me some pointers? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217914 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS Word Com problem with CF
What I generally do is to create an instance of word in the application scope. I first check to see if there is an instance already created and if not then I create one. I then use the same instance for all of my calls, I don't create any new instances and I don't end the one I have got, I just have one instance always there. This works fine for me but you will have to try it to see if it suits your needs. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2005 20:51 To: CF-Talk Subject: MS Word Com problem with CF I am having to convert an asp program to CF and one of the functions needed is a server based mailmerge. I have it working in CF, except it creates a Word app on the server EVERYTIME the template is invoked, I'm invoking as: CFTRY CFOBJECT ACTION=CONNECT CLASS=Word.Application NAME=WordApp TYPE=COM CFCATCH CFTRY CFOBJECT ACTION=CREATE CLASS=Word.Application NAME=WordApp TYPE=COM CFCATCH TYPE=Object FONT COLOR=REDError creating word object./FONT CFABORT /CFCATCH /CFTRY /CFCATCH /CFTRY then at the end: cfset x = ActiveDocument.Close() cfset x = WordApp.Quit() The task manager on the server shows that word, after word, after word is beeing created but not destroyed ...as a point of reference in the asp app the object is created as: Set WordApp = CreateObject(Word.Application) and I KNOW for a fact the line that smokes it out of the task manager is: set wordapp=nothing any help would be GREATLY appreciated!! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Simple Regular Expression?
I am using the cfinput tag, validate=regular_expression and I am totally confusing myself on trying to work out what the pattern should equal. Basically I want the user to only be allowed to enter one of the following values 0,5,10,15,20,25,30,35,40,45,50 They cannot enter anything else i.e. 55 I tried using the following pattern (0|5|10|15|20|25|30|35|40|45|50) but I do not think I an fully understanding this as part of the validation works but it also allows 55 to be entered, I think that is because the individual value 5 is allowed? Can anyone give me some pointers? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple Regular Expression?
Thanks for the reply Ben, your code makes it a bit more understandable as to how to format an expression. The expression that you given me almost works but does still allow 55 to be entered. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 09 September 2005 16:17 To: CF-Talk Subject: RE: Simple Regular Expression? Oops, that would also allow 55. Try this, it allows digits 1-4 followed by a 0 or a 5 (that takes care of 10-45), as well as 50 0 and 5: ([1-4][05])|(50)|(0)|(5) -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 11:06 AM To: CF-Talk Subject: RE: Simple Regular Expression? In other words, you want 1 or 2 characters. If two characters you want 1-4 followed by a 0 or a 5, and if one character you want 0 or 5 followed by a space. So try: ([1-5][05])|(0 )|(5 ) -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 10:56 AM To: CF-Talk Subject: Simple Regular Expression? I am using the cfinput tag, validate=regular_expression and I am totally confusing myself on trying to work out what the pattern should equal. Basically I want the user to only be allowed to enter one of the following values 0,5,10,15,20,25,30,35,40,45,50 They cannot enter anything else i.e. 55 I tried using the following pattern (0|5|10|15|20|25|30|35|40|45|50) but I do not think I an fully understanding this as part of the validation works but it also allows 55 to be entered, I think that is because the individual value 5 is allowed? Can anyone give me some pointers? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: multiple cfoutputs vs one as a wrapper
I was always led to believe that putting cfoutput tags around a whole block of code was slower that only putting the tags around the code that you wanted output. If I remember correctly it is because the entire code block between cfoutput tags has to be parsed and that could mean wasting time on a lot of layout code. Not sure if there is a major difference in performance, suppose it depends on the amount of code in the block? -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 08 September 2005 18:09 To: CF-Talk Subject: multiple cfoutputs vs one as a wrapper Hey all: I'm tasked with the job of reworking someone else's FB CF code, and one thing that is driving me crazy is that the person who originally wrote the code dropped in s many cfoutput's that it's really not readable. Is there a performance benefit for doing this vs just cfoutputting a whole block of code? Ray ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217643 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: multiple cfoutputs vs one as a wrapper
Well, I wasn't aware of that change in CFMX, useful info. :-) -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 08 September 2005 18:20 To: CF-Talk Subject: Re: multiple cfoutputs vs one as a wrapper That was the case on CF5 and lower, because they did runtime parsing of the CF, but with CFMX onward, the CF is compiled on the first request, so the parsing/compiling complexity doesn't have any effect on subsequent requests. In other words, having one or many CFOUTPUT tags only affects the initial compilation, which might make the first request slightly slower, but once it's compiled, there is no difference. cheers, barneyb On 9/8/05, Andy McShane [EMAIL PROTECTED] wrote: I was always led to believe that putting cfoutput tags around a whole block of code was slower that only putting the tags around the code that you wanted output. If I remember correctly it is because the entire code block between cfoutput tags has to be parsed and that could mean wasting time on a lot of layout code. Not sure if there is a major difference in performance, suppose it depends on the amount of code in the block? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFX_Excel 'Can't start excel'
I cannot find a definitive answer but has anyone actually had this tag working with Excel 2003 or does it only suport up to Excel 2000? I am trying to use the CFX_Excel tag but I keep the error 'Can't start excel'. I have office 2003 installed on my development server so I am assuming that it may be permission related. My problem is that I do not what permissions to assign to excel.exe or who for, does anybody know how I can get this tag to work? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC's - Most efficient scope?
Thanks very much for all of your help, this makes things a heck of a lot clearer! :-) ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Convert PDF to Word Doc or RTF?
Has anybody ever tried to convert a Coldfusion generated PDF, created via cfdocument, to a word or RTF format? Does anyone know of any custom tag that may allow this? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217343 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFX_Excel 'Can't start excel'
I am trying to use the CFX_Excel tag but I keep the error 'Can't start excel'. I have office 2003 installed on my development server so I am assuming that it may be permission related. My problem is that I do not what permissions to assign to excel.exe or who for, does anybody know how I can get this tag to work? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217354 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFC's - Most efficient scope?
OK, thanks for all this info so far guy's. Now then, am I correct in saying that I should be scoping all of my argument var's to local var's within each of my functions within my cfc's? Now, is it acceptable, in instances where I pass in an argument collection, to copy the argument collection to a new local collection i.e. duplicate the argument structure to a new local structure? Can someone give me a brief idiot's guide on how CFC's and individual functions behave for each user? i.e. when initializing in the application scope the CFC is available application wide to each user, does this mean that only 1 instance of the CFC ever exists or is there 1 for each user session? Is each call to the CFC session independent or is this where I need to be understanding the whole locking/race condition issue, each call is awaiting for another call to finish first. Bear in mind that so far all my CFC's do is handle database interaction. Am I even making any sense at all, I do not know, I am so confused ;-( ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFC's - Most efficient scope?
Hi, been playing around with CFC's and fusebox4.1 for a bit, nothing too advanced. In the main part I use CFC's to do all of my database work, they contain all of my calls to the database using stored procedures. My question is what is the best amd most efficient way to execute them? At the moment I initialize all of my CFC's into the application scope and then in my fusebox model xml file use the following syntax; invoke object=application.MyObject methodcall=MyMethod( Arg1, Arg2, etc) returnvariable=MyReturnVar OR invoke object=application.MyObject methodcall=MyMethod( argumentcollection=MyArgs ) returnvariable=MyReturnVar Is this an efficient way of doing this? Is there a better way to do it? Have I completely misunderstood the use of CFC's? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217197 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFContent question ...
After I have created a document using cfdocument I am using the following code to open the pdf, cfheader name=content-disposition value=attachment; filename=wibble.pdf cfcontent type=aplication/pdf file=#expandpath('MyFilePath')# deletefile=yes reset=no This shows a dialogue box to the user giving the option of either saving the document, opening it or cancvel. What I want to be able to do is remove the option to open it (I think I set the type to application/unknow to do this) but I also need to be able to capture whether the user actually clicked save or cancel, is this possible? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216982 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFContent question ...
Thanks for that, at least I won't waste any more time looking :-) -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 31 August 2005 17:29 To: CF-Talk Subject: Re: CFContent question ... After I have created a document using cfdocument I am using the following code to open the pdf, cfheader name=content-disposition value=attachment; filename=wibble.pdf cfcontent type=aplication/pdf file=#expandpath('MyFilePath')# deletefile=yes reset=no This shows a dialogue box to the user giving the option of either saving the document, opening it or cancvel. What I want to be able to do is remove the option to open it (I think I set the type to application/unknow to do this) but I also need to be able to capture whether the user actually clicked save or cancel, is this possible? Nope. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217013 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF_TwoSelectsRelated
I searched the archives, I have searched Google and I have checked out the original authors site, http://projects.nateweiss.com/nwdc/workcode.htm, but I cannot find anybody who has actually ever got the default1 default2 values working in the CF_TwoSelectsRelated tag. Basically I love this tag but I need it to allow both of the select options to be defaulted to values on page load with data from the database and I can only ever get the first select box to default to a selection. Has anybody got a working version of this or can tell me what I am missing here? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217020 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_TwoSelectsRelated
Thanks, definately worth a look if I can't get this script to work properly. I searched the archives, I have searched Google and I have checked out here? this is not the answer you're looking for but...cfajax enables you to do this: http://www.indiankey.com/cfajax/ Andrew. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217024 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR)
As part of a reporting process I have a movie that allows the user to drag drop different icons onto the stage to form a diagram of player movement during a football match. This data is then saved into my database as XML. There is an option to be able to print this report. This is where I would have liked to use cfdocument to generate a PDF file. The problem is that I need to load the swf file and populate it with the xml data from the database to recreate the original user diagram. I am interested in your idea of embedding cfdocument but have no idea how to do what you suggest. :-( ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR)
The problem I have Mark is that I am not very clued up about flash, I really wouldn't know where to start :-( -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 15:03 To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Andy, You might be better off to just create a printed report FROM your flash movie. It's kind of painful - but flash does allow for very granular control over printing. -Mark -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 4:45 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) As part of a reporting process I have a movie that allows the user to drag drop different icons onto the stage to form a diagram of player movement during a football match. This data is then saved into my database as XML. There is an option to be able to print this report. This is where I would have liked to use cfdocument to generate a PDF file. The problem is that I need to load the swf file and populate it with the xml data from the database to recreate the original user diagram. I am interested in your idea of embedding cfdocument but have no idea how to do what you suggest. :-( ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR)
Thanks Mark, but you must give up too easy! Keep a post going a few days, more people read it, more posts with helpful information, that's my logic. Doesn't stop me learning other techniques in the meantime with the addition that someone may post a helpful tutorial link or offer useful advice. When people have had enough of this they will stop posting replies and I'll carry on regardless. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 15:40 To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Andy Andy Andy This thread has gone on for some time now. It should be clear to you that there is simply no easy way to do this. You've used that I don't know where to start... line a few times now if I recall :) Frankly you have to either: learn some advanced flash techniques absorb some 3rd party SWF conversion API Find some other way to use Straight HTML without your flash movie. There are no options on the table that anyone (even gurus here) would consider easy or straightforward. Sorry dude. Fish or cut bait. -Mark -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 9:26 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) The problem I have Mark is that I am not very clued up about flash, I really wouldn't know where to start :-( -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 15:03 To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Andy, You might be better off to just create a printed report FROM your flash movie. It's kind of painful - but flash does allow for very granular control over printing. -Mark -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 4:45 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) As part of a reporting process I have a movie that allows the user to drag drop different icons onto the stage to form a diagram of player movement during a football match. This data is then saved into my database as XML. There is an option to be able to print this report. This is where I would have liked to use cfdocument to generate a PDF file. The problem is that I need to load the swf file and populate it with the xml data from the database to recreate the original user diagram. I am interested in your idea of embedding cfdocument but have no idea how to do what you suggest. :-( ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR)
Thanks Kevin, that is an excellent link, I can definitely use that option to solve my problem. :-) -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 16:06 To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) http://www.actionscript.org/tutorials/beginner/the_printjob_class/ http://www.devx.com/webdev/Article/27318 Cheers, Kevin www.keslabs.com -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: August 30, 2005 8:40 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Andy Andy Andy This thread has gone on for some time now. It should be clear to you that there is simply no easy way to do this. You've used that I don't know where to start... line a few times now if I recall :) Frankly you have to either: learn some advanced flash techniques absorb some 3rd party SWF conversion API Find some other way to use Straight HTML without your flash movie. There are no options on the table that anyone (even gurus here) would consider easy or straightforward. Sorry dude. Fish or cut bait. -Mark -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 9:26 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) The problem I have Mark is that I am not very clued up about flash, I really wouldn't know where to start :-( -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 15:03 To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Andy, You might be better off to just create a printed report FROM your flash movie. It's kind of painful - but flash does allow for very granular control over printing. -Mark -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 4:45 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) As part of a reporting process I have a movie that allows the user to drag drop different icons onto the stage to form a diagram of player movement during a football match. This data is then saved into my database as XML. There is an option to be able to print this report. This is where I would have liked to use cfdocument to generate a PDF file. The problem is that I need to load the swf file and populate it with the xml data from the database to recreate the original user diagram. I am interested in your idea of embedding cfdocument but have no idea how to do what you suggest. :-( ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216776 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Replace or REReplace function question.
Thanks all. I have decided to go with the following syntax for my fieldnames fieldname1, fieldname2, etc just to avoid any problems with the hashes. As there will be limited few fields to deal with I think the less elegant but simpler 'replace' function should do the job, unless you know of any example code for doing it better? -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 25 August 2005 18:15 To: CF-Talk Subject: Re: Replace or REReplace function question. First, I'd recommend not using CF markup for the fields. Or at least don't require the CFOUTPUT tags, just the hashes. If you have a small number of fields, loop over them and just do a replace(string, ##detail.firstname##, detail.firstname, all) for each one. Not real elegant, but it is simple. A more robust solution would be to parse the text for hashes, and then check the contents of each pair (making sure to gracefully deal with floating hashes that aren't delimiters) and substituting the right content in it's place. This is a lot more complex, because you'll be doing a seek/cut/insert loop, rather than just replacing content, but it allows for a lot more flexibility. cheers, barneyb On 8/25/05, Andy Mcshane [EMAIL PROTECTED] wrote: Hi all, I am trying to come up with a way to do the following; User creates/edits a basic letter/mailshot document on line using FCKeditor. Within this document the user can add some pre-defined CF output fields i.e. cfoutput#details.firstname#/cfoutput. This is with the idea of trying to do a simple mailshot by extracting the names and addresses required from the database, selecting the letter/mailshot text from the database, looping thorugh the recordset inside of a cfdocument tag and producing a PDF of all the letters. The point at which I am stuck is actually replacing the output tags inserted into the original text with the required data from the database before allowing cfdocument to process it. Does anyone have any suggestions/ideas on the best way to replace my tags with the required text? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54