Verity Office Docs
Hi All We're running CF 5 on Solaris, and for some reason Verity won't index documents of type .doc (various versions of Word), .xls and .rtf. We have included the extensions in the File Extensions field in CF Administrator, and the Verity configuration files (ie style.uni) seems to be OK. The message that appears in the CF logs is as follows: Tue Mar 05 07:21:14 2002 msg(1): WarnE2-0527 (Document Index): Document 70 (/usr/local/web/dev/section/test.doc): Stream error (299) - SKIPPING Has anyone seen this before? Thanks. - Ben. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: slooow query using JOIN
Adrian It is terrible (60 seconds) when run like this: SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table1 a LEFT OUTER JOIN table2 b ON a.id = b.id AND b.ff3 = 'T' WHERE b.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue' How about the id fields in both tables, are they indexed? Nick __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: slooow query using JOIN
Adrian, It is terrible (60 seconds) when run like this: SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table1 a LEFT OUTER JOIN table2 b ON a.id = b.id AND b.ff3 = 'T' WHERE b.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue' It may be total rubbish, but have you tried rotating the whole join? SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table2 b RIGHT OUTER JOIN table1 a ON a.id = b.id AND b.ff3 = 'T' WHERE b.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue' I may be making this up, but this way table2 is the main table, so SQL will have direct access to the dates in that table, rather than having to join everything up in order to get to b.mydate Just a thought Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
html to pdf
Can someone out there tell me where I can get a compiled version of htmldoc.exe v. 1-8-18 (ie the latest version) Much appreciated, thanks. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: html to pdf
Can someone out there tell me where I can get a compiled version of htmldoc.exe v. 1-8-18 (ie the latest version) http://www.easysw.com/htmldoc/ http://www.google.com/search?sourceid=navclientq=htmldoc Turns up loads of references for various platforms. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
getting a strange error when closing studio 4.5
Greetings, I get this error when closing studio, has anyone come accross it before, Exception EAccessViolation in module cfstudio45.exe at 000f9614. Access violation at address 004f9614 in module 'cfstudio45.exe.' Read of address 01ACC024 also on the development box some of the sites decide now and again not to allow you to login, and again some occaissions log you out mid session, this only seems to happen to the sites which have been fuseboxed, I don't understand it there is no STRUCTDELETE applied anywhere except on logout, any ideas gladly appreciated, respectfully, j __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
check for image existence
I have about 50,000 images that are displayed across the site. I'm looking for the best mechanisem to replace a non-exits image with a default file, and came across this two options. if anyone can share his experince I'll appriciate it: (All 50,000 product photos are sorted in ~ 900 directories. files are sorted using their 3 leftmost character). i.e, Product_id # 303921 will go to the dir: \303\ First option: using CF: img src=cfif FileExists(#DirMap#\#left(Product_id,3)#\#Product_id#.jpg#left(Product_id ,3)#/#Product_id#cfelsedefault/cfif.jpg Second option: using javascript: img src=#left(Product_id,3)#/#Product_id#.jpg onError=this.src='default.jpg' Maybe this figure will help out: I did a small test on a 9000 files directory: cfdirectory action=LIST directory=E:\ProductItems\303 name=LongList cfoutput query=LongList cfif FileExists(E:\Syndicate\www.ynet.co.il\home\#NAME#) #NAME#br /cfif /cfoutput This went by in 4 seconds, where while eliminative the FileExists, template was finished in 0 seconds. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: html to pdf
Thanks for this great link!!! this is very useful!! - Original Message - Wrom: SWZIDREXCAXZOWCONEUQZAAFXISHJEXXIMQZUIVOTQ To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 12:47 PM Subject: Re: html to pdf Can someone out there tell me where I can get a compiled version of htmldoc.exe v. 1-8-18 (ie the latest version) http://www.easysw.com/htmldoc/ http://www.google.com/search?sourceid=navclientq=htmldoc Turns up loads of references for various platforms. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Flash Tutorials (WAS: a little about the future)
Uhhh This message is concerning to me, being close to a lot of really wonderful Flash developers who put out a lot of educational materials. Th is message is in two parts, a list of resources on the Web you may find helpful, and 2) my own explanation of why Flash is so tough for so many. I. Resources I don't know how many times I have posted these links to this list, but i f you are looking for instructional materials on Flash, look here: www.moock.org - this is Colin Moock's site and it tells you how to do jus t about everything there is to do in Flash, gives examples, and is useful f or people at an introductory or advanced level. www.praystation.com - This is Joshua Davis's site and it is tremendous. U p until recently, there were like 50 tutorials on advanced actionscript programming, with examples, and they can still be ordered in a cool CD bo x set. Between these two sites, there is a lot to learn for someone patient enou gh to read (or look at) what is posted. However, if you find yourself in nee d of more... www.macromedia.com rules. There are tutorials, instructional materials, links to sites with the same, and answers for troubling questions. But I am stating the obvious. www.flashkit.com is an excellent resource. Many of the tutorials / articl es are a little dated, but there is some really good stuff there. The forums are a font of good advice, and whenever I have needed to have an answer t o a question the community has come through rather quickly. Also, most of the authors on the forums have their own Web sites with more tutorials that a re really excellent. You never know what you are going to get when you searc h through them, but there is always something useful. www.flashchallenge.com is sort of a clearinghouse for the avant garde, an d often features sites that, if you search around through them enough, expl ain what they did and how they did it. Take a few hours and explore this one for the tough questions. http://hotwired.lycos.com/webmonkey/multimedia/shockwave_flash/ has a lot of good resources on planning and deploying a Flash site, and has been helpf ul for me to move from a Flash designer to a Flash programmer. I always encourage people to look there before starting any significant project. www.popedeflash.com is full of tutorials and instructional materials in using the program. Flash's own documentation is worth reading, and explains how to use the program and interface. And, yes, I am a contractual Flash developer who integrates Flash Web sit es with backend systems (using CF, ASP, JSP, PHP, Perl, or anything else end ing or beginning with a P). I am available for project work and classroom-led instruction, and would be happy to consider anything anyone needs help on. There are about ten other people I know who do the same thing, so, shop around if you have needs. II. Differences Between Flash and CF There are two things I find give traditional developers trouble with Flas h: 1) The IDE and 2) the conceptual differences between Flash and Web programming. The IDE is a little obtuse in some regards; there is a timeline, there is a stage, and there is a library. Some people who have been developing in Fl ash for a while still don't get even these basic concepts, much less the fact that any code written is put into a floating actionscript window. Develop ers expect to write code, not draw funny symbols. Understanding how these fou r things interact within the IDE is not always easy for those used to studi o or dreamweaver. The conceptual differences are a little tougher. In OOP, you have objects , which have methods and properties. The same is true in Flash, the differe nce is you see the objects. To make an item an object, it must be defined as a symbol and placed in a layer. Taken a step further, an object's position within a layer affects how you can access it, and the layer itself is an object within the heirarchy. And the most chilling concept, new to anyone who has just developed for the Web, is that all of this occurs over the passage of time. You need to think about controlling the flow of events a s time goes on, and not just when the page is loaded. In DHTML, there are w ays to interact with events over the passage of time, but, for 99% of the DHT ML work actually being done, the passage of time on a page is meaningless except in regards to how long it takes to load a page. In Flash, conceptually, time is everpresent and you are always having to think abou t what came before and what is next. One other big thing that gives developers a lot of trouble, but that most developers do not currently have to worry about, is interacting with a database. It is really easy once someone know how to do it, but it is a p ain for a traditional developer in that Flash (not Flash MX) has no native ho oks to a database. Developers are dependent on a Web server to pull the information out and format it so Flash can understand it. Part of the gen ius behind
RE: check for image existence
I have a dynamic site that builds most images dynamically every evening at 12:00 pm. Because the image-building interface is so prone to error, I have to check the existence of each image prior to using them on the site. The way I do it is: 1) The is an application variable containing an array with the 'intended' name of each image and a date last updated. 2) The first time the page loads each morning after creating the images, it does a file exists on each image name (I think there are about 800 images). This executes rather quickly, less than one second. If the image does not exist, the image name is replaced with an alternate. 3) Things display as close to the way as they are intended as possible. What I have found is that fileexists() is the fastest method for checking up on whether or not the images are there. Mike -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:21 AM To: CF-Talk Subject: check for image existence I have about 50,000 images that are displayed across the site. I'm looking for the best mechanisem to replace a non-exits image with a default file, and came across this two options. if anyone can share his experince I'll appriciate it: (All 50,000 product photos are sorted in ~ 900 directories. files are sorted using their 3 leftmost character). i.e, Product_id # 303921 will go to the dir: \303\ First option: using CF: img src=cfif FileExists(#DirMap#\#left(Product_id,3)#\#Product_id#.jpg#left(Produc t_id ,3)#/#Product_id#cfelsedefault/cfif.jpg Second option: using javascript: img src=#left(Product_id,3)#/#Product_id#.jpg onError=this.src='default.jpg' Maybe this figure will help out: I did a small test on a 9000 files directory: cfdirectory action=LIST directory=E:\ProductItems\303 name=LongList cfoutput query=LongList cfif FileExists(E:\Syndicate\www.ynet.co.il\home\#NAME#) #NAME#br /cfif /cfoutput This went by in 4 seconds, where while eliminative the FileExists, template was finished in 0 seconds. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: check for image existence
The second option has to be better, since you're calling FileExists for all images whether they are there or not whereas the javascript error only triggers when there isn't one. -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: 07 March 2002 13:21 To: CF-Talk Subject: check for image existence I have about 50,000 images that are displayed across the site. I'm looking for the best mechanisem to replace a non-exits image with a default file, and came across this two options. if anyone can share his experince I'll appriciate it: (All 50,000 product photos are sorted in ~ 900 directories. files are sorted using their 3 leftmost character). i.e, Product_id # 303921 will go to the dir: \303\ First option: using CF: img src=cfif FileExists(#DirMap#\#left(Product_id,3)#\#Product_id#.jpg#left(Product_id ,3)#/#Product_id#cfelsedefault/cfif.jpg Second option: using javascript: img src=#left(Product_id,3)#/#Product_id#.jpg onError=this.src='default.jpg' Maybe this figure will help out: I did a small test on a 9000 files directory: cfdirectory action=LIST directory=E:\ProductItems\303 name=Long List cfoutput query=LongList cfif FileExists(E:\Syndicate\www.ynet.co.il\home\#NAME#) #NAME#br /cfif /cfoutput This went by in 4 seconds, where while eliminative the FileExists, template was finished in 0 seconds. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: html to pdf
Thanks, but I don't believe easysw distribute the compiled command line version of htmlDOC for free, you have to compile it yourself (which I have no idea how to do) which is why I put this request out to the list. Stephen Moretti wrote: Can someone out there tell me where I can get a compiled version of htmldoc.exe v. 1-8-18 (ie the latest version) http://www.easysw.com/htmldoc/ http://www.google.com/search?sourceid=navclientq=htmldoc Turns up loads of references for various platforms. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: check for image existence
The best way I think is to have either a boolean in the database that says there is a picture, or a field that holds the picture's filename. Either way you'll know if there's a picture or not before trying to display it. You can write a recursive script with the fileexist function to populate this data first... In the end, this is the best way. IMO. I have about 50,000 images that are displayed across the site. I'm looking for the best mechanisem to replace a non-exits image with a default file, and came across this two options. if anyone can share his experince I'll appriciate it: (All 50,000 product photos are sorted in ~ 900 directories. files are sor ted using their 3 leftmost character). i.e, Product_id # 303921 will go to th e dir: \303\ First option: using CF: img src=cfif FileExists(#DirMap#\#left(Product_id,3)#\#Product_id#.jpg#left(Product _id ,3)#/#Product_id#cfelsedefault/cfif.jpg Second option: using javascript: img src=#left(Product_id,3)#/#Product_id#.jpg onError=this.src='default.jpg' Maybe this figure will help out: I did a small test on a 9000 files directory: cfdirectory action=LIST directory=E:\ProductItems\303 name=Lo ngList cfoutput query=LongList cfif FileExists(E:\Syndicate\www.ynet.co.il\home\#NAME#) #NAME#br /cfif /cfoutput This went by in 4 seconds, where while eliminative the FileExists, templa te was finished in 0 seconds. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
VTML Builder
I am proud to announce the availability of our VTML Builder tool for both use on our site and download. Create your own ColdFusion Studio tag editors and make your custom tags more user friendly with our simple wizard style interface. http://www.smartsoftools.com/vtmlbuilder/ So, what is VTML? Its the language that all tag editors in ColdFusion studio are written in. Thanks, Sam Sam Farmer Senior Developer INTELIX, Inc. 12500 Fair Lakes Circle, Suite 150 Fairfax, VA 22033 www.intelixinc.com http://www.intelixinc.com Intelix Gains Washington TECHWAY Magazine's FAST 50 Recognition ...Debuting at #19!!! _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Session Timing out too fast
I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FoxPro General Error
Any FoxPro folks out there that can tell me why I am receiving this error? ODBC Error Code = S1000 (General error) [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ). I am not sure what function is missing. This query works fine in Access and SQL Server. SQL = SELECT DISTINCT drname.DR_ID, drname.DR_LNAME, drname.DR_FNAME, dr name.DR_INAME FROM (drname LEFT JOIN stfstatu ON drname.DR_ID = stfstatu. DR_ID) RIGHT JOIN Address ON drname.DR_ID = Address.DR_ID WHERE (((drname DR_LNAME) Like 'N%') AND ((stfstatu.DR_ID)=[drname].[dr_id]) AND ((stfst atu.ACTIVE123)='1') AND ((Address.SCH_TYPE)='1')) OR (((Address.OVERRID E)='1')) ORDER BY drname.DR_LNAME Thanks, Bruce __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Timing out too fast
Make sure that it's not set to 20 minutes in the CF Administrator . the max time in cf admin overrules anything you might have set in the application.cfm @llan -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 4:38 PM To: CF-Talk Subject: Session Timing out too fast I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Timing out too fast
The Maxmum timeout you can add to a session is set in the CFAdministrator which by default is 20 minutes... HTH -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: 07 March 2002 15:38 To: CF-Talk Subject: Session Timing out too fast I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session Timing out too fast
Check your settings in the coldfusion administrator. If its shorter(more like 20 minutes) it will override what you have in the Application.cfm template. Quoting Justin Hansen [EMAIL PROTECTED]: I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Timing out too fast
Look in the CFAdministrator ... it's defaulted to 20 minutes. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:38 AM To: CF-Talk Subject: Session Timing out too fast I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Timing out too fast - DOH!
It was the server settings. Never mind. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 9:38 AM To: CF-Talk Subject: Session Timing out too fast I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: html to pdf
Thanks, but I don't believe easysw distribute the compiled command line version of htmlDOC for free, you have to compile it yourself (which I have no idea how to do) which is why I put this request out to the list. You need Visual C++ for a windows compile. The instructions are in the downloads section. If you want a complete version of htmlDOC without compiling it yourself you'll need to pay for the support, even if you only get the 90 day Support contract. Its only $150. Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FoxPro General Error
-Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:50 AM To: CF-Talk Subject: FoxPro General Error Any FoxPro folks out there that can tell me why I am receiving this error? Unless I'm reading it wrong, you have one more ( than you have ). ODBC Error Code = S1000 (General error) [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ). I am not sure what function is missing. This query works fine in Access and SQL Server. SQL = SELECT DISTINCT drname.DR_ID, drname.DR_LNAME, drname.DR_FNAME, dr name.DR_INAME FROM (drname LEFT JOIN stfstatu ON drname.DR_ID = stfstatu. DR_ID) RIGHT JOIN Address ON drname.DR_ID = Address.DR_ID WHERE (((drname DR_LNAME) Like 'N%') AND ((stfstatu.DR_ID)=[drname].[dr_id]) AND ((stfst atu.ACTIVE123)='1') AND ((Address.SCH_TYPE)='1')) OR (((Address.OVERRID E)='1')) ORDER BY drname.DR_LNAME Thanks, Bruce __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session Timing out too fast
I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# My only guess is the CF Admin on the server must have a maximum session length set to 20 minutes. Not much fun if you've no access to the server... - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VTML Builder
I am proud to announce the availability of our VTML Builder tool for both use on our site and download. Looks great! Can you download it without filling in all that info? Pretty pointless to fill in Mailing stuff, or anything really apart from email address, if it's free. Unless you've got some ulterior motives in collecting this info ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Page name ???
What is the variable tha tI can use to call the page name I am on... I want just the name like index.cfm etc... thanks -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:39 PM To: CF-Talk Subject: Re: Adult CF hosts I join Bruce remark. adult content site might require extra bandwidth and space. you can, however - try powersurge (http://www.powersurge.net) from what I recall, they have CF and they don't have any limitation on content. HTH - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:13 PM Subject: Re: Adult CF hosts Although I do not know of any CF Hosting companies that allow adult content (never was a search criteria when looking for a host), it seems to me that since it is a sad fact that porn is one of THE biggest money makers on the net, co-location of your own server may end up paying for itself. And, you have total control of the box. Just my two cents worth. -- Original Message -- From: J B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 06 Mar 2002 13:29:33 -0500 Anyone know of, or have experience with, virtual CF hosts that allow Adult content Thanks _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Page name ???
SCRIPT_NAME Rick -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:55 AM To: CF-Talk Subject: Page name ??? What is the variable tha tI can use to call the page name I am on... I want just the name like index.cfm etc... thanks -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:39 PM To: CF-Talk Subject: Re: Adult CF hosts I join Bruce remark. adult content site might require extra bandwidth and space. you can, however - try powersurge (http://www.powersurge.net) from what I recall, they have CF and they don't have any limitation on content. HTH - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:13 PM Subject: Re: Adult CF hosts Although I do not know of any CF Hosting companies that allow adult content (never was a search criteria when looking for a host), it seems to me that since it is a sad fact that porn is one of THE biggest money makers on the net, co-location of your own server may end up paying for itself. And, you have total control of the box. Just my two cents worth. -- Original Message -- From: J B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 06 Mar 2002 13:29:33 -0500 Anyone know of, or have experience with, virtual CF hosts that allow Adult content Thanks _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Page name ???
oi Kris!! cgi.script_name ? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, March 7, 2002, 11:54:45 AM, you wrote: KP What is the variable tha tI can use to call the page name I am on... I want KP just the name like index.cfm etc... KP thanks KP -Original Message- KP From: Jason Davis [mailto:[EMAIL PROTECTED]] KP Sent: Wednesday, March 06, 2002 5:39 PM KP To: CF-Talk KP Subject: Re: Adult CF hosts KP I join Bruce remark. adult content site might require extra bandwidth and KP space. KP you can, however - try powersurge (http://www.powersurge.net) from what I KP recall, they have CF and they don't have any limitation on content. KP HTH KP - Original Message - KP From: Bruce Sorge [EMAIL PROTECTED] KP To: CF-Talk [EMAIL PROTECTED] KP Sent: Wednesday, March 06, 2002 9:13 PM KP Subject: Re: Adult CF hosts Although I do not know of any CF Hosting companies that allow adult KP content (never was a search criteria when looking for a host), it seems to me that since it is a sad fact that porn is one of THE biggest money makers on the net, co-location of your own server may end up paying for itself. And, you have total control of the box. Just my two cents worth. -- Original Message -- From: J B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 06 Mar 2002 13:29:33 -0500 Anyone know of, or have experience with, virtual CF hosts that allow Adult content Thanks _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com KP __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Page name ???
CGI.SCRIPT_NAME, but it will usually have at least a / in front. What is the variable tha tI can use to call the page name I am on... I wa nt just the name like index.cfm etc... thanks -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:39 PM To: CF-Talk Subject: Re: Adult CF hosts I join Bruce remark. adult content site might require extra bandwidth and space. you can, however - try powersurge (http://www.powersurge.net) from what I recall, they have CF and they don't have any limitation on content. HTH - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:13 PM Subject: Re: Adult CF hosts Although I do not know of any CF Hosting companies that allow adult content (never was a search criteria when looking for a host), it seems to me that since it is a sad fact that porn is one of THE biggest money makers on the net, co-location of your own server may end up paying for itself. And, you have total control of the box. Just my two cents worth. -- Original Message -- From: J B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 06 Mar 2002 13:29:33 -0500 Anyone know of, or have experience with, virtual CF hosts that allow Adult content Thanks _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Page name ???
You want the cgi.script_name variable. (Assuming you want the name of the page referenced in the URL field of the browser.) You should check out the whole set of CGI variables, as they are all very handy. Jerry Johnson [EMAIL PROTECTED] 03/07/02 11:54AM What is the variable tha tI can use to call the page name I am on... I want just the name like index.cfm etc... thanks -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:39 PM To: CF-Talk Subject: Re: Adult CF hosts I join Bruce remark. adult content site might require extra bandwidth and space. you can, however - try powersurge (http://www.powersurge.net) from what I recall, they have CF and they don't have any limitation on content. HTH - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:13 PM Subject: Re: Adult CF hosts Although I do not know of any CF Hosting companies that allow adult content (never was a search criteria when looking for a host), it seems to me that since it is a sad fact that porn is one of THE biggest money makers on the net, co-location of your own server may end up paying for itself. And, you have total control of the box. Just my two cents worth. -- Original Message -- From: J B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 06 Mar 2002 13:29:33 -0500 Anyone know of, or have experience with, virtual CF hosts that allow Adult content Thanks _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: check for image existence
Jason,
Depends on whether you want to do the work server side or client side.
Note that if you have several images on one page, the JavaScript method
can get flaky. Also note the JS method doesn't work with NS4x.
That said, the JS method is very handy when you don't have physical access
to the images. We use it extensively at http://BookCrossing.com. Since
there are lots of images on each page, we found it was better to trigger a
function on body load that loops through all the external images on the
page, and replaces those that were not loaded. (Trying to do an onError
for more than about 5 img tags on a page tends to lock up IE.)
Here is the simple, but highly effective, script:
script language=JavaScript!--
var replacementImage = new Image(60,90);
replacementImage.src = '/images/NoBookImageAvailable-60x90.gif';
function checkAllImages(){
for(i=0;idocument.images.length;i++){
//if image is from amazon, and is smaller than 30,
//it didn't load and needs replaced
if(document.images[i].src.indexOf(amazon.com)=0
parseInt(document.images[i].height)=30)
document.images[i].src=replacementImage.src
}
}
//--
/script
/head
body onLoad=checkAllImages();
Hope this helps someone... if it does, you have to go register and release
at least one book at http://BookCrossing.com now! :)
Ron Hornbaker
President/CTO
. . . . . . . . . . . . http://humankindsystems.com
. . . . . . . . . . . . w e c o d e. w e c a r e.
. email tracking and routing made easy: http://answertrack.com
-Original Message-
From: Jason Davis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 7:21 AM
To: CF-Talk
Subject: check for image existence
I have about 50,000 images that are displayed across the site.
I'm looking for the best mechanisem to replace a non-exits image
with a default file, and came across this two options. if anyone can
share his experince I'll appriciate it:
(All 50,000 product photos are sorted in ~ 900 directories.
files are sorted
using their 3 leftmost character). i.e, Product_id # 303921
will go to the
dir: \303\
First option: using CF:
img src=cfif
FileExists(#DirMap#\#left(Product_id,3)#\#Product_id#.jpg#lef
t(Product_id
,3)#/#Product_id#cfelsedefault/cfif.jpg
Second option: using javascript:
img src=#left(Product_id,3)#/#Product_id#.jpg
onError=this.src='default.jpg'
Maybe this figure will help out:
I did a small test on a 9000 files directory:
cfdirectory action=LIST directory=E:\ProductItems\303
name=LongList
cfoutput query=LongList
cfif FileExists(E:\Syndicate\www.ynet.co.il\home\#NAME#)
#NAME#br
/cfif
/cfoutput
This went by in 4 seconds, where while eliminative the
FileExists, template
was finished in 0 seconds.
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Page name ???
Thanks. Sorry I feel like its monday -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 11:54 AM To: CF-Talk Subject: Re: Page name ??? oi Kris!! cgi.script_name ? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, March 7, 2002, 11:54:45 AM, you wrote: KP What is the variable tha tI can use to call the page name I am on... KP I want just the name like index.cfm etc... KP thanks KP -Original Message- KP From: Jason Davis [mailto:[EMAIL PROTECTED]] KP Sent: Wednesday, March 06, 2002 5:39 PM KP To: CF-Talk KP Subject: Re: Adult CF hosts KP I join Bruce remark. adult content site might require extra bandwidth and KP space. KP you can, however - try powersurge (http://www.powersurge.net) from what I KP recall, they have CF and they don't have any limitation on content. KP HTH KP - Original Message - KP From: Bruce Sorge [EMAIL PROTECTED] KP To: CF-Talk [EMAIL PROTECTED] KP Sent: Wednesday, March 06, 2002 9:13 PM KP Subject: Re: Adult CF hosts Although I do not know of any CF Hosting companies that allow adult KP content (never was a search criteria when looking for a host), it seems to me that since it is a sad fact that porn is one of THE biggest money makers on the net, co-location of your own server may end up paying for itself. And, you have total control of the box. Just my two cents worth. -- Original Message -- From: J B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 06 Mar 2002 13:29:33 -0500 Anyone know of, or have experience with, virtual CF hosts that allow Adult content Thanks _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com KP __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Page name ???
if you'd rather use cold fusion instead of a CGI variable, you can use this: cfoutput#getFileFromPath(ExpandPath(*.*))#/cfoutput _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 11:55 AM To: CF-Talk Subject: Page name ??? What is the variable tha tI can use to call the page name I am on... I want just the name like index.cfm etc... thanks -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:39 PM To: CF-Talk Subject: Re: Adult CF hosts I join Bruce remark. adult content site might require extra bandwidth and space. you can, however - try powersurge (http://www.powersurge.net) from what I recall, they have CF and they don't have any limitation on content. HTH - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:13 PM Subject: Re: Adult CF hosts Although I do not know of any CF Hosting companies that allow adult content (never was a search criteria when looking for a host), it seems to me that since it is a sad fact that porn is one of THE biggest money makers on the net, co-location of your own server may end up paying for itself. And, you have total control of the box. Just my two cents worth. -- Original Message -- From: J B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 06 Mar 2002 13:29:33 -0500 Anyone know of, or have experience with, virtual CF hosts that allow Adult content Thanks _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VTML Builder
What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Gyrus wrote: I am proud to announce the availability of our VTML Builder tool for both use on our site and download. Looks great! Can you download it without filling in all that info? Pretty pointless to fill in Mailing stuff, or anything really apart from email address, if it's free. Unless you've got some ulterior motives in collecting this info ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
thanks Chuck all but it is still not working the way i envision it. any more advice on this would be great! i know i know it, just cant get it! i have tried nesting different the Current Results: Adkins , John (241) Edit Photo Adkins , John 222-223- Edit Photo Anderson , Dorman Edit Photo Anderson , Dorman 222-223- Edit Photo Appleford , Chris 222-223- Edit Photo Ayars , Daniel 222-621- What i want the Results to be: Adkins , John (241) Edit Photo 222-223- Anderson , Dorman Edit Photo 222-223- Appleford , Chris 222-223- Edit Photo Ayars , Daniel 222-621- Thank You All -paul cfquery name=Employees datasource=RPH SELECT tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY #FORM.OrderBy#, tblOffice.City, tblEmployee.EMPLOYEE_ID; /cfquery Name Extension Edit CFOUTPUT QUERY=Employees GROUP=StudioName Office - Studio #Employees.City# - #Employees.StudioName# cfoutput #Employees.LastName#, #Employees.FirstName# #Employees.PhoneNumb# Edit Photo form action=Emp_Delete.cfm method=post name=D_Emp INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfif input type=hidden name=EmployeeID value=#Employees.EmployeeID# cfif #Employees.Status# EQ 0 input type=submit value=check to hide user cfelseinput type=submit value=un-check to show user /cfif/form /cfoutput /cfoutput __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
- Order your query by employee ID. - cfoutput the query and cfabort to verify you are in fact getting an ordered recordset. - cfoutput the query grouping by employee ID In your example, your ORDER BY in the query is not by employee ID. You have to order by employee ID to get your desired output, otherwise it won't work at all. Adam. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 11:23 AM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart thanks Chuck all but it is still not working the way i envision it. any more advice on this would be great! i know i know it, just cant get it! i have tried nesting different the Current Results: Adkins , John (241) Edit Photo Adkins , John 222-223- Edit Photo Anderson , Dorman Edit Photo Anderson , Dorman 222-223- Edit Photo Appleford , Chris 222-223- Edit Photo Ayars , Daniel 222-621- What i want the Results to be: Adkins , John (241) Edit Photo 222-223- Anderson , Dorman Edit Photo 222-223- Appleford , Chris 222-223- Edit Photo Ayars , Daniel 222-621- Thank You All -paul cfquery name=Employees datasource=RPH SELECT tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY #FORM.OrderBy#, tblOffice.City, tblEmployee.EMPLOYEE_ID; /cfquery Name Extension Edit CFOUTPUT QUERY=Employees GROUP=StudioName Office - Studio #Employees.City# - #Employees.StudioName# cfoutput #Employees.LastName#, #Employees.FirstName# #Employees.PhoneNumb# Edit Photo form action=Emp_Delete.cfm method=post name=D_Emp INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfif input type=hidden name=EmployeeID value=#Employees.EmployeeID# cfif #Employees.Status# EQ 0 input type=submit value=check to hide user cfelseinput type=submit value=un-check to show user /cfif/form /cfoutput /cfoutput __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Automated Tasks
I'm having a tough time working with Automated Tasks on the CF server. Wondering if anybody has any kind of great tutorials or references on using Automated Tasks, if so can you send me the links. Thanks Jason Larson __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
I'm not quite sure exaclt what you want but if you want to display the name only once, then all of the phone numbers that are associated with it, then you need multiple grouping values: CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo ... /cfoutput /cfoutput /cfoutput I think one of your problems is tha fact that firstname and lastname are separate values. Try combining them into a single field for sorting purposes: tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, This works in access, I'm not quite sure about your db. You need to also sort the records appropriately. This step is not required, but if you don't do it, then your output will not format properly. ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; I hope some of this helps. - Matt Small cfquery name=Employees datasource=RPH SELECT tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; /cfquery Name Extension Edit CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo form action=Emp_Delete.cfm method=post name=D_Emp INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfif input type=hidden name=EmployeeID value=#Employees.EmployeeID# cfif #Employees.Status# EQ 0 input type=submit value=check to hide user cfelseinput type=submit value=un-check to show user /cfif/form /cfoutput /cfoutput /cfoutput __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
Since cfoutput creates the table one row at a time as each query row is output, wouldn't it be possible to put a cfif statement in the cfoutput to set first and last name to blank if they already exist? -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:23 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart thanks Chuck all but it is still not working the way i envision it. any more advice on this would be great! i know i know it, just cant get it! i have tried nesting different the Current Results: Adkins , John (241) Edit Photo Adkins , John 222-223- Edit Photo Anderson , Dorman Edit Photo Anderson , Dorman 222-223- Edit Photo Appleford , Chris 222-223- Edit Photo Ayars , Daniel 222-621- What i want the Results to be: Adkins , John (241) Edit Photo 222-223- Anderson , Dorman Edit Photo 222-223- Appleford , Chris 222-223- Edit Photo Ayars , Daniel 222-621- Thank You All -paul cfquery name=Employees datasource=RPH SELECT tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY #FORM.OrderBy#, tblOffice.City, tblEmployee.EMPLOYEE_ID; /cfquery Name Extension Edit CFOUTPUT QUERY=Employees GROUP=StudioName Office - Studio #Employees.City# - #Employees.StudioName# cfoutput #Employees.LastName#, #Employees.FirstName# #Employees.PhoneNumb# Edit Photo form action=Emp_Delete.cfm method=post name=D_Emp INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfif input type=hidden name=EmployeeID value=#Employees.EmployeeID# cfif #Employees.Status# EQ 0 input type=submit value=check to hide user cfelseinput type=submit value=un-check to show user /cfif/form /cfoutput /cfoutput __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
Need to use cfloop you can't nest cfoutputs. Dave -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:54 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart I'm not quite sure exaclt what you want but if you want to display the name only once, then all of the phone numbers that are associated with it, then you need multiple grouping values: CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo ... /cfoutput /cfoutput /cfoutput I think one of your problems is tha fact that firstname and lastname are separate values. Try combining them into a single field for sorting purposes: tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, This works in access, I'm not quite sure about your db. You need to also sort the records appropriately. This step is not required, but if you don't do it, then your output will not format properly. ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; I hope some of this helps. - Matt Small cfquery name=Employees datasource=RPH SELECT tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; /cfquery Name Extension Edit CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo form action=Emp_Delete.cfm method=post name=D_Emp INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfif input type=hidden name=EmployeeID value=#Employees.EmployeeID# cfif #Employees.Status# EQ 0 input type=submit value=check to hide user cfelseinput type=submit value=un-check to show user /cfif/form /cfoutput /cfoutput /cfoutput __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfgrid and CF5
has anyone gotten CFGrid to work in CF5 (win2k server) I keep getting an error load: class allaire.controls2.CFGridApplet.class not found. now I searched on the server and can't even find that class... I also have the CFIDE dir as a virtual dir under the site that needs to use CFGrid and gave IUSR read permissions but still that error persists... is there even such a file with CF5? has anyone been able to get CFGrid to work? ~~ Stephenie __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slow CF response times?
sorry for long response time... A primary key IS a unique index, and yes - as far as I know a primary key/unique index is safe. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Chuck McElwee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 5:27 PM To: CF-Talk Subject: RE: Slow CF response times? Is it safe to make it a unique index? Or do you recommend simply making the cfid column a primary key? ColdFusion Administrator seems to simply create a table without a key. - Chuck -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 7:35 PM To: CF-Talk Subject: RE: Slow CF response times? You shouldn't ever use the registry as your client storage mechanism!!! The registry is used by the operating system and clogging it up often has serious repurcussions. I've seen systems go down because of this! If you want to speed things up in the DB you can do two things... 1. Create and index on the CFID column for both tables (CGLOBAL and CDATA). The query currently does a table scan to find the needed info 2. Make sure that Maintain Connection is checked for the DB you are using for client storage. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 3:57 PM To: CF-Talk Subject: RE: Slow CF response times? Robert, you da man. I sit corrected - we were using SQL Server 2000 for client storage. I switched to registry storage as an experiment, and it s ped right up. Did you just create a new client var store, or actually reinstall SQL Server...? -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 3:28 PM To: CF-Talk Subject: RE: Slow CF response times? I had this problem when I used client management with an external databas e. I reinstalled the database and it made the response time what I expected. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:20 PM To: CF-Talk Subject: Slow CF response times? Hi all, I'm getting slow response times from CFM templates on a production server. Many of these templates execute in 150 ms or less on our dev server, and asp and .htm templates on the production server are showing up just fine. If you want to experiment, go to: http://winpisinger.iamaw.org - that's a .html page. Then go to: http://winpisinger.iamaw.org/home.cfm See the difference? What's weird is that home.cfm doesn't do ANY CF processing. It's just an experiment to try to figure out why the server's so slow? The server is a dual processor Pentium III with 1024 meg of RAM, so traff ic isn't the issue, either... Any ideas? Thanks, Ian Portent Interactive Using Process, Design and Content to create great web sites since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
[OT] Re: VTML Builder
What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Maybe I'm being too cynical, but to me *spam* makes the difference. I was just looking for some assurance that the download is actually *free*, and not paid for by allowing the people you give your info to to sell that info on for marketing (I couldn't see any assurance on the site). BTW, it would have been faster for you to not criticise my questioning than to do so (nod to Bill Hicks ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Oracle and Excel
There is a programmer who is trying to do the following: export data to a workbook in excel using OLE alter cell data on the fly save the current workbook What is the command he needs to send through OLE to save the workbook without overwriting it? I don't have a code snippet. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
Dave, you can absolutely nest cfoutputs if you use the group attribute. This is a nice feature of Cold Fusion that allows reports to made without a lot of logic involved. Consider: cfset currentname= cfoutput query=somequery cfif currentname neq namehr#name#Br/cfif #phonenumber#br /cfoutput The same thing using nested cfoutputs: cfoutput query=somequery group=name #name#br cfoutput #phonenumber#br /cfoutput hr /cfoutput The first produces: --- Dave Bosky 843-444- 843-555- --- Matthew Small 843-111- 843-222- 843-333- The second produces: Without the top hr Dave Bosky 843-444- 843-555- --- Matthew Small 843-111- 843-222- 843-333- --- If you have a properly designed query: cfquery name=somequery datasource=dsource select name, number from table order by name, number /cfquery You get this returned set of data: Dave Bosky 843-444- Dave Bosky 843-555- Matthew Small 843-111- Matthew Small 843-222- Matthew Small 843-333- - Matt Small -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:28 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart Need to use cfloop you can't nest cfoutputs. Dave -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:54 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart I'm not quite sure exaclt what you want but if you want to display the name only once, then all of the phone numbers that are associated with it, then you need multiple grouping values: CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo ... /cfoutput /cfoutput /cfoutput I think one of your problems is tha fact that firstname and lastname are separate values. Try combining them into a single field for sorting purposes: tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, This works in access, I'm not quite sure about your db. You need to also sort the records appropriately. This step is not required, but if you don't do it, then your output will not format properly. ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; I hope some of this helps. - Matt Small cfquery name=Employees datasource=RPH SELECT tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; /cfquery Name Extension Edit CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo form action=Emp_Delete.cfm method=post name=D_Emp INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfif input type=hidden name=EmployeeID value=#Employees.EmployeeID# cfif #Employees.Status# EQ 0 input type=submit value=check to hide user cfelseinput type=submit value=un-check to show user /cfif/form /cfoutput /cfoutput /cfoutput __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfgrid and CF5
You need to copy the cfide directory into your virtual webserver directory so that it can load the applet. I ran into this a couple of weeks ago. - Matt Small -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:55 PM To: CF-Talk Subject: cfgrid and CF5 has anyone gotten CFGrid to work in CF5 (win2k server) I keep getting an error load: class allaire.controls2.CFGridApplet.class not found. now I searched on the server and can't even find that class... I also have the CFIDE dir as a virtual dir under the site that needs to use CFGrid and gave IUSR read permissions but still that error persists... is there even such a file with CF5? has anyone been able to get CFGrid to work? ~~ Stephenie __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
My bad I didn't notice the group attribute in the second cfoutput. Dave -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:02 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart Dave, you can absolutely nest cfoutputs if you use the group attribute. This is a nice feature of Cold Fusion that allows reports to made without a lot of logic involved. Consider: cfset currentname= cfoutput query=somequery cfif currentname neq namehr#name#Br/cfif #phonenumber#br /cfoutput The same thing using nested cfoutputs: cfoutput query=somequery group=name #name#br cfoutput #phonenumber#br /cfoutput hr /cfoutput The first produces: --- Dave Bosky 843-444- 843-555- --- Matthew Small 843-111- 843-222- 843-333- The second produces: Without the top hr Dave Bosky 843-444- 843-555- --- Matthew Small 843-111- 843-222- 843-333- --- If you have a properly designed query: cfquery name=somequery datasource=dsource select name, number from table order by name, number /cfquery You get this returned set of data: Dave Bosky 843-444- Dave Bosky 843-555- Matthew Small 843-111- Matthew Small 843-222- Matthew Small 843-333- - Matt Small -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:28 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart Need to use cfloop you can't nest cfoutputs. Dave -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:54 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart I'm not quite sure exaclt what you want but if you want to display the name only once, then all of the phone numbers that are associated with it, then you need multiple grouping values: CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo ... /cfoutput /cfoutput /cfoutput I think one of your problems is tha fact that firstname and lastname are separate values. Try combining them into a single field for sorting purposes: tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, This works in access, I'm not quite sure about your db. You need to also sort the records appropriately. This step is not required, but if you don't do it, then your output will not format properly. ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; I hope some of this helps. - Matt Small cfquery name=Employees datasource=RPH SELECT tblEmployee.Lastname ' ' tblEmployee.Firstname as Fullname, tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY tblOffice.City, Fullname, tblEmployee.EMPLOYEE_ID; /cfquery Name Extension Edit CFOUTPUT QUERY=Employees GROUP=city Office - Studio #Employees.City# - #Employees.StudioName# cfoutput group=fullname #Employees.LastName#, #Employees.FirstName# cfoutput #Employees.PhoneNumb# Edit Photo form action=Emp_Delete.cfm method=post name=D_Emp INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfif input type=hidden name=EmployeeID value=#Employees.EmployeeID# cfif #Employees.Status# EQ 0 input type=submit value=check to hide user cfelseinput type=submit value=un-check to show user /cfif/form /cfoutput /cfoutput /cfoutput __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup
Re: cfgrid and CF5
I use CFGrid constantly, however, I am on a shared server hosting situation (at CrystalTech), and for any domain I am going to use it, I must first get them to make me a virtual directory to the class files so that they can be called by my tags. Hope this is of some help. -James Edmunds Stephenie Hamilton wrote: has anyone gotten CFGrid to work in CF5 (win2k server) I keep getting an error load: class allaire.controls2.CFGridApplet.class not found. now I searched on the server and can't even find that class... I also have the CFIDE dir as a virtual dir under the site that needs to use CFGrid and gave IUSR read permissions but still that error persists... is there even such a file with CF5? has anyone been able to get CFGrid to work? ~~ Stephenie __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfgrid and CF5
There's a good amount of info on this in the macromedia cf support forum, so I won't go into the nitty gritties until you read all the mess about it there. We just gave up and decided to place the class directly into each directory where we run it and we have to go to the user's machine and install the JVM manually most times. This is okay because we're only using it in a few places. Most of our problems came from the JVM not loading, when we upgraded. I can tell you this, however ... I won't ever be using the CFGrid function again. What a mess. http://webforums.macromedia.com/coldfusion/messageview.cfmcatid=3threadid=2 34364highlight_key=ykeyword1=cfgridkeyword2=class (watch for wrapping on the URL above) Best wishes, ~Val - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 1:54 PM Subject: cfgrid and CF5 has anyone gotten CFGrid to work in CF5 (win2k server) I keep getting an error load: class allaire.controls2.CFGridApplet.class not found. now I searched on the server and can't even find that class... I also have the CFIDE dir as a virtual dir under the site that needs to use CFGrid and gave IUSR read permissions but still that error persists... is there even such a file with CF5? has anyone been able to get CFGrid to work? ~~ Stephenie __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Intranet apps
Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Intranet apps
here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people invite the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make the schedule visible to all. There are a few sites that have data feeds of info that you can legally post on your own site. You want to look at www.moreover.com. You can use cfhttp to get the info. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:30 PM To: CF-Talk Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Group in cfoutput query. brain fart
Mathew all thank you! got me back on track! thank you! what i did below. -paul cfquery name=Employees datasource=RPH SELECT tblEmployee.Lastname + ' ' + tblEmployee.Firstname as Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY tblStudio.StudioName, Fullname, tblEmployee.EMPLOYEE_ID; /cfquery cfinclude template=../top.cfm table border=1 align=left cellspacing=0 cellpadding=0 tr td align=center valign=topbEmployee Admin Page/b/td /tr tr td align=center valign=topa href=Emp_Form.cfmAdd an Employee/a :: a href=../Picture_Board/Default.cfmSearch the Picture Board!/a/td /tr tr td table border=1 cellpadding=0 cellspacing=0 tr valign=top align=center tdbName/b/td tdbExtension/b/td td colspan=3bEdit/b/td /tr CFOUTPUT QUERY=Employees GROUP=StudioName tr td colspan=5 align=center valign=topa href=Emp_Form.cfmAdd an Employee/a :: a href=../Picture_Board/Default.cfmSearch the Picture Board!/a/td /tr tr valign=top align=center bgcolor=##33 td colspan=2bfont color=##FFOffice - Studio/font/b/td td colspan=3bfont color=##FF#Employees.City# - a href=../Picture_Board/Emp_Studio_Browse.cfm?StudioID=#StudioID# style=color: White;#Employees.StudioName#/A/font/b/td /tr tr valign=middle cfoutput group=fullname tdB#Employees.Fullname#/td tdcfoutput#Employees.PhoneNumb#br/cfoutput /td td align=justify A HREF=Emp_Form.cfm?EmployeeID=#Employees.EmployeeID#Edit/A/td td align=justify A HREF=Emp_Photo2.cfm?EmployeeId=#Employees.EmployeeId#Photo/A/td form action=Emp_Delete.cfm method=post name=D_Emp td align=justify INPUT TYPE=checkbox NAME=Status VALUE=Yes cfif (# LSNumberFormat(Employees.Status) # EQ 1)CHECKED/cfifinput type=hidden name=EmployeeID value=#Employees.EmployeeID#cfif #Employees.Status# EQ 0input type=submit value=check to hide usercfelseinput type=submit value=un-check to show user/cfif/td/form /tr /cfoutput /cfoutput /table /td /tr tr td align=center valign=topA HREF=Emp_Form.cfmAdd an Employee/A :: a href=../Picture_Board/Default.cfmSearch the Picture Board!/a/td /tr /table __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Intranet apps
our VICO suite of applications provide that (which is actually a very small part of the general functionality of the suite). If you need more information you can contact me off line. thank you Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Bruce Holm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 2:29 PM Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT:Stored Procedure
I have a report that has 6 queries to gather all the info from the related tables. I am in the process of turning these cfquerys into stored procedures (SQL2000). In CF I have things like CFQUERY name=Q1 SELECT blah,blah FROM SCHOOLS WHERE SchoolID=#SchoolID# CFQUERY name=Q2 SELECT * FROM STUDENTS WHERE SchoolID=#SchoolID# AND gradeID=#gradeID# CFSET StudentID=Q2.StudentID CFQUERY NAME=Q3 SELECT * FROM GRADES WHERE StudentID=#StudentID# So query1 gets the schoolid- query2 gets all the students with that schoolid/gradeID and then query3 is getting the grades for those students. I'm wondering how to do this in stored procedures. I've always learned to keep the sp small so they can be reused. I was also told that one stored procedure can call another- so I guess I was wondering if one stored procedure can pass a parameter to the next. (ie: so it knows what students to pull grades for) If this is possible where or how would I put it in the stored procedure? ie: one sp would be: CREATE PROCEDURE GetSchools SchoolID int, GradeLevel int AS SELECT * FROM Students WHERE SchoolID=@SchoolID AND GradeLevel=@GradeLevel GO So how would I filter the StudentId from this stored procedure to put in the next stored procedure: CREATE PROCEDURE GetReportCardMarks StudentID int AS SELECT Skill, StudentID, Grade, SchoolID FROM Grades WHERE StudentID=@StudentID GO I hope I explained this sufficiently. Thanks in advance, __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Intranet apps
I was looking for a conference room signup app only. This would be a corporate wide, web browser accessible application. Outlook requires LDA P I believe and our company does not plan to run or support it. (Don't ask wh y) For weather I'm aware of AccuWeather data feed in XML format but not sure what they would charge. I was hoping for a free app I could integrate in to the home page that shows current weather conditions for a local city, lik e MyExite or MyLycos offers. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:37 AM Subject: RE: Intranet apps here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people invite the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make the schedule visible to all. There are a few sites that have data feeds of info that you can legally post on your own site. You want to look at www.moreover.com. You can use cfhttp to get the info. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:30 PM To: CF-Talk Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT:Stored Procedure
Use Books online and read about declaring variables. On Thu, 07 March 2002, Janine Jakim wrote: I have a report that has 6 queries to gather all the info from the related tables. I am in the process of turning these cfquerys into stored procedures (SQL2000). In CF I have things like CFQUERY name=Q1 SELECT blah,blah FROM SCHOOLS WHERE SchoolID=#SchoolID# CFQUERY name=Q2 SELECT * FROM STUDENTS WHERE SchoolID=#SchoolID# AND gradeID=#gradeID# CFSET StudentID=Q2.StudentID CFQUERY NAME=Q3 SELECT * FROM GRADES WHERE StudentID=#StudentID# So query1 gets the schoolid- query2 gets all the students with that schoolid/gradeID and then query3 is getting the grades for those students. I'm wondering how to do this in stored procedures. I've always learned to keep the sp small so they can be reused. I was also told that one stored procedure can call another- so I guess I was wondering if one stored procedure can pass a parameter to the next. (ie: so it knows what students to pull grades for) If this is possible where or how would I put it in the stored procedure? ie: one sp would be: CREATE PROCEDURE GetSchools SchoolID int, GradeLevel int AS SELECT * FROM Students WHERE SchoolID=@SchoolID AND GradeLevel=@GradeLevel GO So how would I filter the StudentId from this stored procedure to put in the next stored procedure: CREATE PROCEDURE GetReportCardMarks StudentID int AS SELECT Skill, StudentID, Grade, SchoolID FROM Grades WHERE StudentID=@StudentID GO I hope I explained this sufficiently. Thanks in advance, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Intranet apps
Weather cfset attributes.zipcode = 32714 CFHTTP URL=http://www.weather.com/weather/tendayprint/#Attributes.ZipCode#; METHOD=GET PORT=80 RESOLVEURL=true cfset OutPut = Replace(CFHTTP.FileContent, HREF=/, HREF=http://www.weather.com/;, ALL) CFOUTPUT#OutPut#/CFOUTPUT Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:00 PM To: CF-Talk Subject: Re: Intranet apps I was looking for a conference room signup app only. This would be a corporate wide, web browser accessible application. Outlook requires LDA P I believe and our company does not plan to run or support it. (Don't ask wh y) For weather I'm aware of AccuWeather data feed in XML format but not sure what they would charge. I was hoping for a free app I could integrate in to the home page that shows current weather conditions for a local city, lik e MyExite or MyLycos offers. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:37 AM Subject: RE: Intranet apps here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people invite the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make the schedule visible to all. There are a few sites that have data feeds of info that you can legally post on your own site. You want to look at www.moreover.com. You can use cfhttp to get the info. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:30 PM To: CF-Talk Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_SAVECONTENT
For those of you interested, I have created a custom tag that simulates the functionallity of the CFSAVECONTENT tag from CF 5, however this custom tag works in CF 4 and up! Let me know if you would like me to send you a copy. Thanks! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Intranet apps
Bruce, FYI - AccuWeather is about $25 a month. We used them recently and found it to be useful, but if you can get it for free. . . Not a hard choice then. HTH, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:00 PM To: CF-Talk Subject: Re: Intranet apps I was looking for a conference room signup app only. This would be a corporate wide, web browser accessible application. Outlook requires LDA P I believe and our company does not plan to run or support it. (Don't ask wh y) For weather I'm aware of AccuWeather data feed in XML format but not sure what they would charge. I was hoping for a free app I could integrate in to the home page that shows current weather conditions for a local city, lik e MyExite or MyLycos offers. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT:Stored Procedure
I keep saying this, there is an excellent book which covers all this in detail and more, http://www.amazon.com/exec/obidos/ASIN/1893115836/qid=1015531831/s=2-2/re= sr_2_2/103-3058344-6479802 my head is full of coffee, I'm buzzin, sure I'd love to post the code but I'd have to work it out first,and my head is buzzin, Hal helms developed a good stored proc tool which writes out stored procs for time is an issue developer, I emailed him off list, he sent it to me and I installed it in studio, then I opened it and it said if you don't have a thuru knowledge of SP's then your cheating yourself, so I closed it down, and got the book, I'm no whizz, but I've got a strong grasp of the basics, sorry to be of absolutely no help, grow a conscience and redirect you to a book, J -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:00 PM To: CF-Talk Subject: Re: OT:Stored Procedure Use Books online and read about declaring variables. On Thu, 07 March 2002, Janine Jakim wrote: I have a report that has 6 queries to gather all the info from the related tables. I am in the process of turning these cfquerys into stored procedures (SQL2000). In CF I have things like CFQUERY name=Q1 SELECT blah,blah FROM SCHOOLS WHERE SchoolID=#SchoolID# CFQUERY name=Q2 SELECT * FROM STUDENTS WHERE SchoolID=#SchoolID# AND gradeID=#gradeID# CFSET StudentID=Q2.StudentID CFQUERY NAME=Q3 SELECT * FROM GRADES WHERE StudentID=#StudentID# So query1 gets the schoolid- query2 gets all the students with that schoolid/gradeID and then query3 is getting the grades for those students. I'm wondering how to do this in stored procedures. I've always learned to keep the sp small so they can be reused. I was also told that one stored procedure can call another- so I guess I was wondering if one stored procedure can pass a parameter to the next. (ie: so it knows what students to pull grades for) If this is possible where or how would I put it in the stored procedure? ie: one sp would be: CREATE PROCEDURE GetSchools @SchoolID int, @GradeLevel int AS SELECT * FROM Students WHERE SchoolID=@SchoolID AND GradeLevel=@GradeLevel GO So how would I filter the StudentId from this stored procedure to put in the next stored procedure: CREATE PROCEDURE GetReportCardMarks @StudentID int AS SELECT Skill, StudentID, Grade, SchoolID FROM Grades WHERE StudentID=@StudentID GO I hope I explained this sufficiently. Thanks in advance, __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Intranet apps
cfset attributes.zipcode = 32714 What if its the UK, or somewhere else that the US? -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:05 PM To: CF-Talk Subject: RE: Intranet apps Weather cfset attributes.zipcode = 32714 CFHTTP URL=http://www.weather.com/weather/tendayprint/#Attributes.ZipCode#; METHOD=GET PORT=80 RESOLVEURL=true cfset OutPut = Replace(CFHTTP.FileContent, HREF=/, HREF=http://www.weather.com/;, ALL) CFOUTPUT#OutPut#/CFOUTPUT Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:00 PM To: CF-Talk Subject: Re: Intranet apps I was looking for a conference room signup app only. This would be a corporate wide, web browser accessible application. Outlook requires LDA P I believe and our company does not plan to run or support it. (Don't ask wh y) For weather I'm aware of AccuWeather data feed in XML format but not sure what they would charge. I was hoping for a free app I could integrate in to the home page that shows current weather conditions for a local city, lik e MyExite or MyLycos offers. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:37 AM Subject: RE: Intranet apps here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people invite the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make the schedule visible to all. There are a few sites that have data feeds of info that you can legally post on your own site. You want to look at www.moreover.com. You can use cfhttp to get the info. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:30 PM To: CF-Talk Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Intranet apps
Man oh man, I can't win today, you give something for free and people just want more and more and more I think you could figure out the US part. UK I don't deal with. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:20 PM To: CF-Talk Subject: RE: Intranet apps cfset attributes.zipcode = 32714 What if its the UK, or somewhere else that the US? -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:05 PM To: CF-Talk Subject: RE: Intranet apps Weather cfset attributes.zipcode = 32714 CFHTTP URL=http://www.weather.com/weather/tendayprint/#Attributes.ZipCode#; METHOD=GET PORT=80 RESOLVEURL=true cfset OutPut = Replace(CFHTTP.FileContent, HREF=/, HREF=http://www.weather.com/;, ALL) CFOUTPUT#OutPut#/CFOUTPUT Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:00 PM To: CF-Talk Subject: Re: Intranet apps I was looking for a conference room signup app only. This would be a corporate wide, web browser accessible application. Outlook requires LDA P I believe and our company does not plan to run or support it. (Don't ask wh y) For weather I'm aware of AccuWeather data feed in XML format but not sure what they would charge. I was hoping for a free app I could integrate in to the home page that shows current weather conditions for a local city, lik e MyExite or MyLycos offers. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:37 AM Subject: RE: Intranet apps here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people invite the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make the schedule visible to all. There are a few sites that have data feeds of info that you can legally post on your own site. You want to look at www.moreover.com. You can use cfhttp to get the info. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:30 PM To: CF-Talk Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Maybe I'm being too cynical, but to me *spam* makes the difference. I was just looking for some assurance that the download is actually *free*, and not paid for by allowing the people you give your info to to sell that info on for marketing (I couldn't see any assurance on the site). BTW, it would have been faster for you to not criticise my questioning than to do so (nod to Bill Hicks ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Flash Tutorials (WAS: a little about the future)
Thanks for your post Michael. I'm sorry but I haven't seen your list of resources before, and I'll check them out over the next few days. (I sometimes get as many as 800 messages a day and I can't read everything on this list under those conditions) I have to tell you I am really struggling with Flash, but I'll crash through sooner or later. For example yesterday I went to flashkit.com and I can see there is a lot of interesting material there. I looked at one tutorial, and downloaded the example code to go through the tutorial as I read it, and the zip file didn't have a .fla file inside. So the tutorial was useless. I looked at another, and it missed out 3 steps, rushing over some other steps. No problem I suppose for the person who wrote it, or for advanced users, but I spent over an hour trying to figure out how to put a piece of code on a button. I couldn't see where to put it, and couldn't get the code window to open. People who have done a few of these things will know how to do it. But I deliberately chose a tutorial there that was labelled for BEGINNERS. For me, learning from the very start, this simple thing was extremely frustrating. I was screaming at the author that he spent 2 paragraphs explaining how to open a file, but totally missed these steps. The total text for getting the code onto this button was Put this code on your button ... What I find really confusing when I'm using flash is there are so many dialogue boxes, that I take ages to find things. I can never seem to be able to find things in the same place twice. It's not helped I suppose that the dialogs change depending on what kind of object is opening them, and what the circumstances are at the time. I know the problem is mine, that I have to just learn where everything is, but its taking much much longer than it took to get something productive happening in coldfusion, and a whole order of magnitude longer than learning Photoshop or Illustrator or Fireworks or Dreamweaver. Anyway, I really value the advice and help of the people on this list, and Michael's list of sites looks to be well worth checking out. Thank you Michael. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 12:50 AM To: CF-Talk Subject: RE: Flash Tutorials (WAS: a little about the future) Uhhh This message is concerning to me, being close to a lot of really wonderful Flash developers who put out a lot of educational materials. Th is message is in two parts, a list of resources on the Web you may find helpful, and 2) my own explanation of why Flash is so tough for so many. I. Resources I don't know how many times I have posted these links to this list, but i f you are looking for instructional materials on Flash, look here: [snip] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Intranet apps
The weathers cf_rubbish here anyway!! J -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:21 PM To: CF-Talk Subject: RE: Intranet apps Man oh man, I can't win today, you give something for free and people just want more and more and more I think you could figure out the US part. UK I don't deal with. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:20 PM To: CF-Talk Subject: RE: Intranet apps cfset attributes.zipcode = 32714 What if its the UK, or somewhere else that the US? -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:05 PM To: CF-Talk Subject: RE: Intranet apps Weather cfset attributes.zipcode = 32714 CFHTTP URL=http://www.weather.com/weather/tendayprint/#Attributes.ZipCode#; METHOD=GET PORT=80 RESOLVEURL=true cfset OutPut = Replace(CFHTTP.FileContent, HREF=/, HREF=http://www.weather.com/;, ALL) CFOUTPUT#OutPut#/CFOUTPUT Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:00 PM To: CF-Talk Subject: Re: Intranet apps I was looking for a conference room signup app only. This would be a corporate wide, web browser accessible application. Outlook requires LDA P I believe and our company does not plan to run or support it. (Don't ask wh y) For weather I'm aware of AccuWeather data feed in XML format but not sure what they would charge. I was hoping for a free app I could integrate in to the home page that shows current weather conditions for a local city, lik e MyExite or MyLycos offers. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:37 AM Subject: RE: Intranet apps here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people invite the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make the schedule visible to all. There are a few sites that have data feeds of info that you can legally post on your own site. You want to look at www.moreover.com. You can use cfhttp to get the info. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:30 PM To: CF-Talk Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display our company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
Are they padded to 255 all the time, or does that char field have a length or 255? My understanding is that the char would return a string with the entire length of the field. That is the main difference between a char and a varchar (which would return a string only as long as the data put into the field.) 1. change it to a varchar or 2. trim() it before use. Jerry Johnson [EMAIL PROTECTED] 03/07/02 03:24PM I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Maybe I'm being too cynical, but to me *spam* makes the difference. I was just looking for some assurance that the download is actually *free*, and not paid for by allowing the people you give your info to to sell that info on for marketing (I couldn't see any assurance on the site). BTW, it would have been faster for you to not criticise my questioning than to do so (nod to Bill Hicks ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form Caching
I'm sure this has been asked before, but I can't seem to find the answer. When using forms, if a user fills in some information and proceeds to the next page, then uses the browser's back button, the form retains the input information. Is there a way to clear the form or refresh the page without having to expire the page and make the end user refresh the page with their browser? Thank you in advance. Chuck Brockman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mailing an excel file with cfmail
Hey List, Thanks for being always helpful. I have one quick question. There is already code that queries the database, then assigns the results to variables using cfset. Then it creates a file using cffile and inputs these variables in the file with comma in between them, thus creating a comma delimeted string. Then, cfmail tag is used to send email with this file as an attachment. The person opening this email will receive this email, then, they will open the attachment in excel. Is there a way to have cf create a excel file using a query output? I need to send a excel file instead of a text file in the email. AB __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
uploading data file problem
I have a strange problem. After I upload a .mdb or xls file and add it as a datasource I am unable to upload a new version that has been modified locally. I get a datasource in use error msg. (This is true in both WS_FTP and LEAP_FTP. I haven't tried DOS.) Now this doesn't particularly matter in most cases as I change via CF. But now I want to have HR and other staff upload changes via CFFILE. The only way I can do this now is to go the admin page, remove the data source, go to the directory and remove the file, then add the new file and go back to the admin page and add the new datasource. Has anybody faced this before? -- glm --- This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Buy 4.5 pro server
Hi All, Kind of a lame Q. here, but does anyone know where (besides ebay) I can get a relatively cheap copy of 4.5 professional server?? thanks much John __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
odd cookie behavior
Today... right in the middle of working with a cf app when suddenly the Applications starts saying I need to enable cookies. I check and IE 5.5 cookies are enabled... so I fire up Netscrape and it has no problems with the application. It seems to be an IE only problem. S I turn cookies off in IE and it dutifully asks me if I want to accept the cookies... I say yes... and Still CF says it can't find the cookies that I just accepted. I haven't mucked about with the code for several days... So I don't think it's that Netscrape seems to do ok. The code is quite simple... and has been working for months. The dspLogin.cfm has this as it's last line. cfcookie name=TestCookie value=Yes expires=1 The actLogin.cfm has this as it's first line. cfif not isdefined( cookie.TestCookie )Report error and Abort/cfif Anybody have a clue as to what's up? Brian __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploading data file problem
If my mind remembers correctly, just run a cfquery with an error, and the DB will be unhooked. Then you can copy the file into place. The next cfquery will rehook it. Jerry Johnson [EMAIL PROTECTED] 03/07/02 03:37PM I have a strange problem. After I upload a .mdb or xls file and add it as a datasource I am unable to upload a new version that has been modified locally. I get a datasource in use error msg. (This is true in both WS_FTP and LEAP_FTP. I haven't tried DOS.) Now this doesn't particularly matter in most cases as I change via CF. But now I want to have HR and other staff upload changes via CFFILE. The only way I can do this now is to go the admin page, remove the data source, go to the directory and remove the file, then add the new file and go back to the admin page and add the new datasource. Has anybody faced this before? -- glm --- - --- This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
Take your little disagreement offline. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 2:24 PM Subject: Re: [OT] Re: VTML Builder I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Maybe I'm being too cynical, but to me *spam* makes the difference. I was just looking for some assurance that the download is actually *free*, and not paid for by allowing the people you give your info to to sell that info on for marketing (I couldn't see any assurance on the site). BTW, it would have been faster for you to not criticise my questioning than to do so (nod to Bill Hicks ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [OT] Re: VTML Builder
Oracle does the same thing in VB applications. We have always had to trim our variables to get rid of the excess spaces Doubt that helped ya any Shawn Grover -Original Message- From: freddy [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:25 PM To: CF-Talk Subject: Re: [OT] Re: VTML Builder I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Maybe I'm being too cynical, but to me *spam* makes the difference. I was just looking for some assurance that the download is actually *free*, and not paid for by allowing the people you give your info to to sell that info on for marketing (I couldn't see any assurance on the site). BTW, it would have been faster for you to not criticise my questioning than to do so (nod to Bill Hicks ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
quick SQL question for my add/edit page
Hello, I need to add a new hidden field to my add/edit page that will update the table when a new record it added or updated..not sure how to write the SQL stmt to automatically create this hidden field. The user is required to enter a 6 digit program code, which begins with a letter followed by 5 numbers. So, if the program code is A12345, then I want the hidden field to be an Aif the program code is B67891, then the hidden field needs to be a B... how would I write this SQL stmt? Thanks again! __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
They are padded all the time the char fields in question range in length from char(4) to char(10). Also a single trim() doesn't work. I need to trim(trim()) or the length of the field is still 254. I have no control over how the data will be stored in the database. I have requested they all be converted to varchar fields but it doesn't happen. If a single trim would work I would not worry so much but again I am trying to compare values held in cf variables that are now 255 to database fields that are 4-10 chars long. A trim wouldn't help me there unless I have the oracle developers trim all the values coming out of the database in the stored proc and trim(trim()) the char field. This has been going on since version 4 and we are now on version 5 of cf. Thanks Jerry Johnson wrote: Are they padded to 255 all the time, or does that char field have a length or 255? My understanding is that the char would return a string with the entire length of the field. That is the main difference between a char and a varchar (which would return a string only as long as the data put into the field.) 1. change it to a varchar or 2. trim() it before use. Jerry Johnson [EMAIL PROTECTED] 03/07/02 03:24PM I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Maybe I'm being too cynical, but to me *spam* makes the difference. I was just looking for some assurance that the download is actually *free*, and not paid for by allowing the people you give your info to to sell that info on for marketing (I couldn't see any assurance on the site). BTW, it would have been faster for you to not criticise my questioning than to do so (nod to Bill Hicks ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
If you had cared to read through the post you would have seen a legitimate question. Again if you don't want to read it delete it. Thank you, Frederic Paul Giesenhagen wrote: Take your little disagreement offline. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 2:24 PM Subject: Re: [OT] Re: VTML Builder I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: What difference does it make? If you want it fill out the info... it is faster than writing an email to complain about it. Maybe I'm being too cynical, but to me *spam* makes the difference. I was just looking for some assurance that the download is actually *free*, and not paid for by allowing the people you give your info to to sell that info on for marketing (I couldn't see any assurance on the site). BTW, it would have been faster for you to not criticise my questioning than to do so (nod to Bill Hicks ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: quick SQL question for my add/edit page
Amanda, Sounds more like you want to do a hidden input field with value=#left(programcode, 1)# in it. HTH Hatton Amanda Stern wrote: Hello, I need to add a new hidden field to my add/edit page that will update the table when a new record it added or updated..not sure how to write the SQL stmt to automatically create this hidden field. The user is required to enter a 6 digit program code, which begins with a letter followed by 5 numbers. So, if the program code is A12345, then I want the hidden field to be an Aif the program code is B67891, then the hidden field needs to be a B... how would I write this SQL stmt? Thanks again! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fwd: Time Out Problem?
--- Original Message --- From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Cc: Sent: Thu, 7 Mar 2002 16:33:46 -0500 Subject: Time Out Problem? I'm not sure if this is a problem with coding or an ISP problem. My client has been having periodic problems updating a form. We're using an Access 2000 db backend on IIS (Win XP Platform). It looks like a timeout problem at first glance but I'm not so sure. The client states that the problem can occur when changing from one db record to another in a list to edit (using a form) it came to essentially a total stop with the screen saying that it found the website and was waiting for a response. No error message, just that the website for whatever particular reason(s) was not responding. Yet, I could sign off and get onto the main website with no problem. The client states further it is not that I can't get into the [ISP] as I am already there, just going from one internal location [in the admin area] to another is the problem. For a point of reference, here is the Application.cfm variables: cfapplication name=Admin Area clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(2,0,0,0)# clientstorage=Registry I extended the timeout session to 45 minutes because this client could be editing a record for 30 minutes or more - reading paper references and typing them in. Now, here's what I use to write the update statement to the Access db: cflock timeout=150 throwontimeout=No type=EXCLUSIVE CFQUERY code . . . updating code /cfquery /cflock cflocation . . . Again, timeout is set to 150 seconds just to see if there's another issue. So, to recap, is this a coding issue, or an ISP issue? If ISP, where would I begin or what would I want to focus in on. Thanks for taking time to read and respond to this long-winded question. Your comments and insights are appreciated. -- Mark Leder, [EMAIL PROTECTED] on 03/07/2002 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
odd cookie behavior - more serious
This is more serious than my previous post suggests. I just attempted to connect to the application using a Mac and IE4.5 and got the same error... yet yesterday no problem at all... === previous message = Today... right in the middle of working with a cf app when suddenly the Applications starts saying I need to enable cookies. I check and IE 5.5 cookies are enabled... so I fire up Netscrape and it has no problems with the application. It seems to be an IE only problem. S I turn cookies off in IE and it dutifully asks me if I want to accept the cookies... I say yes... and Still CF says it can't find the cookies that I just accepted. I haven't mucked about with the code for several days... So I don't think it's that Netscrape seems to do ok. The code is quite simple... and has been working for months. The dspLogin.cfm has this as it's last line. cfcookie name=TestCookie value=Yes expires=1 The actLogin.cfm has this as it's first line. cfif not isdefined( cookie.TestCookie )Report error and Abort/cfif Anybody have a clue as to what's up? Brian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Time Out Problem?
I'm not sure if this is a problem with coding or an ISP problem. My client has been having periodic problems updating a form. We're using an Access 2000 db backend on IIS (Win XP Platform). It looks like a timeout problem at first glance but I'm not so sure. The client states that the problem can occur when changing from one db record to another in a list to edit (using a form) it came to essentially a total stop with the screen saying that it found the website and was waiting for a response. No error message, just that the website for whatever particular reason(s) was not responding. Yet, I could sign off and get onto the main website with no problem. The client states further it is not that I can't get into the [ISP] as I am already there, just going from one internal location [in the admin area] to another is the problem. For a point of reference, here is the Application.cfm variables: cfapplication name=Admin Area clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(2,0,0,0)# clientstorage=Registry I extended the timeout session to 45 minutes because this client could be editing a record for 30 minutes or more - reading paper references and typing them in. Now, here's what I use to write the update statement to the Access db: cflock timeout=150 throwontimeout=No type=EXCLUSIVE CFQUERY code . . . updating code /cfquery /cflock cflocation . . . Again, timeout is set to 150 seconds just to see if there's another issue. So, to recap, is this a coding issue, or an ISP issue? If ISP, where would I begin or what would I want to focus in on. Thanks for taking time to read and respond to this long-winded question. Your comments and insights are appreciated -- Mark Leder, [EMAIL PROTECTED] on 03/07/2002 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WAY OT: Virus or not GOTCHA
Hi all... OK, this is ridiculous, but my boss's son got stupid and opened up a program that puts some sort of thing on his machine that has a button on it and moves when you go near it. It says something like Gotcha when you go near it. Any ideas what it is? Help on how to get rid of it or find out what it is is appreciated. I'm not anywhere near the computer, and don't intend to go near it unless the boss says to. I'm really sorry for the off topic post, but I can't find any info on this. Thank you, - Matt Small __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Timing out too fast - DOH!
Just remember you hae to stop and restart the service for the change to take effect, in my experience. Chuck McElwee etech solutions inc www.etechsolutions.com -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:48 AM To: CF-Talk Subject: RE: Session Timing out too fast - DOH! It was the server settings. Never mind. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 9:38 AM To: CF-Talk Subject: Session Timing out too fast I know this is kinda vague but... My session is not lasting 4 hours. More like 20 minutes. What am I missing? cfapplication name=work_damn_it sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,24,0,0)# Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mailing an excel file with cfmail
I don't know if this will work, but after you create the file, can you rename it so that the extension is .csv? That will cause Excel to open it, on most systems. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: bajaria aslam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:36 PM To: CF-Talk Subject: Mailing an excel file with cfmail Hey List, Thanks for being always helpful. I have one quick question. There is already code that queries the database, then assigns the results to variables using cfset. Then it creates a file using cffile and inputs these variables in the file with comma in between them, thus creating a comma delimeted string. Then, cfmail tag is used to send email with this file as an attachment. The person opening this email will receive this email, then, they will open the attachment in excel. Is there a way to have cf create a excel file using a query output? I need to send a excel file instead of a text file in the email. AB __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WAY OT: Virus or not GOTCHA
Matt, CTRL-ALT-DELETE , bring up task list, look for something strange/different, end that task...keep trying tasks until you find the one that does it... John -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 4:45 PM To: CF-Talk Subject: WAY OT: Virus or not GOTCHA Hi all... OK, this is ridiculous, but my boss's son got stupid and opened up a program that puts some sort of thing on his machine that has a button on it and moves when you go near it. It says something like Gotcha when you go near it. Any ideas what it is? Help on how to get rid of it or find out what it is is appreciated. I'm not anywhere near the computer, and don't intend to go near it unless the boss says to. I'm really sorry for the off topic post, but I can't find any info on this. Thank you, - Matt Small __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY OT: Virus or not GOTCHA
AltF4 is always your friend... either that or End Task on it... if you're running 2000/XP you can pull up the task manager and see what's running. HTH Hatton Matthew R. Small wrote: Hi all... OK, this is ridiculous, but my boss's son got stupid and opened up a program that puts some sort of thing on his machine that has a button on it and moves when you go near it. It says something like Gotcha when you go near it. Any ideas what it is? Help on how to get rid of it or find out what it is is appreciated. I'm not anywhere near the computer, and don't intend to go near it unless the boss says to. I'm really sorry for the off topic post, but I can't find any info on this. Thank you, - Matt Small __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY OT: Virus or not GOTCHA
http://www.antivirus.com You'll find a free virus scan there that's very good and their PCillan product will probably keep the boss's son out of trouble for $24.95. Greg Alton CFDev - Original Message - From: Matthew R. Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 4:44 PM Subject: WAY OT: Virus or not GOTCHA Hi all... OK, this is ridiculous, but my boss's son got stupid and opened up a program that puts some sort of thing on his machine that has a button on it and moves when you go near it. It says something like Gotcha when you go near it. Any ideas what it is? Help on how to ge t rid of it or find out what it is is appreciated. I'm not anywhere near the computer, and don't intend to go near it unless the boss says to. I'm really sorry for the off topic post, but I can't find any info on this. Thank you, - Matt Small __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Spiders and Cold Fusion
One of out clients has hired an Internet Marketing company to help get them more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spiders and Cold Fusion
Yup they are correct (although some engines are making headway in that area). Go to Forta.com and find Ben's article on making your site search engine accessible. Actually this same topic flew through the list yesterday...so check the archives. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 1:56 PM Subject: Spiders and Cold Fusion One of out clients has hired an Internet Marketing company to help get them more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spiders and Cold Fusion
I had the same thing said to me. The Ben Forta article on it is grea t. This is such a funny topic...Just tell them to type in .cfm in any search engine and look at all the pages that show up.I wou ld suggust telling your clients to fire them...If they claim to be what they are they would know this... [EMAIL PROTECTED] 03/07/02 04:56PM One of out clients has hired an Internet Marketing company to help ge t them more hits. I just got a call from one of their reps, and they were trying to tel l me Cold Fusion will not work with search engine spiders because the pa ges are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. _ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spiders and Cold Fusion
Whoops.. i am a true believer in searching the archives first. I was so worked up after that phone call i just posted. Thanks for the tips guys, i will check out Ben's article. At 01:55 PM 3/7/2002 -0800, you wrote: Yup they are correct (although some engines are making headway in that area). Go to Forta.com and find Ben's article on making your site search engine accessible. Actually this same topic flew through the list yesterday...so check the archives. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 1:56 PM Subject: Spiders and Cold Fusion One of out clients has hired an Internet Marketing company to help get them more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spiders and Cold Fusion
IMO, there is only one search engine that matters anymore and it's Google. They clearly index CF sites since they have 17,600,000 of them listed when you search for .cfm http://google.com/search?hl=enq=%2B.cfm IMO, the people your client hired are idiots and really don't know up from down. IMO, Search engine safe URL's are pretty much a thing of the past. Almost all bots index pages with query strings.. Of course it's not a bad idea to use SES URL's if you can. In regards to creating a static site, that's more work for you. It shouldn't be too hard either using CFHTTP and saving the files to disk. - JD -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:57 PM To: CF-Talk Subject: Spiders and Cold Fusion One of out clients has hired an Internet Marketing company to help get them more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Intranet apps
Thanks for the help Robert! I'm not able to get CFHTTP to get outside our firewall yet. I'm using ou r web proxy server settings but no luck. If anyone has any tips on how to make CFHTTP work through a firewall, let me know. Here's my tag line: cfhttp url=http://www.weather.com/weather/tendayprint/#Attributes.ZipCode#; method=GET username=(my proxy user) password=(my proxy pw) resolveurl=true proxyserver=(our proxy web server) proxyport=8080 - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 12:04 PM Subject: RE: Intranet apps Weather cfset attributes.zipcode = 32714 CFHTTP URL=http://www.weather.com/weather/tendayprint/#Attributes.ZipCode#; METHOD=GET PORT=80 RESOLVEURL=true cfset OutPut = Replace(CFHTTP.FileContent, HREF=/, HREF=http://www.weather.com/;, ALL) CFOUTPUT#OutPut#/CFOUTPUT Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:00 PM To: CF-Talk Subject: Re: Intranet apps I was looking for a conference room signup app only. This would be a corporate wide, web browser accessible application. Outlook requires L DA P I believe and our company does not plan to run or support it. (Don't ask wh y) For weather I'm aware of AccuWeather data feed in XML format but not su re what they would charge. I was hoping for a free app I could integrate in to the home page that shows current weather conditions for a local city, l ik e MyExite or MyLycos offers. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:37 AM Subject: RE: Intranet apps here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people invite the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make t he schedule visible to all. There are a few sites that have data feeds of info that you can legal ly post on your own site. You want to look at www.moreover.com. You can use cfhttp to get the info. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:30 PM To: CF-Talk Subject: Intranet apps Does anyone know of a source for applications that can be integrated into an Intranet? I'm looking for: * a conference room scheduler application * a weather application to display local weather conditions in real time in the corner of the Intranet home page * a stock ticker application that can be configured to only display o ur company stock price movement (delayed quotes is fine) during the day. Any help would be appreciated. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: odd cookie behavior - more serious
Dumb question: Is this occuring on multiple IE machines? Did you try deleting all of your cookies? Your cookie file for that domain may have gotten corrupted. -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 4:36 PM To: CF-Talk Subject: odd cookie behavior - more serious This is more serious than my previous post suggests. I just attempted to connect to the application using a Mac and IE4.5 and got the same error... yet yesterday no problem at all... === previous message Today... right in the middle of working with a cf app when suddenly the Applications starts saying I need to enable cookies. I check and IE 5.5 cookies are enabled... so I fire up Netscrape and it has no problems with the application. It seems to be an IE only problem. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spiders and Cold Fusion
I really wonder about the whole 'spiders wont index your dynamic pages' thing. www.cflib.org is 90% dynamic pages, and we get spidered by all the big boys. I don't know what I'm missing by not using the foo.cfm/udf/2 type syntax. Is this really an issue in these 'modern' times? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 4:56 PM To: CF-Talk Subject: Re: Spiders and Cold Fusion Yup they are correct (although some engines are making headway in that area). Go to Forta.com and find Ben's article on making your site search engine accessible. Actually this same topic flew through the list yesterday...so check the archives. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spiders and Cold Fusion
Spiders bad, cf_porn good. ;) Seriously, one time an in-house Quality Assurance Tester went through one of my ADMIN ONLY sites with a spider one time. He logged in and set the spider loose. It was very bad. The spider took to clicking every link in the site. Flipping ever bit flag that had a link on it. Switching all kinds of things on and off. It took me a while to figure out what happened too. If you are going to be hit buy a spider, make sure you don't have any links that delete records. My boss made sure no more testing was done with spiders! Justin Hansen -- Ulgih Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:57 PM To: CF-Talk Subject: Spiders and Cold Fusion One of out clients has hired an Internet Marketing company to help get them more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spiders and Cold Fusion
In general, search engines do not work against query strings, i.e. URL containing a ?something=x. This is NOT a fault of ColdFusion. There are ways around it, none particularly simple, IMHO. The ColdFusion Developers Journal recently had an article by Ben Forta on techniques for getting around this. Chuck McElwee etech solutions inc www.etechsolutions.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 4:57 PM To: CF-Talk Subject: Spiders and Cold Fusion One of out clients has hired an Internet Marketing company to help get them more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Decryption Licensing Verbiage/Copy
We're looking to add some verbiage/copy to our licensing agreements that says something to the effect of decrypting any encrypted templates violates the terms of this license. Our management-types want it to sound more authoritative (and nastier) than that. Does anyone have anything in their licensing agreements like this that we can copy/steal? Thanks! -R __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spiders and Cold Fusion
I didn't even know Internet Marketing company's still existed. If the search engine is old and technologically out of date then it might not find dynamic pages. But where I am it's year 2002. On Thu, 7 Mar 2002, Chad Gray wrote: One of out clients has hired an Internet Marketing company to help get th em more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF a nd Search Engine spiders? She wants us to generate an alternative site that is static. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY OT: Virus or not GOTCHA
is it a button on the web browser (like an HTML button)? is the button just floating around on the desktop? try format c: to fix it. On Thu, 7 Mar 2002, Matthew R. Small wrote: Hi all... OK, this is ridiculous, but my boss's son got stupid and opened up a program that puts some sort of thing on his machine that has a button on it and moves when you go near it. It says something like Gotcha when you go near it. Any ideas what it is? Help on how to get rid of it or find out what it is is appreciated. I'm not anywhere near the computer, and don't intend to go near it unless the boss says to. I'm really sorry for the off topic post, but I can't find any info on this. Thank you, - Matt Small __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
