RE: Menu Custom Tags
This is an excellent DHTML menu, easy to use and customiseable. I use CF to generate dynamic menus with it. And it's free. http://linux.milonic.co.uk/menu/ -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 07:19 To: CF-Talk Subject: Re: Menu Custom Tags CF_Hiermenus. Actually its a great script without the CF wrapper, albeit a tad slow. Unmatched in its cross-browser compatibility, I think. Go to palm.com to see one of its nicer iterations. Also lucent.com; unisys.com; webtrends.com. With a bit of serious elbow grease you can completely data-drive the thing (generating the controlling hmarrays.js via CF). - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 9:26 PM Subject: Menu Custom Tags Can anyone reccomend a custom tag for Menus (DHTML, or anything else)??? Thanks, Mike ~~ 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
Browse local files
Hi I want to search for a file on the local machine to read and put its contents on a Db on the server! My que is how do I browse thru the files on the machine looking for it you know like what CF Server does when u are adding a datasource Thank you Cell: 091 268 728 A good name is to be chosen rather that great riches, and favor is better than silver or gold - Prov 22 v 1 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.286 / Virus Database: 152 - Release Date: 10/9/01 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help - SQL to Excel
Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Cheers, ~~ 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: sessions and shopping carts
On 11/1/01, James Sleeman penned: CFIF NOT Compare(variables.ReferTest,0) OR NOT Compare(cgi.http_referer,) !--- uh. oh. Reset the session ID --- /CFIF Aha ! therein lies the problem... how does one go about resetting the session ID.. there is no CF function resetSessionID(), I could redirect to another page without adding the URLToken, but CF is just going to set it in a cookie anyway (presuming for the moment that the user has cookies enabled), Not if you use setclientcookies=no in your cfapplication tag. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Browse local files
I want to search for a file on the local machine to read and put its contents on a Db on the server! My que is how do I browse thru the files on the machine looking for it you know like what CF Server does when u are adding a datasource input type=file name=whatever Then use CFFile action=upload to save it No open the file with CFFile action=read and save it to the database Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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
RE: Help - SQL to Excel
Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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
RE: Help - SQL to Excel
Cheers, Found a custom tag (Query2Excel) that does exactly what I wanted. Nick -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 11:55 To: CF-Talk Subject: RE: Help - SQL to Excel Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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: Oracle Help
Dumb question, but, are you sure you have the username and password correct in CFAdministrator. Also, do you have something like Oracle DBA Studio or Enterprise Manager that you can connect with? If so, the problem is with your CF Administrator settings. If not, then check the TNSNames.ora file. Also, are you trying to use ODBC or the Native Drivers. If you are using ODBC, be sure and use the Microsoft ODBC for Oracle drivers. Dave - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 11:47 PM Subject: Re: Oracle Help On my CF5/Win2k machine with Oracle 8.0.5 client, my CF administrator says not verified - but the datasource works just fine... I need some help with Oracle - I am not able to connect to my oracle dbase from within cf administrator - it simply gives the not verified message. The trouble is I am not entirely sure what the host string is supposed to look like in the input box - is it dbasename/username@hostname or nothing like the above? I hope someone can help with this. Cheers Simon ~~ 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
Virus checking uploads
Hi, We've got to develop a facility whereby users can upload material to a server via a cfm page, but we need to have some kind of virus checking software to check all uploads first. Does anyone know of anything already out there and how much it would cost? Thanks in advance, Kath Katherine Maltby Web Production Director -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 488 9131 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~~ 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: CF Security Holes, what are the biggies?
Can anybody tell me the most glaring secutiy holes associated with CF, in particular CFFILE? People have been hacking some sites of mine and I think Do you restrict the file types that can be uploaded (via the CFFILE attribute)? Do you pass the path to the file once it's been uploaded as a URL variable or a form field so that someone could either (i) view them or (ii) edit them? -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: CFX_HTTP
For the rest of us...where did you get it? Someone e-mailed it to me. I'll stick it on my site this weekend. The URL will be http://www.thenetprofits.co.uk/coldfusion/tags/ Anyone feel free to nag me if I forget to do it. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: Generating reports in the background (update)
Let the invisible frame run the .cfm report and notify the visible frame when it's done. After being notified, the visible page doesn't load the reports page directly (this would run the report all over again). Instead, it load the variable into which the reports page has stored all its processed results. Thanks, but I think this is more-or-less what's already happening. Specify report criteria - Insert database record with all report parameters - Framed page (i) Your report is being created. Click here to return to the application. (ii) Invisible frame source calls report generation page via CFHTTP. Passes ReportID. CreateReport.cfm Creates report based on ReportID value passed as form field. The report is written as an HTML string to a .cfm file stored on the server. The filename is then written to the report record in the db. View Reports Does a db query and lists all reports that have a FileCreated flag set to true (so you can't view reports that have only just been specified but which haven't yet been created). Frame source (i) takes a while to load (more than the few seconds it would take if it was on its own). On it, there's one link with TARGET=_top in it, to remove the invisible frames. When you click on that link, it takes *forever* to load the next page. It seems to take as long to load that page as it takes to generate the report. Maybe that's just because I'm working on the development box. Trouble is, I can't upload it to the better-specced production box until I'm sure it's all working OK. Thanks for your help. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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
Quasi OT: DHTML Menus
Any suggestions for a good DHTML menu system? I'm looking around and trying to find one that is fairly cross browser compatible, lightweight, etc., updated for new browser types, etc... Thanks, ~~ 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
Cross Selects
Anyone have any experience with custom tags known as Cross Selects? This is used in a form and provides two textarea boxes. Values in the left box can be selectively moved to the box on the right. My problem, getting the box on the left to be populated from a query (and behaving like a scrolling list), instead of hard coding values in the tag. I've tried loops, outputs, etc. with no effect (I only am able to display the first record of a multiple record query). Any ideas on how to do this dynamically? Thanks, Mark ~~ 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: locking within CFSCRIPT
Pete, you are right concerning cfscript but I can't see the limitations regarding UDFs. A UDF pre se is meant to be self-contained and therefore not relying on anything outside it's own scope. Wouldn't the use of shared data inside a UDF be defeating this purpose? You could read a shared scope variable into a local variable and get that into the UDF do what ever you do and than return a new value, write that value into your shared data. Birgit Thursday, November 01, 2001, 12:34:02 AM, you wrote: PF Nope. It's a big limitation for CFSCRIPT and UDF's PF + PF Pete Freitag ([EMAIL PROTECTED]) PF CFDEV.COM PF ColdFusion Developer Resources PF http://www.cfdev.com/ PF -Original Message- PF From: James Sleeman [mailto:[EMAIL PROTECTED]] PF Sent: Thursday, November 01, 2001 12:30 AM PF To: CF-Talk PF Subject: locking within CFSCRIPT PF Hi all, PF I have a situation where I would like to write a UDF to perform PF the same task as a custom tag does at the moment, problem is I need to be PF able to perform locking operations in the UDF. Are there functions, say PF lock() and unlock() that can do the same function as CFLOCK/CFLOCK PF within a CFSCRIPT block ? PF -- PF James Sleeman PF Innovative Media Ltd PF Phone: (03) 377 6262 PF http://www.websolutions.co.nz/ PF CAUTION: The information contained in this email message is confidential PF and may be legally privileged. If the reader of this message is not the PF intended recipient you are notified that any use, dissemination, PF distribution or reproduction of this message is prohibited. If you have PF received this message in error please notify the sender immediately and PF destroy the original message and any attachments. PF Views expressed in this communication may not be those of Innovative Media PF Ltd. PF ~~ 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: Virus Checking Uploads
McAffee, as I'm sure others, delivers an executable that you can use to scan files on upload. You would use cfexecute then pass any args. McAffee's utility comes with a test virus you can use. JS ~~ 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: Cross Selects
don't use textarea but used select box multiple you can display all you recordset in option yanton - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, 01 November, 2001 8:40 PM Subject: Cross Selects Anyone have any experience with custom tags known as Cross Selects? This is used in a form and provides two textarea boxes. Values in the left box can be selectively moved to the box on the right. My problem, getting the box on the left to be populated from a query (and behaving like a scrolling list), instead of hard coding values in the tag. I've tried loops, outputs, etc. with no effect (I only am able to display the first record of a multiple record query). Any ideas on how to do this dynamically? Thanks, Mark ~~ 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: SQL Server 2000 desktop version.
Hey gang: I attended an MS developer session where they said that SQL Desktop will run you about $50 per seat license. That was probably Canadian funds, so that's about, what, $1 American? ;) ... Patrick Harkins At 01:11 PM 30/10/2001 -0800, Costas Piliotis wrote: And for the most part, it looks like MSDE and Personal Edition are the same except the Desktop Edition comes with the Tools (EM, QA, Profiler). Desktop Engine is just the database. So I don't stand corrected :-) -Original Message- From: Costas Piliotis Sent: Tuesday, October 30, 2001 12:56 PM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. Ahhh... Ooops... I stand corrected. There's a first for everything =) Here's Microsoft's link to a comparison: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ ar_sa2_9gz4.asp -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:01 AM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. It's called msde. It comes with Office 2000/XP. Not Really a desktop edition but rather a scaled down implementation of SQL Server. As far as I know, if you have an Office 2000/XP licence, you have a MSDE licence as well. MSDE isn't the same as SQL Server Desktop Edition. With SQL Server, you could install the Desktop Edition on a Windows 98 machine, for example, and you'd get the core SQL Server engine (with some pretty severe size and functionality limitations) and the Enterprise Manager tools. MSDE, on the other hand, is simply the SQL Server engine (with its own, different, set of limitations), with no Enterprise Manager tools. If you develop applications with Visual Studio, you can redistribute MSDE with those applications, as an alternative to using Access. You can't redistribute SQL Server Desktop Edition. Do you need a license to install the desktop version of SQL Server 2000? As for needing a license to install SQL Server Desktop Edition, I'm sure you need one, but I don't know how much it is. You'd also need licenses for connections, I suspect, if you were to actually have any connections to it. 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: Cross Selects
Yes, I have placed the Select box/multiple code within the custom tag, which I can't get to work. The custom tag only seems to allow comma delimited hard code text. Mark -Original Message- From: Yanton [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:00 AM To: CF-Talk Subject: Re: Cross Selects don't use textarea but used select box multiple you can display all you recordset in option yanton - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, 01 November, 2001 8:40 PM Subject: Cross Selects Anyone have any experience with custom tags known as Cross Selects? This is used in a form and provides two textarea boxes. Values in the left box can be selectively moved to the box on the right. My problem, getting the box on the left to be populated from a query (and behaving like a scrolling list), instead of hard coding values in the tag. I've tried loops, outputs, etc. with no effect (I only am able to display the first record of a multiple record query). Any ideas on how to do this dynamically? Thanks, Mark ~~ 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: Three select
There is a typo in the javascript code and I can't remember where it is - somebody needs to sit down and rewrite this tag! Does anybody know of an open source depository for this tag - where developers can upload their fixes? -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 10:24 AM To: CF-Talk Subject: Three select I am using the cf_threeselectrelated tag. There are a few things that have come up and I'm wondering how others have handled it. I hope I can explain the behavior clearly, because it is somewhat odd/confusing when the back button is used. A user chooses from select box 1 and 2 and (maybe) 3 and chooses from a variety of report styles (different excel reports showing different info). They view their report then retun to the three select page using the back button and if they want to just hit a different report for the same group already chosen: 1. If they previously chose the 1st choice in the 2nd select box they get an error. The error says Incorrect syntax near ')' so it's reading the query as (Choose.Choice2=) instead of (Choose.Choice2=#Choose.Choice2#) 2. If they previously chose any other choice in the 2nd box they don't get an error, but the excel report comes up with just the information listed from the 1st box (it doesn't filter the 2nd box) 3. The options from the 2nd/3rd box disappers when they retun to the page. So if the user wants to keep the same info for the 1st box but wants to change the option in the 2nd/3rd boxes they have to click a different option in the 1st box than re-click on the original choice. Ideally I would like the user to be able to look at their excel sheet, hit the back button, then click on the next report keeping the same filters in place until others are choosen... Is this possible? Thanks in advance! ~~ 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: Three select
Forcewidth4 should be forcewidth3 Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:21 AM To: CF-Talk Subject: RE: Three select There is a typo in the javascript code and I can't remember where it is - somebody needs to sit down and rewrite this tag! Does anybody know of an open source depository for this tag - where developers can upload their fixes? -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 10:24 AM To: CF-Talk Subject: Three select I am using the cf_threeselectrelated tag. There are a few things that have come up and I'm wondering how others have handled it. I hope I can explain the behavior clearly, because it is somewhat odd/confusing when the back button is used. A user chooses from select box 1 and 2 and (maybe) 3 and chooses from a variety of report styles (different excel reports showing different info). They view their report then retun to the three select page using the back button and if they want to just hit a different report for the same group already chosen: 1. If they previously chose the 1st choice in the 2nd select box they get an error. The error says Incorrect syntax near ')' so it's reading the query as (Choose.Choice2=) instead of (Choose.Choice2=#Choose.Choice2#) 2. If they previously chose any other choice in the 2nd box they don't get an error, but the excel report comes up with just the information listed from the 1st box (it doesn't filter the 2nd box) 3. The options from the 2nd/3rd box disappers when they retun to the page. So if the user wants to keep the same info for the 1st box but wants to change the option in the 2nd/3rd boxes they have to click a different option in the 1st box than re-click on the original choice. Ideally I would like the user to be able to look at their excel sheet, hit the back button, then click on the next report keeping the same filters in place until others are choosen... Is this possible? Thanks in advance! ~~ 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: Generating reports in the background (update)
Aidan: Frankly I am not surprised you are having trouble Reports can put a serious load on the CF interpreter. Some questions to ask are: Are you using SQL Server and making full use of its power with views (and calculated columns?), stored procedures, triggers, etc.. Have you considered or have you already created a separate, (repeat separate) OLAP database strictly for reporting? It sounds like you may also have already done this, but have you considered dividing the reports into regularly viewed and must be on-the-fly? For regularly viewed the user could enter their preferred parameters, if any are required, into a database that will store them for use with scheduled reports that could be run in low traffic times and saved to a pick-up location, as, say, pdfs. There is nothing inherent to cflocating and cfhttp that should take forever. As a rule, CF does not handle complex reporting jobs well... it is designed to glue things together. make the work happen elsewhere (for best results)... not meaning to tell you something you already know... sorry if any of this sounds like bad news to you. regards, Patrick At 11:44 AM 31/10/2001 +, Aidan Whitehall wrote: I'm trying to trigger a ColdFusion template that generates a report in the background. I want to start the process and then redirect the browser to a your report is being created page. Try as I might, I can't get the report started without the browser being forced to wait at some point for the report to be finished. The report generation needs to be triggered on-demand. Updating a CFSCHEDULE and then running it straight away doesn't seem to work (I guess because it must be set at least 15 minutes in the future). Calling the report making template via CFHTTP before using CFLOCATION doesn't work, as the page sits there until the report is finished before redirecting. Using CFHTTP at the end of the your report is being created also makes that page take forever to be rendered. If I was using CF5, I guess I could CFFLUSH the page before doing CFHTTP last, but we're stuck with v4.0.1. I can't call CFML.EXE via a URL and CFEXECUTE is only 4.5+. Any ideas? I've run out... Thanks. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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 - SQL to Excel
Where is the Query2Excel tag? I am looking for something similar. Thanks, Jeff -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 6:14 AM To: CF-Talk Subject: RE: Help - SQL to Excel Cheers, Found a custom tag (Query2Excel) that does exactly what I wanted. Nick -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 11:55 To: CF-Talk Subject: RE: Help - SQL to Excel Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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: Help - SQL to Excel
Jeff, I believe there is a CF5 UDF on www.cflib.org that does that too. --- Ben -Original Message- From: Jeff Sokolik [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:36 AM To: CF-Talk Subject: RE: Help - SQL to Excel Where is the Query2Excel tag? I am looking for something similar. Thanks, Jeff -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 6:14 AM To: CF-Talk Subject: RE: Help - SQL to Excel Cheers, Found a custom tag (Query2Excel) that does exactly what I wanted. Nick -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 11:55 To: CF-Talk Subject: RE: Help - SQL to Excel Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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: Menu Custom Tags
CFPLUG Also check out http://www.akc.org I used a reworked cf version of hiermenus to drive the dropdown lists on this site's navigation menu. /CFPLUG Matt Robertson wrote: CF_Hiermenus. Actually its a great script without the CF wrapper, albeit a tad slow. Unmatched in its cross-browser compatibility, I think. Go to palm.com to see one of its nicer iterations. Also lucent.com; unisys.com; webtrends.com. With a bit of serious elbow grease you can completely data-drive the thing (generating the controlling hmarrays.js via CF). - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 9:26 PM Subject: Menu Custom Tags Can anyone reccomend a custom tag for Menus (DHTML, or anything else)??? Thanks, Mike ~~ 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
Goodbye Advanced Security, hello Session Params and eh.. hello list!
Hi, After weeks of struggling to get Advanced Security to run with Access in ColdFusion 5, i have given up. It works like a charm in CF 4.0.1, but not with the new version. Allaire, sorry, Macromedia support have suggested that Advanced Security in CF 5 simply doesn't work with Access. Time to create a customized session handling and security system to use our MySQL server instead. My plan is to use session variables to keep track of what users are allowed where, but I seem to recall a few concerns about relying on session variables for this from my last time on the list about a year ago. Is there something that I should keep in mind while doing this? Also, one of the problems I had in 4.0.1 was locking the shared scope variables. This seems to be much more efficient in CF 5, but I also found the option to run Single Threaded Sessions. This seems like a very easy solution. Would this affect performance a lot? Finally, an introduction could be in place. My name is Tage Widsell and I'm the webmaster at Propellerhead Software, a music software company in Stockholm, Sweden. I've been on this list a few times before and here I am again. Regards Tage Widsell Webmaster Propellerhead Software ~~ 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: Help - SQL to Excel
it's called CSVFormat() ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:40 AM To: CF-Talk Subject: RE: Help - SQL to Excel Jeff, I believe there is a CF5 UDF on www.cflib.org that does that too. --- Ben -Original Message- From: Jeff Sokolik [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:36 AM To: CF-Talk Subject: RE: Help - SQL to Excel Where is the Query2Excel tag? I am looking for something similar. Thanks, Jeff -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 6:14 AM To: CF-Talk Subject: RE: Help - SQL to Excel Cheers, Found a custom tag (Query2Excel) that does exactly what I wanted. Nick -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 11:55 To: CF-Talk Subject: RE: Help - SQL to Excel Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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
RE: Help - SQL to Excel
Try developers exchange on www.allaire.com (probably on Macromedia too) -Original Message- From: Jeff Sokolik [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 14:36 To: CF-Talk Subject: RE: Help - SQL to Excel Where is the Query2Excel tag? I am looking for something similar. Thanks, Jeff -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 6:14 AM To: CF-Talk Subject: RE: Help - SQL to Excel Cheers, Found a custom tag (Query2Excel) that does exactly what I wanted. Nick -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 11:55 To: CF-Talk Subject: RE: Help - SQL to Excel Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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
BOOKS for XML
any good book for xml? ycc PGI - The Event and Communications Agency Experience. The Difference. http://www.pgi.com GOD BLESS AMERICA ! ~~ 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: online chat facilities
Hello again, I'm needing another bit of help. We're looking for an online chat room programme. We don't really know anymore details than this at the moment, but I was wondering if anyone out there knew of any such thing that we could buy off the shelf? Cheers, Kath Katherine Maltby Web Production Director -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 488 9131 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~~ 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: BOOKS for XML
Simon St.Laurent XML : A Primer is a good start. in fact a very good start! Neil Team Macromedia ~~ 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: Help - SQL to Excel
Thanks all, found it on Allaire's site. -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 8:48 AM To: CF-Talk Subject: RE: Help - SQL to Excel Try developers exchange on www.allaire.com (probably on Macromedia too) -Original Message- From: Jeff Sokolik [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 14:36 To: CF-Talk Subject: RE: Help - SQL to Excel Where is the Query2Excel tag? I am looking for something similar. Thanks, Jeff -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 6:14 AM To: CF-Talk Subject: RE: Help - SQL to Excel Cheers, Found a custom tag (Query2Excel) that does exactly what I wanted. Nick -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 11:55 To: CF-Talk Subject: RE: Help - SQL to Excel Can somebody show me some code to simply query a databse then by clicking a link export recordset to Excel and open worksheet displaying data. I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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
RE: BOOKS for XML
XML BIBLE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 14:51 To: CF-Talk Subject: BOOKS for XML any good book for xml? ycc PGI - The Event and Communications Agency Experience. The Difference. http://www.pgi.com GOD BLESS AMERICA ! ~~ 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: online chat facilities
Kath, There's CFChat for one. http://www.cfchat.net quite cheap, nay, very cheap too. --- Rich Wild Senior Web Developer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- -Original Message- From: Katherine Maltby [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 14:57 To: CF-Talk Subject: OT: online chat facilities Hello again, I'm needing another bit of help. We're looking for an online chat room programme. We don't really know anymore details than this at the moment, but I was wondering if anyone out there knew of any such thing that we could buy off the shelf? Cheers, Kath Katherine Maltby Web Production Director -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 488 9131 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~~ 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: BOOKS for XML
I dig the O'Reilly one. EC -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:59 AM To: CF-Talk Subject: RE: BOOKS for XML Simon St.Laurent XML : A Primer is a good start. in fact a very good start! Neil Team Macromedia ~~ 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: Managing DNS via a browser
Does anyone know of a current solution cf based or not, that will allow you to manage DNS records via a browser? Thanks in advance! ~~ 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: Goodbye Advanced Security, hello Session Params and eh.. hello list!
Tage Widsell wrote: Hi, After weeks of struggling to get Advanced Security to run with Access in ColdFusion 5, i have given up. It works like a charm in CF 4.0.1, but not with the new version. Allaire, sorry, Macromedia support have suggested that Advanced Security in CF 5 simply doesn't work with Access. It even says so in the manual. Time to create a customized session handling and security system to use our MySQL server instead. My plan is to use session variables to keep track of what users are allowed where, but I seem to recall a few concerns about relying on session variables for this from my last time on the list about a year ago. Is there something that I should keep in mind while doing this? What exactly are your security needs? Obviously sandboxing can't be handled with session variables. What scenario would be your worst nightmare? Also, one of the problems I had in 4.0.1 was locking the shared scope variables. This seems to be much more efficient in CF 5, but I also found the option to run Single Threaded Sessions. This seems like a very easy solution. Would this affect performance a lot? Yes. Finally, an introduction could be in place. My name is Tage Widsell and I'm the webmaster at Propellerhead Software, a music software company in Stockholm, Sweden. I've been on this list a few times before and here I am again. Hi Tage. I'm Jochem. Jochem ~~ 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
Using Len() to Check for Blanks (Was RE: LT Function)
Why not use Len(q_createRecordSet.INFLOW) - it's quicker and easier to read! FWIW, any non-zero integer that Len() outputs will be cast into Yes (TRUE) when used as an input to CFIF. A blank string will be converted to a zero by the Len() function and will be cast into No (FALSE) when used as an input to CFIF. -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 1:39 PM To: CF-Talk Subject: RE: LT Function q_createRecordSet.INFLOW NEQ dunno about the rest, but this should be NOT q_createRecordSet.INFLOW IS [snip] ~~ 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: Goodbye Advanced Security, hello Session Params and eh.. hello list!
on 01-11-01 16.10, Jochem van Dieten at [EMAIL PROTECTED] wrote: Tage Widsell wrote: Hi, After weeks of struggling to get Advanced Security to run with Access in ColdFusion 5, i have given up. It works like a charm in CF 4.0.1, but not with the new version. Allaire, sorry, Macromedia support have suggested that Advanced Security in CF 5 simply doesn't work with Access. It even says so in the manual. Ok. Support just told me the same thing. I feel stupid now. Time to create a customized session handling and security system to use our MySQL server instead. My plan is to use session variables to keep track of what users are allowed where, but I seem to recall a few concerns about relying on session variables for this from my last time on the list about a year ago. Is there something that I should keep in mind while doing this? What exactly are your security needs? Obviously sandboxing can't be handled with session variables. What scenario would be your worst nightmare? We don't use sandboxing. I need a role based log-in system that enables me to control what information goes where. We have groups like allUsers, RegisteredUser, betaTesters, admins and registered owners of our products. Apart from the basic server security that wouldn't be handled by this system - to stop people from breaking into the server and modify/damage data, the nightmare would be if someone could find a way to pose as a site admin and get access to product registration, serial numbers etc. Also, one of the problems I had in 4.0.1 was locking the shared scope variables. This seems to be much more efficient in CF 5, but I also found the option to run Single Threaded Sessions. This seems like a very easy solution. Would this affect performance a lot? Yes. So I would be stupid not to set cflock around every shared variable? Ouch. /Tage ~~ 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
allaire forums tag gallery
Sometimes I just want to strangle whoever maintains these. Grrr.. Anyway, while I'm grring at them for deleting my account account... again A) I monitor cf-talk through the nntp mirror at fusetalk. It would be nice if there was an option to sign up to cf-talk but NOT receive any email. This way I could read nntp posts and then have a registered email that would let me reply from there without the message bouncing. Just a thought. I know mikey probably doesn't have the time, but someone local might. B) There are lots and lots of small cf web sites out there that want to be the MAIN community portal. I know this because I've got most of them in my bookmark program (http://www.intrafoundation.com/cf.html). Most all of them with only about 3 exceptions start out wanting to conquer the CF world then fizzle out within 2 or 3 months and gather dust afterward. It would be nice if these energies could merged and a viable option to the almost useless cf tag gallery could be founded. Just a seed thought. --min ~~ 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: Virus checking uploads
Hi Katherine, I don't know what kind of solution you are tending to be partial to, but I can speak about a product I have some experience with. It's a network based antivirus program from a company called PandaSoft. At my previous company we ran it on our internal network (which also protected all of our pop servers and checked all incoming email) and on all of our web and production servers. It will realtime monitor everything and as a file is uploaded or otherwise added to the system's drives, it will check it and remove any part of the file that is contaminated. It has very small overhead and has a browser based admin where all of your computers can be monitored and controlled realtime. -Original Message- From: Katherine Maltby [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 7:36 AM To: CF-Talk Subject: Virus checking uploads Hi, We've got to develop a facility whereby users can upload material to a server via a cfm page, but we need to have some kind of virus checking software to check all uploads first. Does anyone know of anything already out there and how much it would cost? ~~ 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: OT: Managing DNS via a browser
oi Clint!! well if you register with dotster.com you can.or you can use the free one zoneedit.com -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, November 01, 2001, 10:08:03 AM, you wrote: CT Does anyone know of a current solution cf based or not, that will allow you to manage DNS records via a browser? CT Thanks in advance! CT ~~ 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: OT: Managing DNS via a browser
Ok, I need to rephrase my question. Is there a tool that will allow me to manage my own DNS through a browser? I am running Win2k and I am using MS DNS. Thanks! -- Original Message -- from: Critz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 10:29:56 -0500 oi Clint!! well if you register with dotster.com you can.or you can use the free one zoneedit.com -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, November 01, 2001, 10:08:03 AM, you wrote: CT Does anyone know of a current solution cf based or not, that will allow you to manage DNS records via a browser? CT Thanks in advance! CT ~~ 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: Managing DNS via a browser
Clint, Not sure if this is what you're looking for, but we use these folks a lot. There customer service is very good, and you can control all aspects of your DNS account from a web browser. http://www.easydns.com Rick - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 7:08 AM Subject: OT: Managing DNS via a browser Does anyone know of a current solution cf based or not, that will allow you to manage DNS records via a browser? Thanks in advance! ~~ 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
sql distinct
My distinct is no longer distinct after a simple, but major, change. SELECT DISTINCT CategoryIdTable.Category, CategoryIdTable.CategoryID, CourseTable.CategoryID, CourseTable.PartNumber FROM CategoryIdTable, CourseTable WHERE CategoryIdTable.CategoryID = CourseTable.CategoryID AND CourseTable.Lang LIKE '%#tmpLangCode#%' I changed my db to embed the language code in the part number (e.g. 1000-ABC-ES), (ES=espanol), instead of using an (existing) column (which was like EN,ES,PT,etc) SELECT DISTINCT CategoryIdTable.Category, CategoryIdTable.CategoryID, CourseTable.CategoryID, CourseTable.PartNumber FROM CategoryIdTable, CourseTable WHERE CategoryIdTable.CategoryID = CourseTable.CategoryID AND CourseTable.PartNumber LIKE '%#tmpLangCode#' So now I get MULTIPLE categories, instead of the DISTINCT list that was returned using the former sql statement. Also can anyone point me to a 'proper' SQL spec for Access 97 / ODBC driver. I'm using a generic Que book which says things like ... try INSTR() but if that doesn't work try INSTRING() or SUBSTR/SUBSTRING ... or maybe they won't work at all ;o) ... It's actually driving me a little batty this halloween. Thanks, Mike ~~ 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
Structures and SetVariable() function
I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryGetInfo.FormFieldName#.Value, qryGetInfo.FormFieldValue) I get this error: Parameter 1 of function SetVariable which is now Ses.Profile[frm3].CRANEUSED.Value must be a syntactically valid variable name When I use this, I get not errors however when I do a cfobject on my structure I get Crane.Vale on the same level, instead of Crane and then under than Value. cfset tmp = SetVariable(Ses.Profile.frm#qryGetInfo.FormNumber#.#qryGetInfo.FormFieldName#.Value, qryGetInfo.FormFieldValue) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion ~~ 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: SQL Server 2000 desktop version.
OK, so it looks like for what I need (a SQL server on my local development machine -- my 120 eval is about to expire, and I've really started to dig SQL Server), I need the developers edition. This costs $500. With this, I could, if I wanted -- in addition to my usual CF-based development -- create distributable applications? Like let's say I have a client -- ok, I do have such a client -- who doesn't want to access the Internet for inventory updates, but wants to do it off line. Could I create a run-time application that I could install on his Win98 machine with nothing else to install (such as his own copy of Access or SQL Server)? You could do that, but not with SQL Server Developer Edition, which is simply a variation on the regular SQL Server product with a limited license for development use only. There's nothing in it that you could redistribute, in any case. If you want to build applications in, say, Visual Basic or VC++, that are local desktop-database interfaces, you can redistribute the Access runtime or MSDE with your applications - that's what they're for. You could develop your application against SQL Server Developer Edition, then distribute it with MSDE, for example. 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: Structures and SetVariable() function
Why not just do: CFSET X[Foo] = Whatever ? Or, in your case, CFSET Ses.Profile[frm#qryGetInfo.FormNumber#].Value = Whatever === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:20 AM To: CF-Talk Subject: Structures and SetVariable() function I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryG etInfo.FormFieldName#.Value, qryGetInfo.FormFieldValue) I get this error: Parameter 1 of function SetVariable which is now Ses.Profile[frm3].CRANEUSED.Value must be a syntactically valid variable name When I use this, I get not errors however when I do a cfobject on my structure I get Crane.Vale on the same level, instead of Crane and then under than Value. cfset tmp = SetVariable(Ses.Profile.frm#qryGetInfo.FormNumber#.#qryGetInf o.FormFieldName#.Value, qryGetInfo.FormFieldValue) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion ~~ 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: Structures and SetVariable() function
Maybe because I have been focusing in the wrong direction on this, I have tried some variations of what you just suggested and had no luck with them yesterday. I am gussing it should be this(you left off the qryGetInfo.FormFieldName): CFSET Ses.Profile[frm#qryGetInfo.FormNumber#].qryGetInfo.FormFieldName.Value = qryGetInfo.FormFieldValue Which errors out saying that: The member QRYGETINFO.FORMFIELDNAME in dimension 1 of object Ses.Profile cannot be found. Please, modify the member name. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 1 Nov 2001, Raymond Camden wrote: Why not just do: CFSET X[Foo] = Whatever ? Or, in your case, CFSET Ses.Profile[frm#qryGetInfo.FormNumber#].Value = Whatever === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:20 AM To: CF-Talk Subject: Structures and SetVariable() function I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryG etInfo.FormFieldName#.Value, qryGetInfo.FormFieldValue) I get this error: Parameter 1 of function SetVariable which is now Ses.Profile[frm3].CRANEUSED.Value must be a syntactically valid variable name When I use this, I get not errors however when I do a cfobject on my structure I get Crane.Vale on the same level, instead of Crane and then under than Value. cfset tmp = SetVariable(Ses.Profile.frm#qryGetInfo.FormNumber#.#qryGetInf o.FormFieldName#.Value, qryGetInfo.FormFieldValue) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion ~~ 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: Structures and SetVariable() function
So, your structure looks like this, correct: Ses Profile SomeKey SomeKey Value Then you would do: CFSET Ses.Profile[frm#qryGetInfo.FormNumber#][frm#qryGetInfo.FormNumber#]. Value = Whatever Remember, if you want to set a dynamic key in a struct, all you need is the [ ] notation. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:32 AM To: CF-Talk Subject: RE: Structures and SetVariable() function Maybe because I have been focusing in the wrong direction on this, I have tried some variations of what you just suggested and had no luck with them yesterday. I am gussing it should be this(you left off the qryGetInfo.FormFieldName): CFSET Ses.Profile[frm#qryGetInfo.FormNumber#].qryGetInfo.FormField Name.Value = qryGetInfo.FormFieldValue Which errors out saying that: The member QRYGETINFO.FORMFIELDNAME in dimension 1 of object Ses.Profile cannot be found. Please, modify the member name. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 1 Nov 2001, Raymond Camden wrote: Why not just do: CFSET X[Foo] = Whatever ? Or, in your case, CFSET Ses.Profile[frm#qryGetInfo.FormNumber#].Value = Whatever == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:20 AM To: CF-Talk Subject: Structures and SetVariable() function I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryG etInfo.FormFieldName#.Value, qryGetInfo.FormFieldValue) I get this error: Parameter 1 of function SetVariable which is now Ses.Profile[frm3].CRANEUSED.Value must be a syntactically valid variable name When I use this, I get not errors however when I do a cfobject on my structure I get Crane.Vale on the same level, instead of Crane and then under than Value. cfset tmp = SetVariable(Ses.Profile.frm#qryGetInfo.FormNumber#.#qryGetInf o.FormFieldName#.Value, qryGetInfo.FormFieldValue) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion ~~ 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: Structures and SetVariable() function
Thanks, seems to work with that, one form is getting skipped over but I am sure that is unrelated to this. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 1 Nov 2001, Raymond Camden wrote: So, your structure looks like this, correct: Ses Profile SomeKey SomeKey Value Then you would do: CFSET Ses.Profile[frm#qryGetInfo.FormNumber#][frm#qryGetInfo.FormNumber#]. Value = Whatever Remember, if you want to set a dynamic key in a struct, all you need is the [ ] notation. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:32 AM To: CF-Talk Subject: RE: Structures and SetVariable() function Maybe because I have been focusing in the wrong direction on this, I have tried some variations of what you just suggested and had no luck with them yesterday. I am gussing it should be this(you left off the qryGetInfo.FormFieldName): CFSET Ses.Profile[frm#qryGetInfo.FormNumber#].qryGetInfo.FormField Name.Value = qryGetInfo.FormFieldValue Which errors out saying that: The member QRYGETINFO.FORMFIELDNAME in dimension 1 of object Ses.Profile cannot be found. Please, modify the member name. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 1 Nov 2001, Raymond Camden wrote: Why not just do: CFSET X[Foo] = Whatever ? Or, in your case, CFSET Ses.Profile[frm#qryGetInfo.FormNumber#].Value = Whatever == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:20 AM To: CF-Talk Subject: Structures and SetVariable() function I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryG etInfo.FormFieldName#.Value, qryGetInfo.FormFieldValue) I get this error: Parameter 1 of function SetVariable which is now Ses.Profile[frm3].CRANEUSED.Value must be a syntactically valid variable name When I use this, I get not errors however when I do a cfobject on my structure I get Crane.Vale on the same level, instead of Crane and then under than Value. cfset tmp = SetVariable(Ses.Profile.frm#qryGetInfo.FormNumber#.#qryGetInf o.FormFieldName#.Value, qryGetInfo.FormFieldValue) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion ~~ 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: OT: Managing DNS via a browser
I want this too! I think it might not be that tough ... the DNS records are jst in text files right? Eric Dawson From: Clint Tredway [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: OT: Managing DNS via a browser Date: Thu, 1 Nov 2001 10:32:33 -0500 Ok, I need to rephrase my question. Is there a tool that will allow me to manage my own DNS through a browser? I am running Win2k and I am using MS DNS. Thanks! -- Original Message -- from: Critz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 10:29:56 -0500 oi Clint!! well if you register with dotster.com you can.or you can use the free one zoneedit.com -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, November 01, 2001, 10:08:03 AM, you wrote: CT Does anyone know of a current solution cf based or not, that will allow you to manage DNS records via a browser? CT Thanks in advance! CT ~~ 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: Structures and SetVariable() function
The cf parser always has trouble when you have arrays of structs in my experience. In a worst case scenario you can always use cfset evaluate( both sides of the expression) (trick i picked up from early spectra code) but Raymonds solution is much better in this case. - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 7:20 AM Subject: Structures and SetVariable() function I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryGetInfo.FormFie ldName#.Value, qryGetInfo.FormFieldValue) I get this error: Parameter 1 of function SetVariable which is now Ses.Profile[frm3].CRANEUSED.Value must be a syntactically valid variable name When I use this, I get not errors however when I do a cfobject on my structure I get Crane.Vale on the same level, instead of Crane and then under than Value. cfset tmp = SetVariable(Ses.Profile.frm#qryGetInfo.FormNumber#.#qryGetInfo.FormFieldNam e#.Value, qryGetInfo.FormFieldValue) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion ~~ 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: OT: Managing DNS via a browser
True, but you need to know the proper format. I know of acompany that created a typical boilerplate that they use for client hosting and they use CF to fill in the proper values. One other thing - if you're using Bind on Windows then the service needs to be restarted for the changes to take affect. We have a freeware service control cfx if you need it. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Eric Dawson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 11:18 AM Subject: Re: OT: Managing DNS via a browser I want this too! I think it might not be that tough ... the DNS records are jst in text files right? Eric Dawson ~~ 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: Structures and SetVariable() function
From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 11:18 AM To: CF-Talk Subject: Re: Structures and SetVariable() function The cf parser always has trouble when you have arrays of structs in my experience. In a worst case scenario you can always use cfset evaluate( both sides of the expression) (trick i picked up from early spectra code) Never, ever use evaluate to set structure values. (Sorry Don, this is just a pet peave of mine. ;) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~~ 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: Generating reports in the background (update)
Are you using SQL Server and making full use of its power with [snip] sorry if any of this sounds like bad news to you. I'm using Access. Go on. Laugh. However, this only needs to tie us over for about 8 weeks. After that, we'll be moving our main database from Sybase's Adaptive Server Anywhere to Adaptive Server Enterprise and host the web application in-house (instead of the remote data transfer from ASA to Access as it's being done at the moment). And then I might end up using PowerBuilder HTML components instead of CF to generate reports for the Web. We've got an in-house app built in PB and we might be able to reuse code for the web pages from the application. And whilst Sybase sells an OLAP component called IQ, it ain't cheap and we need to be able to query data as soon as it's been added. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: OT: Managing DNS via a browser
am i missing something here? if you are using win 2k why aren't you using the terminal service web client? it's an active-x control that lets you run a terminal service session thu your browser. you cant do whatever you want from a browser. do a search in windows or @ MS for tsweb is there more to this issue? Eric Dawson [EMAIL PROTECTED] on 11/01/2001 10:18:02 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: OT: Managing DNS via a browser I want this too! I think it might not be that tough ... the DNS records are jst in text files right? Eric Dawson From: Clint Tredway [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: OT: Managing DNS via a browser Date: Thu, 1 Nov 2001 10:32:33 -0500 Ok, I need to rephrase my question. Is there a tool that will allow me to manage my own DNS through a browser? I am running Win2k and I am using MS DNS. Thanks! -- Original Message -- from: Critz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 10:29:56 -0500 oi Clint!! well if you register with dotster.com you can.or you can use the free one zoneedit.com -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, November 01, 2001, 10:08:03 AM, you wrote: CT Does anyone know of a current solution cf based or not, that will allow you to manage DNS records via a browser? CT Thanks in advance! CT ~~ 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: Structures and SetVariable() function
Actually, I tried Evaluate in several formats before emailing the list, but thanks for the tip. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 1 Nov 2001, Don Vawter wrote: The cf parser always has trouble when you have arrays of structs in my experience. In a worst case scenario you can always use cfset evaluate( both sides of the expression) (trick i picked up from early spectra code) but Raymonds solution is much better in this case. - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 7:20 AM Subject: Structures and SetVariable() function I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryGetInfo.FormFie ldName#.Value, qryGetInfo.FormFieldValue) I get this error: Parameter 1 of function SetVariable which is now Ses.Profile[frm3].CRANEUSED.Value must be a syntactically valid variable name When I use this, I get not errors however when I do a cfobject on my structure I get Crane.Vale on the same level, instead of Crane and then under than Value. cfset tmp = SetVariable(Ses.Profile.frm#qryGetInfo.FormNumber#.#qryGetInfo.FormFieldNam e#.Value, qryGetInfo.FormFieldValue) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion ~~ 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: Structures and SetVariable() function
I don't use it either Raymond unless everything else I try fails. You will note I did say in a worst case scenario and also that your solution was much better. - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 9:27 AM Subject: RE: Structures and SetVariable() function From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 11:18 AM To: CF-Talk Subject: Re: Structures and SetVariable() function The cf parser always has trouble when you have arrays of structs in my experience. In a worst case scenario you can always use cfset evaluate( both sides of the expression) (trick i picked up from early spectra code) Never, ever use evaluate to set structure values. (Sorry Don, this is just a pet peave of mine. ;) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~~ 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: OT: Managing DNS via a browser
Ok, I need to rephrase my question. Is there a tool that will allow me to manage my own DNS through a browser? I am running Win2k and I am using MS DNS. I don't have an answer for you about an existing web interface, but I suspect that if you're running Win2K DNS, you could build your own pretty easily using the appropriate COM interface. Most management functionality is exposed on Win2K through interfaces like ADSI. I suspect that Win2K DNS can be manipulated through ADSI or WMI, although I don't know the specifics. I'm not using Win2K DNS myself. There is also a utility within the Windows 2000 Support Tools called dnscmd.exe, which lets you manipulate your Win2K DNS. The Support Tools come on the Win2K CD. You should be able to automate this pretty easily with CFEXECUTE. Good luck! 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: Structures and SetVariable() function
Oh yea, I certainly didn't mean _NEVER_ use evaluate. Sorry if that wasn't clear! :) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 11:32 AM To: CF-Talk Subject: Re: Structures and SetVariable() function I don't use it either Raymond unless everything else I try fails. You will note I did say in a worst case scenario and also that your solution was much better. ~~ 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: BOOKS for XML
any good book for xml? I'm sure there are many. XML is a very broad topic - and pretty simple, if you're just interested in XML itself. I've been happy with XML in a Nutshell from O'Reilly, which covers XML and a bunch of related topics like XSL/XSLT, XPath, and so on. Since XML is a very broad topic, you might be more interested in a specific use of XML. There are plenty of books covering these more specific topics, such as SOAP. 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: OT: Managing DNS via a browser
sorry, should said you CAN do whatever you want from the browser. [EMAIL PROTECTED] on 11/01/2001 10:25:49 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: OT: Managing DNS via a browser am i missing something here? if you are using win 2k why aren't you using the terminal service web client? it's an active-x control that lets you run a terminal service session thu your browser. you cant do whatever you want from a browser. do a search in windows or @ MS for tsweb is there more to this issue? Eric Dawson [EMAIL PROTECTED] on 11/01/2001 10:18:02 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: OT: Managing DNS via a browser I want this too! I think it might not be that tough ... the DNS records are jst in text files right? Eric Dawson From: Clint Tredway [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: OT: Managing DNS via a browser Date: Thu, 1 Nov 2001 10:32:33 -0500 Ok, I need to rephrase my question. Is there a tool that will allow me to manage my own DNS through a browser? I am running Win2k and I am using MS DNS. Thanks! -- Original Message -- from: Critz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 10:29:56 -0500 oi Clint!! well if you register with dotster.com you can.or you can use the free one zoneedit.com -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, November 01, 2001, 10:08:03 AM, you wrote: CT Does anyone know of a current solution cf based or not, that will allow you to manage DNS records via a browser? CT Thanks in advance! CT ~~ 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
QUESTION: Oracle returning multi referential cursors
I have re-written an app using all stored procedures and it still runs too slow (it's a series of parent-child query loops) so I'd like to move all conditional processing to the db and run it all in one sproc... is this at all possible using referential cursors? Can I return conditional cursors? Basically either one result set, two result sets or four would return for each major record... Or am I going about this all wrong? ~~ 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
SOAP - was BOOKS for XML
I've heard talk of SOAP around the office but haven't had time to look into what it is. Can anyone give a quick overview of what it is and it's benefits. Thanks. d -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Since XML is a very broad topic, you might be more interested in a specific use of XML. There are plenty of books covering these more specific topics, such as SOAP. ~~ 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
Question about using 2 datasources
Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [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: OT: Managing DNS via a browser
I've never seen one available, except for in one of those prefab ISP control panels that are out there. Never seen one in CF though. The zone file are just individual text files though. Go to C:\winnt\system32\dns and open up a couple of the .dns files. It's not to hard to figure out what is different between them. The thing is that the file has to be perfect, line breaks and all. Also necessary is a registry key which is the domain name, and one the keys is the name of the zone file. The other keys I cant remember off the top of my head because I overdid it last night :-/, but a little cffile and cfregistry action is all that is needed. After the zone file and the reg keys are written just cfexecute a little stop start dns server script and that's it. jon Clint Tredway wrote: Ok, I need to rephrase my question. Is there a tool that will allow me to manage my own DNS through a browser? I am running Win2k and I am using MS DNS. Thanks! -- Original Message -- from: Critz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 10:29:56 -0500 oi Clint!! well if you register with dotster.com you can.or you can use the free one zoneedit.com ~~ 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: Goodbye Advanced Security, hello Session Params and eh.. hello list!
Tage Widsell wrote: on 01-11-01 16.10, Jochem van Dieten at [EMAIL PROTECTED] wrote: Tage Widsell wrote: We don't use sandboxing. I need a role based log-in system that enables me to control what information goes where. We have groups like allUsers, RegisteredUser, betaTesters, admins and registered owners of our products. Apart from the basic server security that wouldn't be handled by this system - to stop people from breaking into the server and modify/damage data, the nightmare would be if someone could find a way to pose as a site admin and get access to product registration, serial numbers etc. As long as you don't anticipate the need for clustering session variables should be OK. Also, one of the problems I had in 4.0.1 was locking the shared scope variables. This seems to be much more efficient in CF 5, but I also found the option to run Single Threaded Sessions. This seems like a very easy solution. Would this affect performance a lot? Yes. So I would be stupid not to set cflock around every shared variable? Ouch. Highly recommended sounds better ;) Jochem ~~ 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
ANN: Single user CF5 license available
I don't know if I posted this here, but I thought a dupe was better than not having the information. The ColdFusion Server 5 Single User Activation Kit is now available on Macromedia.com. The Activation Kit converts the ColdFusion Server 5 evaluation software into a non-expiring, Single User Version of ColdFusion Server 5. NOTE: A licensed version of ColdFusion Studio (any version) must already be present on the server to use the Activation Kit. The kit is available at http://www.macromedia.com/software/coldfusion/downloads/update/ _ Matt Brown Community Manager Macromedia (650) 481-4525 [EMAIL PROTECTED] FAQ: http://www.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: Oracle Help
hi there, I have been working on this all day and am still getting errors - I can connect using sqlplus in solaris without problems but cannot connect through cfadministrator - I tried a page to sdee if it would work even though it was failaing connectivity but with no joy. Error code is below: ORA-12154: TNS:could not resolve service name I am not sure what this means but I presume that it is at least seeing Oracle (therefore it is setup correctly). I hope someone can help Cheers Simon - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 12:25 PM Subject: Re: Oracle Help Dumb question, but, are you sure you have the username and password correct in CFAdministrator. Also, do you have something like Oracle DBA Studio or Enterprise Manager that you can connect with? If so, the problem is with your CF Administrator settings. If not, then check the TNSNames.ora file. Also, are you trying to use ODBC or the Native Drivers. If you are using ODBC, be sure and use the Microsoft ODBC for Oracle drivers. Dave - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 11:47 PM Subject: Re: Oracle Help On my CF5/Win2k machine with Oracle 8.0.5 client, my CF administrator says not verified - but the datasource works just fine... I need some help with Oracle - I am not able to connect to my oracle dbase from within cf administrator - it simply gives the not verified message. The trouble is I am not entirely sure what the host string is supposed to look like in the input box - is it dbasename/username@hostname or nothing like the above? I hope someone can help with this. Cheers Simon ~~ 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: Question about using 2 datasources
If you have CF 5 you can join 2 queries with query of a query! - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:52 AM Subject: Question about using 2 datasources Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [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: Question about using 2 datasources
I have CF 5... How do I do this Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:00 PM To: CF-Talk Subject: Re: Question about using 2 datasources If you have CF 5 you can join 2 queries with query of a query! - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:52 AM Subject: Question about using 2 datasources Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [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
RE: SOAP - was BOOKS for XML
I've heard talk of SOAP around the office ... So many jokes, so little time. I've heard talk of SOAP around the office but haven't had time to look into what it is. Can anyone give a quick overview of what it is and it's benefits. Thanks. I did an introductory DevCon presentation on SOAP and CF, which is available here: http://www.cfugorama.com/cfugorama/devcon.cfm 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: Question about using 2 datasources
This works to combine two Access datasources into one query. http://cfhub.com/forum/index.cfm?FuseAction=ThreadTopicID=1914 Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [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: Question about using 2 datasources
You will need to run queries from both datasources and compare the results. HTH -- Original Message -- from: Kris Pilles [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 11:52:31 -0500 Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 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
RE: Question about using 2 datasources
You can join two queries in a third CFQUERY. Look at the docs on querying queries. --- Ben -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:07 PM To: CF-Talk Subject: RE: Question about using 2 datasources I have CF 5... How do I do this Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:00 PM To: CF-Talk Subject: Re: Question about using 2 datasources If you have CF 5 you can join 2 queries with query of a query! - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:52 AM Subject: Question about using 2 datasources Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 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
RE: Oracle Help
I have been working on this all day and am still getting errors - I can connect using sqlplus in solaris without problems but cannot connect through cfadministrator - I tried a page to sdee if it would work even though it was failing connectivity but with no joy. Error code is below: ORA-12154: TNS:could not resolve service name I am not sure what this means but I presume that it is at least seeing Oracle (therefore it is setup correctly). Have you successfully created and tested a connection within the Net8 Oracle client? You'll need to do that first, or add the client entry directly into your tnsnames.ora file. Here's a sample tnsnames.ora file: # TNSNAMES.ORA Configuration File:/opt/u01/app/oracle/product/8.1.5/network/ad min/tnsnames.ora # Generated by Oracle Net8 Assistant ORMAST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myoradb)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ormast.myoradb.figleaf.com) ) ) 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
problem w/ cart structure
I am so CF_CONFUSED !!! I have created a shopping cart to add for the purchase of computer systems, and everything works ok if their is just one computer in the cart. I can update the quantity etc just fine. My problem comes in when I add another computer to the cart and then try to do an update of the quantity or delete it. When I hit update it looks like the items in the Array are switching places. IE : The sysModelNum is where the unitCost is suppose to be and so forth. I cannot figure it out. Do I need to loop over the items again on the update somehow to stop this from happening, and if so could someone give an example. I am posting portions of the code I am using to see if someone can see my error in logic. PLEASE HEPP This is the cart page after the form is submitted, it posts back to itself for update or delete CFLOOP COLLECTION=#session.cart# ITEM=i CFOUTPUT FORM METHOD=post ACTION=/index.cfm?fuseaction=showCartsysModelNum=#session.cart[i] [1]##client.urltoken# NAME=cart1 TABLE ALIGN=center CELLPADDING=0 CELLSPACING=0 WIDTH=70% BORDER=0 TR TD CLASS=header width=31%#session.cart[i][1]#/TD TD CLASS=header width=13%#dollarFormat(session.cart[i][2])#/TD TD CLASS=header width=13%INPUT TYPE=text NAME=qty VALUE=#Trim(session.cart[i][3])# SIZE=2 class=cart/TD cfset total = (session.cart[i][2] * session.cart[i][3]) TD CLASS=header width=13%#dollarFormat(total)#/TD /TR TR INPUT TYPE=hidden NAME=sysModelNum VALUE=#session.cart[i][1]# INPUT TYPE=hidden NAME=show_price_top VALUE=#session.cart[i][2]# INPUT TYPE=hidden NAME=cse VALUE=#session.cart[i][4]# INPUT TYPE=hidden NAME=cpu VALUE=#session.cart[i][5]# INPUT TYPE=hidden NAME=ram VALUE=#session.cart[i][6]# INPUT TYPE=hidden NAME=hdd VALUE=#session.cart[i][7]# INPUT TYPE=hidden NAME=sec_hdd VALUE=#session.cart[i][8]# INPUT TYPE=hidden NAME=mtr VALUE=#session.cart[i][9]# INPUT TYPE=hidden NAME=ctr VALUE=#session.cart[i][10]# INPUT TYPE=hidden NAME=vid VALUE=#session.cart[i][11]# INPUT TYPE=hidden NAME=snd VALUE=#session.cart[i][12]# INPUT TYPE=hidden NAME=cdr VALUE=#session.cart[i][13]# INPUT TYPE=hidden NAME=dvd VALUE=#session.cart[i][14]# INPUT TYPE=hidden NAME=crw VALUE=#session.cart[i][15]# INPUT TYPE=hidden NAME=modem VALUE=#session.cart[i][16]# INPUT TYPE=hidden NAME=stg VALUE=#session.cart[i][17]# INPUT TYPE=hidden NAME=spk VALUE=#session.cart[i][18]# INPUT TYPE=hidden NAME=nic VALUE=#session.cart[i][19]# INPUT TYPE=hidden NAME=clng VALUE=#session.cart[i][20]# INPUT TYPE=hidden NAME=os VALUE=#session.cart[i][21]# INPUT TYPE=hidden NAME=war VALUE=#session.cart[i][22]# TDINPUT TYPE=submit NAME=ACTION value=UpdateINPUT TYPE=submit NAME=ACTION value=Delete/TD /TR /TABLE /CFOUTPUT /CFLOOP This is the struct that I created to hold the values of the computer system and handle the updates THIS IS CALLED AS A CUSTOM TAG IN THE ABOVE PAGE CFSCRIPT if (not(isDefined(session.cart))){ session.cart = structNew(); } tempValue = listToArray( '#attributes.sysModelNum#, #attributes.price#, #attributes.qty#, #attributes.cse#, #attributes.cpu#, #attributes.ram#, #attributes.hdd#, #attributes.sec_hdd#, #attributes.mtr#, #attributes.ctr#, #attributes.vid#, #attributes.snd#, #attributes.cdr#, #attributes.dvd#, #attributes.crw#, #attributes.modem#, #attributes.stg#, #attributes.spk#, #attributes.nic#, #attributes.clng#, #attributes.os#, #attributes.war#' ); // Check to make sure that the item is in the cart, and if it is not add it. if (not(structKeyExists(session.cart,attributes.sysModelNum))) { structInsert(session.cart,attributes.sysModelNum,tempValue); } else { // If the item is already in the cart update the quantity tempvalue[3]=session.cart[attributes.sysModelNum][3]+attributes.qty; structUpdate(session.cart,attributes.sysModelNum,tempValue); } /CFSCRIPT and this is the delete part THIS IS CALLED AS A CUSTOM TAG IN THE ABOVE PAGE CFSCRIPT if (isDefined(session.cart)){ if (StructKeyExists(session.cart, attributes.sysModelNum)) { structDelete(session.cart,attributes.sysModelNum); } } /CFSCRIPT I hope someone can help CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ 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: Oracle Help
The error message you displayed tells me that your TNSNames.ora file is not right. Dave - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 11:55 AM Subject: Re: Oracle Help hi there, I have been working on this all day and am still getting errors - I can connect using sqlplus in solaris without problems but cannot connect through cfadministrator - I tried a page to sdee if it would work even though it was failaing connectivity but with no joy. Error code is below: ORA-12154: TNS:could not resolve service name I am not sure what this means but I presume that it is at least seeing Oracle (therefore it is setup correctly). I hope someone can help Cheers Simon - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 12:25 PM Subject: Re: Oracle Help Dumb question, but, are you sure you have the username and password correct in CFAdministrator. Also, do you have something like Oracle DBA Studio or Enterprise Manager that you can connect with? If so, the problem is with your CF Administrator settings. If not, then check the TNSNames.ora file. Also, are you trying to use ODBC or the Native Drivers. If you are using ODBC, be sure and use the Microsoft ODBC for Oracle drivers. Dave - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 11:47 PM Subject: Re: Oracle Help On my CF5/Win2k machine with Oracle 8.0.5 client, my CF administrator says not verified - but the datasource works just fine... I need some help with Oracle - I am not able to connect to my oracle dbase from within cf administrator - it simply gives the not verified message. The trouble is I am not entirely sure what the host string is supposed to look like in the input box - is it dbasename/username@hostname or nothing like the above? I hope someone can help with this. Cheers Simon ~~ 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: SOAP - was BOOKS for XML
In a sense, what DCOM was supposed to be. You call remote URL's, invoking methods and properties, and get something back. Everything is sent over HTTP; the data going back and forth is XML. For the most part, SOAP and web services are pretty synonymous. Pretty cool; hopefully it's past the infancy (buzzword) stage. If you wanna down and dirty with the spec: http://www.w3.org/2000/xp/ Wrox's Pro CF5 has a section on CF and SOAP. - Original Message - From: Baskin, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:44 AM Subject: SOAP - was BOOKS for XML I've heard talk of SOAP around the office but haven't had time to look into what it is. Can anyone give a quick overview of what it is and it's benefits. Thanks. d -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Since XML is a very broad topic, you might be more interested in a specific use of XML. There are plenty of books covering these more specific topics, such as SOAP. ~~ 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: QUESTION: Oracle returning multi referential cursors
Is it a problem with overall performance or individual cfm templates? Is it the CF that's slow or the Oracle queries? If it's Oracle, it may be poorly structured queries, inefficient design of database tables, lack of or misuse of table indexes, Oracle configuration mistakes? I think that before you go about trying to solve the performance problem, you need to identify the part of your system that's the bottleneck. --- Emily C. Grossman [EMAIL PROTECTED] wrote: I have re-written an app using all stored procedures and it still runs too slow (it's a series of parent-child query loops) so I'd like to move all conditional processing to the db and run it all in one sproc... is this at all possible using referential cursors? Can I return conditional cursors? Basically either one result set, two result sets or four would return for each major record... Or am I going about this all wrong? ~~ 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
### Output all variables?
Anyone know of a quick and dirty way to just show all variables that were passed from a previous page? ~~ 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
Cold Fusion Error on Solaris
We have just taken over hosting of a Cold Fusion website in-house. We are running on Solaris and have been live for just over 2 days without any problems. All of a sudden, everyone trying to connect to the site received the following error: Unix error number 24 occurred: Too many open files This was displayed in a standard Cold Fusion error format. My Sysadmin stopped and started the webserver running on the box, and the problem was resolved. Anyone else had a similar problem and willing to offer some guidance? Thanks, Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ 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: ### Output all variables?
You mean via Form? Or URL? Use Dump. CFDUMP VAR=#Form# CFDUMP VAR=#URL# === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jason Blum [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:27 PM To: CF-Talk Subject: ### Output all variables? Anyone know of a quick and dirty way to just show all variables that were passed from a previous page? ~~ 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: SOAP - was BOOKS for XML
Everything is sent over HTTP; the data going back and forth is XML. For the most part, SOAP and web services are pretty synonymous. To be a bit nit-picky here, SOAP doesn't require the use of HTTP; SOAP data can be sent over any application protocol you like (HTTP, SMTP, FTP, or whatever). Web Services is pretty synonymous with SOAP over HTTP, though, and most SOAP usage is done over HTTP. 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: ### Output all variables?
You can use getClientVariablesList() to get all the client variables that are available to the page, I am not sure about the session vars DB - Original Message - From: Jason Blum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 9:27 AM Subject: ### Output all variables? Anyone know of a quick and dirty way to just show all variables that were passed from a previous page? ~~ 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: ### Output all variables?
You could use CFDUMP if using CF5. Just pass the scope CFDUMP var=#SESSION# Will output all the session variables. Otherwise there is a custom tag out there that will do the same thing for 4.5 Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Jason Blum [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 10:27 AM To: CF-Talk Subject: ### Output all variables? Anyone know of a quick and dirty way to just show all variables that were passed from a previous page? ~~ 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: ### Output all variables?
if you're using cf5: cfdump var=#url# cfdump var=#form# or you could turn on debugging - Original Message - From: Jason Blum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 11:27 AM Subject: ### Output all variables? Anyone know of a quick and dirty way to just show all variables that were passed from a previous page? ~~ 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
Processing an HTTP Post (not form)
I have a java applet that posting some data to my cold fusion template. But I can't seem to access the data. It doesn't appear to be showing up in a FORM post, more of a raw-socket post as far as I can tell from the documentation. When I output the CGI structure seen by the webserver via the Cold Fusion Template, I get the list attached at the bottom. As you can see, 46K of some data is being detected but I don't know how to access this data. I also notice the request method is now set to POST instead of GET. Even though I loop from the form structure and the variable fieldnames it doesn't see any named variables. The java applet also has the ability to transmit a header before the post, is there a way I can fake a form header so this data does show up as a form field? HTTP_CONTENT_LENGTH - 46840 HTTP_CONTENT_TYPE - application/octet-stream These CGI variables show the 46K of data coming through... Any ideas? INSTRUCTIONS ON THE POST FORMAT: == this is the format of POST Data P(1Byte Character) Length of The header for CGI author(8byte Characters) The header for CGI author Length of Image(8byte Characters) \r\n(CR LF) Image data(format is PNG or JPEG) Length of thumbnail(8byte Characters) thumbnail(format is PING or JPEG or AnimationData) Length of thumbnail2(8byte Characters) thumbnail(format is PING or JPEG or AnimationData ) Length is not transmitted, either, when there is not thumbnail. format of poo=true 0x \r\n(CR LF) Image data(format is PNG or JPEG) Lnegth of thumbnaill(8byte characters) thumbnail(format is PING or JPEG or AnimationData) MY CGI ENVIRONMENT RECEIVED AFTER THE POST: == CF_TEMPLATE_PATH - d:\index.cfm CONTENT_LENGTH - 46840 CONTENT_TYPE - application/octet-stream GATEWAY_INTERFACE - CGI/1.1 HTTP_ACCEPT_LANGUAGE - en HTTP_CONNECTION - close HTTP_CONTENT_LENGTH - 46840 HTTP_CONTENT_TYPE - application/octet-stream HTTP_HOST - 127.0.0.1 HTTP_REFERER - http://127.0.0.1/ HTTP_USER_AGENT - PaintBBS/2.x (Windows NT;5.0) HTTPS - off HTTPS_KEYSIZE - HTTPS_SECRETKEYSIZE - HTTPS_SERVER_ISSUER - HTTPS_SERVER_SUBJECT - QUERY_STRING - fuseaction=test REMOTE_USER - REQUEST_METHOD - POST SERVER_NAME - 127.0.0.1 SERVER_PORT - 80 SERVER_PORT_SECURE - 0 SERVER_PROTOCOL - HTTP/1.0 SERVER_SOFTWARE - Microsoft-IIS/5.0 WEB_SERVER_API - ISAPI ~~ 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: ### Output all variables?
dump the contents of the FORM, URL ATTRIBUTE structs using a handy tag such as for example CF_ObjectDump. Steve -Original Message- From: Jason Blum [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 17:27 To: CF-Talk Subject: ### Output all variables? Anyone know of a quick and dirty way to just show all variables that were passed from a previous page? ~~ 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: Upgrading to XP?
Wow. Someone who actually purchases Microsoft Windows =) Too funny... -Original Message- From: Michael Bruce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:24 AM To: CF-Talk Subject: Upgrading to XP? Just thought I would share something with everyone.. I just upgraded to Windows XP Home edition (because I'm cheap) from Win98 and while installing I actually read the 10 page manual (only because I was bored) and it said that PWS is no longer available and if you want a web server you need to upgrade to XP Professional. I ALREADY OPENED THE BOX. So, since MS is getting a little too greedy, I decided to try Apache. It works and it's free. And, you can use CFServer with it. Too cool. Just wanted anyone that was thinking of upgrading to be warned. If you want XP and Windows IIS, you need XP Professional. - $199 upgrade Mike Bruce ~~ 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: SOAP - was BOOKS for XML
In a nutshell, it's a way of envoking methods of remote objects. It's actually more like RPC's than DCOM... Here's what a SOAP reqeust looks like for a remote method HelloWorld(using ASP.NET Web Services) You can also Contact through HTTP GET and HTTP POST methods, however, using SOAP you won't need HTTP GET/POST: POST /costas/MyFirstProject/VoyagerAPI.asmx HTTP/1.1 Host: costas-test Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: http://tempuri.org/HelloWorld; ?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body HelloWorld xmlns=http://tempuri.org/; TempVarstring/TempVar /HelloWorld /soap:Body /soap:Envelope Here's a response: HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length ?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body HelloWorldResponse xmlns=http://tempuri.org/; HelloWorldResultstring/HelloWorldResult /HelloWorldResponse /soap:Body /soap:Envelope -Original Message- From: Baskin, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 8:44 AM To: CF-Talk Subject: SOAP - was BOOKS for XML I've heard talk of SOAP around the office but haven't had time to look into what it is. Can anyone give a quick overview of what it is and it's benefits. Thanks. d -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Since XML is a very broad topic, you might be more interested in a specific use of XML. There are plenty of books covering these more specific topics, such as SOAP. ~~ 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: Question about using 2 datasources
This works to combine two Access datasources into one query. http://cfhub.com/forum/index.cfm?FuseAction=ThreadTopicID=1914 Eh oh, that tells you how to query 2 TABLES not 2 datasources! You can query 2 datasources in Access using the following technique however: SELECT tableA.field1, tableA.field2, tableB.field1 FROM someTable tableA, D:\databases\foo.mdb.someOtherTable tableB WHERE tableA.field1 = tableB.field1 At least you could last time I tried it which was sometime in 1999, MDAC updates _may_ have changed matters but try it anyway. Steve -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 17:07 To: CF-Talk Subject: Re: Question about using 2 datasources Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 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
Re: OT: Managing DNS via a browser
what is different between them. The thing is that the file has to be perfect, line breaks and all. Also necessary is a registry key which is Let me add, that I once (in my younger days ;p ) brought down an entire dns server by having a single space at the beginning of one of the zone records... It took FOREVER to figure that one out... 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 ~~ 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: ### Output all variables?
Anyone know of a quick and dirty way to just show all variables that were passed from a previous page? Save this as OnRequestEnd.cfm. You'll also need to have CF_SHOW somewhere in your application and alter the path to it (ie to whereever you end up putting it on your machine). !--- OnRequestEnd.cfm v1.1 [EMAIL PROTECTED] 28th August 2001 --- CFIF CGI.SERVER_NAME IS 127.0.0.1 CFOUTPUT !--- Application variables. --- H4Application Variables/H4 CFLOOP COLLECTION=#Application# ITEM=Key #Variables.Key#: #Evaluate(Application. Variables.Key)#BR /CFLOOP !--- Client variables. --- H4Client Variables/H4 CFIF NOT ListLen(GetClientVariablesList()) PThere are no client variables/P CFELSE CFLOOP LIST=#GetClientVariablesList()# INDEX=Key #Key#: #Evaluate(Client. Variables.Key)#BR /CFLOOP /CFIF !--- Session variables --- H4Session Variables/H4 !--- Put the session variables in a list. --- CFSET Variables.SessionList = CFLOOP COLLECTION=#session# ITEM=TheKey CFSET Variables.SessionList = ListAppend(Variables.SessionList, TheKey) /CFLOOP CFIF NOT ListLen(Variables.SessionList) PThere are no session variables/P CFELSE !--- Sort the list --- CFSET Variables.SessionList = ListSort(Variables.SessionList, text) TABLE CFLOOP LIST=#Variables.SessionList# INDEX=Key CFIF IsSimpleValue(Evaluate(Session. Variables.Key)) TR TD#Key#: #session[Key]#/TD /TR CFELSE TR TD#Key#/TD TDCFMODULE TEMPLATE=#Request.Mappings.ColdFusion#modules/show/show.cfm Value=#Evaluate(Session. Variables.Key)#/TD /TR /CFIF /CFLOOP /TABLE /CFIF !--- Cookie variables. --- H4Cookies/H4 CFIF NOT IsDefined(Cookie) PThere are no cookies set./P CFELSE CFIF Len(Cookie) CFLOOP LIST=#Cookie# INDEX=VariableValue DELIMITERS=; #Trim(ListFirst(Variables.VariableValue, =))#: #Trim(ListLast(Variables.VariableValue, =))#BR /CFLOOP /CFIF /CFIF !--- URL variables (only stored in a structure in 4.5 and above) --- CFSET Variables.Version = ListGetAt(Server.ColdFusion.ProductVersion, 1) + ListGetAt(Server.ColdFusion.ProductVersion, 2) / 10 CFIF Variables.Version GTE 4.5 !--- Put the URL variables in a list. --- CFSET Variables.URLList = CFLOOP COLLECTION=#url# ITEM=Key CFSET Variables.URLList = ListAppend(Variables.URLList, Key) /CFLOOP CFSET Variables.URLList = ListSort(Variables.URLList, text) H4URL Variables/H4 CFIF NOT Len(Variables.URLList) PThere are no URL variables/P CFELSE CFLOOP LIST=#Variables.URLList# INDEX=Key URL.#Key#: #URL[Key]#BR /CFLOOP /CFIF /CFIF !--- Form variables --- H4Form Variables/H4 CFIF NOT IsDefined(Form.FieldNames) PThere are no form variables/P CFELSE CFLOOP LIST=#Form.FieldNames# INDEX=Key Form.#Key#: #Evaluate(Form. Key)#BR /CFLOOP /CFIF /CFOUTPUT /CFIF -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: Cold Fusion Error on Solaris
this isn't a cf issue. what are the defaults for the user that CF is running under? On Thu, 1 Nov 2001, Steven Monaghan wrote: We have just taken over hosting of a Cold Fusion website in-house. We are running on Solaris and have been live for just over 2 days without any problems. All of a sudden, everyone trying to connect to the site received the following error: Unix error number 24 occurred: Too many open files This was displayed in a standard Cold Fusion error format. My Sysadmin stopped and started the webserver running on the box, and the problem was resolved. Anyone else had a similar problem and willing to offer some guidance? Thanks, Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ 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: Processing an HTTP Post (not form)
I have a java applet that posting some data to my cold fusion template. But I can't seem to access the data. It doesn't appear to be showing up in a FORM post, more of a raw-socket post as far as I can tell from the documentation. When I output the CGI structure seen by the webserver via the Cold Fusion Template, I get the list attached at the bottom. As you can see, 46K of some data is being detected but I don't know how to access this data. I also notice the request method is now set to POST instead of GET. Even though I loop from the form structure and the variable fieldnames it doesn't see any named variables. The java applet also has the ability to transmit a header before the post, is there a way I can fake a form header so this data does show up as a form field? If you're using CF 5, you can use the GetHTTPRequestData function to retrieve the raw HTTP request body, which is what you want. If not, there's no way of which I'm aware within CF to get the request body directly. If you can change what the Java applet sends, you might be able to simply add something like this at the very beginning of your HTTP request body: myvar= Then, everything else within the body will be in the variable Form.myvar within your CF action page. This assumes that the Java applet is posting with the standard POST MIME type of application/x-www-form-urlencoded; if it's formatting the data some other way, you might have problems. 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: Menu Custom Tags
I checked this out and it looks really coolbut how did you generate the dynamic menus? Where do you add the queries? Thanks, j -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 4:22 AM To: CF-Talk Subject: RE: Menu Custom Tags This is an excellent DHTML menu, easy to use and customiseable. I use CF to generate dynamic menus with it. And it's free. http://linux.milonic.co.uk/menu/ -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 07:19 To: CF-Talk Subject: Re: Menu Custom Tags CF_Hiermenus. Actually its a great script without the CF wrapper, albeit a tad slow. Unmatched in its cross-browser compatibility, I think. Go to palm.com to see one of its nicer iterations. Also lucent.com; unisys.com; webtrends.com. With a bit of serious elbow grease you can completely data-drive the thing (generating the controlling hmarrays.js via CF). - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 9:26 PM Subject: Menu Custom Tags Can anyone reccomend a custom tag for Menus (DHTML, or anything else)??? Thanks, Mike ~~ 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] Frustrating IE window.open popup delay...
Sorry for the OT and cross-post from JS-Jive list, but I still haven't found the answer for this. Ever since upgrading to IE5, then 5.5, on my way too fast and memory-laden Dell laptop, JS popup windows take friggin' forEVER to popup, something like 10-12 seconds on average. After a fresh machine reboot, the problem seems to be improved, but still slow, something like 4-5 seconds. As soon as I have 3 or 4 IE windows open, the times jump up. I've done all the service packs, no difference. Anyone else seen this problem, and if so, is it fixable? tia, Ron ~~ 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: ### Output all variables?
CFLOOP COLLECTION=#Application# ITEM=Key #Variables.Key#: #Evaluate(Application. Variables.Key)#BR /CFLOOP No, no, no. Sorry, but, again, this is my pet peave. Please remember that when working with structures, you do not need to use evaluate like this. Simply use bracket notation: CFLOOP COLLECTION=#Application# ITEM=Key #Variables.Key#: #Application[Variables.Key]#BR /CFLOOP (Also note that this should be surrounded by CFLOCKs.) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~~ 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