RE: CFMail Grouping Question
Hi, this one is a corker, I might try to submit it to Rays cookbook if it's not there. (If someone hadn't told you by now) you can group with the CFMAIL tag itself. It's a beautiful thing. So you can group by recipient etc. It's best to think cfmail is cfoutput. The ability to output query data back into the cfmail tag is a bit abnormal. The example below *should* run. Cheers. cfset qryExample = querynew(email,data) cfset queryaddrow(qryExample) cfset querysetcell(qryExample,email,[EMAIL PROTECTED]) cfset querysetcell(qryExample,data,record 1) cfset queryaddrow(qryExample) cfset querysetcell(qryExample,email,[EMAIL PROTECTED]) cfset querysetcell(qryExample,data,record 2) cfset queryaddrow(qryExample) cfset querysetcell(qryExample,email,[EMAIL PROTECTED]) cfset querysetcell(qryExample,data,record 3) cfmail query=qryExample group=email to=#email# from=[EMAIL PROTECTED] subject=Your data type=html Your records...br / cfoutput #data#br / /cfoutput /cfmail mail sent -Original Message- From: Brian Polackoff [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 February 2006 8:23 AM To: CF-Talk Subject: RE: CFMail Grouping Question Thanks for the ideas, the cfsavecontent worked perfectly. Brian -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 4:02 PM To: CF-Talk Subject: RE: CFMail Grouping Question If anything-- you could run that code ahead of the cfmail in a cfsavecontent tag, and then just output the results into the E-mail. ~Brad -Original Message- From: Brian Polackoff [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 2:33 PM To: CF-Talk Subject: CFMail Grouping Question Can anyone tell a lost programmer how to group with CFMAIL so that a recordset with 100 records, grouped into 10 groups gets included into a singe email, not 10 emails ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231629 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: detecting delivered email addresses...
Was wondering if there was a way to send the email from our server say using Perl or some other language to run a telnet session and retrive SMTP return codes. This would then be passed onto CF possible? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231630 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
socket connections from CF to SMTP
Was wanting to confirm the existance of an email address at a particular server and my co-worker has mentioned doing this in the past with PHP. Apparetly what needs to happen is to create a socket connection from Coldfusion to the SMTP server. Then checking MX records. Is this possible? Can someone point me in the right direction? Cheers. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231631 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: socket connections from CF to SMTP
an MX record won't tell you if an email address exists...there is a DNS record called an MBX record but it's seldom used these days - something left over from the dark ages of DNS what about sending a message to the address and then checking the undelivered folder for any bounces? john On 08/02/06, Protoculture [EMAIL PROTECTED] wrote: Was wanting to confirm the existance of an email address at a particular server and my co-worker has mentioned doing this in the past with PHP. Apparetly what needs to happen is to create a socket connection from Coldfusion to the SMTP server. Then checking MX records. Is this possible? Can someone point me in the right direction? Cheers. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231632 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: socket connections from CF to SMTP
Not a bad idea John. Which undelivered folder though... CF or SMTP? what about sending a message to the address and then checking the undelivered folder for any bounces? john On 08/02/06, Protoculture [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231633 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: socket connections from CF to SMTP
cf...c:\cfusionmx7\mail\undeliv you mght want to take a look at Ray's (ray.camdenfamily.com) SpoolMail plugin he's written for the CF Administrator to get some ideas on parsing the folder for starters. It gives you a webmail type interface for the undeliverable folder so you can read what's in there and respool if neccessary jb On 08/02/06, Protoculture [EMAIL PROTECTED] wrote: Not a bad idea John. Which undelivered folder though... CF or SMTP? what about sending a message to the address and then checking the undelivered folder for any bounces? john On 08/02/06, Protoculture [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231634 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
Purging Session Variables
Hi. I want to kill the session, without having to do cfset session.xyz = for each session variable. My application checks for the existence of a session variable, so I don't want session.xyz to exist at all, even with no value. Any ideas please. Thanks, Ken ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231635 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: Purging Session Variables
quickest, easiest, down-and-dirty would be cfset structClear(session) / On 2/8/06, Ken [EMAIL PROTECTED] wrote: Hi. I want to kill the session, without having to do cfset session.xyz = for each session variable. My application checks for the existence of a session variable, so I don't want session.xyz to exist at all, even with no value. Any ideas please. Thanks, Ken ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231636 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: Purging Session Variables
StructDelete(SESSION, xyz) Ade -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: 08 February 2006 14:43 To: CF-Talk Subject: Purging Session Variables Hi. I want to kill the session, without having to do cfset session.xyz = for each session variable. My application checks for the existence of a session variable, so I don't want session.xyz to exist at all, even with no value. Any ideas please. Thanks, Ken ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231637 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: Purging Session Variables
StructDelete() ? Ken wrote: Hi. I want to kill the session, without having to do cfset session.xyz = for each session variable. My application checks for the existence of a session variable, so I don't want session.xyz to exist at all, even with no value. Any ideas please. Thanks, Ken ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231638 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
MySQL Migration and Funky Characters
I am trying to move a client's site to a new host. Their current host is running MySQL 3.23.44 on Linux (with CF5). I am moving to a host running MySQL 4.1.12 on Windows (with CFMX 7). Both databases are using Latin1. I am able to export the structure and data successfully via MySQL Front. Unfortunately, I am getting lots of messed up characters (showing up as boxes). I tried using a .sql file for the transfer with the same result. Does anyone have any ideas? Thanks! Steve Bryant Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231639 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: Purging Session Variables
On 2/8/06, Charlie Griefer [EMAIL PROTECTED] wrote: quickest, easiest, down-and-dirty would be cfset structClear(session) / The one issue with that solution is that you would also be blowing away the keys that actually track your session, SESSIONID and URLTOKEN. Maybe it doesn't matter in this case, but it's also something to keep in mind, as it may have unintended consequences. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231640 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: cross server locking
So exactly how would I use something like this? I started with saying server locking, but the best thing would be... cfquery name=myqry datasource=mydsn Select top 1000 * from emailQueue with (updlock) where isSent=0 /cfquery and for that query to return different things on different servers. Basically, I guess what I'm looking for is select top 1000 * from emailQueue where isSent=0 and ROW IS NOT LOCKED. Is this possible in ms sql server? Russ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 6:32 PM To: CF-Talk Subject: Re: cross server locking Russ wrote: Is this available in SQL Server 2000? Looking at the docs, it doesn't look like it is. It is, but why would MS use the same syntax as everybody else when they can do it their own way and lock users deeper into their propietary syntax? SELECT ... FROM ... WITH (updlock | rowlock) WHERE ... Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231641 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: Purging Session Variables
What about purging all sessions, not just the current session or at least getting a count of sessions somehow... Is that even possible? -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:53 AM To: CF-Talk Subject: Re: Purging Session Variables On 2/8/06, Charlie Griefer [EMAIL PROTECTED] wrote: quickest, easiest, down-and-dirty would be cfset structClear(session) / The one issue with that solution is that you would also be blowing away the keys that actually track your session, SESSIONID and URLTOKEN. Maybe it doesn't matter in this case, but it's also something to keep in mind, as it may have unintended consequences. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231642 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: Purging Session Variables
On 2/8/06, Dave Carabetta [EMAIL PROTECTED] wrote: On 2/8/06, Charlie Griefer [EMAIL PROTECTED] wrote: quickest, easiest, down-and-dirty would be cfset structClear(session) / The one issue with that solution is that you would also be blowing away the keys that actually track your session, SESSIONID and URLTOKEN. Maybe it doesn't matter in this case, but it's also something to keep in mind, as it may have unintended consequences. True...and you're right that it is worth mentioning. I should have thrown it in as a caveat. Guess I didn't since the original message was kill the session, i didn't think it would be an issue in this specific instance (but yah, still worth mentioning) :) -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231643 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
Flash forms and clipping
I have created an advanced search interface for the application that I'm working on using CFFORM and Flash forms. It allows me to efficiently organize and present a number of search options to users while making optimal use of space. The problem that I'm running into is that CFSELECT and CF date input fields are being clipped when they hit the outer boundary of the Flash form. Screenshot here http://www.ruckelshaus.com/dropbox/clipped_flash_form.gif Of course, I could eliminate the clipping by increasing the height of the form, but I really don't want to do that since my goal is to keep the dimensions of the form to an absolute minimum so that the search interface doesn't take over the page. Is there any other way to reduce or eliminate this problem? Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231644 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
Good way to dump java object?
Hi I'm looking for a good way to dump the public properties of a java object, but it should include values available from getX() methods, not just public field members (which I don't ever have). It could be a java solution or a cf custom tag (of cfc). If someone has a head-start on a custom tag that uses java reflection, I'll pick that up and run with it. Thanks Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231645 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: MySQL Migration and Funky Characters
Steve Bryant wrote: moving to a host running MySQL 4.1.12 on Windows (with CFMX 7). Both databases are using Latin1. apparently not. I am able to export the structure and data successfully via MySQL Front. Unfortunately, I am getting lots of messed up characters (showing up as boxes). boxes indicate that the browser is unable to render that character, question marks (??) indicate garbaged data. i would guess these chars were out of the windows codepage (windows-1252) which is a superset of latin-1 (iso-8859-1) maybe copy/pasted from word. i suppose you could either clean-up those chars or change the db's encoding to windows-1252 or utf-8. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231646 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: Purging Session Variables
Hi. I want to kill the session, without having to do cfset session.xyz = for each session variable. My application checks for the existence of a session variable, so I don't want session.xyz to exist at all, even with no value. Any ideas please. Thanks, Ken While others have suggested using structClear(session) etc., that does have some problems with the built in session variables (sessionid, cfid, cftoken, jsessionid, and urltoken). However there's a small UDF at CFLib.org that will clear out all session variables except the built in ones. You can download it at http://www.cflib.org/udf.cfm?ID=1097. hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231647 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: Looping over dynamic checkboxes
Thanks for that suggestion, Bobby. I'm still missing something, and I think I've taken a step back. The following code only gives me one checked checkbox when first editing the form and no checked checkboxes during the error checking: cfloop query=getCheckboxes cfset local.currentCheckboxID = getCheckboxes.checkboxID / input name=checkboxList type=checkbox value=#getCheckboxes.checkboxID# cfloop query=queryUser cfparam name=form.checkboxList default=#queryUser.checkboxID# / cfif local.currentCheckboxID EQ form.checkboxList checked /cfif /cfloop /cfloop Something is eluding me. Any other help? Cameron Use the same loop to declare cfparams for your form fields using the query results as the default Then in all of your form fields, use the form scope for the values When the user first hits the form, the query populates the form scope. When the user submits, THEIR information overrides the cfparams and stays in the form scope Works every time :-) (not to mention... it will get rid of all those cfif statements ;-) .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231648 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: cftry and cfcatch
I'm guessing here but I think your two queries are using stored procedures. So, use cfstoredproc to check the return values. Then, your first issue will be resolved. Then use nested cftry and cfcatch for each stored proc to resolve the second issue. So probably something like this: cftry !--- Set the variable for your second issue here. --- cfset notRunQuery = 0 cfset problemQueryNumber = 0 cftry cfstoredproc name=checksrv datasource=master returnCode=YES result=storedProc1Return SELECT @@SERVICENAME; /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 1 cfthrow type = yourOwnError /cfcatch /cftry cftry cfstoredproc name=checkage datasource=master returnCode=YES result=storedProc2Return SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 2 !--- Throw your own error for the outermost cfcatch to catch --- cfthrow type = yourOwnError /cfcatch /cftry cfcatch type =yourOwnError cfif notRunQuery is 2 !--- Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. --- cfelseif notRunQuery is 1 cfif problemQueryNumber = 1 !--- Send MSSQLSERVER Not Avail in cfmail. --- cfelseif problemQueryNumber = 2 !--- Send Agent Not Avail in cfmail. --- /cfif /cfif /cfcatch /cftry !--- Check the errors(return values) with from two stored procedures. Do CFMail here by checking two return structs (storedProc1Return and storedProc2Return) --- HTH, Pine -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 6:00 PM To: CF-Talk Subject: cftry and cfcatch I have two queries: cfquery name=checksrv datasource=master SELECT @@SERVICENAME; /cfquery cfquery name=checkage datasource=master SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfquery I want to be notified through cfmail if 1) query checksrv doesn't return MSSQLSERVER then, MSSQLSERVER not returned in cfmail or query checkage doesn't return 2 then, Agent not returned 2 in cfmail or both of checksrv and checkage don't return then, MSSQLSERVER not returned and Agent not returned 2 in cfmail or 2) query checksrv cannot be run then, MSSQLSERVER Not Avail in cfmail or query checkage cannot be run then, Agent Not Avail in cfmail or both of checksrv and checkage cannot be run then, MSSQLSERVER Not Avail and Agent Not Avail in cfmail. Any ideas? tia, jl ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231649 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: socket connections from CF to SMTP
Was wanting to confirm the existance of an email address at a particular server and my co-worker has mentioned doing this in the past with PHP. Apparetly what needs to happen is to create a socket connection from Coldfusion to the SMTP server. Then checking MX records. The way to do this, according to the SMTP specification, is to send a VRFY request. This came up on the list yesterday, if I recall correctly. However, many mail servers either disregard VRFY or send back a status code that doesn't indicate whether the email address exists. So, the only way you can really confirm the existence of an email address is to send a message to it, and receive a response. MX records have nothing to do with this, by the way. You use MX records to find the mail server in the first place. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231650 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: MySQL Migration and Funky Characters
I think you are exactly correct that the client copied and pasted from Word (I begged them not to, but what can you do?). I have a request in to the new host now to have them change the character set. Thanks for your help, Steve boxes indicate that the browser is unable to render that character, question marks (??) indicate garbaged data. i would guess these chars were out of the windows codepage (windows-1252) which is a superset of latin-1 (iso-8859-1) maybe copy/pasted from word. i suppose you could either clean-up those chars or change the db's encoding to windows-1252 or utf-8. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231651 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
pre-newbie questions
Hi, (Potentially easy/stupid questions ahead. Please don't shoot the newbie!) I'm a CF pre-newbie. We're trying to get enough information to decide if we're going to run CF and if so, what license we need. We're a very small shop with some odd idiosyncrasies. We have one server guy, who's really a desktop guy who get drafted into supporting servers too and one developer (me) who's only done web programming in ASP (though I've dabbled a little in Java for a class I took). We've made the decision to migrate away from ASP because we're concerned about future support and we want to have time to ramp up into the new language. The two that are really on the table are J2EE and CF. Now for the idiosyncratic part. Our parent organization is ICI. Within ICI there are several groups that operate pretty much independently (often with their own funding sources) although we all share server resources. (We have 1 production server, which is very under utilized, and 1 test server, that we just upgraded.) One of the groups has decided to go with J2EE for future development. Another is looking at CF, largely because of the (perceived?) long ramp up time for J2EE with the thought of possibly using it as a migration tool to go to J2EE in the future. We've been trying to find answers to our questions, but we've had limited success. This could have a lot to do with not knowing enough to know what questions to ask or how to ask them. So I'm looking for some general information, google phrases to search on, links, or anything else that can get us going on the right track. 1. How well will CF perform on IIS? How much better/worse is Apache/Tomcat? 2. Will CF cause performance or other problems for other applications (existing, projected, and/or possible applications in the next 5 yrs) on the same server? (J2EE and legacy ASP) 3. How much time will it take to learn/administer CF on the server? 4. How long does it take to ramp up to programming in CF 5. Macromedia's website says that you need the enterprise license to Create hybrid applications that combine ColdFusion pages with back-end logic written in Java by leveraging the award-winning Macromedia J2EE-compliant application server. Is that what we would be doing if we wanted to migrate the site to J2EE, use (user developed) Java classes in the CF site? What does this really mean? 6. Macromedia's site also says the enterprise license gives you Use ColdFusion with other enterprise-class systems and databases, and deploy ColdFusion applications as standard J2EE EAR/WAR files on leading J2EE application servers such as WebSphere or WebLogic. Applications can optionally be packaged with only compiled Java bytecode to help protect intellectual property. Does that mean that if we want to run J2EE on the same machine that we need the enterprise license? And if there are any J2EE people hanging out 7. How much time will it take to learn/administer J2EE on the server? 8. How long does it take to ramp up to programming in J2EE? 9 How well will J2EE perform on IIS? How much better/worse is Apache/Tomcat? I realize there are a lot of questions here but if anyone can give us some help we would really appreciate it. Thanks much Joelle Tegwen ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231652 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: MySQL Migration and Funky Characters
There is a custom tag at the Adobe web site in the Developer's Exchange called CF_StripASCII that will strip out and replace funky high-ASCII M$Word characters from a block of text. It has proven to be immensely helpful to me in the past when dropping text from a textfield into a DB. I don't have a link, but just do a search for it on the Adobe site, and it should pop right up. Ray Steve Bryant wrote: I think you are exactly correct that the client copied and pasted from Word (I begged them not to, but what can you do?). I have a request in to the new host now to have them change the character set. Thanks for your help, Steve boxes indicate that the browser is unable to render that character, question marks (??) indicate garbaged data. i would guess these chars were out of the windows codepage (windows-1252) which is a superset of latin-1 (iso-8859-1) maybe copy/pasted from word. i suppose you could either clean-up those chars or change the db's encoding to windows-1252 or utf-8. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231653 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: Log analyzer software.
Does SmarterStats make it easy to track pages based on URL variables? Like many sites, our whole site is based on: index.cfm?id=1234 article.cfm?id=5678 conference.cfm?id=91011 And, to further complicate, the same item can be called from different directories: /about/article.cfm?id=5678 /resources/article.cfm?id=5678 Cameron Thanks to all that have helped. Looks like SmarterStats is a go. :) Also, from what I hear, their mail software, SmarterMail is pretty good as well. Thanks, Che. -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 8:48 PM To: CF-Talk Subject: RE: Log analyzer software. I'd like some recommendations on web log analyzer software. I'm a little late on the discussion, so apologies if someone has already mentioned this. I personally prefer SmarterStats. It has a clean interface, scales well, and supports auto-login from client site admin consoles and such. It's easy to create sites, and then let the user see whatever reports they want. It will even remove the log files after a specified period of time to keep your drive from filling up. All around a great product with a great price tag compared to some of the others out there. http://www.smarterstats.com/ -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231654 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: MySQL Migration and Funky Characters
Ray Champagne wrote: There is a custom tag at the Adobe web site in the Developer's Exchange called CF_StripASCII that will strip out and replace funky high-ASCII ASCII iso-8859-1, i would be careful running that thing. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231655 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: Log analyzer software.
Great question? Would anyone care to chime in on this? ~Che -Original Message- From: Cameron Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 11:22 AM To: CF-Talk Subject: Re: Log analyzer software. Does SmarterStats make it easy to track pages based on URL variables? Like many sites, our whole site is based on: index.cfm?id=1234 article.cfm?id=5678 conference.cfm?id=91011 And, to further complicate, the same item can be called from different directories: /about/article.cfm?id=5678 /resources/article.cfm?id=5678 Cameron Thanks to all that have helped. Looks like SmarterStats is a go. :) Also, from what I hear, their mail software, SmarterMail is pretty good as well. Thanks, Che. -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 8:48 PM To: CF-Talk Subject: RE: Log analyzer software. I'd like some recommendations on web log analyzer software. I'm a little late on the discussion, so apologies if someone has already mentioned this. I personally prefer SmarterStats. It has a clean interface, scales well, and supports auto-login from client site admin consoles and such. It's easy to create sites, and then let the user see whatever reports they want. It will even remove the log files after a specified period of time to keep your drive from filling up. All around a great product with a great price tag compared to some of the others out there. http://www.smarterstats.com/ -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231656 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: MySQL Migration and Funky Characters
Sry, I've not been following along - just saw the Word pasting thing and thought I'd throw that in there. I'll preface it next time with YMMV. :) Paul Hastings wrote: Ray Champagne wrote: There is a custom tag at the Adobe web site in the Developer's Exchange called CF_StripASCII that will strip out and replace funky high-ASCII ASCII iso-8859-1, i would be careful running that thing. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231657 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: cftry and cfcatch
I was in a hurry when I typed the previous response and found a glitch in the logic. In the inner cfcatch blocks, I am throwing the errors. So, whenever there is a problem, the yourOwnError exception will be thrown. That means you will never see Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. To resolve that, at the top of my head, just remove the cfthrow tags in the cfcatch blocks. Handle it outside the cftry and cfcatch. I don't think you would even need to nest the cftry anymore. So, the revised version will be like this: !--- Set the variable for your second issue here. --- cfset notRunQuery = 0 cfset problemQueryNumber = 0 cftry cfstoredproc name=checksrv datasource=master returnCode=YES result=storedProc1Return SELECT @@SERVICENAME; /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 1 /cfcatch /cftry cftry cfstoredproc name=checkage datasource=master returnCode=YES result=storedProc2Return SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 2 /cfcatch /cftry cfif notRunQuery is 2 !--- Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. --- cfelseif notRunQuery is 1 cfif problemQueryNumber = 1 !--- Send MSSQLSERVER Not Avail in cfmail. --- cfelseif problemQueryNumber = 2 !--- Send Agent Not Avail in cfmail. --- /cfif /cfif !--- Check the errors(return values) with from two stored procedures. Do CFMail here by checking two return structs (storedProc1Return and storedProc2Return) --- -Original Message- From: PINE Phyo Z Sent: Wednesday, February 08, 2006 8:53 AM To: 'cf-talk@houseoffusion.com' Subject: RE: cftry and cfcatch I'm guessing here but I think your two queries are using stored procedures. So, use cfstoredproc to check the return values. Then, your first issue will be resolved. Then use nested cftry and cfcatch for each stored proc to resolve the second issue. So probably something like this: cftry !--- Set the variable for your second issue here. --- cfset notRunQuery = 0 cfset problemQueryNumber = 0 cftry cfstoredproc name=checksrv datasource=master returnCode=YES result=storedProc1Return SELECT @@SERVICENAME; /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 1 cfthrow type = yourOwnError /cfcatch /cftry cftry cfstoredproc name=checkage datasource=master returnCode=YES result=storedProc2Return SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 2 !--- Throw your own error for the outermost cfcatch to catch --- cfthrow type = yourOwnError /cfcatch /cftry cfcatch type =yourOwnError cfif notRunQuery is 2 !--- Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. --- cfelseif notRunQuery is 1 cfif problemQueryNumber = 1 !--- Send MSSQLSERVER Not Avail in cfmail. --- cfelseif problemQueryNumber = 2 !--- Send Agent Not Avail in cfmail. --- /cfif /cfif /cfcatch /cftry !--- Check the errors(return values) with from two stored procedures. Do CFMail here by checking two return structs (storedProc1Return and storedProc2Return) --- HTH, Pine -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 6:00 PM To: CF-Talk Subject: cftry and cfcatch I have two queries: cfquery name=checksrv datasource=master SELECT @@SERVICENAME; /cfquery cfquery name=checkage datasource=master SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfquery I want to be notified through cfmail if 1) query checksrv doesn't return MSSQLSERVER then, MSSQLSERVER not returned in cfmail or query checkage doesn't return 2 then, Agent not returned 2 in cfmail or both of checksrv and
Cftry doesn't catch COM Errors
I have a cftry block wrapped around a cfscript that creates a COM object and tries to talk to another server. When it can't, it throws an error rather than following what I want to happen in the cftry block around it. Anyone know a good way to handle this error? Thanks! Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: www.ejhassociates.com tel: 651.207.1526 fax: 651.207.1536 mob: 651.245.2717 This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231659 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: pre-newbie questions
Now for the idiosyncratic part. Our parent organization is ICI. Out of curiosity, what's ICI? I've done some CF work with an organization called ICI, but I'm not sure if it's the same one. 1. How well will CF perform on IIS? CF will perform well enough on IIS. How much better/worse is Apache/Tomcat? This is kind of an apples-oranges question - the two aren't really comparable. CFMX, by default, includes a J2EE server called JRun. You can use CFMX/JRun with IIS or Apache. You could also install CFMX onto Tomcat, and use that with IIS or Apache. My luck with using Tomcat with IIS hasn't been very good, though. CFMX Standard includes just enough of JRun to run CF, and can't be installed on another J2EE app server. CFMX Enterprise includes a full version of JRun, and can also be installed on any standard J2EE app server. 2. Will CF cause performance or other problems for other applications (existing, projected, and/or possible applications in the next 5 yrs) on the same server? (J2EE and legacy ASP) Running multiple application servers will generally cause some degree of resource contention. That said, there's nothing special about CFMX, and you can run it on the same machine as other J2EE servers, ASP and ASP.NET applications, etc. 3. How much time will it take to learn/administer CF on the server? CF itself is pretty simple to administer. The underlying J2EE server functionality is quite a bit more complicated. If you plan on supporting high volume applications, you'll probably need to learn a decent amount about JVM tuning. Of course, this would also be true for plain ol' J2EE applications. 4. How long does it take to ramp up to programming in CF It takes significantly less time to learn CFML than any other web programming language I've ever seen. It's very friendly for inexperienced developers, and even non-programmers. That's its biggest selling point, in my opinion. CF applications are generally easier to build and easier to maintain. 5. Macromedia's website says that you need the enterprise license to Create hybrid applications that combine ColdFusion pages with back-end logic written in Java by leveraging the award-winning Macromedia J2EE-compliant application server. Is that what we would be doing if we wanted to migrate the site to J2EE, use (user developed) Java classes in the CF site? What does this really mean? J2EE applications typically consist of JSPs and servlets as well as simple Java classes. You need CFMX Enterprise to run JSPs and servlets. If you want to use other, J2EE-specific functionality you'd need CFMX Enterprise for that as well. 6. Macromedia's site also says the enterprise license gives you Use ColdFusion with other enterprise-class systems and databases, and deploy ColdFusion applications as standard J2EE EAR/WAR files on leading J2EE application servers such as WebSphere or WebLogic. Applications can optionally be packaged with only compiled Java bytecode to help protect intellectual property. Does that mean that if we want to run J2EE on the same machine that we need the enterprise license? No, not necessarily. However, you'd have to run your J2EE stuff in a separate server, and you wouldn't be able to build a single application that used both CFML and J2EE functionality. For example, with CFMX Enterprise, you could build a J2EE application that used servlets and beans, but used CFML pages instead of JSP. CFMX Enterprise buys you all sorts of other advantages, as well, such as the ability to deploy multiple instances. 8. How long does it take to ramp up to programming in J2EE? A lot longer than it would with CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231660 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: Cftry doesn't catch COM Errors
What type are you catching? Any or something else? It's been a while, but I think it works for me using a VB COM object I wrote. M!ke -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 11:48 AM To: CF-Talk Subject: Cftry doesn't catch COM Errors I have a cftry block wrapped around a cfscript that creates a COM object and tries to talk to another server. When it can't, it throws an error rather than following what I want to happen in the cftry block around it. Anyone know a good way to handle this error? Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231661 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: Coldfusion and Active Directory
Ian, sorry it took so long to reply. If you already figured this out, please ignore. ;-) You need to use the DN attribute of the CFLDAP tag to select a single AD object. You are not able to use the ATTRIBUTES attribute of the CFLDAP tag because you must use that attribute to set the new values. If you need to modify multiple objects, you will need to do an initial CFLDAP call to retrieve the DNs that need to be modified. Then, you would CFLOOP over that query and perform a CFLDAP for each loop. I don't know of any way to modify multiple objects using LDAP other than looping. M!ke -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:39 AM To: CF-Talk Subject: RE: Coldfusion and Active Directory That worked thanks !! Just one more small point, I need to create a web form that will allow certain users based on their permissions to update/modify the user information stored in the AD. In the ldap attributes of the modify what is the LDAP equivalent of the SQL Where clause ? I.E. If I wanted to update a users details how would the AD know which user record I would be referring to ? The sAMAccountName would be the unique field equivalent to a primary key in a database table cfldap username=#ldap_user# password=#ldap_password# action=modify server=#ldap_server modifyType=replace delimiter=; dn=CN=AD-SOME-GROUP;OU=Groups;OU=SOME;dc=ads;dc=somedomain;dc=com attributes= sAMAccountName=form.sAMAccountName, sn=form.sn,givenName=form.givenName ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231662 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: SOT: Credit Card Merchant questions.
I've used both payflow link and payflow pro in the past and they seem to work great for me. Setup is fairly easy, once you've read everything and have a handle on how it works. The first time didn't go 1, 2, 3 for me, but by the time I set it up the second and third time it was a breeze. Email me if you need any help with one of these. On 1/31/06, John C. Bland II [EMAIL PROTECTED] wrote: Nah, I used them the last go-round and didn't like it. It is excellent when using it inside of QuickBooks (very convenient) but I never ventured into using the web interface because the site sucks which doesn't give me much faith in the abilities. That's just a personal issue I have with sites. To sum it up, my gripe was I was tied to QuickBooks. On 1/31/06, Tim Laureska [EMAIL PROTECTED] wrote: Anybody had any experience with a quickbooks merchant account ? ... I understand their discount rate is pretty low -Original Message- From: John C. Bland II [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 31, 2006 7:17 PM To: CF-Talk Subject: Re: SOT: Credit Card Merchant questions. Payflow, in my opinion, is grossly overpriced. Authorize.net is perfect for many situations but as discovered in another thread you can manipulate the recurring billing via code. Both are easily done with CF. On 1/31/06, J W [EMAIL PROTECTED] wrote: Whats everyones favorite preferred Gateway, like Payflow pro or authorize.net? What the most Cold Fusion Friendly? Does anyone have any good merchant account reccomendations as well? Thanks. Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231663 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: pre-newbie questions
I'll answer some I feel qualified to answer. 1. How well will CF perform on IIS? How much better/worse is Apache/Tomcat? We currently only use IIS and performance is fine, although apache is considered a lighter weight and more easily configured web server by many. CF integrates in a very simple way to to the web server - simply registering that .cfm pages should be passed to the CF server. 2. Will CF cause performance or other problems for other applications (existing, projected, and/or possible applications in the next 5 yrs) on the same server? (J2EE and legacy ASP) Well if you run more processes on a server they all use resources and have an effect on each other, but I don't know of any specific problems. 3. How much time will it take to learn/administer CF on the server? Half a day to a day will have you up and running - it is really very simple to learn the basics and more indepth stuff can wait until you need it. 4. How long does it take to ramp up to programming in CF For ASP programmers the switch will be very easy and you should get a positive reaction because CF is a very nice language to work with. You can grasp the basics in a few days, but beware of then creating spaggetti code. I would advise that you also take the time to adopt one the frameworks popular with CF (e.g. mach-ii, fusebox, model-glue) and these will push you to structure the code nicely from day one. This investment will pay back 100 fold in saved maintenance costs. HTH Mike T ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231664 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: Purging Session Variables
On 2/8/06, Russ [EMAIL PROTECTED] wrote: What about purging all sessions, not just the current session or at least getting a count of sessions somehow... Is that even possible? As an intended feature? No. And that's something I know Adobe has mentioned Scorpio (CF 8) will hopefully address. However, I think it was Ray Camden who posted this code a long time ago that I've kept around for getting the number of sessions on MX 6.1. I've not tried it on MX 7 yet, so YMMV. It involves getting under the hood of ColdFusion's runtime: function getSessions(appName) { var tracker = createObject(java, coldfusion.runtime.SessionTracker); return tracker.getSessionCollection(appName); } variables.numSessions = 0; variables.sessions = getSessions(application.applicationName); variables.numSessions = structCount(variables.sessions); cfoutputTotal Number of Sessions: #variables.numSessions#/cfoutput Hope this helps? Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231665 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
MySQL Blob issues
Hello all, I need to build a CF (using CF5) front end to a MySQL database. I am having issues trying to get the data from the Blob datatype fields. There are images, files(mostly MSword) and large blocks of text in the fields. My searches have not found much, mostly devleopers/coders disucsing the pros and cons of putting images/files in a database. I have found a few with PhP code for getting the images , but so far no way to do it with Coldfusion. Downloaded and installed Connector/ODBC 3.51.12 from mysql.com to make the OBDC connection. The database is MySQL 5. Any help on getting any of the three diffrent types of blobs, using Coldfusion would be appricated. Thanks Rodney ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231666 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: Purging Session Variables
I just ran this on my local machine, which nobody else can see and it's convinced that there are 5 sessions. Odd-that. I dumped all of the data out and there are 5 nearly identical sessions. Now I'm going to wait until tomorrow AM when there's been no activity on the machine all night long and I'll run that page first thing to see what it says. Very interesting... --Ferg Dave Carabetta wrote: On 2/8/06, Russ [EMAIL PROTECTED] wrote: What about purging all sessions, not just the current session or at least getting a count of sessions somehow... Is that even possible? As an intended feature? No. And that's something I know Adobe has mentioned Scorpio (CF 8) will hopefully address. However, I think it was Ray Camden who posted this code a long time ago that I've kept around for getting the number of sessions on MX 6.1. I've not tried it on MX 7 yet, so YMMV. It involves getting under the hood of ColdFusion's runtime: function getSessions(appName) { var tracker = createObject(java, coldfusion.runtime.SessionTracker); return tracker.getSessionCollection(appName); } variables.numSessions = 0; variables.sessions = getSessions(application.applicationName); variables.numSessions = structCount(variables.sessions); cfoutputTotal Number of Sessions: #variables.numSessions#/cfoutput Hope this helps? Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231667 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: pre-newbie questions
Macromedia's website says that you need the enterprise license to Create hybrid applications that combine ColdFusion pages with back-end logic written in Java by leveraging the award-winning Macromedia J2EE-compliant application server. Is that what we would be doing if we wanted to migrate the site to J2EE, use (user developed) Java classes in the CF site? What does this really mean? Take a look at Blue Dragon Serer JX (http://newatlanta.com). It is a CFML engine, just like ColdFusion, except it comes with a Java servlet and many other features that only come with ColdFusion Enterprise. It will cost you the same price as ColdFusion Standard if you also purchase support, which is a good idea. If you would like to leverage both CFML and J2EE, you should also look into Blue Dragon J2EE Server. For a single CPU license, it will cost the same as ColdFusion Standard, but you will have to get Tomcat or Websphere seperately. The unfortunate thing is that the current edition of Blue Dragon only supports ColdFusion 6 tags and functions. They are planning to release an upgrade which will support many of the CF 7 tags and functions, and that comes as part of the support package (which is why I highly suggest getting the support package). Just thought I would give you some more options. My company is looking into these two solutions as well. Thus far, we have setup BlueDragon Server JX on our live server and have began testing it out. -Aaron On 2/8/06, Dave Watts [EMAIL PROTECTED] wrote: Now for the idiosyncratic part. Our parent organization is ICI. Out of curiosity, what's ICI? I've done some CF work with an organization called ICI, but I'm not sure if it's the same one. 1. How well will CF perform on IIS? CF will perform well enough on IIS. How much better/worse is Apache/Tomcat? This is kind of an apples-oranges question - the two aren't really comparable. CFMX, by default, includes a J2EE server called JRun. You can use CFMX/JRun with IIS or Apache. You could also install CFMX onto Tomcat, and use that with IIS or Apache. My luck with using Tomcat with IIS hasn't been very good, though. CFMX Standard includes just enough of JRun to run CF, and can't be installed on another J2EE app server. CFMX Enterprise includes a full version of JRun, and can also be installed on any standard J2EE app server. 2. Will CF cause performance or other problems for other applications (existing, projected, and/or possible applications in the next 5 yrs) on the same server? (J2EE and legacy ASP) Running multiple application servers will generally cause some degree of resource contention. That said, there's nothing special about CFMX, and you can run it on the same machine as other J2EE servers, ASP and ASP.NET applications, etc. 3. How much time will it take to learn/administer CF on the server? CF itself is pretty simple to administer. The underlying J2EE server functionality is quite a bit more complicated. If you plan on supporting high volume applications, you'll probably need to learn a decent amount about JVM tuning. Of course, this would also be true for plain ol' J2EE applications. 4. How long does it take to ramp up to programming in CF It takes significantly less time to learn CFML than any other web programming language I've ever seen. It's very friendly for inexperienced developers, and even non-programmers. That's its biggest selling point, in my opinion. CF applications are generally easier to build and easier to maintain. 5. Macromedia's website says that you need the enterprise license to Create hybrid applications that combine ColdFusion pages with back-end logic written in Java by leveraging the award-winning Macromedia J2EE-compliant application server. Is that what we would be doing if we wanted to migrate the site to J2EE, use (user developed) Java classes in the CF site? What does this really mean? J2EE applications typically consist of JSPs and servlets as well as simple Java classes. You need CFMX Enterprise to run JSPs and servlets. If you want to use other, J2EE-specific functionality you'd need CFMX Enterprise for that as well. 6. Macromedia's site also says the enterprise license gives you Use ColdFusion with other enterprise-class systems and databases, and deploy ColdFusion applications as standard J2EE EAR/WAR files on leading J2EE application servers such as WebSphere or WebLogic. Applications can optionally be packaged with only compiled Java bytecode to help protect intellectual property. Does that mean that if we want to run J2EE on the same machine that we need the enterprise license? No, not necessarily. However, you'd have to run your J2EE stuff in a separate server, and you wouldn't be able to build a single application that used both CFML and J2EE functionality. For example, with CFMX Enterprise, you could build a J2EE application that used servlets and beans, but used CFML pages
RE: Purging Session Variables
Yea, I recently noticed that JRUN will create sessions even if you say you don't' want session variables in application.cfm. It will create just the basic session, but still kind of sucks, as you get one session for every hit without a cookie (such as search engines or loadbalancer,etc). Russ -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 2:29 PM To: CF-Talk Subject: Re: Purging Session Variables I just ran this on my local machine, which nobody else can see and it's convinced that there are 5 sessions. Odd-that. I dumped all of the data out and there are 5 nearly identical sessions. Now I'm going to wait until tomorrow AM when there's been no activity on the machine all night long and I'll run that page first thing to see what it says. Very interesting... --Ferg Dave Carabetta wrote: On 2/8/06, Russ [EMAIL PROTECTED] wrote: What about purging all sessions, not just the current session or at least getting a count of sessions somehow... Is that even possible? As an intended feature? No. And that's something I know Adobe has mentioned Scorpio (CF 8) will hopefully address. However, I think it was Ray Camden who posted this code a long time ago that I've kept around for getting the number of sessions on MX 6.1. I've not tried it on MX 7 yet, so YMMV. It involves getting under the hood of ColdFusion's runtime: function getSessions(appName) { var tracker = createObject(java, coldfusion.runtime.SessionTracker); return tracker.getSessionCollection(appName); } variables.numSessions = 0; variables.sessions = getSessions(application.applicationName); variables.numSessions = structCount(variables.sessions); cfoutputTotal Number of Sessions: #variables.numSessions#/cfoutput Hope this helps? Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231669 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: Good way to dump java object?
Gaulin, Mark wrote: Hi I'm looking for a good way to dump the public properties of a java object, but it should include values available from getX() methods, not just public field members (which I don't ever have). It could be a java solution or a cf custom tag (of cfc). If someone has a head-start on a custom tag that uses java reflection, I'll pick that up and run with it. this was a fun little challenge. Maybe this will help you. The following function accepts a java object as an argument, and dumps the value of every getXXX() method that requires no arguments. cffunction name=dumpJavaObject cfargument name=obj type=any required=yes cfset var methodname = cfset var classInfo = obj.getClass() !--- class object --- cfset var methods = classInfo.getMethods() cfset var I = 0 cfloop from=1 to=#ArrayLen(methods)# step=1 index=I cfset methodName = methods[i].getName() cfif refind(^get,methodName) gt 0 cfif arrayLen(methods[i].getParameterTypes()) is 0 cfoutputhr#methodName# = br/cfoutput cftry cfdump var=#evaluate(obj.#methodName#())# cfcatch type=any Unable to dump ##evaluate(obj.#methodName#())##br /cfcatch /cftry /cfif /cfif /cfloop /cffunction ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231670 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: Cftry doesn't catch COM Errors
I am using Anyso that's why I am confused. I thought that should grab any possible error in the enclosed process. But for some reason, when the com object times out reaching the other server, it errors out of the cfscript and doesn't handle it via the cftry. Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: www.ejhassociates.com tel: 651.207.1526 fax: 651.207.1536 mob: 651.245.2717 This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 11:56 AM To: CF-Talk Subject: RE: Cftry doesn't catch COM Errors What type are you catching? Any or something else? It's been a while, but I think it works for me using a VB COM object I wrote. M!ke -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 11:48 AM To: CF-Talk Subject: Cftry doesn't catch COM Errors I have a cftry block wrapped around a cfscript that creates a COM object and tries to talk to another server. When it can't, it throws an error rather than following what I want to happen in the cftry block around it. Anyone know a good way to handle this error? Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231671 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: Cftry doesn't catch COM Errors
-Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 3:42 PM To: CF-Talk Subject: RE: Cftry doesn't catch COM Errors I am using Anyso that's why I am confused. I thought that should grab any possible error in the enclosed process. But for some reason, when the com object times out reaching the other server, it errors out of the cfscript and doesn't handle it via the cftry. How do you know its timing out? Can you check for that and do a custom CFTHROW? Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231672 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: pre-newbie questions
Dave Watts wrote: Now for the idiosyncratic part. Our parent organization is ICI. Out of curiosity, what's ICI? I've done some CF work with an organization called ICI, but I'm not sure if it's the same one. ICI is the Institute for Community Integration. We're a non-academic department at the University of Minnesota. Thanks for the rest of your answers. I appreciate the depth! Joelle ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231673 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: Good way to dump java object?
Nice! I can see this opening new windows when the value of a getter is another java class. (Hmm.. Maybe I'll do that...) Q: Do you know how to test if an object is a java object from cf? IsObject() returns false (which makes sense), but I didn't see a proper way to test for that. Thanks for the help. Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 2:42 PM To: CF-Talk Subject: Re: Good way to dump java object? Gaulin, Mark wrote: Hi I'm looking for a good way to dump the public properties of a java object, but it should include values available from getX() methods, not just public field members (which I don't ever have). It could be a java solution or a cf custom tag (of cfc). If someone has a head-start on a custom tag that uses java reflection, I'll pick that up and run with it. this was a fun little challenge. Maybe this will help you. The following function accepts a java object as an argument, and dumps the value of every getXXX() method that requires no arguments. cffunction name=dumpJavaObject cfargument name=obj type=any required=yes cfset var methodname = cfset var classInfo = obj.getClass() !--- class object --- cfset var methods = classInfo.getMethods() cfset var I = 0 cfloop from=1 to=#ArrayLen(methods)# step=1 index=I cfset methodName = methods[i].getName() cfif refind(^get,methodName) gt 0 cfif arrayLen(methods[i].getParameterTypes()) is 0 cfoutputhr#methodName# = br/cfoutput cftry cfdump var=#evaluate(obj.#methodName#())# cfcatch type=any Unable to dump ##evaluate(obj.#methodName#())##br /cfcatch /cftry /cfif /cfif /cfloop /cffunction ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231674 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: Good way to dump java object?
This UDF might help you http://www.cflib.org/udf.cfm?ID=1076 Qasim On 2/8/06, Gaulin, Mark [EMAIL PROTECTED] wrote: Nice! I can see this opening new windows when the value of a getter is another java class. (Hmm.. Maybe I'll do that...) Q: Do you know how to test if an object is a java object from cf? IsObject() returns false (which makes sense), but I didn't see a proper way to test for that. Thanks for the help. Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 2:42 PM To: CF-Talk Subject: Re: Good way to dump java object? Gaulin, Mark wrote: Hi I'm looking for a good way to dump the public properties of a java object, but it should include values available from getX() methods, not just public field members (which I don't ever have). It could be a java solution or a cf custom tag (of cfc). If someone has a head-start on a custom tag that uses java reflection, I'll pick that up and run with it. this was a fun little challenge. Maybe this will help you. The following function accepts a java object as an argument, and dumps the value of every getXXX() method that requires no arguments. cffunction name=dumpJavaObject cfargument name=obj type=any required=yes cfset var methodname = cfset var classInfo = obj.getClass() !--- class object --- cfset var methods = classInfo.getMethods() cfset var I = 0 cfloop from=1 to=#ArrayLen(methods)# step=1 index=I cfset methodName = methods[i].getName() cfif refind(^get,methodName) gt 0 cfif arrayLen(methods[i].getParameterTypes()) is 0 cfoutputhr#methodName# = br/cfoutput cftry cfdump var=#evaluate(obj.#methodName#())# cfcatch type=any Unable to dump ##evaluate(obj.#methodName#())##br /cfcatch /cftry /cfif /cfif /cfloop /cffunction ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231675 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
Flash forms checkbox question
I have a flash form with checkboxes, I need the value of the check box to be 1 or 0, Flash forms return true or false. I know that the form scope is stored as a structure, so I should be able to reset all True values in the form structure to 1 and likewise with false. I'm not sure exactly how to go about this, does anyone have an example of something similar? Thanks, Daron Smith PSEA ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231676 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: cross server locking
Russ wrote: So exactly how would I use something like this? I started with saying server locking, but the best thing would be... cfquery name=myqry datasource=mydsn Select top 1000 * from emailQueue with (updlock) where isSent=0 /cfquery and for that query to return different things on different servers. Basically, I guess what I'm looking for is select top 1000 * from emailQueue where isSent=0 and ROW IS NOT LOCKED. I typically use something like: cfquery all SELECT pk FROM table WHERE finished = FALSE /cfquery cfloop all cftry cftransaction cfquery record SELECT * FROM table WHERE pk = #all.pk# AND finished = FALSE FOR UPDATE NOWAIT /cfquery do something (email, ftp, etc) cfquery UPDATE table SET finished = TRUE WHERE pk = #all.pk# /cfquery /cftransaction cfcatch type=db /cfcatch /cftry /cfloop Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231677 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: Good way to dump java object?
That is cool. Looks like java reflection is the way to go... Thanks Mark -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 4:38 PM To: CF-Talk Subject: Re: Good way to dump java object? This UDF might help you http://www.cflib.org/udf.cfm?ID=1076 Qasim On 2/8/06, Gaulin, Mark [EMAIL PROTECTED] wrote: Nice! I can see this opening new windows when the value of a getter is another java class. (Hmm.. Maybe I'll do that...) Q: Do you know how to test if an object is a java object from cf? IsObject() returns false (which makes sense), but I didn't see a proper way to test for that. Thanks for the help. Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 2:42 PM To: CF-Talk Subject: Re: Good way to dump java object? Gaulin, Mark wrote: Hi I'm looking for a good way to dump the public properties of a java object, but it should include values available from getX() methods, not just public field members (which I don't ever have). It could be a java solution or a cf custom tag (of cfc). If someone has a head-start on a custom tag that uses java reflection, I'll pick that up and run with it. this was a fun little challenge. Maybe this will help you. The following function accepts a java object as an argument, and dumps the value of every getXXX() method that requires no arguments. cffunction name=dumpJavaObject cfargument name=obj type=any required=yes cfset var methodname = cfset var classInfo = obj.getClass() !--- class object --- cfset var methods = classInfo.getMethods() cfset var I = 0 cfloop from=1 to=#ArrayLen(methods)# step=1 index=I cfset methodName = methods[i].getName() cfif refind(^get,methodName) gt 0 cfif arrayLen(methods[i].getParameterTypes()) is 0 cfoutputhr#methodName# = br/cfoutput cftry cfdump var=#evaluate(obj.#methodName#())# cfcatch type=any Unable to dump ##evaluate(obj.#methodName#())##br /cfcatch /cftry /cfif /cfif /cfloop /cffunction ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231678 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: cross server locking
Will there not be a race condition there? If 2 servers run the same code at the same time, wouldn't' they be working with the same set of records? I'm not really sure if and how FOR UPDATE NOWAIT solves that? Russ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 4:42 PM To: CF-Talk Subject: Re: cross server locking Russ wrote: So exactly how would I use something like this? I started with saying server locking, but the best thing would be... cfquery name=myqry datasource=mydsn Select top 1000 * from emailQueue with (updlock) where isSent=0 /cfquery and for that query to return different things on different servers. Basically, I guess what I'm looking for is select top 1000 * from emailQueue where isSent=0 and ROW IS NOT LOCKED. I typically use something like: cfquery all SELECT pk FROM table WHERE finished = FALSE /cfquery cfloop all cftry cftransaction cfquery record SELECT * FROM table WHERE pk = #all.pk# AND finished = FALSE FOR UPDATE NOWAIT /cfquery do something (email, ftp, etc) cfquery UPDATE table SET finished = TRUE WHERE pk = #all.pk# /cfquery /cftransaction cfcatch type=db /cfcatch /cftry /cfloop Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231679 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: cross server locking
Russ wrote: Will there not be a race condition there? If 2 servers run the same code at the same time, wouldn't' they be working with the same set of records? Initially in the big select they can both get the same set of primary keys, but inside the loop they can not get the same records. I'm not really sure if and how FOR UPDATE NOWAIT solves that? In the loop they wait for eachother because that select locks the record with the FOR UPDATE statement. The NOWAIT modifier is added so that the second select doesn't wait for the first one, but fails immediately. The failure is handled through the try/catch and the second thread moves on to the next record. Try it :) Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231680 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: cross server locking
Is there a way to simulate this? maybe run 2 templates and put some sleep code in between so I can see that it's not getting the same record twice? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 4:56 PM To: CF-Talk Subject: Re: cross server locking Russ wrote: Will there not be a race condition there? If 2 servers run the same code at the same time, wouldn't' they be working with the same set of records? Initially in the big select they can both get the same set of primary keys, but inside the loop they can not get the same records. I'm not really sure if and how FOR UPDATE NOWAIT solves that? In the loop they wait for eachother because that select locks the record with the FOR UPDATE statement. The NOWAIT modifier is added so that the second select doesn't wait for the first one, but fails immediately. The failure is handled through the try/catch and the second thread moves on to the next record. Try it :) Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231681 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
Returning information from Oracle update/insert statements to CF
Is this possible and easy to do? Get rows updated information from insert and update SQL statements? PS. For Michael: I originally sent this query by e-mail on Monday. It never showed up. For awhile now, any orginial message I send just disappears. I can reply, but new messages are a no go. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231682 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: cross server locking
Russ wrote: Is there a way to simulate this? maybe run 2 templates and put some sleep code in between so I can see that it's not getting the same record twice? The easiest way to simulate this is from a command line SQL client (Enterprise Manager will also work). In the first instance run: begin; select pk from table where pk = X for update; Then in the second instance run: begin; select pk from table where pk = X for update; You will see that the second instance will do nothing until you rollback or commit the first one. Then try again but this time with the nowait option (though I don't know if MS SQL Server has that option). Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231683 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: Flash forms checkbox question
Hey, I'm a PSEA member! Just got certified to teach English, planning ahead for the day when nobody will hire me as a developer anymore... What about creating a UDF that converts a true/false to a 1/0? What are you doing, inserting the data into a database as individual values, or are you doing something else with the structure? Pete On 2/8/06, Smith, Daron [PA] [EMAIL PROTECTED] wrote: I have a flash form with checkboxes, I need the value of the check box to be 1 or 0, Flash forms return true or false. I know that the form scope is stored as a structure, so I should be able to reset all True values in the form structure to 1 and likewise with false. I'm not sure exactly how to go about this, does anyone have an example of something similar? Thanks, Daron Smith PSEA ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231684 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: Cftry doesn't catch COM Errors
I am using Anyso that's why I am confused. I thought that should grab any possible error in the enclosed process. But for some reason, when the com object times out reaching the other server, it errors out of the cfscript and doesn't handle it via the cftry. This is a bit of a shot in the dark, but try using CFCATCH without a TYPE attribute at all, and see if that works. I've seen occasional cases where CFCATCH with TYPE=Any doesn't catch something, but CFCATCH with no TYPE does. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231685 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: Gmail thinks cf-talk is spam (since January 11th)?
For those who are wondering where their list-email is going: It seems SpamAssassin 3.1 is tagging some mail from HoF as spam because of the way headers are handled. The x-mailer, mimeole and outlook headers are stripped from messages. But because Outlook uses a special algorithm to generate messageids, SpamAssassin recognizes the messageid as originating from Outlook. That means that the following tests in SpamAssassin are triggered: MSGID_DOLLARS: (__OUTLOOK_DOLLARS_MSGID !__HAS_OUTLOOK_IN_MAILER !__UNUSABLE_MSGID) RATWARE_MS_HASH (__MSGID_DOLLARS_OK !__HAS_X_MAILER) RATWARE_OUTLOOK_NONAME (__MSGID_DOLLARS_OK !__MIMEOLE_MS) In parenthesis are the macro expansions of these tests which are pretty self-explaining. This is even submitted as a SpamAssassin bug http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4678 Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231686 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: Returning information from Oracle update/insert statements to CF
I have never seen a way you could do this and it work in a cfquery. Could do it through an SP, what information is it that you want returned? On 2/8/06, Ian Skinner [EMAIL PROTECTED] wrote: Is this possible and easy to do? Get rows updated information from insert and update SQL statements? PS. For Michael: I originally sent this query by e-mail on Monday. It never showed up. For awhile now, any orginial message I send just disappears. I can reply, but new messages are a no go. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231687 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: pre-newbie questions
Thanks for the rest of your answers. I appreciate the depth! You're welcome! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231688 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: Log analyzer software.
-Original Message- From: Cameron Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 11:22 AM Does SmarterStats make it easy to track pages based on URL variables? Like many sites, our whole site is based on: I don't off-hand see a way of doing this, it might take a call to them to find out if there's a way of querying the data based on keys in the query string. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231689 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
CFUNITED-06 interview 6: Hal Helms, Win a ticket, schedule posted
In this issue of ColdFusion conference and training news: * New Sponsor - CFMX Exam Buster * Schedule is posted! * Hotel update - 48% full * Spring Conference 2006 * Win a ticket to CFUNITED with our competition. * Interview with Hal Helms - Celebrity Death Match with Simon Horwith CFUNITED is the premier ColdFusion Conference near Washington DC 6/28-7/1/06 (Four whole days!) Check out speakers and topics at http://www.cfunited.com/ - Michael Smith TeraTech, Inc TeraTech is hiring a senior developer to join our growing team http://www.teratech.com/index.cfm?go=About.JobDetailJobID=7 Conference and training news * Upcoming classes CF202 - Web Accessibility and 508 Feb 21 2006 FB101 - Intro to FuseboxFeb 28 2006 MS01 - Avoiding web disasters Mar 1 2006 FB201 - Intermediate FuseboxMar 7 2006 CF206 - ColdFusion SQL Skills Mar 14 2006 Cost $59 - $349 see http://www.teratech.com/training/ for more details and registration CFUNITED NEWS! * New Sponsor: CFMX ExamBuster If you would like to become a sponsor, see more information on our CFUNITED website. * Schedule is now posted in PDF. http://www.cfunited.com/images/schedule.pdf A new dynamic version is coming soon. This only shows June 28th - 30th (Wed - Fri). We will be doing voting for the most popular sessions to pick the Saturday repeats. * Hotel guest room update. Currently 48% of the rooms have been sold. The Bethesda North Marriot is the host of our event, which is located right at the Montgomery County Conference Center. See http://www.cfunited.com/travel.cfm for details. * Spring Conference 2006 Thursday, March 23, 2006 Athens, Ohio Well, it's that time of year again. Spring Conference 2006 is ready to rock-n-roll! The Southeast Ohio Macromedia User Group (SEOMUG), in partnership with the IT Alliance of Appalachian Ohio (ITAAO), Ohio University and Adobe Systems is proud to present our fourth annual conference. And it's going to be the best yet. Ed Sullivan, director of User Group Relations for Adobe Systems states, Spring Break is one of the better user group regional events in existence. The speakers and sessions are second to none and the conference price is unmatched in the industry. This year's event will be held in the state of the art Walter Hall, on the beautiful campus of Ohio University in Athens, Ohio. Register Online: http://www.seomug.org/conference.cfm * Win a ticket to CFUNITED with our competition. Answer the questions tell us why should people come to CFUNITED-06 and you could win a free ticket to the event http://www.cfunited.com/survey.cfm ** And now our CFUNITED spotlight interview. Michael Smith: This time we are talking with Hal Helms about his CFUNITED-06 talk Celebrity Death Match. So why should a developer come to your session Hal? Hal Helms: One reason, Michael: gore and mayhem. Michael Smith: That's two. Hal Helms: Huh? Michael Smith: That's two reasons: (1)gore and (2)mayhem. Hal Helms: After I finish up Simon, you could be next, pal... Michael Smith: You and Simon are squaring off on the subject of frameworks, right? Hal Helms: Right. Simon and I have had several lively debates on the topic and this time, we're taking our show on the road. Michael Smith: And you're predicting victory? Hal Helms: Betting against me would be like betting against the NFL's Indianapolis Colts. Michael Smith: But...they lost. Hal Helms: What? Michael Smith: They lost. They're not in the playoffs any longer. Hal Helms: OK, New England Patriots. Michael Smith: Also lost. Hal Helms: Well, it's not about victory, then; it's about framing the terms for thinking about whether you should use a framework or not. Michael Smith: I'm guessing you're coming down on the side of yes. Hal Helms: I am. And my friend, Simon, is arguing that the indiscriminate use of frameworks is dunderheaded. Michael Smith: That's what he said? Dunderheaded? Hal Helms: No, but I always wanted to use that term in an interview. You know, spoken with a British accent. In fact, I might do the entire debate in my U.K. persona. You know, give the event some class. Michael Smith: I see you've lapsed into that while we've been speaking. Hal Helms: I'm in training, mate. Say, Michael, you're a Brit: what do you think? Could I pass for a native? Michael Smith: It sounds a bit more like Dick Van Dyke in Mary Poppins. Hal Helms: Well, back to the Death Match. I think it's going to be great to have a sessions that airs the benefits and drawbacks of frameworks. And Simon and I are both passionate defenders of our positions. Michael Smith: So it should be informative and fun. Hal Helms: I think it will be just that. Michael Smith: Well, thanks, Hal. Hal Helms: No worries, mate. I'll throw another shrimp on the barbie... Michael Smith: Good grief... More interviews will be made available at http://www.cfunited.com/interviews.cfm CFUNITED-06 is
RE: Log analyzer software.
Personally, I have a little script I use to create my own IIS logs where I replace the appropriate URL variables with an associated page name. It means you have one set of logs which shows how many people have been looking at different images and with a lot of hits to index.cfm but another which is great for viewing page views, paths through the site, etc. I find that more reliable and less cumbersome than trying to persuade any of the stats packages to display just what I want based upon a number of different URL variables. Best Wishes, Peter -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 6:00 PM To: CF-Talk Subject: RE: Log analyzer software. -Original Message- From: Cameron Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 11:22 AM Does SmarterStats make it easy to track pages based on URL variables? Like many sites, our whole site is based on: I don't off-hand see a way of doing this, it might take a call to them to find out if there's a way of querying the data based on keys in the query string. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231691 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
global error handling
I have 5 www servers over a replicated network, each with the exact same CFMX config. All are running 6.11 with the same hotfixes (same version #, same OS, same JVM, same IIS). The error handler on 2-5 just stopped working. The error handler on 1 works as expected. There is no error in the error handler, 1-5 all have the same file, located in the same place, with the same app.cfm. I verified this by replacing the error file with one that said error! and nothing else, it still does not trigger. The logs on 2-5 all have this with each error, i imagine this is the error handling failing (global error handler set to /error.cfm): Error,jrpp-4,02/08/06,17:41:22,,The filename, directory name, or volume label syntax is incorrect The specific sequence of files included or processed is: C:\CFusionMX\runtime\bin\ E:\Webdocs\error.cfm java.io.IOException: The filename, directory name, or volume label syntax is incorrect at java.io.WinNTFileSystem.canonicalize0(Native Method) at java.io.Win32FileSystem.canonicalize(Win32FileSystem.java:333) at java.io.File.getCanonicalPath(File.java:513) at coldfusion.jsp.JRunTagLibraryInfo.lookupTLI(JRunTagLibraryInfo.java :110) at coldfusion.jsp.JRunTagLibraryInfo.lookupTLI(JRunTagLibraryInfo.java :104) snip This makes no sense at all. E:\webdocs\error.cfm is the path on every server. The path exists on every server. The file exists in that path. All the file does is say error!. Yet it refuses to trigger. Help? Please? Thanks :P -jc ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231692 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
Is there a way to maintain formated text
Hi, I am trying to build a program that allows end users to submit short news articles to a database field. The program would serve the text in the field to a cfm page. Sometimes the original text contains formated text such as words in bold, with bullet points, and even with url behind it. When the text goes to the database, they are stripped away. Is there a way to maintain those format and the cfm page can display them well? Any help is appreciated. Nathan Chen ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231693 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: global error handling
handling failing (global error handler set to /error.cfm): This makes no sense at all. E:\webdocs\error.cfm is the path on every Note the slashes (perhaps error handler wants to see \error.cfm)I can't recall which way CF Admin wants itbut it stuck out while reading over your issue so I'm chiming in ;-) 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 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231694 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: global error handling
I got it, CF simply made up my webroot. (thanks but I tried every kind of diff slash :)) Error,jrpp-4,02/08/06,17:41:22,,The filename, directory name, or volume label syntax is incorrect The specific sequence of files included or processed is: C:\CFusionMX\runtime\bin\ E:\Webdocs\error.cfm It thought the webroot was C:\CFusionMX\runtime\bin\ E:\Webdocs\error.cfm it was set to e:\webdocs We found this by changing error handling on our working server to use a non-existant page. We got the same error, but it would read: Error,jrpp-4,02/08/06, 17:41:22,,The filename, directory name, or volume label syntax is incorrect The specific sequence of files included or processed is: E:\Webdocs\x.cfm Noticing this difference, we... on a whim... deleted the mapping for / on a broken server, and rebuilt it (exactly the same) Now everything works. Amazing. And frightening. All at the same time. -jc On 2/8/06, Bryan Stevenson [EMAIL PROTECTED] wrote: handling failing (global error handler set to /error.cfm): This makes no sense at all. E:\webdocs\error.cfm is the path on every Note the slashes (perhaps error handler wants to see \error.cfm)I can't recall which way CF Admin wants itbut it stuck out while reading over your issue so I'm chiming in ;-) 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 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231695 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: socket connections from CF to SMTP
Was wanting to confirm the existance of an email address Check out EmailVerifier from ActivSoftware. It will do everything you want and more. http://www.activsoftware.com/email/verify/ -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231696 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: global error handling
I would like to add, this makes no sense at all. Even after I watched it work. If CF thought the webroot was C:\CFusionMX\runtime\bin\ E:\Webdocs\, how was it serving webpages? And all of these servers were serving pages just fine, I watched it this morning. This was only an issue when it tried to catch an error. How very odd. -jc On 2/8/06, Jeff Congdon [EMAIL PROTECTED] wrote: I got it, CF simply made up my webroot. (thanks but I tried every kind of diff slash :)) Error,jrpp-4,02/08/06,17:41:22,,The filename, directory name, or volume label syntax is incorrect The specific sequence of files included or processed is: C:\CFusionMX\runtime\bin\ E:\Webdocs\error.cfm It thought the webroot was C:\CFusionMX\runtime\bin\ E:\Webdocs\error.cfm it was set to e:\webdocs We found this by changing error handling on our working server to use a non-existant page. We got the same error, but it would read: Error,jrpp-4,02/08/06, 17:41:22,,The filename, directory name, or volume label syntax is incorrect The specific sequence of files included or processed is: E:\Webdocs\x.cfm Noticing this difference, we... on a whim... deleted the mapping for / on a broken server, and rebuilt it (exactly the same) Now everything works. Amazing. And frightening. All at the same time. -jc On 2/8/06, Bryan Stevenson [EMAIL PROTECTED] wrote: handling failing (global error handler set to /error.cfm): This makes no sense at all. E:\webdocs\error.cfm is the path on every Note the slashes (perhaps error handler wants to see \error.cfm)I can't recall which way CF Admin wants itbut it stuck out while reading over your issue so I'm chiming in ;-) 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 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231697 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: Is there a way to maintain formated text
Hi Nathan: Check out FCKEditor. http://www.sourceforge.net http://sourceforge.net/projects/fckeditor/ Nathan Chen wrote: Hi, I am trying to build a program that allows end users to submit short news articles to a database field. The program would serve the text in the field to a cfm page. Sometimes the original text contains formated text such as words in bold, with bullet points, and even with url behind it. When the text goes to the database, they are stripped away. Is there a way to maintain those format and the cfm page can display them well? Any help is appreciated. Nathan Chen ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231698 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: socket connections from CF to SMTP
...there is a DNS record called an MBX record but it's seldom used these days - something left over from the dark ages of DNS I believe it was actually MB, defined in RFC 1035 as an experimental type. There were also MD, MF, MG and MR (some obsolete, some experimental) which performed various e-mail related functions. I have not seen any of them in actual production use in my eight years of Internetting (is that even a word?). As an aside, I have run DtDNS.com (a DNS hosting service) for the last seven years, so I keep hard copies of the DNS RFC's handy for reference. what about sending a message to the address and then checking the undelivered folder for any bounces? The ColdFusion undeliverable folder should only have messages that were either the result of your e-mail spooler being unavailable, or your spooler out-right rejecting the message (invalid user on a local domain, for instance). If your spooler is configured properly to accept mail for relay from ColdFusion, any bounce generated would go to the FROM address in your CFMAIL tag (or the optional FAILTO attribute on CFMX). You could check that mailbox with POP and parse out the results. I use the Java extension from ActivSoftware myself, which is much easier. (I posted a link earlier). -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231699 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: Is there a way to maintain formated text
Hi, Ray, Thank you! This looks very powerful. I'll have to play with it and might have more questions. Nathan Chen -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 5:16 PM To: CF-Talk Subject: Re: Is there a way to maintain formated text Hi Nathan: Check out FCKEditor. http://www.sourceforge.net http://sourceforge.net/projects/fckeditor/ Nathan Chen wrote: Hi, I am trying to build a program that allows end users to submit short news articles to a database field. The program would serve the text in the field to a cfm page. Sometimes the original text contains formated text such as words in bold, with bullet points, and even with url behind it. When the text goes to the database, they are stripped away. Is there a way to maintain those format and the cfm page can display them well? Any help is appreciated. Nathan Chen ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231700 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: problems with mySql federated storage engine
hi, is anybody using federated tables in mysql? sorry, I already wrote a msg in thy mysql forums, got no help yet.. problem is that I cannot connect to the remote tables, I found a (verified) bug (but not yet assigned to anybody) that seems to cause the problem I'm having: http://bugs.mysql.com/bug.php?id=17049) federated storage engine does not transparently reconnect Well, thats just that what I needed, I wanna set up a new frontend (where an additional frontend and backend exists) to use a part of the existing data stored in a mysql-db. WIthout changing some queries.. Now I sometimes can connect, sometimes not, sometimes I get the error the database doesnt exist, sometimes just a 'closed connection'. Sometimes I see long-running processes where mysql copies data in tmp-tables (strange, there is enough cache available, but they die at all) On a remote-db in my local network it was working (slowly but it worked :-p Does anybody have the same problems? -- Sebastian Mork [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231701 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
A way to set a dynamic anchor in a div?
Hi, all... I'm working on an web-based office application, so I'm trying to put as much functionality on a single screen as possible. I've using scrolling div's for areas to add, update, and delete content. Everythings going well except for trying to place an anchor inside a div for client contact entries. I think I'm coding everything correctly...I've done this before, but the anchor was on a full page of html, not in a particular div. Is there some way I can target the anchor to affect the content in a particular div? I think that's why the anchor's not working, because it's not an anchor for the whole HTML page, just the content in that particular div. It's a dynamic CF-generated anchor, but I've done that before, too. The div just seems to ignore the anchor... Ideas? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231702 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: cftry and cfcatch
Sounds like you do not want TRY/CATCH... that is triggered on a failure. You really want to use CFSWITCH/CFCASE. -- John McKown President, Delaware.Net ICQ: 1812513 We host Fusebox.org and all of our apps are Fusebox/ColdFusion/BlueDragon compliant. John Lucania wrote: I have two queries: cfquery name=checksrv datasource=master SELECT @@SERVICENAME; /cfquery cfquery name=checkage datasource=master SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfquery I want to be notified through cfmail if 1) query checksrv doesn't return MSSQLSERVER then, MSSQLSERVER not returned in cfmail or query checkage doesn't return 2 then, Agent not returned 2 in cfmail or both of checksrv and checkage don't return then, MSSQLSERVER not returned and Agent not returned 2 in cfmail or 2) query checksrv cannot be run then, MSSQLSERVER Not Avail in cfmail or query checkage cannot be run then, Agent Not Avail in cfmail or both of checksrv and checkage cannot be run then, MSSQLSERVER Not Avail and Agent Not Avail in cfmail. Any ideas? tia, jl ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231703 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: Homesite 5.5 and external browsers
Hi, Does anyone know why viewing the pages locally on localhost or 127.0.0.1 both ask me for a username and password? it happens in every browser I use. Thanks Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231704 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: Homesite 5.5 and external browsers (one more thing)
The site is viewable if i type either address in the bar physically just not when I use HS view in external browser button. The default is IE Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:33 PM To: CF-Talk Subject: OT: Homesite 5.5 and external browsers Hi, Does anyone know why viewing the pages locally on localhost or 127.0.0.1 both ask me for a username and password? it happens in every browser I use. Thanks Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231705 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: Homesite 5.5 and external browsers (one more thing)
Are there any references (CSS/Images/etc) that are, themselves, secured? -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 9:40 PM To: CF-Talk Subject: RE: Homesite 5.5 and external browsers (one more thing) The site is viewable if i type either address in the bar physically just not when I use HS view in external browser button. The default is IE Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:33 PM To: CF-Talk Subject: OT: Homesite 5.5 and external browsers Hi, Does anyone know why viewing the pages locally on localhost or 127.0.0.1 both ask me for a username and password? it happens in every browser I use. Thanks Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231706 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: Homesite 5.5 and external browsers (one more thing)
No nothings secure Phil -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:44 PM To: CF-Talk Subject: RE: Homesite 5.5 and external browsers (one more thing) Are there any references (CSS/Images/etc) that are, themselves, secured? -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 9:40 PM To: CF-Talk Subject: RE: Homesite 5.5 and external browsers (one more thing) The site is viewable if i type either address in the bar physically just not when I use HS view in external browser button. The default is IE Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:33 PM To: CF-Talk Subject: OT: Homesite 5.5 and external browsers Hi, Does anyone know why viewing the pages locally on localhost or 127.0.0.1 both ask me for a username and password? it happens in every browser I use. Thanks Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231707 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: Homesite 5.5 and external browsers (one more thing)
OK, now I switched the mapping to localhost and it works in IE but opera NS and FF all want username and password still. I haven't a clue what this could be Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:33 PM To: CF-Talk Subject: OT: Homesite 5.5 and external browsers Hi, Does anyone know why viewing the pages locally on localhost or 127.0.0.1 both ask me for a username and password? it happens in every browser I use. Thanks Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231708 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: Is there a way to maintain formated text
Sometimes the original text contains formated text such as words in bold, with bullet points, and even with url behind it. When the text goes to the database, they are stripped away. How come? HTML is pure texte, database fields that can take text can take HTML. Who strips the code away? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231709 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: passing multiple values from the same form field
I was able to figure out how to do the multi insert. Here are the steps I took. To make sure the form values where passed I setup an actionpage.cfm instead of going directly to a cfc. On the top of the page I added cfdump var=#form# label=Form variables /. Once I knew extactly what formfields where passed I created a variable to hold the number of mulitple fields for insert. cfset formCount = ListLen('#FORM.FieldNames#', ,) !--- minus hidden and other fields that are not part of the multi insert -- cfset formCount = formCount - 4 !--- Query to insert into the fist table. These values are not part of the multi insert. --- cftransaction cfquery datasource=#request.dsn# INSERT INTO cart (cart_custcart_ID, productID, qty, cart_dateadded) VALUES ('#Client.CartID#',#FORM.productid# ,#FORM.qty# ,#CreateODBCDateTime(Now())#) /cfquery !--- Get the last id for use in the multi insert --- cfquery name=lastRec datasource=#request.dsn# SELECT LAST_INSERT_ID() as lastid /cfquery !--- I set the lastID cause without it I get an error message --- cfset lastID = lastRec.lastid !--- Here is where the multi insert is done. The formCount is used to setup loop for the Options --- cfloop from=1 to=#formCount# index=i cfquery datasource=#request.dsn# INSERT cart_options (optionID, cartLineID) VALUES ('#Evaluate(form.option#i#)#', #LastID#) /cfquery /cfloop /cftransaction I still have a problem I hope someone can answer. On the form if their are 3 options to select from (radio buttons) and I select option 1 and 3, I get an error message because the options are not concurrent . This is because the loop goes thru 2 options; option1 and option2 instead of option1 and option3 and gives an error stating their is no value for option2. Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231710 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: Is there a way to maintain formated text
I'd think that it was maybe bold in a Word doc and then copy n pasted into a text area at which point it lost its formating. On 2/8/06, Claude Schneegans [EMAIL PROTECTED] wrote: Sometimes the original text contains formated text such as words in bold, with bullet points, and even with url behind it. When the text goes to the database, they are stripped away. How come? HTML is pure texte, database fields that can take text can take HTML. Who strips the code away? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231711 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: passing multiple values from the same form field
Deanna, I didn't see your post till now. I did it with evaluate instead. I still have a problem; what if I have three options !-- radio button groups -- form input type=radio name=option1 value=#whatever# input type=radio name=option1 value=#whatever# input type=radio name=option2 value=#whatever# input type=radio name=option2 value=#whatever# input type=radio name=option3 value=#whatever# input type=radio name=option3 value=#whatever# /form If I select option1 and option3 I get an error message that option2 is missing. I have to make my selection concurrent because of the loop. Any ideas? He gave you an example: #form[fieldname counter]# Basically, the form scope is an array, so you in cases when you need to use a variable as a form name, you can use the bracket notation above to get the data without using evaluate. So, for example, if you had this form: form input type=text name=option1 value=1 input type=text name=option2 value=2 /form On your action page, you could get the values by looping: cfoutput cfloop from=1 to=2 index=i form.option#i# = #form[option i]#br /cfloop /cfoutput Obviously, you'd make this more dynamic by passing a hidden var with the number of options, and then looping to that number, instead of hard-coding it. But, you get the idea. On 2/6/06, j s [EMAIL PROTECTED] wrote: Ian mentioned array notation, can anybody explain how to do this or a link on an example? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231712 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: passing multiple values from the same form field
Something like: cfif StructKeyExists(FORM, option#i#) do whatever it is I need to do/cfif Where i is the index value of a loop, your 1, 2, 3 or you could just do cfqueryparams for the fields and then just check to see if they have a value other than what you defaulted with the param. Something like: cfparam name=Form.option1 default= / cfparam name=Form.option2 default= / cfparam name=Form.option3 default= / cfloop from=1 to=3 index=i cfif Form[option#i#] NEQ do whatever it is I need to do because it has a value/cfif /cfloop Hope that makes sense, it is late here and my brain is not functioning all that great right now :) On 2/8/06, j s [EMAIL PROTECTED] wrote: Deanna, I didn't see your post till now. I did it with evaluate instead. I still have a problem; what if I have three options !-- radio button groups -- form input type=radio name=option1 value=#whatever# input type=radio name=option1 value=#whatever# input type=radio name=option2 value=#whatever# input type=radio name=option2 value=#whatever# input type=radio name=option3 value=#whatever# input type=radio name=option3 value=#whatever# /form If I select option1 and option3 I get an error message that option2 is missing. I have to make my selection concurrent because of the loop. Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231713 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