Re: CF5 Pro SN
ahhh I think that one is inappropriate... :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Mr Warez <[EMAIL PROTECTED]> Date: Thu, 30 Aug 2001 06:17:03 + Subject: CF5 Pro SN > CFW500-79133-54309-11736 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: template statistics...
Jeff, that works like a gem... wonder if that is truly how it is done :) need to compare with the server reported times for the fancy admin debugging... I placed the starter code in the application.cfm and made the output and counter land in the footer... after the statement :) Very nice... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: "Garza, Jeff" <[EMAIL PROTECTED]> Date: Wed, 29 Aug 2001 22:59:44 -0700 Subject: RE: template statistics... > To get the execution time of the page use the GetTickCount() > function. > > > do some CF processing here or render the entire page > > Execution Time: #bar# ms > > HTH, > > Jeff Garza > Webmaster, > Spectrum Astro, Inc. > [EMAIL PROTECTED] > > -Original Message- > From: Paris Lundis > To: CF-Talk > Sent: 8/29/01 10:15 PM > Subject: RE: template statistics... > > Thanks Michael... I use a permutation of that for some overall server > stats... for when the server is flaking out :) great stuff for > watching > pages fly out when the server is active ... > > I am looking for the undocumented feature that spits out the page > execution time of the current page... including the queries and such > as > part of that... :) > > -paris > [finding the future in the past, passing the future in the present] > [connecting people, places and things] > > > -Original Message- > From: Michael Punsky <[EMAIL PROTECTED]> > Date: Thu, 30 Aug 2001 00:43:28 -0400 > Subject: RE: template statistics... > > > > > -- > > This example gets and displays the metric data provided by > > Windows NT PerfMonitor. > > > - > > -> > > > > > > > > > > Current PerfMonitor data is: > > InstanceName: #pmData.InstanceName# > > PageHits:#pmData.PageHits# > > ReqQueued: #pmData.ReqQueued# > > DBHits: #pmData.DBHits# > > ReqRunning: #pmData.ReqRunning# > > ReqTimedOut: #pmData.ReqTimedOut# > > BytesIn: #pmData.BytesIn# > > BytesOut: #pmData.BytesOut# > > AvgQueueTime: #pmData.AvgQueueTime# > > AvgReqTime: #pmData.AvgReqTime# > > AvgDBTime: #pmData.AvgDBTime# > > CachePops:#pmData.CachePops# > > > > > > > > -Original Message- > > From: Paris Lundis [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 30, 2001 12:05 AM > > To: CF-Talk > > Subject: template statistics... > > > > > > silly question.. > > > > you know that template enhanced admin stuff that trails on the > bottom > > of the pages when you specify IPs to report such to?... > > > > well namely the execution time in milliseconds... how can I get > that > > value directly (programmatically)... want to utilize it within code > > elsewhere... couldn't find any samples or documentation on it... > > > > -paris > > [finding the future in the past, passing the future in the present] > > [connecting people, places and things] > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
CF5 Pro SN
CFW500-79133-54309-11736 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Message Board
http://www.simplemessageboard.com/ > Anyone know of a good, open source message board written in CF? I've found > a few packages, but they are all encoded. I'd rather find an open source > one that I can implement and also learn from. > > John > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: template statistics...
To get the execution time of the page use the GetTickCount() function. do some CF processing here or render the entire page Execution Time: #bar# ms HTH, Jeff Garza Webmaster, Spectrum Astro, Inc. [EMAIL PROTECTED] -Original Message- From: Paris Lundis To: CF-Talk Sent: 8/29/01 10:15 PM Subject: RE: template statistics... Thanks Michael... I use a permutation of that for some overall server stats... for when the server is flaking out :) great stuff for watching pages fly out when the server is active ... I am looking for the undocumented feature that spits out the page execution time of the current page... including the queries and such as part of that... :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Michael Punsky <[EMAIL PROTECTED]> Date: Thu, 30 Aug 2001 00:43:28 -0400 Subject: RE: template statistics... > -- > This example gets and displays the metric data provided by > Windows NT PerfMonitor. > - > -> > > > > > Current PerfMonitor data is: > InstanceName: #pmData.InstanceName# > PageHits:#pmData.PageHits# > ReqQueued: #pmData.ReqQueued# > DBHits: #pmData.DBHits# > ReqRunning: #pmData.ReqRunning# > ReqTimedOut: #pmData.ReqTimedOut# > BytesIn: #pmData.BytesIn# > BytesOut: #pmData.BytesOut# > AvgQueueTime: #pmData.AvgQueueTime# > AvgReqTime: #pmData.AvgReqTime# > AvgDBTime: #pmData.AvgDBTime# > CachePops:#pmData.CachePops# > > > > -Original Message- > From: Paris Lundis [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 30, 2001 12:05 AM > To: CF-Talk > Subject: template statistics... > > > silly question.. > > you know that template enhanced admin stuff that trails on the bottom > of the pages when you specify IPs to report such to?... > > well namely the execution time in milliseconds... how can I get that > value directly (programmatically)... want to utilize it within code > elsewhere... couldn't find any samples or documentation on it... > > -paris > [finding the future in the past, passing the future in the present] > [connecting people, places and things] > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: TextArea
Neil, Here is a good resource for ASCII codes: http://www.asciitable.com/ Best regards, Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com/ -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 AM To: CF-Talk Subject: Re: TextArea I inserted a #chr(10)# and got number 1. Now I want to prepend a > to the front of each line. Basically like Outlook Express or any other mail program does to a mail (see below :) ) Thanks, Neil - Original Message - From: "Will Swain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 6:07 AM Subject: RE: TextArea > 1) Can you be more specific? Lets see the code? > > 2) > is > > > -Original Message- > From: Neil H. [mailto:[EMAIL PROTECTED]] > Sent: 29 August 2001 06:39 > To: CF-Talk > Subject: TextArea > > > Two things with a text area: > > 1. I have some text and I have a break in my code but it isn't breaking on > my screen. Any ideas would help? > > 2. Also I want to append a ">" in the front of each line but I can't find > the right combination of chr(10) chr(13) that would properly work. Any > ideas here would be appreciated too. > > Thanks, > > Neil > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: template statistics...
Thanks Michael... I use a permutation of that for some overall server stats... for when the server is flaking out :) great stuff for watching pages fly out when the server is active ... I am looking for the undocumented feature that spits out the page execution time of the current page... including the queries and such as part of that... :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Michael Punsky <[EMAIL PROTECTED]> Date: Thu, 30 Aug 2001 00:43:28 -0400 Subject: RE: template statistics... > -- > This example gets and displays the metric data provided by > Windows NT PerfMonitor. > - > -> > > > > > Current PerfMonitor data is: > InstanceName: #pmData.InstanceName# > PageHits:#pmData.PageHits# > ReqQueued: #pmData.ReqQueued# > DBHits: #pmData.DBHits# > ReqRunning: #pmData.ReqRunning# > ReqTimedOut: #pmData.ReqTimedOut# > BytesIn: #pmData.BytesIn# > BytesOut: #pmData.BytesOut# > AvgQueueTime: #pmData.AvgQueueTime# > AvgReqTime: #pmData.AvgReqTime# > AvgDBTime: #pmData.AvgDBTime# > CachePops:#pmData.CachePops# > > > > -Original Message- > From: Paris Lundis [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 30, 2001 12:05 AM > To: CF-Talk > Subject: template statistics... > > > silly question.. > > you know that template enhanced admin stuff that trails on the bottom > of the pages when you specify IPs to report such to?... > > well namely the execution time in milliseconds... how can I get that > value directly (programmatically)... want to utilize it within code > elsewhere... couldn't find any samples or documentation on it... > > -paris > [finding the future in the past, passing the future in the present] > [connecting people, places and things] > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Speak Up (WAS: Macromedia strong arms developers into 5.0 upgrade)
> > That is, indeed, most disturbing. > > > > Hm... Allaire heard us (and listened) when we spoke up before. Maybe we > > all need to speak up now, to make this work for all of our community, > > not just the few with deeper pockets? I am just getting on top of this thread, but I want to at least post a note and let people know that we are listening. I am going to find out what we can do about the issue. We are very committed to ColdFusion and our users. I can't tell you how often in every meeting I go to, the question comes up, how can we support CF better in product (you pick which one). My guess, off the top of my head, based on 10 years of experience in shrinkwraped software, that the code base for CF4.x was closed and archived long before CF5 shipped. It would be really unusual to come out with an update for a previous version of a product to make it compatible with a server that was not released when the product was. Perhaps there is something that we can do though so I will look into that. I am sorry this is causing frustration here, I should have been on top of it a little earlier, but the volume of mail here is quite high and I was catching up. _ Matt Brown Community Manager Macromedia (650) 481-4525 [EMAIL PROTECTED] Register now for Macromedia DevCon 2001! Visit for more information and to register http://www.macromedia.com/go/devcon. 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: template statistics...
Current PerfMonitor data is: InstanceName: #pmData.InstanceName# PageHits:#pmData.PageHits# ReqQueued: #pmData.ReqQueued# DBHits: #pmData.DBHits# ReqRunning: #pmData.ReqRunning# ReqTimedOut: #pmData.ReqTimedOut# BytesIn: #pmData.BytesIn# BytesOut: #pmData.BytesOut# AvgQueueTime: #pmData.AvgQueueTime# AvgReqTime: #pmData.AvgReqTime# AvgDBTime: #pmData.AvgDBTime# CachePops:#pmData.CachePops# -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:05 AM To: CF-Talk Subject: template statistics... silly question.. you know that template enhanced admin stuff that trails on the bottom of the pages when you specify IPs to report such to?... well namely the execution time in milliseconds... how can I get that value directly (programmatically)... want to utilize it within code elsewhere... couldn't find any samples or documentation on it... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: template statistics...
I'm not sure if that data is available, it probably is, but when I want to time different sections of code here is what I do. It will probably work for you. At the top of the template I create a timing structure, and then any point I want to see when the piece of code executed I insert a getTickCount() timestamp and label the time. For your purposes getting the tickcount at only the top and bottom would suffice. some code... execute BigUglyCode... more code... GetTickCount() is supposedly accurate to milliseconds, so subtracting the start time from the end time will get the time in milliseconds that it took the code between to execute. jon Paris Lundis wrote: >silly question.. > >you know that template enhanced admin stuff that trails on the bottom >of the pages when you specify IPs to report such to?... > >well namely the execution time in milliseconds... how can I get that >value directly (programmatically)... want to utilize it within code >elsewhere... couldn't find any samples or documentation on it... > >-paris >[finding the future in the past, passing the future in the present] >[connecting people, places and things] > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
template statistics...
silly question.. you know that template enhanced admin stuff that trails on the bottom of the pages when you specify IPs to report such to?... well namely the execution time in milliseconds... how can I get that value directly (programmatically)... want to utilize it within code elsewhere... couldn't find any samples or documentation on it... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
ColdFusion Diagnostic tools?
I've a prospective client who is having some problems with their ColdFusion server, their Windows/IIS server, or a CF App...they're not sure which. I'll be speaking to them tomorrow to get more info, but I'm wondering if anyone has any suggestions on diagnostic tools for ColdFusion server, besides the obvious server logs and such. I've never really used any external diag tools for troubleshooting CF Server, so I thought I'd see what others use. -Kev > -Original Message- > From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 10:28 PM > To: CF-Talk > Subject: RE: custom make Page not found > > > Either setup your web servers custom error templates or use the Missing > Template/Site-Wide Error handling of the CF Administrator (under > Server/Settings - at least under CF5). > > Peter Tilbrook > ColdFusion Applications Developer > Australia New Zealand Food Authority > Boeing House > 55 Blackall Street > BARTON ACT 2600 > Ph: +61-2-6271 2256 > Fax: +61-2-6271 2278 > > http://www.anzfa.gov.au > > -Original Message- > From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 30 August 2001 12:09 > To: CF-Talk > Subject: OT: custom make Page not found > > > hi all, > > can anyone tell me how can i redirect the user to a custom template when > a > page they requested cannot be found. I do not want the user to see the > "Te > page cannot be found" template or the "Error HTTP/1.0 404 Object Not > Found" > templete. > > I'm using apache, did i need to configure on the apache or it have to do > with CF? > > thanks. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: custom make Page not found
Either setup your web servers custom error templates or use the Missing Template/Site-Wide Error handling of the CF Administrator (under Server/Settings - at least under CF5). Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Thursday, 30 August 2001 12:09 To: CF-Talk Subject: OT: custom make Page not found hi all, can anyone tell me how can i redirect the user to a custom template when a page they requested cannot be found. I do not want the user to see the "Te page cannot be found" template or the "Error HTTP/1.0 404 Object Not Found" templete. I'm using apache, did i need to configure on the apache or it have to do with CF? thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
OT: custom make Page not found
hi all, can anyone tell me how can i redirect the user to a custom template when a page they requested cannot be found. I do not want the user to see the "Te page cannot be found" template or the "Error HTTP/1.0 404 Object Not Found" templete. I'm using apache, did i need to configure on the apache or it have to do with CF? thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Dates in Access
On Tue, 28 Aug 2001 09:06:15 +0800, "Kay Smoljak" <[EMAIL PROTECTED]> wrote: >Sorry for what is undoubtably a basic question, but I've been spoilt >with SQL Server. I'm trying to insert a date into an Access database. >The parts of the date have been split into their day, month and year >components - and #createdate(form.year,form.month,form.day)# is throwing >a very unhelpful "syntax error" in Access. So is >#createODBCDate(created_date)# (after assigning the results of >createdate() to created_date). So how are dates meant to be formatted? Thanks to everyone who replied. Turned out it was because I had single quotes around the date functions. As we say in Australia, "how embarrassment". Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
> systems). In our case, we either create another layer of > abstraction (e.g. EJBs, regular Java classes, etc.) or simply > write the SQL in query files (assuming we're using ColdFusion, > that is) - either way we almost completely do away with stored > procedures in this case. Out of curiosity, are you using object tiers with CF? > One thing I like about Java is the ability to use "prepared > statements", which can be created dynamically at run-time, but > is only compiled on the server *once*, and can be used as many > times as needed with different parameters. In this case, the > speed improvement of a stored procedure is negligible (certainly > not noticeable). You can create prepared statements by using CFQUERYPARAM within your CFQUERY tags. If you're using Oracle, that'll probably run as fast as a stored procedure, but doesn't seem to make as much of a difference on SQL Server, which seems to favor stored procedures more. > BTW, I know stored procedures are great to use for most > applications - I was just playing devil's advocate and explaining > disadvantages of using them. There's nothing wrong with discussing pros and cons of an issue. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
I know this is a CF list and yea, I build my own carts in CF. But for a "QUICK" cart for a lower cost site, you cannot beat Merchant Order Form (www.merchantorderform.com). It's a very complete, very well documented package in Perl. I believe I got a 10 site license for $45. Man, it is worth 20x that. Also, you get great email support. Has PaymentNet and other tie ins - very customizable. This guy thought of everything! Check it out. I've deployed it on 4 sites so far and it works great! FWIW Dave - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 7:15 PM Subject: RE: shopping cart / online store > On 8/29/01, Dan Phillips penned: > >I've always liked http://dansie.net/cart.html . It's a really simple Perl > >based cart that is pretty flexable. It can handle "mom and pop" type sites > >or really heavy e-commerce sites. Priced reasonably too. > > UGH! Dansie Cart is what finally what pushed me over the edge into > learning ColdFusion. I think I tried everything from Perlshop, to > Dansie, to Miva and finally figured it be easier to just figure out > how to build a cart than to try and make one of those things do what > you actually want it to do. :) > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: CF Hosting
don't know of any ratings matrix's (but would be a good idea) but CrystalTech are pretty cool - plus cheap. They have a great reputation and really good support. Toby Life is poetry, write it in your own words Toby Tremayne Code Poet and Zen Master of the Heavy Sleep Mercury Red L 9, 123 Queen st Melbourne VIC 3000 DISCLAIMER - All errors and omissions excepted. This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error, please notify Mercury Red immediately - Original Message - From: BEN MORRIS <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 1:27 AM Subject: CF Hosting > Fellow Developers, > > I am looking for a good (cheap) CF host for my personal sites, anyone have praise/horror stories for: > CFXHosting.com > or > CFM-Resources.com > > Or even better, does anyone know of a page that actually lists cf hosts with user ratings? I have seen rated web hosts, and lists of CF hosts, but never the combination of the two. > > Thanks for any input. > > --- > > Ben Morris > > Web Site Developer > American Federation of Government Employees, AFL-CIO > (202) 639-6448 > www.afge.org > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: IIF and DE
Hi, Good idea, but I think you missed the problem. There is not two different expressions to evaluate to be TRUE or FALSE as in your example -- just the isDefined function. CF shouldn't be executing the "... blah blah blah ...", but it does, and that is the problem. -Brent -Original Message- From: Tyson Vanek [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 5:57 PM To: CF-Talk Subject: RE: IIF and DE This goes back to the way the old used to behave. In the past (I think up until CF ver 4.5), the same problem existed with . Here's an example. Say that the parameter "strFoo" doesn't exist, consider the following code: ... blah blah blah ... ... blah2 blah2 blah2 ... In the past, ColdFusion would choke on the CFIF statement when "strFoo" was not defined, even though you'd expect it to immediately jump to the CFELSE statement once the isDefined() returned false. I believe this was fixed with the release of ColdFusion 4.5 - I might be wrong on the version number. My guess is that this behavior is still leftover in the iif() function. I've noticed this in my own development as well that I never seem to be able to use an isDefined() check in an iif() block. Doing so always results in the "Error resolving parameter" error. A workaround would be to set a default for the variable using CFPARAM and then changing your iif() logic. Here's an example: Hope this helps, Tyson -Original Message- From: Brent Goldman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:36 PM To: CF-Talk Subject: IIF and DE Hi, I'm trying to use IIF with DE, and it doesn't seem to be working. My code: http://www.fusionauthority.com/bkinfo.cfm 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: IIF and DE
This goes back to the way the old used to behave. In the past (I think up until CF ver 4.5), the same problem existed with . Here's an example. Say that the parameter "strFoo" doesn't exist, consider the following code: ... blah blah blah ... ... blah2 blah2 blah2 ... In the past, ColdFusion would choke on the CFIF statement when "strFoo" was not defined, even though you'd expect it to immediately jump to the CFELSE statement once the isDefined() returned false. I believe this was fixed with the release of ColdFusion 4.5 - I might be wrong on the version number. My guess is that this behavior is still leftover in the iif() function. I've noticed this in my own development as well that I never seem to be able to use an isDefined() check in an iif() block. Doing so always results in the "Error resolving parameter" error. A workaround would be to set a default for the variable using CFPARAM and then changing your iif() logic. Here's an example: Hope this helps, Tyson -Original Message- From: Brent Goldman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:36 PM To: CF-Talk Subject: IIF and DE Hi, I'm trying to use IIF with DE, and it doesn't seem to be working. My code: http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
> -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 6:59 PM > To: CF-Talk > Subject: RE: shopping cart / online store > > > That's certainly true, but in the case of most complex > applications, you're > not likely to switch the database on a whim, hopefully. I've usually found > that the cost of using proprietary SQL extensions in writing stored > procedures is far outweighed by the gains in performance and application > partitioning. In most cases, yes... at the company I work at, however, we build custom applications (e.g. intranets and extranets) that we have a "template" for, and we just customize these for a particular platform (whatever the customer wants) and make tweaks here and there at the customer's request. In order for this to work, and to be able to re-use what we've done and not be tied down to one database, we can't use stored procedures (and the intranet and extranet applications we create are certainly "complex" systems). In our case, we either create another layer of abstraction (e.g. EJBs, regular Java classes, etc.) or simply write the SQL in query files (assuming we're using ColdFusion, that is) - either way we almost completely do away with stored procedures in this case. One thing I like about Java is the ability to use "prepared statements", which can be created dynamically at run-time, but is only compiled on the server *once*, and can be used as many times as needed with different parameters. In this case, the speed improvement of a stored procedure is negligible (certainly not noticeable). > > While I can imagine that this is possible, I'd argue that in most cases, > you're going to get better overall performance by placing all data > manipulation code (including the parts of your business logic that involve > data manipulation) in stored procedures. I think you're more likely to end > up queueing database requests from your CF servers with lots of little > queries that bring back recordsets for further manipulation in CF than you > are to simply let the database do what it does best. At least, that's been > my experience so far. I guess that if you get to the point where > the stored > procedures are causing problems, you'd be better served with an > object tier > between your database client and server, rather than simply putting data > manipulation logic in CF. > You're right - in most cases performance is better with stored procedures. I just don't like tying myself down to a certain database vendor - it scares me ;-). BTW, I know stored procedures are great to use for most applications - I was just playing devil's advocate and explaining disadvantages of using them. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
Actually, the argument here goes both ways. On one hand, you could code all your queries into stored procedures. In this manner, database operations typically end up performing faster than they would with inline ColdFusion statements. However, if you want to port your ColdFusion code to a different RDBMS (i.e. MS SQL Server to Oracle), then you'll likely have to re-write all the stored procedures per Oracle's standards. Additionally, if your ColdFusion developers do not have access to directly modify the stored procedures (sometimes only the DBA will have these rights), then making a change to a database call now involves more people and typically takes longer to complete. On the other hand, you could code all your queries into the ColdFusion code. In this manner, the queries will not run as fast, but any developer with access to change CFML code with also have direct rights to change database calls - eliminating the possible bottleneck mentioned above with getting a DBA involved. However, now if someone wants to port the application to a different language (i.e. ASP, PHP, Perl, whatever) or perhaps build an add-on application that points to the same database, you've now got to re-write all that database business logic in the new language or the new application. That said, as a developer you really have to weigh this against what best suites your needs. Perhaps you're dealing with a low volume site on a hosted server where you don't have rights to create/update stored procedures. In that case, it makes more sense to build your database logic in-line with statements. However, if you're dealing with a high-traffic site with tons of simultaneous users and have rights to create/update stored procedures (in addition to the knowledge of how to actually write them), you'd probably be best off writing your database logic into stored procedures. Either way, if you shift the RDBMS or the language of the application, you're going to run into some need to change large portions of logic - whether it's in stored procs or it's in ColdFusion code. Just my $0.02, -Tyson -Original Message- From: Dave Feltenberger [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:44 PM To: CF-Talk Subject: RE: shopping cart / online store The problem with using stored procedures is that if you decide to switch databases, you have to re-write all of them because almost all database vendors use different stored procedure code and structure. By writing the queries in the program itself (included as a query file or in the actual file, whichever), you're not quite as locked into the database - as long as you're using a relational database that supports SQL standards and you write standard SQL, you should be ok to plug and play databases as you please - stored procs screw that all up. Another problem with putting too much business logic in stored procedures is that you put too much strain on the database if the site is hit hard - I worked on a site that gets upwards of a million hits a day (www.casio.com) and using stored procedures to do too much business logic would have bogged down the database servers far too much to make it worthwhile. Instead, we load balanced it all onto several really fast ColdFusion servers and they do the business logic. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 5:29 PM To: CF-Talk Subject: RE: shopping cart / online store Coding wise, you better use a real good methodology (gotta do that at all times anyways :P ). Net(fo'got the name) uses fusebox as said on their site. Database wise, you better depend a lot on stored procedures and triggers :) makes things a lot easier and faster. I started working with ASP last week, and passing data back and forth from the DB is a nightmare since I am so used to coldfusion's so very easy query thingamajig. But the ASP project I was updating really relied on stored procedures, and updating it was simple! Although passing variables and such to the stored procedure was still more of a headache than using CF's super dee duper stored procedure param tags =). Stored procedures are your friend! Try to code your site to make the code updated easy. Try not to spaghetti code, and all that stuff they taught u in programming basics. As far as functionality is concerned, think about how cool you want this application to be, then consider if it's worth the time and money. Then think think about how you want the clients to set up a store, and lay out things logically. >From: "Megan Cytron" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: shopping cart / online store >Date: Wed, 29 Aug 2001 16:57:17 -0400 > > > Hello > > Does anybody know of a good resource for planning, > > developing, and building > > an online store front with ColdFusion? > > Including search capabilities, credit card transactions, etc. > > > >Web Monkey has
RE: help with cfx_xmlparser
Nick, That class is part of the CFX library, cfx.jar There is a setting in the Java settings in CF Administrator for the CFX.jar file, make sure that is specified correctly. +++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 8:23 PM To: CF-Talk Subject: RE: help with cfx_xmlparser pf, here's the error. A NativeRequest class is missing in your CFX_XMLParser.jar file??? =Error Diagnostic Information java.lang.NoClassDefFoundError: com/allaire/cfx/NativeRequest. Java exception occurred in attempt to locate class 'com/allaire/cfx/NativeRequest' (you should verify that the class is in the CLASSPATH). == Nick Han >>> [EMAIL PROTECTED] 08/29/01 03:55PM >>> Nick you can't send attachments to the list, please send the error in the message body. Thanks -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:28 PM To: CF-Talk Subject: help with cfx_xmlparser Has anyone sucessfully implemented cfx_xmlparser found on www.cfdev.com ? I ran the setup and verified all java settings in the cf administrator, and they appeared to be setup correctly. The jvm path, the class path, and the cfx jar path are all there. But when I tried running the example page, I got a java exception. Attached is a snapshot off that error. Any insight on what could have caused this error would be appreciated. Thanks. Nick Han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
IIF and DE
Hi, I'm trying to use IIF with DE, and it doesn't seem to be working. My code: http://www.fusionauthority.com/bkinfo.cfm 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: help with cfx_xmlparser
pf, here's the error. A NativeRequest class is missing in your CFX_XMLParser.jar file??? =Error Diagnostic Information java.lang.NoClassDefFoundError: com/allaire/cfx/NativeRequest. Java exception occurred in attempt to locate class 'com/allaire/cfx/NativeRequest' (you should verify that the class is in the CLASSPATH). == Nick Han >>> [EMAIL PROTECTED] 08/29/01 03:55PM >>> Nick you can't send attachments to the list, please send the error in the message body. Thanks -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:28 PM To: CF-Talk Subject: help with cfx_xmlparser Has anyone sucessfully implemented cfx_xmlparser found on www.cfdev.com ? I ran the setup and verified all java settings in the cf administrator, and they appeared to be setup correctly. The jvm path, the class path, and the cfx jar path are all there. But when I tried running the example page, I got a java exception. Attached is a snapshot off that error. Any insight on what could have caused this error would be appreciated. Thanks. Nick Han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Studio 5.0 release date
Looks like a Release Candidate is already at: ftp://ftp2.allaire.com/pub/beta/cfstudio50rc.exe It's 18,584k Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 August 2001 21:09 To: CF-Talk Subject: RE: Studio 5.0 release date ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: counting min chars in form field
use javascript if you want... function checkForm(theForm){ theVal = theForm.zip.value.parseInt(); if( theVal.length() >= 3 && theVal.length() <= 5 ) return true; alert("You must enter whatever"); return false; } mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:31 PM To: CF-Talk Subject: counting min chars in form field How do you count chars in a form field. I have a zip code field that is used for a search. I want to allow them to key in 3-5 digits of a zip code. I've got max to make the 5 happen, but how do I check to make sure that they keyed at least 3? Brian Horn ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
OT: XML Questions
So, anyways, I'm creating a DTD for an XML document and have a few questions... I have a vendor that has an address. The address consists of various elements such as street, city, etc. Now then, the address element itself has no attributes or data directly in it. Is it worth having an address element? e.g. 123 any street calgary Also, when creating the XML document, if there is no street, should I do or just omit the attribute altogether? Do parsers get angry when there are elements that are empty? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Dynamic Fieldnames & database update
Erica, This should do what you want: UPDATE interview SET ivr_key = '#Evaluate("form.fieldname" & counter)#' WHERE ... Nelson - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 6:44 PM Subject: Dynamic Fieldnames & database update > > I am working on a dynamic form that allows me to update multiple records at > once. > We use the primary key from the table as a hidden field to identify the > record, and append a unique number to all fields from each record via a > counter. > For example, the form would look something like this > > < input key#counter#> < input fieldname#counter#> < input fieldname#counter#> > > > Problem is, when we go to update the database, how do we specify the > formfields? I'd assumed that we would need to loop over our counter again, > but I don't know how to make the dynamic fieldnames in the update. How do I > get coldfusion to recognize that I want #form.fieldname1# not > "form.fieldname1" and not "value of fieldname1" the first time I loop over > something like > UPDATE interview > SET ivr_key = '#form.fieldname##counter#' > > Any help would be appreciated! > > > Here's the form so far: > > > SELECT * > FROM interview INNER JOIN interviewer on interview.ivr_key = > interviewer.ivr_key > WHERE interview.ivr_key = #cookie.interviewerid# > AND sch_name = '#cookie.schoolsession#' > > > > > SELECT * > FROM Interviewer > > > > > > Scheduled Interviews for > #getinterviewdata.ivr_firstname# > #getinterviewdata.ivr_lastname# > > > > > ="post"> > > > > cellpadding="0"> > > Interviewer > Start Time > End Time > Location > > > > > > > > >cookie.InterviewerID eq GetIvrs.ivr_key>selected> > #getivrs.ivr_FirstName# #getivrs.ivr_LastName# > > > > > > #TimeFormat(getinterviewdata.int_StartTime, 'hh:mm tt')# > > #TimeFormat(getinterviewdata.int_EndTime, 'hh:mm tt')# > > #getinterviewdata.loc_Name# > value="#getinterviewdata.int_Code#"> > > > > ="#counter#"> > > > > > > > > > > > > > > > > > Thanks! > Erica > > > Erica Vitina > Web Developer > Abbott Laboratories > [EMAIL PROTECTED] > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
On 8/29/01, Dan Phillips penned: >I've always liked http://dansie.net/cart.html . It's a really simple Perl >based cart that is pretty flexable. It can handle "mom and pop" type sites >or really heavy e-commerce sites. Priced reasonably too. UGH! Dansie Cart is what finally what pushed me over the edge into learning ColdFusion. I think I tried everything from Perlshop, to Dansie, to Miva and finally figured it be easier to just figure out how to build a cart than to try and make one of those things do what you actually want it to do. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Netscape 6.1 Problems
No real clue but off the top of my head it sounds like the history object has changed. Why don't you print out the history array in your tag and then abort, maybe you can see what is happening. Don Vawter www.cyberroomies.com [EMAIL PROTECTED] - Original Message - From: "Kamie Curfman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 2:35 PM Subject: Netscape 6.1 Problems > okay, i've run out of ideas and am hoping someone on this list can help. > > after hitting the submit button, my code calls upon -- first thing in > the form's action page -- an in-house custom tag that does some form > validation. if anything in the form is not correct, a javascript pop-up > lets the user know what isn't right. this tag, which we've been using > for years, has worked beautifully in all browsers. for some reason, NN > 6.1 is not liking it. instead of popping up the message and kicking the > user back to the form, NN 6.1 duplicates everything in the javascript, > which means popping up the message twice and kicking the user back two > pages to the shopping cart (which means they have to fill out their > contact/payment info all over again -- not good!). why is this > happening??? has anyone else encountered similar behavior with NN 6.1? > > after doing the form validations, here is the code in the custom tag: > > > > > > > > > > > any thoughts would be much appreciated. thanks! > > ~kamie > > -- > Kamie B. Curfman > Matrix Group International, Inc. > 801 N. Fairfax Street, Suite 205 > Alexandria, VA 22314 > Phone: (703) 838-9777 x3014 > Fax: (703) 838-9799 > [EMAIL PROTECTED] > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: help with cfx_xmlparser
Nick you can't send attachments to the list, please send the error in the message body. Thanks -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:28 PM To: CF-Talk Subject: help with cfx_xmlparser Has anyone sucessfully implemented cfx_xmlparser found on www.cfdev.com ? I ran the setup and verified all java settings in the cf administrator, and they appeared to be setup correctly. The jvm path, the class path, and the cfx jar path are all there. But when I tried running the example page, I got a java exception. Attached is a snapshot off that error. Any insight on what could have caused this error would be appreciated. Thanks. Nick Han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: CF Certified Developer
Hi, Download the demo of CF_BUSTER (just do a search on google to find the home site). It has lots of good demo questions. -Brent -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:02 AM To: CF-Talk Subject: CF Certified Developer Can you guys shoot me an insight as to what is on the test? Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Dynamic Fieldnames & database update
use the evaule function. in your loop, do this (lets say the counter is equal to 3) #Evaluate('form.dateofbirth'& counter)# coldfusion will read that as #form.dateofbirth3# Pooh Bear Web App Developer Picture Below (chicks dig my head!) http://www.geocities.com/kickerazn_2000/sniffles_138x92.jpg";> >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Dynamic Fieldnames & database update >Date: Wed, 29 Aug 2001 17:44:00 -0500 > > >I am working on a dynamic form that allows me to update multiple records at >once. >We use the primary key from the table as a hidden field to identify the >record, and append a unique number to all fields from each record via a >counter. >For example, the form would look something like this > >< input key#counter#> < input fieldname#counter#> < input >fieldname#counter#> > > >Problem is, when we go to update the database, how do we specify the >formfields? I'd assumed that we would need to loop over our counter again, >but I don't know how to make the dynamic fieldnames in the update. How do I >get coldfusion to recognize that I want #form.fieldname1# not >"form.fieldname1" and not "value of fieldname1" the first time I loop over >something like >UPDATE interview >SET ivr_key = '#form.fieldname##counter#' > >Any help would be appreciated! > > >Here's the form so far: > > > SELECT * > FROM interview INNER JOIN interviewer on interview.ivr_key = >interviewer.ivr_key > WHERE interview.ivr_key = #cookie.interviewerid# > AND sch_name = '#cookie.schoolsession#' > > > > > SELECT * > FROM Interviewer > > > > > > Scheduled Interviews for >#getinterviewdata.ivr_firstname# >#getinterviewdata.ivr_lastname# > > > > >="post"> > > > > cellpadding="0"> > > Interviewer > Start Time > End Time > Location > > > > > > > > > cookie.InterviewerID eq GetIvrs.ivr_key>selected> >#getivrs.ivr_FirstName# #getivrs.ivr_LastName# > > > > > >#TimeFormat(getinterviewdata.int_StartTime, 'hh:mm tt')# > >#TimeFormat(getinterviewdata.int_EndTime, 'hh:mm tt')# > >#getinterviewdata.loc_Name# >name="intkey#counter#" >value="#getinterviewdata.int_Code#"> > > > > ="#counter#"> > > > > > > > > >Value="Reset"> > > > > > > > >Thanks! >Erica > > >Erica Vitina >Web Developer >Abbott Laboratories >[EMAIL PROTECTED] > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
> The problem with using stored procedures is that if you > decide to switch databases, you have to re-write all of them > because almost all database vendors use different stored > procedure code and structure. By writing the queries in the > program itself (included as a query file or in the actual > file, whichever), you're not quite as locked into the > database - as long as you're using a relational database that > supports SQL standards and you write standard SQL, you should > be ok to plug and play databases as you please - stored procs > screw that all up. That's certainly true, but in the case of most complex applications, you're not likely to switch the database on a whim, hopefully. I've usually found that the cost of using proprietary SQL extensions in writing stored procedures is far outweighed by the gains in performance and application partitioning. > Another problem with putting too much business logic in > stored procedures is that you put too much strain on the > database if the site is hit hard - I worked on a site that > gets upwards of a million hits a day (www.casio.com) and > using stored procedures to do too much business logic would > have bogged down the database servers far too much to make > it worthwhile. Instead, we load balanced it all onto several > really fast ColdFusion servers and they do the business logic. While I can imagine that this is possible, I'd argue that in most cases, you're going to get better overall performance by placing all data manipulation code (including the parts of your business logic that involve data manipulation) in stored procedures. I think you're more likely to end up queueing database requests from your CF servers with lots of little queries that bring back recordsets for further manipulation in CF than you are to simply let the database do what it does best. At least, that's been my experience so far. I guess that if you get to the point where the stored procedures are causing problems, you'd be better served with an object tier between your database client and server, rather than simply putting data manipulation logic in CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Encrypt and Decrypt - CFX_FuguCrypt demo is up...
Ron Hornbaker wrote: > Yesterday after mentioning our CFX_FuguCrypt tag, which uses a > URL-friendly variant of the fast and popular Blowfish algorithm (no known > weaknesses to my knowledge), I got private responses from many of you > expressing your interest in the tag. > > You can now demo the tag at: > > http://www.humankindsystems.com/FuguCrypt.cfm > > As you'll see, its encrypted strings will contain only characters a-z, > A-Z, 0-9, periods and hyphens. Totally URL-safe, and more pleasing to the > eye than a bunch of $#(!#@^ characters that make your URLs look like a > Tarantino script. Do you also have a version that is NOT url safe and can do a normal Blowfish encryption? Does your CFX work on all *nix platforms supported by CF? Jochem ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Dynamic Fieldnames & database update
Why exactly are you appending the counter variable to all of your form fields? I'm not sure I quite understand what you're trying to do... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 6:44 PM To: CF-Talk Subject: Dynamic Fieldnames & database update I am working on a dynamic form that allows me to update multiple records at once. We use the primary key from the table as a hidden field to identify the record, and append a unique number to all fields from each record via a counter. For example, the form would look something like this < input key#counter#> < input fieldname#counter#> < input fieldname#counter#> Problem is, when we go to update the database, how do we specify the formfields? I'd assumed that we would need to loop over our counter again, but I don't know how to make the dynamic fieldnames in the update. How do I get coldfusion to recognize that I want #form.fieldname1# not "form.fieldname1" and not "value of fieldname1" the first time I loop over something like UPDATE interview SET ivr_key = '#form.fieldname##counter#' Any help would be appreciated! Here's the form so far: SELECT * FROM interview INNER JOIN interviewer on interview.ivr_key = interviewer.ivr_key WHERE interview.ivr_key = #cookie.interviewerid# AND sch_name = '#cookie.schoolsession#' SELECT * FROM Interviewer Scheduled Interviews for #getinterviewdata.ivr_firstname# #getinterviewdata.ivr_lastname# Interviewer Start Time End Time Location selected> #getivrs.ivr_FirstName# #getivrs.ivr_LastName# #TimeFormat(getinterviewdata.int_StartTime, 'hh:mm tt')# #TimeFormat(getinterviewdata.int_EndTime, 'hh:mm tt')# #getinterviewdata.loc_Name# Thanks! Erica Erica Vitina Web Developer Abbott Laboratories [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: creating excel file in the REQUESTED format
Many thanks for your offer. I would love to see your tag Seamus At 02:10 am 30/08/01 , you wrote: >I've done this with a JAVA custom tag and it REALLY sped things up! I was >writing 25,000 records in a reasonable amount of time! My tag takes a query >(any query) and outputs it to an excel CSV file. I've never put it up to >the tag gallery, but I've posted the source code on this list before. If >anyone wants me to send it to them, let me know! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: crystal reports
8.0 on our server. I tried to upgrade to 8.5 and it gave me error installing so I left it at 8.0 for now. Use 8.5 on work stations for some web report design work and all our VBasic stuff and have not a problem (YET!!!) - Original Message - From: "Tammy Hong" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 3:16 PM Subject: RE: crystal reports > David, > > What version of Crystal Reports are you running? > > T > > -Original Message- > From: David Green [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 4:44 PM > To: CF-Talk > Subject: Re: crystal reports > > > I use crystal reports for a web site and it works fine having some new > problems dealing with cftree & 5.0 on the site but thats another post. I > do not use the tag. I have a page that calls out the activex or java > browser depending on browser type. This gave us more control over report > viewer. I have one report page that all our reports are passed to. If > you need the CF page let me know and I will send it. > > Here is the activex code we use have similar stuff for java viewer. We > just set the CF variables then call out our report page. > > Good luck > David > > > CLASSID = "CLSID:C4847596-972C-11D0-9567-00A0C9273C2A" > WIDTH=#session.cry_width# > HEIGHT=#session.cry_height# > > CODEBASE="/viewer/activeXViewer/activexviewer.cab#Version=8,0,2,2"> > > > > #iif(session.cry_tree is > "True",1,0)#> > > > > > > > > > > > > > > > > > > Sub Page_Initialize > Dim webBroker > Set webBroker = CreateObject("WebReportBroker.WebReportBroker") > if ScriptEngineMajorVersion < 2 then >window.alert "IE 3.02 users on NT4 need to get the latest version of > VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and > latest version of VBScript, or install IE 4.01 SP1. These files are > available at Microsofts web site." > >CRViewer.ReportName = "#Report_Location# " > else >Dim webSource >Set webSource = CreateObject("WebReportSource.WebReportSource") >webSource.ReportSource = webBroker > > >websource.url = > "http://www.gbtechnologies.com/pacbell/profile_5ess/#session.dsour > ce# /#session.cry_rpt# " >webSource.AddParameter "prompt0","#client.office# " > >webSource.AddParameter "prompt1","#client.dtswitch# " > >webSource.AddParameter "prompt2","#client.dtlmos# " > >websource.addparameter "prompt3","#client.dtfoms# " >webSource.AddParameter > "prompt4","#session.cry_items# " > webSource.AddParameter > "sf","#replace(session.cry_query,'"',"'","ALL")# " >webSource.PromptOnRefresh = false >CRViewer.ReportSource = webSource > end if >CRViewer.ViewReport > End Sub > > > - Original Message - > From: "Tom Davison" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 29, 2001 1:38 PM > Subject: crystal reports > > > > Ok, I went through all the old emails regarding crystal reports and there > didn't seem to be many answers to the questions I saw. Is any body running > Crystal Reports with Cold Fusion 5 and if so is it working? I am in need of > a web based reporting app and I'm wondering if this is the way to go with > the cfreport or if there is something better out there. > > > > Thanks in advance, > > > > Tom > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Dynamic Fieldnames & database update
I am working on a dynamic form that allows me to update multiple records at once. We use the primary key from the table as a hidden field to identify the record, and append a unique number to all fields from each record via a counter. For example, the form would look something like this < input key#counter#> < input fieldname#counter#> < input fieldname#counter#> Problem is, when we go to update the database, how do we specify the formfields? I'd assumed that we would need to loop over our counter again, but I don't know how to make the dynamic fieldnames in the update. How do I get coldfusion to recognize that I want #form.fieldname1# not "form.fieldname1" and not "value of fieldname1" the first time I loop over something like UPDATE interview SET ivr_key = '#form.fieldname##counter#' Any help would be appreciated! Here's the form so far: SELECT * FROM interview INNER JOIN interviewer on interview.ivr_key = interviewer.ivr_key WHERE interview.ivr_key = #cookie.interviewerid# AND sch_name = '#cookie.schoolsession#' SELECT * FROM Interviewer Scheduled Interviews for #getinterviewdata.ivr_firstname# #getinterviewdata.ivr_lastname# Interviewer Start Time End Time Location selected> #getivrs.ivr_FirstName# #getivrs.ivr_LastName# #TimeFormat(getinterviewdata.int_StartTime, 'hh:mm tt')# #TimeFormat(getinterviewdata.int_EndTime, 'hh:mm tt')# #getinterviewdata.loc_Name# Thanks! Erica Erica Vitina Web Developer Abbott Laboratories [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Encrypt and Decrypt - CFX_FuguCrypt demo is up...
Yesterday after mentioning our CFX_FuguCrypt tag, which uses a URL-friendly variant of the fast and popular Blowfish algorithm (no known weaknesses to my knowledge), I got private responses from many of you expressing your interest in the tag. You can now demo the tag at: http://www.humankindsystems.com/FuguCrypt.cfm As you'll see, its encrypted strings will contain only characters a-z, A-Z, 0-9, periods and hyphens. Totally URL-safe, and more pleasing to the eye than a bunch of $#(!#@^ characters that make your URLs look like a Tarantino script. On that page is an email address to which you can give feedback on whether or not you think we should package this up as a commercially-available CFX tag. All feedback is greatly appreciated. Regards, Ron Ron Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] > -Original Message- > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 5:58 AM > To: CF-Talk > Subject: RE: Encrypt and Decrypt function > > > Chris > > I think the reason you are getting problems may be because some of the > chracters generated by the Encrypt function may be ascii > characters which > are not URL safe and may need URL encoding > there is another thread somewhere which discussses this. Also > be warned the > functions Craig told you about, which i believe do not suffer > from the same > problem are actually undocumented and unofficial functions. Bear this in > mind when you use them as they are NOT guaranteed to be > supported in future > versions/releases/service packs etc. > > HTH > > Kola Oyedeji > Web developer > Macromedia Certified Advanced ColdFusion 5 Developer > http://www.Alexandermark.com > (+44)020-8429-7300 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
Thanx, I've taken that into account. but SP's still rule! :P >From: "Dave Feltenberger" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: shopping cart / online store >Date: Wed, 29 Aug 2001 17:43:31 -0400 > > >The problem with using stored procedures is that if you decide to switch >databases, you have to re-write all of them because almost all database >vendors use different stored procedure code and structure. By writing the >queries in the program itself (included as a query file or in the actual >file, whichever), you're not quite as locked into the database - as long as >you're using a relational database that supports SQL standards and you >write >standard SQL, you should be ok to plug and play databases as you please - >stored procs screw that all up. > >Another problem with putting too much business logic in stored procedures >is >that you put too much strain on the database if the site is hit hard - I >worked on a site that gets upwards of a million hits a day (www.casio.com) >and using stored procedures to do too much business logic would have bogged >down the database servers far too much to make it worthwhile. Instead, we >load balanced it all onto several really fast ColdFusion servers and they >do >the business logic. > > >-Original Message- >From: Fuon See Tu [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 29, 2001 5:29 PM >To: CF-Talk >Subject: RE: shopping cart / online store > > >Coding wise, you better use a real good methodology (gotta do that at all >times anyways :P ). Net(fo'got the name) uses fusebox as said on their >site. Database wise, you better depend a lot on stored procedures and >triggers :) makes things a lot easier and faster. I started working with >ASP last week, and passing data back and forth from the DB is a nightmare >since I am so used to coldfusion's so very easy query thingamajig. But the >ASP project I was updating really relied on stored procedures, and updating >it was simple! Although passing variables and such to the stored procedure >was still more of a headache than using CF's super dee duper stored >procedure param tags =). Stored procedures are your friend! > >Try to code your site to make the code updated easy. Try not to spaghetti >code, and all that stuff they taught u in programming basics. As far as >functionality is concerned, think about how cool you want this application >to be, then consider if it's worth the time and money. Then think think >about how you want the clients to set up a store, and lay out things >logically. > > > > > > > > > >From: "Megan Cytron" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: RE: shopping cart / online store > >Date: Wed, 29 Aug 2001 16:57:17 -0400 > > > > > Hello > > > Does anybody know of a good resource for planning, > > > developing, and building > > > an online store front with ColdFusion? > > > Including search capabilities, credit card transactions, etc. > > > > > > >Web Monkey has a pretty basic CF shopping cart tutorial that > >could give you an idea of how to implement simple shopping cart > >functions: > > > >http://hotwired.lycos.com/webmonkey/99/49/index4a.html > > > >You can also find a lot of information on different CF shopping > >cart issues in the CF forums > >(http://forums.allaire.com/coldfusion/) and this list's archives. > > > >I think the first step would be to decide between client > >variables, session variables and database storage (or some > >combination of the three). > > > > > >Megan > >[EMAIL PROTECTED] > > > >Alpha 60 Design Shop > >http://www.alpha60.com > >phone: 202-745-6393 > >fax: 202-745-6394 > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: crystal reports
Sorry didn't see earlier post. T -Original Message- From: David Green [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:44 PM To: CF-Talk Subject: Re: crystal reports I use crystal reports for a web site and it works fine having some new problems dealing with cftree & 5.0 on the site but thats another post. I do not use the tag. I have a page that calls out the activex or java browser depending on browser type. This gave us more control over report viewer. I have one report page that all our reports are passed to. If you need the CF page let me know and I will send it. Here is the activex code we use have similar stuff for java viewer. We just set the CF variables then call out our report page. Good luck David #session.cry_width# HEIGHT=#session.cry_height# CODEBASE="/viewer/activeXViewer/activexviewer.cab#Version=8,0,2,2"> #iif(session.cry_tree is "True",1,0)#> Sub Page_Initialize Dim webBroker Set webBroker = CreateObject("WebReportBroker.WebReportBroker") if ScriptEngineMajorVersion < 2 then window.alert "IE 3.02 users on NT4 need to get the latest version of VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and latest version of VBScript, or install IE 4.01 SP1. These files are available at Microsofts web site." CRViewer.ReportName = "#Report_Location# " else Dim webSource Set webSource = CreateObject("WebReportSource.WebReportSource") webSource.ReportSource = webBroker websource.url = "http://www.gbtechnologies.com/pacbell/profile_5ess/#session.dsour ce# /#session.cry_rpt# " webSource.AddParameter "prompt0","#client.office# " webSource.AddParameter "prompt1","#client.dtswitch# " webSource.AddParameter "prompt2","#client.dtlmos# " websource.addparameter "prompt3","#client.dtfoms# " webSource.AddParameter "prompt4","#session.cry_items# " webSource.AddParameter "sf","#replace(session.cry_query,'"',"'","ALL")# " webSource.PromptOnRefresh = false CRViewer.ReportSource = webSource end if CRViewer.ViewReport End Sub - Original Message - From: "Tom Davison" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 1:38 PM Subject: crystal reports > Ok, I went through all the old emails regarding crystal reports and there didn't seem to be many answers to the questions I saw. Is any body running Crystal Reports with Cold Fusion 5 and if so is it working? I am in need of a web based reporting app and I'm wondering if this is the way to go with the cfreport or if there is something better out there. > > Thanks in advance, > > Tom > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: crystal reports
David, What version of Crystal Reports are you running? T -Original Message- From: David Green [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:44 PM To: CF-Talk Subject: Re: crystal reports I use crystal reports for a web site and it works fine having some new problems dealing with cftree & 5.0 on the site but thats another post. I do not use the tag. I have a page that calls out the activex or java browser depending on browser type. This gave us more control over report viewer. I have one report page that all our reports are passed to. If you need the CF page let me know and I will send it. Here is the activex code we use have similar stuff for java viewer. We just set the CF variables then call out our report page. Good luck David #session.cry_width# HEIGHT=#session.cry_height# CODEBASE="/viewer/activeXViewer/activexviewer.cab#Version=8,0,2,2"> #iif(session.cry_tree is "True",1,0)#> Sub Page_Initialize Dim webBroker Set webBroker = CreateObject("WebReportBroker.WebReportBroker") if ScriptEngineMajorVersion < 2 then window.alert "IE 3.02 users on NT4 need to get the latest version of VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and latest version of VBScript, or install IE 4.01 SP1. These files are available at Microsofts web site." CRViewer.ReportName = "#Report_Location# " else Dim webSource Set webSource = CreateObject("WebReportSource.WebReportSource") webSource.ReportSource = webBroker websource.url = "http://www.gbtechnologies.com/pacbell/profile_5ess/#session.dsour ce# /#session.cry_rpt# " webSource.AddParameter "prompt0","#client.office# " webSource.AddParameter "prompt1","#client.dtswitch# " webSource.AddParameter "prompt2","#client.dtlmos# " websource.addparameter "prompt3","#client.dtfoms# " webSource.AddParameter "prompt4","#session.cry_items# " webSource.AddParameter "sf","#replace(session.cry_query,'"',"'","ALL")# " webSource.PromptOnRefresh = false CRViewer.ReportSource = webSource end if CRViewer.ViewReport End Sub - Original Message - From: "Tom Davison" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 1:38 PM Subject: crystal reports > Ok, I went through all the old emails regarding crystal reports and there didn't seem to be many answers to the questions I saw. Is any body running Crystal Reports with Cold Fusion 5 and if so is it working? I am in need of a web based reporting app and I'm wondering if this is the way to go with the cfreport or if there is something better out there. > > Thanks in advance, > > Tom > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
I went through the process fine with no errors... Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:00 PM To: CF-Talk Subject: RE: shopping cart / online store FYI, I was check it out and got a CFUSION error while posting to secure.dcprom.com... -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:53 PM To: CF-Talk Subject: RE: shopping cart / online store Just as a plug, we're using NetReady right now on www.dessy.com for their lookbook product. It integrated with their site with about 3 hours of work, start-to-finish. Very slick... > -Original Message- > From: Bryan Love [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 10:53 AM > To: CF-Talk > Subject: RE: shopping cart / online store > > > NetReady. It's pretty new, but it's cheap and it blows the > competition away > > Here's a feature list: > > Administration > > Expandable shipping model based on the total weight of an order > *NEW* InterShipper integration allows you to query for real > time shipping > prices and record them to your own database with the push of a button > Send bulk email to specific security roles, customers, or > anyone who has > ordered specific products > Organization of products and product lines into user-defined > categories > *NEW* Create downloadable products from files with the click > of a button > Inventory maintainance by quantity or by expiration date > Display options to allow customers to see available inventory on a > per-product basis > Turn individual products on or off > Create auctions out of existing products > Turn an auction on or off independantly of the product it represents > Specify any number of options and virtually unlimited choices for each > option on a per-product basis > Rule editing to allow store-wide product modifications with only a few > keystrokes > Add, delete, and modify users to fit your business > Create your own security roles or use the default roles to > limit users' > access to the administration tools > Security log keeps track of user logins and logouts > Ban specified IPs or allow only specified IPs > View, modify, and delete orders > Archive capability hides old orders without deleting them > Integrated banner system turns banners on or off in one mouse click > Specify expiration date, max mouse clicks, or max displays > for individual > banners > Number of clicks or displays for any given banner is always > accessible and > up to date > Bug form allows bugs to be input at any time > Bug tracker allows bugs to be sorted, commented on, deleted, > opened, closed, > and put on hold to aid in development > Client-side error checking (JavaScript) prevents invalid form input > Every product has three generic flags to be used for whatever > you wish (i.e. > Flag1 could be for items of the week, etc...) > Category-level discounts will reduce the price of any product in the > category by a fixed amount or a percentage > Discount codes can be created and given out to individual > users or groups of > users > Set maximum number of uses for a discount code to be one, infinite, or > anything in between > > Store Front > --- > Customer login ability: > View past orders > Create, use, and delete shopping lists > Store a default billing address and unlimited shipping addresses > Quick checkout eliminates time-consuming data entry > Log file tracks logins, failed logins, and logouts > Default store front with home, contact, and privacy pages > Integrated dynamic random banner display with full logging > Default catalog allows drill-down through categories with full product > listings > Auction listings display all items available for auction with links to > purchase the item outright (if applicable) > The auction engine will automatically bid for a user until a > maximum amount > (user-specified) is reached > Product and category click logs track every click through the catalog > Search function searches product names and descriptions > Single style sheet gives developer control over fonts and colors > Shopping basket uses database for unlimited size and > scalability as well as > allowing customers to retain items across visits > Full checkout process is seperate to allow a secure connection > Checkout collects billing info, shipping info, credit card, > and shipping > method information with full server-side error checking and > validation > *NEW* Integration with InterShipper allows the user to choose > from real-time > shipping options > *NEW* CyberCash integration allows real-time credit card processing > *NEW* Your customer can download purchased files at any time > depending on > status of an order and t
RE: coldfusion and 31-bit numbers
Hi, Do you have any UDF's that you wrote that you can send me? -Brent -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 8:54 PM To: CF-Talk Subject: Re: coldfusion and 31-bit numbers Sorry to say but that's old news. Basically, CF only allows a 32 bit number for INTEGERS. This article I wrote about a year back gives a full rundown as well as all the functions that are affected. http://www.fusionauthority.com/alert/index.cfm?alertid=30#tech1 You can get around it by writing your own UDF to do the math for you rather than using the 'basic' CF functions. > Hi, > > You know, I just found a really huge ColdFusion limitation. It can only > work with numbers smaller than 2147483647, which is the same as 7FFF in > hex, 177 in OCT, and 111 in binary. It > seems that ColdFusion only allocated 31 bits of memory to each number (I > counted the 1's in binary). Because of this limitation, you can't use the > MOD operator, or the FormatBaseN and InputBaseN functions, of ColdFusion > using numbers bigger than 31 bits. It seems odd how ColdFusion would limit > a programmer like this. Are there any ways to get around this? > > -Brent > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: subtracting quantity
you would need to provide the SELECT query that runs your drop down to get an answer. Meanwhile you can speed this up dramatically by doing this instead of the code you have below: UPDATE tblApplications set InOut = 1 WHERE appID IN (#form.appID#) Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:38 AM To: CF-Talk Subject: subtracting quantity i have a form for users to check out an application. most of my applications are a quantity of 1, so once it is checked out, it will not show up in the drop down list of apps to check out until it is checked back in. (i automatically set the checkout field to be yes). but for the few apps that have a quantity of greater than one, how can i make it so that it still shows up in the list until every single one has been checked out? right now my code just does this for every app checked out regardless of the quantity UPDATE tblApplications set InOut = 1 WHERE appID = (#a#) * 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 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: Netscape 6.1 Problems
how very interesting. i didn't even really think about anything "launching" the javascript. after one hit the submit button, one was taken to the action page which contained right off the bat the custom form validation tag. if there was a problem with one of the relevant form fields, that chunk of javascript was simply run. just for kicks, i amended the below code to be a little more formal: and NN 6.1 now is having no problems with it and is doing exactly what it should be doing. apparently, the newer browser versions are more particular about structure or something. in any event, judith (judy?), your reply got me thinking down a different path, so thank you very much! ~kamie Judith Campbell wrote: > What event is launching your javascript. It's possiby that Netscape 6 is > handling the onload event diffrently , if that's what you're using. > > At 04:35 PM 8/29/01 -0400, you wrote: > >okay, i've run out of ideas and am hoping someone on this list can help. > > > >after hitting the submit button, my code calls upon -- first thing in > >the form's action page -- an in-house custom tag that does some form > >validation. if anything in the form is not correct, a javascript pop-up > >lets the user know what isn't right. this tag, which we've been using > >for years, has worked beautifully in all browsers. for some reason, NN > >6.1 is not liking it. instead of popping up the message and kicking the > >user back to the form, NN 6.1 duplicates everything in the javascript, > >which means popping up the message twice and kicking the user back two > >pages to the shopping cart (which means they have to fill out their > >contact/payment info all over again -- not good!). why is this > >happening??? has anyone else encountered similar behavior with NN 6.1? > > > >after doing the form validations, here is the code in the custom tag: > > > > > > > > > > > > > > > > > > > > > >any thoughts would be much appreciated. thanks! > > > >~kamie -- Kamie B. Curfman Matrix Group International, Inc. 801 N. Fairfax Street, Suite 205 Alexandria, VA 22314 Phone: (703) 838-9777 x3014 Fax: (703) 838-9799 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: TwoSelectsRelated weirdness
Clear out her cache and try again. Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:43 AM To: CF-Talk Subject: TwoSelectsRelated weirdness Hey all, I use CF_TwoSelectsRelated quite a bit, but this is the first time I've encountered this particular problem. One of my site users can choose an item from the first list, but no matter what she chooses, nothing displays in the second list. No one else has reported this problem (and believe me, they WOULD have--this is an intranet application, and they report everything else). She is using IE 5.5, and has javascript enabled. Can anyone give me some other tips on this one? Thanks! Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: URL varliables
Oops error on that URL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 5:55 PM To: CF-Talk Subject: URL varliables http://www.forta.com/cf/tips/index.cfm?age=H Oops. CC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
Dunno right off... I think it's open source and I know there are discounts for multiple liscenses so it must be a per-liscense system. Go here for answers to questions: http://www.aloha-webdesign.com Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 12:56 PM To: CF-Talk Subject: RE: shopping cart / online store I like the cart ... is the open source licence good for unlimited implementations? servers? sites? Eric Dawson From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: shopping cart / online store Date: Wed, 29 Aug 2001 15:43:23 -0400 If your user doesn't already have a CyberCash account, he won't be able to get one now, so another vendor's requirements will have to be worked into it. JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:53 PM To: CF-Talk Subject: RE: shopping cart / online store NetReady. It's pretty new, but it's cheap and it blows the competition away Here's a feature list: Administration Expandable shipping model based on the total weight of an order *NEW* InterShipper integration allows you to query for real time shipping prices and record them to your own database with the push of a button Send bulk email to specific security roles, customers, or anyone who has ordered specific products Organization of products and product lines into user-defined categories *NEW* Create downloadable products from files with the click of a button Inventory maintainance by quantity or by expiration date Display options to allow customers to see available inventory on a per-product basis Turn individual products on or off Create auctions out of existing products Turn an auction on or off independantly of the product it represents Specify any number of options and virtually unlimited choices for each option on a per-product basis Rule editing to allow store-wide product modifications with only a few keystrokes Add, delete, and modify users to fit your business Create your own security roles or use the default roles to limit users' access to the administration tools Security log keeps track of user logins and logouts Ban specified IPs or allow only specified IPs View, modify, and delete orders Archive capability hides old orders without deleting them Integrated banner system turns banners on or off in one mouse click Specify expiration date, max mouse clicks, or max displays for individual banners Number of clicks or displays for any given banner is always accessible and up to date Bug form allows bugs to be input at any time Bug tracker allows bugs to be sorted, commented on, deleted, opened, closed, and put on hold to aid in development Client-side error checking (JavaScript) prevents invalid form input Every product has three generic flags to be used for whatever you wish (i.e. Flag1 could be for items of the week, etc...) Category-level discounts will reduce the price of any product in the category by a fixed amount or a percentage Discount codes can be created and given out to individual users or groups of users Set maximum number of uses for a discount code to be one, infinite, or anything in between Store Front --- Customer login ability: View past orders Create, use, and delete shopping lists Store a default billing address and unlimited shipping addresses Quick checkout eliminates time-consuming data entry Log file tracks logins, failed logins, and logouts Default store front with home, contact, and privacy pages Integrated dynamic random banner display with full logging Default catalog allows drill-down through categories with full product listings Auction listings display all items available for auction with links to purchase the item outright (if applicable) The auction engine will automatically bid for a user until a maximum amount (user-specified) is reached Product and category click logs track every click through the catalog Search function searches product names and descriptions Single style sheet gives developer control over fonts and colors Shopping basket uses database for unlimited size and scalability as well as allowing customers to retain items across visits Full checkout process is seperate to allow a secure connection Checkout collects billing info, shipping info, credit card, and shipping method information with full server-side error checking and validation *NEW* Integration with InterShipper allows the user to choose from real-time shipping options *NEW* CyberCash integration allows real-time credit card processing *NEW* Your cus
URL varliables
http://www.forta.com/cf/tips/index.cfm?age=H Oops. CC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Printing Question
Is there any way to remove the standard headers and footers from printing off an html document? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: crystal reports
I use crystal reports for a web site and it works fine having some new problems dealing with cftree & 5.0 on the site but thats another post. I do not use the tag. I have a page that calls out the activex or java browser depending on browser type. This gave us more control over report viewer. I have one report page that all our reports are passed to. If you need the CF page let me know and I will send it. Here is the activex code we use have similar stuff for java viewer. We just set the CF variables then call out our report page. Good luck David #session.cry_width# HEIGHT=#session.cry_height# CODEBASE="/viewer/activeXViewer/activexviewer.cab#Version=8,0,2,2"> #iif(session.cry_tree is "True",1,0)#> Sub Page_Initialize Dim webBroker Set webBroker = CreateObject("WebReportBroker.WebReportBroker") if ScriptEngineMajorVersion < 2 then window.alert "IE 3.02 users on NT4 need to get the latest version of VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and latest version of VBScript, or install IE 4.01 SP1. These files are available at Microsofts web site." CRViewer.ReportName = "#Report_Location# " else Dim webSource Set webSource = CreateObject("WebReportSource.WebReportSource") webSource.ReportSource = webBroker websource.url = "http://www.gbtechnologies.com/pacbell/profile_5ess/#session.dsour ce# /#session.cry_rpt# " webSource.AddParameter "prompt0","#client.office# " webSource.AddParameter "prompt1","#client.dtswitch# " webSource.AddParameter "prompt2","#client.dtlmos# " websource.addparameter "prompt3","#client.dtfoms# " webSource.AddParameter "prompt4","#session.cry_items# " webSource.AddParameter "sf","#replace(session.cry_query,'"',"'","ALL")# " webSource.PromptOnRefresh = false CRViewer.ReportSource = webSource end if CRViewer.ViewReport End Sub - Original Message - From: "Tom Davison" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 1:38 PM Subject: crystal reports > Ok, I went through all the old emails regarding crystal reports and there didn't seem to be many answers to the questions I saw. Is any body running Crystal Reports with Cold Fusion 5 and if so is it working? I am in need of a web based reporting app and I'm wondering if this is the way to go with the cfreport or if there is something better out there. > > Thanks in advance, > > Tom > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
The problem with using stored procedures is that if you decide to switch databases, you have to re-write all of them because almost all database vendors use different stored procedure code and structure. By writing the queries in the program itself (included as a query file or in the actual file, whichever), you're not quite as locked into the database - as long as you're using a relational database that supports SQL standards and you write standard SQL, you should be ok to plug and play databases as you please - stored procs screw that all up. Another problem with putting too much business logic in stored procedures is that you put too much strain on the database if the site is hit hard - I worked on a site that gets upwards of a million hits a day (www.casio.com) and using stored procedures to do too much business logic would have bogged down the database servers far too much to make it worthwhile. Instead, we load balanced it all onto several really fast ColdFusion servers and they do the business logic. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 5:29 PM To: CF-Talk Subject: RE: shopping cart / online store Coding wise, you better use a real good methodology (gotta do that at all times anyways :P ). Net(fo'got the name) uses fusebox as said on their site. Database wise, you better depend a lot on stored procedures and triggers :) makes things a lot easier and faster. I started working with ASP last week, and passing data back and forth from the DB is a nightmare since I am so used to coldfusion's so very easy query thingamajig. But the ASP project I was updating really relied on stored procedures, and updating it was simple! Although passing variables and such to the stored procedure was still more of a headache than using CF's super dee duper stored procedure param tags =). Stored procedures are your friend! Try to code your site to make the code updated easy. Try not to spaghetti code, and all that stuff they taught u in programming basics. As far as functionality is concerned, think about how cool you want this application to be, then consider if it's worth the time and money. Then think think about how you want the clients to set up a store, and lay out things logically. >From: "Megan Cytron" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: shopping cart / online store >Date: Wed, 29 Aug 2001 16:57:17 -0400 > > > Hello > > Does anybody know of a good resource for planning, > > developing, and building > > an online store front with ColdFusion? > > Including search capabilities, credit card transactions, etc. > > > >Web Monkey has a pretty basic CF shopping cart tutorial that >could give you an idea of how to implement simple shopping cart >functions: > >http://hotwired.lycos.com/webmonkey/99/49/index4a.html > >You can also find a lot of information on different CF shopping >cart issues in the CF forums >(http://forums.allaire.com/coldfusion/) and this list's archives. > >I think the first step would be to decide between client >variables, session variables and database storage (or some >combination of the three). > > >Megan >[EMAIL PROTECTED] > >Alpha 60 Design Shop >http://www.alpha60.com >phone: 202-745-6393 >fax: 202-745-6394 > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Activeedit 2.5 - Subthread Ektron
I'll try to throw it up on my website - I'll post to the list when I do. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:47 PM To: CF-Talk Subject: RE: Activeedit 2.5 - Subthread Ektron I would be interested in seeing the code you have written for this. I have started making an editor based on IE's abilities. Do you know if there is a way to insert any start and end tag (similar to snippets in studio)? For instance, making an . >>> Billy Cravens <[EMAIL PROTECTED]> 08/29/01 02:11PM >>> As far as the ActiveX issue goes, very true. If your needs are relatively simple, you can easily roll your own ActiveEdit or eWebEdit type product - use the DHTMLEdit control built into IE4+. It has a couple of quirks that are easily coded around. I'm using it on my personal website. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:32 AM To: CF-Talk Subject: RE: Activeedit 2.5 - Subthread Ektron Neither product from ektron works with Netscape 6.1. (Just Verified Again) We use both empower 3.0 and ewebeditpro 2.0 and neither product is usable in Netscape 6.1. Be very wary of ektron solutions as they have not been tested in what I would call professional environments. We use the products on a clustered CF50 solution and as we have had installation and general support issues, we find the product has never been tested under these conditions. We have been pioneering this and making changes as we go, but the lack of testing on their part has pushed us months behind schedule. I'm sure if you have a small site, on a single server without redundancy, and all your webserver pathing is done to the local machine, then yes this product is probably a decent solution for you. Oh it should also be noted that while the product only works on IE, it only works on intel/MS installations of IE. This should be obvious as it utilizes activeX, but not everyone seems to get that. Trey Rouse -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 10:51 AM To: CF-Talk Subject: RE: Activeedit 2.5 Ektron's eWebEdit claims Netscape compatibility. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Chuck Hergenroeder [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 9:16 AM To: CF-Talk Subject: RE: Activeedit 2.5 I don't know this for a fact, but I thought the newest release worked on Netscape. I could be wrong though. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 10:08 AM To: CF-Talk Subject: RE: Activeedit 2.5 Also one thing that one has to consider with this application is that it only works under IE, I am not sure about Netscape 6.x so maybe someone would like to confirm this but it will not work under Netscape 4.x... -Original Message- From: John Patterson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 21 August 2001 12:01 AM To: CF-Talk Subject: Re: Activeedit 2.5 Hello, I use ActiveEdit in an internet application of mine. I use it as a message board for those utilizing the application. The administrator can post application updates and system messages and client information rather than using emails. It provides a nice "value-added" feature to my application. John - Original Message - From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 9:51 AM Subject: Activeedit 2.5 > I have been reading about this new product. Any feedback would be > appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
Coding wise, you better use a real good methodology (gotta do that at all times anyways :P ). Net(fo'got the name) uses fusebox as said on their site. Database wise, you better depend a lot on stored procedures and triggers :) makes things a lot easier and faster. I started working with ASP last week, and passing data back and forth from the DB is a nightmare since I am so used to coldfusion's so very easy query thingamajig. But the ASP project I was updating really relied on stored procedures, and updating it was simple! Although passing variables and such to the stored procedure was still more of a headache than using CF's super dee duper stored procedure param tags =). Stored procedures are your friend! Try to code your site to make the code updated easy. Try not to spaghetti code, and all that stuff they taught u in programming basics. As far as functionality is concerned, think about how cool you want this application to be, then consider if it's worth the time and money. Then think think about how you want the clients to set up a store, and lay out things logically. >From: "Megan Cytron" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: shopping cart / online store >Date: Wed, 29 Aug 2001 16:57:17 -0400 > > > Hello > > Does anybody know of a good resource for planning, > > developing, and building > > an online store front with ColdFusion? > > Including search capabilities, credit card transactions, etc. > > > >Web Monkey has a pretty basic CF shopping cart tutorial that >could give you an idea of how to implement simple shopping cart >functions: > >http://hotwired.lycos.com/webmonkey/99/49/index4a.html > >You can also find a lot of information on different CF shopping >cart issues in the CF forums >(http://forums.allaire.com/coldfusion/) and this list's archives. > >I think the first step would be to decide between client >variables, session variables and database storage (or some >combination of the three). > > >Megan >[EMAIL PROTECTED] > >Alpha 60 Design Shop >http://www.alpha60.com >phone: 202-745-6393 >fax: 202-745-6394 > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart--switching to SSL with session variables
The downside is that if someone sees the CFID and CFTOKEN on another box (don't ask me how), they can steal the users session and have access to all information that would normally be available. We had this problem on a site I worked on and had to avoid ever passing the CFTOKEN and CFID around in the query string, even if there wasn't a good chance that someone would steal your session (you can't be too careful!). Also make sure there isn't already a "?" in the query string - ColdFusion seems to choke on multiple question marks in the query string sometimes. -Original Message- From: Megan Cytron [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 5:10 PM To: CF-Talk Subject: shopping cart--switching to SSL with session variables Does anyone foresee any problems with appending "?#session.URLToken#" to the url to which a form submits when switching from an "insecure" server to a secure server. It seems to work great in preserving the shopping cart session for this particular project, since everything is on one box (and has enabled us to avoid delving into WDDX or database storage). It essentially helps the secure server to locate the session by passing a CFID and CFTOKEN. Just wondering if there are any downsides to doing this that we may not have considered... Thanks! Megan [EMAIL PROTECTED] Alpha 60 Design Shop http://www.alpha60.com phone: 202-745-6393 fax: 202-745-6394 > -Original Message- > From: Ian Lurie [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 4:53 PM > To: CF-Talk > Subject: RE: shopping cart / online store > > > Just as a plug, we're using NetReady right now on > www.dessy.com for their > lookbook product. It integrated with their site with > about 3 hours of work, > start-to-finish. Very slick... > > > -Original Message- > > From: Bryan Love [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 29, 2001 10:53 AM > > To: CF-Talk > > Subject: RE: shopping cart / online store > > > > > > NetReady. It's pretty new, but it's cheap and it blows the > > competition away > > > > Here's a feature list: > > > > Administration > > > > Expandable shipping model based on the total weight > of an order > > *NEW* InterShipper integration allows you to query for real > > time shipping > > prices and record them to your own database with the > push of a button > > Send bulk email to specific security roles, customers, or > > anyone who has > > ordered specific products > > Organization of products and product lines into user-defined > > categories > > *NEW* Create downloadable products from files with the click > > of a button > > Inventory maintainance by quantity or by expiration date > > Display options to allow customers to see available > inventory on a > > per-product basis > > Turn individual products on or off > > Create auctions out of existing products > > Turn an auction on or off independantly of the > product it represents > > Specify any number of options and virtually > unlimited choices for each > > option on a per-product basis > > Rule editing to allow store-wide product > modifications with only a few > > keystrokes > > Add, delete, and modify users to fit your business > > Create your own security roles or use the default roles to > > limit users' > > access to the administration tools > > Security log keeps track of user logins and logouts > > Ban specified IPs or allow only specified IPs > > View, modify, and delete orders > > Archive capability hides old orders without deleting them > > Integrated banner system turns banners on or off in > one mouse click > > Specify expiration date, max mouse clicks, or max displays > > for individual > > banners > > Number of clicks or displays for any given banner is always > > accessible and > > up to date > > Bug form allows bugs to be input at any time > > Bug tracker allows bugs to be sorted, commented on, deleted, > > opened, closed, > > and put on hold to aid in development > > Client-side error checking (JavaScript) prevents > invalid form input > > Every product has three generic flags to be used for whatever > > you wish (i.e. > > Flag1 could be for items of the week, etc...) > > Category-level discounts will reduce the price of > any product in the > > category by a fixed amount or a percentage > > Discount codes can be created and given out to individual > > users or groups of > > users > > Set maximum number of uses for a discount code to be > one, infinite, or > > anything in between > > > > Store Front > > --- > > Customer login ability: > > View past orders > > Create, use, and delete shopping lists > > Store a default billing address and unlimited > shipping addresses > > Quick checkout eliminates time-consuming data entry > > Log file tracks logins, failed logins, and logouts > > Default store front with home, contact, and privacy pages > > Integrated dynamic random banner display with full logging > > Default
Re: Upfrade CF4.5 Pro to 5 Ent
Check your log files. We had one CF log file that was about 200MB and the installation tried to read it into memory. It used up all the RAM and hung. After clearing the log files, (I cleared em all to be safe.) the installation went fine. All apps worked without modification. Obviously be sure to select the "migration" option when you begin the install to import your existing ODBC datasources, Verity collections, custom tags and all other custom settings. Chris > We're going to be upgrading a server from CF 4.5 Profesional to CF5 Enterprise. >Does anyone have a list of things I should look out > for? The server is as follows: > > WIN2K > 1GB RAM/SCSI HDs > O'Reilly WebSite Pro 2.x > > I just want to avoid breaking any applications that are working now :-) > > Thanks, > > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. > www.CoolFusion.com > 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail Server > Join the DevCon community at www.coolfusion.com/devcon > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: crystal reports
Just finished a project where we used Crystal Report files. However, the CR files were called through another application (called Cizer), and converted to PDF. Our testing with CFREPORT wasn't very promising (it renders the CR file as an HTML page, and you loose some formatting, headers, etc.). We weren't able to get Crystal Enterprise up and running to deliver the reports through the web. Good Luck though. Shawn Grover -Original Message- From: Tom Davison [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:39 PM To: CF-Talk Subject: crystal reports Ok, I went through all the old emails regarding crystal reports and there didn't seem to be many answers to the questions I saw. Is any body running Crystal Reports with Cold Fusion 5 and if so is it working? I am in need of a web based reporting app and I'm wondering if this is the way to go with the cfreport or if there is something better out there. Thanks in advance, Tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
shopping cart--switching to SSL with session variables
Does anyone foresee any problems with appending "?#session.URLToken#" to the url to which a form submits when switching from an "insecure" server to a secure server. It seems to work great in preserving the shopping cart session for this particular project, since everything is on one box (and has enabled us to avoid delving into WDDX or database storage). It essentially helps the secure server to locate the session by passing a CFID and CFTOKEN. Just wondering if there are any downsides to doing this that we may not have considered... Thanks! Megan [EMAIL PROTECTED] Alpha 60 Design Shop http://www.alpha60.com phone: 202-745-6393 fax: 202-745-6394 > -Original Message- > From: Ian Lurie [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 4:53 PM > To: CF-Talk > Subject: RE: shopping cart / online store > > > Just as a plug, we're using NetReady right now on > www.dessy.com for their > lookbook product. It integrated with their site with > about 3 hours of work, > start-to-finish. Very slick... > > > -Original Message- > > From: Bryan Love [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 29, 2001 10:53 AM > > To: CF-Talk > > Subject: RE: shopping cart / online store > > > > > > NetReady. It's pretty new, but it's cheap and it blows the > > competition away > > > > Here's a feature list: > > > > Administration > > > > Expandable shipping model based on the total weight > of an order > > *NEW* InterShipper integration allows you to query for real > > time shipping > > prices and record them to your own database with the > push of a button > > Send bulk email to specific security roles, customers, or > > anyone who has > > ordered specific products > > Organization of products and product lines into user-defined > > categories > > *NEW* Create downloadable products from files with the click > > of a button > > Inventory maintainance by quantity or by expiration date > > Display options to allow customers to see available > inventory on a > > per-product basis > > Turn individual products on or off > > Create auctions out of existing products > > Turn an auction on or off independantly of the > product it represents > > Specify any number of options and virtually > unlimited choices for each > > option on a per-product basis > > Rule editing to allow store-wide product > modifications with only a few > > keystrokes > > Add, delete, and modify users to fit your business > > Create your own security roles or use the default roles to > > limit users' > > access to the administration tools > > Security log keeps track of user logins and logouts > > Ban specified IPs or allow only specified IPs > > View, modify, and delete orders > > Archive capability hides old orders without deleting them > > Integrated banner system turns banners on or off in > one mouse click > > Specify expiration date, max mouse clicks, or max displays > > for individual > > banners > > Number of clicks or displays for any given banner is always > > accessible and > > up to date > > Bug form allows bugs to be input at any time > > Bug tracker allows bugs to be sorted, commented on, deleted, > > opened, closed, > > and put on hold to aid in development > > Client-side error checking (JavaScript) prevents > invalid form input > > Every product has three generic flags to be used for whatever > > you wish (i.e. > > Flag1 could be for items of the week, etc...) > > Category-level discounts will reduce the price of > any product in the > > category by a fixed amount or a percentage > > Discount codes can be created and given out to individual > > users or groups of > > users > > Set maximum number of uses for a discount code to be > one, infinite, or > > anything in between > > > > Store Front > > --- > > Customer login ability: > > View past orders > > Create, use, and delete shopping lists > > Store a default billing address and unlimited > shipping addresses > > Quick checkout eliminates time-consuming data entry > > Log file tracks logins, failed logins, and logouts > > Default store front with home, contact, and privacy pages > > Integrated dynamic random banner display with full logging > > Default catalog allows drill-down through categories > with full product > > listings > > Auction listings display all items available for > auction with links to > > purchase the item outright (if applicable) > > The auction engine will automatically bid for a user until a > > maximum amount > > (user-specified) is reached > > Product and category click logs track every click > through the catalog > > Search function searches product names and descriptions > > Single style sheet gives developer control over > fonts and colors > > Shopping basket uses database for unlimited size and > > scalability as well as > > allowing customers to retain items across visits > > Full checkout process is seperate to allow a secure > connection > > Checkout collects billing
RE: shopping cart / online store
I've always liked http://dansie.net/cart.html . It's a really simple Perl based cart that is pretty flexable. It can handle "mom and pop" type sites or really heavy e-commerce sites. Priced reasonably too. Dan Phillips CFXHosting.com -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:53 PM To: CF-Talk Subject: RE: shopping cart / online store Just as a plug, we're using NetReady right now on www.dessy.com for their lookbook product. It integrated with their site with about 3 hours of work, start-to-finish. Very slick... > -Original Message- > From: Bryan Love [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 10:53 AM > To: CF-Talk > Subject: RE: shopping cart / online store > > > NetReady. It's pretty new, but it's cheap and it blows the > competition away > > Here's a feature list: > > Administration > > Expandable shipping model based on the total weight of an order > *NEW* InterShipper integration allows you to query for real > time shipping > prices and record them to your own database with the push of a button > Send bulk email to specific security roles, customers, or > anyone who has > ordered specific products > Organization of products and product lines into user-defined > categories > *NEW* Create downloadable products from files with the click > of a button > Inventory maintainance by quantity or by expiration date > Display options to allow customers to see available inventory on a > per-product basis > Turn individual products on or off > Create auctions out of existing products > Turn an auction on or off independantly of the product it represents > Specify any number of options and virtually unlimited choices for each > option on a per-product basis > Rule editing to allow store-wide product modifications with only a few > keystrokes > Add, delete, and modify users to fit your business > Create your own security roles or use the default roles to > limit users' > access to the administration tools > Security log keeps track of user logins and logouts > Ban specified IPs or allow only specified IPs > View, modify, and delete orders > Archive capability hides old orders without deleting them > Integrated banner system turns banners on or off in one mouse click > Specify expiration date, max mouse clicks, or max displays > for individual > banners > Number of clicks or displays for any given banner is always > accessible and > up to date > Bug form allows bugs to be input at any time > Bug tracker allows bugs to be sorted, commented on, deleted, > opened, closed, > and put on hold to aid in development > Client-side error checking (JavaScript) prevents invalid form input > Every product has three generic flags to be used for whatever > you wish (i.e. > Flag1 could be for items of the week, etc...) > Category-level discounts will reduce the price of any product in the > category by a fixed amount or a percentage > Discount codes can be created and given out to individual > users or groups of > users > Set maximum number of uses for a discount code to be one, infinite, or > anything in between > > Store Front > --- > Customer login ability: > View past orders > Create, use, and delete shopping lists > Store a default billing address and unlimited shipping addresses > Quick checkout eliminates time-consuming data entry > Log file tracks logins, failed logins, and logouts > Default store front with home, contact, and privacy pages > Integrated dynamic random banner display with full logging > Default catalog allows drill-down through categories with full product > listings > Auction listings display all items available for auction with links to > purchase the item outright (if applicable) > The auction engine will automatically bid for a user until a > maximum amount > (user-specified) is reached > Product and category click logs track every click through the catalog > Search function searches product names and descriptions > Single style sheet gives developer control over fonts and colors > Shopping basket uses database for unlimited size and > scalability as well as > allowing customers to retain items across visits > Full checkout process is seperate to allow a secure connection > Checkout collects billing info, shipping info, credit card, > and shipping > method information with full server-side error checking and > validation > *NEW* Integration with InterShipper allows the user to choose > from real-time > shipping options > *NEW* CyberCash integration allows real-time credit card processing > *NEW* Your customer can download purchased files at any time > depending on > status of an order and the IP of the machine they ordered from > Product reviews can be submitted by logged-in users and will > not display > until approved by administration > Meta tags are generated for every product and category to > ensure search > engines will find you > > General >
Re: crystal reports
I'm running crystal reports 8.5 with CF5. I've had to do some wrangling to get it to work correctly. As of Crystal 8.5 they moved their web reporting tool to the Crystal Enterprise program. It's included free with CReports, but only comes with 5 concurrent licenses. When I used that with CF4.5 or CF5, the program didn't seem to want to log off the users so I would quickly run out of licenses. My solution was to use the Crystal Reports COM object. Unfortunately, I ran into the same problem because CF would never destroy the object when finished. My final solution that has been working for around 2 months now was to create a VB COM object that called the Crystal Reports COM object and had a method to explicitly destroy the Crystal Reports COM object. I actually added some functionality so that the VB COM object exports the report to a pdf and CF serves that to the browser. It works much better than either of the online viewers provided by Crystal Marlon - Original Message - From: "Tom Davison" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 3:38 PM Subject: crystal reports > Ok, I went through all the old emails regarding crystal reports and there didn't seem to be many answers to the questions I saw. Is any body running Crystal Reports with Cold Fusion 5 and if so is it working? I am in need of a web based reporting app and I'm wondering if this is the way to go with the cfreport or if there is something better out there. > > Thanks in advance, > > Tom > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
FYI, I was check it out and got a CFUSION error while posting to secure.dcprom.com... -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:53 PM To: CF-Talk Subject: RE: shopping cart / online store Just as a plug, we're using NetReady right now on www.dessy.com for their lookbook product. It integrated with their site with about 3 hours of work, start-to-finish. Very slick... > -Original Message- > From: Bryan Love [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 10:53 AM > To: CF-Talk > Subject: RE: shopping cart / online store > > > NetReady. It's pretty new, but it's cheap and it blows the > competition away > > Here's a feature list: > > Administration > > Expandable shipping model based on the total weight of an order > *NEW* InterShipper integration allows you to query for real > time shipping > prices and record them to your own database with the push of a button > Send bulk email to specific security roles, customers, or > anyone who has > ordered specific products > Organization of products and product lines into user-defined > categories > *NEW* Create downloadable products from files with the click > of a button > Inventory maintainance by quantity or by expiration date > Display options to allow customers to see available inventory on a > per-product basis > Turn individual products on or off > Create auctions out of existing products > Turn an auction on or off independantly of the product it represents > Specify any number of options and virtually unlimited choices for each > option on a per-product basis > Rule editing to allow store-wide product modifications with only a few > keystrokes > Add, delete, and modify users to fit your business > Create your own security roles or use the default roles to > limit users' > access to the administration tools > Security log keeps track of user logins and logouts > Ban specified IPs or allow only specified IPs > View, modify, and delete orders > Archive capability hides old orders without deleting them > Integrated banner system turns banners on or off in one mouse click > Specify expiration date, max mouse clicks, or max displays > for individual > banners > Number of clicks or displays for any given banner is always > accessible and > up to date > Bug form allows bugs to be input at any time > Bug tracker allows bugs to be sorted, commented on, deleted, > opened, closed, > and put on hold to aid in development > Client-side error checking (JavaScript) prevents invalid form input > Every product has three generic flags to be used for whatever > you wish (i.e. > Flag1 could be for items of the week, etc...) > Category-level discounts will reduce the price of any product in the > category by a fixed amount or a percentage > Discount codes can be created and given out to individual > users or groups of > users > Set maximum number of uses for a discount code to be one, infinite, or > anything in between > > Store Front > --- > Customer login ability: > View past orders > Create, use, and delete shopping lists > Store a default billing address and unlimited shipping addresses > Quick checkout eliminates time-consuming data entry > Log file tracks logins, failed logins, and logouts > Default store front with home, contact, and privacy pages > Integrated dynamic random banner display with full logging > Default catalog allows drill-down through categories with full product > listings > Auction listings display all items available for auction with links to > purchase the item outright (if applicable) > The auction engine will automatically bid for a user until a > maximum amount > (user-specified) is reached > Product and category click logs track every click through the catalog > Search function searches product names and descriptions > Single style sheet gives developer control over fonts and colors > Shopping basket uses database for unlimited size and > scalability as well as > allowing customers to retain items across visits > Full checkout process is seperate to allow a secure connection > Checkout collects billing info, shipping info, credit card, > and shipping > method information with full server-side error checking and > validation > *NEW* Integration with InterShipper allows the user to choose > from real-time > shipping options > *NEW* CyberCash integration allows real-time credit card processing > *NEW* Your customer can download purchased files at any time > depending on > status of an order and the IP of the machine they ordered from > Product reviews can be submitted by logged-in users and will > not display > until approved by administration > Meta tags are generated for every product and category to > ensure search > engines will find you > > General > -- > Complete fusebox architecture is widely accepted and easy to > maintain and > modify > All administrative da
RE: counting min chars in form field
In coldfusion, on the server side, do a len(formVariable) - it will return the number of characters long the string is -Original Message- From: Brian Horn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:31 PM To: CF-Talk Subject: counting min chars in form field How do you count chars in a form field. I have a zip code field that is used for a search. I want to allow them to key in 3-5 digits of a zip code. I've got max to make the 5 happen, but how do I check to make sure that they keyed at least 3? Brian Horn ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: No data in the selected time period. (Server Reports)
I think there was a hotfix for some of the server reporting. Check MM's knowledge base -Original Message- From: Benji Spencer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 3:55 PM To: CF-Talk Subject: No data in the selected time period. (Server Reports) We upgraded to CF 5 (Solaris) about a month ago and have a hard time getting the Server Reports to work. Are there any tricks we are missing? The reports always come back with "No data in the selected time period". we are using * Version 5.0 Logging Format * Enabled Performance Monitoring From all I have read, the Server Reports take almost nothing to set up, however, I have yet to have the reports generated. benji --- Benji Spencer Web Programmer Moody Bible Institute 312-329-2288 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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
Just as a plug, we're using NetReady right now on www.dessy.com for their lookbook product. It integrated with their site with about 3 hours of work, start-to-finish. Very slick... > -Original Message- > From: Bryan Love [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 10:53 AM > To: CF-Talk > Subject: RE: shopping cart / online store > > > NetReady. It's pretty new, but it's cheap and it blows the > competition away > > Here's a feature list: > > Administration > > Expandable shipping model based on the total weight of an order > *NEW* InterShipper integration allows you to query for real > time shipping > prices and record them to your own database with the push of a button > Send bulk email to specific security roles, customers, or > anyone who has > ordered specific products > Organization of products and product lines into user-defined > categories > *NEW* Create downloadable products from files with the click > of a button > Inventory maintainance by quantity or by expiration date > Display options to allow customers to see available inventory on a > per-product basis > Turn individual products on or off > Create auctions out of existing products > Turn an auction on or off independantly of the product it represents > Specify any number of options and virtually unlimited choices for each > option on a per-product basis > Rule editing to allow store-wide product modifications with only a few > keystrokes > Add, delete, and modify users to fit your business > Create your own security roles or use the default roles to > limit users' > access to the administration tools > Security log keeps track of user logins and logouts > Ban specified IPs or allow only specified IPs > View, modify, and delete orders > Archive capability hides old orders without deleting them > Integrated banner system turns banners on or off in one mouse click > Specify expiration date, max mouse clicks, or max displays > for individual > banners > Number of clicks or displays for any given banner is always > accessible and > up to date > Bug form allows bugs to be input at any time > Bug tracker allows bugs to be sorted, commented on, deleted, > opened, closed, > and put on hold to aid in development > Client-side error checking (JavaScript) prevents invalid form input > Every product has three generic flags to be used for whatever > you wish (i.e. > Flag1 could be for items of the week, etc...) > Category-level discounts will reduce the price of any product in the > category by a fixed amount or a percentage > Discount codes can be created and given out to individual > users or groups of > users > Set maximum number of uses for a discount code to be one, infinite, or > anything in between > > Store Front > --- > Customer login ability: > View past orders > Create, use, and delete shopping lists > Store a default billing address and unlimited shipping addresses > Quick checkout eliminates time-consuming data entry > Log file tracks logins, failed logins, and logouts > Default store front with home, contact, and privacy pages > Integrated dynamic random banner display with full logging > Default catalog allows drill-down through categories with full product > listings > Auction listings display all items available for auction with links to > purchase the item outright (if applicable) > The auction engine will automatically bid for a user until a > maximum amount > (user-specified) is reached > Product and category click logs track every click through the catalog > Search function searches product names and descriptions > Single style sheet gives developer control over fonts and colors > Shopping basket uses database for unlimited size and > scalability as well as > allowing customers to retain items across visits > Full checkout process is seperate to allow a secure connection > Checkout collects billing info, shipping info, credit card, > and shipping > method information with full server-side error checking and > validation > *NEW* Integration with InterShipper allows the user to choose > from real-time > shipping options > *NEW* CyberCash integration allows real-time credit card processing > *NEW* Your customer can download purchased files at any time > depending on > status of an order and the IP of the machine they ordered from > Product reviews can be submitted by logged-in users and will > not display > until approved by administration > Meta tags are generated for every product and category to > ensure search > engines will find you > > General > -- > Complete fusebox architecture is widely accepted and easy to > maintain and > modify > All administrative database queries are in custom tags to > allow easy re-use > during development > Full fusedoc comment headers for fast understanding of each > page's function > Use of the request scope instead of application and server > scopes eliminates > possible data
crystal reports
Ok, I went through all the old emails regarding crystal reports and there didn't seem to be many answers to the questions I saw. Is any body running Crystal Reports with Cold Fusion 5 and if so is it working? I am in need of a web based reporting app and I'm wondering if this is the way to go with the cfreport or if there is something better out there. Thanks in advance, Tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Netscape 6.1 Problems
okay, i've run out of ideas and am hoping someone on this list can help. after hitting the submit button, my code calls upon -- first thing in the form's action page -- an in-house custom tag that does some form validation. if anything in the form is not correct, a javascript pop-up lets the user know what isn't right. this tag, which we've been using for years, has worked beautifully in all browsers. for some reason, NN 6.1 is not liking it. instead of popping up the message and kicking the user back to the form, NN 6.1 duplicates everything in the javascript, which means popping up the message twice and kicking the user back two pages to the shopping cart (which means they have to fill out their contact/payment info all over again -- not good!). why is this happening??? has anyone else encountered similar behavior with NN 6.1? after doing the form validations, here is the code in the custom tag: any thoughts would be much appreciated. thanks! ~kamie -- Kamie B. Curfman Matrix Group International, Inc. 801 N. Fairfax Street, Suite 205 Alexandria, VA 22314 Phone: (703) 838-9777 x3014 Fax: (703) 838-9799 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
counting min chars in form field
How do you count chars in a form field. I have a zip code field that is used for a search. I want to allow them to key in 3-5 digits of a zip code. I've got max to make the 5 happen, but how do I check to make sure that they keyed at least 3? Brian Horn ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
help with cfx_xmlparser
Has anyone sucessfully implemented cfx_xmlparser found on www.cfdev.com ? I ran the setup and verified all java settings in the cf administrator, and they appeared to be setup correctly. The jvm path, the class path, and the cfx jar path are all there. But when I tried running the example page, I got a java exception. Attached is a snapshot off that error. Any insight on what could have caused this error would be appreciated. Thanks. Nick Han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Form fields going missing
You sure it was NS6? I thought it was only NS 4.*? Mega dittos on the maddening part. I _hate_ Netscape 4.*. Raymond Camden > -Original Message- > From: BEN MORRIS [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 3:50 PM > To: CF-Talk > Subject: Re: Form fields going missing > > > I have run into Netscape 6 not sending all form fields after a > withinin a form. Twas maddening. It seems > that everything worked as long as the was the > very last input in the form. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: shopping cart / online store
I like the cart ... is the open source licence good for unlimited implementations? servers? sites? Eric Dawson From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: shopping cart / online store Date: Wed, 29 Aug 2001 15:43:23 -0400 If your user doesn't already have a CyberCash account, he won't be able to get one now, so another vendor's requirements will have to be worked into it. JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:53 PM To: CF-Talk Subject: RE: shopping cart / online store NetReady. It's pretty new, but it's cheap and it blows the competition away Here's a feature list: Administration Expandable shipping model based on the total weight of an order *NEW* InterShipper integration allows you to query for real time shipping prices and record them to your own database with the push of a button Send bulk email to specific security roles, customers, or anyone who has ordered specific products Organization of products and product lines into user-defined categories *NEW* Create downloadable products from files with the click of a button Inventory maintainance by quantity or by expiration date Display options to allow customers to see available inventory on a per-product basis Turn individual products on or off Create auctions out of existing products Turn an auction on or off independantly of the product it represents Specify any number of options and virtually unlimited choices for each option on a per-product basis Rule editing to allow store-wide product modifications with only a few keystrokes Add, delete, and modify users to fit your business Create your own security roles or use the default roles to limit users' access to the administration tools Security log keeps track of user logins and logouts Ban specified IPs or allow only specified IPs View, modify, and delete orders Archive capability hides old orders without deleting them Integrated banner system turns banners on or off in one mouse click Specify expiration date, max mouse clicks, or max displays for individual banners Number of clicks or displays for any given banner is always accessible and up to date Bug form allows bugs to be input at any time Bug tracker allows bugs to be sorted, commented on, deleted, opened, closed, and put on hold to aid in development Client-side error checking (JavaScript) prevents invalid form input Every product has three generic flags to be used for whatever you wish (i.e. Flag1 could be for items of the week, etc...) Category-level discounts will reduce the price of any product in the category by a fixed amount or a percentage Discount codes can be created and given out to individual users or groups of users Set maximum number of uses for a discount code to be one, infinite, or anything in between Store Front --- Customer login ability: View past orders Create, use, and delete shopping lists Store a default billing address and unlimited shipping addresses Quick checkout eliminates time-consuming data entry Log file tracks logins, failed logins, and logouts Default store front with home, contact, and privacy pages Integrated dynamic random banner display with full logging Default catalog allows drill-down through categories with full product listings Auction listings display all items available for auction with links to purchase the item outright (if applicable) The auction engine will automatically bid for a user until a maximum amount (user-specified) is reached Product and category click logs track every click through the catalog Search function searches product names and descriptions Single style sheet gives developer control over fonts and colors Shopping basket uses database for unlimited size and scalability as well as allowing customers to retain items across visits Full checkout process is seperate to allow a secure connection Checkout collects billing info, shipping info, credit card, and shipping method information with full server-side error checking and validation *NEW* Integration with InterShipper allows the user to choose from real-time shipping options *NEW* CyberCash integration allows real-time credit card processing *NEW* Your customer can download purchased files at any time depending on status of an order and the IP of the machine they ordered from Product reviews can be submitted by logged-in users and will not display until approved by administration Meta tags are generated for every product and category to ensure search engines will find you General -- Complete fusebox architecture is widely accepted and easy to maintain and modify All administrative database queries are in custom tags to allow easy re-use during development Full fusedoc comment headers f
Re: Form fields going missing
I have run into Netscape 6 not sending all form fields after a withinin a form. Twas maddening. It seems that everything worked as long as the was the very last input in the form. >>> "W Luke" <[EMAIL PROTECTED]> 08/29/01 03:35PM >>> Thanks Matt (and everyone else). I've got a lot of work on my hands now Will - Original Message - From: "Matt Robertson " <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Wednesday, August 29, 2001 2:48 AM Subject: Re: Form fields going missing > Yes, I've seen this, and its absolutely maddening. Its not a coding issue, and quite possibly not a CF issue. Check out this thread. > > http://forums.allaire.com/coldfusion/arcmessageview.cfm?catid=3&threadid=165 310&highlight_key=y&keyword1=form&keyword2=variables > > When the user reported this, none of the thread respondents had seen it before, either. Then about 2 weeks later I saw it crop up on two servers, both running 4.5 (one on SP1, the other 4.5.1.0). The apps had been perfectly stable for months, and were unchanged. > > In short the behavior is this: you have a simple text input field using straight html; a required field made so by the usual fieldname_required hidden field... so the form can't be submitted without the value, in theory. But you wind up getting -- rare -- errors saying the field doesn't exist, but it *must* be there. This also can occur with a hidden value passed from page to page, where you have an explicitly set value that *must* be there, yet isn't once in a blue moon. > > Since the errors were reported via CFCATCHed email, I was able to retrieve query strings, referers etc. to confirm it was a normal form submission and not something else. > > The solutions I found were band-aids: reduce or eliminate hidden form fields (not such a bad idea anyway), CFPARAM everything with a NULL or better yet an empty string (with accompanying code to recover from the missing/expected value), and some wacky stuff that I think was a mix of witchcraft and desperation more than anything else. You can see what I mean in the thread. > > Its been so infrequent (1 out of 150 or so?) I haven't really been pestered enough to knock myself out hunting the little bugger down. One possibility: if you're using cfinsert/cfupdate, go to straight sql. That may be related to this. > > Hope this helps, > > --- > Matt Robertson[EMAIL PROTECTED] > MSB Designs, Inc., www.mysecretbase.com > --- > > > -- Original Message -- > from: "W Luke" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > date: Tue, 28 Aug 2001 21:39:30 +0100 > > Can anyone tell me why my form fields are going missing? I'm sure this > hasn't occurred before. For instance, the signup process sends hidden and > text fields to one page after another, finally to a submit page where it > should enter it to the Database (3 pages or processes in all). > > Most of the time it works, but occasionally and seemingly sporadically, > errors like "Error resolving parameter form.whatever." > > Any ideas? > > Thanks > > Will > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
No data in the selected time period. (Server Reports)
We upgraded to CF 5 (Solaris) about a month ago and have a hard time getting the Server Reports to work. Are there any tricks we are missing? The reports always come back with "No data in the selected time period". we are using * Version 5.0 Logging Format * Enabled Performance Monitoring From all I have read, the Server Reports take almost nothing to set up, however, I have yet to have the reports generated. benji --- Benji Spencer Web Programmer Moody Bible Institute 312-329-2288 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: TwoSelectsRelated weirdness
I don't know why it occurs but this is where I narrowed the problem down to in my experiences. Rich -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 3:35 PM To: CF-Talk Subject: RE: TwoSelectsRelated weirdness Hi Rich, But, wouldn't this "glitch" be true across the board? It works fine for every other user. It seems that she just has a different setting in her browser or something... Thanks, Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry Original Message Follows From: "Rich Tretola" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: TwoSelectsRelated weirdness Date: Wed, 29 Aug 2001 15:02:01 -0400 The twoselectsrelated tag breaks when one of the fields in the 1st column has a " or ' in it. This has happened to me a few times. Rich -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:43 PM To: CF-Talk Subject: TwoSelectsRelated weirdness Hey all, I use CF_TwoSelectsRelated quite a bit, but this is the first time I've encountered this particular problem. One of my site users can choose an item from the first list, but no matter what she chooses, nothing displays in the second list. No one else has reported this problem (and believe me, they WOULD have--this is an intranet application, and they report everything else). She is using IE 5.5, and has javascript enabled. Can anyone give me some other tips on this one? Thanks! Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: subtracting quantity
What does the field InOut store? If it is the number checked out, you want to increment it like: UPDATE tblApplications set InOut = InOut + 1 WHERE appID IN (#form.appID#) And your select for the list box could check the value of InOut agains the number available, which I assume is another field. If inOut is the number available, decrement the field like: UPDATE tblApplications set InOut = InOut - 1 WHERE appID IN (#form.appID#) Of course, this all assumes that appID is an integer. This works in MSSQL, but I'm not sure about other ODBC systems. With out knowing more of the table, that's about all I can help you with. > -Original Message- > From: Jones, Becky [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 1:38 PM > To: CF-Talk > Subject: subtracting quantity > > > i have a form for users to check out an application. most of my > applications are a quantity of 1, so once it is checked out, it will not > show up in the drop down list of apps to check out until it is > checked back > in. (i automatically set the checkout field to be yes). > but for the few apps that have a quantity of greater than one, how can i > make it so that it still shows up in the list until every single one has > been checked out? > right now my code just does this for every app checked out > regardless of the > quantity > > > UPDATE > tblApplications > set > InOut = 1 > WHERE > appID = (#a#) > > > > > * > 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 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: shopping cart / online store
If your user doesn't already have a CyberCash account, he won't be able to get one now, so another vendor's requirements will have to be worked into it. JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:53 PM To: CF-Talk Subject: RE: shopping cart / online store NetReady. It's pretty new, but it's cheap and it blows the competition away Here's a feature list: Administration Expandable shipping model based on the total weight of an order *NEW* InterShipper integration allows you to query for real time shipping prices and record them to your own database with the push of a button Send bulk email to specific security roles, customers, or anyone who has ordered specific products Organization of products and product lines into user-defined categories *NEW* Create downloadable products from files with the click of a button Inventory maintainance by quantity or by expiration date Display options to allow customers to see available inventory on a per-product basis Turn individual products on or off Create auctions out of existing products Turn an auction on or off independantly of the product it represents Specify any number of options and virtually unlimited choices for each option on a per-product basis Rule editing to allow store-wide product modifications with only a few keystrokes Add, delete, and modify users to fit your business Create your own security roles or use the default roles to limit users' access to the administration tools Security log keeps track of user logins and logouts Ban specified IPs or allow only specified IPs View, modify, and delete orders Archive capability hides old orders without deleting them Integrated banner system turns banners on or off in one mouse click Specify expiration date, max mouse clicks, or max displays for individual banners Number of clicks or displays for any given banner is always accessible and up to date Bug form allows bugs to be input at any time Bug tracker allows bugs to be sorted, commented on, deleted, opened, closed, and put on hold to aid in development Client-side error checking (JavaScript) prevents invalid form input Every product has three generic flags to be used for whatever you wish (i.e. Flag1 could be for items of the week, etc...) Category-level discounts will reduce the price of any product in the category by a fixed amount or a percentage Discount codes can be created and given out to individual users or groups of users Set maximum number of uses for a discount code to be one, infinite, or anything in between Store Front --- Customer login ability: View past orders Create, use, and delete shopping lists Store a default billing address and unlimited shipping addresses Quick checkout eliminates time-consuming data entry Log file tracks logins, failed logins, and logouts Default store front with home, contact, and privacy pages Integrated dynamic random banner display with full logging Default catalog allows drill-down through categories with full product listings Auction listings display all items available for auction with links to purchase the item outright (if applicable) The auction engine will automatically bid for a user until a maximum amount (user-specified) is reached Product and category click logs track every click through the catalog Search function searches product names and descriptions Single style sheet gives developer control over fonts and colors Shopping basket uses database for unlimited size and scalability as well as allowing customers to retain items across visits Full checkout process is seperate to allow a secure connection Checkout collects billing info, shipping info, credit card, and shipping method information with full server-side error checking and validation *NEW* Integration with InterShipper allows the user to choose from real-time shipping options *NEW* CyberCash integration allows real-time credit card processing *NEW* Your customer can download purchased files at any time depending on status of an order and the IP of the machine they ordered from Product reviews can be submitted by logged-in users and will not display until approved by administration Meta tags are generated for every product and category to ensure search engines will find you General -- Complete fusebox architecture is widely accepted and easy to maintain and modify All administrative database queries are in custom tags to allow easy re-use during development Full fusedoc comment headers for fast understanding of each page's function Use of the request scope instead of application and server scopes eliminates possible data corruption and increase scalability The use of database-stored client variables ins
Re: Form fields going missing
Thanks Matt (and everyone else). I've got a lot of work on my hands now Will - Original Message - From: "Matt Robertson " <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Wednesday, August 29, 2001 2:48 AM Subject: Re: Form fields going missing > Yes, I've seen this, and its absolutely maddening. Its not a coding issue, and quite possibly not a CF issue. Check out this thread. > > http://forums.allaire.com/coldfusion/arcmessageview.cfm?catid=3&threadid=165 310&highlight_key=y&keyword1=form&keyword2=variables > > When the user reported this, none of the thread respondents had seen it before, either. Then about 2 weeks later I saw it crop up on two servers, both running 4.5 (one on SP1, the other 4.5.1.0). The apps had been perfectly stable for months, and were unchanged. > > In short the behavior is this: you have a simple text input field using straight html; a required field made so by the usual fieldname_required hidden field... so the form can't be submitted without the value, in theory. But you wind up getting -- rare -- errors saying the field doesn't exist, but it *must* be there. This also can occur with a hidden value passed from page to page, where you have an explicitly set value that *must* be there, yet isn't once in a blue moon. > > Since the errors were reported via CFCATCHed email, I was able to retrieve query strings, referers etc. to confirm it was a normal form submission and not something else. > > The solutions I found were band-aids: reduce or eliminate hidden form fields (not such a bad idea anyway), CFPARAM everything with a NULL or better yet an empty string (with accompanying code to recover from the missing/expected value), and some wacky stuff that I think was a mix of witchcraft and desperation more than anything else. You can see what I mean in the thread. > > Its been so infrequent (1 out of 150 or so?) I haven't really been pestered enough to knock myself out hunting the little bugger down. One possibility: if you're using cfinsert/cfupdate, go to straight sql. That may be related to this. > > Hope this helps, > > --- > Matt Robertson[EMAIL PROTECTED] > MSB Designs, Inc., www.mysecretbase.com > --- > > > -- Original Message -- > from: "W Luke" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > date: Tue, 28 Aug 2001 21:39:30 +0100 > > Can anyone tell me why my form fields are going missing? I'm sure this > hasn't occurred before. For instance, the signup process sends hidden and > text fields to one page after another, finally to a submit page where it > should enter it to the Database (3 pages or processes in all). > > Most of the time it works, but occasionally and seemingly sporadically, > errors like "Error resolving parameter form.whatever." > > Any ideas? > > Thanks > > Will > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: TwoSelectsRelated weirdness
Hi Rich, But, wouldn't this "glitch" be true across the board? It works fine for every other user. It seems that she just has a different setting in her browser or something... Thanks, Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry Original Message Follows From: "Rich Tretola" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: TwoSelectsRelated weirdness Date: Wed, 29 Aug 2001 15:02:01 -0400 The twoselectsrelated tag breaks when one of the fields in the 1st column has a " or ' in it. This has happened to me a few times. Rich -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:43 PM To: CF-Talk Subject: TwoSelectsRelated weirdness Hey all, I use CF_TwoSelectsRelated quite a bit, but this is the first time I've encountered this particular problem. One of my site users can choose an item from the first list, but no matter what she chooses, nothing displays in the second list. No one else has reported this problem (and believe me, they WOULD have--this is an intranet application, and they report everything else). She is using IE 5.5, and has javascript enabled. Can anyone give me some other tips on this one? Thanks! Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: subtracting quantity
Instead of looping out the input, use QuotedValueList() function, thatputs the value into a comma delimited list and wraps each value inside single quotes, and then you use the IN SQL function. So let's say for example, 1 value was passed, QuotedValueList(a) would equal '343'. if 3 values were passed, it would equal '343','323','43'. and so on. UPDATE tblApplications set InOut = 1 WHERE appID IN (#QuotedValueList(a)#) >From: "Jones, Becky" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: subtracting quantity >Date: Wed, 29 Aug 2001 14:37:48 -0400 > >i have a form for users to check out an application. most of my >applications are a quantity of 1, so once it is checked out, it will not >show up in the drop down list of apps to check out until it is checked back >in. (i automatically set the checkout field to be yes). >but for the few apps that have a quantity of greater than one, how can i >make it so that it still shows up in the list until every single one has >been checked out? >right now my code just does this for every app checked out regardless of >the >quantity > > > UPDATE > tblApplications > set > InOut = 1 > WHERE > appID = (#a#) > > > > >* >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 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: SQL
Thanks so much for the responses. I got my data cleared and OUTTA HERE! ;-) Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) >>> [EMAIL PROTECTED] 08/29/01 01:56PM >>> delete from YourTableNameHere (where whatever conditions are met) you don't HAVE to use a 'where' clause on your delete, and apparently it doesn't matter if you don't in this specific case, but it can be *really* dangerous not to use it on 'real' data (i'm sure everyone here can attest to an accidental delete without a where clause at some point - i know i can). -Original Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 3:36 PM To: CF-Talk Subject: SQL I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. Any help would be greatly appreciated. Thanks, Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Activeedit 2.5 - Subthread Ektron
If you are using javascript as a wrapper, and you have the activeX control with the id of DHTMLSafe and you want to wrap the selection with , you can access the dom of the control as well as the createRange() method. here is the code source = document.DHTMLSafe.DOM.selection.createRange(); source.htmlText = "" + source.htmlText + ""; Most of what you have access to in the dom of the browser you have access to in the dom of the activeX control. Eric Gilbert Manager, Application Development StoneGround 560 Sutter Street, Suite 400 San Francisco, CA 94102 415.252.0600 (phone) 415.252.0123 (fax) http://www.stoneground.com/ CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. All code Copyright ©2001 StoneGround. All rights reserved. > -Original Message- > From: BEN MORRIS [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 11:47 AM > To: CF-Talk > Subject: RE: Activeedit 2.5 - Subthread Ektron > > > I would be interested in seeing the code you have written for > this. I have started making an editor based on IE's abilities. > Do you know if there is a way to insert any start and end tag > (similar to snippets in studio)? For instance, making an . > > >>> Billy Cravens <[EMAIL PROTECTED]> 08/29/01 02:11PM >>> > As far as the ActiveX issue goes, very true. If your needs are > relatively simple, you can easily roll your own ActiveEdit or eWebEdit > type product - use the DHTMLEdit control built into IE4+. It has a > couple of quirks that are easily coded around. I'm using it on my > personal website. > > --- > Billy Cravens > Web Development, EDS > [EMAIL PROTECTED] > > > -Original Message- > From: Trey Rouse [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 11:32 AM > To: CF-Talk > Subject: RE: Activeedit 2.5 - Subthread Ektron > > > Neither product from ektron works with Netscape 6.1. (Just Verified > Again) > > We use both empower 3.0 and ewebeditpro 2.0 and neither product is > usable in Netscape 6.1. > > Be very wary of ektron solutions as they have not been tested in what I > would call professional environments. > > We use the products on a clustered CF50 solution and as we have had > installation and general support issues, we find the product has never > been tested under these conditions. We have been pioneering this and > making changes as we go, but the lack of testing on their part has > pushed us months behind schedule. > > I'm sure if you have a small site, on a single server without > redundancy, and all your webserver pathing is done to the local machine, > then yes this product is probably a decent solution for you. > > Oh it should also be noted that while the product only works on IE, it > only works on intel/MS installations of IE. This should be obvious as > it utilizes activeX, but not everyone seems to get that. > > Trey Rouse > > > > > -Original Message- > From: Billy Cravens [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 10:51 AM > To: CF-Talk > Subject: RE: Activeedit 2.5 > > > Ektron's eWebEdit claims Netscape compatibility. > > --- > Billy Cravens > Web Development, EDS > [EMAIL PROTECTED] > > > -Original Message- > From: Chuck Hergenroeder [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 20, 2001 9:16 AM > To: CF-Talk > Subject: RE: Activeedit 2.5 > > > I don't know this for a fact, but I thought the newest release worked on > Netscape. I could be wrong though. > > -Original Message- > From: Andrew Scott [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 20, 2001 10:08 AM > To: CF-Talk > Subject: RE: Activeedit 2.5 > > Also one thing that one has to consider with this application is that it > only works under IE, I am not sure about Netscape 6.x so maybe someone > would like to confirm this but it will not work under Netscape 4.x... > > > -Original Message- > From: John Patterson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 21 August 2001 12:01 AM > To: CF-Talk > Subject: Re: Activeedit 2.5 > > Hello, > > I use ActiveEdit in an internet application of mine. I use it as a > message board for those utilizing the application. The administrator > can post application updates and system messages and client information > rather than using emails. It provides a nice "value-added" feature to > my application. > > John > > - Original Message - > From: "James Taavon" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, August 20, 2001 9:51 AM > Subject: Activeedit 2.5 > > > > I have been reading about this new product. Any feedback would be > > appreciated. > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: ht
Re: SQL
Here you go... DELETE FROM (tabel name) Rayna Evans wrote: > > I am trying to clear some data out of a table i created which is used in a CF >application I am developing. I don't want the data in the table anymore (it's a >development table so no harm if I delete the data). I know the SQL statement is >Truncate to delete the data and not the table, but I can't figure out what the >statement is or how it should be correctly worded. > > Any help would be greatly appreciated. > > Thanks, > > Rayna > > Rayna Evans > AAMC > 2501 M Street, 2nd Fl > Washington, DC 20037 > 202-862-6243 (direct) > Extension 4243 (internal) > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
CF Hosting - Minerva.net?
Anyone out there ever used Minerva (http://www.minerva.net/) for CF hosting? I was looking around, and they seemed to offer the features I wanted for the right price range. Just looking for reviews from past/current clients. Thanks! Erica Erica Vitina Web Developer Abbott Laboratories [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: SQL
Either of these two statements will remove the data from the table if you want to keep the table and it's structure: DELETE FROM table_name TRUNCATE TABLE table_name This statement will remove the table from the db: DROP TABLE table_name I wouldn't use the last one unless you are certain you won't need the table again, but I hope this helps:þ Eric Gilbert Manager, Application Development StoneGround 560 Sutter Street, Suite 400 San Francisco, CA 94102 415.252.0600 (phone) 415.252.0123 (fax) http://www.stoneground.com/ CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. All code Copyright ©2001 StoneGround. All rights reserved. > -Original Message- > From: Rayna Evans [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 12:36 PM > To: CF-Talk > Subject: SQL > > > I am trying to clear some data out of a table i created which is > used in a CF application I am developing. I don't want the data > in the table anymore (it's a development table so no harm if I > delete the data). I know the SQL statement is Truncate to delete > the data and not the table, but I can't figure out what the > statement is or how it should be correctly worded. > > Any help would be greatly appreciated. > > Thanks, > > Rayna > > Rayna Evans > AAMC > 2501 M Street, 2nd Fl > Washington, DC 20037 > 202-862-6243 (direct) > Extension 4243 (internal) > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: SQL
Don't know about the truncate thing, but this should delete all rows leaving you with an empty table: DELETE FROM TABLE_NAME - Original Message - From: Rayna Evans To: CF-Talk Sent: Wednesday, August 29, 2001 2:35 PM Subject: SQL I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. Any help would be greatly appreciated. Thanks, Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: TwoSelectsRelated weirdness
The twoselectsrelated tag breaks when one of the fields in the 1st column has a " or ' in it. This has happened to me a few times. Rich -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:43 PM To: CF-Talk Subject: TwoSelectsRelated weirdness Hey all, I use CF_TwoSelectsRelated quite a bit, but this is the first time I've encountered this particular problem. One of my site users can choose an item from the first list, but no matter what she chooses, nothing displays in the second list. No one else has reported this problem (and believe me, they WOULD have--this is an intranet application, and they report everything else). She is using IE 5.5, and has javascript enabled. Can anyone give me some other tips on this one? Thanks! Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: SQL
delete from YourTableNameHere (where whatever conditions are met) you don't HAVE to use a 'where' clause on your delete, and apparently it doesn't matter if you don't in this specific case, but it can be *really* dangerous not to use it on 'real' data (i'm sure everyone here can attest to an accidental delete without a where clause at some point - i know i can). -Original Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 3:36 PM To: CF-Talk Subject: SQL I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. Any help would be greatly appreciated. Thanks, Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: TwoSelectsRelated weirdness
if there are any special characters returning in the query, it can screw it up in that way. () was the last one that bit me -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: CF-Talk Subject: TwoSelectsRelated weirdness Hey all, I use CF_TwoSelectsRelated quite a bit, but this is the first time I've encountered this particular problem. One of my site users can choose an item from the first list, but no matter what she chooses, nothing displays in the second list. No one else has reported this problem (and believe me, they WOULD have--this is an intranet application, and they report everything else). She is using IE 5.5, and has javascript enabled. Can anyone give me some other tips on this one? Thanks! Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: subtracting quantity
do a "set InOut = InOut - 1" instead of what you have - this will subtract one from InOut in the database each time the query is called (and it will keep going into negative territory if you're not careful) When you want to add to InOut (i.e. when it's checked back in) change the '-' to a '+'. -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:38 PM To: CF-Talk Subject: subtracting quantity i have a form for users to check out an application. most of my applications are a quantity of 1, so once it is checked out, it will not show up in the drop down list of apps to check out until it is checked back in. (i automatically set the checkout field to be yes). but for the few apps that have a quantity of greater than one, how can i make it so that it still shows up in the list until every single one has been checked out? right now my code just does this for every app checked out regardless of the quantity UPDATE tblApplications set InOut = 1 WHERE appID = (#a#) * 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 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: CFMAIL Performance...
Tom: No we built our own java mail tag. Gary cfdev.com - Original Message - From: "tom muck" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 2:28 PM Subject: Re: CFMAIL Performance... > Does it use the JMail component from http://www.dimac.net ? > > tom > > "Gary Kraeger" <[EMAIL PROTECTED]> wrote in message > 033b01c130b0$1b0e1690$[EMAIL PROTECTED]">news:033b01c130b0$1b0e1690$[EMAIL PROTECTED]... > > Ian: > > > > If it is a one shot thing and you find that cfmail won't handle it. I > would > > be willing to let you use our tag jmail, on our server to help you out. > > > > Gary > > cfdev.com > > http://www.cfdev.com > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: SQL
TRUNCATE TABLE [[database.]owner.]table_name Example This example removes all data from the authors table. TRUNCATE TABLE authors - Original Message - From: "Rayna Evans" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 2:35 PM Subject: SQL > I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. > > Any help would be greatly appreciated. > > Thanks, > > Rayna > > Rayna Evans > AAMC > 2501 M Street, 2nd Fl > Washington, DC 20037 > 202-862-6243 (direct) > Extension 4243 (internal) > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Activeedit 2.5 - Subthread Ektron
I would be interested in seeing the code you have written for this. I have started making an editor based on IE's abilities. Do you know if there is a way to insert any start and end tag (similar to snippets in studio)? For instance, making an . >>> Billy Cravens <[EMAIL PROTECTED]> 08/29/01 02:11PM >>> As far as the ActiveX issue goes, very true. If your needs are relatively simple, you can easily roll your own ActiveEdit or eWebEdit type product - use the DHTMLEdit control built into IE4+. It has a couple of quirks that are easily coded around. I'm using it on my personal website. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:32 AM To: CF-Talk Subject: RE: Activeedit 2.5 - Subthread Ektron Neither product from ektron works with Netscape 6.1. (Just Verified Again) We use both empower 3.0 and ewebeditpro 2.0 and neither product is usable in Netscape 6.1. Be very wary of ektron solutions as they have not been tested in what I would call professional environments. We use the products on a clustered CF50 solution and as we have had installation and general support issues, we find the product has never been tested under these conditions. We have been pioneering this and making changes as we go, but the lack of testing on their part has pushed us months behind schedule. I'm sure if you have a small site, on a single server without redundancy, and all your webserver pathing is done to the local machine, then yes this product is probably a decent solution for you. Oh it should also be noted that while the product only works on IE, it only works on intel/MS installations of IE. This should be obvious as it utilizes activeX, but not everyone seems to get that. Trey Rouse -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 10:51 AM To: CF-Talk Subject: RE: Activeedit 2.5 Ektron's eWebEdit claims Netscape compatibility. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Chuck Hergenroeder [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 9:16 AM To: CF-Talk Subject: RE: Activeedit 2.5 I don't know this for a fact, but I thought the newest release worked on Netscape. I could be wrong though. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 10:08 AM To: CF-Talk Subject: RE: Activeedit 2.5 Also one thing that one has to consider with this application is that it only works under IE, I am not sure about Netscape 6.x so maybe someone would like to confirm this but it will not work under Netscape 4.x... -Original Message- From: John Patterson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 21 August 2001 12:01 AM To: CF-Talk Subject: Re: Activeedit 2.5 Hello, I use ActiveEdit in an internet application of mine. I use it as a message board for those utilizing the application. The administrator can post application updates and system messages and client information rather than using emails. It provides a nice "value-added" feature to my application. John - Original Message - From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 9:51 AM Subject: Activeedit 2.5 > I have been reading about this new product. Any feedback would be > appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: SQL
DELETE FROM TABLE -Original Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:36 PM To: CF-Talk Subject: SQL I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. Any help would be greatly appreciated. Thanks, Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
TwoSelectsRelated weirdness
Hey all, I use CF_TwoSelectsRelated quite a bit, but this is the first time I've encountered this particular problem. One of my site users can choose an item from the first list, but no matter what she chooses, nothing displays in the second list. No one else has reported this problem (and believe me, they WOULD have--this is an intranet application, and they report everything else). She is using IE 5.5, and has javascript enabled. Can anyone give me some other tips on this one? Thanks! Terri Stocke "If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'". -- Dave Barry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
SQL
I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. Any help would be greatly appreciated. Thanks, Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
subtracting quantity
i have a form for users to check out an application. most of my applications are a quantity of 1, so once it is checked out, it will not show up in the drop down list of apps to check out until it is checked back in. (i automatically set the checkout field to be yes). but for the few apps that have a quantity of greater than one, how can i make it so that it still shows up in the list until every single one has been checked out? right now my code just does this for every app checked out regardless of the quantity UPDATE tblApplications set InOut = 1 WHERE appID = (#a#) * 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 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: MS SQL 7/2k File Size
One way: execute the stored procedure 'master.sp_databases'--returns database_size as total of both database and transaction log in KB for each database--on SQL 2000. Glenn -Original Message- From: Chris Sinkwitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:36 AM To: CF-Talk Subject: RE: MS SQL 7/2k File Size There will be a file most likely in your D:\MSSQL7\DATA folder that will be a .mdf file. That is your database, look at the properties of that. If you don't know what the file would be named or can't figure it out you can look in Enterprise Manager right click on your database go to properties and look at the location of your database and it will tell you the name and the place it is stored. Hope this helps. Chris Sinkwitz -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:35 AM To: CF-Talk Subject: MS SQL 7/2k File Size List, Does anyone know of a way in SQL (as opposed to enterprise manager) to get the file size of a MS SQL database? Thanks in advance, Ben Morris ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: CFMAIL Performance...
Does it use the JMail component from http://www.dimac.net ? tom "Gary Kraeger" <[EMAIL PROTECTED]> wrote in message 033b01c130b0$1b0e1690$[EMAIL PROTECTED]">news:033b01c130b0$1b0e1690$[EMAIL PROTECTED]... > Ian: > > If it is a one shot thing and you find that cfmail won't handle it. I would > be willing to let you use our tag jmail, on our server to help you out. > > Gary > cfdev.com > http://www.cfdev.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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