Hide URL
How can I hide the information passed in a URL? I don't want the user to see the variables in the address line. TIA Cami __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hide URL
it is a redirect from an ASP application to CF app during a login process -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 10:24 AM To: CF-Talk Subject: Re: Hide URL send them as a form variable, session var, postit note, cookie On Mon, 12 Aug 2002, Cami Lawson wrote: How can I hide the information passed in a URL? I don't want the user to see the variables in the address line. TIA Cami __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hide URL
Client doesn't allow frames for their application. -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 10:25 AM To: CF-Talk Subject: RE: Hide URL Wouldn't a frameset hide the address bar of child frames? -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 6:27 AM To: CF-Talk Subject: Hide URL How can I hide the information passed in a URL? I don't want the user to see the variables in the address line. TIA Cami __ 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
Redirect from ASP to CF
I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ 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: Redirect from ASP to CF
We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirects sometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Redirect from ASP to CF
We use a redirect as part of the website to send it to a virtual directory and we don't have to pass anything at that point. So I guess the answer is I don't have any idea. We do use response.redirect with information but cookies are set by that time and the switching software knows to keep it on the box it came from. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:36 PM To: CF-Talk Subject: Re: RE: Redirect from ASP to CF So do ASP to ASP page redirects work properly? - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 3:27 pm Subject: RE: Redirect from ASP to CF We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirectssometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ 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
Now error
I have the code in a development environment and a test environment. The development works fine but the test produces this error. It is WinNT 4.0 SP6 with CF 4.5.1 SP2 on both machines. Any ideas? TIA, Cami Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #DateDiff("d", myclosed[Counter][8], now())# LT 15 Error near line 190, column 52. Parameter 2 of function DateDiff which is now "" must be a date/time value The error occurred while processing an element with a general identifier of (CFIF), occupying document position (190:2) to (190:58). ~~ 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: Now error
nevermind, it was a difference in db -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 11:03 AM To: CF-Talk Subject: Re: Now error It is not now() that is the problem. It is the value of myclosed[Counter][8] that is returning "". DC - Original Message ----- From: "Cami Lawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 13, 2001 11:54 Subject: Now error I have the code in a development environment and a test environment. The development works fine but the test produces this error. It is WinNT 4.0 SP6 with CF 4.5.1 SP2 on both machines. Any ideas? TIA, Cami Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #DateDiff("d", myclosed[Counter][8], now())# LT 15 Error near line 190, column 52. -- -- Parameter 2 of function DateDiff which is now "" must be a date/time value The error occurred while processing an element with a general identifier of (CFIF), occupying document position (190:2) to (190:58). ~~ 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
CFApplication Error
Can anyone tell me what causes this error? I seem to be getting it about once a week. TIA, Cami Error Occurred While Processing Request Error Diagnostic Information Error attempting to get the client (Client ID = '118155'). A problem was encountered trying to access the system registry. Error number 1450 occurred. The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (1:1) to (2:49). ~~ 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: SQL Question (Access)
try this cfquery name="getquestions" datasource="#dsn#" SELECT HNTQuestion.QuestionID, HNTQuestion.Category, HNTQuestion.QuestionShort, HNTCategories.HNTCategoryID, HNTCategories.HNTCategoryName FROM HNTQuestion, HNTCategories, tblAnswers WHERE HNTQuestion.Category = HNTCategories.HNTCategoryID AND HNTQuestion.QuestionID = tblAnswers.ANSQuestionID ORDER BY HNTQuestion.Category, HNTQuestion.QuestionShort /cfquery An answer is linked to its associated question with a field ANSQuestionID in the table tblAnswers which has the same value as the field HNTQuestion.QuestionID. -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 4:33 PM To: CF-Talk Subject: OT: SQL Question (Access) I'm sorry if this is off-topic, but I'm hoping for some help from people who know more about SQL than I do ... I have a hints'n'tips section on one of my sites, and it has 3 tables - tblCategories, tblQuestions and tblAnswers. I want to have an index page that lists the questions in their categories, so you click on the question and a window opens with all the answers to that question. Here's the bit I am having trouble with .. A few questions don't have any answers yet - for example some haven't been loaded up yet. How do I get SQL to retrieve only the questions that have answers in the Answers table, leaving out any questions that have no answers? Here's the SQL I'm using now, that returns all the questions (if it's relevant here, the database is Access2000): cfquery name="getquestions" datasource="#dsn#" SELECT HNTQuestion.QuestionID, HNTQuestion.Category, HNTQuestion.QuestionShort, HNTCategories.HNTCategoryID, HNTCategories.HNTCategoryName FROM HNTQuestion, HNTCategories WHERE HNTQuestion.Category = HNTCategories.HNTCategoryID ORDER BY HNTQuestion.Category, HNTQuestion.QuestionShort /cfquery An answer is linked to its associated question with a field ANSQuestionID in the table tblAnswers which has the same value as the field HNTQuestion.QuestionID. Can anyone help me please? Cheers, Mike Kear Windsor, NSW, Australia AFP Webworks. ~~ 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
Secure to unsecure
I have a page that is secure and within the page is a help link that pops up a secondary window with the appropriate help information. All is well except that when the secondary window opens I also get a message about leaving a secure site. How can I stop this message, it happens in IE and Netscape? TIA, Cami ~~ 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: Selecting a date range, access DB
Does the record you are after meet the exact timestamp? You might look at using just the date instead of the whole timestamp. - Original Message - From: "Thomas Chiverton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 9:44 AM Subject: Selecting a date range, access DB My aim is to pick all records out of an access DB, by date range. I'm using the following CF: cfquery name="bulletins" datasource="News" SELECT * FROM Articles where approved and startdate #Now()# and expirydate #Now()# /cfquery Turning on debug on the server shows this ends up as SQL = SELECT * FROM Articles where approved and startdate {ts '2001-02-26 15:37:22'} and expirydate {ts '2001-02-26 15:37:22'} Unsuprisingly, this returns no results (there is at least one record in the intended range). Is my SQL off, or do I need to use a particular type of date in access ? Regards, Thomas Chiverton, Intranet Webmaster and Desktop Analyst Office: 01565 757 909 As a GUI, reality in useless... ~~ 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
Custom Tags
I have a custom tag to run a query that occurs frequently throughout my application. My problem is that it cannot figure out what the PrimaryDataSource is. How can I code it to know what this is? TIA cami ~~ 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: Custom Tags
Nevermind, i had a copy of the tag in my application directory that was causing the problem. Thanks anyway - Original Message - From: "Cami Lawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 1:54 PM Subject: Custom Tags I have a custom tag to run a query that occurs frequently throughout my application. My problem is that it cannot figure out what the PrimaryDataSource is. How can I code it to know what this is? TIA cami ~~ 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: Strengths of each
I am currently running CF 4.5.2 and pass information from CF to ASP which builds a PDF for me. HTH - Original Message - From: "Terry Troxel" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 1:09 PM Subject: Strengths of each I am posing a question that has been rattling around in my mind for awhile. My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and maybe that is why I m in the dark. I would like to know if CF and ASP can co-exist and possibly trade data like CF does with javascript, WAP, etc. The second part of my question is if this is possible has anyone compiled a list of what types of procedures, functionality is best handled by which. If these questions are true then I have to get onto an IIS host, and start learning ASP to broaden my skills. I assume this is the path alot of you have taken by the frequency of ASP and CF in your signatures. Terry Troxel ~~ 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: netscape and session variables
what kind of hardware do you have associated with your application? We had some problems at first with this same issue but it was because of multiple boxes. - Original Message - From: "Eric V. Hodge" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 9:50 AM Subject: netscape and session variables when testing my application session variables work under IE, but not Netscape. I have tried different versions of Netscape and none of them work. In all my browsers cookies are enabled. What could be the problem? -eric ~~ 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: Querying a db with all caps
try UPPER on your variable in your query - Original Message - From: "DSJ / PC1, Inc." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 19, 2001 1:15 PM Subject: Querying a db with all caps Hello All, I am querying a database that uses only capital letters in all of the values inside each field. When I perform a search using smaller case letters, nothing shows up, however, when I type in ALL CAPS in my search, it works as expected. Now, my question is, is there a way that I can make my query work even if someone uses all smaller case letters in the search field? Any help would be greatly appreciated here. Thanks, DSJ ~~ 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: International Date/Time functions
Try this site http://tech.irt.org/articles/js076/index.htm - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 11:10 AM Subject: International Date/Time functions -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Does anyone know of a good source of info or a tutorial on the LS functions in CF? I am having a lot of trouble setting my date and time functions up to work in the local time zone of the customer. The server is in UTC - 5 and the client in UTC + 10 - -- Jon Tillman http://www.eruditum.org Why is it that love letters, business contracts and money due you always arrive three weeks late, whereas junk mail arrives the day it was sent? -BEGIN PGP SIGNATURE- Version: PGP 6.5.1i iQA/AwUBOo1fC9ga7tZtnIOtEQKgOACdF8053Ql14WNd9/JQIK95hAxe4kYAoKuQ rGt3ivrQ2vKbvBBU/LtlPc3g =qPTp -END PGP SIGNATURE- ~~ 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
mail spool
Can anyone tell me what the following message is? It came from my CF mail log file. At the time it happened approximately 326 emails were being generated. "Error","TID=507","02/12/01","14:04:06","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\711.cfmail. SMTP server replied "Cannot attach 'C:\CFUSION\MAIL\spool\711.cfmail' to the mail message. The file does not exist." Moved file to C:\CFUSION\MAIL\undelivr\712.cfmail." TIA, Cami ~~ 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
Continuous Clock
I have a display clock that shows the time the user accessed the page but now they want a clock that shows the current time continuously. I have figured out countdown timers but is there an easy way to display the current time continuously? TIA cami ~~ 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: Continuous Clock
thanks to all, this is what finally worked, I needed to make sure it was EST SCRIPTfunction tick() { var hours, minutes, seconds, ap; var intHours, intMinutes, intSeconds; var today; today = new Date(); timezoneoffset = today.getTimezoneOffset(); today.setTime(today.getTime() + timezoneoffset*60*1000); today.setTime(today.getTime() + -5*60*60*1000); intHours = today.getHours(); intMinutes = today.getMinutes(); intSeconds = today.getSeconds(); if (intHours == 0) { hours = "12:"; ap = "Midnight"; } else if (intHours 12) { hours = intHours+":"; ap = "A.M."; } else if (intHours == 12) { hours = "12:"; ap = "Noon"; } else { intHours = intHours - 12 hours = intHours + ":"; ap = "P.M."; } if (intMinutes 10) { minutes = "0"+intMinutes; } else { minutes = intMinutes; } if (intSeconds 10) { seconds = ":0"+intSeconds+" "; } else { seconds = ":"+intSeconds+" "; } timeString = hours+minutes CFIF IsDefined("Attributes.ShowSeconds") AND Attributes.ShowSeconds eq "Yes"+seconds/CFIF CFIF IsDefined("Attributes.ShowAMPM") AND Attributes.ShowAMPM eq "Yes"+ap/CFIF; Clock.innerHTML = timeString; CFOUTPUT window.setTimeout("tick();", #Attributes.Ticks#); } /CFOUTPUT window.onload = tick; /SCRIPT div id="Clock" title="Clock"/div - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 12:12 PM Subject: Re: Continuous Clock The only way to actually show the seconds ticking is with javascript and a form field, or a java applet. You could use cascading style sheets to change the look of the form field to look more like a clock then... Check out the irt.org page that someone reccommended earlier. They have a very nice tutorial on time, and clocks with javascript. jon - Original Message - From: "Cami Lawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 11:49 AM Subject: Continuous Clock I have a display clock that shows the time the user accessed the page but now they want a clock that shows the current time continuously. I have figured out countdown timers but is there an easy way to display the current time continuously? TIA cami ~~ 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: Continuous Clock
thanks, it is an inner office page and they only use IE - Original Message - From: "Tim Fields" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 4:29 PM Subject: RE: Continuous Clock Just be aware that it's not Netscape compatible due to the innerHTML -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:02 AM To: CF-Talk Subject: RE: Continuous Clock or JavaScript as below script !-- function tick() { var hours, minutes, seconds, ap; var intHours, intMinutes, intSeconds; var today; today = new Date(); intHours = today.getHours(); intMinutes = today.getMinutes(); intSeconds = today.getSeconds(); if (intHours == 0) { hours = "12:"; ap = "Midnight"; } else if (intHours 12) hours = intHours+":"; ap = "A.M."; } else if (intHours == 12) { hours = "12:"; ap = "Noon"; } else { intHours = intHours - 12 hours = intHours + ":"; ap = "P.M."; } if (intMinutes 10) { minutes = "0"+intMinutes+":"; } else { minutes = intMinutes+":"; } if (intSeconds 10) { seconds = "0"+intSeconds+" "; } else { seconds = intSeconds+" "; } timeString = hours+minutes+seconds+ap; Clock.innerHTML = timeString; window.setTimeout("tick();", 100); } window.onload = tick; -- /script br div id=ReplaceMe style="font-family: verdana; font-size: 20;"What you type in below will replace this HTML/div Justin -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 5:09 PM To: CF-Talk Subject: RE: Continuous Clock Java is the only way - and even that is rusty at the best of times - the worst I've seen involved http refresh every second James -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: 25 January 2001 16:50 To: CF-Talk Subject: Continuous Clock I have a display clock that shows the time the user accessed the page but now they want a clock that shows the current time continuously. I have figured out countdown timers but is there an easy way to display the current time continuously? TIA cami ~~ 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: Anyone else had this problem before?
try this cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY cast(UsersTotalPrice as decimal) /cfquery - Original Message - From: "t nelson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 3:45 PM Subject: Anyone else had this problem before? Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ 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: SQL Question
Can you check what each value is before the insert to check and see if one of the values is missing. Your column to values number checks ok. - Original Message - From: "Gieseman, Athelene" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 3:33 PM Subject: OT: SQL Question I am getting the following SQL error: Microsoft][ODBC SQL Server Driver][SQL Server]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement. This doesn't happen all the time. I can't seem to find what's unique about the records that do insert from those that don't. The insert statement is as follows: cfquery datasource="IS_Budget" name="SaveInvoiceQry" INSERT X_Invoices (Vendor, Inv_GL, Inv_City, Inv_Dept, Inv_Date, Inv_No, Inv_Desc, ApprovedDate, Notes, Inv_Amount) values ('#Vendor#', '#Inv_GL#', '#Inv_City#', '#Inv_Dept#', '#Inv_Date#', '#Inv_No#', '#Inv_Desc#', '#ApprovedDate#', '#Notes#', #Inv_Amount#) /cfquery I'm sure I'm not seeing something obvious. But it looks to me like there are 10 items for each of the values and table columns. Can anyone see what I'm not? Athelene Gieseman ~~ 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
Javascript on selectboxes
I have this script that is called when a form is submitted. It is supposed to display a popup window if two of the three selectboxes are the same. It works good except that if the first box is selected and the other two are null or empty then the popup appears. Same thing happens with the second box selected and the first and third null or emtpy, and the same with the third box. Otherwise it works great with two boxes selected that might be the same. Any ideas on where I have gone wrong with this one? TIA, cami function popup( pageToLoad, winName, width, height) { if ((document.updatefav.myselectbox.value == document.updatefav.myselectbox1.value) || (document.updatefav.myselectbox.value == document.updatefav.myselectbox2.value) || (document.updatefav.myselectbox1.value == document.updatefav.myselectbox2.value)) { if ((document.updatefav.myselectbox.value == null) (document.updatefav.myselectbox1.value == null)) {return true;} else if ((document.updatefav.myselectbox.value == null) (document.updatefav.myselectbox2.value == null)) {return true;} else if ((document.updatefav.myselectbox1.value == "") (document.updatefav.myselectbox2.value == "")) {return true;} else { xposition=200; yposition=300; width=250; height=90 args = "width=" + width + "," + "height=" + height + "," + "location=0," + "menubar=0," + "resizable=1," + "scrollbars=0," + "status=0," + "titlebar=0," + "toolbar=0," + "hotkeys=0," + "screenx=" + xposition + "," + "screeny=" + yposition + "," + "left=" + xposition + "," + "top=" + yposition; window.open( "processed.htm","popup_win",args ); return false;} }} ~~ 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: Javascript on selectboxes
Thanks, by stepping through the code a little slower I was able to put most of this to good use - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 15, 2001 10:29 AM Subject: RE: Javascript on selectboxes When two boxes are unselected, their values are the same. Add a statement to make sure one of the values is also checked. For clarity's sake, I'd also rewrite the code this way. In 6 months, you might have to look at this again and the more you can break it down, the better it will be then. This is not the most efficient code, but sometimes with complicated logic its better to write clearly and slow down those animated icons a little... var box1=document.updatefav.myselectbox1.value; var box2=document.updatefav.myselectbox2.value; var box3=document.updatefav.myselectbox3.value; // Next, for clarity, I'd go ahead and compute boolean values on the matches: var box12 = ( (box1==box2) (box1 != unselectedValue) ); // box 12 match and are selected var box13 = ( (box1==box3) (box1 != unselectedValue) ); // box 13 match and are selected var box23 = ( (box2==box3) (box2 != unselectedValue) ); // box 23 match and are selected // Now check the values. Logic is redundent, but left for readability if (box12 box13 box23) { //all 3 match } if (box12 !box13 !box23) {//1 and 2 match, 3 doesn't match either} if (!box12 !box13 box23) {//2 and 3 match, 1 doesn't match either) if (!box12 box13 !box23) {//1 and 3 match, 2 doesn't match either) if (!box12 !box13 !box23) {//none match) // There are 3 other combinations of box12, box23 and box13, but they are logically incosistent // example, box12=1, box23=1, box13=0 == box1=box2=box3!=box1 Brian -Original Message----- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 10:30 AM To: CF-Talk Subject: Javascript on selectboxes I have this script that is called when a form is submitted. It is supposed to display a popup window if two of the three selectboxes are the same. It works good except that if the first box is selected and the other two are null or empty then the popup appears. Same thing happens with the second box selected and the first and third null or emtpy, and the same with the third box. Otherwise it works great with two boxes selected that might be the same. Any ideas on where I have gone wrong with this one? TIA, cami function popup( pageToLoad, winName, width, height) { if ((document.updatefav.myselectbox.value == document.updatefav.myselectbox1.value) || (document.updatefav.myselectbox.value == document.updatefav.myselectbox2.value) || (document.updatefav.myselectbox1.value == document.updatefav.myselectbox2.value)) { if ((document.updatefav.myselectbox.value == null) (document.updatefav.myselectbox1.value == null)) {return true;} else if ((document.updatefav.myselectbox.value == null) (document.updatefav.myselectbox2.value == null)) {return true;} else if ((document.updatefav.myselectbox1.value == "") (document.updatefav.myselectbox2.value == "")) {return true;} else { xposition=200; yposition=300; width=250; height=90 args = "width=" + width + "," + "height=" + height + "," + "location=0," + "menubar=0," + "resizable=1," + "scrollbars=0," + "status=0," + "titlebar=0," + "toolbar=0," + "hotkeys=0," + "screenx=" + xposition + "," + "screeny=" + yposition + "," + "left=" + xposition + "," + "top=" + yposition; window.open( "processed.htm","popup_win",args ); return false;} }} ~~ 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: CFSELECT and Java
I have three cfselects that I need to compare their values before leaving the form for my processor page, I already have a popup message coded to come up if any of the three are the same. I have tried IF ((document.favform.myselectbox1.value != document.favform.myselectbox2.value) (document.favform.myselectbox1.value != document.favform.myselectbox3.value) (document.favform.myselectbox2.value != document.favform.myselectbox3.value)) { popup code; return false; } I get errors when I put these statements in my javascript for the popup. It acts like it doesn't know what the cfselect values are. - Original Message - From: "Jann VanOver" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 3:38 PM Subject: RE: CFSELECT and Java FYI: Java is NOT the same as Javascript That being said, what kind of compare would you like to do? Once you learn Javascript, it is an easy thing to check any and all form values before a form is submitted, but exactly how to do it depends on what you want to compare. -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 9:41 AM To: CF-Talk Subject: CFSELECT and Java Is there a way to check the value of a CFSELECT with a Java script? I have 3 CFSELECTs on one page and I need to compare them against each other before they go to the CFFORM action. TIA ~~ 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: CFSELECT and Java
thanks, this worked great - Original Message - From: "DeVoil, Nick" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 7:23 AM Subject: RE: CFSELECT and Java JavaScript is case-sensitive so you nee "if" not "IF." Also BTW the code says do the popoup if all three are different. I think you want sth like if ((document.favform.myselectbox1.value == document.favform.myselectbox2.value) || (document.favform.myselectbox1.value == document.favform.myselectbox3.value) || (document.favform.myselectbox2.value == document.favform.myselectbox3.value)) { popup code; return false; } Nick -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 1:13 PM To: CF-Talk Subject: Re: CFSELECT and Java I have three cfselects that I need to compare their values before leaving the form for my processor page, I already have a popup message coded to come up if any of the three are the same. I have tried IF ((document.favform.myselectbox1.value != document.favform.myselectbox2.value) (document.favform.myselectbox1.value != document.favform.myselectbox3.value) (document.favform.myselectbox2.value != document.favform.myselectbox3.value)) { popup code; return false; } I get errors when I put these statements in my javascript for the popup. It acts like it doesn't know what the cfselect values are. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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
CFSELECT and Java
Is there a way to check the value of a CFSELECT with a Java script? I have 3 CFSELECTs on one page and I need to compare them against each other before they go to the CFFORM action. TIA ~~ 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: Help with a SQL statement
This will give you the items that only exist in log_userstatus and teaserusers but you will have to build on it to only get the newest date for each one. You could loop through an array with another sql to bring out the newest date. SELECT teaserusers.userid, teaserusers.nickname, teaserusers.firstname, teaserusers.lastnames, teaserusers.email, teaserusers.registereddate, log_userstatus.userid, log_userstatus.logdate from teaserusers, log_userstatus where exists (Select log_userstatus.userid from log_userstatus where log_userstatus.userid = teaserusers.userid) and teaserusers.userid = log_userstatus.userid cami - Original Message - From: "Andres" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 8:44 AM Subject: RE: Help with a SQL statement Heather, I will try this, and continue building upon it. thanks for your help! andres -Original Message- From: Heather Haindel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 7:35 PM To: [EMAIL PROTECTED] Subject: RE: Help with a SQL statement I am trying to figure this out... I've tried a whole bunch of different things, but I just can't get everything to work at once. Right now, I've got two queries... /*this gives us the most current logs*/ select userid, max(logdate) fromlog_userstatus group byuserid /*this give us the users*/ select userid, nickname fromteaserusers Here's the closest I've got so far. It returns the userid and latest log date for each user... I don't know how to get other info for each record... begin declare @userid varchar(25) declare cursorname SCROLL cursor for selectt.userid from teaserusers t open cursorname fetch FIRST from cursorname into @userid while (@@FETCH_STATUS -1) begin select userid, max(logdate) fromlog_userstatus where userid = @userid group byuserid fetch next from cursorname into @userid end close cursorname deallocate cursorname end --- Andres [EMAIL PROTECTED] wrote: SELECT teaserusers.userid, teaserusers.nickname, teaserusers.firstname, teaserusers.lastnames, teaserusers.email, teaserusers.registereddate, log_userstatus.* FROM teaserusers LEFT JOIN log_userstatus ON teaserusers.userid = log_userstatus.userid This statement does two incorrect things: 1. doubles the rows of users according to how-many times they have entries in the "log_userstatus" table 2. provides a NULL value to the userid of users who ARE NOT listed in the "log_userstatus" table. Am i way off? thanx! andres -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 4:54 PM To: CF-Talk Subject: Re: Help with a SQL statement Can we see your current SQL statement? --Greg - Original Message - From: "Andres" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 02, 2001 4:42 PM Subject: Help with a SQL statement I need some help with a sql statement: I have two tables: 1 --- * teaserusers log_userstatus --- -- userid (varchar) logid (varchar) nickname (text) userid (varchar) firstname (text) fieldchanged (varchar) email (text) logdate (datetime) etc... etc... The "teaserusers" table has the data about all users. The "log_userstatus" table keeps track of specific events and tracks their occurrence. These tables, although not explicitly related in the RDBMS, have a "one-to-many" relationship based on the "userid." I would like to write a statement that gives me a list of all users in the "teaserusers" table and the last "logdate" entered into the table for each user listed. Here's the catch, and i think this is what is preventing my code from working: Not all users have entries in the "log_userstatus" table. This means that a simple inner join will not work. I've also tried the left outer and full outer joins, not providing the results i need. Is this possible? if so, can you all please help me write the sql code for it? Thanks for all your help! andres ~~ 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
Email links lost
I am sending out emails for different things and all have web links in them. I was just wondering if anyone has had problems with emails sent from CF not properly identifying web address links when received by the recipient. Is there something to handle the different types of email readers or is it just take a shot at the most used and pray for the best with the rest. I'm using type=HTML and some of the emails show all the html tags, some have the text but the url is not a link, while others are just fine. TIA, cami ~~ 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: Email links lost
All the tag information appears to be correct. Myself and some others are using MS Outlook Express 5 and the links appear ok, others are using the same thing and they see the html code. Still yet others using prodigy and netscape get the words indented and the html tags visible. I have tried leaving the HTML type and removing the href and just putting http://www.something.com and it works on some and won't on others. Right now I'm working on the majority rule but some higher ups want their cake and eat it too. cami - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 2:37 PM Subject: Re: Email links lost At 02:04 PM 1/3/01 -0600, you wrote: I am sending out emails for different things and all have web links in them. I was just wondering if anyone has had problems with emails sent from CF not properly identifying web address links when received by the recipient. Is there something to handle the different types of email readers or is it just take a shot at the most used and pray for the best with the rest. I'm using type=HTML and some of the emails show all the html tags, some have the text but the url is not a link, while others are just fine. I hope this doesn't sound patronizing, but you did put the link in proper HTML link tags, right? Some HTML-enabled email clients (like Eudora) recognize URLs and treat them as links, even if they don't have link tags. If you do have the links between a href .../a tags send us some information about how different email clients handle the issue. ~~ 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: SQL Help
What are the columns that are somewhat linked between these tables? - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 3:32 PM Subject: OT: SQL Help Sorry about posting this to the wrong list, but I'm having trouble getting mail through to the SQL list. I am running a query to see if there is an entry in the database for an event that matches certain date criteria. One of the criteria is that one of the dates that the event is scheduled on does not fall within a certain list of dates that are stored in the "exception_dates" table. All of the query works except for: AND NOT EXISTS (SELECT 1 FROM exception_dates ed WHERE ed.exception_dates = '#year#-#month#-#week_day# 00:00:00')) The way it should work is only return a record if there is no instance of the current year-month-day matching anything in the exception_dates table. Here is the whole query: SELECT 1 FROM dummy WHERE EXISTS (SELECT 1 FROM teacher_schedule ts WHERE ts.contact_id = #Request.TempContactID# AND '#year#-#month#-#week_day#' BETWEEN ts.start_date AND ts.end_date AND (ts.start_time_1 ts.end_time_1 OR ts.start_time_2 ts.end_time_2) AND (SELECT days FROM days_times dt WHERE dt.days_times_id = ts.start_time_1) = '#DayOfWeekAsString(week_day)#' AND NOT EXISTS (SELECT 1 FROM exception_dates ed WHERE ed.exception_dates = '#year#-#month#-#week_day# 00:00:00')) What am I missing? Todd Ashworth ~~ 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: Email links lost
Actually it is just a composed email within the CF file in a CFEMAIL with type=HTML. Like I said, it works great most of the time, but there are those times that it just looks ugly. I have since stripped the HTML tags out and most the email software interprets the http://www.something.com as a link without the tags. For pretty purposes I may leave it like that and those who don't get the link will have to cut and paste until I figure out how to make everyone happy. cami - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 4:23 PM Subject: Re: Email links lost Is the message itself a full HTML document? I just checked some HTML email that works in both Netscape and Eudora and it contains full HTML headers, body tags and all that stuff. The viewable content is all inside a table and it could be that the table is indented, but I can't tell since everything would be indented. At 02:38 PM 1/3/01 -0600, you wrote: All the tag information appears to be correct. Myself and some others are using MS Outlook Express 5 and the links appear ok, others are using the same thing and they see the html code. Still yet others using prodigy and netscape get the words indented and the html tags visible. I have tried leaving the HTML type and removing the href and just putting http://www.something.com and it works on some and won't on others. Right now I'm working on the majority rule but some higher ups want their cake and eat it too. cami - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 2:37 PM Subject: Re: Email links lost At 02:04 PM 1/3/01 -0600, you wrote: I am sending out emails for different things and all have web links in them. I was just wondering if anyone has had problems with emails sent from CF not properly identifying web address links when received by the recipient. Is there something to handle the different types of email readers or is it just take a shot at the most used and pray for the best with the rest. I'm using type=HTML and some of the emails show all the html tags, some have the text but the url is not a link, while others are just fine. I hope this doesn't sound patronizing, but you did put the link in proper HTML link tags, right? Some HTML-enabled email clients (like Eudora) recognize URLs and treat them as links, even if they don't have link tags. If you do have the links between a href .../a tags send us some information about how different email clients handle the issue. ~~ 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: Email links lost
Ok, I see what you are saying, but where do the html/html tags go, inside the CFEMAIL or outside. I have a number of emails that get produced within one file. Thanks, cami - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 4:54 PM Subject: Re: Email links lost At 04:24 PM 1/3/01 -0600, you wrote: Actually it is just a composed email within the CF file in a CFEMAIL with type=HTML. Right, but apparently it needs html/html tags and body/body tags between the CFMail tags. If the content isn't in HTML/HTML tags, the email client won't necessarily recognize it as an HTML document and therefore won't interpret it as such. That could cause your problem. If the non-working Outlook clients have different settings that could cause a problem then too. I've made HTML messages with CFMail and had them work in Netscape. I know it can be done. It seems that your message is being interpreted by the client as plain text, which it will do automatically if it doesn't know better. If the code is indented (as one would expect of HTML or other code) this indentation will show up in a plain text email. Like I said, it works great most of the time, but there are those times that it just looks ugly. I have since stripped the HTML tags out and most the email software interprets the http://www.something.com as a link without the tags. For pretty purposes I may leave it like that and those who don't get the link will have to cut and paste until I figure out how to make everyone happy. cami - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 4:23 PM Subject: Re: Email links lost Is the message itself a full HTML document? I just checked some HTML email that works in both Netscape and Eudora and it contains full HTML headers, body tags and all that stuff. The viewable content is all inside a table and it could be that the table is indented, but I can't tell since everything would be indented. At 02:38 PM 1/3/01 -0600, you wrote: All the tag information appears to be correct. Myself and some others are using MS Outlook Express 5 and the links appear ok, others are using the same thing and they see the html code. Still yet others using prodigy and netscape get the words indented and the html tags visible. I have tried leaving the HTML type and removing the href and just putting http://www.something.com and it works on some and won't on others. Right now I'm working on the majority rule but some higher ups want their cake and eat it too. cami - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 03, 2001 2:37 PM Subject: Re: Email links lost At 02:04 PM 1/3/01 -0600, you wrote: I am sending out emails for different things and all have web links in them. I was just wondering if anyone has had problems with emails sent from CF not properly identifying web address links when received by the recipient. Is there something to handle the different types of email readers or is it just take a shot at the most used and pray for the best with the rest. I'm using type=HTML and some of the emails show all the html tags, some have the text but the url is not a link, while others are just fine. I hope this doesn't sound patronizing, but you did put the link in proper HTML link tags, right? Some HTML-enabled email clients (like Eudora) recognize URLs and treat them as links, even if they don't have link tags. If you do have the links between a href .../a tags send us some information about how different email clients handle the issue. ~~ 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: CFAS Scheduler
check your application log file to see if it has a date/time similar to the run of the scheduler log, the you can get an idea of what is not working - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 2:42 PM Subject: Re: CFAS Scheduler Yes, I've done that. That's how I know it's not working. best, paul At 12:22 PM 12/19/00 -0500, you wrote: Paul, one of the things I do when setting up a scheduled program, until I am sure it is working is have it email me a notice of completion whenever it is executed as the last thing on the template. Then you know if it is running or not. jon - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 18, 2000 8:49 AM Subject: CFAS Scheduler Until now, I've never had problems with CFAS Scheduler. Now I do. The template executes when I do it manually. But not when CFAS Scheduler is supposed to execute it. But the CFAS Scheduler log indicates it was executed. How is this possible? best, paul ~~ 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: CFAS Scheduler
FYI, the system I'm working on has the same things happen to it and if you can't find a code problem then CFAS just quit. Usually I can delete the previous schedule and create a new one to start the next day at 00:01:00 till 23:59:00 for an indefinite number of days and it will start back up just fine. If I try starting it back on the same day it will quit just the same. - Original Message - From: "Lawrence B. Afrin, M.D." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 4:30 PM Subject: Re: CFAS Scheduler Paul -- FYI, I've seen the same thing happen enough times (4.0, 4.1, 4.5, haven't tried any of the 4.5 SP's yet) to know it's a real bug -- you're not imagining it. :-) Don't have the foggiest idea what makes the scheduler "stick". Cycling (stopping, starting) the App Server and the Executive usually seems to fix it, though occasionally I've had to cycle them more than once to finally get the scheduler to start running scheduled jobs again. Most of the time the scheduler works fine. I've seen it run for three months without a hiccup (finally had to cycle the system for other reasons), but sometimes it just sticks, and boy is it irritating to try to get it going again. Sometimes I wonder whether it's having some screwy interaction with my backup package (Veritas Backup Exec Enterprise Edition), but I've never had the time, knowledge, or patience to investigate it. All I've done is to cycle it until it starts working again. Again, I have no idea whether 4.5SP1 or SP2 might fix it. Good luck! -- Larry Afrin Med. Univ. of S.C. [EMAIL PROTECTED] paul smith wrote: Yes, I've done that. That's how I know it's not working. best, paul At 12:22 PM 12/19/00 -0500, you wrote: Paul, one of the things I do when setting up a scheduled program, until I am sure it is working is have it email me a notice of completion whenever it is executed as the last thing on the template. Then you know if it is running or not. jon - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 18, 2000 8:49 AM Subject: CFAS Scheduler Until now, I've never had problems with CFAS Scheduler. Now I do. The template executes when I do it manually. But not when CFAS Scheduler is supposed to execute it. But the CFAS Scheduler log indicates it was executed. How is this possible? best, paul ~~ 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: TextArea for IE vs Netscape
I have tried everything to clean up the code. It works fine in IE and Netscape 6, it has the nice box with the text and a vertical scroll bar. But, in Netscape 4.76 the text is just pasted all over the page with no nice scroll box, it's just ugly. Cami - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:21 AM Subject: Re: TextArea for IE vs Netscape Hmmm I hadnt thought of that one thats most likely. I just ran into this problem again very recently too, so its fresh in my head. I was using a stand alone button with an onclick event, so it never occured to me that I needed the form element wrapped around it. Looked in netscape, boom was right on top of it when it didnt show up. Netscape is strict like that ;) That could very well be his problem. Mike From: "avex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: TextArea for IE vs Netscape Date: Fri, 15 Dec 2000 16:47:36 +1000 this may seem stpid but once we had that problem here. and someone forgot to add a form tag!! adding one fixed the problem.. i am sure this can't be your problem though... ;-) Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ 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: TextArea for IE vs Netscape
this is the abbreviated code without all the text in the text box HTML HEAD TITLEtest page/TITLE /HEAD body BACKGROUND = "img/background.gif" TEXT="#00" LINK=#00 ALINK=#99 VLINK=#33 h3 ALIGN="center"home page/h3 CENTER TEXTAREA NAME="ba" ROWS=6 COLS=60 some text /TEXTAREA FORM ACTION = "ba.cfm" METHOD = "post" input type="radio" name="bag" value="A"checkednbsp;nbsp;b1/b nbsp;nbsp;nbsp;nbsp;nbsp;input type="radio" name="bag" value="D" nbsp;nbsp;b2/b nbsp;nbsp;nbsp;nbsp;nbsp;input type="submit" value="Submit" /form /CENTER /BODY /HTML - Original Message - From: "Courtney Payne" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 9:32 AM Subject: RE: TextArea for IE vs Netscape Code please... :-) Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 10:15 AM To: CF-Talk Subject: Re: TextArea for IE vs Netscape I have tried everything to clean up the code. It works fine in IE and Netscape 6, it has the nice box with the text and a vertical scroll bar. But, in Netscape 4.76 the text is just pasted all over the page with no nice scroll box, it's just ugly. Cami - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:21 AM Subject: Re: TextArea for IE vs Netscape Hmmm I hadnt thought of that one thats most likely. I just ran into this problem again very recently too, so its fresh in my head. I was using a stand alone button with an onclick event, so it never occured to me that I needed the form element wrapped around it. Looked in netscape, boom was right on top of it when it didnt show up. Netscape is strict like that ;) That could very well be his problem. Mike From: "avex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: TextArea for IE vs Netscape Date: Fri, 15 Dec 2000 16:47:36 +1000 this may seem stpid but once we had that problem here. and someone forgot to add a form tag!! adding one fixed the problem.. i am sure this can't be your problem though... ;-) Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ 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: TextArea for IE vs Netscape
Thanks, I moved my form field to the top and it works like a champ! - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:21 AM Subject: Re: TextArea for IE vs Netscape Hmmm I hadnt thought of that one thats most likely. I just ran into this problem again very recently too, so its fresh in my head. I was using a stand alone button with an onclick event, so it never occured to me that I needed the form element wrapped around it. Looked in netscape, boom was right on top of it when it didnt show up. Netscape is strict like that ;) That could very well be his problem. Mike From: "avex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: TextArea for IE vs Netscape Date: Fri, 15 Dec 2000 16:47:36 +1000 this may seem stpid but once we had that problem here. and someone forgot to add a form tag!! adding one fixed the problem.. i am sure this can't be your problem though... ;-) Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ 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: Help on Pulldown - Please help...getting coldfusion rage here
why don't you try concantinating the fields in your query before the cfselect - Original Message - From: "Kim Ahlbrandt" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 14, 2000 10:42 AM Subject: Help on Pulldown - Please help...getting coldfusion rage here is there a way to display more than one field on a pulldown menu. For instance...the users will be choosing a Texas Court on this pulldown menu but the Court name does not mean anything without the County name in front of it. So, in my cfselect cfselect name="rowid" query="court_q" value="rowid" display="court_nm" required="Yes"/cfselect I need to also display a field called county_nm when they pull down. This is driving me crazy!! thanks, Kim Ahlbrandt ~~ 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: Help on Pulldown - Please help...getting coldfusion rage here
read the message from dan haley, there are examples in the email - Original Message - From: "Kim Ahlbrandt" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 14, 2000 11:41 AM Subject: RE: Help on Pulldown - Please help...getting coldfusion rage here I'm not sure how to do that... -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 11:13 AM To: CF-Talk Subject: Re: Help on Pulldown - Please help...getting coldfusion rage here why don't you try concantinating the fields in your query before the cfselect - Original Message - From: "Kim Ahlbrandt" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 14, 2000 10:42 AM Subject: Help on Pulldown - Please help...getting coldfusion rage here is there a way to display more than one field on a pulldown menu. For instance...the users will be choosing a Texas Court on this pulldown menu but the Court name does not mean anything without the County name in front of it. So, in my cfselect cfselect name="rowid" query="court_q" value="rowid" display="court_nm" required="Yes"/cfselect I need to also display a field called county_nm when they pull down. This is driving me crazy!! thanks, Kim Ahlbrandt ~~ 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
TextArea for IE vs Netscape
Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ 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: CFAS Scheduler CFINCLUDE
I have an item that is schedule to run through CFAS and it has 3 includes that work just fine. - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, December 13, 2000 8:03 AM Subject: CFAS Scheduler CFINCLUDE Good (?) Post-Election Morning! Can the CF template executed by the CFAS Scheduler have CFINCLUDEs in it that will work? Or does the CF template executed by the CFAS Scheduler have to all all CF tags directly in it? The latter seems to be the case here (to be confirmed later today when the Scheduler fires). best, paul ~~ 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