Re: Dynamic query woes
try something like... Dim StartDate, EndDate StartDate = DateSerial(Request(s_year),Request(s_month),Request(s_day)) EndDate = DateSerial(Request(e_year),Request(e_month),Request(e_day)) qSearch = SELECT TypeOfEvent,EventText,ModifiedDateTime,ModifiedBy,ActionPerformed _ FROM tbl_auditlog _ WHERE 0=0 If Request(TypeOfSearch) All then qSearch = qSearch AND TypeOfEvent = 'Request(TypeOfSearch)' End If If Request(SearchByDateRange) = yes then qSearch = qSearch AND ModifiedDateTime BETWEEN ' StartDate ' AND ' EndDate ' End If qSearch = qSearch ORDER BY TypeOfEvent, ModifiedDateTime hth Bosky, Dave wrote: I needed to write this page in asp instead of cf and can't seem to locate the error in this query. I figured a few additional eyes would help! Dim StartDate, EndDate StartDate = DateSerial(Request(s_year),Request(s_month),Request(s_day)) EndDate = DateSerial(Request(e_year),Request(e_month),Request(e_day)) qSearch = SELECT TypeOfEvent,EventText,ModifiedDateTime,ModifiedBy,ActionPerformed _ FROM tbl_auditlog _ WHERE 0=0 _ If Request(TypeOfSearch) All then AND TypeOfEvent = 'Request(TypeOfSearch)' _ End If If Request(SearchByDateRange) = yes then AND ModifiedDateTime BETWEEN ' StartDate ' AND ' EndDate ' _ End If ORDER BY TypeOfEvent, ModifiedDateTime -- Thanks, Dave __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
http://address
Greetings, we have a dynamic site running off one directory structure, for multible customers, lets say, http//www.domain.com/allCustomersSeeThisDirName/.. some customers have now specified they would like http//www.domain.com/dirNameSpecificToThem/, is there a clean way to MASK this, while always calling the original directory structure, I will really appreciate any advice on this, Respectfully, j __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QuerySim custom tag and Fusebox 3
Well, that's simple enough. Thanks, Alistair. I would never have seen that. And thanks everyone for their input. Date: Mon, 27 May 2002 11:24:49 +0100 From: Alistair Davidson [EMAIL PROTECTED] Subject: RE: QuerySim custom tag and Fusebox 3 Message-ID: [EMAIL PROTECTED] Hi guys The problem is that thisTag.generatedcontent only captures content that would be destined for the output buffer. If enablecfoutputonly=YES has been called, thisTag.generatedContent is non-existent, unless the tag is called between CFOUTPUT tags. Walk it through - 1) The very first line in the FB3 core file (fbx_fusebox30_CFXX.cfm) sets cfsetting enablecfoutputonly=YES 2) Sections seven and nine of the FB3 core file includes fbx_settings.cfm. enablecfoutputonly is still YES, so any plain text is just ignored 3) Section ten includes fbx_switch.cfm, but does it like this - cfoutputcfinclude template=#FB_.fuseboxpath#fbx_Switch.cfm/cfoutput so THAT's why Cf_querysim works when included from fbx_switch, but not from fbx_settings Workaround - whenever you use a cf_querysim tag, nest it inside a Cfoutput block, like this cf_querysim cfoutput qry_myquery a,column,list your|query|data /cfoutput /cf_querysim or even cfoutput cf_querysim qry_myquery a,column,list your|query|data /cf_querysim /cfoutput Hope that helps, Alistair Alistair Davidson Application Developer Freeserve.com PLC www.smartgroups.com Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus 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: http://address
If you have access to the server itself, you could create virtual directories with whatever dirNameSpecificToThem they want all pointing at the physical location of allCustomersSeeThisDirName, HTH, John. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 13:27 To: CF-Talk Subject: http://address Greetings, we have a dynamic site running off one directory structure, for multible customers, lets say, http//www.domain.com/allCustomersSeeThisDirName/.. some customers have now specified they would like http//www.domain.com/dirNameSpecificToThem/, is there a clean way to MASK this, while always calling the original directory structure, I will really appreciate any advice on this, Respectfully, j __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
K2 Verity
Is it possible to index database content with K2 much like we do with the CF Verity? The documentation doesn't really go there. If yes, is there any advantages to using K2 for DB content? Thanks, Frank Mamone __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: http://address
You can also set up a redirect at... http//www.domain.com/dirNameSpecificToThem/ so that the customer is pointed to... http//www.domain.com/allCustomersSeeThisDirName/.. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:24 AM To: CF-Talk Subject: RE: http://address If you have access to the server itself, you could create virtual directories with whatever dirNameSpecificToThem they want all pointing at the physical location of allCustomersSeeThisDirName, HTH, John. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 13:27 To: CF-Talk Subject: http://address Greetings, we have a dynamic site running off one directory structure, for multible customers, lets say, http//www.domain.com/allCustomersSeeThisDirName/.. some customers have now specified they would like http//www.domain.com/dirNameSpecificToThem/, is there a clean way to MASK this, while always calling the original directory structure, I will really appreciate any advice on this, Respectfully, j __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: http://address
Once again, my fat fingers hit ctrl-enter in outlook... sending too early. If you use this method, they wont always see the dirNameSpecificToThem in the URL after the redirect... But it's enough for them to put in on a business card. I would handle similar cases by personalizing the page depending on the end user entry point. If the user comes in on http://www.domain.com/johnsmith , the page shows the personalized Welcome to John Smith's site. There would also be a generic view if end users entered the http//www.domain.com/dirNameSpecificToThem/ way. -Original Message- From: Carlisle, Eric Sent: Tuesday, May 28, 2002 8:56 AM To: '[EMAIL PROTECTED]' Subject: RE: http://address You can also set up a redirect at... http//www.domain.com/dirNameSpecificToThem/ so that the customer is pointed to... http//www.domain.com/allCustomersSeeThisDirName/.. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:24 AM To: CF-Talk Subject: RE: http://address If you have access to the server itself, you could create virtual directories with whatever dirNameSpecificToThem they want all pointing at the physical location of allCustomersSeeThisDirName, HTH, John. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 13:27 To: CF-Talk Subject: http://address Greetings, we have a dynamic site running off one directory structure, for multible customers, lets say, http//www.domain.com/allCustomersSeeThisDirName/.. some customers have now specified they would like http//www.domain.com/dirNameSpecificToThem/, is there a clean way to MASK this, while always calling the original directory structure, I will really appreciate any advice on this, Respectfully, j __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: http://address
d'oh! *typo below* What I meant to say was... There would also be a generic view if end users entered the http//www.domain.com/allCustomersSeeThisDirName/ way. Eric -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:00 AM To: CF-Talk Subject: RE: http://address Once again, my fat fingers hit ctrl-enter in outlook... sending too early. If you use this method, they wont always see the dirNameSpecificToThem in the URL after the redirect... But it's enough for them to put in on a business card. I would handle similar cases by personalizing the page depending on the end user entry point. If the user comes in on http://www.domain.com/johnsmith , the page shows the personalized Welcome to John Smith's site. There would also be a generic view if end users entered the http//www.domain.com/dirNameSpecificToThem/ way. -Original Message- From: Carlisle, Eric Sent: Tuesday, May 28, 2002 8:56 AM To: '[EMAIL PROTECTED]' Subject: RE: http://address You can also set up a redirect at... http//www.domain.com/dirNameSpecificToThem/ so that the customer is pointed to... http//www.domain.com/allCustomersSeeThisDirName/.. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:24 AM To: CF-Talk Subject: RE: http://address If you have access to the server itself, you could create virtual directories with whatever dirNameSpecificToThem they want all pointing at the physical location of allCustomersSeeThisDirName, HTH, John. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 13:27 To: CF-Talk Subject: http://address Greetings, we have a dynamic site running off one directory structure, for multible customers, lets say, http//www.domain.com/allCustomersSeeThisDirName/.. some customers have now specified they would like http//www.domain.com/dirNameSpecificToThem/, is there a clean way to MASK this, while always calling the original directory structure, I will really appreciate any advice on this, Respectfully, j __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: http://address
Thanks Eric, thanks John, we are currently experimenting with all of these options, respectfully, j -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:00 PM To: CF-Talk Subject: RE: http://address Once again, my fat fingers hit ctrl-enter in outlook... sending too early. If you use this method, they wont always see the dirNameSpecificToThem in the URL after the redirect... But it's enough for them to put in on a business card. I would handle similar cases by personalizing the page depending on the end user entry point. If the user comes in on http://www.domain.com/johnsmith , the page shows the personalized Welcome to John Smith's site. There would also be a generic view if end users entered the http//www.domain.com/dirNameSpecificToThem/ way. -Original Message- From: Carlisle, Eric Sent: Tuesday, May 28, 2002 8:56 AM To: '[EMAIL PROTECTED]' Subject: RE: http://address You can also set up a redirect at... http//www.domain.com/dirNameSpecificToThem/ so that the customer is pointed to... http//www.domain.com/allCustomersSeeThisDirName/.. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:24 AM To: CF-Talk Subject: RE: http://address If you have access to the server itself, you could create virtual directories with whatever dirNameSpecificToThem they want all pointing at the physical location of allCustomersSeeThisDirName, HTH, John. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 13:27 To: CF-Talk Subject: http://address Greetings, we have a dynamic site running off one directory structure, for multible customers, lets say, http//www.domain.com/allCustomersSeeThisDirName/.. some customers have now specified they would like http//www.domain.com/dirNameSpecificToThem/, is there a clean way to MASK this, while always calling the original directory structure, I will really appreciate any advice on this, Respectfully, j __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
executing dts package...part 2
Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the CF server. So both machines recognize the share as drive-letter:\blah. I believe the problem is SQL server thinks the drive-letter:\blah is on the end-user machine sending the request. How do I get SQL server to understand the share is not on the local machine and to use the mapping on the server? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing dts package...part 2
Any chance you can use a UNC path instead of drive mapping? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:42 AM To: CF-Talk Subject: executing dts package...part 2 Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the CF server. So both machines recognize the share as drive-letter:\blah. I believe the problem is SQL server thinks the drive-letter:\blah is on the end-user machine sending the request. How do I get SQL server to understand the share is not on the local machine and to use the mapping on the server? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: executing dts package...part 2
Is the CF Services Logged in as a User that has rights to the share? I.E. In Windows NT/2K YOu can have the user login as a Local User who has access to the Drive Mapping - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 2:40 PM Subject: RE: executing dts package...part 2 Any chance you can use a UNC path instead of drive mapping? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:42 AM To: CF-Talk Subject: executing dts package...part 2 Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the CF server. So both machines recognize the share as drive-letter:\blah. I believe the problem is SQL server thinks the drive-letter:\blah is on the end-user machine sending the request. How do I get SQL server to understand the share is not on the local machine and to use the mapping on the server? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: K2 Verity
Is it possible to index database content with K2 much like we do with the CF Verity? The documentation doesn't really go there. If yes, is there any advantages to using K2 for DB content? You don't index content at all with K2, generally - you index with the VDK and search with K2. The advantage of using K2 for searches is that it's significantly faster. For more information about using K2, you might find these presentations useful: http://www.cfugorama.com/cfugorama/codelibrary/verityk2.cfm http://www.daemon.com.au/navitron/display.cfm?objectid=B9DACD89-A81C-4396-8D EC8540FCF9224A The first one was done by Dave Gallerizzo and myself, the second by Geoff Bowers. Enjoy! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: K2 Verity
I haven't found a mechanism to index database content with K2 yet and while you can index documents with K2 I don't recommend it (unless using the spider to index a website...) . Use your standard tools to index your DB content (CFINDEX ) and then search it using K2. You'll get all the benefits of fast K2 searches with none of the headaches of MKVDK. Jeff Garza - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 5:52 AM Subject: K2 Verity Is it possible to index database content with K2 much like we do with the CF Verity? The documentation doesn't really go there. If yes, is there any advantages to using K2 for DB content? Thanks, Frank Mamone __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing dts package...part 2
no unc path allowed. that's why i had to map the drive. the issue is that sql server thinks the mapping is on the local machine, not on the server. i need to figure out a way around this, or to trick sql server. -Original Message- From: Kevin McCabe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:52 AM To: CF-Talk Subject: Re: executing dts package...part 2 Is the CF Services Logged in as a User that has rights to the share? I.E. In Windows NT/2K YOu can have the user login as a Local User who has access to the Drive Mapping - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 2:40 PM Subject: RE: executing dts package...part 2 Any chance you can use a UNC path instead of drive mapping? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:42 AM To: CF-Talk Subject: executing dts package...part 2 Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the CF server. So both machines recognize the share as drive-letter:\blah. I believe the problem is SQL server thinks the drive-letter:\blah is on the end-user machine sending the request. How do I get SQL server to understand the share is not on the local machine and to use the mapping on the server? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: K2 Verity
I must be misunderstanding this from Fig Leaf's presentation: Ó Determination of which mode to use: ColdFusion looks in the registry for the collection specified in the CFSEARCH tag. If it is found then a VDK search is used Collection names are written to the registry by calls to the CFCOLLECTION tag and represent ColdFusion Aware Verity Collections. This is generally done via the CF Administrator If the collection name is not found in the registry then the K2 search is performed If I use the old way to create collections , that is, using CF Administrator, does it not enter it in the registry? If so, the according to the statement above it will use VDK searching. - Original Message - From: Jeff Garza [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 10:09 AM Subject: Re: K2 Verity I haven't found a mechanism to index database content with K2 yet and while you can index documents with K2 I don't recommend it (unless using the spider to index a website...) . Use your standard tools to index your DB content (CFINDEX ) and then search it using K2. You'll get all the benefits of fast K2 searches with none of the headaches of MKVDK. Jeff Garza - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 5:52 AM Subject: K2 Verity Is it possible to index database content with K2 much like we do with the CF Verity? The documentation doesn't really go there. If yes, is there any advantages to using K2 for DB content? Thanks, Frank Mamone __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing dts package...part 2
nevermind...got it -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:37 AM To: CF-Talk Subject: RE: executing dts package...part 2 no unc path allowed. that's why i had to map the drive. the issue is that sql server thinks the mapping is on the local machine, not on the server. i need to figure out a way around this, or to trick sql server. -Original Message- From: Kevin McCabe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:52 AM To: CF-Talk Subject: Re: executing dts package...part 2 Is the CF Services Logged in as a User that has rights to the share? I.E. In Windows NT/2K YOu can have the user login as a Local User who has access to the Drive Mapping - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 2:40 PM Subject: RE: executing dts package...part 2 Any chance you can use a UNC path instead of drive mapping? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:42 AM To: CF-Talk Subject: executing dts package...part 2 Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the CF server. So both machines recognize the share as drive-letter:\blah. I believe the problem is SQL server thinks the drive-letter:\blah is on the end-user machine sending the request. How do I get SQL server to understand the share is not on the local machine and to use the mapping on the server? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Only Win32 CFHTTP broken (Linux/Solaris OK)?
After wrestling with the Ebay API for a few days and getting some help from list-member Shawn, I discovered that while I couldn't make a call to eBay with CFHTTP (which requires two custom HTTP headers and my errors occured only when passing the required headers) on my Win2k machine, I could do it fine on my Linux machine. And Shawn does it without issue on his Solaris servers... So is it only the Win32 CFHTTP that has this encoded header issue? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
PaymenTech
Is anyone here using PaymenTech for credit card authorization and merchant bank? If so, do they have a CF interface? Thx, Duane __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: K2 Verity
I must be misunderstanding this from Fig Leaf's presentation: Determination of which mode to use: ColdFusion looks in the registry for the collection specified in the CFSEARCH tag. If it is found then a VDK search is used Collection names are written to the registry by calls to the CFCOLLECTION tag and represent ColdFusion Aware Verity Collections. This is generally done via the CF Administrator. If the collection name is not found in the registry then the K2 search is performed If I use the old way to create collections, that is, using CF Administrator, does it not enter it in the registry? If so, the according to the statement above it will use VDK searching. I don't think you're reading it incorrectly, although I agree that the above is poorly worded. When you want to make a collection searchable with K2, you'll have to create a unique collection name within the k2server.ini file; so, for a single physical collection, you may well create one name in the CF Administrator for indexing via VDK, and another name in k2server.ini for searching. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFML on WebLogic, WebSphere, etc.
New Atlanta is seeking participants for the private beta testing program for BlueDragon for J2EE servers. This edition of BlueDragon will allow you to: - Deploy CFML pages as part of a standard J2EE web application (.war) without installing any additional software on the J2EE server. - Deploy a standard J2EE web application (.war), including CFML pages, on any of the following J2EE servers without modification: BEA WebLogic, IBM WebSphere, Sun ONE (iPlanet), Oracle iAS, Macromedia JRun, New Atlanta ServletExec, Apache Tomcat. - Deploy CFML pages as compiled binaries within a standard J2EE web application (.war); deploy your web applications without giving away your CFML source code. Please contact me directly ([EMAIL PROTECTED]) if you're interested in participating in this beta program. Participants will be required to sign a Non-Disclosure Agreement (NDA). Regards, Vince Bonfanti New Atlanta Communications, LLC P.S. The beta program for the BlueDragon standalone server is open to the public. Visit New Atlanta's web site for more information and to download a copy of the current standalone server beta: http://www.newatlanta.com/products/bluedragon/index.jsp __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: K2 Verity
Add the collection to your k2server.ini (e:\CFusion\Verity\_nti40\bin) file. Example: [Coll-0] collPath=e:\cfusion\verity\collections\myCollection\file collAlias=myCollectionK2 topicSet= knowledgeBase= onLine=2 when you code your cfsearch use the name defined as the collAlias above check your admin to make sure you have the k2 port number the same as the one in the k2server.ini file sean -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:37 AM To: CF-Talk Subject: Re: K2 Verity I must be misunderstanding this from Fig Leaf's presentation: Ó Determination of which mode to use: ColdFusion looks in the registry for the collection specified in the CFSEARCH tag. If it is found then a VDK search is used Collection names are written to the registry by calls to the CFCOLLECTION tag and represent ColdFusion Aware Verity Collections. This is generally done via the CF Administrator If the collection name is not found in the registry then the K2 search is performed If I use the old way to create collections , that is, using CF Administrator, does it not enter it in the registry? If so, the according to the statement above it will use VDK searching. - Original Message - From: Jeff Garza [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 10:09 AM Subject: Re: K2 Verity I haven't found a mechanism to index database content with K2 yet and while you can index documents with K2 I don't recommend it (unless using the spider to index a website...) . Use your standard tools to index your DB content (CFINDEX ) and then search it using K2. You'll get all the benefits of fast K2 searches with none of the headaches of MKVDK. Jeff Garza - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 5:52 AM Subject: K2 Verity Is it possible to index database content with K2 much like we do with the CF Verity? The documentation doesn't really go there. If yes, is there any advantages to using K2 for DB content? Thanks, Frank Mamone __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
verity strategies: double post!!
Hi guys, Just a general query really. I am trying to build a search function to allow users to search a large site. The site uses dynamic content from a number of different db tables, and also static content on HTML pages. I have indexed all the HTML pages, and can run searches on these already, but this only accounts for half the content of the site. For the rest, I wanted some ideas for a strategy. The initial problem I can envisage is that the dynamic content takes different formats and is stored in different tables in the db (access2000). So, for example, one table contains details about operas, another details about performers. Do I need to index each table separately, then search each of these collections, and return records from each search, or is there an easier way of doing this? What about the issues that all of this different content is displayed on different templates? Just some general pointers about strategy here would be great. I have used Verity a little before. Cheers Will Swain Hot Horse Ltd __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: PaymenTech
They don't have a CFX but they do have a Java implementation if you want it. We built our own CFX for Paymentech because we're Jave-illiterate g. It took about a week of development and testing to write the CFX (which then had to be certified with their gateway). We used some open-source tools (in Delphi) to write the CFX so, if you want to write your own in Delphi, then let me know and I can give you some pointers. Here's a page with some info on their gateway: http://www.paymentech.net/sol_gat_page.jsp HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Duane Boudreau [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 10:41 AM Subject: PaymenTech Is anyone here using PaymenTech for credit card authorization and merchant bank? If so, do they have a CF interface? Thx, Duane __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: verity strategies: double post!!
I use the spider. I put the website with all the dynamic content on my server and do this C:\CFusion\Verity\_nti40\bin\vspider -common c:\cfusion\verity\common -collection C:\Inetpub\wwwroot\Newweb\verity -start http://localhost -indinclude * -cgiok -followdup Then I move the verity collection somewhere else on the server for productions and just do a replacenocase on localhost with the http_host. Works great. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:51 AM To: CF-Talk Subject: verity strategies: double post!! Hi guys, Just a general query really. I am trying to build a search function to allow users to search a large site. The site uses dynamic content from a number of different db tables, and also static content on HTML pages. I have indexed all the HTML pages, and can run searches on these already, but this only accounts for half the content of the site. For the rest, I wanted some ideas for a strategy. The initial problem I can envisage is that the dynamic content takes different formats and is stored in different tables in the db (access2000). So, for example, one table contains details about operas, another details about performers. Do I need to index each table separately, then search each of these collections, and return records from each search, or is there an easier way of doing this? What about the issues that all of this different content is displayed on different templates? Just some general pointers about strategy here would be great. I have used Verity a little before. Cheers Will Swain Hot Horse Ltd __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: K2 Verity
I see. It checks the if the ColAlias exists in the registry. Thank you all! - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 10:49 AM Subject: RE: K2 Verity I must be misunderstanding this from Fig Leaf's presentation: Determination of which mode to use: ColdFusion looks in the registry for the collection specified in the CFSEARCH tag. If it is found then a VDK search is used Collection names are written to the registry by calls to the CFCOLLECTION tag and represent ColdFusion Aware Verity Collections. This is generally done via the CF Administrator. If the collection name is not found in the registry then the K2 search is performed If I use the old way to create collections, that is, using CF Administrator, does it not enter it in the registry? If so, the according to the statement above it will use VDK searching. I don't think you're reading it incorrectly, although I agree that the above is poorly worded. When you want to make a collection searchable with K2, you'll have to create a unique collection name within the k2server.ini file; so, for a single physical collection, you may well create one name in the CF Administrator for indexing via VDK, and another name in k2server.ini for searching. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Only Win32 CFHTTP broken (Linux/Solaris OK)?
After wrestling with the Ebay API for a few days and getting some help from list-member Shawn, I discovered that while I couldn't make a call to eBay with CFHTTP (which requires two custom HTTP headers and my errors occured only when passing the required headers) on my Win2k machine, I could do it fine on my Linux machine. And Shawn does it without issue on his Solaris servers... So is it only the Win32 CFHTTP that has this encoded header issue? No, I don't think so. I just tested it with CF5 on Solaris, and had the same problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Verity Spider on MX
Has the field mapping problem with Verity Spider in CF 5.0 still exist in CFMX? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity Spider on MX
Has the field mapping problem with Verity Spider in CF 5.0 still exist in CFMX? According to the MX documentation, no, that's been fixed. I haven't tested it myself, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
populate a table
Hello, If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a syntax error with this though. Any better way? Robert O. CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) VALUES ( '#FORM.vendor#', '#FORM.contact#', '#FORM.Address#') from selectedvendor /cfquery /CFIF __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: populate a table
You need to remove from selectedvendor from your query since you are performing an insert not a select. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:47 AM To: CF-Talk Subject: populate a table Hello, If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a syntax error with this though. Any better way? Robert O. CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) VALUES ( '#FORM.vendor#', '#FORM.contact#', '#FORM.Address#') from selectedvendor /cfquery /CFIF __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: populate a table
SQL Insert statements can't have a FROM clause in them...that could be an issue! -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 16:47 To: CF-Talk Subject: populate a table Hello, If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a syntax error with this though. Any better way? Robert O. CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) VALUES ( '#FORM.vendor#', '#FORM.contact#', '#FORM.Address#') from selectedvendor /cfquery /CFIF __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: populate a table
If a user selects a vendor from a drop-down list, I want to
populate a form and main table called purchases with the
info from the vendor data that I have in stored in another
table called vendor. Here is some of the code that checks
the option field in the drop-down menu. I get a syntax error
with this though.
Any better way?
Robert O.
CFIF selectvendor is not New Vendor
cfquery name=addvendor datasource=purchases
INSERT INTO purchases (vendor, Contact, Address)
VALUES ('#FORM.vendor#', '#FORM.contact#', '#FORM.Address#')
from selectedvendor
/cfquery
/CFIF
Now, you're mixing up your INSERT types here
You either INSERT INTO with VALUES or with SELECT
If you only have the vendor info, you could do
INSERT INTO purchases (vendor, contact, address)
SELECT vendor, contact, address
FROM vendors
Where vendor='#form.vendor#'
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911
www.aspmedia.co.uk
www.aspevents.net
An ISO9001 registered company.
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE Upload Parameter
What would be the 'accept' (mime_type/file_type) parameter for CFFILE Upload? application/msexcel does not work. TIA, Sam __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: populate a table
SQL Insert statements can't have a FROM clause in them...that could be an issue! They can if you do INSERT INTO table (fields) SELECT fields FROM otherTable WHERE field=value Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: populate a table
Actually John, an insert statement can have a FROM clause. I believe that Robert might have been confused on the syntax, but if he wanted to say pass an Id for a chosen Vendor he could have performed the following: CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) SELECT vendor, contact, Address FROM vendor where vendor = #selectedvendor# /cfquery /CFIF Or something of the like ... where he would get the contact and address information from the vendor's table and insert it into the purchases table. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:47 AM To: CF-Talk Subject: RE: populate a table SQL Insert statements can't have a FROM clause in them...that could be an issue! -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 16:47 To: CF-Talk Subject: populate a table Hello, If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a syntax error with this though. Any better way? Robert O. CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) VALUES ( '#FORM.vendor#', '#FORM.contact#', '#FORM.Address#') from selectedvendor /cfquery /CFIF __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: populate a table
Yeah, I was just going by his original question which looked like a single INSERT statement to me, not with a nested SELECT. Useful recap though -Original Message- From: Ronald West [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 17:08 To: CF-Talk Subject: RE: populate a table Actually John, an insert statement can have a FROM clause. I believe that Robert might have been confused on the syntax, but if he wanted to say pass an Id for a chosen Vendor he could have performed the following: CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) SELECT vendor, contact, Address FROM vendor where vendor = #selectedvendor# /cfquery /CFIF Or something of the like ... where he would get the contact and address information from the vendor's table and insert it into the purchases table. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:47 AM To: CF-Talk Subject: RE: populate a table SQL Insert statements can't have a FROM clause in them...that could be an issue! -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 16:47 To: CF-Talk Subject: populate a table Hello, If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a syntax error with this though. Any better way? Robert O. CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) VALUES ( '#FORM.vendor#', '#FORM.contact#', '#FORM.Address#') from selectedvendor /cfquery /CFIF __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFEXECUTE
Hi, Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing software 0 - 100% bar? +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Download an Image
I want to grab an image which is located on a backend server and send it to the client browser. In this case, I can not simple send an img src= alt= border=0 tag in an html page (for reasons I can't get into and you probably do not want to hear about it anyway). In this case, I'm using cfhttp to get the binary file (image) from the backend server and using cfcontent to push the binary file to the client browser. Here is the code in my template: Begin getImage.cfm cfsetting enablecfoutputonly=Yes showdebugoutput=No catchexceptionsbypattern=No cfhttp url=http://www.ncsu.edu/design/slides/AccessDenied.gif; method=GET resolveurl=false/cfhttp !--- pre cfoutput#cfhttp.header#/cfoutputbr cfoutput--'#cfhttp.FileContent#'--/cfoutput /pre --- cfcontent type=image/gif reset=YEScfoutput#cfhttp.FileContent#/cfoutput End of getImage.cfm Here is an example of a URL that one would use: http://www.ncsu.edu/design/slides/getImage.cfm/jack.gif All I get is a page with an outlined box in place where the image is to go. I get no image. I'm able to view the properties when I right click in the area where the image should be. Any ideas. Thanks. Sincerely, Troy -- - Troy Simpson Applications Analyst/Programmer Microsoft Certified Systems Engineer Oracle Certified Professional DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFEXECUTE
Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing software 0 - 100% bar? Instead of a 0-100% bar (as you never know how long it's going to take), why not have a progress motion bar Basically something that moves back and forwards, sort of like the light on the front of the Knight Rider car g Anyways, to do this, CFOUTPUT some JavaScript which calls a function to update the bar and then CFFLUSH it Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXECUTE
At 05:27 PM 5/28/2002 +0100, you wrote: Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing software 0 - 100% bar? Instead of a 0-100% bar (as you never know how long it's going to take), why not have a progress motion bar Basically something that moves back and forwards, sort of like the light on the front of the Knight Rider car g Anyways, to do this, CFOUTPUT some JavaScript which calls a function to update the bar and then CFFLUSH it Are there any examples out there? Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFMAIL Outloook SentItems Folder
Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a way that mail sent using the CFMAIL tag could show in the senders SentItems folder in Outlook. Way beyond me. Thanks for any advice. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL Outloook SentItems Folder
Unless you're using a 3rd party cfx/mail tag (to hook into the exchange server) to do that for you the basic CFMAIL tag can't do this. ~Todd On Tue, 28 May 2002, Rollo, Jeff wrote: Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a way that mail sent using the CFMAIL tag could show in the senders SentItems folder in Outlook. Way beyond me. Thanks for any advice. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFEXECUTE
If only IE is required, you could use an IFRAME. This way you could have CFFLUSH on its own page and still keep your site design intact. Cheers, Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: May 28, 2002 10:41 AM To: CF-Talk Subject: RE: CFEXECUTE There's a drawback with CFFLUSH tho. You can't wrap any custom tags around it and ... the footer of the page will not show up until the whole page has been flushed. For example: CF_MySHELL --Flash tag here /CF_MyShell This won't work at all. It won't work with any cfoutputflush tag/cfoutput either. So, to me... CFFLUSH is practically useless unless it's on it's own blank page and ... the organization that I work for, that's not good enough, they want client branding to be on every page, etc. Ray Camden has a tutorial on the macromedia site: http://www.macromedia.com/v1/handlers/index.cfm?id=21216method=full ~Todd On Tue, 28 May 2002, phumes1 wrote: At 05:27 PM 5/28/2002 +0100, you wrote: Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing software 0 - 100% bar? Instead of a 0-100% bar (as you never know how long it's going to take), why not have a progress motion bar Basically something that moves back and forwards, sort of like the light on the front of the Knight Rider car g Anyways, to do this, CFOUTPUT some JavaScript which calls a function to update the bar and then CFFLUSH it Are there any examples out there? Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL Outloook SentItems Folder
Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a way that mail sent using the CFMAIL tag could show in the senders SentItems folder in Outlook. Way beyond me. Thanks for any advice. If you want sent items to be stored in the users' Exchange folders, your best bet is to just use a hyperlink with a mailto URL instead of a regular URL. You could conceivably integrate your server-side code with Exchange through CDO, but that's a decent amount of work. For more information on CDO, you might look at MSDN (http://msdn.microsoft.com/). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFEXECUTE
Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing software 0 - 100% bar? As several people have noted, you can simulate something like this in various ways. However, I don't think you can capture the actual status information. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Download an Image
I want to grab an image which is located on a backend server and send it to the client browser. In this case, I can not simple send an img src= alt= border=0 tag in an html page (for reasons I can't get into and you probably do not want to hear about it anyway). In this case, I'm using cfhttp to get the binary file (image) from the backend server and using cfcontent to push the binary file to the client browser. Here is the code in my template: Begin getImage.cfm cfsetting enablecfoutputonly=Yes showdebugoutput=No catchexceptionsbypattern=No cfhttp url=http://www.ncsu.edu/design/slides/AccessDenied.gif; method=GET resolveurl=false/cfhttp !--- pre cfoutput#cfhttp.header#/cfoutputbr cfoutput--'#cfhttp.FileContent#'--/cfoutput /pre --- cfcontent type=image/gif reset=YEScfoutput#cfhttp.FileContent#/cfoutput End of getImage.cfm Here is an example of a URL that one would use: http://www.ncsu.edu/design/slides/getImage.cfm/jack.gif All I get is a page with an outlined box in place where the image is to go. I get no image. I'm able to view the properties when I right click in the area where the image should be. I don't think you'll be able to just output CFHTTP.FileContent; that only works if it contains valid string data. Instead, you'll probably have to save the image to file in your CFHTTP tag, then use CFCONTENT to reference the file. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Easiest way to get horoscopes on my site?
My users want horoscopes. Are the any prepackaged horoscope grabbers that anybody is aware of? Thanks, Jon __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXECUTE
It all really depends what youre doing with this 1 minute page. if youre doing something in your db that you can query, then you can do so in a repeating manner and display the results each repeat. However, if its just a long query, then you cant do much other than check the indexes and try to make it go faster. DRE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:57 AM To: CF-Talk Subject: RE: CFEXECUTE Yeah, out in the real world being all-browser compatible is a must and that doesn't fly. :( Not to mention that the content that was 'flushed' is now in a minature IFRAME window. Have you worked with CFFLUSH? It's a cool feature, but ... it doesn't really work like people thinks it does. There's no way to query up a result set (complete with progress bars) and have the next page display that result set. That would be useful. ~Todd On Tue, 28 May 2002, Ben Arledge wrote: If only IE is required, you could use an IFRAME. This way you could have CFFLUSH on its own page and still keep your site design intact. Cheers, Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: May 28, 2002 10:41 AM To: CF-Talk Subject: RE: CFEXECUTE There's a drawback with CFFLUSH tho. You can't wrap any custom tags around it and ... the footer of the page will not show up until the whole page has been flushed. For example: CF_MySHELL --Flash tag here /CF_MyShell This won't work at all. It won't work with any cfoutputflush tag/cfoutput either. So, to me... CFFLUSH is practically useless unless it's on it's own blank page and ... the organization that I work for, that's not good enough, they want client branding to be on every page, etc. Ray Camden has a tutorial on the macromedia site: http://www.macromedia.com/v1/handlers/index.cfm?id=21216method=full ~Todd On Tue, 28 May 2002, phumes1 wrote: At 05:27 PM 5/28/2002 +0100, you wrote: Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing software 0 - 100% bar? Instead of a 0-100% bar (as you never know how long it's going to take), why not have a progress motion bar Basically something that moves back and forwards, sort of like the light on the front of the Knight Rider car g Anyways, to do this, CFOUTPUT some JavaScript which calls a function to update the bar and then CFFLUSH it Are there any examples out there? Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Download an Image
Philip, Sorry, that was by design. ;-) I altered the host name and URL because the actual systems are not accessible by the public. Next time I'll use a more truly fictitious host name and URL. Sorry about that. Troy Philip Arnold - ASP wrote: Not Found The requested URL /slides/getImage.cfm/jack.gif was not found on this server. Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 17:30 To: CF-Talk Subject: Download an Image I want to grab an image which is located on a backend server and send it to the client browser. In this case, I can not simple send an img src= alt= border=0 tag in an html page (for reasons I can't get into and you probably do not want to hear about it anyway). In this case, I'm using cfhttp to get the binary file (image) from the backend server and using cfcontent to push the binary file to the client browser. Here is the code in my template: Begin getImage.cfm cfsetting enablecfoutputonly=Yes showdebugoutput=No catchexceptionsbypattern=No cfhttp url=http://www.ncsu.edu/design/slides/AccessDenied.gif; method=GET resolveurl=false/cfhttp !--- pre cfoutput#cfhttp.header#/cfoutputbr cfoutput--'#cfhttp.FileContent#'--/cfoutput /pre --- cfcontent type=image/gif reset=YEScfoutput#cfhttp.FileContent#/cfoutput End of getImage.cfm Here is an example of a URL that one would use: http://www.ncsu.edu/design/slides/getImage.cfm/jack.gif All I get is a page with an outlined box in place where the image is to go. I get no image. I'm able to view the properties when I right click in the area where the image should be. Any ideas. Thanks. Sincerely, Troy -- - Troy Simpson Applications Analyst/Programmer Microsoft Certified Systems Engineer Oracle Certified Professional DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXECUTE
There's a drawback with CFFLUSH tho. You can't wrap any custom tags around it and ... the footer of the page will not show up until the whole page has been flushed. Well, that's hardly a drawback with CFFLUSH. If the footer is at the bottom of the page, why would anyone expect it to appear until the entire page has been sent to the browser? You can, however, work around this with judicious use of JavaScript, if that's an acceptable alternative. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Download an Image
Sorry, that was by design. ;-) I altered the host name and URL because the actual systems are not accessible by the public. Next time I'll use a more truly fictitious host name and URL. Sorry about that. That's OK, if you had used www.mydomain.com then I wouldn't have tried, but it looked like a real URL Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: CFEXECUTE
Well, that's hardly a drawback with CFFLUSH. If the footer is at the bottom of the page, why would anyone expect it to appear until the entire page has been sent to the browser? You can, however, work around this with judicious use of JavaScript, if that's an acceptable alternative. We have done pages where a Please wait, working message is displayed, along with the complete layout Then at the bottom of the page you have repeated JavaScript bits of code with CFFLUSH between then to move a counter/updater Then once it's finished, use a bit of JavaScript to move on - location.replace() This all relies on JS, but it's the easiest way to get a progress bar Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: CFEXECUTE
Javascript that has to work on Mac / PCs and about 200 (+1, Netscape 7pr1 was released) browsers. That's a nightmare in on itself, but yes, you're right. I'm not bashing you Dave - yes, there are workarounds, but it's not worth it. Now that I think about it, having a hidden frame would work as well.. but, these are pretty much established websites that I can't really be too 'creative' with because it's already set in place. So, I agree to all that's stated. IFRAME would work, Javascript would work, etc. I just think that it'd be nice for macromedia to further develop this tag to something useful (and, yes, I have requested it via wishlist). ~Todd On Tue, 28 May 2002, Dave Watts wrote: Well, that's hardly a drawback with CFFLUSH. If the footer is at the bottom of the page, why would anyone expect it to appear until the entire page has been sent to the browser? You can, however, work around this with judicious use of JavaScript, if that's an acceptable alternative. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 == Todd Rafferty ([EMAIL PROTECTED]) | http://www.web-rat.com/ | webRat @ ultrashock.com (Back-end Moderator) | webRat @ FlashCFM.com (Moderator)| == __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Scheduled Tasks
When I schedule a task to run weekly or monthly, it reverts back to daily. Is there a fix for this? I couldn't find one on MM's site. -Brad __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Download an Image
All, I also wanted to add that when I telnet to port 80 on the system here is what I get back: Begin - telnet host.ncsu.edu 80 Trying 1.1.1.1... Connected to host.ncsu.edu. Escape character is '^]'. HEAD /design/slides/Search/getImage.cfm//jack.gif HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Tue, 28 May 2002 17:03:11 GMT Content-type: image/gif Page-Completion-Status: Normal Page-Completion-Status: Normal Set-Cookie: CFID=7399; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; domain=.1.1.1; Set-Cookie: CFMAGIC=7399%3A62418778; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; domain=.1.1.1; Set-Cookie: CFTOKEN=62418778; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; domain=.1.1.1; GIF89aConnection closed by foreign host. --- End Troy Philip Arnold - ASP wrote: Not Found The requested URL /slides/getImage.cfm/jack.gif was not found on this server. Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 17:30 To: CF-Talk Subject: Download an Image I want to grab an image which is located on a backend server and send it to the client browser. In this case, I can not simple send an img src= alt= border=0 tag in an html page (for reasons I can't get into and you probably do not want to hear about it anyway). In this case, I'm using cfhttp to get the binary file (image) from the backend server and using cfcontent to push the binary file to the client browser. Here is the code in my template: Begin getImage.cfm cfsetting enablecfoutputonly=Yes showdebugoutput=No catchexceptionsbypattern=No cfhttp url=http://www.ncsu.edu/design/slides/AccessDenied.gif; method=GET resolveurl=false/cfhttp !--- pre cfoutput#cfhttp.header#/cfoutputbr cfoutput--'#cfhttp.FileContent#'--/cfoutput /pre --- cfcontent type=image/gif reset=YEScfoutput#cfhttp.FileContent#/cfoutput End of getImage.cfm Here is an example of a URL that one would use: http://www.ncsu.edu/design/slides/getImage.cfm/jack.gif All I get is a page with an outlined box in place where the image is to go. I get no image. I'm able to view the properties when I right click in the area where the image should be. Any ideas. Thanks. Sincerely, Troy -- - Troy Simpson Applications Analyst/Programmer Microsoft Certified Systems Engineer Oracle Certified Professional DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP question
Hello all, I have a forecast email that comes out a couple of times a day. I need to extract the numbers and discussion from it and post the information into a database. I am using CFPOP to get the email from the server, I need to know how do get just the information I want from it. So in the following example, I need to pull out the 50, 0.064, 39, 0.050 and the Discussion paragraph and stick each one into an access database. I know how to do the database part, I just need to know how I extract out the parts from the message I need. Regular expressions? - MAIL FROM CFPOP - Yesterday's regional maximum AQI (ppm): 44 (0.056) - Good Today's forecasted regional maximum AQI (ppm): 50 (0.064) - Good Tomorrow's forecasted regional maximum AQI (ppm): 39 (0.050) - Good Discussion: Weak surface high pressure over the region has resulted in light easterly winds today. Despite mostly clear skies and warm surface temperatures, the temperature inversion is weak, so ozone levels will be Good. Tomorrow, an upper-level trough of low pressure will move through the region, which will enhance vertical mixing, resulting in mostly cloudy skies and scattered rain showers. These conditions will keep ozone levels Good. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
generate multiple PDFs automatically
Hello all: Here's the situation I am facing: We have a huge recordset - maybe around 5000-6000 records that we would like to use to create PDF reports on the fly and print. I am using FDFs to create a single PDF report from this dataset, but this would be extremely slow and painful to have a user manually call each record and then print and them move on to the next one. Does anyone have any ideas how this can be automated? Thanks in advance, Dimo __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Download an Image
Do you only have HTTP access to the other server, or does it have a Share to the images? If you can share to it, then CFCONTENT the file via a UNC across the network Otherwise, you'll have to do what Dave said - store the file locally, then CFCONTENT that Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Populating the body of an outlook message
Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Adding Properties to Form elements?
I once came across an article that explained how to use your own properties within a form field for form validation. Something like this: input name=MyText type=text MyProperty= I know the HTML parsers would ignore the MyProperty in the above tag, and this article I saw detailed how to access this property via JS. However, as always, finding the article now is not happening. We have tried document.forms[0].MyText.MyProperty but get a property is undefined error. Can someone tell me how to get access to the value of MyProperty? Or am I out to lunch on this? Thanks in advance. Shawn Grover __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help! CFLOCATION and mystery output of HTTP header
Thanks for this tip Dave, I didn't even know tools like this were around. Sometimes it really pays to lurk :) Marlon At 05:54 PM 5/27/2002 -0400, you wrote: Is it worth tracking down some info on HTTP headers and how CFLOCATION might be getting this wrong? This is a perfect example of when to use a recording proxy for testing. This will show you exactly what headers are being passed between the browser and the server, and should help you to determine why your problem is occurring. You can easily set this up. Just download the recording proxy of your choice, configure it to forward requests to your server, and point your browsers at it. You'll be able to see the actual HTTP request and response headers, and that should give you the information that you need. You can find a recording proxy here: http://www.kestral.com.au/devtools/stretch/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Populating the body of an outlook message
try looking at http://developer.netscape.com/viewsource/husted_mailto/mailto.html seems to cover what you need. will -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 18:45 To: CF-Talk Subject: Populating the body of an outlook message Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Populating the body of an outlook message
Is CFMAIL not an option. If it is you can do whatever you want through CFMAIL.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 12:45 PM To: CF-Talk Subject: Populating the body of an outlook message Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Adding Properties to Form elements?
I once came across an article that explained how to use your own properties within a form field for form validation. Something like this: input name=MyText type=text MyProperty= I know the HTML parsers would ignore the MyProperty in the above tag, and this article I saw detailed how to access this property via JS. However, as always, finding the article now is not happening. We have tried document.forms[0].MyText.MyProperty but get a property is undefined error. Can someone tell me how to get access to the value of MyProperty? Or am I out to lunch on this? Thanks in advance. Shawn Grover __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduled Tasks
- Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 11:18 AM Subject: Scheduled Tasks When I schedule a task to run weekly or monthly, it reverts back to daily. Is there a fix for this? I couldn't find one on MM's site. I don't believe the schedule actually changes to daily, but there's a bug in the Administrator that you need to be aware of. Whenever you edit a task, the select box always switches to 'daily'. As long as you remember (not easy, I know) to double-check this and set it to weekly or monthly, you'll be OK. Jim __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Download an Image
I believe I have run into another snag. When I use cfhttp url=http://www.mydomain.com/design/slides/0202/10780.jpg; method=GET resolveurl=false/cfhttp to get the image, it appears that #cfhttp.FileContent# does not contain the binary of the image file. Instead, it is a text string. In the case with Gif images, it is something like GIF89a instead of the binary of the file. I believe that cfhttp can not be used to get binary files from another web server? Can someone confirm this for me? I wonder if cfftp would work? Troy Philip Arnold - ASP wrote: Do you only have HTTP access to the other server, or does it have a Share to the images? If you can share to it, then CFCONTENT the file via a UNC across the network Otherwise, you'll have to do what Dave said - store the file locally, then CFCONTENT that Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dynamic query woes
dave, i would re-write that section of ASP code to correct both the sql string and the startdate, enddate format as follows: % Dim StartDate, EndDate StartDate = Request(s_month) / Request(s_day) / Request(s_year) EndDate = Request(e_month) / Request(e_day) / Request(e_year) qSearch = SELECT TypeOfEvent,EventText,ModifiedDateTime,ModifiedBy,ActionPerformed qSearch = qsearch FROM tbl_auditlog qSearch = qsearch WHERE 0=0 If Request(TypeOfSearch) All then qSearch = qSearch AND TypeOfEvent = Request(TypeOfSearch) End If If Request(SearchByDateRange) = yes then qSearch = qSearch AND ModifiedDateTime BETWEEN ' StartDate ' qSearch = qSearch AND ' EndDate ' End If qSearch = qSearch ORDER BY TypeOfEvent, ModifiedDateTime % ~ dina __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Populating the body of an outlook message
Yup. Url parameters for the mailto tag. mailto:[EMAIL PROTECTED]?subject=123body=456 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:45 AM To: CF-Talk Subject: Populating the body of an outlook message Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: generate multiple PDFs automatically
Could use a LOOP to generate them however that is alot to handle. Another note is that I am not sure there is a way to FORCE the print. You can force the print dialog box but not the actual print that I am aware of. Randy Adkins [EMAIL PROTECTED] 05/28/02 13:37 PM Hello all: Here's the situation I am facing: We have a huge recordset - maybe around 5000-6000 records that we would like to use to create PDF reports on the fly and print. I am using FDFs to create a single PDF report from this dataset, but this would be extremely slow and painful to have a user manually call each record and then print and them move on to the next one. Does anyone have any ideas how this can be automated? Thanks in advance, Dimo __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Open XLS outside IE...
Is it possible to open an XLS file with the standalone Excel program, rather than the embedded Excel when using IE? If that is not completely clear, this is the scenario: Currently, when an XLS file is viewed, IE spawns an Excel instance within the browser (if not technically correct, I think you get my point) as opposed to opening the standalone Excel program as Netscape does. However, what I'd like to do is open the XLS file in a standalone instance of Excel (which mimics Netscape's method). The only thing I can think of right now is to put a bogus file extension on the file, and when the user is prompted to open the file, choose Excel from the list of programs that pops up. However, I'd like to avoid having the user involved and make that process transparent. Is there a way to do this? Thanks, Dave. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXECUTE
Let me give an example here so people know I'm not talking out my butt. I went through extensive research to figure this all out and then scrapped [CFFLUSH] because it didn't work the way everyone thinks it does. While I'm not accusing you of talking out your butt, since you're not Jim Carrey, I don't think that it's fair to state that CFFLUSH doesn't work the way everyone thinks it does. What CFFLUSH does is very simple - it flushes the already-generated output currently stored in CF's page buffer and sends that output to the browser. That's all - and I don't think most people expect it to do more than that. If you use CFFLUSH within a custom tag block, or any other tag within a custom tag block for that matter, the tag won't actually do anything until the end tag of the custom tag block is itself processed, unless the tag is one that aborts processing (CFABORT, CFEXIT, CFLOCATION). If you use CFFLUSH in the middle of a page, the following commands won't send text to the browser until the page is complete, or until another CFFLUSH tag executes within the page. Neither of these are limitations with Macromedia's CFFLUSH implementation; the first is just how custom tags work (if they didn't work that way, you wouldn't be able to play around with ThisTag.GeneratedContent during the end tag's execution) and the second is just common sense - how could CFFLUSH return the top and the bottom of a page, but not the middle? CFFLUSH really is a useless tag unless you're trying to do a very _basic_ thing with it. Anything fancy beyond the basic will disappoint you. Macromedia should flesh it out some more, but I'm sure they're answer would be use Flash MX, have a nice day. I'd argue that there isn't much that Macromedia can do about this - it's more a limitation of how browsers work, rather than something that could be fixed by more effort on the part of MM developers. So, yes, to that extent, if you want to do something that the browser is simply unable to do, their answer would be to use Flash MX, I suppose. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Easiest way to get horoscopes on my site?
http://www.google.co.uk/search?hl=enie=UTF8oe=UTF8q=horoscope+feedsb tnG=Google+Searchmeta= Erika | -Original Message- | From: Jon Block [mailto:[EMAIL PROTECTED]] | Sent: 28 May 2002 18:00 | To: CF-Talk | Subject: Easiest way to get horoscopes on my site? | | | My users want horoscopes. Are the any prepackaged horoscope | grabbers that anybody is aware of? | | Thanks, | Jon | | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Repost: CFFTP 500 Invalid PORT Command.
My setting are very basic. The Web server is IIS on Win2k The FTP server is the built-in FTP Server of IIS. I keep all the default settings. (didn't change anything). I was able to connect to the server but when trying to list all files/directories, I got that error. any advice? thanks -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 3:25 AM To: CF-Talk Subject: RE: Repost: CFFTP 500 Invalid PORT Command. Does anybody know what causes Error 500 invalid port Command using CFFTP? Which web server are you CFFTPing to Some don't allow FTP access unless it's got the proper header information Also, CFFTP requires a certain amount of responses to work, so if it's a limited FTP server, then it might be causing problems Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL Outloook SentItems Folder
On Tue, 28 May 2002 12:44:25 -0400, in cf-talk you wrote: Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a way that mail sent using the CFMAIL tag could show in the senders SentItems folder in Outlook. Way beyond me. Thanks for any advice. The easiest way is to CC it to their mail account and tell them to make a filter to move it to their Sent folder. That's not a joke. The other way -- the way of masochists -- is to write an actual ActiveX applet. It can be done. I wrote an applet a few months back in fact that mucked around with Outlook's WAB and extended MAPI, etc. Rather challenging. You should expect to spent somewhere between a week and six months writting it though. :) If you know VB or C++ (or Delphi) I can give you pointers where to start, otherwise --min __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL Outloook SentItems Folder
On Tue, 28 May 2002 12:44:25 -0400, in cf-talk you wrote: Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a way that mail sent using the CFMAIL tag could show in the senders SentItems folder in Outlook. Way beyond me. Thanks for any advice. Ah, wait. I missed where you said intranet only (Was thinking of donuts. Seriously.) In that case... you won't need to use activex. Might not be that difficult at all using CDONTS. (yum, DONuTS). Never used it myself - used other API's to chat with mail servers. Over on microsoft's news server there are two or three (large) newsgroups that specifically cater to this subject - the folks there chatter quite a bit about CDO. --min __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Query question
Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. Thanks, Trace __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ORDER BY question
ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... !--- tblJobTitle.TitleID Partner=25 Principal=26 Senior Associate=28 Associate=4 --- Thanks -paul __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Killing a cached query
What is the best way to 'kill' a cached query on a logout sequence? Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORDER BY question
ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... !--- tblJobTitle.TitleID Partner=25 Principal=26 Senior Associate=28 Associate=4 --- Thanks -paul __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query question
Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. Thanks, Trace __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Download an Image
I believe I have run into another snag. When I use cfhttp url=http://www.mydomain.com/design/slides/0202/10780.jpg; method=GET resolveurl=false/cfhttp to get the image, it appears that #cfhttp.FileContent# does not contain the binary of the image file. Instead, it is a text string. In the case with Gif images, it is something like GIF89a- instead of the binary of the file. I believe that cfhttp can not be used to get binary files from another web server? Can someone confirm this for me? No, you can use CFHTTP to get a binary file. You just can't reference CFHTTP.FileContent in that case. Instead, use the PATH and FILE attributes of CFHTTP to write the file to disk. I wonder if cfftp would work? Only if the remote server is running an FTP service. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ORDER BY question
Create a new field called Sequence or something. Based on the data and the two elements you displayed there is no way without Hard-Coding it. Randy Adkins [EMAIL PROTECTED] 05/28/02 15:39 PM ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... !--- tblJobTitle.TitleID Partner=25 Principal=26 Senior Associate=28 Associate=4 --- Thanks -paul __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Populating the body of an outlook message
Yes, try this: a href=mailto:[EMAIL PROTECTED]?subject=Hey therebody=Hello, long time no seeClick here/a You can pass the subject and body of a message through URL parameters. - Matt Small -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 1:45 PM To: CF-Talk Subject: Populating the body of an outlook message Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Adding Properties to Form elements?
I once came across an article that explained how to use your own properties within a form field for form validation. Something like this: input name=MyText type=text MyProperty= I know the HTML parsers would ignore the MyProperty in the above tag, and this article I saw detailed how to access this property via JS. However, as always, finding the article now is not happening. We have tried document.forms[0].MyText.MyProperty but get a property is undefined error. Can someone tell me how to get access to the value of MyProperty? Or am I out to lunch on this? Thanks in advance. Shawn Grover __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Appologies
My appologies for my recent barage of the same question (OT: Adding Properties to Form elements?). The list sent me messages saying (1) it was too big, and (2) I had a signature block that appeared I was going on vacation. I didn't think the message made it through. Shawn Grover __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: generate multiple PDFs automatically
It sounds like you need activepdf at http://www.activepdf.com. If you just need printed reports, use COM and Word. It's a lot cheaper. http://www.cfcomet.com - Matt Small -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:05 PM To: CF-Talk Subject: Re: generate multiple PDFs automatically Could use a LOOP to generate them however that is alot to handle. Another note is that I am not sure there is a way to FORCE the print. You can force the print dialog box but not the actual print that I am aware of. Randy Adkins [EMAIL PROTECTED] 05/28/02 13:37 PM Hello all: Here's the situation I am facing: We have a huge recordset - maybe around 5000-6000 records that we would like to use to create PDF reports on the fly and print. I am using FDFs to create a single PDF report from this dataset, but this would be extremely slow and painful to have a user manually call each record and then print and them move on to the next one. Does anyone have any ideas how this can be automated? Thanks in advance, Dimo __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query question
You need to use a union join. Adam. -Original Message- From: Trace [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:36 PM To: CF-Talk Subject: Query question Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. Thanks, Trace __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Query question
What are you trying to get? 1. a query with all the titles from pages added to all the names from categories? 2. a single field that concatenates the title and the name together? 3. something I'm not seeing? Jerry Johnson [EMAIL PROTECTED] 05/28/02 02:53PM Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. Thanks, Trace __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query question
Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. There's no way around this; that's just the way SQL works! Even if it did work - that is, if it didn't produce an error - what would you want this to do? If you're trying to build one field that contains both of the other fields, you can do that by simple concatenation: SELECT tbl_Pages.title + ' ' + tbl_Categories.Name AS hyperlink_title ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apologies
My apologies for my recent barage of the same question (OT: Adding Properties to Form elements?). The list sent me messages saying (1) it was too big, and (2) I had a signature block that appeared I was going on vacation. I didn't think the message made it through. I just got the same messages after I posted, for some reason. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query question
Trace, What exactly is your intent? It seems that you want to create a list of all the hyperlink_title values, whether they appear in tbl_Pages or tbl_Categories. Is that right? In other words, if you have tbl_Pages: tbl_Pages_pk hyperlink_title 1 A 2 B 3 C ..and tbl_Categories: tbl_Categories_pk hyperlink_title 1 X 2 Y 3 Z ..your query output would be A, B, C, X, Y, Z. Is that what you want? I think that the trick is a union query. Try something like this: cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title FROM tbl_Pages UNION SELECTtbl_Categories.Name AS hyperlink_title FROM tbl_Categories /cfquery Hope that helps, Matthieu -Original Message- From: Trace [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 3:36 PM To: CF-Talk Subject: Query question Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. Thanks, Trace __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
spawning new windows
Hi, everyone. I have a challenge for you. I want to spawn a new (2nd)
browser window, but I don't want it to use JavaScript. And I want to do it
from any page on a site, so I want to put a test in Application.cfm that
initiates the process.
More specifically:
User loads page on site.
Application.cfm does test for a cookie, finds that it fails.
Page requested is sent back to user, but includes {SOME KIND OF HTML} that
forces a second new window to load, displaying a message.
-or-
Page requested is sent back to user, AND CFAS sends a second page back to
new user as a second window.
I assume that there's no way to do the latter option. I've looked for
CFHEADER code that would work, but couldn't find anything. If there is HTML
that does this automatically, I haven't found it. I heard of a
href=blahblah actuate=auto, but then couldn't find documentation on it.
Any ideas?
Thanks,
Matthieu
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
Dynamically Processing Form Values
Hello all. New to the list - Hope someone can help me. Of course time is somewhat urgent on this. I have a lengthy form page. It is created through 5 cfqueries for eachmain subject. The entire page is a form. I have javascript arrays that populate a summary area on the fly when someone enteres a quantity. Each product has a unique identifiersproduct0 - producti - whatever the recordcount is. So another words - it loops through all records.. starting with product0 and currently ending in product79 Each product has about 4 form values I need to process.. So product0 - has itemqty0, itemdesc0, itemname0 and so on. BUT I ONLY want products that have itemQty ( quantity) that is GT 0 to display.With 79 products - each with 4 pieces of information - that becomes 316 of #FORM.Product0# #FORM.ItemQty0# and so on. The latest thing I tried was very straightforward.. except too straigh forward.. do not know how to interject and only spit out the variabls with itemqty of GTE 1 CFLOOP COLLECTION=#form# ITEM=myfield #variables.myfield# : #form[myfield]# /CFLOOP In my head it seems o straightforward.. but whatever I have tried does not produce the right results. So to recap my request. I have over 300 form values on the form page. On the Form Process page - I wish to spit back out ONLY those that have a value in the qty field of 0 or better. Whatever I attempt I am unable to get this to work - seems like it should be so simple. Any help is GREATLY appreciated. Thanks, Jason Miller __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adding Properties to Form elements?
Try MyText.MyProperty.value -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:47 PM To: CF-Talk Subject: OT: Adding Properties to Form elements? I once came across an article that explained how to use your own properties within a form field for form validation. Something like this: input name=MyText type=text MyProperty= I know the HTML parsers would ignore the MyProperty in the above tag, and this article I saw detailed how to access this property via JS. However, as always, finding the article now is not happening. We have tried document.forms[0].MyText.MyProperty but get a property is undefined error. Can someone tell me how to get access to the value of MyProperty? Or am I out to lunch on this? Thanks in advance. Shawn Grover __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: generate multiple PDFs automatically
check cfcomet.com - I just saw a tidbit in there on creating pdf's on the fly.. I think there are less than a dozem posts in the PDF section - so it should be easy to find. I am 100% I saw it there. Jay Miller Randell B Adkins wrote: Could use a LOOP to generate them however that is alot to handle. Another note is that I am not sure there is a way to FORCE the print. You can force the print dialog box but not the actual print that I am aware of. Randy Adkins [EMAIL PROTECTED] 05/28/02 13:37 PM Hello all: Here's the situation I am facing: We have a huge recordset - maybe around 5000-6000 records that we would like to use to create PDF reports on the fly and print. I am using FDFs to create a single PDF report from this dataset, but this would be extremely slow and painful to have a user manually call each record and then print and them move on to the next one. Does anyone have any ideas how this can be automated? Thanks in advance, Dimo __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Query question
It was for concatenating the 2 fields into one. But Dave answered my question. Thank you, Trace - Original Message - From: Jerry Johnson To: CF-Talk Sent: Tuesday, May 28, 2002 1:04 PM Subject: Re: Query question What are you trying to get? 1. a query with all the titles from pages added to all the names from categories? 2. a single field that concatenates the title and the name together? 3. something I'm not seeing? Jerry Johnson [EMAIL PROTECTED] 05/28/02 02:53PM Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. Thanks, Trace __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apologies
I am having the same problem.. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 3:03 PM To: CF-Talk Subject: RE: Apologies My apologies for my recent barage of the same question (OT: Adding Properties to Form elements?). The list sent me messages saying (1) it was too big, and (2) I had a signature block that appeared I was going on vacation. I didn't think the message made it through. I just got the same messages after I posted, for some reason. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: spawning new windows
just use target=_blank in a cflocation or a meta rfresh tag.
If you don't use java however - it may be a bit difficult instructing the size or
parameters of the window.. but if
that doesn't matter - the above should work.
hoep this helps
jay miller
Cornillon, Matthieu wrote:
Hi, everyone. I have a challenge for you. I want to spawn a new (2nd)
browser window, but I don't want it to use JavaScript. And I want to do it
from any page on a site, so I want to put a test in Application.cfm that
initiates the process.
More specifically:
User loads page on site.
Application.cfm does test for a cookie, finds that it fails.
Page requested is sent back to user, but includes {SOME KIND OF HTML} that
forces a second new window to load, displaying a message.
-or-
Page requested is sent back to user, AND CFAS sends a second page back to
new user as a second window.
I assume that there's no way to do the latter option. I've looked for
CFHEADER code that would work, but couldn't find anything. If there is HTML
that does this automatically, I haven't found it. I heard of a
href=blahblah actuate=auto, but then couldn't find documentation on it.
Any ideas?
Thanks,
Matthieu
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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: spawning new windows
Hi, everyone. I have a challenge for you. I want to spawn a new (2nd) browser window, but I don't want it to use JavaScript. This can't be done. If you want to programmatically open a new window, that'll require JavaScript (or something even more complex, like ActiveX) - you can't do it with just HTML. You can build a hyperlink that, when clicked, will open the target document in a new window, but the user would have to click on the hyperlink. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
