RE: Returning javascript variables to CFMX via hidden fields.
Your option tags don't have values (not something I would recommend). FF
is picking up the text as the value, but IE isn't. Just change your code
to
mystr3 += ((mystr3.length0)?|:) + m2.options[i].text
Of course, a better solution would be to actually use the values of your
options (both in the tags and in your JS functions).
Pascal
var mystr3 =
for (i=0; im2.length; i++) {
mystr3 = mystr3 + | + m2.options[i].value
}
document.theForm.result_set1.value=mystr3
}
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184529
Archives: http://www.houseoffusion.com/cf_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
What sets the domain in default CFID cookies?
I'm having real trouble with my sessions and cookies. I can observe the CFID/CFTOKEN cookies get set in my browser. They are set twice, once when I come to the home page and then again when I login. But the confusing part is why the domain name is host.net for one pair and then WWW.host.net for the other. Can someone explain to me what sets the domain value for these cookies? I am concerned that this is why my session variables seem to be incorrect, as if there were a shadow session associated with the different CFID/CTOKEN. Also what determines the expiration - it's 30 years now. I don't use CFCOOKIE because the CFID/CFTOKEN are set automatically. I have the following application.cfm (two of them - one at root and one below it, but both with the same cfapplication tag) cfapplication name=mes clientmanagement=No loginstorage=Session sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0, 1, 1, 0)# ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184530 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Same story everywhere, except the US I guess. Macromedia is just too late with unique features. It was BlueDragon who had to come up with the feature of deploying compiled ColdFusion apps first despite the fact it was widely requested (since v4.0 people requested it) as a builtin functionality in ColdFusion. And seriously, I want a product that runs, is stable, but through the years .. ColdFusion always had the sense of being unstable. = 5 locking up and being thread unsafe, 6.* too much Java dependent stability .. (increase this heap, decrease that heap, do this with memory, do that, check for GC size, monitor this, monitor that..) I just want a product that runs out of the box stable without setting up several failover instances.. and yes, under load, not only my average personal administration but also the applications we sell to our customers. And those issues aren't caused by bad code. I am not saying the product is dying but I haven't got the feeling it is growing either, it remains a niche product and it if I believe our sales team, they have a hard time selling the product. I am committed in learning other languages; no Cold Fusion jobs would mean no paycheck. And if you really look at it, why would you choose ColdFusion?, the only thing I could come up with is the low learning curve. Every language has a learning curve, but once you get over it you can use the language like any other product. The most important things in building applications are the experiences from previous projects. And looking at ASP.NET, my apps in C# are astonishing quick, structured, can be deployed anywhere, and too be honest I didn't found the learning curve to be that steep, it is just different. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184531 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
are you on crack? seriously? -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Nov 2004 09:52:04 +0100 Same story everywhere, except the US I guess. Macromedia is just too late with unique features. It was BlueDragon who had to come up with the feature of deploying compiled ColdFusion apps first despite the fact it was widely requested (since v4.0 people requested it) as a builtin functionality in ColdFusion. And seriously, I want a product that runs, is stable, but through the years .. ColdFusion always had the sense of being unstable. = 5 locking up and being thread unsafe, 6.* too much Java dependent stability .. (increase this heap, decrease that heap, do this with memory, do that, check for GC size, monitor this, monitor that..) I just want a product that runs out of the box stable without setting up several failover instances.. and yes, under load, not only my average personal administration but also the applications we sell to our customers. And those issues aren't caused by bad code. I am not saying the product is dying but I haven't got the feeling it is growing either, it remains a niche product and it if I believe our sales team, they have a hard time selling the product. I am committed in learning other languages; no Cold Fusion jobs would mean no paycheck. And if you really look at it, why would you choose ColdFusion?, the only thing I could come up with is the low learning curve. Every language has a learning curve, but once you get over it you can use the language like any other product. The most important things in building applications are the experiences from previous projects. And looking at ASP.NET, my apps in C# are astonishing quick, structured, can be deployed anywhere, and too be honest I didn't found the learning curve to be that steep, it is just different. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184532 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Why? .. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184533 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
[quote] Macromedia is just too late with unique features[/quote] huh? what other platform has as many built-in features as coldfusion? heres a quote from earlier on another lisr [quote]I imagined MacroMedia would not turn out a template that did not work in all browsers on all platforms[/quote] 2 stupidest things i have heard in a LONG ASS TIME -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Nov 2004 09:52:04 +0100 Same story everywhere, except the US I guess. Macromedia is just too late with unique features. It was BlueDragon who had to come up with the feature of deploying compiled ColdFusion apps first despite the fact it was widely requested (since v4.0 people requested it) as a builtin functionality in ColdFusion. And seriously, I want a product that runs, is stable, but through the years .. ColdFusion always had the sense of being unstable. = 5 locking up and being thread unsafe, 6.* too much Java dependent stability .. (increase this heap, decrease that heap, do this with memory, do that, check for GC size, monitor this, monitor that..) I just want a product that runs out of the box stable without setting up several failover instances.. and yes, under load, not only my average personal administration but also the applications we sell to our customers. And those issues aren't caused by bad code. I am not saying the product is dying but I haven't got the feeling it is growing either, it remains a niche product and it if I believe our sales team, they have a hard time selling the product. I am committed in learning other languages; no Cold Fusion jobs would mean no paycheck. And if you really look at it, why would you choose ColdFusion?, the only thing I could come up with is the low learning curve. Every language has a learning curve, but once you get over it you can use the language like any other product. The most important things in building applications are the experiences from previous projects. And looking at ASP.NET, my apps in C# are astonishing quick, structured, can be deployed anywhere, and too be honest I didn't found the learning curve to be that steep, it is just different. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184534 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Euhmm.. ASP.NET? PHP? Name one thing that cannot be done on these platforms and can be done with ColdFusion. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184535 Archives: http://www.houseoffusion.com/cf_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: Oddball Query question...
Correct me if I am wrong, but would SELECT zip FROM table1 WHERE NOT EXISTS (SELECT zip FROM table2 WHERE zip = table1.zip) Not be a whole faster? Using IN would not stop after it found one occurrence, EXISTS would stop after it finds one occurrence. Could be wrong, had a long day... Taco Fleur -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Wednesday, 17 November 2004 7:23 AM To: CF-Talk Subject: RE: Oddball Query question... Quick and dirty could be: SELECT zip FROM table1 WHERE NOT zip IN (SELECT zip FROM table2) -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 4:09 PM To: CF-Talk Subject: Oddball Query question... Odd query question MY brain is lagging at 4:00pm... I need some help Table one has a list of zip codes. Table two has a list of zip codes. I want to compare table one to table two. The results would list ONLY the zip codes that appear in table one that do not appear in table two. Any help is greatly appreciated... Thanks, Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184536 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
what else has progressed as much as cfm in the last yr or so? .net not much php - nope jsp - nope actually probably gone done now that cfm can play with jsp cgi? lol perl- haha asp - whats that? its 2 am but off the top of my head some of the unique features that i guess dont make your list cfc's, remoting, j2ee deployment, flash forms, the new print functions, new reporting functions, flex intrgration, not to mention that flex flash are really build around using coldfusion as the backend, i mean its a pretty long ass list and the whole language has been completely rebuilt from the ground up. It's been here since the begining and i dont see it going away. but then again someday .net will get sparkle whoo hoo cant u wait to get the sparkled version of shorthorn?? sure there are something that could be improved but i seem to notice quite a few ppl on here who say things like that are still running 4.5 things change being cynical doesnt help and if u open up your eyes and see what all they are doing with it, its pretty sweet. Now ur on the other side of the world and so u may not see it and i think MM needs to do a better job of promoting it but i see more things on cfm then i do on new great features of .net then this comment Euhmm.. ASP.NET? PHP? Name one thing that cannot be done on these platforms and can be done with ColdFusion. ok what builtin featured do they have that cant be done in cfm? one thing huh? cfc :) 1 tag printing to pdf without extra dll's built in reports theres quite a few i never said u cant do the same things with other languages but those other languages dont have the same stuff built in as features and thats what your comment was about.=, lack of unique features as i recall -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Nov 2004 10:07:33 +0100 Why? .. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184537 Archives: http://www.houseoffusion.com/cf_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
cfm tag changes
i was cleaning out my harddrive and i came across this file that has lists of when certain changes to the cfml launguages took place not sure how current it is but a lot of ppl mention about thrying to find out if a certain function existed say in 4.5 or 4, this should say, havent read it but you can here http://www.jamwerx.com/cfmTaghistory/index.htm i guess its up to 6.1 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184538 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Clearly.. If you talk about .NET doesn't have CFC's, or .NET doesn't have J2EE deployment are you being serious? .. or do you think a CLASS is a rabbit on a pogo stick? For the rest, everything what you just mentioned can be done with PHP as well as ASP.NET, and once you know the language development times are the same, or even less but that depends on how you maintain structure your application. Flash Forms, .. a nice feature for the basic user but like CFFORM, I don't think it will be used a lot. You are talking about Blackstone with your features.. euhm .. Blackstone isn't available yet .. the sales team cannot sell a product to customers if the product is not available the market, nor it's licensing model being clear. Don't get me wrong, I like ColdFusion, but I do see why companies are moving away and I can't blame them, and for my own sakes (and the 3 mouths I have to feed at home and being responsible for) I had to widen my playground to .NET, cause I see the strengths it has as well as the amount of jobs being available. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184539 Archives: http://www.houseoffusion.com/cf_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: apache and muliple CF instances
Paella only on sundays.. at 2pm.. precicely! I missed the virutal host/ virtual directory bit I shall post more stuff as I come across it.. the other trick that I implemented was to run a separate instance of Apache.. (on windows) I shall blog that at some point! Regards Mark Drew On Wed, 17 Nov 2004 00:52:38 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: Mark, kewl, helpful, but not for what I was wanting to do. Wow, Valencia, eh? Sweet place, can we say paella? I did find that I could setup virtual hosts on the same domain under different ports and 'map' seperate CF instances to them. Then mod_rewrite can be employed to move requests from foo.com/home to foo.com and foo.com/yourhome to foo.com:88. ...a good day for sure. Doug On Wed, 17 Nov 2004 01:19:30 +0100, Mark Drew [EMAIL PROTECTED] wrote: I blogged on this you might find it helpful http://cybersonic.blogspot.com/2004/09/apache-virtual-hosts-php-cf5-and-cfmx.html Regards Mark Drew On Tue, 16 Nov 2004 17:36:10 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: ah, the one place I failed to lookup. danke sir. Now, I see how to do this using virtual hosts in Apache, which appears to be analogous to a site in IIS. Now, what I want to do is create two virtualhosts based on the dir. domain/foo and domain/goo where the domain is the same. Is that possible with Apache? Maybe I need to create two virtual hosts based on ports, domain:80 and domain:88 and use mod_rewrite or something? Doug On Tue, 16 Nov 2004 16:22:20 -0500, Dave Watts [EMAIL PROTECTED] wrote: Ok, I got a box with CFMX installed on JRun, actually have 2 instances installed, say one is cfusionone and cfusiontwo. In IIS I know I can add a new site, via different port or host-headers, so that http://domain:80/ uses cfusionone and http://domain:88/ uses cfusiontwo. How to do this in Apache? Google is not being my friend the pas two days with this. Basicaly I want http://domain/foo to use cfusionone and http://domain/goo to use cfusion two. I can see in httpd.conf the stuffs loading the so, but only for the port 80 root site. In my limited Apache experience, this can be a little difficult but is certainly doable. However, an additional bit of complexity is that you seem to be asking about two different things. Your IIS example is about having multiple IIS virtual servers, which you can do in Apache using the VirtualHost directive. Later, though, you say you want to use the same virtual server (http://domain/) for both CFMX instances, which is a different thing altogether. To do that, each CFMX instance will require a different context root (/foo, /goo), and both instances will need to be connected to the same Apache virtual server. For more information on this, read Configuring application isolation in Apache within Configuring and Administering ColdFusion MX which is one of the CF documentation books, and which is viewable here: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/cluster8.htm#wp103767 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184540 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
well did u not say to give u one feature that php or .net doesnt have? so i did, cfc's, isnt that what u asked for? and thats a friggin pretty BIG feature wouldnt u say? then why try to change your ? now? so if i say that u dont have to make whole db calls on the pages like .net or php, r u gunna say those dont count either, will any of them? does built in remoting count either? and again i say this, i NEVER said that the same things couldnt be done in those languages, that was u trying to put words into mouth but i never said that i commented on your direct quote which was *copied paste* [quote]Macromedia is just too late with unique features[/quote] so, who gives a rats ass if i do quote blackstone? Least we know the features exists, whats coming up in php .net thats a unique feature, or what has come out as a unique feature of any of those u mentioned? Because thats what u were talking about wasnt it? having unique features coldfusion might be the only one who does actually have unique features outta the box. maybe MM is late on those uniqure features but at least it has them. and you perplex me, you always come on and rip cfm, you are so cynical about it so why even use it then? -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Nov 2004 10:56:59 +0100 Clearly.. If you talk about .NET doesn't have CFC's, or .NET doesn't have J2EE deployment are you being serious? .. or do you think a CLASS is a rabbit on a pogo stick? For the rest, everything what you just mentioned can be done with PHP as well as ASP.NET, and once you know the language development times are the same, or even less but that depends on how you maintain structure your application. Flash Forms, .. a nice feature for the basic user but like CFFORM, I don't think it will be used a lot. You are talking about Blackstone with your features.. euhm .. Blackstone isn't available yet .. the sales team cannot sell a product to customers if the product is not available the market, nor it's licensing model being clear. Don't get me wrong, I like ColdFusion, but I do see why companies are moving away and I can't blame them, and for my own sakes (and the 3 mouths I have to feed at home and being responsible for) I had to widen my playground to .NET, cause I see the strengths it has as well as the amount of jobs being available. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184541 Archives: http://www.houseoffusion.com/cf_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: cfm tag changes
that has lists of when certain changes to the cfml launguages .. i guess its up to 6.1 http://www.jamwerx.com/cfmTaghistory/index.htm Cheers dave :) -- dc ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184542 Archives: http://www.houseoffusion.com/cf_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: cfm tag changes
thank ya thankya very much i'll be here all week ;) i was just looking through it and there is some good stuff in there! think i should zip it up and have it to download? only prob with that is i have no idea how i got it and if it steps on anyones toes -- Original Message -- From: COLLIE David [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Nov 2004 10:16:37 - that has lists of when certain changes to the cfml launguages .. i guess its up to 6.1 http://www.jamwerx.com/cfmTaghistory/index.htm Cheers dave :) -- dc ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184543 Archives: http://www.houseoffusion.com/cf_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: cfm tag changes
think i should zip it up and have it to download? Yeah... Would be good for out intranet... only prob with that is i have no idea how i got it and if it steps on anyones toes Well, give it a day and if nobody hollers then ... meshrugs / ... Why not :) -- dc ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184544 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Dave, Like I said, each platform has it's own syntax. For ColdFusion you have CFC's, for .NET you have Classes. It is pretty obvious .NET doesn't have a cfcomponent tag isn't it? Remote calls through web pages, .. I prefer xmlHttp, SOAP, or JS RPC here, they have much less overhead and have been developed for this specific kind of tasks. maybe MM is late on those uniqure features but at least it has them. and you perplex me, you always come on and rip cfm, you are so cynical about it so why even use it then? I am not being cynical, I am being realistic, just like all those others in this thread who mention they don't see any coverage on ColdFusion in their country. It is just the way the market works, if people buy product A more then product B they choose product B. If a lot of people do not choose product A, there will be a lot more jobs for product B. That's the whole story, and it is plain and simple. And you can agree or disagree, that's all right, everybody deserves his own opinion, and you cannot shake hands all the time, but I am using ColdFusion for a lot of years now will continue using it for hopely many years, but this business is hard and very competitive. If our customers request .NET, .. and even request ports from current ColdFusion application in production to .NET applications the picture becomes quite clear. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184545 Archives: http://www.houseoffusion.com/cf_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
Backup MySQL DB... and restore ;-(
Hi all I want to backup my database to a file that is just like a SQL dump. With mysqldump I can do that. Easy. Then, I just want to be able to execute that .sql file when I need to restore my database... with CF... What do you think about? Cheers Marco ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184546 Archives: http://www.houseoffusion.com/cf_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: cfm tag changes
You got it from the MM site. The zip is available for download there! Pascal -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 11:25 To: CF-Talk Subject: RE: cfm tag changes thank ya thankya very much i'll be here all week ;) i was just looking through it and there is some good stuff in there! think i should zip it up and have it to download? only prob with that is i have no idea how i got it and if it steps on anyones toes ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184547 Archives: http://www.houseoffusion.com/cf_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: Backup MySQL DB... and restore ;-(
Navicat makes it REAL easy to do this. www.navicat.com Will ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184548 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Micha Schopman wrote: have J2EE deployment are you being serious? .. or do you think a CLASS is a rabbit on a pogo stick? a rabbit on a pogo stick? maybe you better explain that one. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184549 Archives: http://www.houseoffusion.com/cf_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: category-unlimited subcategory formatted dropdowns
You could also look at this custom tag that does a great job .. http://www.niederhausen.net/piet/dev/customtags/traversetree.html Pat -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: November 17, 2004 01:17 To: CF-Talk Subject: RE: category-unlimited subcategory formatted dropdowns I'd call you brilliant but you made fun of my chunk of code ;) I cant believe I overlooked repeatstring()! Thanks you thank you thank you. Unfortunately I'm not the greatest when it comes to complex sql so I never looked at nested set to start with. Care to enlighten? My late night is done! Hoorah! -e -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 1:01 AM To: CF-Talk Subject: Re: category-unlimited subcategory formatted dropdowns First, all those queries are going to be really slow. The code as-is will be making n+m+1 queries to generate the dropdown, where n is the number of individual elements, and m is the number of elements with children. The +1 is for the initial query for items with no parent. And yes, you can count the same element in both n and m, so worst case scenario would be 2n queries. However, depending on what you're doing with the result, that might not matter. For example, if you're caching it. Or, if it's a low-use item, then it might not be worth the time to optimize. One alternate route would be to use a nested set model. But that's not your question. To solve the dash insertion problem, make another optional attribute named 'depth' (or 'level') which is omitted from the initial call (just like parentItemID) and defaults to zero. Then add #repeatString(-, attributes.depth)# before the category name within the option. Finally, pass a 'depth' attribute on the recursive calls, incrementing by one. So the call with look like this: cf_makedump parentItemId=#getCurrentCat.catID# dsn=#attributes.dsn# depth=#attributes.depth + 1# cheers, barneyb On Tue, 16 Nov 2004 23:31:31 -0500, Emmet McGovern [EMAIL PROTECTED] wrote: I have a table that contains categories and unlimited subcategories referencing and I need to create a formatted drop down list. I've been messin around with it for a while and now with no luck. I need the list to go like so... Category Name --Child of category --Child of category Child of sub category --Child of sub sub category --Child of category I can get the data out in the proper order, I just cant seem to get the -- in there. I'm using this code as a custom tag which calls itself back again for the recursion. Thanks for the help -emmet ! --- // Calling the initial tag in the dropdown SELECT name=parentID cf_makedrop dsn=#dsn# /SELECT ! --- // now the tag makedrop.cfm cfsilent cfparam name=Variables.ParentItemID default=0 cfif IsDefined(Attributes.ParentItemID) cfset Variables.ParentItemID = Attributes.ParentItemID /cfif CFQUERY NAME=GetCurrentCat DATASOURCE=#attributes.dsn# SELECT * FROM category WHERE ParentID = #Variables.ParentItemID# ORDER BYname /CFQUERY /cfsilent cfloop query=GetCurrentCat cfoutput OPTION value=#catID# cfif getcurrentCat.parentID is 0class=lightcell/cfif#GetCurrentCat.name#/OPTION /cfoutput cfsilent CFQUERY NAME=CheckForSub DATASOURCE=#attributes.dsn# SELECT * FROM category WHERE parentID = #GetCurrentCat.catID# /CFQUERY /cfsilent cfif CheckForSub.RecordCount gt 0 cf_makedrop ParentItemID=#GetCurrentCat.catID# dsn=#attributes.dsn# /cfif /cfloop -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184550 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ERD for MySQL
Mark do you can test dbdesigner4, a open source MySQL modelling tool... http://www.fabforce.net/dbdesigner4/ Cheers Marco On Mon, 15 Nov 2004 10:23:42 +, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Mark Drew wrote: Does anybody use any fornt ends to mysql that allow you to do ERD's in the way the MS SQL Enterprise Manager works? Any ideas? I am NOT looking just for a GUI (phpmyadmin, Aqua Data Studio et al), but something that I can visually design the tables and relationships with . If its for OS X the better! I use Charonware's CASE Studio. (http://www.casestudio.com) Its not the worlds greatest ERD modelling tool, but for your money it does the job nicely and has reverse engineering tools as a bonus. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184551 Archives: http://www.houseoffusion.com/cf_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: CFMX and Access Databases
That was the first driver I tried. It looks like I might have to move towards buying an JDBC Driver for Access from some company. Unless I can get this solved to give me the time I need to migrate to SQL. At 08:47 PM 11/16/2004, you wrote: Has anyone found a solution to using MS Access Databases with CFMX 6.1. I have 4 access databases which everytime cfmx 6.1 tries to do an update/delete query I get a TCP/IP Connection timeout error message and JRUN closes connection. I am slowly converting these to mysql or mssql but at the present time I need these to run. These applications worked with CFMX 6.0 so I am puzzled. I have been searching trying to find JDBC Driver for access and use the similiar method that I am using to connect to the mysql server via the jdbc driver. Have you tried using the Access Unicode driver that comes with CFMX 6.1? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184552 Archives: http://www.houseoffusion.com/cf_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: cfm tag changes
You got it from the MM site. The zip is available for download there! And here they are for anyone that doesn't have them... Cheers dave and Pascal http://www.macromedia.com/support/coldfusion/ts/documents/cfmlhistory.ht m -- Dc ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184553 Archives: http://www.houseoffusion.com/cf_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: Update multiple rows
Check out www.yessoftware.com for a Program called CodeCharge Studio which I usee to create all of my data entry screens. The money I used to purchase this program allows me to save time and not worry about validation or user entry issues as it handles this, I then take their code and wrap my own headers/footers around the application and have a finished product. At 11:22 PM 11/16/2004, you wrote: I need to write an app where the user can update multipe rows from one screen - like a GRID (but not using CFGRID or similar tags) - needs to be table based. I need a starting point to learn how to do this. Can anyone point me to suitable articles, tutes etc Thank you muchly ++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184554 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Getting away from Tit for Tat features and wheter CF has more features than most I think its a sad day that MM walk away and not support any market. its hard enough in the uk as companies go the M$ root and the lower end (where CF would shine) people head up to PHP The deployable apps would be a great way into this market.. of course.. who pays the licence? the web house or the client? MD On Wed, 17 Nov 2004 18:33:58 +0700, Paul Hastings [EMAIL PROTECTED] wrote: Micha Schopman wrote: have J2EE deployment are you being serious? .. or do you think a CLASS is a rabbit on a pogo stick? a rabbit on a pogo stick? maybe you better explain that one. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184555 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ERD for MySQL
Ohh! I spotted that the other day and reviewd it! http://cybersonic.blogspot.com/ Now I want to find something like it for OS X Pah! I should build one... if I had the time :( as the SimpleWebFront plugin is superb! MD On Wed, 17 Nov 2004 10:00:31 -0200, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: Mark do you can test dbdesigner4, a open source MySQL modelling tool... http://www.fabforce.net/dbdesigner4/ Cheers Marco On Mon, 15 Nov 2004 10:23:42 +, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Mark Drew wrote: Does anybody use any fornt ends to mysql that allow you to do ERD's in the way the MS SQL Enterprise Manager works? Any ideas? I am NOT looking just for a GUI (phpmyadmin, Aqua Data Studio et al), but something that I can visually design the tables and relationships with . If its for OS X the better! I use Charonware's CASE Studio. (http://www.casestudio.com) Its not the worlds greatest ERD modelling tool, but for your money it does the job nicely and has reverse engineering tools as a bonus. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184556 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
I started this thread off, by expressing doubts about Macromedia Australia's genuine commitment to the ColdFusion server. My doubts were based on a number of things, some things are historical, dating back to the treatment I received from Allaire and Firmware when I was trying to get my new business started, and some to the impressions I've gained looking on through this list and other places. I wasn't surprised to learn that my original post caused some heartburn in Macromedia, a flurry of emails and phone calls no doubt, and at 10am today I had a call from Mark Blair of Macromedia, who has posted about this topic here already. He was rightly anxious to make sure I had the right impression about Macromedia and its intentions towards ColdFusion. Lets take one thing at a time: [A] I said there was only one person working on growing the server market in Australia. This is the most important part of the market for those of us who earn our livings building ColdFusion web sites. Good growth of servers means we can earn a good living building web sites. Poor growth or no growth and we're going to have to change to working on something else. So it's pretty important. Well it is to me. And I couldnt see what Macromedia were doing to grow it. When I asked this specific question at the CFUG last night, no one seemed to know what Macromedia were doing in this area, or were willing to say, except that Mark Blair was 'the guy'. Just Mark.Or else perhaps no one took my question seriously. Now you all know it was a serious question, based on genuine concern about my own future.. Well Mark went to great pains to tell me all the stuff they're doing to grow the server market, and how he's tramping from one end of Asia/Pacific zone to another. He's outlined all that here too so I wont repeat it all. I think what he's doing is terrific. I wonder if one person, plus several others part time is enough though. [B] I expressed concern that Macromedia ought to be encouraging resellers. Not just a few selected 'favourites' but lots of people, all selling servers.Historically, I have had very poor support in this regard from Macromedia. When i first got started, and was just tring to get my business going, Firmware wouldnt let me sell a subscription renewal and told me it was Allaire's policy. I went all the way to the top at Firmware with it, before giving up. Then I had a spectra deal for about $250.000 lined up, getting close to the proposal stage, and I made 4 attempts to meet with Allaire (or was it Macromedia by then) who stood me up once. I went to their office in Parramatta for a pre-arranged appointment to find no one there. When I arranged an appointment for a presentation at my client's, who were positive and ready to hear teh Spetra story, the sales guy from Macromedia (whose name escapes me) told me he wouldnt be letting me in on the deal, but it would be going to one of the 'favoured' partners. Needless to say I wasnt happy seeing a $250,000 deal go to someone else,specially when I had set it up. So I let it drop.I never tried to do business directly with Macromedia again. They cut me out of that deal? I cut them out of every other deal I've done. I'm a reseller with two of the Macromedia distributors. In 4 years, not once NOT ONCE have I seen anything from them about ColdFusion, except when I specifically asked for prices. No brochures, no emails from the, no promotions, no reminders like I get weekly from them about almost anything else under the sun. But never anything to do with ColdFusion. Now this led me to conclude that Macromedia either didnt want all manner of resellers and were concentrating on the 'favourites' or else they were going to let the whole on-selling thing drop and sell servers through their web site instead. Mark assures me this isnt the case, and that they do want to have lots of us all talking servers to people, and selling server software when and where we can. it's not the private domain of a few 'favourites' after all. So it appears that, at least as far as I'm concerned, the reason I havent seen any activity from Macromedia isnt because they arent doing any, its because [A] I havent read the newspaper they had the story in, and havent been at the major bank (when will we actually SEE an Australian bank using coldfusion so they can stop telling tall tales about it) and [B] the distributors for whatever reason are doing precious little to tell us about how we can sell the product, the way they do on every other product they have. If Macromedia are guilty of anything it's not telling us enough of what they're doing. I said this morning I hoped I was wrong, and I'm reassured to say I think I am, even if there are a few people in the channel who need a bit of a prod along. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year
RE: Macromedia gives up on the server market in Australia and walks away.
So you have also noticed the change in the market also. How do you overcome the Microsoft attention of your prospects? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184558 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
If Macromedia are guilty of anything it's not telling us enough of what they're doing. And that is why I started about the roadmap story. My managers look at the roadmaps for products because, they need to make long term decisions for long term projects and long term contracts. No manager is going to sell a 500k project to a prospect without any idea of the future of such a product. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184559 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Btw .. I am also in the middle of two fights,.. I have build the lasts 11 months intensively on a huge inhouse ColdFusion product (about 2000+ CFC's and CFM files) , and chances are high because it gets cancelled due to company strategy changes (towards Microsoft), so Thursday I have to literally fight for the product in a meeting with company management. This would mean all 80 customers on the system will be ported to ASP.NET, .. and ofcourse I have not spend those lasts freakn 11 months on building the project. ;) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184560 Archives: http://www.houseoffusion.com/cf_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
ESCROW / source code license for CF or BD
Does anybody know if Macromedia or NewAtlanta offer source code licenses for their CF application servers? Under Dutch privacy law processing certain types of information requires you to have ESCROW access to the source code in case the vendor goes belly up. Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184561 Archives: http://www.houseoffusion.com/cf_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: Backup MySQL DB... and restore ;-(
command line is also very easy mysqldump -u sa test test.sql and restore is the same but with regards MD On Wed, 17 Nov 2004 06:22:24 -0400, Will Tomlinson [EMAIL PROTECTED] wrote: Navicat makes it REAL easy to do this. www.navicat.com Will ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184562 Archives: http://www.houseoffusion.com/cf_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
SQL Query using 'FOR XML' Coldfusion
Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to return the results of a stored procedure, called from Coldfusion using 'CFStoredProc', as an XML string to my Coldfusion app. I am having a few problems; When I run the query in the SQL query window the results are exactly as I want, when I then call the stored procedure from Coldfusion app I get a recordset with multiple rows instead of one record containing a string and when I look at the 'ColumnList' property of the query I have mulitple columns with a naming convention as 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. Has anybody managed to use this SQL 'FOR XML' functionality in a Coldfusion app before? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: loop over form objects - using JavaScript - Client Validation
I dont think you are understanding what I'm trying to do..
I already check for server validation on the processing page.
What I'm trying to prevent is from the user to hit submit without
checking a box using client validation... javascript. If they hit
submit I want to display a message that they havent selected
anything... before it goes to the processing page.
On Tue, 16 Nov 2004 15:57:14 -0500, Ewok [EMAIL PROTECTED] wrote:
Well since checkboxes don't really exist in the scope unless they were
checked... I usually build cfparams for the fields with the same query and
loop I built the form fields with. Then use the query loop again to check
the value of the fields
Basic example
~--- to build the fields (which you already have ) ---
cfloop from=1 to=10 index=i
input type=checkbox value=#i# name=fld_#i#br
/cfloop
!--- then on the action page use the exat same loop that you built the
fields with to make params for the fields (im sure urs is a query loop)
So you don't get an error when you try to referecnce a field that wasn't
checked ---
cfloop from=1 to=10 index=i
cfparam name=form.fld_#i# default=
/cfloop
!--- then loop once more to check the values of the fields ---
cfloop from=1 to=10 index=i
FORM.FLD_#i# = #form['fld_' i]#br
/cfloop
You would just use currentrow or a recordID in your query loop rather than
an index.
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 2:34 PM
To: CF-Talk
Subject: loop over form objects
I have a page with X number of check boxes on it.
I have a query which generates these check boxes.
The query also returns the min and max value of the ID for those check
boxes.
Basically creating
r_23
r_24
r_25
r_26
... and so forth.
I'm trying to loop over these fields to check to see if none are checked.
for(i=cfoutput#sweeps.minval#/cfoutput;i
cfoutput#sweeps.maxval#/cfoutput; i++)
{
}
In the above scenerio the for loop would translate to
for(i=23;i=26;i++)
How do I check to see if r_i is checked..
--
Auxilium meum a Domino
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184564
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: loop over form objects - using JavaScript - Client Validation
That is pretty basic stuff..
script type=text/javascript
var i=document.forms['formname'].elements['elementname'].length;
while(i--){
if(document.forms['formname'].elements['elementname'][i]){
return true;
}
}
alert('you haven\'t selected anything.. ');
return false;
/script
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184565
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: loop over form objects - using JavaScript - Client Validation
This line should be different.. made a typo
if(document.forms['formname'].elements['elementname'][i]){
Must be
if(document.forms['formname'].elements['elementname'][i].checked){
You are checking for the bool checked..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184566
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: loop over form objects - using JavaScript - Client Validation
my elements are named differently.
the first checkbox for example is r_20, next is r_21, r_22, r_23, etc.
Will this work with that in mind?
On Wed, 17 Nov 2004 14:32:35 +0100, Micha Schopman
[EMAIL PROTECTED] wrote:
This line should be different.. made a typo
if(document.forms['formname'].elements['elementname'][i]){
Must be
if(document.forms['formname'].elements['elementname'][i].checked){
You are checking for the bool checked..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184567
Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
It would be intersting to hear how the meeting went and what the issues and context was for them to consider scrapping 11 months of development, if you are able to share that is. Thanks, Dan On Wed, 17 Nov 2004 13:36:12 +0100, Micha Schopman [EMAIL PROTECTED] wrote: Btw .. I am also in the middle of two fights,.. I have build the lasts 11 months intensively on a huge inhouse ColdFusion product (about 2000+ CFC's and CFM files) , and chances are high because it gets cancelled due to company strategy changes (towards Microsoft), so Thursday I have to literally fight for the product in a meeting with company management. This would mean all 80 customers on the system will be ported to ASP.NET, .. and ofcourse I have not spend those lasts freakn 11 months on building the project. ;) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184568 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: loop over form objects - using JavaScript - Client Validation
I adapted your function to work...
for(i=cfoutput#sweeps.minval#/cfoutput;i =
cfoutput#sweeps.maxval#/cfoutput; i++)
{
if(document.forms['sweeps'].elements['r_'+i].checked)
{
return true;
}
}
alert('you haven\'t selected anything.. ');
return false;
Thanks, I appreciate it.
On Wed, 17 Nov 2004 07:36:30 -0600, Greg Morphis [EMAIL PROTECTED] wrote:
my elements are named differently.
the first checkbox for example is r_20, next is r_21, r_22, r_23, etc.
Will this work with that in mind?
On Wed, 17 Nov 2004 14:32:35 +0100, Micha Schopman
[EMAIL PROTECTED] wrote:
This line should be different.. made a typo
if(document.forms['formname'].elements['elementname'][i]){
Must be
if(document.forms['formname'].elements['elementname'][i].checked){
You are checking for the bool checked..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184569
Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
I'll post the results here once we're done. I guess our issues are exactly the same as with any other company selling ColdFusion, customers choose the safety of the brand Microsoft instead of using their brains and comparing the results with the costs. That's how it works unfortunately, it is easier for a manager to explain his manager he has failed with a Microsoft project than it is with a ColdFusion project (sounds ridiculous does it?). Then ofcourse we have the sales team, aware of ColdFusion as a product but knowing the M name saves their sales pitch, and knowing the M name enables them to raise prices. :) .. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184570 Archives: http://www.houseoffusion.com/cf_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: Update multiple rows
Below is a link for a DHTML/Javascript spreadsheet. At the same site, I found a DHTML/Javascript slider that I modified to work. You may be able to do the same with this. http://www.blueshoes.org/en/javascript/spreadsheet/ J -Original Message- I need to write an app where the user can update multipe rows from one screen - like a GRID (but not using CFGRID or similar tags) - needs to be table based. I need a starting point to learn how to do this. Can anyone point me to suitable articles, tutes etc Thank you muchly ++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184571 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
wouldnt using the words safety and microsoft in the same sentence and have a direct meaning to one another be slanderous statement? makes me wanna barfff thats funny, the perception that is. and thats the exact route i would take to fight it. running it on a windows server pretty much puts a target on your back, wouldnt it be safer to run cfm on a linux server? Not to mention their constant updating woes. and then before u mentioned something about not knowing if what ur proposing will even be around in a few yrs. u mean like m$ did with asp? and im sure will do again with .net coldfusion was here before asp (if i recall correctly) and it still here now it will be here tomorrow, i wouldnt put a mexican peso on .net out living cfm. im sure the next version will be called .shortNet haha -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Nov 2004 14:45:49 +0100 I'll post the results here once we're done. I guess our issues are exactly the same as with any other company selling ColdFusion, customers choose the safety of the brand Microsoft instead of using their brains and comparing the results with the costs. That's how it works unfortunately, it is easier for a manager to explain his manager he has failed with a Microsoft project than it is with a ColdFusion project (sounds ridiculous does it?). Then ofcourse we have the sales team, aware of ColdFusion as a product but knowing the M name saves their sales pitch, and knowing the M name enables them to raise prices. :) .. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184572 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Not so much outlive anything but going back to topic. count number of sales reps/evangelisers for CF in Australia count number of sales reps/evanglisers for Microsoft/ ASP.NET in Australia Simple.. make a call to noth and see who turns up on your doorstep first pluggin their wares. I LOVE CF but Macromedia need to plan on Total Global Coverge, besides.. I recon a few Macromeedies from London wouldnt mind spending a stint in Oz ;) MD On Wed, 17 Nov 2004 08:59:43 -0500, dave [EMAIL PROTECTED] wrote: wouldnt using the words safety and microsoft in the same sentence and have a direct meaning to one another be slanderous statement? makes me wanna barfff thats funny, the perception that is. and thats the exact route i would take to fight it. running it on a windows server pretty much puts a target on your back, wouldnt it be safer to run cfm on a linux server? Not to mention their constant updating woes. and then before u mentioned something about not knowing if what ur proposing will even be around in a few yrs. u mean like m$ did with asp? and im sure will do again with .net coldfusion was here before asp (if i recall correctly) and it still here now it will be here tomorrow, i wouldnt put a mexican peso on .net out living cfm. im sure the next version will be called .shortNet haha -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Nov 2004 14:45:49 +0100 I'll post the results here once we're done. I guess our issues are exactly the same as with any other company selling ColdFusion, customers choose the safety of the brand Microsoft instead of using their brains and comparing the results with the costs. That's how it works unfortunately, it is easier for a manager to explain his manager he has failed with a Microsoft project than it is with a ColdFusion project (sounds ridiculous does it?). Then ofcourse we have the sales team, aware of ColdFusion as a product but knowing the M name saves their sales pitch, and knowing the M name enables them to raise prices. :) .. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184573 Archives: http://www.houseoffusion.com/cf_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: ESCROW / source code license for CF or BD
Yes, we have standard arrangements for source code escrow for BlueDragon. Contact our sales team at [EMAIL PROTECTED] for more info. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 7:37 AM To: CF-Talk Subject: ESCROW / source code license for CF or BD Does anybody know if Macromedia or NewAtlanta offer source code licenses for their CF application servers? Under Dutch privacy law processing certain types of information requires you to have ESCROW access to the source code in case the vendor goes belly up. Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184574 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
Well.. I must say, and that is because I do both, Microsoft has done a tremendous job with asp.net. Seriously, you must have worked with it to be impressed, and I am not quickly impressed, but this time they've put something on the market which really has alot of potential. The development tools need some (some=alot) work, but overall for such a young platform it is very promising, and it feels and performs very mature. The availability of controls, community support, frameworks and customers is very high. The stability of Windows boxes is another question, and also on this point, we run several Win2K3 boxes under high load and the stability is really awesome. Well, thursday we'll see what the strategy will be, but I have a bad feeling about it. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184575 Archives: http://www.houseoffusion.com/cf_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: Backup MySQL DB... and restore ;-(
Marco Antonio C. Santos wrote: Hi all I want to backup my database to a file that is just like a SQL dump. With mysqldump I can do that. Easy. Then, I just want to be able to execute that .sql file when I need to restore my database... with CF... What do you think about? Aside from using mysqldump, you could also get the freebie version of sqlyog 4.0. I have to be honest and say I haven't looked at it that much, but it does look very nice! Much nice than the pervious versions I've got kicking around here. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184576 Archives: http://www.houseoffusion.com/cf_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
How do I rewrite this as a join query?
Good morning, all... I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Select CAL.EmailAddress from classroom_access_list CAL where CAL.EmailAddress not in (Select S.EmailAddress from staff S) What I'm after is a query that gives me all the email addresses in the classroom_access_list table and the staff table without duplicates... I've been working on the join approach, but those things just elude my logic for some reason...can't wait until I'm ready to move to MySQL 4.1, which supports subqueries... Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184577 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
I LOVE CF but Macromedia need to plan on Total Global Coverge, besides.. I recon a few Macromeedies from London wouldnt mind spending a stint in Oz ;) ~lol~ You know there aren't that many MM employees in the UK any more (I think its 3 now) and I believe one of those is an escapee... errr I mean Australian anyway. ;oD Steal some of the american staff instead. ;op ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184578 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What sets the domain in default CFID cookies?
Is there any chance that the host names are changing across your web site? Using both www.xyz.com and xyz.com will cause different sets of cookies to be used, even if you use domain cookies. (But www.xyz.com and abc.xyz.com will share cookies when domain cookies are used.) Mark -Original Message- From: Nick Cabell [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 2:43 AM To: CF-Talk Subject: What sets the domain in default CFID cookies? I'm having real trouble with my sessions and cookies. I can observe the CFID/CFTOKEN cookies get set in my browser. They are set twice, once when I come to the home page and then again when I login. But the confusing part is why the domain name is host.net for one pair and then WWW.host.net for the other. Can someone explain to me what sets the domain value for these cookies? I am concerned that this is why my session variables seem to be incorrect, as if there were a shadow session associated with the different CFID/CTOKEN. Also what determines the expiration - it's 30 years now. I don't use CFCOOKIE because the CFID/CFTOKEN are set automatically. I have the following application.cfm (two of them - one at root and one below it, but both with the same cfapplication tag) cfapplication name=mes clientmanagement=No loginstorage=Session sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0, 1, 1, 0)# ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184579 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and walks away.
I rest my case :D Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184580 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
At 09:24 AM 11/17/2004, Rick Faircloth wrote: Good morning, all... I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Select CAL.EmailAddress from classroom_access_list CAL where CAL.EmailAddress not in (Select S.EmailAddress from staff S) What I'm after is a query that gives me all the email addresses in the classroom_access_list table and the staff table without duplicates... Not too sure, but something like SELECT DISTINCT EmailAddress FROM SELECT EmailAddress FROM classroom_access_list UNION SELECT EmailAddress FROM staff Since you don't want the two sets of results to actually key together, a union makes more sense: just append the results of one to the bottom of the other. Then the distinct will find all the unique ones. However I just realized that this may count as a subquery too! Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | | Do you like Evite? This is better: http://RSVPtracker.com/| +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184581 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
Without subqueries, I think it is easiest just to use CF's Query of Queries. This is close to what you need: The trick is the last query It uses both queries to filter the results. cfquery name=excludeStaffEmail datasource=myDataSource SELECT S.EmailAddress FROM staff S /cfquery cfquery name=allEmail datasource=myDataSource SELECT CAL.EmailAddress FROM classroom_access_list CAL /cfquery cfquery dbtype=query SELECT * FROM allEmail OUTER JOIN excludeStaffEmail WHERE allEmail.EmailAddress != excludeStaffEmail.EmailAddress /cfquery Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 8:25 AM To: CF-Talk Subject: How do I rewrite this as a join query? Good morning, all... I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Select CAL.EmailAddress from classroom_access_list CAL where CAL.EmailAddress not in (Select S.EmailAddress from staff S) What I'm after is a query that gives me all the email addresses in the classroom_access_list table and the staff table without duplicates... I've been working on the join approach, but those things just elude my logic for some reason...can't wait until I'm ready to move to MySQL 4.1, which supports subqueries... Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184582 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
Sorry I didn't mention this before, but I'm on CF 4.5.2...no Q of Q's available... :o( Rick -Original Message- From: Ryan Duckworth [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 9:47 AM To: CF-Talk Subject: RE: How do I rewrite this as a join query? Without subqueries, I think it is easiest just to use CF's Query of Queries. This is close to what you need: The trick is the last query It uses both queries to filter the results. cfquery name=excludeStaffEmail datasource=myDataSource SELECT S.EmailAddress FROM staff S /cfquery cfquery name=allEmail datasource=myDataSource SELECT CAL.EmailAddress FROM classroom_access_list CAL /cfquery cfquery dbtype=query SELECT * FROM allEmail OUTER JOIN excludeStaffEmail WHERE allEmail.EmailAddress != excludeStaffEmail.EmailAddress /cfquery Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 8:25 AM To: CF-Talk Subject: How do I rewrite this as a join query? Good morning, all... I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Select CAL.EmailAddress from classroom_access_list CAL where CAL.EmailAddress not in (Select S.EmailAddress from staff S) What I'm after is a query that gives me all the email addresses in the classroom_access_list table and the staff table without duplicates... I've been working on the join approach, but those things just elude my logic for some reason...can't wait until I'm ready to move to MySQL 4.1, which supports subqueries... Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184582 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184583 Archives: http://www.houseoffusion.com/cf_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
Output by Fiscal Quarter
I have a recordset that I would like to output by Fiscal Qaurter. The query has a condition to pull only records where the year part of the DATE_CREATED value equals the passed in year (@filterYear). Id like to output the records by Fiscal Qtr: FY04 ---QTR1 [Jan-Mar] -record 1 -record 2 -record 3 -record 4 -record 5 ---QTR2 [Apr-Jun] -record 1 -record 2 -record 3 -record 4 -record 5 ---QTR3 [Jul-Sep] -record 1 -record 2 -record 3 -record 4 -record 5 ---QTR4 [Oct-Dec] -record 1 -record 2 -record 3 -record 4 -record 5 How would I go about this in the SQL? I am using SQL Server 2K. Thanks, Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184584 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
MySQL didn't like that one...got a syntax error... Rick -Original Message- From: Anders Green [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 9:41 AM To: CF-Talk Subject: Re: How do I rewrite this as a join query? At 09:24 AM 11/17/2004, Rick Faircloth wrote: Good morning, all... I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Select CAL.EmailAddress from classroom_access_list CAL where CAL.EmailAddress not in (Select S.EmailAddress from staff S) What I'm after is a query that gives me all the email addresses in the classroom_access_list table and the staff table without duplicates... Not too sure, but something like SELECT DISTINCT EmailAddress FROM SELECT EmailAddress FROM classroom_access_list UNION SELECT EmailAddress FROM staff Since you don't want the two sets of results to actually key together, a union makes more sense: just append the results of one to the bottom of the other. Then the distinct will find all the unique ones. However I just realized that this may count as a subquery too! Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | | Do you like Evite? This is better: http://RSVPtracker.com/| +===+ ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184585 Archives: http://www.houseoffusion.com/cf_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: Output by Fiscal Quarter (SOLVED)
From: Tangorre, Michael [mailto:[EMAIL PROTECTED] I have a recordset that I would like to output by Fiscal Qaurter. The query has a condition to pull only records where the year part of the DATE_CREATED value equals the passed in year (@filterYear). Nevermind. Used to UDFs. All set. Michael T. Tangorre ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184586 Archives: http://www.houseoffusion.com/cf_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
Image color info?
Anyone know of a way to determine color format in an image with cf. I need to know if a file is cmyk or rgb. Thanks, Emmet ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184587 Archives: http://www.houseoffusion.com/cf_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
Verity Installation Problem
Hi, I have recently installed CFMX 6.1 on a server that was locked down by the hosting company. The server already had CF5 running and I wanted to be able to run the two versions on the same box. The server was installe in JRun Mode and I have now set up a new virtual server that uses CFMX while the exsiting virtual server is running CF5 All seems Ok except the verity pages which says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I read the manual and it says that verity must have a couple of lines added to the JRun parameters. I checked and they are already there. Anyone know what else I should be looking for ? -- Kevin Roche ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184588 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
Btw .. I am also in the middle of two fights,.. I have build the lasts 11 months intensively on a huge inhouse ColdFusion product (about 2000+ CFC's and CFM files) , and chances are high because it gets cancelled due to company strategy changes (towards Microsoft), so Thursday I have to literally fight for the product in a meeting with company management. This would mean all 80 customers on the system will be ported to ASP.NET, .. and ofcourse I have not spend those lasts freakn 11 months on building the project. ;) If that's how things turn out for you, you should seriously consider using BlueDragon.NET to preserve some or all of your investment in your current codebase. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184589 Archives: http://www.houseoffusion.com/cf_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: Verity Installation Problem
What O/S? On Windows you will need to enable Verity via the Command Prompt to be a Windows Service (if you want it to be). -Original Message- From: kevin roche [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 15:26 To: CF-Talk Subject: Verity Installation Problem Hi, I have recently installed CFMX 6.1 on a server that was locked down by the hosting company. The server already had CF5 running and I wanted to be able to run the two versions on the same box. The server was installe in JRun Mode and I have now set up a new virtual server that uses CFMX while the exsiting virtual server is running CF5 All seems Ok except the verity pages which says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I read the manual and it says that verity must have a couple of lines added to the JRun parameters. I checked and they are already there. Anyone know what else I should be looking for ? -- Kevin Roche ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184590 Archives: http://www.houseoffusion.com/cf_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: CFMX and Access Databases
That was the first driver I tried. It looks like I might have to move towards buying an JDBC Driver for Access from some company. Unless I can get this solved to give me the time I need to migrate to SQL. Have you also tried the regular Microsoft Access datasource option, then? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184591 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Well, here's a clumsy idea that gets the job done. Do an outer join (don't know the exact syntax for MySQL) that gets you two columns in each row: email address from classroom_access_list and email address from classroom_access_list. In your output, you just say if column 1 is blank, use column 2, otherwise, use column 1. The values will be deduped by virtue of the fact that equal values will collapse into a single row. HTH, Matthieu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184592 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
well did u not say to give u one feature that php or .net doesnt have? so i did, cfc's, isnt that what u asked for? and thats a friggin pretty BIG feature wouldnt u say? Uh, that's just a language-specific implementation of a feature - the ability to write class templates. You can certainly write classes in .NET, and to be perfectly honest if what you really care about is writing OO code using classes, you'd probably prefer .NET (or Java) to CFML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184593 Archives: http://www.houseoffusion.com/cf_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: Image color info?
Emmet, I don't know as I've ever seen a .gif or .jpg that was ever cmyk (only time I ever really see .png is within a Flash movie). I know when I open various ones within PS and look at the Mode under the Image menu all of them appear to be either RGB or Indexed color. I also know that, when transferring an image from PS to ImageReady, to make a web ready image, it always stops me if the image isn't already RGB. Somebody stop me if I'm wrong here. Hope some of this helps. Now if the image you are testing is not a native web format image (.tiff, .pdf, etc.), that might be a different story... Cutter Emmet McGovern wrote: Anyone know of a way to determine color format in an image with cf. I need to know if a file is cmyk or rgb. Thanks, Emmet ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184594 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
I think your Union query worked, Anders. MySQL wasn't returning an error and I was basing its success on the number of email addresses returned...what I forgot was that I was looking at the number of addresses in my development database instead of the production database...which is about 68 and 700 respectively... Thanks! Rick -Original Message- From: Anders Green [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 9:41 AM To: CF-Talk Subject: Re: How do I rewrite this as a join query? At 09:24 AM 11/17/2004, Rick Faircloth wrote: Good morning, all... I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Select CAL.EmailAddress from classroom_access_list CAL where CAL.EmailAddress not in (Select S.EmailAddress from staff S) What I'm after is a query that gives me all the email addresses in the classroom_access_list table and the staff table without duplicates... Not too sure, but something like SELECT DISTINCT EmailAddress FROM SELECT EmailAddress FROM classroom_access_list UNION SELECT EmailAddress FROM staff Since you don't want the two sets of results to actually key together, a union makes more sense: just append the results of one to the bottom of the other. Then the distinct will find all the unique ones. However I just realized that this may count as a subquery too! Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | | Do you like Evite? This is better: http://RSVPtracker.com/| +===+ ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184595 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
At 10:40 AM 11/17/2004, Rick Faircloth wrote: I think your Union query worked, Anders. A la Stewie from the Family Guy cartoon: HA! Victory is mine! ;) Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | | Do you like Evite? This is better: http://RSVPtracker.com/| +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184596 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
what else has progressed as much as cfm in the last yr or so? .net not much php - nope jsp - nope actually probably gone done now that cfm can play with jsp cgi? Lol Well, actually, have you checked out ASP.NET 2.0? There's quite a bit of new stuff coming there. Likewise, in the JSP world, there are all kinds of relatively new things like JavaServer Faces. I don't know enough about PHP 5 to comment on it, but PHP fans are very excited about new features there. cfc's, remoting, j2ee deployment, flash forms, the new print functions, new reporting functions, flex intrgration, not to mention that flex flash are really build around using coldfusion as the backend Most of the things you mention here aren't really specific to CF. CFCs are essentially just classes, you can use remoting with J2EE or .NET (and pay less for those packages than you would for CF), you can do fantastic reporting from ASP.NET using the new MS SQL Server Reporting Services (which are also available through CF). Neither Flex nor Flash is built around using CF as the back end, either - you can use practically anything to get your data into Flex. Personally, I really like CF, as you do. I'm very excited about Blackstone, especially with regard to the asynchronous processing stuff like event gateways. But I don't let that blind me to the fact that there are lots of other competitive products out there, and neither should you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184597 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
Not so much outlive anything but going back to topic. count number of sales reps/evangelisers for CF in Australia count number of sales reps/evanglisers for Microsoft/ ASP.NET in Australia Simple.. make a call to noth and see who turns up on your doorstep first pluggin their wares. I LOVE CF but Macromedia need to plan on Total Global Coverge, besides.. I recon a few Macromeedies from London wouldnt mind spending a stint in Oz ;) Do you really expect Macromedia to be able to field as many product evangelists as Microsoft? Is that realistic? Would you be happy to cover their salaries by paying significantly more for CF? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184598 Archives: http://www.houseoffusion.com/cf_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: Image color info?
That's the issue. The app I'm writing is a file manager for a print company. It will index all image formats. The feature isn't mission critical; I could always have them add the attribute on file upload. I was just hoping to lose a few steps in between. -Original Message- From: Cutter (CF related) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 10:47 AM To: CF-Talk Subject: Re: Image color info? Emmet, I don't know as I've ever seen a .gif or .jpg that was ever cmyk (only time I ever really see .png is within a Flash movie). I know when I open various ones within PS and look at the Mode under the Image menu all of them appear to be either RGB or Indexed color. I also know that, when transferring an image from PS to ImageReady, to make a web ready image, it always stops me if the image isn't already RGB. Somebody stop me if I'm wrong here. Hope some of this helps. Now if the image you are testing is not a native web format image (.tiff, .pdf, etc.), that might be a different story... Cutter Emmet McGovern wrote: Anyone know of a way to determine color format in an image with cf. I need to know if a file is cmyk or rgb. Thanks, Emmet ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184599 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
I don't know much about MySql but can you do this?
cfquery name=emailList
Select S.EmailAddress from staff S
/cfquery
cfquery name=whatever
Select CAL.EmailAddress
from classroom_access_list CAL
where CAL.EmailAddress
not in ('#ValueList(emailList.EmailAddress, ',')#')
/cfquery
Phillip b.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184600
Archives: http://www.houseoffusion.com/cf_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: Image color info?
I don't know as I've ever seen a .gif or .jpg that was ever cmyk (only time I ever really see .png is within a Flash A gif can't be CMYK, it can't be RGB either, a gif is by definition an indexed format with it's own colour palette. A jpg can be either RGB or CMYK but will not be displayed in IE or Netscape if it is CMYK, you usually only see it when you receive graphics from Mac using graphic designers used to designing for print and not appreciating the difference in designing for screen use. -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184601 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
Dave, PHP 5 has some mayor (and I mean really mayor) changes regarding OO development, with true classes and full OO support. That is why the PHP crowd goes mad. Personally, I really like CF, as you do. I'm very excited about Blackstone, especially with regard to the asynchronous processing stuff like event gateways. But I don't let that blind me to the fact that there are lots of other competitive products out there, and neither should you. Bingo... Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184602 Archives: http://www.houseoffusion.com/cf_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: Image color info?
Look for something like ImageMagik on the Net, there are a few nice apps/tags out there which do this. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 15:49 To: CF-Talk Subject: RE: Image color info? That's the issue. The app I'm writing is a file manager for a print company. It will index all image formats. The feature isn't mission critical; I could always have them add the attribute on file upload. I was just hoping to lose a few steps in between. -Original Message- From: Cutter (CF related) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 10:47 AM To: CF-Talk Subject: Re: Image color info? Emmet, I don't know as I've ever seen a .gif or .jpg that was ever cmyk (only time I ever really see .png is within a Flash movie). I know when I open various ones within PS and look at the Mode under the Image menu all of them appear to be either RGB or Indexed color. I also know that, when transferring an image from PS to ImageReady, to make a web ready image, it always stops me if the image isn't already RGB. Somebody stop me if I'm wrong here. Hope some of this helps. Now if the image you are testing is not a native web format image (.tiff, .pdf, etc.), that might be a different story... Cutter Emmet McGovern wrote: Anyone know of a way to determine color format in an image with cf. I need to know if a file is cmyk or rgb. Thanks, Emmet ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184603 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
Euhmm.. ASP.NET? PHP? Name one thing that cannot be done on these platforms and can be done with ColdFusion. Clean, painless J2EE integration? The fact is, you can do pretty much anything with any of these products. The hands-down advantage of CF, in my opinion, is that you can do most of the common, important things very easily. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184604 Archives: http://www.houseoffusion.com/cf_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: apache and muliple CF instances
I did find that I could setup virtual hosts on the same domain under different ports and 'map' seperate CF instances to them. Then mod_rewrite can be employed to move requests from foo.com/home to foo.com and foo.com/yourhome to foo.com:88. Out of curiosity, why do you want separate virtual hosts at all? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What sets the domain in default CFID cookies?
I guess I'm not sure what would cause them to change, but I can see the result of it in the different cookies. Doesn't happen on dev machine where it is always localhost. What determines the domain value for CFIF/CFTOKEN cookies and how can I prevent it? Is there any chance that the host names are changing across your web site? Using both www.xyz.com and xyz.com will cause different sets of cookies to be used, even if you use domain cookies. (But www.xyz. com and abc.xyz.com will share cookies when domain cookies are used.) Mark ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184606 Archives: http://www.houseoffusion.com/cf_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: Image color info?
I wrote the original question assuming everyone knew I was talking about jpg. Although it would be nice to be able to determine ai, tiff, psd, eps but I can just assume that they are cmyk to begin with and so can the printer. The problem exists with reading any jpg's in the directory. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 10:51 AM To: CF-Talk Subject: RE: Image color info? I don't know as I've ever seen a .gif or .jpg that was ever cmyk (only time I ever really see .png is within a Flash A gif can't be CMYK, it can't be RGB either, a gif is by definition an indexed format with it's own colour palette. A jpg can be either RGB or CMYK but will not be displayed in IE or Netscape if it is CMYK, you usually only see it when you receive graphics from Mac using graphic designers used to designing for print and not appreciating the difference in designing for screen use. -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184607 Archives: http://www.houseoffusion.com/cf_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: Verity Installation Problem
- Forwarded message from [EMAIL PROTECTED] - Date: Wed, 17 Nov 2004 16:02:46 + From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Subject: Not Subscribed: RE: Verity Installation Problem To: [EMAIL PROTECTED] You are not subscribed to the CF-Talk list with the address [EMAIL PROTECTED] To add this address to your profile, please visit the sign in page at http://www.houseoffusion.com/signin/ Return-Path: [EMAIL PROTECTED] Received: from nmail1.systems.pipex.net ([62.241.160.130]) by hof001.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Wed, 17 Nov 2004 11:04:35 -0500 Received: from nmail1.systems.pipex.net (localhost [127.0.0.1]) by nmail1.systems.pipex.net (8.12.10/8.12.10) with ESMTP id iAHG2kre023121 for [EMAIL PROTECTED]; Wed, 17 Nov 2004 16:02:46 GMT Received: (from [EMAIL PROTECTED]) by nmail1.systems.pipex.net (8.12.10/8.12.10/Submit) id iAHG2kih023120 for [EMAIL PROTECTED]; Wed, 17 Nov 2004 16:02:46 GMT Neil, It is Windows, but I never needed to do that before. Any ideas why this is different? How do I do I make it a Windows Service? What if I don't want to do that? Kevin Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: What O/S? On Windows you will need to enable Verity via the Command Prompt to be a Windows Service (if you want it to be). -Original Message- From: kevin roche [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 15:26 To: CF-Talk Subject: Verity Installation Problem Hi, I have recently installed CFMX 6.1 on a server that was locked down by the hosting company. The server already had CF5 running and I wanted to be able to run the two versions on the same box. The server was installe in JRun Mode and I have now set up a new virtual server that uses CFMX while the exsiting virtual server is running CF5 All seems Ok except the verity pages which says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I read the manual and it says that verity must have a couple of lines added to the JRun parameters. I checked and they are already there. Anyone know what else I should be looking for ? -- Kevin Roche ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184608 Archives: http://www.houseoffusion.com/cf_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: How do I rewrite this as a join query?
Rick Faircloth wrote: I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Select CAL.EmailAddress from classroom_access_list CAL where CAL.EmailAddress not in (Select S.EmailAddress from staff S) What I'm after is a query that gives me all the email addresses in the classroom_access_list table and the staff table without duplicates... I've been working on the join approach, but those things just elude my logic for some reason...can't wait until I'm ready to move to MySQL 4.1, which supports subqueries... SELECT DISTINCT COALESCE(s.EmailAddress, cal.EmailAddress) EmailAddress FROMclassroom_access_list cal FULL OUTER JOIN staff s ON s.EmailAddress = cal.EmailAddress Or something like that. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184609 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
I'll post the results here once we're done. I guess our issues are exactly the same as with any other company selling ColdFusion, customers choose the safety of the brand Microsoft instead of using their brains and comparing the results with the costs. That's how it works unfortunately, it is easier for a manager to explain his manager he has failed with a Microsoft project than it is with a ColdFusion project (sounds ridiculous does it?). Then ofcourse we have the sales team, aware of ColdFusion as a product but knowing the M name saves their sales pitch, and knowing the M name enables them to raise prices. :) .. Unfortunately, you're correct about this. However, it's not really ridiculous at all. People have a limited amount of time to learn about competing products, so all things being equal you're better off choosing the product from the company you know about rather than the one you don't. The key to success here is not to fail with your CF projects. Of course, that's easy to say, but I think that's really your only hope. I prefer CF to .NET simply because I think projects are more likely to succeed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184610 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
wouldnt using the words safety and microsoft in the same sentence and have a direct meaning to one another be slanderous statement? makes me wanna barfff thats funny, the perception that is. and thats the exact route i would take to fight it. running it on a windows server pretty much puts a target on your back, wouldnt it be safer to run cfm on a linux server? Not to mention their constant updating woes. This kind of visceral, irrational anti-MS sentiment doesn't really help sell non-MS products. Lots of people use MS products successfully and safely, and just dismiss any rational arguments you might actually have if they're preceded by this. Lots of people run secure Windows servers, and lots of people run insecure Linux servers. and then before u mentioned something about not knowing if what ur proposing will even be around in a few yrs. u mean like m$ did with asp? and im sure will do again with .net Classic ASP is still here - there's nothing stopping you from running your ASP applications on Windows Server 2003, for example. Most web applications have a relatively short lifespan anyway. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184611 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
rant No, that I wouldnt but surely Australia (and probably that includes New Zealand and South Africa) is a large enough area to need more than one person out there.. then again its a demand vs supply thing. Here in spain CF is pretty low (where I am at any rate) But I know that in the capital there is more activity. I am sure that one MM person for the whole of Europe would be a kinda small testimate. It would sadden me to see MM leave any territory, but as has been said in this list, survive or die. If PHP is becoming glorious (no ££ to buy and avalable on nearly all platforms) its an amazing testament to no marketing forces right? With the ASP.NET stuff I am kinda dubious as has been said before but then again Microsoft can aford to saturate and do what the hell it likes as it can make it a loss leader just so that people have to buy Visual Studio. Would MM do that to Coldfusion to let them sell more licences for Dreamweaver? Maybe ship a free version of CF with every copy of dreamweaver? I think CF and the related technologies (fusebox for example) is great, love it. but is MM really on the decline financially? (not rethorical question.. I simply dont know or have the time to check out) As the market fragments I think CF wil find its niche (look at the proposed features of Blackstone) and work it until that dries up and then change the feature focus. As with any product really. /rant plug I hope CF and MM keep gonig.. means that more people get to use CFEclipse! /plug My 50 eurocents worth MD On Wed, 17 Nov 2004 10:55:27 -0500, Dave Watts [EMAIL PROTECTED] wrote: Not so much outlive anything but going back to topic. count number of sales reps/evangelisers for CF in Australia count number of sales reps/evanglisers for Microsoft/ ASP.NET in Australia Simple.. make a call to noth and see who turns up on your doorstep first pluggin their wares. I LOVE CF but Macromedia need to plan on Total Global Coverge, besides.. I recon a few Macromeedies from London wouldnt mind spending a stint in Oz ;) Do you really expect Macromedia to be able to field as many product evangelists as Microsoft? Is that realistic? Would you be happy to cover their salaries by paying significantly more for CF? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184612 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
Dave nailed it here: The fact is, you can do pretty much anything with any of these products. The hands-down advantage of CF, in my opinion, is that you can do most of the common, important things very easily. 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/54 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184613 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
Their stocks aren't doing too bad. http://finance.yahoo.com/q?s=MACR On Wed, 17 Nov 2004 08:20:24 -0800, Bryan Stevenson [EMAIL PROTECTED] wrote: Dave nailed it here: The fact is, you can do pretty much anything with any of these products. The hands-down advantage of CF, in my opinion, is that you can do most of the common, important things very easily. 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/54 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184614 Archives: http://www.houseoffusion.com/cf_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: Macromedia gives up on the server market in Australia and wal ks away.
yeah... when I first started years ago as a rookie, I could not believe how easy it was to connect to a db and write out your queries freely without worrying about line breaks, not appending correctly, etc. and all inside a tag to boot. [EMAIL PROTECTED] 11/17/2004 8:20:24 AM Dave nailed it here: The fact is, you can do pretty much anything with any of these products. The hands-down advantage of CF, in my opinion, is that you can do most of the common, important things very easily. 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/54 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184615 Archives: http://www.houseoffusion.com/cf_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
DevNet Version of CFMX adds rubbish to the start of my HTML.
Hi, I am trying to build pages for the first time with XHTML and the validators in both Homesite and Dreamweaver seem only to do half the job. I am trying to point the W3C validator at my development machine which is running the multiuser devnet version of my site but the server adds an extra line at the front of the file and the result is invalid. Anyone know how to get rid of the line? META NAME=ColdFusionMXEdition CONTENT=ColdFusion DevNet Edition - Not for Production Use. The MM site says use cfcontent to make the file text/xml but then it does not work in a browser and I need to have both. -- Kevin Roche ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184616 Archives: http://www.houseoffusion.com/cf_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
Verity Search string assistance
We are still using CF5 and the built in verity engine with excellent success. However, every once in a while the search page generates an error within the cfsearch tag that tells us that an invalid character was passed in the search string. We have written a filter that removes non-alphanumeric characters from the search string, but every now and then someone finds a way to enter a search string that our filter doesn't catch and generates an error. Does anyone have a definitive filter for the search string that will insure that CFSearch will not complain? Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184617 Archives: http://www.houseoffusion.com/cf_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: apache and muliple CF instances
We have a server on our intranet hosting several CF apps all under one CFMX instance. A couple of these apps have grown in popularity and I'd like to run thme under a seperate CFMX instance BUT retain the URL path. Running https too, so IIRC, can't use host headers. We are using IIS now, can add a new site but has to be a diff port, hence the URL path changes. Looks like I'll just have to work with a redirect and get everyone to add a new bookmark, eh? Doug On Wed, 17 Nov 2004 11:10:18 -0500, Dave Watts [EMAIL PROTECTED] wrote: I did find that I could setup virtual hosts on the same domain under different ports and 'map' seperate CF instances to them. Then mod_rewrite can be employed to move requests from foo.com/home to foo.com and foo.com/yourhome to foo.com:88. Out of curiosity, why do you want separate virtual hosts at all? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184618 Archives: http://www.houseoffusion.com/cf_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: Verity Search string assistance
http://www.cflib.org/udf.cfm?ID=760 Enjoy On Wed, 17 Nov 2004 11:33:44 -0500, Dennis Powers [EMAIL PROTECTED] wrote: We are still using CF5 and the built in verity engine with excellent success. However, every once in a while the search page generates an error within the cfsearch tag that tells us that an invalid character was passed in the search string. We have written a filter that removes non-alphanumeric characters from the search string, but every now and then someone finds a way to enter a search string that our filter doesn't catch and generates an error. Does anyone have a definitive filter for the search string that will insure that CFSearch will not complain? Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184619 Archives: http://www.houseoffusion.com/cf_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: Image color info?
I think http://www.intrafoundation.com/CFX_ImageInfoMX.asp will do what you ask. -- Jay -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 16:03 To: CF-Talk Subject: RE: Image color info? I wrote the original question assuming everyone knew I was talking about jpg. Although it would be nice to be able to determine ai, tiff, psd, eps but I can just assume that they are cmyk to begin with and so can the printer. The problem exists with reading any jpg's in the directory. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 10:51 AM To: CF-Talk Subject: RE: Image color info? I don't know as I've ever seen a .gif or .jpg that was ever cmyk (only time I ever really see .png is within a Flash A gif can't be CMYK, it can't be RGB either, a gif is by definition an indexed format with it's own colour palette. A jpg can be either RGB or CMYK but will not be displayed in IE or Netscape if it is CMYK, you usually only see it when you receive graphics from Mac using graphic designers used to designing for print and not appreciating the difference in designing for screen use. -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184620 Archives: http://www.houseoffusion.com/cf_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: apache and muliple CF instances
We have a server on our intranet hosting several CF apps all under one CFMX instance. A couple of these apps have grown in popularity and I'd like to run thme under a seperate CFMX instance BUT retain the URL path. Running https too, so IIRC, can't use host headers. We are using IIS now, can add a new site but has to be a diff port, hence the URL path changes. Looks like I'll just have to work with a redirect and get everyone to add a new bookmark, eh? Why not just use one virtual web server connected to two different CFMX/JRun instances using different context roots? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184621 Archives: http://www.houseoffusion.com/cf_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: payment gateway question
nobody every heard of them? On Tue, 16 Nov 2004 15:18:56 -0800, DRE [EMAIL PROTECTED] wrote: Hi, I have a client who wants to run credit cards thru a processor / gateway called WorkSmartPros.com who uses Cornerstone as their Merchant processor. Anybody got any feedback on these people and how easy it is to deal with their system, uptime, etc? Or perhaps I should be asking for best recomendations. She seems to think that authorize.net is more expensive. Thanks. -- DRE www.webmachineinc.com www.theanticool.com -- DRE www.webmachineinc.com www.theanticool.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184622 Archives: http://www.houseoffusion.com/cf_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: Image color info?
I totally forgot about that site. It should get the wacky cf site of the millennia award. Or something like that. I put together a nice server manager with his hosting toolkit a long time ago. I wonder if any of that stuff works with IIS/win2003 these days. BTW... the tag works like a charm. Hopefully the server will appreciate the atomic warfare that I've unleashed upon it. -e -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 11:55 AM To: CF-Talk Subject: RE: Image color info? I think http://www.intrafoundation.com/CFX_ImageInfoMX.asp will do what you ask. -- Jay -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 16:03 To: CF-Talk Subject: RE: Image color info? I wrote the original question assuming everyone knew I was talking about jpg. Although it would be nice to be able to determine ai, tiff, psd, eps but I can just assume that they are cmyk to begin with and so can the printer. The problem exists with reading any jpg's in the directory. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 10:51 AM To: CF-Talk Subject: RE: Image color info? I don't know as I've ever seen a .gif or .jpg that was ever cmyk (only time I ever really see .png is within a Flash A gif can't be CMYK, it can't be RGB either, a gif is by definition an indexed format with it's own colour palette. A jpg can be either RGB or CMYK but will not be displayed in IE or Netscape if it is CMYK, you usually only see it when you receive graphics from Mac using graphic designers used to designing for print and not appreciating the difference in designing for screen use. -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184623 Archives: http://www.houseoffusion.com/cf_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: payment gateway question
Check out www.modernauthorize.com It doesn't really answer your original question, but its pretty competitive. The same company also runs www.sslfactory.com very cheap ssl certs. I had a client try to grope me after the amount she saved from switching from the Verisign/CSI/Thawte money pit. -e -Original Message- From: DRE [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 12:19 PM To: CF-Talk Subject: Re: payment gateway question nobody every heard of them? On Tue, 16 Nov 2004 15:18:56 -0800, DRE [EMAIL PROTECTED] wrote: Hi, I have a client who wants to run credit cards thru a processor / gateway called WorkSmartPros.com who uses Cornerstone as their Merchant processor. Anybody got any feedback on these people and how easy it is to deal with their system, uptime, etc? Or perhaps I should be asking for best recomendations. She seems to think that authorize.net is more expensive. Thanks. -- DRE www.webmachineinc.com www.theanticool.com -- DRE www.webmachineinc.com www.theanticool.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184624 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: loop over form objects - using JavaScript - Client Validation
I believe this is what you are looking for:
script type=text/javascript
function validateFields(oForm) {
var colorChecked = 0;
for (var i=0; ioForm.color.length; i++) {
if (oForm.color[i].checked) {
colorChecked++;
break;
}
}
if (colorChecked == 0) {
alert(Please Choose at least one color!);
return false;
}
return true;
}
/script
form name=rColor action= method=post onsubmit=return
validateFields(this);
redinput type=radio name=color value=red /br /
blueinput type=radio name=color value=blue / br /
greeninput type=radio name=color value=green / br /
input type=submit value=test The Script /
/form
On Wed, 17 Nov 2004 07:16:27 -0600, Greg Morphis [EMAIL PROTECTED] wrote:
I dont think you are understanding what I'm trying to do..
I already check for server validation on the processing page.
What I'm trying to prevent is from the user to hit submit without
checking a box using client validation... javascript. If they hit
submit I want to display a message that they havent selected
anything... before it goes to the processing page.
On Tue, 16 Nov 2004 15:57:14 -0500, Ewok [EMAIL PROTECTED] wrote:
Well since checkboxes don't really exist in the scope unless they were
checked... I usually build cfparams for the fields with the same query and
loop I built the form fields with. Then use the query loop again to check
the value of the fields
Basic example
~--- to build the fields (which you already have ) ---
cfloop from=1 to=10 index=i
input type=checkbox value=#i# name=fld_#i#br
/cfloop
!--- then on the action page use the exat same loop that you built the
fields with to make params for the fields (im sure urs is a query loop)
So you don't get an error when you try to referecnce a field that wasn't
checked ---
cfloop from=1 to=10 index=i
cfparam name=form.fld_#i# default=
/cfloop
!--- then loop once more to check the values of the fields ---
cfloop from=1 to=10 index=i
FORM.FLD_#i# = #form['fld_' i]#br
/cfloop
You would just use currentrow or a recordID in your query loop rather than
an index.
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 2:34 PM
To: CF-Talk
Subject: loop over form objects
I have a page with X number of check boxes on it.
I have a query which generates these check boxes.
The query also returns the min and max value of the ID for those check
boxes.
Basically creating
r_23
r_24
r_25
r_26
... and so forth.
I'm trying to loop over these fields to check to see if none are checked.
for(i=cfoutput#sweeps.minval#/cfoutput;i
cfoutput#sweeps.maxval#/cfoutput; i++)
{
}
In the above scenerio the for loop would translate to
for(i=23;i=26;i++)
How do I check to see if r_i is checked..
--
Auxilium meum a Domino
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184625
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Query using 'FOR XML' Coldfusion
Yes, you have to loop over the query columns and build a new string with the columns data. The way you go about it is pretty wacky and I forget the syntax, but I (and others) have posted how to do it to the list at one point so it should be in the archive (it was like a year ago though) On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane [EMAIL PROTECTED] wrote: Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to return the results of a stored procedure, called from Coldfusion using 'CFStoredProc', as an XML string to my Coldfusion app. I am having a few problems; When I run the query in the SQL query window the results are exactly as I want, when I then call the stored procedure from Coldfusion app I get a recordset with multiple rows instead of one record containing a string and when I look at the 'ColumnList' property of the query I have mulitple columns with a naming convention as 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. Has anybody managed to use this SQL 'FOR XML' functionality in a Coldfusion app before? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184626 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFC form handling
I am stumped here. I am trying to learn how to utilize the full power of CFC's in a better practice way (working my way towards best practices). I am building an administrative application. I have put the queries into a data CFC, my business logic into its own CFC, and thus leaving the display code in its own CFM file. This has been working well so far, but I have found my self in a dark alley and I can not see how to code myself out of it. I'm looking for some basic strategy suggestions on how to build this in a more OO/multi-tier and less procedural way. The path I have followed so far is something like this: Form.cfm This is just what it says, a file that contains a form. App.cfc This file is a middleman CFC that the form submits to using the following structure. My current thinking is that this file is doing the validation and verification of the data submitted from the form according to the business needs. form action=app.cfc... input type=hidden name=method value=formMethod ... /form Data.cfc This is the CFC that the App.cfc utilizes to actually get the data from the form into the database. It contains the database logic and SQL statements. The trouble I am experiencing is that the logic in the app.cfc has two exits. First of all, my understanding of best practices makes me feel that this may be a bad result of itself, but I do not see a way to rearrange the pieces of my code to eliminate this. Secondly, even if I accept the two exits from the App.cfc method, I can't figure a way to actually make it work. The problem is that the formMethod() function is checking the data from the form, if the data is valid; it calls the appropriate method of the data.cfc to get the data into the database. But what do I do when the data is invalid? The program flow needs to somehow get back to the form with information about why the data is invalid, so that the user can be prompted to correct the errors. Since the form has been submitted to the App.cfc that is where the logic pointer is currently located. In other words, if I don't do anything to relocate and just finish processing, the URL of the browser will be such as http://aWebSite/app.cfc;. So how can I get the location and the error data back to the form.cfm file? I tried to store the error data in the session scope to persist it and then us a cflocation..., but that does not seem to work. When I dump the session scope in the form file, it is unaware of any of the values set in the app.cfc code. I think I have run into this problem before. It seems that if one submits forms to cfc methods for processing, this cfc has a separate world of persistent variables. I can set and output values in application or session scope in the cfc, but not from files that come after the cfc. So can somebody guide me to a better way to organize my logic so that I do not have the two exits currently required from the app.cfc formMethod() function? Or at least help me figure out how to get the data from this method back to the originating form? Thank you much. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC form handling
Could you pass in the Form.cfm url along with the form, hidden fields maybe. Then if the data is valid go to a function that calls Data.cfc or if the data is invalid then it goes to a function that returns the form fields back to Form.cfm using the url parameter. Just a thought. I have been mulling the idea of using cfc's in a similar method. Doug Ian Skinner wrote: I am stumped here. I am trying to learn how to utilize the full power of CFC's in a better practice way (working my way towards best practices). I am building an administrative application. I have put the queries into a data CFC, my business logic into its own CFC, and thus leaving the display code in its own CFM file. This has been working well so far, but I have found my self in a dark alley and I can not see how to code myself out of it. I'm looking for some basic strategy suggestions on how to build this in a more OO/multi-tier and less procedural way. The path I have followed so far is something like this: Form.cfm This is just what it says, a file that contains a form. App.cfc This file is a middleman CFC that the form submits to using the following structure. My current thinking is that this file is doing the validation and verification of the data submitted from the form according to the business needs. form action=app.cfc... input type=hidden name=method value=formMethod ... /form Data.cfc This is the CFC that the App.cfc utilizes to actually get the data from the form into the database. It contains the database logic and SQL statements. The trouble I am experiencing is that the logic in the app.cfc has two exits. First of all, my understanding of best practices makes me feel that this may be a bad result of itself, but I do not see a way to rearrange the pieces of my code to eliminate this. Secondly, even if I accept the two exits from the App.cfc method, I can't figure a way to actually make it work. The problem is that the formMethod() function is checking the data from the form, if the data is valid; it calls the appropriate method of the data.cfc to get the data into the database. But what do I do when the data is invalid? The program flow needs to somehow get back to the form with information about why the data is invalid, so that the user can be prompted to correct the errors. Since the form has been submitted to the App.cfc that is where the logic pointer is currently located. In other words, if I don't do anything to relocate and just finish processing, the URL of the browser will be such as http://aWebSite/app.cfc;. So how can I get the location and the error data back to the form.cfm file? I tried to store the error data in the session scope to persist it and then us a cflocation..., but that does not seem to work. When I dump the session scope in the form file, it is unaware of any of the values set in the app.cfc code. I think I have run into this problem before. It seems that if one submits forms to cfc methods for processing, this cfc has a separate world of persistent variables. I can set and output values in application or session scope in the cfc, but not from files that come after the cfc. So can somebody guide me to a better way to organize my logic so that I do not have the two exits currently required from the app.cfc formMethod() function? Or at least help me figure out how to get the data from this method back to the originating form? Thank you much. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184628 Archives: http://www.houseoffusion.com/cf_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
