Re: Close window : JavaScript (OT)
Instead of opening a new window, why don't you use an onUnload or onBeforeUnload event in the body tag to close the session? This script from MSDN worked in IE5.5 for me and supposedly it works in IE4+. HTML HEAD SCRIPT function closeIt() { // enter your close session script here event.returnValue = Any string value here will force a dialog box to appear before closing the window.; alert(alert); } /SCRIPT /HEAD BODY onbeforeunload=closeIt() PNavigate to another page to fire the before unload event. /BODY /HTML Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: Joseph Eugene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 05, 2001 9:33 AM Subject: Close window : JavaScript (OT) Hi all, I would like to know, if you guys had any code to 1.Open a new window when the User tries to close his Browser. 2. Close the new window Just opened when the user tried to close his browser. The above really is to Log the User Out and terminate his session. Appretiate any help Thanks Joe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ADA Section 508 Accessibility and CF tags
I don't know what a VBA site is but 'skip repetitve navigation links' was handled by USPS by putting a transparent link at the top of the navbar named Skip Navigation Bar with a target to the cell with the content of that page. That way when clicked, the screen reader would skip the navigation and go to the content area. Whats a 'VBA' site ? And also - A method shall be provided that permits users to skip repetitive navigation links. What is that driving at, exactly ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ADA Section 508 Accessibility and CF tags
Thanks Jeanne; I've been working with Section 508 a little, but I'm looking for specifics on CF tags like CFGrid mostly. It's an applet and I don't know if the screen readers can read that applet. So I guess my question is, are CF tags Section 508 compliant? Which ones are not? I searched the Allaire site and found nothing on tags and compliance. I'm now working on an application that uses CFGrid extensively (for a government client). I want to know if we need to offer an alternative (or change the CFGrid to something else) or if they are ok to leave in the application. Since government applications are supposed to be compliant by June 21st, I need to find out if we need to extend the pilot date so we can make this change, or if it is compliant we can stay on schedule. Any advice on cftag compliance is welcome! (I've already almost memorized the w3c accessibility so I only need cftag assistance). Thanks again Jeanne. That article is pretty much a repeat of the w3c recommendations tho. Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com Hi Bonnie, Our Maryland CFUG hosted a talk given by Jon Brundage, on 508 requirements at our last meeting. You can view his presentation under April 10, 2000: http://www.cfug-md.org/meetings.cfm I don't recall whether he touched on specific CFM tags, but it might be of some help. Best, - - - Jeanne - Original Message - From: Bonnie Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 11:47 PM Subject: ADA Section 508 Accessibility and CF tags Can anyone point me to articles or information on whether certain tags are Section 508 compliant? Say for example, CFGRID. is that accessible to disabled persons (a screen reader like JAWS or something)? MUCH tia! Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ADA Section 508 Accessibility and CF tags
To add to this, I've received a number of personal emails from persons wanting me to post any findings I get. I would appreciate replys to the list on this subject so folks can see how many are interested in this subject. I saved all those emails tho and I will definitely email you any answers I get (from the list or elsewhere). Thanks, Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: Bonnie Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 11:47 PM Subject: ADA Section 508 Accessibility and CF tags Can anyone point me to articles or information on whether certain tags are Section 508 compliant? Say for example, CFGRID. is that accessible to disabled persons (a screen reader like JAWS or something)? MUCH tia! Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ADA Section 508 Accessibility and CF tags
Can anyone point me to articles or information on whether certain tags are Section 508 compliant? Say for example, CFGRID. is that accessible to disabled persons (a screen reader like JAWS or something)? MUCH tia! Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Partners List
You're a saver for the 'short version' ;) Thanks! Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: Michael Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 11:17 PM Subject: Re: CF-Partners List Ok Bonnie, let me give you the shortened version ... 1. Someone at Macromedia had a brilliant idea, probably over the fifth chardonnay of the evening that they could screw a lot more money out of teh rich fat hosting companies if they gave them a special edition of CF and charged them a whole lot more for it. 2. Macromedia announced the good news. 3. Every small developer in the world howled from the rooftops and sales of ASP textbooks soared at Amazon.com 4. The guy at Macromedia, nursing a sore head, saw the messages in teh cold light of day and pondered for a while if he could brazen it out, but decided he wasn't in the White House and Wasn't at Redmond so he figured it was probably an idea who's day hadn't come yet. 5. Macromedia announced they'd listened to the developers and weren't going to do this afterall. 6. Every small developer in the world howled from the rooftops that Macromedia were great cos they listen to their customers. (Great huh? If Macromedia had taken the more traditional approach to lunatic ideas, and just let it die or pretended it was not a real idea only a proposal that wasn't going to be implemented, the good pR wouldn't have happened for them.) 7. The CF developoment community went back to work. Now you don't have to read it all. Cheers, Mike Kear Windsor, NSW, Australia AFP Webworks. On Wed, 2 May 2001, Bonnie Betts wrote: Ya know, I was thinking My computer has been down for about 3 days now,... I come back online to find this hot topic blazing on the list about the Hosting edition, CF-Partners, etc. and I really would like to just focus on that subject alone. I sorted my email by subject, but still that didnt' get me any chronological order of the subject etc. Not to mention that I can't possibly read it all before I go to bed and can't get my emails that have downloaded at work tomorrow so I can't finish follow-up at work. It's really too bad this format isn't an online forum instead of an email list. I just started a new job this week so I didn't have a chance yet to subscribe for my work email address yet. And I actually dread doing that because that would mean wading thru 200ish emails/day both at home and at work and many would be duplicates (time waste reading dups). Is there an archive section of subjects or list postings etc that I'm not aware of? Does anyone have a suggestion for a 'wander CF Devr' to stay current (while being practical with time restraints)? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 8:17 AM Subject: Re: CF-Partners List *** Team Allaire *** On the topic of mine is bigger than yours, the list gets an average of 200 posts a day. Multiply that by 30 days and that's your 6000 messages. Now if that's just a month, think of how much you have after a year. Now think of ALL the lists together. Anyone want to buy me a new hard drive for my mail alone? ;) Only 6000? Your post made me take a look at my CF-Talk folder. I've got over 12,000 and that's after archiving almost 5000 to a local DB. Guess you're right, it's time to archive again. Thx Stephen -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 10:27 AM To: CF-Talk Subject: RE: CF-Partners List I agree, my CF-Talk folder has over 6000 messages in it. I think its time to clean up. Rich -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 12:43 PM To: CF-Talk Subject: Re: CF-Partners List Only if you set up a filter to do it... Personally, I don't think I could survive on a daily basis without e-mail filtering. At 09:20 AM 04/30/2001 -0400, you wrote: Doesn't email filtering accomplish the same task? Howie - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 5:05 AM Subject: RE: CF-Partners List Great idea. I was getting sick of opening up e-mails (in Outlook) just to see if an e-mail came from a macromedia.com address. Any chance of doing the same for e-mails from allaire.com? -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650
Re: CF-Partners List
Ya know, I was thinking My computer has been down for about 3 days now,... I come back online to find this hot topic blazing on the list about the Hosting edition, CF-Partners, etc. and I really would like to just focus on that subject alone. I sorted my email by subject, but still that didnt' get me any chronological order of the subject etc. Not to mention that I can't possibly read it all before I go to bed and can't get my emails that have downloaded at work tomorrow so I can't finish follow-up at work. It's really too bad this format isn't an online forum instead of an email list. I just started a new job this week so I didn't have a chance yet to subscribe for my work email address yet. And I actually dread doing that because that would mean wading thru 200ish emails/day both at home and at work and many would be duplicates (time waste reading dups). Is there an archive section of subjects or list postings etc that I'm not aware of? Does anyone have a suggestion for a 'wander CF Devr' to stay current (while being practical with time restraints)? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 8:17 AM Subject: Re: CF-Partners List *** Team Allaire *** On the topic of mine is bigger than yours, the list gets an average of 200 posts a day. Multiply that by 30 days and that's your 6000 messages. Now if that's just a month, think of how much you have after a year. Now think of ALL the lists together. Anyone want to buy me a new hard drive for my mail alone? ;) Only 6000? Your post made me take a look at my CF-Talk folder. I've got over 12,000 and that's after archiving almost 5000 to a local DB. Guess you're right, it's time to archive again. Thx Stephen -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 10:27 AM To: CF-Talk Subject: RE: CF-Partners List I agree, my CF-Talk folder has over 6000 messages in it. I think its time to clean up. Rich -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 12:43 PM To: CF-Talk Subject: Re: CF-Partners List Only if you set up a filter to do it... Personally, I don't think I could survive on a daily basis without e-mail filtering. At 09:20 AM 04/30/2001 -0400, you wrote: Doesn't email filtering accomplish the same task? Howie - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 5:05 AM Subject: RE: CF-Partners List Great idea. I was getting sick of opening up e-mails (in Outlook) just to see if an e-mail came from a macromedia.com address. Any chance of doing the same for e-mails from allaire.com? -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is CF still relevant?
Can someone point me to any online articles about NEO? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "John McKown" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, April 21, 2001 8:56 PM Subject: RE: Is CF still relevant? Joseph, Great questions. If you asked me 6 months ago, I would answer you by saying that the reason I use CF primarily is because it is a great RAD tool. Today, I am thinking about how cool it will be to leverage my CF experience once CF is tied to Flash better (better than Harpoon). The thought of this alone gets my heart racing.A couple of years ago, M$ introduced their "Agent" ActiveX component that allowed you to have a little character (like those annoying M$ Office Assistants) that you could script to make talk. I thought that this was pretty neat, but it required a slow download, and the performance was hideous. Also, you were stuck with the characters that M$ developed. With Flash working better with CF, you could create some compelling agents, IM programs, distance learning tools, training programs, and more. There is probably a lot of potential here that we have not even thought of yet. So the Flash potential and also UltraDev's *potential* have me excited. Those are my hopes for CF. My fears are: - How well will CF be integrated with UltraDev? - How well will CF be integrated with Flash? And I don't mean little Harpoon calendars. - Will MM fix/improve the advanced security features of CF? The "Users -- Groups -- Policies" security model is cludgy. - Will MM or Version 5.0 improve/automate remote file management? By this I mean that I would like for CF to allow me to manage files on the server much like FrontPage extensions do. You rename a file, and all of the links to the file get renamed. FP is a newbie tool, but this is a HUGE time saver when you have a really big site to manage. - Will MM lower the cost of the server? The pro version should cost $599.00. - How will the real world performance be with the Java-based "NEO" (CF version 6.0). I know they say it is faster, but I am just worried. - How soon will 5.0 be out? User defined functions and querying a query will be awesome. The User defined functions alone will add tremendously to the CF community once you can download custom functions (loan calculators, etc.). Just my 2 cents. John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] -Original Message- From: Joseph Grossberg [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 12:28 PM To: CF-Talk Subject: Is CF still relevant? Now, before you dismiss this as a troll, please let me elaborate. This isn't so much an instigation or a whine as it is a call for us to take a step back and reevalutate things periodically. Over the course of my career as a web programmer/developer, I have worked with a variety of sever-side languages and technologies: ColdFusion, ASP, JSP, PHP, Perl and Python. I like some more than others, but I'm not an evangelist for any; they each have their uses. And I recognize some of CF's strengths: easy to learn for people who know only tag-based HTML or don't have significant programming experience; built-in admin tool; specialized editor; comes with pre-built tags and web-based administrator. There are also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively small community; etc. Right now, I work at a web development firm that is primarily "a CF house" (besides me). Our more senior programmers are looking at honing their CF skills, while our less experienced webmasters are trying to learn ColdFusion. But, I can't help but wonder whether they are wasting their time. Would they be better off spending their time learning ASP, Java or another non-CF solution? Why or why not? And how would we tell if and when it was time to give up CF and try something else, as all but the most stubborn experts in also-ran languages (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems (Amiga) have resignedly done? Lastly, why do *you* still use CF? Is it because it's what you're best at, and you don't want to try something new (where, temporarily, you'd be a novice again)? Is it because your ccompany's legacy code is all in CF? Is it because you genuinely think that ColdFusion is, generally speaking, the best solution for web application development in 2001? Joe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Screen Resolution with CF?
BrowserHawk is an excellent tool I've used as javascript and he has it as a CF tag as well as for ASP. Here's some links: http://devex.allaire.com/Developer/Gallery/SearchResults.cfm?Category=web+co ntent+and+style+sheets http://www.browserhawk.com/ Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Phill Gibson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 20, 2001 7:05 PM Subject: Screen Resolution with CF? Hi everyone, Does anyone know of a CF way to determine the users screen resolution? I know about using JS to produce something like: document.write("Your screen resolution is "+screen.width+"nbsp;Xnbsp;"+screen.height+".") but am looking for a way to obtain those numbers for use by CF while still on the server-side. Thanks for any help! Phill Gibson Velawebs Web Designs [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Un-defining a Variable
Can you try CFSET aVariable = "" where you want to 'undefine' it and use CFIF IsDefined("aVariable") AND aVariable IS NOT " " instead? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Geoff Hoffman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 12:33 PM Subject: Un-defining a Variable What I need/want is the ability to cfset aVariable = VOID so that subsequent isdefined("aVariable") returns FALSE. Another way of saying it would be, why isnt there DeleteVariable("var") like there is DeleteClientVariable("var") Or put yet another way, Why can't you cfset r=StructDelete(Variables, "var") As far as I can tell, once you use CFSET to create a variable, you can't undefine it. Is this true, or am I missing something? geoff hoffman [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfif myvar IS true vs cfif myvar
I thought cfif myvar tested to see if it existed.. no? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Bert" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 6:19 AM Subject: cfif myvar IS true vs cfif myvar There seems to be a difference in the outcome of cfif myvar IS true and cfif myvar, when myvar is a number but neither 0 nor 1. Is this a feature to be used, or a bug, or have i missed something? Bert ps save the code below as trueorfalse.cfm to see what i mean: cfparam name="myvar" default="2" cfoutput b#myvar#:/b cfif myvar IS true myvar IS true cfelseif myvar IS false myvar IS false cfelse cfelse (i.e. NOT "myvar IS true" OR "myvar IS false") /cfif br b#myvar#:/b cfif myvar myvar cfelseif NOT myvar NOT myvar cfelse cfelse (i.e. NOT "cfif myvar" OR "cfif NOT myvar") /cfif form action="trueorfalse.cfm" method="post" input type="text" name="myvar" value="#myvar#" input type="Submit" /form /cfoutput ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Showing the results of an add or edit operation
Try this on your submit button: INPUT TYPE="BUTTON" VALUE="Close Window" onClick="window.opener.location.reload(); self.close();" I used this for a popup page that added a new user, so just take out the self.close() if you aren't using a popup. Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Hubert Earl" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 10:42 AM Subject: Showing the results of an add or edit operation Hi, I've built four files. The first shows the contents of a table. The second is a form which the user to add to, edit or delete from the table, after which the user is automatically returned to the file showing the table contents. The third is the action file for the add to and edit operation and the fouth the action file for the delete operation. The problem is that when the user is automatically returned to the page showing the table contents, it doesn't show the results of the change for the add to or the edit operations. The user has to hit the refresh button to see the changes made (for the delete operation, however, the change is shown). What additional code should I use so that the results of the add to and edit operations are immediately visible, and in which file should the code be put? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Using 90-100% of processor time (911!)
Question on this thread: Would any of the log files give you a hint as to which pages were accessed when the server started using up resources? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Steven A. del Sol" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:35 PM Subject: Re: CF Using 90-100% of processor time (911!) I believe your problem is that on one of your pages you are timing out. Check to see if you have a page where you are passing a Alpha into a numeric field. It will not necessarily crash if you have a number in the sequence somewhere but it can stall your cfserver for hours. Also, set your timeout's lower and set server to restart on two timeouts. This error can happen with datefields too. Hope you find your problem it took us three weeks going through thousands of line of code to fine one date field not validating, throwing errors and causing the server to have cfserver at 95% to 100% of the memory usage. GOOD LUCK At 12:48 PM 4/16/2001 -0400, you wrote: My server developed a problem today. CFServer.exe is using almost all of the available processing time. I've tried stopping and starting the services and the NT box, but as soon as I start CF again it almost immediately grabs all of the processor time. I'm running NT and CF 4.01. We've had this application up and running for a little over a year now and have only started having this problem today. I'd greatly appreciate any suggestions, since this has my Web site running at a crawl. TIA! Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (646) 638-3444 http://www.hallofsports.com .. . . where the legends live on ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: two queries (nested cfoutput?)
Instead of doing one query, do two with the second query using a WHERE clause that matches the result id from the first. Then you can make separate cfoutputs and you won't get a "nested cfoutput" error. I'm not sure which table ids match what so I'm guessing here in this sample but it will give you the gist. CFQUERY NAME="notices" DATASOURCE="newsAndNotices" SELECT n.noticeID, n.title, n.url, n.information, d.iconPath FROM notices n, documents d WHERE notice.docType = documents.docTypeID /CFQUERY CFQUERY NAME="subnotices" DATASOURCE="newsAndNotices" SELECT title, docType FROM subnotices WHERE noticeID=#notices.noticeID# /CFQUERY Now you can display like: CFOUTPUT query="notices" #title# #url# #information# #iconPath# /CFOUTPUT CFOUTPUT query="subnotices" #title# #docType# /CFOUTPUT OR you can even do this: CFOUTPUT query="notices" #title# #url# #information# #iconPath# #subnotices.title# #subnotices.docType# /CFOUTPUT Hope that helps. Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Aimee Abbott" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 15, 2001 12:58 PM Subject: two queries (nested cfoutput?) I have have a problem in doing the cold fusion output (or the query) from three tables. I have simplified my example to just the part that is the problem -- hopefully I haven't simplified it too much. Basically I want a nested cfoutput to do what I want, I would like to know if this is because my design is flawed somewhere else. The tables are as follows. notices table noticeID docType title url information the second is all of the supporting documents for the notices, subnotes table subNoteID noticeID (relationship to notices.noticeID) title docType the third, is all the icons. documents table docTypeID type iconPath Now I would like to do a query that pulls all the notices, then I would like to do another query for the sub documents. What I would like to do (but can't) CFQUERY NAME="notices" DATASOURCE="newsAndNotices" select notice.noticeID, notice.title, notice.url, notice.information, documents.iconPath from notices, documents where notice.docType = documents.docTypeID /CFQUERY cfoutput query="notices" img src="#iconPath#" a href="#url#"#title#/a CFQUERY NAME="subs" DATASOURCE="newsAndNotices" select subnote.title as subTitle, subnotes.url as subUrl, documents.iconPath as subIcon from subnote, documents where notice.noticeID = subnote.noticeID and subnote.docType = documents.docTypeID and subnote.noticeID = #noticeID# /CFQUERY cfoutput query="subs" This is where the trouble is! img src="#subIcon#" a href="#subUrl#"#subTitle#/a /cfoutput /cfoutput You see what I want? I would really like a nested cfoutput. Do I really want this because my query is flawed? I tried origianally to get this all in one query, by doing joins but I got back results that had copys of all the notices for each of the subdocuments (so if I had five sub documents for a particular notice I got five query results containing the notice -- and the icon always seem to match the first result) The method I am using now logically does what I want it to do, I just can't seem to output it this way. Does anyone have any suggestions for what I can do? --Aimee ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW:
Bonnie E. Betts [EMAIL PROTECTED] 703-344-7057 -Original Message- From: Bonnie Betts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:36 PM To: Cf-Talk (E-mail) Subject: Does anyone know where the url is for the states-country database someone had post a while back? Bonnie E. Betts [EMAIL PROTECTED] 703-344-7057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.