CFMAIL and us-ascii/utf-8 charsets
I've finally got a multipart email working with CFMAIL under CFMX -- with many thanks to Bob Everland and his CF_EmailEveryone tag. However, I've run into a slight problem with character sets. Because of copying/pasting text (from various origins) into a form to build a newsletter, occasionally the newsletter comes out with a strange symbol in place of an m-dash, apostrophe, etc. I know this can be solved on a website by going to a UTF-8 charset, but are there any problems with using UTF-8 in email? All of the examples of multipart email solutions I have seen use a charset of 'us-ascii' and content-transfer-encoding of 7bit...is there any reason to not use UTF-8? Best regards, David ~| 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
CFMX slow for specific sites?
G'mornin' everyone, Has anyone run into a problem with CFMX being really slow to render a page for one site, but runs just fine for another site on the same server? Here's the deal: The test server is a dual P3-750, 1 Gig ram, Windows 2000 server SP3, CFMX with latest updates. Website #1 comes up without any problem. Website #2 takes approx. 45 seconds (!) to finally come up, although when examining the debug settings it says the total execution time was only 270 ms. So why would it take 45 seconds for the page to actually come up, when it only takes 270ms for CFMX to render the page? I have the exact same websites loaded on a development machine (Win2kSP3, P3-900, 256mb RAM), and they both come up without any problem, under both CFMX (standalone webserver -- port 8500) and CF4.5, so even though I'll admit my code isn't bulletproof :-) it at least shouldn't account for the huge wait time. Any ideas what might be going on here? Regards, David ~| 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 slow for specific sites?
Thanks, Mark I'm pretty sure bandwidth and load aren't part of the issue; I'm actually on the test server when I do a page request, and this server isn't being hit from anywhere else -- its not even on the network :-) Completely isolated. Also, the CPU usage doesn't change appreciably when I do a page request -- no spiking or anything like that. It literally sits at 0%-1% for 45+ seconds before the page comes up. And, yes, the pages are all already compiled...when I hit refresh it takes just as long. What gets me is that the first website, using the same webserver hardware and software, just hums along without any problem. Is there something in the IIS/CFMX configuration that could account for this happening to just one website? David -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 10:14 AM To: CF-Talk Subject: RE: CFMX slow for specific sites? Dave, If your execution time is low, it''s likely that the page is being rendered and sent to the output buffer and it's the web server that is the bottleneck. How weighty is the page? On the local machine a very weighty page might come up quickly because there's no bandwidth issues or load. Also, I assume you are running multiple requests to the live server to account for the fact that CFMX must compile the page the first time it runs it. -Mark -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 8:55 AM To: CF-Talk Subject: CFMX slow for specific sites? G'mornin' everyone, Has anyone run into a problem with CFMX being really slow to render a page for one site, but runs just fine for another site on the same server? Here's the deal: The test server is a dual P3-750, 1 Gig ram, Windows 2000 server SP3, CFMX with latest updates. Website #1 comes up without any problem. Website #2 takes approx. 45 seconds (!) to finally come up, although when examining the debug settings it says the total execution time was only 270 ms. So why would it take 45 seconds for the page to actually come up, when it only takes 270ms for CFMX to render the page? I have the exact same websites loaded on a development machine (Win2kSP3, P3-900, 256mb RAM), and they both come up without any problem, under both CFMX (standalone webserver -- port 8500) and CF4.5, so even though I'll admit my code isn't bulletproof :-) it at least shouldn't account for the huge wait time. Any ideas what might be going on here? Regards, David ~| 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: CFMX slow for specific sites?
Nope, no ASPs here...just the 2 CFMX sites. What kind of diagnostics would you recommend for IIS? David -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 11:01 AM To: CF-Talk Subject: RE: CFMX slow for specific sites? Asp sites on the same server? Because yes it would be related. It's not the scripting engine that is causing your difficulty. Check your web server and overall server resources. -mk -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 9:13 AM To: CF-Talk Subject: Re: CFMX slow for specific sites? doubt its related but most of my asp sites have been barely crawling along lately - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 10:13 AM Subject: RE: CFMX slow for specific sites? Dave, If your execution time is low, it''s likely that the page is being rendered and sent to the output buffer and it's the web server that is the bottleneck. How weighty is the page? On the local machine a very weighty page might come up quickly because there's no bandwidth issues or load. Also, I assume you are running multiple requests to the live server to account for the fact that CFMX must compile the page the first time it runs it. -Mark -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 8:55 AM To: CF-Talk Subject: CFMX slow for specific sites? G'mornin' everyone, Has anyone run into a problem with CFMX being really slow to render a page for one site, but runs just fine for another site on the same server? Here's the deal: The test server is a dual P3-750, 1 Gig ram, Windows 2000 server SP3, CFMX with latest updates. Website #1 comes up without any problem. Website #2 takes approx. 45 seconds (!) to finally come up, although when examining the debug settings it says the total execution time was only 270 ms. So why would it take 45 seconds for the page to actually come up, when it only takes 270ms for CFMX to render the page? I have the exact same websites loaded on a development machine (Win2kSP3, P3-900, 256mb RAM), and they both come up without any problem, under both CFMX (standalone webserver -- port 8500) and CF4.5, so even though I'll admit my code isn't bulletproof :-) it at least shouldn't account for the huge wait time. Any ideas what might be going on here? Regards, David ~| 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 slow for specific sites? - SOLVED!
Alrighty, here's what the problem was: In the IIS settings for the slow site, under the Home Directory tab, Configuration option, then App Mappings tab, somehow through the installation of CFMX and/or the CFMX updater, I had duplicate entries for the .cfm, .cfc, .cfml, and .jsp entries. Even though they were all pointing to the same jrun.dll, it appears the duplicate entries caused the huge lag time between page execution and when it would actually show up in the browser. Hope this helps somebody else, too! David -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 10:28 AM To: CF-Talk Subject: RE: CFMX slow for specific sites? Thanks, Mark I'm pretty sure bandwidth and load aren't part of the issue; I'm actually on the test server when I do a page request, and this server isn't being hit from anywhere else -- its not even on the network :-) Completely isolated. Also, the CPU usage doesn't change appreciably when I do a page request -- no spiking or anything like that. It literally sits at 0%-1% for 45+ seconds before the page comes up. And, yes, the pages are all already compiled...when I hit refresh it takes just as long. What gets me is that the first website, using the same webserver hardware and software, just hums along without any problem. Is there something in the IIS/CFMX configuration that could account for this happening to just one website? David -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 10:14 AM To: CF-Talk Subject: RE: CFMX slow for specific sites? Dave, If your execution time is low, it''s likely that the page is being rendered and sent to the output buffer and it's the web server that is the bottleneck. How weighty is the page? On the local machine a very weighty page might come up quickly because there's no bandwidth issues or load. Also, I assume you are running multiple requests to the live server to account for the fact that CFMX must compile the page the first time it runs it. -Mark -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 8:55 AM To: CF-Talk Subject: CFMX slow for specific sites? G'mornin' everyone, Has anyone run into a problem with CFMX being really slow to render a page for one site, but runs just fine for another site on the same server? Here's the deal: The test server is a dual P3-750, 1 Gig ram, Windows 2000 server SP3, CFMX with latest updates. Website #1 comes up without any problem. Website #2 takes approx. 45 seconds (!) to finally come up, although when examining the debug settings it says the total execution time was only 270 ms. So why would it take 45 seconds for the page to actually come up, when it only takes 270ms for CFMX to render the page? I have the exact same websites loaded on a development machine (Win2kSP3, P3-900, 256mb RAM), and they both come up without any problem, under both CFMX (standalone webserver -- port 8500) and CF4.5, so even though I'll admit my code isn't bulletproof :-) it at least shouldn't account for the huge wait time. Any ideas what might be going on here? Regards, David ~| 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: Weird page loading issues
Hi Barney, I recently ran into the same thing -- its a config issue: You need to edit the jrun.xml file. This is typically installed at: C:\CFusionMX\runtime\servers\default\SERVER-INF Look for the variable cacheRealPath, and set it to false. That should fix it! David -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 6:55 PM To: CF-Talk Subject: Weird page loading issues I have three domains all containing a '/home.cfm'. When I run the first home.cfm (after clearing the cfclasses directory and restarting CFMX), it compiles and displays the right content. When I go to another domain and view home.cfm, it doesn't compile the appropriate template, it just serves the first domain's template. I can freely flip back and forth between the three domains and always get the same output. However, after between 7 and 8 minutes of not doing anything, when I view a different domain's home.cfm, it will compile and display that file for that request, and all subsequent requests, no matter the domain. Throught the whole process, cgi.server_name contains the appropriate field, but cgi.path_translated and cgi.cf_template_path contain the bungled values. This latter point makes me think that it might be the web server (Apache 2.0.44), but that seems unlikely to me. If anyone has any help on resolving the issue, I'd be very appreciative. CFMX with updater 2 on Apache 2.0.44 on RedHat. ~| 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
RE: Outlook and Cfmail
Josh - Try something like this (code below). You will need to make an html version of the email (FriendConfirmation.htm) and a text version (FriendConfirmation.txt) -- which I also use for AOL mail readers. Best regards, David cfset mimeBoundary = World=_WatchDaily cfmail to=#Attributes.friendEmail# from=World Watch Daily[EMAIL PROTECTED] subject=Personal recommendation from #Attributes.senderName# server=#request.mailserver# port=25 CFMAILPARAM name=X-mailer value=#chr(34)##mimeBoundary##chr(34)#multipart mailer v1.0 cfmailparam name=MIME-Version value=1.0 cfmailparam name=Content-Type value=multipart/alternative;boundary=#chr(34)##mimeBoundary##chr(34)# This is a Multipart MIME message. --#mimeBoundary# Content-Type:text/plain; charset=us-ascii cfinclude template=FriendConfirmation.txt --#mimeBoundary# Content-Type:text/x-aol; charset=us-ascii cfinclude template=FriendConfirmation.txt --#mimeBoundary# Content-Type:text/html; charset=us-ascii cfinclude template=FriendConfirmation.htm --#mimeBoundary#-- /cfmail David Grabbe News Editor World Watch Daily [EMAIL PROTECTED] http://worldwatchdaily.org -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 9:53 AM To: CF-Talk Subject: Outlook and Cfmail Is there anyway to send an email so that if the user has html it shows up html formatted and if they are setup as plain text then it will only show the plain text email? Josh __ 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
Do you have enough disk space on the disk your mail server is located? Best regards, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -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 __ 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
SQL insanity...
I need some help from your SQL gurus out there :) Here's the deal: we are keeping a running tally of the sermons which have been downloaded the most over the past 30 days. Every time a sermon is downloaded, I write a record out to a sermons_details table, where the primary key is the sermon number. This is working fine: cfset TestDate = CreateODBCDate(Now()) cfset Last30Days = '#DateAdd(d,-30,#TestDate#)#' cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally FROM sermons_details WHERE sermons_details.date_stamp = #Last30Days# AND sermons_details.subject = 'SERMONACCESS' GROUP BY sermons_details.sermon_num ORDER BY count(sermons_details.sermon_num) DESC /cfquery This counts up the number of detail records, and orders them. Works like a champ. The difficulty comes in when I try to get the info from the header record for each sermon: cfquery name=most_requested datasource=maindsn maxrows=5 SELECT sermons.title, sermons.tape, sermons.name, speakers.initials, sermons.size FROM sermons, speakers WHERE tape IN (cfloop query=sermon_nums'#sermon_num#'cfif nums.currentrow LT 5,/cfif/cfloop) AND sermons.size 0 --- AND speakers.full_name = sermons.speaker /cfquery This gets the right info, but now the ordering is off -- the second query isn't ordered according to which sermon was downloaded most. I'm assuming there is a way to do all of this with a single query, but so far I haven't been able to figure it out. Oh yeah, I'm (still) using Access2000, so the functionality of the DB is a bit limited too. Ideas? TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: SQL insanity...
I tried this: cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally, sermons.title, sermons.tape, sermons.name, speakers.initials, sermons.size FROM (sermons_details INNER JOIN sermons ON sermons_details.sermon_num = sermons.tape) INNER JOIN speakers ON sermons.speaker = speakers.full_name WHERE sermons_details.date_stamp = #Last30Days# AND sermons_details.subject = 'SERMONACCESS' GROUP BY sermons_details.sermon_num ORDER BY count(sermons_details.sermon_num) DESC /cfquery ...and I got this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'title' as part of an aggregate function. ideas? David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:32 PM To: CF-Talk Subject: Re: SQL insanity... Why not do a join... something like this I expect... cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally sermons.title etc, speakers.initials FROM sermons_details JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num JOIN speakers ON sermons.speaker = speaker.full_name WHERE sermons_details.date_stamp = #Last30Days# AND sermons_details.subject = 'SERMONACCESS' GROUP BY sermons_details.sermon_num ORDER BY count(sermons_details.sermon_num) DESC /cfquery This counts up the number of detail records, and orders them. Works like a At 03:07 PM 4/17/02 -0400, you wrote: I need some help from your SQL gurus out there :) Here's the deal: we are keeping a running tally of the sermons which have been downloaded the most over the past 30 days. Every time a sermon is downloaded, I write a record out to a sermons_details table, where the primary key is the sermon number. This is working fine: cfset TestDate = CreateODBCDate(Now()) cfset Last30Days = '#DateAdd(d,-30,#TestDate#)#' cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally FROM sermons_details WHERE sermons_details.date_stamp = #Last30Days# AND sermons_details.subject = 'SERMONACCESS' GROUP BY sermons_details.sermon_num ORDER BY count(sermons_details.sermon_num) DESC /cfquery This counts up the number of detail records, and orders them. Works like a champ. The difficulty comes in when I try to get the info from the header record for each sermon: cfquery name=most_requested datasource=maindsn maxrows=5 SELECT sermons.title, sermons.tape, sermons.name, speakers.initials, sermons.size FROM sermons, speakers WHERE tape IN (cfloop query=sermon_nums'#sermon_num#'cfif nums.currentrow LT 5,/cfif/cfloop) AND sermons.size 0 --- AND speakers.full_name = sermons.speaker /cfquery This gets the right info, but now the ordering is off -- the second query isn't ordered according to which sermon was downloaded most. I'm assuming there is a way to do all of this with a single query, but so far I haven't been able to figure it out. Oh yeah, I'm (still) using Access2000, so the functionality of the DB is a bit limited too. Ideas? TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: SQL insanity...
Yup -- that was it. Thanks for the help. David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: David DiPietro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 4:03 PM To: CF-Talk Subject: RE: SQL insanity... Every item in the select statement other than the count needs to be in the group by statement -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 4:01 PM To: CF-Talk Subject: RE: SQL insanity... I tried this: cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally, sermons.title, sermons.tape, sermons.name, speakers.initials, sermons.size FROM (sermons_details INNER JOIN sermons ON sermons_details.sermon_num = sermons.tape) INNER JOIN speakers ON sermons.speaker = speakers.full_name WHERE sermons_details.date_stamp = #Last30Days# AND sermons_details.subject = 'SERMONACCESS' GROUP BY sermons_details.sermon_num ORDER BY count(sermons_details.sermon_num) DESC /cfquery .and I got this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'title' as part of an aggregate function. ideas? David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:32 PM To: CF-Talk Subject: Re: SQL insanity... Why not do a join... something like this I expect... cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally sermons.title etc, speakers.initials FROM sermons_details JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num JOIN speakers ON sermons.speaker = speaker.full_name WHERE sermons_details.date_stamp = #Last30Days# AND sermons_details.subject = 'SERMONACCESS' GROUP BY sermons_details.sermon_num ORDER BY count(sermons_details.sermon_num) DESC /cfquery This counts up the number of detail records, and orders them. Works like a At 03:07 PM 4/17/02 -0400, you wrote: I need some help from your SQL gurus out there :) Here's the deal: we are keeping a running tally of the sermons which have been downloaded the most over the past 30 days. Every time a sermon is downloaded, I write a record out to a sermons_details table, where the primary key is the sermon number. This is working fine: cfset TestDate = CreateODBCDate(Now()) cfset Last30Days = '#DateAdd(d,-30,#TestDate#)#' cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally FROM sermons_details WHERE sermons_details.date_stamp = #Last30Days# AND sermons_details.subject = 'SERMONACCESS' GROUP BY sermons_details.sermon_num ORDER BY count(sermons_details.sermon_num) DESC /cfquery This counts up the number of detail records, and orders them. Works like a champ. The difficulty comes in when I try to get the info from the header record for each sermon: cfquery name=most_requested datasource=maindsn maxrows=5 SELECT sermons.title, sermons.tape, sermons.name, speakers.initials, sermons.size FROM sermons, speakers WHERE tape IN (cfloop query=sermon_nums'#sermon_num#'cfif nums.currentrow LT 5,/cfif/cfloop) AND sermons.size 0 --- AND speakers.full_name = sermons.speaker /cfquery This gets the right info, but now the ordering is off -- the second query isn't ordered according to which sermon was downloaded most. I'm assuming there is a way to do all of this with a single query, but so far I haven't been able to figure it out. Oh yeah, I'm (still) using Access2000, so the functionality of the DB is a bit limited too. Ideas? TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: inetinfo.exe taking 99% of CPU?
Nope -- ANY CF script, even without any database processing, loops, etc. David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 9:46 AM To: CF-Talk Subject: RE: inetinfo.exe taking 99% of CPU? is it any particular CF script? if so, perhaps there's an infinite loop or somesuch. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:53 PM To: CF-Talk Subject: SOT: inetinfo.exe taking 99% of CPU? Hello all, I've run into a problem with my local development machine (Win2k, IIS, CF 4.5). For some bizarre reason today whenever I try to run a CF script, the INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I can get it to release is to reboot. I have tried uninstalling and reinstalling IIS, but that didn't help. Has anyone else run into this problem with inetinfo before? Any ideas why this started happening, and how I can make it stop? :) TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: inetinfo.exe taking 99% of CPU?
Here's the code:
-
cfif ParameterExists(m) IS No
cfset m=d
/cfif
cfif ParameterExists(s) IS No
cfset s=photo_date
/cfif
cfquery name=ygt_gallery datasource=cgg maxrows=10
SELECT *
FROM gallery
ORDER BY #s#
cfif m IS dDESCcfelseASC/cfif
/cfquery
html
head
titlePhoto Gallery/title
SCRIPT LANGUAGE=JavaScript
!--
function SetAll()
{
}
function launchModify(int_num) {
terms = window.open(ygt_gallery_modify.cfm?int_num= +
int_num, mini,
scrollbars=yes,resizable=yes,status=yes,width=800,height=600);
self.mini = terms
}
function launchAdd() {
terms = window.open(ygt_gallery_modify.cfm, mini,
scrollbars=yes,resizable=yes,status=yes,width=800,height=600);
self.mini = terms
}
function launchDelete(int_num) {
terms = window.open(ygt_gallery_delete.cfm?int_num= +
int_num, mini,
scrollbars=yes,resizable=yes,status=yes,width=800,height=250);
self.mini = terms
}
//--
/SCRIPT
/head
body OnLoad=SetAll() LANGUAGE=JavaScript
cfset flag=0
div align=center
A href=JavaScript:launchAdd()font size=2 face=arialAdd
New/a/font
/div
table align=center border=1 bordercolor=black cellspacing=0
cellpadding=0trtd
table
cf_clickable_header
column_headers = Photo Date,Title,Caption,Filename,Active?,,
field_names = photo_date,title,caption,file_name,active_rec
column_sort = Y,Y,N,Y,N
file_name = ygt_gallery_admin.cfm
m=#m#
s=#s#
bg_color=a8a8ff
cfoutput query=ygt_gallery
cfif flag IS 1
CFSET flag=0
tr bgcolor=c1
cfelse
CFSET flag=1
tr
/cfif
tdfont size=2 face=arial#DateFormat(photo_date,
m/d/)#/td
tdfont size=2 face=arial#title#/td
tdfont size=2 face=arial#caption#/a/td
td align=centerfont size=2 face=arial#file_name#/td
td align=centerfont size=2 face=arial#active_rec#/td
td
A href=JavaScript:launchModify('#int_num#')
font size=2 face=arialedit/anbsp:nbsp;nbsp;nbsp;
A href=JavaScript:launchDelete('#int_num#')
font size=2 face=arialdelete/a
/td
/tr
/cfoutput
/table
/td/tr/table
/body
/html
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:52 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?
[snip]
this suggest that the problem is a coding problem and not related to file
corruption or a service pack fix. I would suggest you look at you code more
closly or post it here for all the gang to take a crack at.
Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org
-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:45 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?
Nope -- ANY CF script, even without any database processing, loops, etc.
David
David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org
-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:46 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?
is it any particular CF script? if so, perhaps there's an infinite loop or
somesuch.
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:53 PM
To: CF-Talk
Subject: SOT: inetinfo.exe taking 99% of CPU?
Hello all,
I've run into a problem with my local development machine (Win2k, IIS, CF
4.5). For some bizarre reason today whenever I try to run a CF script, the
INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I
can get it to release is to reboot. I have tried uninstalling and
reinstalling IIS, but that didn't help. Has anyone else run into this
problem with inetinfo before? Any ideas why this started happening, and how
I can make it stop? :)
TIA,
David
David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org
__
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
SOT: inetinfo.exe taking 99% of CPU?
Hello all, I've run into a problem with my local development machine (Win2k, IIS, CF 4.5). For some bizarre reason today whenever I try to run a CF script, the INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I can get it to release is to reboot. I have tried uninstalling and reinstalling IIS, but that didn't help. Has anyone else run into this problem with inetinfo before? Any ideas why this started happening, and how I can make it stop? :) TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: WOT: INACCESSIBLE_BOOT_DEVICE error on Win2k
No, tried that -- same error. I ended up doing a new Win2k install and then accessing the old HD through that. David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Jacob [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 5:23 PM To: CF-Talk Subject: Re: WOT: INACCESSIBLE_BOOT_DEVICE error on Win2k Can you boot into safe mode? At 11:28 AM 3/10/2002 -0500, you wrote: Hello all, This is not even remotely a CF question :) but the contributors to this list have a broad range of experience, so I'm hoping somebody has run into this before and has a solution. One of our older Win2k machines went down -- the m-board is fried (bad power supply) but the HD seems to be OK. I tried hooking up the old HD with a new m-board/processor. When I try to boot up, Windows starts going through its normal boot sequence, but then always blue-screens with a STOP error message that says INACCESSIBLE_BOOT_DEVICE. I've gleaned enough from MSDN to know that Win2k doesn't like it when there is a radical hardware change (i.e. different motherboard and proc), but their suggestion to reinstall Windows isn't an option at this point. Has anyone run into this before? Any solutions? Greatly appreciative, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cgg.org http://www.cgg.org/ __ 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
Need help with mappings in CF Admin
I'm stuck on getting these CF mappings to work. In CF Admin, I have set up a logical path called '/articles/', and a physical path of 'C:\Inetpub\wwwroot\test_domain1\literature\articles\'. I am trying to access this directory from a different domain: test_domain2 (same box). I set up a link to a file in this directory: A href=index.cfm/page/articles.#file_name# .and in my index.cfm I have the CF_INCLUDE line: CFINCLUDE template=#Replace(Attributes.page, ., /, ALL)#.htm So when I have the url http://www.test_domain2.com/index.cfm/page/articles.file0407.htm .the index.cfm should map the 'articles' back to the 'C:\Inetpub\wwwroot\test_domain1\literature\articles\', and the filename (file0407.htm) should be included. But its not working that way. Can anyone see what's wrong here? Thanks in advance, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org - Original Message - From: Dave Hannum Subject: Re: CFINCLUDE and virtual directories Date: Tue, 26 Feb 2002 10:48:19 -0800 You need to map the includes from a physical path in the CF Administrator: Click on Mappings in your CF Administrator Give the include a logical path and map it to the physical (directory) path. Voila - it works. Dave - Original Message - From: David Grabbe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 1:48 PM Subject: CFINCLUDE and virtual directories I need to be able to CFINCLUDE files from a directory on a different website (same server though). In IIS I have set up a virtual mapping so the directory in question is available to both websites -- as a real directory in the first website (domain1) and a virtual directory in the second (domain2). The mapping works fine -- I can access the same files from the directory regardless of which domain I am under. The kink comes in when I try to CFINCLUDE a file listed in the virtual directory. That is, I can access http://domain2.com/dir1/dir2/filename.htm, but when I try to include that file in a template (http://domain2.com/index.cfm/page/dir1.dir2.filename.htm) I get the template not found error. But this works fine when the directory is being accessed as a standard directory rather than a virtual directory (http://domain1.com/index.cfm/page/dir1.dir2.filename.htm). Has anyone run into this before? What am I missing here? Thanks bunches, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: Need help with mappings in CF Admin
Thanks, Bryan. That solved it. Didn't realize I needed a leading /. David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 2:08 PM To: CF-Talk Subject: RE: Need help with mappings in CF Admin could be many things. What's the value of attributes.page? Most likely you just need to add a / in front of the replace() function like this... CFINCLUDE template=/#Replace(Attributes.page, ., /, ALL)#.htm If the template in a CFINCLUDE tag begins with a / then CF looks for a CF mapping, otherwise it will try the file relative to it's current position in the file system. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 9:38 AM To: CF-Talk Subject: Need help with mappings in CF Admin I'm stuck on getting these CF mappings to work. In CF Admin, I have set up a logical path called '/articles/', and a physical path of 'C:\Inetpub\wwwroot\test_domain1\literature\articles\'. I am trying to access this directory from a different domain: test_domain2 (same box). I set up a link to a file in this directory: A href=index.cfm/page/articles.#file_name# and in my index.cfm I have the CF_INCLUDE line: CFINCLUDE template=#Replace(Attributes.page, ., /, ALL)#.htm So when I have the url http://www.test_domain2.com/index.cfm/page/articles.file0407.htm the index.cfm should map the 'articles' back to the 'C:\Inetpub\wwwroot\test_domain1\literature\articles\', and the filename (file0407.htm) should be included. But its not working that way. Can anyone see what's wrong here? Thanks in advance, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org - Original Message - From: Dave Hannum Subject: Re: CFINCLUDE and virtual directories Date: Tue, 26 Feb 2002 10:48:19 -0800 You need to map the includes from a physical path in the CF Administrator: Click on Mappings in your CF Administrator Give the include a logical path and map it to the physical (directory) path. Voila - it works. Dave - Original Message - From: David Grabbe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 1:48 PM Subject: CFINCLUDE and virtual directories I need to be able to CFINCLUDE files from a directory on a different website (same server though). In IIS I have set up a virtual mapping so the directory in question is available to both websites -- as a real directory in the first website (domain1) and a virtual directory in the second (domain2). The mapping works fine -- I can access the same files from the directory regardless of which domain I am under. The kink comes in when I try to CFINCLUDE a file listed in the virtual directory. That is, I can access http://domain2.com/dir1/dir2/filename.htm, but when I try to include that file in a template (http://domain2.com/index.cfm/page/dir1.dir2.filename.htm) I get the template not found error. But this works fine when the directory is being accessed as a standard directory rather than a virtual directory (http://domain1.com/index.cfm/page/dir1.dir2.filename.htm). Has anyone run into this before? What am I missing here? Thanks bunches, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: Need help with mappings in CF Admin
Are there any safeguards I can use to protect against this? David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 2:57 PM To: CF-Talk Subject: RE: Need help with mappings in CF Admin [snip] Also, it's worth noting that there's a possible security issue in using information from the browser to build the TEMPLATE attribute of a CFINCLUDE tag, since the end user could potentially change that information to reference a file that you don't want to include. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Database locked by admin?
I think that was at least part of the problem -- I checked in CF Admin, and that box was checked... Thanks for the tips! David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 7:23 AM To: CF-Talk Subject: Re: Database locked by admin? When setting up an Access datasource on CF, you should ALWAYS uncheck the Maintain Database Connections box under CF Settings in the ODBC Data Sources administrator. CF hangs on to the connection and can lock out other users trying to access the same tables. Access is not a very good RDBMS for web applications. 2000 is much better than 97, but still is not real good. Dave - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:07 AM Subject: RE: Database locked by admin? While using Access you may want to set you session variables for a shorter period of time, so that when CF accesses the database it will also let go in a short amount of time. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 2:57 PM To: CF-Talk Subject: Re: Database locked by admin? I am getting an error message about my database being locked by 'admin' and was wondering if anyone out there has any suggestions: Message: ODBC Error Code = S1000 (General error)P Native error code: -1102 SQLState: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'MYMACHINE'.PPData Source = mydatasourceP In the archives I found that this may be because the database is corrupt -- I've run the compression/correction option on it (MS-Access database), but this keeps happening. The database this error occurs on is my visitors log -- for every page hit I write out a record w/ the HTTP referrer, USER_AGENT, date/time, etc. The website isn't high-volume at all (i.e. averaging around 1000 page hits/day), but when these errors come up IS when there are a relatively large number of page requests (for this website) within a short period of time. ODBC problem? MDAC? Need to upgrade to SQL server? :) First off, I would highly recommend against using Access in a production environment. While 1000 hits/day isn't exactly Amazon.com volume, that's a respectable number and you should consider looking into an upgrade to a RDBMS such as SQL Server. The problem with access is that only one person may access (no pun intended) the DB at a time because an Access database is by default set up to be opened exclusively. So if two people concurrently try and hit the database, Access will lock the other user out -- hence your error. I doubt it's a corruption thing, although I don't know what your DB looks like either. Make sure nobody has the database open in the Access program itself. This also causes an exclusive lock that will prevent others from accessing it. But, again, if you're at 1000 hits/day and that number may go up, I would highly recommend looking into a more suitable solution such as SQL Server, MySQL, Oracle, etc. Regards, Dave. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF mappings with a template?
I'm stuck on getting these CF mappings to work. In CF Admin, I have set up a logical path called '/articles/', and a physical path of 'C:\Inetpub\wwwroot\test_domain1\literature\articles\'. I am trying to access this directory from a different domain: test_domain2 (same box). I set up a link to a file in this directory: A href=index.cfm/page/articles.#file_name# ..and in my index.cfm I have the CF_INCLUDE line: CFINCLUDE template=#Replace(Attributes.page, ., /, ALL)#.htm So when I have the url http://www.test_domain2.com/index.cfm/page/articles.file0407.htm ..the index.cfm should map the 'articles' back to the 'C:\Inetpub\wwwroot\test_domain1\literature\articles\', and the filename (file0407.htm) should be included. But its not working that way. Can anyone see what's wrong here? Thanks in advance, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org - Original Message - From: Dave Hannum Subject: Re: CFINCLUDE and virtual directories Date: Tue, 26 Feb 2002 10:48:19 -0800 You need to map the includes from a physical path in the CF Administrator: Click on Mappings in your CF Administrator Give the include a logical path and map it to the physical (directory) path. Voila - it works. Dave - Original Message - From: David Grabbe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 1:48 PM Subject: CFINCLUDE and virtual directories I need to be able to CFINCLUDE files from a directory on a different website (same server though). In IIS I have set up a virtual mapping so the directory in question is available to both websites -- as a real directory in the first website (domain1) and a virtual directory in the second (domain2). The mapping works fine -- I can access the same files from the directory regardless of which domain I am under. The kink comes in when I try to CFINCLUDE a file listed in the virtual directory. That is, I can access http://domain2.com/dir1/dir2/filename.htm, but when I try to include that file in a template (http://domain2.com/index.cfm/page/dir1.dir2.filename.htm) I get the template not found error. But this works fine when the directory is being accessed as a standard directory rather than a virtual directory (http://domain1.com/index.cfm/page/dir1.dir2.filename.htm). Has anyone run into this before? What am I missing here? Thanks bunches, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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
Database locked by admin?
I am getting an error message about my database being locked by 'admin' and was wondering if anyone out there has any suggestions: Message: ODBC Error Code = S1000 (General error)P Native error code: -1102 SQLState: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'MYMACHINE'.PPData Source = mydatasourceP In the archives I found that this may be because the database is corrupt -- I've run the compression/correction option on it (MS-Access database), but this keeps happening. The database this error occurs on is my visitors log -- for every page hit I write out a record w/ the HTTP referrer, USER_AGENT, date/time, etc. The website isn't high-volume at all (i.e. averaging around 1000 page hits/day), but when these errors come up IS when there are a relatively large number of page requests (for this website) within a short period of time. ODBC problem? MDAC? Need to upgrade to SQL server? :) TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ 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: INACCESSIBLE_BOOT_DEVICE error on Win2k
Thanks -- this is just what I was looking for. David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Dirk Sieber [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 1:10 PM To: CF-Talk Subject: RE: INACCESSIBLE_BOOT_DEVICE error on Win2k Hi David, You might want to take a look at this page: http://www.windowsreinstall.com/install/other/motherboard/problems.htm They discuss this exact issue, and a variety of possible solutions. Dirk -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 10, 2002 8:29 AM To: CF-Talk Subject: WOT: INACCESSIBLE_BOOT_DEVICE error on Win2k Hello all, This is not even remotely a CF question :) but the contributors to this list have a broad range of experience, so I'm hoping somebody has run into this before and has a solution. One of our older Win2k machines went down -- the m-board is fried (bad power supply) but the HD seems to be OK. I tried hooking up the old HD with a new m-board/processor. When I try to boot up, Windows starts going through its normal boot sequence, but then always blue-screens with a STOP error message that says INACCESSIBLE_BOOT_DEVICE. I've gleaned enough from MSDN to know that Win2k doesn't like it when there is a radical hardware change (i.e. different motherboard and proc), but their suggestion to reinstall Windows isn't an option at this point. Has anyone run into this before? Any solutions? Greatly appreciative, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cgg.org http://www.cgg.org/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WOT: INACCESSIBLE_BOOT_DEVICE error on Win2k
Hello all, This is not even remotely a CF question :) but the contributors to this list have a broad range of experience, so I'm hoping somebody has run into this before and has a solution. One of our older Win2k machines went down -- the m-board is fried (bad power supply) but the HD seems to be OK. I tried hooking up the old HD with a new m-board/processor. When I try to boot up, Windows starts going through its normal boot sequence, but then always blue-screens with a STOP error message that says INACCESSIBLE_BOOT_DEVICE. I've gleaned enough from MSDN to know that Win2k doesn't like it when there is a radical hardware change (i.e. different motherboard and proc), but their suggestion to reinstall Windows isn't an option at this point. Has anyone run into this before? Any solutions? Greatly appreciative, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cgg.org http://www.cgg.org/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: INACCESSIBLE_BOOT_DEVICE error on Win2k
Both systems (fried and new) are IDE...the old m-board is legacy (old) enough that I haven't been able to find a matching model. David -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 10, 2002 11:45 AM To: CF-Talk Subject: Re: INACCESSIBLE_BOOT_DEVICE error on Win2k Are you using the same Drive Controller (I.e. IDE or SCSI). We have found that if you have the same motherboard to use temporarily you can install drivers for whatever else you are using beforehand. Let us know what you figure out. Neil - Original Message - From: David Grabbe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 11:28 AM Subject: WOT: INACCESSIBLE_BOOT_DEVICE error on Win2k Hello all, This is not even remotely a CF question :) but the contributors to this list have a broad range of experience, so I'm hoping somebody has run into this before and has a solution. One of our older Win2k machines went down -- the m-board is fried (bad power supply) but the HD seems to be OK. I tried hooking up the old HD with a new m-board/processor. When I try to boot up, Windows starts going through its normal boot sequence, but then always blue-screens with a STOP error message that says INACCESSIBLE_BOOT_DEVICE. I've gleaned enough from MSDN to know that Win2k doesn't like it when there is a radical hardware change (i.e. different motherboard and proc), but their suggestion to reinstall Windows isn't an option at this point. Has anyone run into this before? Any solutions? Greatly appreciative, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cgg.org http://www.cgg.org/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFINCLUDE and virtual directories
I need to be able to CFINCLUDE files from a directory on a different website (same server though). In IIS I have set up a virtual mapping so the directory in question is available to both websites -- as a real directory in the first website (domain1) and a virtual directory in the second (domain2). The mapping works fine -- I can access the same files from the directory regardless of which domain I am under. The kink comes in when I try to CFINCLUDE a file listed in the virtual directory. That is, I can access http://domain2.com/dir1/dir2/filename.htm, but when I try to include that file in a template (http://domain2.com/index.cfm/page/dir1.dir2.filename.htm) I get the template not found error. But this works fine when the directory is being accessed as a standard directory rather than a virtual directory (http://domain1.com/index.cfm/page/dir1.dir2.filename.htm). Has anyone run into this before? What am I missing here? Thanks bunches, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf_mail, cf_NoTags and too much extra whitespace!
We have an HTML and a text-only version for each of our email newsletters. The content is pulled in from a database. The problem is that when the editor enters the content into the database, he occasionally sprinkles in some HTML with it (style definitions, blockquote tags, etc)so of course the recipients of the text-only versions get HTML in their email -- not a good thing. I've tried using a couple of different custom tags that will strip out the HTML, but when those tags are run within the cf_mail tag, they add in lots of extra whitespace -- which is fine for the HTML version, but which really messes up the text version. Can anyone see a way out of this? TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf_mail, cf_NoTags and too much extra whitespace!
Thanks -- that worked beautifully. David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 1:23 PM To: CF-Talk Subject: RE: cf_mail, cf_NoTags and too much extra whitespace! Yes, in the custom tags that strip out the html, wrap all non output with CFSILENT. HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 10:11 AM To: CF-Talk Subject: cf_mail, cf_NoTags and too much extra whitespace! We have an HTML and a text-only version for each of our email newsletters. The content is pulled in from a database. The problem is that when the editor enters the content into the database, he occasionally sprinkles in some HTML with it (style definitions, blockquote tags, etc)so of course the recipients of the text-only versions get HTML in their email -- not a good thing. I've tried using a couple of different custom tags that will strip out the HTML, but when those tags are run within the cf_mail tag, they add in lots of extra whitespace -- which is fine for the HTML version, but which really messes up the text version. Can anyone see a way out of this? TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The darndest time w/ Cookies. Actually form checking.
Chris, I'm not quite sure what error you are having (am I missing something from the post???)...but if the problem is with the JavaScript alert not coming up, try using ParameterExists(...) rather than IsDefined(...). HTH, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Chris Luksha [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 3:39 PM To: CF-Talk Subject: The darndest time w/ Cookies. Actually form checking. I apologize if this ends up getting posted a couple times. I haven't seen the first posting in over an hour and I got a bounceback message from the second attempt. So here is the third... I am having the hardest time setting a cookie. I think it is actually in testing for the form field. Simple login application. -User comes to page -gets authorized -If remember me is checked, set a cookie Here is the code for setting the cookie. CFIF get_user.recordcount CFSET Session.current_user_id = get_user.userID !--- If Remember Me was checked, set a cookie on user's computer w/ User ID. --- CFIF IsDefined(form.rememberme) IS Yes SCRIPT TYPE=text/javascript alert(Hey set a cookie will you!) /SCRIPT For testing of course CFCOOKIE name=sID value=#get_user.userID# EXPIRES=NEVER /CFIF The form field looks like this INPUT TYPE=checkbox NAME=rememberme VALUE=YesFONT face=Tahomanbsp;Remember Me/FONT I have tried everything I can think of. I have read 3 diferent examples of this exact thing. Could it be that I am using the cf4.5 svr that comes w/ cfstudio, and not on a real live server? I know that some things do not function properly on this version of the server software, but I don't know which things. Thanks __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML E-mail Stats
Ben - For the email newsletters that we send out, on average about 25% of the users are signed up for the text-only version. The vast majority of the users are in non-technical fields, and I'm sure that influences the numbers a bit -- i.e. certain tech gurus preferring or swearing by text-only emails :) whereas your average home user might enjoy the color, graphics etc. available w/ an HTML email. This isn't always the case though; some people w/ web-based email accounts (Hotmail, yahoo, etc) actually do sign up for the text version. HTH, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 2:02 PM To: CF-Talk Subject: HTML E-mail Stats Does anyone have (or heard of) or any stats on how many people are unable to view HTML e-mail messages? Or, if anyone does a mailing list where people can choose plain text or HTML, how many choose plain text? TIA, Ben Morris __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT
Hi Tony, Church of the Great God's website (http://www.cgg.org) is also written in CF. Regards, David - Original Message - From: Tony Hicks [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 9:56 PM Subject: OT Any y'all got Christian sites written in CF? Thanks, Tony Hicks -- Search the Holy Bible: http://www.bibleclicks.com ~~ 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
Using Verity to index a db table
'afternoon, everyone I'm using Verity to index a db table (Access) and the indexing works fine. However, specifying a URLPath doesn't seem to work. I recognize conceptually that if you are pulling something from a DB there isn't a path to get back to the databut is there any way, given the data that is returned from the CFSEARCH tag, to build a query string so the Title within the search results can be hyperlinked (i.e. to a dynamic page which will pull up that data)? Many thanks, David ~~ 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: Verity: Can I search just on the TITLE of a document?
Thanks, Raymond. Actually, what I described/asked about would only be a side feature -- not the full extent of Verity's use. I am planning on using as much of Verity's searching capabilities as possible, and this would just be one of the options available for display. You mentioned using another technique if possible -- do you know of one that might work for this? David -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 5:23 PM To: CF-Talk Subject: RE: Verity: Can I search just on the TITLE of a document? You can pass CF_TITLE to the criteria string. Now, I'm not sure if Verity will auto add the text between TITLE tags when it indexes your site, but you can try it. FYI, you can find out more here: http://localhost/CFDOCS/Developing_ColdFusion_Applications/indexSearch7. html#1096786 Of course, change localhost to your local CF server. To be honest, using Verity in this fashion seems a bit like overkill. You won't be using any of Verity's searching power. You will be just saying All docs where title begins with A. I'd suggest using another technique if possible. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 5:14 PM To: CF-Talk Subject: Verity: Can I search just on the TITLE of a document? Hi everyone, In Verity, is it possible to search just on the title of a document? Or does Verity treat all text w/in a document the same? Rather than displaying x number of records per page and then using the Next/Previous scenario, I would like to have it organized alphabetically by the title: 26 links across the top of the page (A,B,C...), and clicking on one of the letters will display the documents whose title begins with that letter. Is this sort of goofiness possible? Thanks in advance, David ~~ 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
Verity: Can I search just on the TITLE of a document?
Hi everyone, In Verity, is it possible to search just on the title of a document? Or does Verity treat all text w/in a document the same? Rather than displaying x number of records per page and then using the Next/Previous scenario, I would like to have it organized alphabetically by the title: 26 links across the top of the page (A,B,C...), and clicking on one of the letters will display the documents whose title begins with that letter. Is this sort of goofiness possible? Thanks in advance, David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Search Safe String - How-To?
I understand that in order to make a URL search engine happy it can't contain the '?' or '' charactersall of the solutions I have seen revolve around replacing those with the backslash. I'm running into a problem, though, because the values of my URL variables regularly have a backslash in them already -- to delineate a directory on the web server: http://www.domain.com/home.cfm?page=news/worldnews.cfmlang=en ...and so forth. (Every page is based off the 'home.cfm?page=foo.cfm' template, for ease of including a header, navigation, etc). so the backslash in 'news/worldnews.cfm' is throwing me a curve. I've 'inherited' this site -- not sure if this architecture is a good one or not. Its great because of the template structure, but now that i'm trying to optimize it for search engines, its becoming a pain because of the directory notation. Any suggestions for fixing the URLs for the search engines and/or the underlying structure of the site? TIA, David -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 12:10 PM To: CF-Talk Subject: Re: Search Safe String - How-To? Try this: http://spider-food.net/dynamic-page-optimization.html Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 11:59 AM Subject: Search Safe String - How-To? Where can I find some information on using the Search Safe String methodology (part of Fusebox I believe?) I went to fusebox.org but couldn't find anything specifically detailing how this is done, etc. Thanks! Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
replacing carriage-returns in a db field with commas?
'afternoon everyone, We are storing meta-tag Description and Keyword information for many of our documents in a database (MS-Access 2000), so the meta information can be maintained without having to make changes to a static page. The problem I am running into is that the individual who entered in the Keywords delimited them by hitting the Enter key rather than putting a comma in between...will search engines recognize this? (is it as effective?) If commas are the recommended route, is there a way in SQL (MS Access) to do a global replace on that field and replace all the carriage returns with the normal comma+space delim.? Any pointers would be greatly appreciated! Cheers, David ~~ 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: replacing carriage-returns in a db field with commas?
I gave this code a try, but CF choked on the 'chr' part...does that function (ListChangeDelims) actually take 3 parameters? David -Original Message- From: Chris Martinez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 2:41 PM To: CF-Talk Subject: RE: replacing carriage-returns in a db field with commas? I'm not sure about the first part of your question but the second part goes something like this: CFQUERY NAME=Get DATASOURCE=#DSN# SELECT YourField FROM YourTable ORDER BY YourPrimaryKey /CFQUERY CFOUTPUT QUERY=GET CFSET NewVal = ListChangeDelims(Get.YourField, , , chr(013)chr(010)) CFQUERY NAME=Put DATASOURCE=#DSN# UPDATE YourTable SET (YourField=#NewVal#) /CFQUERY /CFOUTPUT This should do it. Have fun Chris -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 1:17 PM To: CF-Talk Subject: replacing carriage-returns in a db field with commas? 'afternoon everyone, We are storing meta-tag Description and Keyword information for many of our documents in a database (MS-Access 2000), so the meta information can be maintained without having to make changes to a static page. The problem I am running into is that the individual who entered in the Keywords delimited them by hitting the Enter key rather than putting a comma in between...will search engines recognize this? (is it as effective?) If commas are the recommended route, is there a way in SQL (MS Access) to do a global replace on that field and replace all the carriage returns with the normal comma+space delim.? Any pointers would be greatly appreciated! Cheers, David ~~ 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
Data-modeling for anniversaries...
I've run into a data-modeling stumper. I have a database table which contains wedding anniversaries and the respective couple's name. The date is stored as the wedding date, so calculating the anniversary is easy. The primary usage of this is to display the anniversaries on a monthly calendar. However, now i need to select just the anniversaries which will be coming up in the next week. The problem is that since the dates are stored with the original years (i.e. 11/28/1970), I can't just select the dates that are between a specific date range, because the year will throw that all out of whack. So how can i select based just on the month/day, also taking into account that in the middle of the week the month can change to the next month (November-December)? Any ideas? Cheers, David ~~ 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: Data-modeling for anniversaries...
Is there a way to do the same thing in Access2000? David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:09 PM To: CF-Talk Subject: RE: Data-modeling for anniversaries... I would use a series of database functions to turn the original date into a date in the current year, like this (Oracle-ish code since I don't know what DB you're using but am too lazy to find the exact syntax): to_date (to_char(aniv_date_field, 'm-d') + '-' + currentyear(), 'm-d-' ) now I have a date field and can compare to today and today + 7 days. -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:31 PM To: CF-Talk Subject: Data-modeling for anniversaries... I've run into a data-modeling stumper. I have a database table which contains wedding anniversaries and the respective couple's name. The date is stored as the wedding date, so calculating the anniversary is easy. The primary usage of this is to display the anniversaries on a monthly calendar. However, now i need to select just the anniversaries which will be coming up in the next week. The problem is that since the dates are stored with the original years (i.e. 11/28/1970), I can't just select the dates that are between a specific date range, because the year will throw that all out of whack. So how can i select based just on the month/day, also taking into account that in the middle of the week the month can change to the next month (November-December)? Any ideas? Cheers, David ~~ 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
Duplicate e-mails generated by CFMAIL?
Hello all, I am in the process of putting together an e-mail newsletter (using CFMAIL), and everything is working fine except that each email address is receiving TWO emails instead of one. Obviously this is not going to make for happy recipients :) Can anybody see (from the code below) why I am generating duplicate emails? Cheers, David - cfset TestDate = CreateODBCDate(Now()) cfset yesterday = '#DateAdd(d,-1,#TestDate#)#' cfquery name=email_address datasource=dsn cachedwithin=#CreateTimeSpan(0,23,0,0)# SELECT email FROM users /cfquery cfquery name=articles datasource=dsn cachedwithin=#CreateTimeSpan(0,23,0,0)# SELECT * FROM world_news WHERE date_entered = #yesterday# AND date_entered #TestDate# ORDER BY news_date DESC /cfquery cfif articles.RecordCount GT 0 cfloop query=email_address cfmail to=#email_address.email# from=[EMAIL PROTECTED] subject=Daily News server=home.com port=25 type=HTML !--- beginning of email content here --- cfloop query=articles !--- Looping through the news articles... --- /cfloop /cfmail /cfloop /cfif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I increment counter field by clicking on link?
Hi Tom, What you might try is creating a script that updates the visits table by one, and then use CFLOCATION to redirect to the specified #WebAddress#. Change your anchor tag to point to this script: A href=scriptname.cfm?WebAddress=#WebAddress# TARGET=bottomright .and then create your scriptname.cfm: --- cfquery name=Update datasource=dsn maxrows=1 UPDATE table SET visits = visits+1 WHERE WebAddress='#WebAddress#' /cfquery cfoutput cflocation URL=#WebAddress# /cfoutput HTH, David -Original Message- From: Tom Forbes [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 12:08 AM To: CF-Talk Subject: How do I increment counter field by clicking on link? Help Please - I have a database table with company information, and a field called Visits - The below link appears in the left hand frame panel. When clicked, the visitor sees the company's web site in the right hand frame (bottomright). A href=http://#WebAddress#; TARGET=bottomright#CompanyName#/a I want to increment the Visits field by one count every time the link is clicked. I have tried many approaches, but am unable to resolve this - can someone please help me?? Thanks very much! Tom *** MedMatrix Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 *** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Netscape allows script downloads???
OK, So I have some RealAudio files on my website, and I have 2 different types of links for each file: one link starts the RealAudio player, the other link is so the user can just download the file. For both of these links I point to a script keeps track of how many times this particular RA file has been downloaded. In IE, everything for the download works fine -- the user right-clicks, selects Save file as, and we're all good. In Netscape, I do a right-click Save link as, and instead of the script executing and then pointing to the correct RA file, the *script* is what suddenly becomes available for download -- not good, because it contains SQL, DSN info, etc. I then realized that (in Netscape) I could right-click, Save link as and download ANY .cfm file, whereas IE executes the script first and lets you download the resulting rendered web page. Is this an IIS setting? Any ideas on how to keep my scripts from being downloaded??? TIA Cheers, David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape allows script downloads???
Well, that is somewhat of a consolation -- even though it still has the .cfm extension on it, the pages don't actually contain the CF content. .so in regards to the original message, it isn't actually downloading the script (radl.cfm): it is downloading the RealAudio file, but renaming it as the radl.cfm page (i discovered this when i realized the supposed script file that i had downloaded was over 3 megs!). The question becomes: for Netscrape, is there a way to change the name? I've included the code for radl.cfm below; all it does it update the database and then redirect to the RealAudio content (either as a download or as a live stream). So even though the content of the download is actually a RealAudio file, Netscape still puts the script name as the name of the file.any ideas? -- radl.cfm cfquery name=Update datasource=dsn maxrows=1 Update table SET num_access = num_access+1 WHERE name='#name#' /cfquery cfif m IS 'listen' cflocation url=http://www.domain.com:7070/ramgen/#name#; cfelseif m IS 'dl' cflocation url=http://www.domain.com/realaudiocontent/#name#; /cfif - Cheers, David -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 12:47 PM To: CF-Talk Subject: RE: Netscape allows script downloads??? did you look at the .CFM file that downloads and actually see CF code? or is it all HTML? -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:33 AM To: CF-Talk Subject: Netscape allows script downloads??? OK, So I have some RealAudio files on my website, and I have 2 different types of links for each file: one link starts the RealAudio player, the other link is so the user can just download the file. For both of these links I point to a script keeps track of how many times this particular RA file has been downloaded. In IE, everything for the download works fine -- the user right-clicks, selects Save file as, and we're all good. In Netscape, I do a right-click Save link as, and instead of the script executing and then pointing to the correct RA file, the *script* is what suddenly becomes available for download -- not good, because it contains SQL, DSN info, etc. I then realized that (in Netscape) I could right-click, Save link as and download ANY .cfm file, whereas IE executes the script first and lets you download the resulting rendered web page. Is this an IIS setting? Any ideas on how to keep my scripts from being downloaded??? TIA Cheers, David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
duplicate logins
Hello All!
I'm running into a problem with session/cookie management, and am hoping
you folks would be able to point me in the right direction.
It's like this: we ask user's to sign in with basic information to gain
access to a certain part of the website. After they fill out the form, I
run a script which writes their information to a database and sets a session
variable to represent that they have already logged in (so they don't have
to log back in if they surf to other parts of the site and then come back).
This works fine for probably 85% of the users, but it seems that for some
users that session variable isn't getting set (I haven't been able to verify
this; I can't replicate the problem but I've received reports about it). It
might be an issue of the user turning of cookies -- which I am attempting to
catch and deal with in the Application.cfm file.
If the user is not accepting cookies, I'm trying to add the CFID and
CFTOKEN to the URL so I can still keep track of their session info.
Here's the code I am working with -- do you see anything amiss?
TIA!
Cheers,
David
---Application.cfm
cfapplication name=cgg clientmanagement=Yes sessionmanagement=Yes
setclientcookies=Yes sessiontimeout=#CreateTimeSpan(1,0,0,0)#
applicationtimeout=#createTimeSpan(1,0,0,0)# clientstorage=Cookie
setdomaincookies=Yes
CFIF NOT ISDEFINED(session.rollCount)
CFSET SESSION.ROLLCOUNT = 1
CFCOOKIE NAME=isOn VALUE=testing
CFSET APPLICATION.ADDTOKEN =
cfid=#client.cfid#cftoken=#client.cftoken#
CFELSE
CFSET APPLICATION.ADDTOKEN = IIF(NOT ISDEFINED(cookie.isOn),
DE(cfid=#client.cfid#cftoken=#client.cftoken#), DE())
/CFIF
---
---form processing page-
!--- Insert Query Here ---
cfquery name=Update_login datasource=dsn maxrows=1
INSERT INTO
tablename(name,city,state,zip,country,email,num_people,login_date,login_time
,http_user_agent)
VALUES('#name#','#city#','#state#','#zipcode#','#country#','#email#','#num_p
eople#','#DateFormat(Now(),MM/DD/)#','#TimeFormat(Now(), hh:mm:ss
tt)#','cfoutput#CGI.HTTP_USER_AGENT#/cfoutput')/cfquery
cfoutput
cfif (ParameterExists(save_info)) AND (#save_info# IS Yes)
cfcookie name=name value=#name# expires=NEVER
cfcookie name=city value=#city# expires=NEVER
cfcookie name=state value=#state# expires=NEVER
cfcookie name=zipcode value=#zipcode# expires=NEVER
cfcookie name=country value=#country# expires=NEVER
cfcookie name=email value=#email# expires=NEVER
cfelse
cfcookie name=name value=#name# expires=NOW
cfcookie name=city value=#city# expires=NOW
cfcookie name=state value=#state# expires=NOW
cfcookie name=zipcode value=#zipcode# expires=NOW
cfcookie name=country value=#country# expires=NOW
cfcookie name=email value=#email# expires=NOW
/cfif
/cfoutput
CFSET SESSION.LOGGED_IN = yes
script
self.location='newlocation.cfm';
/script
---
-newlocation.cfm---
CFIF SESSION.CGG_RA_LIVE_LOGGED_IN IS NOT yes
cflocation url=login.cfm addtoken=Yes
/CFIF
--- HTML content here ---
--
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RealAudio and ColdFusion
Still stumped on this. I tried using the 'FileExists()' method, but it didn't detect the RealAudio stream. Then I got onto the server console to verify that the .rm file was actually there -- and it wasn't! but we were indeed putting out a RealAudio stream. How is it possible for a RealAudio stream to be playing, and yet that .rm file doesn't exist anywhere on the file system of the server? The web server (IIS/CF) and RealServer are on the same machine, but the RealPublisher is on a remote machine. When the stream is started by the RealPublisher, we have to specify the domain (where the web server/RealServer is located), the RealAudio port (7070), and the stream filename (as well as username/password to gain access to that server/port). Yet when I check that server, the stream file is nowhere to be found. Am I out of my tree, or what?? Cheers, David -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 9:40 AM To: CF-Talk Subject: RE: RealAudio and ColdFusion Try FileExists(), as suggested by another post. If the file exists on the box it can be queried. Make sure to check the docs for usage. Steve -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 8:41 PM To: CF-Talk Subject: RE: RealAudio and ColdFusion Thanks, Steve. CF and RealServer ARE on the same machine, but since the .rm file is being sent out over a different port (7070), it doesn't seem to be available for normal file processing (I set up a CFDIRECTORY tag, and the .rm doesn't show up in the folder). Is there a way, then, to 'listen' on a different port and direct CFFILE or CFDIRECTORY in that direction? Cheers, David -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 5:44 PM To: CF-Talk Subject: RE: RealAudio and ColdFusion If CF and Real Server are on the same machine just use CFFILE. Steve -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 3:57 PM To: CF-Talk Subject: RealAudio and ColdFusion Howdy folks, I'm running CF 4.5.1. The organization I work for has a weekly program which we stream via RealAudio. The RealAudio aspect is working just fine, but I'm wondering if there is a way for CF to detect whether or not the RealAudio stream is active or not (i.e. check for the existence of the .rm file). I looked into using CFHTTP, but couldn't get that to work -- probably because of the media type. I'm not actually wanting to download, just see if the stream exists. If there an easy way to do this? Are there any RA gurus out there :) Thanks in advance! Cheers, David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RealAudio and ColdFusion
Howdy folks, I'm running CF 4.5.1. The organization I work for has a weekly program which we stream via RealAudio. The RealAudio aspect is working just fine, but I'm wondering if there is a way for CF to detect whether or not the RealAudio stream is active or not (i.e. check for the existence of the .rm file). I looked into using CFHTTP, but couldn't get that to work -- probably because of the media type. I'm not actually wanting to download, just see if the stream exists. If there an easy way to do this? Are there any RA gurus out there :) Thanks in advance! Cheers, David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RealAudio and ColdFusion
Thanks, Steve. CF and RealServer ARE on the same machine, but since the .rm file is being sent out over a different port (7070), it doesn't seem to be available for normal file processing (I set up a CFDIRECTORY tag, and the .rm doesn't show up in the folder). Is there a way, then, to 'listen' on a different port and direct CFFILE or CFDIRECTORY in that direction? Cheers, David -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 5:44 PM To: CF-Talk Subject: RE: RealAudio and ColdFusion If CF and Real Server are on the same machine just use CFFILE. Steve -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 3:57 PM To: CF-Talk Subject: RealAudio and ColdFusion Howdy folks, I'm running CF 4.5.1. The organization I work for has a weekly program which we stream via RealAudio. The RealAudio aspect is working just fine, but I'm wondering if there is a way for CF to detect whether or not the RealAudio stream is active or not (i.e. check for the existence of the .rm file). I looked into using CFHTTP, but couldn't get that to work -- probably because of the media type. I'm not actually wanting to download, just see if the stream exists. If there an easy way to do this? Are there any RA gurus out there :) Thanks in advance! Cheers, David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
