How do I stop losing my cookies and stay logged in?
Hi Guys! I am running CF Server 5. Everything was working fine until a few weeks ago. Now sometimes when I click on a form link, I lose my User_Info cookie that tells me if I'm logged in or not. This causes the Application.cfm to cf include the login page and abort. If I hit Ctrl-F5 when I am sent to this forced relogin page, it always corrects itself and gives me the intended page. How do I stop losing my cookies and stay logged in? Thanx Dave P.S. Check out my Experts Exchange question for further details. Referring URL 1: http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20557348.htm l Referring URL 2: http://www.clipboardsolutions.net/RentACoder/test_form_field_inpection_logic .cfm Referring URL 3: http://www.clipboardsolutions.net/RentACoder/test_cgi_http_host.cfm Referring URL 4: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=12&threadid =578875 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Why is my CGI.HTTP_HOST an empty string now?
Hi Guys! Go to http://www.clipboardsolutions.net/RentACoder/test_cgi_http_host.cfm and push the submit button. Does the CGI.HTTP_HOST variable come up blank? It does for me and a few irate customers. Not only is the CGI.HTTP_HOST missing, but so are the CGI.HTTP_ACCEPT_ENCODING, CGI.HTTP_ACCEPT_LANGUAGE, CGI.HTTP_CACHE_CONTROL, CGI.HTTP_CONNECTION, CGI.HTTP_CONTENT_LENGTH, CGI.HTTP_CONTENT_TYPE, CGI.HTTP_COOKIE, CGI.HTTP_REFERER, and CGI.HTTP_USER_AGENT variables. This just started happening from templates that pass information via forms and I can't think of anything that could be causing it. Thanx Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: excel as a vehicle to collect and write back data to a CF-App
I have done more or less the same thing with my customers. It's a lot less taxing on the server to create the spreadsheet from HTML/CSV and have it run on the client than it is to manipulate it via an MS Office object on the server, but you end up doing both. I create the look I want for my Excel spreadsheet in HTML and save it as an HTML file then open it up in an Excel object on the server: /* Get the first sheet */ objWorkSheet = objWorkSheets.Item(Val(1)); objWorkSheet.Name = SheetName; Then I just save it as an Excel spreadsheet: /* Save the file */ objWorkSheet.SaveAs(ExcelFilePath, Val(1)); When the user is done filling in the workbook, they upload it via a form and then I query the sheet: ExcelODBCConnectionString = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & ExcelFilePath & ";DefaultDir=" & GetDirectoryFromPath(ExcelFilePath) & ";"; SELECT * FROM "#SheetName#$" WHERE (Users_ID IS NOT NULL) It took a long time to figure out how to read the complete set of an arbitrary number of columns and associate it with the correct row. Also, validation is a real pain. I'm still working on vbscript validation that I can convert from HTML, but haven't figured out how to do it yet. -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 10:34 PM To: [EMAIL PROTECTED] Date: Sat, 28 Dec 2002 22:00:48 +0100 From: [EMAIL PROTECTED] Subject: excel as a vehicle to collect and write back data to a CF-App Message-ID: <[EMAIL PROTECTED]> I have a customer, who runs an application, where he can show, who is a a promotor or a consultant for certain products he is selling. The application runs on: CF 4.5, Win NT 4 Server with IIS 4 and MS-Access as a backend. Updating and deleting data works on a user-data-record base via web-frontend. Now the customer wants to deliver certain data, that has to be edited by certain responsible users. He wants to deliver the lists, the people should use in excel. What he wants is, that he collects all the excel-lists and rewrite the changed records he got back from the excel-lists and transferring them (via CF) to MS-Access. Some aspects how to do this are clear, but can somebody give me some advice on what the pitfalls are on scripting those templates, maybe somebody who has done more or less the same ? Would be great. Thanks. Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Translucent Databases and Cold Fusion
Hi Guys! Check out http://www.wayner.org/books/td/ - in it, Peter Wayner describes methods to construct databases that use one-way functions to scramble data and shield it from prying eyes. Unfortunately his examples are all in the overly-long-winded Java language, and I don't have the time nor money right now to analyze his code. Can anybody translate his examples into Cold Fusion? Here are some of the case studies (take your pick): 1. A database that hides the position of Navy ships from enemies while simultaneously providing accurate information to those with proper authorization. 2. An anti-rape database that identifies trends without containing any personal information. 3. A babysitter scheduling service that matches parents with available sitters while protecting the sitters' identities and locations'. 4. A department store database that guards the modesty of customers. 5. A private accounting system that detects fraud without revealing information. 6. A poker game for the Internet that prevents cheating. 7. A pharmacy database for preventing dangerous drug interactions while keeping medical records secure. 8. A tool for travel agents to protect their clients from stalkers and kidnappers. 9. A stock exchange transaction mechanism designed to stop insider-trading. 10. A website logfile tool that provides accurate counts of visitors while protecting their identities. 11. A credit-card database for defending crucial e-commerce transactions. 12. A patent search tool that doesn't reveal the nature and focus of the search. 13. A conference bulletin board that routes messages without helping stalkers. 14. A tool for studying the radon concentration in homes without maintaining personal information. 15. An anti-money laundering database. I know one trick where the password is hashed before it is stored in the database - an administrator can reset the password but can't tell you what it is. But this trick doesn't cover cases where the information needs to be displayed to certain people. Know any others? Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Page is Loading message...
Processing #Variables.PageTitle# http://www.paypal.com/images/period_ani.gif"; width="20" /> document.all.PleaseWaitMessage.style.display='none'; -Original Message- [snip] I have several CF templates that take quite some time to process. Can someone tell me how I can include an animated gif to display 'Page is loading' while the template is being processed so that the page visitors don't have to stare at a blank screen while it is being processed? []snip]
RE: sql for creating access memo field?
CREATE TABLE TESTTABLE ( BookmarkID COUNTER NOT NULL PRIMARY KEY, BookmarkName TEXT(255), BookmarkCategory TEXT(255), BookmarkURL TEXT(255), BookmarkDescription MEMO, BookmarkAdded DATETIME DEFAULT GETDATE(), BookmarkVisits NUMBER, BookmarkRating TEXT(50), BookmarkLastVisit DATETIME DEFAULT GETDATE() ) -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 7:30 PM To: CF-Talk Subject: RE: sql for creating access memo field? How do I set my DATETIME fields to default to "=Now()" when creating the following table: CREATE TABLE TESTTABLE ( BookmarkID COUNTER NOT NULL PRIMARY KEY, BookmarkName TEXT(255), BookmarkCategory TEXT(255), BookmarkURL TEXT(255), BookmarkDescription MEMO, BookmarkAdded DATETIME, BookmarkVisits NUMBER, BookmarkRating TEXT(50), BookmarkLastVisit DATETIME ); Thanks. Peter Tilbrook Project Officer Strategic Development Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2600 Telephone: (02) 6213 6731 Facsimile: (02) 6213 7287 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 15 October 2002 4:56 AM To: CF-Talk Subject: RE: sql for creating access memo field? desc is a reserved word [desc] is okay. Joshua Tipton -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 2:35 PM To: CF-Talk Subject: sql for creating access memo field? Can anyone tell me the sql for creating a memo field in a table (Access database)? This obviously does not work: CREATE TABLE temp (tapeid number PRIMARY KEY, Title char(255), Desc memo) Thanks, Les ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: ThreeRelatedSelects.cfm javascript error
threerelatedselects is not being maintained properly so this error has to be refixed by every coder who downloads it! If you email me I will send you my copy. -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 9:27 AM To: CF-Talk Subject: ThreeRelatedSelects.cfm javascript error Hello all, Just a quick question... Has anybody used the threerelatedselects tag from the developer exchange? I've bee using it for a long time, and I just recently began getting an error on it. I'm not great with javascript, so maybe somebody else has seen this and knows the cause: My javascript error: = Line: 1852 Char: 3 Error: 'NewOpt' is undefined Code: 0 This is the section in the source code: = if (menuNum2 == 11) { NewOpt = new Array; NewVal = new Array; NewOpt[0] = new Option("RTM"); NewOpt[0].value = 'RTM'; } Thanks for any help. Ryan J. Pieszak Applications Engineer Ziphany, LLC. (716) 510-0379 www.ziphany.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: This feature should never have been uploaded!" or Version Control Systems, Anyone?
What makes this issue "fundamentally more complicated" is, as Eric points out, OTHER PEOPLE - i.e., getting the boss to annotate his changes to the templates. For instance, my templates have this kind of stuff on top: and this kind of stuff on the bottom: Now, what good does it do if I "work in a consistent and systematic manner" but can't get anybody else to respect that? I need an outside enforcer. I NEED SOFTWARE! Introducing software into the corporation means not having to teach petulant developers who can't write less than 30 bugs per KLOC my organization system. I spend less time babysitting that way, with less resentment. I hope, anyway. :-) -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 1:44 PM To: CF-Talk Subject: RE: This feature should never have been uploaded!" or Version Control Systems, Anyone? >>Wow, you can keep track of 200 issues? Most people can only keep >>track of 7 according to psychological tests. Just reread your post. I was going to say someone told me the human brain breaks down after 5 elements. so if you are building interfaces - if you have 5 things to look at people can handle and understand those 5 things at once. As soon as you start to get more - it just looks like a bunch of noise and retention and understanding is low. my point? i dunno. I personally use the human engineering bit. and it breaks down as soon as someone else starts developing with me on a project. I have been looking for a simple, easy to implement source control manager. I just can't decide exactly what I want - AND find the system that does it for free. I'll keep looking. To defend Mark's position - I think what he is saying is - if you work in a consistent and systematic manner that IS an effective method of source control. You don't need to track 200 things at once - because in the scope of performing a task you rarely multitask like that. I mean what do you want in a source control system. Revision Management, File Locking / Revision Branching, Distribution builds? You guys are the pros - you tell me. Revision Management is easy enough. Name the file with its version information. ie index [1.001.001].cfm File locking index [eric][1.001.002].cfm Branching index [mark][1.001.002.2].cfm Builds? maybe a batch file? which creates a distribution build? build_app.bat copy index [1.001.001].cfm build_001/index.cfm etc. Just thinking aloud. meaning structured work flow - means controlled source. and I don't think fundamentally its any more complicated than that. Eric From: Dave Babbitt <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: This feature should never have been uploaded!" or Version Control Systems, Anyone? Date: Mon, 24 Jun 2002 12:49:10 -0400 If I took that psychological test, I would probably score 2 out of 7. Let's just say that my manual implemented issue control mechanism increases that by a factor of 50. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 11:33 AM To: CF-Talk Subject: RE: This feature should never have been uploaded!" or Version Control Systems, Anyone? Wow, you can keep track of 200 issues? Most people can only keep track of 7 according to psychological tests. Source control is the most basic part of the development process and anyone who recommends "human engineering" is someone to steer clear from. On Thu, 20 Jun 2002, Dave Babbitt wrote: > I have been using the human engineering method of controlling code, but it > seems at about 200 Issues, my brain starts losing track of which issues > intersect at which template. > > -Original Message- > From: Mark Warrick [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 19, 2002 6:03 PM > To: CF-Talk > Subject: RE: This feature should never have been uploaded!" or Version > Control Systems, Anyone? > > > Visual Source Safe? > > http://msdn.microsoft.com/ssafe/ > > Personally I prefer the human engineering method of controlling code, but if > you gotta have a computer keep track of what you do - well - there you go. > > ---mark > > > Mark Warrick ([EMAIL PROTECTED]) > Founder, Fusioneers.com / CTO, ZapConnect.com > Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 > http://www.warrick.net / http://www.fusioneers.com > http://www.zapconnect.com > ICQ: 125160 AIM: markwarric Yahoo: Serengeti > > > > > -Original Message- > > From: Dave Babbitt [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 19, 2002 1:29 PM > > To: CF-Talk > > Subject: This feature should never have
RE: This feature should never have been uploaded!" or Version Control Systems, Anyone?
Are you implying that there is a hidden cost? Called "turnaround time"? Please explain. -Original Message- From: Cravens, Billy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 19, 2002 5:12 PM To: CF-Talk Subject: RE: This feature should never have been uploaded!" or Version Control Systems, Anyone? The the quickest turnaround, I'd say PVCS Version Manager. --- Billy Cravens -Original Message- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 19, 2002 3:29 PM To: CF-Talk Subject: This feature should never have been uploaded!" or Version Control Systems, Anyone? Hi Guys! For some inexplicable reason, probably financial, my boss, the CTO, steadfastly refused to buy any version control system off the shelf and left me with the task of managing this manually. I didn't have control over the development server, there was no staging server, etc. Now, the CTO is no longer my boss and the president has given me permission to buy something. But, what? It has to manage about 84,000 lines of code. It has to be able to revert to a previous version on the production server, etc. Any suggestions? Thanx Dave __ 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: This feature should never have been uploaded!" or Version Control Systems, Anyone?
If I took that psychological test, I would probably score 2 out of 7. Let's just say that my manual implemented issue control mechanism increases that by a factor of 50. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 11:33 AM To: CF-Talk Subject: RE: This feature should never have been uploaded!" or Version Control Systems, Anyone? Wow, you can keep track of 200 issues? Most people can only keep track of 7 according to psychological tests. Source control is the most basic part of the development process and anyone who recommends "human engineering" is someone to steer clear from. On Thu, 20 Jun 2002, Dave Babbitt wrote: > I have been using the human engineering method of controlling code, but it > seems at about 200 Issues, my brain starts losing track of which issues > intersect at which template. > > -Original Message- > From: Mark Warrick [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 19, 2002 6:03 PM > To: CF-Talk > Subject: RE: This feature should never have been uploaded!" or Version > Control Systems, Anyone? > > > Visual Source Safe? > > http://msdn.microsoft.com/ssafe/ > > Personally I prefer the human engineering method of controlling code, but if > you gotta have a computer keep track of what you do - well - there you go. > > ---mark > > > Mark Warrick ([EMAIL PROTECTED]) > Founder, Fusioneers.com / CTO, ZapConnect.com > Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 > http://www.warrick.net / http://www.fusioneers.com > http://www.zapconnect.com > ICQ: 125160 AIM: markwarric Yahoo: Serengeti > ==== > > > > -Original Message- > > From: Dave Babbitt [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 19, 2002 1:29 PM > > To: CF-Talk > > Subject: This feature should never have been uploaded!" or Version > > Control Systems, Anyone? > > > > > > Hi Guys! > > > > For some inexplicable reason, probably financial, my boss, the CTO, > > steadfastly refused to buy any version control system off the > > shelf and left > > me with the task of managing this manually. I didn't have control over the > > development server, there was no staging server, etc. > > > > Now, the CTO is no longer my boss and the president has given me > > permission > > to buy something. But, what? It has to manage about 84,000 lines > > of code. It > > has to be able to revert to a previous version on the production server, > > etc. > > > > Any suggestions? > > > > Thanx > > > > Dave > > > > > > __ 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: How Do I Flip A Table?
Jefry Houser got it down to one database query and one query of a query: select Division, Program_Name from table select Distinct Program_Name, Count(Division) as colspan from Loop2 Then look similar to the way I Set up the above table: #loop2.Program_Name# And he didn't even stumble over any furniture! :-) The nice thing about this solution is that you can change the CFOUTPUTs to CFLOOPs because it doesn't use grouping. -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 12:56 PM To: CF-Talk Subject: RE: How Do I Flip A Table? So what was the solution that actually worked? Nathan > -Original Message- > From: Dave Babbitt [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 10, 2002 9:33 AM > To: CF-Talk > Subject: How Do I Flip A Table? > > > Hi Guys! > > How do I turn a CFQUERY record set that CFDUMPs like this: > > bordercolor="Red"> > > > DIVISION > > PROGRAM_NAME > > > Team valign="top" > bgcolor="#ff"> Bear Street > Team valign="top" bgcolor="#ff"> > Clipboard Solutions bgcolor="#ff"> > Team bgcolor="#ff"> Emerson Associates valign="top" > bgcolor="#ff"> Team > Lake Avenue valign="top" bgcolor="#ff"> > Team Smithfield > road > > Cambridge Health Alliance bgcolor="#ff"> The Beck > Ward valign="top" bgcolor="#ff"> North East bgcolor="#ff"> The Oliver Street > House > > > into something like this: > > BORDERCOLOR="Red"> > > Team > Cambridge Health Alliance > North East > > > Bear Street > Clipboard Solutions > Emerson Associates > Lake Avenue > Smithfield road > The Beck Ward > The Oliver Street House > > > > I left the COLSPANs in there as a possible help to solving the general > problem. I suspect there is a more eloquent solution than > performing two or > three subqueries, though. :-) > > Thanx > > Dave > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How Do I Flip A Table?
Well, if you go out on a binge tonight and crash into any furniture, I'm not accepting that as a solution. :-) -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 11:03 AM To: CF-Talk Subject: Re: How Do I Flip A Table? oi Dave!! any extra leverage from on side alone should do it :) baahahahahahh it's friday. whatcha spect from me (i thought it was funny anyway) -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - [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
How Do I Flip A Table?
Hi Guys! How do I turn a CFQUERY record set that CFDUMPs like this: DIVISION PROGRAM_NAME Team Bear Street Team Clipboard Solutions Team Emerson Associates Team Lake Avenue Team Smithfield road Cambridge Health Alliance The Beck Ward North East The Oliver Street House into something like this: Team Cambridge Health Alliance North East Bear Street Clipboard Solutions Emerson Associates Lake Avenue Smithfield road The Beck Ward The Oliver Street House I left the COLSPANs in there as a possible help to solving the general problem. I suspect there is a more eloquent solution than performing two or three subqueries, though. :-) Thanx Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
[no subject]
Hi Guys! How do I turn a CFQUERY record set that CFDUMPs like this: DIVISION PROGRAM_NAME Team Bear Street Team Clipboard Solutions Team Emerson Associates Team Lake Avenue Team Smithfield road Cambridge Health Alliance The Beck Ward North East The Oliver Street House into something like this: Team Cambridge Health Alliance North East Bear Street Clipboard Solutions Emerson Associates Lake Avenue Smithfield road The Beck Ward The Oliver Street House I left the COLSPANs in there as a possible help to solving the general problem. I suspect there is a more eloquent solution than performing two or three subqueries, though. :-) Thanx Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: URGENT : How to Detect screen resolution in COLDFUSION?
Hi Jaime! Any of these events (the body tag's onLoad, the form tags onSubmit, or the submit field's onClick) can be used to set the info you need in the hidden field: function detectScreenResolution() { var myResolution = 'height = ' + screen.availHeight + ', width = ' + screen.availWidth; alert(myResolution); document.myForm.myHiddenField.value = myResolution; } Check URL.myHiddenField to see the value. Or, alternately you can POST the form and pick it up in Form.myHiddenField. Get it? Dave -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 9:26 PM To: CF-Talk Subject: RE: URGENT : How to Detect screen resolution in COLDFUSION? i understand...but how can i set javascript into a coldfusion variable? -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:18 AM To: CF-Talk Subject: Re: URGENT : How to Detect screen resolution in COLDFUSION? The only thing you can do is use Javascript to get the resolution and then stick it into a variable ... that may work. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: "JAIME HOI" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 24, 2002 8:11 PM Subject: URGENT : How to Detect screen resolution in COLDFUSION? > hi > Anyone have the script to detect screen resolution in coldfusion? i am > able to detect the screen resolution in javascript but not in coldfusion. > > > "Contentment is not the fulfillment of what you want, it is the realization > of how much you already have." > > > > __ 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: Macromedia's XML Resource Feed
Is it that the WDDX cannot read the tag? When I try to subscribe to this feed with my Radio Userland I get: Can't subscribe to the channel. The most likely cure is to check the URL in a web browser and see if you can get it to read the feed. The following message probably won't help you figure out what went wrong, but we include it here because it might. "Can't get the address of "rss" because the table doesn't have an object with that name." The reference you give says: ColdFusion Use the XML feed as a data source within ColdFusion to create dynamic content for an HTML page. In order to parse the XML in ColdFusion, you will need to use a third party XML parser such as a COM object or Java based parser. Of course you knew that. :-) My instinct is to use the loadXML method (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/htm /xml_mth_hn_1nho.asp) by downloading it into some MSXML javascript like this: var xmlDoc = new ActiveXObject("Msxml2.DOMDocument.4.0"); xmlDoc.async = false; xmlDoc.loadXML("#REReplace(CFHTTP.FileContent, Chr(62) & '[[[:space:]]]+' & Chr(60), Chr(62) & Chr(60), 'ALL')#"); alert(xmlDoc.xml); Of course you have to download (http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?u rl=/msdn-files/027/001/766/msdncompositedoc.xml) and register (http://doc.ddart.net/xmlsdk/htm/sdk_installregister_4r76.htm) Microsoft XML Core Services 4.0 RTM. If you could download a copy local to the browser you could just use var xmlDoc = new ActiveXObject("Microsoft.XMLDOM"); and xmlDoc.load("macromedia_resources.xml"); and not have to worry about downloading the 4.0 as the XMLDOM is probably already installed in your IE browser. -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 1:54 PM To: CF-Talk Subject: Macromedia's XML Resource Feed Hi, Has anyone used Macromedia's resource feed with CF located at http://www.macromedia.com/desdev/articles/xml_resource_feed.html How is it done? I've done XML parsing with Moreover's XML feeds using WDDX, but this is different. Here's my feeble code: http://www.macromedia.com/desdev/resources/macromedia_resources.xml";> The error is: unknown element encountered I know I'm probably way off in using WDDX to parse the xml doc here. Any help here greatly appreciated. Thanks! Andrew __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Queries Are Running Too Long
Hi Guys! Can anybody tell why this query is taking SEVENTEEN SECONDS to run? I'm looping through a bunch of form variables, and this query is taking 12 to 14 seconds every time (but this first time) to run. I'm running SQL Server and CF Server off my laptop, but it didn't started running this slow until lately. Updating to SQL Server SP2 had no effect. UpdateTimeEntry (Records=1, Time=17095ms) SQL = -- ID: /_PM/includes/get_approver_field.cfm, v1.1.0 4/6/2001 4:45:10 PM dbabbitt (71726827) SET NOCOUNT ON -- Set it up so that you can see if the update actually occurred DECLARE @rowcount INT DECLARE @Audit_ID INT -- Attempt to set the clockin UPDATE Time_Actual SET -- Payroll approves all Approved_House_Manager = 1, Approved_Human_Resources = 1, Approved_Payroll = 1 WHERE Time_Actual_ID = 34552 SET @rowcount = @@ROWCOUNT -- Assume our audit table has a new record in it if we return a row count IF @rowcount > 0 BEGIN SELECT @Audit_ID = MAX(IDENTITYCOL) FROM Time_Actual_Audit UPDATE Time_Actual_Audit -- The user here is the approver SET Users_ID = 1427 WHERE (Time_Actual_Audit_ID = @Audit_ID) END SET NOCOUNT OFF __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Running Excel Web Queries Cause Browser Caching Problems?
Hi Guys! I have this strange problem: after running an Excel Web Query to a Cold Fusion template on a server, some browsers refuse to not cache certain pages on that server. First I mucked up my laptop, then I mucked up the Development Server, now the Production Server is mucked up. Thanks to my inattentiveness on the matter, some of our clients are logging on to our application from mult-user pcs and seeing the previous users personalization! At first I was distracted by the way Excel cf authenticates - on our application a wddx cookie is set containing some personal information after a simple login. So I concentrated on getting the Excel Web Query to send the proper name and password. I successfully developed a custom tag that just needs to be placed where you want the link to show and creates an iqy file which automatically opens in Excel and sends all form and url data needed to query the same page you are on. The only thing Excel asks for is your password. Beautiful, huh? But, basking in my success, I am now able to see what happens on servers which many people are using. Couple of questions: 1) How do I find out what header info Excel is sending to my Cold Fusion server? I inserted the custom tag at the bottom of the developer's version of the site wide error handler, which just cf dumps all the structures that exist on the Cold Fusion server, and ran the web query to there, but I can't see any differences. The http user agent is Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461), but that isn't any different than the browser. Even the cf token and cf id are the same! 2) How do I get the browser cache on certain machines to work normally again? I have scads of no-cache header tags, uuids in my url, etc., my these are just work-arounds. The underlying problem still remains. Thanx Dave __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are these, headers?
Hi Guys! I have this strange problem: after running an Excel Web Query to a Cold Fusion template on a server, some browsers refuse to not cache certain pages on that server. First I mucked up my laptop, then I mucked up the Development Server, now the Production Server is mucked up. Thanks to my inattentiveness on the matter, some of our clients are logging on to our application from mult-user pcs and seeing the previous users personalization! At first I was distracted by the way Excel cf authenticates - on our application a wddx cookie is set containing some personal information after a simple login. So I concentrated on getting the Excel Web Query to send the proper name and password. I successfully developed a custom tag that just needs to be placed where you want the link to show and creates an iqy file which automatically opens in Excel and sends all form and url data needed to query the same page you are on. The only thing Excel asks for is your password. Beautiful, huh? But, basking in my success, I am now able to see what happens on servers which many people are using. Couple of questions: 1) How do I find out what header info Excel is sending to my Cold Fusion server? I inserted the custom tag at the bottom of the developer's version of the site wide error handler, which just cf dumps all the structures that exist on the Cold Fusion server, and ran the web query to there, but I can't see any differences. The http user agent is Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461), but that isn't any different than the browser. Even the cf token and cf id are the same! 2) How do I get the browser cache on certain machines to work normally again? I have scads of no-cache header tags, uuids in my url, etc., my these are just work-arounds. The underlying problem still remains. Thanx Dave __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any Javascript people out there? I need help with select bo xes...
You'll need to recreate the menu items a la TwoSelectsRelated. -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 4:48 PM To: CF-Talk Subject: RE: Any Javascript people out there? I need help with select bo xes... I tried that and got this error... selectCtrl.options[i] has no properties. Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Brian Rosenstock [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 3:48 PM To: CF-Talk Subject: RE: Any Javascript people out there? I need help with select bo xes... I think you'd need to do: selectCtrl.options[i].value = i+1; selectCtrl.options[i].text = i+1; instead of just: selectCtrl.options[i] = i+1; Brian Rosenstock -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 4:39 PM To: CF-Talk Subject: OT: Any Javascript people out there? I need help with select bo xes... sorry about the OT post..I need help with a select box. I am making 2 select boxes (Month and Day). when the user changes the month, I want the javascript to delete what is in the day select box and fill it with the number o f days in that month. I have the deleting part working. It just won't add. I 'm not sure what I need to do. Here is my code(Please ignore that I HAVE to use ASP for this).. January February March April May June July August September October November December Day: <%for i = 1 to 31%> <%=i%> <%next%> function changeMonth(theform,selectCtrl,iValue) { var oNewOption; iSelection = iValue; iOptLen=selectCtrl.length + 1; for (i=0;i<=iOptLen;i=i+1) { selectCtrl.options[0] = null; } if (iSelection == "1" || iSelection == "3" || iSelection ="5" ||iSelection= "7" || iSelection == "8" || iSelection == "10" || iSelection == "12") { for (i=0;i<=30;i=i+1) { selectCtrl.options[i] = i+1; } } if (iSelection == "2") { for (i=0;i<=27;i=i+1) { selectCtrl.options[i] = i+1; } } if (iSelection == "4" || iSelection == "6" || iSelection ="9" ||iSelection= "11") { for (i=0;i<=29;i=i+1) { selectCtrl.options[i] = i+1; } } } Someone please drop me a line and tell me what I am doing wrong. I am absolutely clueless Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Formatting HTML to be Handled by Excel's Web Query
Hi Guys! Playing around with Excel's Web Query, I've discovered that when you format a cell as a date and save it as a web page, Excel encloses that cell in table data tags and adds a number to the tag's attributes like so: 12/10/01 8:00 AM 12/10/01 5:00 PM I guess this number represents the date in Microsoft Excel date-time code. If this is true then the integer part represents (on my wintel system) the number of days after January 1, 1900 (plus one). And I guess 8 am is about a third of a day, so the fractional part seems right, though incorrectly rounded at 10E-12. I also discovered, looking in the style sheet created by Excel, that if you don't have the mso-number-format in your style correctly, Excel won't format the date-time code correctly. So it's just a matter of: #DateFormat(MyHoursQuery.Time_In, Application.DateMask)# #TimeFormat(MyHoursQuery.Time_In, Application.TimeMask)# #DateFormat(MyHoursQuery.Time_Out, Application.DateMask)# #TimeFormat(MyHoursQuery.Time_Out, Application.TimeMask)# Creating a cell in Cold Fusion that gives you the difference between these two in fractional hours in Excel is a little tricky. If you try to reverse engineer it from Excel, Excel will give you the absolute cell references. This would be a pain to keep track of in Cold Fusion. Luckily, it's just a matter of creating a formula that uses relative references. So it's just a matter of: #Variables.HoursColumn# The only hang here is that when you want 1/2, Excel gives you 2/4 instead. I suppose the fact that I didn't have to go through all the rigamorole to get Variables.HoursColumn into fractional hours in Excel like I did in Cold Fusion should be of some confort. Anybody out there have any better/faster/cheaper ways of prepping an HTML output to be pushed live into Excel? Thanx Dave __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: When is your site coming back online?
Which one? :-) -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 3:49 PM To: CF-Talk Subject: When is your site coming back online? Robert Everland III Dixon Ticonderoga ~~ 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: Ensure File Path Exists?
Here's the way I ensuring that the export file path exists now: ExportFileParentDirectory = GetDirectoryFromPath(DefaultPayrollExportFile); MissingDirectoryList = ""; MissingDirectoryList = ListPrepend(MissingDirectoryList, ExportFileParentDirectory); ExportFileParentDirectory = GetDirectoryFromPath(ExportFileParentDirectory); -Original Message----- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 10:33 AM To: CF-Talk Subject: Ensure File Path Exists? Hi Guys! Is there a UDF or Custom Tag that will create the directories necessary to save to any filepath? I imagine the best way to do it would be to peal the subdirectories off the file path onto a stack, then take them off the stack one by one and create as neccessary, but I can't find a UDF or Custom Tag that creates a stack either. Thanx Dave ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ensure File Path Exists?
Hi Guys! Is there a UDF or Custom Tag that will create the directories necessary to save to any filepath? I imagine the best way to do it would be to peal the subdirectories off the file path onto a stack, then take them off the stack one by one and create as neccessary, but I can't find a UDF or Custom Tag that creates a stack either. Thanx Dave ~~ 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: The Case of the Disappearing Cookies
What I'm planning to do is when I get another email, to call the group home and have whoever is there do some snooping for me. Assuming the person on the phone with me has nothing to hide and will try to help me, what steps should I tell them to take to inspect the history? I am working with IE 5.x here. Thanx Dave -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 3:25 PM To: CF-Talk Subject: RE: The Case of the Disappearing Cookies [snip] > 3) Is their a way to catch them in the act? It's possible that, > depending on what non-work related websites the staff are visiting, > our client would want to know and take appropriate action. [snip] On an even more casual note, these people probably aren't deleting their history, just their cookies, so you could take a look at that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [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
The Case of the Disappearing Cookies
Hi Guys! We run an Application Service for a collection of group homes. These group homes are manned 24/7 and the staff use our application to clock in and out. Maybe this wasn't the greatest idea, but I have implemented a system of cookies to track logins and clockins. When someone accesses our server, the CFID and CFTOKEN cookies are set, of course. When someone logs in, the USER_INFO cookie is set. When they log out, the USER_INFO cookie is deleted. In addition, in order to facilitate categorizing the time entries, three cookies are set up on each machine being used to clock in and out of: MACHINE_COST_CENTER, MACHINE_HOURS_TYPE, and MACHINE_LOCATION. The cookies are never deleted in my code - either through JavaScript or using . Whenever these cookies are missing or not correctly set, an email is sent to me with as much debug information as I can get. The problem I am having is that at different times and at different group homes, someone will not be able to clock in, even though their supervisor set up the machine earlier in the week. And the email I receive reveals that the CFID and CFTOKEN cookies are set, and the USER_INFO cookie is set, but the MACHINE_COST_CENTER, MACHINE_HOURS_TYPE, and MACHINE_LOCATION cookies are missing. I have to do some more research to be sure, but it seems like the only machines that lose some of their cookies are machines tucked away in group homes, not in office settings. What I suspect is that someone on the previous shift is visiting non-work related websites and deleting all the cookies that were modified on their shift. The next person logging in would then recreate all but the machine cookies, but then trying to clock in, would get the error. Questions: 1) Is their a machine-unique identification that can be sent from each browser that cannot be deleted? 2) Is their a way to prevent someone from deleting cookies? I think most of these machines are running Windows 98. 3) Is their a way to catch them in the act? It's possible that, depending on what non-work related websites the staff are visiting, our client would want to know and take appropriate action. Thanx Dave ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 . 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 . -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: 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: Determining Daylight Savings
There would be no way to tell that just by the date - you would have to have geographical data. Note: Daylight Saving Time, for the U.S. and its territories, is NOT observed in Hawaii, American Samoa, Guam, Puerto Rico, the Virgin Islands, the Eastern Time Zone portion of the State of Indiana, and the state of Arizona. The Navajo Nation, which is mostly in Arizona, also participates in the Daylight Saving Time policy, due to its large size and location in three other states which DO observe it. I heard that Sonora, MX is now on DST, FWIW. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 11:29 AM To: CF-Talk Subject: Determining Daylight Savings Hello, I have an issue that others may be running into or have solved. I am posting a series of events with their date, time, and time zone, i.e. EST. Is there a custom tag or UDF that will return whether a date/time is in Daylight Savings or not? It would need to work like the parameter isDSTon from GetTimeZoneInfo() but allow a date to be passed in. Any advice? Thank you, ~~ 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
Getting Trigger Results Back Through CFPROCS
Hi Guys! I posted this before but never got a response. Has anybody been able to figure out how to get trigger results back through cfprocs? If I do something like this: { CALL sp_MyStoredProc(#Int(MyInput)#) } The results of whatever triggers run can be seen in the dump - like Audit_ID will be there if their is some audit trail being run on the table that sp_MyStoredProc is affecting, for instance. But, if I do something like this: How do I see the results of whatever triggers run? What if I know that Audit_ID is the name of the field that the trigger returns? Understand that the Audit_ID field is never mentioned in sp_MyStoredProc - it's the output of a separate trigger (sp_MySeparateTrigger). Thanx Dave ~~ 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: AS400 Stored Procedure without using CFSTOREDPROC? - Anyone?
This doesn't work with IN/OUTs: { CALL ASTDTCCK.TESTPRC14('12345678', '#Variables.Price#') } But I guess you knew that. ;-| -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 7:30 AM To: CF-Talk Subject: RE: AS400 Stored Procedure without using CFSTOREDPROC? - Anyone? Can you not do it any other way? -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 7:59 AM To: CF-Talk Subject: AS400 Stored Procedure without using CFSTOREDPROC? The above stored proc works against the AS400. How can I do the same thing but without using the cfstoredproc tag? What would I put here? 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
RE: pop up windows
Hi bec.! You can't avoid the alert box - it's a safety feature. Assuming you have nothing untoward displayed from your Application.cfm or OnRequestEnd.cfm pages, on the parent page write something like this: function newWindow(windowURL, windowWidth, windowHeight) { /* creates a new resizable, centered window that can be closed and reopened without spawning errors. */ var windowLeft = (screen.availWidth - windowWidth)/2; var windowTop = (screen.availHeight - windowHeight)/2; var newWindow = window.open(windowURL, "Link", "toolbar=0, location=0, directories=0, status=0, menubar=0, scrollbars=0, resizable=1, width=" + windowWidth + ", height=" + windowHeight + ", left=" + windowLeft + ", top=" + windowTop + ", screenX=" + windowLeft + ", screenY=" + windowTop); if(newWindow.opener == null) {newWindow.opener = window}; newWindow.focus(); } add data (#TimeFormat(Now(), 'hh:mm:ss')#) On the child page write something like this: opener.location.reload(); close(); http://#CGI.HTTP_HOST##CGI.SCRIPT_NAME#/"; METHOD="POST" ENABLECAB="No"> -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 10:14 AM To: CF-Talk Subject: pop up windows i have a template that i want to be able to have a link that you would click on that would launch a popup window. the contents of that popup window when changed will effect the template underneath. my problem is that the window doesnt automatically close after i click on submit (an alert box asks me if i really want to close the window) i click on yes, but it doesnt refresh the template. how can i get the template to automatically refresh with the new changes and the popup window to just close after the submit button is clicked? i used window.close() but that still gives me that alert box. thanks, bec. [snip] ~~ 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: Popup calendar
Man! That is wild! Some fine craftmanship comes out of Brazil. In the fillDate(dataVal,month,year) function could you run obj1's onChange event if there was one set in the tag? How would you go about doing that? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:51 AM To: CF-Talk Subject: RE: Popup calendar I have one at http://planeta.terra.com.br/informatica/vega/_opcal/cal_en2.html It has nothing to do with CF and it only puts the date into the field but that can be accomplished with a small script modification. Feel free to modify and use it if you like. __ Jones, Becky wrote: > Has anyone seen a good script that pops up a calendar > and fills in not only a date in the text field but > also a time? UAI - ESTADO DE MINAS O Grande portal dos Mineiros na Internet ~~ 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: Running app from server...HELP!
Write yourself a plug-in that when loaded will redirect text files from the browser to UltraEdit. Because you are not going to get the browser to hand them off unless its preferences are changed. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 8:51 AM To: CF-Talk Subject: Running app from server...HELP! Hi, I've posted this before but I'm at a dead end. I have no idea how to go about this. I'm listing files in a directory on my server. All files are wrapped with What I want to happen is when a user clicks on a file I want that file opened in an editor on the client PC (not the server). In my case, UltraEdit. ~~ 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
Not Working With MSSQL
Hi Guys! Thanx to Ian Rutherford's suggestion, I have discovered the source of the problem: As long as I create my stored procedure without it, and not try to pass the CF version of the ODBC date setting as an input variable, I can call my stored procedure using the tag. But... that kind of defeats the purpose. So, how do I get a date value in there? Thanx Dave ~~ 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
ODBC Error Code = 22008 (Datetime field overflow)
Hi Guys! Can anybody figure out why I get a date time field overflow on this: SELECT * FROM sysobjects WHERE (OBJECTPROPERTY(id, N'IsProcedure') = 1) AND (name = N'sp_UpdateTimeOut') CREATE PROCEDURE sp_UpdateTimeOut @UserID [int] ,@TimeOutVarChar [varchar] AS SET @RowsEffected = 0 UPDATE Time_Actual SET Time_Out = CAST(@TimeOutVarChar AS datetime) WHERE Users_ID = @UserID AND Time_Out IS NULL Thanx Dave ~~ 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
'2001-10-23 06:18:10' Is Being Converted to "2"
Hi Guys! Can anybody figure out why this stored procedure is converting my varchar to "2"? Write your own for the datasource variable MyDSN and run this: SELECT COUNT(*) FROM sysobjects WHERE (OBJECTPROPERTY(id, N'IsProcedure') = 1) AND (name = N'sp_Test') DROP PROCEDURE sp_Test CREATE PROCEDURE sp_Test @DateTimeVarChar [varchar] AS SELECT @DateTimeVarChar -- DECLARE @Test_Assignment [datetime] -- SET @Test_Assignment = CAST(@DateTimeVarChar AS datetime) { CALL sp_Test('#DateTimeVarChar#') } Thanx Dave ~~ 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
Getting Trigger Results Back Through CFPROCS
Hi Guys! Has anybody been able to figure out how to get trigger results back through cfprocs? If I do something like this: { CALL sp_MyStoredProc(#Int(MyInput)#) } The results of whatever triggers run can be seen in the dump - like Audit_ID will be there if their is some audit trail being run on the table. If I do something like this: How do I see the results of whatever triggers run? What if I know that Audit_ID is the name of the field/column? Note that Audit_ID is never mentioned in sp_MyStoredProc - it's the output of a separate trigger. Thanx Dave ~~ 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
How do you cast a query into a structure?
Hi Guys! How do I do this: StructFindKey(MyQuery, MyKey, 'ALL') Thanx ~~ 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
How do I pipe the results of running CFML.EXE to a file?
Hi Guys! How do I pipe the results of running C:\CFUSION\BIN\CFML.EXE C:\Inetpub\wwwroot\hhss_root\_PM\dbabbitt-test\harness_tag_disqualify_user_f ield.cfm to test_results.htm? Thanx Dave ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to prevent Serialization failures?
Hi Guys! Does anybody know how to prevent deadlocks? I have a lock around every query to the table I use for clocking in and out of, whether inserts, updates, or deletes. Occasionally, though, I get these: ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #10) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Any help would be greatly appreciated. Dave ~~ 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: How to find out the page to send 'em back to
I could never use this technique. Why is my CGI.Authorization always an empty string? Anybody know? I use , though, to great effect. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 1:34 PM To: CF-Talk Subject: Re: How to find out the page to send 'em back to > If you want I can send a code example tonight. Code is below (does this list accept attachments?). This code still is based on session variables, but that should be easy to solve. If the user needs to log in an HTTP statuscode 401 is send. This results in a browser popup. When the user submits username&password these are send as the HTTP header "authorization" with the form ToBase64(username:password). I would recommend reading the first 2 chapters of RFC 2617 for background info (5 pages). Have fun. Jochem [snip] ~~ 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: Quotes questions
-Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 3:03 PM To: CF-Talk Subject: Quotes questions I'm using CFFILE and im trying to insert a list similar to the following in the output part of the tag: "#form.username#", "#form.firstname#", "#form.lastname#", "#form.email#", "#password#" making my entire cffile cammand look like: " addnewline="yes"> my problem is that I do not know/rememebr how to make those quotesa that ahve to be around each entry appear in the file but not close the output. thanks for oyur 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: Scheduled Tasks in CF Admin
Tell us what application.cfm pages also run along with this task template and what they have in them. -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 11:25 AM To: CF-Talk Subject: Scheduled Tasks in CF Admin Hello all I have created 3 tasks that I want to run on the 1st of each month. When I run the pages manually they run fine. When in CF Admin and I run the task, no errors pop up and I get the message the task ran ok, but nothing happens. I set the first run of the task for testing to be this morning, but nothing happened. All the tasks do is check for accounts that have not been used in over 60/90 days and sends an email to me and other site managers. I have set accounts so that they are over 60/90 days. What am I missing? Using CF 5, IIS4, NT 4.0 SP6, Access 2000 Thanks for any suggestions ~~ 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: variable in custom tag name?
-Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 4:59 PM To: CF-Talk Subject: variable in custom tag name? Is it possible to have a variable in a custom tag *name* when calling it? I have an app that has 50 different tag modules whose only difference is 2 letters in their name. I'd like to be able to do a single generic call to them if possible. The example below blows up, and other attempts to dummy something up with Evaluate() and DE() went nowhere for me. #tagresult# --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.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: How Can i pre select an update form using cf_threeselectsrelated
Make a tag with similar attributes as the three select tags which will insert javascript like this: /* Make sure the #Attributes.Display1# is preselected */ var preselected = false; var selectionObject = document.#Attributes.FormName#.#Attributes.Name1#; var tot = selectionObject.length; for(i = 0; i#Chr(60)#tot; i++) { var optionObject = selectionObject.options[i]; var optionValue = optionObject.value; if(optionValue==#Attributes.Default1#) { optionObject.selected = true; #Attributes.FormName#ChangeMenu(i); preselected = true; /* break so we don't get stuck at the bottom */ break; } else {optionObject.selected = false;} } if(preselected == false) {selectionObject.options[0].selected = true;} /* Make sure the #Attributes.Display2# is preselected */ preselected = false; selectionObject = document.#Attributes.FormName#.#Attributes.Name2#; tot = selectionObject.length; for(i = 0; i#Chr(60)#tot; i++) { optionObject = selectionObject.options[i]; optionValue = optionObject.value; if(optionValue==#Attributes.Default2#) { optionObject.selected = true; #Attributes.FormName#ChangeMenu2(i); preselected = true; /* break so we don't get stuck at the bottom */ break; } else {optionObject.selected = false;} } if(preselected == false) {selectionObject.options[0].selected = true;} /* Make sure the #Attributes.Display3# is preselected */ preselected = false; selectionObject = document.#Attributes.FormName#.#Attributes.Name3#; tot = selectionObject.length; for(i = 0; i#Chr(60)#tot; i++) { optionObject = selectionObject.options[i]; optionValue = optionObject.value; if(optionValue==#Attributes.Default3#) { optionObject.selected = true; preselected = true; /* break so we don't get stuck at the bottom */ break; } else {optionObject.selected = false;} } if(preselected == false) {selectionObject.options[0].selected = true;} -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 9:04 AM To: CF-Talk Subject: How Can i pre select an update form using cf_threeselectsrelated How Can i pre select an update form using cf_threeselectsrelated by using something like SELECTED SELECTED SELECTED thank you -paul also is there a way to use both 2selects related & 2selects related on the ~~ 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: Auto Refresh
Set up the page in the first place to have an onload event that runs the changeMenu function, something like this: function initPage() { /* Make sure the the second select box does not revert to the options available had the first option in the first select box been selected */ var selectionObject = document.#Variables.FormName#.#Variables.TwoSelectsRelatedNAME1Field#; if(selectionObject!=null) { var selectionIndex = selectionObject.selectedIndex; if(selectionIndex<>-1) { #Variables.FormName##Variables.TwoSelectsRelatedNAME1Field#ChangeMenu(select ionIndex); selectionObject = document.#Variables.FormName#.#Variables.TwoSelectsRelatedNAME2Field#; if(selectionObject!=null) { selectionObject.options[0].selected = true; } } } } -Original Message- From: cf kaizen [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 2:04 PM To: CF-Talk Subject: Auto Refresh Hi There, Upon hitting the back button to go back to a page with the twoSelectsRelated tag on it, the first select box maintains its selected option, whereas the second select box reverts to the options available had the first option in the first select box been selected, causing an error when the user resubmits the form. I've been trying to force a refresh of the page, but my refresh code causes havoc on the two select boxes. Any ideas? Thanks, Andy ~~ 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: CF Two Selected TAG
Assuming that your version of the CF two selected tag is using the ChangeMenu function: Variables.FormName = "whateverMyFormNameIs"; Variables.My_Default_Left_ID = 1; Variables.My_Default_Right_IDs = '2,3,4,5'; function initPage() { /* Make sure the leftID is preselected */ var preselected = false; var selectionObject = document.#Variables.FormName#.Left_ID; var tot = selectionObject.length; for(var i = 0; i#Chr(60)#tot; i++) { var optionObject = selectionObject.options[i]; var optionValue = optionObject.value; if(optionValue==#My_Default_Left_ID#) { optionObject.selected = true; #Variables.FormName#Left_IDChangeMenu(i); preselected = true; /* break so we don't get stuck at the bottom */ break; } else {optionObject.selected = false;} } if(preselected == false) {selectionObject.options[0].selected = true;} /* Make sure the rightIDs are preselected */ var rightIDArray = new Array(#Variables.My_Default_Right_IDs#); preselected = false; selectionObject = document.#Variables.FormName#.Right_ID; tot = selectionObject.length; for(i = 0; i#Chr(60)#tot; i++) { optionObject = selectionObject.options[i]; optionValue = optionObject.value; for(var j = 0; j#Chr(60)#rightIDArray.length; j++) { if(optionValue==rightIDArray[j]) { optionObject.selected = true; preselected = true; } } } if(preselected == false) {selectionObject.options[0].selected = true;} } function selectAllRights() { var tot = document.#Variables.FormName#.Right_ID.length; for(var i = 0; i#Chr(60)#tot; i++) { if(document.#Variables.FormName#.Right_ID.options[i].value!=0) { document.#Variables.FormName#.Right_ID.options[i].selected = true; } else { document.#Variables.FormName#.Right_ID.options[i].selected = false; } } } -Original Message- From: David Boyd [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 6:19 AM To: CF-Talk Subject: CF Two Selected TAG Hi, Does anyone know how to preselect values using the CF two selected tag? Cheers. [snip] ~~ 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 (CF-based church website application)
Whether GPL or something more BSD-like is still in conference. My preference is for GPL, but I'm not hosting it, nor is my code the base code. -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 5:47 PM To: CF-Talk Subject: RE: OT (CF-based church website application) Would it be initially? If his church tool is GPL, that requires all applications to use it to adhere to GPL as well (I'm assuming GPL, could be something different) --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 4:24 PM To: CF-Talk Subject: RE: OT (CF-based church website application) it will be. Eric Dawson From: Dave Babbitt <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: OT (CF-based church website application) Date: Tue, 02 Oct 2001 14:14:40 -0400 It would be free and opensource. It would force your community site network app to be free and opensource also. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 1:24 PM To: CF-Talk Subject: RE: OT (CF-based church website application) free and opensource - or fee and opensource? I want to plug a free church publishing tool into a community site network. Eric Dawson From: Dave Babbitt <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: OT Date: Tue, 02 Oct 2001 12:14:50 -0400 I have www.wscccpca.org - a church website in CF. Also, Tony Jenkins of jittle.com and I are preparing to launch a open source initiative for eChurch, a CF-based church website application. In reference to your sig link, I force every sermon, testimony, and article submitter on my site to provide a scripture reference or two to categorize it with. -Original Message- From: Marc Edwards [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:52 AM To: CF-Talk Subject: Re: OT not that I can think ofI know musicforce.com used to be on CF, but they switched to something else a year or so ago. - Original Message - From: "Tony Hicks" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 9:56 PM Subject: OT > Any y'all got Christian sites written in CF? > > Thanks, > Tony Hicks > -- > Search the Holy Bible: http://www.bibleclicks.com > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (CF-based church website application)
It would be free and opensource. It would force your community site network app to be free and opensource also. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 1:24 PM To: CF-Talk Subject: RE: OT (CF-based church website application) free and opensource - or fee and opensource? I want to plug a free church publishing tool into a community site network. Eric Dawson From: Dave Babbitt <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: OT Date: Tue, 02 Oct 2001 12:14:50 -0400 I have www.wscccpca.org - a church website in CF. Also, Tony Jenkins of jittle.com and I are preparing to launch a open source initiative for eChurch, a CF-based church website application. In reference to your sig link, I force every sermon, testimony, and article submitter on my site to provide a scripture reference or two to categorize it with. -Original Message- From: Marc Edwards [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:52 AM To: CF-Talk Subject: Re: OT not that I can think ofI know musicforce.com used to be on CF, but they switched to something else a year or so ago. - Original Message - From: "Tony Hicks" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 9:56 PM Subject: OT > Any y'all got Christian sites written in CF? > > Thanks, > Tony Hicks > -- > Search the Holy Bible: http://www.bibleclicks.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: MySQL error
You need to scope every field in every table. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 12:44 PM To: CF-Talk Subject: MySQL error Im getting this error when using a JOIN in my SQL statement Any Ideas? ODBC Error Code = S1000 (General error) [TCX][MyODBC]Not unique table/alias: 'Step2UserList' ~~ 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 Issue
How about or #x# #Evaluate('form.' & x)# There are many variations. -Original Message- From: Mike Tangorre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 12:37 PM To: CF-Talk Subject: Output Issue I have the following code: #x# #form.#x## The value for the form field throws an error the way I am doing it. I am not familiar with the Evaluate function and the concatonation of strings, is this what I should do? Thanks for any help or explanation. 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
RE: OT
I have www.wscccpca.org - a church website in CF. Also, Tony Jenkins of jittle.com and I are preparing to launch a open source initiative for eChurch, a CF-based church website application. In reference to your sig link, I force every sermon, testimony, and article submitter on my site to provide a scripture reference or two to categorize it with. -Original Message- From: Marc Edwards [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:52 AM To: CF-Talk Subject: Re: OT not that I can think ofI know musicforce.com used to be on CF, but they switched to something else a year or so ago. - Original Message - From: "Tony Hicks" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 9:56 PM Subject: OT > Any y'all got Christian sites written in CF? > > Thanks, > Tony Hicks > -- > Search the Holy Bible: http://www.bibleclicks.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