CFX_EXCEL ERROR
hi I juz downloaded this custom tag , but it keeps giving me this error when using : Error in CFX_Excel Tag Can't start Excel Does anyone knows what wrong with it ? ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Variable locking
Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: Primary Keys Duplicate Values
Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. I cannot use the Find and replace function as I do not know which values to look for. Also manually it is impossible as there are too many records to search through. Is there a Cold Fusion custom tag or function or SQL syntax I can use? Any help will be much appreciated. Thanks Srimanta - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:38 PM Subject: RE: Variable locking Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: Primary Keys Duplicate Values
Quoting Srimanta [EMAIL PROTECTED]: I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. SELECT field1, Count(field1) FROM table GROUP BY field1 HAVING Count(field1) 1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Primary Keys Duplicate Values
Yep, your problem is that you have dupes in the column you want to tag as a PK. is Field 1 the only field which is uses dupe values? are the records technically unique or can you safely delete them? -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 10:43 To: CF-Talk Subject: OT: Primary Keys Duplicate Values Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. I cannot use the Find and replace function as I do not know which values to look for. Also manually it is impossible as there are too many records to search through. Is there a Cold Fusion custom tag or function or SQL syntax I can use? Any help will be much appreciated. Thanks Srimanta - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:38 PM Subject: RE: Variable locking Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Need more coffee - help with CFIF logic please...
Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CFFORM validation issue
CFFORM validation testing great locally (Cold Fusion MX) Once files are placed out on the server, validation is ignored. I don't see anything in the CFADMIN that would control this. Ideas? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Need more coffee - help with CFIF logic please...
A case statement would be more logical... cfswitch -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Need more coffee - help with CFIF logic please...
A Case statement would be more logical : cfswitch expression=#cfformfield# cfcase value=20101-23217,23290-24658 delimiters=, DO THIS /cfcase cfcase value=27060-28909 DO THIS /cfcase cfcase value=27060-28909 DO THIS /cfcase cfcase value=23218-23298 DO ERROR MESSAGE ONE /cfcase cfdefaultcase SHOW ERROR MESSAGE TWO FOR ALL ELSE /cfdefaultcase /cfswitch -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFFORM validation issue
Is there a virtual directory so that cfide/scripts exists as the CFForm javascript is now referenced rather than being included in the page like previous versions... HTH -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:03 To: CF-Talk Subject: CFFORM validation issue CFFORM validation testing great locally (Cold Fusion MX) Once files are placed out on the server, validation is ignored. I don't see anything in the CFADMIN that would control this. Ideas? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Need more coffee - help with CFIF logic please...
This *might* work... Havnt tested it and my cases are a bit rusty... CFSWITCH EXPRESSION=#FORM.Zip# CFCASE VALUE=20101-23217,23290-24658 Do One (altho the above case may need to be split into 2 cases) /CFCASE CFCASE VALUE=27060-28909 do 2 /CFCASE CFCASE VALUE=23218-23298 error 1 /CFCASE CFDEFAULTCASE Error 2 /CFDEFAULTCASE /CFSWITCH HTH Mikey -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
How do I send email with logos(images) after a query result?
Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? CFQUERY NAME=ValidateUser DATASOURCE=#application.PrimaryDataSource# dbtype=ODBC SELECT client_username, client_password, client_id, client_firstname, client_surname, client_admin FROM tbl_client WHERE client_id = #id# /CFQUERY cfset session.NewReg = True CFMAIL TO=#Form.client_email# FROM=[EMAIL PROTECTED] SUBJECT=Thanks for Your registration TYPE=HTML TABLE border=0 cellspacing=0 cellpadding=0 align=left bgcolor=##00 TR TDimg src=images/top_half_red_600.jpg width=615 height=58/td /TR TR TD class=bodytextnbsp;/TD /TR TR TDfont face=Arial size=-1Dear #Form.client_Firstname#,/font/TD /TR TR TD class=bodytextnbsp;/TD /TR TR TD class=bodytextnbsp;/TD /TR TR TDfont face=Arial size=-1Thanks for registering with us/font/TD /TR /TABLE /cfmail Cheers! Kodjo Ackah Principal Consultant Concrete Media Ltd 32 Great Sutton Street Clerkenwell London, EC1V 0DX Tel:+44 (0)20 7251 8090 Fax: +44 (0)20 7251 8780 Mobile: +44 (0)7748 79 1038 Office Location: http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852 http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 Y=182204A=YZ=1 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Need more coffee - help with CFIF logic please...
the 3rd case has the wrong value, but it should work! generally a case statement is more efficient than a big IF block. For a multiple decision flow like you have, then I would more than 99% select a case over an IF. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:12 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... A Case statement would be more logical : cfswitch expression=#cfformfield# cfcase value=20101-23217,23290-24658 delimiters=, DO THIS /cfcase cfcase value=27060-28909 DO THIS /cfcase cfcase value=27060-28909 DO THIS /cfcase cfcase value=23218-23298 DO ERROR MESSAGE ONE /cfcase cfdefaultcase SHOW ERROR MESSAGE TWO FOR ALL ELSE /cfdefaultcase /cfswitch -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT? Easy data entry util for SQL?
If you are going to use an access data project to connect to the SQL tables, the SQL table must have a primary key - or access won't let you edit data in the table (the PK can be composite) Alex -Original Message- From: Jeff [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 02:44 To: CF-Talk Subject: RE: OT? Easy data entry util for SQL? In addition to what Dave mentioned, you can create an Access Data Project (.adp) file that gives you access to views and stored procedures as well. HTH, Jeff -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 5:52 PM To: CF-Talk Subject: OT? Easy data entry util for SQL? We have been using Access for so long now I got used to being able to enter/edit data with a few mouse clicks, just opened up the table and started typing or making corrections (to users, parameters files, or erroneous transactions during development). Now that development has been ported to SQL, I dread the command-line data entry of ISQL 6.5. Is there an easier way to do what I got used to doing with Access? A recent article, I believe it was in CFDJ, talked about interfacing the Access front-end to an SQL database thru ODBC. Have you actually tried it? Any tips/tricks? Thanks In Advance Ed Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Need more coffee - help with CFIF logic please...
Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? I would suggest a CFIF I don't believe that CFCASE can handle ranges only individual instances, but I could be wrong. cfif (form.zipcode GTE 20101 AND form.zipcode LTE 23217) OR (form.zipcode GTE 23290 AND form.zipcode LTE 24658 !--- Action ONE --- cfelseif form.zipcode GTE 27060 AND form.zipcode LTE 28909 !--- Action TWO --- cfelseif form.zipcode GTE 23218 AND form.zipcode LTE 23298 !--- Show Error ONE --- cfelse !--- Show Error TWO --- /cfif Hope that helps Regards Stephen (suitably coffee'd up) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: How do I send email with logos(images) after a query result?
Kodjo, Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? Why doesn't it work? What happens? Is there an error that you receive? Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: How do I send email with logos(images) after a query result?
I expect to see the image in the first row at the top of the email but I only see a place holder. Kodjo Ackah Principal Consultant Concrete Media Ltd 32 Great Sutton Street Clerkenwell London, EC1V 0DX Tel:+44 (0)20 7251 8090 Fax: +44 (0)20 7251 8780 Mobile: +44 (0)7748 79 1038 Office Location: http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:41 To: CF-Talk Subject: Re: How do I send email with logos(images) after a query result? Kodjo, Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? Why doesn't it work? What happens? Is there an error that you receive? Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Need more coffee - help with CFIF logic please...
A Case can certainly handle ranges. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:40 To: CF-Talk Subject: Re: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? I would suggest a CFIF I don't believe that CFCASE can handle ranges only individual instances, but I could be wrong. cfif (form.zipcode GTE 20101 AND form.zipcode LTE 23217) OR (form.zipcode GTE 23290 AND form.zipcode LTE 24658 !--- Action ONE --- cfelseif form.zipcode GTE 27060 AND form.zipcode LTE 28909 !--- Action TWO --- cfelseif form.zipcode GTE 23218 AND form.zipcode LTE 23298 !--- Show Error ONE --- cfelse !--- Show Error TWO --- /cfif Hope that helps Regards Stephen (suitably coffee'd up) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: How do I send email with logos(images) after a query result?
Hi Kodjo, could it be that you need to use an absolute URL or embed the image manual? Patric KA I expect to see the image in the first row at the top of the email but I KA only see a place holder. KA Kodjo Ackah KA Principal Consultant KA Concrete Media Ltd KA 32 Great Sutton Street KA Clerkenwell KA London, EC1V 0DX KA Tel:+44 (0)20 7251 8090 KA Fax: +44 (0)20 7251 8780 KA Mobile: +44 (0)7748 79 1038 KA Office Location: KA http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 KA -Original Message- KA From: Stephen Moretti [mailto:[EMAIL PROTECTED]] KA Sent: 07 October 2002 11:41 KA To: CF-Talk KA Subject: Re: How do I send email with logos(images) after a query KA result? KA Kodjo, Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? KA Why doesn't it work? What happens? Is there an error that you receive? KA Stephen KA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: How do I send email with logos(images) after a query result?
I expect to see the image in the first row at the top of the email but I only see a place holder. You need to use fully qualified file path. You only have a relative path so the image won't be found. img src=images/top_half_red_600.jpg width=615 height=58 needs to be img src=http://www.concrete-media.com/images/top_half_red_600.jpg; width=615 height=58 Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: How do I send email with logos(images) after a query result?
When it gets to the client then if images are not included in-line of the email then they should be referenced with a fully qualified path... i.e. http://www.yourserver/images/foo.gif HTH -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:42 To: CF-Talk Subject: RE: How do I send email with logos(images) after a query result? I expect to see the image in the first row at the top of the email but I only see a place holder. Kodjo Ackah Principal Consultant Concrete Media Ltd 32 Great Sutton Street Clerkenwell London, EC1V 0DX Tel:+44 (0)20 7251 8090 Fax: +44 (0)20 7251 8780 Mobile: +44 (0)7748 79 1038 Office Location: http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:41 To: CF-Talk Subject: Re: How do I send email with logos(images) after a query result? Kodjo, Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? Why doesn't it work? What happens? Is there an error that you receive? Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
How to get MS-Access Table Column info without cfobject
I used to be able to get system info from a MS-Access DB using cfobject ADO. I can't do that anymore because I am running CFMX on Mac OS X (Linux), The MS-Access database is running under emulated windows. This is a large Access97 database I can manipulate it OK from CFMX (I know some of the table names). In SQL Server there are system calls you can issue to the db to get table names, column names, column attributes, etc. Can you do a similar thing with MS-Access 2000? For some reason I cannot open the database either in Access97 or Access2000 - It just hangs. TIA Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: How to get MS-Access Table Column info without cfobject
You need read permissions on table 'MSysObjects', you have to set thee inside Access, once you have, the following query should return table names ok. select MSysObjects.Name from MSysObjects where (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1)) order by MSysObjects.Name Craig. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 12:12 To: CF-Talk Subject: How to get MS-Access Table Column info without cfobject I used to be able to get system info from a MS-Access DB using cfobject ADO. I can't do that anymore because I am running CFMX on Mac OS X (Linux), The MS-Access database is running under emulated windows. This is a large Access97 database I can manipulate it OK from CFMX (I know some of the table names). In SQL Server there are system calls you can issue to the db to get table names, column names, column attributes, etc. Can you do a similar thing with MS-Access 2000? For some reason I cannot open the database either in Access97 or Access2000 - It just hangs. TIA Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Need more coffee - help with CFIF logic please...
: A Case can certainly handle ranges. This don't work though... cfcase value GT 20100 and value LT 23218 So, how would you define a range for case? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Need more coffee - help with CFIF logic please...
With a - So for that case you would have... CFCASE VALUE=20100-23218 HTH -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 13:06 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... : A Case can certainly handle ranges. This don't work though... cfcase value GT 20100 and value LT 23218 So, how would you define a range for case? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Need more coffee - help with CFIF logic please...
Since when does CFCASE allow a range (27060-28909) ? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:15 AM To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... This *might* work... Havnt tested it and my cases are a bit rusty... CFSWITCH EXPRESSION=#FORM.Zip# CFCASE VALUE=20101-23217,23290-24658 Do One (altho the above case may need to be split into 2 cases) /CFCASE CFCASE VALUE=27060-28909 do 2 /CFCASE CFCASE VALUE=23218-23298 error 1 /CFCASE CFDEFAULTCASE Error 2 /CFDEFAULTCASE /CFSWITCH HTH Mikey -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Need more coffee - help with CFIF logic please...
ahhh, I though 27060-28909 was a number :-) c'mon, its Monday! -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 13:36 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... Since when does CFCASE allow a range (27060-28909) ? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:15 AM To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... This *might* work... Havnt tested it and my cases are a bit rusty... CFSWITCH EXPRESSION=#FORM.Zip# CFCASE VALUE=20101-23217,23290-24658 Do One (altho the above case may need to be split into 2 cases) /CFCASE CFCASE VALUE=27060-28909 do 2 /CFCASE CFCASE VALUE=23218-23298 error 1 /CFCASE CFDEFAULTCASE Error 2 /CFDEFAULTCASE /CFSWITCH HTH Mikey -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Need more coffee - help with CFIF logic please...
cfset x=5 cfswitch expression=#x# cfcase value=1-4 1 - 4 /cfcase cfcase value=5-8 5 - 8 /cfcase cfcase value=9-12 9 - 12 /cfcase cfdefaultcase Not found /cfdefaultcase /cfswitch Outputs Not found -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 8:36 AM To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... Since when does CFCASE allow a range (27060-28909) ? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:15 AM To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... This *might* work... Havnt tested it and my cases are a bit rusty... CFSWITCH EXPRESSION=#FORM.Zip# CFCASE VALUE=20101-23217,23290-24658 Do One (altho the above case may need to be split into 2 cases) /CFCASE CFCASE VALUE=27060-28909 do 2 /CFCASE CFCASE VALUE=23218-23298 error 1 /CFCASE CFDEFAULTCASE Error 2 /CFDEFAULTCASE /CFSWITCH HTH Mikey -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Need more coffee - help with CFIF logic please...
or should I say : an ID. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 13:40 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... ahhh, I though 27060-28909 was a number :-) c'mon, its Monday! -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 13:36 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... Since when does CFCASE allow a range (27060-28909) ? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:15 AM To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... This *might* work... Havnt tested it and my cases are a bit rusty... CFSWITCH EXPRESSION=#FORM.Zip# CFCASE VALUE=20101-23217,23290-24658 Do One (altho the above case may need to be split into 2 cases) /CFCASE CFCASE VALUE=27060-28909 do 2 /CFCASE CFCASE VALUE=23218-23298 error 1 /CFCASE CFDEFAULTCASE Error 2 /CFDEFAULTCASE /CFSWITCH HTH Mikey -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Need more coffee - help with CFIF logic please...
So I was right after all! Thought that I was going loopy or something!!! Stephen (who thought he'd had a enough coffee when he wrote his reply) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 1:39 PM Subject: RE: Need more coffee - help with CFIF logic please... ahhh, I though 27060-28909 was a number :-) c'mon, its Monday! -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 13:36 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... Since when does CFCASE allow a range (27060-28909) ? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:15 AM To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... This *might* work... Havnt tested it and my cases are a bit rusty... CFSWITCH EXPRESSION=#FORM.Zip# CFCASE VALUE=20101-23217,23290-24658 Do One (altho the above case may need to be split into 2 cases) /CFCASE CFCASE VALUE=27060-28909 do 2 /CFCASE CFCASE VALUE=23218-23298 error 1 /CFCASE CFDEFAULTCASE Error 2 /CFDEFAULTCASE /CFSWITCH HTH Mikey -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error message TWO Suggestions as to the best way to construct this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT topics and posts about OT topics
I apologize for this post but I have to speak my mind on this.. I have an Inbox rule that moves all cf-talk emails to another folder. I'm sure all of us are busy most of the day to read every email that comes in. Every 30-60 minutes, I check the folder and scan the topics. If I see something that interests me, I read it. If it is something I can help with, I read it. If it doesn't interest me, I ignore it. How hard is it for the rest of you guys to do. I know I DON'T have time to click on a link from an email to get rid of it..and why should I. If I don't want to read it, I don't. Some people on this list make such a HUGE deal about some OT posts that it makes me wonder if their job depends on whether or not they read EVERY SINGLE POST that comes in. Some people need to get a life (or back to work) if that's the case. I don't know how much it pay's to read every post, but I don't think I'm qualified. -stepping of my soap box now. Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 10:50 AM To: CF-Talk Subject: OT topics and posts about OT topics Seems like there are more posts about Off topic posts and also the off topic posts them selves on this list than ever before. While I enjoy OT post as much as anyone, I highly value this list for its on topic info. My idea is a voting system where after about 20 or so list member votes, via a link at the bottom of all of the posts, would cause the thread to be moved to another list or to block the topic entirely. This idea is just another way that this list could police itself. I have brought the idea up once before, and this will be the last time I bring it up. Thanks Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: MX and Javamail - Upgrading MX to Javamail 1.3
Jon Hall wrote: Ok then I will... ;) Never one to turn down a challenge, but having no clue what I was doing my first thought was to try brute force...and it worked. So here are the steps for anyone interested. Download Javamail 1.3 from Sun's site. Shut down Cold Fusion. Make backup of CFusionMX\runtime\lib\jrun.jar. Make backup of CFusionMX\runtime\lib\jrun.jar. Read the above two lines again. Using Jar archive manager of choice (I used WinRar), and open both jrun.jar and the mail.jar file from the Javamail 1.3 download. In the mail.jar file, navigate the the javax\mail directory and copy it to the clipboard. Int the jrun.jar file, navigate to the javax directory and paste files. WinRar will do it's thing and write out a file called something like zias.j40. That's the new and improved jrun.jar. Rename it to jrun.jar, and start up ColdFusion again. Congratulations, you now have Javamail 1.3, probably voided all warranties, and gained access to the nifty validate() method! Some example code: cfset objJavamail = createObject(java, javax.mail.internet.InternetAddress) cfdump var=#objJavamail# cfset emailAddress = inv@[EMAIL PROTECTED] cfset objJavamail.init(emailAddress, true) cftry cfset objJavamail.validate() cfcatch type=javax.mail.internet.AddressException cfoutput#cfcatch.message#/cfoutput /cfcatch /cftry cfoutput #objJavamail.getAddress()# /cfoutput This doesn't catch everything a tweaked regex catches, but it does catch a lot, and it gives a very specific english error message. It's also very fast. There are a lot of other handy methods in the InternetAddress class too. You can make it try and correct an invalid email address even. Seems to do a pretty good job at it. Link to docs: http://java.sun.com/products/javamail/1.3/docs/javadocs/index.html I'm starting to think this MX stuff is pretty cool. There is a lot of untapped power built into Java that I can't wait to see exposed in CF. You can also place the Javamail 1.3 jar file first in the classpath of coldfusion. This will amke sure it finds the new version first. This is easier, and will work consistent with updates ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Randomizing Query Results
What is the best way to randomize the results of a CF query? Thanks, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Randomizing Query Results
In what way? Do you just want to display a random record from a set... Or a load of records just in a random order? -Original Message- From: David Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 14:24 To: CF-Talk Subject: Randomizing Query Results What is the best way to randomize the results of a CF query? Thanks, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Randomizing Query Results
Your query results range between 1 and Total Record Count right? So you could do something like cfset r=randRange(1,QueryName.recordCount) cfoutput #QueryName.columnName[r]# /cfouput The above is what i guessed from your question. Joe Eugene Certified Advanced ColdFusion Developer - Original Message - From: David Jones [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:23 AM Subject: Randomizing Query Results What is the best way to randomize the results of a CF query? Thanks, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
mx conversion problem: code exposed
We are starting to migrate to mx from cf5, but we're not getting very far off the ground with our first site. When we hit the site, dev.myurlhere.com, all the code of the default page is exposed; it's almost as if the server is not recognizing the .cfm extension. And yet the administrator works just fine. Has anyone else run into this? We're on IIS, W2K -- Kelly Tetterton duoDesign -- Technical Lead Macromedia Certified ColdFusion Developer Internet design, technology and marketing 847-491-3000 | main 847-491-3100 | fax 847-491-7125 | direct [EMAIL PROTECTED] www.duoDesign.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: mx conversion problem: code exposed
You havent mapped (or more likely, the installer didnt) the jrun.dll extension. You will have to go into IIS and map the .cfm extension direct to the jrun.dll. Neil -Original Message- From: Kelly Tetterton [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 14:53 To: CF-Talk Subject: mx conversion problem: code exposed We are starting to migrate to mx from cf5, but we're not getting very far off the ground with our first site. When we hit the site, dev.myurlhere.com, all the code of the default page is exposed; it's almost as if the server is not recognizing the .cfm extension. And yet the administrator works just fine. Has anyone else run into this? We're on IIS, W2K -- Kelly Tetterton duoDesign -- Technical Lead Macromedia Certified ColdFusion Developer Internet design, technology and marketing 847-491-3000 | main 847-491-3100 | fax 847-491-7125 | direct [EMAIL PROTECTED] www.duoDesign.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Does there exist...
Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Primary Keys Duplicate Values
If all of your current fields have meaning, I recommend that you add a new field that is a meaningless number that you use as your key field. I've found that if I use a field with meaning as my key that I end up wanting to change that value. Exceptions might be code tables like ZIP Code and State Abbreviations where you have a reasonable expectation that the key (zip code or abbreviation) will never change. Andy -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 4:43 AM To: CF-Talk Subject: OT: Primary Keys Duplicate Values Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. I cannot use the Find and replace function as I do not know which values to look for. Also manually it is impossible as there are too many records to search through. Is there a Cold Fusion custom tag or function or SQL syntax I can use? Any help will be much appreciated. Thanks Srimanta - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:38 PM Subject: RE: Variable locking Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: help with IIS 5
is the service started? make sure the cf application server service is started... - Original Message - From: Tim Laureska [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 06, 2002 9:38 AM Subject: Re: help with IIS 5 I have only 5 hairs left on my head.. I think though I've narrowed it down to the fact that the CF server will not start when I try to start it manually, I get CF application server error (error while processing request) I have uninstalled and reinstalled the CF server (single edition) multiple times, but am still unable to start the cfserver ..even manually... I must be doing something very basically wrong - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: October 06, 2002 5:24 AM Subject: Re: help with IIS 5 Error 1060 is listed as : The specified service does not exist as an installed service. The fact that CF won't even start seems to indicate that the problem isn't an IIS problem though. You might have a busted install...try checking the event log though. It may have some more detail as to why the service won't start. -- jon mailto:[EMAIL PROTECTED] Saturday, October 5, 2002, 10:58:10 PM, you wrote: TL some more info that may help you help me diagnose this thing. This is a TL two partition system with W2k installed on the D drive. I didn't notice TL at first that the mappings were to the C:\cfusion\bin directory...I changed TL those to d:\cfusion\bin and am getting a different error now when trying to TL open CFM files I can't start the CF server either TL Error Occurred While Processing Request TL Error Diagnostic Information TL Error occurred while attempting to open service. TL Windows NT error number 1060 occurred. TL HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Sun, 06 Oct 2002 02:56:44 TL GMT Connection: close Content-type: text/html Expires: 0 Pragma: no-cache TL Cache-control: no-cache, no-store, must-revalidate TL ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Primary Keys Duplicate Values
U might want to use this query select field1 from yourtable group by field1 having count(*) 1 this would result all the duplicate row. If u want to list down all the duplicate records select * from yourtable where field1 in (select field1 from yourtable group by field1 having count(*) 1) good luck -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:24 AM To: CF-Talk Subject: RE: Primary Keys Duplicate Values If all of your current fields have meaning, I recommend that you add a new field that is a meaningless number that you use as your key field. I've found that if I use a field with meaning as my key that I end up wanting to change that value. Exceptions might be code tables like ZIP Code and State Abbreviations where you have a reasonable expectation that the key (zip code or abbreviation) will never change. Andy -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 4:43 AM To: CF-Talk Subject: OT: Primary Keys Duplicate Values Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as there are duplicate values in the records in field1. How do I find which values are duplicate in field1. I cannot use the Find and replace function as I do not know which values to look for. Also manually it is impossible as there are too many records to search through. Is there a Cold Fusion custom tag or function or SQL syntax I can use? Any help will be much appreciated. Thanks Srimanta - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 9:38 PM Subject: RE: Variable locking Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 04 October 2002 22:53 To: CF-Talk Subject: Re: Variable locking On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote: Actually, that using NAME is not a better practice... the SCOPE attribute is safer and is also what MM support advised us to use (when applicable). Pre-MX. Sure, the scope of a NAME-based lock will be tighter than using SCOPE, but SCOPE will be safer and, as a bonus, you can use CF 5's (and prior) auto-checking for missing locks... Which is no longer available in MX because it is no longer needed. Basically, NAME is older than SCOPE, and SCOPE was added to address issues that NAME cannot handle. SCOPE was added to resolve bugs in earlier releases of CF around the shared scope memory corruption problems. That is no longer an issue in CFMX. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Does there exist...
If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Does there exist...
http://groups.google.com/groups?hl=enlr=ie=UTF-8group=mailing.database.sql-general this would be your best bet. Justin Hansen -- Uhlig Communications Systems Engineer -- [EMAIL PROTECTED] 913-754-4273 -- -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:31 AM To: CF-Talk Subject: Re: Does there exist... If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Does there exist...
http://www.sswug.org/ Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: Re: Does there exist... If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Dreamweaver MX keyboard shortcuts...
THANK YOU!!! That has been SOOO annoying!!! - Original Message - From: Anthony Wong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, October 05, 2002 2:33 PM Subject: RE: Dreamweaver MX keyboard shortcuts... David, 1) Select Edit -- Keyboard Shortcuts 2) On the edit window, click on the first box next to 'Current Set' (the box should have the hint 'Duplicate Set') 3) Name your duplicated set. 4) In the Command select box, choose Menu Commands 5) Select Insert -- ColdFusion Basic Objects -- Surround with # 6) apply Ctrl-3 on the shortcuts. More about customizing your DW MX can be found in the following article. http://www.macromedia.com/support/dreamweaver/custom/customizing_dwmx/ anthony Is there a way to replace the cntrl-3 short cut that does an h3 to surround whatever is highlighted with #'s? thanks David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Randomizing Query Results
David Jones wrote: What is the best way to randomize the results of a CF query? Offload it to the database: SELECT * FROMtable ORDER BYRandom() Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CF MX and CFTREE
Hello. We just upgraded our CF 4.5 server to CF MX. However, on one of our applications we have a CFTREE that is used to select files. The CFTREE tag worked just fine in CF4.5, however we are not getting the following error message: Error in__CFTree__myForm__DirectoryExplorer value. We found on the macromedia site technote 22491 and 23150 which also describes this error. We have already tried the 22491 fix using the javascript solution. This solution did not work. The question is, the patch that is mentioned in 23150 for the JavaApplets also go for CF MX? I know that it mentions CF 5. But does that mean the CF MX can be included in this fix. Thanks. Michael Michael S. Kimmett Software Engineering Phantom Works Boeing Huntsville ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Struct state between pages in an application
OK, I've made this disclaimer before, but it still applies: I'm really new when it comes to CF, so I request that you please keep that in mind as you read this. I don't claim that as an excuse for not searching out the answers on my own, but I've been unable to find an explanation of this behavior in the CF docs so far. So anyway... I've got this form, and I want to use the selected/input values from the form to call a stored procedure that is within a package in an Oracle database for processing. But, before passing the values to the database, I want the user to be able to confirm the selections that they've made before sending the information to the database. So, at the beginning of the page that displays the form, I check to see if the structure is defined, and if it's not, I create it. (I realize that what you're about to read may not make sense if it's not the best way to do this, but it was the only way that I could figure out to do it, so this is how it currently works...I'm open to suggestions) So, on the form page, the action is GET, and on the action page, I first populate all of the properties of the structure with the URL parameters that have been passed from the form, by evaluating their values in the URL. I then display the users selections, by outputting the values of the structure p! roperties. All of this to this point works fine. The fact that it works fine, suggests to me that structures reside in memory on the CF server, and can persist between templates in an application. So, based on that assumption, I also assumed that the properties of the structure would be available on the NEXT page as well. The action page for the form, has two links at the bottom of it, after all of the values that the user has selected are displayed for confirmation...one link is a back button, that allows the user to go back to the form and make any necessary corrections to their input, and the other is a link to another template that actually process the form by passing all of the properties of the structure to the stored procedure in the database for processing. The first thing I do in this template, is check for the existence of the structure, to make sure that it's values can be passed to the stored procedure. This is where my problem comes up. Every time I click! the link to go to this template for processing, I get the me! ssage that gets displayed if the structure does not exist (it's a message that I've inserted to let the user know that there was an error, due to the fact that the structure cannot be found, and processing cannot continue). What am I doing wrong? Why is the server not finding this structure? Am I not defining it properly to be available across multiple templates or something like that? Any thoughts would be greatly appreciated. The code for checking for the existence of the structure is below. Thanks in advance. cfif not isDefined(myStructure) pThe structure does not exist. Blah blah blah./p cfelse ... /cfif ::YEX:: ))) /* || Robert D. Yexley || Oracle Programmer/Analyst || Northrop Grumman IT || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFX_EXCEL ERROR
Do you have Excel installed on the server? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:11 AM To: CF-Talk Subject: CFX_EXCEL ERROR hi I juz downloaded this custom tag , but it keeps giving me this error when using : Error in CFX_Excel Tag Can't start Excel Does anyone knows what wrong with it ? ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Struct state between pages in an application
Like any other variable in the local scope, the structure you're creating ceases to exist when the page finishes processing. You'll need to put it in a persistent scope (Session, Client) or in some other way pass it to the next page (serialize it with WDDX and put it in a hidden form variable, deserializing it on the next page; using Uncle Ben's CF_embedformfields tag; etc.) You'll probably want to use Session variables. 1. Remember your CFLOCKs 2. You should probably delete the structure in Session when you get to your processing page so it's not hanging around. OK, I've made this disclaimer before, but it still applies: I'm really new when it comes to CF, so I request that you please keep that in mind as you read this. I don't claim that as an excuse for not searching out the answers on my own, but I've been unable to find an explanation of this behavior in the CF docs so far. So anyway... I've got this form, and I want to use the selected/input values from the form to call a stored procedure that is within a package in an Oracle database for processing. But, before passing the values to the database, I want the user to be able to confirm the selections that they've made before sending the information to the database. So, at the beginning of the page that displays the form, I check to see if the structure is defined, and if it's not, I create it. (I realize that what you're about to read may not make sense if it's not the best way to do this, but it was the only way that I could figure out to do it, so this is how it currently works...I'm open to suggestions) So, on the form page, the action is GET, and on the action page, I first populate all of the properties of the structure with the URL parameters that have been passed from the form, by evaluating their values in the URL. I then display the users selections, by outputting the values of the structure p! roperties. All of this to this point works fine. The fact that it works fine, suggests to me that structures reside in memory on the CF server, and can persist between templates in an application. So, based on that assumption, I also assumed that the properties of the structure would be available on the NEXT page as well. The action page for the form, has two links at the bottom of it, after all of the values that the user has selected are displayed for confirmation...one link is a back button, that allows the user to go back to the form and make any necessary corrections to their input, and the other is a link to another template that actually process the form by passing all of the properties of the structure to the stored procedure in the database for processing. The first thing I do in this template, is check for the existence of the structure, to make sure that it's values can be passed to the stored procedure. This is where my problem comes up. Every time I click! the link to go to this template for processing, I get the me! ssage that gets displayed if the structure does not exist (it's a message that I've inserted to let the user know that there was an error, due to the fact that the structure cannot be found, and processing cannot continue). What am I doing wrong? Why is the server not finding this structure? Am I not defining it properly to be available across multiple templates or something like that? Any thoughts would be greatly appreciated. The code for checking for the existence of the structure is below. Thanks in advance. cfif not isDefined(myStructure) pThe structure does not exist. Blah blah blah./p cfelse ... /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CF execute HELP
I have never used cfexecute before and could use a few pointers before I suffer early hair loss. Here is what I am attempting to do. I would like to run Access from the command line opening a database with a linked table in it that will be copied to another datasource using an autoexec macro which has a copy object call as it's action. The reason I am doing this is my financial package (MAS90) uses illegal characters in its database table naming that Access can handle, but not CF. So I am attempting to create a new table everytime I open the test.mdb. It works fine in windows 2000, but not in a CF template using the following parameters. This is an intranet app. cfexecute name = C:\program files\microsoft office\office\msaccess.exe arguments = c:\inetpub\databases\test.mdb timeout = 100 /cfexecute If anyone can show me the correct method to accomplish my task I would greatly appreciate it. Terry ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Update Problem in CF
This should work with SQL Server update table1 set price = b.price from table1 a join table2 b on a.productid = b.productid and a.modelno = b.modelno I have two tables in a DB containing information about the same products. Table 1 is comprehensive and has complete details about the products. Table 2 has fewer no of fields. The fields common in both Table 1 and Table 2 are productid, modelno, price, details . Table1.price contains the old price. Table2. price is the latest price. I want to update Table1.price with the values in Table2.price and use modelno as the unique value for this update. Can someone please help. My SQL knowlede is very basic. Also what if Table two consists of new products not included in Table 1.? What syntax Should I use? Thanks JB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
OT: Can a subscription site be classed as shipped goods
Hi - (sorry for the cross post) This is more legal than technical so excuse me if its OT. Apparently in the US, payment cannot be fully debited from a credit card until the goods have been shipped. If a site provides a subscription service does this count as goods already shipped? In addition to this what is the law regarding products which can be downloaded immediately ( with a CD to follow in the post). I know you guys are not lawyers but I figured some of you may have encountered this before Thanks in advance Oh and sorry for the cross post Kola Oyedeji Certified Advanced Coldfusion Developer, ICLP London DDI: +44 (0) 208 256 9034 www.iclployalty.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: How to get MS-Access Table Column info without cfobject
Unfortunately, read permissions on table 'MSysObject are not set. I can't open the db in either Access97 or Access2000 on WinNT or WinXP -- hangs on NT, crashes on XP. I was able to repair the db successfully, but still can't open it. Yet, I can manipulate it with CFMX for any table I can remember. Any way to set the MSysObject permissions through an SQL Query? TIA Dick Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest. - Isaac Asimov - On Monday, October 7, 2002, at 04:36 AM, Craig Dudley wrote: You need read permissions on table 'MSysObjects', you have to set thee inside Access, once you have, the following query should return table names ok. select MSysObjects.Name from MSysObjects where (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1)) order by MSysObjects.Name Craig. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 12:12 To: CF-Talk Subject: How to get MS-Access Table Column info without cfobject I used to be able to get system info from a MS-Access DB using cfobject ADO. I can't do that anymore because I am running CFMX on Mac OS X (Linux), The MS-Access database is running under emulated windows. This is a large Access97 database I can manipulate it OK from CFMX (I know some of the table names). In SQL Server there are system calls you can issue to the db to get table names, column names, column attributes, etc. Can you do a similar thing with MS-Access 2000? For some reason I cannot open the database either in Access97 or Access2000 - It just hangs. TIA Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Big Trouble in T-SQL land
Thanks for you help Paul. Actually, this doesn't fail in cf5. The SET NOCOUNT allows for multi sql statements (in MS SQL). Thanks for your suggestion on checking for objects, but as I am sure you can tell this is only a sample bit of code to explain our problem. This is not on our site. This type of query is used a lot on our site and in cf5 there was no problem. Moving to a stored proc does fix the problem; however, that is an impossibility with some of our queries - plus it would be a major re-write. -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 05, 2002 12:49 AM To: CF-Talk Subject: Re: Big Trouble in T-SQL land Now, we seem to be unable to create temporary tables. The following query returns 0 records in CFMX but 1 record in query analyzer. no, it looks like the CREATE TABLE in the same cfquery. fails with regular tables too. Anyone else? Suggestions? Glass of hemlock? move this into an SP. works there as expected. CREATE TABLE ##xyz (a varchar(10)) btw you should always check for objects prior to creating them just in case a process croaks leaves that table or whatever hanging about. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.394 / Virus Database: 224 - Release Date: 10/3/2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: Can a subscription site be classed as shipped goods
At 05:33 PM 10/7/2002 +0100, you wrote: Hi - (sorry for the cross post) This is more legal than technical so excuse me if its OT. Apparently in the US, payment cannot be fully debited from a credit card until the goods have been shipped. If a site provides a subscription service does this count as goods already shipped? A subscription is a service, not goods. I do not think a service counts as goods by any stretch of the imagination. ColdFusion Consulting = service ColdFusion Application Server = Goods. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Phone: 1-203-379-0773 -- Vote for ColdFusion: A Beginner's Guide in the ColdFusion Developer's Journal Readers Choice Awards http://www.sys-con.com/coldfusion/readerschoice2002/ -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CF 5 Hack
Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Struct state between pages in an application
I don't think you can store complex objects like structures in the client scope without first serializing them into a wddx packet... ( which would be similar to passing it in a form, just different management of the packet )... however... I think Al's right, sessions are probably your best bet... I'd change the action in your form from GET to POST and put this on your intermediary action page: cfif isdefined(form.myrequiredfield) cflock scope=session type=exclusive timeout=10 cfset session.mystruct = duplicate(form) /cflock cflocation url=#cgi.path_info# addtoken=nocfabort cfelse cflock scope=session type=readonly timeout=10 cfif structkeyexists(session,mystruct) cfset mystruct = duplicate(session.mystruct)/cfif /cflock /cfif cfif isdefined(mystruct) ... output the structure and the form to go to the next page here... cfelse ... custom error message ... /cfif The reason for using POST instead of GET is to insulate the data from a mangled or over-long url for whatever reason. If it sees your required form field, it coppies the data into the request scope, then relocates to the current page without the form, so that if the user refreshes the page, they won't get the annoying do you want to repost the form message. It then grabs the data from the session scope and if everything is okay, they can hit the next button and on the following page, you can grab the data from the request scope again, as in the else clause above. hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Like any other variable in the local scope, the structure you're creating ceases to exist when the page finishes processing. You'll need to put it in a persistent scope (Session, Client) or in some other way pass it to the next page (serialize it with WDDX and put it in a hidden form variable, deserializing it on the next page; using Uncle Ben's CF_embedformfields tag; etc.) You'll probably want to use Session variables. 1. Remember your CFLOCKs 2. You should probably delete the structure in Session when you get to your processing page so it's not hanging around. OK, I've made this disclaimer before, but it still applies: I'm really new when it comes to CF, so I request that you please keep that in mind as you read this. I don't claim that as an excuse for not searching out the answers on my own, but I've been unable to find an explanation of this behavior in the CF docs so far. So anyway... I've got this form, and I want to use the selected/input values from the form to call a stored procedure that is within a package in an Oracle database for processing. But, before passing the values to the database, I want the user to be able to confirm the selections that they've made before sending the information to the database. So, at the beginning of the page that displays the form, I check to see if the structure is defined, and if it's not, I create it. (I realize that what you're about to read may not make sense if it's not the best way to do this, but it was the only way that I could figure out to do it, so this is how it currently works...I'm open to suggestions) So, on the form page, the action is GET, and on the action page, I first populate all of the properties of the structure with the URL parameters that have been passed from the form, by evaluating their values in the URL. I then display the users selections, by outputting the values of the structure p! roperties. All of this to this point works fine. The fact that it works fine, suggests to me that structures reside in memory on the CF server, and can persist between templates in an application. So, based on that assumption, I also assumed that the properties of the structure would be available on the NEXT page as well. The action page for the form, has two links at the bottom of it, after all of the values that the user has selected are displayed for confirmation...one link is a back button, that allows the user to go back to the form and make any necessary corrections to their input, and the other is a link to another template that actually process the form by passing all of the properties of the structure to the stored procedure in the database for processing. The first thing I do in this template, is check for the existence of the structure, to make sure that it's values can be passed to the stored procedure. This is where my problem comes up. Every time I click! the link to go to this template for processing, I get the me! ssage that gets displayed if the structure does not exist (it's a message that I've inserted to let the user know that there was an error, due to the fact that the structure cannot be found, and processing cannot continue). What am I doing wrong? Why is the server not finding this structure? Am I not defining it properly to be
RE: CF execute HELP
Try writing a batch file that does what you want, then just cfexecute that instead, I have more luck doing it that way. Craig. -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 16:19 To: CF-Talk Subject: CF execute HELP I have never used cfexecute before and could use a few pointers before I suffer early hair loss. Here is what I am attempting to do. I would like to run Access from the command line opening a database with a linked table in it that will be copied to another datasource using an autoexec macro which has a copy object call as it's action. The reason I am doing this is my financial package (MAS90) uses illegal characters in its database table naming that Access can handle, but not CF. So I am attempting to create a new table everytime I open the test.mdb. It works fine in windows 2000, but not in a CF template using the following parameters. This is an intranet app. cfexecute name = C:\program files\microsoft office\office\msaccess.exe arguments = c:\inetpub\databases\test.mdb timeout = 100 /cfexecute If anyone can show me the correct method to accomplish my task I would greatly appreciate it. Terry ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Does there exist...
We have such a list on HoF. It's low traffic but has enough people to handle almost all SQL questions. subscribe: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/sql archives: http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=6 Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CF 5 Hack
We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? Yes, just change the registry key value to 0 for this key: HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CF 5 Hack
As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF 5 Hack
Off the top of my head, no, but if you can get into the registry you can set Administrator to not require a password. Sorry, but I don't know the key either. However, Google is a wonderfult thing: http://www.teratech.com/coldcuts/cutdetail.cfm?cutid=253 http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=6lngWId =9 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:31 PM To: CF-Talk Subject: CF 5 Hack Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CF 5 Hack
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg05663.html Quote: yeah you can disable it in the registry, set a new one, then enable it again. HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdmi nPassword = 0 That will disable the password Pete - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 12:30 PM Subject: CF 5 Hack Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CF execute HELP
Terry Troxel wrote: The reason I am doing this is my financial package (MAS90) uses illegal characters in its database table naming that Access can handle, but not CF. How about: cfquery SELECT [illegal ##$@* name] AS allowed_fieldname FROM [illegal ##$@* name] allowed_tablename /cfquery Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
SOT:SSL problem
Hey everyone, Maybe someone can give me an ideas as to what may cause this. We have 2 different websites, on the same server, one uses a Verisign Digital Certificate and the other uses a Thawte cert, I know Verisign owns both. I get a small amount of people who when they go to the secure part of our site can't see the page, they either get a dns lookup error, a undefined variable error or just a blank page. But if I have them change the url from https:// to http:// they can see the page fine. Has anyone else run into this type of problem? The people who have had this problem say they can get to other secure sites fine. I'm kind of baffled. Thanks, Ben Ben Densmore Web Developer eSupport.com,Inc. 1538 Turnpike St. North Andover, MA 01845 Phone: (978) 686-6468 x333 Email: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CF 5 Hack
Can someone forward me the proper ethical procedure documentation referenced in the e-mail below. Thanks. Casey Cook Alex axs @m-net.arbornTo: CF-Talk [EMAIL PROTECTED] et.org cc: Subject: Re: CF 5 Hack 10/07/02 12:00 PM Please respond to cf-talk As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CF 5 Hack
I am following those procedures. I think I've been quite open about it. -mk -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:00 PM To: CF-Talk Subject: Re: CF 5 Hack As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CF 5 Hack
Alex, Would you like me to send you the number or email of my client so you can verify that I'm not doing anything funny? Exactly what would satisfy you beyond the honesty I've already displayed? -mk -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:00 PM To: CF-Talk Subject: Re: CF 5 Hack As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF 5 Hack
Ethical procedures: 1. The owner of the site have full right to know and change the passwords on the site. 2. Any developer must inform their employer of any passwords for the site. 3. A developer who leaves an employer should inform the employer of their change in work status as well as follow item 2. Two weeks notice is usual. In the case mentioned below, I see no issue of ethics that have to be examined or followed. The owner of the site wants access, simple as that. Can someone forward me the proper ethical procedure documentation referenced in the e-mail below. Thanks. Casey Cook As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Can a subscription site be classed as shipped goods
As long as the subscription starts immediately upon payment, you can charge the card. If the subscription starts next month or at some future point in time, you have to wait. Basically, you can grab the cash as soon as you deliver the contract, whether it's for service or material goods or subscriptions. There are numerous ways to slice and dice this, but it all boils down to the same thing. Did you give access to your goods or services? If yes, you can charge. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:33 PM To: CF-Talk Subject: OT: Can a subscription site be classed as shipped goods Hi - (sorry for the cross post) This is more legal than technical so excuse me if its OT. Apparently in the US, payment cannot be fully debited from a credit card until the goods have been shipped. If a site provides a subscription service does this count as goods already shipped? In addition to this what is the law regarding products which can be downloaded immediately ( with a CD to follow in the post). I know you guys are not lawyers but I figured some of you may have encountered this before Thanks in advance Oh and sorry for the cross post Kola Oyedeji Certified Advanced Coldfusion Developer, ICLP London DDI: +44 (0) 208 256 9034 www.iclployalty.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SSL problem
Have you checked the browser vers of the people having the problem, then checked the browser compatibility of the cert? Different certs have different compatibility. I have no idea if Thawte is handicapped over Verisign in this regard, but the cheapie GeoTrust and InstantSSL certs are. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 8:59 AM To: CF-Talk Subject: SOT:SSL problem Hey everyone, Maybe someone can give me an ideas as to what may cause this. We have 2 different websites, on the same server, one uses a Verisign Digital Certificate and the other uses a Thawte cert, I know Verisign owns both. I get a small amount of people who when they go to the secure part of our site can't see the page, they either get a dns lookup error, a undefined variable error or just a blank page. But if I have them change the url from https:// to http:// they can see the page fine. Has anyone else run into this type of problem? The people who have had this problem say they can get to other secure sites fine. I'm kind of baffled. Thanks, Ben Ben Densmore Web Developer eSupport.com,Inc. 1538 Turnpike St. North Andover, MA 01845 Phone: (978) 686-6468 x333 Email: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Custom Tags and CFX
So is there a separate list for 4.x questions now or did the whole list upgrade? :O -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 11:25 AM To: CF-Talk Subject: Custom Tags and CFX Does the 4.01 engine handle Custom Tags and CFX in the same manner as far as thread handling goes? From my understanding a CFX would be a third party request that CF passes off too, if there is no response back from that request the processing thread is lost until the server is restarted. Are Custom Tags handled in the same manner or basically just used like an include? Do newer CF versions offer better performance/error debugging, such as the logging of the template that the current thread/s are processing? or better yet the piece of code that is being processed? Thanks,Adrian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF 5 Hack
Yes he has. It wouldn't be following those procedures to say something like: Dreamweaver makes a directory on your server that has the name _MMServerScripts that allows one to brute force passwords - for RDS or Administrator. And, as a lovely addition, you can search google for _MMServerScripts to find a bunch of vulnerable sites. That would be bad, as it would point out blaring holes in security. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:17 AM To: CF-Talk Subject: RE: CF 5 Hack I am following those procedures. I think I've been quite open about it. -mk -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:00 PM To: CF-Talk Subject: Re: CF 5 Hack As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CF 5 Hack
search the archives listed on the footer of this message... you will find what you need probably by searching for RESET or password... -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Mark A. Kruger - CFG [EMAIL PROTECTED] Date: Mon, 7 Oct 2002 12:17:12 -0500 Subject: RE: CF 5 Hack I am following those procedures. I think I've been quite open about it. -mk -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:00 PM To: CF-Talk Subject: Re: CF 5 Hack As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Big Trouble in T-SQL land
This move to MX has been quite the learning experience. Now, we seem to be unable to create temporary tables. The following query returns 0 records in CFMX but 1 record in query analyzer. Anyone else? Suggestions? Glass of hemlock? CFQUERY NAME=test DATASOURCE=foobardb DBTYPE=ODBC SET NOCOUNT ON CREATE TABLE ##xyz (a varchar(10)) INSERT INTO ##xyz ( a )VALUES ( 'foo' ) SELECT * FROM ##xyz DROP TABLE ##xyz SET NOCOUNT OFF /CFQUERY We are using MX with SQL 7. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Big Trouble in T-SQL land
Try turning the NOCUNT OFF right before the SELECT * FROM ##xyz then back on for the drop? Just a SWAG, perhaps it is similar to resultsets from stored procedures... Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:21 PM To: CF-Talk Subject: Big Trouble in T-SQL land This move to MX has been quite the learning experience. Now, we seem to be unable to create temporary tables. The following query returns 0 records in CFMX but 1 record in query analyzer. Anyone else? Suggestions? Glass of hemlock? CFQUERY NAME=test DATASOURCE=foobardb DBTYPE=ODBC SET NOCOUNT ON CREATE TABLE ##xyz (a varchar(10)) INSERT INTO ##xyz ( a )VALUES ( 'foo' ) SELECT * FROM ##xyz DROP TABLE ##xyz SET NOCOUNT OFF /CFQUERY We are using MX with SQL 7. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Recall: Big Trouble in T-SQL land
Smith, Matthew P -CONT(DYN) would like to recall the message, Big Trouble in T-SQL land. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CF 5 Hack
What does that have to do with my problem? I'm coming in after the fact - the previous developer is the one who failed, we are just trying to clean up the mess. In this case, I am (of course!) giving all the information to the owner of the site. -mk -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:16 PM To: CF-Talk Subject: Re: CF 5 Hack Ethical procedures: 1. The owner of the site have full right to know and change the passwords on the site. 2. Any developer must inform their employer of any passwords for the site. 3. A developer who leaves an employer should inform the employer of their change in work status as well as follow item 2. Two weeks notice is usual. In the case mentioned below, I see no issue of ethics that have to be examined or followed. The owner of the site wants access, simple as that. Can someone forward me the proper ethical procedure documentation referenced in the e-mail below. Thanks. Casey Cook As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CFMX - I've never seen anything so unstable in my life
Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Big Trouble in T-SQL land
Try turning the NOCOUNT OFF right before the SELECT * FROM ##xyz then back on for the drop? Just a SWAG, perhaps it is similar to resultsets from stored procedures... Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:21 PM To: CF-Talk Subject: Big Trouble in T-SQL land This move to MX has been quite the learning experience. Now, we seem to be unable to create temporary tables. The following query returns 0 records in CFMX but 1 record in query analyzer. Anyone else? Suggestions? Glass of hemlock? CFQUERY NAME=test DATASOURCE=foobardb DBTYPE=ODBC SET NOCOUNT ON CREATE TABLE ##xyz (a varchar(10)) INSERT INTO ##xyz ( a )VALUES ( 'foo' ) SELECT * FROM ##xyz DROP TABLE ##xyz SET NOCOUNT OFF /CFQUERY We are using MX with SQL 7. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CF 5 Hack
Nothing at all. That's the point of what I was saying. All you need is the means to access the admin password and that's been described already. There are no ethical issues that I can see. What does that have to do with my problem? I'm coming in after the fact - the previous developer is the one who failed, we are just trying to clean up the mess. In this case, I am (of course!) giving all the information to the owner of the site. -mk -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:16 PM To: CF-Talk Subject: Re: CF 5 Hack Ethical procedures: 1. The owner of the site have full right to know and change the passwords on the site. 2. Any developer must inform their employer of any passwords for the site. 3. A developer who leaves an employer should inform the employer of their change in work status as well as follow item 2. Two weeks notice is usual. In the case mentioned below, I see no issue of ethics that have to be examined or followed. The owner of the site wants access, simple as that. Can someone forward me the proper ethical procedure documentation referenced in the e-mail below. Thanks. Casey Cook As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFMX - I've never seen anything so unstable in my life
Well, I have had the problem of it losing a connection to SQL Server via JDBC, that is the only problem I have had but has prevented me from buying the full version for use in the company I work for. Other than that it works great, but I can't have these connection reset errors coming up every few minutes. Ben -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:31 PM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
I lost my brain - checkboxes
Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td /tr /cfloop So here is my problem. When a checkbox (or more) is checked, I do this SQL statement: UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great. However, if I deselect the checkbox I no longer have the SID: UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID). So how do I do this? I want to set the Hot field to 1 on only the SID when checked and if i deselect it, then i want the field to be set to 0 on the SID i deselect. The default value in the Hot (bit) field is 0. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CF 5 Hack
Yeah, change the registry setting. Either with the cfregistry tag or regedit. cfregistry action=SET branch=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Server entry=UseAdminPassword type=String value=0 Cheers, Sam - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 12:30 PM Subject: CF 5 Hack Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Comma-Space as delimiter
When working with Lists, I'm finding that you can't specify a delimiter of comma-space (, ). CF is treating this as , OR . How do I tell it to delimit as comma-space? The ListAppend function in the Reference states you can use , CHR(32) in the delimiter parameter but it doesn't work. -- Bruce Holm Web Developer Lattice Semiconductor [EMAIL PROTECTED] -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: I lost my brain - checkboxes
You could do a second update as follows: Update survey Set hot = 0 Where SID not in (10,17) A warning though: A not in query only runs well on well-indexed or small tables. If your table doesn't meet those standards then you'd be better off getting the whole list of SIDs as a list and removing the ones that were checked then running the in statement with the remainder. Margaret -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:39 AM To: CF-Talk Subject: I lost my brain - checkboxes Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td /tr /cfloop So here is my problem. When a checkbox (or more) is checked, I do this SQL statement: UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great. However, if I deselect the checkbox I no longer have the SID: UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID). So how do I do this? I want to set the Hot field to 1 on only the SID when checked and if i deselect it, then i want the field to be set to 0 on the SID i deselect. The default value in the Hot (bit) field is 0. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Commit one query while rolling back the rest within a CFTRANSACTION
I have a piece of code that has CFTRANSACTION tags around it. When the credit card authorization fails, I roll back all the queries, however I would like to insert a record into a log table. Is there a way to do that? Russ Example cftransaction action=begin cftry some credit card processing code here cfif session.card.status neq APPROVED cfthrow type=creditcard /cfif cftransaction action=commit cfcatch type=CreditCard cftransaction action=ROLLBACK/ cfquery name=qryAddTransactionLog datasource=#request.dsn# query I want to run /cfquery cflocation url=order.cfm /cfcatch /cftry /cftransaction ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: I lost my brain - checkboxes
I always delete ALL previous selections from the DB and then insert the new ones...that way everything stays current and the coding is dead simple. HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tony Carcieri [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 10:39 AM Subject: I lost my brain - checkboxes Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td /tr /cfloop So here is my problem. When a checkbox (or more) is checked, I do this SQL statement: UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great. However, if I deselect the checkbox I no longer have the SID: UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID). So how do I do this? I want to set the Hot field to 1 on only the SID when checked and if i deselect it, then i want the field to be set to 0 on the SID i deselect. The default value in the Hot (bit) field is 0. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Comma-Space as delimiter
You can't. You must use replace() to replace the comma/space with a single character that you can use as the delimiter. The bell character works well since it can't be typed (chr(7)). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:45 AM To: CF-Talk Subject: Comma-Space as delimiter When working with Lists, I'm finding that you can't specify a delimiter of comma-space (, ). CF is treating this as , OR . How do I tell it to delimit as comma-space? The ListAppend function in the Reference states you can use , CHR(32) in the delimiter parameter but it doesn't work. -- Bruce Holm Web Developer Lattice Semiconductor [EMAIL PROTECTED] -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Variable locking
On Monday, Oct 7, 2002, at 01:38 US/Pacific, Kola Oyedeji wrote: I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? The last part is relatively easy to answer: yes, you only need locks when a race condition could occur. The first part is slightly harder to answer: in general, named locks allow finer grained control over locking and therefore will cause fewer lock contentions between requests. Consider a couple of variables in server scope: in CF5 (and earlier) you had to use scope=server to protect access to such variables so any code accessing one of those variables would block any code accessing the other variable. In CFMX, it is safe to use a named lock instead, with a different lock name for each variable: !--- page1.cfm : CF5 scoped lock --- cflock scope=server type=exclusive cfset server.a = 42 /cflock !--- page2.cfm : CF5 scoped lock --- cflock scope=server type=exclusive cfset server.b = 77 /cflock While page1.cfm is executing, page2.cfm would block. In CFMX you can do this: !--- page1.cfm : CFMX named lock --- cflock scope=server_a type=exclusive cfset server.a = 42 /cflock !--- page2.cfm : CFMX named lock --- cflock scope=server_b type=exclusive cfset server.b = 77 /cflock Now the pages won't block each other (obviously multiple requests to page1.cfm will block each other but page2.cfm wouldn't be affected). That's easy enough for application and server scope because the name is easy to figure out. For session scope, you need a name that is unique to your session which may be harder to invent (you could perhaps use a user ID if it exists or a per-session UUID). OTOH, race conditions within session scope are probably going to be rarer because they can only occur if you have multiple windows or frames open with the same session data (frames are evil, in my opinion, so I'm not very sympathetic to people who get into a session integrity mess when they use frames! :) If it's too hard to come up with a unique name for your lock, using scope= may be the easiest solution for you. Since the shared scope corruption problem is no longer an issue in CFMX, there are many cases where you safely omit the lock altogether (for example, if the assignment is 'atomic' and all request would store the same value - or it doesn't matter which request actually stores the value, e.g., the application just needs *a* value in the shared scope variable). Hope that helps clarify? An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFMX - I've never seen anything so unstable in my life
Ben, I've seen that socket reset error too. Does anyone have an idea why it occurs? -mk -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:37 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Well, I have had the problem of it losing a connection to SQL Server via JDBC, that is the only problem I have had but has prevented me from buying the full version for use in the company I work for. Other than that it works great, but I can't have these connection reset errors coming up every few minutes. Ben -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:31 PM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CF 5 Hack
I was kidding. You could decrypt the Application.cfm page in the admin section and change authentication or do the registry change as mentioned. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Alex, Would you like me to send you the number or email of my client so you can verify that I'm not doing anything funny? Exactly what would satisfy you beyond the honesty I've already displayed? -mk -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:00 PM To: CF-Talk Subject: Re: CF 5 Hack As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get in to the administrator. Short of re-installing, does anyone remember the hack to reset the password? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
Just so you know there is a patch on the smack-romedia site that might help (don't know the address though). We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently existing cf code is - it runs like a champ. It is *very* obvious that the project was pushed out the door without being tested well, or at least tested in some sort of large production environment - probably do to the dropping stock. Don't give up just yet as this appears to be the way cf is going, and if you give up your site will be stuck in old technology. either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Good luck, Rob -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Comma-Space as delimiter
sub-optimal but Replace(String,', ',chr(07),'all') would leave you a bell delimited list... How do I tell it to delimit as comma-space? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX - I've never seen anything so unstable in my life
Maybe Microsoft really owns Macromedia and is dilluting the market with unstable products in a effort to move everyone to a single Microsoft platform... Or maybe it is just the fact that your using a little older database in which a small portion of testing was conducted upon. - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 10:56 AM Subject: RE: CFMX - I've never seen anything so unstable in my life Ben, I've seen that socket reset error too. Does anyone have an idea why it occurs? -mk -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:37 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Well, I have had the problem of it losing a connection to SQL Server via JDBC, that is the only problem I have had but has prevented me from buying the full version for use in the company I work for. Other than that it works great, but I can't have these connection reset errors coming up every few minutes. Ben -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:31 PM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: I lost my brain - checkboxes
I've done stuff where I also pass the universe of values as a hidden tag. So if you have: cfloop query=qry input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput /cfloop I would also put: input type=hidden name=listofleads value=cfoutput#ValueList(qry.SID)#/cfoutput Now on your next page you'll have the SIDs that are checked as well as all the SIDs. Some simple list manipulation (and there are some good UDFs at cflib.org for that) and you'll have all you need. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:39 PM To: CF-Talk Subject: I lost my brain - checkboxes Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td /tr /cfloop So here is my problem. When a checkbox (or more) is checked, I do this SQL statement: UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great. However, if I deselect the checkbox I no longer have the SID: UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID). So how do I do this? I want to set the Hot field to 1 on only the SID when checked and if i deselect it, then i want the field to be set to 0 on the SID i deselect. The default value in the Hot (bit) field is 0. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
auto tag completion
Hi All, Perhaps this has been covered (but I couldn't find it in the archive).. I used to use the auto completion feature in CF pre-DWMX. Does that feature exist in DWMX. -- Joe Zanter, Materials Lab, Woodward Aircraft Engine Systems 5001 North 2nd Street, Rockford IL 61125 ph 815-639-6312, fx 815-639-5104 mailto:[EMAIL PROTECTED] How much fruit could a fruitbat bat if a fruitbat could bat fruit? *** The information in this e-mail is confidential and intended solely for the individual or entity to whom it is addressed. If you have received this e-mail in error please notify the sender by return e-mail, delete this e-mail, and refrain from any disclosure or action based on the information. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMX - I've never seen anything so unstable in my life
Rob, If you get an answer to the JDBC Drivers please let us know, I have been asking for like 2 months now, trying to figure out what's going on. And have not gotten an answer, I've used the updater, Installed all the newest sp's for SQL Server and still nothing. Thanks, Ben -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:57 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Just so you know there is a patch on the smack-romedia site that might help (don't know the address though). We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently existing cf code is - it runs like a champ. It is *very* obvious that the project was pushed out the door without being tested well, or at least tested in some sort of large production environment - probably do to the dropping stock. Don't give up just yet as this appears to be the way cf is going, and if you give up your site will be stuck in old technology. either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Good luck, Rob -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 10:30 US/Pacific, Dave Wilson wrote: Is it just me, or is CFMX proving totally unstable for everyone else too? It isn't *just* you but it is certainly a minority. Unfortunately, mailing lists like this (and the webforums) are typically where people come when they have problems so things seem worse than they are - we don't see legions of people piping up and saying It works just fine for me!... I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. That sounds unusually unstable. Perhaps applying the Updater will resolve some of your problems but it sounds to me like something else is wrong in your environment. Hopefully folks here can help you resolve it. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. We have CFMX running on Solaris backed by Oracle for some applications in production (ColdFusion Examples app, various Flash / Flash Remoting / CFMX examples, PetMarket) and these have been running just fine for months without needing any attention (except when we upgraded to Apache 2.x and broke some connector mappings - but that was our bad!). We have been running CFMX internally for many, many months and have experienced very few stability problems (we had a badly-behaved Java tag library that occasionally hung JRun but not much apart from that). An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm