Adding DSN externally
I wanted to add DSN externally (Microsoft Access). How can i do so, so that its added just like its done through the CFMX admin interface. Is there any utility or method provided by CFMX for this. Please note that i want it to be added using my application but it should be listed in ColdFusion DSN list like it was added through it. I'm using Cold Fusion MX 6.1 Windows 2003. Please help me if anyone has any idea. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFCHART in CFFORM
Well.. I still havent been able to figure this out... so I am posting my code to see if a) I am doing something wrong b) there is a bug in CF My code is as follows: cfform name=results format=flash width=800 height=600 cfformgroup type=tabnavigator cfformgroup type=page label=Log File cfgrid name=logGrid query=qLog selectmode=row/cfgrid /cfformgroup cfformgroup type=page label=Hits/Day width=800 height=600 cfformitem type=html !--- Here starts the chart --- cfchart format=png chartheight=400 chartwidth=700 showxgridlines=no showygridlines=no showborder=no fontbold=no fontitalic=no labelformat=number xaxistitle=date yaxistitle=hits rotated=no sortxaxis=no showlegend=no showmarkers=no title=Daily Hits style=blue cfchartseries type=bar query=qHits itemcolumn=VisitDate valuecolumn=Hits/cfchartseries /cfchart !--- Here ends the chart --- /cfformitem /cfformgroup /cfformgroup The first is just a grid that shows in the first tab in the second tab I am trying to display a chart. The chart works fine outside of the CFFORM but if I put the chart in the form... nothing displays. I have tried doing it as flash etc. Any ideas on at least how to debug this? MD On 05/07/05, Mark Drew [EMAIL PROTECTED] wrote: Hi there I dont seem to be able to get a cfchart within a cfformgroup. I basically have a two tabs in a tabnavigator and in one of them I want to place a chart. Is this not possible? or do I just have to seek errors in my code? (which is minimal at the moment) Thanks in advance Mark Drew (and a belated happy 4th of july to you americans out there!) -- Mark Drew ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
flashForm+Firefox: no cursor, no @ etc...
Hi, did anybody have a similar problem in firefox when viewing flash-Forms: when focussing a text-field, there's no blinking cursor visible (but in IE it is). And.. when I try to enter an email-address in a field, I cant enter the @-sign, there appears a lowercase q. Similar problems with other values like questionmark etc.. try here: http://www.friendcom.de/index.cfm?evnt=account.createnew#abvtp On that server I use the /cfide/scripts-folder from my devEnvironment, where the same problems occur. Is there another version of some files from the script-folder or what? I thooght it might be a encoding-problem or something like this (?) but why there's no cursor? (btw. thanks mike nimer getting the flashForms run on that server:) thx -- Sebastian Mork [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211308 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: flashForm+Firefox: no cursor, no @ etc...
well, I think I found the problem, but no solution :( In my flash-forms I use the cfform-attribute wMode=transparent, because there's a background-image at the site (+style=backgroundAlpha: 0;) When I remove wMode=transparent the problem disappears, when I add it, firefox displays no cursor and gives no chance to enter an @-sign and other chars, mmh.. anybody has an idea how to solve that?? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 07 Jul 2005 13:32:29 +0200 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, did anybody have a similar problem in firefox when viewing flash-Forms: when focussing a text-field, there's no blinking cursor visible (but in IE it is). And.. when I try to enter an email-address in a field, I cant enter the @-sign, there appears a lowercase q. Similar problems with other values like questionmark etc.. try here: http://www.friendcom.de/index.cfm?evnt=account.createnew#abvtp On that server I use the /cfide/scripts-folder from my devEnvironment, where the same problems occur. Is there another version of some files from the script-folder or what? I thooght it might be a encoding-problem or something like this (?) but why there's no cursor? (btw. thanks mike nimer getting the flashForms run on that server:) thx -- Sebastian Mork [EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: flashForm+Firefox: no cursor, no @ etc...
http://www.5etdemi.com/blog/archives/2005/06/firefox-wmodetransparent-is-completely-screwy-and-breaks-textfields/ -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 07 Jul 2005 13:32:29 +0200 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, did anybody have a similar problem in firefox when viewing flash-Forms: when focussing a text-field, there's no blinking cursor visible (but in IE it is). And.. when I try to enter an email-address in a field, I cant enter the @-sign, there appears a lowercase q. Similar problems with other values like questionmark etc.. try here: http://www.friendcom.de/index.cfm?evnt=account.createnew#abvtp On that server I use the /cfide/scripts-folder from my devEnvironment, where the same problems occur. Is there another version of some files from the script-folder or what? I thooght it might be a encoding-problem or something like this (?) but why there's no cursor? (btw. thanks mike nimer getting the flashForms run on that server:) thx -- Sebastian Mork [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Validation of Date on Form
I most certainly agree with slapping people silly when they can't even enter a date properly. I just thought I'd mention it in case the OP needed to be sure of what he was getting. --Ferg Dawson, Michael wrote: Well, true, but you have to assume that people are capable of typing dates in any normal date format. If they type 403 for a date, they should be slapped silly, the shown an error message. I assumed any number of formats meant reasonable dates syntaxes. If it were me, I would use qForms API to mask the field using javascript, then I would use isDate() to ensure it doesn't get through to the app server. -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 06, 2005 6:13 PM To: CF-Talk Subject: Re: Validation of Date on Form depending on how you're handling the data, isDate can give you some funkiness. There are a lot of values which are considered valid date objects which don't fit your actual needs for a date. I'd go with Bob's suggestion of a regex. eg. #isdate(403)# -- NO #isdate(4/03)# -- YES #isdate(4-03)# -- YES #isdate(4.03)# -- YES #isdate(1030)# -- NO Dawson, Michael wrote: How about isDate()? -Original Message- From: Bob Clingan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 06, 2005 11:12 AM To: CF-Talk Subject: Validation of Date on Form You will to write regular expressions to check for those types of dates you want to allow. Don't forget about sanity checks like 31st in a month with 30 days and leap year. I've got a number of forms in an administration area that will accept a date in any number of formats mm/dd/ mm/dd/yy July 4, 2005 ...and so on... I need a way to validate this field so if somebody types something other than an accepted date (like Bob) they get an alert saying Please format your date like X. Looks pretty easy with CF 7, but their host ain't running CF 7. Suggestions? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Validation of Date on Form
Just force them to enter a date correctly. -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: 07 July 2005 14:01 To: CF-Talk Subject: Re: Validation of Date on Form I most certainly agree with slapping people silly when they can't even enter a date properly. I just thought I'd mention it in case the OP needed to be sure of what he was getting. --Ferg Dawson, Michael wrote: Well, true, but you have to assume that people are capable of typing dates in any normal date format. If they type 403 for a date, they should be slapped silly, the shown an error message. I assumed any number of formats meant reasonable dates syntaxes. If it were me, I would use qForms API to mask the field using javascript, then I would use isDate() to ensure it doesn't get through to the app server. -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 06, 2005 6:13 PM To: CF-Talk Subject: Re: Validation of Date on Form depending on how you're handling the data, isDate can give you some funkiness. There are a lot of values which are considered valid date objects which don't fit your actual needs for a date. I'd go with Bob's suggestion of a regex. eg. #isdate(403)# -- NO #isdate(4/03)# -- YES #isdate(4-03)# -- YES #isdate(4.03)# -- YES #isdate(1030)# -- NO Dawson, Michael wrote: How about isDate()? -Original Message- From: Bob Clingan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 06, 2005 11:12 AM To: CF-Talk Subject: Validation of Date on Form You will to write regular expressions to check for those types of dates you want to allow. Don't forget about sanity checks like 31st in a month with 30 days and leap year. I've got a number of forms in an administration area that will accept a date in any number of formats mm/dd/ mm/dd/yy July 4, 2005 ...and so on... I need a way to validate this field so if somebody types something other than an accepted date (like Bob) they get an alert saying Please format your date like X. Looks pretty easy with CF 7, but their host ain't running CF 7. Suggestions? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Validation of Date on Form
Just force them to enter a date correctly. A good datepicker can be handy for that. I wrote a custom tag wrapper for DHTML Calendar created by Mihai Bazon. You can get it here: http://www.olimpo.ch/tmt/tag/datepicker/ See it in action: http://www.olimpo.ch/tmt/tag/datepicker/sample.cfm Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
.net (please don't hit me)
Is it possible to run CF5 and ASP.net (framework) on the same box? Any gotchas? TIA Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: .net (please don't hit me)
Yes. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 07 July 2005 14:25 To: CF-Talk Subject: .net (please don't hit me) Is it possible to run CF5 and ASP.net (framework) on the same box? Any gotchas? TIA Dave ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cannot disable JSP functionality for CFMX 7
On 7/5/05, wolf2k5 [EMAIL PROTECTED] wrote: Hi, I am running ColdFusion MX 7 (server configuration) on Red Hat Enterprise Linux 3 with Apache 2. I was running ColdFusion MX 6.1, before the upgrade to version 7 this week, and Tomcat was processing JSP files just fine (since I disabled the JSP functionality for CFMX 6.1). After the upgrade to version 7, I disabled the JSP functionality for CFMX 7 as well: I commented out the servlet-mapping entry for JspLicenseServlet in the default-web.xml file [1]. But ColdFusion MX 7 still tries to process the JSP files! I even removed the .jsp extension from the jrun-handler directive in the Apache config file, but apparently it didn't make any difference. How can I have ColdFusion MX 7 ignore JSP files and have Tomcat process them instead, just like I had with CFMX 6.1? Thanks. [1] http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0054.htm Any help? Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: .net (please don't hit me)
You can use BD.net -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Thursday, July 07, 2005 9:16 AM Para: CF-Talk Asunto: RE: .net (please don't hit me) Yes. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 07 July 2005 14:25 To: CF-Talk Subject: .net (please don't hit me) Is it possible to run CF5 and ASP.net (framework) on the same box? Any gotchas? TIA Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Differnet type of multi select
I have a list of line items in an invoicing app. Within the line item is a check box for Do not print. Is there any way to do a highlight and select, in the same way that you can do in a desktop app. IE Click on multiple line items to perform a single task Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.10/43 - Release Date: 07/06/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What breaks during upgrade from 6.1 to 7 - VERITY
There's a bunch of new options for searching in 7.0. Read the docs on verity. I haven't used it yet, but I went to a great session on it by Ray Camden at CF-United. You can now do natural language searches and internet language searches and such. The default behavior may have changed, but you actually now have a much more powerful feature set to play with. On 7/6/05, Mark Leder [EMAIL PROTECTED] wrote: I would have to chime in here and state that Verity is broken in V7. Here's why: I upgraded from v6.1 Std to v7 Std this past weekend. In v6.1 all searching worked perfectly for 2+ years. I use collections built from SQL queries obtained from MS-Access (I know, I know - don't bash me for using Access, it's a client decision). As an example, a search on a small 270 recordset containing an ID, question and answer is done on the word Fact. Up pops 15 records. Good. However, a search is performed on Factoid - no results. In 6.1 both search terms would return results, in 7.0 only the word Fact returns results. The data was entered by the client in January 2005, so we know it was working for several months. Problem solving on my end: 1) deleting and recreating the collections in the Cfadmin area, and reindexing the collections - no resolution. 2) Installing the CFMX7 hotfix 2, which addresses some verity problems. Restart CFMX7, delete and recreate collections from CFAdmin console, reindexing the collections - no resolution. 3) Deleting the actual record from the db, then reinserting the record as new, then reindexing - no resolution. FYI - prior to reindexing, the Access db is compacted to make sure there are no errors. Here's the actual question text for this record: Fact or Factoid - the addition of copper pennies to vase water increases the life of tulips? What's really weird is that this phrase will not even show up in the search for fact. Hmm, does the non-Unicode of this MS-access db have an effect? Here's the code I use for indexing and searching (I have made no changes to this code in 2+ years of use): !---Index the contents of the query object using CFINDEX--- cflock name=cfindexFAQ_lock type=EXCLUSIVE TIMEOUT=30 CFINDEX ACTION=REFRESH COLLECTION=faq_db KEY=faq_ID TYPE=CUSTOM TITLE=question QUERY=indexdb BODY=question,answer LANGUAGE=English /cflock cfsearch collection=faq_db NAME=v_faq TYPE=SIMPLE CRITERIA=#FORM.criteria# Anyone else having these problems? Is this a bug, or are there code changes in the cfindex routine that I need to tweak from 6.1 to 7.0? If this can't be fixed, is there a way to run 6.1 Verity again, disable 7.0 verity, but keep 7.0 as the primary application server? Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211319 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Validation of Date on Form
Just force them to enter a date correctly. I wanted to go with three dropdown boxes for month/day/year, but was told nope, just one text input. So, next to the text input in bold red letters, it says: (format date as mm/dd/) In previewing the thing to the client, they started filling out the form and immediately entered July 26, 2005 and ignored the format alert. It's often amazing to me the weird stupid user tricks that you have to compensate for - and if you haven't thought of it yet, the user certainly will within 24 hours of getting a finished product! -- --- Les Mizzell ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211320 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Validation of Date on Form
You could use JS to automatically format the date or to wipe out what they entered if it does match the correct values - they will soon learn. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 07 July 2005 15:01 To: CF-Talk Subject: Re: Validation of Date on Form Just force them to enter a date correctly. I wanted to go with three dropdown boxes for month/day/year, but was told nope, just one text input. So, next to the text input in bold red letters, it says: (format date as mm/dd/) In previewing the thing to the client, they started filling out the form and immediately entered July 26, 2005 and ignored the format alert. It's often amazing to me the weird stupid user tricks that you have to compensate for - and if you haven't thought of it yet, the user certainly will within 24 hours of getting a finished product! -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Validation of Date on Form
But you can accept that value just fine -- it's a date. cfset d = July 26, 2005 cfset newd = dateFormat(d, mm/dd/) yields: 07/26/2005 So you have no problems here. As long as you're checking for validity, you're good to go. Now you only have to worry about handling the instances where some knucklehead puts 03.07.2005 in the field expecting it to yield July 7th instead of March 7th., but you've got to draw the line somewhere, right? --Ferg. Les Mizzell wrote: Just force them to enter a date correctly. I wanted to go with three dropdown boxes for month/day/year, but was told nope, just one text input. So, next to the text input in bold red letters, it says: (format date as mm/dd/) In previewing the thing to the client, they started filling out the form and immediately entered July 26, 2005 and ignored the format alert. It's often amazing to me the weird stupid user tricks that you have to compensate for - and if you haven't thought of it yet, the user certainly will within 24 hours of getting a finished product! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Web Services over HTTPS
I have been trying to get two CF Web Services here to talk to one another via HTTPS with no success. They are both hosted on the same web server and communicate fine via HTTP. I tried getting our data center to use the keytool.exe program to import the certificate for the site but still get the same error. The error we get and steps we have tried are very similar to what is listed on this link: http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825?q=cfinvok I was curious if anyone has ran into this and had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Validation of Date on Form
Yep. We use, and love, this one. If you set the form field as disabled, they would have no choice but to use the date picker. -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 8:07 AM To: CF-Talk Subject: Re: Validation of Date on Form Just force them to enter a date correctly. A good datepicker can be handy for that. I wrote a custom tag wrapper for DHTML Calendar created by Mihai Bazon. You can get it here: http://www.olimpo.ch/tmt/tag/datepicker/ See it in action: http://www.olimpo.ch/tmt/tag/datepicker/sample.cfm Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211324 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Validation of Date on Form
From: Ken Ferguson [mailto:[EMAIL PROTECTED] But you can accept that value just fine -- it's a date. cfset d = July 26, 2005 cfset newd = dateFormat(d, mm/dd/) yields: 07/26/2005 So you have no problems here. As long as you're checking for validity, you're good to go. Now you only have to worry about handling the instances where some knucklehead puts 03.07.2005 in the field expecting it to yield July 7th instead of March 7th., but you've got to draw the line somewhere, right? If that is a possibility, which it almost always is, I would stick with the locale neutral format of -MM-DD and then the US versus European formats are a moot point. :-) ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What breaks during upgrade from 6.1 to 7 - VERITY
There's a bunch of new options for searching in 7.0. Read the docs on verity. I haven't used it yet, but I went to a great session on it by Ray Camden at CF-United. You can now do natural language searches and internet language searches and such. The default behavior may have changed, but you actually now have a much more powerful feature set to play with. That doesn't help my situation. Nothing in LiveDocs or Forta CFMX 7 books tells me that I need to change logic to get it to work. The code is pretty basic stuff. It may be great for you, but to my customer, it sucks. He bases a good portion of his business on Verity searching his proprietary db's. Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using FSO with CF
Hi all I need to know about directories in our Win2003 server with CF7. Using FSO is the best option? What I need to do? Thanx ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using FSO with CF
Hi all I need to know about directories in our Win2003 server with CF7. Using FSO is the best option? What I need to do? Are you talking about the Windows scripting File System Object? ... I wouldn't use that with CF7, I'd use java.io.File and related java file-system classes... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding DSN externally
You can use the (undocumented and unsupported) CF Java servicefactory objects. Google for this and it will turn up. On 7/7/05, ekcien [EMAIL PROTECTED] wrote: I wanted to add DSN externally (Microsoft Access). How can i do so, so that its added just like its done through the CFMX admin interface. Is there any utility or method provided by CFMX for this. Please note that i want it to be added using my application but it should be listed in ColdFusion DSN list like it was added through it. I'm using Cold Fusion MX 6.1 Windows 2003. Please help me if anyone has any idea. -- Geeque - accept the geek within and get your friends off your back - http://www.cafepress.com/geeque/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using FSO with CF
I used to use Win2000 and FSO with CFMX. I was creating directories across the network. It worked perfectly. Then, we upgraded to Win2003 and it all broke. I could still manipulate directories on the CF server, but not across the network anymore. So, if you can use Java to do this, that is the way I would go now. -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 10:07 AM To: CF-Talk Subject: Using FSO with CF Hi all I need to know about directories in our Win2003 server with CF7. Using FSO is the best option? What I need to do? Thanx ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211330 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Services over HTTPS
We have a custom webservice(.NET) we provide to our firm clients that provides use with their data. When we began using CF to access the service, it wouldn't go. Can you reach the service online without the 'invalid certificate' prompt through HTTPS without the certificate imported into your key library? If not, than you're solution is a valid certificate. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 8:33 AM Subject: Web Services over HTTPS I have been trying to get two CF Web Services here to talk to one another via HTTPS with no success. They are both hosted on the same web server and communicate fine via HTTP. I tried getting our data center to use the keytool.exe program to import the certificate for the site but still get the same error. The error we get and steps we have tried are very similar to what is listed on this link: http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825?q=cfinvok I was curious if anyone has ran into this and had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Services over HTTPS
Well every site I go to internally prompts me with the following in IE: Security Alert: Revocation information for the security certificate for this site is not available. Do you want to proceed? Yes / No / View Certificate I can View it and install it but will always get that prompt when using a new instance of the browser. Is this what you are referring to as the invalid certificate prompt? On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: We have a custom webservice(.NET) we provide to our firm clients that provides use with their data. When we began using CF to access the service, it wouldn't go. Can you reach the service online without the 'invalid certificate' prompt through HTTPS without the certificate imported into your key library? If not, than you're solution is a valid certificate. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 8:33 AM Subject: Web Services over HTTPS I have been trying to get two CF Web Services here to talk to one another via HTTPS with no success. They are both hosted on the same web server and communicate fine via HTTP. I tried getting our data center to use the keytool.exe program to import the certificate for the site but still get the same error. The error we get and steps we have tried are very similar to what is listed on this link: http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825?q=cfinvok I was curious if anyone has ran into this and had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: producing a .tif-file
Hi list, I have a few data stored in a my-sql-db. I want to build a word formular based on this data. Then I want to produce a ..tif-file and send it via a fax-gateway to the receipient. Any clues how to produce a .tif-file with or without ColdFusion ? Uwe ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211333 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFCHART in CFFORM
First, you can't use cfchart inside of cfform, it's not a form tag. However, if you want the chart inside of your form you can do it. Like this (either as a flash or jpg): !--- Here starts the chart --- cfchart Name=myChart format=swf chartheight=400 chartwidth=700 showxgridlines=no showygridlines=no showborder=no fontbold=no fontitalic=no labelformat=number xaxistitle=date yaxistitle=hits rotated=no sortxaxis=no showlegend=no showmarkers=no title=Daily Hits style=blue cfchartseries type=bar query=qHits itemcolumn=VisitDate valuecolumn=Hits/cfchartseries /cfchart !--- write the chart to an image file --- cffile action=WRITE file=myChart.swf output=#myChart# cfform name=results format=flash width=800 height=600 cfformitem type=html height=400 width=700 img src=myChart.swf height=400 width=700 /cfform /cfform Hth, ---nimer -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 5:16 AM To: CF-Talk Subject: Re: CFCHART in CFFORM Well.. I still havent been able to figure this out... so I am posting my code to see if a) I am doing something wrong b) there is a bug in CF My code is as follows: cfform name=results format=flash width=800 height=600 cfformgroup type=tabnavigator cfformgroup type=page label=Log File cfgrid name=logGrid query=qLog selectmode=row/cfgrid /cfformgroup cfformgroup type=page label=Hits/Day width=800 height=600 cfformitem type=html !--- Here starts the chart --- cfchart format=png chartheight=400 chartwidth=700 showxgridlines=no showygridlines=no showborder=no fontbold=no fontitalic=no labelformat=number xaxistitle=date yaxistitle=hits rotated=no sortxaxis=no showlegend=no showmarkers=no title=Daily Hits style=blue cfchartseries type=bar query=qHits itemcolumn=VisitDate valuecolumn=Hits/cfchartseries /cfchart !--- Here ends the chart --- /cfformitem /cfformgroup /cfformgroup The first is just a grid that shows in the first tab in the second tab I am trying to display a chart. The chart works fine outside of the CFFORM but if I put the chart in the form... nothing displays. I have tried doing it as flash etc. Any ideas on at least how to debug this? MD On 05/07/05, Mark Drew [EMAIL PROTECTED] wrote: Hi there I dont seem to be able to get a cfchart within a cfformgroup. I basically have a two tabs in a tabnavigator and in one of them I want to place a chart. Is this not possible? or do I just have to seek errors in my code? (which is minimal at the moment) Thanks in advance Mark Drew (and a belated happy 4th of july to you americans out there!) -- Mark Drew ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Any way to remove/rename \cfusionmx\runtime\logs\*.log files?
Hi Is there any way to remove or rename \cfusionmx\runtime\logs\*.log files, short of stopping the cfmx service, moving the files, and starting it again? Can the files be created with dated file name, or be configured to rotate somehow? I've got some pretty big files and it stinks now being able to manipulate them when the site is up. Thanks Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any way to remove/rename \cfusionmx\runtime\logs\*.log files?
Can you not do this in the CF admin's Logging Settings section? If you archive logs in the CF admin, you don't have to worry about locks. You can also set your file sizes to auto-archive the logs. M!ke -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 11:25 AM To: CF-Talk Subject: Any way to remove/rename \cfusionmx\runtime\logs\*.log files? Hi Is there any way to remove or rename \cfusionmx\runtime\logs\*.log files, short of stopping the cfmx service, moving the files, and starting it again? Can the files be created with dated file name, or be configured to rotate somehow? I've got some pretty big files and it stinks now being able to manipulate them when the site is up. Thanks Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211336 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFCHART in CFFORM
First, you can't use cfchart inside of cfform, it's not a form tag. However, if you want the chart inside of your form you can do it. Like this (either as a flash or jpg): !--- Here starts the chart --- cfchart Name=myChart format=swf chartheight=400 chartwidth=700 showxgridlines=no showygridlines=no showborder=no fontbold=no fontitalic=no labelformat=number xaxistitle=date yaxistitle=hits rotated=no sortxaxis=no showlegend=no showmarkers=no title=Daily Hits style=blue cfchartseries type=bar query=qHits itemcolumn=VisitDate valuecolumn=Hits/cfchartseries /cfchart !--- write the chart to an image file --- cffile action=WRITE file=myChart.swf output=#myChart# cfform name=results format=flash width=800 height=600 cfformitem type=html height=400 width=700 img src=myChart.swf height=400 width=700 /cfform /cfform Hth, ---nimer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Services over HTTPS
Yep... did you generate the certificate yourself? Is it a trial certificate? If you get a valid certificate (we use www.thawte.com), your problems should disappear. In fact, this was the only issue we ran into during the whole process. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:37 AM Subject: Re: Web Services over HTTPS Well every site I go to internally prompts me with the following in IE: Security Alert: Revocation information for the security certificate for this site is not available. Do you want to proceed? Yes / No / View Certificate I can View it and install it but will always get that prompt when using a new instance of the browser. Is this what you are referring to as the invalid certificate prompt? On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: We have a custom webservice(.NET) we provide to our firm clients that provides use with their data. When we began using CF to access the service, it wouldn't go. Can you reach the service online without the 'invalid certificate' prompt through HTTPS without the certificate imported into your key library? If not, than you're solution is a valid certificate. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 8:33 AM Subject: Web Services over HTTPS I have been trying to get two CF Web Services here to talk to one another via HTTPS with no success. They are both hosted on the same web server and communicate fine via HTTP. I tried getting our data center to use the keytool.exe program to import the certificate for the site but still get the same error. The error we get and steps we have tried are very similar to what is listed on this link: http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825?q=cfinvok I was curious if anyone has ran into this and had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211338 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: producing a .tif-file
TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Something like a GIF or JPG should be more than adequate... Kevin - Original Message - From: Uwe Degenhardt [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:57 AM Subject: OT: producing a .tif-file Hi list, I have a few data stored in a my-sql-db. I want to build a word formular based on this data. Then I want to produce a ..tif-file and send it via a fax-gateway to the receipient. Any clues how to produce a .tif-file with or without ColdFusion ? Uwe ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any way to remove/rename \cfusionmx\runtime\logs\*.log files?
It looks like that controls the logs in the cfusionmx\logs dir, but not the one under the runtime\logs, which are default-event.log, default-out.log, and default-err.log. Thanks for the pointer though... I didn't know about the other log settings. Mark -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 12:33 PM To: CF-Talk Subject: RE: Any way to remove/rename \cfusionmx\runtime\logs\*.log files? Can you not do this in the CF admin's Logging Settings section? If you archive logs in the CF admin, you don't have to worry about locks. You can also set your file sizes to auto-archive the logs. M!ke -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 11:25 AM To: CF-Talk Subject: Any way to remove/rename \cfusionmx\runtime\logs\*.log files? Hi Is there any way to remove or rename \cfusionmx\runtime\logs\*.log files, short of stopping the cfmx service, moving the files, and starting it again? Can the files be created with dated file name, or be configured to rotate somehow? I've got some pretty big files and it stinks now being able to manipulate them when the site is up. Thanks Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding DSN externally
Go to http://www.keslabs.com/crd Download the CF components, and rip what you need out of the datasource.cfc file. Voila! Kevin - Original Message - From: James Holmes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:15 AM Subject: Re: Adding DSN externally You can use the (undocumented and unsupported) CF Java servicefactory objects. Google for this and it will turn up. On 7/7/05, ekcien [EMAIL PROTECTED] wrote: I wanted to add DSN externally (Microsoft Access). How can i do so, so that its added just like its done through the CFMX admin interface. Is there any utility or method provided by CFMX for this. Please note that i want it to be added using my application but it should be listed in ColdFusion DSN list like it was added through it. I'm using Cold Fusion MX 6.1 Windows 2003. Please help me if anyone has any idea. -- Geeque - accept the geek within and get your friends off your back - http://www.cafepress.com/geeque/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211341 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: producing a .tif-file
You should also be able to feed PDF's or Postscript (.ps) files to the fax gateway. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 12:50 pm To: CF-Talk Subject: Re: producing a .tif-file Importance: Low TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Something like a GIF or JPG should be more than adequate... Kevin - Original Message - From: Uwe Degenhardt [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:57 AM Subject: OT: producing a .tif-file Hi list, I have a few data stored in a my-sql-db. I want to build a word formular based on this data. Then I want to produce a ..tif-file and send it via a fax-gateway to the receipient. Any clues how to produce a .tif-file with or without ColdFusion ? Uwe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: producing a .tif-file
And if not, you can use Ghostscript (cfexecute call from cold fusion) to convert your PDF or .ps files to .tif files if you truly need .tif files. And ghostscript is free. On 7/7/05, SStewart [EMAIL PROTECTED] wrote: You should also be able to feed PDF's or Postscript (.ps) files to the fax gateway. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 12:50 pm To: CF-Talk Subject: Re: producing a .tif-file Importance: Low TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Something like a GIF or JPG should be more than adequate... Kevin - Original Message - From: Uwe Degenhardt [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:57 AM Subject: OT: producing a .tif-file Hi list, I have a few data stored in a my-sql-db. I want to build a word formular based on this data. Then I want to produce a ..tif-file and send it via a fax-gateway to the receipient. Any clues how to produce a .tif-file with or without ColdFusion ? Uwe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211343 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any way to remove/rename \cfusionmx\runtime\logs\*.log files?
To control the runtime logs, update the attributes filename, rotationSize and rotationFiles in cfusion/runtime/servers/coldfusion/SERVER-INF/jrun.xml and restart the CF server. HTH, Jon On 7/7/05, Gaulin, Mark [EMAIL PROTECTED] wrote: Hi Is there any way to remove or rename \cfusionmx\runtime\logs\*.log files, short of stopping the cfmx service, moving the files, and starting it again? Can the files be created with dated file name, or be configured to rotate somehow? I've got some pretty big files and it stinks now being able to manipulate them when the site is up. Thanks Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Services over HTTPS
The certificate is generated through some internal company process that I am nor priviledged to know all the details. I do know that all sites(probably in the 100s) on the network using certificates from this process. Installing a certificate provided through another means would probably be about as hard as turning water into wine though. Sounds almost like we would be best off if we could get our data center to talk to MACR tech support to see if any resolution could be found. Thanks for the pointers though, I was begining to notice that it looks like CF or JRun just does not like our certificates. Although our LDAPS certificate is provided through the exact same process and CFLDAP works fine with it. On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: Yep... did you generate the certificate yourself? Is it a trial certificate? If you get a valid certificate (we use www.thawte.comhttp://www.thawte.com), your problems should disappear. In fact, this was the only issue we ran into during the whole process. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:37 AM Subject: Re: Web Services over HTTPS Well every site I go to internally prompts me with the following in IE: Security Alert: Revocation information for the security certificate for this site is not available. Do you want to proceed? Yes / No / View Certificate I can View it and install it but will always get that prompt when using a new instance of the browser. Is this what you are referring to as the invalid certificate prompt? On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: We have a custom webservice(.NET) we provide to our firm clients that provides use with their data. When we began using CF to access the service, it wouldn't go. Can you reach the service online without the 'invalid certificate' prompt through HTTPS without the certificate imported into your key library? If not, than you're solution is a valid certificate. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 8:33 AM Subject: Web Services over HTTPS I have been trying to get two CF Web Services here to talk to one another via HTTPS with no success. They are both hosted on the same web server and communicate fine via HTTP. I tried getting our data center to use the keytool.exe program to import the certificate for the site but still get the same error. The error we get and steps we have tried are very similar to what is listed on this link: http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825?q=cfinvok I was curious if anyone has ran into this and had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Form variables Application.cfc
Never mind. As I was removing code from Application.cfc to remove clutter, I found an error in the code. -Original Message- From: S. Isaac Dealey I've just started converting my application from application.cfm to Application.cfc. Now none of my form variables are making to the action page. What am I doing wrong? You might want to post the code from your Application.cfc to the list. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: producing a .tif-file
TIFs are mainly uncompressed That's the idea. Uncompressed = 100% quality, unlike a JPEG even at 100%. Though personally I would use a 24 or 32 bit PNG, as it compresses without loss of quality. Sounds like the faxing software only accepts TIFF images though. As for the original question, I'm at a loss. You'll certainly have to call something external, possibly through COM or cfexecute. -nathan strutz Kevin Aebig wrote: TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Something like a GIF or JPG should be more than adequate... Kevin - Original Message - From: Uwe Degenhardt [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:57 AM Subject: OT: producing a .tif-file Hi list, I have a few data stored in a my-sql-db. I want to build a word formular based on this data. Then I want to produce a ..tif-file and send it via a fax-gateway to the receipient. Any clues how to produce a .tif-file with or without ColdFusion ? Uwe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211347 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: producing a .tif-file
Since the end goal is to send a fax, why not go direct with one of the many fax gateway services that CF can talk to? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: .net (please don't hit me)
Or you can just run CF 5 and ASP.NET on the same machine, since BD.NET is CF 6 and because if someone is asking about running cf 5 he is talking about legacy code on a server that probably already has a cf 5 license. I don't know of any gotchas because I didn't work on that part of our server migration. However, we did have issues with NT authentication in CF 5 when we went from IIS 5 to IIS 6. Our ASP code required a few changes, but there was an upgrade in ASP versions invoved also. On 7/7/05, David Manriquez Farias [EMAIL PROTECTED] wrote: You can use BD.net -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Thursday, July 07, 2005 9:16 AM Para: CF-Talk Asunto: RE: .net (please don't hit me) Yes. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 07 July 2005 14:25 To: CF-Talk Subject: .net (please don't hit me) Is it possible to run CF5 and ASP.net (framework) on the same box? Any gotchas? -- You can't destroy EVERYthing. Where would you sit? The Tick Now for hire... http://www.blivit.org/mr_urc/index.cfm Now blogging http://www.blivit.org/blog/index.cfm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211349 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any way to remove/rename \cfusionmx\runtime\logs\*.log files?
Interesting... I can control the default-event.log file name and stuff through the jrun.xml file, but the -err and -out files don't seem to be in here explicitly. Is yours any different? The ThreadedLogEventHandler section looks like this now: service class=jrunx.logger.ThreadedLogEventHandler name=ThreadedLogEventHandler service class=jrunx.logger.ConsoleLogEventHandler name=:service=ConsoleLogEventHandler / service class=jrunx.logger.FileLogEventHandler name=FileLogEventHandler !-- I added .{year}{month}{day} to the filename; it works -- attribute name=filename{jrun.rootdir}/logs/{jrun.server.name}-event.{year}{mont h}{day}.log/attribute attribute name=rotationSize200k/attribute attribute name=rotationFiles3/attribute !-- Use heading to specify an alternate log heading for system event log. -- !-- EXAMPLE: attribute name=heading# Created by JRun on {date MM/dd HH:mm:ss}/attribute -- attribute name=closeDelay5000/attribute attribute name=deleteOnExitfalse/attribute /service /service Ah, I just found them in the registry, in the LocalMachine\Services\CurrentControlSet\ColdFusion MX App Server section, as SystemOut and SystemErr. Unfortunately, the {year}{month}{day} symbols are not being replaced with values... they end up empty. Bummer. (I got those symbols from some jrun 3 documentation, and it does work for the event file in the jrun.xml) Anybody know more about this stuff? Thanks Mark -Original Message- From: Jon Gunnip [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 1:06 PM To: CF-Talk Subject: Re: Any way to remove/rename \cfusionmx\runtime\logs\*.log files? To control the runtime logs, update the attributes filename, rotationSize and rotationFiles in cfusion/runtime/servers/coldfusion/SERVER-INF/jrun.xml and restart the CF server. HTH, Jon On 7/7/05, Gaulin, Mark [EMAIL PROTECTED] wrote: Hi Is there any way to remove or rename \cfusionmx\runtime\logs\*.log files, short of stopping the cfmx service, moving the files, and starting it again? Can the files be created with dated file name, or be configured to rotate somehow? I've got some pretty big files and it stinks now being able to manipulate them when the site is up. Thanks Mark ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211350 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any way to remove/rename \cfusionmx\runtime\logs\*.log files?
its a JRun thing...AFAIK, a couple of those log files do not have rollover/rotate capabilities. This was discussed before wither here or JRun-Talk I think. DK On 7/7/05, Gaulin, Mark [EMAIL PROTECTED] wrote: Interesting... I can control the default-event.log file name and stuff through the jrun.xml file, but the -err and -out files don't seem to be in here explicitly. Is yours any different? The ThreadedLogEventHandler section looks like this now: service class=jrunx.logger.ThreadedLogEventHandler name=ThreadedLogEventHandler service class=jrunx.logger.ConsoleLogEventHandler name=:service=ConsoleLogEventHandler / service class=jrunx.logger.FileLogEventHandler name=FileLogEventHandler !-- I added .{year}{month}{day} to the filename; it works -- attribute name=filename{jrun.rootdir}/logs/{jrun.server.namehttp://jrun.server.name }-event.{year}{mont h}{day}.log/attribute attribute name=rotationSize200k/attribute attribute name=rotationFiles3/attribute !-- Use heading to specify an alternate log heading for system event log. -- !-- EXAMPLE: attribute name=heading# Created by JRun on {date MM/dd HH:mm:ss}/attribute -- attribute name=closeDelay5000/attribute attribute name=deleteOnExitfalse/attribute /service /service Ah, I just found them in the registry, in the LocalMachine\Services\CurrentControlSet\ColdFusion MX App Server section, as SystemOut and SystemErr. Unfortunately, the {year}{month}{day} symbols are not being replaced with values... they end up empty. Bummer. (I got those symbols from some jrun 3 documentation, and it does work for the event file in the jrun.xml) Anybody know more about this stuff? Thanks Mark -Original Message- From: Jon Gunnip [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 1:06 PM To: CF-Talk Subject: Re: Any way to remove/rename \cfusionmx\runtime\logs\*.log files? To control the runtime logs, update the attributes filename, rotationSize and rotationFiles in cfusion/runtime/servers/coldfusion/SERVER-INF/jrun.xml and restart the CF server. HTH, Jon On 7/7/05, Gaulin, Mark [EMAIL PROTECTED] wrote: Hi Is there any way to remove or rename \cfusionmx\runtime\logs\*.log files, short of stopping the cfmx service, moving the files, and starting it again? Can the files be created with dated file name, or be configured to rotate somehow? I've got some pretty big files and it stinks now being able to manipulate them when the site is up. Thanks Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211351 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: .net (please don't hit me)
I'm with David. I would strongly reccomend checking out Blue Dragon ..NET edition. Why run CFML along side .NET if you and run it IN .NET. Blue dragon is pretty good on the compatability with CF 5, and the license is reasonable. I'm sure Charlie or someone else from New Atlanta will be along soon enough to pimp thier product in this discussion :) Adam H On 7/7/05, Jennifer Larkin [EMAIL PROTECTED] wrote: Or you can just run CF 5 and ASP.NET on the same machine, since BD.NET is CF 6 and because if someone is asking about running cf 5 he is talking about legacy code on a server that probably already has a cf 5 license. I don't know of any gotchas because I didn't work on that part of our server migration. However, we did have issues with NT authentication in CF 5 when we went from IIS 5 to IIS 6. Our ASP code required a few changes, but there was an upgrade in ASP versions invoved also. On 7/7/05, David Manriquez Farias [EMAIL PROTECTED] wrote: You can use BD.net -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Thursday, July 07, 2005 9:16 AM Para: CF-Talk Asunto: RE: .net (please don't hit me) Yes. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 07 July 2005 14:25 To: CF-Talk Subject: .net (please don't hit me) Is it possible to run CF5 and ASP.net (framework) on the same box? Any gotchas? -- You can't destroy EVERYthing. Where would you sit? The Tick Now for hire... http://www.blivit.org/mr_urc/index.cfm Now blogging http://www.blivit.org/blog/index.cfm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Application Planning
Can anyone recommend any good planning software for ColdFusion apps? Specifically apps created using Fusebox or Mach-ii. In the past I have used MindMapper and Fusebuilder but I'm wondering if there are any tools that may be better and allow for faster application development. Any ideas? Thanks, --Anne ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211353 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: producing a .tif-file
TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Because the fax format is a TIFF format. And yes, TIFF is compressed, not as much as other formats, but compression is provided in TIFF format. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211354 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: producing a .tif-file
Uncompressed = 100% quality Contrarily to JPEG, the TIFF compression is lossless, then quality is not affected. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211355 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application Planning
From: Anne Girardeau [mailto:[EMAIL PROTECTED] Can anyone recommend any good planning software for ColdFusion apps? Specifically apps created using Fusebox or Mach-ii. In the past I have used MindMapper and Fusebuilder but I'm wondering if there are any tools that may be better and allow for faster application development. Any ideas? Anne, Check out Adalon from a company called Synthis. www.adalon.net It is an excellent tool! Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211356 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: producing a .tif-file
The output is a .tif. But the input could be almost anything as long as the server/software can read it. And yes, you're right the .tif format uses LZW compression Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 02:11 pm To: CF-Talk Subject: Re: producing a .tif-file Importance: Low TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Because the fax format is a TIFF format. And yes, TIFF is compressed, not as much as other formats, but compression is provided in TIFF format. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211357 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using FSO with CF
Thanks S. Isaac Dealey Yes. I need to use FSO with CF(CreateObject). But what I need to setup in our Win2003 Server. With Java I'll get best results? Thanx once more again. MD 2005/7/7, S. Isaac Dealey [EMAIL PROTECTED]: Hi all I need to know about directories in our Win2003 server with CF7. Using FSO is the best option? What I need to do? Are you talking about the Windows scripting File System Object? ... I wouldn't use that with CF7, I'd use java.io.File and related java file-system classes... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211358 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: producing a .tif-file
But it is lossless compression, as opposed to the lossy compression in jpgs. It just uses RLE, doesn't it? On 7/7/05, Claude Schneegans [EMAIL PROTECTED] wrote: TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Because the fax format is a TIFF format. And yes, TIFF is compressed, not as much as other formats, but compression is provided in TIFF format. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211359 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: producing a .tif-file
you're right the .tif format uses LZW compression To be more accurate, the TIFF format used for fax uses LZW compression. The tiff format can use any compression algorithm, or no compression at all. This is why digitizers generally produce uncompressed tiff files, because the compression standard in tiff format is too fuzzy. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211360 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
insert one xml object as the child of another?
Is there any way to insert one xml object as a child node in another xml object? Right now I'm doing an xml search, which returns an array with xml objects. I want to loop through the array, process each xml object individually. (during which I add nodes to each object) Then I want to combine all the objects in the array as children of another xml object. So far I have only been able to combine these by converting each array element to it's xml string, replace the xml definition and insert the xml string into the destination xml string. Then finally parse the destination xml string. Why can't I get this to work without strings or a recursive UDF? I tried: ArrayAppend(destXML.DispenseFile.XmlChildren, XmlElemNew(destXML,XML_SearchResultsArray[1].xmlName)); destXML.DispenseFile.XmlChildren[arraylen(destXML.DispenseFile.XmlChildren)] = XML_SearchResultsArray[1]; but I get the error: WRONG_DOCUMENT_ERR: A node is used in a different document than the one that created it. Only thing I can find with google is that the DOM1 doesn't support this so am I correct in assuming this has to do with the underling java? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application Planning
Can anyone recommend any good planning software for ColdFusion apps? FuseBuilder.net :-) Its designed for Fusebox 4.1 and can output either PHP or CFML code. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOT] regex to validate SQL Server datetime type (for xsd pattern restriction)
I'm working on using the xmlvalidate() function in MX7 but I'm finding the standard for datetime that xsd uses annoying since CF doesn't recognize it as a date. I would rather setup a custom type in my xsd using a pattern restriction. Pattern restrictions use regex to validate the element. Does anyone have regex to validate a datetime for sql server? preferably where the time portion is optional. Anthony ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211363 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
Mike, That looks like a really good piece of software but a little on the expensive side at $1,500 per seat. Might they offer a lower price for government agencies? --Anne Michael T. Tangorre wrote: From: Anne Girardeau [mailto:[EMAIL PROTECTED] Can anyone recommend any good planning software for ColdFusion apps? Specifically apps created using Fusebox or Mach-ii. In the past I have used MindMapper and Fusebuilder but I'm wondering if there are any tools that may be better and allow for faster application development. Any ideas? Anne, Check out Adalon from a company called Synthis. www.adalon.net It is an excellent tool! Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211364 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
XML xmlText or Attributes
When would I use an attribute to hold a value versus xmlText? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211365 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using FSO with CF
Thanks S. Isaac Dealey Yes. I need to use FSO with CF(CreateObject). But what I need to setup in our Win2003 Server. With Java I'll get best results? Thanx once more again. I would expect the java classes like java.io.File to be more efficient when using ColdFusion version 6.1 or later. (On version 5 the windows scripting object might be more efficient.) But asside from efficiency, the java classes are more portable since they can be used on any CF app platform, whether that's windows, linux, solaris or some unsupported JBoss instance on a SCO Unix machine. Reflection of the java classes when using ColdFusion 6.1 or later is amazingly efficient in and of itself when you're not relying on the CF native tags like cfdirectory which returns a bunch of information you may or may not need / want about the collection of files in your directory. Cfdirectory is great for the sake of simplicity, but if you really need performance, digging out the underlying java classes is the way to go. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application Planning
Can anyone recommend any good planning software for ColdFusion apps? FuseBuilder.net :-) Its designed for Fusebox 4.1 and can output either PHP or CFML code. On a related note, this just landed in my inbox: - Dear Damien Mckenna A new version of FuseBuilder 4.1 Edition is online now, with some fantastic advancements. I list some of these features below: 1 - Existing Fusebox apps -- ColdFusion or PHP -- can now be imported for use as new FuseBuilder projects! This is a huge advancement, and works extremely well in preserving your fusebox and circuit xml, and any Class / Lexicons. Round-trip editing with FuseBuilder as your IDE is now completely possible! 2 - Improved 'listener' for Wireframe Notes: It's now keyed properly to the name of the fuseaction only, so switching from simulation to editing won't make the Notes switch to a different page. 3 - Full support for loop's newer attributes, such as 'index', or 'query' 4 - Bugs squashed, as always :p I hope you're as thrilled with the new features as I am! As always, I'm available to answer any questions you may have via this email address. Mike www.fusebuilder.net ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Services over HTTPS
I would definately talk with MM about this... and definately post the results. =] Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 11:09 AM Subject: Re: Web Services over HTTPS The certificate is generated through some internal company process that I am nor priviledged to know all the details. I do know that all sites(probably in the 100s) on the network using certificates from this process. Installing a certificate provided through another means would probably be about as hard as turning water into wine though. Sounds almost like we would be best off if we could get our data center to talk to MACR tech support to see if any resolution could be found. Thanks for the pointers though, I was begining to notice that it looks like CF or JRun just does not like our certificates. Although our LDAPS certificate is provided through the exact same process and CFLDAP works fine with it. On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: Yep... did you generate the certificate yourself? Is it a trial certificate? If you get a valid certificate (we use www.thawte.comhttp://www.thawte.com), your problems should disappear. In fact, this was the only issue we ran into during the whole process. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:37 AM Subject: Re: Web Services over HTTPS Well every site I go to internally prompts me with the following in IE: Security Alert: Revocation information for the security certificate for this site is not available. Do you want to proceed? Yes / No / View Certificate I can View it and install it but will always get that prompt when using a new instance of the browser. Is this what you are referring to as the invalid certificate prompt? On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: We have a custom webservice(.NET) we provide to our firm clients that provides use with their data. When we began using CF to access the service, it wouldn't go. Can you reach the service online without the 'invalid certificate' prompt through HTTPS without the certificate imported into your key library? If not, than you're solution is a valid certificate. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 8:33 AM Subject: Web Services over HTTPS I have been trying to get two CF Web Services here to talk to one another via HTTPS with no success. They are both hosted on the same web server and communicate fine via HTTP. I tried getting our data center to use the keytool.exe program to import the certificate for the site but still get the same error. The error we get and steps we have tried are very similar to what is listed on this link: http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825?q=cfinvok I was curious if anyone has ran into this and had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Checkbox baby checkbox 123..
Hi guys, I've got a form which has 4 checkboxes - relationshipType1, relationshipType2, relationshipType3 and relationshipType4. Getting this information I then use it in a select statement. In my WHERE clause i put something like: WHERE gender = '#form.genderSeeking#' AND genderSeeking = '#form.gender#'cfif form.relationshipType1 eq 'true' AND relationshipTypes LIKE '%1%'/cfifcfif form.relationshipType2 eq 'true' AND relationshipTypes LIKE '%2%'/cfifcfif form.relationshipType3 eq 'true' AND relationshipTypes LIKE '%3%'/ cfifcfif form.relationshipType4 eq 'true' AND relationshipTypes LIKE '%4%'/cfif In my DB there relationshipType may equal something like '1,2,3,4' or '1,3' etc, any of the combinations of the 4 types. I have realised that my logic isn't correct... is there an easy way to check whether relationshipTypes (in my DB) = one of my four form checkboxes? Thanks for your help, Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211369 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: SQL count of rows from a union query
Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Services over HTTPS
If we find a solution then I will post it up. Right now they want to wait and see if the problem still occurs after restarting the CF service. The restart happens this evening so will not know anything until tomorrow. On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: I would definately talk with MM about this... and definately post the results. =] Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 11:09 AM Subject: Re: Web Services over HTTPS The certificate is generated through some internal company process that I am nor priviledged to know all the details. I do know that all sites(probably in the 100s) on the network using certificates from this process. Installing a certificate provided through another means would probably be about as hard as turning water into wine though. Sounds almost like we would be best off if we could get our data center to talk to MACR tech support to see if any resolution could be found. Thanks for the pointers though, I was begining to notice that it looks like CF or JRun just does not like our certificates. Although our LDAPS certificate is provided through the exact same process and CFLDAP works fine with it. On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: Yep... did you generate the certificate yourself? Is it a trial certificate? If you get a valid certificate (we use www.thawte.com http://www.thawte.comhttp://www.thawte.com), your problems should disappear. In fact, this was the only issue we ran into during the whole process. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:37 AM Subject: Re: Web Services over HTTPS Well every site I go to internally prompts me with the following in IE: Security Alert: Revocation information for the security certificate for this site is not available. Do you want to proceed? Yes / No / View Certificate I can View it and install it but will always get that prompt when using a new instance of the browser. Is this what you are referring to as the invalid certificate prompt? On 7/7/05, Kevin Aebig [EMAIL PROTECTED] wrote: We have a custom webservice(.NET) we provide to our firm clients that provides use with their data. When we began using CF to access the service, it wouldn't go. Can you reach the service online without the 'invalid certificate' prompt through HTTPS without the certificate imported into your key library? If not, than you're solution is a valid certificate. Kevin - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 8:33 AM Subject: Web Services over HTTPS I have been trying to get two CF Web Services here to talk to one another via HTTPS with no success. They are both hosted on the same web server and communicate fine via HTTP. I tried getting our data center to use the keytool.exe program to import the certificate for the site but still get the same error. The error we get and steps we have tried are very similar to what is listed on this link: http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825?q=cfinvok I was curious if anyone has ran into this and had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
PreserveSingleQuotes Woes - Possible Bug?
I'm having an issue with the PreserveSingleQuotes function. I'm running CFMX 6.1 on a Win2k box. Here's a code sample: ---Start--- cfset testa = arraynew(1) cfloop from=1 to=5 index=go cfset testa[go] = ' go ' /cfloop cfoutput#preservesinglequotes(testa[1])#/cfoutput ---End--- Now this results in a Invalid CFML construct found on line 10 at column 38. Where line 10, Col 38 being the [ character. Now if I do this: ---Start--- cfset testa = arraynew(1) cfloop from=1 to=5 index=go cfset testa[go] = ' go ' /cfloop cfset tes = testa[1] cfoutput#preservesinglequotes(tes)#/cfoutput ---End--- The code will execute without a hitch. Is there any reason why this function will not accept an array variable? TIA. --j ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Checkbox baby checkbox 123..
I yi yi...it sounds like your DB design could use a good kick in the pants, is what it sounds like. If I were doing it, I'd make the db design a many to many relationship, and I'd name the checkboxes all the same thing, and then I'd have SELECT ... FROM maintable m, typejointable t WHERE m.id = t.id AND t.relationshipTypes IN (cfqueryparam cfsqltype=cf_sql_integer list=yes value=#form.relationshipTypes#) On 7/7/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I've got a form which has 4 checkboxes - relationshipType1, relationshipType2, relationshipType3 and relationshipType4. Getting this information I then use it in a select statement. In my WHERE clause i put something like: WHERE gender = '#form.genderSeeking#' AND genderSeeking = '#form.gender#'cfif form.relationshipType1 eq 'true' AND relationshipTypes LIKE '%1%'/cfifcfif form.relationshipType2 eq 'true' AND relationshipTypes LIKE '%2%'/cfifcfif form.relationshipType3 eq 'true' AND relationshipTypes LIKE '%3%'/ cfifcfif form.relationshipType4 eq 'true' AND relationshipTypes LIKE '%4%'/cfif In my DB there relationshipType may equal something like '1,2,3,4' or '1,3' etc, any of the combinations of the 4 types. I have realised that my logic isn't correct... is there an easy way to check whether relationshipTypes (in my DB) = one of my four form checkboxes? Thanks for your help, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL count of rows from a union query
Try something like SELECT count(ObjectID) + (SELECT count(ObjectID) FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID) AS total FROMtable1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID the UNION operator is really for returning multiple rows of similarly typed data from disparate tables. That's not what you are trying to do here. -mk Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 2:22 PM To: CF-Talk Subject: OT: SQL count of rows from a union query Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211374 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML xmlText or Attributes
Andy, When would I use an attribute to hold a value versus xmlText? When it makes sense to do so. ;) There really is no absolute rule to this, but generally speaking I leave xmlText for when I need to define large amounts of content that are static and use attributes to define very specific aspects of the tag (which are normally single word values.) Example 1: // doesn't make sense p value=Imagine this as a really long paragraph. / // makes sense p Imagine this as a really long paragraph. /p Example 2: // makes sense item id=S0023JC / // doesn't make as much sense itemS0023JC/item If you're really not sure what makes the most sense, try and think of an example HTML/CFML tag that is similar in nature and follow what they do (not that those are always correct.) -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL count of rows from a union query
could you put it in a 3rd query? Something like.. SELECT count(*) from ( SELECT * FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) ) On 7/7/05, Mark A Kruger [EMAIL PROTECTED] wrote: Try something like SELECT count(ObjectID) + (SELECT count(ObjectID) FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID) AS total FROMtable1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID the UNION operator is really for returning multiple rows of similarly typed data from disparate tables. That's not what you are trying to do here. -mk Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 2:22 PM To: CF-Talk Subject: OT: SQL count of rows from a union query Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Checkbox baby checkbox 123..
Thanks Deanna, So do you mean i should create a table and in that i should have the different types of relationships, ie Love, Friendship, Travelmate, Casual as separate rows? Thanks, Saturday On 7 Jul 2005, at 21:05, Deanna Schneider wrote: I yi yi...it sounds like your DB design could use a good kick in the pants, is what it sounds like. If I were doing it, I'd make the db design a many to many relationship, and I'd name the checkboxes all the same thing, and then I'd have SELECT ... FROM maintable m, typejointable t WHERE m.id = t.id AND t.relationshipTypes IN (cfqueryparam cfsqltype=cf_sql_integer list=yes value=#form.relationshipTypes#) On 7/7/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I've got a form which has 4 checkboxes - relationshipType1, relationshipType2, relationshipType3 and relationshipType4. Getting this information I then use it in a select statement. In my WHERE clause i put something like: WHERE gender = '#form.genderSeeking#' AND genderSeeking = '#form.gender#'cfif form.relationshipType1 eq 'true' AND relationshipTypes LIKE '%1%'/cfifcfif form.relationshipType2 eq 'true' AND relationshipTypes LIKE '%2%'/cfifcfif form.relationshipType3 eq 'true' AND relationshipTypes LIKE '%3%'/ cfifcfif form.relationshipType4 eq 'true' AND relationshipTypes LIKE '%4%'/cfif In my DB there relationshipType may equal something like '1,2,3,4' or '1,3' etc, any of the combinations of the 4 types. I have realised that my logic isn't correct... is there an easy way to check whether relationshipTypes (in my DB) = one of my four form checkboxes? Thanks for your help, Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211377 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
I just got the e-mail too. As I mentioned in my earlier post, I've already been using Fusebuilder. I'm just wondering if there may be anything else out there that's better. Thanks, --Anne Damien McKenna wrote: Can anyone recommend any good planning software for ColdFusion apps? FuseBuilder.net :-) Its designed for Fusebox 4.1 and can output either PHP or CFML code. On a related note, this just landed in my inbox: - Dear Damien Mckenna A new version of FuseBuilder 4.1 Edition is online now, with some fantastic advancements. I list some of these features below: 1 - Existing Fusebox apps -- ColdFusion or PHP -- can now be imported for use as new FuseBuilder projects! This is a huge advancement, and works extremely well in preserving your fusebox and circuit xml, and any Class / Lexicons. Round-trip editing with FuseBuilder as your IDE is now completely possible! 2 - Improved 'listener' for Wireframe Notes: It's now keyed properly to the name of the fuseaction only, so switching from simulation to editing won't make the Notes switch to a different page. 3 - Full support for loop's newer attributes, such as 'index', or 'query' 4 - Bugs squashed, as always :p I hope you're as thrilled with the new features as I am! As always, I'm available to answer any questions you may have via this email address. Mike www.fusebuilder.net ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211378 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Checkbox baby checkbox 123..
Yep. So you'd have your relationshiptypes table, and you'd also have a join table. In the join table you'd just store the id of the main table row and the id of the relationshiptype table row. The combo of the two would be the primary key. So, if I was person1 and I was looking for friendship and travelmates, I'd have 2 rows in the join table - one for each of the types I'm looking for. On 7/7/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Thanks Deanna, So do you mean i should create a table and in that i should have the different types of relationships, ie Love, Friendship, Travelmate, Casual as separate rows? Thanks, Saturday On 7 Jul 2005, at 21:05, Deanna Schneider wrote: I yi yi...it sounds like your DB design could use a good kick in the pants, is what it sounds like. If I were doing it, I'd make the db design a many to many relationship, and I'd name the checkboxes all the same thing, and then I'd have SELECT ... FROM maintable m, typejointable t WHERE m.id = t.id AND t.relationshipTypes IN (cfqueryparam cfsqltype=cf_sql_integer list=yes value=#form.relationshipTypes#) On 7/7/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I've got a form which has 4 checkboxes - relationshipType1, relationshipType2, relationshipType3 and relationshipType4. Getting this information I then use it in a select statement. In my WHERE clause i put something like: WHERE gender = '#form.genderSeeking#' AND genderSeeking = '#form.gender#'cfif form.relationshipType1 eq 'true' AND relationshipTypes LIKE '%1%'/cfifcfif form.relationshipType2 eq 'true' AND relationshipTypes LIKE '%2%'/cfifcfif form.relationshipType3 eq 'true' AND relationshipTypes LIKE '%3%'/ cfifcfif form.relationshipType4 eq 'true' AND relationshipTypes LIKE '%4%'/cfif In my DB there relationshipType may equal something like '1,2,3,4' or '1,3' etc, any of the combinations of the 4 types. I have realised that my logic isn't correct... is there an easy way to check whether relationshipTypes (in my DB) = one of my four form checkboxes? Thanks for your help, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211379 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML xmlText or Attributes
I read an Eric Meyer, of CSS fame, quote on this that makes some sense to me. As a general rule of thumb i.e. not a hard and fast rule. Use xmlText for values you mean to be output and viewed by the user. Use attributes for values used to sort, filter or select the above. Make sense. Otherwise I will have to go dig up the quote, and I am so bad at that. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211380 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: insert one xml object as the child of another?
You have two options here. You can do it with undocumented ColdFusoin functionality that allows the copying and replacing of nodes in a CF XML object. Or you can use XSLT code and the xmlTransform() function. I generally prefer the latter. Contact my off-list if you would like a copy of the below as a CFM file. cfxml variable=doc1 root member id=10 nameIan/name sexmale/sex /member /root /cfxml cfxml variable=doc2 root member id=1 nameJoe/name sexmale/sex /member member id=2 nameJohn/name sexmale/sex /member member id=3 nameSue/name sexfemale/sex /member /root /cfxml cffile action=write file=#expandPath(/)#\doc2.xml output=#ToString(doc2)# nameconflict=overwrite !--- METHOD ONE using a depreciated and undocumented method --- cfset newNode = doc1.root.member.cloneNode(true) cfset doc2.changeNodeOwner(newNode) cfset doc2.root.appendChild(newNode) cfdump var=#doc2# label=Merged by hidden functions expand=no !--- METHOD TWO using XSLT --- !--- create an xsl docutment--- cfoutput cfsavecontent variable=transformer xsl:stylesheet xmlns:xsl=http://www.w3.org/1999/XSL/Transform; version=1.0 xsl:output method=xml/ !--load the merge file -- xsl:variable name=emps select=document('#expandPath(/)#\doc2.xml')/ !--- this line references and XML file to be combined with the main file, I wonder if there is a way to use an XML document in memory here? --- !-- combine the files -- xsl:template match=/ root !-- select all the child nodes of the root tag in the main file -- xsl:for-each select=root/child::* !-- copy the member tag -- xsl:copy-of select=./ /xsl:for-each !-- and all the child nodes of the root tag in the merge file -- xsl:for-each select=$emps/root/child::* !-- copy the member tag -- xsl:copy-of select=./ /xsl:for-each /root /xsl:template /xsl:stylesheet /cfsavecontent /cfoutput !--- create a combined xml document --- cfset doc2 = XMLparse(XMLtransform(doc1,transformer)) cfdump var=#doc2# label=Merged by XSLT expand=no -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211381 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL count of rows from a union query
SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) AFAIK, one can have a subquery in a WHERE or HAVING clause, but not inside a FROM. How about making two separate queries and add their record count in CF? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PreserveSingleQuotes Woes - Possible Bug?
Preservesinglequote () is a weird object in CF and is NOT really a function. All what it does it telling the CF precessor NOT to automatically escape single quotes while building an SQL expression, then: rule 1 = you cannot use Preservesinglequote () outside some CFQUERY construct, rule 2 = you cannot use as a parameter anything else than a variable. So, cfoutput#preservesinglequotes(testa[1])#/cfoutput is illegal . cfoutput#preservesinglequotes(tes)#/cfoutput The code will execute without a hitch. This one may be synctically legal, but outside a CFQUERY it will just do nothing. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL count of rows from a union query
Mark, I am trying to return multiple rows of similarly typed data, specifically one column named ObjectID. Only, instead of deriving the number of rows from a getResults.RecordCount, I want to do it in the SQL query itself. Your suggestion will not weed out the duplicate instances of ObjectID which a UNION would accomplish. Thanks though, it would have worked save for the fact that the database was not the best conceived. I am having the deuce of a time doing any reporting. George On 7/7/05, Mark A Kruger [EMAIL PROTECTED] wrote: Try something like SELECT count(ObjectID) + (SELECT count(ObjectID) FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID) AS total FROMtable1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID the UNION operator is really for returning multiple rows of similarly typed data from disparate tables. That's not what you are trying to do here. -mk Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 2:22 PM To: CF-Talk Subject: OT: SQL count of rows from a union query Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211384 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL count of rows from a union query
Greg, It fails even with a SELECT * FROM (SELECT UNION SELECT). George On 7/7/05, Greg Morphis [EMAIL PROTECTED] wrote: could you put it in a 3rd query? Something like.. SELECT count(*) from ( SELECT * FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) ) On 7/7/05, Mark A Kruger [EMAIL PROTECTED] wrote: Try something like SELECT count(ObjectID) + (SELECT count(ObjectID) FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID) AS total FROMtable1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID the UNION operator is really for returning multiple rows of similarly typed data from disparate tables. That's not what you are trying to do here. -mk Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 2:22 PM To: CF-Talk Subject: OT: SQL count of rows from a union query Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Checkbox baby checkbox 123..
You should have a people table and you should have a relationship types table and you should have a people's relationship types table. people -userid -blah -blah relationship_types -typeid -typeDesc people_relationship_types -userid -typeid then name the checkboxes the same with different values and then: select distinct userid from people p left join people_relationship_types prt on p.userid = prt.userid left join relationship_types rt on rt.typeid = prt.typeid where rt.typeid in(#form.relationshipTypes#) and I'm sure you can do it in other db's too with different syntax and there are probably other ways to accomplish the same goal, but if you're using MySQL, you could just do: select distinct p.userid, group_concat(rt.typedesc) as typeDesc from people p left join people_relationship_types prt on p.userid = prt.userid left join relationship_types rt on rt.typeid = prt.typeid group by p.userid where rt.typeid in(#form.relationshipTypes#) Someone may not like my left join query there, but that's my first thought. --Ferg Saturday (Stuart Kidd) wrote: Thanks Deanna, So do you mean i should create a table and in that i should have the different types of relationships, ie Love, Friendship, Travelmate, Casual as separate rows? Thanks, Saturday On 7 Jul 2005, at 21:05, Deanna Schneider wrote: I yi yi...it sounds like your DB design could use a good kick in the pants, is what it sounds like. If I were doing it, I'd make the db design a many to many relationship, and I'd name the checkboxes all the same thing, and then I'd have SELECT ... FROM maintable m, typejointable t WHERE m.id = t.id AND t.relationshipTypes IN (cfqueryparam cfsqltype=cf_sql_integer list=yes value=#form.relationshipTypes#) On 7/7/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I've got a form which has 4 checkboxes - relationshipType1, relationshipType2, relationshipType3 and relationshipType4. Getting this information I then use it in a select statement. In my WHERE clause i put something like: WHERE gender = '#form.genderSeeking#' AND genderSeeking = '#form.gender#'cfif form.relationshipType1 eq 'true' AND relationshipTypes LIKE '%1%'/cfifcfif form.relationshipType2 eq 'true' AND relationshipTypes LIKE '%2%'/cfifcfif form.relationshipType3 eq 'true' AND relationshipTypes LIKE '%3%'/ cfifcfif form.relationshipType4 eq 'true' AND relationshipTypes LIKE '%4%'/cfif In my DB there relationshipType may equal something like '1,2,3,4' or '1,3' etc, any of the combinations of the 4 types. I have realised that my logic isn't correct... is there an easy way to check whether relationshipTypes (in my DB) = one of my four form checkboxes? Thanks for your help, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211386 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL count of rows from a union query
Ah, That explains it. I just solved it using an ugly workaround. SELECT count(*) FROM table1 WHERE ObjectID IN( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) Thanks all, George On 7/7/05, Claude Schneegans [EMAIL PROTECTED] wrote: SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) AFAIK, one can have a subquery in a WHERE or HAVING clause, but not inside a FROM. How about making two separate queries and add their record count in CF? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211387 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL count of rows from a union query
No you are not - you are trying to aggregate the results from multiple rows - NOT return them .. and you don't want the objectID you want a count of objectids that meet a certain test. -mk -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 3:59 PM To: CF-Talk Subject: Re: SQL count of rows from a union query Mark, I am trying to return multiple rows of similarly typed data, specifically one column named ObjectID. Only, instead of deriving the number of rows from a getResults.RecordCount, I want to do it in the SQL query itself. Your suggestion will not weed out the duplicate instances of ObjectID which a UNION would accomplish. Thanks though, it would have worked save for the fact that the database was not the best conceived. I am having the deuce of a time doing any reporting. George On 7/7/05, Mark A Kruger [EMAIL PROTECTED] wrote: Try something like SELECT count(ObjectID) + (SELECT count(ObjectID) FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID) AS total FROMtable1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID the UNION operator is really for returning multiple rows of similarly typed data from disparate tables. That's not what you are trying to do here. -mk Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 2:22 PM To: CF-Talk Subject: OT: SQL count of rows from a union query Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: SQL count of rows from a union query
There you go... it's not ugly - I think it's light years better than the union query :) -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 4:03 PM To: CF-Talk Subject: Re: OT: SQL count of rows from a union query Ah, That explains it. I just solved it using an ugly workaround. SELECT count(*) FROM table1 WHERE ObjectID IN( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) Thanks all, George On 7/7/05, Claude Schneegans [EMAIL PROTECTED] wrote: SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) AFAIK, one can have a subquery in a WHERE or HAVING clause, but not inside a FROM. How about making two separate queries and add their record count in CF? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Noob: getting a total from some CFOUTPUTted fields
Hey list! How's it going? My first app is running now. I couldn't have done it without everybody's help! Thanks to all. Perhaps I will eventually become a useful member myself. Now, in my app I have a CFOUTPUT that displays table rows like this: CUSTOMER PRODUCT ORDER VALUE #customer##product##order_value# I'd like to have a TOTAL field at the bottom of the table, that displays the sum of all the CFOUTPUTted #order_values#. Is this very difficult? This is what I'd like to see: CUSTOMERPRODUCTORDER VALUE Tom Apple 100 Dick Banana 200 -- TOTAL 300 How do I calculate the total? Thanks in advance, CK. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211390 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Noob: getting a total from some CFOUTPUTted fields
cfset total = 0 / cfoutput ... cfset total = total + order_value / ... /cfoutput TOTAL #total# cheers, barneyb On 7/7/05, Chris Kavanagh [EMAIL PROTECTED] wrote: Hey list! How's it going? My first app is running now. I couldn't have done it without everybody's help! Thanks to all. Perhaps I will eventually become a useful member myself. Now, in my app I have a CFOUTPUT that displays table rows like this: CUSTOMER PRODUCT ORDER VALUE #customer##product##order_value# I'd like to have a TOTAL field at the bottom of the table, that displays the sum of all the CFOUTPUTted #order_values#. Is this very difficult? This is what I'd like to see: CUSTOMERPRODUCTORDER VALUE Tom Apple 100 Dick Banana 200 -- TOTAL 300 How do I calculate the total? Thanks in advance, CK. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211391 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Noob: getting a total from some CFOUTPUTted fields
Just incase the noobie misses the mistake. cfset total = 0 / cfoutput ... cfset total = total + order_value / ... /cfoutput . TOTAL cfoutput#total#/cfoutput cheers, barneyb We still need those variables to be inside cfoutput sets, don't we. :-) -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 3:40 PM To: CF-Talk Subject: Re: Noob: getting a total from some CFOUTPUTted fields cfset total = 0 / cfoutput ... cfset total = total + order_value / ... /cfoutput TOTAL #total# cheers, barneyb On 7/7/05, Chris Kavanagh [EMAIL PROTECTED] wrote: Hey list! How's it going? My first app is running now. I couldn't have done it without everybody's help! Thanks to all. Perhaps I will eventually become a useful member myself. Now, in my app I have a CFOUTPUT that displays table rows like this: CUSTOMER PRODUCT ORDER VALUE #customer##product##order_value# I'd like to have a TOTAL field at the bottom of the table, that displays the sum of all the CFOUTPUTted #order_values#. Is this very difficult? This is what I'd like to see: CUSTOMERPRODUCTORDER VALUE Tom Apple 100 Dick Banana 200 -- TOTAL 300 How do I calculate the total? Thanks in advance, CK. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211392 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: getting a total from some CFOUTPUTted fields
cfset Total = 0 cfoutput query=MyQuery cfset Total = Total + order_value cfif CurrentRow eq RecordCount #Total# /cfif /cfoutput Of course you can add in whatever tabling/formatting you need HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Noob: getting a total from some CFOUTPUTted fields
Whoops. Thanks for catching that, Ian. I always wrap blocks of display code in CFOUTPUT (and use CFLOOP for loops), so I never use inline CFOUTPUT tags. cheers, barneyb On 7/7/05, Ian Skinner [EMAIL PROTECTED] wrote: Just incase the noobie misses the mistake. cfset total = 0 / cfoutput ... cfset total = total + order_value / ... /cfoutput . TOTAL cfoutput#total#/cfoutput cheers, barneyb We still need those variables to be inside cfoutput sets, don't we. :-) -- Ian Skinner -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Noob: getting a total from some CFOUTPUTted fields
:) thanks guys! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
URL String and cfsavecontent
How can i pull a url string into a cfsavecontent. below is an example: Sample URL String: http://www.test.com?myurlvar=testing Sample CFML Code: cfsavecontent variable=testing var myvar = _root.MyUrlVar; /cfsavecontent I receive no errors when testing. MyVar comes back to me as undefined. The code is simplified to match my real problem. Thanks, mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211396 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL String and cfsavecontent
Michael... To be honest, your code makes no sense at all... try this: http://www.test.com?myurlvar=testing cfsavecontent variable=testing cfset myvar = url.myUrlVar /cfsavecontent cfoutput#testing#/cfoutput First off, you only have a string inside the savecontent... which means that you're not going to execute the code. CFSAVECONTENT actually executes the code inside it and puts the output buffer into the variable named in the variable attribute. Also, I've got no idea where _root. comes from, but you have no connection to the URL scope in the code example. You can only use the var keyword inside a CFFUNCTION tag, and if that's the case you should be passing the URL scope (or any struct for that matter) into the function instead of accessing it directly. If you want your code to work as written, you'll have to wrap your set operation in a CFSCRIPT tag. Hope that helps, J On 7/7/05, Michael Hohnecker [EMAIL PROTECTED] wrote: How can i pull a url string into a cfsavecontent. below is an example: Sample URL String: http://www.test.com?myurlvar=testing Sample CFML Code: cfsavecontent variable=testing var myvar = _root.MyUrlVar; /cfsavecontent I receive no errors when testing. MyVar comes back to me as undefined. The code is simplified to match my real problem. Thanks, mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211397 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL String and cfsavecontent
cfset testing = url.myurlvar / perhaps? I'm not really sure what you're asking. Maybe this: cfset myvar = url.myurlvar / Your code will put the string var myvar = _root.myurlvar; into the variable testing, along with some leading and trailing whitespace. No other variables will be set or accessed (including your URL variable; it's totally unused). cheers, barneyb On 7/7/05, Michael Hohnecker [EMAIL PROTECTED] wrote: How can i pull a url string into a cfsavecontent. below is an example: Sample URL String: http://www.test.com?myurlvar=testing Sample CFML Code: cfsavecontent variable=testing var myvar = _root.MyUrlVar; /cfsavecontent I receive no errors when testing. MyVar comes back to me as undefined. The code is simplified to match my real problem. Thanks, mike -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL String and cfsavecontent
Hold the phone... bah. cfsavecontent varible=testing cfoutput#url.myUrlVariable#/cfoutput /cfsavecontent Much better... it will only save the text stored in the output buffer once the savecontent tag is done executing. So if you haven't output anything, you won't have anything inside the variable. Sorry for the confusion... J On 7/7/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Michael... To be honest, your code makes no sense at all... try this: http://www.test.com?myurlvar=testing cfsavecontent variable=testing cfset myvar = url.myUrlVar /cfsavecontent cfoutput#testing#/cfoutput First off, you only have a string inside the savecontent... which means that you're not going to execute the code. CFSAVECONTENT actually executes the code inside it and puts the output buffer into the variable named in the variable attribute. Also, I've got no idea where _root. comes from, but you have no connection to the URL scope in the code example. You can only use the var keyword inside a CFFUNCTION tag, and if that's the case you should be passing the URL scope (or any struct for that matter) into the function instead of accessing it directly. If you want your code to work as written, you'll have to wrap your set operation in a CFSCRIPT tag. Hope that helps, J On 7/7/05, Michael Hohnecker [EMAIL PROTECTED] wrote: How can i pull a url string into a cfsavecontent. below is an example: Sample URL String: http://www.test.com?myurlvar=testing Sample CFML Code: cfsavecontent variable=testing var myvar = _root.MyUrlVar; /cfsavecontent I receive no errors when testing. MyVar comes back to me as undefined. The code is simplified to match my real problem. Thanks, mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211399 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL String and cfsavecontent
Here is a better example of what i'm doing. I have an alert box in flash forms. I would like the getURL to run with the current URL string which looks like http://www.test.com?lid=4. Is this the proper way to bring in a URL string variable: var myvar = _root.lid; cfsavecontent variable=showApprovalAlert var myvar = _root.lid; var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { getUrl('Detail.cfm?task=1LID=' +myvar); } } //create the alert var myAlert = mx.controls.Alert.show(Are you sure you want to approve this request, Warning, mx.controls.Alert.YES | mx.controls.Alert.CANCEL, this, myClickHandler); /cfsavecontent cfform format=flash action=#cgi.SCRIPT_NAME# method=post name=Approve width=400 height=200 cfformgroup type=horizontal visible=yes enabled=yes cfinput type=button name=btnApproval label=test value=Approve Request onClick=#ShowApprovalAlert# cfinput type=button name=btnDecline label=test value=Decline Request /cfformgroup /cfform ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211400 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL String and cfsavecontent
A ha! That's a COMPLETELY different question, and I have no idea how to solve, since I don't use CF7 for anything. Any set of flash docs should give you the anwser though. You're form is just a movie, so it has the same access to the page it's embedded in's URL scope as a normal Flash IDE-created movie. cheers, barneyb On 7/7/05, Michael Hohnecker [EMAIL PROTECTED] wrote: Here is a better example of what i'm doing. I have an alert box in flash forms. I would like the getURL to run with the current URL string which looks like http://www.test.com?lid=4. Is this the proper way to bring in a URL string variable: var myvar = _root.lid; cfsavecontent variable=showApprovalAlert var myvar = _root.lid; var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { getUrl('Detail.cfm?task=1LID=' +myvar); } } //create the alert var myAlert = mx.controls.Alert.show(Are you sure you want to approve this request, Warning, mx.controls.Alert.YES | mx.controls.Alert.CANCEL, this, myClickHandler); /cfsavecontent cfform format=flash action=#cgi.SCRIPT_NAME# method=post name=Approve width=400 height=200 cfformgroup type=horizontal visible=yes enabled=yes cfinput type=button name=btnApproval label=test value=Approve Request onClick=#ShowApprovalAlert# cfinput type=button name=btnDecline label=test value=Decline Request /cfformgroup /cfform -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211401 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Including App.cfc in App.cfc
If I have an Application.cfc in the site root, and it contains an APPLICATION.DSN variable, and there's an admin folder with its own App.cfc, how would I include the root's APP.DSN inside the admin folder's app.cfc? When I used App.cfm I just included the root App.cfm. Thanks, Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211402 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Including App.cfc in App.cfc
-Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 10:44 PM To: CF-Talk Subject: Including App.cfc in App.cfc If I have an Application.cfc in the site root, and it contains an APPLICATION.DSN variable, and there's an admin folder with its own App.cfc, how would I include the root's APP.DSN inside the admin folder's app.cfc? When I used App.cfm I just included the root App.cfm. Well... it is just a CFC. Can't you just CFINVOKE the other Application.cfc methods in the child one? Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Including App.cfc in App.cfc
Just the one variable but not the rest of the template? I don't think you can do that. You could set up an apps_globals.cfm to hold all of your sitewide variables and include that in each Application.cfm. If you don't mind having access to the rest of your application scoped variables, you could also just give them the same application name in your cfapplication tag. You would need to be careful about overwriting the application variables then, and possibly naming something the same way. Tim -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 10:44 PM To: CF-Talk Subject: Including App.cfc in App.cfc If I have an Application.cfc in the site root, and it contains an APPLICATION.DSN variable, and there's an admin folder with its own App.cfc, how would I include the root's APP.DSN inside the admin folder's app.cfc? When I used App.cfm I just included the root App.cfm. Thanks, Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211404 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Including App.cfc in App.cfc
have to read more carefully :) -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 10:47 PM To: CF-Talk Subject: RE: Including App.cfc in App.cfc -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 10:44 PM To: CF-Talk Subject: Including App.cfc in App.cfc If I have an Application.cfc in the site root, and it contains an APPLICATION.DSN variable, and there's an admin folder with its own App.cfc, how would I include the root's APP.DSN inside the admin folder's app.cfc? When I used App.cfm I just included the root App.cfm. Well... it is just a CFC. Can't you just CFINVOKE the other Application.cfc methods in the child one? Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211405 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54