excel dsn woes (file used by another process)
Hi I have a situation where I get 6 different excel spreadsheets uploaded to a website - then have to import them into one database (I do not have any control over this). The spreadsheets have the same fields. I have an excel DSN called update So I upload the 6 files, loop over each one and if it's file name (less the extension) is in a table (tbl_category) I rename it to the dsn file name, then import into the main database. Then I delete that file get the next one and so on. However I get an error when deleting each renamed file (Error processing CFFILE Unable to delete the file 'C:\InetPub\wwwroot\nmm\DropBox\update.xls.' The process cannot access the file because it is being used by another process. (error 32)) I have put in !--- Disable connections to remove read-only lock on the file --- CFSET CFUSION_DISABLE_DBCONNECTIONS(#request.health_update_dsn#, 1) !--- Enable connections if they've been disabled --- CFSET CFUSION_DISABLE_DBCONNECTIONS(#request.health_update_dsn#, 0) but this doesn't seem to help. Does anyone have any clues please. BTW if set things up so each loop is done manually ie go to first file, do insert stuff, click to do next file it works fine. MTIA Seamus Seamus Campbell Boldacious WebDesign http://www.boldacious.com [EMAIL PROTECTED] ph 02 6297 4883 fax 02 6297 8464 mob 0410 609 267 ~| 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
CF based blogging software
Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. I need to convince a company to let me write a blogger for them for a fee. :) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| 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: CF based blogging software
Michael Dinowitz wrote: Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. BlogMX, http://www.benorama.com/ Jochem ~| 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: CF based blogging software
Thanks. I'll try it out but for some reason it 'feels' overly complicated. Michael Dinowitz wrote: Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. BlogMX, http://www.benorama.com/ Jochem ~| 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
activePDF webgrabber
Has anybody had issues with this product and ColdFusion MX cfchart? Although I can successfully web grab any screen with graphics, the moment I attempt to web grab a report containing 15 cfchart graphs, it doesn't even get passed the 1st graph. Slightly doing my head in. Adam ~| 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: CF based blogging software
Hi everyone, BlogMX on benorama.com is just a very basic example application, and is definitely not a complete blogging system (and as you rightly said, it is overly complicated for what it does, because it is just a sample application showing a methodology aimed to build more complex applications). Moreover it was written in august 2002... so it does not represent the latest best practices for CFMX. I plan to write an updated version, with updated best practices next month. For your information, that's funny, because there is currently an initiative launched on CFCDev mailing list to build a blogging system by following different methodologies/frameworks in order to be able to compare them. The discussion has just started few days ago, so it is really just the begining and you might have to wait several month before to see any results. Untill then, you might also check Raymond Camden blog CFC : http://www.camdenfamily.com/morpheus/blog/blog.zip (which looks more like a real blogging system) Benoit Hediard www.benorama.com -Message d'origine- De : Jochem van Dieten [mailto:[EMAIL PROTECTED] Envoyé : mardi 1 avril 2003 10:40 À : CF-Talk Objet : Re: CF based blogging software Michael Dinowitz wrote: Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. BlogMX, http://www.benorama.com/ Jochem ~| 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
Oracle CF5
Hi all, I have a bit of a problem I wouldn't mind some help with - We are using CF5 and Oracle 8i(8.1.7.0.0) (using Native drivers) and our application is running REALLY slowly. We have tuned the queries as much as we see possible and cached wherever possible although the neature of the beast makes caching a bit of a pipe-dream. I have been doing some debugging and found that the first query of the page is taking a very long time: getnews (Records=3, Time=2359ms) SQL = SELECT news_id, headline FROMnews WHERE show = 1 ORDER BY newsdate desc These are not big records and the query is very fast if I perform it through SQLPLUS or TOAD (Oracle gui devlopment tool) - the rest of the queries on the page are then performed in regular time. A tnsping of the box produces: Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=*REMOVEDHOSTNAME*)(PORT=1521)) OK (40 msec) so the connection to the oracle instance itself seems to be a reasonable time. Does anyone have any ideas that could help us out as it is starting to cause problems Many Thanks Simon ~| 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: activePDF webgrabber
Just to udate. You must have WebGrabber.EngineToUse = 1 set to make it work. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 09:54 To: CF-Talk Subject: activePDF webgrabber Has anybody had issues with this product and ColdFusion MX cfchart? Although I can successfully web grab any screen with graphics, the moment I attempt to web grab a report containing 15 cfchart graphs, it doesn't even get passed the 1st graph. Slightly doing my head in. Adam ~| 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
CF is creating a new session after each page refresh!
Hi, I have just developed an application in CF 5 which is using session variables and I am coming across some strange behavior by CF. On each page load CF is assigning a new session to each page visit, I know this as CFID increments by one after I use CFDUMP VAR =#session# at the top of the page. Every time I hit F5 CFID increments by 1. This is the CFAPPLICATION tag: --- CFAPPLICATION NAME=myAppHere SESSIONMANAGEMENT=Yes SETCLIENTCOOKIES=No SESSIONTIMEOUT=#createtimespan(0,0,20,0) # --- The client doesnt want to use cookies so I am passing the CFID\CFTOKEN around in the URL as below: CFLOCK TIMEOUT=20 THROWONTIMEOUT=No TYPE=READONLY SCOPE=SESSION A HREF=publishArticle.cfm? CFOUTPUT#SESSION.URLToken#/CFOUTPUTa link/A /CFLOCK This is working fine on my development box (again CF5) but when we upload to the clients server this increment problem happens? If anyone could shed any light on this matter I would appreciate it. Thanks Oliver Cookson ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
SQL: Deleting items older than 7 days from today
Hey all,
I'm trying to do this with a single SQL statement.
Delete all records from the table tblEvents that are older than 7 days.
:)
This is the code I tried using:
CFQUERY name=DE Datasource=#DSN#
Select * FROM tblEvents
WHERE Now() - estarttime = 7
/CFQUERY
CFDUMP var=#DE#
CFQUERY name=DE2 Datasource=#DSN#
Select * FROM tblEvents
WHERE #DateDiff('dd',Now(),estarttime)# GTE 7
/CFQUERY
CFDUMP VAR=#DE2#
The first query works fine...the second one throws an error:
Error Diagnostic Information
An error occurred while evaluating the expression:
#DateDiff('dd',Now(),estarttime)#
Error near line 19, column 9.
~|
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: Deleting items older than 7 days from today
Try this:
WHERE DATEDIFF(d, estarttime, NOW()) = 7
HTH!
Scott
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 9:12 AM
To: CF-Talk
Subject: SQL: Deleting items older than 7 days from today
Hey all,
I'm trying to do this with a single SQL statement.
Delete all records from the table tblEvents that are older
than 7 days.
:)
This is the code I tried using:
CFQUERY name=DE Datasource=#DSN#
Select * FROM tblEvents
WHERE Now() - estarttime = 7
/CFQUERY
CFDUMP var=#DE#
CFQUERY name=DE2 Datasource=#DSN#
Select * FROM tblEvents
WHERE #DateDiff('dd',Now(),estarttime)# GTE 7
/CFQUERY
CFDUMP VAR=#DE2#
The first query works fine...the second one throws an error:
Error Diagnostic Information
An error occurred while evaluating the expression:
#DateDiff('dd',Now(),estarttime)#
Error near line 19, column 9.
~|
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
loopy loop!
I have this loop that runs ~22,000 iterations. It brings the server to its
knees. The RAM usage skyrockets above 800 Megs cutting into major virtual
memory. But when I just write the output instead of storing it to a
variable, it runs fine. I'm trying to retrieve a list of email addresses
and then write them to a file.
cfscript
emails = ;
for( i = 1; i lte list.recordcount; i=i+1 )
{
emails = emails list.email[i] chr(13) chr(10);
}
/cfscript
I can't imagine that the list in memory would take that much room. Does
anyone have a suggestion?
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com
~|
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: cf forum suggestions
we use http://forum.snitz.com/ lately...its free...an ASP app, so you need a winblows server for it. Works well enough. Doug -Original Message- From: Jas Panesar [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 11:56 PM To: CF-Talk Subject: cf forum suggestions Apologize for asking a question that has no doubt been asked before, couldn't find the search button on the houseoffusion.com site. I am presently bringing up a project manager to handle work with developers and clients. One of the requirements is to be able to attach a forum to an entire client, as well as any one of their projects. I am looking to use this forums software in a slew of other projects, I was wondering if anyone could make any suggestions. So far I've noticed cfforums is a good bang for the buck, feature, and presumably extensibility wise (with the open source license) but, before I take the leap, I want some first hand experience of the different forums out there on extending and customizing the forums (open source would be a must). Thanks in advance! Jas ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Deleting items older than 7 days from today
'#DateDiff('d',Now(),estarttime)#
Error near line 17, column 9.
~|
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: CF based blogging software
Michael, I have a copy of Fuseblog if you would like me to send it to you off-line. We used it as the basis for our blog. I also tried out Benoit's CFC based blog after we had already set up Fuseblog and that is very interesting conceptually with its use of CFC's, XML etc. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:37 AM To: CF-Talk Subject: CF based blogging software Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. I need to convince a company to let me write a blogger for them for a fee. :) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| 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: Deleting items older than 7 days from today
Don't use CF for it, let the SQL do the work for you...
Just setup your SQL statement like this:
Select * FROM tblEvents
WHERE DateDiff(d, GETDATE(), estarttime) = 7
(Sorry, I referenced NOW() last time...it should be GETDATE())
HTH,
Scott
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 9:29 AM
To: CF-Talk
Subject: RE: Deleting items older than 7 days from today
'#DateDiff('d',Now(),estarttime)#
Error near line 17, column 9.
~|
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: loopy loop!
How about replacing it with:
Warning - Not tested !
cfscript
emails = replace(valuelist(list.email,|),|,chr(13)chr(10),ALL);
/cfscript
Marlon
Chris Edwards wrote:
I have this loop that runs ~22,000 iterations. It brings the server to its
knees. The RAM usage skyrockets above 800 Megs cutting into major virtual
memory. But when I just write the output instead of storing it to a
variable, it runs fine. I'm trying to retrieve a list of email addresses
and then write them to a file.
cfscript
emails = ;
for( i = 1; i lte list.recordcount; i=i+1 )
{
emails = emails list.email[i] chr(13) chr(10);
}
/cfscript
I can't imagine that the list in memory would take that much room. Does
anyone have a suggestion?
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com
~|
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: Dynamic anchors on CF Page
Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark). Does anyone have any other suggestions for how to get my bookmarks to function correctly. I am now on a deadline to get this done today. Thank you, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:46 PM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ok, so I now have this: a href=###GetKey##title#/a The name tag as this:a name=#GetKey##Title#/a ~ the above displays the ID for the title correctly when hovering on the hyperlink to the bookmark...but still doesn't seem like it's jumping directly to the bookmark when I click the hyperlink ~~ Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you needed ## in front of the anchor I think... anyway -- that code should be correct... My experience with MSIE has been that the browser jumps to a point where either a) the anchor is butted up against the top of the display or b) where the bottom of the page is butted up against the bottom of the display. So if your anchor happens to be close enough to the bottom of the page, the anchor link won't bring the display up beyond where the bottom of the page reaches the bottom of the display which results in the anchor being somewhat below the top. Not sure about other browsers -- this could be W3C recommended behavior, not sure. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: loopy loop!
I have this loop that runs ~22,000 iterations. It brings the server to its
knees. The RAM usage skyrockets above 800 Megs cutting into major virtual
memory. But when I just write the output instead of storing it to a
variable, it runs fine. I'm trying to retrieve a list of email addresses
and then write them to a file.
cfscript
emails = ;
for( i = 1; i lte list.recordcount; i=i+1 )
{
emails = emails list.email[i] chr(13) chr(10);
}
/cfscript
I can't imagine that the list in memory would take that much room. Does
anyone have a suggestion?
It seems like it would make sense that WriteOutput takes less memory than
storing to a variables. If you think about it, once it does the
WriteOutput(), CF no longer needs to keep track of what's inside it -- it's
no longer in memory. But if you store it to a variable, CF needs to go find
that variable and then append to it and then store it again. That overhead
is minimal with a smaller number of iterations. But 22,000 times is a lot of
times!!
Are you sure that your approach is the best solution? I obviously have no
idea what your ultimate goal is, but it looks from your code like you're
trying to build a list of email address from a database with Windows
carriage returns. Have you tried maybe using an array instead? Perhaps they
have better performance than what you're doing? Or you could use ValueList()
on the query column using a delimiter of #Chr(13)##Chr(10)#.
Those are just off the top of my head, but 22,000 of anything is going to
take a lot of processing time, so I wouldn't be so suprised to see what
you're seeing.
Regards,
Dave.
~|
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
how to make it go faster?
I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Deleting items older than 7 days from today
Ehmm...now I get the error that GetDate can't resolve. I'm using your exact syntax for the datediff statement. I saw that I used dd Instead of 'd' at first..so I changed that. But it still doesn't help. It seems that within the SQL statement it can't resolve the SQL field if I use a CF Function. -Gel -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Don't use CF for it, let the SQL do the work for you... Just setup your SQL statement like this: Select * FROM tblEvents WHERE DateDiff(d, GETDATE(), estarttime) = 7 (Sorry, I referenced NOW() last time...it should be GETDATE()) HTH, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF based blogging software
You can also download my blog code for free. (Link is below.) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:50 AM To: CF-Talk Subject: Re: CF based blogging software Thanks. I'll try it out but for some reason it 'feels' overly complicated. Michael Dinowitz wrote: Has there been any movement on this front? I found Fuseblog but can't see any ~| 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: how to make it go faster?
I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? Chris, any time you use cffile you're doing a read/write from the disk, which is always going to be more process intensive. Somebody may chime in with a silver bullet for your problem, but 22,000 of anything is *huge* and you may want to run this as a scheduled job at night. How long is forever? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how to make it go faster?
how about not looping at all: cfset emailtowrite = valueList(list.email,#chr(13)##chr(10)#) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) http://www.figleaf.com -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Tuesday, 01 April, 2003 9:56 AM To: CF-Talk Subject: how to make it go faster? I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| 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
HTML Prob
How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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: how to make it go faster?
Chris: What is your final intent with the document you're outputting to? Scott -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:56 AM To: CF-Talk Subject: how to make it go faster? I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| 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: how to make it go faster?
forever is : 182713 milliseconds-- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:01 AM Subject: Re: how to make it go faster? I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? Chris, any time you use cffile you're doing a read/write from the disk, which is always going to be more process intensive. Somebody may chime in with a silver bullet for your problem, but 22,000 of anything is *huge* and you may want to run this as a scheduled job at night. How long is forever? ~| 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: Deleting items older than 7 days from today
Try this.
delete from tblEvents
where DATEDIFF(dd,estarttime , getdate()) 7
Dave
- Original Message -
From: Angel Stewart [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 9:12 AM
Subject: SQL: Deleting items older than 7 days from today
Hey all,
I'm trying to do this with a single SQL statement.
Delete all records from the table tblEvents that are older than 7 days.
:)
This is the code I tried using:
CFQUERY name=DE Datasource=#DSN#
Select * FROM tblEvents
WHERE Now() - estarttime = 7
/CFQUERY
CFDUMP var=#DE#
CFQUERY name=DE2 Datasource=#DSN#
Select * FROM tblEvents
WHERE #DateDiff('dd',Now(),estarttime)# GTE 7
/CFQUERY
CFDUMP VAR=#DE2#
The first query works fine...the second one throws an error:
Error Diagnostic Information
An error occurred while evaluating the expression:
#DateDiff('dd',Now(),estarttime)#
Error near line 19, column 9.
~|
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: HTML Prob
input type=Text name=testBox value=ldquo; this is in quotes rdquo; -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:03 AM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
HTML Prob
How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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: loopy loop!
cfscript emails = replace(valuelist(list.email,|),|,chr(13)chr(10),ALL); /cfscript before 182713 milliseconds-- After 77502 milliseconds Thats better. Can I make it go faster? This is on a windows box( p3 1ghtz, 512ram ) CF5. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| 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: HTML Prob
How about using quot; ??? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:10 AM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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: Deleting items older than 7 days from today
That didn't work either.
Error Diagnostic Information
An error occurred while evaluating the expression:
#DATEDIFF('dd',estarttime , Now())#
Error near line 17, column 9.
~|
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: Deleting items older than 7 days from today
Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:53 AM To: CF-Talk Subject: RE: Deleting items older than 7 days from today Ehmm...now I get the error that GetDate can't resolve. I'm using your exact syntax for the datediff statement. I saw that I used dd Instead of 'd' at first..so I changed that. But it still doesn't help. It seems that within the SQL statement it can't resolve the SQL field if I use a CF Function. -Gel -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Don't use CF for it, let the SQL do the work for you... Just setup your SQL statement like this: Select * FROM tblEvents WHERE DateDiff(d, GETDATE(), estarttime) = 7 (Sorry, I referenced NOW() last time...it should be GETDATE()) HTH, Scott ~| 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: Deleting items older than 7 days from today
Try what you had before: Select * FROM tblEvents WHERE DateDiff(d, GETDATE(), estarttime) = 7 There is no CF in this query, therefore no need for pound signs. This should work for SQL2K. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:26 AM To: CF-Talk Subject: RE: Deleting items older than 7 days from today Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:53 AM To: CF-Talk Subject: RE: Deleting items older than 7 days from today Ehmm...now I get the error that GetDate can't resolve. I'm using your exact syntax for the datediff statement. I saw that I used dd Instead of 'd' at first..so I changed that. But it still doesn't help. It seems that within the SQL statement it can't resolve the SQL field if I use a CF Function. -Gel -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Don't use CF for it, let the SQL do the work for you... Just setup your SQL statement like this: Select * FROM tblEvents WHERE DateDiff(d, GETDATE(), estarttime) = 7 (Sorry, I referenced NOW() last time...it should be GETDATE()) HTH, Scott ~| 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: Deleting items older than 7 days from today
Nope..that didn't work either. Still error resolving estarttime. -Gel -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: loopy loop!
I prepare inventory files to upload to Half.com and Amazon marketplace.
Some 150k records or so.
I used to run the script so that I appended each row to a variable, then
when done, wrote this variable to a file - thinking that the variable
would take less time that writing to a file 150k times.
WRONG!
I rewrote the script to write to the file each iteration instead of memory
and the time it took to run when from 22 hours to 1 hour.
I wrote some sample code to compare the two loops and found that the time
it took to complete the variable-file loop increased almost exponentially
as the number of iterations went up while the file loop increased in a
nice linear fashion.
I have this loop that runs ~22,000 iterations. It brings the server to its
knees. The RAM usage skyrockets above 800 Megs cutting into major virtual
memory. But when I just write the output instead of storing it to a
variable, it runs fine. I'm trying to retrieve a list of email addresses
and then write them to a file.
cfscript
emails = ;
for( i = 1; i lte list.recordcount; i=i+1 )
{
emails = emails list.email[i] chr(13) chr(10);
}
/cfscript
I can't imagine that the list in memory would take that much room. Does
anyone have a suggestion?
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com
~|
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: HTML Prob
That's fine it works, thanks. However I wonder if you help me here as well. Basically what I am doing is Value=#myVar# And my var is coming from DB with value I am text with inverted commas. Now if I would be able to make a list with delimiter of then I can loop and just stick quote; between each item of list. But doing that I need to change delimiter of list from to , ListChangeDelims(myList,,,quot) but it doesn't work. Probably CF doesn't recognise quot and ListChangeDelims(myList,,,) gives error right away. Any help Shaz -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 16:20 To: CF-Talk Subject: RE: HTML Prob How about using quot; ??? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:10 AM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: loopy loop!
file I/O operations are very fast - their speed tends to be under-estimated
by developers. One thing you should watch out for are concurrency issues...
I recommend using named locks whenever accessing the local file system.
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified Advanced ColdFusion MX Developer
Certified Flash MX Developer
CFDJList - List Administrator
Fig Leaf Software
1400 16th St NW, # 220
Washington DC 20036
202.797.6570 (direct line)
http://www.figleaf.com
-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 01 April, 2003 10:36 AM
To: CF-Talk
Subject: Re: loopy loop!
I prepare inventory files to upload to Half.com and Amazon marketplace.
Some 150k records or so.
I used to run the script so that I appended each row to a variable, then
when done, wrote this variable to a file - thinking that the variable
would take less time that writing to a file 150k times.
WRONG!
I rewrote the script to write to the file each iteration instead of memory
and the time it took to run when from 22 hours to 1 hour.
I wrote some sample code to compare the two loops and found that the time
it took to complete the variable-file loop increased almost exponentially
as the number of iterations went up while the file loop increased in a
nice linear fashion.
I have this loop that runs ~22,000 iterations. It brings the server to
its
knees. The RAM usage skyrockets above 800 Megs cutting into major virtual
memory. But when I just write the output instead of storing it to a
variable, it runs fine. I'm trying to retrieve a list of email addresses
and then write them to a file.
cfscript
emails = ;
for( i = 1; i lte list.recordcount; i=i+1 )
{
emails = emails list.email[i] chr(13) chr(10);
}
/cfscript
I can't imagine that the list in memory would take that much room. Does
anyone have a suggestion?
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com
~|
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: Oracle CF5
I don't have any great ideas, but one thing I'd do is put the connectstring into the CFQUERY itself to see what happens. If things go faster then the problem is in accessing the tnsnames.ora file. We had some problems during load testing CF4.5,SP2 and Oracle 8.1.7 where the problem was trying to access tnsnames.ora too often. Putting the connectstring info into the CFQUERY fixed that. Also, I've heard of using sql trace/TKPROF to debug slow Oracle queries. I haven't used it myself, but info about it should be in the Oracle docs. Chris Norloff -- Original Message -- From: Simon Whittaker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 1 Apr 2003 10:54:49 +0100 Hi all, I have a bit of a problem I wouldn't mind some help with - We are using CF5 and Oracle 8i(8.1.7.0.0) (using Native drivers) and our application is running REALLY slowly. We have tuned the queries as much as we see possible and cached wherever possible although the neature of the beast makes caching a bit of a pipe-dream. I have been doing some debugging and found that the first query of the page is taking a very long time: getnews (Records=3, Time=2359ms) SQL = SELECT news_id, headline FROMnews WHERE show = 1 ORDER BY newsdate desc These are not big records and the query is very fast if I perform it through SQLPLUS or TOAD (Oracle gui devlopment tool) - the rest of the queries on the page are then performed in regular time. A tnsping of the box produces: Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=*REMOVEDHOSTNAME*)(PORT=1521)) OK (40 msec) so the connection to the oracle instance itself seems to be a reasonable time. Does anyone have any ideas that could help us out as it is starting to cause problems Many Thanks Simon ~| 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
Generic XML App
Hi We are looking into XML at the moment for a project, however we have come across an idea and was wondering if anyone else had seen such a tool or if the idea was totally mad. The idea is to take a XML Scheme document, and put it into a parser. It in turn would create a ColdFusion application that would allow you to edit that XML document. So for example, if the XML scheme was a address book. The address book application would be generated on the fly which would allow you to add, edit, delete address book items from a XML file The main idea would be to make this generic so that it could take any XML scheme - from an address book to a database of birds! Thoughts? Daniel ~| 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: Generic XML App
We are looking into XML at the moment for a project, however we have come across an idea and was wondering if anyone else had seen such a tool or if the idea was totally mad. The idea is to take a XML Scheme document, and put it into a parser. It in turn would create a ColdFusion application that would allow you to edit that XML document. So for example, if the XML scheme was a address book. The address book application would be generated on the fly which would allow you to add, edit, delete address book items from a XML file The main idea would be to make this generic so that it could take any XML scheme - from an address book to a database of birds! Have you looked into Xindice from the Apache project? It's a native XML database and you can to inserts/updates/deletes to XML files without even having to pull the documents out of the database. If you did want to pull them out, you could use their easy syntax and use MX's XML capabilities to do what you want to it. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HTML Prob
If the value is coming from a CF Variable, then you could try; input type=text name=test value=#HTMLeditFormat(form.test)# That naturally converts into quot; (as well as a few others) -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:03 PM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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: how to make it go faster?
I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? Which database engine is it? If it's SQL Server, then can't you use DTS? ~| 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: HTML Prob
Use the function htmlEditFormat e.g. input type=text value=#htmlEditFormat(myVar)# - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 8:41 AM Subject: RE: HTML Prob That's fine it works, thanks. However I wonder if you help me here as well. Basically what I am doing is Value=#myVar# And my var is coming from DB with value I am text with inverted commas. Now if I would be able to make a list with delimiter of then I can loop and just stick quote; between each item of list. But doing that I need to change delimiter of list from to , ListChangeDelims(myList,,,quot) but it doesn't work. Probably CF doesn't recognise quot and ListChangeDelims(myList,,,) gives error right away. Any help Shaz -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 16:20 To: CF-Talk Subject: RE: HTML Prob How about using quot; ??? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:10 AM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HTML Prob
Thanks -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 16:52 To: CF-Talk Subject: Re: HTML Prob Use the function htmlEditFormat e.g. input type=text value=#htmlEditFormat(myVar)# - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 8:41 AM Subject: RE: HTML Prob That's fine it works, thanks. However I wonder if you help me here as well. Basically what I am doing is Value=#myVar# And my var is coming from DB with value I am text with inverted commas. Now if I would be able to make a list with delimiter of then I can loop and just stick quote; between each item of list. But doing that I need to change delimiter of list from to , ListChangeDelims(myList,,,quot) but it doesn't work. Probably CF doesn't recognise quot and ListChangeDelims(myList,,,) gives error right away. Any help Shaz -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 16:20 To: CF-Talk Subject: RE: HTML Prob How about using quot; ??? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:10 AM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas I guess there should be something in CF or HTML to get it working? Thanks, Shaz ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
-OT- Javascript and combo boxes
Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? T ~| 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: how to make it go faster?
I'm using MySQL. I have this now: cfscript email_list = replace(valuelist(list.email,|),|,chr(13)chr(10),ALL); /cfscript cffile action=write file=#ExpandPath(users.lst)# output=#email_list# It takes about 70 seconds to run. Which is ok by me for right now. I'm going to try and schedule it to run late night. It would be super nice though if I could get the db to do what I want. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: Philip Arnold [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:48 AM Subject: RE: how to make it go faster? I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? Which database engine is it? If it's SQL Server, then can't you use DTS? ~| 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: Dynamic anchors on CF Page
That sucks... I'm about tapped for ideas at this point... Wish I had any other suggestions to offer... Have you tested it on multiple machines / browsers to make sure it's not just a problem with your particular setup? Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark). Does anyone have any other suggestions for how to get my bookmarks to function correctly. I am now on a deadline to get this done today. Thank you, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:46 PM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ok, so I now have this: a href=###GetKey##title#/a The name tag as this:a name=#GetKey##Title#/a ~ the above displays the ID for the title correctly when hovering on the hyperlink to the bookmark...but still doesn't seem like it's jumping directly to the bookmark when I click the hyperlink ~~ Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you needed ## in front of the anchor I think... anyway -- that code should be correct... My experience with MSIE has been that the browser jumps to a point where either a) the anchor is butted up against the top of the display or b) where the bottom of the page is butted up against the bottom of the display. So if your anchor happens to be close enough to the bottom of the page, the anchor link won't bring the display up beyond where the bottom of the page reaches the bottom of the display which results in the anchor being somewhat below the top. Not sure about other browsers -- this could be W3C recommended behavior, not sure. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: Dynamic anchors on CF Page
Ok, well it turns out that for some reason I was using 2 different queries. The bookmarks were for one and the content for the other. (You must understand, I am being taught ASP in which this is a somewhat necessary demon). At any rate, I consolidated the queries down to 1, then I had to output it and end it once for the hyperlinks to the bookmarks and then output it again for the content in order for the formatting to be correct. The agonies of coding in ASP and not CF. Thanks for your help... -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:27 AM To: CF-Talk Subject: RE: Dynamic anchors on CF Page That sucks... I'm about tapped for ideas at this point... Wish I had any other suggestions to offer... Have you tested it on multiple machines / browsers to make sure it's not just a problem with your particular setup? Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark). Does anyone have any other suggestions for how to get my bookmarks to function correctly. I am now on a deadline to get this done today. Thank you, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:46 PM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ok, so I now have this: a href=###GetKey##title#/a The name tag as this:a name=#GetKey##Title#/a ~ the above displays the ID for the title correctly when hovering on the hyperlink to the bookmark...but still doesn't seem like it's jumping directly to the bookmark when I click the hyperlink ~~ Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you needed ## in front of the anchor I think... anyway -- that code should be correct... My experience with MSIE has been that the browser jumps to a point where either a) the anchor is butted up against the top of the display or b) where the bottom of the page is butted up against the bottom of the display. So if your anchor happens to be close enough to the bottom of the page, the anchor link won't bring the display up beyond where the bottom of the page reaches the bottom of the display which results in the anchor being somewhat below the top. Not sure about other browsers -- this could be W3C recommended behavior, not sure. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: Dynamic anchors on CF Page
Sorry I missed this one--I had to arm-wrestle with it a couple months back. Here's a snippet: tr td !--- Naming my anchor --- p align=lefta name=Comment#qCommentDisplay.commentID#/aa href=profileView.cfm?profileID=#profileID# class=commentNameu#profileLogin#/u/au span class=blinkCopy - #DateFormat(commentDate,DD - - )# - #TimeFormat(commentTime,hh:mm:ss tt)#/span/u /p /td !--- Identifying the anchor by a specific URL --- td align=right a href=##Comment#qCommentDisplay.commentID# class=blinkCMTfont color=##FFlink/font/a/td /tr Sorry if this isn't exactly what you wanted, but after a LOT of trial and error, I finally got this solution to work for me. HTH, Russ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:27 AM To: CF-Talk Subject: RE: Dynamic anchors on CF Page That sucks... I'm about tapped for ideas at this point... Wish I had any other suggestions to offer... Have you tested it on multiple machines / browsers to make sure it's not just a problem with your particular setup? Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark). Does anyone have any other suggestions for how to get my bookmarks to function correctly. I am now on a deadline to get this done today. Thank you, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:46 PM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ok, so I now have this: a href=###GetKey##title#/a The name tag as this:a name=#GetKey##Title#/a ~ the above displays the ID for the title correctly when hovering on the hyperlink to the bookmark...but still doesn't seem like it's jumping directly to the bookmark when I click the hyperlink ~~ Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you needed ## in front of the anchor I think... anyway -- that code should be correct... My experience with MSIE has been that the browser jumps to a point where either a) the anchor is butted up against the top of the display or b) where the bottom of the page is butted up against the bottom of the display. So if your anchor happens to be close enough to the bottom of the page, the anchor link won't bring the display up beyond where the bottom of the page reaches the bottom of the display which results in the anchor being somewhat below the top. Not sure about other browsers -- this could be W3C recommended behavior, not sure. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: -OT- Javascript and combo boxes
Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF Exchange. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: loopy loop!
-Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:47 AM To: CF-Talk Subject: RE: loopy loop! file I/O operations are very fast - their speed tends to be under-estimated by developers. One thing you should watch out for are concurrency issues... I recommend using named locks whenever accessing the local file system. If your process is taking several hours you may be able to speed things up considerably by doing your initial I/O on a RAM drive. In general for huge jobs like this writing directly to the file system faster because CF does not have to maintain memory space for the entire result. However it's still hamstrung (a little) by the physical speed of the disk. In many corporate environments write-ahead caching is not allowed for data integrity issues - this will really kill peformance if you're used to having it turned on (often the case on a developer's local machine). A RAM disk effectively eliminates the physical disk lag, but maintains the append and forget speed of direct-to-file processing. Once you're done a single file operation moves the file from the RAM Disk to the physical disk. Very peppy. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Loopy Loop Fast SOLVED
Thanks for all the help. Takes ~ 14 seconds. Down from the original ~180 !--- get email list --- cfquery name=list datasource=#Request.App.Db# SELECT DISTINCT CONCAT(email,'\r\n') AS email FROM `mail_subscriptions` #optlist# /cfquery cffile action=write file=#ExpandPath(users.lst)# output=#valuelist(list.email,)# Once again, the DB shines through as the savior. Thanks Doug for reminding me. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
truncated log data
I'm using SQL via CF to try to read my CF application.log file and display the data on screen. I stripped out some characters on some of the rows, unfortunately on some rows all the data does not display. For example, one row has this info: Error,TID=227,04/01/03,10:57:28,1XX.XX.XX.XX,Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),PAn error occurred while evaluating the expression: PPRE#FORM.lcatalog# /PRE/P/PError near line 31, column 3.HRPError resolving parameter BFORM.LCATALOG/BPPThe specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name.PP pThe error occurred while processing an element with a general identifier of (#FORM.lcatalog#), occupying document position (31:2) to (31:16) in the template file d:\Inetpub\wwwroot\wwebforms\catalog\HWcatalog.cfm./pPPDate/Time: 04/01/03 10:57:28BRBrowser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)BRRemote Address: 1XX.XX.XX.XXBRHTTP Referer: http: I'm using this code to display it and strip some fields: Error: replace(replace(col006, p, , all), , , all)# It only displays: An error occurred while evaluating the expression: and no more of the line. Anything I'm missing here? Thanks. Robert Orlini HW Wilson 718-588-8400 x2656 ~| 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
ChartFX and CFMX?
Does anyone have any experience with ChartFX and CFMX? I was wondering if there were any COM compatibility issues with this product that anyone has encountered. We've currently got a copy on our CF4.5 server, and want to move to CFMX. Erica Lomax Corporate Engineering Division Abbott Laboratories [EMAIL PROTECTED] ~| 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
ColdFusion Focus Group Invitation
Hello!?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / The ColdFusion product team is seeking participants for a live Internet focus group to discuss some details concerning future versions of ColdFusion. The meeting will be held early in the week beginning April 7th and will last approximately one hour. If you are interested in participating, please send an email with the following information to [EMAIL PROTECTED]: * Your Name and Title * Your Company Name and address * Company size (total number of employees) * Version(s) of ColdFusion in use (ie: 4.5, 5, MX) * Edition(s) of ColdFusion (e.g. Professional, Enterprise) in use * How long you have been using ColdFusion We are interested in speaking with many different types of customers - so feel free to email us even if you're relatively new to the product or if you're only running one copy of ColdFusion 3.1 in a broom closet somewhere. Note - participation in the focus group will require signing a Macromedia Non-Disclosure Agreement. Thanks, The ColdFusion Product Team Tim Buntel Product Manager Macromedia ColdFusion Server _ Macromedia Inc. 275 Grove Street Newton, MA 02466 Phone: 617-219-2375 Email: [EMAIL PROTECTED] http://www.macromedia.com/software/coldfusion/ ~| 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: ColdFusion Focus Group Invitation
Kris Pilles Website Manager Western Suffolk BOCES 507 deer park Rd, dix hills, ny 11746 5, MX Pro Enterprise Over 3 years (personally) agency over 2 -Original Message- From: Tim Buntel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:06 PM To: CF-Talk Subject: ColdFusion Focus Group Invitation Hello!?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / The ColdFusion product team is seeking participants for a live Internet focus group to discuss some details concerning future versions of ColdFusion. The meeting will be held early in the week beginning April 7th and will last approximately one hour. If you are interested in participating, please send an email with the following information to [EMAIL PROTECTED]: * Your Name and Title * Your Company Name and address * Company size (total number of employees) * Version(s) of ColdFusion in use (ie: 4.5, 5, MX) * Edition(s) of ColdFusion (e.g. Professional, Enterprise) in use * How long you have been using ColdFusion We are interested in speaking with many different types of customers - so feel free to email us even if you're relatively new to the product or if you're only running one copy of ColdFusion 3.1 in a broom closet somewhere. Note - participation in the focus group will require signing a Macromedia Non-Disclosure Agreement. Thanks, The ColdFusion Product Team Tim Buntel Product Manager Macromedia ColdFusion Server _ Macromedia Inc. 275 Grove Street Newton, MA 02466 Phone: 617-219-2375 Email: [EMAIL PROTECTED] http://www.macromedia.com/software/coldfusion/ ~| 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: CF based blogging software
Michael, as some may know I have been working on one for the last few months. It is fully plug and playable, platform independent and driven by XML, it produces rss feeds in versions 0.92 and 1. I'm working on stuffing the functionality into cfc's now. I have full add/edit/delete entry functionality. The only thing that is left to do is allow for not only editing of the current month, but to allow for editing of all entries no matter the date. If you pull up the archived entries via XML, you will view it in your own customized design. Logic and design is/will be fully separated from the view. Archives are not currently cached, but will be in future versions. I have tested the application with 5 years of archives, and 100 entries per day for each month and have had no problems. I have not had a chance to load test it yet, so I can't say if the xml driven functionality will work. But in worst case scenario I will be providing the ability to use a database within the cfc's. I plan on completing a fully functional version 1 in the next few months. If anyone is interested, please let me know and I will add you to my list of first-to-know when released. Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:37 AM To: CF-Talk Subject: CF based blogging software Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. I need to convince a company to let me write a blogger for them for a fee. :) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| 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: ColdFusion Focus Group Invitation
I HATE THAT! -Original Message- From: Tim Buntel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:06 PM To: CF-Talk Subject: ColdFusion Focus Group Invitation Hello!?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / The ColdFusion product team is seeking participants for a live Internet focus group to discuss some details concerning future versions of ColdFusion. The meeting will be held early in the week beginning April 7th and will last approximately one hour. If you are interested in participating, please send an email with the following information to [EMAIL PROTECTED]: * Your Name and Title * Your Company Name and address * Company size (total number of employees) * Version(s) of ColdFusion in use (ie: 4.5, 5, MX) * Edition(s) of ColdFusion (e.g. Professional, Enterprise) in use * How long you have been using ColdFusion We are interested in speaking with many different types of customers - so feel free to email us even if you're relatively new to the product or if you're only running one copy of ColdFusion 3.1 in a broom closet somewhere. Note - participation in the focus group will require signing a Macromedia Non-Disclosure Agreement. Thanks, The ColdFusion Product Team Tim Buntel Product Manager Macromedia ColdFusion Server _ Macromedia Inc. 275 Grove Street Newton, MA 02466 Phone: 617-219-2375 Email: [EMAIL PROTECTED] http://www.macromedia.com/software/coldfusion/ ~| 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: ColdFusion Focus Group Invitation
Die frontpage die ^_^ *chuckle* -Gel -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] I HATE THAT! -Original Message- From: Tim Buntel [mailto:[EMAIL PROTECTED] Hello!?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| 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: truncated log data
Use htmlEditFormat... use htmlEditFormat Garrkkk... My last word on this planet will be htmlEditFormat - Original Message - From: Robert Orlini [EMAIL PROTECTED] Date: Tuesday, April 1, 2003 9:54 am Subject: truncated log data I'm using SQL via CF to try to read my CF application.log file and display the data on screen. I stripped out some characters on some of the rows, unfortunately on some rows all the data does not display. For example, one row has this info: Error,TID=227,04/01/03,10:57:28,1XX.XX.XX.XX,Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),PAn error occurred while evaluating the expression: PPRE#FORM.lcatalog# /PRE/P/PError near line 31, column 3.HRPError resolving parameter BFORM.LCATALOG/BPPThe specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name.PP pThe error occurred while processing an element with a general identifier of (#FORM.lcatalog#), occupying document position (31:2) to (31:16) in the template file d:\Inetpub\wwwroot\wwebforms\catalog\HWcatalog.cfm./pPPDate/Time: 04/01/03 10:57:28BRBrowser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)BRRemote Address: 1XX.XX.XX.XXBRHTTP Referer: http: I'm using this code to display it and strip some fields: Error: replace(replace(col006, p, , all), , , all)# It only displays: An error occurred while evaluating the expression: and no more of the line. Anything I'm missing here? Thanks. Robert Orlini HW Wilson 718-588-8400 x2656 ~| 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
OT - Recommend a good, free web tracking software
Anyone have any good recommendations as well as links? Get your own free email account from http://www.popmail.com ~| 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: Dynamic anchors on CF Page
Ahh... Well, glad to know you were able to get it all working. :) I've worked in ASP myself -- about 3-4 years ago now I was a crack ASP programmer -- unfortunately for my boss I already knew ColdFusion. I'm lead to believe that I was pretty good at it but god those tools were hideous. ASP 3 or ASP.NET could be better, I dunno... I've not bothered to keep up with it. Ok, well it turns out that for some reason I was using 2 different queries. The bookmarks were for one and the content for the other. (You must understand, I am being taught ASP in which this is a somewhat necessary demon). At any rate, I consolidated the queries down to 1, then I had to output it and end it once for the hyperlinks to the bookmarks and then output it again for the content in order for the formatting to be correct. The agonies of coding in ASP and not CF. Thanks for your help... -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:27 AM To: CF-Talk Subject: RE: Dynamic anchors on CF Page That sucks... I'm about tapped for ideas at this point... Wish I had any other suggestions to offer... Have you tested it on multiple machines / browsers to make sure it's not just a problem with your particular setup? Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark). Does anyone have any other suggestions for how to get my bookmarks to function correctly. I am now on a deadline to get this done today. Thank you, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:46 PM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ok, so I now have this: a href=###GetKey##title#/a The name tag as this:a name=#GetKey##Title#/a ~ the above displays the ID for the title correctly when hovering on the hyperlink to the bookmark...but still doesn't seem like it's jumping directly to the bookmark when I click the hyperlink ~~ Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you needed ## in front of the anchor I think... anyway -- that code should be correct... My experience with MSIE has been that the browser jumps to a point where either a) the anchor is butted up against the top of the display or b) where the bottom of the page is butted up against the bottom of the display. So if your anchor happens to be close enough to the bottom of the page, the anchor link won't bring the display up beyond where the bottom of the page reaches the bottom of the display which results in the anchor being somewhat below the top. Not sure about other browsers -- this could be W3C recommended behavior, not sure. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~ ~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| 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/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer
RE: OT - Recommend a good, free web tracking software
Web tracking or raw log analyzer? If log analyzer: http://awstats.sourceforge.net/ Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:32 AM To: CF-Talk Subject: OT - Recommend a good, free web tracking software Anyone have any good recommendations as well as links? Get your own free email account from http://www.popmail.com ~| 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: Dynamic anchors on CF Page
It's not too bad. I haven't migrated to .NET, not sure I want to just yet, but I do find it annoying that I have to code so many loops in ASP. I really liked how CF does that for you. However, on the flipside, it is easier to control what the loop is doing in ASP than in CF. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:43 AM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ahh... Well, glad to know you were able to get it all working. :) I've worked in ASP myself -- about 3-4 years ago now I was a crack ASP programmer -- unfortunately for my boss I already knew ColdFusion. I'm lead to believe that I was pretty good at it but god those tools were hideous. ASP 3 or ASP.NET could be better, I dunno... I've not bothered to keep up with it. Ok, well it turns out that for some reason I was using 2 different queries. The bookmarks were for one and the content for the other. (You must understand, I am being taught ASP in which this is a somewhat necessary demon). At any rate, I consolidated the queries down to 1, then I had to output it and end it once for the hyperlinks to the bookmarks and then output it again for the content in order for the formatting to be correct. The agonies of coding in ASP and not CF. Thanks for your help... -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:27 AM To: CF-Talk Subject: RE: Dynamic anchors on CF Page That sucks... I'm about tapped for ideas at this point... Wish I had any other suggestions to offer... Have you tested it on multiple machines / browsers to make sure it's not just a problem with your particular setup? Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark). Does anyone have any other suggestions for how to get my bookmarks to function correctly. I am now on a deadline to get this done today. Thank you, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:46 PM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ok, so I now have this: a href=###GetKey##title#/a The name tag as this:a name=#GetKey##Title#/a ~ the above displays the ID for the title correctly when hovering on the hyperlink to the bookmark...but still doesn't seem like it's jumping directly to the bookmark when I click the hyperlink ~~ Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you needed ## in front of the anchor I think... anyway -- that code should be correct... My experience with MSIE has been that the browser jumps to a point where either a) the anchor is butted up against the top of the display or b) where the bottom of the page is butted up against the bottom of the display. So if your anchor happens to be close enough to the bottom of the page, the anchor link won't bring the display up beyond where the bottom of the page reaches the bottom of the display which results in the anchor being somewhat below the top. Not sure about other browsers -- this could be W3C recommended behavior, not sure. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~ ~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| 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.
Re: Generic XML App
Considering that an XML Schema is written in XML I'd say it's definitely possible, as a matter of fact, it's what the XML authority really hoped would happen once XML Schema became the standard as opposed to the older DTD's. I'm not aware of any CF apps that do it currently -- I suspect it'd be a fairly large project considering the complexities of XML Schema, but all the documentation you need is right there on the W3C site. http://www.w3.org/XML/Schema If you go ahead with the project, I'd be interrested to know what you discover from the schema for SPEC (Simple Programming Environment Catalog) -- it's in the zip for TAPI at http://www.turnkey.to/tapi Hi We are looking into XML at the moment for a project, however we have come across an idea and was wondering if anyone else had seen such a tool or if the idea was totally mad. The idea is to take a XML Scheme document, and put it into a parser. It in turn would create a ColdFusion application that would allow you to edit that XML document. So for example, if the XML scheme was a address book. The address book application would be generated on the fly which would allow you to add, edit, delete address book items from a XML file The main idea would be to make this generic so that it could take any XML scheme - from an address book to a database of birds! Thoughts? Daniel ~~ ~~~| 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/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: SQL: Deleting items older than 7 days from today
If you are going to be doing this regularly, you should consider using a stored procedure, assuming your database supports them. Cary Gordon The Cherry Hill Company At 10:12 AM 4/1/2003 -0400, you wrote: Hey all, I'm trying to do this with a single SQL statement. Delete all records from the table tblEvents that are older than 7 days. :) --- snip --- ~| 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: OT - Recommend a good, free web tracking software
Webalizer is pretty good. www.webalizer.com Free (i.e. open source), cross platform, and easy to setup - if you don't mind working with config files Shawn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:32 AM To: CF-Talk Subject: OT - Recommend a good, free web tracking software Anyone have any good recommendations as well as links? Get your own free email account from http://www.popmail.com ~| 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: OT - Recommend a good, free web tracking software
Vote two for webalizer. (I worked with the guy who wrote it. ;) ) Webalizer is pretty good. www.webalizer.com Free (i.e. open source), cross platform, and easy to setup - if you don't mind working with config files Shawn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:32 AM To: CF-Talk Subject: OT - Recommend a good, free web tracking software Anyone have any good recommendations as well as links? Get your own free email account from http://www.popmail.com ~| 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: -OT- Javascript and combo boxes
At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF Exchange. I don't think this is what I want. I've got about 30 combo boxes, all with four or five departments. What I want to do is when I select the first department for the first person, the following boxes change to that department. Then if I change the department for the second person, I want the remaining boxes to change to that. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: -OT- Javascript and combo boxes
the general rule for selecting an option in a combo box is: document.formName.selectBoxName.selectedIndex = n where n is your number (remember, the first option is 0) In your case, i'd guess you want to store the names of your 30 combo boxes in an array, and add a function for onchange into each select, which loops over the array, setting eavh value appropriately (which would be this.selectedIndex...passed as an argument) :) you can contact me off-list if you need any help with it if you'd like. charlie Thane Sherrington writes: At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF Exchange. I don't think this is what I want. I've got about 30 combo boxes, all with four or five departments. What I want to do is when I select the first department for the first person, the following boxes change to that department. Then if I change the department for the second person, I want the remaining boxes to change to that. T ~| 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: -OT- Javascript and combo boxes
Thane You might want to look into Fusionscript at www.fusionscript.com With this you can do calls back to the database without refreshing your page. This is an example of a FS function: !start of FS function cf_fs_function name=MyFunction !---Calls the server page with the CF query !---and passes the var for your query, from your select box--- cf_fs_activeServer action=call page=getSubDepts.cfm Department= form.MainDept !Loops through the returned query to populate the next select box--- !---SubDepts will be the next Select box-- cf_fs_loop query=SubDepts cf_fs_select action=addOption field='SubDepts' value=query.SubDepts.SubDeptsID text=query.SubDepts.SubDeptstext /cf_fs_loop /cf_fs_function !You can call the function like so select name=MainDept size=1 onChange=cf_fs_function call=MyFunction/ option value=0 SELECTEDDept2/option /SELECT Then on your Serverpage (just the CF template with the query code) you would have something like: !--- !---Query to get info-- CFQUERY name=QgetSubs Select * WHERE Dept = #ActiveServer.Department# /CFQUERY !---returns query info back to calling page for use in populating your select box--- cf_fs_activeServer action=return name=SubDepts value=#QgetSubs# type=query You could have as many calls in the function as you needed to populate any number of select boxes. you can run any CF code on the server page. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:32 AM To: CF-Talk Subject: Re: -OT- Javascript and combo boxes At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF Exchange. I don't think this is what I want. I've got about 30 combo boxes, all with four or five departments. What I want to do is when I select the first department for the first person, the following boxes change to that department. Then if I change the department for the second person, I want the remaining boxes to change to that. T ~| 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: -OT- Javascript and combo boxes
I think what he really wants is a script that will receive a select object and value (probably an onChange event) And then find all the select boxes with the same naming convention but larger sequence numbers, and set them all to the new value. Thane, is this closer? Jerry Johnson [EMAIL PROTECTED] 04/01/03 02:06PM Thane You might want to look into Fusionscript at www.fusionscript.com With this you can do calls back to the database without refreshing your page. This is an example of a FS function: !start of FS function cf_fs_function name=MyFunction !---Calls the server page with the CF query !---and passes the var for your query, from your select box--- cf_fs_activeServer action=call page=getSubDepts.cfm Department= form.MainDept !Loops through the returned query to populate the next select box--- !---SubDepts will be the next Select box-- cf_fs_loop query=SubDepts cf_fs_select action=addOption field='SubDepts' value=query.SubDepts.SubDeptsID text=query.SubDepts.SubDeptstext /cf_fs_loop /cf_fs_function !You can call the function like so select name=MainDept size=1 onChange=cf_fs_function call=MyFunction/ option value=0 SELECTEDDept2/option /SELECT Then on your Serverpage (just the CF template with the query code) you would have something like: !--- !---Query to get info-- CFQUERY name=QgetSubs Select * WHERE Dept = #ActiveServer.Department# /CFQUERY !---returns query info back to calling page for use in populating your select box--- cf_fs_activeServer action=return name=SubDepts value=#QgetSubs# type=query You could have as many calls in the function as you needed to populate any number of select boxes. you can run any CF code on the server page. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:32 AM To: CF-Talk Subject: Re: -OT- Javascript and combo boxes At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF Exchange. I don't think this is what I want. I've got about 30 combo boxes, all with four or five departments. What I want to do is when I select the first department for the first person, the following boxes change to that department. Then if I change the department for the second person, I want the remaining boxes to change to that. T ~| 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: -OT- Javascript and combo boxes
At 02:12 PM 4/1/03 -0500, Jerry Johnson wrote: I think what he really wants is a script that will receive a select object and value (probably an onChange event) And then find all the select boxes with the same naming convention but larger sequence numbers, and set them all to the new value. Thane, is this closer? Dead on. :) I guess I'm not well written. T ~| 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: truncated log data
Thanks Ksuh. This helped by displaying more log info than before. One problem persists though, somewhere after displaying a good number of records, it craps out and displays html code right to the end. Any help would be appreciated. Robert O. HWW Here's my code: cfquery name=getsomedata datasource=application_log select * from application2 order by number desc /cfquery pfont face=ArialbCF Error Log for WWW.HWWILSON.COM/b /font cfoutput query=getsomedata bDate: /b#replace(col002, , , all)#bbr Time:/b/font #replace(col003, , , all)#bfont face=Arial size=2br IP:/font/b font face=Arial size=2#replace(col004, , , all)#/fontbfont face=Arial size=2br Browser:/font/b font face=Arial size=2#replace(col005, , , all)#/fontbfont face=Arial size=2br !--- Error:/font/b font face=Arial size=2#replace(replace(col006, xmp, , all), , , all)#/font --- br Error:/font/b font face=Arial size=2#htmlEditFormat(col006, -1)#/font hr !--- /cfloop --- /cfoutput -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:20 PM To: CF-Talk Subject: Re: truncated log data Use htmlEditFormat... use htmlEditFormat Garrkkk... My last word on this planet will be htmlEditFormat - Original Message - From: Robert Orlini [EMAIL PROTECTED] Date: Tuesday, April 1, 2003 9:54 am Subject: truncated log data I'm using SQL via CF to try to read my CF application.log file and display the data on screen. I stripped out some characters on some of the rows, unfortunately on some rows all the data does not display. For example, one row has this info: Error,TID=227,04/01/03,10:57:28,1XX.XX.XX.XX,Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),PAn error occurred while evaluating the expression: PPRE#FORM.lcatalog# /PRE/P/PError near line 31, column 3.HRPError resolving parameter BFORM.LCATALOG/BPPThe specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name.PP pThe error occurred while processing an element with a general identifier of (#FORM.lcatalog#), occupying document position (31:2) to (31:16) in the template file d:\Inetpub\wwwroot\wwebforms\catalog\HWcatalog.cfm./pPPDate/Time: 04/01/03 10:57:28BRBrowser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)BRRemote Address: 1XX.XX.XX.XXBRHTTP Referer: http: I'm using this code to display it and strip some fields: Error: replace(replace(col006, p, , all), , , all)# It only displays: An error occurred while evaluating the expression: and no more of the line. Anything I'm missing here? Thanks. Robert Orlini HW Wilson 718-588-8400 x2656 ~| 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: -OT- Javascript and combo boxes
At 11:53 AM 4/1/03 -0700, charlie griefer wrote: the general rule for selecting an option in a combo box is: document.formName.selectBoxName.selectedIndex = n where n is your number (remember, the first option is 0) Excellent. I think I can muddle through from here. :) T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: -OT- Javascript and combo boxes
At 12:06 PM 4/1/03 -0700, Bruce, Rodney S HQISEC/Veridian IT Services wrote: Thane You might want to look into Fusionscript at www.fusionscript.com With this you can do calls back to the database without refreshing your page. Hmmm...this might be a bit of overkill for what I'm doing but it is interesting. I'll take a look. T ~| 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: -OT- Javascript and combo boxes
Thank you! -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:07 PM To: CF-Talk Subject: RE: -OT- Javascript and combo boxes Thane You might want to look into Fusionscript at www.fusionscript.com With this you can do calls back to the database without refreshing your page. This is an example of a FS function: !start of FS function cf_fs_function name=MyFunction !---Calls the server page with the CF query !---and passes the var for your query, from your select box--- cf_fs_activeServer action=call page=getSubDepts.cfm Department= form.MainDept !Loops through the returned query to populate the next select box--- !---SubDepts will be the next Select box-- cf_fs_loop query=SubDepts cf_fs_select action=addOption field='SubDepts' value=query.SubDepts.SubDeptsID text=query.SubDepts.SubDeptstext /cf_fs_loop /cf_fs_function !You can call the function like so select name=MainDept size=1 onChange=cf_fs_function call=MyFunction/ option value=0 SELECTEDDept2/option /SELECT Then on your Serverpage (just the CF template with the query code) you would have something like: !--- !---Query to get info-- CFQUERY name=QgetSubs Select * WHERE Dept = #ActiveServer.Department# /CFQUERY !---returns query info back to calling page for use in populating your select box--- cf_fs_activeServer action=return name=SubDepts value=#QgetSubs# type=query You could have as many calls in the function as you needed to populate any number of select boxes. you can run any CF code on the server page. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:32 AM To: CF-Talk Subject: Re: -OT- Javascript and combo boxes At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF Exchange. I don't think this is what I want. I've got about 30 combo boxes, all with four or five departments. What I want to do is when I select the first department for the first person, the following boxes change to that department. Then if I change the department for the second person, I want the remaining boxes to change to that. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: -OT- Javascript and combo boxes
oops, maybe I read your post wrong.
If you are looking at setting all the selects to the same option try
something like this:
Don't know how you have your selects named now but if they are in order
like:
MySelect1 OnChange=resetlists(1)
MySelect2 OnChange=resetlists(2)
MySelect3 OnChange=resetlists(3)
...
MySelectLast
because on the last one there are no more below it to change??
SCRIPT
Function resetlists(start){
Var SelectName = MySelect + start;
Var next = start-1;
Var SelectNext = MySelect + next;
While (next MaxnumSelects){
control = 0;
while (control document.form.[Selectnext].options.length){
if
(document.form.[Selectnext].options.[control].value ==
document[formname][SelectName].value){
document.dform.Workplans.options[control].selected = true;
}
control++;
}
next++;
}
}
/SCRIPT
Something like this might work.
Look it over, it's written on the cuff so , will ;o) have errors
but should get you pointed in a direction, hopefully.
-Original Message-
From: charlie griefer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 11:53 AM
To: CF-Talk
Subject: Re: -OT- Javascript and combo boxes
the general rule for selecting an option in a combo box is:
document.formName.selectBoxName.selectedIndex = n
where n is your number (remember, the first option is 0)
In your case, i'd guess you want to store the names of your 30 combo boxes
in an array, and add a function for onchange into each select, which loops
over the array, setting eavh value appropriately (which would be
this.selectedIndex...passed as an argument) :)
you can contact me off-list if you need any help with it if you'd like.
charlie
Thane Sherrington writes:
At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote:
Howdy Thane,
Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote:
Is it possible to use Javascript to select a choice in a combo box?
For instance, if I have a form with people listed, and beside each, a
combo
box with all the departments in the company, can I select a department
in
the first combobox, and have the other combo boxes automatically switch
to
that department as well?
Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF
Exchange.
I don't think this is what I want. I've got about 30 combo boxes, all
with four or five departments. What I want to do is when I select the
first department for the first person, the following boxes change to that
department. Then if I change the department for the second person, I want
the remaining boxes to change to that.
T
~|
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: Dynamic anchors on CF Page
Does ASP 3 have a method of using variables when specifying an included template (like cfinclude)? When I was working with it we only had SSI includes, which all get processed prior to the ASP engine, so you couldn't use variables in them. And all the ASP developers I knew were using switch-case statements to display different headers and footers which just ended up hideously bloating up the request since each header inevitably had a db driven menu in it somewhere. It's not too bad. I haven't migrated to .NET, not sure I want to just yet, but I do find it annoying that I have to code so many loops in ASP. I really liked how CF does that for you. However, on the flipside, it is easier to control what the loop is doing in ASP than in CF. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:43 AM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ahh... Well, glad to know you were able to get it all working. :) I've worked in ASP myself -- about 3-4 years ago now I was a crack ASP programmer -- unfortunately for my boss I already knew ColdFusion. I'm lead to believe that I was pretty good at it but god those tools were hideous. ASP 3 or ASP.NET could be better, I dunno... I've not bothered to keep up with it. Ok, well it turns out that for some reason I was using 2 different queries. The bookmarks were for one and the content for the other. (You must understand, I am being taught ASP in which this is a somewhat necessary demon). At any rate, I consolidated the queries down to 1, then I had to output it and end it once for the hyperlinks to the bookmarks and then output it again for the content in order for the formatting to be correct. The agonies of coding in ASP and not CF. Thanks for your help... -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:27 AM To: CF-Talk Subject: RE: Dynamic anchors on CF Page That sucks... I'm about tapped for ideas at this point... Wish I had any other suggestions to offer... Have you tested it on multiple machines / browsers to make sure it's not just a problem with your particular setup? Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark). Does anyone have any other suggestions for how to get my bookmarks to function correctly. I am now on a deadline to get this done today. Thank you, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:46 PM To: CF-Talk Subject: RE: Dynamic anchors on CF Page Ok, so I now have this: a href=###GetKey##title#/a The name tag as this:a name=#GetKey##Title#/a ~ the above displays the ID for the title correctly when hovering on the hyperlink to the bookmark...but still doesn't seem like it's jumping directly to the bookmark when I click the hyperlink ~~ Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you needed ## in front of the anchor I think... anyway -- that code should be correct... My experience with MSIE has been that the browser jumps to a point where either a) the anchor is butted up against the top of the display or b) where the bottom of the page is butted up against the bottom of the display. So if your anchor happens to be close enough to the bottom of the page, the anchor link won't bring the display up beyond where the bottom of the page reaches the bottom of the display which results in the anchor being somewhat below the top. Not sure about other browsers -- this could be W3C recommended behavior, not sure. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~ ~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid= 4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified
RE: -OT- Javascript and combo boxes
At 12:27 PM 4/1/03 -0700, Bruce, Rodney S HQISEC/Veridian IT Services wrote: oops, maybe I read your post wrong. If you are looking at setting all the selects to the same option try something like this: I appreciate it. Thanks. T ~| 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
Updating to CFMX Updater 3 causes client ASP functions to stop working?
Is this a known issue or is it likely that something else is at fault here? The ASP was working fine before the update, no changes were made and now not working after the CFMX update. Does this sound plausible? CFMX w/ IIS 5, everything patched to current. Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 3/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Scheduler?
Any idea why in the log file for scheduler, I see that my Scheduled Task has been initiated and completed but nothing happens. When I run the tasks from the browser (on the server) it runs without a problem and processes the messages as designed? BTW: CF 5 is the server and IE is the browser. --- I must be brain dead and hope someone has a simple answer - ~| 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: Deleting items older than 7 days from today
You know..if I use just plain SQL..how does it know if I mean 7 Days..7 Weeks..or 7 months?? -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Nope..that didn't work either. Still error resolving estarttime. -Gel -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH ~| 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: Deleting items older than 7 days from today
What does your query look like right now? Also the 'd' in the datediff function lets the query know to use days. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:40 PM To: CF-Talk Subject: RE: Deleting items older than 7 days from today You know..if I use just plain SQL..how does it know if I mean 7 Days..7 Weeks..or 7 months?? -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Nope..that didn't work either. Still error resolving estarttime. -Gel -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH ~| 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
Searching (Verity?)
Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity search, but the powers-that-be are not happy with the results. Because these pages are so long, any search result takes you to the top of a long page...then you pretty much have to do a ctrl-f to find the term you were searching for originally. Is there any way (using Verity or any other product that might be out there) where the search result will link to a position in a document? I can't see how there would be, as each word would have to be anchored...but i've been told to look into it. Incidentally, this is updated every quarter, so the thought of taking these HTML pages and dumping the contents into a database isn't really an option (the contents would have to be re-done with each update, in addition to importing the content itself)...more maintenance than mgmt cares to allocate to this particular project. Any leads would be appreciated. Thx, Charlie ~| 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: Searching (Verity?)
How about a pdf? -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:52 PM To: CF-Talk Subject: Searching (Verity?) Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity search, but the powers-that-be are not happy with the results. Because these pages are so long, any search result takes you to the top of a long page...then you pretty much have to do a ctrl-f to find the term you were searching for originally. Is there any way (using Verity or any other product that might be out there) where the search result will link to a position in a document? I can't see how there would be, as each word would have to be anchored...but i've been told to look into it. Incidentally, this is updated every quarter, so the thought of taking these HTML pages and dumping the contents into a database isn't really an option (the contents would have to be re-done with each update, in addition to importing the content itself)...more maintenance than mgmt cares to allocate to this particular project. Any leads would be appreciated. Thx, Charlie ~| 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: Searching (Verity?)
Tim: I'd still have 30-ish PDFs, which, when searched, would go to the top of each PDF. Looking for some way to point not only to a document that contains the search term, but to point to the spot within the document that contains the search term. There is actually a desktop version of this application, which is what the mgmt wants me to duplicate. On the desktop version (which seems to be a little VB app), you do your search, it shows the results in a window, and when you click the results, it takes you to the spot in the document where the search term is located. That's the mandate here. They want that...but on the Intranet :) charlie Tim Laureska writes: How about a pdf? -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:52 PM To: CF-Talk Subject: Searching (Verity?) Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity search, but the powers-that-be are not happy with the results. Because these pages are so long, any search result takes you to the top of a long page...then you pretty much have to do a ctrl-f to find the term you were searching for originally. Is there any way (using Verity or any other product that might be out there) where the search result will link to a position in a document? I can't see how there would be, as each word would have to be anchored...but i've been told to look into it. Incidentally, this is updated every quarter, so the thought of taking these HTML pages and dumping the contents into a database isn't really an option (the contents would have to be re-done with each update, in addition to importing the content itself)...more maintenance than mgmt cares to allocate to this particular project. Any leads would be appreciated. Thx, Charlie ~| 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: Searching (Verity?)
Are these docs too large to incorporate into 1 PDF ?... if you do that, then there is that type of search capability ... just a thought -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:02 PM To: CF-Talk Subject: Re: Searching (Verity?) Tim: I'd still have 30-ish PDFs, which, when searched, would go to the top of each PDF. Looking for some way to point not only to a document that contains the search term, but to point to the spot within the document that contains the search term. There is actually a desktop version of this application, which is what the mgmt wants me to duplicate. On the desktop version (which seems to be a little VB app), you do your search, it shows the results in a window, and when you click the results, it takes you to the spot in the document where the search term is located. That's the mandate here. They want that...but on the Intranet :) charlie Tim Laureska writes: How about a pdf? -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:52 PM To: CF-Talk Subject: Searching (Verity?) Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity search, but the powers-that-be are not happy with the results. Because these pages are so long, any search result takes you to the top of a long page...then you pretty much have to do a ctrl-f to find the term you were searching for originally. Is there any way (using Verity or any other product that might be out there) where the search result will link to a position in a document? I can't see how there would be, as each word would have to be anchored...but i've been told to look into it. Incidentally, this is updated every quarter, so the thought of taking these HTML pages and dumping the contents into a database isn't really an option (the contents would have to be re-done with each update, in addition to importing the content itself)...more maintenance than mgmt cares to allocate to this particular project. Any leads would be appreciated. Thx, Charlie ~| 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: Searching (Verity?)
hmm..i didn't realize that type of searching was available in PDFs. Is it thru Verity? Unfortunately tho, it would also mean having to re-do all of the table of contents. but at least it's an option i can present for consideration. thx, charlie Tim Laureska writes: Are these docs too large to incorporate into 1 PDF ?... if you do that, then there is that type of search capability ... just a thought -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:02 PM To: CF-Talk Subject: Re: Searching (Verity?) Tim: I'd still have 30-ish PDFs, which, when searched, would go to the top of each PDF. Looking for some way to point not only to a document that contains the search term, but to point to the spot within the document that contains the search term. There is actually a desktop version of this application, which is what the mgmt wants me to duplicate. On the desktop version (which seems to be a little VB app), you do your search, it shows the results in a window, and when you click the results, it takes you to the spot in the document where the search term is located. That's the mandate here. They want that...but on the Intranet :) charlie Tim Laureska writes: How about a pdf? -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:52 PM To: CF-Talk Subject: Searching (Verity?) Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity search, but the powers-that-be are not happy with the results. Because these pages are so long, any search result takes you to the top of a long page...then you pretty much have to do a ctrl-f to find the term you were searching for originally. Is there any way (using Verity or any other product that might be out there) where the search result will link to a position in a document? I can't see how there would be, as each word would have to be anchored...but i've been told to look into it. Incidentally, this is updated every quarter, so the thought of taking these HTML pages and dumping the contents into a database isn't really an option (the contents would have to be re-done with each update, in addition to importing the content itself)...more maintenance than mgmt cares to allocate to this particular project. Any leads would be appreciated. Thx, Charlie ~| 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: Searching (Verity?)
I'm sure money is an issue (it always is) but these product rocks. You can probably get the site up and searchable this week. And it jumps to specific items within a PDF too. http://www.dtsearch.com/dtweb.html Jerry Johnson [EMAIL PROTECTED] 04/01/03 03:02PM Tim: I'd still have 30-ish PDFs, which, when searched, would go to the top of each PDF. Looking for some way to point not only to a document that contains the search term, but to point to the spot within the document that contains the search term. There is actually a desktop version of this application, which is what the mgmt wants me to duplicate. On the desktop version (which seems to be a little VB app), you do your search, it shows the results in a window, and when you click the results, it takes you to the spot in the document where the search term is located. That's the mandate here. They want that...but on the Intranet :) charlie Tim Laureska writes: How about a pdf? -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:52 PM To: CF-Talk Subject: Searching (Verity?) Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity search, but the powers-that-be are not happy with the results. Because these pages are so long, any search result takes you to the top of a long page...then you pretty much have to do a ctrl-f to find the term you were searching for originally. Is there any way (using Verity or any other product that might be out there) where the search result will link to a position in a document? I can't see how there would be, as each word would have to be anchored...but i've been told to look into it. Incidentally, this is updated every quarter, so the thought of taking these HTML pages and dumping the contents into a database isn't really an option (the contents would have to be re-done with each update, in addition to importing the content itself)...more maintenance than mgmt cares to allocate to this particular project. Any leads would be appreciated. Thx, Charlie ~| 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: CF Scheduler?
Any idea why in the log file for scheduler, I see that my Scheduled Task has been initiated and completed but nothing happens. When I run the tasks from the browser (on the server) it runs without a problem and processes the messages as designed? BTW: CF 5 is the server and IE is the browser. --- I must be brain dead and hope someone has a simple answer -- Make sure your scheduled task code isn't relying on any session vars. Also double-check any url vars and make sure they're in the URL for the task. And lastly, Make sure the same is also true for the first Application.cfm in the directory or any parent directories (all the way to the root of the drive or the *nix root directory) so as to prevent those from causing problems with the scheduled task. iirc any errors which occur on the page being requested won't appear in the scheduler log, they'll appear in the application log like any other error, so if you're running a scheduled task the scheduler log will say ok even if an error occurred on that page because the scheduler was able to receive the page via cfhttp without any 403 forbidden or 404 not found errors. That's what I seem to remember anyway. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT:Oraclequery-quick question on an insert
I have an insert query that I can't get to work... when I remove the top line and run it as a select statement it's fine. when I add the insert statement I get the error 'invalid number' job_ID is actually a varchar2 field- not a number field. here's the query INSERT INTO HR_DEPARTMENTS (DEPARTMENT_nAME, Mgr_Job_ID, LOCATION_ID) SELECT DISTINCT DEPTNAME, JOB_ID, LOCATION_ID FROM HR_TEMPDUMP T JOIN HR_lOCATIONS L ON T.cITY=L.CITY JOIN HR_JOBS J ON T.JOBTITLE=J.JOB_TITLE WHERE j.JOB_ID LIKE 'Mgr%' / any ideas? Thanks in advance. j ~| 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
Display Excel Data
I am trying to deliver spreadsheets in my browser using CF and BlueDragon. I can't get it to display correct. Anyone know what the problem could be?? Here is the code I am using CFSETTING ENABLECFOUTPUTONLY=yes CFQUERY name=PrimaryUserNames datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE SEAT_ID IS NOT NULL /CFQUERY CFQUERY name=PrimaryUsers datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE ROOM = 'P216' OR ROOM = 'P237' OR ROOM = 'D215' /CFQUERY CFSET TabCHar =Chr(9) CFSET NewLine =Chr(13) CHR(10) CFCONTENTTYPE=application/msexcel CFHEADER NAME=Content-Disposition value=filename=NNPTC_USERS.xls CFLOOP QUERY=PrimaryUserNames cfoutput #Rank##TabCHar# #First_Name##TabCHar# #Middle_Initial##TabCHar# #Last_Name##TabCHar# #Room##TabCHar# #Floor##TabCHar# #SEAT_ID##TabCHar# #Seat_Clin##TabCHar##NewLine# /cfoutput /CFLOOP ~| 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: Display Excel Data
You need to tell the browser that you are trying to deliver a different MIME type than the usual HTML. The CFCONTENT tag should get you there, I think. Jerry Johnson [EMAIL PROTECTED] 04/01/03 07:43PM I am trying to deliver spreadsheets in my browser using CF and BlueDragon. I can't get it to display correct. Anyone know what the problem could be?? Here is the code I am using CFSETTING ENABLECFOUTPUTONLY=yes CFQUERY name=PrimaryUserNames datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE SEAT_ID IS NOT NULL /CFQUERY CFQUERY name=PrimaryUsers datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE ROOM = 'P216' OR ROOM = 'P237' OR ROOM = 'D215' /CFQUERY CFSET TabCHar =Chr(9) CFSET NewLine =Chr(13) CHR(10) CFCONTENTTYPE=application/msexcel CFHEADER NAME=Content-Disposition value=filename=NNPTC_USERS.xls CFLOOP QUERY=PrimaryUserNames cfoutput #Rank##TabCHar# #First_Name##TabCHar# #Middle_Initial##TabCHar# #Last_Name##TabCHar# #Room##TabCHar# #Floor##TabCHar# #SEAT_ID##TabCHar# #Seat_Clin##TabCHar##NewLine# /cfoutput /CFLOOP ~| 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: Display Excel Data
try CFHEADER NAME=Content-Disposition VALUE=Inline;filename=foo.xls cfcontent type=application/vnd.ms-excel Doug -Original Message- From: Michael Pool [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 7:44 PM To: CF-Talk Subject: Display Excel Data I am trying to deliver spreadsheets in my browser using CF and BlueDragon. I can't get it to display correct. Anyone know what the problem could be?? Here is the code I am using CFSETTING ENABLECFOUTPUTONLY=yes CFQUERY name=PrimaryUserNames datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE SEAT_ID IS NOT NULL /CFQUERY CFQUERY name=PrimaryUsers datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE ROOM = 'P216' OR ROOM = 'P237' OR ROOM = 'D215' /CFQUERY CFSET TabCHar =Chr(9) CFSET NewLine =Chr(13) CHR(10) CFCONTENTTYPE=application/msexcel CFHEADER NAME=Content-Disposition value=filename=NNPTC_USERS.xls CFLOOP QUERY=PrimaryUserNames cfoutput #Rank##TabCHar# #First_Name##TabCHar# #Middle_Initial##TabCHar# #Last_Name##TabCHar# #Room##TabCHar# #Floor##TabCHar# #SEAT_ID##TabCHar# #Seat_Clin##TabCHar##NewLine# /cfoutput /CFLOOP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Searching (Verity?)
See if dtSearch will work - www.dtsearch.com - just an idea :-) Thanks, Mark -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:02 PM To: CF-Talk Subject: Re: Searching (Verity?) Tim: I'd still have 30-ish PDFs, which, when searched, would go to the top of each PDF. Looking for some way to point not only to a document that contains the search term, but to point to the spot within the document that contains the search term. There is actually a desktop version of this application, which is what the mgmt wants me to duplicate. On the desktop version (which seems to be a little VB app), you do your search, it shows the results in a window, and when you click the results, it takes you to the spot in the document where the search term is located. That's the mandate here. They want that...but on the Intranet :) charlie Tim Laureska writes: How about a pdf? -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:52 PM To: CF-Talk Subject: Searching (Verity?) Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity search, but the powers-that-be are not happy with the results. Because these pages are so long, any search result takes you to the top of a long page...then you pretty much have to do a ctrl-f to find the term you were searching for originally. Is there any way (using Verity or any other product that might be out there) where the search result will link to a position in a document? I can't see how there would be, as each word would have to be anchored...but i've been told to look into it. Incidentally, this is updated every quarter, so the thought of taking these HTML pages and dumping the contents into a database isn't really an option (the contents would have to be re-done with each update, in addition to importing the content itself)...more maintenance than mgmt cares to allocate to this particular project. Any leads would be appreciated. Thx, Charlie ~| 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
Is there a trick...
Is there a trick...to getting Request variables to work with pages that have frames? Something like this works in pages without frames. What gives? cflock SCOPE=Application THROWONTIMEOUT=NO TIMEOUT=10 TYPE=Exclusive cfscript Application.BGColor=FF; // White Application.FlagColor=FF; // Dark Red // Request.AdminVars = Duplicate(Application); /cfscript /cflock Am I missing something??? Ché Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there a trick...
Think of frames as individual pages. Including not only the page that creates the frame, but each frame's SRC attribute. Therefore each has its own set of request variables that have to be handled in the same way that individual pages have to handle them. Once you get this, then dealing with frames is neither more nor less difficult than any regular page -- although, to be sure, a frames-based site will typically score much much lower in the search engine rankings than the equivalent non-frames site. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 5:02 PM To: CF-Talk Subject: Is there a trick... Is there a trick...to getting Request variables to work with pages that have frames? Something like this works in pages without frames. What gives? cflock SCOPE=Application THROWONTIMEOUT=NO TIMEOUT=10 TYPE=Exclusive cfscript Application.BGColor=FF; // White Application.FlagColor=FF; // Dark Red // Request.AdminVars = Duplicate(Application); /cfscript /cflock Am I missing something??? Ché Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| 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
