copying files
I need to use CFFILE to go through a directory (and Sub directories) and copy all the files in the dir and subs and copy them to another location. My problem is I need to get the file names and copy the files for the dir and sub.. An help would be appreciated. If more info is needed let me know.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: copying files
Because it is between 2 servers one is NT and the other is Unix and they will not allow a batch file between the 2. That is why we have to do it this way. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 10:49 AM To: CF-Talk Subject: Re: copying files is there a reason you need to use cffile vs maybe a batch file? Eric From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: copying files Date: Thu, 13 Jun 2002 10:44:12 -0500 I need to use CFFILE to go through a directory (and Sub directories) and copy all the files in the dir and subs and copy them to another location. My problem is I need to get the file names and copy the files for the dir and sub.. An help would be appreciated. If more info is needed let me know.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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
Read or delivery receipts for CF and Exchange
Is there A way if I use the CFMAIL tag to get a read or delivery receipt from the Exchange server? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Read or delivery receipts for CF and Exchange
I have looked in the archives and can not find an answer to this subject. I have also looked a Macromedia Exchange. Has nobody ever wanted to do this? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Tuesday, June 11, 2002 9:26 AM To: CF-Talk Subject: Read or delivery receipts for CF and Exchange Is there A way if I use the CFMAIL tag to get a read or delivery receipt from the Exchange server? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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
CFENCRYPT Files
We had someone leave and before they left they encrypted all of one site using cfencrypt. Is there any way to decrypt them? If not We are in some serious trouble!! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
I am sooo confused!!
I have included a file we are trying to change and the file at one point has this code and we are wondering if anyone has seen this before and what it may be calling? CFFORM NAME=theform ACTION=uploadmainbutton.cfm?RequestTimeout=cfoutput#application.timeout# /cfoutput onSubmit=return validateSubmit(_CF_this.__CFTREE__theform__webserver.value) Begin full file here __ 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: I am sooo confused!!
height=20br /CFOUTPUT Select a directory or file from the File Structure, select a function, then Submit. !--- border table --- table border=0 cellspacing=0 cellpadding=1 tr bgcolor=99 td table align=center width=600 border=0 cellspacing=0 cellpadding=2 bgcolor=#FF tr td CFFORM NAME=theform ACTION=uploadmainbutton.cfm?RequestTimeout=cfoutput#application.timeout# /cfoutput onSubmit=return validateSubmit(_CF_this.__CFTREE__theform__webserver.value) TABLE TR TD VALIGN=bottom ALIGN=right bgcolor=CC CFTREE NAME=webserver HEIGHT=250 WIDTH=400 CFTREEITEM DISPLAY=File Structure - #baserootdir# VALUE=#baserootdir# IMG=folder !--- build the first two items in the tree manually. CF no longer returns . and .. as part of a directory listing --- CFIF #baserootdir# IS NOT #origroot# CFTREEITEM DISPLAY=. Current Directory VALUE=Dir#baserootdir# IMG=folder PARENT=#baserootdir# /CFIF CFIF #baserootdir# IS NOT #origroot# CFSET #num# = #Len(baserootdir)#-1 CFSET #slash# = / CFLOOP CONDITION=(#num# GT 0) AND (Mid(baserootdir,num,1) NEQ #slash#) CFSET #num# = #num#-1 /CFLOOP CFIF #Mid(baserootdir,num,1)# IS #slash# CFSET #num# = #num#-1 /CFIF CFTREEITEM DISPLAY=.. Parent Directory VALUE=Dir#Left(baserootdir,num)# IMG=folder PARENT=#baserootdir# /CFIF CFLOOP QUERY=currdir CFIF #type# IS dir CFIF baserootdir IS origroot CFIF (#ListFind(home_path,#baserootdir##name#)# GT 0) CFTREEITEM DISPLAY=#name# -- Date: #datelastmodified# VALUE=#type##baserootdir##name# IMG=folder PARENT=#baserootdir# /CFIF CFELSE CFTREEITEM DISPLAY=#name# -- Date: #datelastmodified# VALUE=#type##baserootdir##name# IMG=folder PARENT=#baserootdir# /CFIF CFELSE CFIF #baserootdir# IS NOT #origroot# CFTREEITEM DISPLAY=#name# -- Date: #datelastmodified# -- Size: #size# bytes VALUE=#type##baserootdir##name# IMG=document PARENT=#baserootdir# /CFIF /CFIF /CFLOOP /CFTREE /TD TD valign=top align=left INPUT TYPE=radio NAME=afunction VALUE=Change Directory onClick=listTypeChangeDirectory()Change Directory BR INPUT TYPE=radio NAME=afunction VALUE=Add New Sub-Directory onClick=listTypeNewDirectory()Add New Sub-Directory P INPUT TYPE=radio NAME=afunction VALUE=Upload File onClick=listTypeUploadFile()Upload File BR INPUT TYPE=radio NAME=afunction VALUE=Bulk Upload Files onClick=listTypeUploadFile()Bulk Upload Files BR INPUT TYPE=radio NAME=afunction VALUE=Rename File onClick=listTypeRenameFile()Rename File BR INPUT TYPE=radio NAME=afunction VALUE=Delete File onClick=listTypeDeleteFile()Delete File P INPUT TYPE=radio NAME=afunction VALUE=Refresh File Structure onClick=listTypeChangeRefreshFileStructure()Refresh File Structure BR INPUT TYPE=radio NAME=afunction VALUE=Sort By Name onClick=listTypeSortByName()Sort By Name BR INPUT TYPE=radio NAME=afunction VALUE=Sort By Date onClick=listTypeSortByDate()Sort By Date p INPUT TYPE=submit VALUE=Submit cfoutputINPUT TYPE=hidden NAME=baserootdir VALUE=#baserootdir#/cfoutput INPUT TYPE=hidden NAME=kilobyte VALUE= INPUT TYPE=hidden NAME=listType VALUE= /TD /TR /TABLE /CFFORM !--- end of border table --- /td /tr /table /td /tr /table CFSET pageno =26 CFINCLUDE template=../templates/pocfooter.cfm /CENTER /BODY /HTML Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Monday, June 10, 2002 1:20 PM To: CF-Talk Subject: I am sooo confused!! I have included a file we are trying to change and the file at one point has this code and we are wondering if anyone has seen this before and what it may be calling? CFFORM NAME=theform ACTION=uploadmainbutton.cfm?RequestTimeout=cfoutput#application.timeout# /cfoutput onSubmit=return validateSubmit(_CF_this.__CFTREE__theform__webserver.value) Begin full file here __ 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: I am sooo confused!!
Yes it does and we were wondering what the double underscore was for and what it may be calling. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:33 PM To: CF-Talk Subject: RE: I am sooo confused!! Does it use the CFTREE Java Applet? It looks like some kind of form verification for a cfform cftree object. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 2:20 PM To: CF-Talk Subject: I am sooo confused!! I have included a file we are trying to change and the file at one point has this code and we are wondering if anyone has seen this before and what it may be calling? CFFORM NAME=theform ACTION=uploadmainbutton.cfm?RequestTimeout=cfoutput#application .timeout# /cfoutput onSubmit=return validateSubmit(_CF_this.__CFTREE__theform__webserver.value) Begin full file here __ 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
MY recipe Database
I have created a application that will allow for an insertion of recipes the only problem I am running into is I want the user to be able to put in the amount of Ingredients and am not sure how to identify the amount with the Ingredient. I have the ingredients go into the table as a value list so How would I create it so that the amount goes with which ingredient. I am using access and CF 5. I have one table but do not object to using 2 or more tables what would be the best way to do this? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: MY recipe Database
I want then to be able to enter all information from one screen to make it more user friendly, but I mean I don't want the to submit then submit until all ingredients are added. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 8:16 AM To: CF-Talk Subject: Re: MY recipe Database Steven, Depends on how much work you want to do. Are you just going to allow a text blob for the full ingredient(indicates one table) or do you want the user to type in / add an ingredient at a time (indicates 2 or more tables)? ~Todd On Thu, 6 Jun 2002, LANCASTER, STEVEN M. (JSC-OL) (BAR) wrote: I have created a application that will allow for an insertion of recipes the only problem I am running into is I want the user to be able to put in the amount of Ingredients and am not sure how to identify the amount with the Ingredient. I have the ingredients go into the table as a value list so How would I create it so that the amount goes with which ingredient. I am using access and CF 5. I have one table but do not object to using 2 or more tables what would be the best way to do this? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: LDAP/Active Directory
I have a guy here at work working on an LDAP server (brand New) I will get some info from him and pass it along to you. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 4:15 PM To: CF-Talk Subject: LDAP/Active Directory Does anyone have links to good resources for using Active Directory through LDAP? I am doing some work on this now, I have the tutorial out on the MM site, but I am also looking for anything I should look out for? Pitfalls people? TIA :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net __ 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: IE 6.0 Bug ... style sheet bug ... looking for workaround
Have you checked MS site for a possible fix? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:48 AM To: CF-Talk Subject: RE: IE 6.0 Bug ... style sheet bug ... looking for workaround Tried that... and a zillion other things too. ;-( Are you running IE 6.0 and see the problem?? At 11:09 PM 6/2/02 -0700, you wrote: Brian, Try adding a pound sign before the rgb color value. background: #66; Robert -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 02, 2002 12:28 PM To: CF-Talk Subject: IE 6.0 Bug ... style sheet bug ... looking for workaround I just installed a large project on a site that is used exclusively with IE 6.0 and suddenly some very simple text is not displaying inside forms. So I hit it with IE 5.5 and all is OK. I am having trouble with Free Form text that floats above Select Boxes not displaying unless I drag the scroll bar to force IE to repaint the screen... the text is there, but not displayed until the scroll bar drag forces IE to repaint the section as it comes into view a second time... THIS ONLY happens above the FIRST Select Box on the page. I jerked the .css file and put 1 style sheet tag into the header section to demonstrate the problem. Removing the 'background: 66' from the style sheet solves the problem at the expense of the entire site design. Pulled most of my hair out by now. You can reproduce this BUG with this simple html code below... if you are running IE 6.0 Any Ideas?? what a workaround might be?? Once again, thanks for Looking at this. ~Brian -- -- html head style type=text/css !-- FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif; font-size : 11px; background : 66; border : thin outset } -- /style /head body leftmargin=0 topmargin=0 table width=100% cellspacing=0 tr td brADDING ITEM DETAIL - CHOOSE A PART TYPE form name=PartTypeSelect action=index.html method=POST brstrongSelect Part Type/strongbr Select name=PartType_ID size=6 align=left onclick=this.form.submit() Option value=3BACKLIGHT/Option Option value=5MILLENIA/Option Option value=4TETRUS/Option Option value=2TSUNAMI/Option /SELECT br /form form action=index.html method=post input name=Submit type=Submit value=Cancel Action /form form name=PartSelect action=index.cfm method=POST input name=PartType_ID type=Hidden value=2 strongSelect Part/strongbr Select name=Part_ID size=6 align=top onclick=this.form.submit() Option value=2THE FIRST PART NUMBER A THE FIRST PART NAME/Option Option value=3TSV C TSUNAMI-VITEX/Option /SELECT /form br /td /tr /table /body /html -- here it is again -- Perhaps this Exclaimed one (!) one is a readable copy if the first one formats and displays as a web document in your Email reader. !html !head !style type=text/css !-- FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif; font-size : 11px; background : 66; border : thin outset } -- /style /head !body leftmargin=0 topmargin=0 table width=100% cellspacing=0 tr td brADDING ITEM DETAIL - CHOOSE A PART TYPE form name=PartTypeSelect action=index.html method=POST brstrongSelect Part Type/strongbr Select name=PartType_ID size=6 align=left onclick=this.form.submit() Option value=3BACKLIGHT/Option Option value=5MILLENIA/Option Option value=4TETRUS/Option Option value=2TSUNAMI/Option /SELECT br /form form action=index.html method=post input name=Submit type=Submit value=Cancel Action /form form name=PartSelect action=index.cfm method=POST input name=PartType_ID type=Hidden value=2 strongSelect Part/strongbr Select name=Part_ID size=6 align=top onclick=this.form.submit() Option value=2THE FIRST PART NUMBER A THE FIRST PART NAME/Option Option value=3TSV C TSUNAMI-VITEX/Option /SELECT /form br /td /tr /table /body /html __ 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: CFCOMET - can't access site
I got the error: No website configured at that address.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Peter Lutwyche [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 10:03 AM To: CF-Talk Subject: CFCOMET - can't access site Anyone know of any reason why www.cfcomet.com would not be available. Haven't been there for a while but keep getting a 404 today. Regards Pete Lutwyche Website: http://www.mourant.com The information in this email is confidential. The contents may not be disclosed or used by anyone other than the addressee. If you are not the intended recipient, please notify us immediately at the above E-mail address or telephone +44 1534 609000 We cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. If you suspect that the message may have been intercepted or amended, please call the sender. If this message includes attachments, please ensure they are opened within the relevant application to ensure full receipt. If you experience difficulties, please refer back to the sender. __ 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 parsing problem
I think the Key word here is ONLINE. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: nagraj [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:41 AM To: CF-Talk Subject: Re: cffile parsing problem Hi , If you just want to export the file to Access manually you can use import feature of Access It will ask where you follow the wizard will help you to export the text file data to Access table later you can import the data to appropriate table. Regards Nagaraj.A - Original Message - From: Seamus Campbell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 8:22 PM Subject: cffile parsing problem Hi all I have a txt file (I cannot change the format) which I want to insert/update into an access database online. I've been trying to read the file using CFFILE but cannot parse it properly This is the file: SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden,CLYNE DENSEY,23.95,1,TP,, SUS,CATTLE,0882660667,Family Cow,VAN LOON DIRK,29.95,2,PB,, SUS,CATTLE,0911311688,Natural Cattle Care ACRES USA ED,COLEBY PAT,49.50,0,TP,, SUS,COMPOS,0670904678,Australian Self Sufficiency Ha,SMITH KEITH,39.95,0,TP,1992, SUS,CONIFE,1876473312,Gardening With Conifers,BLOOM ADRIAN,42.90,0,HB,2001, SUS,COOKIN,0732265517,Best of Jackie French,FRENCH JACKIE,24.95,1,TP,, SUS,COWSMI,086417120X,Keeping a Cow,WILSON JIM,0,0,TP,1987, I don't know how to get rid of the last comma in each line, and then how to parse with a blank line between each record. I've tried this CFFILE action=READ file=D:\InetPub\wwwroot\_Candelo\database\candeloweb1603.txt variable=Candelo !--- Set a variable to hold the ascii values for a line break and a carriage return --- CFSET new_line=Chr(10) Chr(13) !--- Loop thru lines of text --- CFLOOP index=i list=Candelo delimiters=new_line cfoutput#Candelo#/cfoutputBR /CFLOOP and get this (but repeated three times!) SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden,CLYNE DENSEY,23.95,1,TP,, SUS,CATTLE,0882660667,Family Cow,VAN LOON DIRK,29.95,2,PB,, SUS,CATTLE,0911311688,Natural Cattle Care ACRES USA ED,COLEBY PAT,49.50,0,TP,, SUS,COMPOS,0670904678,Australian Self Sufficiency Ha,SMITH KEITH,39.95,0,TP,1992, SUS,CONIFE,1876473312,Gardening With Conifers,BLOOM ADRIAN,42.90,0,HB,2001, SUS,COOKIN,0732265517,Best of Jackie French,FRENCH JACKIE,24.95,1,TP,, SUS,COWSMI,086417120X,Keeping a Cow,WILSON JIM,0,0,TP,1987, Can anyone give me some clues or help please Many thanks Seamus __ 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: installing PHP with CF on Win2K server
I have installed PHP on a server thought I was not running SQL Server 2000. If you have plenty of resource then it should be fine, but there are a few things you will run into. 1) it does not seem to set it up in IIS so that it recognizes that it needs to use the PHP interpreter for those files. 2) If you install on one drive and have IIS on another it seems to have a problem finding the interpreter. Those were the only probelms I ran into and also PHP took a lot of resources if all that is on the same box.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:56 PM To: CF-Talk Subject: installing PHP with CF on Win2K server I've been developing quite happily with CF for a while now, using Access and SQL Server on our Win2K Server development box. Thinking of branching out into PHP, with mySQL, and just wondering about the server setup as it gets more complex: Can PHP4, CF5 (developer edition), mySQL, SQL Server 2000 (developer edition), all coexist happily with IIS 5 on a Win2K Server box? Can't see a reason why not, but this is going beyond my knowledge, so thought I'd check to see if there are any pitfalls to watch out for! cheers, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Populating the body of an outlook message
Is CFMAIL not an option. If it is you can do whatever you want through CFMAIL.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 12:45 PM To: CF-Talk Subject: Populating the body of an outlook message Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [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: Apologies
I am having the same problem.. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 3:03 PM To: CF-Talk Subject: RE: Apologies My apologies for my recent barage of the same question (OT: Adding Properties to Form elements?). The list sent me messages saying (1) it was too big, and (2) I had a signature block that appeared I was going on vacation. I didn't think the message made it through. I just got the same messages after I posted, for some reason. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dynamic image
I want to create an image and make the text on the image dynamic, but I am not sure where to start.. Anybody have a suggestion? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic image
The layers worked great! Thanks Bryan Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 12:05 PM To: CF-Talk Subject: RE: dynamic image You could do it with layers and Javascript. Just put a layer containing text over the top of the image. +---+ 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: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:38 AM To: CF-Talk Subject: dynamic image I want to create an image and make the text on the image dynamic, but I am not sure where to start.. Anybody have a suggestion? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: Online CSS editors ?
I would like to see it work and maybe use it myself.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:35 AM To: CF-Talk Subject: Re: Online CSS editors ? Any chance we see this? At 10:59 AM 5/21/2002 -0400, you wrote: James I am looking for a way that I can allow site admins to edit CSS styles to effect the look of a site, or page etc. It needs to be edited online. Basically I want soEditor but for editing CSS styles instead of html :-) Anybody seen anything like this around ? Yes, I have one I built, drop me a line if you're still looking. Nick __ 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: Shopping cart
Look at Web monkey's shopping cart it also go over the basics of building that shopping cart.. also there is one in the 4.0 WACK I am not sure about the 5.0.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:35 AM To: CF-Talk Subject: Shopping cart I just started work for a company that is using CF mainly, but has a ASP shopping cart. Does anyone know of an open source shopping cart done in CF that is pretty good? Douglas Brown Email: [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
Inserting into 2 tables with a relationship
I have a database with 2 tables one has a relationship with the other and when I do an insert I need to insert into table 1 and insert into table 2 with an var_id field that has not been generated until table 1 has been inserted into.. I am not sure what to do or how to do it.. I am using CF 5 and Access.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting into 2 tables with a relationship
The problem I am having is that it adds the variable to the field, but it won't update the var_id that has the relationship with the main table it adds a 0 in the field.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Donnie Bachan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:53 AM To: CF-Talk Subject: Re: Inserting into 2 tables with a relationship Use CFTRANSACTION so if the action fails you can rollback. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ 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: test
got it Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 1:34 PM To: CF-Talk Subject: Re: test Got it ... :) Paul Giesenhagen QuillDesign test Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.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: Query Tool Set (was: Left Outer Join - Lotsa Pain!)
You can use MSQuery. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:48 PM To: CF-Talk Subject: Query Tool Set (was: Left Outer Join - Lotsa Pain!) I'd love to use a Query tool - but I think the MS Access tool is tough to work with. Drawing lines and connectors is easy enough, but editing row attributes I think is counterintuitive. I can't seem to get rid of a row if I make a mistake unless I start over entirely - can't seem to delete a row. Anyone have any suggestions on other Query Builder tools that they like? I'd like to use the one included with CF 5, but every time I run a query, it crashes my machine and eats all the memory. Thanks, Mark -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:47 PM To: CF-Talk Subject: 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
cookie problem
I have a cookie holding a value like useraccess_id's but the problemr I am running into is that my cookie can hold a value like (23,4) I need to break this down to one value and reset the cookie with that value. How do I do that? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cookie problem
Doing the CFSET did the trick thanks!! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:51 PM To: CF-Talk Subject: RE: cookie problem What do you mean? Reset the whole thing, or part of it? You should be able to handle it as a list: !--- change to 23,5 --- cfset cookie.value = listSetAt(cookie.value, 2, 5) --- Billy Cravens Web and Software Consulting www.Architechx.com -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:45 PM To: CF-Talk Subject: cookie problem I have a cookie holding a value like useraccess_id's but the problemr I am running into is that my cookie can hold a value like (23,4) I need to break this down to one value and reset the cookie with that value. How do I do that? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: double post: access2000 on unix. Is it even possible??
What about exporting to a MySQL database and using that, it is pretty comparable to Access as far as databases go.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 11:47 AM To: CF-Talk Subject: double post: access2000 on unix. Is it even possible?? Hello, This might be a stoopid question (in fact i'm pretty sure it is) but I have always worked with NT servers up to now. I want to port a site over to a unix server. The backend DB is Access2000. Are there ODBC drivers for Access on Unix? Can I do this, or do I need to upgrade to SQL server? Cheers Will __ 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
PowerPoint on the home page of HOF
I need to know to place a .ppt on a website like on the HOF homepage do I need to do something special? I have a .ppt and it is driving me crazy it either opens real slow or times out or It will open PowerPoint itself. I can not get to work like it works on HOF. Is there something I am missing? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Work around fro LDAP
I am wanting to run the RDS service, but we do not have an LDAP server we are on a UNIX box is there anyway we can work around the problem so we can run RDS? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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: Work around fro LDAP
I ma having to install RDS and we currently have NES, but when you try to install RDS it asks for the IP of the LDAP server. Since we do not have one How do I work around that? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Tim Heald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 2:39 PM To: CF-Talk Subject: RE: Work around fro LDAP If you are using basic security you can just use a password, no login. If you are using advanced security then CF 5 can authenticate to LDAP, or SQL. Tim Heald ACP/CCFD Application Development www.schoollink.net -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 3:20 PM To: CF-Talk Subject: Work around fro LDAP I am wanting to run the RDS service, but we do not have an LDAP server we are on a UNIX box is there anyway we can work around the problem so we can run RDS? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Make last line of query available
Help, I know this is probably a silly question but I can not find how to point at the last record in this query. I would like to make the last value for triptrav_seq,value is currently 41456 for this query, available for use. Is there a method to point to the last record of an ordered query and make the variable triptrav_seq available I would appreciate any input you can give. CFQUERY NAME=revquery datasource=#application.issrtd# SELECT rev, triptrav_seq, rownum FROM rtd_triptrav WHERE rtd_trip_id = '#trip_id#' Order by rtd_triptrav.rev /CFQUERY A 1 40777 A 2 40778 A 3 40779 A 4 41456 Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: Payment terms
In the past when I have done terms I have given net 15 and after 90days they can move to a net 30 as long as there were no late payments. I do that just to get to know someone and there payment habits.. 8) Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 2:39 PM To: CF-Talk Subject: RE: Payment terms I don't know if this helps but this is the way we usually do things. Short term projects(a few weeks): 50% up front the rest at completion Long term projects(around 2 or more months): 1/3 up front, 1/3 around mid way through and the rest at completion. Phillip -Original Message- From: Dirk Sieber [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 2:24 PM To: CF-Talk Subject: OT: Payment terms Hi everyone, This is a little off-topic, but I'm hoping some of you might be able to give me some good advice. I'm going to be entering in a formal agreement to perform some enhancement/bug fix work for a client on a casual, but ongoing basis, and they're asking me for my payment terms. Now, in the past, I've either always been paid COD, or been someone's employee, so this is a bit new to me. :) I'd welcome comments on what everyone thinks is a 'fair' amount of time for payment. My first thought was 1 week from delivery for bug testing - if nothing is reported in that week, the client is assumed to have signed off on the work (if they don't do so sooner), and payment is due within 30 days. Thoughts? Comments? Thanks! Dirk __ 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
RDS and CF Studio 4.5.2
Does anyone know where I can get more info. on RDS so that I can make a presentation next week? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RDS and CF Studio 4.5.2
How it works, What it can do, What kind of access it allows (possible security issues), Database connectivity, Anything and Everything... Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 6:45 AM To: CF-Talk Subject: RE: RDS and CF Studio 4.5.2 What kind of info are you wanting? Ken -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 7:33 AM To: CF-Talk Subject: RDS and CF Studio 4.5.2 Does anyone know where I can get more info. on RDS so that I can make a presentation next week? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RDS (Second Post)
I need to find out everything there is to know about RDS for a presentation I have to give next week. Can anyone tell me where to look.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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
HELP!!! Date problems
I have a database with holiday dates in it. I have a date (duedate) and I want to see if duedate has a holidaydate between now and duedate. I also want to see if the duedate lands on a holiday. If there is a holiday then I want to subract 1 day from duedate. Shouldn't this give me what I need? CFLOOP QUERY=GetHolidaydate CFIF ((DateCompare(DATEDUE, #CreateOdbcDate(holiday_date)#) IS 1) AND (DateCompare(NEWDATE, #CreateOdbcDate(holiday_date)#) IS -1)) OR (DateCompare(DATEDUE, #CreateOdbcDate(holiday_date)#) IS 0) CFSET NEWDATE3 = #DateAdd('D', -1, DATEDUE)# /CFIF CFIF DAY IS Sunday CFSET DATEDUE = #DateAdd('D', -2, DATEDUE)# /CFIF CFIF DAY IS Saturday CFSET DATEDUE = #DATEADD('D', -1, DATEDUE)# /CFIF !--- QUERY FOR A HOLIDAY COUNT --- CFQUERY DATASOURCE=#application.lldbDatasource# name=GetHolidayCount select count(1) hlday_cnt from ll_holiday where #CreateOdbcDate(holiday_date)# = #CreateODBCDate(DATEDUE)# /CFQUERY CFIF GetHolidayCount.hlday_cnt EQ 1 CFSET DATEDUE = #DATEADD('D', -1, DATEDUE)# /CFIF /CFLOOP Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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: HELP!!! Date problems (RE-Post)
Nobody answered so I thought I would ask if someone has an answer? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Wednesday, April 03, 2002 7:33 AM To: CF-Talk Subject: HELP!!! Date problems I have a database with holiday dates in it. I have a date (duedate) and I want to see if duedate has a holidaydate between now and duedate. I also want to see if the duedate lands on a holiday. If there is a holiday then I want to subract 1 day from duedate. Shouldn't this give me what I need? CFLOOP QUERY=GetHolidaydate CFIF ((DateCompare(DATEDUE, #CreateOdbcDate(holiday_date)#) IS 1) AND (DateCompare(NEWDATE, #CreateOdbcDate(holiday_date)#) IS -1)) OR (DateCompare(DATEDUE, #CreateOdbcDate(holiday_date)#) IS 0) CFSET NEWDATE3 = #DateAdd('D', -1, DATEDUE)# /CFIF CFIF DAY IS Sunday CFSET DATEDUE = #DateAdd('D', -2, DATEDUE)# /CFIF CFIF DAY IS Saturday CFSET DATEDUE = #DATEADD('D', -1, DATEDUE)# /CFIF !--- QUERY FOR A HOLIDAY COUNT --- CFQUERY DATASOURCE=#application.lldbDatasource# name=GetHolidayCount select count(1) hlday_cnt from ll_holiday where #CreateOdbcDate(holiday_date)# = #CreateODBCDate(DATEDUE)# /CFQUERY CFIF GetHolidayCount.hlday_cnt EQ 1 CFSET DATEDUE = #DATEADD('D', -1, DATEDUE)# /CFIF /CFLOOP Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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
HAPPY EASTER!!!
I am working from 6am this morning until tomorrow about 4pm, but I am taking Sunday off (Day Off WOOO HOO!!). Everybody have a Happy Easter!!! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: CF/Database Help
Dave, I have seen some of your other comments and I think I get more impressed with your thinking everytime you make a comment. I too believe in Data normalization. One of the problems that I am running into now is that on the project I am on the data is denormalized and the client (NASA) wants to keep using the existing database with existing data. I am making some major changes that will help but not fix the problem. If they want even more functionality than they have now it will be almost impossible with database built the way it is. The worst is the implied foreign key.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 5:05 PM To: CF-Talk Subject: RE: CF/Database Help Is there any particular reason why ONE table wouldn't do the trick just fine? Title (varchar 255) Recipe (long text) or break it out to maybe refine ingredient searches and get a little fancier: ShortDescr (long text) Ingredients (long text) Method (long text) KeyWords (varchar 255) If all the guy wants to do is type in his recipes and find them again, or search for all recipes which contain chili peppers, wouldn't this be simpler for him to maintain and deliver the same functionality? Denormalized data is almost always a very bad thing, and would be in this case, as well. There are all kinds of problems with storing a list of items in a field; what will the user do when he wants to find out what ingredients he needs to buy that week, or wants to find all the recipes that contain paprika? Sure, you could build workarounds to allow both of those, but that's all they'd be - workarounds. They'd cause their own problems, and would require more code to provide the same functionality. There are all kinds of things that can go wrong with denormalized data: - data will be duplicated, so the database will be unnecessarily large - duplicated data may be incorrectly entered - searches will be less efficient - in your example, you'd have to search a long text field to match ingredients! - the database won't scale well - what if your chef has more than a couple of hundred recipes? I'm just taking this from the user's side rather than the programmer's. Would you be making a highly capable system whose elegance is lost on a user when he has to pick one ingredient from a drop-down list of 200 (and populate that list himself when he needs a new ingredient not on the list)? I'm just suggesting that the user should have options put before him: expandability/capability vs. simplicity/usability, and let him decide. Then you build based on informed consent. These are UI issues, not database design issues. All of them can be solved relatively easily, without compromising the normalization of data. In addition, having that normalized data allows you to provide more functionality, and have fewer bugs and glitches, and in the long run, things will simply work better. I realize that my argument may not be especially convincing to you, but until you've run into these sorts of problems enough, the path of denormalization may look very attractive. Unfortunately, it's easy going down that path, but hard to get back. I've seen this sort of thing a lot with projects which start small, then get bigger. In any case, the programmer should be on the user's side - they're not supposed to be antagonists. The best solution for the user is one that's easy to use, but also robust and reliable. It's up to the programmer to deliver that solution. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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
Clearing a form or Reset button only for new information
I have a form that has a submit button and A reset button. I populating the fields with info from a database and I only want them to be able to clear any new information that they type in, but not the info they are pulling in from the database.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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: Clearing a form or Reset button only for new information
Yeah! I got I'll show you what I did: INPUT TYPE=button NAME=submitButton VALUE=Clear Entries onClick=clearEntries(document.#formName#) Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Friday, March 29, 2002 7:29 PM To: CF-Talk Subject: Clearing a form or Reset button only for new information I have a form that has a submit button and A reset button. I populating the fields with info from a database and I only want them to be able to clear any new information that they type in, but not the info they are pulling in from the database.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and EBAY
Me too!! Me too!! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:40 AM To: CF-Talk Subject: RE: CF and EBAY I'd be interested as well. Thanks. Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:35 PM To: CF-Talk Subject: RE: CF and EBAY I'm interested as well. thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:20 PM To: CF-Talk Subject: RE: CF and EBAY Can the rest of us see? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 3:19 PM To: CF-Talk Subject: Re: CF and EBAY I wrote one of those two. It goes a step further and grabs all the bidders on the matching auctions... Very evil. ;) I have an agent that takes a search term and an optional category and searches for all items of that type. Would that do? I also did a little with an ebay agent in my HTTPAgent lecture from one of the conferences. Should be on the front of HoF. At 06:27 PM 3/26/02, you wrote: Does anyone know if any tags exist that grab a sellers auctions form ebay? I thought I would ask before trying to do this myself... no sense in reinventing the wheel. Thanks, Mike __ 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: Office on Solaris?
You can do exports to Excel and Word on Solaris. We do it and we do not have Office setup on the server. You can create or I know there are some custom tags out there. Once you export it opens Excel or Word on there desktop. That is one way of doing it. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:21 AM To: CF-Talk Subject: Office on Solaris? I'm wondering if it's possible to do exports to Excel, Word, etc. on Solaris? I know that Office has to be installed on the server to do this kind of stuff, but do COM objects, etc. work on Solaris? Is there an Office for Solaris to begin with? I don't know much about Solaris, and I've searched CFComet with no luck on the issue. If you can't use Office, are there alternatives for a Solaris environment? I currently export to excel by giving an html file and xls extension, but I need more functionality (i.e., sorting columns, datatypes, etc.) than that trick provides. Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ 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: Hypothetical SQL question
Hope this helps :) cfset goodgrade = A CFQUERY name=getgradeA datasource=datasource Select Distinct people.people, grades.grades FROMgrades, people Where people.people_id = grades.people_id AND grades.grades = '#goodgrade#' /CFQUERY Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:32 AM To: CF-Talk Subject: Hypothetical SQL question Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle version of TOP
My Oracle Guy says you can do a where CURRVAL is and NEXTVAL is.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:11 PM To: CF-Talk Subject: OT: Oracle version of TOP Sorry for the OT, but do any of you know the Oracle function for selecting the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL). Thanks! Scott -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ 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
Returning only one record HELP PLEASE!!!!
I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: Returning only one record HELP PLEASE!!!!
with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAMECOLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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: Returning only one record HELP PLEASE!!!!
query2 can output up to 7 records.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Sharon DiOrio [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:24 PM To: CF-Talk Subject: Re: Returning only one record HELP PLEASE OK, is query2 only *supposed* to be outputting one record? I don't think you need to group the first query: CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test QUERY=query1 #column1# nbps; #query2.column2# /CFMAIL Sharon DiOrio - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 1:02 PM Subject: RE: Returning only one record HELP PLEASE I am not allowed to post data. but what I put out is very close to what I have.. I have multiple records in both tables and query2 is only outputting one record. cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAME COLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk
RE: Returning only one record HELP PLEASE!!!!
yes Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:23 PM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE At 12:02 PM 3/26/02 -0600, LANCASTER, STEVEN M. (JSC-OL) (BAR) wrote: cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery If you just do this: CFOUTPUT Query=Query2 BR #Column12, #column22# /CFOUTPUT Do you get multiple records? CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- You could do something like this: Create a new file called Query2loop.cfm looking like this: CFOUTPUT Query=Query2 #Column22$ Then do CFOUTPUT Query=query1 group=column1 CFMAIL #column1# CFINCLUDE template=Query2Loop.cfm /CFOUTPUT That way it'll loop through the first query and then do a nested loop through the second. T __ 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: Returning only one record HELP PLEASE!!!!
you can't when you have nested tags. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Albrechtas, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:14 PM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE Get rid of the group parameter of your cfoutput -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 1:02 PM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I am not allowed to post data. but what I put out is very close to what I have.. I have multiple records in both tables and query2 is only outputting one record. cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAMECOLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Xpplication.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning only one record HELP PLEASE!!!!
Actually after I get the result which are dates I take the dates from query1 and put up against the dates in query2, but query1 returns all the dates I need query2 returns only one result, but if I go outside the cfoutput tags and use query=query2 attribute on the cfoutput it will return the right amount of results, but I just can't find a way to do it in the cfouput statement that I have. I tried an array and a list function neither one worked.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Sharon DiOrio [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:39 PM To: CF-Talk Subject: Re: Returning only one record HELP PLEASE OK, so are the results in query2 dependent upon what's returned in query1 or is it just listing the query results everytime? Sharon - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 1:24 PM Subject: RE: Returning only one record HELP PLEASE query2 can output up to 7 records.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Sharon DiOrio [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:24 PM To: CF-Talk Subject: Re: Returning only one record HELP PLEASE OK, is query2 only *supposed* to be outputting one record? I don't think you need to group the first query: CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test QUERY=query1 #column1# nbps; #query2.column2# /CFMAIL Sharon DiOrio - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 1:02 PM Subject: RE: Returning only one record HELP PLEASE I am not allowed to post data. but what I put out is very close to what I have.. I have multiple records in both tables and query2 is only outputting one record. cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAME COLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED
RE: Returning only one record HELP PLEASE!!!!(Solved)
That Worked Thank You!! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:39 PM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE It is not progressing through the second query, only the first. Do you want each mail message to contain all of the data in for Column22 in the second query? If so, then you would need to loop over that query and output each record - separately from the top-level CFOUTPUT (as that pertains only to the first query). CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; cfloop query=query2 #query2.column22# /cfloop /CFMAIL /CFOUTPUT Note that in this case, you may or may note need the GROUP attribute. Using it in the case would result in output with a sort-of DISTINCT group of COLUMN1 values. Hope this helps. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:32 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE you can't when you have nested tags. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Albrechtas, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:14 PM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE Get rid of the group parameter of your cfoutput -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 1:02 PM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I am not allowed to post data. but what I put out is very close to what I have.. I have multiple records in both tables and query2 is only outputting one record. cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAMECOLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Xpplication.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED
RE: CF 5 Support for Oracle 9i
I know there are some security issues Check out cert.org.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Deborah Curley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:31 PM To: CF-Talk Subject: CF 5 Support for Oracle 9i Hi All, My company is interested in upgrading some of our Oracle 8.x databases to 9i. I don't see any mention of ColdFusion 5 support for 9i and just wanted to get the official word on whether or not it is supported. If it is supported are there any known issues? TIA! Deb _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ 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
Business days from Dates PLEASE HELP!!!!
I have a Database it has a date in one of the columns. I take that date and another column in the table which is just an integer an use the DateAdd function to come up with a second date. I have: date1, duedate(created from the DateAdd function), days_until_it_is_due Now I need to give these people X amount of business days based on days_until_it_is_due to come up with a proper due date. Can anyone please help me or tell me where to start.. Steven Lancaster __ 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
Multiple File Upload
I need to have a multiple file upload. I know if I want to do one file I can use CFFILE, but how do I do more than one. Steven Lancaster __ 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
CF admin password
I am on a Unix System running Apache and I need to reset the CF Admin password for CF 4.5 because it was forgotten can someone tell me how to do this. Please email me off list. Steven Lancaster __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF JS Menus
Here is a tutorial that Macromedia gave me about a year ago. check it out and see if you can use it.. http://www.projectseven.com/tutorials/menuing/mcloser/index.htm -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 6:52 PM To: CF-Talk Subject: Re: CF JS Menus Thanks Shawn. This is for a school project I am putting together..so free is what I am looking for. I'd like to get into DHTML, Javascript, and DOM more, but with graduation coming up, I just dont have time right now... so anyone reading this..any free menus would be great. I am looking for something that I can use with CF. I have a query that grabs the main categories and then loops around another query passing in the main catid to get the sub cats and thus I get the info needed to give the javascript to generate the menus.. I have on working in some versions of NS and all IE but need it to work in IE4+, NS4.08+. Thanks for any links.. advice, help.. much appreciated. Mike - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 7:48 PM Subject: RE: CF JS Menus Hiermenus is now charging for licensed use. And their prices are pretty extreme. I checked into this in January sometime - it was something like $500 if your site had less than 20 pages, $900 if it was between 20 and 40 pages, and $1500 if you had more than 40 pages. After doing some checking around, there are some very good systems out there that are much less (free even), and meet or exceed Hiermenus' capabilities. Unfortunately, I don't have the links with me I'll see if I can dig them out tonight... Shawn Grover -Original Message- From: Chuck McElwee [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:23 PM To: CF-Talk Subject: RE: CF JS Menus You might also want to check out http://www.webreference.com/dhtml/hiermenus/ Chuck McElwee etech solutions inc www.etechsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:37 PM To: CF-Talk Subject: Re: CF JS Menus We have a very solid script that is very compatible with many browsers. http://www.quilldesign.com/popupmenupro/index.cfm Drop in and check it out... Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder Hello Everyone. I have been playing with the IE DOM and NS DOM for the past two weeks, and decided to ask if anyone knows of any good JS menu scripts that looks nice and work in IE4+, NS4.08+? I would appreciate any links or advice. Mike __ 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
test
test __ 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: Database locked by admin?
While using Access you may want to set you session variables for a shorter period of time, so that when CF accesses the database it will also let go in a short amount of time. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 2:57 PM To: CF-Talk Subject: Re: Database locked by admin? I am getting an error message about my database being locked by 'admin' and was wondering if anyone out there has any suggestions: Message: ODBC Error Code = S1000 (General error)P Native error code: -1102 SQLState: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'MYMACHINE'.PPData Source = mydatasourceP In the archives I found that this may be because the database is corrupt -- I've run the compression/correction option on it (MS-Access database), but this keeps happening. The database this error occurs on is my visitors log -- for every page hit I write out a record w/ the HTTP referrer, USER_AGENT, date/time, etc. The website isn't high-volume at all (i.e. averaging around 1000 page hits/day), but when these errors come up IS when there are a relatively large number of page requests (for this website) within a short period of time. ODBC problem? MDAC? Need to upgrade to SQL server? :) First off, I would highly recommend against using Access in a production environment. While 1000 hits/day isn't exactly Amazon.com volume, that's a respectable number and you should consider looking into an upgrade to a RDBMS such as SQL Server. The problem with access is that only one person may access (no pun intended) the DB at a time because an Access database is by default set up to be opened exclusively. So if two people concurrently try and hit the database, Access will lock the other user out -- hence your error. I doubt it's a corruption thing, although I don't know what your DB looks like either. Make sure nobody has the database open in the Access program itself. This also causes an exclusive lock that will prevent others from accessing it. But, again, if you're at 1000 hits/day and that number may go up, I would highly recommend looking into a more suitable solution such as SQL Server, MySQL, Oracle, etc. Regards, Dave. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSELECT Problems
I have a CFSELECT statement and I want have the user click on and if they change there mind be able to click off the value with out having to hit like a clear or reset button. Is there anyway in CF 4.5 to use a value like value=. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Second Post CFSELECT Problems
Does anybody have any advice? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Monday, March 18, 2002 10:07 AM To: CF-Talk Subject: CFSELECT Problems I have a CFSELECT statement and I want have the user click on and if they change there mind be able to click off the value with out having to hit like a clear or reset button. Is there anyway in CF 4.5 to use a value like value=. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [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: Second Post CFSELECT Problems
Thanks Mike, I worked over 52 hours since Friday. I can barely think of what my name is... Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 11:43 AM To: CF-Talk Subject: RE: Second Post CFSELECT Problems Steve, Set your cfselect up.. then just add the following between the opening and closing tag. option value=0/option so, you'd have cfselect...option value=0 selected/options/cfselect substitute anything you want for 0. Mike -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 12:46 PM To: CF-Talk Subject: RE: Second Post CFSELECT Problems Does anybody have any advice? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Monday, March 18, 2002 10:07 AM To: CF-Talk Subject: CFSELECT Problems I have a CFSELECT statement and I want have the user click on and if they change there mind be able to click off the value with out having to hit like a clear or reset button. Is there anyway in CF 4.5 to use a value like value=. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Second Post CFSELECT Problems
it worked! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 11:52 AM To: CF-Talk Subject: RE: Second Post CFSELECT Problems :-) I hear ya! I have been reading up on DOM all weekend! LOL Lemme know if that works for you. Mike -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 12:55 PM To: CF-Talk Subject: RE: Second Post CFSELECT Problems Thanks Mike, I worked over 52 hours since Friday. I can barely think of what my name is... Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 11:43 AM To: CF-Talk Subject: RE: Second Post CFSELECT Problems Steve, Set your cfselect up.. then just add the following between the opening and closing tag. option value=0/option so, you'd have cfselect...option value=0 selected/options/cfselect substitute anything you want for 0. Mike -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 12:46 PM To: CF-Talk Subject: RE: Second Post CFSELECT Problems Does anybody have any advice? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Monday, March 18, 2002 10:07 AM To: CF-Talk Subject: CFSELECT Problems I have a CFSELECT statement and I want have the user click on and if they change there mind be able to click off the value with out having to hit like a clear or reset button. Is there anyway in CF 4.5 to use a value like value=. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Trimming Duplicates
I have this query and it is returning records with the same name. I want to use a function like DISTINCT in my select statement, but I can't because I am pulling 2 field any suggestions. Basically when I put #location# it will come up with a city and right now it is coming up with it 20 times. CFQUERY NAME=getLocationQuery DATASOURCE=#application.lldbDatasource# SELECT ll_location.location_id, ll_location.location FROM ll_location, ll_lesson, ll_lessonstage WHEREll_location.location_id = ll_lesson.location_id AND ll_lesson.lessonstage_id = ll_lessonstage.lessonstage_id AND ll_lessonstage.lessonstage = '#application.migratedStr#' ORDER BY seq_no, upper(location) Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: UGH Stupid web save
I have run into something similar before.. I have CF Studio and Ultra Dev and Dream weaver installed on my home PC depending on the order in which they installed is what dictates what is associated with and .html file if I just click on it. The fix is simple check to see if the association is there if it is delete it and add an association to the program he wants to open it.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:23 PM To: CF-Talk Subject: RE: OT: UGH Stupid web save He does, that's the thing I don't understand. They both have the exact same program. When he clicks save and opens it it works fine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 3:14 PM To: CF-Talk Subject: Re: OT: UGH Stupid web save My understanding is that when it comes to viewing files outside of the browser, it depends if your PC has any programs associated with the file extension. So he probably just doesn't have any image viewer/editor installed that views tiffs. Robert Everland [EMAIL PROTECTED] 03/14/02 03:07PM I have a client who is having problems having internet explorer opening up tif files in the web browser. I know IE doesn't open TIF natively but he uses the same exact program as someone else in his office and her internet explorer asks her if she wants to open or save, his just asks if he wants to save. Where do I change this so he can hit open. He is driving me crazy, thanks in advance. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Trimming Duplicates
I have this query and it is returning records with the same name. I want to use a function like DISTINCT in my select statement, but I can't because I am pulling 2 field any suggestions. Basically when I put #location# it will come up with a city and right now it is coming up with it 20 times. CFQUERY NAME=getLocationQuery DATASOURCE=#application.lldbDatasource# SELECT ll_location.location_id, ll_location.location FROM ll_location, ll_lesson, ll_lessonstage WHEREll_location.location_id = ll_lesson.location_id AND ll_lesson.lessonstage_id = ll_lessonstage.lessonstage_id AND ll_lessonstage.lessonstage = '#application.migratedStr#' ORDER BY seq_no, upper(location) Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Trimming Duplicates
this is the error I get. MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01791: not a SELECTed expression SQL = SELECT DISTINCT ll_location.location_id, ll_location.location FROM ll_location, ll_lesson, ll_lessonstage WHERE ll_location.location_id = ll_lesson.location_id AND ll_lesson.lessonstage_id = ll_lessonstage.lessonstage_id AND ll_lessonstage.lessonstage = 'released' ORDER BY seq_no, upper(location) Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Thursday, March 14, 2002 2:20 PM To: CF-Talk Subject: Trimming Duplicates I have this query and it is returning records with the same name. I want to use a function like DISTINCT in my select statement, but I can't because I am pulling 2 field any suggestions. Basically when I put #location# it will come up with a city and right now it is coming up with it 20 times. CFQUERY NAME=getLocationQuery DATASOURCE=#application.lldbDatasource# SELECT ll_location.location_id, ll_location.location FROM ll_location, ll_lesson, ll_lessonstage WHEREll_location.location_id = ll_lesson.location_id AND ll_lesson.lessonstage_id = ll_lessonstage.lessonstage_id AND ll_lessonstage.lessonstage = '#application.migratedStr#' ORDER BY seq_no, upper(location) Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape VS IE
http://www.w3c.org might be a good place to start.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Ryan Edgar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 11:11 AM To: CF-Talk Subject: OT: Netscape VS IE Sorry for the off topic post. Does anyone know where I can find a definitive description of the differences (i.e. what will and won't work / html display differences etc...) between IE 5+ and Netscape 4.7 + TIA Ryan Edgar Certified Coldfusion 5 Developer www.biznet-solutions.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Searching a Variable
I have a variable being passed from one page to the next and it may or may not be a list of variables so the actual output could be 21 or it could be 18, 21. What I need to do is specifically search this string and find if this 21 exists. Can I do that in a CFIF statement or do some kind of query that would help out. HELP Please. I do not even know where to start. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Searching a Variable
will this same thing work on a variable so could I do something like: cfif ListFindNoCase(form.variable,#dlostr#) ... cfelse ... /cfif Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 1:37 PM To: CF-Talk Subject: RE: Searching a Variable If you wanted to see if 21 exists in a form variable, you could: cfif ListFindNoCase(form.variable,21) ... cfelse ... /cfif This will return the List index of 21 if it is found. If it is not found, then it will return 0, and in this case would cause the cfelse. HTH. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 11:27 AM To: CF-Talk Subject: Searching a Variable I have a variable being passed from one page to the next and it may or may not be a list of variables so the actual output could be 21 or it could be 18, 21. What I need to do is specifically search this string and find if this 21 exists. Can I do that in a CFIF statement or do some kind of query that would help out. HELP Please. I do not even know where to start. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL in a CFIF
How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL in a CFIF
more like cfif ListFindNoCase(#userroles#, 'SELECT something FROM database WHERE condition = exist') Do something here cfelse Do something else here!! /cfif Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:35 PM To: CF-Talk Subject: RE: SQL in a CFIF You mean: cfquery Select cfif var eq whatevercol,col2,col3cfelse*/cfif From Table /cfquery -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:30 PM To: CF-Talk Subject: SQL in a CFIF How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL in a CFIF
Let me give an understanding of what I am doing. I have a variable that is passing one or up to three numbers. The numbers are passed like this: 1, 2, 3 or 1 or 1,2. My problem is I need to check to see if the the number is listed in the #variable#. so That I can go from there. My application works as long as my variable is only passing one number. If it passes 2 numbers my query doesn't like it. I have a query based on the variable 2 being in there. Any help would be appreciated. I am going crazy trying to figure it out. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:43 PM To: CF-Talk Subject: RE: SQL in a CFIF you can not have your cfif conditional execute on the database-side; but you can put cfif and other cftags inside a cfquery tag-pair. for example if you had a page that had to display some item from your database, you could use a cfif to decide whether to pull an item by id or if no id is specified, pull the default item: cfquery name=iteminfo datasource=mydsn SELECT TOP 1 * FROM tbl_Merchandise WHERE cfparam name=currentitem default= cfif currentitem IS NOT id=#currentitem# cfelse default='y' /cfif /cfquery but it is important to note that the cftags, including the cfif are processed before the query itself is sent to the sql server, so all this happens within cf. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 13:30 To: CF-Talk Subject: SQL in a CFIF How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL in a CFIF
Yeah but the 1 or 2 or 3 is dynamic and may not always be the same. If I have the ability to run a query I can figure out which one I need. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:08 PM To: CF-Talk Subject: RE: SQL in a CFIF Use Listfind Cfif Listfind(varName, 1) do A cfelseif Listfind(varName, 2) do B /cfif Listfind will work without throwing an error - even if the VarName is an empty string. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:54 PM To: CF-Talk Subject: RE: SQL in a CFIF Let me give an understanding of what I am doing. I have a variable that is passing one or up to three numbers. The numbers are passed like this: 1, 2, 3 or 1 or 1,2. My problem is I need to check to see if the the number is listed in the #variable#. so That I can go from there. My application works as long as my variable is only passing one number. If it passes 2 numbers my query doesn't like it. I have a query based on the variable 2 being in there. Any help would be appreciated. I am going crazy trying to figure it out. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:43 PM To: CF-Talk Subject: RE: SQL in a CFIF you can not have your cfif conditional execute on the database-side; but you can put cfif and other cftags inside a cfquery tag-pair. for example if you had a page that had to display some item from your database, you could use a cfif to decide whether to pull an item by id or if no id is specified, pull the default item: cfquery name=iteminfo datasource=mydsn SELECT TOP 1 * FROM tbl_Merchandise WHERE cfparam name=currentitem default= cfif currentitem IS NOT id=#currentitem# cfelse default='y' /cfif /cfquery but it is important to note that the cftags, including the cfif are processed before the query itself is sent to the sql server, so all this happens within cf. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 13:30 To: CF-Talk Subject: SQL in a CFIF How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL in a CFIF
#org_dlo# can equal on of three numbers at this point. When they update the database the ID's change so this time it may be 18, 20, 21 next week it may be 1, 2, 3 and so on and so forth. I need to create everything so that if the ID's change the application will function exactly the same way without any interruption. CFIF IsDefined(dlo_org) CFIF Len(dlo_org) GT 0 TD VALIGN=top ALIGN=left FONT SIZE=-1 cfoutput cfquery name=getDloOrganization datasource=#application.lldbDatasource# SELECT DISTINCT InitCap(ll_userroles.userroles) || ' - ' || ll_organization.description as description FROMll_userroles, ll_useruserroles, ll_user_org, ll_organization WHERE ll_userroles.userroles_id = '#org_dlo#' AND ll_userroles.userroles_id = ll_useruserroles.userroles_id AND ll_useruserroles.useruserroles_id = ll_user_org.useruserroles_id AND ll_user_org.org_id = ll_organization.org_id /cfquery /cfoutput cfoutput query=getDloOrganization #description# /cfoutput CFELSE nbsp; /CFIF /FONT /TD /CFIF Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:14 PM To: CF-Talk Subject: RE: SQL in a CFIF Ok ... I have no idea what that means. Perhaps you should post some actual code. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:07 PM To: CF-Talk Subject: RE: SQL in a CFIF Yeah but the 1 or 2 or 3 is dynamic and may not always be the same. If I have the ability to run a query I can figure out which one I need. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:08 PM To: CF-Talk Subject: RE: SQL in a CFIF Use Listfind Cfif Listfind(varName, 1) do A cfelseif Listfind(varName, 2) do B /cfif Listfind will work without throwing an error - even if the VarName is an empty string. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:54 PM To: CF-Talk Subject: RE: SQL in a CFIF Let me give an understanding of what I am doing. I have a variable that is passing one or up to three numbers. The numbers are passed like this: 1, 2, 3 or 1 or 1,2. My problem is I need to check to see if the the number is listed in the #variable#. so That I can go from there. My application works as long as my variable is only passing one number. If it passes 2 numbers my query doesn't like it. I have a query based on the variable 2 being in there. Any help would be appreciated. I am going crazy trying to figure it out. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:43 PM To: CF-Talk Subject: RE: SQL in a CFIF you can not have your cfif conditional execute on the database-side; but you can put cfif and other cftags inside a cfquery tag-pair. for example if you had a page that had to display some item from your database, you could use a cfif to decide whether to pull an item by id or if no id is specified, pull the default item: cfquery name=iteminfo datasource=mydsn SELECT TOP 1 * FROM tbl_Merchandise WHERE cfparam name=currentitem default= cfif currentitem IS NOT id=#currentitem# cfelse default='y' /cfif /cfquery but it is important to note that the cftags, including the cfif are processed before the query itself is sent to the sql server, so all this happens within cf. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 13:30 To: CF-Talk Subject: SQL in a CFIF How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED
RE: SQL in a CFIF
That worked!!! Thank YOU!!! I can't think anymore. These 19hr days are killing me. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:39 PM To: CF-Talk Subject: Re: SQL in a CFIF Sorry that should be: WHERE ll_userroles.userroles_id IN (#org_dlo#) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 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: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 2:26 PM Subject: Re: SQL in a CFIF Like I said use: WHERE ll_userroles.userroles_id IN '#org_dlo#' instead of WHERE ll_userroles.userroles_id = '#org_dlo#' Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 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: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 2:20 PM Subject: RE: SQL in a CFIF #org_dlo# can equal on of three numbers at this point. When they update the database the ID's change so this time it may be 18, 20, 21 next week it may be 1, 2, 3 and so on and so forth. I need to create everything so that if the ID's change the application will function exactly the same way without any interruption. CFIF IsDefined(dlo_org) CFIF Len(dlo_org) GT 0 TD VALIGN=top ALIGN=left FONT SIZE=-1 cfoutput cfquery name=getDloOrganization datasource=#application.lldbDatasource# SELECT DISTINCT InitCap(ll_userroles.userroles) || ' - ' || ll_organization.description as description FROM ll_userroles, ll_useruserroles, ll_user_org, ll_organization WHERE ll_userroles.userroles_id = '#org_dlo#' AND ll_userroles.userroles_id = ll_useruserroles.userroles_id AND ll_useruserroles.useruserroles_id = ll_user_org.useruserroles_id AND ll_user_org.org_id = ll_organization.org_id /cfquery /cfoutput cfoutput query=getDloOrganization #description# /cfoutput CFELSE nbsp; /CFIF /FONT /TD /CFIF Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:14 PM To: CF-Talk Subject: RE: SQL in a CFIF Ok ... I have no idea what that means. Perhaps you should post some actual code. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:07 PM To: CF-Talk Subject: RE: SQL in a CFIF Yeah but the 1 or 2 or 3 is dynamic and may not always be the same. If I have the ability to run a query I can figure out which one I need. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:08 PM To: CF-Talk Subject: RE: SQL in a CFIF Use Listfind Cfif Listfind(varName, 1) do A cfelseif Listfind(varName, 2) do B /cfif Listfind will work without throwing an error - even if the VarName is an empty string. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:54 PM To: CF-Talk Subject: RE: SQL in a CFIF Let me give an understanding of what I am doing. I have a variable that is passing one or up to three numbers. The numbers are passed like this: 1, 2, 3 or 1 or 1,2. My problem is I need to check to see if the the number is listed in the #variable#. so That I can go from there. My application works as long as my variable is only passing one number. If it passes 2 numbers my query doesn't like it. I have a query based on the variable 2 being in there. Any help would be appreciated. I am going crazy trying to figure it out. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:43 PM To: CF-Talk
RE: Time Clock / Punch Application
If you find someone who let's you have a copy or tells you where to get one let me know.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Emmanuel Crouvisier [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 1:45 PM To: CF-Talk Subject: Time Clock / Punch Application Hi folks, I can only imagine that someone here has built the little application I'm looking for, so I thought I'd check here first before building it myself ! I'm looking for a time punch/tracking software to keep track of employees' hours. Basically, all the system would need to do is have the person punch in in the morning via our intranet, and when they leave for they day they need to punch out, just like the old time punch cards. At the end of the pay periods, the administrator can get an itemized list of hours (per employee per day), with the total number of hours worked for each employee. Anyone have such an application that they wouldn't mind sharing? Thanks a lot, Emmanuel Crouvisier __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists