RE: I lost my brain - checkboxes
You could do a second update as follows: Update survey Set hot = 0 Where SID not in (10,17) A warning though: A not in query only runs well on well-indexed or small tables. If your table doesn't meet those standards then you'd be better off getting the whole list of SIDs as a list and removing the ones that were checked then running the in statement with the remainder. Margaret -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:39 AM To: CF-Talk Subject: I lost my brain - checkboxes Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td /tr /cfloop So here is my problem. When a checkbox (or more) is checked, I do this SQL statement: UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great. However, if I deselect the checkbox I no longer have the SID: UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID). So how do I do this? I want to set the Hot field to 1 on only the SID when checked and if i deselect it, then i want the field to be set to 0 on the SID i deselect. The default value in the Hot (bit) field is 0. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
RE: cfinclude, how granular can you make it?
You could use the include to create a variable and then use evaluate to act on it I believe. Yes, I've run into this limitation myself. Margaret -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 8:17 AM To: CF-Talk Subject: RE: cfinclude, how granular can you make it? You can't break out cfif's into different pages and then include them, you have to have the cfif then else all in the same page. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 11:15 AM To: CF-Talk Subject: cfinclude, how granular can you make it? How granular can you make your includes? I ask because I'm unable to breakup an if-else clause. If I pull out the cfif ... and put it into an include I get a Just in time compilation error. If I put the entire cfifcfelse/cfif into the include everything works fine. I'm not finding information on just in time complitation error in either google, or forta's book or the macromedia site. WHAT EXISTS : // if today is a holiday do this else do that cfif ... snip ... #year# EQ 2002 AND #month# EQ 9 AND #ThisDay# EQ 2 OR ... snip ... td class=holiday#ThisDay#/td cfelse tda href=#ThisDay#/td cfif WHAT I WOULD LIKE TO BE ABLE TO DO: cfinclude template=holiday.cfm td class=holiday#ThisDay#/td cfelse tda href=#ThisDay#/td cfif thx // gilbert midonnet __ 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: Going crazy! Dates acting insane..AIIIEEE!
I'd check to see if StartDate is a system variable. Sometimes you get issues if you choose variable names that are already captured by the server. Try renaming StartDate to Starting_Date and see if that helps. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 10:14 AM To: CF-Talk Subject: Re: Going crazy! Dates acting insane..AIIIEEE! Same here. It's exactly the same as the full version except that it's got a 2G size limit per database. - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:36 AM Subject: RE: Going crazy! Dates acting insane..AIIIEEE! Ok...maybe I didn't explain this properly. Basically, I have set a variable to a date: !--- DEBUG CODE --- CFSET STARTDATE = #CreateODBCDate('9/01/2002')# CFSET ENDDATE = #CreateODBCDate('9/30/2002')# CFSET client.empid = 1 !--- DEBUG CODE --- I output the variable startdate and I get : {d '2002-09-01'} Then I set another variable, to the startdate. CFSET TheDate = StartDate Now..when I output this date, in the line directly BENEATH this statement above, I get 2002-09-08 00:00:00 How did it suddenly jump forward by 7 days??? I have NO other manipulations of the startdate variable in between these statements. What am I doing wrong??? -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 9:58 AM To: CF-Talk Subject: Going crazy! Dates acting insane..AIIIEEE! !--- DEBUG CODE --- CFSET STARTDATE = #CreateODBCDate('9/01/2002')# CFSET ENDDATE = #CreateODBCDate('9/30/2002')# CFSET client.empid = 1 !--- DEBUG CODE --- tdCFOUTPUT#startdate#/CFOUTPUT/td [This CFOUTPUT shows : {d '2002-09-01'} ] /tr CFSET TheDate = StartDate!--- Set variable to the startdate ---strong/strong CFLOOP query=GetClients CFSET TheDate = StartDate trtdCFOUTPUT#TheDate#/CFOUTPUT/td/tr [BUT THIS CFOUTPUT shows: 2002-09-08 00:00:00] td CFOUTPUT#GetClients.offtime#/CFOUTPUT/td cfloop Condition = #TheDate# LESS THAN OR EQUAL TO #EndDate#!--- Create a loop to loop over the days from the startdate to the enddate which should cover an entire month --- CFQUERY name=GetHours datasource=#DSN# SELECT * FROM tblMaster,tblDetails WHERE tblMaster.ClientID = '#GetClients.ClientID#' AND tblDetails.RecordDate = #CreateODBCDate(TheDate)# AND tblMaster.empid = #client.empid# AND tblMaster.MasterID = tblDetails.MasterID /CFQUERY td class=SnowDataTDCFIF #GetHours.RecordHours# GT 0 cfoutput#GETHOURS.RECORDHOURS#/cfoutput CFELSE nbsp /CFIF /td CFSET TheDate = DateAdd(d,TheDate,1)!--- Increment date value by one --- /CFLOOP!--- Date Loop --- td class=SnowFieldCaptionTDCFOUTPUT#GetClients.clientid#/CFOUTPUT/t d td class=SnowFieldCaptionTDCFOUTPUT#GetClients.hoursworked#/CFOUTPUT /td td class=SnowFieldCaptionTDCFOUTPUT#GetClients.hoursbilled#/CFOUTPUT /td td class=SnowFieldCaptionTDCFOUTPUT#GetClients.jobno#/CFOUTPUT/td !--- td class=SnowFieldCaptionTDbAcct Group/b/td --- /tr !---CFSET TheDate = #CreateODBCDate('9/01/2002')# Set variable to the startdate --- strong/strong /CFLOOP!--- Clients Query --- How the HELLS did it jump forward 7 days!!?? I am not changing the date ANYWHERE... And I just don't understand what is happening...I'm tearing my hair out and its already short and Im really starting to mess up my scalp. Any ideas?? Yes yes yes I know I can use an Index loop instead of the conditional..I'll fix all those little things I suppose..but before I do that I need to figure out why my dates are suddenly gaining days!! :-\ ARRRGGHH! What stupid thing am I doing now? :-( -Gel __ 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: Search string pasing?
This doesn't parse by token, but you could replace the search for % with a space. I use this to allow for dynamic emails, i.e. user types in the email message with actual db fields designated by %. CFSET found=#find(%,tmp)# cfloop condition=found gt 0 CFIF #left(tmp,1)# is % CFELSE CFSET contents=#contents##left(tmp,(find(%,tmp) -1))# /CFIF CFSET tmp=#mid(tmp,(find(%,tmp)+1),len(tmp))# CFSET foundvariable=Sql. #left(tmp,(find(%,tmp) -1))# CFSET contents=#contents##evaluate(foundvariable)# CFSET tmp=#mid(tmp,find(%,tmp)+1,len(tmp))# CFSET found=#find(%,tmp)# /cfloop CFSET contents=#contents##tmp# -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 7:37 AM To: CF-Talk Subject: Search string pasing? Does anyone have an example sof parsing strings with CF? I need to enhanceour search engine so that we can control the search cresults and in order to do this, I need to break the search string down into words so I can search for keyword matches by the entire string then by each word... Any ideas.. Thanks KP Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to add BR to CRLF?
You may want to verify that the database or text file actually contains line feeds. It could just be using a wrap function. If so, you probably would half to set a line length then find the nearest space to the line length and add the br there. Margaret -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 4:04 AM To: CF-Talk Subject: Re: How to add BR to CRLF? Try: CFSET HTMLBody = replace(Body, tmpCRLF,#tmpCRLF#br,ALL) On Wed, 11 Sep 2002, Erik Britt-Webb wrote: I'm trying to take plain text from a database or text file and display it on a web page. Problem is that the CRLF characters don't work in HTML. So, I tried converting them using: CFSet tmpCRLF = Chr(13)Chr(10) CFSet HTMLBody = #Replace(Body,tmpCRLF,tmpCRLFBR)# But that doesn't work. I still get the same run-on paragraph. Any suggestions how I do this? I'm sure it's easy. Thanks, Erik __ 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: Programmatically Import XLS into SQL Server 2000
Look for something like SQLloader for Oracle that can load based on delimited fields. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 11:10 AM To: CF-Talk Subject: OT: Programmatically Import XLS into SQL Server 2000 Any ideas? __ 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
Has anyone seen this before? Strange garbling of the SQL statement when passed by CFQUERY
Hi all, I just moved my box to another domain in another network but the actual box stayed the same and contains CF 4.5, Oracle 8i and IIS. I tried to run one of my reports and I get the following error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression SQL = select q.incident,(q.calldate||' '|| q.calltime) as create_time, min(c.calldate||' '|| c.calltime) as action_time, sysdate from cnotes c, question q where c.incident=q.incident and =2.12452406865E-314 and =q.incident and (c.callgroup is not null) group by q.incident,q.calldate||' '|| q.calltime The actual query is: select q.incident as incident, (q.calldate||' '|| q.calltime) as create_time, min(to_char((to_date((c.calldate||' '|| c.calltime),'DD-MON-YY HH24:MI:SS') - to_date((q.calldate||' '|| q.calltime),'DD-MON-YY HH24:MI:SS'))*24,'.00')) AS difference, sysdate from cnotes c,question q where c.incident=q.incident and q.calldate = sysdate-#Actionrange# and c.calldate is not null and (c.callgroup is not null) and q.incident not in (select incident from cnotes where callnote like '%Case taken from Cus Support+Knowledge Base%') group by q.incident,q.calldate||' '|| q.calltime Actionrange is a variable set to 8 by default. I'm thinking the problem is related to the greater than sign, but am not sure. The report worked fine up until the move and the box itself is the same as it was before, only the domain is different. Please help, I am completely stumped. Even if you can just give me some idea where the 2.12452406865E-314 is coming from I'd appreciate it. Running the query in native SQL has no problems even on that box. Thanks in advance, Margaret __ 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: CFFORM/CFINPUT
When I tried to use cfinput, it had to download an applet onto the client machine. So I decided to stick with self-validation rather than requiring a user automatic download that they might be concerned about. -Original Message- From: JLH All Turbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 8:56 AM To: CF-Talk Subject: Re: CFFORM/CFINPUT It really depends on how fast you need something done and how detailed you want error messages. I use cfform at times and at other times when more complex error checking is required--I don't use it. I never use cfinsert and cfupdate though. J - Original Message - From: G L [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 11:53 AM Subject: CFFORM/CFINPUT Can someone explain to me why alot of advanced CF'ers don't like to use CFFORM and CFINPUTs in their code? I've even heard them refer to it as novice cf-coding. I've always had good luck using them. Are there drawbacks to letting CF generate the js to validate your input fields? There must be a good reason. __ 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: CFFORM/CFINPUT
Wow. Thanks. I'll admit I'm not going to redo all my forms now, but that's good to know for the future. Margaret -Original Message- From: JLH All Turbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 9:07 AM To: CF-Talk Subject: Re: CFFORM/CFINPUT CFFORM NAME=name ACTION=form_action ENABLECAB=Yes or No set enablecab = no and you don't have to download the applet. j - Original Message - From: Margaret Fisk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 11:55 AM Subject: RE: CFFORM/CFINPUT When I tried to use cfinput, it had to download an applet onto the client machine. So I decided to stick with self-validation rather than requiring a user automatic download that they might be concerned about. -Original Message- From: JLH All Turbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 8:56 AM To: CF-Talk Subject: Re: CFFORM/CFINPUT It really depends on how fast you need something done and how detailed you want error messages. I use cfform at times and at other times when more complex error checking is required--I don't use it. I never use cfinsert and cfupdate though. J - Original Message - From: G L [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 11:53 AM Subject: CFFORM/CFINPUT Can someone explain to me why alot of advanced CF'ers don't like to use CFFORM and CFINPUTs in their code? I've even heard them refer to it as novice cf-coding. I've always had good luck using them. Are there drawbacks to letting CF generate the js to validate your input fields? There must be a good reason. __ 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: Single Quote in Multiple Record Update - not yet
You may have to replace the in the comments field with the html equivalent, quot; before you insert. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 10:12 AM To: CF-Talk Subject: RE: Single Quote in Multiple Record Update - not yet Whoops, typo! It's correct on the actual page. Actually, it only the comments field that's the problem - everything else is fine. The update is actually much larger than the example - probably 50 fields. Query works great until somebody puts something like I can't figure this into the comments field... For my update multiple records problem with single quotes: CFOUTPUT CFLOOP index=thisID list=#FORM.ProjID# CFQUERY NAME=update datasource=creati610.data UPDATE INT_PROJECT FORM_NUM= '#evaluate(FORM.NUM_#thisID#)#', DUE_DATE= '#evaluate(FORM.DUE_DATE_#thisID#)#', COMMENTS= '#evaluate(FORM.COMMENTS_#thisID#)#' WHERE ID = #thisID# /CFQUERY /CFLOOP /CFOUTPUT __ 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: How to append a string to a string?
I may be missing something but this works: output = table border='#border#' bgcolor='#color#' output = #output# tr td etc. -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 2:17 PM To: CF-Talk Subject: How to append a string to a string? whats an easy way to append a string to a string? I'm trying to do this: // php $output = table border='$border' bgcolor='$color'; $output .= tr; $output .= td; etc... in CF. I don't want to use cfscript though. Thanks. __ 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: record linking prob
It's a silly detail, but are you sure you're within a functioning loop when the href url is generated? Sounds like it is just showing the first searchResults.RecordID from your description. -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:35 AM To: CF-Talk Subject: record linking prob Hey I am a newbie here and am having abit of troubles ... i am trying to link together a brief results page to a full details page. i am able to create the link, but when I click on it, it always brings me to the same record ... here is my source: a href=matdetails.cfm?searchResults.RecordId=#URLEncodedFormat(searchResults. RecordID)##searchResults.Title#/a . no matter when I click on it I always get record one ... any suggestions would be appreciated. thanks __ 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: Cold Fusion and imap
Does anyone know if Cold Fusion can support getting mail from an imap connection instead of POP? Thanks in advance, Margaret __ 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: Password protecting browsable web directories
I actually had a similar problem and solved it in the following way: I have a form that reads the results of of CFDIRECTORY listing and makes URLs out of the files and buttons out of the subdirectories. When you click a button, it redoes the CFDIrectory but adds the subdirectory to the path that is listed. Since security is such a big deal, this download page is only available within a password protected site (using a database and an encrypted password) and then additionally I use CFCONTENT to pass the file to them without ever showing where the indicated file structure exists. Is this what you're looking for? -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:19 PM To: CF-Talk Subject: Password protecting browsable web directories I've got a client that wants a simple web-accessible file store where employees can download files. The simplest approach is just to enable directory browsing and to allow administrators to FTP to the web site to upload the files. Now they want to password protect the directory. I don't want to use NT user accounts. If I use CF for login management, I must create index files in each directory, but I lose the simple web server based 'browsability' of the directory tree. What are the alternatives? Do I need to create an application that mimics the web server behavior? Jim __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Populating a form with query results
One other thing is you should do isDefined and provide a blank or default if it is not. Otherwise you get errors if the query returns a null for that field. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 10:05 AM To: CF-Talk Subject: RE: Populating a form with query results I generally do something like this: cfquery name=foo select bar from table /cfquery cfoutput input name=newfoo type=text value=#foo.bar# /cfoutput Hope that helps. Maybe my brain is in gear on this one. :-) --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Yexley Robert D Contr Det 1 AFRL/WSI : [mailto:[EMAIL PROTECTED]] : Sent: Monday, July 22, 2002 12:50 PM : To: CF-Talk : Subject: Populating a form with query results : : : I have a basic HTML form in a CF document, and I need to be able : to populate some of the fields on the form with the results of a : database query. I can't seem to find anywhere that explains how : to go about doing this. Could somebody point me in the right : direction? Thanks in advance. : : /* : || Robert D. Yexley : || Oracle Programmer/Analyst : || Easylink Services Corporation : || Professional Services : || Contractor - Wright Research Site MIS : || Det-1 AFRL/WSI Bldg. 45 Rm. 062 : || (937) 255-1984 : || [EMAIL PROTECTED] : || ))) : */ : : Robert D. Yexley (E-mail).vcf : : __ 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: CFCONTENT and closing the main page
Hi everyone, I am using CFCONTENT to force a download dialog box (thanks to some help from this list :-)) and I have an additional question. Right now, I pop up a separate window that then pops up the File Download dialog. However, the original window stays open even after the download is complete and displays as a blank page. I'm going to work on putting a Click Save on the File Download dialog box message to avoid the blank page, but this is rather obvious. Is there any way to close the window after the File Download box has displayed...without disrupting the download of course. Thanks in advance, Margaret Fisk Manager of Customer Support [EMAIL PROTECTED] Quiver, Inc. 2121 El Camino Real Suite 300 San Mateo, CA 94403 Quiver...Knowledge is Your Advantage Visit our website: http://www.quiver.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCONTENT and closing the main page
Nope. It doesn't close. I also tried CFLOCATION after the CFCONTENT but it didn't work either. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:08 AM To: CF-Talk Subject: Re: CFCONTENT and closing the main page You cant just use script window.close(); /script after your code? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Margaret Fisk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 10:57 AM Subject: RE: CFCONTENT and closing the main page Hi everyone, I am using CFCONTENT to force a download dialog box (thanks to some help from this list :-)) and I have an additional question. Right now, I pop up a separate window that then pops up the File Download dialog. However, the original window stays open even after the download is complete and displays as a blank page. I'm going to work on putting a Click Save on the File Download dialog box message to avoid the blank page, but this is rather obvious. Is there any way to close the window after the File Download box has displayed...without disrupting the download of course. Thanks in advance, Margaret Fisk Manager of Customer Support [EMAIL PROTECTED] Quiver, Inc. 2121 El Camino Real Suite 300 San Mateo, CA 94403 Quiver...Knowledge is Your Advantage Visit our website: http://www.quiver.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCONTENT and closing the main page
Thanks Isaac. I'll give it a try. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:39 AM To: CF-Talk Subject: RE: CFCONTENT and closing the main page Hi Margaret, I believe you'll get what you want if you simply don't spawn the separate window... If you just use a link to the cfcontent page, i.e. a href=cfcontent.cfm?fileid=#fileid#Get the File/a The user will only see the download dialogue -- the page they're on won't change -- in essence, the same as if you linked to a zip file like a href=myfile.zipGet the file/a Isaac Dealey www.turnkey.to 954-776-0046 __ 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: Recursive queries
This is a very complex query that I used to use to generate a report from: ID Parent Name 1 0 Dad 2 1 Daughter 3 2 Grandson To this: Master_Parent Parent Topic count Dad Dad Daughter1 Dad DaughterGrandson1 Or something like that...its been a while. Is this what you're looking for? It requires a known number of topic relationships SELECT s4.sort_order,' '||substr(rtrim(s3.Name),1,length(s3.name)) Master_Parent, ' '||substr(rtrim(s2.Name),1,length(s2.name)) Parent, ' '||substr(rtrim(s.Name),1,length(s.name)) Topic, ' '||rtrim(c.URL) URL, ' '||sum(c.Count) CountOfURL FROM pbls_$partner s,pbl_count_$partner c,sortorder_$partner s2, pbls_$partner s3, sortorder_$partner s4 WHERE s.pbl_id=c.pbl_id and s2.pbl_id(+)=s.father_id and s2.master_father_id=s3.pbl_id(+) and s.pbl_id=s4.pbl_id and c.hit_date in (select hit_date from temp_pbl2_$partner) GROUP BY s.path, s2.name, s.father_id, s.name,c.URL, s3.name, s4.sort_order; -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:57 AM To: CF-Talk Subject: RE: Recursive queries I looped this: SELECT * WHERE PARENT_ID IN (#keyList#) appending the keys returned to a list, and kept going till recordcount = 0 That goes from parent to all children, grandchildcren, all the way down. Going up is the opposite. I can chunk you the code if you want. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:37 AM To: CF-Talk Subject: Recursive queries Still trying to decide how I like to perform some type of recursive query wth the following Table structure; ID NAME PARENT_ID If the current record IS the parent then the Parent ID is 0 Otherwise the child has the ID of the parent as it's Parent ID. Anyone have any good references on recursive queries to handle this? A way to spider down through the parents and children basically. Ive done this before using Stored Procs and temp tables, but there has to be an easier way. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail can only deliver to our domain name...
What does your mail log say? We had the same problem when my company changed the mail server. It did not include a rule that the CFserver could use it as a forwarding server and so rejected any mail address that did not exist on the box. -Original Message- From: Philippe Varichon [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 7:52 AM To: CF-Talk Subject: CFmail can only deliver to our domain name... I sent 180 different emails generated from our db in that way: BATCH #1: to myself with the From being '[EMAIL PROTECTED]' and the To: '[EMAIL PROTECTED]' Worked just fine. BATCH #2: to myself with the From being '[EMAIL PROTECTED]' and the To: '[EMAIL PROTECTED]' Worked just fine. BATCH #3: to myself with the From being a list of 180 different emails not related to our domain name: 'circumvista.com' such as '[EMAIL PROTECTED]' and 3 emails that were: '[EMAIL PROTECTED]' '[EMAIL PROTECTED]' '[EMAIL PROTECTED]' and the To: '[EMAIL PROTECTED]' Results: only the 3 above emails sent to our domain were successfully received all other ones were dumped in the undeliverable bin and transferring them in the spool would just dump them again. I did the tests twice each time with the same results. Our box is scanned daily for virus by Norton with the latest updates. Does someone can explain this weird behavior of CFmail? It used to work just fine with hundred's of emails. Thanks in advance, Philippe Varichon __ 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: cffile copy problem
It will only get you the text of the file and probably lose some formatting, but you could read it and then output a new file using the file contents couldn't you? -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 1:08 PM To: CF-Talk Subject: RE: cffile copy problem No joy, still won't copy a file that I don't have write permissions for. Shawn -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 8:49 AM To: Shawn McKee Subject: RE: cffile copy problem Yeah, the attributes parameter looks like a Windows-only thing. -- Original Message -- From: Shawn McKee [EMAIL PROTECTED] Date: Thu, 11 Jul 2002 08:40:44 -0500 This actually comes from the custom tag local_to_local. In looking at it I am wondering if it is the combination of the attributes and the mode in the same tag. I am betting I added the mode and left the attributes. cffile action=COPY source=#Dir#/#Name# destination=#attributes.DestDir#/#NewFile# attributes=normal mode=664 Shawn -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 8:35 AM To: Shawn McKee Subject: RE: cffile copy problem Ah, yes, I agree - your CF is running as userid cfadm. Sounds like Linux itself is happy with what you've got. Do you have a mode parameter in your cffile statement? Here's one I use: cffile action=append file=myfilename mode=644 addnewline=Yes output=blah blah blah -- Original Message -- From: Shawn McKee [EMAIL PROTECTED] Date: Thu, 11 Jul 2002 08:16:54 -0500 I'll check that but when it does successfully copy the files the end up as owned by cfadm not by nobody thus my assumption that it was running as cfadm. Shawn -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 7:59 AM To: CF-Talk; [EMAIL PROTECTED] Subject: Re: cffile copy problem CF (on Solaris, anyway) runs as userid nobody. So the permissions have to be right for nobody for cffile to work. Chris Norloff -- Original Message -- from: Shawn McKee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 10 Jul 2002 19:00:20 -0500 I am trying to copy a file on a Linux system that has read permissions at the group level (644 specifically). I can log into the box and su to cfadm and make the copy just fine. If I try and do it with the cffile tag I get a permission denied. If I change the file permissions to read, write at the group level (774) all is OK. The write permission at group should not impact my ability to read and copy the file. Any ideas? Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ 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: I don't want refreshing when I am selectiong to download
I have a similar situation where users choose between 12 different downloads. How I've resolved the situation is to place a checkmark next to each download. The checkmarks are evaluated after the submit and those downloads are sent to the user in email. -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 8:08 AM To: CF-Talk Subject: I don't want refreshing when I am selectiong to download Hi, my application gives the user the choice to select from search results(images), in order to download. They will usually select more than one image. PROBLEM: Each click of the select button means my page is refreshed - that is a new query has to begin in order to select yet another image. The code is attached. I have been advised that javascript will help me stop this happenning. What kind of javascript are we referring to? How can I implement this. I don't know where to start. __ 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: CFMX CFDUMP / Stylesheets.
I've not tried it, but you could probably override the default TD class by putting TD class=cfdump for all the cfdump information. That way you'd only have to change the cfdump entries rather than every TD call. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 8:51 AM To: CF-Talk Subject: RE: CFMX CFDUMP / Stylesheets. Ok, perhaps I'm not seeing the obvious.. if I have my site css... and I have something like: TD{font-family : Verdana, Geneva, Arial, Helvetica;font-size : xx-small;} Now... just because I want my fonts in a TD to be xx-small doesn't mean I want the TD's in the CFDUMP to be xx-small. I'm guessing that I need to remove the above TD in the stylesheet and just make my own class, but that would mean me having to go and add class=whatever to all my TD's that I want it applied to. :) ~Todd On Mon, 8 Jul 2002, Katherine Maltby wrote: but you can have more than one class for all tds in a site..or am I missing what the problem is here?! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 08 July 2002 16:34 To: CF-Talk Subject: RE: CFMX CFDUMP / Stylesheets. No, my stylesheet is interferring with cfdumps. I'd have to go in and remove my own TD class and make a class that doesn't conflict I guess. ~Todd On Mon, 8 Jul 2002, Raymond Camden wrote: Are you saying that cfdump's style sheet inteferes with your pages style sheet? === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 11:27 AM To: CF-Talk Subject: CFMX CFDUMP / Stylesheets. Anyone know of a way to stop a block of code from using stylesheets? For example, my css obviously has a TD {blah} in it - and, because of that ... cfdump also uses that stylesheet. Basic question here, but ... my brain is dead atm. Too much Warcraft 3. :) (Awesome game btw) TIA, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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: variables not let go
You can always use an ISNULL in your query...different for each database... to make sure it has a value even if the field is blank. -Original Message- From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 1:19 PM To: CF-Talk Subject: Re: variables not let go I have noticed this in a nested loop/query situation. I just had to make a workaround for it. ~Val - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 2:28 PM Subject: variables not let go has anyone noticed when they have a query that returns lets say for example the variable called CompanyName, and on the 3rd loop through the results the variable CompanyName is undefined and then value of CompanyName from the 2nd row shows up as the value of the 3rd row? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 __ 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: Working with empty lists
Set your form to supply default values that are overridden or in the case of a checkbox, have a hidden value with the same name that you strip in your code. If only the hidden value exists, insert null otherwise, insert the other list value. Multiple entries will usually be separated by a comma. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 2:07 PM To: CF-Talk Subject: Re: Working with empty lists Ok...Let me try to be a little more presice in what I am needing, and by the way Brian your help yesterday was excellent. What I want to do is insert the value of or NULL if none of the checkboxes are checked and insert the id, inventory_id into the table also. Right now if the person does not choose any options, then nothing gets inserted into the options table. This causes a problem if the user later goes back and decides to give the car some options from the update form since their is no inventory_id in the table to reference for the vehicle. Does this make a little more sense? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 1:52 PM Subject: Re: Working with empty lists OK...I thought I showed you how to do this yesterday ;-) First off I think what you're trying to will loop as many times as there are options. Instead you should only need to loop as many times as there are checked checkboxes. yes I know it's not a big deal, but if you can be more efficient...why not ;-) Here's what I'd do: DISPLAY AND ASSIGN VALUES TO CHECKBOXES: cfloop query=get_otptions input type=checkbox name=chkOption value=#ID##Option_Name#br /cfloop AFTER THE BOXES ARE CHECKED AND THE FORM IS PASSED: Now we have to insert all your CHECKED options. I'll just focus on the option INSERT query and skip your other stuff to grab the right ID and all that (so at this point we assume we have the vehicle ID). cfquery datasource=DSN name=InsertOptions cfloop list=#FORM.chkOption# index=Option_ID INSERT INTO Options ( inventory_id, option_id ) VALUES ( #Inventory_ID#, #Option_ID# ) ; /cfloop /cfquery So what happened above is; The value for FORM.chkOption will contain a comma delimited list of ALL the values (option_IDs) from the CHECKED boxes. You CFLOOP through that list and insert the Option_IDs. Hopefully I understand what you're up to and this has made sense ;-) Good luck Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 1:08 PM Subject: Re: Working with empty lists Ok here we go. I am using the hidden field as someone pointed out IE: input type=hidden name=chkOptionList value=#valuelist(get_options.id)# This gives me a list of 1,2,3,4,5 etc...etc... then using the cfif listFind(attributes.chkOption,j) to see if the checkbox was indeed checked and if so run the query to insert the value and if not to insert NULL or Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 1:04 PM Subject: Re: Working with empty lists An overview of exactly what you're trying to do might help. It's hard to tell where everything is coming from and what kind of value it's supposed to have ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 12:55 PM Subject: Re: Working with empty lists I still must be doing something wrong.It inserts all the values of the checkboxes, if they are checked or not. Here is the code I have so far, and thanks for all the help cfif ListLen(attributes.chkOptionList) cfloop list=#attributes.chkOptionList# index=j cfparam name=attributes.chkOption
RE: fusebox 3.0 help needed
I may be missing something but why don't you use either CFLOCATION to redirect or CFCONTENT to display the contents of the additional page from within the called page? CFINCLUDE only works on code not other pages as far as I know. Margaret -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 8:40 AM To: CF-Talk Subject: RE: fusebox 3.0 help needed Nope still got a 404, -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 4:32 PM To: CF-Talk Subject: RE: fusebox 3.0 help needed How do you include a location? All you are doing with include is throwing a bunch of code in the middle of the template you initially called. Try killing the request.virtualhost. If you are routing this all through the root level index.cfm it is in the directory you are currently in. just do href = index.cfm?fuseaction=GlobalAdmin.admin:; See if that works. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 11:13 AM To: CF-Talk Subject: RE: fusebox 3.0 help needed yes using javscript is a good altrenative to redirecting to the approprite circuit and FA, BUT THE cfinclude should still work all the same. but CFINCLUDE SHOULD still work, I tried this CFOUTPUT SCRIPT LANGUAGE=Javascript document.location.href=#REQUEST.VIRTUALROOT#index.cfm?fuseaction= GlobalAdmi n.admin; /SCRIPT /CFOUTPUT I still get the same error, I am posting to index.cfm at root level, //my FBX_CIRCUITS CFSET Fusebox.Circuits = StructNew() cfset fusebox.Circuits.utilityEyeAdmin=utilityEyeAdmin cfset fusebox.Circuits.GlobalAdmin=utilityEyeAdmin/secure/GlobalAdmin SO THEN EFFECTIVELY i should go to my FBX_switch at utilityEyeAdmin/secure/GlobalAdmin/ which is CFPARAM NAME=VARIABLES.ERROR DEFAULT= CFSWITCH EXPRESSION = #FUSEBOX.FUSEACTION# CFCASE VALUE=admin test /CFCASE CFDEFAULTCASE CFPARAM NAME=ATTRIBUTES.DISPLAYACTION DEFAULT=NEW CFINCLUDE TEMPLATE=TEST.CFM /CFDEFAULTCASE /CFSWITCH inside utilityEyeAdmin/secure/GlobalAdmin/ i have fbx_Layouts.cfm fbx_Settings.cfm fbx_Switch.cfm lay_adminLayout.cfm test.cfm N.B. no index.cfm ... -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 3:30 PM To: CF-Talk Subject: RE: fusebox 3.0 help needed I am not sure how you are going about relocating to another page by using cfinclude. In Fb3, and cf development in general, I will usually use a javascript location. Something along the lines of: SCRIPT document.locaction.href=index.cfm?fuseaction=this.that; /SCRIPT I am not sure why you are getting a 404 error. Are you continuing to route your calls through the root level index.cfm, or are you making a call to a circuit directly? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:15 AM To: CF-Talk Subject: fusebox 3.0 help needed Greetings, I need some help here guys and gals, I am seriously confused with FB 3, bearing in mind I am migrating from ver 1 to 3 skipping 2, the problem is when I post a form validate it and then relocate to a different directory using CFINCLUDE (BECAUSE I AM SETTING A COOKIE), i get a HTTP/1.0 404 Object Not Found, the sample app I downloaded (simpsons) is a bad example to be honest because it does not cover the problem when posting data only circuit nesting, and I don't see the advantages of that anyway to be painfully honest. I don't know if I need an index file in each directory, because the sample app does not, I understand #fusebox.layout# and its relationship with FBX_switch, I don't want to post any code unless someone is prepared to identify where I am going wrong, you'll probably spot it quicker than me if you have been developing with FB3 for a while, any one want to help me out here, Respectfully, j __ 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: MAX function problem
The problem is that your As TheID needs to appear immediately after Max(ID) like so: SELECT MAX(ID) AS TheID FROM UserInfo The way you have it actually is renaming the table not the result. -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:28 AM To: CF-Talk Subject: MAX function problem Hello, Everytime I use this function I have problems. My code is below. I keep receiving an error saying: The column THEID is not present in the query named GETID CFQUERY datasource=#dsn# name=GetID SELECT MAX(ID) FROM UserInfo AS TheID /CFQUERY CFOUTPUT#GetID.TheID#/CFOUTPUT thanks for your help, Sal __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: populate a table
You need to remove from selectedvendor from your query since you are performing an insert not a select. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:47 AM To: CF-Talk Subject: populate a table Hello, If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a syntax error with this though. Any better way? Robert O. CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases INSERT INTO purchases ( vendor, Contact, Address) VALUES ( '#FORM.vendor#', '#FORM.contact#', '#FORM.Address#') from selectedvendor /cfquery /CFIF __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange SQL error
Something that's happened to me before is that, depending on what you used to write the code originally, a hidden illegal character may have been introduced. When you moved it, once again depending on what you were using, the cut and paste would eliminate any illegal characters. I usually pass code through notepad if I've touched anything like Word or Wordpad for example because of the illegal characters. Margaret -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 9:25 AM To: CF-Talk Subject: RE: Strange SQL error What Andy meant was that he moved the @JuryTitle param to the bottom of the list like so: -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int , @JuryTitle varchar(50) @JuryTitle was originally declared after the second param @JuryName. For some reason the SP then released perfectly. Bizarrely I then moved the @JuryTitle param back to where it was and then the SP relases again. For the last 2 hours the SP would not release and we are at a loss as to why it didn't work. Any Ideas SQL gurus what may have happened? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:10 To: CF-Talk Subject: RE: Strange SQL error uh? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:18 To: CF-Talk Subject: RE: Strange SQL error Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy,
RE: Is there any way to touch a file and update its dateLastMod ified?
Thanks Dave, your script is probably exactly what I need. And yes, I know it is common on Unix, but I'm working on Windows. Every once in a while I get frustrated by the differences :-) Margaret -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:37 PM To: CF-Talk Subject: RE: Is there any way to touch a file and update its dateLastMod ified? Is there any way to touch a file and update its dateLastModified? There's a utility called touch, which will do this. It's common on Unix/Linux systems, and it's part of the Cygwin distribution that you can use on Windows. I wouldn't be surprised if there were versions of touch available for Windows outside of Cygwin, either. I'm trying to archive files after 5 days that are moved over to the CF server for download but they are retaining their dateLastModified from their original location. I've checked the file properties in the OS and the date created is the value I want because it shows when they were copied into the folder. How do I access date created as opposed to dateLastModified? Unfortunately, I don't think you can get that from CFDIRECTORY. If you're on Windows, you can access the COM interface to the filesystem: cfscript strFile = d:\sample_file.txt; fso = CreateObject(COM, Scripting.FileSystemObject); f = fso.GetFile(strFile); WriteOutput(DateFormat(f.DateCreated)); /cfscript Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Subquery from the same table: Is it possible??
You have to join the two tables even if it is the same one. However, this particular query makes no sense. This type of technique is best with the key manager where they have a connected key so you do something like this: Select * from tbl_users where role = (select role from tbl_users a,tbl_users b where a.role_owner=b.role and a.username = '#session.username#') this would be a case where role_owner is the manager and the role_owner key is matched to the role key for the subordinates. Margaret cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users a where fullname IN (select fullname from tbl_users a,tbl_users b where a.username=b.username and username = '#session.username#') /cfquery -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:07 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? almost like the same output I got with this, but it produces the same name in both fields. My code prodcues two instances of USER and your code produces two instances of the KEY USER. Getting closer though... cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:06 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whererole = ( select 'key_' role as keyrole from tbl_users where username = '#session.username#') /cfquery See if that works for you. It's an educated guess. - Matt Small -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo
RE: How to detect timeout session??
I do a similar check but at the top of the page so it also catches people who haven't logged in at all. If the session variables are not defined or don't have the correct values (clicking logout changes to invalid value) then it redirects to the login page. This is both security for direct calls to the individual page and manages session timeouts in one. Margaret -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:21 AM To: CF-Talk Subject: RE: How to detect timeout session?? put this in application.cfm cfif (logic to check timeout) cfset fuseAction = login // fusebox style OR cflocation url=login.cfm // be careful here that you don't end up in an endless loop since application.cfm will be called again when the location happens /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:50 AM To: CF-Talk Subject: How to detect timeout session?? Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time without actvity. Any easy way to detect that at the beginning of one template??? regards and thanks in advance Mario __ 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
Is there any way to touch a file and update its dateLastModifie d?
Is there any way to touch a file and update its dateLastModified? I'm trying to archive files after 5 days that are moved over to the CF server for download but they are retaining their dateLastModified from their original location. I've checked the file properties in the OS and the date created is the value I want because it shows when they were copied into the folder. How do I access date created as opposed to dateLastModified? Thanks in advance, Margaret -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:43 AM To: CF-Talk Subject: OT : js submit into new window... Is there a way to submit a form into a new window, on somebody else's server, and control it's properties (size, status bars, etc)? Right now, I'm using the target attribute in the form tag, but I'd like to have more control over the the window...TIA- Tyler Silcox email | [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can this be done?
One way you can do this is to keep a count of the items in the list and when the count is equal to X, create a new cell. Have the count restart every time you create a new cell (td) and don't forget to close your previous one. You can even have the X variable be something a user can set. Margaret -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:57 AM To: CF-Talk Subject: Re: Can this be done? Hi, This might be a crazy question but here it goes. I'm using cfdirectory to list files on our server. Some directories can have a 100+ files in them. Presently I'm displaying the list down the left side of my webpage under each other. file1.txt file2.txt file3.txt file4.txt file5.txt etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [admin] List status
Actually, we just priced this: It is about $5000 per cpu if you get SQL Server Standard edition and about 20,000 (not sure about this one) per cpu if you want Enterprise edition. The difference between the editions is failover and uptime tools. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:07 PM To: CF-Talk Subject: RE: [admin] List status At 04:42 PM 5/14/02, you wrote: I would chip in. Have a fund raiser Mike. I am not too familiar with SQL Server costs, what would it cost? No clue. I've already started the ball rolling for it and whatever it costs will be taken care of. Donations from people on the list, from pocket, whatever. It's needed and it's going in. -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:39 PM To: CF-Talk Subject: RE: [admin] List status Being able to search the archives might even be worth a donation to many of us. I know it would help me out on occasion. It would greatly reduce the number of emails I save in my CF Archive folder. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/14/02 03:42PM Wow, searching the archives would be 'the heat'! how can we help to get the sql box online? Tony Gruen __ 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: what is causing this mail server error???
Hi all, I periodically get the No connection to mail server error in my mail log and my mail is moved to undeliverable. It seems to be a timing issue or load issue because the server is always available. I have two questions: 1) Is there some bug that I can add a patch for that is responsible? 2) Can I configure my system to try again when this happens? I realize I could create a cf page that just moves the files back into spool based on the error message, but I was wondering if there was a better solution. Thanks, Margaret Failed to send the spooled mail file, 41B.cfmail. SMTP server replied No connection to mail server. __ 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: Problem with comparenocase vs is in CFIF
Hi everyone, I'm experiencing a strange error that I can't figure out and was hoping for some help. I've included the problem code below. Here is what I'm doing: I have a form that includes a report table. Each of the headers is a submit button with the name sort_order and the value of the text that displays (taken from the columnlist variable below). I also pass the previous sort_order button in a hidden field called sort_order_hidden so if the user choses the next 10 records, they will still be sorted by the selected value. I started with using is to compare the list value for the display names with the button value (which is the display name). However, on one of my pages, only when passing the sort order through the hidden field (the CFELSEIF), it does not find any matching value when running the statement CFIF a[i] is Form.sort_order_hidden (I displayed the results and the value is there, but it is not considered a match. I changed to the code to CFIF comparenocase(sort_order_display,a[i]) and now it matches the first value (or when I remove the CFBREAK, the last value) in the loop even if for example, the list item is Company Name and the Form.sort_order_hidden is Phone. As you can tell, I'm stumped and would appreciate any advice, assistance etc. Thanks in advance, Margaret __ 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: Problem with comparenocase vs is in CFIF
Thanks for all the help I know I would have gotten, but I figured it out. Human error of course :-) In my columnlist, I am doing a comma delimited list but to make it more readable, I have a space in front of the values. In my default, I didn't include the space. It only affected this page because the other pages have the first value as the default sort. Sorry, Margaret -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:19 PM To: CF-Talk Subject: RE: Problem with comparenocase vs is in CFIF Hi everyone, I'm experiencing a strange error that I can't figure out and was hoping for some help. I've included the problem code below. Here is what I'm doing: I have a form that includes a report table. Each of the headers is a submit button with the name sort_order and the value of the text that displays (taken from the columnlist variable below). I also pass the previous sort_order button in a hidden field called sort_order_hidden so if the user choses the next 10 records, they will still be sorted by the selected value. I started with using is to compare the list value for the display names with the button value (which is the display name). However, on one of my pages, only when passing the sort order through the hidden field (the CFELSEIF), it does not find any matching value when running the statement CFIF a[i] is Form.sort_order_hidden (I displayed the results and the value is there, but it is not considered a match. I changed to the code to CFIF comparenocase(sort_order_display,a[i]) and now it matches the first value (or when I remove the CFBREAK, the last value) in the loop even if for example, the list item is Company Name and the Form.sort_order_hidden is Phone. As you can tell, I'm stumped and would appreciate any advice, assistance etc. Thanks in advance, Margaret __ 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: Determine if file is there
You could use CFdirectory. That only gets the directory listing which you can loop through to find the file or files. -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 7:59 AM To: CF-Talk Subject: Determine if file is there Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ 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: Do I need to lock around queries?
Sorry I don't have an answer for you, but I do have another question on the locking issue When you put a variable in your application.cfm (for example, your DSN name), is it automatically an application scope variable requiring application locking whether or not you use application.DSN rather than just DSN? And if it is not an application scope variable, what is its scope? Thanks in advance, Margaret -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Do I need to lock around queries?
Thanks. I'll look up type variables to figure out how to treat them. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:01 AM To: CF-Talk Subject: RE: Do I need to lock around queries? No. Default unless fully qualified is type variables, not application Andy -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:55 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Sorry I don't have an answer for you, but I do have another question on the locking issue When you put a variable in your application.cfm (for example, your DSN name), is it automatically an application scope variable requiring application locking whether or not you use application.DSN rather than just DSN? And if it is not an application scope variable, what is its scope? Thanks in advance, Margaret -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Left Outer Join - Lotsa Pain!
The easiest way to get the Access SQL is to construct the statement in the Access GUI. Then you can test out your query as well. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:47 AM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: transact-sql datediff function
Just a guess, but in the datediff you are just extracting the year. If you want to include the month in the calculation, you should probably get the month part too. Margaret -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:20 AM To: CF-Talk Subject: OT: transact-sql datediff function hi all, i posted this on the sql list but got no response. i have a test table named employees with the following fields: fname varchar lname varchar hire_date datetime the record i'm querying contains 2001-05-11 00:00:00.000 in the hire_date field. but this query returns 1 rather than the expected 0: select datediff(yy, hire_date, getdate()) as yearsdiff from employees where fname = 'ann' this should give me the number of years between 5/11/2001 and today's date of 5/6/2002, which should be 0 since it's not 5/11 yet. so why am i getting 1??? ~ dina __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL and singlequotes
Are you doubling all your single quotes in the phrases where you are preserving single quotes? I've had this problem in the past where Oracle reads the sql as: Insert into tablea (lastname) values ('o'dell') as 'o' and dies or ignores dell. Need to write: Insert into tablea (lastname) values ('o''dell') And then it usually works. Margaret -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:26 PM To: CF-Talk Subject: SQL and singlequotes Preservesinglequote() not working or are we missing something? Here is our code, and the resulting error from a user: cfquery name=putitin datasource=mrskellystea username=#tea.user# password=#tea.pass# Insert Into Feedback (comment, sitecomment, tearequest, okforemail, response, firstname, lastname, email, timedate) VALUES('#preservesinglequotes(form.comments)#', '#preservesinglequotes(form.sitesuggestions)#', '#preservesinglequotes(form.tearequests)#', '#form.teamail#', '#form.pleaserespond#', '#form.fname#', '#form.lname#', '#form.email_address#', #setdate#) /cfquery [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 't'. SQL = Insert Into Feedback (comment, sitecomment, tearequest, okforemail, response, firstname, lastname, email, timedate) VALUES('I don't know if you got my message. Am looking for Mrs. Kelly's Special Jasmine tea. Is that the same as your Jasmine Special Grade? Is that the only Jasmine tea you carry? Do you have any hibiscus teas? ', '', '', 'n', 'n', 'Barb', 'Chapman', '[EMAIL PROTECTED]', {d '2002-05-06'}) Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with CFHeader and CFCONTENT
Hi all, I'm having a problem with the CFHeader tag and the CFContent tag combination and hoped someone had a way around it. I am trying to force browsers to download a file rather than launching it in their plugins while also masking the actual location of the file. Thanks to Shawn, I've gotten far enough that the functionality is correct, but I'm running into an annoying display issue. My code is below. This is what happens: To force the browser to save rather than opening the file in the browsers, you have to use the attachment value in the CFHeader (as far as I can tell.) When you use the attachment value, two things go wrong: 1) The filename displayed in the File Download dialog is actually the full URL with query string that you call to launch files this way, (i.e. getfile.cfm?file=george.txttype=petercomment=what is the meaning of 42), of course only actually the last 20-40 characters display. 2) If you select Open file from this location, on one of my test systems, it actually opens the File Download dialog again. (This may be a fluke since its not on the other system. CFSET actualname=#URLDecode(URL.file)# CFHEADER NAME=Content-Disposition VALUE=attachment; filename=#actualname# cfcontent type=nothing/unknown file=#filepath# deletefile=No I'd appreciate any suggestions or even just the answer that I have to live with it. I've tried a bunch of stuff, but the only way to get the filename back into the display is to take out attachment from the CFHEADER value and that will not work. Thanks in advance, Margaret __ 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: Email Time Off Unix
Have you checked the message in another viewer other than MS Outlook? Outlook puts its own interpretation on the date and may think it is in a different time zone. We had that problem for messages between two Exchange servers. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 2:27 PM To: CF-Talk Subject: Email Time Off Unix I am running CF4.5 on solaris. When I send an email with cfmail the resulting email's sent time (in MS Outlook) is 1 hour ahead. The date and time on the unix server is correct. When I send an email from the shell the resulting email's sent time is correct.When I cfoutput now() to a browser window I get the correct time. Anyone come across this? __ 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 cf to html
Just schedule it on your CF server in Administration Tools. Delete the original file Create a new file Write the report + html coding to the file. Or am I missing the point? Margaret -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:35 PM To: CF-Talk Subject: output cf to html I have this Huge Honking report written in cf it shows exactly what i want. but i don't want a user to run this report every time they hit the page. i would like to know how to have cf-server run the page... but just save it to html every night. so that it gets updated basically once a day. instead of hitting the db every time some one views the cfm page.. any ideas? -paul __ 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: masking URLs and cflocation
Hi everyone, I know there is a way to do this (at least the URL masking), but I can't find any answers. I may be asking the wrong questions but... Currently: I have a page that displays the files available for download with hrefs to download them. The user clicks the href and the files either launches in another browser or downloads. The URL is listed both on the href and in the browser address. Here is what I want to do: I want the page to list the files available for download (preferably not as buttons but that's livable) User clicks the link to download (this is not an href so the URL is not displayed) The document/file download launches (cflocation?) in another browser window but the address line displays a default address rather than the true URL. I'd prefer to do this with Cold Fusion rather than JavaScript because not everyone can run JavaScript, but I am willing to be flexible on that if it will work. Thanks in advance, Margaret __ 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: masking URLs and cflocation
Thanks for the correction. It looks like it might be exactly what I need. I'll need to play with it first of course :-) -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:11 PM To: CF-Talk Subject: RE: masking URLs and cflocation oops http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords=cf_ download -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:07 PM To: CF-Talk Subject: RE: masking URLs and cflocation Try cf_download http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347854-2830-11D4 -AA9700508B94F380method=Full -- Sam -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:00 PM To: CF-Talk Subject: RE: masking URLs and cflocation I've hidden the URL to a specific file through the use of a special page and the CFContent tag. For instance, if I asked for a file that was named MyFile.gif, the URL of the link to the file would be something like getfile.cfm?FileID=44. The end result is that the user would download MyFile.gif (with the same filename in the save as window), without ever knowing where MyFile.gif actually resided. Tying this in with the use of the status bar (onmouseover, blank the status bar value), then you would effectively hide the URL to the specific file. Not sure if that's quite what you want, but hope it helps. Shawn Gover -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:46 PM To: CF-Talk Subject: RE: masking URLs and cflocation Hi everyone, I know there is a way to do this (at least the URL masking), but I can't find any answers. I may be asking the wrong questions but... Currently: I have a page that displays the files available for download with hrefs to download them. The user clicks the href and the files either launches in another browser or downloads. The URL is listed both on the href and in the browser address. Here is what I want to do: I want the page to list the files available for download (preferably not as buttons but that's livable) User clicks the link to download (this is not an href so the URL is not displayed) The document/file download launches (cflocation?) in another browser window but the address line displays a default address rather than the true URL. I'd prefer to do this with Cold Fusion rather than JavaScript because not everyone can run JavaScript, but I am willing to be flexible on that if it will work. Thanks in advance, Margaret __ 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