Re: How can I ORDER BY RANDOM ?
Tom Forbes wrote: I need to modify the below query so that my results are still ordered by ClassOfService (a number between 1 and 4) - BUT, the CompanyName needs to be displayed in a RANDOM ORDER each time the query is run, rather than its current alphabetical order. This will give all companies that participate an even advantage of being selected rather than those that begin with the first letters of the alphabet. Usually I do: SELECT fields FROMtables WHERE predicates ORDER BY Random() It might be that your database does not support that because the Random() function needs to be seeded or else it will generate the same sequence every time. In that case, seed it with a different random number for each row. This different random number is best obtained by taking the primary key (different) and add a number (random). SELECT fields FROMtables WHERE predicates ORDER BY Random(PrimaryKey + cfqueryparam cfsqltype=cf_sql_integer value=#RandRange(1,99)#) This might be a little hard on your CPU when you have many records. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Community recommendations?
Paul Campano wrote: I am looking to build a community website for my apartment building of almost 200 units. I would like to have a members area with forums, the ability to add news stories and other community functions. Could someone recommend a free or low cost solution? I am doing this as a freebee, so I'm on my own as far as funding goes. If you want to stay with CFML and still spend little money you might want to look into AssetNow Personal Edition http://www.assetnow.com/ I believe they are working on an edition for BlueDragon as well. Combine it with any of the numerous forum applications and you should be done pretty soon. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hiding JavaScript codes
Costas Piliotis wrote: The only way for one to do this is if they know how to pass their own http headers. And then they need to know that you're looking at that particular cgi variable, and they need to know what you're comparing to as well. Too much trouble for a little piece of javascript IMHO... No, you just need to use the header-replay feature from Mozilla. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Community recommendations?
If his use doesn't qualify for their free personal edition, then that will cost at least US$995. My CMPro cms is US$350. One of my customers is a private dormitory at UC Berkeley, where the residents each get their own web pages, can pay their rent online using a form generated by the auto-form generator and a bunch of other stuff. Add in an inexpensive forum and you're up and running for a lot less. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com I've stopped 47,943 spam messages. You can too! Get your free, safe spam protection at http://www.cloudmark.com/spamnetsig/ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:22 AM To: CF-Talk Subject: Re: CF Community recommendations? Paul Campano wrote: I am looking to build a community website for my apartment building of almost 200 units. I would like to have a members area with forums, the ability to add news stories and other community functions. Could someone recommend a free or low cost solution? I am doing this as a freebee, so I'm on my own as far as funding goes. If you want to stay with CFML and still spend little money you might want to look into AssetNow Personal Edition http://www.assetnow.com/ I believe they are working on an edition for BlueDragon as well. Combine it with any of the numerous forum applications and you should be done pretty soon. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Community recommendations?
Matt Robertson wrote: If his use doesn't qualify for their free personal edition, then that will cost at least US$995. The way I read the license and his requirements he qualifies. My CMPro cms is US$350. One of my customers is a private dormitory at UC Berkeley Berkeley? As in BSD? And they don't have a resident that writes this sort of thing in Haskell or some other obscure language? What is wrong with the world lately? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Community recommendations?
I've not used it / reviewed it / looked at it yet - it's on my to do list (for situations like yours!) :-) http://www.ultraapps.com/freecommunitywebportal.html -Original Message- From: Paul Campano [mailto:[EMAIL PROTECTED] Sent: Thursday 03 April 2003 23:42 To: CF-Talk Subject: CF Community recommendations? I am looking to build a community website for my apartment building of almost 200 units. I would like to have a members area with forums, the ability to add news stories and other community functions. Could someone recommend a free or low cost solution? I am doing this as a freebee, so I'm on my own as far as funding goes. Thanks. Paul Campano ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Community recommendations?
Jochem wrote: Berkeley? As in BSD? And they don't have a resident that writes this sort of thing in Haskell or some other obscure language? What is wrong with the world lately? In Berserkeley ??? Expect the unexpected in the People's Republic. :D --Matt-- Berkeley? As in BSD? And they don't have a resident that writes this sort of thing in Haskell or some other obscure language? What is wrong with the world lately? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 5 For Sale?
Anyone have Cold Fusion 5 Pro for sale? Where can I obtain...everything I see is for MX... eBay? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: -OT- Adding a button to IE
Is it possible to add a button to IE that will open a new window and load a webpage? Would one have to write it in VBscript? Do you mean on your machine, or on a visitors? If you're talking about a visitors, then I think that might be classed under hacking... On your own, you can add buttons to the Links bar by adding it to the Links folder in your Favorites ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple forms, looping and inserting
Similar to Matt's solution, but name your Form fields with a numeric extension input type=text name=Name_#i# value=#HTMLeditFormat(Form[Name_#i#])# Then when you're inserting, just use the form[Name_#i#] Remember to pass the number of entries along with the form, otherwise you won't know how many to loop over I'd use the underscore to separate the field name from the number HTH -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:56 AM To: CF-Talk Subject: Multiple forms, looping and inserting Ok, so I have an idea, but I'm not sure how to carry it through. I have a basic insert record page. However, I want the person to be able to add 5, 10, or 15 records at a time, depending on the value they select from a drop-down. Meaning, depending on how many they want to add, there will be that many forms, and one submit button to add all the records. I'm thinking I need a loop somewhere, but not sure where. Any help is greatly appreciated! Here's what I have so far: addSite.cfm: form name=MultiForm action=addSite.cfm?MultiForm=TRUENumForms=#NumForms# select name=NumForms option value=55/option option value=10 selected10/option option value=1515/option /select input name= type=submit value=Show /form cfif MultiForm IS True form action=addSite2.cfm method=post name=addSite cfloop from=0 to=URL.NumForms index=i table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p/cfloop /form cfelse form action=addSite2.cfm method=post name=addSite table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p /form /cfif The problem is that the page is trying to run the loop regardless of if the upper form has been submitted or not. And then it says that my to value is invalid because it isn't a simple data type. Thanks for taking the time to read my rambling :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Count(*) Query
I have a table that has one field that holds numbers 1 thru 9. Can I run a single query that will give me the count(*) of 1's, count(*) of 2's, etc. or do I have to run a separate query for each? Thanks to all, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Count(*) Query
I have a table that has one field that holds numbers 1 thru 9. Can I run a single query that will give me the count(*) of 1's, count(*) of 2's, etc. or do I have to run a separate query for each? Do you want them in one row, or one row per number? The SQL is a lot bigger for one row, but here they are This will give you only 1-9 and one row per number; SELECT number, Count(number) as Counted FROM table GROUP BY number HAVING number BETWEEN 1 AND 9 ORDER BY number This will give you one row with all 9 values; SELECT TOP 1 (SELECT count(number) FROM table WHERE number=1) as Count1, (SELECT count(number) FROM table WHERE number=2) as Count2, (SELECT count(number) FROM table WHERE number=3) as Count3, (SELECT count(number) FROM table WHERE number=4) as Count4, (SELECT count(number) FROM table WHERE number=5) as Count5, (SELECT count(number) FROM table WHERE number=6) as Count6, (SELECT count(number) FROM table WHERE number=7) as Count7, (SELECT count(number) FROM table WHERE number=8) as Count8, (SELECT count(number) FROM table WHERE number=9) as Count9 FROM table HTH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple forms, looping and inserting
Thanks to Matt and Philip for helping out with this. I have the form page displaying correctly now. HOWEVER, (and there always is one with me) I thought of one of those user-error things. What if the user tells the page she wants to add 10 records, but only fills in eight of them? If I use the initial loop value (which I am calling NumForms) there will be empty records added. Any ideas? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 4/4/2003 5:09:07 AM Similar to Matt's solution, but name your Form fields with a numeric extension input type=text name=Name_#i# value=#HTMLeditFormat(Form[Name_#i#])# Then when you're inserting, just use the form[Name_#i#] Remember to pass the number of entries along with the form, otherwise you won't know how many to loop over I'd use the underscore to separate the field name from the number HTH -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:56 AM To: CF-Talk Subject: Multiple forms, looping and inserting Ok, so I have an idea, but I'm not sure how to carry it through. I have a basic insert record page. However, I want the person to be able to add 5, 10, or 15 records at a time, depending on the value they select from a drop-down. Meaning, depending on how many they want to add, there will be that many forms, and one submit button to add all the records. I'm thinking I need a loop somewhere, but not sure where. Any help is greatly appreciated! Here's what I have so far: addSite.cfm: form name=MultiForm action=addSite.cfm?MultiForm=TRUENumForms=#NumForms# select name=NumForms option value=55/option option value=10 selected10/option option value=1515/option /select input name= type=submit value=Show /form cfif MultiForm IS True form action=addSite2.cfm method=post name=addSite cfloop from=0 to=URL.NumForms index=i table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p/cfloop /form cfelse form action=addSite2.cfm method=post name=addSite table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p /form /cfif The problem is that the page is trying to run the loop regardless of if the upper form has been submitted or not. And then it says that my to value is invalid because it isn't a simple data type. Thanks for taking the time to read my rambling :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple forms, looping and inserting
Hmm...could just check if they are empty?? And only add to the database if they are not empty? So loop over the fields during the insert query, and only run the insert query if the field is NEQ . So even if they select 15 records and only actually fill out 5 you won't try to insert anything. CFLOOP FROM=1 TO=#form.Numforms# index=j CFIF form.Name_#j# NEQ CFQUERY name=insertrecords datasource=#DSN# .. .. .. /CFQUERY /CFIF /CFLOOP ?? Okies..maybe not.. *sneaks away quietly* -Gel -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Thanks to Matt and Philip for helping out with this. I have the form page displaying correctly now. HOWEVER, (and there always is one with me) I thought of one of those user-error things. What if the user tells the page she wants to add 10 records, but only fills in eight of them? If I use the initial loop value (which I am calling NumForms) there will be empty records added. Any ideas? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 4/4/2003 5:09:07 AM Similar to Matt's solution, but name your Form fields with a numeric extension input type=text name=Name_#i# value=#HTMLeditFormat(Form[Name_#i#])# Then when you're inserting, just use the form[Name_#i#] Remember to pass the number of entries along with the form, otherwise you won't know how many to loop over I'd use the underscore to separate the field name from the number HTH -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:56 AM To: CF-Talk Subject: Multiple forms, looping and inserting Ok, so I have an idea, but I'm not sure how to carry it through. I have a basic insert record page. However, I want the person to be able to add 5, 10, or 15 records at a time, depending on the value they select from a drop-down. Meaning, depending on how many they want to add, there will be that many forms, and one submit button to add all the records. I'm thinking I need a loop somewhere, but not sure where. Any help is greatly appreciated! Here's what I have so far: addSite.cfm: form name=MultiForm action=addSite.cfm?MultiForm=TRUENumForms=#NumForms# select name=NumForms option value=55/option option value=10 selected10/option option value=1515/option /select input name= type=submit value=Show /form cfif MultiForm IS True form action=addSite2.cfm method=post name=addSite cfloop from=0 to=URL.NumForms index=i table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p/cfloop /form cfelse form action=addSite2.cfm method=post name=addSite table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p /form /cfif The problem is that the page is trying to run the loop regardless of if the upper form has been submitted or not. And then it says that my to value is invalid because it isn't a simple data type. Thanks for taking the time to read my rambling :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple forms, looping and inserting
Sounds like a plan, thanks Gel. I'll try it out when I get home :) okies?? ;) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 4/4/2003 8:25:30 AM Hmm...could just check if they are empty?? And only add to the database if they are not empty? So loop over the fields during the insert query, and only run the insert query if the field is NEQ . So even if they select 15 records and only actually fill out 5 you won't try to insert anything. CFLOOP FROM=1 TO=#form.Numforms# index=j CFIF form.Name_#j# NEQ CFQUERY name=insertrecords datasource=#DSN# .. .. .. /CFQUERY /CFIF /CFLOOP ?? Okies..maybe not.. *sneaks away quietly* -Gel -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Thanks to Matt and Philip for helping out with this. I have the form page displaying correctly now. HOWEVER, (and there always is one with me) I thought of one of those user-error things. What if the user tells the page she wants to add 10 records, but only fills in eight of them? If I use the initial loop value (which I am calling NumForms) there will be empty records added. Any ideas? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 4/4/2003 5:09:07 AM Similar to Matt's solution, but name your Form fields with a numeric extension input type=text name=Name_#i# value=#HTMLeditFormat(Form[Name_#i#])# Then when you're inserting, just use the form[Name_#i#] Remember to pass the number of entries along with the form, otherwise you won't know how many to loop over I'd use the underscore to separate the field name from the number HTH -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:56 AM To: CF-Talk Subject: Multiple forms, looping and inserting Ok, so I have an idea, but I'm not sure how to carry it through. I have a basic insert record page. However, I want the person to be able to add 5, 10, or 15 records at a time, depending on the value they select from a drop-down. Meaning, depending on how many they want to add, there will be that many forms, and one submit button to add all the records. I'm thinking I need a loop somewhere, but not sure where. Any help is greatly appreciated! Here's what I have so far: addSite.cfm: form name=MultiForm action=addSite.cfm?MultiForm=TRUENumForms=#NumForms# select name=NumForms option value=55/option option value=10 selected10/option option value=1515/option /select input name= type=submit value=Show /form cfif MultiForm IS True form action=addSite2.cfm method=post name=addSite cfloop from=0 to=URL.NumForms index=i table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p/cfloop /form cfelse form action=addSite2.cfm method=post name=addSite table width=100% border=0 cellspacing=2 cellpadding=5 tr td width=24% class=copyTealdiv align=rightAuthor Name: /div/td td width=76%input name=Website_author type=text id=Website_author/td /tr tr td class=copyTealdiv align=rightWebsite link:/div/td tdp input name=Website_Link type=text id=Website_Link size=45 /p pspan class=tealHeaderPlease include the http:// and remember to verify the link's accuracy./span/p/td /tr /table p class=tealHeader input type=submit value=Continue /p /form /cfif The problem is that the page is trying to run the loop regardless of if the upper form has been submitted or not. And then it says that my to value is invalid because it isn't a simple data type. Thanks for taking the time to read my rambling :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads
Re: CF Server Mappings
Thanks Barney, Al, Chris On 4/3/2003 5:11 PM, Barney Boisvert [EMAIL PROTECTED] wrote: This is somewhat off topic, but if you don't want to put settings like this in every directory's Application.cfm, just set up your Application.cfm files to cascade. Then you can abstract things up to a single place: /Application.cfm cfset request.dsn = asdf / cfif cgi.remote_addr EQ 1.1.1.1 cfset path = dev/ / cfelse cfset path = prod/ / /cfif !--- global application variables --- /users/Application.cfm -- cfinclude template=../Application.cfm / !--- user directory specific app variables --- /products/Application.cfm - cfinclude template=../Application.cfm / cfset request.catalog_dsn = whatever / /products/order/Application.cfm - cfinclude template=../Application.cfm / cfset request.payment_gateway = 1.1.1.2 / --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 2:03 PM To: CF-Talk Subject: Re: CF Server Mappings What I do is set a variable in the application.cfm called path, and then whereever you need a mapping, just use: #path# for example, instead of dev/images you set #path# = 'dev/' then call: #path#images I actually use a little conditional logic in the application.cfm to automate it.. I set the path depending on the ip address of the host. This way I can move it from my development machine to the server, which has a different directory structure, but the conditional logic is just in 1 place (per directory), not all over the place. Al At 09:25 AM 4/3/2003, Matt Kornguth wrote: Think the answer to this is No, but worth a try: We recently moved our development and staging sites onto the same physical server running CF 5.0. We are running into the situation where our CF server mappings are pointing to specific directories on EITHER dev or staging. So, when working on dev, we may have to change a file in a mapped directory on staging ... or vice versa. Anyone know of a way (without conditional coding) to have the same server mapping point to the correct mapped directory (i.e. dev when on dev, staging when on staging)? I know multiple instances of CF are not possible with 5.0, so any thoughts? Hope I conveyed the problem OK. Thanks for your help, Matt Kornguth BLR.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: compare
Thanks, but I think I should explain this a little better... Col002 is a text (varchar in SQL) field imported from a log file which displays a date such as 04/04/03. I need to compare this field, 04/04/03, using the dateformat command which gives me the current numeric(?) date. Using the examples below I get a blank screen with no errors but no date comparison. Robert O. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:21 PM To: CF-Talk Subject: RE: compare I think you just need more quotes: cfquery name=getsomedata datasource=application_log select * from application2 where col002 = '#dateformat(now(), MM/DD/YY)#' /cfquery -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Robert Orlini [mailto:[EMAIL PROTECTED] : Sent: Thursday, April 03, 2003 4:08 PM : To: CF-Talk : Subject: compare : : : I'm using an SQL table and comparing a date column which was : imported from a log file. The date is setup as a varchar not a : number. I would it so that the varchar date in the column can be : compared with the current date (which of course is a number) : using dateformat. : : The code I have is: : : cfquery name=getsomedata datasource=application_log : select * from application2 : where col002 = #dateformat(now(),'MM/DD/YY')# : /cfquery : : This of course does not work. What can I code in the where : col002 section that compares the varchar date (which is written : 04/03/03) with the current date using the CF dateformat command? : : Thanks! : : Robert O. : HWW : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple forms, looping and inserting
Yesh! Okies! :) -Gel -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sounds like a plan, thanks Gel. I'll try it out when I get home :) okies?? ;) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Count(*) Query
You could do something like this: SELECT TOP 1 (select count(qty) from items where qty = 1) AS num_1s, (select count(qty) from items where qty = 2) AS num_2s FROM items GROUP BY qty I'm sure there's a more efficient way to do this, but this should work. - Original Message - From: Hawkes, Keith A CIV [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 6:17 AM Subject: Count(*) Query I have a table that has one field that holds numbers 1 thru 9. Can I run a single query that will give me the count(*) of 1's, count(*) of 2's, etc. or do I have to run a separate query for each? Thanks to all, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Count(*) Query
SELECT Count(NumbersField) AS CountOfField FROM table1 GROUP BY NumbersField That does it, I tried it. Matt Small -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 7:18 AM To: CF-Talk Subject: Count(*) Query I have a table that has one field that holds numbers 1 thru 9. Can I run a single query that will give me the count(*) of 1's, count(*) of 2's, etc. or do I have to run a separate query for each? Thanks to all, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfparam
Anyone else thing cfparam would be more useful when if using it like this... cfparam name=URL.id default=0 type=numeric ...was the same as using... cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id) cfset URL.id = 0 /cfif ...so the param kicks in if URL.id isn't defined OR if it isn't a number? I'd never really used the type attribute in cfparam before and I was hoping this was the way it worked. Oh well :O( Adrian Lynch Web Developer Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfparam
cfparam name=URL.id default=0 type=numeric ...was the same as using... cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id) cfset URL.id = 0 /cfif ...so the param kicks in if URL.id isn't defined OR if it isn't a number? Correct. If url.id = ray, then you would get an error. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfparam
Afaik, with the cfparam name=URL.id default=0 type=numeric if URL.ID is passed in as 8nb3b23k then it will throw an error, where as the if not defined or not numeric code will still run... HTH -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, April 4, 2003 15:29 To: CF-Talk Subject: cfparam Anyone else thing cfparam would be more useful when if using it like this... cfparam name=URL.id default=0 type=numeric ...was the same as using... cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id) cfset URL.id = 0 /cfif ...so the param kicks in if URL.id isn't defined OR if it isn't a number? I'd never really used the type attribute in cfparam before and I was hoping this was the way it worked. Oh well :O( Adrian Lynch Web Developer Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfparam
Prob is that CF doesn't set the datatype of a variable on creation (as in other languages). It determines it when it is referenced or tested. Guess it's good in some ways and bad in others. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 15:29 To: CF-Talk Subject: cfparam Anyone else thing cfparam would be more useful when if using it like this... cfparam name=URL.id default=0 type=numeric ...was the same as using... cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id) cfset URL.id = 0 /cfif ...so the param kicks in if URL.id isn't defined OR if it isn't a number? I'd never really used the type attribute in cfparam before and I was hoping this was the way it worked. Oh well :O( Adrian Lynch Web Developer Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re:Count(*) Query
Use the aggregate functions GROUP BY and WITH ROLLUP. I just tested this and it should work just fine for what you're trying to do. Good luck. SELECT numberColumn, COUNT(numberColumn) AS total FROMnumberTable GROUP BYnumberColumn WITH ROLLUP ORDER BYnumberColumn ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re:Count(*) Query
Actually, didn't need the WITH ROLLUP. It works just fine like this as well. WITH ROLLUP gives you a grand total as well which you probably don't need. SELECT number, COUNT(number) AS total FROMnumberTable GROUP BYnumber ORDER BYnumber ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfparam
I understand what it's doing, but I'd rather it worked like the example I gave than throw an error. Ade -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 15:32 To: CF-Talk Subject: RE: cfparam cfparam name=URL.id default=0 type=numeric ...was the same as using... cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id) cfset URL.id = 0 /cfif ...so the param kicks in if URL.id isn't defined OR if it isn't a number? Correct. If url.id = ray, then you would get an error. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Count(*) Query
SELECT Count(NumbersField) AS CountOfField FROM table1 GROUP BY NumbersField That does it, I tried it. But you only get the Count, so you don't know what it's a count of... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: compare
Have you tried doing something like LTrim(RTrim(Col002)) in case you're accidentally importing spaces? I'm just trying to think of anything, because it looks to me like the query ought to run properly. Have you tried running the query from the equivalent of Query Analizer, so you can play with it easily? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Robert Orlini [mailto:[EMAIL PROTECTED] : Sent: Friday, April 04, 2003 8:45 AM : To: CF-Talk : Subject: RE: compare : : : Thanks, but I think I should explain this a little better... : : Col002 is a text (varchar in SQL) field imported from a log file : which displays a date such as 04/04/03. : I need to compare this field, 04/04/03, using the dateformat : command which gives me the current numeric(?) date. Using the : examples below I get a blank screen with no errors but no date comparison. : : Robert O. : : -Original Message- : From: Ben Doom [mailto:[EMAIL PROTECTED] : Sent: Thursday, April 03, 2003 4:21 PM : To: CF-Talk : Subject: RE: compare : : : I think you just need more quotes: : : cfquery name=getsomedata datasource=application_log : select * from application2 : where col002 = '#dateformat(now(), MM/DD/YY)#' : /cfquery : : : -- Ben Doom : Programmer General Lackey : Moonbow Software, Inc : : : -Original Message- : : From: Robert Orlini [mailto:[EMAIL PROTECTED] : : Sent: Thursday, April 03, 2003 4:08 PM : : To: CF-Talk : : Subject: compare : : : : : : I'm using an SQL table and comparing a date column which was : : imported from a log file. The date is setup as a varchar not a : : number. I would it so that the varchar date in the column can be : : compared with the current date (which of course is a number) : : using dateformat. : : : : The code I have is: : : : : cfquery name=getsomedata datasource=application_log : : select * from application2 : : where col002 = #dateformat(now(),'MM/DD/YY')# : : /cfquery : : : : This of course does not work. What can I code in the where : : col002 section that compares the varchar date (which is written : : 04/03/03) with the current date using the CF dateformat command? : : : : Thanks! : : : : Robert O. : : HWW : : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hiding JavaScript codes
Costas Piliotis wrote: cfparam name=cgi.http_referer default= cfif cgi.http_referer eq cfabort/cfif at the top. Then, in your script, just enter: script language=javascript src=temp.cfm/script Costas Piliotis also wrote: The only way for one to do this is if they know how to pass their own http headers. And then they need to know that you're looking at that particular cgi variable, and they need to know what you're comparing to as well. Too much trouble for a little piece of javascript IMHO... Sorry if I'm coming late to the party, but you don't need to spoof headers at all. What follows is the high-tech security breaker: A HREF=temp.cfmclick here to d/l the JS file/A -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfparam
ugh...CFCATCH Doug -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:54 AM To: CF-Talk Subject: RE: cfparam I understand what it's doing, but I'd rather it worked like the example I gave than throw an error. Ade -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 15:32 To: CF-Talk Subject: RE: cfparam cfparam name=URL.id default=0 type=numeric ...was the same as using... cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id) cfset URL.id = 0 /cfif ...so the param kicks in if URL.id isn't defined OR if it isn't a number? Correct. If url.id = ray, then you would get an error. === = === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Server Mappings
On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote: Looking forward to our transition to CFMX for J2EE and multiple instances of CF! Depends - we haven't be able to achive this with j2EE on WebLogic. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Count(*) Query
You're right, I didn't see your query when I wrote this one. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:52 AM To: CF-Talk Subject: RE: Count(*) Query SELECT Count(NumbersField) AS CountOfField FROM table1 GROUP BY NumbersField That does it, I tried it. But you only get the Count, so you don't know what it's a count of... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re:OT: Outer Join
I think changing INNER JOIN csite c to FULL OUTER JOIN csite c will work. And I think you might have to add OR c.id IS NULL ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfmx and clientmanagement-problem
Hi list, this is the email of a friend: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FED-Ex API calls
Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FED-Ex API calls
Now why on earth would you want to interface with FedEx? :) After all UPS is now Synchronizing Commerce. Rob UPS Developer -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:18 AM To: CF-Talk Subject: FED-Ex API calls Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfcookie expires syntax
I would like to expire a cookie after 10 min. Something is not correct with my syntax any ideas? cfset foo = DateAdd(n, 10, Now()) cfcookie name = MYCOOKIE value = #Now()# expires = #foo# thanks! sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FED-Ex API calls
Plus, UPS has a spiffy new Logo! Edwards Robert (air0rae) wrote: Now why on earth would you want to interface with FedEx? :) After all UPS is now Synchronizing Commerce. Rob UPS Developer -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:18 AM To: CF-Talk Subject: FED-Ex API calls Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FED-Ex API calls
Believe I wanted to go the UPS route, but I had no choice. I assume the Fed-Ex was the low bidder on the contract and won - that's about all I know about it. I am just a developer doing what I am told to do. Yes the logo is nicer and I do want to drive the big brown truck :-) But serious if anyone has any info it would really help. Thanks Mario -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:23 AM To: CF-Talk Subject: RE: FED-Ex API calls Now why on earth would you want to interface with FedEx? :) After all UPS is now Synchronizing Commerce. Rob UPS Developer -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:18 AM To: CF-Talk Subject: FED-Ex API calls Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FED-Ex API calls
What version of CF are you trying to do this with? From what I know of the FedEx API, you can connect to it with Java, hence you should be able to write a servlet/web service for Jrun/CFMX. Another option is that you can use COM objects to connect with FedEx. I would think you create a CFOBJECT to instantiate the object and connect to it using cfscript. Just my thoughts. I'd help more, but downloading FedEx's api on a UPS machine would probably be a fireable offence. :) Rob -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:36 AM To: CF-Talk Subject: RE: FED-Ex API calls Believe I wanted to go the UPS route, but I had no choice. I assume the Fed-Ex was the low bidder on the contract and won - that's about all I know about it. I am just a developer doing what I am told to do. Yes the logo is nicer and I do want to drive the big brown truck :-) But serious if anyone has any info it would really help. Thanks Mario -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:23 AM To: CF-Talk Subject: RE: FED-Ex API calls Now why on earth would you want to interface with FedEx? :) After all UPS is now Synchronizing Commerce. Rob UPS Developer -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:18 AM To: CF-Talk Subject: FED-Ex API calls Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
multiple instances of CFMX [was: CF Server Mappings]
Strange. Any idea why? CFMX for J2EE is just an app in a container, so I'm surprised it isn't pretty straight forward to have two CFMX's on one machine. Of course, I might be even MORE surprised if I can't do it when we get it ourselves. thanks, Chris Norloff -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 4 Apr 2003 16:00:20 +0100 On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote: Looking forward to our transition to CFMX for J2EE and multiple instances of CF! Depends - we haven't be able to achive this with j2EE on WebLogic. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
question
CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfcookie expires syntax
I have also tried: cfcookie name = MYCOOKIE value = foo expires=#DateFormat(CreateDate(2001,12,31), 'ddd, dd-mmm-')# #TimeFormat(CreateTime(00,00,00), 'HH:mm:ss')# GMT with no luck -Original Message- From: Sean McCarthy Sent: Friday, April 04, 2003 10:26 AM To: CF-Talk Subject: cfcookie expires syntax I would like to expire a cookie after 10 min. Something is not correct with my syntax any ideas? cfset foo = DateAdd(n, 10, Now()) cfcookie name = MYCOOKIE value = #Now()# expires = #foo# thanks! sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfcookie expires syntax
Use CreateTimeSpan(0,0,10,0) 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: Sean McCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 8:20 AM Subject: RE: cfcookie expires syntax I have also tried: cfcookie name = MYCOOKIE value = foo expires=#DateFormat(CreateDate(2001,12,31), 'ddd, dd-mmm-')# #TimeFormat(CreateTime(00,00,00), 'HH:mm:ss')# GMT with no luck -Original Message- From: Sean McCarthy Sent: Friday, April 04, 2003 10:26 AM To: CF-Talk Subject: cfcookie expires syntax I would like to expire a cookie after 10 min. Something is not correct with my syntax any ideas? cfset foo = DateAdd(n, 10, Now()) cfcookie name = MYCOOKIE value = #Now()# expires = #foo# thanks! sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfcookie expires syntax
Actually the docs seem to say that you can't use minutes to timeout acookie...only a future date or a number of days: From the docs: Expires: Optional. Schedules the expiration of a cookie variable. Can be specified as a date (as in, 10/09/97), number of days (as in, 10, 100), NOW, or NEVER. Using NOW effectively deletes the cookie from the client's browser. 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: Sean McCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 8:20 AM Subject: RE: cfcookie expires syntax I have also tried: cfcookie name = MYCOOKIE value = foo expires=#DateFormat(CreateDate(2001,12,31), 'ddd, dd-mmm-')# #TimeFormat(CreateTime(00,00,00), 'HH:mm:ss')# GMT with no luck -Original Message- From: Sean McCarthy Sent: Friday, April 04, 2003 10:26 AM To: CF-Talk Subject: cfcookie expires syntax I would like to expire a cookie after 10 min. Something is not correct with my syntax any ideas? cfset foo = DateAdd(n, 10, Now()) cfcookie name = MYCOOKIE value = #Now()# expires = #foo# thanks! sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FED-Ex API calls
On 4/4/03, Ciliotta, Mario penned: Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. I'm waiting for the XML to come out this summer. This is all the info I have: Click the link below to obtain a copy of the Seven-Step Implementation: http://www.fedex.com/globaldeveloper/shipapi/implementation.pdf In order to review the Implementation guide, you will need to have Microsoft PowerPoint installed on your system. If you do not have access to the PowerPoint application, please go to the following website location and download the powerpoint viewer. http://office.microsoft.com/downloaddetails/ppview97.htm If you have any additional questions or encounter any technical difficulties/issues, please visit the Global Developer Program website and review our technical and F.A.Q. (Frequently Asked Questions) sections. You may also wish to contact the API Support Team via email, [EMAIL PROTECTED] or phone, 1-800-810-9073. Thank you for choosing FedEx as a shipping solution, API Technical Support Group -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ http://www.cf-ezcart.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strange Error in CF MX Administrator
We had another server hang this morning (we're at about 1 every 2 days now), so I went through our logs and I found this error in the application log a few minutes before the crash: Could not find the included template cfadmin_5_unix.cfm.Note: If you wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The specific sequence of files included or processed is: D:\Inetpub\wwwroot\CFIDE\componentutils\cfcexplorer.cfc This is an error in the CF Administrator itself, so I'm not sure what would cause this. Anybody seen it before or have a guess what would cause it? Thanks, Kevin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FED-Ex API calls
Rob, I have access to either MX or 4.5. I do not have that much Java experience so I was kind of thinking of going that route but I am not sure where to even start. Mario -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:57 AM To: CF-Talk Subject: RE: FED-Ex API calls What version of CF are you trying to do this with? From what I know of the FedEx API, you can connect to it with Java, hence you should be able to write a servlet/web service for Jrun/CFMX. Another option is that you can use COM objects to connect with FedEx. I would think you create a CFOBJECT to instantiate the object and connect to it using cfscript. Just my thoughts. I'd help more, but downloading FedEx's api on a UPS machine would probably be a fireable offence. :) Rob -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:36 AM To: CF-Talk Subject: RE: FED-Ex API calls Believe I wanted to go the UPS route, but I had no choice. I assume the Fed-Ex was the low bidder on the contract and won - that's about all I know about it. I am just a developer doing what I am told to do. Yes the logo is nicer and I do want to drive the big brown truck :-) But serious if anyone has any info it would really help. Thanks Mario -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:23 AM To: CF-Talk Subject: RE: FED-Ex API calls Now why on earth would you want to interface with FedEx? :) After all UPS is now Synchronizing Commerce. Rob UPS Developer -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:18 AM To: CF-Talk Subject: FED-Ex API calls Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strange Error in CF MX Administrator
Also, this is the entry in the exception.log: Error,jrpp-74,04/04/03,10:32:41,,Could not find the included template cfadmin_5_unix.cfm.Note: If you wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The specific sequence of files included or processed is: D:\Inetpub\wwwroot\CFIDE\componentutils\cfcexplorer.cfc coldfusion.tagext.lang.IncludeTag$NoSuchIncludeTemplateException: Could not find the included template cfadmin_5_unix.cfm. at coldfusion.tagext.lang.IncludeTag.setTemplate(Unknown Source) at cflogin2ecfm1942167648.runPage(D:\Inetpub\wwwroot\CFIDE\componentutils\login .cfm:92) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source) at cfApplication2ecfm1272781787.runPage(D:\Inetpub\wwwroot\CFIDE\componentutils \Application.cfm:54) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.CfincludeFilter.include(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.xml.rpc.CFCServlet.invoke(Unknown Source) at coldfusion.xml.rpc.CFCServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java: 335) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) -Original Message- From: Ruggiero, Kevin D Sent: Friday, April 04, 2003 11:34 AM To: CF-Talk Subject: Strange Error in CF MX Administrator We had another server hang this morning (we're at about 1 every 2 days now), so I went through our logs and I found this error in the application log a few minutes before the crash: Could not find the included template cfadmin_5_unix.cfm.Note: If you wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The specific sequence of files included or processed is: D:\Inetpub\wwwroot\CFIDE\componentutils\cfcexplorer.cfc This is an error in the CF Administrator itself, so I'm not sure what would cause this. Anybody seen it before or have a guess what would cause it? Thanks, Kevin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multiple instances of CFMX [was: CF Server Mappings]
You can put multiple CFMX's on one machine. You can also put multiple CFMX's on one J2EE server instance, as long as you use different context paths. However, unless you need the security that provides, I'd recommend just using one, and have a two-part context path (to the CFMX server, and then to the app's directory). That way you don't need to have two copies of the CF Server loaded in memory all the time. In other words, rather than this: www.mydomain.com/cfapp1/ www.mydomain.com/cfapp2/ do this: www.mydomain.com/cfmx/app1/ www.mydomain.com/cfmx/app2/ --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 8:04 AM To: CF-Talk Subject: multiple instances of CFMX [was: CF Server Mappings] Strange. Any idea why? CFMX for J2EE is just an app in a container, so I'm surprised it isn't pretty straight forward to have two CFMX's on one machine. Of course, I might be even MORE surprised if I can't do it when we get it ourselves. thanks, Chris Norloff -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 4 Apr 2003 16:00:20 +0100 On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote: Looking forward to our transition to CFMX for J2EE and multiple instances of CF! Depends - we haven't be able to achive this with j2EE on WebLogic. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
It displays 34(or rather the equivalent on my result set) on my test. Ade -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question
Because that is the first element in the list. cfoutput is like a loop. It starts at the first record, and loops through to the last. If you tell it to output a recordcount of 1, that it will only give you the first record. Make sense? - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:11 AM Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
OK, it display 34 but how can I set it to 1. I was a bit screwed up and said it displays 1. Actually it is displaying 34 but I want it to display 1 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:01 To: CF-Talk Subject: RE: question It displays 34(or rather the equivalent on my result set) on my test. Ade -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MX Sites Crossed
On Wed, 2 Apr 2003 22:18:56 -0800, in cf-talk you wrote: On Wednesday, Apr 2, 2003, at 19:01 US/Pacific, Matthew Walker wrote: http://www.macromedia.com/support/coldfusion/ts/documents/tn18258.htm And this is mentioned in the Release Notes I believe... Thanks for the RTFM, guys, that did the trick. Jamie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
If you want to maintain the recordset, you can't. If you don't care about the recordset, then do this: cfset test = structNew() / cfset test.recordcount = 1 / the 'recordcount' attribute of a recordset is immutable. --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:03 AM To: CF-Talk Subject: RE: question OK, it display 34 but how can I set it to 1. I was a bit screwed up and said it displays 1. Actually it is displaying 34 but I want it to display 1 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:01 To: CF-Talk Subject: RE: question It displays 34(or rather the equivalent on my result set) on my test. Ade -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hiding Javascript codes
Ben, Your best bet is to obfuscate your code. As several people have demonstrated here, it is not possible to keep anyone who is even remotely determined from getting your code, but you can prevent them from understanding and reusing it. This is by far the best technique I have seen used. There are several companies out there that have entire business models partially riding on Javascript code (ad serving companies, site trackers, etc) and they typically do an extremely thorough job of obfuscating their code. If all of your variables are named with a combination of random characters and hundreds of lines of script calling dozens of interwoven functions are all moved onto a single line with no whitespace at all, you code is pretty safe. Christian On Saturday, March 29, 2003, at 08:41 PM, DESIGN SHOP wrote: Hi all!, This may be a very dumb question. Is there any way at all to hide/encrypt Client side Javascript codes. We have a situation where we have to use certain client side Javascript codes which we wish to hide in the source code for security reasons. Any ideas?? Thanks in advance Ben Thomas Uncertified Dangerous Digital Internet Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
Lovely stuff that's all I wanted. Thanks -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:11 To: CF-Talk Subject: RE: question If you want to maintain the recordset, you can't. If you don't care about the recordset, then do this: cfset test = structNew() / cfset test.recordcount = 1 / the 'recordcount' attribute of a recordset is immutable. --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:03 AM To: CF-Talk Subject: RE: question OK, it display 34 but how can I set it to 1. I was a bit screwed up and said it displays 1. Actually it is displaying 34 but I want it to display 1 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:01 To: CF-Talk Subject: RE: question It displays 34(or rather the equivalent on my result set) on my test. Ade -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX fails to respond under high load with IIS5
Also, we have our CFMX servers simultaneous threads set to 100, and this seems to have also helped with the crashing which is much less frequent now. Is this setting enabled with the: Limit simultaneous requests to: (textbox) option in ColdFusion administrator? We're having a problem right now with crashes and I'd like to try this. Also, why did you settle on 100? I'm just wondering if there's any formula behind it, etc. Thanks! Kevin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Count(*) Query
YOU GUYS ROCK!!! Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
Boy, was my answer dumb. Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:01 PM To: CF-Talk Subject: RE: question It displays 34(or rather the equivalent on my result set) on my test. Ade -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Count(*) Query
SELECT number, count(*) FROM table GROUP BY number I have a table that has one field that holds numbers 1 thru 9. Can I run a single query that will give me the count(*) of 1's, count(*) of 2's, etc. or do I have to run a separate query for each? Thanks to all, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfparam
On Friday, April 4, 2003, at 09:54 AM, Adrian Lynch wrote: I understand what it's doing, but I'd rather it worked like the example I gave than throw an error. So write a custom tag that works the way you want it to, publish it here, and get famous. Whenever I come across a tag that doesn't work exactly like I want it to, I wrap it up in a custom tag that I like better. I've even experimented with doing this with HTML that I don't like so that something like this... table width=100% cellpadding=0 cellspacing=0 broder=0 ... becomes this ... my:table All attributes have defaults that I can override if I want. I haven't used anything like this in a production environment yet, though, because I would want to see if adds too much overhead (I use a lot of table tags), but it's an interesting idea. Christian http://www.macromedia.com/go/cantrell ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfparam
-Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:54 AM To: CF-Talk Subject: RE: cfparam I understand what it's doing, but I'd rather it worked like the example I gave than throw an error. Of course if it did this thread would have been created by somebody else wishing it worked the other way. ;^) You can't please everybody so CF's core philosophy has always been to make things work the way most people would use it most of the time. It's part of it's abstraction-of-complexity mission. When you wan't to do something different or more complex CF provides many avenues of extension for you. I suppose that a new attribute - something like ApplyDefaultForTypeMismatch but named better would solve it... But that would require a change to the language. A simpler option considering is to create a CustomTag or UDF that does just what you described and use that instead. By using the Is() functions inside a case statement with try catch this should be very easy. Then you'd call CF_ParamPlus (or maybe even CF_ParamTheWayIDamnWellWantIt or, my favorite CF_ParamALamaDingDing) instead of CFPARAM. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multiple instances of CFMX [was: CF Server Mappings]
Thanks, that makes sense. Though in our case we WANT to have two copies of the cfserver - so we can have two completely independent environments on one physical machine. Chris Norloff -- Original Message -- From: Barney Boisvert [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 4 Apr 2003 08:55:04 -0800 You can put multiple CFMX's on one machine. You can also put multiple CFMX's on one J2EE server instance, as long as you use different context paths. However, unless you need the security that provides, I'd recommend just using one, and have a two-part context path (to the CFMX server, and then to the app's directory). That way you don't need to have two copies of the CF Server loaded in memory all the time. In other words, rather than this: www.mydomain.com/cfapp1/ www.mydomain.com/cfapp2/ do this: www.mydomain.com/cfmx/app1/ www.mydomain.com/cfmx/app2/ --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 8:04 AM To: CF-Talk Subject: multiple instances of CFMX [was: CF Server Mappings] Strange. Any idea why? CFMX for J2EE is just an app in a container, so I'm surprised it isn't pretty straight forward to have two CFMX's on one machine. Of course, I might be even MORE surprised if I can't do it when we get it ourselves. thanks, Chris Norloff -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 4 Apr 2003 16:00:20 +0100 On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote: Looking forward to our transition to CFMX for J2EE and multiple instances of CF! Depends - we haven't be able to achive this with j2EE on WebLogic. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
Why would you want to do this? Why not set a separate variable that does not appear to be part of your query? Throughout your code, recordcount should probably usually (always) refer to the total number of rows returned by a query. Making it mean something else may not be wise. -mark -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:03 AM To: CF-Talk Subject: RE: question OK, it display 34 but how can I set it to 1. I was a bit screwed up and said it displays 1. Actually it is displaying 34 but I want it to display 1 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:01 To: CF-Talk Subject: RE: question It displays 34(or rather the equivalent on my result set) on my test. Ade -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLOCK around CFDIRECTORY?
Is it necessary (or good practice) to put CFLOCK around CFDIRECTORY? If I understand correctly, CFLOCKs should be used around CFFILEs. If someone knows of a good article on non-db locking in CF, I'd appreciate it. Most of the resources I'm finding provide details on using CFLOCK for CFXs or CFQUERYs. TIA Pam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Structure Referencing Problem
I have a structure where the key and value items are URLEncoded strings - i.e. Key = Google%2Ecom Value = http%3A%2F%2Fwww%2Egoogle%2Ecom I am not being able to reference this value however. If I try to access structure(Google.com) or structure(Google%2Ecom) - both return the following error: Element ITEM is undefined in DGADGETSETTINGS Any suggestions as to how to get this info out? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Structure Referencing Problem
i haven't tried it, but i am curious what would happen if you do something like this #UrlDecode(structure[#urlDecode(key)#])#? Nick Han [EMAIL PROTECTED] 04/04/03 09:56AM I have a structure where the key and value items are URLEncoded strings - i.e. Key = Google%2Ecom Value = http%3A%2F%2Fwww%2Egoogle%2Ecom I am not being able to reference this value however. If I try to access structure(Google.com) or structure(Google%2Ecom) - both return the following error: Element ITEM is undefined in DGADGETSETTINGS Any suggestions as to how to get this info out? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Structure Referencing Problem
I have attempted to reference the value using both an encoded and decoded key value - both have returned the same error message. I believe what you suggested was to attempt it with a decoded key - correct? -- Jeff -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:15 PM To: CF-Talk Subject: Re: Structure Referencing Problem i haven't tried it, but i am curious what would happen if you do something like this #UrlDecode(structure[#urlDecode(key)#])#? Nick Han [EMAIL PROTECTED] 04/04/03 09:56AM I have a structure where the key and value items are URLEncoded strings - i.e. Key = Google%2Ecom Value = http%3A%2F%2Fwww%2Egoogle%2Ecom I am not being able to reference this value however. If I try to access structure(Google.com) or structure(Google%2Ecom) - both return the following error: Element ITEM is undefined in DGADGETSETTINGS Any suggestions as to how to get this info out? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Structure Referencing Problem
I think you might be referencing your structure incorrectly. Try using brackets [] instead of parenthesis ()... I got the following to work properly using CF5.0 on Win2000... CFSET mylinks = structNew() CFSET foo = StructInsert(mylinks, Google%2Ecom, http%3A%2F%2Fwww%2Egoogle%2Ecom) CFOUTPUT CFLOOP collection=#mylinks# item=link #URLDecode(link)# = #URLDecode(StructFind(mylinks, link))# /CFLOOP /CFOUTPUT BRBR Manual calling of mylinks[Google%2Ecom] = CFOUTPUT#mylinks[Google%2Ecom]#/CFOUTPUT HTH, Jeff Garza - Original Message - From: Jeff Chastain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:56 AM Subject: Structure Referencing Problem I have a structure where the key and value items are URLEncoded strings - i.e. Key = Google%2Ecom Value = http%3A%2F%2Fwww%2Egoogle%2Ecom I am not being able to reference this value however. If I try to access structure(Google.com) or structure(Google%2Ecom) - both return the following error: Element ITEM is undefined in DGADGETSETTINGS Any suggestions as to how to get this info out? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Structure Referencing Problem
use brackets instead of parentheses? - Original Message - From: Jeff Chastain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:56 PM Subject: Structure Referencing Problem I have a structure where the key and value items are URLEncoded strings - i.e. Key = Google%2Ecom Value = http%3A%2F%2Fwww%2Egoogle%2Ecom I am not being able to reference this value however. If I try to access structure(Google.com) or structure(Google%2Ecom) - both return the following error: Element ITEM is undefined in DGADGETSETTINGS Any suggestions as to how to get this info out? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Structure Referencing Problem
That was it -- Thanks -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:19 PM To: CF-Talk Subject: Re: Structure Referencing Problem I think you might be referencing your structure incorrectly. Try using brackets [] instead of parenthesis ()... I got the following to work properly using CF5.0 on Win2000... CFSET mylinks = structNew() CFSET foo = StructInsert(mylinks, Google%2Ecom, http%3A%2F%2Fwww%2Egoogle%2Ecom) CFOUTPUT CFLOOP collection=#mylinks# item=link #URLDecode(link)# = #URLDecode(StructFind(mylinks, link))# /CFLOOP /CFOUTPUT BRBR Manual calling of mylinks[Google%2Ecom] = CFOUTPUT#mylinks[Google%2Ecom]#/CFOUTPUT HTH, Jeff Garza - Original Message - From: Jeff Chastain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:56 AM Subject: Structure Referencing Problem I have a structure where the key and value items are URLEncoded strings - i.e. Key = Google%2Ecom Value = http%3A%2F%2Fwww%2Egoogle%2Ecom I am not being able to reference this value however. If I try to access structure(Google.com) or structure(Google%2Ecom) - both return the following error: Element ITEM is undefined in DGADGETSETTINGS Any suggestions as to how to get this info out? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFPOP From and db
I am trying to use CFPOP to look for a certain email address in the FROM. I have the address I am looking for stored in my DB. I know that the email I am looking for is there (I can see it) but when I try to compare the CFPOP.From to the address in my DB I never get a match??? Anyone have any ideas??? !--- Declare Variables--- cfquery name=GetVars datasource=DSN select * from settings /cfquery !--- Get New Mail --- cfquery name=getpops datasource=DSN select * from pop3 /cfquery CFLOOP QUERY=getpops STARTROW=1 ENDROW=#getpops.recordcount# CFPOP server=#getpops.pop3_server# username=#getpops.pop_username# password=#getpops.pop_password# action=GetAll NAME=MailList strongLooking for:/strong cfoutput#GetVars.CLFrom#/cfoutput BRBR cfoutput query=maillist cfset trimaddress = trim(#mailList.from#) cfif '#trimaddress#' NEQ '#GetVars.CLFrom#' /cfif /cfoutput /CFLoop Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Formatting output question
I have a message form where users submit a form via a textarea box. In this textarea box they may make a carriage return. When I output the message everything is on one line and the carriage returns are not there. I looked in the datbase and the lines are setup with carriage returns. Example a b c When I out put I get a b c How do I format this to keep the carriage returns? Get your own free email account from http://www.popmail.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Formatting output question
Use replace() to add br tags to the carriage returns. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Friday, April 04, 2003 1:40 PM : To: CF-Talk : Subject: Formatting output question : : : I have a message form where users submit a form via a textarea : box. In this textarea box they may make a carriage return. When I : output the message everything is on one line and the carriage : returns are not there. I looked in the datbase and the lines are : setup with carriage returns. : : Example : a : b : c : : When I out put I get : a b c : : How do I format this to keep the carriage returns? : : : Get your own free email account from : http://www.popmail.com : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Run CF Studio 4 and 4.5 on same machine?
I've been running CF Studio 4 for just about forever. I recall trying 4.5 quite a while ago and not particularly liking it, but I'd like to try it out again. Can I run both on the same machine, so that I could uninstall one or the other if I choose? It would be easier than installing, uninstalling, reinstalling, if I want to go back to 4. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Time Format Question
ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hiding JavaScript codes
Okay okay... I know Dave... You're right of course... The browser has to read the file, ergo it can be downloaded and viewed. However that being said, it still somewhat helps, even a little... Any web developer with a modicum of common sense I have a modicum of common sense, I was just trying to help the guy out so he can keep dumb people out at least... To simply say you can't doesn't do anyone any good. I may have understated how simple it was... I for one wouldn't go to that much effort to borrow a snippet. There's so much out there that if someone really doesn't want me to take it, I'll just move on. Chances are he isn't the first one to come up with that script idea, and won't be the last. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 7:40 PM To: CF-Talk Subject: RE: Hiding JavaScript codes Actually, you kind of can I think... You can use a cfm file as a .js file to emulate a javascript file. Change the extension to .cfm... Careful, cf studio won't correctly parse it, but nonetheless it'll work... Just tested it. cfparam name=cgi.http_referer default= cfif cgi.http_referer eq cfabort/cfif at the top. Then, in your script, just enter: script language=javascript src=temp.cfm/script In THEORY, the .js will come up blank unless it's called from another file on your site. Tweak it as you wish. It should keep prying eyes from reading your .js file. This isn't 100% bulletproof, but should work for the most part. You can of course get more anal on the file and verify the referer more carefully. If prying eyes are being used in concert with a brain (or just common, off-the-shelf software), this won't stop them from seeing your Javascript. I know, you cannot for sure, 100% hide it... Cgi variables can be spoofed. Still better than leaving it wide open if you want to lock it down... It's like your house. Just because someone can break a window doesn't mean you should leave the door unlocked. Nothing is really 100% secure. But it protects you from everyone but the elite hacker. This is a poor analogy. Perhaps a better one would be locking your door, but leaving the key under the mat. But that doesn't really do justice to the situation either. The simple fact is, securing your house is quite a bit different from securing application code, and you simply can't secure code that is being downloaded to the client. Any web developer with a modicum of common sense knows that for your browser to run Javascript, it has to be downloaded to the browser. If your browser can get to it, so can the web developer. Knowing this, it's pretty trivial to figure out how to do this - just send the same message to the server that your browser sends. (Or, for that matter, just fetch it from the browser cache.) You certainly don't have to be an elite hacker to do this. The only way for one to do this is if they know how to pass their own http headers. And then they need to know that you're looking at that particular cgi variable, and they need to know what you're comparing to as well. Too much trouble for a little piece of javascript IMHO... It's no trouble at all. Again, the developer doesn't have to know what variable you're checking against - it really doesn't matter at all. All the developer has to do is send the same HTTP request that your browser sent. Since HTTP requests are just text, this is a very easy thing to do. Any packet sniffer or recording proxy will tell you exactly what that text is. I've recently started using EffeTech HTTP Sniffer for this sort of thing - it just does HTTP, but it will let you refetch any file automatically, among other things. But you don't have to spend $40 to do this - you can use free tools like Ethereal. Finally, keep in mind that your approach means more (unnecessary) work for your CF server, and defeats the primary purpose of using external source files in the first place - caching! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Formatting output question
To expand on what Ben said below... try this: Replace(string,Chr(13),br,ALL) -Novak - Original Message - From: Ben Doom [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:42 AM Subject: RE: Formatting output question Use replace() to add br tags to the carriage returns. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Friday, April 04, 2003 1:40 PM : To: CF-Talk : Subject: Formatting output question : : : I have a message form where users submit a form via a textarea : box. In this textarea box they may make a carriage return. When I : output the message everything is on one line and the carriage : returns are not there. I looked in the datbase and the lines are : setup with carriage returns. : : Example : a : b : c : : When I out put I get : a b c : : How do I format this to keep the carriage returns? : : : Get your own free email account from : http://www.popmail.com : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
Either create a regex that checks what the user entered for correctness or, instead of letting the user enter the mask free form, let them choose from a predetermined number of masks via a SELECT list. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Formatting output question
Or the paragraphFormat() function. --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:43 AM To: CF-Talk Subject: RE: Formatting output question Use replace() to add br tags to the carriage returns. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Friday, April 04, 2003 1:40 PM : To: CF-Talk : Subject: Formatting output question : : : I have a message form where users submit a form via a textarea : box. In this textarea box they may make a carriage return. When I : output the message everything is on one line and the carriage : returns are not there. I looked in the datbase and the lines are : setup with carriage returns. : : Example : a : b : c : : When I out put I get : a b c : : How do I format this to keep the carriage returns? : : : Get your own free email account from : http://www.popmail.com : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
allaire MIB event log error
Ok, I'm getting this error thing in my event log Failure to connect to url: http://magnys2/cfide/mib/getmetricdataXML.cfm. Where does CF get the computer name used in the url above? That's incorrect causing the error. Using CF 5.0 on Win2K I know what the file/reuest is for and all, I just can't figure out where CF is building the URL for the request. Cheers! -- Douglas Knudsen Alltel Corporate CIS Group 678-351-6063 Spoon feeding in the long run teaches us nothing but the shape of the spoon. - E.M. Forster NOTE!! Magnys production changes occur on Friday evenings ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
Why don't you just check to make sure the mask contains only the chars: h,H,m,M,s,S,t,T,: (or whatever the time chars are). -R -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
TimeFormat (and DateFormat) ignore characters they don't understand and send them directly to the output, with an apostrophe in there as well. The solution would be to strip out all illegal characters with an RE. --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:03 AM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Demo Version of CFMX with 5.0
Hi all, I just installed MX on the same machine as 5. Everything is working AOK, but just wanted to make sure i did the install right. I installed MX as a standalone server. In IIS, for sites that i want to use MX, i set the Application Mappings for *.cfm etc to: C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll For CF5, I keep the Application Mappings for *.cfm as: C:\CFusion\bin\iscf.dll This seemed too easy... so i wanted to check with you folk to see if there is anything else I should have done. Thanks in advance!!! - jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: allaire MIB event log error
It should be coming from \CFusion\cfam\Database\mib.properties Deb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:15 PM To: CF-Talk Subject: allaire MIB event log error Ok, I'm getting this error thing in my event log Failure to connect to url: http://magnys2/cfide/mib/getmetricdataXML.cfm. Where does CF get the computer name used in the url above? That's incorrect causing the error. Using CF 5.0 on Win2K I know what the file/reuest is for and all, I just can't figure out where CF is building the URL for the request. Cheers! -- Douglas Knudsen Alltel Corporate CIS Group 678-351-6063 Spoon feeding in the long run teaches us nothing but the shape of the spoon. - E.M. Forster NOTE!! Magnys production changes occur on Friday evenings ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
Cause the field does not need to have all those characters. Trying to rule out someone putting in something that is not part of the proper Time Mask paramters [EMAIL PROTECTED] 04/04/03 02:15PM Why don't you just check to make sure the mask contains only the chars: h,H,m,M,s,S,t,T,: (or whatever the time chars are). -R -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: allaire MIB event log error
ah ha!! that did it. Thans Deb. -Original Message- From: Debbie Dickerson [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:20 PM To: CF-Talk Subject: RE: allaire MIB event log error It should be coming from \CFusion\cfam\Database\mib.properties Deb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:15 PM To: CF-Talk Subject: allaire MIB event log error Ok, I'm getting this error thing in my event log Failure to connect to url: http://magnys2/cfide/mib/getmetricdataXML.cfm. Where does CF get the computer name used in the url above? That's incorrect causing the error. Using CF 5.0 on Win2K I know what the file/reuest is for and all, I just can't figure out where CF is building the URL for the request. Cheers! -- Douglas Knudsen Alltel Corporate CIS Group 678-351-6063 Spoon feeding in the long run teaches us nothing but the shape of the spoon. - E.M. Forster NOTE!! Magnys production changes occur on Friday evenings ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
Right, so make sure that the chars entered are part of the list of acceptable chars? They don't all need to be there, just can't have chars that aren't supposed to be there.. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:21 PM To: CF-Talk Subject: RE: Time Format Question Cause the field does not need to have all those characters. Trying to rule out someone putting in something that is not part of the proper Time Mask paramters [EMAIL PROTECTED] 04/04/03 02:15PM Why don't you just check to make sure the mask contains only the chars: h,H,m,M,s,S,t,T,: (or whatever the time chars are). -R -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Formatting output question
Thanks, I got it to work with your help using cfset field=replace(#rf10#,#chr(10)#,BR,ALL) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Run CF Studio 4 and 4.5 on same machine?
No, I don't think you can run both copies of CFserver on one physical machine. CFMX for J2EE is the first version of CF that can have more than one copy of the CFserver running on one physical machine. Chris Norloff -- Original Message -- From: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 4 Apr 2003 11:42:22 -0700 I've been running CF Studio 4 for just about forever. I recall trying 4.5 quite a while ago and not particularly liking it, but I'd like to try it out again. Can I run both on the same machine, so that I could uninstall one or the other if I choose? It would be easier than installing, uninstalling, reinstalling, if I want to go back to 4. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IIF() and IsDefined()
Help: #IIF(StructKeyExists(struct, 'keyname'),DE(struct.keyname),DE('no key'))#.fails if the key is not present. BUT, cfif StructKeyExists(struct, 'keyname') #struct.keyname# cfelse no key /cfif doesn't. Am I missing something about IIF() and DE()? It looks as if both DE() expressions must be evaluateable, and the IIF() just decides which one to evaluate? Correct? Thanks, -- Alex Sherwood PHS Collection Agency THE COLLECTORS T: 301.215.4200 F: 301.664.6834 W: www.phs-net.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Run CF Studio 4 and 4.5 on same machine?
Jim, I seem to recall being able to do that successfully, but it's been a while. Have you tried Homesite+ ? I'm liking it pretty well - in fact it's all I use. Jeff -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 1:42 PM To: CF-Talk Subject: Run CF Studio 4 and 4.5 on same machine? I've been running CF Studio 4 for just about forever. I recall trying 4.5 quite a while ago and not particularly liking it, but I'd like to try it out again. Can I run both on the same machine, so that I could uninstall one or the other if I choose? It would be easier than installing, uninstalling, reinstalling, if I want to go back to 4. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IIF() and IsDefined()
try quotes around the argument passed to DE. DE(struct.keyname) should be DE('struct.keyname') mike -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:36 PM To: CF-Talk Subject: IIF() and IsDefined() Help: #IIF(StructKeyExists(struct, 'keyname'),DE(struct.keyname),DE('no key'))#.fails if the key is not present. BUT, cfif StructKeyExists(struct, 'keyname') #struct.keyname# cfelse no key /cfif doesn't. Am I missing something about IIF() and DE()? It looks as if both DE() expressions must be evaluateable, and the IIF() just decides which one to evaluate? Correct? Thanks, -- Alex Sherwood PHS Collection Agency THE COLLECTORS T: 301.215.4200 F: 301.664.6834 W: www.phs-net.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IIF() and IsDefined()
you don't need the de() call around the variable name, just put it in quotes: iif(structKeyExists(struct, keyname), struct.keyname, de(no key)) Your code was trying to output a variable with a name equal to the value stored in #struct.keyname#, which isn't what you wanted. Usually, using CFIF is more readable (especially with complex expressions) and it's always faster, as it doesn't require any delayed evaluation (which is slow). Sometimes it's the only way to get a job done, but you generally shouldn't use it unless you have to. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:36 AM To: CF-Talk Subject: IIF() and IsDefined() Help: #IIF(StructKeyExists(struct, 'keyname'),DE(struct.keyname),DE('no key'))#.fails if the key is not present. BUT, cfif StructKeyExists(struct, 'keyname') #struct.keyname# cfelse no key /cfif doesn't. Am I missing something about IIF() and DE()? It looks as if both DE() expressions must be evaluateable, and the IIF() just decides which one to evaluate? Correct? Thanks, -- Alex Sherwood PHS Collection Agency THE COLLECTORS T: 301.215.4200 F: 301.664.6834 W: www.phs-net.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cffile, uploading on a mac, which doesn't need file suffixes...
Okay, so using cffile, I've got the uploading part down, but one thing I shoulda seen coming. When people in the office on a mac browse their hard drive to choose the file they want to upload, what do I do, if it's got no suffix on it? On macs, you can (and these people frequently do) create pdfs and jpegs with no suffix. I'm only accepting jpegs and pdfs, so that part's figured out, and works...um, when there's a suffix on the file apparently. Not to mention, any link to the file won't work with the browser, it doesn't know what kind of file it is, naturally. What I'd like, was that, when the user uploads a file, if it doesn't have a suffix, maybe throw an error. (which would be a different error than if it wasn't the right type of file) Or is there a way to even determine the file type when there's no suffix? In other words, what kind of file *is* MyDocument? If I could tell if it was a jpeg, then I might consider just putting the suffix on if it doesn't exist. So I guess I'm really just sort of looking for a direction to go in, to do such a thing, or to handle such an event. How do others who have to do cffile in a mac browser environment handle this sort of thing? What's the logic? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data source error
Hmmm, are you using the system user as the user CF service operates under? Or have you created a new user? Ensure that the user has permissions on the database folder, it is also a good idea to ensure the db is not in a folder that is accessible to the web (ie: your inetpub/wwwroot or whatever dir structure you use). Yes it should be a system dsn. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Eric Vacin [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:28 PM To: CF-Talk Subject: Re: Data source error Stephanie, I got it from the CF Admin...when I tried to do an ODBC socket to the data source I created in the ODBC panel. Below is the exact output: * Connection verification failed for data source: ss []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC Driver][SequeLink Server]Could not create a trace file.. I've added a system DSN...this is right, right? I'm starting to think its some kind of permissions thing as I have the server locked down, very locked down. Singed, Eternally Confused. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
REreplace(string, [^tTmMhHsH: ], , all) that'll strip out the extra chars --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:28 AM To: CF-Talk Subject: RE: Time Format Question Right, so make sure that the chars entered are part of the list of acceptable chars? They don't all need to be there, just can't have chars that aren't supposed to be there.. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:21 PM To: CF-Talk Subject: RE: Time Format Question Cause the field does not need to have all those characters. Trying to rule out someone putting in something that is not part of the proper Time Mask paramters [EMAIL PROTECTED] 04/04/03 02:15PM Why don't you just check to make sure the mask contains only the chars: h,H,m,M,s,S,t,T,: (or whatever the time chars are). -R -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4