Re: CF and DB2
how soon? but anywya, is there any other way that i can make the CF access to a DB2 database now? - Original Message - From: Gena <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Monday, November 06, 2000 2:41 PM Subject: Re: CF and DB2 > We are going to do this in the future. Logically it shouldn't be problem. > > Regards > > > - Original Message - > From: "Mak Wing Lok" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, December 15, 2000 5:25 PM > Subject: CF and DB2 > > > > do anyone know if it is possible that CF on Solaris can access to a DB2 > > database on a AS/400? if yes, how? > > > > > > > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CGI.HTTP_REFERER and SSL
Aaron, Thanks for the reply. I considered using CGI.REMOTE_ADDR, but I'm not sure if this will be the same each time (depends on whether AuthorizeNet uses multiple servers or IP addresses). In the end, since the info is coming back to my site as an HTTP form post, I decided to just check to see if one of the required form fields is defined like when checking for this on the action page of any form submission. Should work fine (don't know why I didn't think of this before). Chris Montgomery [EMAIL PROTECTED] Web Development & Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 > -Original Message- > From: Aaron Johnson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 3:46 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: CGI.HTTP_REFERER and SSL > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Chris, > > I doubt there's an issue with the cgi.http_referer between secure & > non secure.. It's just that their server (authorize.net) is doing an > HTTP POST to your server... just like in a CFHTTP post, you have the > option what you want to POST... I'm sure what's happening is that > authorize.net is not sending the http_referrer variable as part of > that post. > > Maybe use the CGI.REMOTE_ADDR to make sure the IP address is correct? > Maybe the form variables are posted to receipt.cfm they abort or > cflocate the request? > > Aaron Johnson, MCSE, MCP+I ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Archiving Site built in CF
Pan; At the moment, for outside run sites (those that are archived only and I don't run - of which in BETA there are none, that will change in 7 days), there is no way to change your personal information. http://www.tallylist.com The system pulls apart from sections of the email, and updates dynamically the name based on previous emails. (so if 2 posts ago your email system called you Jennifer, and last night you changed it to read Jenny - the system will automatically correct the database to now read Jenny). The affiliated web site is simply the end extension of your email address. So, if you utilize a Hotmail account, then your affiliated web site is hot mail. In most cases, as seen from the Ipswitch Imail test, common posters to a list, and those that are the most knowledgeable tend to utilize an email that will link to their website and generate traffic to them. Remember, the reason I built version one of this system (this is two) was to build a better search system for archived posts (hurray!), second - to add recognition to those people that are truly helpful to a community by counting posts and allowing posts to be rated, and third - to increase recognition of the lists themselves. Owners of archived lists have their web site URL and list page on every archived page, and can have their logo on the archive section for free too! Check out HKS-Imail Admin Archive as an example on TallyList. None of this archiving is a for-charge service. I am looking for more lists to archive, and if anyone has a favorite, or runs an active list, please forward an email with some info. All accounts have passwords generated for them (indeed, a password for each list and each email, so if you have posted to several lists - you already have several passwords) - for a time when I will have third party ability to modify information or link all the accounts. The world of List-Email seems way underdeveloped, and this is my project for the next couple of months. Given that - your thoughts about modifying user information, even for archived (non-hosted) lists will be given some thought. Thanks for the quick email, Stephen. http://www.tallylist.com Archive your email list here, for free, branded! -Original Message- From: pan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 6:59 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Archiving Site built in CF Very nice app. A question: How can a person listed as a poster to cf-talk edit their personal information - (you have the wrong associated web site for me :) ) Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 4.5 Studio Install Order
All: For god sakes, can it get any lamer? ;) Trying to install Studio 4.5 to Win2K, as follows: Installed base installation, rebooted. Installed 4.5a update, rebooted. Installed 4.5.1 update, rebooted. Tried other combinations, too. All's good, but when I add an FTP server (via RDS and FTP), I can't see the contents of any remote directories, which leads me to believe the installation is screwed. 4.5a, 4.5.1 -- geez, how cumbersome. Did this many times before, but this time I don't think it's working just right. Any insights? -Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: TextArea for IE vs Netscape
Hmmm I hadnt thought of that one & thats most likely. I just ran into this problem again very recently too, so its fresh in my head. I was using a stand alone button with an onclick event, so it never occured to me that I needed the form element wrapped around it. Looked in netscape, boom was right on top of it when it didnt show up. Netscape is strict like that ;) That could very well be his problem. Mike >From: "avex" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: TextArea for IE vs Netscape >Date: Fri, 15 Dec 2000 16:47:36 +1000 > >this may seem stpid >but once we had that problem here. >and someone forgot to add a form tag!! > >adding one fixed the problem.. > >i am sure this can't be your problem though... > >;-) > > > > Any ideas why a nice clean textarea with scrollbars and readonly >attributes looks fine in IE but looses everything in Netscape? > > > > TIA > > Cami > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and DB2
We are going to do this in the future. Logically it shouldn't be problem. Regards - Original Message - From: "Mak Wing Lok" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 15, 2000 5:25 PM Subject: CF and DB2 > do anyone know if it is possible that CF on Solaris can access to a DB2 > database on a AS/400? if yes, how? > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and DB2
do anyone know if it is possible that CF on Solaris can access to a DB2 database on a AS/400? if yes, how? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this even possible?
At 12:25 AM -0500 12/15/00, Dave Watts wrote: > > ... I am told there is a 500 file per directory limit on NT ... > >This isn't true. I've seen directories with more than 50,000 files on NT. >With NT or even with Solaris, though, this can cause performance problems. Sorry to pass on untrue rumors! Is there a practical limit, though? Does this (a 50,000 entry directory) cause problems with things like doing a directory listing with an FTP program? Or, Adding, deleting retrieving an individual file from FTP or CFFILE? When, if ever, does it make more sense to store the images as blobs in a db... probably in a separate child table (where it would only be retrieved when needed), e.g.: ImageId Integer Identity Primary Key. ProductIDInteger References Product, BinaryImage Image A db would certainly be a lot easier to manage from a programmer's point of view. Anyone with some real-world experience? TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: TextArea for IE vs Netscape
this may seem stpid but once we had that problem here. and someone forgot to add a form tag!! adding one fixed the problem.. i am sure this can't be your problem though... ;-) > Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? > > TIA > Cami > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Remote Printing
Just curious, why an alternative to fax? It doesn't get much cheaper or more idiot proof. Also, if you're sending credit card numbers, there's a bit of built-in security from faxing that you're unlikely to find in another technology. Jim - Original Message - From: "Eron Cohen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 8:05 PM Subject: OT: Remote Printing > Hi Everyone, > > I am trying to figure out an alternative to faxing, > and I am wondering if anyone has any ideas. I am > basically looking for some kind of technology where I > can send orders from a ColdFusion e-commerce site to > various stores and shops. It would have to be > relatively inexpensive and durable...and the "simpler" > the better. Something ideal would be along the lines > of a credit card printer that is somehow able to > "Answer the phone" so that it could get and print > incoming orders. > > I have considered a text pager, but they're too > expensive and are rather difficult to read long orders > from. Also, the device has to be reliable and idiot > proof. > > Does anyone have any ideas? > > Thank you, > > Eron Cohen > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List w/" " delims
> Dave, if this is the case (which I don't doubt), then why > will this work: > > > > #first_list# > > > > #new_list# > > Granted if you perform a listgetat on the new_list with > delims as ", " eg: > it will only pick up 'kiwi' and not 'kiwi fruit' as it uses > the space as an optional delimiter rather than space comma, > but isn't it odd that the change delims works? I don't know why that function works the way that it does, but my guess is that it's essentially just a type of Replace function. 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Service Pack 1 or 2, or Both
> I am running CF 4.5.1 Pro. I have not installed any service > packs. I know there have been two service packs published by > Allaire. Does SP2 encompass all that was included in SP1, or > do I need to install SP1, then SP2? You can just install SP2, which is a cumulative service pack. 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how many milliseconds is too many?
> Say I have a page that takes about 3,600 ms to process. Does > anyone know how much traffic that page can handle before > killing the server .. or at least until the app becomes > unusable? There are lots of other variables you'd have to provide to answer this question. How often is the page run? How many concurrent users run this page at the same time? Does the page time increase significantly when it is run concurrently? (This is very likely, by the way.) The problem here is that you really can't simply look at how long one page takes to execute in a vacuum. You really need to use a performance testing process to determine how your application will run under the load that you expect. 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this even possible?
> ... I am told there is a 500 file per directory limit on NT ... This isn't true. I've seen directories with more than 50,000 files on NT. With NT or even with Solaris, though, this can cause performance problems. 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
> > Yep. One bug recently found in IIS+CF give source code of any > > *.cfm. AFAIK many websites on CF can be broken very easily then. > > That's not a CF bug, it's an IIS bug. The script reading exploits will work > with any scripting language used on IIS. Actually I tried another scripting languages on IIS - and cannot get the same result as at CF. But I agree that it is not CF problem. It is problem of CF+IIS Regards ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon using CF
I first heard about it last spring and apparently it had been in the works for some time. - Steve -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 11:52 PM To: CF-Talk Subject: Re: Amazon using CF If I remember correctly, the announcement about the partnership with Amazon was made in August of this year. All in all, pretty ballsy, unless it had been in the works for quite some time. Jim - Original Message - From: "Steve Pierce" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 9:23 PM Subject: RE: Amazon using CF > You wrote: > >> It took Amazon about 15 minutes to convert the > > >site from Cold Fusion to their own system. > > Where did you get this data? The stuff I read is that it took thousands of > man hours and almost a year to complete the integration of the TRU store at > Amazon. > > - Steve > > > -Original Message- > At 04:16 PM 12/14/00 -0700, Jim McAtee you wrote: > > >No kidding. I think Allaire could be a little embarassed about the > previous > >CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the > >site from Cold Fusion to their own system. > > > >Jim > > > > > >- Original Message - > >From: "Aaron Johnson" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Thursday, December 14, 2000 1:53 PM > >Subject: RE: Amazon using CF > > > > > > > -BEGIN PGP SIGNED MESSAGE- > > > Hash: SHA1 > > > > > > I'll give $5 to the person who can a .cfm file on Amazon.com. > > > > > > Seriously... > > > > > > > > > > > > > > > > > > Aaron Johnson, MCSE, MCP+I > > > Allaire Certified ColdFusion Developer > > > MINDSEYE, Inc. > > > 617.350.0339 > > > 617.350.8884 > > > 66172567 > > > [EMAIL PROTECTED] > > > > > > ___ > > > "Never forget that only dead fish swim with > > > the stream." -- Malcolm Muggeridge > > > ___ > > > > > > > > > - -Original Message- > > > From: John Grubb [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, December 14, 2000 2:11 PM > > > To: CF-Talk > > > Subject: RE: Amazon using CF > > > > > > > > > Yes, they do, among other languages. I have seen ".cfm" files on > > > their site. > > > > > > John > > > > > > - -Original Message- > > > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, December 14, 2000 12:32 PM > > > To: CF-Talk > > > Subject: Amazon using CF > > > > > > > > > Hey Guys: > > > > > > I was looking at some amazon.com source and notice quite a bit of > > > whitespace, resembling CF output. Does anyone know if Amazon uses CF > > > or > > > what language they do use. > > > > > > > > > Greg ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Translating some ASP to CF
Thanks! Just the code you supplied gives me a good frame of reference and
teaches me much .. even if it doesn't work. :)
Notifying the user doesn't matter as this is something that will be done
behind the scenes (via cfschedule, hopefully) and the user will never see
it.
I'll try it first thing in the morning and let you know if it works.
Thanks again!
Todd Ashworth
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, December 14, 2000 8:59 PM
Subject: RE: Translating some ASP to CF
> Since I don't have the ASF encoder installed, I can't tell whether this
will
> work, but you can give it a try:
>
>
> Encoder1 = CreateObject("COM", "ASF.RealTimeEncoder");
> Encoder2 = CreateObject("COM", "ASF.RealTimeEncoder");
> Encoder1.LoadASD("C:\SampleConfig1.asd");
> Encoder2.LoadASD("C:\SampleConfig2.asd");
> Encoder1.InputSourceFile = "C:\sample.wav";
> Encoder1.Start();
> Encoder1.Start();
> Encoder1.RecordStart();
> Encoder2.RecordStop();
> Encoder2.RecordMaxSize = 5000;
> Encoder2.RecordFileName = "C:\MyNewOutputFileName.asf";
> Encoder2.RecordStart();
> Encoder1.RecordStop();
> Encoder2.RecordStop();
> Encoder1.Stop();
> Encoder2.Stop();
>
>
> You'll notice that it doesn't look all that different. CFSCRIPT follows
> JavaScript syntax, so method calls are followed by parentheses. Also, I
left
> out two parts. In the middle of your VB code, a message box is being
> displayed. That won't work in a web environment very well, as by the time
> the user sees it, the rest of the (server-side) code will have already
run.
> At the bottom of your code, you're setting the COM object references to
> "Nothing". That's not really necessary in CF, as the references will be
> released at the end of the script.
>
> Good luck! Let me know on the off chance that it actually works.
>
> 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
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Remote Printing
An email appliance is a good idea and might be the best solution...I thought of this too, but its main downfall is that it would require a constant internet connection (because these orders are extremely time sensitive--minutes will matter) so it would tie up a phone line. This could be very expensive on a business line. Something wireless could turn out to be cheaper...but the wireless devices I've looked at would be pretty hard to recoup the cost of. Also, the store owners might not like to put something in the store that could distract their employees from doing their job. Eron -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 10:47 PM To: CF-Talk Subject: RE: Remote Printing Get one of those "email only" devices and email the information. They are not much over $100 i think. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 9:06 PM To: CF-Talk Subject: OT: Remote Printing Hi Everyone, I am trying to figure out an alternative to faxing, and I am wondering if anyone has any ideas. I am basically looking for some kind of technology where I can send orders from a ColdFusion e-commerce site to various stores and shops. It would have to be relatively inexpensive and durable...and the "simpler" the better. Something ideal would be along the lines of a credit card printer that is somehow able to "Answer the phone" so that it could get and print incoming orders. I have considered a text pager, but they're too expensive and are rather difficult to read long orders from. Also, the device has to be reliable and idiot proof. Does anyone have any ideas? Thank you, Eron Cohen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
If I remember correctly, the announcement about the partnership with Amazon was made in August of this year. All in all, pretty ballsy, unless it had been in the works for quite some time. Jim - Original Message - From: "Steve Pierce" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 9:23 PM Subject: RE: Amazon using CF > You wrote: > >> It took Amazon about 15 minutes to convert the > > >site from Cold Fusion to their own system. > > Where did you get this data? The stuff I read is that it took thousands of > man hours and almost a year to complete the integration of the TRU store at > Amazon. > > - Steve > > > -Original Message- > At 04:16 PM 12/14/00 -0700, Jim McAtee you wrote: > > >No kidding. I think Allaire could be a little embarassed about the > previous > >CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the > >site from Cold Fusion to their own system. > > > >Jim > > > > > >- Original Message - > >From: "Aaron Johnson" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Thursday, December 14, 2000 1:53 PM > >Subject: RE: Amazon using CF > > > > > > > -BEGIN PGP SIGNED MESSAGE- > > > Hash: SHA1 > > > > > > I'll give $5 to the person who can a .cfm file on Amazon.com. > > > > > > Seriously... > > > > > > > > > > > > > > > > > > Aaron Johnson, MCSE, MCP+I > > > Allaire Certified ColdFusion Developer > > > MINDSEYE, Inc. > > > 617.350.0339 > > > 617.350.8884 > > > 66172567 > > > [EMAIL PROTECTED] > > > > > > ___ > > > "Never forget that only dead fish swim with > > > the stream." -- Malcolm Muggeridge > > > ___ > > > > > > > > > - -Original Message- > > > From: John Grubb [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, December 14, 2000 2:11 PM > > > To: CF-Talk > > > Subject: RE: Amazon using CF > > > > > > > > > Yes, they do, among other languages. I have seen ".cfm" files on > > > their site. > > > > > > John > > > > > > - -Original Message- > > > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, December 14, 2000 12:32 PM > > > To: CF-Talk > > > Subject: Amazon using CF > > > > > > > > > Hey Guys: > > > > > > I was looking at some amazon.com source and notice quite a bit of > > > whitespace, resembling CF output. Does anyone know if Amazon uses CF > > > or > > > what language they do use. > > > > > > > > > Greg ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Remote Printing
Get one of those "email only" devices and email the information. They are not much over $100 i think. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 9:06 PM To: CF-Talk Subject: OT: Remote Printing Hi Everyone, I am trying to figure out an alternative to faxing, and I am wondering if anyone has any ideas. I am basically looking for some kind of technology where I can send orders from a ColdFusion e-commerce site to various stores and shops. It would have to be relatively inexpensive and durable...and the "simpler" the better. Something ideal would be along the lines of a credit card printer that is somehow able to "Answer the phone" so that it could get and print incoming orders. I have considered a text pager, but they're too expensive and are rather difficult to read long orders from. Also, the device has to be reliable and idiot proof. Does anyone have any ideas? Thank you, Eron Cohen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon using CF
You wrote: >> It took Amazon about 15 minutes to convert the > >site from Cold Fusion to their own system. Where did you get this data? The stuff I read is that it took thousands of man hours and almost a year to complete the integration of the TRU store at Amazon. - Steve -Original Message- At 04:16 PM 12/14/00 -0700, Jim McAtee you wrote: >No kidding. I think Allaire could be a little embarassed about the previous >CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the >site from Cold Fusion to their own system. > >Jim > > >- Original Message - >From: "Aaron Johnson" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, December 14, 2000 1:53 PM >Subject: RE: Amazon using CF > > > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > I'll give $5 to the person who can a .cfm file on Amazon.com. > > > > Seriously... > > > > > > > > > > > > Aaron Johnson, MCSE, MCP+I > > Allaire Certified ColdFusion Developer > > MINDSEYE, Inc. > > 617.350.0339 > > 617.350.8884 > > 66172567 > > [EMAIL PROTECTED] > > > > ___ > > "Never forget that only dead fish swim with > > the stream." -- Malcolm Muggeridge > > ___ > > > > > > - -Original Message- > > From: John Grubb [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, December 14, 2000 2:11 PM > > To: CF-Talk > > Subject: RE: Amazon using CF > > > > > > Yes, they do, among other languages. I have seen ".cfm" files on > > their site. > > > > John > > > > - -Original Message- > > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, December 14, 2000 12:32 PM > > To: CF-Talk > > Subject: Amazon using CF > > > > > > Hey Guys: > > > > I was looking at some amazon.com source and notice quite a bit of > > whitespace, resembling CF output. Does anyone know if Amazon uses CF > > or > > what language they do use. > > > > > > Greg > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and SQL
Lmao... I think that was Mcfarland??? >From: Peter Theobald <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Oracle and SQL >Date: Thu, 14 Dec 2000 21:47:00 -0500 > >Can't you use Cold Fusion's startrow= and maxrows= to do the same thing? > > >P.S. I loved your comics, animations, film, and action figures :-) > >At 10:17 AM 12/14/00 -0800, Todd McFarlin wrote: > >Greetings, > > > >Being an Oracle person, I'm having a difficult time trying to >make a > >CFQuery work correctly in SQL. > > > >The Problem: I have a database with thousands of rows. I need to select >only > >50 rows per query. The start row and end row need to be variables. Now, > >Oracle has a function called RowNum. In the Where part of a query, it >allows > >the selection of certain rows from the table between two set > >paramaters...something like select rows >=50 and <=100. This yields 50 >rows > >returned. > > > >My Question: Is there a similar function in SQL, or how is this > >accomplished? > > > >My thanks, > > > >Todd McFarlin > >Celosis, Inc. > >[EMAIL PROTECTED] > >(510) 814-3078 > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Remote Printing
There is this one thing, called email ;) >From: Eron Cohen <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: OT: Remote Printing >Date: Thu, 14 Dec 2000 19:05:57 -0800 (PST) > >Hi Everyone, > >I am trying to figure out an alternative to faxing, >and I am wondering if anyone has any ideas. I am >basically looking for some kind of technology where I >can send orders from a ColdFusion e-commerce site to >various stores and shops. It would have to be >relatively inexpensive and durable...and the "simpler" >the better. Something ideal would be along the lines >of a credit card printer that is somehow able to >"Answer the phone" so that it could get and print >incoming orders. > >I have considered a text pager, but they're too >expensive and are rather difficult to read long orders >from. Also, the device has to be reliable and idiot >proof. > >Does anyone have any ideas? > >Thank you, > >Eron Cohen > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Remote Printing
Sometimes you don't see the forest 'cause of the trees, so I'm going to say this out-loud anyway. What about e-mail? Although, some would argue about how idiot proof it is, but almost everyone knows how to use it in some manner. Add some form of encrypting on either end it could be made secure. Eron Cohen wrote: > > Hi Everyone, > > I am trying to figure out an alternative to faxing, > and I am wondering if anyone has any ideas. I am > basically looking for some kind of technology where I > can send orders from a ColdFusion e-commerce site to > various stores and shops. It would have to be > relatively inexpensive and durable...and the "simpler" > the better. Something ideal would be along the lines > of a credit card printer that is somehow able to > "Answer the phone" so that it could get and print > incoming orders. > > I have considered a text pager, but they're too > expensive and are rather difficult to read long orders > from. Also, the device has to be reliable and idiot > proof. > > Does anyone have any ideas? > > Thank you, > > Eron Cohen > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
Funny thing... Allaire's sales guy that just came to my company to do a demo still pushes Toys R Us as a customer. At 04:16 PM 12/14/00 -0700, Jim McAtee you wrote: >No kidding. I think Allaire could be a little embarassed about the previous >CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the >site from Cold Fusion to their own system. > >Jim > > >- Original Message - >From: "Aaron Johnson" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, December 14, 2000 1:53 PM >Subject: RE: Amazon using CF > > > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > I'll give $5 to the person who can a .cfm file on Amazon.com. > > > > Seriously... > > > > > > > > > > > > Aaron Johnson, MCSE, MCP+I > > Allaire Certified ColdFusion Developer > > MINDSEYE, Inc. > > 617.350.0339 > > 617.350.8884 > > 66172567 > > [EMAIL PROTECTED] > > > > ___ > > "Never forget that only dead fish swim with > > the stream." -- Malcolm Muggeridge > > ___ > > > > > > - -Original Message- > > From: John Grubb [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, December 14, 2000 2:11 PM > > To: CF-Talk > > Subject: RE: Amazon using CF > > > > > > Yes, they do, among other languages. I have seen ".cfm" files on > > their site. > > > > John > > > > - -Original Message- > > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, December 14, 2000 12:32 PM > > To: CF-Talk > > Subject: Amazon using CF > > > > > > Hey Guys: > > > > I was looking at some amazon.com source and notice quite a bit of > > whitespace, resembling CF output. Does anyone know if Amazon uses CF > > or > > what language they do use. > > > > > > Greg > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Browsers cache
You could try but no promises. ~Mike >From: Dian Oktosoma <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Browsers cache >Date: Fri, 15 Dec 2000 09:05:22 +0700 > >I create a page to view database rows, then I create a button to delete >selected record and still go to the same page after delete process. If I >didn't use META TAG pragma "no-cache", the deleted record still there (but >already deleted from database) because of the browser cached it so users >need to refresh. Is there any other method using CF function instead of >using meta tag ? > >thanks > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon using CF
Its just a mapping, once removed the vulnerability is gone. >From: Dave Watts <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Amazon using CF >Date: Thu, 14 Dec 2000 21:12:21 -0500 > > > Yep. One bug recently found in IIS+CF give source code of any > > *.cfm. AFAIK many websites on CF can be broken very easily then. > >That's not a CF bug, it's an IIS bug. The script reading exploits will work >with any scripting language used on IIS. > >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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfcatch.tagcontext
> Does this variable only work under a certain type of cfcatch type ? The > documentation I'm looking at doesn't specify and it's not working under a > cfcatch type="any" > Administrator/debugging/"Enable CFML stack trace" Use this only on a development machine - stack trace will slow a production server down significantly. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfcatch.tagcontext
The tag stack is as follows: #x# #context["ID"]# (#context["LINE"]#,#context["COLUMN"]#) #context["TEMPLATE"]# That should do it for you, run this inside the tags . When an exeption is caught it'll work. Mike >From: "Rob Sherman" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: cfcatch.tagcontext >Date: Thu, 14 Dec 2000 19:56:42 -0800 > >Does this variable only work under a certain type of cfcatch type ? The >documentation I'm looking at doesn't specify and it's not working under a >cfcatch type="any" > > >Sincerely, > >Rob Sherman >Allaire Certified Developer & Instructor >CFDude, Inc. http://www.cfdude.com > (310) 543-1622 (310) 543-0512 > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
Silly question: Why would you have to *see* '.cfm' to prove they are using cf? laszlo Aaron Johnson wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I'll give $5 to the person who can a .cfm file on Amazon.com. > > Seriously... > > > > > > Aaron Johnson, MCSE, MCP+I > Allaire Certified ColdFusion Developer > MINDSEYE, Inc. > 617.350.0339 > 617.350.8884 > 66172567 > [EMAIL PROTECTED] > > ___ > "Never forget that only dead fish swim with > the stream." -- Malcolm Muggeridge > ___ > > - -Original Message- > From: John Grubb [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 2:11 PM > To: CF-Talk > Subject: RE: Amazon using CF > > Yes, they do, among other languages. I have seen ".cfm" files on > their site. > > John > > - -Original Message- > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 12:32 PM > To: CF-Talk > Subject: Amazon using CF > > Hey Guys: > > I was looking at some amazon.com source and notice quite a bit of > whitespace, resembling CF output. Does anyone know if Amazon uses CF > or > what language they do use. > > Greg > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Remote Printing
Hi Everyone, I am trying to figure out an alternative to faxing, and I am wondering if anyone has any ideas. I am basically looking for some kind of technology where I can send orders from a ColdFusion e-commerce site to various stores and shops. It would have to be relatively inexpensive and durable...and the "simpler" the better. Something ideal would be along the lines of a credit card printer that is somehow able to "Answer the phone" so that it could get and print incoming orders. I have considered a text pager, but they're too expensive and are rather difficult to read long orders from. Also, the device has to be reliable and idiot proof. Does anyone have any ideas? Thank you, Eron Cohen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
That's because they didn't convert anything. They loaded Toys R Us's inventory into their existing system. Nothing new had to be written. BTW, they lost alot of "toy specific" functionality along the way. At 04:16 PM 12/14/00 -0700, Jim McAtee wrote: >No kidding. I think Allaire could be a little embarassed about the previous >CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the >site from Cold Fusion to their own system. > >Jim > > >- Original Message - >From: "Aaron Johnson" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, December 14, 2000 1:53 PM >Subject: RE: Amazon using CF > > >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> I'll give $5 to the person who can a .cfm file on Amazon.com. >> >> Seriously... >> >> >> >> >> >> Aaron Johnson, MCSE, MCP+I >> Allaire Certified ColdFusion Developer >> MINDSEYE, Inc. >> 617.350.0339 >> 617.350.8884 >> 66172567 >> [EMAIL PROTECTED] >> >> ___ >> "Never forget that only dead fish swim with >> the stream." -- Malcolm Muggeridge >> ___ >> >> >> - -Original Message- >> From: John Grubb [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, December 14, 2000 2:11 PM >> To: CF-Talk >> Subject: RE: Amazon using CF >> >> >> Yes, they do, among other languages. I have seen ".cfm" files on >> their site. >> >> John >> >> - -Original Message- >> From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, December 14, 2000 12:32 PM >> To: CF-Talk >> Subject: Amazon using CF >> >> >> Hey Guys: >> >> I was looking at some amazon.com source and notice quite a bit of >> whitespace, resembling CF output. Does anyone know if Amazon uses CF >> or >> what language they do use. >> >> >> Greg >> > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this even possible?
On www.allbooks4less.com we store the file name of the image in the database. Since the site deals with books, every item has a unique ISBN number (substitute your favorite ID# here). Each image is named .gif, so we didn't really need to store the file names in the database (but we do just in case that relationship doesn't always hold true- for example if we add products that DONT have ISBN numbers). There are too many files to put in one directory, so we split them by the least significant digit of the ISBN # (more random distribution than the most significant digit). Eg: /images/8/12345678.gif (FYI: most of this is hidden from the user, and this is NOT a CF site. Sorry...) At 10:51 PM 12/14/00 +, t nelson wrote: >Hi all, > >I am wondering if this will even be possible or if I just have a pie in the >sky dream. > >Here it goes: > >Let's say that you have an online store with a huge inventory of products, >we're talking close to 10'000 distinct items. your site has everything we >have come to expect from an e-store application (search features, shopping >carts, etc..). if by some miracle i had a good quality and not too big >(under 10k each) .jpg or .gif for each item in my inventory. would it be >possible for me to some how link each of those pictures to its corresponding >part in my database? this way when a customer searched for an item, a nice >picture could come along with it. > >again, is this even possible, if so how? > >thanks in advance for your time and help, > >nelson > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and SQL
Can't you use Cold Fusion's startrow= and maxrows= to do the same thing? P.S. I loved your comics, animations, film, and action figures :-) At 10:17 AM 12/14/00 -0800, Todd McFarlin wrote: >Greetings, > >Being an Oracle person, I'm having a difficult time trying to make a >CFQuery work correctly in SQL. > >The Problem: I have a database with thousands of rows. I need to select only >50 rows per query. The start row and end row need to be variables. Now, >Oracle has a function called RowNum. In the Where part of a query, it allows >the selection of certain rows from the table between two set >paramaters...something like select rows >=50 and <=100. This yields 50 rows >returned. > >My Question: Is there a similar function in SQL, or how is this >accomplished? > >My thanks, > >Todd McFarlin >Celosis, Inc. >[EMAIL PROTECTED] >(510) 814-3078 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
But if I'm thinking of the same bug, that was an IIS exploit that would have shown source code for lots of file types: CF, ASP, etc. - Original Message - From: Gena <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Sunday, November 05, 2000 5:06 PM Subject: Re: Amazon using CF > > Do you think that the largest online e-tailor wants people to know what > > language and app servers they use? That would aid hackers quite nicely, > > huh? > > Yep. One bug recently found in IIS+CF give source code of any *.cfm. AFAIK > many websites on CF can be broken very easily then. > > Regards, > Gennadi > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
Although, 'easy to read' CFML just means a good coder coded it. I wouldn't take that as a reflection on Allaire or ColdFusion. I've worked with CFM templates that were so large and poorly written it took weeks to make heads or tails out of it. Raymond Camden wrote: > > Outside of losing a client, why is this bad? It seems like your saying, > "Geeze, it was hard to convert from CF to another language, which means that > CF was easy to read and understand." :> > > === > Raymond Camden, Principal Spectra Compliance Engineer for Allaire > > Email : [EMAIL PROTECTED] > ICQ UIN : 3679482 > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, December 14, 2000 6:17 PM > > To: CF-Talk > > Subject: Re: Amazon using CF > > > > > > No kidding. I think Allaire could be a little embarassed about > > the previous > > CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the > > site from Cold Fusion to their own system. > > > > Jim > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Browsers cache
I create a page to view database rows, then I create a button to delete selected record and still go to the same page after delete process. If I didn't use META TAG pragma "no-cache", the deleted record still there (but already deleted from database) because of the browser cached it so users need to refresh. Is there any other method using CF function instead of using meta tag ? thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: TextArea for IE vs Netscape
Could you be more specific & add some additional code samples??? Mike >From: "Bob Silverberg" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: TextArea for IE vs Netscape >Date: Thu, 14 Dec 2000 19:07:04 -0500 > >The readonly attribute is only supported in IE (according to my >documentation). I wouldn't think that it would cause problems with your >page (NS should ignore it), but it could be the culprit. > >Bob > >-Original Message- >From: Cami Lawson [mailto:[EMAIL PROTECTED]] >Sent: December 14, 2000 4:59 PM >To: CF-Talk >Subject: TextArea for IE vs Netscape > > >Any ideas why a nice clean textarea with scrollbars and readonly attributes >looks fine in IE but looses everything in Netscape? > >TIA >Cami > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon using CF
> Yep. One bug recently found in IIS+CF give source code of any > *.cfm. AFAIK many websites on CF can be broken very easily then. That's not a CF bug, it's an IIS bug. The script reading exploits will work with any scripting language used on IIS. 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this even possible?
I'd say easily enough if you started this project from scratch. Lets say all your items fall into certain categories like: Stereos Lawn & Garden equipment Sports equipment Antiques Etc. Etc. Now lets say you have shortened the names down & added a column within your database that holds the value of the categorie that the product falls under. The values in that field would look like this: electronics antiques lawn furniture etc. etc. Ok now lets say you have an images directory that contains a folder for each one of those values with the same name. So your images directory contains one folder for each categorie value. Add one more additional field to your database that holds the items/inventory image name with the extension. Now the values for that new field should look like this: chair0001.jpg stereo635.gif etc. etc. In your query for a particular item include the the path (which would be the categorie name) & the image file as dynamic variables generated from your query & display the image inside an image tag like this: SELECT Blah, Bleah FROM Blah That would do it for you. Ive incorporated something like this into a shopping cart before, works like a charm. HTH, Mike >From: "t nelson" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Is this even possible? >Date: Thu, 14 Dec 2000 22:51:20 - > >Hi all, > >I am wondering if this will even be possible or if I just have a pie in the >sky dream. > >Here it goes: > >Let's say that you have an online store with a huge inventory of products, >we're talking close to 10'000 distinct items. your site has everything we >have come to expect from an e-store application (search features, shopping >carts, etc..). if by some miracle i had a good quality and not too big >(under 10k each) .jpg or .gif for each item in my inventory. would it be >possible for me to some how link each of those pictures to its >corresponding >part in my database? this way when a customer searched for an item, a nice >picture could come along with it. > >again, is this even possible, if so how? > >thanks in advance for your time and help, > >nelson > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access DB error on insert
I get this error when trying to insert to the Access database i have over at cfm-resources.com, the access DB is available to view here http://www.cfm-resources.com/b/bludhall/data/bludhall.mdb I'm using CF 4.5, i have no idea of the service pack versions, its the free hosting at cfm-resources.com Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:64). _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon using CF
Of course, what I meant to say is : " Geeze, it was EASY to convert from CF to another language, which means that CF was easy to read and understand." === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 7:57 PM > To: CF-Talk > Subject: RE: Amazon using CF > > > Outside of losing a client, why is this bad? It seems like your saying, > "Geeze, it was hard to convert from CF to another language, which > means that > CF was easy to read and understand." :> > > === > Raymond Camden, Principal Spectra Compliance Engineer for Allaire > > Email : [EMAIL PROTECTED] > ICQ UIN : 3679482 > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, December 14, 2000 6:17 PM > > To: CF-Talk > > Subject: Re: Amazon using CF > > > > > > No kidding. I think Allaire could be a little embarassed about > > the previous > > CF poster child, ToysRUs. It took Amazon about 15 minutes to > convert the > > site from Cold Fusion to their own system. > > > > Jim > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Translating some ASP to CF
Since I don't have the ASF encoder installed, I can't tell whether this will
work, but you can give it a try:
Encoder1 = CreateObject("COM", "ASF.RealTimeEncoder");
Encoder2 = CreateObject("COM", "ASF.RealTimeEncoder");
Encoder1.LoadASD("C:\SampleConfig1.asd");
Encoder2.LoadASD("C:\SampleConfig2.asd");
Encoder1.InputSourceFile = "C:\sample.wav";
Encoder1.Start();
Encoder1.Start();
Encoder1.RecordStart();
Encoder2.RecordStop();
Encoder2.RecordMaxSize = 5000;
Encoder2.RecordFileName = "C:\MyNewOutputFileName.asf";
Encoder2.RecordStart();
Encoder1.RecordStop();
Encoder2.RecordStop();
Encoder1.Stop();
Encoder2.Stop();
You'll notice that it doesn't look all that different. CFSCRIPT follows
JavaScript syntax, so method calls are followed by parentheses. Also, I left
out two parts. In the middle of your VB code, a message box is being
displayed. That won't work in a web environment very well, as by the time
the user sees it, the rest of the (server-side) code will have already run.
At the bottom of your code, you're setting the COM object references to
"Nothing". That's not really necessary in CF, as the references will be
released at the end of the script.
Good luck! Let me know on the off chance that it actually works.
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
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfcatch.tagcontext
Does this variable only work under a certain type of cfcatch type ? The documentation I'm looking at doesn't specify and it's not working under a cfcatch type="any" Sincerely, Rob Sherman Allaire Certified Developer & Instructor CFDude, Inc. http://www.cfdude.com (310) 543-1622 (310) 543-0512 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Archiving Site built in CF
[cc'd to author] From: "Stephen R. Cassady" <[EMAIL PROTECTED]> Subject: Archiving Site built in CF > > Hey everyone! > I've released into beta v2 an archive site for email-lists. It started as a > project just to archive my favorite lists (I hated the available search > systems) and it's slowly evolving into something larger and larger. > > I would appreciate any feedback that you might have, and any ideas for > further lists to archive! > > http://www.tallylist.com > Very nice app. A question: How can a person listed as a poster to cf-talk edit their personal information - (you have the wrong associated web site for me :) ) Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with cachedwithin
It will also work if you just evaluate the timespan first: Rick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 5:49 PM To: CF-Talk Subject: RE: Problem with cachedwithin This works: Bob -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: December 14, 2000 4:20 PM To: CF-Talk Subject: Problem with cachedwithin The following works: while the following two do not: Testing with simple outputs of #createtimespan(0,variables.timespan,0,0)#, etc. all seem to provide the same result, so why won't it work in the . I'm basing my assumption that it isn't working by the debug output that will change from saying "Cached Query" to giving a time in milliseconds. If this won't work, how else do you dynamically refresh a cached query whenever you want to? Thanks, Dan The information contained in this message is privileged and confidential. It is intended solely for the use of the named recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this transmission is strictly prohibited. If you receive this message in error, please notify the sender immediately. Thank you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this even possible?
Yes it is possible Some considerations: You can store the .jpg files as files and reference them with a SQL database pointer to the file keeping track of 10,000 different .jpg files is messy if you store them as files (I am told there is a 500 file per directory limit on NT)... so you have multiple files and directories You can store the .jpg files in the database as blob (large binary) fields (I am told that this is inefficient) CF 4.0 does not support manipulation of binary fields to/from a database (4.5 apparently does) If you are on CF 4.0 and a win OS, you can manipulate the binary files to/from the database with ASP I have done limited experimentation with this ASP CF combo and it appears to work and perform acceptably... and eliminates a lot of messy file manipulation All in all, i would think that the blob in the db is the lesser of two evils. Dick At 10:51 PM + 12/14/00, t nelson wrote: >Hi all, > >I am wondering if this will even be possible or if I just have a pie in the >sky dream. > >Here it goes: > >Let's say that you have an online store with a huge inventory of products, >we're talking close to 10'000 distinct items. your site has everything we >have come to expect from an e-store application (search features, shopping >carts, etc..). if by some miracle i had a good quality and not too big >(under 10k each) .jpg or .gif for each item in my inventory. would it be >possible for me to some how link each of those pictures to its corresponding >part in my database? this way when a customer searched for an item, a nice >picture could come along with it. > >again, is this even possible, if so how? > >thanks in advance for your time and help, > >nelson > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Beware the imposter
lol @ Uwe Granted that they could easily remain anonymous, but I was just offering a suggestion. I apologize for my sacrilege .. this *is* Ben Forta we are talking about. Shame on me for not thinking he hadn't already thought of this :( Todd Ashworth - Original Message - From: "Gary McNeel, Jr." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 7:00 PM Subject: RE: Beware the imposter > I confess, it was Uwe who did it. ;) > > (Moving to Cafe 182). > > -Gary > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, December 14, 2000 3:45 PM > > To: CF-Talk > > Subject: Re: Beware the imposter > > > > > > Todd, what if he works from an internet cafe to do this ? > > And he is changing the cafes constantly ? > > You simply can't find this guy ! > > > > Uwe > > > > > > Mail: [EMAIL PROTECTED] > > WWW: www.sdsolutions.de > > - Original Message - > > From: "Todd Ashworth" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, December 14, 2000 5:09 PM > > Subject: Re: Beware the imposter > > > > > > Doesn't Hotmail include the originating IP in their headers > > anymore? I know > > they used to. If they still do, you can just figure out their > > ISP and lodge > > a complaint. I'm sure you would get prompt action ;) > > > > Todd Ashworth > > > > - Original Message - > > From: "Ben Forta" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, December 14, 2000 9:51 AM > > Subject: OT: Beware the imposter > > > > > > | Hi all, sorry for the OT message, but ... > > | > > | Some creep has set up an e-mail account "[EMAIL PROTECTED]" and is > > | sending out messages pretending to be me. Not that any of you would be > > | fooled by the messages (they essentially badmouth ColdFusion, > > Allaire, and > > | me, and the language is both immature and tasteless) but just so you > > know - > > | it is not me. Promise. :-) > > | > > | What he is doing is illegal. If any of you have any idea who > > this jerk is, > > | please let me know. Thanks. > > | > > | --- Ben ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAV conversion to MP3
I have been trying to do something similar, except I want to automaticly convert an mp3 file to a streaming Windows Media file. Technicly speaking, you should be able to use Microsoft's Windows Media Encoder (available at http://www.microsoft.com/windows/windowsmedia/en/download/default.asp [choose Windows Media Services 4.1 for Windows NT 4 (sp4)]) to do what you ask by using the COM objects associated with it. Unfortunately, MS only provides examples using VB, so I've had a devil of a time getting it to work ... but in theory you should be able to convert your files to streaming media on the fly. Todd Ashworth > > I have been playing around with tellme.com for my rivercityhockey.net > hockey > > league web site. > > > > They have a feature where you can record a soundfile and have it post > back > > to the server. Pretty cool. http://www.rivercityhockey.net/voiceBook > > > > The sound files post in a WAV format, but I was thinking I might want to > > convert to MP3 or some streaming format. Does anyone know where I could > find > > a little utility I could use to convert from WAV to ??? said audio > format? > > > > Eric > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this even possible?
Just have the image filename in the products table.. pretty simple if that's what you meant. -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 8:51 AM To: CF-Talk Subject: Is this even possible? Hi all, I am wondering if this will even be possible or if I just have a pie in the sky dream. Here it goes: Let's say that you have an online store with a huge inventory of products, we're talking close to 10'000 distinct items. your site has everything we have come to expect from an e-store application (search features, shopping carts, etc..). if by some miracle i had a good quality and not too big (under 10k each) .jpg or .gif for each item in my inventory. would it be possible for me to some how link each of those pictures to its corresponding part in my database? this way when a customer searched for an item, a nice picture could come along with it. again, is this even possible, if so how? thanks in advance for your time and help, nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Just a stray thought
As can I recall, IBM was proud about some million+ numbers per hour against their DB2 during the winter olimpic games. (Sorry, I couldn't find the article about it). laszlo Judith Campbell wrote: > > At 08:36 AM 12/13/00 -0800, you wrote: > >Ok, this is meant as no shameless plug but I read on their website: > > > >UPS expects to receive 5 million tracking requests on their website per day > >especially on their peak days (it reads something like that) > > > >Who's up for this? > > Doesn't seem like it would be that difficult. Correct database design, > enough servers, tracking requests against a database shouldn't be that hard > to write. > > Judith Campbell > Chief Technical Officer > Digital Positions, Inc. > [EMAIL PROTECTED] > 404-351-9366 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: compound interest
If i understand your question right (you'll have to excuse me for not knowing the english terms for stuff like interests) you're looking for something like this Balance on your account after n years = deposit x * (1 + r %) ^ n F.ex deposit $10,000 on december 31st at 6 % apr will accumulate to $12,624.77 if you leave it for 4 years 10,000 * (1.06)^4 = 12,624.77 Hope this is what you're looking for! Allan Pichler Machine Dreams Inc. -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 3:08 PM To: CF-Talk Subject: ot: compound interest does anyone know the formula for calculating compound interest? I need to figure the values of trucks on our site... it has been simple interest up until 3 days AFTER it went live... GRRR... Thanks! Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
> Do you think that the largest online e-tailor wants people to know what > language and app servers they use? That would aid hackers quite nicely, > huh? Yep. One bug recently found in IIS+CF give source code of any *.cfm. AFAIK many websites on CF can be broken very easily then. Regards, Gennadi ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: compound interest
Isn't it just new_value = current_value times (1 + intrest_rate)? Then save the new_value over the current_value and repeat as needed? Todd Ashworth - Original Message - From: "Jason Egan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 6:07 PM Subject: ot: compound interest > does anyone know the formula for calculating compound interest? I need to > figure the values of trucks on our site... it has been simple interest up > until 3 days AFTER it went live... GRRR... > > Thanks! > Jason > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon using CF
Outside of losing a client, why is this bad? It seems like your saying, "Geeze, it was hard to convert from CF to another language, which means that CF was easy to read and understand." :> === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 6:17 PM > To: CF-Talk > Subject: Re: Amazon using CF > > > No kidding. I think Allaire could be a little embarassed about > the previous > CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the > site from Cold Fusion to their own system. > > Jim > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF4.5.1 SP2.
Are you using stored procs or CF for large or complicated queries? > Second, we cleaned up rogue code that allowed huge record set returns on queries. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this even possible?
Some possibilities: 1. Add a column to the Parts table, store the name of the image file in that column, retrieve the name in a query and dynamically create the tag. 2. Create each image file so that the name is somehow linked to the record in the database. For example, if the part_id is ABC123, call the image file ABC123.jpg. Dynamically create the tag based in the part_id. 3. Do both 1 and 2, that way you could write an update query that would pre-populate the image name column with the proper file name, and any inserts into the table could do the same as well. Bob -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: December 14, 2000 5:51 PM To: CF-Talk Subject: Is this even possible? Hi all, I am wondering if this will even be possible or if I just have a pie in the sky dream. Here it goes: Let's say that you have an online store with a huge inventory of products, we're talking close to 10'000 distinct items. your site has everything we have come to expect from an e-store application (search features, shopping carts, etc..). if by some miracle i had a good quality and not too big (under 10k each) .jpg or .gif for each item in my inventory. would it be possible for me to some how link each of those pictures to its corresponding part in my database? this way when a customer searched for an item, a nice picture could come along with it. again, is this even possible, if so how? thanks in advance for your time and help, nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this even possible?
What I do is keep the picture url in the database with the product. Have a column named PicURL or something that just holds the location and filename of the picture. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 4:51 PM To: CF-Talk Subject: Is this even possible? Hi all, I am wondering if this will even be possible or if I just have a pie in the sky dream. Here it goes: Let's say that you have an online store with a huge inventory of products, we're talking close to 10'000 distinct items. your site has everything we have come to expect from an e-store application (search features, shopping carts, etc..). if by some miracle i had a good quality and not too big (under 10k each) .jpg or .gif for each item in my inventory. would it be possible for me to some how link each of those pictures to its corresponding part in my database? this way when a customer searched for an item, a nice picture could come along with it. again, is this even possible, if so how? thanks in advance for your time and help, nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this even possible?
We've done this on several sites by naming the images with the sku of the product. Since you'll always have the sku (product id) you can append .jpg or .gif to the end and display it. We even use thumbnails with links to the larger image by having the different size images in different directories. Not very hard at all. The only issue (of course) is storage space for the images. Judith Campbell Chief Technical Officer Digital Positions, Inc. [EMAIL PROTECTED] 404-351-9366 At 10:51 PM 12/14/00 +, you wrote: >Hi all, > >I am wondering if this will even be possible or if I just have a pie in the >sky dream. > >Here it goes: > >Let's say that you have an online store with a huge inventory of products, >we're talking close to 10'000 distinct items. your site has everything we >have come to expect from an e-store application (search features, shopping >carts, etc..). if by some miracle i had a good quality and not too big >(under 10k each) .jpg or .gif for each item in my inventory. would it be >possible for me to some how link each of those pictures to its corresponding >part in my database? this way when a customer searched for an item, a nice >picture could come along with it. > >again, is this even possible, if so how? > >thanks in advance for your time and help, > >nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this even possible?
At 10:51 PM 12/14/00 +, you wrote: >Hi all, > >I am wondering if this will even be possible or if I just have a pie in the >sky dream. > >Here it goes: > >Let's say that you have an online store with a huge inventory of products, >we're talking close to 10'000 distinct items. your site has everything we >have come to expect from an e-store application (search features, shopping >carts, etc..). if by some miracle i had a good quality and not too big >(under 10k each) .jpg or .gif for each item in my inventory. would it be >possible for me to some how link each of those pictures to its corresponding >part in my database? this way when a customer searched for an item, a nice >picture could come along with it. > >again, is this even possible, if so how? I hope I am understanding your question correctly, so if I didn't please let me know. You can put a field in the database that has the name of the image file for that product, then the search page would have a call to that image. That's pretty standard. Some people want to put the pictures in the database but that seems overly complicated to me. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this even possible?
Piece of cake, use the CFFILE to manage your image file, and use a database field as a pointer to that file (look up the CFFILE tag in your favorite book for more info). It doesn't matter too much on size of the product database. Some creative design on the directory structures can make the files more manageable if you like. I mean honestly, how do you think stores that offer gazillions of products do this in the first place? Gregory Harris Web Developer Stirling Bridge Group LLC - Original Message - From: "t nelson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 2:51 PM Subject: Is this even possible? > Hi all, > > I am wondering if this will even be possible or if I just have a pie in the > sky dream. > > Here it goes: > > Let's say that you have an online store with a huge inventory of products, > we're talking close to 10'000 distinct items. your site has everything we > have come to expect from an e-store application (search features, shopping > carts, etc..). if by some miracle i had a good quality and not too big > (under 10k each) .jpg or .gif for each item in my inventory. would it be > possible for me to some how link each of those pictures to its corresponding > part in my database? this way when a customer searched for an item, a nice > picture could come along with it. > > again, is this even possible, if so how? > > thanks in advance for your time and help, > > nelson > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this even possible?
I've done something like this with mp3 files. I store the files in a certain location and just include the file name, or path and file name, in the database. Whenever the particular mp3 is listed, I just access the file name stored in the database and set up a link. An example is here: http://www.janty.com/MYVQF/band/Default.cfm?bid=6 The download link is made of 2 parts: 1) A file name pulled from the database (6_5.mp3 in this case) 2) The path is taken from a variable that is set in the Application.cfm, though the path could be stored in the database as well. For something as heavy-duty as you are suggesting, I would reccomend putting all of your images on their own file server :) Todd Ashworth - Original Message - From: "t nelson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 5:51 PM Subject: Is this even possible? > Hi all, > > I am wondering if this will even be possible or if I just have a pie in the > sky dream. > > Here it goes: > > Let's say that you have an online store with a huge inventory of products, > we're talking close to 10'000 distinct items. your site has everything we > have come to expect from an e-store application (search features, shopping > carts, etc..). if by some miracle i had a good quality and not too big > (under 10k each) .jpg or .gif for each item in my inventory. would it be > possible for me to some how link each of those pictures to its corresponding > part in my database? this way when a customer searched for an item, a nice > picture could come along with it. > > again, is this even possible, if so how? > > thanks in advance for your time and help, > > nelson > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this even possible?
Nothing to do with CF; I built a store for a client that does this by naming the image according to the part number. E.g. 159_thumbnail.gif. It's called as IMG SRC="/thumbnails/#part_id#_thumbnail.gif". -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 2:51 PM To: CF-Talk Subject: Is this even possible? Hi all, I am wondering if this will even be possible or if I just have a pie in the sky dream. Here it goes: Let's say that you have an online store with a huge inventory of products, we're talking close to 10'000 distinct items. your site has everything we have come to expect from an e-store application (search features, shopping carts, etc..). if by some miracle i had a good quality and not too big (under 10k each) .jpg or .gif for each item in my inventory. would it be possible for me to some how link each of those pictures to its corresponding part in my database? this way when a customer searched for an item, a nice picture could come along with it. again, is this even possible, if so how? thanks in advance for your time and help, nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
how many milliseconds is too many?
Say I have a page that takes about 3,600 ms to process. Does anyone know how much traffic that page can handle before killing the server .. or at least until the app becomes unusable? Todd Ashworth ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error 37000 (anyone using SQL 7 SP2 - read!!!)
I think you got it!
I was in such a rush to fix it, I skimmed right by the correct
article. It is a "known bug" in SQL server 7 SP2. That is why it just
showed up - I recently installed SP2.
The maintanace plan wizard created a maintanace plan that puts the
database into single user mode, runs the test, corrects any errors it
finds, then removes the single user mode. If someone hits the database in
that exact moment between those last 2 steps, the table is in still single
user mode - so the command to remove single user mode can't get through.
That is also why it happens in the middle of the night:) That is when the
plan ran. For some reason, it couldn't even email me that there was a problem.
All of the tables checked out ok with a manual DBCC checkdatabase!
(And I just ordered sql 2000 because of this problem:)
thanks a million - I owe you one!
Al
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>hey Al,
>
>You might try going to the MS support site and running a query for
>single user mode...
>
>http://search.support.microsoft.com/kb/psssearch.asp?SPR=sql&T=B&KT=AL
>L&T1=7d&LQ=single+user+mode&S=F&A=T&DU=C&FR=0&D=sqlserver%2Bor%2Bodbc&
>LPR=%22SQL+Server%22&LNG=ENG&VR=http%3A%2F%2Fsupport.microsoft.com%2Fs
>upport%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fservicedesks%2Fwebcasts%
>3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fhighlights&CAT=Support&VRL=ENG&
>SA=GN
>
>which I did for you... are you doing maintenance on your DB's?
>Ton's of things might cause this.
>
>Aaron Johnson, MCSE, MCP+I
>MINDSEYE, Inc.
>617.350.0339
>617.350.8884
>66172567
>[EMAIL PROTECTED]
>
>___
>"Never forget that only dead fish swim with
>the stream." -- Malcolm Muggeridge
>___
>
>
>- -Original Message-
>From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, December 13, 2000 7:20 PM
>To: CF-Talk
>Subject: RE: ODBC Error 37000
>
>
>
>Chris,
> Wow...
>This is going to sound strange
> When I first got that message, I went into the enterprise
>manager, and strangely about 5 out of the 20 or so databases were
>in
>single user mode. I never selected single user mode in my entire
>life:)
>
> I unchecked the "single user" option, and everything was fine for
>a
>while. And I forgot about it. Today, when I first checked my email,
>I got
>4500 messages from my server saying there is a problem (When I trap a
>database error in CF, I do a cfmail to me to tell me about it)
>
>I just went back in, and 2 of the databases were in single user
>mode. One was the database for my busiest site, thethin.net.
>The other was used infrequently, so I guess it didn't trigger any
>errors.
>
>Nobody other than me has access to that server. I know I did not
>select
>single user mode.
>
>So the question is: How did it go into single user mode?
> Is there a bug in SQL Server 7.0SP2?
> Could it have been a hacker playing around with a cold fusion
>exploit in
>some way?
>
>
>thanks for the reply.. I will watch it closely.
>Al
>
>
>
> >Al,
> >
> >Go into SQLServer Enterprise Manager. Click on the entry for the
> >database, select Database Properties, go to the Options Tab and
> >deselect the Single User option.
> >
> >Chris
> >--
> >Chris Lomvardias
> >[EMAIL PROTECTED]
> >Syscom, Inc.
> >400 E. Pratt Street, Suite 300
> >Baltimore, MD 21202
> >(410)539-3737 x1722 voice
> >(410)539-7302 fax
> >[EMAIL PROTECTED] (pager via email)
> >http://www.syscom.com/
> >--
> >
> >-Original Message-
> >From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, December 13, 2000 1:41 PM
> >To: CF-Talk
> >Subject: ODBC Error 37000
> >
> >
> >
> >I have been getting this error message a lot lately.. I have no
> >idea where the problem is.
> > When it happens, I have been rebooting the cold fusion server and
> > sql 7
> >server. Then it works for a while and then stops.
> >
> >
> >ODBC Error Code = 37000 (Syntax error or access violation)
> >[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'thethin' is
> >already open and can only have one user at a time.
> >
> >
> >The most commonly executed querry is for a banner ad rotation I
> >wrote, which calls a stored procedure. I am pretty new at stored
> >procedures... so I may have blew this badly:)
> >
> >
> >
> > { call getad(#cat_id#) }
> >
> >
> >The procedure is:
> >
> >create procedure getad
> >@cat_id integer
> >as
> >begin transaction
> > declare @lastad_id int
> > declare @nextad_id int
> >declare @shown int
> >
> > set @lastad_id = (select lastad_id from category where
> > category_id =
> >@cat_id)
> > set @nextad_id = (select min(ad_link) from ad_category_link
> > where
> >((category_link = @cat_id) and (ad_link > @lastad_id)))
> > set @shown = (select shown from
RE: CF4.5.1 SP2.
When thread management gets out of control, CF can cause any web server process to hang. Just because (in this case) Inetinfo hangs doesn't mean CF can be excluded as a cause. I'm not saying it's the problem (since I know nothing about it) but I've certainly seen CF cause my web server to hang in the past for different reasons. -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 2:22 PM To: CF-Talk Subject: Re: CF4.5.1 SP2. > I am still experiencing huge memory leaks but I notice it is from > Inetinfo.exe and NOT CF. There is no doubt in my mind the CF is the > culprit, So if you've pinned it down to Inetinfo why are you blaming it on something else? Just curious what your logic is. Ken ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: TextArea for IE vs Netscape
The readonly attribute is only supported in IE (according to my documentation). I wouldn't think that it would cause problems with your page (NS should ignore it), but it could be the culprit. Bob -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: December 14, 2000 4:59 PM To: CF-Talk Subject: TextArea for IE vs Netscape Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Beware the imposter
I confess, it was Uwe who did it. ;) (Moving to Cafe 182). -Gary > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 3:45 PM > To: CF-Talk > Subject: Re: Beware the imposter > > > Todd, what if he works from an internet cafe to do this ? > And he is changing the cafes constantly ? > You simply can't find this guy ! > > Uwe > > > Mail: [EMAIL PROTECTED] > WWW: www.sdsolutions.de > - Original Message - > From: "Todd Ashworth" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, December 14, 2000 5:09 PM > Subject: Re: Beware the imposter > > > Doesn't Hotmail include the originating IP in their headers > anymore? I know > they used to. If they still do, you can just figure out their > ISP and lodge > a complaint. I'm sure you would get prompt action ;) > > Todd Ashworth > > - Original Message - > From: "Ben Forta" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, December 14, 2000 9:51 AM > Subject: OT: Beware the imposter > > > | Hi all, sorry for the OT message, but ... > | > | Some creep has set up an e-mail account "[EMAIL PROTECTED]" and is > | sending out messages pretending to be me. Not that any of you would be > | fooled by the messages (they essentially badmouth ColdFusion, > Allaire, and > | me, and the language is both immature and tasteless) but just so you > know - > | it is not me. Promise. :-) > | > | What he is doing is illegal. If any of you have any idea who > this jerk is, > | please let me know. Thanks. > | > | --- Ben > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with cachedwithin
This works: Bob -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: December 14, 2000 4:20 PM To: CF-Talk Subject: Problem with cachedwithin The following works: while the following two do not: Testing with simple outputs of #createtimespan(0,variables.timespan,0,0)#, etc. all seem to provide the same result, so why won't it work in the . I'm basing my assumption that it isn't working by the debug output that will change from saying "Cached Query" to giving a time in milliseconds. If this won't work, how else do you dynamically refresh a cached query whenever you want to? Thanks, Dan The information contained in this message is privileged and confidential. It is intended solely for the use of the named recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this transmission is strictly prohibited. If you receive this message in error, please notify the sender immediately. Thank you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAV conversion to MP3
Greg: Tell me this isn't a Cold Fusion application: http://www.rivercityhockey.net/vxml/vxml.cfm Eric From: "Greg Wolfinger" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: WAV conversion to MP3 Date: Thu, 14 Dec 2000 09:48:10 -0500 Eric: Are you lost? This is a ColdFusion mailing list. Greg - Original Message - From: "Eric Dawson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 13, 2000 5:55 PM Subject: WAV conversion to MP3 > I have been playing around with tellme.com for my rivercityhockey.net hockey > league web site. > > They have a feature where you can record a soundfile and have it post back > to the server. Pretty cool. http://www.rivercityhockey.net/voiceBook > > The sound files post in a WAV format, but I was thinking I might want to > convert to MP3 or some streaming format. Does anyone know where I could find > a little utility I could use to convert from WAV to ??? said audio format? > > Eric > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: List [Array] and Val(troubles) -> HELP!
Just out of interest, have you ever output restList?
I'm guessing your mid parameters might be wrong, in which case the ">" and "<"
might be in the list...
David Cummins
JoshMEagle wrote:
>
> I have a dilemma, any help is deeply appreciated. I've been driving myself nuts
>trying to figure out why this doesn't work.
>
> The variable restList comes from an XML file I'm parsing and contains 3 comma
>delimited numbers:
>
> 111,112,207 (or any infinite variation of numbers in comma
>delimited format)
>
> I do the following to pull the list from the XML line:
>
>
> repIDStart = #Find("", content, 1)#;
> repIDEnd = #Find("", content, repIDStart)#+11;
> repIDTotal = (repIDEnd)-(repIDStart);
> restList = #Mid(content, repIDStart, repIDTotal)#;
>
>
> I run the following loop to take each list item, convert it to a number and pass it
>to a custom tag for processing in an SQL statement that then outputs the report
>associated with that number.
>
>
>
>
>
> If I output the value of #val(trim(listitem))# in the loop, the first one is always
>0 the second is 112 and the third is 207 (or whatever numbers are in the list ...
>problem is, first is always 0)
>
> If I run IsNumeric(val(trim(listitem))) the first is NO, the second YES and the last
>is NO, but the last one still evaluates to the correct number (207,etc.)
>
> If I put a comma in FRONT of the list, they all display correctly.
>
> If there's just one number, it evaluates to 0
>
> Am I going insane or what is it I'm missing? Is there another way to turn a string
>value into a number?
>
> Joshua Miller
> Eagle Technologies Group, Inc.
> www.eagletgi.com
> [EMAIL PROTECTED]
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape refresh problem w/cf page
> >We have our home page using Cold Fusion to access dynamic data
> to update a
> >new biography displayed on the page each day.
> >
> >One minor problem we notice, only in Netscape (we use 4.04), is that when
> >you resize the screen the home page comes up blank; clicking
> reload brings
> >it back. It does not do this in IE.
> Thats a clasic netscape problem. It has nothing to do with Cold Fusion or
> your CF code. Id look directly into the javascript your using on the page.
That's correct. You're probably using a frameset, no? If so, add this
function to the frameset template between the tags:
function myResize(){
if (navigator.userAgent.indexOf("Netscape")>-1){
alert('Hey Buddy, now look what you did! If you're going to be resizing
the window all the time, at least get a decent friggin browser!')
self.location.reload();
}
}
Then in your main tag, add this:
onResize="myResize();"
Works for us. Of course, you might want to leave the alert() call out. :)
Ron Allen Hornbaker
President/CTO
Humankind Systems, Inc.
http://humankindsystems.com
mailto:[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: queries vs arrays
Thank you all for you help, you are part of what makes the CF community so great. On Wed, 13 Dec 2000 16:16:59 -0600, you wrote: >In Ben Fortas he says "ColdFusion queries are essentially arrays with >named collumns. You may therefore use any of the array functions with >queries" Does this mean ther is a way to address queries in the form >Query [row] [collumname]? I have tried and can not get it to work. > >Kevin > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
No kidding. I think Allaire could be a little embarassed about the previous CF poster child, ToysRUs. It took Amazon about 15 minutes to convert the site from Cold Fusion to their own system. Jim - Original Message - From: "Aaron Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 1:53 PM Subject: RE: Amazon using CF > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I'll give $5 to the person who can a .cfm file on Amazon.com. > > Seriously... > > > > > > Aaron Johnson, MCSE, MCP+I > Allaire Certified ColdFusion Developer > MINDSEYE, Inc. > 617.350.0339 > 617.350.8884 > 66172567 > [EMAIL PROTECTED] > > ___ > "Never forget that only dead fish swim with > the stream." -- Malcolm Muggeridge > ___ > > > - -Original Message- > From: John Grubb [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 2:11 PM > To: CF-Talk > Subject: RE: Amazon using CF > > > Yes, they do, among other languages. I have seen ".cfm" files on > their site. > > John > > - -Original Message- > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 12:32 PM > To: CF-Talk > Subject: Amazon using CF > > > Hey Guys: > > I was looking at some amazon.com source and notice quite a bit of > whitespace, resembling CF output. Does anyone know if Amazon uses CF > or > what language they do use. > > > Greg > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and SQL
Greetings again, I'm afraid I wasn't complete in my first posting. Please allow me to expand the situation. I fire off a quick query to grab the number of entries in the table. >From this number, I populate a select box based on number of entries/50=pages. Depending on the value from the select box, I need to pass two variables into the SQL statement: StartRow and EndRow. Now, the table I'm grabbing info from is constantly having entries added, deleted, and updated. So that rules out caching Also, we use OBDC drivers. The BETWEEN function sounds very much like it is a starting point. But how does one say RowNum in SQL? -Original Message- From: Todd McFarlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 10:17 AM To: CF-Talk Subject: Oracle and SQL Greetings, Being an Oracle person, I'm having a difficult time trying to make a CFQuery work correctly in SQL. The Problem: I have a database with thousands of rows. I need to select only 50 rows per query. The start row and end row need to be variables. Now, Oracle has a function called RowNum. In the Where part of a query, it allows the selection of certain rows from the table between two set paramaters...something like select rows >=50 and <=100. This yields 50 rows returned. My Question: Is there a similar function in SQL, or how is this accomplished? My thanks, Todd McFarlin Celosis, Inc. [EMAIL PROTECTED] (510) 814-3078 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ot: compound interest
does anyone know the formula for calculating compound interest? I need to figure the values of trucks on our site... it has been simple interest up until 3 days AFTER it went live... GRRR... Thanks! Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structures?????
never mid the comment last response i made... i found a problem... still working on it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 3:55 PM To: CF-Talk Subject: Structures? I'm getting frustrated with this. I want to build a structure from a query with multiple fields in each record in the structure. Then query the structure for a particular row. In other words use a structure like a DB table insert/edit/delete. I seem to be getting only one record in the structure. Anyone see what is wrong with this code?? select * from ads stads = StructNew(); stads.adID="#thequery.adID#"; stads.CDate="#thequery.CDate#"; stads.Email="#thequery.Email#"; stads.Phone="#thequery.Phone#"; stads.City="#thequery.City#"; stads.AdDesc="#thequery.AdDesc#"; stads=StructNew(); StructInsert(stads, "adID", "#thequery.adID#"); StructInsert(stads, "CDate", "#thequery.CDate#"); StructInsert(stads, "email", "#thequery.email#"); StructInsert(stads, "phone", "#thequery.phone#"); StructInsert(stads, "City", "#thequery.City#"); StructInsert(stads, "AdDesc", "#thequery.AdDesc#"); AdID is #StructFind(stads, "AdID")# CDate is #StructFind(stads, "CDate")# EMail is #StructFind(stads, "email")# Phone is #StructFind(stads, "phone")# City is #StructFind(stads, "City")# AdDesc is #StructFind(stads, "AdDesc")# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Just a stray thought
At 08:36 AM 12/13/00 -0800, you wrote: >Ok, this is meant as no shameless plug but I read on their website: > >UPS expects to receive 5 million tracking requests on their website per day >especially on their peak days (it reads something like that) > >Who's up for this? Doesn't seem like it would be that difficult. Correct database design, enough servers, tracking requests against a database shouldn't be that hard to write. Judith Campbell Chief Technical Officer Digital Positions, Inc. [EMAIL PROTECTED] 404-351-9366 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF4.5.1 SP2.
Okay. I was quick to blame Allaire and still do, albeit for a different reason.
First, we locked all the session variables
Second, we cleaned up rogue code that allowed huge record set returns on
queries.
Finally, we've watched our logs religiously and fixed any bad code that
became apparent.
So, at this point we're relatively stable, though I'm still not convinced
we're out of the woods.
Allaire has erred in judgement in their locking concept. If a variable
needs to be locked, it should be done automatically in the program and not
by putting extra code around it... that does not make sense.
Secondly, Allaire decided to allow CF to hold onto memory without release
("to build to a plateau") without the ability to control how much memory
should be retained. We should have the ability to tell the system the max
amount of memory we are willing to have the server hold without using swap
or (as was happening to us) running out of virtual memory and crashing the
server.
At 02:01 PM 12/14/00 -0500, you wrote:
>I am still experiencing huge memory leaks but I notice it is from
>Inetinfo.exe and NOT CF. There is no doubt in my mind the CF is the
>culprit, but how in the world does Allaire put out this lousy of a product
>update? This is reminiscent of Microsoft. If anyone from Allaire,
>especially their QA team is listening: GET ON THE BALL AND DO YOUR JOBS.
>
>Neil
>
>- Original Message -
>From: "Joseph Thompson" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, December 14, 2000 12:26 PM
>Subject: CYYDDD
>
>
> > I know I can hack a date of the form CYDDD (like 100235) into it's proper
> > date (08/22/2000) with the DayOfYear() function, but is there another way
> > you MS SQL guys have figured out?
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structures?????
apparently you do not need the first set of struct ure definitions... i took your code and modified to work with a table i had... worked just fine... here's the code... select * from courses CourseTitle stads=StructNew(); StructInsert(stads, "courseid", "#thequery.courseid#"); StructInsert(stads, "datecreated", "#thequery.datecreated#"); StructInsert(stads, "title", "#thequery.CourseTitle#"); StructInsert(stads, "active", "#thequery.active#"); courseid is #StructFind(stads, "courseid")# datecreated is #StructFind(stads, "datecreated")# title is #StructFind(stads, "title")# active is #StructFind(stads, "active")# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 3:55 PM To: CF-Talk Subject: Structures? I'm getting frustrated with this. I want to build a structure from a query with multiple fields in each record in the structure. Then query the structure for a particular row. In other words use a structure like a DB table insert/edit/delete. I seem to be getting only one record in the structure. Anyone see what is wrong with this code?? select * from ads stads = StructNew(); stads.adID="#thequery.adID#"; stads.CDate="#thequery.CDate#"; stads.Email="#thequery.Email#"; stads.Phone="#thequery.Phone#"; stads.City="#thequery.City#"; stads.AdDesc="#thequery.AdDesc#"; stads=StructNew(); StructInsert(stads, "adID", "#thequery.adID#"); StructInsert(stads, "CDate", "#thequery.CDate#"); StructInsert(stads, "email", "#thequery.email#"); StructInsert(stads, "phone", "#thequery.phone#"); StructInsert(stads, "City", "#thequery.City#"); StructInsert(stads, "AdDesc", "#thequery.AdDesc#"); AdID is #StructFind(stads, "AdID")# CDate is #StructFind(stads, "CDate")# EMail is #StructFind(stads, "email")# Phone is #StructFind(stads, "phone")# City is #StructFind(stads, "City")# AdDesc is #StructFind(stads, "AdDesc")# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Structures?????
Try this... I'm using your "adID" as the key to each structure row...
select *
from ads
stads = StructNew();
for (x = 1; x LTE thequery.recordcount; x = x + 1) {
curkey = thequery.adID[x];
stads.curkey.CDate="#thequery.CDate#";
stads.curkey.Email="#thequery.Email#";
stads.curkey.Phone="#thequery.Phone#";
stads.curkey.City="#thequery.City#";
stads.curkey.AdDesc="#thequery.AdDesc#";
}
That should build up your structure so you have all the rows. Then you can say
"StructDelete(stats, x)" I believe, to nuke a particular row "x".
-Original Message-
From:[EMAIL PROTECTED]
Sent:Thu, 14 Dec 2000 14:54:50 -0600
To: [EMAIL PROTECTED]
Subject: Structures?
I'm getting frustrated with this. I want to build a structure from a query with
multiple fields in each record
in the structure. Then query the structure for a particular row. In other words use a
structure like a DB
table insert/edit/delete. I seem to be getting only one record in the structure.
Anyone see what is wrong
with this code??
select *
from ads
stads = StructNew();
stads.adID="#thequery.adID#";
stads.CDate="#thequery.CDate#";
stads.Email="#thequery.Email#";
stads.Phone="#thequery.Phone#";
stads.City="#thequery.City#";
stads.AdDesc="#thequery.AdDesc#";
stads=StructNew();
StructInsert(stads, "adID", "#thequery.adID#");
StructInsert(stads, "CDate", "#thequery.CDate#");
StructInsert(stads, "email", "#thequery.email#");
StructInsert(stads, "phone", "#thequery.phone#");
StructInsert(stads, "City", "#thequery.City#");
StructInsert(stads, "AdDesc", "#thequery.AdDesc#");
AdID is #StructFind(stads, "AdID")#
CDate is #StructFind(stads, "CDate")#
EMail is #StructFind(stads, "email")#
Phone is #StructFind(stads, "phone")#
City is #StructFind(stads, "City")#
AdDesc is #StructFind(stads, "AdDesc")#
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is this even possible?
Hi all, I am wondering if this will even be possible or if I just have a pie in the sky dream. Here it goes: Let's say that you have an online store with a huge inventory of products, we're talking close to 10'000 distinct items. your site has everything we have come to expect from an e-store application (search features, shopping carts, etc..). if by some miracle i had a good quality and not too big (under 10k each) .jpg or .gif for each item in my inventory. would it be possible for me to some how link each of those pictures to its corresponding part in my database? this way when a customer searched for an item, a nice picture could come along with it. again, is this even possible, if so how? thanks in advance for your time and help, nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repopulating combo ( or select) boxes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian, Best way would be to keep the list of states in a database... and then you could have code like this: SELECT id, state FROM states SELECT first_name, last_name, stateid FROM users WHERE id = #someid# selected> Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ___ "Never forget that only dead fish swim with the stream." -- Malcolm Muggeridge ___ - -Original Message- From: Brian Ivey [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 3:48 PM To: CF-Talk Subject: Repopulating combo ( or select) boxes Dear List, I am working on a form where a user can modify their account information. This information contains their state, country, etc. You know the standard stuff. If the user was from South Carolina, I only save SC or some number representing South Carolina. Now here is my question. If I have a something like: South Carolina Georgia ... some name and I am only saving 1 for South Carolina, 2 for Georgia, etc. Is there an easy way to repopulate this data. So when I go to reload the record and I have a 1 for state. How do I easily/painlessly translate the 1 to South Carolina. The only solution I can think of takes about a million lines of code and seems very clunky. I would greatly appreciate any advice. BTW, I have looked at CFINPUT and have not yet seen how I could make it do this for me. Thanks in advance, Brian Ivey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon using CF
> I'll give $5 to the person who can a .cfm file on Amazon.com. They mask the URLs now. > > > Do you think that the largest online e-tailor wants people to know what language and app servers they use? That would aid hackers quite nicely, huh? -Greg - Original Message - From: "Aaron Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 3:53 PM Subject: RE: Amazon using CF > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I'll give $5 to the person who can a .cfm file on Amazon.com. > > Seriously... > > > > > > Aaron Johnson, MCSE, MCP+I > Allaire Certified ColdFusion Developer > MINDSEYE, Inc. > 617.350.0339 > 617.350.8884 > 66172567 > [EMAIL PROTECTED] > > ___ > "Never forget that only dead fish swim with > the stream." -- Malcolm Muggeridge > ___ > > > - -Original Message- > From: John Grubb [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 2:11 PM > To: CF-Talk > Subject: RE: Amazon using CF > > > Yes, they do, among other languages. I have seen ".cfm" files on > their site. > > John > > - -Original Message- > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 12:32 PM > To: CF-Talk > Subject: Amazon using CF > > > Hey Guys: > > I was looking at some amazon.com source and notice quite a bit of > whitespace, resembling CF output. Does anyone know if Amazon uses CF > or > what language they do use. > > > Greg > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Archiving Site built in CF
Hey everyone! I've released into beta v2 an archive site for email-lists. It started as a project just to archive my favorite lists (I hated the available search systems) and it's slowly evolving into something larger and larger. I would appreciate any feedback that you might have, and any ideas for further lists to archive! http://www.tallylist.com Stephen R. Cassady President, Ububik new media [EMAIL PROTECTED] http://www.ububik.com 403.271.0468 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Delete method
Append this javascript to the link on the main page
onclick="return confirm('Are you sure you want to delete this entry? If so
click OK, otherwise Cancel.')
jon
- Original Message -
From: "Michael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 14, 2000 3:12 PM
Subject: Delete method
> I have the following code on an action page that is being called from a
> delete reference on the main page, however I want it so that when the
> click the delete, it ask's them are they sure , absolutely sure, and
> then delete the record. Right now if I delete, it just goes, and
> deletes.I know this is'nt Rocket science but I just dont remember
> how the coding goes.
>
> TIA
>
> Michael
> password="" >
> DELETE FROM interview
> WHERE ID = #URL.DID#
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF4.5.1 SP2.
> I am still experiencing huge memory leaks but I notice it is from > Inetinfo.exe and NOT CF. There is no doubt in my mind the CF is the > culprit, So if you've pinned it down to Inetinfo why are you blaming it on something else? Just curious what your logic is. Ken ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CGI.HTTP_REFERER and SSL
Maybe you could try to capture the cgi.Server_Name or IP instead? You may also want to look at the authorizenet merchant management section though. Login and click on settings. Then select Manage URLs. You'll want to configure this area. -Gary > -Original Message- > From: Chris Montgomery [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 1:43 PM > To: CF-Talk > Subject: CGI.HTTP_REFERER and SSL > > > Howdy, > > I have a simple payment form that submits to a secure page at > AuthorizeNet. > Once a customer makes a payment, they are returned to a receipt page on my > remotely hosted site. The AuthorizeNet gateway submits transaction > information back to this receipt page using a form POST method. The form > post is originating on their secure site back to my non-secure > receipt page. > > To prevent anyone from inadvertently accessing the receipt page > (receipt.cfm) I wanted to check for the http referring page > (AuthorizeNet's > posting page) and redirect them to another page if the referrer > was anything > else. This isn't working, the #cgi.http_referer# variable comes up blank. > > Is there a known problem using cgi.http_referer when transferring requests > between secure and non-secure pages? > > TIA, > > Chris Montgomery [EMAIL PROTECTED] > > Web Development & Consulting http://www.astutia.com > Allaire Consulting Partner > 210-490-3249/888-745-7603Fax 210-490-4692 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_TwoSelectsRelated not working on one table (followup)
Hello Everyone, I wanted to give a little more information with regards to my first message about CF_TwoSelectsRelated not working on one table. I have three instances of the same code inside a CFFORM. Each is enclosed within an CFIF statement. Here is the basic form StateZip ZipCode StateCity City StateCounty County The tag looks like this: StateCounty With NAME2, DISPLAY2 and VALUE2 being "County", "City" or "Zipcode" respectively. Zipcode is the largest table followed by City, then County. City is the only one where the second value field is not generated by a selection in the first value field. All that is visible is the EMPTYTEXT2 message. Even if I remove the other two tag instances, the City tag still fails to populate the second selection field when executed. Thats about it. What can be the problem? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Beware the imposter
If you download the Hotmail message using a mail client like Outlook or Eudora, you should be able to view the header info on the first message without having to wait for a 'reply to a reply' or anything. Todd Ashworth - Original Message - From: "Michael Thomas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 3:04 PM Subject: Re: Beware the imposter | Yeah hotmail still does that. This only happens after a reply to a reply | though, at least as far as Ive ever noticed having used it for about 2 years | now. | | HTH, | Mike | | | >From: "Todd Ashworth" <[EMAIL PROTECTED]> | >Reply-To: [EMAIL PROTECTED] | >To: CF-Talk <[EMAIL PROTECTED]> | >Subject: Re: Beware the imposter | >Date: Thu, 14 Dec 2000 11:09:34 -0500 | > | >Doesn't Hotmail include the originating IP in their headers anymore? I | >know | >they used to. If they still do, you can just figure out their ISP and | >lodge | >a complaint. I'm sure you would get prompt action ;) | > | >Todd Ashworth | > | >- Original Message - | >From: "Ben Forta" <[EMAIL PROTECTED]> | >To: "CF-Talk" <[EMAIL PROTECTED]> | >Sent: Thursday, December 14, 2000 9:51 AM | >Subject: OT: Beware the imposter | > | > | >| Hi all, sorry for the OT message, but ... | >| | >| Some creep has set up an e-mail account "[EMAIL PROTECTED]" and is | >| sending out messages pretending to be me. Not that any of you would be | >| fooled by the messages (they essentially badmouth ColdFusion, Allaire, | >and | >| me, and the language is both immature and tasteless) but just so you | >know - | >| it is not me. Promise. :-) | >| | >| What he is doing is illegal. If any of you have any idea who this jerk | >is, | >| please let me know. Thanks. | >| | >| --- Ben | > | > | > | > | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help on Pulldown - Please help...getting coldfusion rage here
Just signed on. Here is a code snippet from a website we've done - hope it helps. I had trouble attempting this with cfselect tags. #cityofregistry# (#areacode#) Lonny Eckert Hesta Corporation [EMAIL PROTECTED] Hesta 610-230-2500 x147 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
TextArea for IE vs Netscape
Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Service Pack 1 or 2, or Both
I am running CF 4.5.1 Pro. I have not installed any service packs. I know there have been two service packs published by Allaire. Does SP2 encompass all that was included in SP1, or do I need to install SP1, then SP2? Thanks, Andrew C. Davis ([EMAIL PROTECTED]) TAMMIS Website Administrator / Systems Administrator Metrica, Inc. * San Antonio, TX Phone: (210) 637-4616 / (888) 567-2514 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CGI.HTTP_REFERER and SSL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris, I doubt there's an issue with the cgi.http_referer between secure & non secure.. It's just that their server (authorize.net) is doing an HTTP POST to your server... just like in a CFHTTP post, you have the option what you want to POST... I'm sure what's happening is that authorize.net is not sending the http_referrer variable as part of that post. Maybe use the CGI.REMOTE_ADDR to make sure the IP address is correct? Maybe the form variables are posted to receipt.cfm they abort or cflocate the request? Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ___ "Never forget that only dead fish swim with the stream." -- Malcolm Muggeridge ___ - -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 2:43 PM To: CF-Talk Subject: CGI.HTTP_REFERER and SSL Howdy, I have a simple payment form that submits to a secure page at AuthorizeNet. Once a customer makes a payment, they are returned to a receipt page on my remotely hosted site. The AuthorizeNet gateway submits transaction information back to this receipt page using a form POST method. The form post is originating on their secure site back to my non-secure receipt page. To prevent anyone from inadvertently accessing the receipt page (receipt.cfm) I wanted to check for the http referring page (AuthorizeNet's posting page) and redirect them to another page if the referrer was anything else. This isn't working, the #cgi.http_referer# variable comes up blank. Is there a known problem using cgi.http_referer when transferring requests between secure and non-secure pages? TIA, Chris Montgomery [EMAIL PROTECTED] Web Development & Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Beware the imposter
Todd, what if he works from an internet cafe to do this ? And he is changing the cafes constantly ? You simply can't find this guy ! Uwe Mail: [EMAIL PROTECTED] WWW: www.sdsolutions.de - Original Message - From: "Todd Ashworth" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 5:09 PM Subject: Re: Beware the imposter Doesn't Hotmail include the originating IP in their headers anymore? I know they used to. If they still do, you can just figure out their ISP and lodge a complaint. I'm sure you would get prompt action ;) Todd Ashworth - Original Message - From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 9:51 AM Subject: OT: Beware the imposter | Hi all, sorry for the OT message, but ... | | Some creep has set up an e-mail account "[EMAIL PROTECTED]" and is | sending out messages pretending to be me. Not that any of you would be | fooled by the messages (they essentially badmouth ColdFusion, Allaire, and | me, and the language is both immature and tasteless) but just so you know - | it is not me. Promise. :-) | | What he is doing is illegal. If any of you have any idea who this jerk is, | please let me know. Thanks. | | --- Ben ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alternative or Workaround to IsDefined
I guess you could just encode & escape the strings yourself. As you can see
you cannot use ' as part of a variable name nor can you use -, % etc. etc.
This might be a lil' bit time consuming but you can do something like this:
That would intially take care of the ' in the variable name & replace it
with _1. Then if you ever needed to replace the _1 back into a ', just
change the code on below inside the processing page. Now you could go on a
numbering scheme here for every invalid character so ! = _1, @ = _2, # = _3
so on & so forth.
HTH,
Mike
>From: John Stanley <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Alternative or Workaround to IsDefined
>Date: Thu, 14 Dec 2000 14:14:04 -0500
>
>I have a page that may or may not receive a variable from a referring
>template. The page is supposed to query a database and compare it's results
>to do a check with the following code:
>
> counter refers to a value that is passed regarding the total number
>of hidden fields possible
> hiddenfield(one through counter) are the actual hidden fields
>
>
>
>
>
>
> datasource="#sharecaredatasource#">
> select *
> from page_edit_settings
> where screen_id = #rpt_num#
>and objectname = '#temp_hidden#'
>
>
> ','',"all")#>
>
>
>
>
>
>
>
> more code...
>
>
>
> --- this code works fine and dandy until you introduce a weird
>character like a "-" or a single quote for the object name that is returned
>by the query. The value is getting passed as you can see below; but then
>you
>get the following error message:
>
> Parameters
>URL Parameters:
>
>HIDDENFIELD5=Mental Status'DO NOT USE
>MENTALSTATUS'DONOTUSE=on
>PHY_NME=/screens/atp/newintake.cfm
>VERIFICATIONOFPERSONCENTEREDPLANNING=on
>
>
>
>ERROR MESSAGE:
> An error occurred while evaluating the expression:
> isDefined("#temp#")
> Error near line 171, column 9.
> Parameter 1 of function IsDefined which is now
>"MentalStatus'DONOTUSE" must be a syntactically valid variable name
>
>QUESTION: Is there another function that will check for the existance of a
>variable passed through the URL that is not so restrictive in the sysntax
>it
>allows ? I need to be able to let my clients enter whatever special
>characters they need for these fields. I do not think ParameterExists will
>work because the variable temp will need to be set dynamically, and
>therefore will exist, causing the function to return true every time. I
>have
>tried urlencodedformat by addingthe following code (#urlencodedformat(temp)#>) and recieve the following error message:
>
>ERROR MESSAGE:
> An error occurred while evaluating the expression:
> isDefined("#temp#")
> Error near line 171, column 9.
> Parameter 1 of function IsDefined which is now
>"MentalStatus%27DONOTUSE" must be a syntactically valid variable name
>
> Any help would be appreciated.
>
>Thanks in advance,
>
>John Stanley
>
>
>
>
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List [Array] and Val(troubles) -> HELP!
Have you output restList to see what is in it?
In your example - 111,112,207 this is what I would
expect to see from your code:
repIDStart = 1
repIDEnd = 33 (22 + 11)
repIDTotal = 32
restList = 111,112,207", content, 1)# + 10;
repIDEnd = #Find("", content, repIDStart)#;
repIDTotal = (repIDEnd)-(repIDStart);
restList = #Mid(content, repIDStart, repIDTotal)#;
Dan
-Original Message-
From: JoshMEagle [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 2:29 PM
To: CF-Talk
Subject: List [Array] and Val(troubles) -> HELP!
I have a dilemma, any help is deeply appreciated. I've been driving myself
nuts trying to figure out why this doesn't work.
The variable restList comes from an XML file I'm parsing and contains 3
comma delimited numbers:
111,112,207 (or any infinite variation of numbers in
comma delimited format)
I do the following to pull the list from the XML line:
repIDStart = #Find("", content, 1)#;
repIDEnd = #Find("", content, repIDStart)#+11;
repIDTotal = (repIDEnd)-(repIDStart);
restList = #Mid(content, repIDStart, repIDTotal)#;
I run the following loop to take each list item, convert it to a number and
pass it to a custom tag for processing in an SQL statement that then outputs
the report associated with that number.
If I output the value of #val(trim(listitem))# in the loop, the first one is
always 0 the second is 112 and the third is 207 (or whatever numbers are in
the list ... problem is, first is always 0)
If I run IsNumeric(val(trim(listitem))) the first is NO, the second YES and
the last is NO, but the last one still evaluates to the correct number
(207,etc.)
If I put a comma in FRONT of the list, they all display correctly.
If there's just one number, it evaluates to 0
Am I going insane or what is it I'm missing? Is there another way to turn a
string value into a number?
Joshua Miller
Eagle Technologies Group, Inc.
www.eagletgi.com
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFreport and crystal reports
Lena,
I don't use cookies (they frown on that at a government site). With regards
to the "Error detected in database dll", I had the same problem. It turns
out the the User Name I specified in the "user0" parameter didn't have the
right permissions on the table. Other than that, I'm using simple cfforms to
call the reports, passing the parameters the same way as you are. I've
pasted some samples below.
HTH
Mike Hales
---
--
-Original Message-
From: Lena Trajkovska [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 3:40 AM
To: CF-Talk
Subject: RE: CFreport and crystal reports
Hi, Mike!
I had a posting a month ago about CR8 and the problems I have. You wrote
that you didn't have any problem using it, so I would like to know how you
are implementing the reports. Here is the .cfm template that I'm using to
open the report in a new window. I got the template with recrystallize. The
problem is that with CR8 - sometimes it opens, sometimes it doesn't and
gives the error "Error detected in database dll". But, even if it opens, the
cookies that I had created with the EXPIRES="NEVER" are gone. Could you,
please, tell me how you are calling the reports and have you tried this
cookie expiring thing?
Thank you in advance,
Lena Trajkovska
P.S. This code is working great with CR7, on NT4 with CF4.0.1 Enterprise,
Oracle 8.
Konten plan
function decode( valstring ) {
var resultstring = ""
for (var p=0; p < valstring.length - 1; p +=2) {
tmp = '%' + valstring.charAt(p) + valstring.charAt(p + 1)
resultstring += unescape( tmp )
}
return resultstring
}
function validateandsubmit( f ) {
document.parmform.user0.value = decode( document.parmform.user0.value )
document.parmform.password0.value = decode(
document.parmform.password0.value )
window.open( '', 'reportviewerwindow',
'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,re
sizable=yes');
document.parmform.submit()
}
Konten plan
-Original Message-
From: Hales, John M [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 17:18
To: CF-Talk
Subject: RE: CFreport and crystal reports
I could never get it to work. We just use CF to pass the parameters to
Crystal, and the CR Web Server to display the reports. That works well for
us.
HTH
Mike Hales
-Original Message-
From: Katie Bessiere [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 11:08 AM
To: CF-Talk
Subject: CFreport and crystal reports
has anyone had any luck using CFREPORT with crystal reports 8? i've tried
the workaround that Allaire recommends and I still can't get the tag to
work. It's very frustrating..
If anyone has any ideas, please let me know..
katie
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with cachedwithin
The following works: while the following two do not: Testing with simple outputs of #createtimespan(0,variables.timespan,0,0)#, etc. all seem to provide the same result, so why won't it work in the . I'm basing my assumption that it isn't working by the debug output that will change from saying "Cached Query" to giving a time in milliseconds. If this won't work, how else do you dynamically refresh a cached query whenever you want to? Thanks, Dan The information contained in this message is privileged and confidential. It is intended solely for the use of the named recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this transmission is strictly prohibited. If you receive this message in error, please notify the sender immediately. Thank you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF4.5.1 SP2.
Okay. I was quick to blame Allaire and still do, albeit for a different reason.
First, we locked all the session variables
Second, we cleaned up rogue code that allowed huge record set returns on
queries.
Finally, we've watched our logs religiously and fixed any bad code that
became apparent.
So, at this point we're relatively stable, though I'm still not convinced
we're out of the woods.
Allaire has erred in judgement in their locking concept. If a variable
needs to be locked, it should be done automatically in the program and not
by putting extra code around it... that does not make sense.
Secondly, Allaire decided to allow CF to hold onto memory without release
("to build to a plateau") without the ability to control how much memory
should be retained. We should have the ability to tell the system the max
amount of memory we are willing to have the server hold without using swap
or (as was happening to us) running out of virtual memory and crashing the
server.
At 02:01 PM 12/14/00 -0500, you wrote:
>I am still experiencing huge memory leaks but I notice it is from
>Inetinfo.exe and NOT CF. There is no doubt in my mind the CF is the
>culprit, but how in the world does Allaire put out this lousy of a product
>update? This is reminiscent of Microsoft. If anyone from Allaire,
>especially their QA team is listening: GET ON THE BALL AND DO YOUR JOBS.
>
>Neil
>
>- Original Message -
>From: "Joseph Thompson" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, December 14, 2000 12:26 PM
>Subject: CYYDDD
>
>
> > I know I can hack a date of the form CYDDD (like 100235) into it's proper
> > date (08/22/2000) with the DayOfYear() function, but is there another way
> > you MS SQL guys have figured out?
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
