RE: Homesite+ Error
Open up a folder on your desktop ... go to folder options, open the FileTypes tab ... from there you can change the icons to anything you like. To get the HomeSite icons, find the .cfm listing, click on advance ... click on icon browse to the HS application exe and click it ... a bevy of ICON options will pop up. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Tangorre, Michael [SMTP:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 10:09 AM To: CF-Talk Subject: RE: Homesite+ Error I used to get that too... I uninstalled, dug through the registry and deleted all keys pertainig to homesite, reinstalled to adifferent location... problem solved. However, all my .cfm files have icon types that look like word pad!!! How do i get them to appear with the homesite icon??? -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:07 PM To: CF-Talk Subject: OT: Homesite+ Error Whenever I open Homesite+ I get an error along the lines of The system cannot find the file.Occasionally it will display a large gray dialog box showing the contents of a template and some other error.The other thing I notice is that Homesite won't start in the folder last opened in the Files tab as I've got setup in the startup configuration.I've uninstalled and reinstalled with no improvement. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: lite source control for Homesite+ ?
I wonder if you wrote a WHS script to use within HS, if you couldn't emulate this behavior ... using, say the OpenTextFile method, and setting the iomode to ForWriting or ForAppending?Since the file was open in a way that told the system it was going to be written to, if that wouldn't lock it for any other application. If such operations are part of the API, I've got to believer there is a way to get to that function through ADO. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Samuel Neff [SMTP:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 8:44 AM To: CF-Talk Subject: RE: lite source control for Homesite+ ? This functionality is built into Windows, it just depends on how applications implement file open/save. In Windows API you can open a file, read to it, and optionally close it. Multiple program can get a shared open of a file or programs can get an exclusive open of a file.If you do an exclusive open and leave it open, then the file is locked and windows won't let another program open it. This is how Office does it's file open/save.It even allows the program to be notified when the file is no longer locked, which is a very kewl feature not present in most source control systems.However, most text editors, including HomeSite, open a file, read to memory, and then close it.When the save, then open, write, and close.They don't leave it open and thus it can be modified by another program.AFAIK, there is no option to change this behavior. Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: lite source control for Homesite+ ?
If that's the case, it sounds like you could write a script that creates a custom open dialog ... it would -- after you select the file you want to open, check to see if there is a file of the same name with .lck extension ... -- if yes, not let you open the file; -- if no, let you open the file and create a .lck file All developers would then need to ALWAYS use the custom open dialog to open files. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Kevin Graeme [SMTP:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 9:12 AM To: CF-Talk Subject: Re: lite source control for Homesite+ ? We're on the same network. How does MS Office do it so effortlessly? Do Word and Excel have a built-in CVS system?! Or is there just a bit of Windows scripting that can replicate this? The more I look at it, the more it seems odd that this basic little idea isn't built into Windows drive/file sharing. Office does it in pretty much the same way that DW does it. When you open the file, it puts a .lck file there with the same name. Then when anyone else tries to open the file, Office looks for a file of the same name but with a .lck extension. If that exists, then it warns the user. -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Using CFHTTP to download EPSes
Here's my tag: cfhttp url="" method=get path=#request.ImagePath# file=#ad_struct[loopCount].adID##request.filetype#.EPS?a=site/locationt=ts /f:eps Tag works fine for getting the JPG version of the image.But when adding the stuff to request the EPS version, nothing happens.However, if I hard code the EPS request URL into my browser window, works fine. Any thoughts, suggestions? H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using CFHTTP to download EPSes
Never mind ... found the problem ... wrong code in one of the attributes. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 11:32 AM To: CF-Talk Subject: Using CFHTTP to download EPSes Here's my tag: cfhttp url="" method=get path=#request.ImagePath# file=#ad_struct[loopCount].adID##request.filetype#.EPS?a=site/locationt= ts /f:eps Tag works fine for getting the JPG version of the image.But when adding the stuff to request the EPS version, nothing happens.However, if I hard code the EPS request URL into my browser window, works fine. Any thoughts, suggestions? H. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Another HomeSite+ Scripting Question
I've been through the documentation that comes with HomeSite+ but have not been able to find anything that gives me enough of a hint to answer this question ... If I want to use JScript to access an MSSQL datasource from within HomeSite, either through a datasource, through the RDS/FTP resource tab pane, or directly ... what objects, methods, properties, etc. do I need to know about?Where can I get more documentation? H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another HomeSite+ Scripting Question
Steve:
JScript, as well as VBScript, can be used in the Windows Scripting
Environment.You can access various (if not all?) Windows objects.
HomeSite (and Studio and JRun) allow you to run scripts within the
application to perform various tasks.It's a way to extend the
functionality of HomeSite/Studio.
Normally, to run a script you would create a custom button on a toolbar, but
you can also run a script, if it is the open/active document, by pressing
shift-control-Q.
Take the code below, paste it into a document, save it with a .js extension,
then press shift-control-Q (you may need to change the path of the file
you're saving before executing)
function Main() {
var sURL;
var sContents;
var doc;
var app;
app = Application;
doc = app.ActiveDocument;
sURL = http://www.howardowens.com/;
with (app){
sContents = GetURL(sURL);
// Storing HTML code of the URL in sContents
}
var fs = new ActiveXObject(Scripting.FileSystemObject);
var TestFile = fs.CreateTextFile(C:\\CFusionMX\\wwwroot\\foundpage.html,
true);
TestFile.WriteLine(sContents);
}
/-- end code with curly brace above.
Now go open the document you just saved.It's the source code for the page
you specified in the script.
Here's more info for you:
http://www.webreference.com/js/column48/customize.html
http://scripts.hsguide.com/scripts.php3
H.
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
-Original Message-
From: DURETTE, STEVEN J (AIT) [SMTP:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 11:44 AM
To: CF-Talk
Subject: RE: Another HomeSite+ Scripting Question
I was under the impression that JSCRIPT was client side only and therefore
cannot access datasources.
Steve
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Another HomeSite+ Scripting Question
Jon, I can't find the UDF browser on cflib.org :-( ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: jon hall [SMTP:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:25 PM To: CF-Talk Subject: Re: Another HomeSite+ Scripting Question Totally missed that JScript clause in your question... You can access COM/ActiveX Objects from JScript, so you could just use ADO. cflib.org has a homesite udf browser that accesses a COM object if you want an example. -- jon mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another HomeSite+ Scripting Question
Jon, never mind ... it's under tools, not part of the udflib. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: jon hall [SMTP:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:25 PM To: CF-Talk Subject: Re: Another HomeSite+ Scripting Question Totally missed that JScript clause in your question... You can access COM/ActiveX Objects from JScript, so you could just use ADO. cflib.org has a homesite udf browser that accesses a COM object if you want an example. -- jon mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another HomeSite+ Scripting Question
Well, obviously ... I just started.But I'm damn excited about figuring it all out.I've already written four scripts that will be very, very useful to my development process.And I have several ideas on others I'd like. That's why I want to learn more about ADO, especially as it pertains to accessing database objects.Still haven't found anything useful on that topic.I guess I'll need to hit the bookstore after work and see what I can find there. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Raymond Camden [SMTP:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:30 PM To: CF-Talk Subject: RE: Another HomeSite+ Scripting Question Just curious, how many people use this tool? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another HomeSite+ Scripting Question
NP for me in HomeSite+ 5.2 H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: jon hall [SMTP:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 3:13 PM To: CF-Talk Subject: Re: Another HomeSite+ Scripting Question I used it until there was a new version of Homesite or something that broke it...can't remember what exactly. Haven't had a chance to go grab the new version. Pretty cool little app though. -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Studio 5 question
Actually, I can't get ctrl-M to match braces ... only CFML tags.
On the following link you'll find a match braces script you can install into
a homesite toolbar
http://scripts.hsguide.com/scripts.php3#bracematch2
Here's instructions on how to install:
http://www.macromedia.com/support/homesite/ts/documents/tn17448.htm
H.
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
-Original Message-
From: Scott Brady [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 1:28 PM
To: CF-Talk
Subject: re: CF Studio 5 question
Original Message:
From: Ryan Stille [EMAIL PROTECTED]
For example is textpad I can highlight any type of bracket ()[]{},
then press Ctrl+M and it highlights the matching bracket.Very useful.
Yes. It's . . . CTRL-M.You don't actually have to highlight it. If your
cursor is within the tag, it will find the matching tag.
(though, I've found that when dealing with a series of nested cfif's (for
example), it doesn't always work)
Scott
---
Scott Brady
http://www.scottbrady.net/
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Cfloop ?
If you want to avoid using the CFLOOP tag, try:
for(i=1; i totalpages; i=i+1) {
if (i = 1)
{newstart = 1;
newend = 18;}
else
{newstart = (i * 18) + 1;
newend =(i + 1)* 18) - 1;}
}
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
-Original Message-
From: Matthew Walker [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 6:22 PM
To: CF-Talk
Subject: RE: Cfloop ?
You don't need i.currentrow - i is the numeric index. Also you don't need
those # signs.
-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: Thursday, 9 October 2003 12:47 p.m.
To: CF-Talk
Subject: Cfloop ?
How do I call the index from a cfloop in a cfscript?What did I miss?
cfloop index=i from=1 to=#totalpages#
cfscript
if i.currentrow = 1
{newstart = 1;
newend = 18;}
else
{newstart = (i * 18) + 1;
newend =(#i# + 1)* 18) - 1;}
currentpage = #i# + 1;
/cfscript
Thanks!!
Regards,
Eric J. Hoffman
Technology Tamer
DataStream Connexion
www.datastreamconnexion.com
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: cfscript
Improving my knowledge of _javascript_ helped me a lot with CFSCRIPT. I would learn how functions work. Learn flow control and conditionals. Remember you can use cf's built-in functions in cfscript. Go to cflib.org and study a bunch of UDFs. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Gabriel Robichaud [SMTP:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:24 PM To: CF-Talk Subject: cfscript Hey out there? Anyone know of a good resource for CFScript... some documentation would be really cool! TIA!! Gabriel _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Hashtable in CF?
Well, I don't know if a hashtable is exactly what I need since I'm not 100 percent familiar with that kind of datastructure. But what I do need is a function that feeds in a long list of delminated data and parses out one copy of each unique value (where each value might be repeated several times). If I have a list of (2,2,1,3,4,1,2,1) How do I get (2,1,3,4) // order isn't important // ? You ever do anything like this? Sample code to share? A suggested algorithm? (Actually, as I write this, an idea springs to mind, but I'll post anyway in case there's a better idea out there or something I can learn from). H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Hashtable in CF?
Thanks for all of the suggestions ... The UDF works for the direction I ended up taking. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Writing Scripts for HomeSite+
Ray,Can you help me with another issue ...
I get an error if I do this:
if (arDataLine[5] == yes) {
requiredMessage = message=\ arDataLine[6];
}
else { requiredMessage = ; }
But if I do this, it's fine:
if (arDataLine[5] == yes) {
requiredMessage = arDataLine[6];
}
else { requiredMessage = ; }
Or this is fine:
if (arDataLine[5] == yes) {
requiredMessage = message=\;
}
else { requiredMessage = test; }
What I'm trying to do is insert this constructed string into a nother series
of string, via
doc.InsertText(requiredMessage, true)
Any ideas?
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
-Original Message-
From: Raymond Camden [SMTP:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 6:21 AM
To: CF-Talk
Subject: RE: Writing Scripts for HomeSite+
You need to actually write to the document. Consider this example:
function Main() {
var str;
var app;
var doc;
str = Jedi Master Whopper Supreme;
app = Application;
doc = app.ActiveDocument;
doc.InsertText(str, true);
}
The last two lines in particular are what you are missing.
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Writing Scripts for HomeSite+
I'm trying to learn to write JScript for customizing HomeSite+
So I'm stuck right at the beginning ... all I want to do at this point is
write a simple string to the current active document ...
I've tried a few things, most recently ...
function Main() {
var app = Application;
var strText = test;
}
Doesn't work.
Does anybody know how to do this?
H.
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
cffunction question
I'm making my first UDF using CFFUNCTION ... It goes something like this: myFunction(arg1, arg2, arg3) If I hard code the arguments into the function call, it works fine.But if I try this ... myFunction(form.myField), where myField is a list of the three arguments required, it doesn't work.The error says the second argument (which is required) isn't being passed. Any suggestions as to why I can't pass my arguments via the form scope? H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Array of Struts Question
Why does this code:
ad_ID = ArrayNew(1);
item = StructNew();
for (i=1; i LTE ArrayLen(image_ID); i=i+1) {
item.ID = ListGetAt(image_ID[i], 1, _);
item.adRep = ListGetAt(image_ID[i], 2, _);
collection=ArrayAppend(ad_ID, item);
}
Create an Array with duplicate data in all elements instead of keeping each
the data from each pass through the data unique, as God intended?The last
item is overwriting everything that proceeded it.What can I do to get what
I want?
H.
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
-Original Message-
From: Kevin Graeme [SMTP:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 1:16 PM
To: CF-Talk
Subject: Re: security flaw in web services
It's been a
while since I've muddled with Kerberos so I don't know if there's a
clean
way to handle it for a web application. I know there are clients you
can
install that will handle the tickets, but I don't know what it would
take to
integrate them on the client side with the browser.
It takes an experimental Mozilla netlib ;-)
BTW, as of Win2K Windows authentication is largely based on
Kerberos, with a few extensions. So if you use Integrated Windows
Security, you are using Kerberos for browser authentication already.
Interesting. Now that you mention it I do seem to recall now hearing some
hubub about MS Security just being Kerberos. Do you have some quick links
to
information about it? I'm assuming that MS just hard-coded their own
ticket
checker server since I haven't heard of having to designate one?
-Kevin
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Array of Struts Question
Thanks ... been told that before and forgot ...
H
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
-Original Message-
From: Barney Boisvert [SMTP:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 2:42 PM
To: CF-Talk
Subject: RE: Array of Struts Question
Because structs are pass-by-reference, so you only ever have one struct,
just with a lot of reference to it ('item' and each array element).You
need to either move the 'item = structNew()' line inside the loop, or use
duplicate() in the arrayAppend() line.The former should be faster, and
probably more readable as well.
barneyb
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 2:37 PM
To: CF-Talk
Subject: Array of Struts Question
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: parsing txt file - seems unparsable
If you're still having trouble, instead of CFFILE, try this cfsavecontent variable=myDoc. cfinclude template=myDoc.txt /cfsavecontent Now parse your file. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Stephenie Hamilton [SMTP:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 9:19 AM To: CF-Talk Subject: parsing txt file - seems unparsable I am trying to use CFFILE to parse a text file, put the contents in a var and then insert that into a db. However, the file only gets parsed halfway through the first line. I couldn't at first figure out why it would stop. If I opened the file in notepad, added a space, then deleted the space, the file would then parse correctly. I then opened the file in wordpad and discovered that where the parsing stops there is a little square that doesn't show up in notepad, assuming some type of special character or something, but I have no idea what. If I manually delete the little square, then it parses fine (until it runs into the one on the next line etc)... is there any way to get past this? I am beating my head against the wall and can no longer even see straight... tia Stephenie _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Seeking RegEx help
Thanks for the response ... last night I ended up going with a list function
... as you suggest in the second place. I had tried that originally, but got
bad results.Went back to it and got the results I wanted. I think in my
first try I simply had some illogical code that I didn't notice.
But thanks for the regex ... may come in handy someday.
H.
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
-Original Message-
From: Gyrus [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:55 PM
To: CF-Talk
Subject: Re: Seeking RegEx help
At 17:33 01/10/2003 -0700, you wrote:
I have a URL I'm grabbing ...
http://ww.mysite.com/VENTURA-435672_123-1.jpg
I'm actually only interested in grabbing the 435672_123 part.
REReplace(myURL, ([-])([0-9]{6,}[_][0-9]{3})([-]), \2, ONE)
But all that does is drop the dashes from around the number I want ...
how
do I grab out just 435672_123?
This seems to do the trick:
REReplace(myURL, [^-]+-([0-9]{6,6}_[0-9]{3,3})-.+, \1, ONE)
Also a possibility:
ListGetAt(myURL, 2, -)
Gyrus
[EMAIL PROTECTED]
http://norlonto.net/gyrus/dev/
PGP key available
_
[ Todays Threads
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: [Stats] Cold Fusion Talk List Stats; September 2003
Bill Doerrfeld interested in CF-Talk stats? Has he abandoned Lasso and switched to CF? ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Bill Doerrfeld [SMTP:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:07 PM To: CF-Talk Subject: [Stats] Cold Fusion Talk List Stats; September 2003 Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Seeking RegEx help
I have a URL I'm grabbing ...
http://ww.mysite.com/VENTURA-435672_123-1.jpg
I'm actually only interested in grabbing the 435672_123 part.
REReplace(myURL, ([-])([0-9]{6,}[_][0-9]{3})([-]), \2, ONE)
But all that does is drop the dashes from around the number I want ... how
do I grab out just 435672_123?
H.
~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFV: comp.lang.coldfusion Usenet Newsgroup
Speaking of more legitimacy -- what's up with chain bookstores always filing the CF titles under graphic/web design? I asked an employee of my local Barnes and Nobel the other day and he said this was a corporate decision. Personally, it always irks me that CF books aren't in with the programming books.Maybe we should all start complaining to the chains about this, and MM -- MM should file its own protests. I think. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Dave Hodder [SMTP:[EMAIL PROTECTED] Sent: Saturday, September 27, 2003 12:38 PM To: CF-Talk Subject: Re: CFV: comp.lang.coldfusion Usenet Newsgroup Jim McAtee wrote: There's already a CF newsgroup.Why the need for another? It's covered in the comp.lang.coldfusion rationale.Some of us on the existing alt.comp.lang.coldfusion group feel a proper comp.* group would give ColdFusion more legitimacy, as well as the group having better propagation, longer message retention periods, etc. Regards, Dave _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 6.1 RDS
I solved this issue ... thanks to MM support finally answering my questionin the forum.They asked me for more details, such as whether I had CFMX6.1 installed in standalone mode on port 8500 ...Doh!I changed the properties in my RDS setting for local host to point to port8500 and I'm in.H.~~Howard OwensInternet Operations CoordinatorVentura County Star / E.W. Scripps Co.www.venturacountystar.com[EMAIL PROTECTED]AIM: GoCatGo1956~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 6.1 RDS
I did cover this previously, but ... XP Pro, CF 6.1, HS+ 5.2 What do you mean by context root other than /? What is rds.war? H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Dave Carabetta [SMTP:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 7:05 AM To: CF-Talk Subject: RE: 6.1 RDS Tried it. No go. Gee, I wonder if anybody from Macromedia might have some ideas What version of MX are you using? Do you have a context root other than /? If so, make sure you've deployed rds.war correctly. If not, what are the details on your setup (OS, MX version, etc.)? Regards, Dave. _ Instant message during games with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138291 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Enabling RDS on 6.1
I don't have wasweb.xml or j2ee-web.xml And I'm guessing what you give here isn't the full document. I'm not running j2ee, though, just standalone CF 6.1. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 6:08 PM To: CF-Talk Subject: Re: Enabling RDS on 6.1 Here are the different xml settings from my cfusionmx directory. Maybe I have a setting that enables RDS which your missing: \lib\neo-security.xml var name='rds.security.enabled' boolean value='true'/ /var \wwwroot\web-inf\j2ee-web.xml servlet id=macromedia_servlet_7 servlet-nameRDSServlet/servlet-name servlet-classcoldfusion.rds.RdsFrontEndServlet/servlet-class /servlet servlet-mapping id=macromedia_mapping_5 servlet-nameRDSServlet/servlet-name url-pattern/CFIDE/main/ide.cfm/url-pattern /servlet-mapping \wwwroot\web-inf\wasweb.xml servlet servlet-nameRDSServlet/servlet-name servlet-classcoldfusion.rds.RdsFrontEndServlet/servlet-class /servlet servlet-mapping servlet-name RDSServlet /servlet-name url-pattern /CFIDE/main/ide.cfm /url-pattern /servlet-mapping \wwwroot\web-inf\web.xml servlet servlet-nameRDSServlet/servlet-name servlet-classcoldfusion.rds.RdsFrontEndServlet/servlet-class /servlet servlet-mapping servlet-nameRDSServlet/servlet-name url-pattern/CFIDE/main/ide.cfm/url-pattern /servlet-mapping For some reason known only to me I didn't activate RDS when installing CFMX 6.1. How do I re-enable it? TIA! ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138304 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: 6.1 RDS
I have standalone. 2. If you open up WEB-INF/jrun-web.xml, what does it say in between context-root/context-root? I don't have that. In jrun-web.xml, all I have is virtual-mapping resource-path/WEB-INF/resource-path system-pathE:/CFusionMX/wwwroot/WEB-INF/system-path /virtual-mapping H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Dave Carabetta [SMTP:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 10:47 AM To: CF-Talk Subject: RE: 6.1 RDS I did cover this previously, but ... XP Pro, CF 6.1, HS+ 5.2 What do you mean by context root other than /? What is rds.war? 1. By MX version, I meant standalone or for J2EE. 2. If you open up WEB-INF/jrun-web.xml, what does it say in between context-root/context-root? 3. In your SERVER-INF/web.xml file, do you see the both of following entries at any point in the file? servlet id=macromedia_servlet_8789 servlet-nameRDSServlet/servlet-name display-nameApache-Axis Servlet/display-name servlet-classcoldfusion.bootstrap.BootstrapServlet/servlet-class init-param id=InitParam_103401311065856789 param-nameservlet.class/param-name param-valuecoldfusion.rds.RdsFrontEndServlet/param-value /init-param /servlet and servlet-mapping id=macromedia_mapping_5 servlet-nameRDSServlet/servlet-name url-pattern/CFIDE/main/ide.cfm/url-pattern /servlet-mapping I'm on MX for J2EE for JRun, but I'm assuming that with 6.1, the files are the same. Regards, Dave. _ Get MSN 8 Dial-up Internet Service FREE for one month. Limited time offer-- sign up now! http://join.msn.com/?page=dept/dialup ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138305 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Maybe You'll See Something I Don't
I have this file that I'm sucking into a database. I'm treating each line as a list. The delimiters (out of my contro) are . Here's a sample line: 1405 09-17-2003 Mike Keys Re-Spray/Painted/Removed Water/Smoke/Crack Damage. Wall Repair/Texturing Free Estimate - Lic.#416345 r (805)659-6356 r r (805)494-1915 r CENTERIMG SRC=http://web.insidevc.com/classified/logos/6596356.jpg;/CENTER 619620 This particular line is choaking the thing. It wants to read the text starting with the image tag as the fourth element in the list, which creates a bad SQL query. I can't see what is causing this. Do you? Here's the list code: cfset CATEGORY_NUM=#ListGetAt(tmp, 1, )# cfset START_DATE=#ListGetAt(tmp, 2, )# cfset AD_TEXT=#ListGetAt(tmp, 3, )# cfset AD_NUM=#ListGetAt(tmp, 4, )# H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Claude Schneegans [SMTP:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:57 PM To: CF-Talk Subject: Verifying an email address exists Hi, I'd like to know if there exists any method to check if an email address actually exists? I mean not only be syntactically valid, but does correspond to a true mail box in a true server. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138358 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
RE: Auto Pinging Script?
There's also a site out there (and I too lost all my bookmarks) that gives you historical up reports on any domain you ask it to monitor. It will tell you the last time the server was rebooted, what os and server its running, and how often it's been rebooted. I think it even tells you how long it was down for if it's down. If I can find the site again, I'll pass along the url. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: cfhelp [SMTP:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:52 PM To: CF-Talk Subject: RE: Auto Pinging Script? I lost my bookmarks but I had a really cool Whois and trace-route website that showed all the sites hosted on a server. That may be some help in evaluating a host. Anyone know of it or another? Rick ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138361 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
RE: Maybe You'll See Something I Don't
OK, well ... I guess I need to change these delims before processing ... to something not likely to be in the text ... and that's the tough part ... hopefull ^ will work. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Barney Boisvert [SMTP:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:57 PM To: CF-Talk Subject: RE: Maybe You'll See Something I Don't the delimiter argument to the list functions is not a multicharacter string, it's a set of delimiter characters. So listGetAt(myList, 3, ) isn't looking for the third item using as the delimiter, it's looking for the third item using OR as the delimiter. More clearly, listGetAt(myList, 3, ;,) isn't looking for the third item using ;, as the delimiter, it's looking for the third item using ; OR , as the delimiter. listGetAt(i,like;cheese, 3, ;,) will return 'cheese' barneyb -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:48 PM To: CF-Talk Subject: Maybe You'll See Something I Don't ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138362 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
RE: 6.1 RDS
Yes ... I've sent a couple of messages to this list and left a message on the MM forum ... still no help. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Robert Shaw [SMTP:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 1:08 PM To: CF-Talk Subject: 6.1 RDS I've upgraded to cfmx 6.1 and it seems to have broken RDS, it just won't work - has anyone else experienced this? TIA, Rob ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138213 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: 6.1 RDS
That didn't work for me ... even tried stopping and restarting CF, and HS. H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 3:52 PM To: CF-Talk Subject: Re: 6.1 RDS Create a directory in the CFIDE subdirectory called main. That should do it. If not, I'll send you the ide.cfm template that goes there, though my experiments in the past have shown that it was not needed. I've upgraded to cfmx 6.1 and it seems to have broken RDS, it just won't work - has anyone else experienced this? TIA, Rob ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138219 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: 6.1 RDS
Tried it. No go. Gee, I wonder if anybody from Macromedia might have some ideas H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 4:29 PM To: CF-Talk Subject: Re: 6.1 RDS Hm. I've seen the problem before and the answer has always been to make sure there is a Main directory under CFIDE and it contains a file called ide.cfm with the following code: html head titleIDE Interface Base Page/title /head /html The RDS service is a 'pickup' service that takes any data sent to that particular template and instead uses it for RDS information. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138226 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Upload File Problem
We're talking a new install of XP Pro, CF 6.1 ... Code that I've used in numerous apps to upload a text file ... even still works on our production 5.0 servers, but not working on my new set up. When I cfoutput the file I'm uploading to see what the text is looking like, cfoutput#form.TextFile#/cfoutput cfabort instead of the contents of the file, I get this F:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp58606 .tmp What the heck is going on? H. ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138231 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: JDBC error
Thanks for the suggestions, guys ... For Dave and Jim, I have cf as a SQL user in the SQL admin ... full permissions. For Mark, I tried the IP address ... didn't make a difference ... also, the error I'm getting doesn't refer to the domain name ... it's username ... I can change the domain name and get a domain name error, but right now I'm not getting that error. H. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Jim Davis [SMTP:[EMAIL PROTECTED] Sent: Sunday, September 21, 2003 5:31 PM To: CF-Talk Subject: RE: JDBC error -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, September 21, 2003 6:46 PM To: CF-Talk Subject: RE: JDBC error I had not put the security tab on mixed mode, and doing so got rid of theis part of the error Not associated with a trusted SQL Server connection. But I still can't find the right combo of username ... I've tried domain/cf, sqlname/cf and just cf by itself. I must still be missing something. Is cf a Windows account, or is it an SQL login? It should be an SQL login, and won't need any prefix. Dave's right here - just putting the SQL Server into mixed won't do it - you actually have to (possibly create) and log in as a SQL Server user. Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137977 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: JDBC error -- GOT IT
OK, I figured out how to make a SQL user independent of any server domain, and that worked. H. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137981 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: JDBC error -- Q II
OK, so I've got this new XP Pro machine and I've installed HomeSite+ on it. Now I want to use the Database/RDS pane to view tables and columns in my datasources. As mentioned previously, I sucessfully set up a JDBC datasrouce. I also set up an ODBC datasource. No datasource is showing up in the Database/RDS pane. When I try to open that pane, nothing happens for a long time then I get an unable to connect to server error. Suggestions? H. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138006 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: JDBC error -- Q II
No. But then I'm sure I'm doing it right since I never use RDS to edit files ... H. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ Can you use RDS to edit files, either? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138017 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: JDBC error -- Q II
And ... just checked a new XP machine we're setting up (with HS+) ... some problem ... I've searched the knowledge base on MM and found nothing helpful so far. H. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Dave Watts [SMTP:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 3:44 PM To: CF-Talk Subject: RE: JDBC error -- Q II OK, so I've got this new XP Pro machine and I've installed HomeSite+ on it. Now I want to use the Database/RDS pane to view tables and columns in my datasources. As mentioned previously, I sucessfully set up a JDBC datasrouce. I also set up an ODBC datasource. No datasource is showing up in the Database/RDS pane. When I try to open that pane, nothing happens for a long time then I get an unable to connect to server error. Can you use RDS to edit files, either? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138018 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
HomeSite+ RDS/Datasource Bug (was: RE: JDBC error -- Q II)
Just an additional note ... I remembered how to use RDS ... in settings, I set the RDS time out for 120 seconds ... get an error that says the server returned an unrecognized error (the server is not asking for a password, btw). HomeSite+ 5.2, WinXP Pro, CF 6.1, SQL2000 Background from previous thread ... I can't access my datasources through the RDS/Database pane. H. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138020 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
JDBC error
I'm trying to set up a datasource in the cf administrator. I'm on WinXP Pro with CF 6.1 and MSSQL 2000. Here's the error: Connection verification failed for data source: ventura []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'vsw00\cf'. Reason: Not associated with a trusted SQL Server connection. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'vswsp200\cf'. Reason: Not associated with a trusted SQL Server connection. I've tried lots of things ... set up a SQL Server group, created a user CF and assigned that user to that group. In Enterprise manager, I gave that user every conceivable permission I could find. If somebody is available to get on the phone with me and talk me through this, that might help ... send me your number privately and I'll call you back on my dime. E-mail: [EMAIL PROTECTED], or AIM: GoCatGo1956 ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137771 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: JDBC error
Thanks, Dave. I had not put the security tab on mixed mode, and doing so got rid of theis part of the error Not associated with a trusted SQL Server connection. But I still can't find the right combo of username ... I've tried domain/cf, sqlname/cf and just cf by itself. I must still be missing something. H. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137773 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: cfc vs cfinclude
Well, wait then and see what ads up. Fight the battles that really need to be fought (where bottlenecks are) and don't slow down your development process with fighting battles that won't necessarily impact performance enough to worry about. H. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Samuel Neff [SMTP:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 6:51 PM To: CF-Talk Subject: RE: cfc vs cfinclude 'cause sometimes the little things add up. :-) Sam -- Blog: http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 4:21 PM To: CF-Talk Subject: Re: cfc vs cfinclude (Why are people so focused on micro-performance issues instead of the bigger picture stuff?) Sean A Corfield -- http://www.corfield.org/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137631 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT .Net? Java? No Thanks, We'll Take Macromedia Instead
One of my doctors is part of a very large group. Every member of the medical staff carries around a wireless clipboard .. it is really just a laptop designed to be held and used like a clipboard, or an 8x10 PDA. The entire office is digital. No paper charts or records of any kind (except archives). It's a very cool set up. It's WindowsXP. Full internet access, too. If medical staff wanted an application they could access from any modern computer, then Flash would make a good deal of sense. ~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Dave Carabetta [SMTP:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:58 AM To: CF-Talk Subject: Re: OT .Net? Java? No Thanks, We'll Take Macromedia Instead As a quick aside, I don't know if I see their product as being overly successful in hospitals. It seems that their product is dependent on running in a browser. Most doctors (my brother and father being two of them) carry around PDAs with their patient info, not cumbersome laptops. Unless the UI was designed with PDAs and other handheld devices in mind (the article doesn't mention that), it's a nice-sounding product, but not terribly usable in the real world. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137633 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
(OT) Windows XP Pro
I'm getting a new computer ... I can either keep my Win2K license, or get XP Professional. I know there is a problem running web servers on XP Home. I just want to double check -- no problem on XP, right. This is my development machine, so I shouldn't have any trouble with CF 6.1, MSSQL2000, etc. on an XP Pro machine, right? H. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Where's my CGI.PATH_INFO variable?
I have a little security device I just on some of my sites ... if somebody
goes to the /secure section of the site, and the proper client vars haven't
been set, they get prompted to login.
The code begins with this line:
cfif CGI.PATH_INFO contains /secure
On CF 5.0, this works fine every time.
Now I'm using this code on a CFMX site, and it's not working.
In Debug, the CGI variables shows PATH_INFO as blank.
This bit of debug code:
cfoutputscriptalert('#CGI.PATH_INFO#');/script/cfoutput
Shows the PATH_INFO is blank.
There are other CGI variables that are set, but why is this one blank? I'm
using the same browser session on the same machine to hit the sites on 5.0
and MX, so I don't think it's a browser or client configuration issue.
Is there a setting in MX admin I'm missing?
I've installed CFMX 6.1 on a Win2K machine.
H.
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Where's my CGI.PATH_INFO variable?
I have a little security device I just on some of my sites ... if somebody
goes to the /secure section of the site, and the proper client vars haven't
been set, they get prompted to login.
The code begins with this line:
cfif CGI.PATH_INFO contains /secure
On CF 5.0, this works fine every time.
Now I'm using this code on a CFMX site, and it's not working.
In Debug, the CGI variables shows PATH_INFO as blank.
This bit of debug code:
cfoutputscriptalert('#CGI.PATH_INFO#');/script/cfoutput
Shows the PATH_INFO is blank.
There are other CGI variables that are set, but why is this one blank? I'm
using the same browser session on the same machine to hit the sites on 5.0
and MX, so I don't think it's a browser or client configuration issue.
Is there a setting in MX admin I'm missing?
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
Where's my CGI.PATH_INFO variable?
I have a little security device I just on some of my sites ... if somebody
goes to the /secure section of the site, and the proper client vars haven't
been set, they get prompted to login.
The code begins with this line:
cfif CGI.PATH_INFO contains /secure
On CF 5.0, this works fine every time.
Now I'm using this code on a CFMX site, and it's not working.
In Debug, the CGI variables shows PATH_INFO as blank.
This bit of debug code:
cfoutputscriptalert('#CGI.PATH_INFO#');/script/cfoutput
Shows the PATH_INFO is blank.
There are other CGI variables that are set, but why is this one blank? I'm
using the same browser session on the same machine to hit the sites on 5.0
and MX, so I don't think it's a browser or client configuration issue.
Is there a setting in MX admin I'm missing?
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
CFMX, XML and Verity
Is it possible to use Verity with XML documents (index, search, display)? If so, any good tutorials on the web anywhere? I've looked and haven't been able to find anything that was helpful. If so, URLs, please. H. ~| 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: RE: re: Mach-II
Angus, ever happen to see this page? http://www.fusebox.org/index.cfm?fuseaction=learn.resourceList Or this one http://www.fusebox.org/index.cfm?fuseaction=framework.languages Or this one http://www.fusebox.org/index.cfm?fuseaction=methodology.personas Or this one http://www.fusebox.org/index.cfm?fuseaction=learn.FAQ#Q3 Well, ... I think you get the point ... H. -Original Message- From: Angus McFee [SMTP:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:09 PM To: CF-Talk Subject: RE: RE: re: Mach-II Matt - Good to hear from a fellow fuseboxer! No, this isn't a joke, this guy clearly has a problem with what fusebox has become and has made this other framework that clearly doesn't do most of what Fusebox is capable of. I don' t think him having helped make fusebox or having been in a few books makes a huge difference. My dog has been in a few books, that doesn't mean he don't hate cats. But this really sounds like he is dissing fusebox. Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. These things aren't new and they don't do something you can't do with fusebox already. Fusebox already works in ColdFusion, PHP, ASP, JSP and Perl, and I have even seen a TCL port for the framework. In PHP, you can do all the object oriented programming you want, so I don't see why there would be a need for this mach-ii except to take away from fusebox. This guy is just one of the ones who is never going to get what it is all about. Angus McFee -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:37 PM To: CF-Talk Subject: Re: Mach-II This is a joke right? -Matt On Wednesday, July 30, 2003, at 04:08 PM, Angus McFee wrote: Hal - I've heard from plenty of people looking for a way to beat up on Fusebox, but usually they have nothing to say when it comes to building a better framework. This is the first time in a long time anyone has suggested an alternative approach, and I really don't see how any of this benefits developers. This mach-ii stuff looks like just another petty attack on Fusebox. It's pretty clear we see things differently when it comes to building Web applications. I don't know you, but I can tell you are a pretty intelligent person, so you probably have some good reasons for why you don't like or hate fusebox. What I have to ask you is: do you use fusebox? Becuase there are plenty of people who are ready to attack it anytime and don't even know ColdFusion, much less what a framework is. You will probably never be convinced about the benefits of fusebox, all I can do is disagree with you, and point out all the great things fusebox does for developers: * it separates business logic from presentation logic, making for more organized, efficent code * it gives developers a common set of rules and methods to work from, so that everyone can understand what the other people are doing on a project regardless of the size of a team * it modularizes and encapsulates code, making it easier to reuse and thus to maintain * it is self-documenting, containing a complete, inline XML standard for documenting your applications * most importantly, there are thousands and thousands of fusebox developers out there, and more and more shops are choosing to use it every day. it is close to becoming a de-facto standard, which I doubt your mach-ii 'framework' will ever be able to match Angus McFee -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:16 PM To: CF-Talk Subject: RE: RE: re: Mach-II You're right, Dave. We're not looking to be able to incorporate Fusebox 3 (or 4) with Mach-II. We think that Fusebox is a great framework for procedural programmers. (Please, God, don't let this degenerate into yet another pro/con Fusebox debate...) Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. Hal Helms Java for CF Programmers class in Las Vegas, August 18-22 www.halhelms.com - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software ~| 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
RE: RE: re: Mach-II
Classic, Hal. And Classy. Angus, what do you think of Jeremy Allaire? Do think he's one of the ones who doesn't get it, too? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ -Original Message- From: Hal Helms [SMTP:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:36 PM To: CF-Talk Subject: RE: RE: re: Mach-II Yeah, yeah, I've heard of this Fusebox framework. I've even used it once or twice. I just don't get what the big deal is, though. Sure it helps you separate logic and presentation, it helps teams work together, it provides encapsulation, etc, etc. But is that really sufficient grounds for liking something - that it helps people? What's next? Shall we adopt something simply because it works? Where would great corporations like Microsoft or Oracle be if they adopted that attitude? You sound too much like that guy in CFDJ who sounds like freakin' Oprah with his talk about empowering people and supporting developers. Give me something manlier than that! And as for documentation, which you note as a strength of Fusebox, well, all I can do is quote a greater man than I who said: It was hard to write. It should be hard to understand. Hal Helms Java for CF Programmers class in Las Vegas, August 18-22 www.halhelms.com -Original Message- From: Angus McFee [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 5:09 PM To: CF-Talk Subject: RE: RE: re: Mach-II Matt - Good to hear from a fellow fuseboxer! No, this isn't a joke, this guy clearly has a problem with what fusebox has become and has made this other framework that clearly doesn't do most of what Fusebox is capable of. I don' t think him having helped make fusebox or having been in a few books makes a huge difference. My dog has been in a few books, that doesn't mean he don't hate cats. But this really sounds like he is dissing fusebox. Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. These things aren't new and they don't do something you can't do with fusebox already. Fusebox already works in ColdFusion, PHP, ASP, JSP and Perl, and I have even seen a TCL port for the framework. In PHP, you can do all the object oriented programming you want, so I don't see why there would be a need for this mach-ii except to take away from fusebox. This guy is just one of the ones who is never going to get what it is all about. Angus McFee -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:37 PM To: CF-Talk Subject: Re: Mach-II This is a joke right? -Matt On Wednesday, July 30, 2003, at 04:08 PM, Angus McFee wrote: Hal - I've heard from plenty of people looking for a way to beat up on Fusebox, but usually they have nothing to say when it comes to building a better framework. This is the first time in a long time anyone has suggested an alternative approach, and I really don't see how any of this benefits developers. This mach-ii stuff looks like just another petty attack on Fusebox. It's pretty clear we see things differently when it comes to building Web applications. I don't know you, but I can tell you are a pretty intelligent person, so you probably have some good reasons for why you don't like or hate fusebox. What I have to ask you is: do you use fusebox? Becuase there are plenty of people who are ready to attack it anytime and don't even know ColdFusion, much less what a framework is. You will probably never be convinced about the benefits of fusebox, all I can do is disagree with you, and point out all the great things fusebox does for developers: * it separates business logic from presentation logic, making for more organized, efficent code * it gives developers a common set of rules and methods to work from, so that everyone can understand what the other people are doing on a project regardless of the size of a team * it modularizes and encapsulates code, making it easier to reuse and thus to maintain * it is self-documenting, containing a complete, inline XML standard for documenting your applications * most importantly, there are thousands and thousands of fusebox developers out there, and more and more shops are choosing to use it every day. it is close to becoming a de-facto standard, which I doubt your mach-ii 'framework' will ever be able to match Angus McFee -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:16 PM To: CF-Talk Subject:
RE: Anti-Spam Email harvesting
FWIW: All of my [EMAIL PROTECTED] e-mail addresses get hammered with spam. I say use forms as much as possible. H. -Original Message- From: Jochem van Dieten [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 11:43 AM To: CF-Talk Subject: Re: Anti-Spam Email harvesting Ian Skinner wrote: What are current best practices (if any are left) for preventing, or at least discouraging, the harvesting of e-mail addresses from web pages for use by spammers? We are building a new corporate website that will have at least a dozen different e-mail contacts for various functions. It would be nice if we could at least mitigate some of the deluge of junk mail that will come to these poor cooperate citizens once e-mail address they are responsible for reviewing have gone public. The easiest one is not to have any email addresses on the site. Just have a feedback form that is accessible for all (even if the rest of the site has certain requirements). (You still need the (rather predictable) role addresses from RFC 2142, but in my experience these addresses are somewhat listwashed.) 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
deleting log files
I've created a log file via CFLog. It's in the CFusionMX\logs folder. Daily, I have a template that reads it and e-mails the content to some people. I then want to delete it. CFFile won't delete it. I can't even delete it by hand (another process is using it). I can only delete it via the CFAdmin. I assume the process using it is CF. How do I get it automatically unlocked, if there is a way, so I can delete it with CFFile? H. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dynamically populating an XML document
I have a newly created XML document: cfscript file_log = XmlNew(); file_log.xmlRoot = XmlElemNew(file_log, Collection); file_log.xmlRoot.XmlChildren[1] = XmlElemNew(file_log, File); /cfscript I want to loop over some values and insert them, so the document ends up looking something like this: collection filesome value/file filesome value/file filesome value/file filesome value/file /collection I'm trying to insert with some variation of: cfset StructInsert(file_log.Collection.XmlAttributes, File, selectedElements[i].XmlAttributes.id#.pdf) But I keep getting this error with every thing I try: Missing argument name. When using named parameters to a function, every parameter must have a name. I'm not getting what I'm missing? ~| 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: Dynamically populating an XML document
Thanks, but ... That won't work for me because I wind up with a loop inside a loop, looping over the same elements. I need to dynamically increase the size of my structure with each loop and output after the loop exists. I guess I'm thinking about this wrong, and I need to use an array of structures. H. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 4:05 PM To: CF-Talk Subject: Re: Dynamically populating an XML document I've never been in a situation where create a document via the DOM was necessary. cfsavecontent does the trick for me. cfsavecontent variable=foo collection cfloop... filesome value/file /cfloop /collection /cfsavecontent cfset file_log = xmlParse(foo) -- mailto:[EMAIL PROTECTED] Monday, June 16, 2003, 6:33:22 PM, you wrote: OH I have a newly created XML document: OH cfscript OH file_log = XmlNew(); OH file_log.xmlRoot = XmlElemNew(file_log, Collection); OH file_log.xmlRoot.XmlChildren[1] = XmlElemNew(file_log, File); OH /cfscript OH I want to loop over some values and insert them, so the document ends up OH looking something like this: OH collection OH filesome value/file OH filesome value/file OH filesome value/file OH filesome value/file OH /collection OH I'm trying to insert with some variation of: OH cfset StructInsert(file_log.Collection.XmlAttributes, File, OH selectedElements[i].XmlAttributes.id#.pdf) OH But I keep getting this error with every thing I try: OH Missing argument name. When using named parameters to a function, every OH parameter must have a name. OH I'm not getting what I'm missing? ~| 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: Dynamically populating an XML document
I've tried this, but it's not getting me there either: cfscript file_log.xmlRoot.XmlChildren[i] = XmlElemNew(file_log, File); file_log.xmlRoot.Collection.File[i].XmlText = #selectedElements[i].XmlAttributes.id#.pdf; /cfscript H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 4:13 PM To: CF-Talk Subject: RE: Dynamically populating an XML document Thanks, but ... That won't work for me because I wind up with a loop inside a loop, looping over the same elements. I need to dynamically increase the size of my structure with each loop and output after the loop exists. I guess I'm thinking about this wrong, and I need to use an array of structures. H. ~| 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
CFMX datasource question
I just installed CFMX on my development machine. It's co-installed with 5.0. I imported my 5.0 settings, including datasources, but on all my datasources, I'm getting this error: Connection verification failed for data source: encore []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Connectivity info seems to be fine. What might the problem be? (connecting to MSSQL 2000) H. ~| 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: CFMX datasource question
If I just test, it just says error If I try to update, I get this the error posted below. H. -Original Message- From: Matthew Walker [SMTP:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 4:28 PM To: CF-Talk Subject: RE: CFMX datasource question What happens when you test the datasources within CF administrator? I've been tripped up by the port being incorrectly set in the past. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, 13 June 2003 11:02 a.m. To: CF-Talk Subject: CFMX datasource question I just installed CFMX on my development machine. It's co-installed with 5.0. I imported my 5.0 settings, including datasources, but on all my datasources, I'm getting this error: Connection verification failed for data source: encore []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Connectivity info seems to be fine. What might the problem be? (connecting to MSSQL 2000) H. ~| 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
populate the damn array
OK, this probably something real stupid, but I'm not seeing it ...
This code takes a tabbed file and is supposed to parse it into an array of
structures.
The problem is, the array is populating with 36 elements of the same data.
Whatever the last item in the file is, that because the repeated element ...
which means that each array append is overwriting previous data, or
something like that ... below is the complete code ... can anyone see what
the error is? Probably something simple and stupid:
cfscript
Manifest=Replace(manifest, chr(09), ;, ALL);
ListFileLen=ListLen(Manifest, #chr(10)##chr(13)#);
container = ArrayNew(1);
ad = StructNew();
for (y=1; y LTE ListFileLen; y=y+1) {
ListFileText=#ListGetAt(Manifest, y,
#chr(10)##chr(13)#)#;
ad.attribute_name=#ListGetAt(ListFileText, 2, ;)#;
ad.ad_id=#ListGetAt(ListFileText,
3, ;)#;
ad.display_text=Caption;
ad.attribute_cdata=#ListGetAt(ListFileText, 4, ;)#;
ad.startdate=#ListGetAt(ListFileText, 5, ;)#;
ad.stopdate=#ListGetAt(ListFileText, 5, ;)#;
containerAds = ArrayAppend(container, ad);
}
/cfscript
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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: populate the damn array
Great explanation, Bryan. Thanks. And it worked. H. -Original Message- From: Bryan Love [SMTP:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:50 AM To: CF-Talk Subject: RE: populate the damn array just move ad = StructNew(); inside the for loop and problem solved. The reason it's doing that is because you only declared structNew once. When you declare structNew it causes the variable (ad) to point to a memory address (let's use 0x1234 for this example). You then add this memory address to the array 36 times so you have an array where each item points to the exact same memory space. The last loop of the for loop sets the values in that memory space to the last item in the file and so it will appear that all the array items are the same (which they are) and they all point to the last item from the file. Put structNew inside the for loop and each iteration of the list will give ad a new memory pointer and each array item will be unique. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [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 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
My Shopping Cart is Broken :-(
I have this code that I've used to build several shopping carts ... now, on
a new site, just two days before launch ... it's not working right.
I've been pulling my hair out for five hours trying to figure what the hell
is going on.
I can add one item to the cart fine. I can add two items fine. But on the
third item, I suddenly start getting duplicate items in the cart, like up to
three copies of the last item added. I've never come across this problem
before with this code.
The code is below ... if anybody can see what the hell is going on, I would
certainly appreciate the help.
!--- first, find the details on the item being added to the cart ---
!--- select ---
cfquery name=FindItem
datasource=#DSN#
blockfactor=100
SELECT store.ITEM_ID,
store.ITEM_NAME,
store.DESCRIPTION,
store.PRICE,
store.CASE_PRICE,
store.IMAGE,
store.MERCHANTS_ID,
store.CASE_INVENTORY,
store.INVENTORY,
merchants.MERCHANTS_ID,
merchants.COMPANY_NAME
FROM store LEFT OUTER JOIN merchants
ON store.MERCHANTS_ID = merchants.MERCHANTS_ID
WHERE store.ITEM_ID = #URL.ITEM_ID#
/cfquery
!--- for the remove from cart to work, we need to
count the total number of items ---
cfset client.totalitems = 0
cfparam name=FORM.TOTAL_BOTTLES default=0
cfparam name=FORM.TOTAL_CASES default=0
!--- set a param to determine whether we're adding
to the cart for the first time or not ---
cfif IsDefined('client.cartItems')
cfset client.newcart=Yes
cfelse
cfset client.newcart=No
/cfif
!--- if this is not a new cart, let's add our first item ---
cfif client.newcart is NO
!--- script to add item to cart ---
CFSCRIPT
cart = ArrayNew(1);
item = StructNew();
item.ITEM_ID = #FindItem.ITEM_ID#;
item.ITEM_NAME = #FindItem.ITEM_NAME#;
item.DESCRIPTION = #FindItem.DESCRIPTION#;
item.MERCHANTS_ID = #FindItem.MERCHANTS_ID#;
item.COMPANY_NAME = #FindItem.COMPANY_NAME#;
item.ITEMTOTAL = 0;
if (attributes.action IS 'buy_bottle') {
item.PRICE = #FindItem.PRICE#;
item.BASE_PRICE = #FindItem.PRICE#;
item.CONTAINER = 'bottle';
item.QUANTITY = '1';
item.AVAILABLE = #FindItem.INVENTORY#;
}
else {
item.PRICE = #FindItem.CASE_PRICE#;
item.BASE_PRICE = #FindItem.CASE_PRICE#;
item.CONTAINER = 'caseof';
item.QUANTITY = '1';
item.AVAILABLE = #FindItem.CASE_INVENTORY#;
}
CartItems = ArrayAppend(cart, item);
client.newcart = 'Yes';
/CFSCRIPT
cfwddx action=CFML2WDDX
input=#cart#
output=client.cartItems
usetimezoneinfo=No
cfelse
cfwddx action=WDDX2CFML
input=#client.cartItems#
output=Cart
CFSCRIPT
// loop through the current cart to check for duplicates
for (x=1; x lte arrayLen(cart); x=x+1){
if (cart[x].item_id is FindItem.ITEM_ID) {
temp = 1;
}
else {
item = StructNew();
item.ITEM_ID = #FindItem.ITEM_ID#;
item.ITEM_NAME = #FindItem.ITEM_NAME#;
item.DESCRIPTION = #FindItem.DESCRIPTION#;
item.MERCHANTS_ID = #FindItem.MERCHANTS_ID#;
item.COMPANY_NAME = #FindItem.COMPANY_NAME#;
item.ITEMTOTAL = 0;
if (attributes.action IS 'buy_bottle') {
item.PRICE = #FindItem.PRICE#;
item.BASE_PRICE = #FindItem.PRICE#;
item.CONTAINER = 'bottle';
item.QUANTITY = '1';
item.AVAILABLE = #FindItem.INVENTORY#;
}
else {
item.PRICE = #FindItem.CASE_PRICE#;
item.BASE_PRICE = #FindItem.CASE_PRICE#;
item.CONTAINER = 'caseof';
item.QUANTITY = '1';
item.AVAILABLE = #FindItem.CASE_INVENTORY#;
}
CartItems = ArrayAppend(cart, item);
}
}
/CFSCRIPT
cfwddx action=CFML2WDDX
input=#cart#
output=client.cartItems
usetimezoneinfo=No
/cfif
!--- update the total items count for the remove code ---
cfset
RE: CF and PhotoShop
Jay: You could probably do what you want right now with ImageMagic and GhostScript. The only reason I'm looking at abandoning that environment is that I have seemingly hit an impossible error to solve. Your mileage may vary. But IM and GS, when they work right, are an incredible pair of image processing tools. And entirely compatible with CF. H. -Original Message- From: Jason Miller [SMTP:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 9:18 AM To: CF-Talk Subject: Re: CF and PhotoShop Yup - you nailed all the reasons below why I use image ready for batch. Although I have found batch processing in Macromedia MX to be just as fast and robust. Perhaps that is even a better option for the more possiblye likeli support of being able to use other Macr tools like coldfusion.. just another idea.. Actually - I hope the original poster -if he solves the issue responds back to the list with his findings.. my mind envisions me on a beach chair : while an image editing software is working it's but off ; with the thought of setting something like that up. I didn't even consider that route and am going the flash mx - load jpg to create certain graphical elements as flash which indeed could be handled as jpgs instead with some functionality loss - but I would love to test them together. good luck jay miller Adrocknaphobia Jones wrote: I agree. ImageReady isn't a Photoshop replacement, but I do use it for all batch processing with droplets and it works great. It has a lower over head than PS so running batches doesn't take up all your resources. Although I've never tried to use cfexecute to run droplets live on a server. Sounds like a good experiment. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 8:57 PM To: CF-Talk Subject: Re: CF and PhotoShop Don't know if it was answered - but that I know of droplet is an Adobe Image Ready term - same as macro or I think Macr MX is called a sriptlet etc etc. jay miller P.S. I was never impressed with ImageReady but it did have photoshopts basic image editing and much nicer batch processing - perhaps a possibility? - may allow for com - Owens, Howard wrote: Sorry for the ignorant question ... please define droplet H. -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [ SMTP:[EMAIL PROTECTED] mailto:SMTP:[EMAIL PROTECTED] ] Sent:Thursday, March 13, 2003 10:39 AM To: CF-Talk Subject: RE: CF and PhotoShop What if you created a droplet and used cfexecute to run the droplet? Can you create a droplet that will work on every file in a certain directory? The main thing that scares me about trying to script photoshop is loading and unloading it. Its a bulky program that can take forever to load. Maybe you could have it load automatically on startip. DM = -Original Message- From: Owens, Howard [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Thursday, 13 March 2003 8:35 AM To: CF-Talk Subject: CF and PhotoShop Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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
htmlArea
Somebody here recommend htmlArea ... I've been trying it out ... pretty nice for a free tool. http://www.interactivetools.com/products/htmlarea/ I've also used ActiveEdit. AE has some advantages, especially in the ability to easily upload photos, and you get the advantage of a supported product. But if you can't afford AE, htmlArea is a good alternative and is very easy to set up and use. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: disappearing client scope
That's what I'm doing ... passing client-scoped structs/arrays between
templates with WDDX.
Works fine thoughout the site ... and worked fine on this section until I
decided to use an image as the submit widget rather and a form submit button
... so I had to write some javascript to handle the submit, and I started
having trouble passing the variables ... again I'm successfully passing the
CFID/CFTOKEN as form vars.
H.
-Original Message-
From: Joe Eugene [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 7:52 PM
To: CF-Talk
Subject: RE: disappearing client scope
Submission is working fine, but on the other end is a WDDX tag that
expecting to read a Client.object
What do you have on the other end?
cfml2wddx/wddx2cfm convertion back and forth between client scope and
local vars?
client.cart
You cannot put complex(structure) variables in client scope UNLESS
you use wddx to serialize/deserialize, if thats the case you would
deserialize from client scope to variable/request scope.
Joe Eugene
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 9:52 PM
To: CF-Talk
Subject: disappearing client scope
Ok, my form submission goes through this little scrpt (on an on-click
event):
function updateSubmit(itemID,qNum) {
document.cartform.action = index.cfm;
document.cartform.method = post;
document.cartform.saction.value = update_cart;
document.cartform.CFID.value = #URL.CFID#;
document.cartform.CFTOKEN.value = #URL.CFTOKEN#;
document.cartform.ITEM_ID.value = itemID;
document.cartform.QUANTITY.value = qNum;
document.cartform.submit();
}
Submission is working fine, but on the other end is a WDDX tag that
expecting to read a Client.object, but I'm getting an error that the the
client.cart does not exist.
Now, I've seen client vars get dropped before when I haven't maintained
state (such as in a URLTOKEN), but as far as I can tell the CFID
and CFTOKEN
are getting passed. Here's what I'm seeing in my debug:
Form Fields:
CFID=1678
CFTOKEN=46234445
FIELDNAMES=SACTION,CFID,CFTOKEN,ITEM_ID,QUANTITY,ITEM_ID,QUANTITY
ITEM_ID=6,6
QUANTITY=1,1
SACTION=update_cart
So, where is my client var?
Why am I seeing this: Error resolving parameter CLIENT.CARTITEMS
H.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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: CF and PhotoShop
Sorry for the ignorant question ... please define droplet H. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 10:39 AM To: CF-Talk Subject: RE: CF and PhotoShop What if you created a droplet and used cfexecute to run the droplet? Can you create a droplet that will work on every file in a certain directory? The main thing that scares me about trying to script photoshop is loading and unloading it. Its a bulky program that can take forever to load. Maybe you could have it load automatically on startip. DM = -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 8:35 AM To: CF-Talk Subject: CF and PhotoShop Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: CF and PhotoShop
Here's your link: http://www.adobe.com/support/downloads/detail.jsp?ftpID=1536 There's also a few tools out there to turn JavaScipt into a desktop scripting tool. H. -Original Message- From: Adrocknaphobia Jones [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 10:13 AM To: CF-Talk Subject: RE: CF and PhotoShop What do you mean PS is scriptable with javaScript? Do you have any URLs about this? Are you trying to run batches client-side? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 7:58 PM To: CF-Talk Subject: RE: CF and PhotoShop We've hit a brick wall in dealing with IM on this particular server ... the problem isn't IM, it's GhostScript. It just refuses to run on this one machine. To answer the previous question -- I need to batch convert, automated like, PDFs to JPGs. Besides the previous problems with GS, PS is just much more stable in dealing with PDFs than GS. Since I sent my e-mail, I've learned that PS is scriptable with JavaScript on Win, so I'll be looking into that, I guess. Or the other option is switch the imaging processing to a Mac and use AppleScript. We're also looking into that. H. -Original Message- From: Buckland, Ramon [SMTP:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 4:34 PM To: CF-Talk Subject:RE: CF and PhotoShop Depending on what type of processing you want, you may find the solution in ImageMagick http://www.imagemagick.org/ There is abit of work done with ImageMagick and ColdFusion tags, just google for more info. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 8:35 AM To: CF-Talk Subject: CF and PhotoShop Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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 and PhotoShop
Also, don't really need to worry about load and unload ... PS will just stay on/open ... forever. H. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 10:39 AM To: CF-Talk Subject: RE: CF and PhotoShop What if you created a droplet and used cfexecute to run the droplet? Can you create a droplet that will work on every file in a certain directory? The main thing that scares me about trying to script photoshop is loading and unloading it. Its a bulky program that can take forever to load. Maybe you could have it load automatically on startip. DM = -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 8:35 AM To: CF-Talk Subject: CF and PhotoShop Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: CF and PhotoShop
Doesn't look like it handles PDFs :-( http://www.equilibrium.com/Internet/Equil/Products/DeBabelizer/Product+Tour/ File+Conversion.htm H. -Original Message- From: Joshua Miller [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 10:28 AM To: CF-Talk Subject: RE: CF and PhotoShop For image automation and conversion I'd look into Equilibrium Debabelizer Pro (http://www.equilibrium.com). This application has been around for years and it's always been a favorite of image manipulators everywhere. I'm sure it has scripting capabilities, it's designed to automate massive image conversion projects. Good luck! Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 1:13 PM To: CF-Talk Subject: RE: CF and PhotoShop What do you mean PS is scriptable with javaScript? Do you have any URLs about this? Are you trying to run batches client-side? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 7:58 PM To: CF-Talk Subject: RE: CF and PhotoShop We've hit a brick wall in dealing with IM on this particular server ... the problem isn't IM, it's GhostScript. It just refuses to run on this one machine. To answer the previous question -- I need to batch convert, automated like, PDFs to JPGs. Besides the previous problems with GS, PS is just much more stable in dealing with PDFs than GS. Since I sent my e-mail, I've learned that PS is scriptable with JavaScript on Win, so I'll be looking into that, I guess. Or the other option is switch the imaging processing to a Mac and use AppleScript. We're also looking into that. H. -Original Message- From: Buckland, Ramon [SMTP:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 4:34 PM To: CF-Talk Subject:RE: CF and PhotoShop Depending on what type of processing you want, you may find the solution in ImageMagick http://www.imagemagick.org/ There is abit of work done with ImageMagick and ColdFusion tags, just google for more info. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 8:35 AM To: CF-Talk Subject: CF and PhotoShop Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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
OT: Javascript -- why is this form submitting?
I found this pretty nice cc validation script out on the net ... but I had
to make some modifications to it.
I'm having a weird problem with it, however.
Here is the relevant function:
function validCCForm(ccTypeField,ccNumField)
{
var result =
isValidCreditCardNumber(ccNumField,ccTypeField.value,Credit Card
Number,true);
if (result == true){
return true;
}
else {
return false;
}
The final function of a rather complex script.
Now to my way of thinking, if it returns false, it means the script isn't
valid; in fact the proper alert pops up. But then the form submits anyway.
Now I thought if a return was false, the form wouldn't submit. But this
keeps submitting.
Here's the event handler:
onClick=validCCForm(this.form.ccType,this.form.ccNum);
If you need to see the whole script, let me know and I'll send it to you
directly.
H.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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: distinct count
Ah, this answer sounded so promising. Alas, it didn't do the trick. H. -Original Message- From: A.Little [SMTP:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 1:28 AM To: CF-Talk Subject: RE: distinct count You could try removing the a_items.END_TIME from your select and group by clauses to see if that does what you need, as if each of the values for a_items.END_TIME are different the query will create a row in the resultset for each value. Does that help? Alex -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 04:35 To: CF-Talk Subject: RE: distinct count Nope. That wasn't it. I removed the time stuff and it didn't change the results. Yet I can't see any real other difference between the queries. H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 8:09 PM To: CF-Talk Subject: RE: distinct count OK, I just realized something about this query ... I have a similar query for another part of the site that is exactly the same query, except their is no date comparison. That's why I'm not getting the results I expect (the other query works the way I expect), because since each entry has a diffferent SMALLDATETIME value, it counts as one ... now I've got to figure out a work around ... any suggestions? H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 2:01 PM To: CF-Talk Subject:SQL: distinct count The following query doesn't quite do what I want it to do, and I'm stumped on how to get what I want ... SELECT COUNT(a_items.WINE_TYPE_ID) AS WCOUNT, w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME FROM w_types, a_items WHERE w_types.TYPE_ID = a_items.TYPE_ID AND DATEDIFF( minute, #createODBCDATETIME(dateAdd(h, -3, NOW()))#, a_items.END_TIME) = 0 GROUP BY w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME ORDER BY TYPE What I need is something that returns: a_typeA (5) a_typeB (6) Where (n) is the number of that named type. What I'm getting is a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) Anybody have any pointers on how to get what I need? (speaking strictly of the query, of course). H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: distinct count
I take that back ... DOH! I was loading the revised query to the wrong directory. This change did work Thanks, Mr. Alex Little. H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:51 AM To: CF-Talk Subject: RE: distinct count Ah, this answer sounded so promising. Alas, it didn't do the trick. H. -Original Message- From: A.Little [SMTP:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 1:28 AM To: CF-Talk Subject:RE: distinct count You could try removing the a_items.END_TIME from your select and group by clauses to see if that does what you need, as if each of the values for a_items.END_TIME are different the query will create a row in the resultset for each value. Does that help? Alex -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 04:35 To: CF-Talk Subject: RE: distinct count Nope. That wasn't it. I removed the time stuff and it didn't change the results. Yet I can't see any real other difference between the queries. H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 8:09 PM To: CF-Talk Subject:RE: distinct count OK, I just realized something about this query ... I have a similar query for another part of the site that is exactly the same query, except their is no date comparison. That's why I'm not getting the results I expect (the other query works the way I expect), because since each entry has a diffferent SMALLDATETIME value, it counts as one ... now I've got to figure out a work around ... any suggestions? H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 2:01 PM To: CF-Talk Subject: SQL: distinct count The following query doesn't quite do what I want it to do, and I'm stumped on how to get what I want ... SELECT COUNT(a_items.WINE_TYPE_ID) AS WCOUNT, w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME FROM w_types, a_items WHERE w_types.TYPE_ID = a_items.TYPE_ID AND DATEDIFF( minute, #createODBCDATETIME(dateAdd(h, -3, NOW()))#, a_items.END_TIME) = 0 GROUP BY w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME ORDER BY TYPE What I need is something that returns: a_typeA (5) a_typeB (6) Where (n) is the number of that named type. What I'm getting is a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) Anybody have any pointers on how to get what I need? (speaking strictly of the query, of course). H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: cfapplication: really basic question
CFApplication doesn't have an end tag. Just put it at the top of your Application.cfm page, setting the attributes you want/need to set. Then on your Application.cfm page, set your global variables. You should scope your variables. I use the request scope ... cfset request.myDSN=datasource If you use the application scope (cfset application.myDSN=data), you need to lock your write and read of these variables (I'm not using CFMX yet, but I don't think you need to lock them in CFMX). (learn up on CFLOCK, if necessary). Last thing you need to know is that if you're setting a lot of global variables, it's best to use CFSCRIPT cfscript request.myDSN='datasource'; request.myEmail='[EMAIL PROTECTED]'; /cfscrpt H. -Original Message- From: Austin Govella [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 10:22 AM To: CF-Talk Subject: cfapplication: really basic question I'm setting app wide variables for DSNs in Application.cfm. My book says you set them after the CFAPPLICATION tag, but it doesn't say there's an end tag. I was worried the app might not know when varialbles stoppped being app variables... So, I have: cfapplication name=blah cfset dsn_course_catalog = db_course_catalog Is that all I need? It seems like you'd wanna close the CFAPPLICATION tag, but I can't find an example like that. Many thanks, -- Austin Govella Grafofini ~| 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
CF and PhotoShop
Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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 and PhotoShop
We've hit a brick wall in dealing with IM on this particular server ... the problem isn't IM, it's GhostScript. It just refuses to run on this one machine. To answer the previous question -- I need to batch convert, automated like, PDFs to JPGs. Besides the previous problems with GS, PS is just much more stable in dealing with PDFs than GS. Since I sent my e-mail, I've learned that PS is scriptable with JavaScript on Win, so I'll be looking into that, I guess. Or the other option is switch the imaging processing to a Mac and use AppleScript. We're also looking into that. H. -Original Message- From: Buckland, Ramon [SMTP:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 4:34 PM To: CF-Talk Subject: RE: CF and PhotoShop Depending on what type of processing you want, you may find the solution in ImageMagick http://www.imagemagick.org/ There is abit of work done with ImageMagick and ColdFusion tags, just google for more info. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 8:35 AM To: CF-Talk Subject: CF and PhotoShop Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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
OT: JavaScript form submit
OK, I've done this before ... copied previous used script ... but it's not
work ... maybe somebody will see something I'm not seeing.
Here's the function:
function updateSubmit(itemID) {
document.cartform.action = index.cfm;
document.cartform.saction.value = update;
document.cartform.CFID.value = #URL.CFID#;
document.cartform.CFTOKEN.value = #URL.CFTOKEN#;
document.cartform.I_ID.value = itemID;
document.cartform.submit();
}
Here's the opening form tag:
form name=cartform
Here's the image I want to click for form submission (I have multiple images
for submitting the same form, based on the desired action, so each image
needs to send its own form variable, just like a submit button would, but
I've discovered that doesn't work with image buttons on forms, so I'm trying
to fashion a workaround).
cfoutput
a href=## onclick=updateSubmit('#itemIDList#');img
src=update_85x22.gif alt= border=0/a
/cfoutput
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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: JavaScript form submit -- SOLVED
Well, besides not telling you what the error message was (oops), I realized
after I sent this e-mail that I was missing the necessary hidden form fields
with this particular form.
H.
-Original Message-
From: Owens, Howard [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 5:22 PM
To: CF-Talk
Subject: OT: JavaScript form submit
OK, I've done this before ... copied previous used script ... but it's not
work ... maybe somebody will see something I'm not seeing.
Here's the function:
function updateSubmit(itemID) {
document.cartform.action = index.cfm;
document.cartform.saction.value = update;
document.cartform.CFID.value = #URL.CFID#;
document.cartform.CFTOKEN.value = #URL.CFTOKEN#;
document.cartform.I_ID.value = itemID;
document.cartform.submit();
}
Here's the opening form tag:
form name=cartform
Here's the image I want to click for form submission (I have multiple
images
for submitting the same form, based on the desired action, so each image
needs to send its own form variable, just like a submit button would, but
I've discovered that doesn't work with image buttons on forms, so I'm
trying
to fashion a workaround).
cfoutput
a href=## onclick=updateSubmit('#itemIDList#');img
src=update_85x22.gif alt= border=0/a
/cfoutput
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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
ListAppend not Appending
I hate shit like this ... how many times have I used ListAppend? But I just can't see why this isn't appending ... each new value is simply overwriting the first value cfloop index=ThisOrder from=1 to=#ArrayLen(cart)# cfset itemIDList= cfset itemIDList=#ListAppend(itemIDList, #cart[ThisOrder].ITEM_ID#)# cfoutputlist: #itemIDList#/cfoutput cfoutput ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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
disappearing client scope
Ok, my form submission goes through this little scrpt (on an on-click
event):
function updateSubmit(itemID,qNum) {
document.cartform.action = index.cfm;
document.cartform.method = post;
document.cartform.saction.value = update_cart;
document.cartform.CFID.value = #URL.CFID#;
document.cartform.CFTOKEN.value = #URL.CFTOKEN#;
document.cartform.ITEM_ID.value = itemID;
document.cartform.QUANTITY.value = qNum;
document.cartform.submit();
}
Submission is working fine, but on the other end is a WDDX tag that
expecting to read a Client.object, but I'm getting an error that the the
client.cart does not exist.
Now, I've seen client vars get dropped before when I haven't maintained
state (such as in a URLTOKEN), but as far as I can tell the CFID and CFTOKEN
are getting passed. Here's what I'm seeing in my debug:
Form Fields:
CFID=1678
CFTOKEN=46234445
FIELDNAMES=SACTION,CFID,CFTOKEN,ITEM_ID,QUANTITY,ITEM_ID,QUANTITY
ITEM_ID=6,6
QUANTITY=1,1
SACTION=update_cart
So, where is my client var?
Why am I seeing this: Error resolving parameter CLIENT.CARTITEMS
H.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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
SQL: distinct count
The following query doesn't quite do what I want it to do, and I'm stumped on how to get what I want ... SELECT COUNT(a_items.WINE_TYPE_ID) AS WCOUNT, w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME FROM w_types, a_items WHERE w_types.TYPE_ID = a_items.TYPE_ID AND DATEDIFF( minute, #createODBCDATETIME(dateAdd(h, -3, NOW()))#, a_items.END_TIME) = 0 GROUP BY w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME ORDER BY TYPE What I need is something that returns: a_typeA (5) a_typeB (6) Where (n) is the number of that named type. What I'm getting is a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) Anybody have any pointers on how to get what I need? (speaking strictly of the query, of course). H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: distinct count
Ben wrote: Remember -- it's generally a bad idea to run a query selecting real data and aggregates (like count) at the same time. Then how do I get both the aggregate info and the other query columns I need for the same output? H. -Original Message- From: Ben Doom [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 2:22 PM To: CF-Talk Subject: RE: distinct count I think you've overcomplicated the query. IIRC, it should look something like: select count(a_items.wine_type_id) as wcount where [whatever] group by a_items.wine_type_id order by [whatever] Remember -- it's generally a bad idea to run a query selecting real data and aggregates (like count) at the same time. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Owens, Howard [mailto:[EMAIL PROTECTED] : Sent: Tuesday, March 11, 2003 5:01 PM : To: CF-Talk : Subject: SQL: distinct count : : : The following query doesn't quite do what I want it to do, and I'm stumped : on how to get what I want ... : : SELECT COUNT(a_items.WINE_TYPE_ID) AS WCOUNT, : w_types.TYPE_ID, : w_types.TYPE, : a_items.TYPE_ID, : a_items.END_TIME : FROM w_types, a_items : WHERE w_types.TYPE_ID = a_items.TYPE_ID : AND DATEDIFF( minute, #createODBCDATETIME(dateAdd(h, -3, NOW()))#, : a_items.END_TIME) = 0 : GROUP BY w_types.TYPE_ID, : w_types.TYPE, : a_items.TYPE_ID, : a_items.END_TIME : ORDER BY TYPE : : What I need is something that returns: : : a_typeA (5) : a_typeB (6) : : Where (n) is the number of that named type. : : What I'm getting is : : a_typeA (1) : a_typeA (1) : a_typeA (1) : a_typeA (1) : a_typeA (1) : a_typeA (1) : : Anybody have any pointers on how to get what I need? (speaking strictly of : the query, of course). : : H. : ~| 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: Auto-populating form item
Another suggestion ... Store your queries in WDDX packages ... deserialize to JavaScript. There's an example on how to do this on my advanced Forta book ... which is two editions old ... not sure if it's carried forward ... but if you know JS at all, it's not really difficult to figure out once you have the examples. H. -Original Message- From: Lincoln Milner [SMTP:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 7:31 AM To: CF-Talk Subject: Auto-populating form item Folks, We've got this data entry form that allows entry, query, record deletion, and a host of other functionality. One thing it needs to do is after the first three form items are completed (it's a subject id.t number), the fourth auto-populates with the subject initials. This should be seamless to the user, i.e., no refresh of the page or submitting of data, so my question is how can we take form items 1, 2, and 3 and use them to dynamically call a query to retrieve the initials from a database? Or is this beyond the scope of CF? Cheers! Lincoln T. Milner Senior Application Programmer/Analyst Department of Health Evaluation Sciences Pennsylvania State University 600 Centerview Drive Suite 2200, A210 Hershey, PA 17033-0855 Ph: 717.531.7178 Fax: 717.531.5779 [EMAIL PROTECTED] *E-Mail Confidentiality Notice* This message (including any attachments) contains information intended for a specific individual(s) and purpose that may be privileged, confidential or otherwise protected from disclosure pursuant to applicable law. Any inappropriate use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalty. If you have received this transmission in error, please reply to the sender indicating this error and delete the transmission from your system immediately. ~| 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: distinct count
OK, I just realized something about this query ... I have a similar query for another part of the site that is exactly the same query, except their is no date comparison. That's why I'm not getting the results I expect (the other query works the way I expect), because since each entry has a diffferent SMALLDATETIME value, it counts as one ... now I've got to figure out a work around ... any suggestions? H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 2:01 PM To: CF-Talk Subject: SQL: distinct count The following query doesn't quite do what I want it to do, and I'm stumped on how to get what I want ... SELECT COUNT(a_items.WINE_TYPE_ID) AS WCOUNT, w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME FROM w_types, a_items WHERE w_types.TYPE_ID = a_items.TYPE_ID AND DATEDIFF( minute, #createODBCDATETIME(dateAdd(h, -3, NOW()))#, a_items.END_TIME) = 0 GROUP BY w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME ORDER BY TYPE What I need is something that returns: a_typeA (5) a_typeB (6) Where (n) is the number of that named type. What I'm getting is a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) Anybody have any pointers on how to get what I need? (speaking strictly of the query, of course). H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: distinct count
Nope. That wasn't it. I removed the time stuff and it didn't change the results. Yet I can't see any real other difference between the queries. H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 8:09 PM To: CF-Talk Subject: RE: distinct count OK, I just realized something about this query ... I have a similar query for another part of the site that is exactly the same query, except their is no date comparison. That's why I'm not getting the results I expect (the other query works the way I expect), because since each entry has a diffferent SMALLDATETIME value, it counts as one ... now I've got to figure out a work around ... any suggestions? H. -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 2:01 PM To: CF-Talk Subject:SQL: distinct count The following query doesn't quite do what I want it to do, and I'm stumped on how to get what I want ... SELECT COUNT(a_items.WINE_TYPE_ID) AS WCOUNT, w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME FROM w_types, a_items WHERE w_types.TYPE_ID = a_items.TYPE_ID AND DATEDIFF( minute, #createODBCDATETIME(dateAdd(h, -3, NOW()))#, a_items.END_TIME) = 0 GROUP BY w_types.TYPE_ID, w_types.TYPE, a_items.TYPE_ID, a_items.END_TIME ORDER BY TYPE What I need is something that returns: a_typeA (5) a_typeB (6) Where (n) is the number of that named type. What I'm getting is a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) a_typeA (1) Anybody have any pointers on how to get what I need? (speaking strictly of the query, of course). H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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
OpenForums coders
Anybody here familiar with OpenForums, the open source discussion forums program ... I've got some questions and not getting any help from the so-called support forum for it (it's down) and not getting answers to my e-mail questions. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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
OT I need a list of all usa states
Anybody have a text file (no mark up) of all the US states? ... two letter abbrivation and full state name spelled out, tabbed or CSV ... just want to import into a table. If so, e-mail to [EMAIL PROTECTED] H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: blue dragon and coolfusion iMS
I mean a CF-Talk type of mailing list ... a discussion list. H. -Original Message- From: Pete Freitag [SMTP:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:46 AM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Yes with ActivMail you can use a ColdFusion query to supply the email addresses, or a list. You can also personalize the content in the message using the query columns. Is that what you mean by Does it handle mailing lists? _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 7:30 PM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Does it handle mailing lists? H. -Original Message- From: Pete Freitag [SMTP:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:37 PM To: CF-Talk Subject:RE: blue dragon and coolfusion iMS Is anybody running iMS on a Blue Dragon server? How's the performance? Do they work well and play well together? Have they been tested together? If you need a high end email solution for Blue Dragon ActivMail works great on it. It's written in Java, so it should work on all but the free versions of BD. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.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
recurrence engine
Thanks to all who helped figure some of this stuff out.
FWIW: Here's the calendar recurrence engine I built:
cfscript
// events may or may not have an end_date
if (Len(form.day_end)) {
end_date = #form.month_end#/#form.day_end#/#form.year_end#; }
else {
end_date = 'NULL';
}
// run through case statements for which kind of recurrance this is
switch (#form.RECURRENCE_TYPE#) {
// if onetime date entry, create a single element array
case OneTime: {
mydate = ArrayNew(1);
mydate[1] = #form.month#/#form.day#/#form.year#;
// get the final date of the array
finalDate=myDate[arrayLen(myDate)];
break;
}
case Daily: {
calDays = 365;
interval = form.TIME_INTERVAL_daily;
numEvents = calDays \ interval;
myDate = ArrayNew(1);
myDate[1] = #form.month#/#form.day#/#form.year#;
for(i=1; i LTE numEvents; i=i+1) {
arrayAppend(myDate, dateAdd('d', i *
interval,myDate[1]));
}
// get the final date of the array
finalDate=myDate[arrayLen(myDate)];
break;
}
case Weekly: {
calDays = 365;
interval = form.TIME_INTERVAL_weekly;
numEvents = calDays \ interval;
numEvents = numEvents \ 7;
myDate = ArrayNew(1);
myDate[1] = #form.month#/#form.day#/#form.year#;
for(i=1; i LTE numEvents; i=i+1) {
arrayAppend(myDate, dateAdd('d', (i * 7) *
interval,myDate[1]));
}
// get the final date of the array
finalDate=myDate[arrayLen(myDate)];
break;
}
case Monthly: {
// calculate month recurrence
// udf can be found here: http://www.cflib.org/udf.cfm?ID=179
// udf modified to loop over 12 months past a change of year ...
calMonths = 12;
interval = form.TIME_INTERVAL_monthly;
numEvents = calMonths \ interval;
firstDate =
DayOfWeek('#form.month#/#form.day#/#form.year#');
/* check to see if pattern is specific date of each month,
* or Nth occurance of each day of the month */
if (form.PATTERN is specificdate){
// create array and seed with first date
myDate = ArrayNew(1);
myDate[1] = '#form.month#/#form.day#/#form.year#';
// loop over number of events for the year and create
date-specific array
for(i=1; i LTE numEvents; i=i+1) {
arrayAppend(myDate, dateAdd('m', i *
interval,myDate[1]));
}
}
Else {
// or use UDF to get the Nth day of the month for each month
for a year out
startDate = GetNthOccOfDayInMonth(form.EVERY_N, firstDate,
form.Month, form.Year);
// create array and seed with first date
myDate = ArrayNew(1);
myDate[1] = #form.month#/#startDate#/#form.year#;
/* loop over UDF
* new month is each new month integer for 12 months through
the loop
* calcMonth contains the incremental integer so we can loop
over
* 12 months and recognize that we're dealing with a new
year
* when that happens, we calculate what month starting in
Jan. we're dealing with
*/
for(i=1; i LTE 12; i=i+1) {
newMonth=form.Month+i;
calcMonth=form.Month+i;
if (calcMonth GTE 13) {
useYear=form.Year+1;
newMonth=i-(12-form.month); }
else {useYear=form.Year;}
newDate =
GetNthOccOfDayInMonth(form.EVERY_N, firstDate, newMonth, useYear);
arrayAppend(myDate,
'#newMonth#/#newDate#/#useYear#');
}
}
// get the final date of the array
finalDate=myDate[arrayLen(myDate)];
break;
}
case Yearly: {
break;
}
default: {
break;
}
}
/cfscript
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
RE: Is it possible to achieve workflow in Coldfusion ???
You might want to think about whether there is a required publication date. For example, if a story is entered, but is embargoed until next week, you might want to store that publication date and it won't show up on the site until that date arrives. H. -Original Message- From: Ian Vaughan [SMTP:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:54 AM To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Andre Thanks for the explanation!! Ok I understand how it is working - A user fills in the fields and clicks submit the data in entered into the db with a 'status' field set to a default of 'Pending' Ok Then when the form is submitted I use CFMail to send an e-mail to the approver informing them they have a story to approve. (Is this process correct ?) The approver clicks on the link in the e-mail and they are taken to the 'Pending Jobs' Screen. The approver opens the relevant pending job. At the bottom of this page there are two buttons 'Approve' and 'Decline' If the aprrover clicks approve the 'status' field changes to 'approve' However if the approver clicks decline then the 'status' field stays the same and an e-mail is sent back to the content owner informing them that the content has been declined. Does this make sense logically ?? Or would you add more features and or more advanced settings?? - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:24 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, Perhaps I can clarify/expand on what Adam suggested: 1) You do not stop the data entering the database when a story is submitted. Instead, it is inserted as normal but you also set another column probably in the same table, perhaps named status with a value of P for pending when you perform the insert e.g. insert into stories (story_id, foo, bar, status) values (666,'Foo','Bar','P') 2) Only display stories on the website if the status column is not P, perhaps only if the status column is A for approved e.g. select foo, bar from stories where status = 'A' 3) When the approver approves a story to be published, the appropriate row in the database gets updated and the status column is changed appropriately. e.g. update stories set status = 'A' where story_id = 666 You could extend this model quite simply to allow for multi-level approvals and multiple types of status. It's important to note that this is not a ColdFusion specific problem. It is merely a programming issue and there is more than one way to skin a cat. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who
RE: anybody ever done: every n day of the month for a year ...
Doh! H. -Original Message- From: Cameron Childress [SMTP:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 11:28 AM To: CF-Talk Subject: RE: anybody ever done: every n day of the month for a year ... Always check CFLib first... http://www.cflib.org/udf.cfm?ID=179 -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [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 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: anybody ever done: every n day of the month for a year ...
That's why I come to the list and value the list ... great place to learn stuff. Just wish this time I had learned a little faster :-) H. -Original Message- From: Adam Cantrell [SMTP:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 5:20 PM To: CF-Talk Subject: anybody ever done: every n day of the month for a year ... At least you and I learned something. What was I thinking with the dateAdd+4weeks thing, I've built calendars before and should know better ;) surry bout that. 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: anybody ever done: every n day of the month for a year ...
Oops, found a problem with this UDF ... It give you the option of feeding in a 5 for the Nth recurrence, which 5, as I take it, should equal 'last' ... meaning, say, the Last Friday of the month. Some months that will be the 5th Friday, some months the 4th. So for November, for example, the UDF returns -1 instead of the 28th. H. -Original Message- From: Cameron Childress [SMTP:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 11:28 AM To: CF-Talk Subject: RE: anybody ever done: every n day of the month for a year ... Always check CFLib first... http://www.cflib.org/udf.cfm?ID=179 -Cameron ~| 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: anybody ever done: every n day of the month for a year ...
Here, I changed this:
//If the result is greater than days in month or less than 1, return -1
if(TheDayInMonth gt DaysInMonth(CreateDate(TheYear,TheMonth,1)) OR
TheDayInMonth lt 1){
return -1;
}
else{
return TheDayInMonth;
to this:
//If the result is greater than days in month or less than 1, return -1
if(TheDayInMonth gt DaysInMonth(CreateDate(TheYear,TheMonth,1)) OR
TheDayInMonth lt 1){
return TheDayInMonth - 7;
}
else{
return TheDayInMonth;
So far, seems to fix it.
H.
-Original Message-
From: Owens, Howard [SMTP:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 6:50 PM
To: CF-Talk
Subject: RE: anybody ever done: every n day of the month for a year
...
Oops, found a problem with this UDF ...
It give you the option of feeding in a 5 for the Nth recurrence, which 5,
as
I take it, should equal 'last' ... meaning, say, the Last Friday of the
month. Some months that will be the 5th Friday, some months the 4th.
So for November, for example, the UDF returns -1 instead of the 28th.
H.
-Original Message-
From: Cameron Childress [SMTP:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 11:28 AM
To: CF-Talk
Subject:RE: anybody ever done: every n day of the month for a year
...
Always check CFLib first...
http://www.cflib.org/udf.cfm?ID=179
-Cameron
~|
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: blue dragon and coolfusion iMS
Any ETA on the next release? I'm sort of in a hurry :-) H. -Original Message- From: Howie Hamlin [SMTP:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 8:27 AM To: CF-Talk Subject: Re: blue dragon and coolfusion iMS We are actually going to be focusing on getting iMS to work with Blue Dragon (it's on our short list and should be in the next iMS release). The two are not currently compatible. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 27, 2003 9:05 PM Subject: blue dragon and coolfusion iMS Is anybody running iMS on a Blue Dragon server? How's the performance? Do they work well and play well together? Have they been tested together? Also, I'm thinking about investing in a small server and putting Blue Dragon and iMS on it. If anybody wants to lease some server space for (a) low-impact site(s), drop me a private line and if it comes together, I'll let you know. I'm still negotiating with my host, so I don't know what my expenses will be yet, so I can't quote a price, but it would help defray my costs if I can rent out some space. MSSQL server available. I'll have four or five web sites on it and three e-mail discussion lists running throuhg iMS. No redundancy, so this isn't for mission critical hosting, though I think the hosting facility provides backups, and I know (or so I'm told) the SQL server is backed up. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: calculating date recurrence
Matthew, thanks ... I modified what you showed me to the code below, and it
works perfectly.
cfscript
calDays = 365;
interval = form.TIME_INTERVAL;
numEvents = calDays \ interval;
variables.myDate = ArrayNew(1);
variables.myDate[1] = #form.month#/#form.day#/#form.year#;
for(i=1; i LTE numEvents; i=i+1) {
arrayAppend(variables.myDate, dateAdd('d', i *
interval, variables.myDate[1]));
}
variables.recurrence_type = Daily;
/cfscript
-Original Message-
From: Matthew Walker [SMTP:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 5:53 PM
To: CF-Talk
Subject: RE: calculating date recurrence
What are you trying to do? Create an array of dates for your recurring
event? How about this...?
cfset showEventsnDaysInAdvance = 365
cfset interval = 7
cfset numberOfEventsToShow = showEventsnDaysInAdvance \ interval
cfset myDates = arrayNew(1)
cfloop from=1 to=#numberOfEventsToShow# index=i
cfset arrayAppend(myDates, dateAdd(d, i * interval, now()))
/cfloop
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Friday, 28 February 2003 1:36 p.m.
To: CF-Talk
Subject: calculating date recurrence
OK, I'm working on building my own calendar application.
I'm trying to come up with a way of dealing with recurrence.
The first step is to calculate -- event occures every n days apart, i.e.,
event occures every 3 days.
Here's one way I've tried so far (but this is like chewing up all the
processor time)
variables.date = ArrayNew(1);
variables.date[1] = #form.month#/#form.day#/#form.year#;
for(i=1; i LTE 30; i=i+1) {
x=1;
while (i mod form.TIME_INTERVAL){
variables.date[x] = DateAdd(d, (form.TIME_INTERVAL-1)+x,
variables.date[1]);
x=x+1;
}
}
Something else I tried, but it creates too many empty array elements:
variables.date = ArrayNew(1);
variables.date[1] = #form.month#/#form.day#/#form.year#;
for(i=1; i LTE 30; i=i+1) {
if (i mod TIME_INTERVAL){
}
else {
variables.date[i] = DateAdd(d,
(TIME_INTERVAL-1)+i, variables.date[1]);
}
}
I'm open to suggestions.
H.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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
anybody ever done: every n day of the month for a year ...
Just to save me spending too much time trying to figure this out ... Anybody already have a code snippet for calculating every N day of the Month, for a year ... Such as, Every 3rd Tuesday of the month? That's where I'm at on building my little recurrance engine. I'll spit the whole code back out the list when it's done, if anybody wants it. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: anybody ever done: every n day of the month for a year ...
Are you speaking of the RFC? What page? If not, what then and where? H. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 3:33 PM To: CF-Talk Subject: Re: anybody ever done: every n day of the month for a year ... Howard, why reinvent the wheel? the ical format specifies all this and more WG Quoting Owens, Howard [EMAIL PROTECTED]: Just to save me spending too much time trying to figure this out ... Anybody already have a code snippet for calculating every N day of the Month, for a year ... Such as, Every 3rd Tuesday of the month? That's where I'm at on building my little recurrance engine. I'll spit the whole code back out the list when it's done, if anybody wants it. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: anybody ever done: every n day of the month for a year ...
Adam:
I had trouble getting this to work with a while loop, so I used a for loop,
and what I wind up with is the date of every 4 weeks apart ... if there's a
five week month, things get thrown off ...
cfscript
variables.myDate = ArrayNew(1);
variables.myDate[1] = 2/28/03;
for (i=1; i LTE 12; i=i+1){
arrayAppend(variables.myDate, DateAdd(ww, 4,
variables.myDate[i]));
writeoutput('date:');
writeoutput(variables.myDate[i]);
writeoutput(br);
}
/cfscript
H.
-Original Message-
From: Cantrell, Adam [SMTP:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:37 PM
To: CF-Talk
Subject: RE: anybody ever done: every n day of the month for a year
...
There may be more efficient means, but if you can supply the initial seed
date - this would work:
DateAdd(ww, 4, seedDate)
You would want to put that in a while loop, (while the year remains the
same
as your seed date, add this date to my list).
Adam.
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 5:22 PM
To: CF-Talk
Subject: anybody ever done: every n day of the month for a year ...
Just to save me spending too much time trying to figure this out ...
Anybody already have a code snippet for calculating every N day of the
Month, for a year ...
Such as, Every 3rd Tuesday of the month?
That's where I'm at on building my little recurrance engine.
I'll spit the
whole code back out the list when it's done, if anybody wants it.
H.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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
