Re: cfinclude from within CFML tag
At 16:42 25/08/2003 -0600, you wrote: >The tags are shared by a number of web sites. I want to be able have multiple >tags cfinclude an html file that sits in the same directory as the >tags. If it >can be done. What error gets thrown when you try it? Gyrus [EMAIL PROTECTED] play: http://norlonto.net/ work: http://tengai.co.uk/ PGP key available ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfinclude from within CFML tag
Can you not just create a mapping to the directory where your HTML files live? Then, in your custom tag: -Brad -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 6:42 PM To: CF-Talk Subject: Re: cfinclude from within CFML tag - Original Message - From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 4:07 PM Subject: Re: cfinclude from within CFML tag > At 14:21 25/08/2003 -0600, you wrote: > >How do you cfinclude a file from within a custom tag? I've got a group of > >cftags that all want to cfinclude an html file in the same directory. The > >directory with the tags is a subdirectory of a custom tag directory set up in > >the CF Administrator. > > > >One thing I suppose I could do is rename the file with a CF extension and then > >call it as a CF tag. And I believe I could do it by mapping the directory in > >the Administrator. Was wondering if there was another way. > > CFINCLUDE works fine inside custom tags. Are you not able to grab files > from the web root when your tag is inside the CF installation? Why not keep > CF tags inside the web root and call them with CFMODULE? Not sure I'm > grasping the problem though... The tags are shared by a number of web sites. I want to be able have multiple tags cfinclude an html file that sits in the same directory as the tags. If it can be done. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: cfc vs php rule of thumb
On Monday, August 25, 2003, at 11:51 AM, Patricia G. L. Hall wrote: > I've seen you talk about the ini way of doing things before and I > thought > it was an interesteing way to carry on. I'm pretty sure you've > mentioned > ini on your blog, but have you ever blogged its use specifically? I actually think INI files, or initialization files, are a great way to externalize simple application configuration. They are somewhere between defining variables in your Application.cfm file, and creating a configuration file in XML. For simple apps (or even complex apps that don't require a lot of configuration), they work great and are quick and simple to write and parse (using the getProfileSections and getProfileString functions). They are much less verbose than XML and more human-readable. Where you tend to run into trouble is when you try to create your own "namespaces" with dot notation or something as your files start to get complex. If you don't need the relational nature of XML, however, and you don't mind other developers making fun of you for not using XML, INI files are often a good solution. Christian ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: cfinclude from within CFML tag
- Original Message - From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 5:57 PM Subject: Re: cfinclude from within CFML tag > >The tags are shared by a number of web sites. I want to be able have > >multiple > >tags cfinclude an html file that sits in the same directory as the > >tags. If it > >can be done. > > What error gets thrown when you try it? Duh... As soon as you mentioned 'error' I realized that it wasn't being cfinclude'd for another reason. What I was seeing was that the HTML wasn't appearing on the page. Had I been thinking I would have realized that CF throws an error when cfinclude can't find the file. So it works. Apparently from within a custom tag cfinclude looks in the directory containing that tag. Which is exactly what I wanted. Thanks, Jim ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Logging users in with CFC
I'm learning about CFCs, and becoming more and more a devotee every day. I see lots of benefits with becoming adept at using them, but something has drawn my attention I've not seen an example of using a CFC to log users in and handle their authorization etc. I know the code isn't much to log someone in, but it seems to me that if you have a CFC to handle all the manipulation of users profiles and access etc, then you ought to have the login code in that CFC too. Are there any pros and cons with putting the username/password verification etc into a "users.cfc" along with a function to update the profile and list users and other user functions? I just like the idea of putting all that code together in once place, leaving the presentation aspects to the .cfm files. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: DWMX 2004 - Whats new for us?
What I really want to know is if ANYONE from Macromedia is taking note of this? I've been requesting the column mode forever. Every new version that comes out... I check for the feature... but it's never there. I mean sheesh... how hard can it be to put it in there? UltraEdit cost $35.00 Just something for the Macromedia folks to think about... ;-) -Novak - Original Message - From: "David DiPietro" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 2:29 PM Subject: Re: DWMX 2004 - Whats new for us? > I'll jump on the band wagon. > I use the column mode of UltraEdit 3-4 times a day because I write my code > in such a was as to take advantage of its speed. > > It's tag completion (including CF tags) and macros make it a very fast > development tool. > It's seemingly unlimited (not really but nearly 100 steps back) undo and > timed > backup to a separate directory (defacto though limited sourcesafe) > have saved me many a time. > > The ability to color code HTML, JavaScript, and ColdFusion tags, attributes > and declarations > granularly makes it very easy to research code I wrote 3 years ago as > changes need to be made. > > I have also enjoyed the use of its macro writing and text manipulation > features to process > the CSV files we get from various sources. > > Those are the features that I am looking for in any other text editor before > I abandon > UltraEdit32 > > David DiPietro > OSU College of Medicine > > > - Original Message - > From: "Mark W. Breneman" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, August 25, 2003 3:40 PM > Subject: RE: DWMX 2004 - Whats new for us? > > > > I hate to do a "me too" but I keep Ultraedit 32 on my computer just for > > that Vertical select feature. I use it at least 2-5 a week. > > > > Mark W. Breneman > > -Cold Fusion Developer > > -Network Administrator > > Vivid Media > > [EMAIL PROTECTED] > > www.vividmedia.com > > 608.270.9770 > > > > -Original Message- > > From: Jerry Barnes [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 25, 2003 2:27 PM > > To: CF-Talk > > Subject: RE: DWMX 2004 - Whats new for us? > > > > Vertical select would be a nice feature. Also allowing the user to > > insert spaces for tabs and indicating the cursor column position in code > > view would make good additions. > > > > J > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 25, 2003 2:32 PM > > To: CF-Talk > > Subject: Re: DWMX 2004 - Whats new for us? > > > > > > What I'd like to know is if they've finally added the ability to mark a > > column of text in "code view" mode just like UltraEdit32 can. Until I > > see that feature added, UltraEdit will probably remain my editor of > > choice. > > > > That's not to say that I don't used DWMX at all. I just find myself > > using UltraEdit more than DWMX. > > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: DWMX 2004 - Whats new for us?
> I strongly recommend that every Cf'er, studio, and dreamweaver user, > who have not already planned to do so to contact the user group in > your area who is participating in the Worldwide Macromedia user > group meeting sponsored by Macromedia via Breeze on September 3, > 2004. An additional perk is a copy of StudioMX 3004 will be > raffled off at each meeting (a $499.00 value) Is this something that's available to someone who is not able to physically go to a "presentation site"? If so, what's the URL and time? Thanks, Stephen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: cfc vs php rule of thumb
> and simple to write and parse (using the getProfileSections and > getProfileString functions). They are much less verbose than XML and they don't handle unicode, too bad as they would make provide pretty good substitutes for resource bundle functionality. cf really needs something like getResourceBundle(). ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Logging users in with CFC
what things might you be worried about? security? just wondering...i hadnt given it much thought but now that you mention it, what things are you wondering about? later. tw -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 10:10 PM To: CF-Talk Subject: Logging users in with CFC I'm learning about CFCs, and becoming more and more a devotee every day. I see lots of benefits with becoming adept at using them, but something has drawn my attention I've not seen an example of using a CFC to log users in and handle their authorization etc. I know the code isn't much to log someone in, but it seems to me that if you have a CFC to handle all the manipulation of users profiles and access etc, then you ought to have the login code in that CFC too. Are there any pros and cons with putting the username/password verification etc into a "users.cfc" along with a function to update the profile and list users and other user functions? I just like the idea of putting all that code together in once place, leaving the presentation aspects to the .cfm files. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Forcing a List to a Specific Length
:<>: Why not use an array instead? Because the Flash guy I'm working with said he needed this information in a list?? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: DWMX 2004 - Whats new for us?
It is not available to individuals, sorry - just to organized groups. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Stephen Hait" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 9:16 PM Subject: Re: DWMX 2004 - Whats new for us? | > I strongly recommend that every Cf'er, studio, and dreamweaver user, | > who have not already planned to do so to contact the user group in | > your area who is participating in the Worldwide Macromedia user | > group meeting sponsored by Macromedia via Breeze on September 3, | > 2004. An additional perk is a copy of StudioMX 3004 will be | > raffled off at each meeting (a $499.00 value) | | Is this something that's available to someone who is not able to | physically go to a "presentation site"? If so, what's the URL and | time? | | Thanks, Stephen | ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Logging users in with CFC
Tony, to be honest, I'm not sure. It's just that I haven't seen any examples of CFCs being used for that functionality, so I wondered why. It seems that one of the ways to collect all the functionality related to users is to have a users.cfc where you'd have a method called login, one called listusers, one called updateprofile, one called emailpassword etc, and then all the database access, and action related to user access is in the one place. This is what's advocated in other applications about CFCs, but I haven't seen login, authentication, updating last login date, number of logins etc - all that user access stuff - gathered into a CFC. So I wondered if that was because people have always done it without CFCs and therefore old habits are at play, or whether there was a logical reason not to include this stuff in CFCs, that I wasn't seeing. (Believe me there's a LOT about my world that I don't see. Just ask my wife!) Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 August 2003 1:05 PM To: CF-Talk Subject: RE: Logging users in with CFC what things might you be worried about? security? just wondering...i hadnt given it much thought but now that you mention it, what things are you wondering about? later. tw ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Logging users in with CFC
i cant fathom a reason not to. its probably just a prerogative choice for a developer to make. but then again...im sure someone will come up with a reason, albeit obscure, there might be one :) cheers... oh, and my wife...loves when im working...she talks, i nod and sometimes she quizzes me on the details...im about 95% winning percentage on the short term memory skills test ;) later -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 11:24 PM To: CF-Talk Subject: RE: Logging users in with CFC Tony, to be honest, I'm not sure. It's just that I haven't seen any examples of CFCs being used for that functionality, so I wondered why. It seems that one of the ways to collect all the functionality related to users is to have a users.cfc where you'd have a method called login, one called listusers, one called updateprofile, one called emailpassword etc, and then all the database access, and action related to user access is in the one place. This is what's advocated in other applications about CFCs, but I haven't seen login, authentication, updating last login date, number of logins etc - all that user access stuff - gathered into a CFC. So I wondered if that was because people have always done it without CFCs and therefore old habits are at play, or whether there was a logical reason not to include this stuff in CFCs, that I wasn't seeing. (Believe me there's a LOT about my world that I don't see. Just ask my wife!) Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 August 2003 1:05 PM To: CF-Talk Subject: RE: Logging users in with CFC what things might you be worried about? security? just wondering...i hadnt given it much thought but now that you mention it, what things are you wondering about? later. tw ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
convert to upper or lowercase?
Hello, trying to detect what a person submitted and want to make sure I catch all variations and I totally blanked on what the tag is for converting the text to upper or lowercase. example someone types in cA I want to catch it as CA or ca cause its the same thing. Thanks in Advance Troy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: convert to upper or lowercase?
ucase() or lcase() > -Original Message- > From: Troy Montour [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 26 August 2003 3:57 p.m. > To: CF-Talk > Subject: convert to upper or lowercase? > > Hello, > trying to detect what a person submitted and want to make sure I catch > all variations and I totally blanked on what the tag is for converting the > text to upper or lowercase. > > example someone types in cA I want to catch it as CA or ca cause its the > same thing. > > Thanks in Advance > Troy > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: convert to upper or lowercase?
-Brad -Original Message- From: Troy Montour [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 11:57 PM To: CF-Talk Subject: convert to upper or lowercase? Hello, trying to detect what a person submitted and want to make sure I catch all variations and I totally blanked on what the tag is for converting the text to upper or lowercase. example someone types in cA I want to catch it as CA or ca cause its the same thing. Thanks in Advance Troy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: convert to upper or lowercase?
lcase(form.field) ucase(form.field) http://livedocs.macromedia.com > Hello, > trying to detect what a person submitted and want to > make sure I catch > all variations and I totally blanked on what the tag is > for converting the > text to upper or lowercase. > example someone types in cA I want to catch it as CA or ca > cause its the > same thing. > Thanks in Advance > Troy > ~~ > ~~~| > Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 > Subscription: > http://www.houseoffusion.com/lists.cfm?link=s:4 > Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubsc > ribe.cfm?user=633.558.4 > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm s. isaac dealey972-490-6624 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
.properties for scite?
anyone? anyone? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Forcing a List to a Specific Length
May be a more elegant way, but -Brad -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 10:36 PM To: CF-Talk Subject: RE: Forcing a List to a Specific Length :<>: Why not use an array instead? Because the Flash guy I'm working with said he needed this information in a list?? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: DWMX 2004 - Whats new for us?
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What I really want to know is if ANYONE from Macromedia is taking note of > this? I've been requesting the column mode forever. Every new version that > comes out... I check for the feature... but it's never there. I mean > sheesh... how hard can it be to put it in there? UltraEdit cost $35.00 > > Just something for the Macromedia folks to think about... ;-) Cast your vote: http://www.macromedia.com/support/email/wishform/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DWMX 2004 - Whats new for us?
jEdit also includes this feature (Vertical Select, Cut/Copy/Paste). www.jedit.org www.joshuasmiller.com/jedit/ Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 3:40 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? I hate to do a "me too" but I keep Ultraedit 32 on my computer just for that Vertical select feature. I use it at least 2-5 a week. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jerry Barnes [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 2:27 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? Vertical select would be a nice feature. Also allowing the user to insert spaces for tabs and indicating the cursor column position in code view would make good additions. J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 2:32 PM To: CF-Talk Subject: Re: DWMX 2004 - Whats new for us? What I'd like to know is if they've finally added the ability to mark a column of text in "code view" mode just like UltraEdit32 can. Until I see that feature added, UltraEdit will probably remain my editor of choice. That's not to say that I don't used DWMX at all. I just find myself using UltraEdit more than DWMX. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
CFUPDATE and MX. Help is needed ASAP!
I just recently upgraded to MX 6.1 from 5.0 and am now running into problems with CFUPDATE and CFINSERT. My code worked flawlessly in 5.0 I am getting : [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. What is going on here? If I were a guessing man it has to do with some dates I am entering BUT this code worked FINE on CF5.0. At this point I am begining to ask myself if the upgrade to 6.1 is worth it Is the some kind of BUG in CFMX or a known issue. Yes I can solve the problem by entering cfquery statements instead of cfupdate but that is a MAJOR hastle... Thanks Jeff ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re[2]: DWMX 2004 - Whats new for us?
jEdit can also do multiple select (select several seperate lines/paragraphs) which is fantastically useful. I actually switched to jEdit when I moved to a linux desktop and now I've ditched the MM IDE's in favour of jedit permanently - tricked up to provide everything cfstudio does, except for tag insight and F1 help, both of which can be implemented but I haven't had the time to set it up ;) cheers, Toby Tuesday, August 26, 2003, 3:50:45 PM, you wrote: JM> jEdit also includes this feature (Vertical Select, Cut/Copy/Paste). JM> www.jedit.org JM> www.joshuasmiller.com/jedit/ JM> Joshua Miller JM> Head Programmer / IT Manager JM> Garrison Enterprises Inc. JM> www.garrisonenterprises.net JM> [EMAIL PROTECTED] JM> (704) 569-0801 ext. 254 JM> JM> * JM> Any views expressed in this message are those of the individual sender, JM> except where the sender states them to be the views of JM> Garrison Enterprises Inc. JM> This e-mail is intended only for the individual or entity to which it is JM> addressed and contains information that is private and confidential. If JM> you are not the intended recipient you are hereby notified that any JM> dissemination, distribution or copying is strictly prohibited. If you JM> have received this e-mail in error please delete it immediately and JM> advise us by return e-mail to [EMAIL PROTECTED] JM> JM> * JM> -Original Message- JM> From: Mark W. Breneman [mailto:[EMAIL PROTECTED] JM> Sent: Monday, August 25, 2003 3:40 PM JM> To: CF-Talk JM> Subject: RE: DWMX 2004 - Whats new for us? JM> I hate to do a "me too" but I keep Ultraedit 32 on my computer just for JM> that Vertical select feature. I use it at least 2-5 a week. JM> Mark W. Breneman JM> -Cold Fusion Developer JM> -Network Administrator JM> Vivid Media JM> [EMAIL PROTECTED] JM> www.vividmedia.com JM> 608.270.9770 JM> -Original Message- JM> From: Jerry Barnes [mailto:[EMAIL PROTECTED] JM> Sent: Monday, August 25, 2003 2:27 PM JM> To: CF-Talk JM> Subject: RE: DWMX 2004 - Whats new for us? JM> Vertical select would be a nice feature. Also allowing the user to JM> insert spaces for tabs and indicating the cursor column position in code JM> view would make good additions. JM> J JM> -Original Message- JM> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] JM> Sent: Monday, August 25, 2003 2:32 PM JM> To: CF-Talk JM> Subject: Re: DWMX 2004 - Whats new for us? JM> What I'd like to know is if they've finally added the ability to mark a JM> column of text in "code view" mode just like UltraEdit32 can. Until I JM> see that feature added, UltraEdit will probably remain my editor of JM> choice. JM> That's not to say that I don't used DWMX at all. I just find myself JM> using UltraEdit more than DWMX. JM> ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfdirectory help - photo album
> If you pass to the display page the forward and back values, > and then click forward or back, how are you going to know > what the next next or previous previous values are. > > I would instead suggest that on the display page you again do > a cfdirectory, and then grab the previous and next files from > the list on each display of the page. Performance tip: If you have a lot of users hitting the gallery pages, your hard drives will take quite a beating from all of the CFDIRECTORY accesses. Unless your gallery is constantly being updated, store the CFDIRECTORY result in an application variable. Then, all you have to do is check for existence of the application variable each time the page loads. If you are using CFMX, you can make this even easier by putting the code into a CFC. Mike Wolfe [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
AW: multiple user login
Thank you Christian, I think that solves my problem. Margrit > I just wrote about this last week in a post entitled "Separating > Sessions from Cookies": > http://www.markme.com/cantrell/archives/003109.cfm Christian ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Where's my CGI.PATH_INFO variable?
Doesn't the CGI vars depend on what the web-server passes, and how CF handles them. I have seen differences Apache vs IIS. /H. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] | Sent: Tuesday, August 26, 2003 01:34 | To: CF-Talk | Subject: Re: Where's my CGI.PATH_INFO variable? | | | MX was also the first time I saw the cgi.path_info variable | as anything other than the same as cgi.script_name -- it was | blank for me also. I just replaced cgi.path_info with | cgi.script_name throughout all my code and that seemed to | work for me. Wish I could provide more detailed information | about it, but I really don't know anything more myself. | | hth | | s. isaac dealey972-490-6624 | | team macromedia volunteer | http://www.macromedia.com/go/team | | chief architect, tapestry cms http://products.turnkey.to | | onTap is open source http://www.turnkey.to/ontap | | | | > I have a little security device I just on some of my sites | > ... if somebody | > goes to the /secure section of the site, and the proper | > client vars haven't | > been set, they get prompted to login. | | > The code begins with this line: | | > | | > On CF 5.0, this works fine every time. | | > Now I'm using this code on a CFMX site, and it's not | > working. | | > In Debug, the CGI variables shows PATH_INFO as blank. | | > This bit of debug code: | | > alert('#CGI.PATH_INFO#'); tput> | | > Shows the PATH_INFO is blank. | | > There are other CGI variables that are set, but why is | > this one blank? I'm | > using the same browser session on the same machine to hit | > the sites on 5.0 | > and MX, so I don't think it's a browser or client | > configuration issue. | | > Is there a setting in MX admin I'm missing? | | > I've installed CFMX 6.1 on a Win2K machine. | | > H. | | > ~~ | > ~~~| | > Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 | > Subscription: | > http://www.houseoffusion.com/lists.cfm?link=s:4 | > Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubsc | > ribe.cfm?user=633.558.4 | | > This list and all House of Fusion resources hosted by | > CFHosting.com. The place for dependable ColdFusion | > Hosting. | > http://www.cfhosting.com | | | | ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
more php vs cf (cfcase and constants)
Hello Again with a PHP-related question (trying to convert some PHP code to CF). This one has to do with CFCASE. In PHP you can define a constant using define("constantname","constantvalue"). From there on the variable is indeed treated as a constant (like true or false). I have a switch/case in PHP I want converted to CF but I cannot find a way of creating a "constant-constant" and end up having the old "This expression must have a constant value." error. I know I can use CFIF but, well, just wanted to know if this can be done with CFSWITCH PHP can do it! : ) Regards - mga _ Get MSN 8 and enjoy automatic e-mail virus protection. http://join.msn.com/?page=features/virus ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: DevNet Pro watermark
On Friday 22 Aug 2003 18:08 pm, Calvin Ward wrote: > It's a work around if it is an additional requirement. > Setting content-type is not necessarily required in all forms of output. I was under the impression you only had to set it if you were not outputting text/html... which you'd have to do anyway... -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Intranet/Hosting Toolkit
Anyone used this? In particular the new MX version? (will it still work in ColdFusion 5?) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: MX 6.1 404 Problem : HELP!
No, I am using a network addressi.e. I am resolving it via its normal network name via IIS. -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: 21 August 2003 16:50 To: CF-Talk Subject: RE: MX 6.1 404 Problem : HELP! Are you using a localhost address? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] Do you want complete ColdFusion Administrator access? RDS? Terminal Server?- CFX-Advanced VPS - http://www.cfxhosting.com/Plans/s_cfxadvancedVPS.cfm -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 11:40 AM To: CF-Talk Subject: MX 6.1 404 Problem : HELP! OKI have installed MX 6.1 on a dev server...all running sweet.. I can browse folders AOK via port 8500but when I click on a page I get.. 404 File not found eh?! I clicked on the damn link that WAS the file! ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DWMX 2004 - Whats new for us?
> Those are the features that I am looking for in any other > text editor before I abandon UltraEdit32 All this talk of UltraEdit has made me d/l it and check it out... Does anyone have (or can point me in the direction of) a wordfile and tag list file for CFMX, preferably 6.1? There are files for CF4.5/5 on the ultraedit site but no MX... Cheers, Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DWMX 2004 - Whats new for us?
Do remember that there will be an updated version of Homesite (version 5.5) shipping with DWMX. -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 26 August 2003 10:59 To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? > Those are the features that I am looking for in any other > text editor before I abandon UltraEdit32 All this talk of UltraEdit has made me d/l it and check it out... Does anyone have (or can point me in the direction of) a wordfile and tag list file for CFMX, preferably 6.1? There are files for CF4.5/5 on the ultraedit site but no MX... Cheers, Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: DWMX 2004 - Whats new for us?
> Do remember that there will be an updated version of Homesite (version 5.5) > shipping with DWMX. And, if you really don't like DW, Homesite standalone can be a good (and cheap) choice: http://www.macromedia.com/software/homesite/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: DWMX 2004 - Whats new for us?
> Do remember that there will be an updated version of Homesite > (version 5.5) shipping with DWMX. But I wanna play NOW! ;) --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: DWMX 2004 - Whats new for us?
> > Do remember that there will be an updated version of Homesite > > (version 5.5) shipping with DWMX. > > But I wanna play NOW! ;) Then you can download Homesite 5.2 trial and play for 30 days :-) Massimo ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
MX 2004 and Devnet Pro
I am thinking of subscribing to Devnet Pro in the next month or so. I understand that i should get the upgrades to MX 2004 as part of Devnet Pro. One question that i am stuck on is, will the MX 2004 versions of the various studio products contain the items that are in DRKs prior to MX 2004? In other words, do i still need to buy DRKs 1-3 (since 4 is the current one) to get all the features (Flash components, Dreamweaver components, CFMX components) that are in available in those DRKs, or can i just wait for the 2004 versions of the products? Hopefully someone from MACR can answer this for me. Thanks, Rob Edwards ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: MX 2004 and Devnet Pro
> I am thinking of subscribing to Devnet Pro in the next month or so. I > understand that i should get the upgrades to MX 2004 as part of Devnet > Pro. One question that i am stuck on is, will the MX 2004 versions of the > various studio products contain the items that are in DRKs prior to MX > 2004? In other words, do i still need to buy DRKs 1-3 (since 4 is the > current one) to get all the features (Flash components, Dreamweaver > components, CFMX components) that are in available in those DRKs, or can i > just wait for the 2004 versions of the products? You may try this: http://macromedia.com/software/drk/productinfo/faq/#1_11 Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Logging users in with CFC
Mike, Macromedia has an article about this very topic: http://www.macromedia.com/devnet/mx/coldfusion/articles/cfc_practices.ht ml Its been there for about a year so Im sure there are more comprehensive examples around by now. Regards, André -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 26 August 2003 04:24 To: CF-Talk Subject: RE: Logging users in with CFC Tony, to be honest, I'm not sure. It's just that I haven't seen any examples of CFCs being used for that functionality, so I wondered why. It seems that one of the ways to collect all the functionality related to users is to have a users.cfc where you'd have a method called login, one called listusers, one called updateprofile, one called emailpassword etc, and then all the database access, and action related to user access is in the one place. This is what's advocated in other applications about CFCs, but I haven't seen login, authentication, updating last login date, number of logins etc - all that user access stuff - gathered into a CFC. So I wondered if that was because people have always done it without CFCs and therefore old habits are at play, or whether there was a logical reason not to include this stuff in CFCs, that I wasn't seeing. (Believe me there's a LOT about my world that I don't see. Just ask my wife!) Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 August 2003 1:05 PM To: CF-Talk Subject: RE: Logging users in with CFC what things might you be worried about? security? just wondering...i hadnt given it much thought but now that you mention it, what things are you wondering about? later. tw ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
CFC's & Shared Scopes
If I cache a CFC in the Server scope, then copy it to a local scope (to avoid locking), is there any performance gain? Or, should I forget the Server scope all together? I've got a CFC that will be shared across multiple sites... how do you guys normally handle this?... put it in a shared scope? make it available as a webservice?... just curious. -Brad ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Dreamweaver and include files
yes, it can dl the trial. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Okay, how could I accomplish this?
>Yeah, but here's the thing. The tables hold data that can be stuck into >"key, title, body" columns, but the display of each column is different, so >each collection will be displayed differently, thus the "custom1" column in >my cfsearch. I want to mix the results for display purposes, showing scores >correctly ranked when mixed, but I want to display the results differently. >My solution was to search each collection, place the results into a >structure of some sort, including the "custom1" column that will determine >how to display the data on the details page, and sort them all by "score" so >that output results are "sorted" by "score" yet their "colum1" information >will determine how the data is displayed on the following page. > >Make sense? > >So *can* you do that? stick each result set into some sort of data structure >for each query returned, then sort that structure, ordering by "score", then >outputting the results? > >For instance, collection 1 returns the following: >Score - Title (custom1) >97 - My New Title (1) >67 - A Second Title (1) >78 - The Fifth Title (1) > >And collection 2 returns the following: >86 - The Title of This Document is This (2) >76 - I'm Titling This Document Thusly (2) >23 - A Whimsical Title To Enjoy (2) > >Then my output is as follows: >97 - My New Title (1) >86 - The Title of This Document is This (2) >78 - The Fifth Title (1) >76 - I'm Titling This Document Thusly (2) >67 - A Second Title (1) >23 - A Whimsical Title To Enjoy (2) > >See? Then, when you clicked the link, you'd know *which* collection passed >you the results...then you could display it appropriately, if it needs to be >displayed differently (which mine does). Perhaps you could avoid trying to put the two queries into one structure... What you want to do is *exactly* like the merge portion of the merge sort algorithm - the problem is to take two already-sorted data structures and combine them into a single sorted structure. Merge sorts are known to be very fast, so perhaps an efficient solution would be to mimic the merge part of the merge sort algorithm. Here's the basic idea: list A = 1, 3, 4, 6 list B = 2, 3, 5, 7 merge into: 1 2 3 3 4 5 6 7 to merge the two lists: loop while A and B have elements remaining --compare the first elements of A and B --if B is less, append to final list --else, append A's first element instead end loop So to mimic this: Initialize two counters - counterA and counterB - to 1 -- you begin by looking at the first record from each query loop while both counters are LTE their respective recordcount --compare queryA.score[counterA] and queryB.score[counterB] --if the score from B is GT the score from A output info for B, iterate counterB --else output info for A, iterate counterA end loop One thing to remember - you can go through all the records of one query before the other query is finished so you need to test for that. Something like that. Data structures was my favorite class in college :-) Mike Mertsock Alfred University Web Team ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
CFMX and AS/400
Hello, In the process of upgrading from CF 5.0 to CFMX 6.1. I am using an AS/400 for some of apps. Does the DB2 Driver that comes with CFMX 6.1 able to connect to an AS/400 without using DB2 Connect software? James Taavon Senior Web Developer Department of Labor, Licensing and Regulation 1100 N. Eutaw Street Room 203 Baltimore, MD 21201 Ph: 410 767-8190 Fx: 410 333-5203 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
oracle datasource as OLEDB
This is my first encounter with Oracle. I need to define a datasource in CF5. As far as using the database, it'll be nothing but the simplest SELECT statements, so that shouldn't be a problem. Is it possible to define an Oracle database with OLEDB, or do I have to use ODBC? Can anyone give me some hints about defining an Oracle datasource? My experience is mostly with Sql Server. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
oracle datasource as OLEDB
This is my first encounter with Oracle. I need to define a datasource in CF5. As far as using the database, it'll be nothing but the simplest SELECT statements, so that shouldn't be a problem. Is it possible to define an Oracle database with OLEDB, or do I have to use ODBC? Can anyone give me some hints about defining an Oracle datasource? My experience is mostly with Sql Server. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
multiple user login
Hi I' am using CF MX and made a login with cflogin. IE allows on the same computer multiple different users to login. Mozilla accepts only one user to login. If I login twice with two different users in Mozilla, the second logedin user gets to see the page of the first logedin user. Has anyone an idea how to handle this? Thanks for helping Margrit ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
OT: Congressional Data
Hi, I am working with an association that wants to do some advocacy work with their members. We are looking for data for zip codes and congressional districts to do lookups for Representatives in Congress. Anyone have any experience finding this kind of data? Thanks Chuck Rodgers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Coldfusion and Palm Calendar
Anyone out there used/developed any good tools that would allow data to be downloaded from a coldfusion component / web services / etc.. in to Palm's Calendar? Thanks, Glen Salisbury [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Okay, how could I accomplish this?
>Yeah, but here's the thing. The tables hold data that can be stuck into >"key, title, body" columns, but the display of each column is different, so >each collection will be displayed differently, thus the "custom1" column in >my cfsearch. I want to mix the results for display purposes, showing scores >correctly ranked when mixed, but I want to display the results differently. >My solution was to search each collection, place the results into a >structure of some sort, including the "custom1" column that will determine >how to display the data on the details page, and sort them all by "score" so >that output results are "sorted" by "score" yet their "colum1" information >will determine how the data is displayed on the following page. > >Make sense? > >So *can* you do that? stick each result set into some sort of data structure >for each query returned, then sort that structure, ordering by "score", then >outputting the results? > >For instance, collection 1 returns the following: >Score - Title (custom1) >97 - My New Title (1) >67 - A Second Title (1) >78 - The Fifth Title (1) > >And collection 2 returns the following: >86 - The Title of This Document is This (2) >76 - I'm Titling This Document Thusly (2) >23 - A Whimsical Title To Enjoy (2) > >Then my output is as follows: >97 - My New Title (1) >86 - The Title of This Document is This (2) >78 - The Fifth Title (1) >76 - I'm Titling This Document Thusly (2) >67 - A Second Title (1) >23 - A Whimsical Title To Enjoy (2) > >See? Then, when you clicked the link, you'd know *which* collection passed >you the results...then you could display it appropriately, if it needs to be >displayed differently (which mine does). Perhaps you could avoid trying to put the two queries into one structure... What you want to do is *exactly* like the merge portion of the merge sort algorithm - the problem is to take two already-sorted data structures and combine them into a single sorted structure. Merge sorts are known to be very fast, so perhaps an efficient solution would be to mimic the merge part of the merge sort algorithm. Here's the basic idea: list A = 1, 3, 4, 6 list B = 2, 3, 5, 7 merge into: 1 2 3 3 4 5 6 7 to merge the two lists: loop while A and B have elements remaining --compare the first elements of A and B --if B is less, append to final list --else, append A's first element instead end loop So to mimic this: Initialize two counters - counterA and counterB - to 1 -- you begin by looking at the first record from each query loop while both counters are LTE their respective recordcount --compare queryA.score[counterA] and queryB.score[counterB] --if the score from B is GT the score from A output info for B, iterate counterB --else output info for A, iterate counterA end loop One thing to remember - you can go through all the records of one query before the other query is finished so you need to test for that. Something like that. Data structures was my favorite class in college :-) Mike Mertsock Alfred University Web Team ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
multiple user login
Hi I' am using CF MX and made a login with cflogin. IE allows on the same computer multiple different users to login. Mozilla accepts only one user to login. If I login twice with two different users in Mozilla, the second logedin user gets to see the page of the first logedin user. Has anyone an idea how to handle this? Thanks for helping Margrit ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
WOT: Securing word docs, excel, etc in a web app
Hi, This is off topic, but I am sure many of you have had to deal with issues such as these in the past. I have been living in a bubble for the past 3 years and have developped many web apps in CF, ASP and JSP on secure networks with no Internet connection. For the first time, I am building an Internet based web app in CF. Creating the members only portion with user authentication and so on is no problem. However, the site's main focus is to share research data among members. Most members want to upload MS Word docs, MS Excel docs and PDFs. The site will be hosted at an ISP, so using IIS or NT security is not an option. So here is my dilema, once I have uploaded documents that I only want members to access, how can I achieve something better than "security through obscurity" and prevent people from stumbling on the docs by guessing or as the result of a search engine search? Same question for images. There will be images in .jpg and .gif format which are destined for members eyes only. Any recommendations appreciated. Grif ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
CFMX and AS/400
Hello, In the process of upgrading from CF 5.0 to CFMX 6.1. I am using an AS/400 for some of apps. Does the DB2 Driver that comes with CFMX 6.1 able to connect to an AS/400 without using DB2 Connect software? James Taavon Senior Web Developer Department of Labor, Licensing and Regulation 1100 N. Eutaw Street Room 203 Baltimore, MD 21201 Ph: 410 767-8190 Fx: 410 333-5203 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: hard returns and text areas
Chr(10) and Chr(13) in the ASCII table are carriage return with a line feed So do a REReplace(#Chr(10)##Chr(13)#," ",ALL) (may not be syntactically accurate - but you get the idea...) Matt Knight ► w: 972 361 9943 ► m: 214 213 4016 -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 9:23 AM To: CF-Talk hi. does anyone know of a way to identify that a user has entered a hard return into a text-area and then pull those hard returns out (or replace them with just a single space). any help is greatly appreciated. thanks very much. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFMX and AS/400
Hello, In the process of upgrading from CF 5.0 to CFMX 6.1. I am using an AS/400 for some of apps. Does the DB2 Driver that comes with CFMX 6.1 able to connect to an AS/400 without using DB2 Connect software? James Taavon Senior Web Developer Department of Labor, Licensing and Regulation 1100 N. Eutaw Street Room 203 Baltimore, MD 21201 Ph: 410 767-8190 Fx: 410 333-5203 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
ckeck for finished download
Hi I have a page, where users can download files. It is done with cfheader and cfcontent. I want to receive a mail, as soon as the download is finished. I manage to send a mail (cfmail), if the user starts the download. That means, when I receive the mail, I am not shure, if the user ever finished the download. Is there a possibility to check if a download is finished? Thank you Margrit ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
cfc vs php rule of thumb
Hello When developing in PHP, it is common to have something like this in a class document: // start include 'my_config_file.php'; class MyClass { // properties and functions } // end Where my_config_file.php is a file that has constants and other shared variables. I am familiar with CFCs also but am not sure what would be the right way to go on this issue. It is good to have an external file with common variables, and sometimes people have them inside Application.cfm but you don't always want to have them there. Can anyone shed any light on this issue? Thanks - mga _ MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CF Studio/HomeSite+
True, and Dreamweaver is cheaper than Studio was. Clint - Original Message - From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 9:14 AM Subject: RE: CF Studio/HomeSite+ > Homesite+ is the only version of 'Studio' which MM still actively supports > and develops AFAIKit is also ONLY included with DWMX > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: 21 August 2003 10:32 > To: CF-Talk > Subject: CF Studio/HomeSite+ > > > Which of the two is still being maintained, even if not sold directly, by > Macromedia? Would it be Homesite+, since it's included with Dreamweaver MX? > > We need to purchase a couple of additional licenses for CF Studio. We're > not > working with CF6 MX and have no plans to move away from CF5 Server. We > don't > have much use for Dreamweaver or any of the other Studio MX components. So > what > would be the best (and cheapest) route to aquiring a couple of > Studio/Homesite+ > licenses? If contacted directly, will Macromedia sell you CF Studio > licenses, > even though its no longer a product available for purchase from their web > page? > > Jim > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Question about cf and ldap
I read somewhere that it needs to be a full name, >not just the actual username, but I'm not sure what this means. You probably need to use a full-qualified Windows domain name. In your code snippet, it would be something like the following: ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Test: Dec 31 1969 ?
I'm seeing a lot of mail come in with dec 31 1969 as the date. Just testing to see if this one does too. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
ckeck for finished download
Hi I have a page, where users can download files. It is done with cfheader and cfcontent. I want to receive a mail, as soon as the download is finished. I manage to send a mail (cfmail), if the user starts the download. That means, when I receive the mail, I am not shure, if the user ever finished the download. Is there a possibility to check if a download is finished? Thank you Margrit ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
WOT: SQL Data types
I am curious how religiously people stay true to using data types for MS SQL Server. I know some of these stretch to other RDBMS's, however, I would like to know what people in industry think. What type of general rules of thumb do people follow when planning data types for a data store? For instance Money, Numeric, varchar, int, bigint ... I think you get the point. I am looking for response such as; never use that type, it won't convert to Oracle. Never use that type, the space you save is not worth it, etc If this needs more elaboration, please let me know Mike. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFMX 6.0 Error
has anyone seen this... coldfusion.tagext.lang.ModuleTag null _ Matt Knight ►Dresser Corporate Web Team ► Dresser, Inc. ► w: 972 361 9943 ► m: 214 213 4016 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Access issue in CF6.1
I posted this to the webforums a few weeks back, but never really got a definitive solution. Perhaps someone here knows the solution: Can anyone explain why when using remoting to connect to CF 6.0 I get dates returned as 'Wed Aug 6 12:15:00 GMT-0700 2003', which is perfect with me, but using CF6.1, I get dates back formatted '2003-07-31 01:00:00'? Is 6.1 converting my longs to mediums? Below is a basic sample created entirely for the purpose of demonstrating the change. I compare CF6.0, CF6.1 to MSAccess and MySQL. I would upgrade the data to SQL and solve the prob, but my client insists on using Access. Sigh. -=-=-=-=-=-=- CFC SELECT * FROM myTABLE WHERE myTABLE_ID = 550 -=-=-=-=-=-=- Flash #include "NetServices.as" #include "NetDebug.as" cnn0 = NetServices.createGatewayConnection("http://67.115.131.211:8500/flashser vices/gateway"); svc0 = cnn0.getService("eomp.com.DateService"); svc0.querySomeDate( { onResult: function(result) { trace("CFMX6.0: " + result.items[0].OMP_Date); } } ); cnn1 = NetServices.createGatewayConnection("http://127.0.0.1:8500/flashservices /gateway"); svc1 = cnn1.getService("eomp.com.DateService"); svc1.querySomeDate( { onResult: function(result) { trace("CFMX6.1: " + result.items[0].OMP_Date); } } ); -=-=-=-=-=-=- Trace Output: CFMX6.0/Access: Sat Jun 14 20:15:00 GMT-0700 2003 CFMX6.1/mySQL: Thu Aug 7 13:34:00 GMT-0700 2003 CFMX6.1/Access: 2003-06-14 22:15:00 -=-=-=-=-=-=- END So it appears that Access is the culprit, as SQL returns a proper 'long' date in 6.1. Wonder why Access is returning different output all of a sudden? Does 6.1 use a different driver for Access? If so, how do I update it so it works proper? Thanks in advance for any assistance. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
storing xml in sql
Hi there, If you are still wishing to go down the route of XML after the previous posts, you might wish to externatize some specific nodes in your XML data. That way the value of particular nodes and particular atttributes are stored seperate from the XML in another table with the ID of the XML record they belong to. I don't know if this makes sense in your situation, but if you had a XML doc like so in a text field of your DB: My product AABBCC123 Related to these prodocut XMLs you have a reference field(s) for e.g. //product/name and/or //product/sku or whatever, it just has to be valid Xpath syntax. Now when you go to save/update the XML text field in your DB you read these reference values, simply query the XML object using the Xpath and store the value somewhere (say in a 'references' table) with the record ID of the XML text field. Now if you wish to look up all Products with a name of 'My product', you just need to lookup the references table, and this ought to give you a list of the DocIDs where the XML node 'Products' has the name 'My product'. You can then read in and create an XML object or whatever. It's like a book's index. This of course is only useful if you have a number of XML fields that you might like to search by etc. However, I have this implemented at our place, and it's fast and effective for our uses. Hope it makes sense or helps :) Ciaran >Somewhat OT but this is for a CF app and I thought it could be useful for >others too. > >I'm in the processing of making a very flexible OO inventory app. The basic >rundown is this. > > > >You have a table in the DB called "Products". This is where you inventory >goes. Now because this database is going to be used by several different >e-commerce apps, it has to be flexible. App 1 may have a field called >"MODEL" for the item data to go into the table. > >App2 might have a field called "YEAR", and etc. Now if I make new columns >for every app, I'm going to end up with a products table with like 40 >columns. Sure that will work, but its not very organized, and there are >things like, one product cant have more than one model, and etc. > > > >Instead I want to store the data as XML in a text field. Pretty simple >right? > >I format the data using cfwddx. This way I can easily format the data as it >comes in and out of the database. It works great. > > > >But now I ran into a problem. What if I want to search by model? Say I want >all the items in the database that are model "XYZ". Well the only option I >have it to search the xml text field for XYZ, but then I "could" get double >the number of fields I want if any other xml data has "XYZ" in it. > > > >Does anyone know of a good solution to this? Is there a way to search the >specific xml fields while its still in the database? I've looked into the >Microsoft OpenXML, but that seems overly complex. > > >Any ideas would be great. > > > >Thanks, > >-Alan > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
OT: Congressional Data
Hi, I am working with an association that wants to do some advocacy work with their members. We are looking for data for zip codes and congressional districts to do lookups for Representatives in Congress. Anyone have any experience finding this kind of data? Thanks Chuck Rodgers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
QofQ syntax
I'm trying to do a query of queries like so: 68: 69: SELECT * from myQuery 70: WHERE myStart BETWEEN 71: ( and 72: ) 73: AND myStart >= #createDateTime(Year(getEarlierData.skedDate),Month(getEarlierData.skedDate) ,Day(getEarlierData.WScdDate),0,0,1)# 74: ***Here's the error I get: Query Of Queries syntax error. Encountered "myStart >= {" at line 0, column 0. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, The error occurred in [this file]: line 73 71 : and 72 : 73 :AND myStart >= #createDateTime(Year(getEarlierData.skedDate),Month(getEarlierData.skedDate) ,Day(getEarlierData.skedDate),0,0,1)# 74 : ***Here is the query its trying to do: SELECT * from myQuery WHERE myStart BETWEEN (param 1) and (param 2) AND myStart >= {ts '2003-08-01 00:00:01'} The variable myStart is in the {ts '2003-08-01 00:00:01'} format earlier in the code. Is it that I can't perform this kind of comparision in QofQ? Should I convert the date using datediff or some other function? Thanks! /Keith ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CFMX 6.1: floats being read from DB are truncated?
Hi there, We have just upgraded to CFMX 6.1 and we are having an issue with either CFMX, or the JDBC drivers reading from our SQL 7 database. The problem centers around any float field in the DB, (e.g. 1.0). I can look it up the value of this field in SQL query analyser and get '1.0'. However, if I read that value into a variable, or even just use a cfdump from a query the value I get is not '1.0', but instead '1' - i.e. the value is truncated before the decimal point. This only happens if the number is x.0 - reading in 0.75 from the DB results in 0.75, as you might expect. Does any one know whats is going on here? Is it a problem with the driver SETTINGS, that it doesn't pad decimals with nothing after the decimal point? Is it a SQL server problem? Cheers for any help - I am tearing my hair out :) Ciaran ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
storing xml in sql
Somewhat OT but this is for a CF app and I thought it could be useful for others too. I'm in the processing of making a very flexible OO inventory app. The basic rundown is this. You have a table in the DB called "Products". This is where you inventory goes. Now because this database is going to be used by several different e-commerce apps, it has to be flexible. App 1 may have a field called "MODEL" for the item data to go into the table. App2 might have a field called "YEAR", and etc. Now if I make new columns for every app, I'm going to end up with a products table with like 40 columns. Sure that will work, but its not very organized, and there are things like, one product cant have more than one model, and etc. Instead I want to store the data as XML in a text field. Pretty simple right? I format the data using cfwddx. This way I can easily format the data as it comes in and out of the database. It works great. But now I ran into a problem. What if I want to search by model? Say I want all the items in the database that are model "XYZ". Well the only option I have it to search the xml text field for XYZ, but then I "could" get double the number of fields I want if any other xml data has "XYZ" in it. Does anyone know of a good solution to this? Is there a way to search the specific xml fields while its still in the database? I've looked into the Microsoft OpenXML, but that seems overly complex. Any ideas would be great. Thanks, -Alan ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Okay, how could I accomplish this?
>Yeah, but here's the thing. The tables hold data that can be stuck into >"key, title, body" columns, but the display of each column is different, so >each collection will be displayed differently, thus the "custom1" column in >my cfsearch. I want to mix the results for display purposes, showing scores >correctly ranked when mixed, but I want to display the results differently. >My solution was to search each collection, place the results into a >structure of some sort, including the "custom1" column that will determine >how to display the data on the details page, and sort them all by "score" so >that output results are "sorted" by "score" yet their "colum1" information >will determine how the data is displayed on the following page. > >Make sense? > >So *can* you do that? stick each result set into some sort of data structure >for each query returned, then sort that structure, ordering by "score", then >outputting the results? > >For instance, collection 1 returns the following: >Score - Title (custom1) >97 - My New Title (1) >67 - A Second Title (1) >78 - The Fifth Title (1) > >And collection 2 returns the following: >86 - The Title of This Document is This (2) >76 - I'm Titling This Document Thusly (2) >23 - A Whimsical Title To Enjoy (2) > >Then my output is as follows: >97 - My New Title (1) >86 - The Title of This Document is This (2) >78 - The Fifth Title (1) >76 - I'm Titling This Document Thusly (2) >67 - A Second Title (1) >23 - A Whimsical Title To Enjoy (2) > >See? Then, when you clicked the link, you'd know *which* collection passed >you the results...then you could display it appropriately, if it needs to be >displayed differently (which mine does). Perhaps you could avoid trying to put the two queries into one structure... What you want to do is *exactly* like the merge portion of the merge sort algorithm - the problem is to take two already-sorted data structures and combine them into a single sorted structure. Merge sorts are known to be very fast, so perhaps an efficient solution would be to mimic the merge part of the merge sort algorithm. Here's the basic idea: list A = 1, 3, 4, 6 list B = 2, 3, 5, 7 merge into: 1 2 3 3 4 5 6 7 to merge the two lists: loop while A and B have elements remaining --compare the first elements of A and B --if B is less, append to final list --else, append A's first element instead end loop So to mimic this: Initialize two counters - counterA and counterB - to 1 -- you begin by looking at the first record from each query loop while both counters are LTE their respective recordcount --compare queryA.score[counterA] and queryB.score[counterB] --if the score from B is GT the score from A output info for B, iterate counterB --else output info for A, iterate counterA end loop One thing to remember - you can go through all the records of one query before the other query is finished so you need to test for that. Something like that. Data structures was my favorite class in college :-) Mike Mertsock Alfred University Web Team ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: hard returns and text areas
Chr(10) and Chr(13) in the ASCII table are carriage return with a line feed So do a REReplace(#Chr(10)##Chr(13)#," ",ALL) (may not be syntactically accurate - but you get the idea...) Matt Knight ► w: 972 361 9943 ► m: 214 213 4016 -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 9:23 AM To: CF-Talk hi. does anyone know of a way to identify that a user has entered a hard return into a text-area and then pull those hard returns out (or replace them with just a single space). any help is greatly appreciated. thanks very much. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: hard returns and text areas
use replace to replace "chr(13)" with what ever you like. replace("#string#","chr(13)"," ","ALL") At 10:22 AM 8/20/2003 -0400, you wrote: >hi. does anyone know of a way to identify that a user has entered a hard >return into a text-area and then pull those hard returns out (or replace >them with just a single space). any help is greatly appreciated. thanks >very much. > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Banner Ads
Anyone have any experience with a good CF Banner Ad Application? Perhaps Fusebox? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
No more data available to read
I know that this was a problem with the Oracle db drivers on CFMX pre Updater 3, but I get this error on CFMX6.1 SQL Server I can't recreate it, they where in my email this morning from last night. "Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more data available to read." I tried stopping the SQL Server service and running a site again to see if this error was returned when it could not connect to the SQL Server, but it gives me a completely different error message. So when this error occurred it could reach the SQL Server. So far I don't see anything in the event viewer. Anyone have any ideas? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: oracle datasource as OLEDB
Hi, Sheila. The best connectivity between CF and Oracle /based on my own expirience/ - ODBC with Microsoft ODBC driver for Oracle. We have had many troubles with native drivers under load within 2 years, but those troubles disappeared as soon as we switched to ODBC. Alex. SH> This is my first encounter with Oracle. I need to define a datasource in SH> CF5. As far as using the database, it'll be nothing but the simplest SELECT SH> statements, so that shouldn't be a problem. SH> Is it possible to define an Oracle database with OLEDB, or do I have to use SH> ODBC? Can anyone give me some hints about defining an Oracle datasource? My SH> experience is mostly with Sql Server. SH> ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: oracle datasource as OLEDB
Hi, Sheila. The best connectivity between CF and Oracle /based on my own expirience/ - ODBC with Microsoft ODBC driver for Oracle. We have had many troubles with native drivers under load within 2 years, but those troubles disappeared as soon as we switched to ODBC. Alex. SH> This is my first encounter with Oracle. I need to define a datasource in SH> CF5. As far as using the database, it'll be nothing but the simplest SELECT SH> statements, so that shouldn't be a problem. SH> Is it possible to define an Oracle database with OLEDB, or do I have to use SH> ODBC? Can anyone give me some hints about defining an Oracle datasource? My SH> experience is mostly with Sql Server. SH> ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFC's & Shared Scopes
> If I cache a CFC in the Server scope, then copy it to a local > scope (to avoid locking), is there any performance gain? Or, > should I forget the Server scope all together? You do not need to use locking with a cfc unless there is a race condition possibility. Even then, you can do it in the method. So, for example, if you had a method that set x to x + 1, you would do your lock right there, not in the caller. > I've got a CFC that will be shared across multiple sites... > how do you guys normally handle this?... put it in a shared > scope? make it available as a webservice?... just curious. Depends. Will the CFC need to have instance data? If not, just put one copy in each of the application scopes for simplicity's sake, or just use the server scope. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
storing xml in sql
Issac more or less covered why im using wddx. Because its so simple. You can with with one statement, convert a struct to wddx, and wddx to a struct. You cant get any easier than that. The reasion i chose to store attributes in this manor was for flexibilty and expandability. This is for an inventory system. Currently we have 30+ customers, all who have similiar, and different fields for their product data. And as i said, if i had it all in one field, well that would be a table with 50+ columns. And i also wanted to give the option for the administrators of the app to add new fields and etc. Well if i let them add new fields, and i created new DB columns every time, that would just be a DB disaster. The wddx method worked fine, with little performance issues, i did a test with 1000+ items in the DB, and outputed them all at once, there wasnt much of a load. But as you pointed out, it has its limitations. Im working on something with the best of both worlds i think. I basically made a "product_attributes" table that links to the product table. All the attribtues can go there. Its not what i originally wanted to do, but im meeting myself in the middle here. hah ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFC's & Shared Scopes
Unless there is a race condition (ie Counter = Counter + 1), there is no need to lock in MX. -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 8:18 AM To: CF-Talk Subject: CFC's & Shared Scopes If I cache a CFC in the Server scope, then copy it to a local scope (to avoid locking), is there any performance gain? Or, should I forget the Server scope all together? I've got a CFC that will be shared across multiple sites... how do you guys normally handle this?... put it in a shared scope? make it available as a webservice?... just curious. -Brad ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Where's my CGI.PATH_INFO variable?
> Doesn't the CGI vars depend on what the web-server passes, > and how CF handles them. I have seen differences Apache vs IIS. > /H. Yes but I don't know any of the specifics. > -- > --- > Hugo Ahlenius E-Mail: > [EMAIL PROTECTED] > Project OfficerPhone:+46 8 > 230460 > UNEP GRID-Arendal Fax: +46 8 > 230441 > Stockholm Office Mobile: +46 733 > 467111 >WWW: >http://www.grida.no > -- > --- > | -Original Message- > | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > | Sent: Tuesday, August 26, 2003 01:34 > | To: CF-Talk > | Subject: Re: Where's my CGI.PATH_INFO variable? > | > | > | MX was also the first time I saw the cgi.path_info > variable > | as anything other than the same as cgi.script_name -- it > was > | blank for me also. I just replaced cgi.path_info with > | cgi.script_name throughout all my code and that seemed > to > | work for me. Wish I could provide more detailed > information > | about it, but I really don't know anything more myself. > | > | hth > | > | s. isaac dealey972-490-6624 > | > | team macromedia volunteer > | http://www.macromedia.com/go/team > | > | chief architect, tapestry cms > http://products.turnkey.to > | > | onTap is open source > http://www.turnkey.to/ontap > | > | > | > | > I have a little security device I just on some of my > sites > | > ... if somebody > | > goes to the /secure section of the site, and the > proper > | > client vars haven't > | > been set, they get prompted to login. > | > | > The code begins with this line: > | > | > > | > | > On CF 5.0, this works fine every time. > | > | > Now I'm using this code on a CFMX site, and it's not > | > working. > | > | > In Debug, the CGI variables shows PATH_INFO as blank. > | > | > This bit of debug code: > | > | > > alert('#CGI.PATH_INFO#'); | > tput> > | > | > Shows the PATH_INFO is blank. > | > | > There are other CGI variables that are set, but why is > | > this one blank? I'm > | > using the same browser session on the same machine to > hit > | > the sites on 5.0 > | > and MX, so I don't think it's a browser or client > | > configuration issue. > | > | > Is there a setting in MX admin I'm missing? > | > | > I've installed CFMX 6.1 on a Win2K machine. > | > | > H. s. isaac dealey972-490-6624 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CF in XSL, passing variables
I think I know what you are trying to do, and it's simply not possible. You want to be able to access a variable like a URL variable in a HTML page from within your XSL page. There is a way to do this in Java's implementation of XSL, but not the flavour that Cold fusion have given us. I even went to CF_Europe and cornered a guy about it and he says that MM weren't planning to allow that functionality, and to essentially move on and find another way :( But I did, even though it's a bit of a pain. What I did (this assumes you are using your XSL to render a XML document) was insert a generic node set under the root node of the doc I was trying to render, like so: ...Data 2323221 Oil Filter The values are totally up to you. Since you then know in your XSL that you have a generic nodeset under the root node of your XML document, you can create hidden variables in your HTML from these, and then use them like form variables. Hope this helps your situation :) Ciaran >Hello all, > >I am trying to pass an url variable from one xsl page to another and USE it. > >How could I... > >a.) invoke the url-variable in xsl.. > >OR > >b.) output Cold Fusion in the XSL page, like.. >#url.item# > >this has gotten me NO replies in various XSL forums, >gawd - can't you pass a bloody variable in XSL, what a pain in the a** > >all thanks - flashlight > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
storing xml in sql
Somewhat OT but this is for a CF app and I thought it could be useful for others too. I'm in the processing of making a very flexible OO inventory app. The basic rundown is this. You have a table in the DB called "Products". This is where you inventory goes. Now because this database is going to be used by several different e-commerce apps, it has to be flexible. App 1 may have a field called "MODEL" for the item data to go into the table. App2 might have a field called "YEAR", and etc. Now if I make new columns for every app, I'm going to end up with a products table with like 40 columns. Sure that will work, but its not very organized, and there are things like, one product cant have more than one model, and etc. Instead I want to store the data as XML in a text field. Pretty simple right? I format the data using cfwddx. This way I can easily format the data as it comes in and out of the database. It works great. But now I ran into a problem. What if I want to search by model? Say I want all the items in the database that are model "XYZ". Well the only option I have it to search the xml text field for XYZ, but then I "could" get double the number of fields I want if any other xml data has "XYZ" in it. Does anyone know of a good solution to this? Is there a way to search the specific xml fields while its still in the database? I've looked into the Microsoft OpenXML, but that seems overly complex. Any ideas would be great. Thanks, -Alan ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
WOT: SQL Data types
I am curious how religiously people stay true to using data types for MS SQL Server. I know some of these stretch to other RDBMS's, however, I would like to know what people in industry think. What type of general rules of thumb do people follow when planning data types for a data store? For instance Money, Numeric, varchar, int, bigint ... I think you get the point. I am looking for response such as; never use that type, it won't convert to Oracle. Never use that type, the space you save is not worth it, etc If this needs more elaboration, please let me know Mike. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Banner Ads
Anyone have any experience with a good CF Banner Ad Application? Perhaps Fusebox? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
cfc vs php rule of thumb
> > > > > I guess this would be the answer (did not know u could cfinclude right away). But the other posts raised some interesting questions: Didn't quite understand the INI suggestion (Raymond Camden) Is it recommendable to put CFCs in the application scope? (Barney Boisvert) how will things work when using: Thanks Mauricio ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Okay, how could I accomplish this?
The pseudocode below is a little off. The loop condition should be while counterA is LTE queryA's recordcount *or* counterB is LTE queyrB's recordcount. >Initialize two counters - counterA and counterB - to 1 -- you begin by >looking at the first record from each query > >loop while both counters are LTE their respective recordcount >--compare queryA.score[counterA] and queryB.score[counterB] >--if the score from B is GT the score from A >output info for B, iterate counterB >--else >output info for A, iterate counterA >end loop > >One thing to remember - you can go through all the records of one >query before the other query is finished so you need to test for that. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Index.cfm problem
Very strange problem. We run a variety of .cfm pages, we decided to convert our homepage over from index.html to index.cfm, when I point IIS to run index.cfm and the default page we get a 404 error, if I rename the index.cfm to index1.cfm and repoint IIS it works fine. If I go directly to http://ourwebsite/inde.cfm, I get a jrun servlet error and the url changes to /CFIDE/administrator/index.cfm with a 404 error. What could be causing this? The IIS settings look fine, if I copy the index.cfm to another website on the same box and point to it everything is fine. JRUN 4 SP2 with CFMX 6.0 updater3 and Win2k Suggestions? - Alex ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Congressional Data
Hi, I did that and searching for congress data or congressional data did not turn up anything. Chuck Rodgers - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 12:14 PM Subject: Re: Congressional Data > I seem to recall this data being asked for a year or so ago on this > list.might want to check the archives > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: "Chuck Rodgers" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 20, 2003 8:46 AM > Subject: OT: Congressional Data > > > > Hi, > > > > I am working with an association that wants to do some advocacy work with > their members. We are looking for data for zip codes and congressional > districts to do lookups for Representatives in Congress. Anyone have any > experience finding this kind of data? > > > > Thanks > > > > Chuck Rodgers > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFMX 6.1: floats being read from DB are truncated?
Hi there, We have just upgraded to CFMX 6.1 and we are having an issue with either CFMX, or the JDBC drivers reading from our SQL 7 database. The problem centers around any float field in the DB, (e.g. 1.0). I can look it up the value of this field in SQL query analyser and get '1.0'. However, if I read that value into a variable, or even just use a cfdump from a query the value I get is not '1.0', but instead '1' - i.e. the value is truncated before the decimal point. This only happens if the number is x.0 - reading in 0.75 from the DB results in 0.75, as you might expect. Does any one know whats is going on here? Is it a problem with the driver SETTINGS, that it doesn't pad decimals with nothing after the decimal point? Is it a SQL server problem? Cheers for any help - I am tearing my hair out :) Ciaran ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
cfc vs php rule of thumb
Hello When developing in PHP, it is common to have something like this in a class document: // start include 'my_config_file.php'; class MyClass { // properties and functions } // end Where my_config_file.php is a file that has constants and other shared variables. I am familiar with CFCs also but am not sure what would be the right way to go on this issue. It is good to have an external file with common variables, and sometimes people have them inside Application.cfm but you don't always want to have them there. Can anyone shed any light on this issue? Thanks - mga _ MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Question about cf and ldap
I read somewhere that it needs to be a full name, >not just the actual username, but I'm not sure what this means. You probably need to use a full-qualified Windows domain name. In your code snippet, it would be something like the following: ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
ckeck for finished download
Hi I have a page, where users can download files. It is done with cfheader and cfcontent. I want to receive a mail, as soon as the download is finished. I manage to send a mail (cfmail), if the user starts the download. That means, when I receive the mail, I am not shure, if the user ever finished the download. Is there a possibility to check if a download is finished? Thank you Margrit ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: CF Studio/HomeSite+
True, and Dreamweaver is cheaper than Studio was. Clint - Original Message - From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 9:14 AM Subject: RE: CF Studio/HomeSite+ > Homesite+ is the only version of 'Studio' which MM still actively supports > and develops AFAIKit is also ONLY included with DWMX > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: 21 August 2003 10:32 > To: CF-Talk > Subject: CF Studio/HomeSite+ > > > Which of the two is still being maintained, even if not sold directly, by > Macromedia? Would it be Homesite+, since it's included with Dreamweaver MX? > > We need to purchase a couple of additional licenses for CF Studio. We're > not > working with CF6 MX and have no plans to move away from CF5 Server. We > don't > have much use for Dreamweaver or any of the other Studio MX components. So > what > would be the best (and cheapest) route to aquiring a couple of > Studio/Homesite+ > licenses? If contacted directly, will Macromedia sell you CF Studio > licenses, > even though its no longer a product available for purchase from their web > page? > > Jim > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Okay, how could I accomplish this?
The pseudocode below is a little off. The loop condition should be while counterA is LTE queryA's recordcount *or* counterB is LTE queyrB's recordcount. >Initialize two counters - counterA and counterB - to 1 -- you begin by >looking at the first record from each query > >loop while both counters are LTE their respective recordcount >--compare queryA.score[counterA] and queryB.score[counterB] >--if the score from B is GT the score from A >output info for B, iterate counterB >--else >output info for A, iterate counterA >end loop > >One thing to remember - you can go through all the records of one >query before the other query is finished so you need to test for that. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: JavaScript question??
Mario, try doing this. document.selectedIndex == null I believe that will tell check if the user has selected anything in the drop-down box. Hope this helps. >From: "Ciliotta, Mario" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: OT: JavaScript question?? >Date: Fri, 22 Aug 2003 18:07:16 -0400 > >Hi all, > >Sorry for the OT on JavaScript but I cannot figure out how to tell if >someone has selected in option in the box. I know how to do it if the I >add another option at the beginning: Please select >one... and then use : documentoptions[0].selected to >see if the first one is selected but I cannot figure out how to do it >below. The users want the boxed sized to be the same a recordcount of the >query. > > > > 1700 - CORPORATE >SERVICES > 1701 - BUILDING & >FACILITIES > 1702 - > CSD >FINANCE & ACCOUNTS PAYABLE > 1703 - SECURITY > 1704 - > INFORMATION >MANAGEMENT > 1706 - GSS > 1707 - ICSG > 1708 - GENERAL >SERVICES > 1710 - LIS & ARM > > >Thanks >Mario > >This message is for the named person's use only. It may contain sensitive >and private proprietary or legally privileged information. No >confidentiality or privilege is waived or lost by any mistransmission. If >you are not the intended recipient, please immediately delete it and all >copies of it from your system, destroy any hard copies of it and notify the >sender. You must not, directly or indirectly, use, disclose, distribute, >print, or copy any part of this message if you are not the intended >recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE >FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT >SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications >through its networks. Any views expressed in this message are those of the >individual sender, except where the message states otherwise and the sender >is authorized to state them to be the views of any such entity. >Unless otherwise stated, any pricing information given in this message is >indicative only, is subject to change and does not constitute an offer to >deal at any price quoted. Any reference to the terms of executed >transactions should be treated as preliminary only and subject to our >formal written confirmation. > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Okay, how could I accomplish this?
The pseudocode below is a little off. The loop condition should be while counterA is LTE queryA's recordcount *or* counterB is LTE queyrB's recordcount. >Initialize two counters - counterA and counterB - to 1 -- you begin by >looking at the first record from each query > >loop while both counters are LTE their respective recordcount >--compare queryA.score[counterA] and queryB.score[counterB] >--if the score from B is GT the score from A >output info for B, iterate counterB >--else >output info for A, iterate counterA >end loop > >One thing to remember - you can go through all the records of one >query before the other query is finished so you need to test for that. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
multiple user login
I would like to have two applications of Mozilla open on the same machine and login on each application with a seperate user. Margrit >Margrit John wrote: >> >> I' am using CF MX and made a login with cflogin. IE allows >> on the same computer multiple different users to login. >> Mozilla accepts only one user to login. >> >> If I login twice with two different users in Mozilla, the >> second logedin user gets to see the page of the first >> logedin user. >> >> Has anyone an idea how to handle this? > >Which behaviour do you want? > >Jochem > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
WOT: Securing word docs, excel, etc in a web app
Hi, This is off topic, but I am sure many of you have had to deal with issues such as these in the past. I have been living in a bubble for the past 3 years and have developped many web apps in CF, ASP and JSP on secure networks with no Internet connection. For the first time, I am building an Internet based web app in CF. Creating the members only portion with user authentication and so on is no problem. However, the site's main focus is to share research data among members. Most members want to upload MS Word docs, MS Excel docs and PDFs. The site will be hosted at an ISP, so using IIS or NT security is not an option. So here is my dilema, once I have uploaded documents that I only want members to access, how can I achieve something better than "security through obscurity" and prevent people from stumbling on the docs by guessing or as the result of a search engine search? Same question for images. There will be images in .jpg and .gif format which are destined for members eyes only. Any recommendations appreciated. Grif ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Coldfusion and Palm Calendar
Anyone out there used/developed any good tools that would allow data to be downloaded from a coldfusion component / web services / etc.. in to Palm's Calendar? Thanks, Glen Salisbury [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Okay, how could I accomplish this?
The pseudocode below is a little off. The loop condition should be while counterA is LTE queryA's recordcount *or* counterB is LTE queyrB's recordcount. >Initialize two counters - counterA and counterB - to 1 -- you begin by >looking at the first record from each query > >loop while both counters are LTE their respective recordcount >--compare queryA.score[counterA] and queryB.score[counterB] >--if the score from B is GT the score from A >output info for B, iterate counterB >--else >output info for A, iterate counterA >end loop > >One thing to remember - you can go through all the records of one >query before the other query is finished so you need to test for that. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: hard returns and text areas
use replace to replace "chr(13)" with what ever you like. replace("#string#","chr(13)"," ","ALL") At 10:22 AM 8/20/2003 -0400, you wrote: >hi. does anyone know of a way to identify that a user has entered a hard >return into a text-area and then pull those hard returns out (or replace >them with just a single space). any help is greatly appreciated. thanks >very much. > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Okay, how could I accomplish this?
>Yeah, but here's the thing. The tables hold data that can be stuck into >"key, title, body" columns, but the display of each column is different, so >each collection will be displayed differently, thus the "custom1" column in >my cfsearch. I want to mix the results for display purposes, showing scores >correctly ranked when mixed, but I want to display the results differently. >My solution was to search each collection, place the results into a >structure of some sort, including the "custom1" column that will determine >how to display the data on the details page, and sort them all by "score" so >that output results are "sorted" by "score" yet their "colum1" information >will determine how the data is displayed on the following page. > >Make sense? > >So *can* you do that? stick each result set into some sort of data structure >for each query returned, then sort that structure, ordering by "score", then >outputting the results? > >For instance, collection 1 returns the following: >Score - Title (custom1) >97 - My New Title (1) >67 - A Second Title (1) >78 - The Fifth Title (1) > >And collection 2 returns the following: >86 - The Title of This Document is This (2) >76 - I'm Titling This Document Thusly (2) >23 - A Whimsical Title To Enjoy (2) > >Then my output is as follows: >97 - My New Title (1) >86 - The Title of This Document is This (2) >78 - The Fifth Title (1) >76 - I'm Titling This Document Thusly (2) >67 - A Second Title (1) >23 - A Whimsical Title To Enjoy (2) > >See? Then, when you clicked the link, you'd know *which* collection passed >you the results...then you could display it appropriately, if it needs to be >displayed differently (which mine does). Perhaps you could avoid trying to put the two queries into one structure... What you want to do is *exactly* like the merge portion of the merge sort algorithm - the problem is to take two already-sorted data structures and combine them into a single sorted structure. Merge sorts are known to be very fast, so perhaps an efficient solution would be to mimic the merge part of the merge sort algorithm. Here's the basic idea: list A = 1, 3, 4, 6 list B = 2, 3, 5, 7 merge into: 1 2 3 3 4 5 6 7 to merge the two lists: loop while A and B have elements remaining --compare the first elements of A and B --if B is less, append to final list --else, append A's first element instead end loop So to mimic this: Initialize two counters - counterA and counterB - to 1 -- you begin by looking at the first record from each query loop while both counters are LTE their respective recordcount --compare queryA.score[counterA] and queryB.score[counterB] --if the score from B is GT the score from A output info for B, iterate counterB --else output info for A, iterate counterA end loop One thing to remember - you can go through all the records of one query before the other query is finished so you need to test for that. Something like that. Data structures was my favorite class in college :-) Mike Mertsock Alfred University Web Team ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com