Collections Insight
Can someone give me a clear idea of how the Verity Collections work? I have CF 5.0 and have setup a collection that points to a sub-directory such as manuals/windows I want to be able to search that sub-directory. However, when I do a search it does not find the page I want that has the specific information. The info I want to search is: A30.09. The actual page exists in the windows sub-folder of the manuals folder, but I don't get the direct page, I get a file in the manuals folder that points to the page in the windows folder. The collections is setup in via the CFAdmin and I have Recursively Index Sub Directories checked off. Please help... Robert O. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.3 - Release Date: 5/3/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Save web page
IS there a way to save the content of a web page using cfsavecontent? Here's my script: cfsavecontent variable=intro CFLocation url=http://www.mypage.com; /cfsavecontent cfoutput#intro#/cfoutput Would I be able to search #intro# for certain text? Or is there a better way? Sorry but this is new to me. Robert O. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Scheduled task time mix up?
I'm using CF 5.0 and am running a Scheduled Task. I want it to run every five (5) minutes. In the setup for the task, I have Daily every set to 5 minutes and from set to 12:00:00 and to at: 23:30:00. I setup up a scheduled task log, but see no entries for today. Is my from/to times mixed up somehow? Please help! Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.18 - Release Date: 4/19/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203804 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Scheduled task time mix up?
Thanks Ray. In other words, how would I set the from/to times to reflect a continual task that runs 24 hours and every five minutes. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 21, 2005 9:16 AM To: CF-Talk Subject: Re: Scheduled task time mix up? I should add that if you want to start it at midnight, you need to use 0:00:00, I believe. Ray Ray Champagne wrote: Well, it is not noon yet here, and if it isn't where you are, either, then you wouldn't see anything, I think. Ray Robert Orlini wrote: I'm using CF 5.0 and am running a Scheduled Task. I want it to run every five (5) minutes. In the setup for the task, I have Daily every set to 5 minutes and from set to 12:00:00 and to at: 23:30:00. I setup up a scheduled task log, but see no entries for today. Is my from/to times mixed up somehow? Please help! Robert O. HWW -- = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203809 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Scheduled task time mix up?
Sounds logical to me. Thanks again... -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 21, 2005 10:15 AM To: CF-Talk Subject: Re: Scheduled task time mix up? Well, I would say to use the start date as 0:00:00 and the end date as 23:55:00, with a recurring time of 5 minutes. I don't use the scheduler that much, but I just tried a test on my dev machine (MX, tho) and it worked fine. I don't think anything should be any different for 5.0 Robert Orlini wrote: Thanks Ray. In other words, how would I set the from/to times to reflect a continual task that runs 24 hours and every five minutes. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 21, 2005 9:16 AM To: CF-Talk Subject: Re: Scheduled task time mix up? I should add that if you want to start it at midnight, you need to use 0:00:00, I believe. Ray Ray Champagne wrote: Well, it is not noon yet here, and if it isn't where you are, either, then you wouldn't see anything, I think. Ray Robert Orlini wrote: I'm using CF 5.0 and am running a Scheduled Task. I want it to run every five (5) minutes. In the setup for the task, I have Daily every set to 5 minutes and from set to 12:00:00 and to at: 23:30:00. I setup up a scheduled task log, but see no entries for today. Is my from/to times mixed up somehow? Please help! Robert O. HWW -- = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Check for a file in a directory
How would I check for the existence of file in a directory? I'm thinking I use list option in CFDIRECTORY, but I'm a little stuck on where to start with this. I figure I use this statement: cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory and then check for the file name using this statement: cfoutput query=myDirectory CFIF name EQ 'errror.txt' Do this... /cfif Am I on the right track here? Robert at HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.18 - Release Date: 4/19/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Check for a file in a directory
Thanks all. I read over the link below, however, I need it to monitor this directory with the use of a form that a user enters the file name so the cfif IsDefined(FORM.yourFile) will not work. How can I have it monitor the directory on its own so-to-speak and then tell me if it finds a certain file. Robert O. -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 20, 2005 2:15 PM To: CF-Talk Subject: Re: Check for a file in a directory Use the FileExists() function in CFML. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi79.htm#wp1104406 George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Check for a file in a directory
Thanks Barney. Sorry I re-read my previous email and realized I may have worded wrong. I don't want a form that submits anything. Just a way for the CF script to monitor this directory for a file and then do a cfif... -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 20, 2005 2:26 PM To: CF-Talk Subject: Re: Check for a file in a directory You mean like this: cfif structKeyExists(form, filename) cfif fileExists(c:\path\to\directory\ form.filename) File Exists! cfelse File Doesn't Exist! /cfif /cfif form method=post action=#cgi.script_name# input name=filename / input type=submit / /form On 4/20/05, Robert Orlini [EMAIL PROTECTED] wrote: Thanks all. I read over the link below, however, I need it to monitor this directory with the use of a form that a user enters the file name so the cfif IsDefined(FORM.yourFile) will not work. How can I have it monitor the directory on its own so-to-speak and then tell me if it finds a certain file. Robert O. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203714 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Check for a file in a directory
Thanks -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 20, 2005 2:51 PM To: CF-Talk Subject: Re: Check for a file in a directory CF scripts only execute based on page requests, either from users or from scheduled tasks. So CF can't monitor a directory for a specific file, unless you use an event gateway (only in CF7 Enterprise). cheers, barneyb On 4/20/05, Robert Orlini [EMAIL PROTECTED] wrote: Thanks Barney. Sorry I re-read my previous email and realized I may have worded wrong. I don't want a form that submits anything. Just a way for the CF script to monitor this directory for a file and then do a cfif... -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203720 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
drop down dilemma
I have a dropdown that I want to pass to vales similar to a URL. The url passes two values: a href=faq.cfm?categoryname=#categoryname#num=#categorynum#/a How do I get the dropdown below to pass both categoryname and categorynum? I tried a hidden field: form action=faq_list2.cfm method=post name=dropdown input type=hidden name=num value=#form.categorynum# select name=category onchange=this.form.submit(); option value=Select/option cfoutput query=getlistoftopics option value=#categoryname# #categoryname#/option /cfoutput /select /form Thanks. Robert at HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 3/30/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: drop down dilemma
Thanks Jim, It works to a degree, but I need those two fields then separated. In the next coding lines I have: Category: #url.categoryname#/cfoutput /cfif cfquery name=faqlist datasource=new Select * from faq where category = '#url.num#' /cfquery That is where the url: a href=faq.cfm?categoryname=#categoryname#num=#categorynum#/a worked fine. Robewrt O. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 2:55 PM To: CF-Talk Subject: Re: drop down dilemma Would this work for you? form action=faq_list2.cfm method=post name=dropdown select name=category onchange=this.form.submit(); option value=Select/option cfoutput query=getlistoftopics option value=#categorynum#,#categoryname##categoryname# /cfoutput /select /form Usually you'd just use: option value=#categorynum##categoryname# and then look up the category name on the form's action page. But the above should work if you want to avoid doing another query to get the name. - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 30, 2005 12:45 PM Subject: drop down dilemma I have a dropdown that I want to pass to vales similar to a URL. The url passes two values: a href=faq.cfm?categoryname=#categoryname#num=#categorynum#/a How do I get the dropdown below to pass both categoryname and categorynum? I tried a hidden field: form action=faq_list2.cfm method=post name=dropdown input type=hidden name=num value=#form.categorynum# select name=category onchange=this.form.submit(); option value=Select/option cfoutput query=getlistoftopics option value=#categoryname# #categoryname#/option /cfoutput /select /form Thanks. Robert at HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 3/30/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFOBJECT in the CF Administrator
I'm using a script that Uses COM and requires CFOBJECT be enabled in the CF Administrator in CF version 5. I've looked throughout the admin and can't find where to enable cfobject. It's the script in a previous post found at: http://cflib.org/udf.cfm?ID=105 Any ideas? Or is there something else that's missing here? I'm using the script that returns the amount of free space (in bytes) available to the ColdFusion server for a specified drive or network sharein CFLIB.org. See below: Robert O. HWW cfscript function FreeSpace(drvPath) { Var fso = CreateObject(COM, Scripting.FileSystemObject); Var drive = fso.GetDrive(c); Return drive.FreeSpace; } /cfscript CFOUTPUTFree space available on C: #FreeSpace(c:)# bytes/CFOUTPUT -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Image Submit button
Thanks Troy. It does not submit the value just refreshes though. Robert O. -Original Message- From: Troy Murray [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 4:29 PM To: CF-Talk Subject: Re: OT: Image Submit button Try this instead for the button: button type=submit class=formitemsimg src=/images/next10.gif border=0 Next 10/button -t On Fri, 11 Mar 2005 14:19:39 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I have another problem with a submit button. It works well as input type=submit and moves on to the next ten records, but when I change it to an image it seems to just refresh the page but not go to the next records. This works: input type=submit class=formitems value=Next 10 name=submitNext This does not: input type=image class=formitems src=/images/next10.gif value=Next 10 name=submitNext onclick=javascript:this.form.submit(); I added onclick=javascript:this.form.submit(); but to no avail. Am I missing something here? Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: reset button
Is there a way I can use an image for a reset button? For a submit I have: input type=image border=0 src=images/login.gif value=Login name=B1 How different is the coding for the reset button? Thx. Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: reset button
Thanks Jeff, It treats it as a submit though. Did I do this right? form method=post action=trackindex.cfm name=track input type=image border=0 src=images/reset.gif value=reset name=reset onclick=document.track.reset() Robert O. -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 11:17 AM To: CF-Talk Subject: RE: reset button You will have to use some javascript to do the reset. Add in onclick=document.myform.reset() to your button tag. HTH, Jeff Garza -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 9:12 AM To: CF-Talk Subject: OT: reset button Is there a way I can use an image for a reset button? For a submit I have: input type=image border=0 src=images/login.gif value=Login name=B1 How different is the coding for the reset button? Thx. Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: reset button
Thanks all. It worked! -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 11:22 AM To: CF-Talk Subject: Re: OT: reset button Use a bit of javascript instead? something like input type=image border=0 src=images/login.gif value=Reset name=B2 onclick=this.form.reset(); return false; HTH On Fri, 11 Mar 2005 11:11:51 -0500, Robert Orlini [EMAIL PROTECTED] wrote: Is there a way I can use an image for a reset button? For a submit I have: input type=image border=0 src=images/login.gif value=Login name=B1 How different is the coding for the reset button? Thx. Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198407 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Image Submit button
I have another problem with a submit button. It works well as input type=submit and moves on to the next ten records, but when I change it to an image it seems to just refresh the page but not go to the next records. This works: input type=submit class=formitems value=Next 10 name=submitNext This does not: input type=image class=formitems src=/images/next10.gif value=Next 10 name=submitNext onclick=javascript:this.form.submit(); I added onclick=javascript:this.form.submit(); but to no avail. Am I missing something here? Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
232
Hello, What does this mean in my CF Server log: Error,2136,02/08/05,01:33:23,,Error number 232 occurred attempting to close connection to web server. Error,2136,02/08/05,01:33:23,,Windows NT error number 232 occurred. Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.6 - Release Date: 2/7/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193630 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: 232
Thanks all... -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 11:21 AM To: CF-Talk Subject: RE: 232 On CF 5 and below, 232 errors are generally to do with timeouts or clients hitting their stop button in the browser... You may want to turn on logging for long running pages and if you have a DB capable of it, turn on your profiler and look for slow execution times Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT SQL date/time default
I have a form that if the date field is blank SQL automatically inserts the date of 1/1/1900 and then this displays. How can I have it leave this field blank? The column is set as datetime in design view. Thx. Robert O. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191957 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT SQL date/time default
Ian, NULL in default and Allow Nulls checked off. Still leaves the 1/1/1900 date if field is left blank -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 12:06 PM To: CF-Talk Subject: RE: OT SQL date/time default Allow nulls and set the default as null in the table description? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Robert Orlini [mailto:[EMAIL PROTECTED] ...Sent: Thursday, January 27, 2005 9:03 AM ...To: CF-Talk ...Subject: OT SQL date/time default ... ...I have a form that if the date field is blank SQL automatically inserts ...the date of 1/1/1900 and then this displays. ... ...How can I have it leave this field blank? The column is set as datetime ...in design view. ... ...Thx. ... ...Robert O. ... ... ... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191962 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT SQL date/time default
Randy default is now (null) and allow nulls is checked, but when filed is blank and submitted 1/1/1900 is inserted. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 12:07 PM To: CF-Talk Subject: RE: OT SQL date/time default Check to see if the Default Value of the field is set. Else you can insert a NULL to the field based on the INSERT query -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 12:03 PM To: CF-Talk Subject: OT SQL date/time default I have a form that if the date field is blank SQL automatically inserts the date of 1/1/1900 and then this displays. How can I have it leave this field blank? The column is set as datetime in design view. Thx. Robert O. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191963 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT SQL date/time default
Ian, Randy, Just a plain insert and I fear that is the problem...only I don't work with CF enough to know the coding tips. Here it is below: cfquery name=off datasource=off Insert into off ( formdate, admin, side1collectionsdate, side2collectionsdate, side3collectionsdate, side4collectionsdate, side5collectionsdate ) VALUES ( '#form.formdate#', '#form.admin#', '#form.side1collectionsdate#', '#form.side2collectionsdate#', '#form.side3collectionsdate#', '#form.side4collectionsdate#', '#form.side5collectionsdate#' ) /cfquery -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 12:45 PM To: CF-Talk Subject: RE: OT SQL date/time default On the INSERT query are you setting the field to '' or NULL? If you use myDate = '' then yes you will more than likely get that Type of date, try using myDate = NULL -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 12:37 PM To: CF-Talk Subject: RE: OT SQL date/time default Randy default is now (null) and allow nulls is checked, but when filed is blank and submitted 1/1/1900 is inserted. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 12:07 PM To: CF-Talk Subject: RE: OT SQL date/time default Check to see if the Default Value of the field is set. Else you can insert a NULL to the field based on the INSERT query -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 12:03 PM To: CF-Talk Subject: OT SQL date/time default I have a form that if the date field is blank SQL automatically inserts the date of 1/1/1900 and then this displays. How can I have it leave this field blank? The column is set as datetime in design view. Thx. Robert O. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191969 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT SQL date/time default
Thanks Ian, Randy, and Michael! Your suggestions combined helped me. Now I understand (and better appreciate) using cfqueryparam especially since it also makes things more secure. This line worked: CFQUERYPARAM VALUE=#form.side1collectionsdate# CFSQLTYPE=CF_SQL_VARCHAR null=#yesNoFormat(NOT len(trim(form.side1collectionsdate)))# Robert O. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 1:06 PM To: CF-Talk Subject: RE: OT SQL date/time default That is probably your problem. I presume that form.formdate is a text field. And a empty text field is '' which is completely different then NULL. So you are inserting a value into the date field, a value of an empty string, but a value none the less. For situations like this and many other good reasons you should read up on the cfqueryparam tag. To fix your date issue trying changing this line ...'#form.formdate#', To cfqueryparam value=#form.formdate# cfsqltype=cf_sql_date null=#yesNoFormat(NOT len(trim(form.formdate)))# Now looking at your code example, you seem to be inserting your date as a string, not a date? Is the field in the database a date field or a char|varchar field? PS you should change your other inserts to queryparams as well. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Robert Orlini [mailto:[EMAIL PROTECTED] ...Sent: Thursday, January 27, 2005 9:56 AM ...To: CF-Talk ...Subject: RE: OT SQL date/time default ... ...Ian, Randy, ... ...Just a plain insert and I fear that is the problem...only I don't work ...with CF enough to know the coding tips. ... ...Here it is below: ... ...cfquery name=off datasource=off ...Insert into off ...( ...formdate, ...admin, ...side1collectionsdate, ...side2collectionsdate, ...side3collectionsdate, ...side4collectionsdate, ...side5collectionsdate ...) ...VALUES ...( ...'#form.formdate#', ...'#form.admin#', ...'#form.side1collectionsdate#', ...'#form.side2collectionsdate#', ...'#form.side3collectionsdate#', ...'#form.side4collectionsdate#', ...'#form.side5collectionsdate#' ...) .../cfquery Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: JavaScript onSubmit
I have a JavaScript question. How can I combine these two validation scripts? I need it to do a return confirm and also a validation to make sure the proper field is selected. I'm trying to combine the onSubmit of onsubmit=return checkUserInputs(this); and onSubmit=return verify. SEE BELOW CODE I'm weak with JavaScript. Any suggestions please? Thanks. Robert O. -- SCRIPT LANGUAGE=JAVASCRIPT function verify(){ msg = Submit Signoff sheet?; //all we have to do is return the return value of the confirm() method return confirm(msg); } /SCRIPT form method=POST action=action.cfm name=searchQuery onSubmit=return verify SCRIPT LANGUAGE=JAVASCRIPT function checkUserInputs(form) { // One of the trials must be selected. if(form.name.options[0].selected) { alert(Please select a trial.); return false; } } /script form action=action.cfm method=post onsubmit=return checkUserInputs(this); ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191868 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Problems w/printing in IE
Anyone out there having problems with printing in IE (6.0) or Outlook 2000? When I try to re-install IE from Microsoft it crashes. A Windows File Protection pop-up appears later. Also Norton has some Office files in Quarantine it can fix with the latest definitions. Thanks. Robert O. HWW ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189813 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Javascript or CF in drop-down
In the example below, how would I use Javascript or CF informing a user to please make a selection as opposed to clicking SUBMIT on the title View Available Reports? Thanks as always. form method=post action=test.cfm select name=date optionView Available Reports/option /select input type=image src=images/view.gif name=submit value=submit /form Robert O. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189441 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Extract year from date field
How do I extract the year from a date field such as 2005-10-12? I'm using datepart in the Query as: datepart(yy,report_date), but when I try to output it as: cfoutput query=populatedropdown #datepart(, populatedropdown.report_date)# /cfoutput it gives an form field not found error. Here is the query: cfquery name=populatedropdown datasource=test select distinct(datepart(m,report_date)) as month from report where datepart(yy,report_date) = '2005' /cfquery Thank you. Robert O. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189059 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Extract year from date field
Thanks Jochem. How would I extract the year from 2005-10-12 please? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 10:47 AM To: CF-Talk Subject: Re: Extract year from date field Robert Orlini wrote: How do I extract the year from a date field such as 2005-10-12? I'm using datepart in the Query as: datepart(yy,report_date), but when I try to output it as: cfoutput query=populatedropdown #datepart(, populatedropdown.report_date)# /cfoutput it gives an form field not found error. Here is the query: cfquery name=populatedropdown datasource=test select distinct(datepart(m,report_date)) as month from report where datepart(yy,report_date) = '2005' /cfquery This query only returns months, so how can you extract a year from that? Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Extract year from date field
Thank you Sean. How can I apply the DISTINCT to the year as well? It gives me an error when I add it in front of datepart(yy,report_date) -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 12:49 PM To: CF-Talk Subject: Re: Extract year from date field On Fri, 31 Dec 2004 10:43:43 -0500, Robert Orlini [EMAIL PROTECTED] wrote: How do I extract the year from a date field such as 2005-10-12? cfquery name=populatedropdown datasource=test select distinct(datepart(m,report_date)) as month from report where datepart(yy,report_date) = '2005' /cfquery You need to change your query so returns years as well as months - otherwise there is no year to extract later on: cfquery name=populatedropdown datasource=test select distinct(datepart(m,report_date)) as month, datepart(yy,report_date) as year from report where datepart(yy,report_date) = '2005' /cfquery Then you can refer to populatedropdown.year. Mind you, if your query really does just search by year like that, you *know* what the year is since you specified it in the query! -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 6 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Extract year from date field
Thanks -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 1:51 PM To: CF-Talk Subject: Re: Extract year from date field How do I extract the year from a date field such as 2005-10-12? cfquery name=populatedropdown datasource=test select distinct(datepart(m,report_date)) as month from report where datepart(yy,report_date) = '2005' /cfquery Not to be a wiseass...but if that's the query, it'll always be 2005 :) It looks like your query gets all of the months of reports from 2005. If you wanted to get all of the distinct years for all reports, you could do the following: cfquery name=populatedropdown datasource=test select distinct(datepart(yy,report_date)) as reportYear from report /cfquery cfoutput query=populatedropdown#reportYear# /cfoutput -Joe -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189078 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Check for next year
I have a popup that will display one month in advance. The issue I have is that users can view January, but the display still reads January 2004. I have the month and year formatted below. How can I check and/or display the year 2005? The dateformat below does not take that in consideration. Thanks! Report for month of: #month# -- #dateformat(now(), )# Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Check for next year
Thanks all! -Original Message- From: Ben Rogers [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 12:00 PM To: CF-Talk Subject: RE: Check for next year cfset theDate = dateAdd(m, 1, now()) cfoutput #month(theDate)# -- #year(theDate)# /cfoutput You can wrap month() in monthAsString() if you want to display the name of the month rather than the month as a number. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 11:53 AM To: CF-Talk Subject: Check for next year I have a popup that will display one month in advance. The issue I have is that users can view January, but the display still reads January 2004. I have the month and year formatted below. How can I check and/or display the year 2005? The dateformat below does not take that in consideration. Thanks! Report for month of: #month# -- #dateformat(now(), )# Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189006 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFHTTP
I have this code using cfhttp below. When it does not connect I want it to display some text reading Connection lost. I have throwOnError set to yes. What do I have to add to the code below to get it to do this? Thanks. Robert O. HWW CFhttp method=get url=http://myurl/stats.cfm; resolveurl = 1 throwOnError = yes ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188957 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cf 5.0
How do I stop/restart CF 5.0 server? Robert O. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188429 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
number of logins
The query below does not search the form.login value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still it does not give me the desired results on the number of logins. Its in an Access table What am I coding wrong here? Thanks. Robert O. HWW cfquery name=Getcustomer datasource=test Select * from test Where 0 = 0 CFIF IsDefined(FORM.customer) And customer LIKE '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187571 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: number of logins
I get an Data type mismatch in criteria expression. error when I do that though... -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 12:16 PM To: CF-Talk Subject: RE: number of logins Is form.login a NUMERIC? If so, should it be: And LOGIN #FORM.LOGIN# Drop the single quotes -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 12:06 PM To: CF-Talk Subject: number of logins The query below does not search the form.login value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still it does not give me the desired results on the number of logins. Its in an Access table What am I coding wrong here? Thanks. Robert O. HWW cfquery name=Getcustomer datasource=test Select * from test Where 0 = 0 CFIF IsDefined(FORM.customer) And customer LIKE '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: number of logins
I converted the field to numeric, all fixed--still thanks for the advice Randy and Pascal -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 1:36 PM To: CF-Talk Subject: RE: number of logins Does the database field login a string or numeric type? If it is String, then by using the symbol indicates That you are doing a numeric comparative.. What does LOGIN field contain? What is the user entering as form.login? -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 1:07 PM To: CF-Talk Subject: RE: number of logins I get an Data type mismatch in criteria expression. error when I do that though... -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 12:16 PM To: CF-Talk Subject: RE: number of logins Is form.login a NUMERIC? If so, should it be: And LOGIN #FORM.LOGIN# Drop the single quotes -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 12:06 PM To: CF-Talk Subject: number of logins The query below does not search the form.login value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still it does not give me the desired results on the number of logins. Its in an Access table What am I coding wrong here? Thanks. Robert O. HWW cfquery name=Getcustomer datasource=test Select * from test Where 0 = 0 CFIF IsDefined(FORM.customer) And customer LIKE '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
dynamic table union?
Is there a way to do a dynamic Union of tables. I a drop-down I would like to have the ability to search one table or have the option of searching ALL the tables. I was think of having a count or maybe an array to keep track of the amount of tables and then loop them. The code I have now dynamically grabs just one table in the data source and then searches it. Anyone know how I can try to implement this if possible? Maybe there is another way I need to know? Thanks. cfquery name=Getcustomer datasource=market SELECT * FROM #form.table# Where 0 = 0 Robert O. at HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186154 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFDIRECTORY question
With your suggestion and a few tweaks it does what I want. Thanks Mike! Robert O. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 4:34 PM To: CF-Talk Subject: RE: CFDIRECTORY question Why not just use CFDIRECTORY on each page request? This will ensure that you have the most up-to-date list of directories. What is the point of adding these to the database which could quickly become outdated? If you still need to do this, I would query the database, then run CFDIRECTORY. Then, put it all together with a Query of Query. You should be able to find the differences between the two. M!ke -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 2:42 PM To: CF-Talk Subject: CFDIRECTORY question I have this cfdirectory code (see below) that I want to read a list of directory names and then insert into a table. However, this script will be running each time a user accesses drop-down list. I want to list the current directories and any new directory names that have been added. At this point it will add the directory names numerous times along with any new directories. How can it just add new directories to the table using this cfdirectory script? Thanks! cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory cfloop query=myDirectory cfif type EQ dir CFQUERY name=get datasource=marketing INSERT INTO directories (name) VALUES ('#mydirectory.name#') Where #mydirectory.name# != '#name#' /CFQUERY /cfif /cfloop Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFFile or CFDirectory?
I'm using cfdirectory successfully to list the directory names and then list them in a drop-down menu. Now after a user selects the directory name I would like it to load a specific file in that directory. Is that done with cffile or again using cfdirectory in some other way? Thanks as always. Robert O. ô¿ô Here is my code so far: cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory form action=select_directory.cfm method=post name=dropdown select name=name style=font-family: Verdana; font-size: 8pt; color: #80; font-weight:bold; background-color:#EBEBEB onchange=this.form.submit(); option value=Select Trial/option cfoutput query=myDirectory CFIF name NEQ '_vti_cnf' and name NEQ 'application.cfm' and name NEQ '..' and name NEQ '.' and name NEQ 'MTManager' and name NEQ 'err_req.cfm' and name NEQ 'err_valid.cfm' and name NEQ 'scheduled_trial_email' and name NEQ 'template' option value=#name# #name#/option /cfif /cfoutput /select /form ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185924 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFDIRECTORY question
I have this cfdirectory code (see below) that I want to read a list of directory names and then insert into a table. However, this script will be running each time a user accesses drop-down list. I want to list the current directories and any new directory names that have been added. At this point it will add the directory names numerous times along with any new directories. How can it just add new directories to the table using this cfdirectory script? Thanks! cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory cfloop query=myDirectory cfif type EQ dir CFQUERY name=get datasource=marketing INSERT INTO directories (name) VALUES ('#mydirectory.name#') Where #mydirectory.name# != '#name#' /CFQUERY /cfif /cfloop Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
get directory name
Using CFFile or another tag, is there a way to get the name of directories? I have a folder with directory names I need to use in a drop-down list. For example, in this directory: d:\wwwroot\trials\science the name I would need to isolate would be science. Thanks. Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: get directory name
Thanks Ben and Greg. I'm using the CFDirectory example on Macromedia's site. It lists the directory name and size of files found. One step further: How can I filter out any files (if #size# = 0 which means it is a directory name and not a file) and then insert the directory names in a table? Robert O. See code I'm using: cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory ! Output the contents of the cfdirectory as a cftable - cftable query=myDirectory htmltable colheaders cfcol header=NAME: text=#Name# cfcol header=SIZE: text=#Size# /cftable -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 10:09 AM To: CF-Talk Subject: Re: get directory name Use cfdirectory Then cfif dirlist.type eq Dir ... On Wed, 24 Nov 2004 09:52:16 -0500, Robert Orlini [EMAIL PROTECTED] wrote: Using CFFile or another tag, is there a way to get the name of directories? I have a folder with directory names I need to use in a drop-down list. For example, in this directory: d:\wwwroot\trials\science the name I would need to isolate would be science. Thanks. Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: get directory name - one more thing
works fine Ian thank you. One more thing please: How can I add each directory name into a table using a cfquery? I have this: CFQUERY name=get datasource=marketing INSERT INTO directories (name) VALUES ('#mydirectory.name#') /CFQUERY But it adds just the first entry. I guess your gonna say use a cfloop, if so what type? Robert O. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 11:18 AM To: CF-Talk Subject: RE: get directory name Thanks Ben and Greg. I'm using the CFDirectory example on Macromedia's site. It lists the directory name and size of files found. One step further: How can I filter out any files (if #size# = 0 which means it is a directory name and not a file) and then insert the directory names in a table? Robert O. Instead of using size, I would use the type field which equals file for files and dir for directories. cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory cfloop query=myDirectory cfif type EQ dir !--- Do something, I'm a directory --- /cfif /cfloop -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185341 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: get directory name - one more thing
Sorry I may have not specified this correctly. I need to put each dir name into a table -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 1:38 PM To: CF-Talk Subject: Re: get directory name - one more thing I use cfoutput query=NameOfDirCall I suppose you could use cfloop query= too. On Wed, 24 Nov 2004 13:27:49 -0500, Robert Orlini [EMAIL PROTECTED] wrote: works fine Ian thank you. One more thing please: How can I add each directory name into a table using a cfquery? I have this: CFQUERY name=get datasource=marketing INSERT INTO directories (name) VALUES ('#mydirectory.name#') /CFQUERY But it adds just the first entry. I guess your gonna say use a cfloop, if so what type? Robert O. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 11:18 AM To: CF-Talk Subject: RE: get directory name Thanks Ben and Greg. I'm using the CFDirectory example on Macromedia's site. It lists the directory name and size of files found. One step further: How can I filter out any files (if #size# = 0 which means it is a directory name and not a file) and then insert the directory names in a table? Robert O. Instead of using size, I would use the type field which equals file for files and dir for directories. cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory cfloop query=myDirectory cfif type EQ dir !--- Do something, I'm a directory --- /cfif /cfloop -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: get directory name - one more thing
perfect...thanks much! -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 1:54 PM To: CF-Talk Subject: Re: get directory name - one more thing loop over the directory and use a insert query statement. cfloop query=dirlist cfquery ... insert into table values(#dirlist.name#) /cfquery /cfloop On Wed, 24 Nov 2004 13:41:30 -0500, Robert Orlini [EMAIL PROTECTED] wrote: Sorry I may have not specified this correctly. I need to put each dir name into a table -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 1:38 PM To: CF-Talk Subject: Re: get directory name - one more thing I use cfoutput query=NameOfDirCall I suppose you could use cfloop query= too. On Wed, 24 Nov 2004 13:27:49 -0500, Robert Orlini [EMAIL PROTECTED] wrote: works fine Ian thank you. One more thing please: How can I add each directory name into a table using a cfquery? I have this: CFQUERY name=get datasource=marketing INSERT INTO directories (name) VALUES ('#mydirectory.name#') /CFQUERY But it adds just the first entry. I guess your gonna say use a cfloop, if so what type? Robert O. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 11:18 AM To: CF-Talk Subject: RE: get directory name Thanks Ben and Greg. I'm using the CFDirectory example on Macromedia's site. It lists the directory name and size of files found. One step further: How can I filter out any files (if #size# = 0 which means it is a directory name and not a file) and then insert the directory names in a table? Robert O. Instead of using size, I would use the type field which equals file for files and dir for directories. cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory cfloop query=myDirectory cfif type EQ dir !--- Do something, I'm a directory --- /cfif /cfloop -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185349 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Find first letter
I need to output a list of names alphabetically via the field employee_lname (last name). What's the code that can check the first letter of the field employee_lname? Thanks. Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
len
I have this query: CFQUERY datasource=wilsoncart name=compare Select from data Where len(order#) = '5' order by order# /CFQUERY I get an error on the ( It works in SQL Query Analyzer though. What can I use to get the length of that string which is numeric? Thx Robert O. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: len
Thanks all. -Original Message- From: Robert Orlini Sent: Friday, November 05, 2004 1:52 PM To: CF-Talk Subject: len I have this query: CFQUERY datasource=wilsoncart name=compare Select from data Where len(order#) = '5' order by order# /CFQUERY I get an error on the ( It works in SQL Query Analyzer though. What can I use to get the length of that string which is numeric? Thx Robert O. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
mod command to alter row color
I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? Thanks. Robert O. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: mod command to alter row color
Thank you. One question, in this part of the code: cfloop from=1 to=10 index=i How would I make it infinite? I don't want it to end at the 10th row? Robert O. -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 1:35 PM To: CF-Talk Subject: Re: mod command to alter row color put this in your tr tag cfif query.CurrentRow MOD 2 EQ 0bgcolor=##00cfelsebgcolor=##f/cfif it think that's right. On Tue, 2 Nov 2004 13:24:19 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? Thanks. Robert O. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Mozilla or Linux
I'm running CFMX 6.1 on a Linux box. My login.cfm page generates a undefined session variable error when I run it on Mozilla. It has to do with the last line: CFSET temp=structdelete(session,errormsg) The same Login.cfm file works fine on Windows. I've narrowed everything down and the problem seems to be w/the session variables. Anyone know of problems with Mozilla or Linux w/CF coding or sessions? Robert Orlini HWW ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182630 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Mozilla or Linux
Works fine on Mozilla/Firefox in Windows...I don't have any different cookies settings that I am aware of... -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 1:31 PM To: CF-Talk Subject: Re: Mozilla or Linux Robert Orlini wrote: My login.cfm page generates a undefined session variable error when I run it on Mozilla. It has to do with the last line: CFSET temp=structdelete(session,errormsg) Does it run fine on Mozilla/Firefox on Windows or IE? Do you have the cookie settings different on Mozilla on your Linux machine? -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfinclude or cflocation
I have a slight problem. I need to include code from one page into another. I tried cfinclude but it won't allow a logical path using http:\\... CFlocation sends me right to the url bypassing the page. I need something similar to what is found in html using an insert to put in a portion of another page only this is for .cfm pages. Any suggestions or other tags I could use? Thx. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfinclude or cflocation
Thanks Dave. cfhttp was what I needed. Robert O. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 2:34 PM To: CF-Talk Subject: RE: cfinclude or cflocation I have a slight problem. I need to include code from one page into another. I tried cfinclude but it won't allow a logical path using http:\\... CFlocation sends me right to the url bypassing the page. I need something similar to what is found in html using an insert to put in a portion of another page only this is for .cfm pages. Any suggestions or other tags I could use? I'm not exactly sure what you're trying to do. The CFINCLUDE tag doesn't let you reference files on another server. You can, however, reference any files that CF can get to on your own server. If you must include content from a file on another server, you will either have to use CFHTTP or CFFILE to retrieve that file first. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Variable session is undefined in CFMX
Hello, I have CFMX 6.1 on one server and CF 5 on another. Both run the same CF program I created, however, on the one running CFMX I get a variable session is undefined on the login.cfm page that I don't get on the login.cfm page on the machine running CF 5. The code (in brief) for the exact page on both machines is below. I get the error on the last line: CFSET temp=structdelete(session,errormsg) I ran the tester on CFMX admin to see what compatibility issues the coding on this page had with CFMX, but it revealed nothing. Any help would be appreciated. Thanks. Robert O. HWW ¿ form method=POST action="" name=f1 CFIF IsDefined(session.errormsg)CFoutput#session.errormsg#/CFOUTPUT/CFIF td bgcolor=#FF valign=middle align=rightbfont face=Arial size=2Password:/font/b/td td bgcolor=#FF valign=middlefont face=Verdana size=2binput type=password size=20 name=password/b/font/td /tr tr td bgcolor=#FF valign=middlenbsp;/td td bgcolor=#FF valign=middleinput type=image src="" name=submit width=93 height=27/td /tr /form CFSET temp=structdelete(session,errormsg) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Variable session is undefined in CFMX
Damien, This is the line in my application.cfm file: CFApplication name=check sessionmanagement=Yes sessiontimeout=#createTimeSpan(0,0,15,0)# Robert O. -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 11:11 AM To: CF-Talk Subject: Re: Variable session is undefined in CFMX Check to see if sessions are enabled in your application.cfm file. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: cf tree menu
Is there a CF tree menu I could download or see a link somewhere? Doesn't have to be a tree menu specifically; I need to expand a links on a page as opposed to using bookmarks. Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
MySQL on Linux
Anyone can tell me how to setup/start MySQL on Linux Enterprise. I can't seem to find where to begin. Thanks. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: MySQL on Linux (OT)
Thanks Rick, Jochem, Sorry for the OT subject on this. Will check other references as well. Robert O. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 8:18 AM To: CF-Talk Subject: Re: MySQL on Linux (OT) Robert Orlini wrote: Anyone can tell me how to setup/start MySQL on Linux Enterprise. First of all Robert, I only know you're referring to REDHAT because you've posted previously.You need to specify REDHAT, otherwise people won't know for sure what you're talking about... I think Suse also makes an Enterprise Linux. The startup script for mysql by default in RedHat (all versions) is /etc/rc.d/init.d/mysql Just do this from the linux shell prompt: /etc/rc.d/init.d/mysql start I suggest you get a good book about Linux that focuses on Redhat, and read it.And you might consider posting your questions to a mysql or linux specific mailing list, since this question has nothing to do with CF. - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
trim numbers
I need to trim numbers from a price. For example, I want the price displayed as $120 not $120.00 as it is now. Is the code for this using LTRIM? I need it to count how many characters then trim the last three so that $50.00 would look like $50 the same as $120.00 would look like $120. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: trim numbers
Thanks it did... -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 12:25 PM To: CF-Talk Subject: RE: trim numbers I usually use the following: replace(dollarformat(number), .00, , All) hope this helps Duane _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 12:14 PM To: CF-Talk Subject: trim numbers I need to trim numbers from a price. For example, I want the price displayed as $120 not $120.00 as it is now. Is the code for this using LTRIM? I need it to count how many characters then trim the last three so that $50.00 would look like $50 the same as $120.00 would look like $120. Robert O. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF on Linux
Anyone out there running CFMX on Linux? How do I get it to recognize the .cfm extension? The cfm pages show but seem not to be running thru CF. Is there something in the Apache setup? Where's that file? Thx. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF on Linux
Thanks for the quick reply Thomas. During the install CF mentioned something about a C++ module(?). Is that it? If so, where do I find it. Any URL you can send please? Robert O. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 9:36 AM To: CF-Talk Subject: Re: CF on Linux On Tuesday 03 Aug 2004 14:27 pm, Robert Orlini wrote: Anyone out there running CFMX on Linux? Plenty of folks. How do I get it to recognize the .cfm extension? The cfm pages show but seem not to be running thru CF. Is there something in the Apache setup? It sounds like the connector (module) is not loaded into httpd.conf correctly - did the CF installer say anything about that ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF on Linux
Doug, Looked and could not see that file. I saw cfmx.init.sh, but not the one you emailed. Where can I get it? RO -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 9:54 AM To: CF-Talk Subject: Re: CF on Linux look in the [cf_root]/bin directory for cfmx-connectors-run.sh. It is a shell script that will install the connector between apache and cfmx. Good luck. Doug Robert Orlini wrote: Thanks for the quick reply Thomas. During the install CF mentioned something about a C++ module(?). Is that it? If so, where do I find it. Any URL you can send please? Robert O. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 9:36 AM To: CF-Talk Subject: Re: CF on Linux On Tuesday 03 Aug 2004 14:27 pm, Robert Orlini wrote: Anyone out there running CFMX on Linux? Plenty of folks. How do I get it to recognize the .cfm extension? The cfm pages show but seem not to be running thru CF. Is there something in the Apache setup? It sounds like the connector (module) is not loaded into httpd.conf correctly - did the CF installer say anything about that ? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF on Linux
Found apache_connector.sh in the connectors directory. If thats the file, just doubleclick on it or is there something else I shoulddo? Sorry I'm new to Linux. Robert O. -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 10:25 AM To: CF-Talk Subject: Re: CF on Linux Look in the '[cf_root]/bin/connectors' dir for the appropriate script for your web server. cfdocs If you specified the use of an external web server when running the installer, ColdFusion MX automatically runs the /cf_root//bin/cfmx-connectors.sh script when starting for the first time. This shell script runs the Web Server Configuration Tool using the settings you specified during the installation. If there are problems running this script, review the configuration and bin directory specifications, modify as necessary and rerun the script. You can also configure your web server using the scripts in /cf_root//bin/connectors, as appropriate. /cfdocs Hope this helps. Doug Robert Orlini wrote: Doug, Looked and could not see that file. I saw cfmx.init.sh, but not the one you emailed. Where can I get it? RO -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 9:54 AM To: CF-Talk Subject: Re: CF on Linux look in the [cf_root]/bin directory for cfmx-connectors-run.sh. It is a shell script that will install the connector between apache and cfmx. Good luck. Doug Robert Orlini wrote: Thanks for the quick reply Thomas. During the install CF mentioned something about a C++ module(?). Is that it? If so, where do I find it. Any URL you can send please? Robert O. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 9:36 AM To: CF-Talk Subject: Re: CF on Linux On Tuesday 03 Aug 2004 14:27 pm, Robert Orlini wrote: Anyone out there running CFMX on Linux? Plenty of folks. How do I get it to recognize the .cfm extension? The cfm pages show but seem not to be running thru CF. Is there something in the Apache setup? It sounds like the connector (module) is not loaded into httpd.conf correctly - did the CF installer say anything about that ? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Checked/unchecked input boxes
How do I send via a CFIF IsDefined(form.update.x) in my code instructing CF to Update a field when a input box is unchecked as well as checked. Its working when its checked (input type=checkbox name=itemstatus value=received checked), but how do I send a NR when its unchecked? Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF on Linux
OK. I installed RedHat ES server. Do I need a cd that is CF for Linux? Can the regular CFMX installation you use for Windows work? I'm sorry but I'm very new to Lunix. Thx. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF on Linux
Thanks Ben. I looked through Macromedia's site, but could not find it. Do you have the link or how should I search for this installer? Do I then copy it to a cd and run it on the Linux box? Robert O. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 2:56 PM To: CF-Talk Subject: RE: CF on Linux The same CF works, but the installer is different. You can grab a downloadable installer off of the Macromedia web site. --- Ben _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 2:46 PM To: CF-Talk Subject: CF on Linux OK. I installed RedHat ES server. Do I need a cd that is CF for Linux? Can the regular CFMX installation you use for Windows work? I'm sorry but I'm very new to Lunix. Thx. Robert O. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Formatting output for printing question
Does the tag work with CF 5.0 as well as CFMX? -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 3:51 PM To: CF-Talk Subject: Re: Formatting output for printing question Hi Tom, Thank you for the link and info. I have a more specific question on output and hope you can help. I was thinking of creating a PDF document and then populating it with the fields from a SQL query. For example, I make a PDF template of an invoice and set the fields to be filled in. The from the query populate the PDF with the info and then allow it to be saved and / or printed. Is this possible without purchasing an external program? Also, what about the same idea using a Word Document? Thanks, Kevin Kevin, If you want to go the route of generating a PDF, then you may want to look at HTMLDOC.exe and the custom tag cf_html2pdf3. Just put your output between the tag and that's about it. Its very easy to work with and it will automatically generate the PDF and the HTML output according to the specifications you set up when you first call the tag: cf_html2pdf3 myhtmldoc=pathToHTMLDOC myoptions=--textfont Arial --fontsize 10pt mypdf=#variables.PDFName# output goes here. /cf_html2pdf3 That's about it. This does presuppose of course that you've got HTMLDoc running on your server. regards, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- - Original Message - On Thursday 29 Jul 2004 20:34 pm, Kevin wrote: What would everyone suggest as the easiest way to generate formatted output? Specify a print CSS stylesheet. Alistapart.com may come in handy here. -- Tom Chiverton Advanced ColdFusion Programmer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF on Linux
Sorry I'm not too Linux savvy But does Cold Fusion work on Linux Enterprise server edition? No workaround for MS SQL either I guess(?) Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF on Linux
Thanks Doug, I presume you are using IIS on the Win2003 and modifying pages how?...with FrontPage? I'm thinking of Linux Server with CFMX and connecting to a Win2000 Advanced Server running FP. Sounds OK folks or am I missing something? Robert O. -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 2:21 PM To: CF-Talk Subject: Re: CF on Linux We are running CFMX 6.1 on a RedHat 2.1 AS server connected to a separate Win2003 Server with SQL Server and the setup works great. And Verity works on our version regardless of the official MM system requirements stating differently. Doug Robert Orlini wrote: Sorry I'm not too Linux savvy But does Cold Fusion work on Linux Enterprise server edition? No workaround for MS SQL either I guess(?) Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: js pop-up
I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please? Thx. script LANGUAGE=_javascript_ var newWindow; var firsttime=0; function PopWindow(url) { if (firsttime==0) { newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); firsttime++; } else{ if (newWindow) {newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); newWindow.focus(); } else { newWindow.location.href="" newWindow.focus();} } } /script Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: js pop-up
Seems to work now. Thx. RO -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 10:47 AM To: CF-Talk Subject: Re: OT: js pop-up I could be wrong, but I don't think spaces are legal between a function name and the parameters. ie window.open (bob) is wrong window.open(bob) is right. --Ben Robert Orlini wrote: I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please? Thx. script LANGUAGE=_javascript_ var newWindow; var firsttime=0; function PopWindow(url) { if (firsttime==0) { newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); firsttime++; } else{ if (newWindow) {newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); newWindow.focus(); } else { newWindow.location.href="" newWindow.focus();} } } /script Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
increase session time
I'm getting into the programming of CF OK. I work with sessions but am a bit confused on its setup. In the application.cfm file I have this: CFApplication name=check sessionmanagement=Yes sessiontimeout=#createTimeSpan(0,0,45,0)# It should timeout at 45 minutes but it seems shorter than that. Is adding 60 as opposed to 45 going to get it at 60 minutes. Can I just leave the timeout at 0 or no timeout? Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: JavaScript window
Thanks Ian. One question. Using either code does not allow the popup to stay active. It immediately closes and then tries to refresh the page that spawned it. The update.gif is the image button on the popup page. Once I click that then it performs the update and should close and reload the po3.cfm page. Robert O. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 7:09 PM To: CF-Talk Subject: RE: OT: _javascript_ window If po3.cfm is the window that opend the popup this should work. input type=image src="" name=update value=update width=56 height=23 window.close(); IF po3.cf is not the window that opened the popup this should be what you want. input type=image src="" name=update value=update width=56 height=23 ='po3.cfm'; window.close(); -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: JavaScript window
Ian, Never mind. A few tweaks and all is well. Thanks again and thanks all who contributed. Robert O. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 7:09 PM To: CF-Talk Subject: RE: OT: _javascript_ window If po3.cfm is the window that opend the popup this should work. input type=image src="" name=update value=update width=56 height=23 window.close(); IF po3.cf is not the window that opened the popup this should be what you want. input type=image src="" name=update value=update width=56 height=23 ='po3.cfm'; window.close(); -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: JS number check
I need a _javascript_ later to come up when anything but a number and/or a decimal point is entered into a price each field. The _javascript_ below is not allowing the decimal point. Can anyone suggest what I have to add or fix please? function isNumber2(inputStr, field) { for(var i=0; iinputStr.length; i++) { var charVal = inputStr.substring(i, i+1); if(charVal 0 || charVal 9 || (charVal.value== || charVal.value ==,)) { alert (Please make sure your + field + entry are numbers only); return false; } } return true; Robert Orlini HW ¿ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: JavaScript window
This was touched on before slightly. I have a pop-up that upon closing I would like to refresh a certain page. The code I have is this: input type=image src="" name=update value=update width=56 height=23 > What do I add to the onclick to refresh the page: po3.cfm as the pop-up closes? Or is there no way to do it. Thanks. Robert O. ¿ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JavaScript window
Thanks Pascal -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 1:37 PM To: CF-Talk Subject: RE: _javascript_ window window.opener.location.reload(true); window.close(); Pascal -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: 19 July 2004 18:59 To: CF-Talk Subject: OT: _javascript_ window This was touched on before slightly. I have a pop-up that upon closing I would like to refresh a certain page. The code I have is this: input type=image src="" name=update value=update width=56 height=23 > What do I add to the onclick to refresh the page: po3.cfm as the pop-up closes? Or is there no way to do it. Thanks. Robert O. ¿ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
outputting variable
I have a form where the from variable is incremented dynamically if there is more than one occurrence of the same field. The input name looks like this: name=qty#i#. The #i# is a number that increments according to how many fields are needed. In this instance, if I have more than one item, then the quantity field would be qty2, qty3, qty4, etc. How do I carry over this field as a form variable to the next form on a submit? I tried: #trim(form.qty#i#)# but it does not work. Somewhere I read the Evaluate function my help. Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: outputting variable
Thanks All, but... On each example I get: Error resolving parameter i ColdFusion was unable to determine the value of the parameter. On the bottom of the page, however, the form field for qty appears correctly: Form Fields: QTY1=12 QTY2=13 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 9:27 AM To: CF-Talk Subject: RE: outputting variable #trim(form[qty i])# Don't use evaluate if you don't have to. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:05 To: CF-Talk Subject: outputting variable I tried: #trim(form.qty#i#)# but it does not work. Somewhere I read the _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: outputting variable
Sorry my brain just loosened up after the coffee cart came. I put it in a loop now which defines the i. I'm gettin there...thanks for the patience and help. Robert O. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 9:53 AM To: CF-Talk Subject: RE: outputting variable That's because I doesn't exist. Show us the code of the action page Pascal -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:35 To: CF-Talk Subject: RE: outputting variable Thanks All, but... On each example I get: Error resolving parameter i ColdFusion was unable to determine the value of the parameter. On the bottom of the page, however, the form field for qty appears correctly: Form Fields: QTY1=12 QTY2=13 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 9:27 AM To: CF-Talk Subject: RE: outputting variable #trim(form[qty i])# Don't use evaluate if you don't have to. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:05 To: CF-Talk Subject: outputting variable I tried: #trim(form.qty#i#)# but it does not work. Somewhere I read the _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: keyword 'Where' error
Is there a problem with this Insert? I get an Incorrect syntax near the keyword 'Where' error. I added single quotes around #cnumber# and still get the error. CFQUERY name=additem datasource=purchaseorders INSERT INTO itemsordered (cnumber, line, qty, item, priceeach, totalprice ) VALUES (#cnumber#, '#line#', '#qty#', cfqueryparam value=#Trim(item)# cfsqltype=CF_SQL_VARCHAR, '#trim(item)#', '#trim(totalprice)#' ) Where cnumber = #cnumber# /cfquery Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT: keyword 'Where' error
Thanks all. Too many cut-and-pastes and I didn't pay attention. Also, still am a newbie on some of this. Robert O. -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Friday, July 09, 2004 9:26 AM To: CF-Talk Subject: Re: SOT: keyword 'Where' error Yes, you cannot specify a where clause in an insert. If you are updating a row then use update not insert. Doug Robert Orlini wrote: Is there a problem with this Insert? I get an Incorrect syntax near the keyword 'Where' error. I added single quotes around #cnumber# and still get the error. CFQUERY name=additem datasource=purchaseorders INSERT INTO itemsordered (cnumber, line, qty, item, priceeach, totalprice ) VALUES (#cnumber#, '#line#', '#qty#', cfqueryparam value=#Trim(item)# cfsqltype=CF_SQL_VARCHAR, '#trim(item)#', '#trim(totalprice)#' ) Where cnumber = #cnumber# /cfquery Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT - DHTML tab folder
Anyone know where I can get some snippet(s) of a DHTML tabbed document/text viewer? I found two on dynamic drive but not quite what I wanted Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT - DHTML tab folder
Yes please. Let me know. Robert O. -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:00 AM To: CF-Talk Subject: Re: OT - DHTML tab folder I'll be releasing a whole set of things like this as custom tags in the next week or two, want to do some testing :)? -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: JavaScript history and refresh
Is it possible to go back one page with JS history and also refresh the page as well? I have this script: Script Language = _javascript_ alert (Item Deleted); window.history.go(-1); /script It goes back fine after prompting the user, but I would like it to refresh the same page it goes back to at the same time? What can I add to the above script if its possible? Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: JavaScript - Return Confirm
I'm trying to use _javascript_ to issue a popup confirm before it goes to a page. I'm using the return confirm function below which I used in a onSubmit. I'm kinda new to JS. Can I use the return confirm like an alert? It doesn't stop to confirm. Does someone have a better way? Thanks. CFIF IsDefined(form.add.x) Script Language = _javascript_ return confirm('Are you sure you want to RELEASE this PO?'); /script CFLocation URL="" /CFIF Roberto O. ¿ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: JavaScript - Return Confirm
Thanks. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 1:12 PM To: CF-Talk Subject: Re: OT: _javascript_ - Return Confirm Robert Orlini wrote: I'm trying to use _javascript_ to issue a popup confirm before it goes to a page. I'm using the return confirm function below which I used in a onSubmit. I'm kinda new to JS. Can I use the return confirm like an alert? It doesn't stop to confirm. Not the way you're doing it... ick!Why don't you use it in the onSubmit of the form? If you must do it AFTER the user submits, then you could try this: CFIF IsDefined(form.add.x) Script Language = _javascript_ if( confirm('Are you sure you want to RELEASE this PO?') ) { window.location.href=""> } /script /CFIF Does someone have a better way? Thanks. CFIF IsDefined(form.add.x) Script Language = _javascript_ return confirm('Are you sure you want to RELEASE this PO?'); /script CFLocation URL=""> /CFIF Roberto O. ¿ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL query style (WAS: SQL search query)
Since I started this thread and am thankful for the help, my query works with just one flaw: it displays duplicate records. I've tried the SQL in two ways: SELECTDISTINCT p.ponumber, i.item, p.invoicenumber, p.vendor, p.cnumber, i.cnumber, p.state, p.podate FROM purchaseorders p JOIN itemsordered i ON p.cnumber=i.cnumber Where 0=0 and SELECT p.ponumber, i.item, p.invoicenumber, p.vendor, p.cnumber, i.cnumber, p.state, p.podate FROM purchaseorders p JOIN itemsordered i ON p.cnumber=i.cnumber Where Exists ( Select * from itemsordered i where p.cnumber=i.cnumber ) But is still grabs duplicate records from the itremsordered table. There the cnumber field is displayed for each item that is ordered. The purchaseorders table has the cnumber once since it just contains contact info. How can I just display one recordfor each cnumber when I do a search of all records for instance? Robert O. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 12:59 PM To: CF-Talk Subject: RE: SQL query style (WAS: SQL search query) While we are on the subject I have noticed recently that more and ore people are joining tables using the... FROM table1 x JOIN table2 y ON x.ID = y.ID And I am wondering if there is a reason for this.Sure I use this syntax for my outer joins but inner joins I still do the old fashioned way in the where clause, for example FROMtable1 x, table2 y WHERE x.ID = y.ID This has the added benefit of taking the place of the 'WHERE 0=0' line we recently discussed.What are the benefits of one form of inner join over the other or is it just today's SQL fashion trend? It's hardly a fashion trend - it's the law (ANSI SQL 92 specification). Most modern databases support explicit JOINs. It provides two benefits. Jochem mentioned that it separates filters from join conditions. As a byproduct of this, it prevents unintentional Cartesian products or cross joins, which can easily happen when you perform joins in a WHERE clause. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: SQL search query
I'm still new to SQL. I want to search two tables from a form. The search below does not give me any errors, but neither does it generate any hits even though I enter the correct items to look for. How do I edit the SQL to make it search info in both the purchaseorders and/or itemsordered tables? Thanks. cfquery name=Getpo datasource=purchaseorders SELECT * FROM purchaseorders p, itemsordered i Where 0=0 CFIF IsDefined(FORM.ponumber) And ponumber LIKE '%#FORM.ponumber#%' /CFIF CFIF IsDefined(FORM.invoicenumber) And invoicenumber LIKE '%#FORM.invoicenumber#%' /CFIF CFIF IsDefined(FORM.vendor) And vendor LIKE '#trim(FORM.vendor)#' /CFIF Order by p.cnumber DESC Robert O. ¿ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
drop-down list problem
I have a dynamic dropdown list that gets a statecode from a table and then compares to what is sent via form tag. It displays the state in the tag as selected along with other states that can be chosen in the dropdown. Its all OK, except it displays all the states twice. Any help with the code would be appreciated; here it is: select size=1 name=State size=20 cfoutput query=getstates option value=#trim(statecode)# CFIF trim(statecode) EQ trim(form.state)Selected/CFIF#left(trim(statename),15)#/option /cfoutput /select Thanks. Robert at HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: drop-down list problem
The table had doubles and I did not bother to look. Thanks. RO -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:31 AM To: CF-Talk Subject: Re: drop-down list problem On Mon, 14 Jun 2004 11:22:36 -0400, Robert Orlini wrote: I have a dynamic dropdown list that gets a statecode from a table and then compares to what is sent via form tag. It displays the state in the tag as selected along with other states that can be chosen in the dropdown. Its all OK, except it displays all the states twice. Any help with the code would be appreciated; here it is: select size=1 name=State size=20 cfoutput query=getstates option value=#trim(statecode)# CFIF trim(statecode) EQ trim(form.state)Selected/CFIF#left(trim(statename),15)#/option /cfoutput /select There's nothing in your code to indicate why you're getting doubles - before you run this code, can you CFDUMP the getStates query to make sure that it's not got the doubles within it? Oh, and get rid of the double SIZE attribute in the SELECT - either it's size 1 or it's size 20... which is it? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: JavaScript confirm delete
Anyone have or know where I can get some _javascript_ code that uses a _javascript_ confirm box to ask the user if they want to delete? Is there a CF way to do it? Thanks. Robert O. at HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JavaScript confirm delete
Done. Thanks all. Robert O. -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 3:35 PM To: CF-Talk Subject: RE: _javascript_ confirm delete Why not just say Form blah action="" confirm('Are you sure you want to delete?'); etc -Dov _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 3:30 PM To: CF-Talk Subject: RE: _javascript_ confirm delete Robert: Something like the following should do it for you.The confirm() function in _javascript_ creates a dialog box with OK and Cancel buttons. Pressing OK returns true, pressing Cancel returns false. SCRIPT LANGUAGE=_javascript_ !-- function confirmDelete() { var msg = Are you sure you want to delete?; if ( confirm(msg) ) { document.formName.submit(); } } // -- /SCRIPT FORM NAME=formName ACTION="" METHOD=Post INPUT TYPE=Button VALUE=Delete > /FORM Note, this was just whipped together and not tested.Also, the above form is incomplete.At the least, it should likely specify an ID of the object that is to be deleted, etc. ColdFusion can do this too but it requires an extra trip to the server, i.e., deleteForm.cfm - deleteConfirm.cfm - deleteAction.cfm -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message----- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 3:04 PM To: CF-Talk Subject: SOT: _javascript_ confirm delete Anyone have or know where I can get some _javascript_ code that uses a _javascript_ confirm box to ask the user if they want to delete? Is there a CF way to do it? Thanks. Robert O. at HWW _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
chars not accepted in SQL?
I get this error when I click SUBMIT in a form where I have an apostrophe in a name such as John's in the input field: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax near 's'. SQL = INSERT INTO itemsordered Is there a code/way to make SQL accept these characters. The ITEM column is setup as a CHAR field. Should it be VARCHAR? Thanks as always. Robert Orlini [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: chars not accepted in SQL?
I have an apostrophe in the input filed before I submit yes. How does this CFQUERYPARAM go into the Insert? The sample code I got below confused me. Sorry folks I'm a newbie at this, but I'm doing my best to try. SELECT STATEMENT WHERE column_name = cfqueryPARAM value = parameter value CFSQLType = parameter type maxLength = maximum parameter length scale = number of decimal places dbName = database name null = Yes or No list = Yes or No separator = separator character -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 9:52 AM To: CF-Talk Subject: Re: chars not accepted in SQL? On Fri, 11 Jun 2004 09:36:26 -0400, Robert Orlini wrote: I get this error when I click SUBMIT in a form where I have an apostrophe in a name such as John's in the input field: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax near 's'. SQL = INSERT INTO itemsordered Is there a code/way to make SQL accept these characters. The ITEM column is setup as a CHAR field. Should it be VARCHAR? It looks more like you have an apostrophie in the code You're probably not using CFQUERYPARAM for your insert, are you? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: chars not accepted in SQL?
Thanks. I have it down as: CFQUERY name=addPO datasource=purchaseorders INSERT INTO itemsordered (item) VALUES ('cfqueryparam value=#Trim(session.item[i][2])# cfsqltype=CF_SQL_CHAR') /cfquery It still gives a incorrect syntax error. How do I correctly incorporate that into the above insert? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 10:17 AM To: CF-Talk Subject: Re: chars not accepted in SQL? On Friday 11 Jun 2004 15:07 pm, Robert Orlini wrote: CFQUERYPARAM go into the Insert? The sample code I got below confused me. In most cases instead of dbFieldName=#thing# you write dbFieldName=cfqueryparam value=#thing# (If the query is in a loop,) it'll execute much faster too. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]