Asset and Inventory Tracking Application
I am looking for an asset/inventory tracking application written in Cold Fusion. Would like to find one tht supports MS SQL Server as the database engine if possible. Thanks in advance Kent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Fire Department Blotter Program
I am working with a local volunteer fire department that needs a daily blotter (log) program for keeping a running log of activities and runs into a MS SQL database. Anyone heard of anything already created in CF? Thanks in Advance, Kent ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFIF Statement
Trying to do a CFOUTPUT Statement that returns all of the lastname records that begin with the letter A, and order by lastnames, but the following is not working, any ideas? cfif LASTNAME IS A#LASTNAME#/cfif Thanks in advance, Kent __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFIF Statement
Thanks for the information, how would I keep the database from displaying the remaining LASTNAME records that don't start with A? This is what I have thus far, CFQUERY DATASOURCE=clast NAME=list SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM olist ORDER BY LASTNAME /CFQUERY CFOUTPUT QUERY=list cfif Left(LastName,1) eq A#LASTNAME#/CFIF, #FIRSTNAME# #DEPARTMENT#BR /CFOUTPUT - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 24, 2002 12:13 PM Subject: Re: CFIF Statement CFIF LEFT(LASTNAME,1) EQ A#LASTNAME#/CFIF [EMAIL PROTECTED] 06/24/02 12:10PM Trying to do a CFOUTPUT Statement that returns all of the lastname records that begin with the letter A, and order by lastnames, but the following is not working, any ideas? cfif LASTNAME IS A#LASTNAME#/cfif Thanks in advance, Kent __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Receive CFQUERY results in dollar format
I'm trying to write a CFQUERY statement that will take data from a Microsoft Access 2000 database and return the numeric value as dollar value. I have tried using DOLLARFORMAT in the CFOUTPUT statement but I have six different pricing columns based on the product size and the empty columns/rows show $0.00 if the DOLLARFORMAT command is used. The Microsoft Access database columns are formatted as follows: FIELD SIZE: Long Integer FORMAT: Fixed Decimal Places: 2 This is what I have thus far for the CFQUERY: CFQUERY DATASOURCE=cat NAME=Products SELECT SPECIES, DESCRIPTION, SIZE_A, PRICE_A1, PRICE_A2 SIZE_B, PRICE_B1, PRICE_B2 SIZE_C, PRICE_C1, PRICE_C2 FROM ProductTable ORDER BY SPECIES /CFQUERY Thanks in advance... Kent NB: This email and any attachments have been checked for the presence of computer viruses using McAfee's Anti-Virus Protection technology. None were found. - Imagenet Tel: 513-561-2328 http://www.imagenet2000.com Sales Email: [EMAIL PROTECTED] Support Email: [EMAIL PROTECTED] This message is confidential and intended solely for the use of the addressee. Quotations are subject to contract and valid for 28 days. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Receive CFQUERY results in dollar format
Steve and everyone else, Thanks for the CFIF suggestion, this will work, I was attacking the problem from a different direction. Kent - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 7:35 AM Subject: RE: Receive CFQUERY results in dollar format I'm assuming you want nothing returned then if the value is 0? Why not just use a cfif? cfoutput query=cat cfif cat.price_a1 GT 0 #DollarFormat(cat.PRICE_A1)# /cfif cfif cat.price_a2 GT 0 #DollarFormat(cat.PRICE_A2)# /cfif /cfoutput __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Kent A. Orso [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 7:25 AM To: CF-Talk Subject: Receive CFQUERY results in dollar format I'm trying to write a CFQUERY statement that will take data from a Microsoft Access 2000 database and return the numeric value as dollar value. I have tried using DOLLARFORMAT in the CFOUTPUT statement but I have six different pricing columns based on the product size and the empty columns/rows show $0.00 if the DOLLARFORMAT command is used. The Microsoft Access database columns are formatted as follows: FIELD SIZE: Long Integer FORMAT: Fixed Decimal Places: 2 This is what I have thus far for the CFQUERY: CFQUERY DATASOURCE=cat NAME=Products SELECT SPECIES, DESCRIPTION, SIZE_A, PRICE_A1, PRICE_A2 SIZE_B, PRICE_B1, PRICE_B2 SIZE_C, PRICE_C1, PRICE_C2 FROM ProductTable ORDER BY SPECIES /CFQUERY Thanks in advance... Kent NB: This email and any attachments have been checked for the presence of computer viruses using McAfee's Anti-Virus Protection technology. None were found. - Imagenet Tel: 513-561-2328 http://www.imagenet2000.com Sales Email: [EMAIL PROTECTED] Support Email: [EMAIL PROTECTED] This message is confidential and intended solely for the use of the addressee. Quotations are subject to contract and valid for 28 days. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database of US Zip Codes
Check out CF_STATE on the Allaire Tag Gallery - Original Message - From: "JoshMEagle" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 12, 2001 8:52 AM Subject: RE: Database of US Zip Codes Anyone know of a pre-existing database of US zips/cities? Proabably a shot in the dark, but a shot I'm willing to take. JoshM -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 8:26 PM To: CF-Talk Subject: RE: Database of US Zip Codes Put it in a request-scoped cached query instead and you won't have any locking worries. best, paul At 08:26 AM 3/9/01 +1100, you wrote: 2. Is it good practice to have it as a query in an application.cfm (server or application scope) ~~ 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
Appointment Applicaton
Fellow CFer's, Looking for a appointment application written in Cold Fusion. The application should be able to support multiple users and allow for scheduling of appointments on an hourly basis. Anyone know of such an animal?? Thanks In Advance, Kent ~~ 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: Appointment Applicaton
Todd, Thanks for writing me about your developing application. I have checked out the Allaire Developer's Gallery and I found one that is close (SIBER) that might work. The problem is it won't allow for the scheduling of more than one appointment in the same timeframe. For instance, I need to be able to have two trainers booked at 9:00AM to 10:00AM with two different clients, or have them both booked to workout with one client. The owner has a restriction that he only wants two of the four Full time Personal Trainers in the facility during an appointment. So in a perfect world, I could book a one hour session at 10:00AM with Robert and another customer could book a 10:00AM session in the same gym with Lauren and the system would not allow for any additional bookings because the maximum number of trainers for that timeframe for that specific gym has been reached. Any chance you application could possibly handle this? If it can, it would be nice if it was a configuration change from 2, to 4, or 6, or 8 trainers in case he decides to expand. Any idea how much you app might run? I would give you all the copyright credit and exposure if it can do the job. Kent A. Orso Vice-President I M A G E N E T http://www.imagenet2000.com http://www.imagenet.cc - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 14, 2000 10:02 AM Subject: Re: Appointment Applicaton Yes .. I am writing one as we speak. It should be completed by the end of the year. It allows for scheduling down to 15 minute intervals and supports repeating appointments on a daily, weekly, monthly, quarterly and yearly basis an 'infinite' amount of time into the future. I can show you what I have so far, but I can't grantee that it will always be functional since I am actively working on it. If you need something more immediately, there are 3 or 4 good calendar/scheduling apps in the Allaire tag gallery. Todd Ashworth - Original Message - From: "Kent A. Orso" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 14, 2000 8:21 AM Subject: Appointment Applicaton | Fellow CFer's, | Looking for a appointment application written in Cold Fusion. The | application should be able to support multiple users and allow for | scheduling of appointments on an hourly basis. Anyone know of such an | animal?? | | Thanks In Advance, | | Kent | | | ~~ 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
MY Apologies
Sorry to all the list members for my last post, I was not paying attention to my reply address info. ~~ 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 Application
Does anyone know of a Chat Application written in CF that will work with about 30-40 users at one time and will work with users coming in from AOL, Prodigy or MSN? I need an application that will allow a couple of moderators to "police" the room and "mute" or remove abusive users. Kent A. Orso [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
Photo Database App
Does anyone out in CF-Land know of a photo database app written in CF? What I am looking for is a database app that would allow you to bring up a page with multiple thumbnails of photos with possibly a small description. The text and photos (thumbnails and originals) would be indexed int he database. Any user hiting the website would, be taken to a page dynamically generated from the entries in the database. Thanks In Advance, Kent -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Chat Application
Does anyone out in CF Land know of a WEBTV "friendly" Chat Application? I'd like to find one written in Cold Fusion if possible. Thanks in Advance, Kent -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Other File Types
I know someone already touched on this, but I can't seem to find the email so I'll ask again. Where in Cold Fusion Administrator, do I add other files types that I want the Cold Fusion server to recognize beyond *.cfm types? (i.e. - *.html, *.jtml) Thanks in Advance, K. Orso -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Other File Types
It's Website 2.5, is this the time that I say "Doh!"... Thanks.. - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 02, 2000 7:44 AM Subject: Re: Other File Types It's in the webserver setting that you put those settings... What webserver you using ? Justin - Original Message - From: "Kent A. Orso" [EMAIL PROTECTED] To: "CF-TALK" [EMAIL PROTECTED] Sent: Wednesday, August 02, 2000 12:32 PM Subject: Other File Types I know someone already touched on this, but I can't seem to find the email so I'll ask again. Where in Cold Fusion Administrator, do I add other files types that I want the Cold Fusion server to recognize beyond *.cfm types? (i.e. - *.html, *.jtml) Thanks in Advance, K. Orso -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FAQ Application
Anyone know if an inexpensive FAQ application written in ColdFusion to use with an Oracle database? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: U.S. states pull down menu
Go to the Tag Gallery on Allaire and do a search for CF_STATE - Original Message - From: "Tom Rainey" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 19, 2000 8:04 PM Subject: U.S. states pull down menu Can someone direct me to a snippet somewhere for a U.S. states pull down menu? Thanks, Tom -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Imagenet USA Tel USA: 513-271-9566 Fax USA: 513-753-7705 6225 Margo Lane Cincinnati, Ohio 45227 URL: http://www.imagenet2000.com EMail: [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.