Sites & discussion groups for coldfusion
Hi friends, I am working in coldfusion. I have done a demo project. I want to host it in the real server. Can anybody tell me the sites for coldfusion free hosting other than cfm-resources.com & cf-developer.net? with thanks & regards, G. KISHORE KUMAR Mail : [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Could Not Delete From Specified Tables
Patty: When you go into the relationships window in Access 2000, you can add your tables (which I gather you've done) to the diagram and then specify which fields match up, whether to enforce referential integrity between them, and what join type they use. Basically once you relate a primary key to other fields, those fields are considered foreign keys to the primary. So you only want one primary key called cabinID in the cabins table. The cabinID fields in the other two tables, the photo tables, will be foreign keys, which you don't have to specify directly. Basically they can even be foreign keys if you DON'T specify a relationship between them and the primary key, however as a best practice you want to have the database do as much work as possible so you don't have to manually enforce the relationships or cascade update and delete manually within your code. I've responded more below under your questions: > -Original Message- > From: P@tty Ayers [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 7:59 PM > To: CF-Talk > Subject: Re: Could Not Delete From Specified Tables > > > > Andy - Thanks for your response. (Still welcoming any help from others as > well..) > > > Do you mean you have a primary key called photoID in this table as a > primary key? cabinID in this table should be a foreign key, > related to the > cabins table. > > Okay, I just checked and no, actually I didn't make photoID in the table > 'photos' a primary key. I *did* make 'otherphotoID' in 'otherphotos' a > primary key. > > Let me see if I am understanding you - should the two secondary > tables, each > which have a 'cabinID' column, each have 'cabinID' as a foreigh key, and > neither should have a primary key? Both should have a primary key (again as a good database design practice, but not always necessary). Name the keys whatever you want. I suggest photoID and otherphotoID, as you have it now. Both should also have cabinID as a foreign key, related to the primary key cabinID in the cabins table. > > And (forgive my ignorance) how do I make a foreign key? I'm looking in > Access's help files and a reference book, but haven't found it yet. In the relationships window, you can specify which keys are related. You can, for instance, click on the primary key in cabins (cabinID), hold down the mouse button and drag to the foreign key in photos (cabinID). A box will pop up (I take it you might've done this already) where you can specify more options for how the fields are related, join types, and more. Sorry if I've repeated myself -- it's late and time to sleep! - Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Create login page with secure
Hallo everyone, Can anyone help me to create a login page securely? I you have made login page, can you give your source code? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
Check us out at CFDynamics http://www.cfdynamics.com -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:57 PM To: CF-Talk Subject: Hosting recommendations I am looking for hosting recommendations for multiple client sites. Requirements include CF 4.x SQL Server 7.0 MS Access Cybercash ASP Particularly interest in hosts with a good availability track record and excellent support... so I won't be be spending all my time performing support duties. TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: chat room application
Somebody posted a link here a couple weeks ago about passing data between the client and the server with tags using JavaScript -- it was a brilliant idea and would probably work well for a chat application, but I can't find the link any more. tom "Jason Green" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > does anyone know of a place where i can find information about writing a > chat room in coldfusion? or has anyone done this? i'm looking for > something that would be like MSN Messenger, but not having to refresh the > page all the time to view the new chats. if it can't be done in coldfusion, > then i'll have to look elsewhere. thanks. > > jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spectra
No, you need Spectra installed and licensed on the host machine. This is because Spectra is a set of custom templates and tags that make up the system. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "Joseph Thompson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 05, 2001 10:57 PM Subject: Spectra > If you develop a site with Spectra, will it be possible to "host" that site > on a CF 4.x server whithout Spectra? > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Spectra
If you develop a site with Spectra, will it be possible to "host" that site on a CF 4.x server whithout Spectra? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
This question comes up all the time and it always leads to a huge amount of posts for different hosts. A very good list of CF hosts can be found here: http://www.forta.com/cf/isp The lists, HoF and FA are all hosted through CFHosting. Let me say publicly that while we all see me at the front of the community we rarely think of those who are in the back helping to keep the networks running and providing support. Thanks to them we have a number of resources and more coming. Thanks CFHosting > I am looking for hosting recommendations for multiple client sites. > > Requirements include > >CF 4.x >SQL Server 7.0 >MS Access >Cybercash >ASP > > Particularly interest in hosts with a good availability track record > and excellent support... so I won't be be spending all my time > performing support duties. > > TIA > > Dick > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Windows ME
I'm running CF Server on an ME box with PWS 4.0 on a machine. I didn't have any problems installing at all. Hatton -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 7:17 PM To: CF-Talk Subject: Windows ME Hi, I'm not having any luck installing CF 4.5 on Windows Millenium Edition, and I vaguely remember someone mentioning months ago on this list that it was difficult or impossible--does anybody know for sure? I've got a little ThinkPad 560X laptop with Windows ME already on it that I'd like to use for portable CF developing and was hoping I could get a good CF install. If I can't use Windows ME, what would perform best on that machine (233 MHz, 64 megs RAM, 4 gig hard drive), Win 95 or Win 98? TIA, Karl Simanonok Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: adding records
Hi Bec, This works for me: It gives me a pulldoen of the "lastname, firstname" of the person. When a name is selected it auto fills in the "email address" from the database into the TO: field of the form. The pulldown is right above the input field but they could be in seperate places on the page. It uses a javascript "document.formname.fieldname.value" to locate the field it needs to fill in. Select * FROM dbCEAddressBook ORDER BY lastname, firstname --snip-- --snip-- To: #LastName#, #FirstName# --snip-- Let me know if you have any questions. Michael -- >From: "Jones, Becky" <[EMAIL PROTECTED]> >To: CF-Talk <[EMAIL PROTECTED]> >Subject: FW: adding records >Date: Thu, Apr 5, 2001, 3:11 PM > > > hey again, > i have a form which allows a user to add a new application to my apps > database. > i want to have a drop down list of companies. (that i can do) but i want the > phone number field to automatically populate if when the user selects say > "microsoft" from the list. that phone number will show up in the phone > number field because "microsoft" has a phone number in my database. > otherwise, the person inputting the data will have to retype the phone > number in each time (and remember the number in order to input it!) > is this possible to do on the same form? > thanks for the info.. > b > > > * > This e-mail, including any attachments, is intended for the > receipt and use by the intended addressee(s), and may contain > confidential and privileged information. If you are not an intended > recipient of this e-mail, you are hereby notified that any unauthorized > use or distribution of this e-mail is strictly prohibited. > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
Well, well... since the shameless plugs have started... go with www.atswebnet.com. I am a very happy customer that would not use any other host... they are hands down the best in my humble opinion. Clint -- Original Message -- From: "Lee Fuller" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 05 Apr 2001 18:41:56 -0700 We do all of those things... www.aaawebhosting.com Just a shameless plug! :) Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation > -Original Message- > From: Dick Applebaum [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:57 PM > To: CF-Talk > Subject: Hosting recommendations > > > I am looking for hosting recommendations for multiple client sites. > > Requirements include > >CF 4.x >SQL Server 7.0 >MS Access >Cybercash >ASP > > Particularly interest in hosts with a good availability track record > and excellent support... so I won't be be spending all my time > performing support duties. > > TIA > > Dick > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedure
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes! Check out xp_cmdshell and the dtsrun command-line executable. :) Joe > -Original Message- > From: Joshua Tipton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 5:29 PM > To: CF-Talk > Subject: Stored Procedure > > > Is it possible for a stored procedure to run a dts package. > > Joshua Tipton > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: chat room application
so how does microsoft do their chat rooms running asp? or is it asp with java mixed in? >From: Costas Piliotis <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: chat room application >Date: Thu, 05 Apr 2001 15:29:20 -0700 > >Isn't there a meta-tag that forces a refresh? > >How about using the setInterval javascript method? > >You're right though, an Applet is the best way to write this... > >-Original Message- >From: Clint Tredway [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 05, 2001 1:25 PM >To: CF-Talk >Subject: Re: chat room application > > >you have to refresh the page to get new messages. browsers don't work any >other way. to do this you need an applet to do what you want. > >I built a simple chat application for this reason. > >-- Original Message -- >From: "Jason Green" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >Date: Thu, 05 Apr 2001 18:38:07 - > >does anyone know of a place where i can find information about writing a >chat room in coldfusion? or has anyone done this? i'm looking for >something that would be like MSN Messenger, but not having to refresh the >page all the time to view the new chats. if it can't be done in >coldfusion, > >then i'll have to look elsewhere. thanks. > >jason > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
We do all of those things... www.aaawebhosting.com Just a shameless plug! :) Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation > -Original Message- > From: Dick Applebaum [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:57 PM > To: CF-Talk > Subject: Hosting recommendations > > > I am looking for hosting recommendations for multiple client sites. > > Requirements include > >CF 4.x >SQL Server 7.0 >MS Access >Cybercash >ASP > > Particularly interest in hosts with a good availability track record > and excellent support... so I won't be be spending all my time > performing support duties. > > TIA > > Dick > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Windows ME
I'm not having any joy with CF on my ME machine either so next weekend I'm upgrading to Win 2K - that should fix it. It did run OK when my machine was running 98 if that's of any help. Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: +61 8 82332548 f: +61 8 82332000 m: 0418 800 287 -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 April 2001 8:47:AM To: CF-Talk Subject: Windows ME Hi, I'm not having any luck installing CF 4.5 on Windows Millenium Edition, and I vaguely remember someone mentioning months ago on this list that it was difficult or impossible--does anybody know for sure? I've got a little ThinkPad 560X laptop with Windows ME already on it that I'd like to use for portable CF developing and was hoping I could get a good CF install. If I can't use Windows ME, what would perform best on that machine (233 MHz, 64 megs RAM, 4 gig hard drive), Win 95 or Win 98? TIA, Karl Simanonok Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: chat room application
e.g. http://www.mysite.com/index.htm"> But I', not sure this is an appropriate application for what you are trying to do. I think you can also set a page expiry date in the past for the same effect but again I'm not too sure this is an appropriate application for this code. Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: +61 8 82332548 f: +61 8 82332000 m: 0418 800 287 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 April 2001 7:59:AM To: CF-Talk Subject: RE: chat room application Isn't there a meta-tag that forces a refresh? How about using the setInterval javascript method? You're right though, an Applet is the best way to write this... -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:25 PM To: CF-Talk Subject: Re: chat room application you have to refresh the page to get new messages. browsers don't work any other way. to do this you need an applet to do what you want. I built a simple chat application for this reason. -- Original Message -- From: "Jason Green" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 05 Apr 2001 18:38:07 - does anyone know of a place where i can find information about writing a chat room in coldfusion? or has anyone done this? i'm looking for something that would be like MSN Messenger, but not having to refresh the page all the time to view the new chats. if it can't be done in coldfusion, then i'll have to look elsewhere. thanks. jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: adding records
i don't think it will directly do it. i've worked with it, and she wants to populate a textbox, not another drop down. but i think you can abuse the tag by writing your own handler for what it already does. just replace the bit that changes the second select box to populate the text box. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 6:50 PM To: CF-Talk Subject: RE: adding records Check out the Allaire Developer's Exchange for CF_TwoSelectsRelated custom tag. This will do exactally what you want. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA 9700508B94F380&method=Full (carefull of the line wrapping...) Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:43 PM To: CF-Talk Subject: adding records hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduled tasks using CF
Problems we've had are mostly with CF not recognizing a scheduled task, or not updating it when changes have been made. I'm not sure we've ever seen "intermitant" running of scheduled tasks, where it just doesn't work sometimes, but works other times. If reliability is an issue, then don't use the CF scheduler. It's really as simple as that. The built-in NT scheduler has never failed us, and third party schedulers for NT are inexpensive, simple to use, and 100% reliable. For some people, CF scheduler works flawlessly. If you have room to test it in your environment and can monitor it, see if CF's scheduler works for you. I monitor scheduled events by either having CF send an email to me upon completion and/or having the task make entries into a log file. Jim - Original Message - From: "Michael S. Kimmett" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 05, 2001 4:03 PM Subject: Scheduled tasks using CF > Question? > > What are some of the problems you or a client has had with scheduled tasks using CF? Specifics of the incident and the resolution would be very helpful. Also if you know, the web server used and version of CF server would be helpful. > > I am building a application for a client and reliablity is very important. If scheduled tasks are going to fail often, then the reliable answer will be to have this done manually. > > Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Could Not Delete From Specified Tables
Andy - Thanks for your response. (Still welcoming any help from others as well..) > Do you mean you have a primary key called photoID in this table as a primary key? cabinID in this table should be a foreign key, related to the cabins table. Okay, I just checked and no, actually I didn't make photoID in the table 'photos' a primary key. I *did* make 'otherphotoID' in 'otherphotos' a primary key. Let me see if I am understanding you - should the two secondary tables, each which have a 'cabinID' column, each have 'cabinID' as a foreigh key, and neither should have a primary key? And (forgive my ignorance) how do I make a foreign key? I'm looking in Access's help files and a reference book, but haven't found it yet. My original message is quoted below. Thank you again, P@tty [original message] I've created a Delete Record page, but when I test it, I get an error message simply saying "Could not delete from specified tables." Any ideas at all why? A little information on the database: It's in Access2000 and has three tables, 'cabins', 'photos' and 'otherphotos'. cabins has cabinID as its primary key, each rental cabin is a record. photos also has cabinID as a primary key, and I created a relationship between the two tables using the two cabinID fields. otherphotos has otherphotoID as its primary key, and each record is a photo, each associated with, again, cabinID. cabins is related to otherphotos by the cabinID column. Both of the relationships are one-to-many, and I have checked "Enforce Referential Integrity" and "Cascade Update Related Fields." > > > > > > > otherphotos has otherphotoID as its primary key, and each record > > is a photo, > > each associated with, again, cabinID. cabins is related to otherphotos by > > the cabinID column. > > > > Both of the relationships are one-to-many, and I have checked "Enforce > > Referential Integrity" and "Cascade Update Related Fields." > > > > Are you trying to delete a cabin record? It should work then, and also cascade delete all records that contain a foreign key in the other photo tables, based on how you say you have it set up. If you DO have the cabinID set as a primary key in the photos table, this could be your problem. > > > > > > > Your help and suggestions are GREATLY appreciated! > > > > P@tty Ayers > > Macromedia Evangelist > > > - Andy > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hosting recommendations
I am looking for hosting recommendations for multiple client sites. Requirements include CF 4.x SQL Server 7.0 MS Access Cybercash ASP Particularly interest in hosts with a good availability track record and excellent support... so I won't be be spending all my time performing support duties. TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can cfhttp access to https?
> Can cfhttp access to https site and get the files with username > and pasword > provided? https://www.blah.com" method="GET" port="443" username="DOMAIN\USERNAME" password="**" resolveurl="TRUE" throwonerror="YES"> I've been following this thread and had a question. I thought I had read that the code above would only work on NT if the Web server was not using NT Challenge/Response for security. Is that correct? Also, does that mean that it work won't on the server if it is running or only for the directory you choose to secure that way? Ok, that's two questions. TIA Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (646) 638-3444 http://www.hallofsports.com .. . . where the legends live on > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting the value of a variable, once removed
By the way, you can just use #Evaluate(collist)# and get rid of the extra quotes and pound signs. - Andy > -Original Message- > From: Hayes, David [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 5:50 PM > To: CF-Talk > Subject: RE: Getting the value of a variable, once removed > > > look at Evaluate. > > #evaluate("#collist#")# > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 3:04 PM > To: CF-Talk > Subject: Getting the value of a variable, once removed > > > > I have this: > > > > OPTIONAL IS 0) > > > #COLLIST# > > > > > > The #COLLIST# variable contains the name of another variable (a > table column > name) which is the value I *really* need. I know this sounds confusing. > Say the current #COLLIST# value is ACCT. What I really need is > the value of > #ACCT#, not ACCT (the value of #COLLIST#). Basically what I want to do is > find out what > columns were selected, and then display the value of the fields, not the > name of the column (which is what I get now). > The value of #GetFromUAT.Columnlist# would be something like this: > ACCT,BMPRICE,BMREV,BMVOL,NETPRICE,NETREV,NETVOL > The value of #ACCT#, for example, would be something like this: > 493892847855103 ; > the value of #BMPRICE# would be 34.48, etc. > So, for each of the values in the #GetFromUAT.Columnlist#, I need the > underlying value - > (in the ACCT example, I actually need to return 493892847855103 (the > value of #ACCT#), not ACCT (the value of #COLLIST#). > I hope someone can understand this and help me out. I need a function like > #TheValueOfThisValue(Var)#. > > Gina Shillitani > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ALTER TABLE query help
Hi group, When using a query to alter table structure in Access like so: ALTER TABLE dynamicmultipage ADD CleverFieldName TEXT(50) Is there any way to set some other field attributes when I create this field? Specifically, Access seems to default to "Allow zero length" of NO. I need to set it to YES. TIA, Douglas Malcolm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert to two tables
I do the same! > -Original Message- > From: Jason Green [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 5:40 PM > To: CF-Talk > Subject: Re: insert to two tables > > i have had this issue before and the only way i could come up with it is > insert into the peopletable and then query it with the same info you just > inserted, thus giving you the id of that personthen insert into the > appointment table > > it's a pain, but i haven't found an easier solution > > jason > > > >From: Aimee Abbott <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: insert to two tables > >Date: Thu, 05 Apr 2001 14:08:41 -0600 > > > >Hello everyone. > > > >I have mostly worked on very simple, single table, cold fusion projects > but > >now I need to do something where I need to add information into two > >tables. I have something like this: > > > >PeopleTable > >personID Autonumber > >name Text > >address Text > > > >AppointmentTable > >aptIDAutonumber > >PersonID Number > >AptName Text > >AptDate Date/Time > > > >The information for both tables come from one entry form on a web page. > I > >have a second page to do the insert. When I insert the person into the > >person table, how do I find out what the personID was so I can enter it > >into the AppointmentTable/PersonID? Or can I do some sort of more > complex > >insert statement that inserts into both tables at once? What if I add a > >third table? Does it get more complex? Should I setup the join as a > >relationship in microsoft access? > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Windows ME
Hi, I'm not having any luck installing CF 4.5 on Windows Millenium Edition, and I vaguely remember someone mentioning months ago on this list that it was difficult or impossible--does anybody know for sure? I've got a little ThinkPad 560X laptop with Windows ME already on it that I'd like to use for portable CF developing and was hoping I could get a good CF install. If I can't use Windows ME, what would perform best on that machine (233 MHz, 64 megs RAM, 4 gig hard drive), Win 95 or Win 98? TIA, Karl Simanonok Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT But Urgent - Knock CF if you dare
Give these FUD tactics the attention they deserve - none. Talk to your potential client about the things that you have done with CF. That's what will be relevant for your client. Also, ask the competitor to substantiate their claims. Take the high ground, and refuse to mud sling. By throwing mud back, you are lowered to their level, and there is no differentiation between the two of you. Kevin >>> [EMAIL PROTECTED] 04/05/01 02:03PM >>> Hi all, We use a little bit of ASP with CF from time to time. We are pitching for a contract whereby the opposition are slating CF big time. In actual fact they are saying all sorts of bad things about CF to the client in an effort to get the client to move to ASP. Any Amunition out there i can fire back with. I dont normally slate ASP but they have started this. Articles would be good... Appreciate the help Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) http://www.cfug.ie The Irish Cold Fusion User Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Could Not Delete From Specified Tables
P@tty, If you have the tables related, with 'cabins' as the "parent" table, you cannot normally delete a 'cabins' record while there exist "child" records in 'photos' or 'otherphotos' with the same key (cabinID). You can use cascading delete in Access to do this. (As in "flows downhill".) Or, you can first delete all the photos for that cabinID, and subsequently delete the cabin record. HTH. Ben -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:29 PM To: CF-Talk Subject: RE: Could Not Delete From Specified Tables > -Original Message- > From: P@tty Ayers [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 3:26 PM > To: CF-Talk > Subject: Could Not Delete From Specified Tables > > > Ok, you all helped me tremendously this morning, so I'm hoping someone can > point me in the right direction on this new problem. > > I've created a Delete Record page, but when I test it, I get an error > message simply saying "Could not delete from specified tables." > Any ideas at > all why? > > A little information on the database: > > It's in Access2000 and has three tables, 'cabins', 'photos' and > 'otherphotos'. > > cabins has cabinID as its primary key, each rental cabin is a record. > > photos also has cabinID as a primary key, and I created a relationship > between the two tables using the two cabinID fields. Do you mean you have a primary key called photoID in this table as a primary key? cabinID in this table should be a foreign key, related to the cabins table. > > otherphotos has otherphotoID as its primary key, and each record > is a photo, > each associated with, again, cabinID. cabins is related to otherphotos by > the cabinID column. > > Both of the relationships are one-to-many, and I have checked "Enforce > Referential Integrity" and "Cascade Update Related Fields." Are you trying to delete a cabin record? It should work then, and also cascade delete all records that contain a foreign key in the other photo tables, based on how you say you have it set up. If you DO have the cabinID set as a primary key in the photos table, this could be your problem. > > Your help and suggestions are GREATLY appreciated! > > P@tty Ayers > Macromedia Evangelist - Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT But Urgent - Knock CF if you dare
Here are a couple of useful URL's http://www.webreview.com/2000/09_01/developers/09_01_00_1.shtml This is Microsoft's take on CFAS http://msdn.microsoft.com/library/default.asp?URL=/library/periodic/period00 /coldfusion.htm Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.allaire.com/services/consulting/ -Original Message- From: Daryl Fullerton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:04 PM To: CF-Talk Subject: OT But Urgent - Knock CF if you dare Hi all, We use a little bit of ASP with CF from time to time. We are pitching for a contract whereby the opposition are slating CF big time. In actual fact they are saying all sorts of bad things about CF to the client in an effort to get the client to move to ASP. Any Amunition out there i can fire back with. I dont normally slate ASP but they have started this. Articles would be good... Appreciate the help Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: adding records
It is but its pretty lengthy. I do this type of thing all the time. It involves the use of a Javascript and I use a Fusebox method. Are you familiar with writing CF using a Fusebox? Let me know if you have any background with the Fusebox method and some Javascript. Feel free to e-mail direct. Thanks, Kevin -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:43 PM To: CF-Talk Subject: adding records hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: adding records
Check out the Allaire Developer's Exchange for CF_TwoSelectsRelated custom tag. This will do exactally what you want. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA 9700508B94F380&method=Full (carefull of the line wrapping...) Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:43 PM To: CF-Talk Subject: adding records hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
Thanks to all! especially Richard who turned me on to this site that does exactly what i needed! http://www.webreference.com/dhtml/column18/ i feel some tight design coming on! this list is great! -paul > -Original Message- > From: Semrau, Steven L Mr SRA [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:17 PM > To: CF-Talk > Subject: RE: DHTML Menu :: Spanning frameset? > > I'm not sure what you might be looking for as a replacement, currently I'm > using the Joust DHTML menu (http://www.ivanpeters.com/) which is freeware. > Although it doesn't accomplish what you are looking for as far as the > 'overlapping' it does allow you to specify that a menu item's description > be > 'wrapped' to accommodate text that extends beyond the width of your frame. > It's quite flexible and I'm currently using it to create several dynamic > menu systems based upon multiple queries. > > Hope this helps. > > Steven Semrau > SRA International, Inc. > Senior Member, Professional Staff > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Com: (703) 805-1095 > DSN: (703) 655-1095 > > > -Original Message- > From: Paul Ihrig [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 2:30 PM > To: CF-Talk > Subject: RE: DHTML Menu :: Spanning frameset? > > > do you have any suggestions? > i would hate to include this chunk of code on every page... > that is very tiresome. > > some one must have an idea? > > -paul > > Web Developer, NBBJ > Work: [EMAIL PROTECTED] > 614 241-3534 > fax: 614 485-5534 > > Home: [EMAIL PROTECTED] > 614 449-1681 > > > icq:47658358 > > > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 12:26 PM > To: CF-Talk > Subject: RE: DHTML Menu :: Spanning frameset? > > > CSS elements cant overlap frame borders. > > -Original Message- > From: Paul Ihrig [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:08 PM > To: CF-Talk > Subject: OT: DHTML Menu :: Spanning frameset? > > > ok. > i have a dhtml menu in my left frame set. > is there a way that i can have the sub menus overlap the main frame or > right > frame? > > right now in the left frame nav, if i open a few sub menus they are > partially hidden due to the next frameset. > i would like the sub menu on top of all the frames? > > any ideas? > please advise.. > > thank you > > -paul > > Web Developer, NBBJ > Work: [EMAIL PROTECTED] > 614 241-3534 > fax: 614 485-5534 > > Home: [EMAIL PROTECTED] > 614 449-1681 > > > icq:47658358 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
We just found a ready-made solution to the same problem. Check out Russ Michaels custom tag in the DevEx- cf_zerokiller found at the URL: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34775F-2830-11D4-AA 9700508B94F380&method=Full Does the trick. Too bad NumberFormat() isn't a little smarter. ;) Truman -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:15 PM To: CF-Talk Subject: RE: Numberformat question. Hatton; The code below will do exactly as you ask. Only on the first if statement where I have the mask as .9 change it to .99 and it works fine. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:44 PM To: CF-Talk Subject: RE: Numberformat question. This isn't pretty, however it does work. #NumberFormat(Item, "$999,999.9")# #NumberFormat(Item, "$999,999.99")# #NumberFormat(Item, "$999,999.999")# #NumberFormat(Item, "$999,999.")# Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:36 AM To: CF-Talk Subject: Numberformat question. I have a situation where I need to display a price with either 2, 3 or 4 digits after the decimal place. The database is storing the information properly, but I need to format the display to "trim" the output. For example, I have three prices for four items: Item 1 has a price of 45.9 Item 2 has a price of 9.99 Item 3 has a price of 2.985 Item 4 has a price of 0.4585 I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since it trims at two decimal places. The question is, how do I set up the NumberFormat to show the pricing properly when possible top-ends are up to $999,999,999.? TIA Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AbleCommerce
If you need one I think forsite-designs built one. Check the forums on ABLE's site I have seen numerous messages about it. At 04:34 PM 4/5/2001 -0400, you wrote: >Hi All, > >Has anyone here built an add on to ACB for customer handling returns? > >TIA, >Duane > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: chat room application
Isn't there a meta-tag that forces a refresh? How about using the setInterval javascript method? You're right though, an Applet is the best way to write this... -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:25 PM To: CF-Talk Subject: Re: chat room application you have to refresh the page to get new messages. browsers don't work any other way. to do this you need an applet to do what you want. I built a simple chat application for this reason. -- Original Message -- From: "Jason Green" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 05 Apr 2001 18:38:07 - does anyone know of a place where i can find information about writing a chat room in coldfusion? or has anyone done this? i'm looking for something that would be like MSN Messenger, but not having to refresh the page all the time to view the new chats. if it can't be done in coldfusion, then i'll have to look elsewhere. thanks. jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting the value of a variable, once removed
CF has a problem with CFLOOP QUERY= inside CFLOOP QUERY= Refer to the entries via a FOR loop with GetFromUAT.ColumnList[i] Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 05 April 2001 20:04 > To: CF-Talk > Subject: Getting the value of a variable, once removed > > > > I have this: > > > > NEQ 0 OR OPTIONAL IS 0) > > > #COLLIST# > > > > > > The #COLLIST# variable contains the name of another variable (a > table column name) which is the value I *really* need. I know > this sounds confusing. > Say the current #COLLIST# value is ACCT. What I really need is > the value of #ACCT#, not ACCT (the value of #COLLIST#). Basically > what I want to do is > find out what > columns were selected, and then display the value of the fields, > not the name of the column (which is what I get now). > The value of #GetFromUAT.Columnlist# would be something like this: > ACCT,BMPRICE,BMREV,BMVOL,NETPRICE,NETREV,NETVOL > The value of #ACCT#, for example, would be something like this: > 493892847855103 ; > the value of #BMPRICE# would be 34.48, etc. > So, for each of the values in the #GetFromUAT.Columnlist#, I need > the underlying value - > (in the ACCT example, I actually need to return > 493892847855103 (the value of #ACCT#), not ACCT (the value of > #COLLIST#). > I hope someone can understand this and help me out. I need a > function like #TheValueOfThisValue(Var)#. > > Gina Shillitani > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: adding records
hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Scheduled tasks using CF
Question? What are some of the problems you or a client has had with scheduled tasks using CF? Specifics of the incident and the resolution would be very helpful. Also if you know, the web server used and version of CF server would be helpful. I am building a application for a client and reliablity is very important. If scheduled tasks are going to fail often, then the reliable answer will be to have this done manually. Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting the value of a variable, once removed
#evaluate(collist)# will give you what you're looking for. D -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:04 PM To: CF-Talk Subject: Getting the value of a variable, once removed I have this: #COLLIST# The #COLLIST# variable contains the name of another variable (a table column name) which is the value I *really* need. I know this sounds confusing. Say the current #COLLIST# value is ACCT. What I really need is the value of #ACCT#, not ACCT (the value of #COLLIST#). Basically what I want to do is find out what columns were selected, and then display the value of the fields, not the name of the column (which is what I get now). The value of #GetFromUAT.Columnlist# would be something like this: ACCT,BMPRICE,BMREV,BMVOL,NETPRICE,NETREV,NETVOL The value of #ACCT#, for example, would be something like this: 493892847855103 ; the value of #BMPRICE# would be 34.48, etc. So, for each of the values in the #GetFromUAT.Columnlist#, I need the underlying value - (in the ACCT example, I actually need to return 493892847855103 (the value of #ACCT#), not ACCT (the value of #COLLIST#). I hope someone can understand this and help me out. I need a function like #TheValueOfThisValue(Var)#. Gina Shillitani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form Submital
I have a rollover that needs to be a form submital. I need to make this rollover pass some paramaters for me. How can I best do this? TIA Alan Koenig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting the value of a variable, once removed
look at Evaluate. #evaluate("#collist#")# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 3:04 PM To: CF-Talk Subject: Getting the value of a variable, once removed I have this: #COLLIST# The #COLLIST# variable contains the name of another variable (a table column name) which is the value I *really* need. I know this sounds confusing. Say the current #COLLIST# value is ACCT. What I really need is the value of #ACCT#, not ACCT (the value of #COLLIST#). Basically what I want to do is find out what columns were selected, and then display the value of the fields, not the name of the column (which is what I get now). The value of #GetFromUAT.Columnlist# would be something like this: ACCT,BMPRICE,BMREV,BMVOL,NETPRICE,NETREV,NETVOL The value of #ACCT#, for example, would be something like this: 493892847855103 ; the value of #BMPRICE# would be 34.48, etc. So, for each of the values in the #GetFromUAT.Columnlist#, I need the underlying value - (in the ACCT example, I actually need to return 493892847855103 (the value of #ACCT#), not ACCT (the value of #COLLIST#). I hope someone can understand this and help me out. I need a function like #TheValueOfThisValue(Var)#. Gina Shillitani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting the value of a variable, once removed
Hiya Gina! What you want to do is use the Evaluate() function. So to normally just output the value of ACCT, you would just do: #ACCT# However, in your case you only get the actual name that holds the value returned from your code, which is ACCT. So to evaluate it, you would do: #Evaluate(GetFromUAT.Columnlist)# But, I assume (sorry if I am wrong) that the GetFromUAT.ColumnList will hold more than 1 value, all delimited by commas. So you must Evaluate(yourindex), where yourindex is whatever name you give to the index attribute in your cfloop tag. good luck! - Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:04 PM > To: CF-Talk > Subject: Getting the value of a variable, once removed > > > > I have this: > > > > NEQ 0 OR OPTIONAL IS 0) > > > #COLLIST# > > > > > > The #COLLIST# variable contains the name of another variable (a > table column name) which is the value I *really* need. I know > this sounds confusing. > Say the current #COLLIST# value is ACCT. What I really need is > the value of #ACCT#, not ACCT (the value of #COLLIST#). Basically > what I want to do is > find out what > columns were selected, and then display the value of the fields, > not the name of the column (which is what I get now). > The value of #GetFromUAT.Columnlist# would be something like this: > ACCT,BMPRICE,BMREV,BMVOL,NETPRICE,NETREV,NETVOL > The value of #ACCT#, for example, would be something like this: > 493892847855103 ; > the value of #BMPRICE# would be 34.48, etc. > So, for each of the values in the #GetFromUAT.Columnlist#, I need > the underlying value - > (in the ACCT example, I actually need to return > 493892847855103 (the value of #ACCT#), not ACCT (the value of > #COLLIST#). > I hope someone can understand this and help me out. I need a > function like #TheValueOfThisValue(Var)#. > > Gina Shillitani > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHEADER questions
That's what I'm looking for. Excellent! tom "Zachary S. Bedell" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > At the top of your file, put: > > > Then for the rest of the page request (or until you do enablecfoutputonly="No">), ONLY stuff that's between and > will get sent out. So this: > > > > > This is your page > > This isn't! > > > > Would result in only 17 bytes of output ("This is your page"), plus > headers. The "This isn't!" part would never get sent out. > > Hope that helps! > > Best regards, > Zac Bedell ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHEADER questions
Thanks. In ASP I can do it with a Response.Flush and Response.End, but I didn't think there was a CF equivalent (although I think CF 5 has something like this. . .haven't played with the new features yet). tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > That is a pain. As I said, I generally put everything into a variable and > then send that, but you still have to be careful about whitespace. There's > no magic way to say "CFCONTENT only up to this point" that I know of. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHEADER questions
Could you do a CFEXIT or CFABORT? At 03:46 PM 4/5/01 -0400, you wrote: >That is a pain. As I said, I generally put everything into a variable and >then send that, but you still have to be careful about whitespace. There's >no magic way to say "CFCONTENT only up to this point" that I know of. > >-Original Message- >From: tom muck [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 05, 2001 1:30 PM >To: CF-Talk >Subject: Re: CFHEADER questions > > >Thanks for that link. Very informative. > >As to the other question: I was mainly interested in it from a practical >point of view. When I insert the code on the page from a snippet, I always >have to make sure that there isn't any whitespace, closing or > tags, or any other tags after it, or they end up in the file. I >just want to make sure the output gets cut off immediately. > >tom > ><[EMAIL PROTECTED]> wrote in message >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I'm not sure what you mean by stopping the output. Do you mean that you > > might start working through a query (or something) and then find that you > > don't want to send the data to the user after all? If so, you could first > > put all the data to download into a variable, then only do the CFCONTENT >if > > you've decided the data are ok. > > > > I've used this sort of approach to create RTF files to download to the > > browser before; I wouldn't call it easy but it's certainly possible. More > > info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 > > > > -Original Message- > > From: tom muck [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 05, 2001 10:21 AM > > To: CF-Talk > > Subject: CFHEADER questions > > > > > > I have some code on my page using and that allows >the > > download of a to a text file. Is there anything I can use on > > that page, aside from a or to stop the output of >the > > server to the text file? > > > > Also, is there an easy way to create an RTF or Word doc on the fly using > > this method? > > > > tom > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: insert to two tables
i have had this issue before and the only way i could come up with it is insert into the peopletable and then query it with the same info you just inserted, thus giving you the id of that personthen insert into the appointment table it's a pain, but i haven't found an easier solution jason >From: Aimee Abbott <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: insert to two tables >Date: Thu, 05 Apr 2001 14:08:41 -0600 > >Hello everyone. > >I have mostly worked on very simple, single table, cold fusion projects but >now I need to do something where I need to add information into two >tables. I have something like this: > >PeopleTable >personID Autonumber >name Text >addressText > >AppointmentTable >aptID Autonumber >PersonID Number >AptNameText >AptDateDate/Time > >The information for both tables come from one entry form on a web page. I >have a second page to do the insert. When I insert the person into the >person table, how do I find out what the personID was so I can enter it >into the AppointmentTable/PersonID? Or can I do some sort of more complex >insert statement that inserts into both tables at once? What if I add a >third table? Does it get more complex? Should I setup the join as a >relationship in microsoft access? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DHTML Menu :: Spanning frameset?
an example of the popup object in IE 5.5 http://msdn.microsoft.com/workshop/author/dhtml/reference/objects/popup.asp - Original Message - From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 05, 2001 1:48 PM Subject: RE: DHTML Menu :: Spanning frameset? > here is the example i speak of. > http://www.columbus.nbbj.com/Dhtml/Default.htm > > how would i put the sub menu in the frame set for the main page with the > corporate Babel? > also if i did that would the linked pages to that main frame set keep the > sub menu intact? > > any advice would be Superb! > thank you! > > -paul > > Web Developer, NBBJ > Work: [EMAIL PROTECTED] > 614 241-3534 > fax: 614 485-5534 > > Home: [EMAIL PROTECTED] > 614 449-1681 > > > icq: 47658358 > > > -Original Message- > From: Costas Piliotis [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 12:58 PM > To: CF-Talk > Subject: RE: DHTML Menu :: Spanning frameset? > > > Hey Paul. I had some other problems as well with DHTML menus, and > unfortunately, there are no workarounds. > > DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading > two different pages, there is no workaround other than creating a layer in > the other fram that you want the layer to appear in... Becauase in a normal > framset, your framesets occur in the head of the page, not the body, I don't > think you can put layers inside of the head tags successfully... > > Good luck... Hope you find a better answer =) > > -Original Message- > From: Paul Ihrig [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 8:08 AM > To: CF-Talk > Subject: OT: DHTML Menu :: Spanning frameset? > > > ok. > i have a dhtml menu in my left frame set. > is there a way that i can have the sub menus overlap the main frame or right > frame? > > right now in the left frame nav, if i open a few sub menus they are > partially hidden due to the next frameset. i would like the sub menu on top > of all the frames? > > any ideas? > please advise.. > > thank you > > -paul > > Web Developer, NBBJ > Work: [EMAIL PROTECTED] > 614 241-3534 > fax: 614 485-5534 > > Home: [EMAIL PROTECTED] > 614 449-1681 > > > icq: 47658358 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert to two tables
Hi there. I'll point you to a page on the Allaire site. It was posted in another cf-talk message today, I think: http://www.allaire.com/Handlers/index.cfm?ID=1463&Method=Full This will also show you how to make sure concurrency issues don't affect the value that is returned. - Andy > -Original Message- > From: Aimee Abbott [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:09 PM > To: CF-Talk > Subject: insert to two tables > > > Hello everyone. > > I have mostly worked on very simple, single table, cold fusion > projects but > now I need to do something where I need to add information into two > tables. I have something like this: > > PeopleTable > personID Autonumber > name Text > address Text > > AppointmentTable > aptID Autonumber > PersonID Number > AptName Text > AptDate Date/Time > > The information for both tables come from one entry form on a web > page. I > have a second page to do the insert. When I insert the person into the > person table, how do I find out what the personID was so I can enter it > into the AppointmentTable/PersonID? Or can I do some sort of > more complex > insert statement that inserts into both tables at once? What if I add a > third table? Does it get more complex? Should I setup the join as a > relationship in microsoft access? > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Stored Procedure
Is it possible for a stored procedure to run a dts package. Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can cfhttp access to https?
https://www.blah.com" method="GET" port="443" username="DOMAIN\USERNAME" password="**" resolveurl="TRUE" throwonerror="YES"> #errormsg# #errordetail# #cfhttp.filecontent# Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 11:50 AM To: CF-Talk Subject: can cfhttp access to https? Hi, Can cfhttp access to https site and get the files with username and pasword provided? if so, can anyone provide a code example!! Thank you very much yc If you change the query in any way, it will rerun, so you can do a couple things... One of the most interesting would be to make the CACHEDWITHIN value a variable, set in the Application.cfm, but updatable through the url. So, when you wanted to "flush" the cache, you could call the page with a url ?cache=flush, and your code would set the value of the CACHEDWITHIN to 0. Next run without the url variable would recache it back up. .. Application.cfm: or whatever your normal cache value is ---> Think this might work? "Al Musella, DPM" wrote: > >I make extensive use of cached queries on 1 of my websites, that uses > read-only data that gets updated once a week.. > > the problem is that when I update that database, I want to clear the cache > so the new data is used.. sometimes the cached querry presents a record > that is no longer available, and when you click to get the details - the > record is no longer there, so it generates an error. > > So - how do you clear the cache? Hopefully with cfcode without having to > restart the CF server? > > Al Musella, DPM > A1webs.com > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: e fax
Try Protus: http://www.protus.com/index.cfm A company I used to work for uses them with great success, apparently. (Andy they use ColdFusion...) - Andy > -Original Message- > From: Chang Liu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:08 PM > To: CF-Talk > Subject: e fax > > > hi all, > > my project needs to send out fax after web users input > information to a form. > does somebody know any custom tags and software for cold fusion server? > > PS. I know cf_fax and http://www.protonet.com/ , but seems their > download server has something wrong. > > hope somebody can help this. > thank you very much in advance! > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Could Not Delete From Specified Tables
> -Original Message- > From: P@tty Ayers [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 3:26 PM > To: CF-Talk > Subject: Could Not Delete From Specified Tables > > > Ok, you all helped me tremendously this morning, so I'm hoping someone can > point me in the right direction on this new problem. > > I've created a Delete Record page, but when I test it, I get an error > message simply saying "Could not delete from specified tables." > Any ideas at > all why? > > A little information on the database: > > It's in Access2000 and has three tables, 'cabins', 'photos' and > 'otherphotos'. > > cabins has cabinID as its primary key, each rental cabin is a record. > > photos also has cabinID as a primary key, and I created a relationship > between the two tables using the two cabinID fields. Do you mean you have a primary key called photoID in this table as a primary key? cabinID in this table should be a foreign key, related to the cabins table. > > otherphotos has otherphotoID as its primary key, and each record > is a photo, > each associated with, again, cabinID. cabins is related to otherphotos by > the cabinID column. > > Both of the relationships are one-to-many, and I have checked "Enforce > Referential Integrity" and "Cascade Update Related Fields." Are you trying to delete a cabin record? It should work then, and also cascade delete all records that contain a foreign key in the other photo tables, based on how you say you have it set up. If you DO have the cabinID set as a primary key in the photos table, this could be your problem. > > Your help and suggestions are GREATLY appreciated! > > P@tty Ayers > Macromedia Evangelist - Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT But Urgent - Knock CF if you dare
Hi all, We use a little bit of ASP with CF from time to time. We are pitching for a contract whereby the opposition are slating CF big time. In actual fact they are saying all sorts of bad things about CF to the client in an effort to get the client to move to ASP. Any Amunition out there i can fire back with. I dont normally slate ASP but they have started this. Articles would be good... Appreciate the help Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Changing CF Studio Shortcuts - Thanks
Thanks to everyone who told me what to do. Guess my eyes just glazed over after a while. *sheepish grin* thanks again, everyone. Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL: Help!
Thanks for the quick answer - sorry for the slow reply. Works like a charm. Duane -Original Message- From: Edward Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 12:07 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: SQL: Help! Database? If it is Oracle, I might use the "MINUS" Operator: SELECT C.CompanyID, P.Product ID FROM Company C, Product P MINUS SELECT C.CompanyID, S.Product ID FROM Company C, StoreProducts S To get Company->Product Uniques And swap the two queries to get StoreProducts uniques. Not sure if an analogous operater exists in TransactSQL.. Yep, its NOT EXISTS SELECT C.CompanyID, P.Product ID FROM Company C, Product P WHERE NOT EXISTS (SELECT C.CompanyID, S.Product ID FROM Company C, StoreProducts S) Access? Not sure... Duane Boudreau wrote: > > I've got one heckuva mess on my hands. I am trying to straighten out a huge > mess of an ecommerce application I have inherited. It went into production > w/h zero testing a couple of months ago and now I am in firefighting mode). > > This app relies heavily on three tables company, products, storeproducts. > Company contains store retailers and product distributors, products contain > all products entered by distributors and storeproducts is a derived table > that contains the combinations of products to retailers. (confused yet???). > My problem is that I need to write a routine that lists all the combinations > that exist in the company -> products that do not exist in storeproducts and > all the combinations in storeproducts that do not exist in company -> > products. A simplified version of the db schema looks like?: > > Company > Company_ID (retailer or distributor) > > Products > Company_ID (distributor) > Product_ID > > StoreProducts > Company_ID (retailer) > Product_ID > > The answer probably uses outer joins but I haven't yet mastered the art of > writting outer joins. > > Duane > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
Paul, It's impossible to overlay a layer over a multiple frames. In order to have something appear over multiple frames, you'd need to use an ActiveX control or some other external control that's not bound to the browser window. The one thing you can do-but it's a big pain, is to have you're main topics in frame 1 then have the actual layers pop-up in frame 2. It'll appear to expand frames, but really the pieces are in two completely different frames. There's a library here that will work with frames, but the library is really slow loading for a lot of options (at least it was last time I looked at it.) http://www.webreference.com/dhtml/column51/ -Dan -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:48 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? here is the example i speak of. http://www.columbus.nbbj.com/Dhtml/Default.htm how would i put the sub menu in the frame set for the main page with the corporate Babel? also if i did that would the linked pages to that main frame set keep the sub menu intact? any advice would be Superb! thank you! -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:58 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? Hey Paul. I had some other problems as well with DHTML menus, and unfortunately, there are no workarounds. DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading two different pages, there is no workaround other than creating a layer in the other fram that you want the layer to appear in... Becauase in a normal framset, your framesets occur in the head of the page, not the body, I don't think you can put layers inside of the head tags successfully... Good luck... Hope you find a better answer =) -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:08 AM To: CF-Talk Subject: OT: DHTML Menu :: Spanning frameset? ok. i have a dhtml menu in my left frame set. is there a way that i can have the sub menus overlap the main frame or right frame? right now in the left frame nav, if i open a few sub menus they are partially hidden due to the next frameset. i would like the sub menu on top of all the frames? any ideas? please advise.. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
Here's the problem: Your framset page looks like this: CF Enterprise Manager Notice the body tag is only envoked when the browser doesn't support frames. Unfortunately, layers need to be inside the body tag... Too bad iframe is only supported by newer browsers... One technique I have seen is to hide and show the objects depending on the layer showing. Still a pain though. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 11:48 AM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? here is the example i speak of. http://www.columbus.nbbj.com/Dhtml/Default.htm how would i put the sub menu in the frame set for the main page with the corporate Babel? also if i did that would the linked pages to that main frame set keep the sub menu intact? any advice would be Superb! thank you! -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:58 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? Hey Paul. I had some other problems as well with DHTML menus, and unfortunately, there are no workarounds. DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading two different pages, there is no workaround other than creating a layer in the other fram that you want the layer to appear in... Becauase in a normal framset, your framesets occur in the head of the page, not the body, I don't think you can put layers inside of the head tags successfully... Good luck... Hope you find a better answer =) -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:08 AM To: CF-Talk Subject: OT: DHTML Menu :: Spanning frameset? ok. i have a dhtml menu in my left frame set. is there a way that i can have the sub menus overlap the main frame or right frame? right now in the left frame nav, if i open a few sub menus they are partially hidden due to the next frameset. i would like the sub menu on top of all the frames? any ideas? please advise.. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
adding records
hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: chat room application
you can do it by auto refreshing a message pane with the META tag. if you want persistence, you should use something like Java or Flash. -Original Message- From: Jason Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 11:38 AM To: CF-Talk Subject: chat room application does anyone know of a place where i can find information about writing a chat room in coldfusion? or has anyone done this? i'm looking for something that would be like MSN Messenger, but not having to refresh the page all the time to view the new chats. if it can't be done in coldfusion, then i'll have to look elsewhere. thanks. jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
AbleCommerce
Hi All, Has anyone here built an add on to ACB for customer handling returns? TIA, Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: chat room application
Fusetalk does this but it's commercial. www.e-zonemedia.com HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "Jason Green" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 05, 2001 2:38 PM Subject: chat room application > does anyone know of a place where i can find information about writing a > chat room in coldfusion? or has anyone done this? i'm looking for > something that would be like MSN Messenger, but not having to refresh the > page all the time to view the new chats. if it can't be done in coldfusion, > then i'll have to look elsewhere. thanks. > > jason > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: chat room application
you have to refresh the page to get new messages. browsers don't work any other way. to do this you need an applet to do what you want. I built a simple chat application for this reason. -- Original Message -- From: "Jason Green" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 05 Apr 2001 18:38:07 - does anyone know of a place where i can find information about writing a chat room in coldfusion? or has anyone done this? i'm looking for something that would be like MSN Messenger, but not having to refresh the page all the time to view the new chats. if it can't be done in coldfusion, then i'll have to look elsewhere. thanks. jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSETTING "HTML Strings" *URGENT*
This one is not W3C-compliant HTML, because of the single quotes: The others are all good. If you take the above and switch the single and double quotes, you'll be okay: tom "bfalloon" <[EMAIL PROTECTED]> wrote in message 3acbdad5$[EMAIL PROTECTED]">news:3acbdad5$[EMAIL PROTECTED]... > WOW! > > Thanks everyone! > > So many solutions! Which should I use?? > Are there any drawbacks with any of the solutions below? > > > > > > Category'))> > > > > Thanks for the prompt responces! > > Benjamin > > > > > "David Baskin" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Benjamin, just escape the quotes with an extra quote. > > > > > > > > HTH, > > > > david > > > > -Original Message- > > From: bfalloon [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 05, 2001 7:05 AM > > To: CF-Talk > > Subject: CFSETTING "HTML Strings" *URGENT* > > > > > > Hello, > > > > Can someone help me with this problem? > > > > I want to create a string that contains HTML. Specifically a 'path' string > > to be > > outputted at the top of a page with variable content. The problem that I > > have > > is that I need to do something like this... > > > > Category > href="subcategory.cfm">Sub"> > > > > The problem is that because of the quotation marks within the string > itself, > > it is terminating > > the CFSET command before it gets to the end of the string. > > > > I'm not sure if I should use the converted HTML ie. < becomes < and so > on > > because I need to output 'functional' HTML on the page below this CFSET, > not > > 'display' HTML. > > > > Can someone explain how this should be phrased. > > I may also need to append more string information onto the end of this > > string > > depending of other query results. > > > > Thanks in advance! > > > > Benjamin Falloon > > Objektmedia > > www.objekt.com.au > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHEADER questions
"Costas Piliotis" <[EMAIL PROTECTED]> wrote in message 22A8D10172BFD41195B700D0B765C3F05330@vcsvanntex0">news:22A8D10172BFD41195B700D0B765C3F05330@vcsvanntex0... > Another good way, if you want to output to word is to use the MS Word COM > library. > > Some good samples are at www.cfcomet.com > > It's a pain, but end user's will love it :) Thanks -- that's a great resource. I was able to make use of the HTMLtoWord code. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
I'm not sure what you might be looking for as a replacement, currently I'm using the Joust DHTML menu (http://www.ivanpeters.com/) which is freeware. Although it doesn't accomplish what you are looking for as far as the 'overlapping' it does allow you to specify that a menu item's description be 'wrapped' to accommodate text that extends beyond the width of your frame. It's quite flexible and I'm currently using it to create several dynamic menu systems based upon multiple queries. Hope this helps. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:30 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? do you have any suggestions? i would hate to include this chunk of code on every page... that is very tiresome. some one must have an idea? -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:26 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? CSS elements cant overlap frame borders. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:08 PM To: CF-Talk Subject: OT: DHTML Menu :: Spanning frameset? ok. i have a dhtml menu in my left frame set. is there a way that i can have the sub menus overlap the main frame or right frame? right now in the left frame nav, if i open a few sub menus they are partially hidden due to the next frameset. i would like the sub menu on top of all the frames? any ideas? please advise.. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
Hatton; The code below will do exactly as you ask. Only on the first if statement where I have the mask as .9 change it to .99 and it works fine. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:44 PM To: CF-Talk Subject: RE: Numberformat question. This isn't pretty, however it does work. #NumberFormat(Item, "$999,999.9")# #NumberFormat(Item, "$999,999.99")# #NumberFormat(Item, "$999,999.999")# #NumberFormat(Item, "$999,999.")# Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:36 AM To: CF-Talk Subject: Numberformat question. I have a situation where I need to display a price with either 2, 3 or 4 digits after the decimal place. The database is storing the information properly, but I need to format the display to "trim" the output. For example, I have three prices for four items: Item 1 has a price of 45.9 Item 2 has a price of 9.99 Item 3 has a price of 2.985 Item 4 has a price of 0.4585 I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since it trims at two decimal places. The question is, how do I set up the NumberFormat to show the pricing properly when possible top-ends are up to $999,999,999.? TIA Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Getting the value of a variable, once removed
I have this: #COLLIST# The #COLLIST# variable contains the name of another variable (a table column name) which is the value I *really* need. I know this sounds confusing. Say the current #COLLIST# value is ACCT. What I really need is the value of #ACCT#, not ACCT (the value of #COLLIST#). Basically what I want to do is find out what columns were selected, and then display the value of the fields, not the name of the column (which is what I get now). The value of #GetFromUAT.Columnlist# would be something like this: ACCT,BMPRICE,BMREV,BMVOL,NETPRICE,NETREV,NETVOL The value of #ACCT#, for example, would be something like this: 493892847855103 ; the value of #BMPRICE# would be 34.48, etc. So, for each of the values in the #GetFromUAT.Columnlist#, I need the underlying value - (in the ACCT example, I actually need to return 493892847855103 (the value of #ACCT#), not ACCT (the value of #COLLIST#). I hope someone can understand this and help me out. I need a function like #TheValueOfThisValue(Var)#. Gina Shillitani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHEADER questions
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At the top of your file, put: Then for the rest of the page request (or until you do ), ONLY stuff that's between and will get sent out. So this: This is your page This isn't! Would result in only 17 bytes of output ("This is your page"), plus headers. The "This isn't!" part would never get sent out. Hope that helps! Best regards, Zac Bedell > -Original Message- > From: tom muck [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 1:30 PM > To: CF-Talk > Subject: Re: CFHEADER questions > > > Thanks for that link. Very informative. > > As to the other question: I was mainly interested in it from > a practical > point of view. When I insert the code on the page from a > snippet, I always > have to make sure that there isn't any whitespace, closing or > tags, or any other tags after it, or they end up in > the file. I > just want to make sure the output gets cut off immediately. > > tom > > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > ate.ky.us... > > I'm not sure what you mean by stopping the output. Do you > mean that you > > might start working through a query (or something) and then > find that you > > don't want to send the data to the user after all? If so, > you could first > > put all the data to download into a variable, then only do > the CFCONTENT > if > > you've decided the data are ok. > > > > I've used this sort of approach to create RTF files to > download to the > > browser before; I wouldn't call it easy but it's certainly > possible. More > > info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 > > -Original Message- > From: tom muck [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 10:21 AM > To: CF-Talk > Subject: CFHEADER questions > > > I have some code on my page using and that allows the > download of a to a text file. Is there anything I can use on > that page, aside from a or to stop the output of the > server to the text file? > > Also, is there an easy way to create an RTF or Word doc on the fly using > this method? > > tom > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
e fax
hi all, my project needs to send out fax after web users input information to a form. does somebody know any custom tags and software for cold fusion server? PS. I know cf_fax and http://www.protonet.com/ , but seems their download server has something wrong. hope somebody can help this. thank you very much in advance! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
How do you know which number gets which format? Is there some clue in another db field, or is it based on how many digits after the decimal point, or what? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:55 PM To: CF-Talk Subject: RE: Numberformat question. I've been playing with a few different masks, but anytime I set up a decimal mask it's forcing all the places, so for example, if I have the mask set at ",9$99.", the numbers get formatted (using the examples I cited originally) $45.9000, $9.9900, $2.8950 and $0.4585. What I need is $45.90, $9.99, $2.985 and $0.4585. Hatton > -Original Message- > From: Tumy, Brad [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 12:27 PM > To: CF-Talk > Subject: RE: Numberformat question. > > > can't you output like this: > > $#numberformat(number,mask)# > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 11:36 AM > To: CF-Talk > Subject: Numberformat question. > > > I have a situation where I need to display a price with either 2, 3 or 4 > digits after the decimal place. The database is storing the information > properly, but I need to format the display to "trim" the output. > > For example, I have three prices for four items: > > Item 1 has a price of 45.9 > Item 2 has a price of 9.99 > Item 3 has a price of 2.985 > Item 4 has a price of 0.4585 > > I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 > for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since > it trims at two decimal places. The question is, how do I set up the > NumberFormat to show the pricing properly when possible top-ends are up to > $999,999,999.? > > TIA > Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE and testing a list for items other than...
Hello all, I need the RE for seeing if a list ONLY contains 1/multiples of four allowable options. For instance, the allowable options are "jane,tom,sally,mark" you pass me a list. "Jane,tom,mark" or "Tom,Sally" or "Jane" all of these are OK you pass me a list. "jane,allisa,tom" this is NOT Ok and I will throw an error... How do I check this??? Preferably with RE - I suppose I could loop through every item in your list and checke it against my list - but this seems kludgie TIA JP ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
"The application, iexplore.exe, generated an application error "
Anyone seen this before?? I have a small registration application comprised of three pages of forms that collect user info, travel info and activity info). The form values are pushed into session variables between forms and stay there until the very end when I commit them to a database. I also have some hand coded JavaScript for form validation that Cold Fusion doesn't provide (select lists and check box stuff) but the JavaScript is all working properly. Internet Exploder is having some trouble when I hit the 'Back' button of the browser between the three forms and it proceeds to crash. I get an error message written to the log which states the following: The application, iexplore.exe, generated an application error The error occurred on 04/05/2001 @ 13:05:18.328 The exception generated was c005 at address 77E8557F (SetFilePointer) Netscape is not having these problem when the 'Back' button of the browser is used anywhere is the application. This app is still on my machine behind a firewall so I can't send you a URL. Sorry. Joyce E. Evans Web Systems Developer Spectra Logic Corporation 1700 North 55th Ave Boulder, CO 80301 303-449-6444 x1319 http://www.spectralogic.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
> This isn't pretty, however it does work. > > > #NumberFormat(Item, "$999,999.9")# > > #NumberFormat(Item, "$999,999.99")# > > #NumberFormat(Item, "$999,999.999")# > > #NumberFormat(Item, "$999,999.")# > A shorter version; #NumberFormat(Item,"$999,999.#RepeatString("9",Len(ListLast(Item,".")))#")# Or, if you always want the 2 digits on the end; #NumberFormat(Item,"$999,999.#RepeatString("9",Max(2,Len(ListLast(Item,".")) ))#")# I haven't tested this, it's just typed... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHEADER questions
That is a pain. As I said, I generally put everything into a variable and then send that, but you still have to be careful about whitespace. There's no magic way to say "CFCONTENT only up to this point" that I know of. -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:30 PM To: CF-Talk Subject: Re: CFHEADER questions Thanks for that link. Very informative. As to the other question: I was mainly interested in it from a practical point of view. When I insert the code on the page from a snippet, I always have to make sure that there isn't any whitespace, closing or tags, or any other tags after it, or they end up in the file. I just want to make sure the output gets cut off immediately. tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I'm not sure what you mean by stopping the output. Do you mean that you > might start working through a query (or something) and then find that you > don't want to send the data to the user after all? If so, you could first > put all the data to download into a variable, then only do the CFCONTENT if > you've decided the data are ok. > > I've used this sort of approach to create RTF files to download to the > browser before; I wouldn't call it easy but it's certainly possible. More > info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 > > -Original Message- > From: tom muck [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 10:21 AM > To: CF-Talk > Subject: CFHEADER questions > > > I have some code on my page using and that allows the > download of a to a text file. Is there anything I can use on > that page, aside from a or to stop the output of the > server to the text file? > > Also, is there an easy way to create an RTF or Word doc on the fly using > this method? > > tom > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
Oy, that almost merits being put into a custom tag with as many times as I'm going to have to call it! I had come to the conclusion that I could do something similar to this, but was hoping that there was a way to do it dynamically within the numberformat function. I guess there isn't. Thanks! Hatton > -Original Message- > From: Larry Juncker [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 1:44 PM > To: CF-Talk > Subject: RE: Numberformat question. > > > This isn't pretty, however it does work. > > > #NumberFormat(Item, "$999,999.9")# > > #NumberFormat(Item, "$999,999.99")# > > #NumberFormat(Item, "$999,999.999")# > > #NumberFormat(Item, "$999,999.")# > > > > Larry Juncker > Senior Cold Fusion Developer > Heartland Communications Group, Inc. > > > -Original Message- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 10:36 AM > To: CF-Talk > Subject: Numberformat question. > > > I have a situation where I need to display a price with either 2, 3 or 4 > digits after the decimal place. The database is storing the information > properly, but I need to format the display to "trim" the output. > > For example, I have three prices for four items: > > Item 1 has a price of 45.9 > Item 2 has a price of 9.99 > Item 3 has a price of 2.985 > Item 4 has a price of 0.4585 > > I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 > for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since > it trims at two decimal places. The question is, how do I set up the > NumberFormat to show the pricing properly when possible top-ends are up to > $999,999,999.? > > TIA > Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Could Not Delete From Specified Tables
Ok, you all helped me tremendously this morning, so I'm hoping someone can point me in the right direction on this new problem. I've created a Delete Record page, but when I test it, I get an error message simply saying "Could not delete from specified tables." Any ideas at all why? A little information on the database: It's in Access2000 and has three tables, 'cabins', 'photos' and 'otherphotos'. cabins has cabinID as its primary key, each rental cabin is a record. photos also has cabinID as a primary key, and I created a relationship between the two tables using the two cabinID fields. otherphotos has otherphotoID as its primary key, and each record is a photo, each associated with, again, cabinID. cabins is related to otherphotos by the cabinID column. Both of the relationships are one-to-many, and I have checked "Enforce Referential Integrity" and "Cascade Update Related Fields." Your help and suggestions are GREATLY appreciated! P@tty Ayers Macromedia Evangelist ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
Thanks Richard. the dhtml menu i was tweaking out began in FireWorks. then i tweaked the *.js file then all the code to get it to look right. http://www.columbus.nbbj.com/Dhtml/Default.htm do you have an example of a menu that spans frames? url??? thank you so much. this could be cool if i could get it to work right. -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 -Original Message- From: richard ten barge [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:54 PM To: CF-Talk Subject: Re: OT: DHTML Menu :: Spanning frameset? I don't knnow whbich DHTML menu you are using, but Hiermenus has an option for this, making it possible to show (sub) menu's in another frame... richard ten Barge 1MB At 11:08 5-4-2001 -0400, you wrote: >ok. >i have a dhtml menu in my left frame set. >is there a way that i can have the sub menus overlap the main frame or right >frame? > >right now in the left frame nav, if i open a few sub menus they are >partially hidden due to the next frameset. >i would like the sub menu on top of all the frames? > >any ideas? >please advise.. > >thank you > >-paul > >Web Developer, NBBJ >Work: [EMAIL PROTECTED] > 614 241-3534 >fax: 614 485-5534 > >Home: [EMAIL PROTECTED] > 614 449-1681 > >> icq: 47658358 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
USPS API
Anyone do anything with the USPS api or anything with thier rate tables they have on the site? Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Includes on HtML?
IIS is pretty easy. I'm sure you'll get responses on how do to this before you even get my reply... Barring that, look in IIS to see where .cfm is mapped to cold fusion and copy that... > Are there any websites/books you could recommend I could go to for more > information on accomplishing this via an NT/IIS box? > > Thanks, > > Dayv > > > > -Original Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 4:11 AM > To: CF-Talk > Subject: RE: Includes on HtML? > > > It's not in CF, it's done through your webserver. You add the extensions > you wish to be parsed as cold fusion types. For example, in Apache: > > AddHandler type-coldfusion .mml > DirectoryIndex index.mml > > Adds the extension .mml to be parsed by CF. (.cfm is added as part of the > cf module) > > > I'd rather Cold Fusion parse through the HTM/HTML files. How is this done > > via CF Server? > > > > Dayv > > > > > > > > -Original Message- > > From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, April 04, 2001 2:03 PM > > To: CF-Talk > > Subject: RE: Includes on HtML? > > > > > > In my opinion... > > > > Unless you have a huge amount of html files and are running other web > sites > > on the same server, this won't be a big performance concern. > > > > Also, remember, that if you have more than 1 virtual site on the server, > you > > can configure the applicable site to process htm and html files through > the > > ColdFusion server, so only that site will be processing the files through > > CF. > > > > To use server side includes will not offer that much of a performance gain > > since the ssinc.dll must then process the html files as well (by default > it > > is mapped to .shtm, .shtml and .stm files). So you'd be stuck in having > the > > ssinc.dll process the files vs. having ColdFusion's iscf.dll do the work. > > > > Changing file extensions is not really dangerous. Many sites use their > own > > custom extensions. If portability is not a concern then go ahead and do > it. > > Of course you can always rename the files and change the mappings back to > > the way they were in IIS. > > > > - Andy > > > > > -Original Message- > > > From: Erika L Walker [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, April 04, 2001 3:37 PM > > > To: CF-Talk > > > Subject: RE: Includes on HtML? > > > > > > > > > WellI know it's not recommended changing how the server > > > interprets .htm > > > or .html files,however, if the site doesn't really take a > > > huge amount of > > > hitsand it's hosted on a server by itself.and the company flatly > > > refuses to change the page names for fear of breaking bookmarks or some > > > other silly reasonthen allow CF to parse through html files > > > isn't a huge > > > load.. > > > > > > But, if the hardware can't take the work and/or traffic beefs up, > > > could slow > > > everything down? > > > > > > Erika > > > > > > -Original Message- > > > From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, April 04, 2001 2:28 PM > > > To: CF-Talk > > > Subject: RE: Includes on HtML? > > > > > > > > > > > > > > > But the question was "can I a file from a page with the > > > extension .htm or .html?" The answer is no. There is file inclusion > > > using server side includes, which is actually how it is done in ASP. > > > > > > The thing to keep in mind is that 'includes' are synonymous with > > > 'inline functions' as in C programming. The code just gets pasted to > > > the current 'page'. So, if you could include a .cfm file within a > > > ...html file, the CFML would not get processed unless you told your Web > > > Server to run all .html files through your ColdFusion App Server, > > > something that is usually not recomended. Check out Allaire's site. > > > There are some diagrams there on the interactions betwix web server, > > > cold fusion app server, and browser. Ask yourself 'What actually > > > happens when I enter a URL and hit enter from my favourite browser?'. > > > > > > I think your stuck changing your files to .cfm files. opinions? > > > > > > DK > > > > > > > > > > > > From: [EMAIL PROTECTED] AT INTERNET on 04/04/2001 01:20 PM > > > > > > To: [EMAIL PROTECTED] AT INTERNET@CCMAIL > > > cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) > > > > > > Subject: RE: Includes on HtML? > > > > > > > > > You can CFINCLUDE a file with any extension. > > > > > > -Original Message- > > > From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, April 04, 2001 12:21 PM > > > To: CF-Talk > > > Subject: Includes on HtML? > > > > > > > > > Hi All, > > > > > > Another question. > > > > > > Can you from *.htm *.html based files? I want to be able > > > to > > > include a hit counter on some of our pages but not by not having them > > > changed to .cfm. > > > > > > Thanks, > > > Dayv > > > > > > > > > ~~~
insert to two tables
Hello everyone. I have mostly worked on very simple, single table, cold fusion projects but now I need to do something where I need to add information into two tables. I have something like this: PeopleTable personIDAutonumber nameText address Text AppointmentTable aptID Autonumber PersonIDNumber AptName Text AptDate Date/Time The information for both tables come from one entry form on a web page. I have a second page to do the insert. When I insert the person into the person table, how do I find out what the personID was so I can enter it into the AppointmentTable/PersonID? Or can I do some sort of more complex insert statement that inserts into both tables at once? What if I add a third table? Does it get more complex? Should I setup the join as a relationship in microsoft access? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
can cfhttp access to https?
Hi, Can cfhttp access to https site and get the files with username and pasword provided? if so, can anyone provide a code example!! Thank you very much yc If you change the query in any way, it will rerun, so you can do a couple things... One of the most interesting would be to make the CACHEDWITHIN value a variable, set in the Application.cfm, but updatable through the url. So, when you wanted to "flush" the cache, you could call the page with a url ?cache=flush, and your code would set the value of the CACHEDWITHIN to 0. Next run without the url variable would recache it back up. . Application.cfm: or whatever your normal cache value is ---> Think this might work? "Al Musella, DPM" wrote: > >I make extensive use of cached queries on 1 of my websites, that uses > read-only data that gets updated once a week.. > > the problem is that when I update that database, I want to clear the cache > so the new data is used.. sometimes the cached querry presents a record > that is no longer available, and when you click to get the details - the > record is no longer there, so it generates an error. > > So - how do you clear the cache? Hopefully with cfcode without having to > restart the CF server? > > Al Musella, DPM > A1webs.com > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
here is the example i speak of. http://www.columbus.nbbj.com/Dhtml/Default.htm how would i put the sub menu in the frame set for the main page with the corporate Babel? also if i did that would the linked pages to that main frame set keep the sub menu intact? any advice would be Superb! thank you! -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:58 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? Hey Paul. I had some other problems as well with DHTML menus, and unfortunately, there are no workarounds. DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading two different pages, there is no workaround other than creating a layer in the other fram that you want the layer to appear in... Becauase in a normal framset, your framesets occur in the head of the page, not the body, I don't think you can put layers inside of the head tags successfully... Good luck... Hope you find a better answer =) -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:08 AM To: CF-Talk Subject: OT: DHTML Menu :: Spanning frameset? ok. i have a dhtml menu in my left frame set. is there a way that i can have the sub menus overlap the main frame or right frame? right now in the left frame nav, if i open a few sub menus they are partially hidden due to the next frameset. i would like the sub menu on top of all the frames? any ideas? please advise.. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
chat room application
does anyone know of a place where i can find information about writing a chat room in coldfusion? or has anyone done this? i'm looking for something that would be like MSN Messenger, but not having to refresh the page all the time to view the new chats. if it can't be done in coldfusion, then i'll have to look elsewhere. thanks. jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
do you have any suggestions? i would hate to include this chunk of code on every page... that is very tiresome. some one must have an idea? -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:26 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? CSS elements cant overlap frame borders. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:08 PM To: CF-Talk Subject: OT: DHTML Menu :: Spanning frameset? ok. i have a dhtml menu in my left frame set. is there a way that i can have the sub menus overlap the main frame or right frame? right now in the left frame nav, if i open a few sub menus they are partially hidden due to the next frameset. i would like the sub menu on top of all the frames? any ideas? please advise.. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: encrypt/decrypt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The values that the CF Encrypt function creates usually aren't safe to put into a database -- they're binary values if my memory serves correctly. The error you're getting is because Decrypt throws an error if the value it gets isn't a valid value made by the Encrypt functions. Before you put your values into the DB, you need to convert them to text only values. URLEncodedFormat() would work. ToString() would probably work too. Then when you pull the value back out of the DB, you just URLDecode() it. I'm not sure how you turn ToString() back to it's original form. I thought it was ToBinary() or something, but I don't see that in my quickref book To guard against crashes b/c of modified, corrupted values, just surround your Decrypt() function call in a CF Try block & handle it accordingly. INSERT INTO Table (Secret) VALUES( '#Gibberish#' SELECT Secret FROM Table WHERE ... The secret word is: #Secret# Something broke... Hope that's helpful. Best regards, Zac Bedell > -Original Message- > From: Will Swain [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 7:16 AM > To: CF-Talk > Subject: encrypt/decrypt > > > Hi guys, > > Got an interesting one here. I am encrypting some details > before entering > them in a databse, then decrypting them as the authorised views them. > > > However, I am getting this error on decryption: > > Error Diagnostic Information > > An error occurred while evaluating the expression: > > > decryptednumber = decrypt(encryptednumber, numberkey) > > > > Error near line 25, column 8. > -- > -- > > > The value to be decrypted is not valid > > > This is the code I have in that location. Interestingly, > decrtypting the > name doesn't seem to cuase a problem: > > > > > > > > > > > > > > > This is the code on another page that encrypts the values: > > > > > > > > > > Any ideas on this anyone?? > > TIA > > Will Swain > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Changing CF Studio Shortcuts
How do you create your own shortcut and has anybody ever found a problem with debugger not listening to your changes? At 11:48 AM 4/5/2001 -0500, you wrote: >help --> Using ColdFusion Studio --> Chapter 6 Writing Code and >WebContent --> Using Keyboard Shortcuts > >excerted > > To assign a key > combination: > > > > >1. Open the Keyboard Shortcuts tab and select a command from > the list. >2. Click in the text box beside the Apply button and press the > key combination you want to use. > > > If the key combination is already in use, the current assignment > appears below the text box. >3. Click Apply to save the assignment. > > > This overwrites the existing assignment. > > >The list automatically refreshes when changes are made. > > > >- >Douglas Knudsen >Leveraged Technologies Group >Alltel AIS >678-351-6063 >Got Linux? http://linuxmall.com > > > > >From: [EMAIL PROTECTED] AT INTERNET on 04/05/2001 11:26 AM > >To: [EMAIL PROTECTED] AT INTERNET@CCMAIL >cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) > >Subject: Changing CF Studio Shortcuts > > >Hi. > >I was wondering if it is possible to change the shortcut for >control+shift+m. Currently, it will insert regular html comments, but >I >would like it insert cfml comments. I went into the >Options->Customize >menu, and looked at the keyboard shortcuts, but it doesn't look like >you can >edit what the shortcut does, only assign or re-assign a shortcut. >There >also does not appear to be an entry for CFML comment. IS there a way >I can >do this? > >Thanks, > >Chris Martin > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Changing CF Studio Shortcuts and date
I would like to have CF put today's date in a comment. Example: <--- 04-05-01 - MB comment here ---> Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 11:49 AM To: CF-Talk Subject: RE: Changing CF Studio Shortcuts You could use a snippet shortcut. Create a snippet for the CF comment, and then map that snippet to your key combination. Bob -Original Message- From: Chris Martin [mailto:[EMAIL PROTECTED]] Sent: April 5, 2001 11:27 AM To: CF-Talk Subject: Changing CF Studio Shortcuts Hi. I was wondering if it is possible to change the shortcut for control+shift+m. Currently, it will insert regular html comments, but I would like it insert cfml comments. I went into the Options->Customize menu, and looked at the keyboard shortcuts, but it doesn't look like you can edit what the shortcut does, only assign or re-assign a shortcut. There also does not appear to be an entry for CFML comment. IS there a way I can do this? Thanks, Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFStudio - TopStyle Lite
For some reason, ever since I loaded CFStudio 4.5.2 I cannot use TopStyle within ColdFusion. When I right click between
Masters Leaderboard
I'm looking at the source of The Masters leaderboard. www.masters.org/scores The data looks pretty consistent. Is there a quick and easy way to "harvest" that data so I can dump it into a database? Just checking. I'm guessing it would be a fairly complicated CFHTTP process. -- Lee Surma Public Radio International [EMAIL PROTECTED] 612-330-9223 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
I've been playing with a few different masks, but anytime I set up a decimal mask it's forcing all the places, so for example, if I have the mask set at ",9$99.", the numbers get formatted (using the examples I cited originally) $45.9000, $9.9900, $2.8950 and $0.4585. What I need is $45.90, $9.99, $2.985 and $0.4585. Hatton > -Original Message- > From: Tumy, Brad [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 12:27 PM > To: CF-Talk > Subject: RE: Numberformat question. > > > can't you output like this: > > $#numberformat(number,mask)# > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 11:36 AM > To: CF-Talk > Subject: Numberformat question. > > > I have a situation where I need to display a price with either 2, 3 or 4 > digits after the decimal place. The database is storing the information > properly, but I need to format the display to "trim" the output. > > For example, I have three prices for four items: > > Item 1 has a price of 45.9 > Item 2 has a price of 9.99 > Item 3 has a price of 2.985 > Item 4 has a price of 0.4585 > > I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 > for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since > it trims at two decimal places. The question is, how do I set up the > NumberFormat to show the pricing properly when possible top-ends are up to > $999,999,999.? > > TIA > Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date problems
> Hi guys, hope somebody can help as this is starting to drive us insane. > > We have a query that we need to extract a survey question. The survey is > given a section id, be it news, sport, etc. The survey is given > a start and > finish date, no surveys within the same section can run co-currently just > share a start and end date. > > When the user clicks through I want the running survey to be presented to > them, we have been playing with the date functions for ages and trying > desperately to make it work, no joy. Please any ideas would be very > helpful. > > > SELECT poll.poll_id, poll.poll_name, poll_sections.section_name, > poll_votes.question_id, poll_votes.question, poll_votes.votes, > poll_sections.section_id, poll.date_opened > FROM poll, poll_sections, poll_votes > WHERE poll.section_id = #url.section_id# AND poll.section_id = > poll_sections.section_id AND poll.poll_id = poll_votes.poll_id Why can't you add a bit to the WHERE similar to AND poll.StartDate <= getDate() and poll.EndDate >= getDate() with "getDate()" I'm assuming SQL Server, but you could AND poll.StartDate <= #Now()# and poll.EndDate >= #Now()# This basically means that the start date is before the current date, and the end date is after the current date... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
This isn't pretty, however it does work. #NumberFormat(Item, "$999,999.9")# #NumberFormat(Item, "$999,999.99")# #NumberFormat(Item, "$999,999.999")# #NumberFormat(Item, "$999,999.")# Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:36 AM To: CF-Talk Subject: Numberformat question. I have a situation where I need to display a price with either 2, 3 or 4 digits after the decimal place. The database is storing the information properly, but I need to format the display to "trim" the output. For example, I have three prices for four items: Item 1 has a price of 45.9 Item 2 has a price of 9.99 Item 3 has a price of 2.985 Item 4 has a price of 0.4585 I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since it trims at two decimal places. The question is, how do I set up the NumberFormat to show the pricing properly when possible top-ends are up to $999,999,999.? TIA Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHEADER questions
Thanks for that link. Very informative. As to the other question: I was mainly interested in it from a practical point of view. When I insert the code on the page from a snippet, I always have to make sure that there isn't any whitespace, closing or tags, or any other tags after it, or they end up in the file. I just want to make sure the output gets cut off immediately. tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I'm not sure what you mean by stopping the output. Do you mean that you > might start working through a query (or something) and then find that you > don't want to send the data to the user after all? If so, you could first > put all the data to download into a variable, then only do the CFCONTENT if > you've decided the data are ok. > > I've used this sort of approach to create RTF files to download to the > browser before; I wouldn't call it easy but it's certainly possible. More > info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 > > -Original Message- > From: tom muck [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 10:21 AM > To: CF-Talk > Subject: CFHEADER questions > > > I have some code on my page using and that allows the > download of a to a text file. Is there anything I can use on > that page, aside from a or to stop the output of the > server to the text file? > > Also, is there an easy way to create an RTF or Word doc on the fly using > this method? > > tom > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHEADER questions
Another good way, if you want to output to word is to use the MS Word COM library. Some good samples are at www.cfcomet.com It's a pain, but end user's will love it :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:55 AM To: CF-Talk Subject: RE: CFHEADER questions I'm not sure what you mean by stopping the output. Do you mean that you might start working through a query (or something) and then find that you don't want to send the data to the user after all? If so, you could first put all the data to download into a variable, then only do the CFCONTENT if you've decided the data are ok. I've used this sort of approach to create RTF files to download to the browser before; I wouldn't call it easy but it's certainly possible. More info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:21 AM To: CF-Talk Subject: CFHEADER questions I have some code on my page using and that allows the download of a to a text file. Is there anything I can use on that page, aside from a or to stop the output of the server to the text file? Also, is there an easy way to create an RTF or Word doc on the fly using this method? tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfhttp access to https
Hi, Can cfhttp access to https site and get the files with username and pasword provided? if so, can anyone provide a code example!! Thank you very much yc If you change the query in any way, it will rerun, so you can do a couple things... One of the most interesting would be to make the CACHEDWITHIN value a variable, set in the Application.cfm, but updatable through the url. So, when you wanted to "flush" the cache, you could call the page with a url ?cache=flush, and your code would set the value of the CACHEDWITHIN to 0. Next run without the url variable would recache it back up. . Application.cfm: or whatever your normal cache value is ---> Think this might work? "Al Musella, DPM" wrote: > >I make extensive use of cached queries on 1 of my websites, that uses > read-only data that gets updated once a week.. > > the problem is that when I update that database, I want to clear the cache > so the new data is used.. sometimes the cached querry presents a record > that is no longer available, and when you click to get the details - the > record is no longer there, so it generates an error. > > So - how do you clear the cache? Hopefully with cfcode without having to > restart the CF server? > > Al Musella, DPM > A1webs.com > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Includes on HtML?
Thanks Tony, Are there any websites/books you could recommend I could go to for more information on accomplishing this via an NT/IIS box? Thanks, Dayv -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:11 AM To: CF-Talk Subject: RE: Includes on HtML? It's not in CF, it's done through your webserver. You add the extensions you wish to be parsed as cold fusion types. For example, in Apache: AddHandler type-coldfusion .mml DirectoryIndex index.mml Adds the extension .mml to be parsed by CF. (.cfm is added as part of the cf module) > I'd rather Cold Fusion parse through the HTM/HTML files. How is this done > via CF Server? > > Dayv > > > > -Original Message- > From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 04, 2001 2:03 PM > To: CF-Talk > Subject: RE: Includes on HtML? > > > In my opinion... > > Unless you have a huge amount of html files and are running other web sites > on the same server, this won't be a big performance concern. > > Also, remember, that if you have more than 1 virtual site on the server, you > can configure the applicable site to process htm and html files through the > ColdFusion server, so only that site will be processing the files through > CF. > > To use server side includes will not offer that much of a performance gain > since the ssinc.dll must then process the html files as well (by default it > is mapped to .shtm, .shtml and .stm files). So you'd be stuck in having the > ssinc.dll process the files vs. having ColdFusion's iscf.dll do the work. > > Changing file extensions is not really dangerous. Many sites use their own > custom extensions. If portability is not a concern then go ahead and do it. > Of course you can always rename the files and change the mappings back to > the way they were in IIS. > > - Andy > > > -Original Message- > > From: Erika L Walker [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, April 04, 2001 3:37 PM > > To: CF-Talk > > Subject: RE: Includes on HtML? > > > > > > WellI know it's not recommended changing how the server > > interprets .htm > > or .html files,however, if the site doesn't really take a > > huge amount of > > hitsand it's hosted on a server by itself.and the company flatly > > refuses to change the page names for fear of breaking bookmarks or some > > other silly reasonthen allow CF to parse through html files > > isn't a huge > > load.. > > > > But, if the hardware can't take the work and/or traffic beefs up, > > could slow > > everything down? > > > > Erika > > > > -Original Message- > > From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, April 04, 2001 2:28 PM > > To: CF-Talk > > Subject: RE: Includes on HtML? > > > > > > > > > > But the question was "can I a file from a page with the > > extension .htm or .html?" The answer is no. There is file inclusion > > using server side includes, which is actually how it is done in ASP. > > > > The thing to keep in mind is that 'includes' are synonymous with > > 'inline functions' as in C programming. The code just gets pasted to > > the current 'page'. So, if you could include a .cfm file within a > > ...html file, the CFML would not get processed unless you told your Web > > Server to run all .html files through your ColdFusion App Server, > > something that is usually not recomended. Check out Allaire's site. > > There are some diagrams there on the interactions betwix web server, > > cold fusion app server, and browser. Ask yourself 'What actually > > happens when I enter a URL and hit enter from my favourite browser?'. > > > > I think your stuck changing your files to .cfm files. opinions? > > > > DK > > > > > > > > From: [EMAIL PROTECTED] AT INTERNET on 04/04/2001 01:20 PM > > > > To: [EMAIL PROTECTED] AT INTERNET@CCMAIL > > cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) > > > > Subject: RE: Includes on HtML? > > > > > > You can CFINCLUDE a file with any extension. > > > > -Original Message- > > From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, April 04, 2001 12:21 PM > > To: CF-Talk > > Subject: Includes on HtML? > > > > > > Hi All, > > > > Another question. > > > > Can you from *.htm *.html based files? I want to be able > > to > > include a hit counter on some of our pages but not by not having them > > changed to .cfm. > > > > Thanks, > > Dayv > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Menu :: Spanning frameset?
Hey Paul. I had some other problems as well with DHTML menus, and unfortunately, there are no workarounds. DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading two different pages, there is no workaround other than creating a layer in the other fram that you want the layer to appear in... Becauase in a normal framset, your framesets occur in the head of the page, not the body, I don't think you can put layers inside of the head tags successfully... Good luck... Hope you find a better answer =) -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:08 AM To: CF-Talk Subject: OT: DHTML Menu :: Spanning frameset? ok. i have a dhtml menu in my left frame set. is there a way that i can have the sub menus overlap the main frame or right frame? right now in the left frame nav, if i open a few sub menus they are partially hidden due to the next frameset. i would like the sub menu on top of all the frames? any ideas? please advise.. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 > icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Maybe a silly question.
I've never seen this, but some thoughts I have: 1) what do the CF Server logs say? 2) how are you manipulating the record set? Are you building a variable to store all the recordset info and associated HTML cumulatively then outputting the value of that variable? Is there a limit to variable size in CF? What is it? I forget the answer to this question. I had this problem with Lotus Domino development. I was looping through a record set and adding the data plus some HTML to a variable in a cumulative fashion. It worked great for small recordsets but not large ones. The problem was that Domino has a 64KB limit on size. Just some thoughts, perhaps if you posted the code your using, we could help better - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 04/05/2001 11:32 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: Maybe a silly question. I have run into this situation in the past. I never came up with a concrete cause but found if I limited the output formatting it worked i.e. no tables). I think it had to do with buffers in the browser. Jeff -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:11 AM To: CF-Talk Subject: RE: Maybe a silly question. I thought out that as well, however this is a dynamic query that the results of the query changes frequently. It is not cached. I have consider timeouts on the server however, I can turn right around and execute another query with less results and they will display. This happens infrequently. Maybe once every 10 queries or so. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 9:47 AM To: CF-Talk Subject: Re: Maybe a silly question. Is the query cached? I've had this problem with cachedwithin in the past. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com - Original Message - From: ""Adkins, Randy"" <[EMAIL PROTECTED]> Newsgroups: dotcom.lists.cftalk Sent: Thursday, April 05, 2001 2:18 PM Subject: Maybe a silly question. > Okay this might be off the wall, but it escapes me as to the reasoning of > this. > > I have a query that runs and generates between 200-2000 records to be > displayed > to the user. When the record count is low say below 300 or 4000, it will > spit out > the desired results without a problem. > > However when the record count is higher, say once the query is completed and > it will display a BLANK Page. No out put or anything. If you view the source > of it, > you will see the following: > > > > > > > I have no MAXROWs or Aborts or EXIT tags that would prevent this from > displaying > the appropriate data. > > Any ideas? > > Thanks in advance. > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Changing CF Studio Shortcuts
> I was wondering if it is possible to change the shortcut for > control+shift+m. Currently, it will insert regular html comments, but I > would like it insert cfml comments. I went into the Options->Customize > menu, and looked at the keyboard shortcuts, but it doesn't look like you can > edit what the shortcut does, only assign or re-assign a shortcut. There > also does not appear to be an entry for CFML comment. IS there a way I can > do this? Easy: Shift-F8. Keyboard Shortcuts tab. Scroll down to the Description "ColdFusion comment" and select it. Click in the window to the left of the "Apply" button. Hold Down Ctrl-Shft-M and then click the "Apply" button. Confirm that you wish to reassign that shortcut. Click Close and you're done. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Changing CF Studio Shortcuts
You can create a code snippet which inserts CFML comments, and then assign Ctrl + Shift + M to that snippet. I think Studio asks if you're sure you want to assign that key combination to the snippet, since, as you said, it is already assigned to HTML comments. I've created other snippets to insert ##, (), and ##/ and then assigned them to Ctrl + 3, Ctrl + 0 and Ctrl + Shift + O, respectively. They're very helpful, save a lot of time, and keep my hand off of the mouse. :-) Snippets are your friends. HTH, Matthew -Original Message- From: Chris Martin [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:27 AM To: CF-Talk Subject: Changing CF Studio Shortcuts Hi. I was wondering if it is possible to change the shortcut for control+shift+m. Currently, it will insert regular html comments, but I would like it insert cfml comments. I went into the Options->Customize menu, and looked at the keyboard shortcuts, but it doesn't look like you can edit what the shortcut does, only assign or re-assign a shortcut. There also does not appear to be an entry for CFML comment. IS there a way I can do this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: DHTML Menu :: Spanning frameset?
I don't knnow whbich DHTML menu you are using, but Hiermenus has an option for this, making it possible to show (sub) menu's in another frame... richard ten Barge 1MB At 11:08 5-4-2001 -0400, you wrote: >ok. >i have a dhtml menu in my left frame set. >is there a way that i can have the sub menus overlap the main frame or right >frame? > >right now in the left frame nav, if i open a few sub menus they are >partially hidden due to the next frameset. >i would like the sub menu on top of all the frames? > >any ideas? >please advise.. > >thank you > >-paul > >Web Developer, NBBJ >Work: [EMAIL PROTECTED] > 614 241-3534 >fax: 614 485-5534 > >Home: [EMAIL PROTECTED] > 614 449-1681 > >> icq: 47658358 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists