Dynamically creating multiple pages/rows of images from a query
Would like to create a preview page(s) of results froma search function from an image catalog. Displaying 1 image per row seems easy enough, but we would like to display 3 images per row and either 3 or 4 rows per page. Is a loop or multiple loops within a loop the only way to output 3 results per row as well as multiple rows? Or am I approaching this from a wrong-headed point of view. My mind tells me it should be much easier than what I'm thinking, but for the life of me I can't see how. Thanks, Charles Nahm ~| 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:189663 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: Dynamically creating multiple pages/rows of images from a query
Thank you very much Ian, Martin and Al. Your way is much better than my way of thinking for sure. I appreciate the virtual smack upside the head. Charles -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 12:25 PM To: CF-Talk Subject: RE: Dynamically creating multiple pages/rows of images from a query Something along these lines might get you started. cfset cols = 4!---number of columns you would like--- cfoutput table tr cfloop query=myQuery td#query.column#/td !---If the remainder of currentRow/cols is zero start a new row.--- cfif NOT myQuery.currentRow MOD cols /tr tr /cfif /cfloop /tr /table /cfoutput Off the top of my head, AKA debugging no doutedly necessary. This could also be very easily modified to create other structures to display the output. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Charles Nahm [mailto:[EMAIL PROTECTED] ...Sent: Friday, January 07, 2005 9:12 AM ...To: CF-Talk ...Subject: Dynamically creating multiple pages/rows of images from a query ... ...Would like to create a preview page(s) of results froma search function ...from ...an image catalog. Displaying 1 image per row seems easy enough, but we ...would like to display 3 images per row and either 3 or 4 rows per page. ... ...Is a loop or multiple loops within a loop the only way to output 3 ...results ...per row as well as multiple rows? Or am I approaching this from a ...wrong-headed point of view. My mind tells me it should be much easier ...than ...what I'm thinking, but for the life of me I can't see how. ... ...Thanks, ...Charles Nahm ... ... ... ~| 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:189671 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
Mysql and CF 5 - really slow db interaction?
Running an intranet app using mysql and CF5 on distinct W2k boxes on the same private subnet.It doesn't appear to be a network issue.I'm using the production build of the mysql odbc connector (3.51). However, writing a test record to a table takes many seconds (7-15 seconds). There is nothing else happening in the test script.Simply two inserts to two tables. This seems rather unacceptably slow. What things could possibly be causing this slowdown? Thank you very much for any help you can provide. Charles Nahm Sonic Networks Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PCode problem - just started today
Only thing that has changed is that some Windows updates were installed early this morning. All of a sudden, code that has worked fine for 2 years won't work.I'm getting this error: Error Diagnostic Information unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (104:3) to (104:51). This is for a DBase III type database. Searching through some google archievs I see reference to session variables and locking and the like, but this query is about as mundane as it gets: cfquery name=getunits datasource=DBIIIsource SELECT Units FROM TABLE WHERE Accountnumber = '#GetAccounts.AccountNumber#' /cfquery We are running CF 5 on a W 2K platform. Any ideas or help would be greatly appreciated.I'd like to emphasize that this code was working just fine yesterday as it had for the previous 2 years including when we ran on CF 4.5 and the only thing that has changed from yesterday to today is the Windows updates. Thank you, Charles Nahm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PCode problem - just started today
Thanks to all the respondants. I don't know DCOM from a hole in the ground.:) The problem went away after rebooting the PDC and then rebooting the CF server. Perhaps an unclean restart after the auto updates? Thank you for your help. Charles Nahm -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 10:32 AM To: CF-Talk Subject: Re: PCode problem - just started today Do you know if any of the database stuff for DBase ]|[ uses DCOM - thats what all this hub bub is about - a DCOM exploit. If the DBase connectivity or actual DBase program doesn't use DCOM it *might* not be the update. You might want to find out if it relys on DCOM, as you seem to think the windows update (I assume you mean that security path) hosed your system. Hope that helps On Wed, 2004-02-11 at 07:02, Charles Nahm wrote: Only thing that has changed is that some Windows updates were installed early this morning. All of a sudden, code that has worked fine for 2 years won't work.I'm getting this error: Error Diagnostic Information unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (104:3) to (104:51). This is for a DBase III type database. Searching through some google archievs I see reference to session variables and locking and the like, but this query is about as mundane as it gets: cfquery name=getunits datasource=DBIIIsource SELECT Units FROM TABLE WHERE Accountnumber = '#GetAccounts.AccountNumber#' /cfquery We are running CF 5 on a W 2K platform. Any ideas or help would be greatly appreciated.I'd like to emphasize that this code was working just fine yesterday as it had for the previous 2 years including when we ran on CF 4.5 and the only thing that has changed from yesterday to today is the Windows updates. -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF using up all available bandwidth?!
Hello, I was wondering if anyone had experienced something like this before. We are connected to our CF 5 server by a 10 MB connection. The connection has tested out fine as far as all the techs are concerned. However, every once in a while all bandwidth will get choked up or bottlenecked to the point where no access of any kind is available (for up to 15 seconds). Then it will return to normal as if nothing happened. At first I was absolutely convinced it was a worm or virus, but now I'm not so sure. I have tried isolating each and every machine on the network and it doesn't seem to make a difference. The only thing that I can think of is that maybe CF is gobbling up all of the available bandwidth when multiple concurrent attempts are made to access the server and databases. Maybe I'm totally off base and it is not related to CF at all, but I'm reaching at this point trying to explain an event that is random and sporadic and unreproducible. Any thoughts or comments would be greatly appreciated. Charles Nahm Sonic Networks Inc. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF using up all available bandwidth?!
Matt, We are running a Windows LAN, what exactly is a dreaded election? Charles Nahm Sonic Networks Inc. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:11 AM To: CF-Talk Subject: Re: CF using up all available bandwidth?! If you running a Windows LAN watch out for the dreaded elections, which will saturate a 10MB link in no time. Even better they often appear to happen at random. -Matt On Wednesday, August 27, 2003, at 10:09 AM, Charles Nahm wrote: Hello, I was wondering if anyone had experienced something like this before. We are connected to our CF 5 server by a 10 MB connection. The connection has tested out fine as far as all the techs are concerned. However, every once in a while all bandwidth will get choked up or bottlenecked to the point where no access of any kind is available (for up to 15 seconds). Then it will return to normal as if nothing happened. At first I was absolutely convinced it was a worm or virus, but now I'm not so sure. I have tried isolating each and every machine on the network and it doesn't seem to make a difference. The only thing that I can think of is that maybe CF is gobbling up all of the available bandwidth when multiple concurrent attempts are made to access the server and databases. Maybe I'm totally off base and it is not related to CF at all, but I'm reaching at this point trying to explain an event that is random and sporadic and unreproducible. Any thoughts or comments would be greatly appreciated. Charles Nahm Sonic Networks Inc. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CF using up all available bandwidth?!
Matt, Thank you. Sounds like it could be what's going on here. Appreciate the information greatly. Charles Nahm Sonic Networks Inc. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:28 AM To: CF-Talk Subject: Re: CF using up all available bandwidth?! In Windows LANs you have what is called the master browser, which keeps tracks of other Windows machines on the network. This is the machine that is in fact polled for information when a user opens up network neighborhood and starts looking at machines and their associated shares and printers. In a properly setup Windows LAN, the master browser should be the PDC. However, if for whatever reason the PDC is not responding as the master browser than a new master browser must be elected. When election is happening every Windows machine is broadcasting to the entire LAN their capabilities to take over as a master browser. Sometimes a master browser is elected that can't really handle the responsibility so another election ensues. These can continue for some time until a proper master browser is found or the LAN administrator takes preventive measures. -Matt On Wednesday, August 27, 2003, at 10:23 AM, Charles Nahm wrote: Matt, We are running a Windows LAN, what exactly is a dreaded election? Charles Nahm Sonic Networks Inc. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:11 AM To: CF-Talk Subject: Re: CF using up all available bandwidth?! If you running a Windows LAN watch out for the dreaded elections, which will saturate a 10MB link in no time. Even better they often appear to happen at random. -Matt On Wednesday, August 27, 2003, at 10:09 AM, Charles Nahm wrote: Hello, I was wondering if anyone had experienced something like this before. We are connected to our CF 5 server by a 10 MB connection. The connection has tested out fine as far as all the techs are concerned. However, every once in a while all bandwidth will get choked up or bottlenecked to the point where no access of any kind is available (for up to 15 seconds). Then it will return to normal as if nothing happened. At first I was absolutely convinced it was a worm or virus, but now I'm not so sure. I have tried isolating each and every machine on the network and it doesn't seem to make a difference. The only thing that I can think of is that maybe CF is gobbling up all of the available bandwidth when multiple concurrent attempts are made to access the server and databases. Maybe I'm totally off base and it is not related to CF at all, but I'm reaching at this point trying to explain an event that is random and sporadic and unreproducible. Any thoughts or comments would be greatly appreciated. Charles Nahm Sonic Networks Inc. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF using up all available bandwidth?!
Thomas, Thank you for the suggestion. I will try to find the programs you suggested. Charles Nahm Sonic Networks Inc. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:24 AM To: CF-Talk Subject: Re: CF using up all available bandwidth?! On Wednesday 27 Aug 2003 15:23 pm, Charles Nahm wrote: We are running a Windows LAN, what exactly is a dreaded election? If you're using WINS to resolve names, one of the machines on the network must be a 'master browser' and hold the up to date list of machines. Every so often (I think it's every 15 minutes) one of the other machines will decide it needs to check if the master is OK, and if not, start a process to 'elect' a new master. This causes a packet storm. On slow or congeted networks this can be a pain. I'd suggest setting up ethereal, tcpdump or something and looking at the network trafic directly. - Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Shopping Cart
I like Cartweaver. I'm a novice at best and not really a web programmer, but I've found it very easy to work with. Charles Nahm -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 5:41 PM To: CF-Talk Subject: Shopping Cart Hello All, Does anyone know of a good shopping cart. Nothing too elaborate, but something easy to implement. I don't feel like re-inventing the wheel. Thanks Joel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PC Configuration Shopping Cart
I don't know about pre-built for PC Configuration, but Cartweaver is pretty excellent and even I can use it so it's pretty dummy/novice proof and it is very customizable. Charles -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:49 PM To: CF-Talk Subject: PC Configuration Shopping Cart Anyone know of a pre-built PC Configuration Shopping cart? I'd love to build one, but it's for a friend and of course he doesn't have millions for development. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating to CFMX Updater 3 causes client ASP functions to stop working?
It was a form handler with a site redirect. I decided to cleanse the system with a reboot and everything came back up and the ASP is working again. Perhaps when I shut down the WWW Publishing services to install the updater I didn't restart everything like I thought I had although I'm certain I did. Thanks, Charles -Original Message- From: Sean [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 12:37 AM To: CF-Talk Subject: RE: Updating to CFMX Updater 3 causes client ASP functions to stop working? I've just re-checked a few ASP apps on my production server (IIS5/CFMX/Updater3/etc). I can't fault them. What sort of errors are you recieving? -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 April 2003 5:39 AM To: CF-Talk Subject: Updating to CFMX Updater 3 causes client ASP functions to stop working? Is this a known issue or is it likely that something else is at fault here? The ASP was working fine before the update, no changes were made and now not working after the CFMX update. Does this sound plausible? CFMX w/ IIS 5, everything patched to current. Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 3/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
Updating to CFMX Updater 3 causes client ASP functions to stop working?
Is this a known issue or is it likely that something else is at fault here? The ASP was working fine before the update, no changes were made and now not working after the CFMX update. Does this sound plausible? CFMX w/ IIS 5, everything patched to current. Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 3/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Administrator Page won't open
Thank you Candace, however, the CFIDE directories are in the default C:\inetpub\wwwroot directory. Also I have tried the IP and now tried allowing any unassigned IP to be used by the default site, but now it asks if I want to download the file instead of just opening it. I tried opening the index.cfm and it appears to be garbled or encrypted. BUT, I copied the exact files over and they work fine inside of another site, so I think it is a directory issue or default web site issue. Sorta stumped here. I sent an email to Macromedia support 2 days ago and have yet to hear back. Great support, glad I bothered to register and all so I can get Macromedia spam but no help at all when it comes to making their product work. Charles -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:04 AM To: CF-Talk Subject: RE: CFMX Administrator Page won't open Instead of localhost, I have to use the actual IP address on boxes where I am not using the default C:\InetPub... Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 3/25/2003 6:06:21 PM Just tried it same error message as localhost. I then tried letting it choose all unassigned IPs instead of binding it to one IP and now it tries to download the file?! When I click Open, it doesn't do anything. Thanks, Charles -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 5:57 PM To: CF-Talk Subject: RE: CFMX Administrator Page won't open Try http://127.0.0.1/CFIDE/Administrator/index.cfm -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 March 2003 9:38 AM To: CF-Talk Subject: CFMX Administrator Page won't open All the other CF sites on the box work fine. When I copied the CFIDE directory to another site on the same box it seems to run okay, but not within the root. http://localhost/CFIDE/Administrator/index.cfm it says file cannot be found when the file is clearly right there. In IIS (5), the Documents tab has index.cfm as one of the possible home pages for the default Site and the Default site is running. The JRunScripts directory appears in the default root as well as all the other site roots. I ran the IIS Connectors batch after adding the most recent sites as well. Is it fine for me to run the CF Admin from within another domain instead of the default or do I need to uninstall and reinstall everything? Thanks, Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.463 / Virus Database: 262 - Release Date: 3/17/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Administrator Page won't open
-Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED] Charles, I suggest you take a look at the CFMX installation release notes and follow the instructions for re-installing the JRun connector to IIS. Also you haven't specified what updater level you are at. If you have installed updater 3 then you should take a look at the New connector FAQ page at http://www.macromedia.com/support/coldfusion/ts/documents/connecto r_install_ faq.htm#MicrosoftIIS I downloaded the MX installer on the 11th, but apparently there has been a new one since then. I will try that first. Thanks. It's kinda a catch-22, where you need CFMX admin to open to see what version you are at, but CFMX admin is not working. Thanks for your help. Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 3/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IIS Problem
Randell, Thank you! I think you have isolated the problem. You are the man! For CFMX, the executable in question is: C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll Adding the .cfm extension and the executable worked. Can see the Admin again! Charles Nahm -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:57 AM To: CF-Talk Subject: Re: IIS Problem Go to IIS View the properties of the website Click on Home Directory Click on Configuration See if you have the extension of .cfm in the Application Mapping If not, add it Extension: .cfm Executable: C:\CFusion\bin\iscf.dll Check That File Exists: CHECKED [EMAIL PROTECTED] 03/26/03 11:13AM If I type in http://127.0.0.1/CFIDE/Administrator/Index.cfm the rather than opening my cfadmin page it opens a dialog box with options to SAVE, OPEN, CANCEL.. Same thing is happening for my website which is remotely used. What could be the reason. I've already restarted IIS quite few times. Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Administrator Page won't open
All the other CF sites on the box work fine. When I copied the CFIDE directory to another site on the same box it seems to run okay, but not within the root. http://localhost/CFIDE/Administrator/index.cfm it says file cannot be found when the file is clearly right there. In IIS (5), the Documents tab has index.cfm as one of the possible home pages for the default Site and the Default site is running. The JRunScripts directory appears in the default root as well as all the other site roots. I ran the IIS Connectors batch after adding the most recent sites as well. Is it fine for me to run the CF Admin from within another domain instead of the default or do I need to uninstall and reinstall everything? Thanks, Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.463 / Virus Database: 262 - Release Date: 3/17/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Administrator Page won't open
Just tried it same error message as localhost. I then tried letting it choose all unassigned IPs instead of binding it to one IP and now it tries to download the file?! When I click Open, it doesn't do anything. Thanks, Charles -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 5:57 PM To: CF-Talk Subject: RE: CFMX Administrator Page won't open Try http://127.0.0.1/CFIDE/Administrator/index.cfm -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 March 2003 9:38 AM To: CF-Talk Subject: CFMX Administrator Page won't open All the other CF sites on the box work fine. When I copied the CFIDE directory to another site on the same box it seems to run okay, but not within the root. http://localhost/CFIDE/Administrator/index.cfm it says file cannot be found when the file is clearly right there. In IIS (5), the Documents tab has index.cfm as one of the possible home pages for the default Site and the Default site is running. The JRunScripts directory appears in the default root as well as all the other site roots. I ran the IIS Connectors batch after adding the most recent sites as well. Is it fine for me to run the CF Admin from within another domain instead of the default or do I need to uninstall and reinstall everything? Thanks, Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.463 / Virus Database: 262 - Release Date: 3/17/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Julian Date Format output 0YYDDD
Does someone have a function built to convert the current date to a julian format? Thanks, Charles Nahm Sonic Networks Inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Julian Date Format output 0YYDDD
-Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] I have a udf, will that do? Hello Robert, I am not sure what a udf is. If it is something I can learn and use fairly easily, it would be much appreciated. I would welcome any help that will assist me in solving this issue. Thanks, Charles Nahm __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Julian Date Format output 0YYDDD
-Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] What is julian exactly? Just curious? Please give an example. Some archaic Unix based date format from what I can see. It is still used by some banks. The format is 0YYDDD, so today would be 002150 (assuming there have been 150 days total this year). Regards, Charles Nahm __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Julian Date Format output 0YYDDD
Thank you Robert.
Could you provide a small usage sample for the function?
Would it be like:
JDate = '#Julian(Now(), '0YYDDD')#'
Thanks,
Charles Nahm
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 12:36 PM
To: CF-Talk
Subject: RE: Julian Date Format output 0YYDDD
Here is what I have
CFSCRIPT
/**
* Returns a gregorian date if a julian date is submitted, or returns a
julian date if a gregorian date is submitted.
*
* @param date
* @param outvar
* @return Returns a date.
* @author Robert Everland III ([EMAIL PROTECTED])
* @version 1, January 10, 2002
*/
function julian(date, date_format)
{
if (isnumeric(date))
{
if (len(date) eq 5)
{
date = 0 date;
}
if (left(date,3) LT 100)
{
yr = 19 right(left(date,3),2);
}
else
{
yr = 20 right(left(date,3),2);
}
days = right(date,3)-1;
firstday = 1/1/ yr;
return dateformat(dateadd(d,days,firstday),date_format);
}
else if (isdate(date))
{
date = dateformat(date, mm/dd/);
if (year(date) eq 1999)
{
return 0 left(99000+Dayofyear(date),5);
}
else
{
return
left(1right(date,2)right(00Dayofyear(date),3),6);
}
}
return Not a valid date;
}
/CFSCRIPT
Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com
-Original Message-
From: Charles Nahm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 12:41 PM
To: CF-Talk
Subject: RE: Julian Date Format output 0YYDDD
-Original Message-
From: Jim Vosika [mailto:[EMAIL PROTECTED]]
What is julian exactly? Just curious? Please give an example.
Some archaic Unix based date format from what I can see. It is still used
by some banks.
The format is 0YYDDD, so today would be 002150 (assuming there
have been 150
days total this year).
Regards,
Charles Nahm
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Reading only part of a really big text file...
If I have a 270 MB log file, can I use CF to split it up into say ten 27 MB files or some such thing? Or maybe into like 100,000 lines per file or some such thing. I'm currently finding it impossible to view the contents of this file due to the size. Purchased a file splitting utility, but it was unable to do the task. Have not been able to load the file in Notepad or Word. I'm hoping there might be a CF way around this. Thanks, Charles Nahm Sonic Networks Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading only part of a really big text file...
-Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] What, may I ask, are you trying to do with it? I guess analyze for patterns would be the best description. Basically just wanted to do text searches for key phrases. If you are trying to garner info out of it, may I suggest grep, sed awk, or perl? Depending on your need for searching. Are these Unix tools? We are running Windows 2K. If you need to query it as if it were data, do you have access to MSSQL and DTS? You could import the whole darn thing into a table. If you need to analyze the info in it (look for patterns and such), there are a number of free web log analysis tools out there. Thanks, I was not aware of this. Charles Nahm Sonic Networks Inc. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail error
I think this happened to me last week or the week before. Check disk space on the CF Server and make sure there are no 0 length files in the CF Spool. Regards, Charles Nahm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 2:46 PM To: CF-Talk Subject: cfmail error Does anybody know what this is all about: -- unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (1:1) to (5:2). --- It's suddenly started happening everytime CFMail tries to send an email. We're running CF5. We just recently changed our mail server machine, so we figured maybe it wasn't able to connect to the new machine. But we checked the CF Administrator and it verified the connection to the mail server. Has anybody ever seen that error before or have any clue as to what's causing it? jim __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
A way to hide the CF source on a website?
Is there a way to do this? Thanks, Charles __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A way to hide the CF source on a website?
-Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Depends on what you mean by hide and who you are wanting to hide it from. I guess by hide I mean things like file locations, IPs, certain keys and strings and such for server side processing of tasks such as CC validation or account manipulation. If only the HTML of the page shows up, then that's fine, but if everything shows up, then I guess it would be a small concern. I guess hiding my poor excuse for code is another thing too. :) Charles __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A way to hide the CF source on a website?
-Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED]] Yes, I guess I was not quite clear. Since the CF source does NOT appear, I only assumed that she meant the resultant HTML code. I did not realize the CF source does not appear. I am sorry for the confusion. I am still a rookie at this whole business. Thanks everyone for your help and patience. Charles __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using cftransaction/cftransaction... Why?
-Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] What it means to you as a developer is essentially that however many queries you do inside a CFSTRANSACTION/CFTRANSACTION block they will ALL be executed at the same time (well, they won't strictly, but it will look that way to you). Generally you use them to maintain database query integrit, think of this (most common) example... Is there much of a processing cost to this? If not why wouldn't I surround all my associated query blocks with the cftransaction tags. Thank you very much to all who responded and emailed, Charles Nahm __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Server Enterprise versus Server Professional - what is the diff?
Can anyone please give me a quick run-down on the key differences between the two? Charles __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Enterprise versus Server Professional - what is the diff?
-Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] oi Critz!! Don't forget Verity is able to index more docs in Ent (250k vs 100k) and also advanced security. - Original Message - From: Critz [EMAIL PROTECTED] oi Charles!! Enterprise = more $$$ plus support for clustered servers /me thinks -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Clustering and native ODBC drivers (ie. oracle) on the Enterprise version. Probably more, but those seem to be the biggest differences. Thank you Adam, Critz and Pete. Clustered servers?! not sure what that is, but pretty sure we don't need it. As far as the native ODBC driver thing goes, can I use SQL Server 2000 and MS Access with the Professional Server? We do not use any Oracle here... Charles __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Enterprise versus Server Professional - what is the diff?
-Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Charles, Can anyone please give me a quick run-down on the key differences between the two? http://www.macromedia.com/software/coldfusion/productinfo/matrix/cf 5_matrix. pdf Quick enough for you? ;o) Fantastic, thank you Stephen, do you know if this applies to the products in version 4.5 as well? I love this list! Charles __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Enterprise versus Server Professional - what is the di ff?
-Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Ride on brother, stay away from oracle until you can afford $400/hr or until you need to impress the VC's. I myself don't enjoy paying for cocky asses to fly around in MIG jets and propose National ID cards to the government - regardless of how much faster (http://tpc.org/tpcw/results/tpcw_perf_results.asp) their DB is. Interesting snippet: http://slashdot.org/article.pl?sid=02/04/17/179252mode=thread To answer your question, yes - you can use SQL server and Access just fine with professional. You have an option of using ODBC or OLEDB with SQL server. That's great, thank you very much! Charles __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Enterprise versus Server Professional - what is the diff?
-Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Personally, I think CF Pro can handle the needs of the vast majority of CF-based web sites. If you don't need those extras, you should certainly get Pro, and if in the future you realize you need some of those extras, just upgrade your license to Enterprise. Thanks. To answer your points specifically, you can most certainly use SQL2K and Access with Pro, since they use standard ODBC and Microsoft's drivers. You can also use Oracle, since there are ODBC drivers for Oracle, you just won't get the Merant drivers (which I never use anyway, and we do use Oracle). We currently use the Merant 3.60 drivers to access some DBase III (.dbf) files from a legacy system. We purchased the Merant drivers separately from what I understand. Do you know if we will still be able to integrate the Merant drivers with the CF Pro Server? Thank you very much again for your help! Charles __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using cftransaction/cftransaction... Why?
Are cftransaction tags necessary for certain types of queries (e.g. queries involving Merant driver access to a DBaseIII database?). I am working with some code from the past and I notice the cftransaction tags in some areas but not in others. Recently I have added more stress/queries to the DBaseIII databases and am noticing big slowdowns in the processes that require access to those files... In: http://www.cfcertification.com/cfdocs/CFML_Language_Reference/2_ColdFusion_T ags/lr2_098.htm They say it can be used to group multiple transactions into one single business event. What does that mean? Does this mean the database will be locked out until all the functions within the cftransaction tags are finished? Is this a requirement for certain types of db's? Any help/ideas appreciated, you people have been amazing. Thanks. Charles __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Submitting a form only once, iow, preventing impatient user double clicks.
-Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Oh! Oh! I know this one! I know this one! Someone helped me with this just the other day :) Thank you to Angel, Diana, Justin, Thane, Larry and [EMAIL PROTECTED] Unbelievably fast helpful people on this list. Charles Nahm Sonic Networks Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
