RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Pascal Peters
cfscript
stTmp =
REFind([*]{3}[[:space:]]+([^*]+)[[:space:]]+[*]{3},str,1,true);
info = Mid(str,stTmp.pos[2],stTmp.len(2);
/cfscript
cfoutputspan class=time#info#/span/cfoutput 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: vrijdag 14 mei 2004 17:07
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Pascal or anybody who can help!
 
 I'm in a similar problem again and need your help. I'm 
 currently using the code provided by Pascal. The solution to 
 which is mentioned above.
 
 I am pulling the data from the 'comments' column in a 
 database table. The data in the comments column looks like this. 
 
 *** User1 10/28/2003 2:53:52 *** 
 
 THIS IS A TEST
 
 *** User 2 04/06/200313:41:47 *** 
 
 blah, blah
 
 I want to read everything that's between the *** ie *** User 
 1 10/28/2003 2:53:52 *** and display it like this:
 span class=timeUser 1 | 14/4/2004 15:58:15/span THIS IS A TEST
 
 Can somebody please show me how to do this using regular expressions?
 Many thanks
 cf coder
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFmail and Spam

2004-05-17 Thread Adam Reynolds
Hi,
Hotmail keeps marking emails sent by the server as junk mail. These mails
are sent out to players in a game to tell them to take their turn.

Is there anything that can be done to make it look like the mail came from
say Outlook?

Adam
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
Hey Pascal, hope you're doing well buddy! I'm getting an error.

The selected method len was not found.
Either there are no methods with the specified method name and argument types, or the method len is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity.

Any idea why?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: How to secure email with CFMAIL

2004-05-17 Thread Rick Root
Brant Winter wrote:
 Hi - Maybe I should be addressing this question to the CF-Newbies list, but
 I will try here anyway!
 
 I need to create a form to submit patient data to another health company be
 email. I was thinking I could easily write the app in CF to do this, but I
 want to secure the actual email with a digital cert. Can this be done ???

In my experience, the only good way to send encrypted email is to use 
PGP or GnuPG ... the client who reads the mail uses PGP or GnuPG to 
generate a public/private key, then you use CFEXECUTE on the server to 
encrypt the email text with PGP or GnuPG using the public key before 
sending it.Then the email can only be read when decrypted with the 
private key.

This is not a user friendly method though.

An alternative would be store the data in the database, and simply email 
the user a link to the data that they can view over an SSL connection 
after entering their username and password.

- Rick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfmx admin question

2004-05-17 Thread Whittingham, P
yes (cfstart) , but i think it produce some errors...how does one interprete them.

 
Pat

-Original Message-
From: Jim Louis [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 15, 2004 7:56 PM
To: CF-Talk
Subject: Re: cfmx admin question

DO you have a web server running on your system?

JIm Louis

 Hi All,

 

 After I install the cfmx dev copy on my win98 (yes, it is an old PC), 
 I try to goto cfadmin with no success. I get a 'page can't be 
 displayed'. I do have
 cfstart.bat running. 
 Is there some xml file which I need to change. I did this before, but 
 no success today.

 
 TIA,
 Patrick Whittingham

 
 
 
 
 

 _
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
I figured that out.. thanks

cfscript 
stTmp = REFind([*]{3}[[:space:]]+([^*]+)[[:space:]]+[*]{3},str,1,true); 
info = Mid(str,stTmp.pos[2],stTmp.len[2]); 
/cfscript 
span class=timestamp#info#/span

the above code works however I was wondering if you could do me another favour. At the minute you are searching for the ***. Would it be possible to come up with a pattern that finds the three stars, username, date and time?

ex: *** User1 10/28/2003 2:53:52 *** 

Its just so its fool proof. My concern is if the column contains three stars somewhere else in the comments then this code would fail. Are you with me?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need to have a javascript that selectively validates

2004-05-17 Thread Whittingham, P
Jim,

 
i presume session1 is a field name within your form and you want the validation at on submit eventremember _javascript_ is a case-sensitive language
unlike CF.
 The _javascript_ Bible, by Dan Goodman is an excellent book

 Pat

 
script
!--

 
function valid() {

 
if (document.forms[0].session.value == 'yes' ) 
(document.forms[0].field2.value != '' or document.forms[0].field3.value != '') {
alert(field 2 and field3 are required);
return false;
}

 
return true; 
}

 
/script

 
form name=x  valid();  
..
/form

-Original Message-
From: Jim Louis [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 15, 2004 7:55 PM
To: CF-Talk
Subject: OT: Need to have a _javascript_ that selectively validates

I have a web form that I need _javascript_ validation for if 
Session1 is yes then field2 and field3 are required.
If session 1 is no then field 2 and field3 are not required. 

Can someone point me in the right direction.I want to use javascipt because the rest of the form validation is using it.

Jim Louis 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
sorry for being such a pest... I forgot to add in my earlier post that the timestamp for all existing comments is in the format:

 *** 10/28/2003 2:53:52 User1 *** 

and the timestamp for new comments is:

 *** User1 10/28/2003 2:53:52 *** 

Can you also show me how to display all existing timestamps in the above format

Many many thanks in advance.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Pascal Peters
cfscript
stTmp =
REFind([*]{3}([^*]+)([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space:]]+([0-9]{
1,2}:[0-9]{1,2}:[0-9]{1,2})([^*]+)[*]{3},str,1,true);
user1 = Mid(str,stTmp.pos[2],stTmp.len[2]);
date = Mid(str,stTmp.pos[3],stTmp.len[3]);
time = Mid(str,stTmp.pos[4],stTmp.len[4]);
user2 = Mid(str,stTmp.pos[5],stTmp.len[5]);
if(len(trim(user1))) user = trim(user1);
else if(len(trim(user2))) user = trim(user2);
else user = ;
/cfscript
span class=timestamp#user# #date# #time#/span

It's not full proof, but it should work. 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 13:11
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 sorry for being such a pest... I forgot to add in my earlier 
 post that the timestamp for all existing comments is in the format:
 
*** 10/28/2003 2:53:52 User1 *** 
 
 and the timestamp for new comments is:
 
*** User1 10/28/2003 2:53:52 *** 
 
 Can you also show me how to display all existing timestamps 
 in the above format
 
 Many many thanks in advance.
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: The never-ending windows

2004-05-17 Thread Hagan, Ryan Mr (Contractor ACI)
How about doing something like this:

 
MAIN Window
 tons of stuff
 event trigger:
pop2();

pop2 data loader
 msgWin = window.open( 'pop1.htm', 'msg', '' );
 msgWin.focus();

 
 do tons of stuff;

 
 msgWin.close();
 self.close();

pop1 message 
 document.write('Please wait, loading...');

-Original Message-
From: Chunshen Li [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 12:36 AM
To: CF-Talk
Subject: The never-ending windows

Hello,

I've spent at least one hour on figuring out how to work out this oo
thing.Here's the scoop, I have one Main window, which contain form and
elements, upon certain action, triggers a popup window, which does two
things of 1) query a database to pull certain data out; 2) write the data to
(populate) the Main window, then, close itself.

However, since, query/data retrieval and population may take a while, so,
I'd like to add msg like, Please wait ... upon loading, and yet, it causes
double buffer, the single popup window won't do, which leaves me with no
choice but to add another little named popup window to say Please wait
These two popup windows are loaded in the sequence of pop msg and pop
data loader.Problem, pop data loader, closes itself upon job completion,
fine, but the pop msg window won't close.

Here's the relevant code:

MAIN Window
tons of stuff
event trigger:
pop1();
pop2();

pop1 about msg
msgWin = (window.open('pop1.htm','msg','');
msgWin.focus();

pop2 about data loader
do tons of stuff;
// close pop1 window
msgWin.close();
// also tried, msg.close() to no avail
self.close();

TIA 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
thanks Pascal! It doesn't quite work how I would like it to.

EX: *** 08/12/200320:33:31EDWARI31 ***

You code displays the above timestamp like this:

0 8/12/2003 20:33:31

Where as I would like it to be displayed like this:

EDWARI31 08/12/2003 20:33:31

I dumped stTmp cfdump var=#stTmp#. This is what it returns

struct 
LEN 
array
1 38
2 2
3 9
4 8
5 11

 
POS 
array
1 1
2 4
3 6
4 17
5 25
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
Pascal, sorry again for being such a PEST. I really do apprecaite your help.

There can be more than one occurance of the timestamp in the comment column. Ex:

*** 05/12/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

 *** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.

 *** 04/12/200318:13:22USER3 ***
Roger that

 *** 04/12/200318:05:01USER4 ***
closed

Can you please add code in your script to handle this and display all timestamps correctly

Many thanks again
cfcoder



thanks Pascal! It doesn't quite work how I would like it to.

EX: *** 08/12/200320:33:31EDWARI31 ***

You code displays the above timestamp like this:

0 8/12/2003 20:33:31

Where as I would like it to be displayed like this:

EDWARI31 08/12/2003 20:33:31

I dumped stTmp cfdump var=#stTmp#. This is what it returns

struct 
LEN 
array
1 38
2 2
3 9
4 8
5 11
 
POS 
array
1 1
2 4
3 6
4 17
5 25
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: FW: How do you concatanate two table fields in CFQUERY with MS Access

2004-05-17 Thread Doug James
The first thing I see is you need a comma after 'tblJobSeekers.jsphone1'.

Doug

Angel Stewart wrote:

Well Sandy...I tried that initially but it just didn't work.
So I thought I was doing something totally wrong and that Access SQL
uses something beside the +.

But! Good news!

I tried that code in an SQL Statement with nothing else but 

Select atfname + ' ' + atlname AS Agentname
FROM tblagent

And it worked fine.

So there must be something else in the syntax of 

SELECT tblusers.username, tblJobSeekers.jsfname,
tblJobSeekers.jslname,tblJobSeekers.jsemail, tblJobSeekers.jscountry,
tblJobSeekers.pverify,tblJobSeekers.jsphone1 
[atfname] +   + [atlname] AS AgentName
FROM tblAgent INNER JOIN (tblusers INNER JOIN tblJobSeekers ON
tblusers.userid = tblJobSeekers.userid) ON tblAgent.atid =
tblJobSeekers.agentid
ORDER BY tblJobSeekers.jslname;

That's causing it to fail. *sigh*
I hate syntax errors.
And I don't understand why the MSACcess SQL string failed to work. 
Could someone explain that?

Thanks for the help :)
-Gel


-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED] 
Sent: Saturday, May 15, 2004 3:01 AM
To: CF-Talk
Subject: CF-Talk: Digest every 2 hours

Subject: How do you concatanate two table fields in CFQUERY with MS
Access 
From: Sandy Clark 

Date: Fri, 14 May 2004 22:18:07 -0400
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid
=32529forumid=4#163293

Sql uses +
 is the CF concatenation.
 
Silly gel. 
_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Don
Thanks, Ryan, to me, your suggestion is 100% logical, and I tried that before except I used plain HTML without js for the msgWin, however, still to no avail.

What do you think of launching a frame page with two frames (top and bottom), the top one display the msg and the bottom one do data loading and size set to 0 to hide it, once the loader completes its job close the top and bottom frames).Since I don't use frames that often, just to check to see if anyone has done something similar and that works before I spend the time.

Many thanks.

Don
How about doing something like this:
 
MAIN Window
 tons of stuff
 event trigger:
pop2();
 
 
pop2 data loader
 msgWin = window.open( 'pop1.htm', 'msg', '' );
 msgWin.focus();
 
 do tons of stuff;
 
 msgWin.close();
 self.close();
 
 
pop1 message 
 document.write('Please wait, loading...');
 
 

-Original Message-
From: Chunshen Li [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 12:36 AM
To: CF-Talk
Subject: The never-ending windows


Hello,

I've spent at least one hour on figuring out how to work out this oo
thing.Here's the scoop, I have one Main window, which contain form and
elements, upon certain action, triggers a popup window, which does two
things of 1) query a database to pull certain data out; 2) write the data to
(populate) the Main window, then, close itself.

However, since, query/data retrieval and population may take a while, so,
I'd like to add msg like, Please wait ... upon loading, and yet, it causes
double buffer, the single popup window won't do, which leaves me with no
choice but to add another little named popup window to say Please wait
These two popup windows are loaded in the sequence of pop msg and pop
data loader.Problem, pop data loader, closes itself upon job completion,
fine, but the pop msg window won't close.

Here's the relevant code:

MAIN Window
tons of stuff
event trigger:
pop1();
pop2();

pop1 about msg
msgWin = (window.open('pop1.htm','msg','');
msgWin.focus();

pop2 about data loader
do tons of stuff;
// close pop1 window
msgWin.close();
// also tried, msg.close() to no avail
self.close();


TIA 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




New at Structures

2004-05-17 Thread Robert Orlini
I'm new at Structures...I wanted to addvariables to the items structure. 
The variables increment as they go thru a loop. The variable is called qty and as it goes thru the loop it would increment as qty1, qty2, etc thru a form. 
Here's the code. I'm having an obvious problem with the CFSET items.qty#countlist#=qty(#countlist#) which I know is not the right syntax...

Any thoughts please? Thanks as always.

Robert at HWW

CFIF isDefined(form.more.x)
cfset countList = countList + 1
/cfif
cfloop index=record from=1 to=#countList# step=1 
form action="" method=POST 
input type=hidden name=qty value
CFOUTPUT
tr
td width=25% bgcolor=##FFEEB3 align=center
input type=text name=qty size=4/td
/tr
/CFOUTPUT
CFSET items=StructNew()
CFIF IsDefined(qty#countlist#)
CFSET items.qty#countlist#=qty(#countlist#)
/cfif
cfoutput
#items.qty#countlist#br
/cfoutput
/CFLOOP
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: New at Structures

2004-05-17 Thread Dave Watts
 I'm new at Structures...I wanted to add variables to the 
 items structure. The variables increment as they go thru 
 a loop. The variable is called qty and as it goes thru 
 the loop it would increment as qty1, qty2, etc thru a 
 form. Here's the code. I'm having an obvious problem with the 
 CFSET items.qty#countlist#=qty(#countlist#) which I know is 
 not the right syntax...

You can use array syntax to reference your structure keys:

cfset items[qty#countlist#] = ...

But I'm not sure exactly what you're trying to do with the rest of your
code. Currently, you have two places where you're creating hidden form
fields named qty within the same page, which probably won't give you the
result you want.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




re: The never-ending windows

2004-05-17 Thread Scott Brady
Original Message:
 From: Chunshen (Don) Li 

 I've spent at least one hour on figuring out how to work out this oo thing.Here's the scoop, I have one Main window, which contain form and elements, upon certain action, triggers a popup window, which does two things of 1) query a database to pull certain data out; 2) write the data to (populate) the Main window, then, close itself.
 
 However, since, query/data retrieval and population may take a while, so, I'd like to add msg like, Please wait ... upon loading, and yet, it causes double buffer, the single popup window won't do, which leaves me with no choice but to add another little named popup window to say Please wait These two popup windows are loaded in the sequence of pop msg and pop data loader.Problem, pop data loader, closes itself upon job completion, fine, but the pop msg window won't close.

If all the first popup window does is perform a query and populate the main window, have you considered using an iframe instead?

Basically, here's what I'm thinking:
Your main window will have a hidden iframe. Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame.And, if you want, you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done.

That would seem a bit more user-friendly, because your users won't have to see the unnecessary pop-ups (not to mention that if they have pop-ups disabled, this code will still work).

Scott
---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Pascal Peters
cfscript
start = 1;
aLog = ArrayNew(1);
while(true){
	stTmp =
	
REFind([*]{3}([^*]*[[:space:]])([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space
:]]+([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})([[:space:]][^*]*)[*]{3},str,star
t,true);
	if(stTmp.pos[1]){
		stLog = StructNew();
		stLog = StructNew();
		user1 = Mid(str,stTmp.pos[2],stTmp.len[2]);
		stLog.date = Mid(str,stTmp.pos[3],stTmp.len[3]);
		stLog.time = Mid(str,stTmp.pos[4],stTmp.len[4]);
		user2 = Mid(str,stTmp.pos[5],stTmp.len[5]);
		if(len(trim(user1))) stLog.user = trim(user1); 
		else if(len(trim(user2))) stLog.user = trim(user2); 
		else stLog.user = ; 
		stLog.text = ;
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Mid(str,start,stTmp.pos[1]-start);
		}
		ArrayAppend(aLog,stLog);
		start = stTmp.pos[1]+stTmp.len[1];
	}
	else{
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Trim(Mid(str,start,Len(str)-start));
		}
		break;
	}
}
/cfscript
cfoutput
cfloop from=1 to=#ArrayLen(aLog)# index=i
div class=timestamp#aLog[i].user# #aLog[i].date#
#aLog[i].time#/div
pre#aLog[i].text#/pre
/cfloop
/cfoutput

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 14:32
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Pascal, sorry again for being such a PEST. I really do 
 apprecaite your help.
 
 There can be more than one occurance of the timestamp in the 
 comment column. Ex:
 
 *** 05/12/200309:52:10USER1 ***
 closing if fixed - awaitng response from User2
 
*** 04/12/200318:55:18USER2 ***
 Have been there, however user was on air shortly after, will 
 try again in a bit.
 
*** 04/12/200318:13:22USER3 ***
 Roger that
 
*** 04/12/200318:05:01USER4 ***
 closed
 
 Can you please add code in your script to handle this and 
 display all timestamps correctly
 
 Many thanks again
 cfcoder

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




whats this error?

2004-05-17 Thread Tony Weeg
05/17 10:30:17 error Connection reset
java.net.SocketException: Connection reset
	at java.net.SocketInputStream.read(SocketInputStream.java:168)
	at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
	at java.io.BufferedInputStream.read1(BufferedInputStream.java:222)
	at java.io.BufferedInputStream.read(BufferedInputStream.java:277)
	at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:530)
	at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:522)
	at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:540)
	at
jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:229)
	at
jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:144)
	at
jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.java:32
0)
	at
jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:433)
	at
jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(ThreadPool.java:280)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:76)

thanks!

my cfmx server is crashing every half hour or so. HELP!

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfmx not picking up spooled messages

2004-05-17 Thread Dieter Sommer
 All of the sudden on our production server (running CFMX 6.1) has 
 stopped picking up spooled mail messages. There are no errors in the 
 logs related to cfmail and no new entries in the mail log. In addition, 
 new messages are being added to the spool folder and they are never 
 moved into the undelivr folder, they just never send out. No settings 
 have changed via the CF Administrator and everything is configured 
 properly. Any ideas? Thanks.
 
 Mike

We had the same problem: the spool dir got more and more messages, and no spooler seemed to pick up any of them.

Restart the CFMX service. Our spooler worked normally after this, and the spool dir was empty in a minute.

I guess CFMX 6.1 had reached an inconsistent state without reporting any errors: I also found that after restarting the service we got a new logfile scheduled tasks, although I had defined several scheduled tasks the day before. Without restarting the service they never would have been started by CFMX.

Dieter
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
Pascal,

I may have missed the answer to this question, but is the content that we are looking at a query record set (multiple records), or is it from like a flat file, where the content is just appended?

It seems like all of these solutions are overly complex.It seems like such a simple problem to resolve.

Thanks,
Robert

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 10:15 A
To: CF-Talk
Subject: RE: help with string manipulation (Find,Replace)

cfscript
start = 1;
aLog = ArrayNew(1);
while(true){
	stTmp =
	
REFind([*]{3}([^*]*[[:space:]])([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space
:]]+([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})([[:space:]][^*]*)[*]{3},str,star
t,true);
	if(stTmp.pos[1]){
		stLog = StructNew();
		stLog = StructNew();
		user1 = Mid(str,stTmp.pos[2],stTmp.len[2]);
		stLog.date = Mid(str,stTmp.pos[3],stTmp.len[3]);
		stLog.time = Mid(str,stTmp.pos[4],stTmp.len[4]);
		user2 = Mid(str,stTmp.pos[5],stTmp.len[5]);
		if(len(trim(user1))) stLog.user = trim(user1); 
		else if(len(trim(user2))) stLog.user = trim(user2); 
		else stLog.user = ; 
		stLog.text = ;
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Mid(str,start,stTmp.pos[1]-start);
		}
		ArrayAppend(aLog,stLog);
		start = stTmp.pos[1]+stTmp.len[1];
	}
	else{
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Trim(Mid(str,start,Len(str)-start));
		}
		break;
	}
}
/cfscript
cfoutput
cfloop from=1 to=#ArrayLen(aLog)# index=i
div class=timestamp#aLog[i].user# #aLog[i].date#
#aLog[i].time#/div
pre#aLog[i].text#/pre
/cfloop
/cfoutput

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 14:32
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Pascal, sorry again for being such a PEST. I really do 
 apprecaite your help.
 
 There can be more than one occurance of the timestamp in the 
 comment column. Ex:
 
 *** 05/12/200309:52:10USER1 ***
 closing if fixed - awaitng response from User2
 
*** 04/12/200318:55:18USER2 ***
 Have been there, however user was on air shortly after, will 
 try again in a bit.
 
*** 04/12/200318:13:22USER3 ***
 Roger that
 
*** 04/12/200318:05:01USER4 ***
 closed
 
 Can you please add code in your script to handle this and 
 display all timestamps correctly
 
 Many thanks again
 cfcoder

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Don
Thanks, Scott, this is a step forward from my last update.Did quick srch on iframe got little thing but not satisfactory.
OK, I need some clarification.For consistency sake, let's stick with the naming convention for now.

Main Window
contains a hidden iframe (pop2),

Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame
Now, does the Main Window have to constructed as some sort of frame? the definition of iframe does not seem to suggest that.

The way to construct the iframe piece is like?
div id=loader style=visibility:hidden
iframe src="" width=0 height=0
/div

How to trigger the iframe to load (should be different from display, right?)

you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done.
Elaborate please.main frame refers to Main Window?

Many thanks.

Don

 Original Message:
  From: Chunshen (Don) Li 
 
  I've spent at least one hour on figuring out how to work out this 
 oo thing.Here's the scoop, I have one Main window, which contain 
 form and elements, upon certain action, triggers a popup window, which 
 does two things of 1) query a database to pull certain data out; 2) 
 write the data to (populate) the Main window, then, close itself.
  
  However, since, query/data retrieval and population may take a while, 
 so, I'd like to add msg like, Please wait ... upon loading, and yet, 
 it causes double buffer, the single popup window won't do, which 
 leaves me with no choice but to add another little named popup window 
 to say Please wait These two popup windows are loaded in the 
 sequence of pop msg and pop data loader.Problem, pop data loader, 
 closes itself upon job completion, fine, but the pop msg window won't 
 close.
 
 If all the first popup window does is perform a query and populate the 
 main window, have you considered using an iframe instead?
 
 Basically, here's what I'm thinking:
 Your main window will have a hidden iframe. Your trigger will load a 
 page in that hidden iframe which runs the query and then populates the 
 data in the main visible frame.And, if you want, you can have a 
 hidden div in the main frame that says Please wait... that will 
 become visible while that iframe code is doing its work and invisible 
 when the iframe code is done.
 
 That would seem a bit more user-friendly, because your users won't 
 have to see the unnecessary pop-ups (not to mention that if they have 
 pop-ups disabled, this code will still work).
 
 Scott
 ---
 Scott Brady
 http://www.scottbrady.net/
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




FW: Mihai Bazon ( mishoo ) website gone

2004-05-17 Thread mayo
-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 9:40 AM
To: CF-TALK
Subject: Mihai Bazon ( mishoo ) website gone

Does anyone know what's happened to http://dynarch.com? I was going to
purchase his htmlarea code and the site's been down since Thursday night.

Is he still there?

Gil Midonnet
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfmx not picking up spooled messages

2004-05-17 Thread Maureen
Sometimes the spool will get a zero byte message stuck at the top of the 
queue, and nothing behind it will send.Restarting may help, but you may 
have to go in and manually delete the junk message.

At 10:39 AM 5/17/04, you wrote:
  All of the sudden on our production server (running CFMX 6.1) has
  stopped picking up spooled mail messages. There are no errors in the
  logs related to cfmail and no new entries in the mail log. In addition,
  new messages are being added to the spool folder and they are never
  moved into the undelivr folder, they just never send out. No settings
  have changed via the CF Administrator and everything is configured
  properly. Any ideas? Thanks.
 
  Mike

We had the same problem: the spool dir got more and more messages, and no 
spooler seemed to pick up any of them.

Restart the CFMX service. Our spooler worked normally after this, and the 
spool dir was empty in a minute.

I guess CFMX 6.1 had reached an inconsistent state without reporting any 
errors: I also found that after restarting the service we got a new 
logfile scheduled tasks, although I had defined several scheduled tasks 
the day before. Without restarting the service they never would have been 
started by CFMX.

Dieter

--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] 
[http://www.houseoffusion.com/lists.cfm/link=i:4:163343This Message] 
[http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] 
[http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1523.1443.4Fast 
Unsubscribe] [http://www.houseoffusion.com/signin/User Settings]

--
http://www.houseoffusion.com/banners/view.cfm?bannerid=351d12e09.jpg
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Pascal Peters
It's like a flat file. (a huge comment field in the DB).
Storing the comments in a related table would have made his life easier,
but I don't think he can change the way the data is stored.

 -Original Message-
 From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 
 [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 16:37
 To: CF-Talk
 Subject: RE: help with string manipulation (Find,Replace)
 
 Pascal,
 
 I may have missed the answer to this question, but is the 
 content that we are looking at a query record set (multiple 
 records), or is it from like a flat file, where the content 
 is just appended?
 
 It seems like all of these solutions are overly complex.It 
 seems like such a simple problem to resolve.
 
 Thanks,
 Robert
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
My bad, I responded to Pascal earlier... Sorry about that.

CFCODER:

You have shown your data two ways, and this impacts any solution that is presented:

Latest: 
*** 05/12/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

 *** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.

 *** 04/12/200318:13:22USER3 ***
Roger that

 *** 04/12/200318:05:01USER4 ***
closed

Originally:

*** User1 10/28/2003 2:53:52 *** 

 
THIS IS A TEST

 
*** User 2 04/06/200313:41:47 *** 

 
blah, blah

So which is it?

Also, I may have missed this answer, but it seems to me that the solution is to drop the separate data elements into their own fields in the database IN THE FIRST PLACE.That way they can be queried out, or barring that solution, change the code that writes each entry to include delimiters
e.g. 
*** User 2|04/06/2003|13:41:47***blah, blah 

And use CR/LF between fields to separate records...

I'm sorry if this doesn't help, but the fact is you are dealing with output that sorely needs to be reformatted to make it easier to process. You shouldn't need anything major to pull it apart.

Thanks,
Robert

P.S. What are the rules for the data that you are pulling apart now? 
e.g.
3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf
3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf
etc...

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 8:32 A
To: CF-Talk
Subject: Re: help with string manipulation (Find,Replace)

Pascal, sorry again for being such a PEST. I really do apprecaite your help.

There can be more than one occurance of the timestamp in the comment column. Ex:

*** 05/12/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

 *** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.

 *** 04/12/200318:13:22USER3 ***
Roger that

 *** 04/12/200318:05:01USER4 ***
closed

Can you please add code in your script to handle this and display all timestamps correctly

Many thanks again
cfcoder



thanks Pascal! It doesn't quite work how I would like it to.

EX: *** 08/12/200320:33:31EDWARI31 ***

You code displays the above timestamp like this:

0 8/12/2003 20:33:31

Where as I would like it to be displayed like this:

EDWARI31 08/12/2003 20:33:31

I dumped stTmp cfdump var=#stTmp#. This is what it returns

struct 
LEN 
array
1 38
2 2
3 9
4 8
5 11
 
POS 
array
1 1
2 4
3 6
4 17
5 25
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
You are a GENIUS man! That code rocks, I wouldn't know how to do this without your help. You are a star. Just one small problem, the comments column sometimes doesn't store the timestamp. I went through your code. The while condition in the above mentioned situation would be false so the code in the else part would be executed. 

if(ArrayLen(aLog)){ 
aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); 
}

The above condition would be false. I added a 'else' condition and want to assign 'str' to aLog[ArrayLen(aLog)].text.

something like this:

if(ArrayLen(aLog)){ 
aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); 
}
else
{
'What should I be doing here?'
}
break;

Many thanks again!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Scott Brady
Original Message:
 From: Chunshen (Don) Li

 Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame
 Now, does the Main Window have to constructed as some sort of frame? the definition of iframe does not seem to suggest that.
 
 The way to construct the iframe piece is like?
 div id=loader style=visibility:hidden
iframe src="" width=0 height=0
 /div

You don't need the div around it in order to hide it.You can just apply the style to the iframe.Assuming you're not going to load anything in that iframe when the page loads, here's one option:

iframe name=loadFrame id=loadFrame style=display:none; src="">

 How to trigger the iframe to load (should be different from display, right?)

Using _javascript_, you can treat it just like a frame.Meaning something like this should work in whatever function you use to trigger the load:

document.frames['loadFrame'].src = '';

 you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done.
 Elaborate please.main frame refers to Main Window?

Err, yeah. Main window that contains your hidden iframe.Basically, that main window also has a hidden div something like this:

div id=waitDiv style=position:absolute;top:100;left:100;height:200;width:200;z-index:2;visibility:hidden;
Loading. Please wait...
/div

Now, in the _javascript_ above where you load the iframe's loader, you can do this:

document.getElementById('waitDiv').style.visibility = 'visible';

In dataLoader.cfm, you can do an onload (or just after where you populate the main window's data) that does this:

parent.document.getElementById('waitDiv').style.visibility = 'hidden';

All of that SHOULD work, but I'm typing this on the fly so haven' t tested it completely. If it doesn't work, let me know.

Scott
---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Pascal Peters
If your format isn't always the same (*** user timestamp *** OR ***
timestamp user ***) you can't use my code. You need to do it in a
different way. I can help if you want, but if you keep changing the
specs it's not very easy. Also, remind me what version you are on. I'm
writing CF5 regexp for the moment, but this is easier in CFMX.

Pascal 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 16:55
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 You are a GENIUS man! That code rocks, I wouldn't know how to 
 do this without your help. You are a star. Just one small 
 problem, the comments column sometimes doesn't store the 
 timestamp. I went through your code. The while condition in 
 the above mentioned situation would be false so the code in 
 the else part would be executed. 
 
 if(ArrayLen(aLog)){
 aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start));
 }
 
 The above condition would be false. I added a 'else' 
 condition and want to assign 'str' to aLog[ArrayLen(aLog)].text.
 
 something like this:
 
 if(ArrayLen(aLog)){
 aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start));
 }
 else
 {
'What should I be doing here?'
 }
 break;
 
 Many thanks again!
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
Hi Robert,

apologies for causing any confusion. I was asked to present the data stored in the database table column in a certain way. Historically data stored in this column is as under:

timestamp
comments

EX:

*** 05/12/2003 09:52:10 USER1 ***
closing if fixed - awaitng response from User2

I was asked to get rid of the stars and reorder the timestamp to something like this:

USER1 05/12/2003 09:52:10
(Username, Date, Time)

All comments (timestamps) added henceforth will be added in this fashion.
I hope this gives you a better understanding. The solution Pascal provided does just that and it does the job for me.

Best Regards,
cfcoder

 My bad, I responded to Pascal earlier... Sorry about that.
 
 CFCODER:
 
 You have shown your data two ways, and this impacts any solution that 
 is presented:
 
 Latest: 
 *** 05/12/200309:52:10USER1 ***
 closing if fixed - awaitng response from User2
 

 
 *** 04/12/200318:55:18USER2 ***
 Have been there, however user was on air shortly after, will try again 
 in a bit.
 

 
 *** 04/12/200318:13:22USER3 ***
 Roger that
 

 
 *** 04/12/200318:05:01USER4 ***
 closed
 
 Originally:
 
 *** User1 10/28/2003 2:53:52 *** 

 
 
 THIS IS A TEST

 
 
 *** User 2 04/06/200313:41:47 *** 

 
 
 blah, blah
 
 
 So which is it?
 
 Also, I may have missed this answer, but it seems to me that the 
 solution is to drop the separate data elements into their own fields 
 in the database IN THE FIRST PLACE.That way they can be queried out, 
 or barring that solution, change the code that writes each entry to 
 include delimiters
 e.g. 
 *** User 2|04/06/2003|13:41:47***blah, blah 
 
 And use CR/LF between fields to separate records...
 
 I'm sorry if this doesn't help, but the fact is you are dealing with 
 output that sorely needs to be reformatted to make it easier to 
 process. You shouldn't need anything major to pull it apart.
 
 Thanks,
 Robert
 
 P.S. What are the rules for the data that you are pulling apart now? 
 e.g.
 3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 
 3 asterisks, comment, cr/lf, cr/lf
 3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 
 3 asterisks, comment, cr/lf, cr/lf
 etc...
 
 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED]
 Sent: Monday, May 17, 2004 8:32 A
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 
 Pascal, sorry again for being such a PEST. I really do apprecaite your 
 help.
 
 There can be more than one occurance of the timestamp in the comment 
 column. Ex:
 
 *** 05/12/200309:52:10USER1 ***
 closing if fixed - awaitng response from User2
 

 
 *** 04/12/200318:55:18USER2 ***
 Have been there, however user was on air shortly after, will try again 
 in a bit.
 

 
 *** 04/12/200318:13:22USER3 ***
 Roger that
 

 
 *** 04/12/200318:05:01USER4 ***
 closed
 
 Can you please add code in your script to handle this and display all 
 timestamps correctly
 
 Many thanks again
 cfcoder
 
 
 
 
 
 
 
 thanks Pascal! It doesn't quite work how I would like it to.
 
 EX: *** 08/12/200320:33:31EDWARI31 ***
 
 You code displays the above timestamp like this:
 
 0 8/12/2003 20:33:31
 
 Where as I would like it to be displayed like this:
 
 EDWARI31 08/12/2003 20:33:31
 
 I dumped stTmp cfdump var=#stTmp#. This is what it returns
 
 struct 
 LEN 
 array
 1 38
 2 2
 3 9
 4 8
 5 11
  
 POS 
 array
 1 1
 2 4
 3 6
 4 17
 5 25

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
sorry Pascal, my bad. The format is not always the same, there may be few comments in the database without the timestamp. All comments added when I build the functionality will not have the *** user timestamp ***. I have CFMX installed on the server.

Best regards,
cfcoder

If your format isn't always the same (*** user timestamp *** OR ***
timestamp user ***) you can't use my code. You need to do it in a
different way. I can help if you want, but if you keep changing the
specs it's not very easy. Also, remind me what version you are on. I'm
writing CF5 regexp for the moment, but this is easier in CFMX.

Pascal 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Deleted records being returned

2004-05-17 Thread John Croney
I am using Visual Fox Pro8 to create my dbf tables. 
I have created a connection on the server ODBC and referred to it in Coldfusion. The option for Deleted in the ODBC for VFP is not checked.

When I retrieve the records, all records are return including the deleted ones.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Pascal Peters
I'm off to home right now, but I'll send you the code in the morning
(for me GMT+2) 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 17:15
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 sorry Pascal, my bad. The format is not always the same, 
 there may be few comments in the database without the 
 timestamp. All comments added when I build the functionality 
 will not have the *** user timestamp ***. I have CFMX 
 installed on the server.
 
 Best regards,
 cfcoder
 
 If your format isn't always the same (*** user timestamp *** OR *** 
 timestamp user ***) you can't use my code. You need to do it in a 
 different way. I can help if you want, but if you keep changing the 
 specs it's not very easy. Also, remind me what version you 
 are on. I'm 
 writing CF5 regexp for the moment, but this is easier in CFMX.
 
 Pascal
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: help with string manipulation (Find,Replace)

2004-05-17 Thread cf coder
Thanks Pascal. Sorry again for any inconvenience caused.

Best regards
cfcoder

I'm off to home right now, but I'll send you the code in the morning
(for me GMT+2) 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Don
 Your trigger will load a page in that hidden iframe which runs the 
 query and then populates the data in the main visible frame
 Now, does the Main Window have to constructed as some sort of frame? 
 the definition of iframe does not seem to suggest that.
 
 The way to construct the iframe piece is like?
 div id=loader style=visibility:hidden

 iframe src="" width=0 height=0
 /div
 
 How to trigger the iframe to load (should be different from display, 
 right?)
 
 you can have a hidden div in the main frame that says Please wait...
  that will become visible while that iframe code is doing its work 
 and invisible when the iframe code is done.

Thanks, Scott, not there yet, maybe I'm missing something.

Here's more details:

MAIN WINDOW

js function xyz(obj,el,p1,p2,p3) 
document.frames['loadFrame'].src = ''+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3;

bla bla tons of stuff

div id=waitDiv style=position:absolute;top:100;left:100;height:200;width:200;z-index:2;visibility:hidden; 
Loading. Please wait... 
/div 

iframe name=loadFrame id=loadFrame style=display:none; src="" 



content of dataloader.cfm:
top:
script
 parent.document.getElementById('waitDiv').style.display = 'block'; 
/script

main js:
 pull data
 and populate the MAIN window
 // now close the please wait .. frame
 parent.document.getElementById('waitDiv').style.visibility = 'hidden';

msg win does not show up, data not loaded, what am i missing?many thanks.

Don
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFmail and Spam

2004-05-17 Thread Thomas Chiverton
On Monday 17 May 2004 09:47 am, Adam Reynolds wrote:
 Is there anything that can be done to make it look like the mail came from
 say Outlook?

You can change the ID of the sending mail program using cfmailparam.
Check the archives.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfmx admin question

2004-05-17 Thread Thomas Chiverton
On Monday 17 May 2004 11:53 am, Whittingham, P wrote:
 yes (cfstart) , but i think it produce some errors...how does one
 interprete them.

Look in the logs sub. dir. of the CF install.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Please Help! XML Webservice Question

2004-05-17 Thread Thomas Chiverton
On Friday 14 May 2004 21:57 pm, Shawn Contreras wrote:
 HOW do I write code that says:
 If there is no data, skip to the next field and so on

cfif isDefined('nameOfVar')

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: grabbing only a part of a string

2004-05-17 Thread Thomas Chiverton
On Thursday 13 May 2004 20:46 pm, Steve Nelson wrote:
 That looks like a short list to me. You could just use
 #listlast(custom|98,|)# If it's really more complex than that, check
 out the functions: findnocase() and mid()

If it's really more complex than that, check our reFind() and friends.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Scott Brady
Original Message:
 From: Chunshen (Don) Li 
 msg win does not show up, data not loaded, what am i missing?many thanks.

It could be any number of things. (It all looks right, but I may be missing something)

Do you have a link where this is in action? 

If not, here are some things to try:

1) If you're using a Mozilla-based browser [or some other browser that doesn't popup JS error messages], make sure you're not getting any JS errors by using the _javascript_ Console

2) If you're not getting any JS errors, make sure the page knows the iframe exists.In your xyz function before setting the iframe's source, do an alert:

alert(document.frames['loadFrame'].src);
[you should get something like about:blank]

(and do it again after you set the source and you should get the url you passed in)

3) If you see that the dataloader.cfm is being called in the iframe, go to that page and do another alert:

alert(parent.document.getElementById('waitDiv');
[you should get something like object:object]

If that still doesn't work, try to put it on a server somewhere so we can take a look.

Scott
---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Don
Sorry, I missed one thing from your last post, here's the revised version, please see below.Thanks.

 
 Thanks, Scott, not there yet, maybe I'm missing something.
 
 Here's more details:
 
 MAIN WINDOW
 
 js function xyz(obj,el,p1,p2,p3) {
... 
 // load the wait msg
 document.getElementById('waitDiv').style.visibility = 'visible';
 // works

 // retrieve data and populate MAIN WINDOW 
 document.frames['loadFrame'].src = ''+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3;
 /* this part seems problem, not loading
 tried variant
 document.frames['loadFrame'].src = "">
 cfm?obj='+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3+;
 to no avail either
 */
}

 bla bla tons of stuff
 
 div id=waitDiv 
style=position:absolut e;top:100;left:100;height:200;width:200;z-index:2;visibility:hidden; 
 
 Loading. Please wait... 
 /div 
 
 iframe name=loadFrame id=loadFrame style=display:none; 
 src="" 
 
 
 
 content of dataloader.cfm:
 top:

 script
 parent.document.getElementById('waitDiv').style.display = 'block'; 
 /script
ABOVE REMOVED.

 
 main js:

 
 pull data

 
 and populate the MAIN window

 
 // now close the please wait .. frame

 
 parent.document.getElementById('waitDiv').style.visibility = 'hidden';
 
 
 
 msg win does not show up, data not loaded, what am i missing?many 
 thanks.
 
 Don
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Maxing out running requests then server hanging -- Help

2004-05-17 Thread Jeremy Bruck
Everyone,

 
We put out a new release of our web-application and have been having
server problems problems ever since.All will run fine and then all of
a sudden running requests will start creeping up and then CFMX hangs --
about every 4/6ish hours.Before the new release the most problems we
would ever have was database locks and we could either wait for the
database lock to finish or kill it -- none of this has been database
locks.Majority of the time both boxes (2 web servers hardware
loadbalanced) will be using up about 700ish meg of ram (both have 1 gig
of ram) when they are hung.We tried even running CFMX from a command
line to get a java stack trace when it hangs, but it never would create
a dump of the stack trace for us even -- t hung I am assuming.

 
Then this past week for a solid hour the running requests would keep
running up to the max (25/box) and then would hang -- all we could do
was continually restart the service which we did about 20 times on both
boxes -- we tried rebooting in the middle of all this as well which
didn't help either.The weird thing was after about an hour it all went
back to the 4/6ish hour hand routine.

 
Any ideas on what could be causing the hangs?Since the new release
used CFC's heavily could this be causing any of the issues?Any ideas
on better ways to trace/debug it?

 
Here are the details on our setup (all software is fully patched):
 2 hardware loadbalanced webservers running Win2K with CFMX 6.1 with
an Apache webserver (2.046)
 Seperate box running MS SQL Server
 Approximate traffic is 12K to 15K unique visitors/day

 
Thanks,
Jeremy

 
--
Jeremy Bruck
ManufacturingQuote
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Advanced session mgt?

2004-05-17 Thread Katz, Dov B (IT)
Can someone please advise if there is anything I should know about this
process?

 
It seems that whenever I enable a Who's online or homegrown advanced
session information features on my site, the server eventually degrades
etc...Other than a CFLOCK which I know I need to add in (and will) is
there any other red flags about doing something like this which I
should be aware of?

 
I am trying to determine if there are any known issues with CFMX 6.1
with doing something like that.

 
Here's (in cf-nevercompiled-pseudocode) what I'm doing: (names of files
are made up for this email...)

 
!--- Act_OnLoginSuccessful.cfm ---
Cfset session.state = structnew()
Cfset session.username = SomeLoginQuery.username 
Cfset structinsert(session.username,session.state)

 
!--- App_globals.cfm or application.cfm ---
Cfparam name=application.states default=structnew()
Cfif isdefined(session.state)
 Cfset session.state.last=now() 
/cfif

 
!--- Dsp_WhosOnline.cfm ---
cfset MyStruct=StructCopy(Application.states)
Cfloop list=structkeylist(mystruct) index=key
 Cfif
datediff(n,structfind(structfind(mystruct,key),last),now()) gt 30
CFset structdelete(application.states,key)
 /cfif
 Cfelse
Display something here about #key# and
#structfind(structfind(mystruct,key),last)#
 /cfif
/cfloop 


 
NOTICE: If received in error, please destroy and notify sender.Sender does not waive confidentiality or privilege, and use is prohibited.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Maxing out running requests then server hanging -- Help

2004-05-17 Thread Bryan Stevenson
Well the only thing I've seen on our boxes that is similar is if a parsing error occurs (likea cfset missing an opening or closing bracket).What happens when that page is run, JRun starts eating RAM until the server grinds to a halt.

This happens fairly quickly though and I would suspect that that you've got something else going on...because that kind of traffic with the issue we've seen would toast your servers much faster than they seem to be dying.

HTH

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Jeremy Bruck 
To: CF-Talk 
Sent: Monday, May 17, 2004 9:18 AM
Subject: Maxing out running requests then server hanging -- Help

Everyone,

We put out a new release of our web-application and have been having
server problems problems ever since.All will run fine and then all of
a sudden running requests will start creeping up and then CFMX hangs --
about every 4/6ish hours.Before the new release the most problems we
would ever have was database locks and we could either wait for the
database lock to finish or kill it -- none of this has been database
locks.Majority of the time both boxes (2 web servers hardware
loadbalanced) will be using up about 700ish meg of ram (both have 1 gig
of ram) when they are hung.We tried even running CFMX from a command
line to get a java stack trace when it hangs, but it never would create
a dump of the stack trace for us even -- t hung I am assuming.

Then this past week for a solid hour the running requests would keep
running up to the max (25/box) and then would hang -- all we could do
was continually restart the service which we did about 20 times on both
boxes -- we tried rebooting in the middle of all this as well which
didn't help either.The weird thing was after about an hour it all went
back to the 4/6ish hour hand routine.

Any ideas on what could be causing the hangs?Since the new release
used CFC's heavily could this be causing any of the issues?Any ideas
on better ways to trace/debug it?

Here are the details on our setup (all software is fully patched):
2 hardware loadbalanced webservers running Win2K with CFMX 6.1 with
an Apache webserver (2.046)
Seperate box running MS SQL Server
Approximate traffic is 12K to 15K unique visitors/day

Thanks,
Jeremy

--
Jeremy Bruck
ManufacturingQuote
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Scott Brady
Original Message:
 From: Chunshen (Don) Li 

// retrieve data and populate MAIN WINDOW 
document.frames['loadFrame'].src = ''+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3;
/* this part seems problem, not loading
tried variant
document.frames['loadFrame'].src = "">
cfm?obj='+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3+;
to no avail either
*/
 }
 

I'd say try the JS alerts I suggested in my last reply and make sure that the iframe's src is being set. 

There's also a possibility that the .cfm file is throwing an error (one problem with invisible iframes:you don't see the error messages).So, you can try doing a try/catch block around it and alert a message if there's a CF error occurring.

Scott
---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Maxing out running requests then server hanging -- Help

2004-05-17 Thread Dave Carabetta
We put out a new release of our web-application and have been having
server problems problems ever since.All will run fine and then all of
a sudden running requests will start creeping up and then CFMX hangs --
about every 4/6ish hours.Before the new release the most problems we
would ever have was database locks and we could either wait for the
database lock to finish or kill it -- none of this has been database
locks.Majority of the time both boxes (2 web servers hardware
loadbalanced) will be using up about 700ish meg of ram (both have 1 gig
of ram) when they are hung.We tried even running CFMX from a command
line to get a java stack trace when it hangs, but it never would create
a dump of the stack trace for us even -- t hung I am assuming.

Then this past week for a solid hour the running requests would keep
running up to the max (25/box) and then would hang -- all we could do
was continually restart the service which we did about 20 times on both
boxes -- we tried rebooting in the middle of all this as well which
didn't help either.The weird thing was after about an hour it all went
back to the 4/6ish hour hand routine.

Any ideas on what could be causing the hangs?Since the new release
used CFC's heavily could this be causing any of the issues?Any ideas
on better ways to trace/debug it?

Here are the details on our setup (all software is fully patched):
2 hardware loadbalanced webservers running Win2K with CFMX 6.1 with
an Apache webserver (2.046)
Seperate box running MS SQL Server
Approximate traffic is 12K to 15K unique visitors/day


We had similar problems that were resolved by reverting the 6.1 database 
drivers to the 6.0+ version available at the related TechNote 
(http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserver_cpu.htm). 
Unfortunately, MM has removed the 6.0+ drivers in that TechNote and replaced 
the download to point to the new DataDirect 3.3 drivers. Perhaps you'll have 
luck with those, but we continued to have problems, so we're still on the 
6.0+ drivers.

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Losing Sessions Variable

2004-05-17 Thread ANNAMANAIDU, VENKATESH (SBCSI)
Experts,
I am reposting this question. Please bear with me.

Application.cfm isfollows
..
..
cfparam name=Session.LogState default=OUT
cfif IsDefined(url.uCmpyID)
	cfinclude template=set_session.cfm
/cfif 
..
..

In set_session.cfm,after our authentication session variable is set as
follows, 
cfset session.LogState = IN

Authentication
All pages looks for this session, otherwise it kicks you out.
Home page works fine and we can see the session variable in debug
statement.

But, here is mystery, if we click any link in home page, session
variable gets
disappeared and hence that page kicks you out. All links are cfmx
templates in same server and directory.

Also
(1) We have enabled session management in Application.cfm
(2) We have given ample time in CFMX admin for session timeout.

Have you come across this issue of losing sessions. Any ideas how to
retain session, between pages?

Venky
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Losing Sessions Variable

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
Make sure you don't have more than one CFAPPLICATION tag in your code... and that the name is the always the same:

cfparam name=request.app.internal_name default = TEST_DEV
cfparam name=request.app.timespan default = #createTimeSpan(0,4,0,0)#

cfapplication 
	name=#request.app.internal_name#_10 
	clientmanagement=Yes 
	sessionmanagement=Yes 
	sessiontimeout=#request.app.timespan# 
	clientstorage=test_DSN 
	loginstorage=session

If you have another CFAPPLICATION tag anywhere else, you lose the original cfapplication data.

Robert

-Original Message-
From: ANNAMANAIDU, VENKATESH (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 12:47 P
To: CF-Talk
Subject: Losing Sessions Variable

Experts,
I am reposting this question. Please bear with me.

Application.cfm isfollows
..
..
cfparam name=Session.LogState default=OUT
cfif IsDefined(url.uCmpyID)
	cfinclude template=set_session.cfm
/cfif 
..
..

In set_session.cfm,after our authentication session variable is set as
follows, 
cfset session.LogState = IN

Authentication
All pages looks for this session, otherwise it kicks you out.
Home page works fine and we can see the session variable in debug
statement.

But, here is mystery, if we click any link in home page, session
variable gets
disappeared and hence that page kicks you out. All links are cfmx
templates in same server and directory.

Also
(1) We have enabled session management in Application.cfm
(2) We have given ample time in CFMX admin for session timeout.

Have you come across this issue of losing sessions. Any ideas how to
retain session, between pages?

Venky
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Don
Scott,

Please see my comments below.Thanks.

Don
 Original Message:
 I'd say try the JS alerts I suggested in my last reply and make sure 
 that the iframe's src is being set. 
Right on.err msg undefined.

 There's also a possibility that the .cfm file is throwing an error 
 (one problem with invisible iframes:you don't see the error 
 messages).So, you can try doing a try/catch block around it and 
 alert a message if there's a CF error occurring.
CF error extremly unlikely for the dataloader.As for the try/catch, yes, I use it.

 Scott
 ---
 Scott Brady
 http://www.scottbrady.net/

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Don
 Original Message:
 Do you have a link where this is in action? 
Scott,

I've just sent an email to [EMAIL PROTECTED] with a URL.

Thanks.

Don
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Maxing out running requests then server hanging -- Help

2004-05-17 Thread Dave Watts
 We had similar problems that were resolved by reverting the 
 6.1 database drivers to the 6.0+ version available at the 
 related TechNote 
 (http://www.macromedia.com/support/coldfusion/ts/documents/cfm
 x61_sqlserver_cpu.htm). 
 Unfortunately, MM has removed the 6.0+ drivers in that 
 TechNote and replaced the download to point to the new 
 DataDirect 3.3 drivers. Perhaps you'll have luck with those, 
 but we continued to have problems, so we're still on the 6.0+
 drivers.

Out of curiosity, are you having the same problems with the 3.3 drivers that
you were with the 3.2 drivers? What database server are you using?

For our SQL Server clients, we've successfully deployed the MS JDBC drivers
in some cases.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT: JavaScript RegEx bug in NS6?

2004-05-17 Thread Lofback, Chris
I think I've found a bug in the _javascript_ RegEx implementation in Netscape 6 (for Windows, anyway).Below is a RegEx pattern for a non-IP email address.The first alert shows zero, which is a match beginning with the first character, but the second alert shows '-1', indicating no match.The only difference is using $ for an end-of-line anchor.This code works correctly in NS4(!), NS7 and IE6.Any JS gurus out there have any ideas for a workaround for this?

Thanks,
Chris

SCRIPT LANGUAGE=_javascript_
	var s = '[EMAIL PROTECTED]';
	alert(s.search(/^['_a-z0-9-]+(\.[_a-z0-9-]+)*@([a-z0-9-]+\.)+([a-z]{2,3}|aero|coop|info|museum|name)/i));
	alert(s.search(/^['_a-z0-9-]+(\.[_a-z0-9-]+)*@([a-z0-9-]+\.)+([a-z]{2,3}|aero|coop|info|museum|name)$/i));
/SCRIPT
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CF_Web_services preparation for consumption

2004-05-17 Thread coldfusion . developer
All,

We're writing CFCs tht will become Web services.These Web services are going
to be data exchanges from a few of our database tables.We want the Web Services
to be used to access our database information and import the data to their own
database.To sign up for access to these Web Services, Affiliates will have to 
log in via a username and password which drops them into their own subdirectory 
below the webroot. 

My three questions are ...

1) How can I prevent these Affiliates from using these Web services as live data
feeds to populate their Web pages?Can I somehow restrict the number of hits/bytes to 
these Web services?

2) What's the best way to present example code for the various application development laungauges?
I want to give users of our Web Service sample code based on their application launguage.
I was going to see what code was developed within DreamWeaver's component panel and edit the
Proxy Generator from Cold Fusion MX to what's available. (.NET C#, .NET VB, APACHE SOAP 3.0)

3) When I click on new Proxy Generator and then Get more proxy generators, it takes me to the
Macromedia site, but i can't find any downloadables that look like proxy generators.I'd like to
find generators for JSP, PHP and a PERL generator is there is one.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: JavaScript RegEx bug in NS6?

2004-05-17 Thread Massimo, Tiziana e Federica
It works fine on Mozilla 1.6
NN 6 was based on a beta version of Mozilla and was very buggy. You should
at least try NN 7


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ColdFusion installation issue

2004-05-17 Thread Doug White
Re-Post

I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then
installed CFMX 6.1.I am not using Active Directory.

After going through the install chores, the installer notifies you that the
installation was successful and that CFMX administrator will then open in the
browser to complete the installation.The install log file shows no errors.

This is where I ran into a problemWhen IE opens up and tries to open the CFMX
administrator page, it reports SERVICE NOT AVAILABLE

All files seem to be in the right place, and the ISAPI configuration appears to
be set up by the installer correctly.all the settings shown in the exhibit of
Dave Watts paper on the Macromedia site appear to be in place.

Anyone have a clue as what I need to do to get this installation completed?

Thanks

Doug
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFmail and Spam

2004-05-17 Thread Mosh Teitelbaum
Actually, don't use CFMAILPARAM for this.Using CFMAILPARAM this way causes
there to be 2 X-Mailer headers.Instead, use the MAILERID attribute of the
CFMAIL tag to set the X-Mailer header like the following:

	CFMAIL TO=.. MAILERID=Microsoft Outlook, Build 10.0.3416
		...
	/CFMAIL

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 11:44 AM
To: CF-Talk
Subject: Re: CFmail and Spam

On Monday 17 May 2004 09:47 am, Adam Reynolds wrote:
 Is there anything that can be done to make it look like the mail came from
 say Outlook?

You can change the ID of the sending mail program using cfmailparam.
Check the archives.

--
Tom Chiverton
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ColdFusion installation issue

2004-05-17 Thread Adkins, Randy
for some reason the CF Application Service was not restarted on mine, I had
to restart it and all was fine.

-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 2:20 PM
To: CF-Talk
Subject: Re: ColdFusion installation issue

Re-Post

I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then
installed CFMX 6.1.I am not using Active Directory.

After going through the install chores, the installer notifies you that the
installation was successful and that CFMX administrator will then open in
the
browser to complete the installation.The install log file shows no errors.

This is where I ran into a problemWhen IE opens up and tries to open the
CFMX
administrator page, it reports SERVICE NOT AVAILABLE

All files seem to be in the right place, and the ISAPI configuration appears
to
be set up by the installer correctly.all the settings shown in the exhibit
of
Dave Watts paper on the Macromedia site appear to be in place.

Anyone have a clue as what I need to do to get this installation completed?

Thanks

Doug 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Deleted records being returned

2004-05-17 Thread John Croney
Can someone please help???

 I am using Visual Fox Pro8 to create my dbf tables. 
 I have created a connection on the server ODBC and referred to it in 
 Coldfusion. The option for Deleted in the ODBC for VFP is not checked.
 
 
 When I retrieve the records, all records are return including the 
 deleted ones.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Deleted records being returned

2004-05-17 Thread Greg Luce
John,
	It's been a long time since I've seen a foxpro .dbf, but I'm sure I
can help if you post some code. When you say refer to it with ColdFusion,
do you mean you created a datasource pointing to it? 
	Did you query the table in a CF template? Post the code in question.

Greg

-Original Message-
From: John Croney [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 2:34 PM
To: CF-Talk
Subject: Re: Deleted records being returned

Can someone please help???

 I am using Visual Fox Pro8 to create my dbf tables. 
 I have created a connection on the server ODBC and referred to it in 
 Coldfusion. The option for Deleted in the ODBC for VFP is not checked.
 
 
 When I retrieve the records, all records are return including the 
 deleted ones.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JavaScript RegEx bug in NS6?

2004-05-17 Thread Lofback, Chris
Thanks for the feedback on Mozilla--good to know.I'd heard that NN6 was buggy but my goal is to support users who have NN6 if at all possible rather than ask them to upgrade.

 
Chris

-Original Message-
From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 2:00 PM
To: CF-Talk
Subject: Re: _javascript_ RegEx bug in NS6?

It works fine on Mozilla 1.6
NN 6 was based on a beta version of Mozilla and was very buggy. You should
at least try NN 7


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFChart and the Y-Axis

2004-05-17 Thread DURETTE, STEVEN J (AIT)
Hi all,

 
Got one for you all.(and yes I did search the list history before asking!)
:)

 
I have a cfchart that has a minimum value of 0 (zero) and a maximum of 100.
No matter whether I put in only integers or decimals (the data that will be
in the final chart) the Y-Axis always shows up in decimals.

 
Example:
100
88.89
77.78
66.67
55.56
44.44
33.33
22.22
11.11
0

 
but what I need is for all of them to be in integers (the data will still be
in decimals).
100
90
80
70
60
50
40
30
20
10
0

 
Anyone know how to make this happen?

 
Extra information:
Line chart with 3 series.
CFMX6.1 Enterprise
Win2K
IIS5

 
Thanks,
Steve
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




How to validate form variables with this method including Encoding: multi-part/form-data

2004-05-17 Thread Rick Faircloth
Hi, all...

I know the subject is unclear, but here's the situation.

I'm using CF 4.5...

I validate formfields by submitting a form back to the page containing the
form
and using CFTRY / CFCATCH, then, if everything passes validation, setting
the form variables to session variables and then using CFLOCATION to pass
them to an action page for processing.

I haven't, to this point, used this method, with a from that contains a file
upload field.

Typically, with a form that contains a file upload field, I just don't
validate the fields.
I would, however, like to start validating all form submissions, even those
that contain
file upload fields.

The main question is...how would I pass on the Encoding type:
multipart/form-date specification
through the form page itself during verification then send that encoding
info along with the session
variables to the processing page using my typical CFLOCATION
URL="" ?

Here's the code I've set up so far to validate the form entries...

CFIF IsDefined(Form.Submit)

CFTRY

 CFIF Form.Newsletter_Title is 

CFTHROW Type=AddError Message=Please enter a title for
the newsletter.

 /CFIF

 CFIF Form.Newsletter_Upload is 

CFTHROW Type=AddError Message=Please use the Browse
button below to locate the newsletter file.

 /CFIF

 CFLOCK Scope=Session Type=Exclusive Timeout=10

CFSET Session.Newsletter.Newsletter_Title =
Form.Newsletter_Title
CFSET Session.Newsletter.Newsletter_Upload =
Form.Newsletter_Upload

 /CFLOCK

 CFLOCATION URL = "" AddToken=No

 CFCATCH Type=AddError

Error Message...

 /CFCATCH

/CFTRY

/CFIF

Thanks,

Rick

Rick Faircloth

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.241 / Virus Database: 262.10.1 - Release Date: 5/16/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: The never-ending windows

2004-05-17 Thread Scott Brady
Original Message:
 From: Chunshen (Don) Li 

  I'd say try the JS alerts I suggested in my last reply and make sure 
  that the iframe's src is being set. 
 Right on.err msg undefined.

I always make this mistake. Instead of doing the .src of the iframe, try the location.href of the iframe. (I never remember if it's the document.location.href or the .src)

i.e.:document.frames['loadFrame'].location.href = '';

(or whatever your frame's name is)

Scott

---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFX_IMAP with TLS support beta programme. Anyone interested?

2004-05-17 Thread Paul Vernon
Hi all,

 
I've just completed my alpha tests on a new version of CFX_IMAP4 that should
now support TLS based connections as well as the standard authentication
methods of CRAM-MD5, LOGIN and PLAIN.

 
My access to IMAP servers supporting TLS is limited and so I am looking for
people that would be interested in helping beta test. If anyone is
interested in joining a beta test programme for this tag then please mail me
off list and I can sort out distribution for a limited number of people.

 
For those that may be interested, the tag is Windows only, Delphi (C++
style) CFX. I would like to know what IMAP server you would be testing
against so that I can test the tag against as wider number of servers as
possible.

Thanks in advance

 
Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ColdFusion installation issue

2004-05-17 Thread Doug White
Been there done that - all services running - install log files show no errors
and still no joy

but thanks for the reply.

Doug



for some reason the CF Application Service was not restarted on mine, I had
to restart it and all was fine.

-Original Message-
To: CF-Talk
Subject: Re: ColdFusion installation issue

Re-Post

I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then
installed CFMX 6.1.I am not using Active Directory.

After going through the install chores, the installer notifies you that the
installation was successful and that CFMX administrator will then open in
the browser to complete the installation.The install log file shows no
errors.

This is where I ran into a problemWhen IE opens up and tries to open the
CFMX administrator page, it reports SERVICE NOT AVAILABLE

All files seem to be in the right place, and the ISAPI configuration appears
to be set up by the installer correctly.all the settings shown in the
exhibit
of Dave Watts paper on the Macromedia site appear to be in place.

Anyone have a clue as what I need to do to get this installation completed?

Thanks

Doug
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Deleted records being returned

2004-05-17 Thread Doug White
In VFP look at the commands

Set deleted() on(to filter deleted records)

PACK(this command will remove the deleted records permanently)

These commands only work within the VFP environment.If you do it via SQL, then
you must copy the records to another table (temp will do) with a Where not
deleted.Then delete the original table and rename the temp table to the same
name as the original.

==
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
==

Can someone please help???

 I am using Visual Fox Pro8 to create my dbf tables.
 I have created a connection on the server ODBC and referred to it in
 Coldfusion. The option for Deleted in the ODBC for VFP is not checked.


 When I retrieve the records, all records are return including the
 deleted ones.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ColdFusion installation issue

2004-05-17 Thread Adkins, Randy
Have you tried re-starting the World-wide web services from the IIS module?
Not from the services, but the IIS module?

-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 3:17 PM
To: CF-Talk
Subject: Re: ColdFusion installation issue

Been there done that - all services running - install log files show no
errors
and still no joy

but thanks for the reply.

Doug

for some reason the CF Application Service was not restarted on mine, I
had
to restart it and all was fine.

-Original Message-
To: CF-Talk
Subject: Re: ColdFusion installation issue

Re-Post

I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and
then
installed CFMX 6.1.I am not using Active Directory.

After going through the install chores, the installer notifies you that
the
installation was successful and that CFMX administrator will then open in
the browser to complete the installation.The install log file shows no
errors.

This is where I ran into a problemWhen IE opens up and tries to open the
CFMX administrator page, it reports SERVICE NOT AVAILABLE

All files seem to be in the right place, and the ISAPI configuration
appears
to be set up by the installer correctly.all the settings shown in the
exhibit
of Dave Watts paper on the Macromedia site appear to be in place.

Anyone have a clue as what I need to do to get this installation
completed?

Thanks

Doug 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




2 OnRequestEnd files

2004-05-17 Thread Doug James
Hello all,

I have an application residing in a subdirectory of my web root. Inside 
the application subdirectory I have my Application.cfm and 
OnRequestEnd.cfm files; my web root contains both files as well. As far 
as I can tell the webroot/Application.cfm is not processed (as I 
expect). But the webroot/OnRequestEnd.cfm is processed then my 
application/OnRequestEnd.cfm is processed, I thought that CFMX was only 
supposed to process my application/OnRequestEnd.cfm and then stop.

Processing steps (as I can determine)
1. application/Application.cfm
2. application code
3. webroot/OnRequestEnd.cfm
4. application/OnRequestEnd.cfm

Can someone please explain this to me or am I overlooking something 
plain and simple?

Thanks!

Doug
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ColdFusion installation issue

2004-05-17 Thread Dave Watts
 This is where I ran into a problemWhen IE opens up and 
 tries to open the CFMX administrator page, it reports 
 SERVICE NOT AVAILABLE

Is this all the page says? Did you install CFMX as a standalone server, or
on top of JRun? What happens if you just try to run your own CFM page?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Array question

2004-05-17 Thread Robert Orlini
Why can't I get a display of the fields I'm entering with this array? When I cfoutput the #arraylen(session.item)#its always 0 (zero).

CFIF Not IsDefined(Session.item)
CFSET session.item = arraynew(2)
/CFIF

CFIF isDefined(form.more.x)

CFSET itemcount = arraylen(session.item)
#arraylen(session.item)#
CFLOOP from=1 to=#arraylen(session.item)# index=i step=1
CFSET Session.item[itemcount+1][1]=form.qty
CFSET Session.item[itemcount+1][2]=form.item
CFSET Session.item[itemcount+1][3]=form.priceeach
#session.item[i][1]#br
#session.item[i][2]#br
#session.item[i][3]#br
/cfloop

/cfif
/CFOUTPUT

Robert Orlini
HW Wilson
718-588-8400 x2656
¿
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Weird CFHTTP Error....

2004-05-17 Thread Jeff Waris
Talk about a WEIRD error. I need some help getting to the bottom of this.

 
I have a custom tag being called to from a CFHTTP call with cfhttpparam form
variables.The server I am working on is CFMX 6.0. 

 
One way I call the tag it throws an error, but not out to the screen.
Looking at my logs this is what it is...

 
Error,jrpp-237,05/17/04,14:27:35,,Exception thrown by
error-handling template:
Error,jrpp-237,05/17/04,14:27:35,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
Error,jrpp-236,05/17/04,14:27:35,,Data source
HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03
HTTP_CONTENT_LENGTH:41333
HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u
rlencoded,trucated (this goes on for
about 30
lines).application/x-www-form-urlencoded
,app could not be found. The specific sequence of files included or
processed is: I:\CFusionMX\CustomTags\Interface\GetHistory.cfm 

Has anyone ever run into anything even remotely close to this??? Any help
would be greatly appreciated.

 
Thanks!
Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ColdFusion installation issue

2004-05-17 Thread Doug White
Yes I have - several times in fact - plus complete re-boots, still no joy

- 

Have you tried re-starting the World-wide web services from the IIS module?
Not from the services, but the IIS module?

Been there done that - all services running - install log files show no
errors
and still no joy

but thanks for the reply.

Doug

 for some reason the CF Application Service was not restarted on mine, I
had
 to restart it and all was fine.

 -Original Message-
 To: CF-Talk
 Subject: Re: ColdFusion installation issue

 Re-Post

 I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and
then
 installed CFMX 6.1.I am not using Active Directory.

 After going through the install chores, the installer notifies you that
the
 installation was successful and that CFMX administrator will then open in
 the browser to complete the installation.The install log file shows no
errors.

 This is where I ran into a problemWhen IE opens up and tries to open the
 CFMX administrator page, it reports SERVICE NOT AVAILABLE

 All files seem to be in the right place, and the ISAPI configuration
appears
 to be set up by the installer correctly.all the settings shown in the
exhibit
 of Dave Watts paper on the Macromedia site appear to be in place.

 Anyone have a clue as what I need to do to get this installation
completed?

 Thanks

 Doug 
 _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ColdFusion installation issue

2004-05-17 Thread Doug White
Hi Dave;

That is all the page says.Since Admin will not run, the scripts required to
complete the install have also not yet run.Consequently CFM pages will not run
either

The install log shows no errors - all stopped services are restarted as they
should be.

The install was NOT a standalone but on IIS/JRUN


 This is where I ran into a problemWhen IE opens up and
 tries to open the CFMX administrator page, it reports
 SERVICE NOT AVAILABLE

Is this all the page says? Did you install CFMX as a standalone server, or
on top of JRun? What happens if you just try to run your own CFM page?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Array question

2004-05-17 Thread Bryan F. Hogan
Because arrayLen(session.item) is 0 and your looping from 
1-arrayLen(session.item). If your just trying to add an item to the 
array from a form post just use the following.

cfif not isDefined('session.item')
	cfset session.item=arrayNew(2)
/cfif

cfset arrayLength=arrayLen(session.item)
cfset session.item[variables.arrayLength+1][1]='qty'
cfset session.item[variables.arrayLength+1][2]='item'
cfset session.item[variables.arrayLength+1][3]='price'

cfoutput#arrayLen(session.item)#/cfoutput
cfdump var=#session.item#
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How to validate form variables with this method including Encoding: multi-part/form-data

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
Well, one thing to remember is that with CFFILE, you don't get physical access to the upload, other than the fact that you know info about it (filename, size, etc).

So, you could pass that info in a field on to the next page, for example.

The fact the cffile handles the upload for you is all you care about; once you have the name of the file, and size (for example), you really don't need anything else at that point.

If you need to validate the file itself, you can do that, by doing your compare against the cffile variables (you might wanna only allow certain filetypes for example).

I would recommend you working some client side validated into the process.It would save the user some time if the process was never allowed to happen server side at all if they hadn't done everything they needed to submit (e.g. use REQUIRED, or _javascript_).

Another thing is that you don't need to do any cflocation either, or use the session scope if after the validation, you just included your data posting, and thus you'd be able to eleviate a hassle (in passing that info around).

Robert

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 12:42 P
To: CF-Talk
Subject: How to validate form variables with this method including
Encoding: multi-part/form-data

Hi, all...

I know the subject is unclear, but here's the situation.

I'm using CF 4.5...

I validate formfields by submitting a form back to the page containing the
form
and using CFTRY / CFCATCH, then, if everything passes validation, setting
the form variables to session variables and then using CFLOCATION to pass
them to an action page for processing.

I haven't, to this point, used this method, with a from that contains a file
upload field.

Typically, with a form that contains a file upload field, I just don't
validate the fields.
I would, however, like to start validating all form submissions, even those
that contain
file upload fields.

The main question is...how would I pass on the Encoding type:
multipart/form-date specification
through the form page itself during verification then send that encoding
info along with the session
variables to the processing page using my typical CFLOCATION
URL="" ?

Here's the code I've set up so far to validate the form entries...

CFIF IsDefined(Form.Submit)

CFTRY

 CFIF Form.Newsletter_Title is 

CFTHROW Type=AddError Message=Please enter a title for
the newsletter.

 /CFIF

 CFIF Form.Newsletter_Upload is 

CFTHROW Type=AddError Message=Please use the Browse
button below to locate the newsletter file.

 /CFIF

 CFLOCK Scope=Session Type=Exclusive Timeout=10

CFSET Session.Newsletter.Newsletter_Title =
Form.Newsletter_Title
CFSET Session.Newsletter.Newsletter_Upload =
Form.Newsletter_Upload

 /CFLOCK

 CFLOCATION URL = "" AddToken=No

 CFCATCH Type=AddError

Error Message...

 /CFCATCH

/CFTRY

/CFIF

Thanks,

Rick

Rick Faircloth

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.241 / Virus Database: 262.10.1 - Release Date: 5/16/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: 2 OnRequestEnd files

2004-05-17 Thread Barney Boisvert
Do you have a cfinclude template=../OnRequestEnd.cfm / in your approot's
OnRequestEnd.cfm to chain them together?

OnRequestEnd.cfm should only be processed for the directory that contains
Application.cfm.There isn't a directory tree parse for OnRequestEnd.cfm,
it uses the one that was performed for Application.cfm.

 -Original Message-
 From: Doug James [mailto:[EMAIL PROTECTED] 
 Sent: Monday, May 17, 2004 12:33 PM
 To: CF-Talk
 Subject: 2 OnRequestEnd files
 
 Hello all,
 
 I have an application residing in a subdirectory of my web 
 root. Inside 
 the application subdirectory I have my Application.cfm and 
 OnRequestEnd.cfm files; my web root contains both files as 
 well. As far 
 as I can tell the webroot/Application.cfm is not processed (as I 
 expect). But the webroot/OnRequestEnd.cfm is processed then my 
 application/OnRequestEnd.cfm is processed, I thought that 
 CFMX was only 
 supposed to process my application/OnRequestEnd.cfm and then stop.
 
 Processing steps (as I can determine)
 1. application/Application.cfm
 2. application code
 3. webroot/OnRequestEnd.cfm
 4. application/OnRequestEnd.cfm
 
 Can someone please explain this to me or am I overlooking something 
 plain and simple?
 
 Thanks!
 
 Doug
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How to validate form variables with this method including Encoding: multi-part/form-data

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
I'm not entirely sure why you feel you can't validate that encoding type; the only difference is that it allows UPLOADING.So you can't validate that one field; you can still do the same thing (validate) with all of your other fields.

One thing to remember is that with CFFILE, you don't get physical access to the upload, other than the fact that you know info about it (filename, size, etc).

So, you could pass that info in a field on to the next page, for example.

The fact the cffile handles the upload for you is all you care about; once you have the name of the file, and size (for example), you really don't need anything else at that point.

If you need to validate data about the file upload itself, you can do that by doing your compare against the cffile variables (you might wanna only allow certain filetypes for example).

I would recommend you working some client side validation into the process.It would save the user some time if the process was never allowed to happen server side at all if they hadn't done everything they needed to submit (e.g. use REQUIRED, or _javascript_).

Another thing is that you don't need to do any cflocation either, or use the session scope if after the validation, you just included your data posting, and thus you'd be able to alleviate a hassle (in passing that info around).

Robert

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 12:42 P
To: CF-Talk
Subject: How to validate form variables with this method including
Encoding: multi-part/form-data

Hi, all...

I know the subject is unclear, but here's the situation.

I'm using CF 4.5...

I validate formfields by submitting a form back to the page containing the
form
and using CFTRY / CFCATCH, then, if everything passes validation, setting
the form variables to session variables and then using CFLOCATION to pass
them to an action page for processing.

I haven't, to this point, used this method, with a from that contains a file
upload field.

Typically, with a form that contains a file upload field, I just don't
validate the fields.
I would, however, like to start validating all form submissions, even those
that contain
file upload fields.

The main question is...how would I pass on the Encoding type:
multipart/form-date specification
through the form page itself during verification then send that encoding
info along with the session
variables to the processing page using my typical CFLOCATION
URL="" ?

Here's the code I've set up so far to validate the form entries...

CFIF IsDefined(Form.Submit)

CFTRY

 CFIF Form.Newsletter_Title is 

CFTHROW Type=AddError Message=Please enter a title for
the newsletter.

 /CFIF

 CFIF Form.Newsletter_Upload is 

CFTHROW Type=AddError Message=Please use the Browse
button below to locate the newsletter file.

 /CFIF

 CFLOCK Scope=Session Type=Exclusive Timeout=10

CFSET Session.Newsletter.Newsletter_Title =
Form.Newsletter_Title
CFSET Session.Newsletter.Newsletter_Upload =
Form.Newsletter_Upload

 /CFLOCK

 CFLOCATION URL = "" AddToken=No

 CFCATCH Type=AddError

Error Message...

 /CFCATCH

/CFTRY

/CFIF
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Array question

2004-05-17 Thread Robert Orlini
Thank you. One more ?: How do I clear the array to start over?

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 3:50 PM
To: CF-Talk
Subject: Re: Array question

Because arrayLen(session.item) is 0 and your looping from 
1-arrayLen(session.item). If your just trying to add an item to the 
array from a form post just use the following.

cfif not isDefined('session.item')
cfset session.item=arrayNew(2)
/cfif

cfset arrayLength=arrayLen(session.item)
cfset session.item[variables.arrayLength+1][1]='qty'
cfset session.item[variables.arrayLength+1][2]='item'
cfset session.item[variables.arrayLength+1][3]='price'

cfoutput#arrayLen(session.item)#/cfoutput
cfdump var=#session.item# 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Using recursion with query results

2004-05-17 Thread nancy . tracy
I'm trying to build a recursive routine that will go through my query
results and display them in a tree structure.There are four fields in each
row of my results.Is it possible for me to pass an entire row of my query
results to a custom tag?If so, when I come back out of my recursive
routine, will CF know that that row has been processed?Or is it best for
me to throw all my query results into a structure then run the recursive
routine?

I've done this in ASP, but I'm at a loss in ColdFusion.I know this should
be easy, but

Nancy P. Tracy
Electrical Design and Web Development
GE Global Controls Services
3800 N. Wilson Ave.
Loveland, CO 80538
970.461.5273
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Weird CFHTTP Error....

2004-05-17 Thread Jeff Waris
This is in the exception log if it helps anyone answer the question.

 at coldfusion.tagext.sql.QueryTag.doStartTag(Unknown Source)
 at
cfIRBGetHistory2ecfm1907956765._factor0(I:\CFusionMX\CustomTags\Interface\IR
BGetHistory.cfm:22)
 at
cfIRBGetHistory2ecfm1907956765.runPage(I:\CFusionMX\CustomTags\Interface\IRB
GetHistory.cfm:272)
 at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
 at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
 at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
 at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
 at coldfusion.filter.PathFilter.invoke(Unknown Source)
 at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
 at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
 at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
 at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
 at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
 at coldfusion.CfmServlet.service(Unknown Source)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
 at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
 at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
 at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
 at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
 at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
coldfusion.runtime.UndefinedElementException: Element SQL is undefined in
ERROR.
 at coldfusion.runtime.DotResolver.resolve(Unknown Source)
 at coldfusion.runtime.CfJspPage._resolve(Unknown Source)
 at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(Unknown Source)
 at
cfDatabaseException2ecfm813111904.runPage(I:\CFusionMX\wwwroot\WEB-INF\excep
tion\coldfusion\runtime\DatabaseException.cfm:13)
 at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
 at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
 at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
 at coldfusion.filter.CfincludeFilter.include(Unknown Source)
 at coldfusion.filter.ExceptionFilter.runBuiltInHandler(Unknown Source)
 at coldfusion.filter.ExceptionFilter.handleException(Unknown Source)
 at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
 at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
 at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
 at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
 at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
 at coldfusion.CfmServlet.service(Unknown Source)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
 at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
 at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
 at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
 at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
 at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Jeff



-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 3:21 PM
To: CF-Talk
Subject: Weird CFHTTP Error

Talk about a WEIRD error. I need some help getting to the bottom of this.

I have a custom tag being called to from a CFHTTP call with cfhttpparam form
variables.The server I am working on is CFMX 6.0. 

One way I call the tag it throws an error, but not out to the screen.
Looking at my logs this is what it is...

Error,jrpp-237,05/17/04,14:27:35,,Exception thrown by
error-handling template:
Error,jrpp-237,05/17/04,14:27:35,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
Error,jrpp-236,05/17/04,14:27:35,,Data source
HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03
HTTP_CONTENT_LENGTH:41333
HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u
rlencoded,trucated (this goes on for
about 30
lines).application/x-www-form-urlencoded
,app could not be found. The specific sequence of files 

RE: Using recursion with query results

2004-05-17 Thread Barney Boisvert
If you're tree-ing the recordset, I assume that you have a itemID/parentID
field coupling?Here's the basic algorithm that I use to perform such a
convertion:

cffunction name=makeTree
cfargument name=rs /
cfargument name=parentID default= /
cfargument name=level default=0 /
cfloop query=rs
 cfif rs.parentID EQ parentID
cfoutput#repeatString(nbsp; , level)##rs.name#br //cfoutput
cfset makeTree(rs, itemID, level + 1) /
 /cfif
/cfloop
/cffunction

Keep in mind that this isn't particularly efficient (even with optimization)
and that you should try to cache the generated tree in some form or another,
rather than regenerating it every request.If you need to generate it every
request, then you're probably better of using a different storage mechanism
(the Nested Set Model, is one).

Cheers,
barneyb

Cheers
barneyb

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Monday, May 17, 2004 1:12 PM
 To: CF-Talk
 Subject: Using recursion with query results
 
 I'm trying to build a recursive routine that will go through my query
 results and display them in a tree structure.There are four 
 fields in each
 row of my results.Is it possible for me to pass an entire 
 row of my query
 results to a custom tag?If so, when I come back out of my recursive
 routine, will CF know that that row has been processed?Or 
 is it best for
 me to throw all my query results into a structure then run 
 the recursive
 routine?
 
 I've done this in ASP, but I'm at a loss in ColdFusion.I 
 know this should
 be easy, but
 
 Nancy P. Tracy
 Electrical Design and Web Development
 GE Global Controls Services
 3800 N. Wilson Ave.
 Loveland, CO 80538
 970.461.5273
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Weird CFHTTP Error....

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
I can't say for sure, but it looks like your Error handler is throwing an error.

-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 3:58 P
To: CF-Talk
Subject: RE: Weird CFHTTP Error

This is in the exception log if it helps anyone answer the question.

 at coldfusion.tagext.sql.QueryTag.doStartTag(Unknown Source)
 at
cfIRBGetHistory2ecfm1907956765._factor0(I:\CFusionMX\CustomTags\Interface\IR
BGetHistory.cfm:22)
 at
cfIRBGetHistory2ecfm1907956765.runPage(I:\CFusionMX\CustomTags\Interface\IRB
GetHistory.cfm:272)
 at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
 at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
 at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
 at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
 at coldfusion.filter.PathFilter.invoke(Unknown Source)
 at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
 at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
 at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
 at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
 at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
 at coldfusion.CfmServlet.service(Unknown Source)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
 at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
 at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
 at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
 at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
 at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
coldfusion.runtime.UndefinedElementException: Element SQL is undefined in
ERROR.
 at coldfusion.runtime.DotResolver.resolve(Unknown Source)
 at coldfusion.runtime.CfJspPage._resolve(Unknown Source)
 at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(Unknown Source)
 at
cfDatabaseException2ecfm813111904.runPage(I:\CFusionMX\wwwroot\WEB-INF\excep
tion\coldfusion\runtime\DatabaseException.cfm:13)
 at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
 at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
 at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
 at coldfusion.filter.CfincludeFilter.include(Unknown Source)
 at coldfusion.filter.ExceptionFilter.runBuiltInHandler(Unknown Source)
 at coldfusion.filter.ExceptionFilter.handleException(Unknown Source)
 at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
 at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
 at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
 at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
 at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
 at coldfusion.CfmServlet.service(Unknown Source)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
 at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
 at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
 at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
 at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
 at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Jeff



-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 3:21 PM
To: CF-Talk
Subject: Weird CFHTTP Error

Talk about a WEIRD error. I need some help getting to the bottom of this.

I have a custom tag being called to from a CFHTTP call with cfhttpparam form
variables.The server I am working on is CFMX 6.0. 

One way I call the tag it throws an error, but not out to the screen.
Looking at my logs this is what it is...

Error,jrpp-237,05/17/04,14:27:35,,Exception thrown by
error-handling template:
Error,jrpp-237,05/17/04,14:27:35,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
Error,jrpp-236,05/17/04,14:27:35,,Data source
HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03
HTTP_CONTENT_LENGTH:41333

Re: Array question

2004-05-17 Thread Bryan F. Hogan
Use arrayClear(session.item) or just reset the array cfset 
session.item=arrayNew(2)

Robert Orlini wrote:
 Thank you. One more ?: How do I clear the array to start over?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Using recursion with query results

2004-05-17 Thread Ian Skinner
I think your friend may be the array notion for a ColdFusion record set.Try playing with these and see if this doesn't lead somewhere.

 
The following forms are perfectly legal ways to reference record sets.

 
query.columnName[row]
query[columnName][row]

 
Also if you are using a cfoutput query= or a cfloop query= #currentRow# is a system variable of the current row (duh) that the loop is in.

 
Hopefully these will get you on the right track.

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Weird CFHTTP Error....

2004-05-17 Thread Maureen
At 03:58 PM 5/17/04, Jeff wrote:
This is in the exception log if it helps anyone answer the question.

Looks like the query being called by the CFHTTP tagisn't finding a 
valid data source, or the data source isn't finding the database, or the 
query in question isn't a valid SQL query.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: 2 OnRequestEnd files

2004-05-17 Thread Doug James
Thank you, Barney!

I knew it was something so plain and simple. Right before my eyes and I 
did not see it, my wife would roll her eyes if she knew.

Thanks again.

Doug

Barney Boisvert wrote:

Do you have a cfinclude template=../OnRequestEnd.cfm / in your approot's
OnRequestEnd.cfm to chain them together?

OnRequestEnd.cfm should only be processed for the directory that contains
Application.cfm.There isn't a directory tree parse for OnRequestEnd.cfm,
it uses the one that was performed for Application.cfm.



-Original Message-
From: Doug James [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 12:33 PM
To: CF-Talk
Subject: 2 OnRequestEnd files

Hello all,

I have an application residing in a subdirectory of my web 
root. Inside 
the application subdirectory I have my Application.cfm and 
OnRequestEnd.cfm files; my web root contains both files as 
well. As far 
as I can tell the webroot/Application.cfm is not processed (as I 
expect). But the webroot/OnRequestEnd.cfm is processed then my 
application/OnRequestEnd.cfm is processed, I thought that 
CFMX was only 
supposed to process my application/OnRequestEnd.cfm and then stop.

Processing steps (as I can determine)
1. application/Application.cfm
2. application code
3. webroot/OnRequestEnd.cfm
4. application/OnRequestEnd.cfm

Can someone please explain this to me or am I overlooking something 
plain and simple?

Thanks!

Doug


 



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Weird CFHTTP Error....

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
Sorry, I meant to post more, and hit send accidentally!

Looks like:
4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
coldfusion.runtime.UndefinedElementException: Element SQL is undefined in
ERROR.

Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps:

#ERROR.SQL# 

or something like it.

Without code to look at, its hard to say.

If that is the case, thats not valid, since in the ERROR scope that variable isn't present.

TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself.

Robert
-Original Message-
From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 
Sent: Monday, May 17, 2004 4:19 P
To: CF-Talk
Subject: RE: Weird CFHTTP Error

I can't say for sure, but it looks like your Error handler is throwing an error.

-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 3:58 P
To: CF-Talk
Subject: RE: Weird CFHTTP Error

This is in the exception log if it helps anyone answer the question.

 at coldfusion.tagext.sql.QueryTag.doStartTag(Unknown Source)
 at
cfIRBGetHistory2ecfm1907956765._factor0(I:\CFusionMX\CustomTags\Interface\IR
BGetHistory.cfm:22)
 at
cfIRBGetHistory2ecfm1907956765.runPage(I:\CFusionMX\CustomTags\Interface\IRB
GetHistory.cfm:272)
 at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
 at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
 at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
 at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
 at coldfusion.filter.PathFilter.invoke(Unknown Source)
 at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
 at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
 at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
 at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
 at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
 at coldfusion.CfmServlet.service(Unknown Source)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
 at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
 at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
 at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
 at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
 at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
coldfusion.runtime.UndefinedElementException: Element SQL is undefined in
ERROR.
 at coldfusion.runtime.DotResolver.resolve(Unknown Source)
 at coldfusion.runtime.CfJspPage._resolve(Unknown Source)
 at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(Unknown Source)
 at
cfDatabaseException2ecfm813111904.runPage(I:\CFusionMX\wwwroot\WEB-INF\excep
tion\coldfusion\runtime\DatabaseException.cfm:13)
 at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
 at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
 at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
 at coldfusion.filter.CfincludeFilter.include(Unknown Source)
 at coldfusion.filter.ExceptionFilter.runBuiltInHandler(Unknown Source)
 at coldfusion.filter.ExceptionFilter.handleException(Unknown Source)
 at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
 at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
 at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
 at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
 at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
 at coldfusion.CfmServlet.service(Unknown Source)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
 at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
 at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
 at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
 at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
 at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Jeff



-Original Message-
From: Jeff Waris [mailto:[EMAIL 

RE: 2 OnRequestEnd files

2004-05-17 Thread Douglas.Knudsen
check out
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/appfra11.htm

Doug

-Original Message-
From: Doug James [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 3:33 PM
To: CF-Talk
Subject: 2 OnRequestEnd files

Hello all,

I have an application residing in a subdirectory of my web root. Inside 
the application subdirectory I have my Application.cfm and 
OnRequestEnd.cfm files; my web root contains both files as well. As far 
as I can tell the webroot/Application.cfm is not processed (as I 
expect). But the webroot/OnRequestEnd.cfm is processed then my 
application/OnRequestEnd.cfm is processed, I thought that CFMX was only 
supposed to process my application/OnRequestEnd.cfm and then stop.

Processing steps (as I can determine)
1. application/Application.cfm
2. application code
3. webroot/OnRequestEnd.cfm
4. application/OnRequestEnd.cfm

Can someone please explain this to me or am I overlooking something 
plain and simple?

Thanks!

Doug 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Weird CFHTTP Error....

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
Sorry, I meant to post more, and hit send accidentally!

Looks like:
4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in
ERROR. The specific sequence of files included or processed is:
I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException.
cfm 
coldfusion.runtime.UndefinedElementException: Element SQL is undefined in
ERROR.

Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps:

#ERROR.SQL# 

or something like it.

Without code to look at, its hard to say.

If that is the case, thats not valid, since in the ERROR scope that variable isn't present.

TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself.

Robert
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: How to validate form variables with this method including Encoding: multi-part/form-data

2004-05-17 Thread Matt Robertson
Rick,

Why are you doing that cflocation to finish processing?Why not do your form processing right then and there on the current template?

Not that everyone has to do it this way, but I typically build a form where it submits to itself and, 1)validates 2)processes and 3)proceeds (i.e. [b]thanks for filling out the form.We love you.[/b].

If I had form processing code that needed to be shared with something else (maybe thats why you're doing the cflocation?) I would use an include or a cfmodule call.


--
---
 Matt Robertson,[EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---

--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Maxing out running requests then server hanging -- Help

2004-05-17 Thread Dave Carabetta
  We had similar problems that were resolved by reverting the
  6.1 database drivers to the 6.0+ version available at the
  related TechNote
  (http://www.macromedia.com/support/coldfusion/ts/documents/cfm
  x61_sqlserver_cpu.htm).
  Unfortunately, MM has removed the 6.0+ drivers in that
  TechNote and replaced the download to point to the new
  DataDirect 3.3 drivers. Perhaps you'll have luck with those,
  but we continued to have problems, so we're still on the 6.0+
  drivers.

Out of curiosity, are you having the same problems with the 3.3 drivers 
that
you were with the 3.2 drivers? What database server are you using?

No, it was a different problem. We started getting loads of this message in 
our log files:

removeOnExceptions is true for XXX, closed the physical Connection

where XXX is the datasource name defined in the MX Administrator (MX for 
J2EE for JRun on Solaris with Oracle 8i/9i). After a period of a few hours, 
the JRun process would send the system load through the roof (95-99% CPU 
usage) and the only way to stop it was by doing a kill -9 (jrun stop 
servername would just time out).


For our SQL Server clients, we've successfully deployed the MS JDBC drivers
in some cases.

We're an Oracle shop (8i/9i), so I unfortunately can't test againt SQL 
Server. All this being said, I haven't had much time to go back and do 
research into what was causing my problems.

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Regular Expression Help

2004-05-17 Thread Ian
I'm trying to parse a string and pluck a bit of text, but my regex
isn't working :( Here's a sample string:

(msg:My Message Here; content:My Content Here;)

I want to return My Message Here.

And here's my regex:

refindnocase(msg:[[:print:]]+;, mystring)

I'm using print as mystring may contain any printable characters.

This returns 0 as the position. Any ideas?

Ian
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ColdFusion installation issue

2004-05-17 Thread Dave Watts
 That is all the page says.Since Admin will not run, the 
 scripts required to complete the install have also not yet 
 run.Consequently CFM pages will not run either
 
 The install log shows no errors - all stopped services are 
 restarted as they should be.
 
 The install was NOT a standalone but on IIS/JRUN

I would recommend that you enable the JRun web server, then finish the
installation process using that. Then, run the web server configuration
tool, remove the existing configuration, and recreate it.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How to validate form variables with this method including Encoding: multi-part/form-data

2004-05-17 Thread Rick Faircloth
Hi, Robert, and thanks for the reply...

It's not so much a matter of validating the encoding type,
but including the multi-part/form-data as part of the Form specifications
when the form data is passed for processing...

I'll give your ideas some thought...

Thanks,

Rick

-Original Message-
From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 4:10 PM
To: CF-Talk
Subject: RE: How to validate form variables with this method including
Encoding: multi-part/form-data

I'm not entirely sure why you feel you can't validate that encoding type;
the only difference is that it allows UPLOADING.So you can't validate that
one field; you can still do the same thing (validate) with all of your other
fields.

One thing to remember is that with CFFILE, you don't get physical access
to the upload, other than the fact that you know info about it (filename,
size, etc).

So, you could pass that info in a field on to the next page, for example.

The fact the cffile handles the upload for you is all you care about; once
you have the name of the file, and size (for example), you really don't need
anything else at that point.

If you need to validate data about the file upload itself, you can do that
by doing your compare against the cffile variables (you might wanna only
allow certain filetypes for example).

I would recommend you working some client side validation into the
process.It would save the user some time if the process was never allowed
to happen server side at all if they hadn't done everything they needed to
submit (e.g. use REQUIRED, or _javascript_).

Another thing is that you don't need to do any cflocation either, or use
the session scope if after the validation, you just included your data
posting, and thus you'd be able to alleviate a hassle (in passing that info
around).

Robert

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 12:42 P
To: CF-Talk
Subject: How to validate form variables with this method including
Encoding: multi-part/form-data

Hi, all...

I know the subject is unclear, but here's the situation.

I'm using CF 4.5...

I validate formfields by submitting a form back to the page containing the
form
and using CFTRY / CFCATCH, then, if everything passes validation, setting
the form variables to session variables and then using CFLOCATION to pass
them to an action page for processing.

I haven't, to this point, used this method, with a from that contains a
file
upload field.

Typically, with a form that contains a file upload field, I just don't
validate the fields.
I would, however, like to start validating all form submissions, even
those
that contain
file upload fields.

The main question is...how would I pass on the Encoding type:
multipart/form-date specification
through the form page itself during verification then send that encoding
info along with the session
variables to the processing page using my typical CFLOCATION
URL="" ?

Here's the code I've set up so far to validate the form entries...

CFIF IsDefined(Form.Submit)

 CFTRY

CFIF Form.Newsletter_Title is 

CFTHROW Type=AddError Message=Please enter a title for
the newsletter.

/CFIF

CFIF Form.Newsletter_Upload is 

CFTHROW Type=AddError Message=Please use the Browse
button below to locate the newsletter file.

/CFIF

CFLOCK Scope=Session Type=Exclusive Timeout=10

CFSET Session.Newsletter.Newsletter_Title =
Form.Newsletter_Title
CFSET Session.Newsletter.Newsletter_Upload =
Form.Newsletter_Upload

/CFLOCK

CFLOCATION URL = "" AddToken=No

CFCATCH Type=AddError

 Error Message...

/CFCATCH

 /CFTRY

/CFIF
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Regular Expression Help

2004-05-17 Thread Marlon Moyer
This should work.

cfset test = (msg:My Message Here; content:My Content Here;)

cfset temp = refindnocase(msg:([^;]*),test,1,yes)

cfloop from=1 to=#arraylen(temp.pos)# index=i
	cfoutput#mid(test,temp.pos[i],temp.len[i])#br/cfoutput
/cfloop

-- 
Marlon Moyer, Sr. Internet Developer
American Contractors Insurance Group
phone: 972.687.9445
fax: 972.687.0607
mailto:[EMAIL PROTECTED]
www.acig.com

 -Original Message-
 From: Ian [mailto:[EMAIL PROTECTED]
 Sent: Monday, May 17, 2004 3:39 PM
 To: CF-Talk
 Subject: Regular _expression_ Help
 
 I'm trying to parse a string and pluck a bit of text, but my regex
 isn't working :( Here's a sample string:
 
 (msg:My Message Here; content:My Content Here;)
 
 I want to return My Message Here.
 
 And here's my regex:
 
 refindnocase(msg:[[:print:]]+;, mystring)
 
 I'm using print as mystring may contain any printable characters.
 
 This returns 0 as the position. Any ideas?
 
 Ian
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Importing Outlook exports

2004-05-17 Thread stas
I am writing a simple contact management app and one specific request is to
be able to map files from Outlook export( csv or tab) to our internal data
fields. Conceptually, this is very simple, but I running into some nasty
Outlook formatting issues. Has anyone successfully done something like this
in CF? Thanks!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How to validate form variables with this method including Encoding: multi-part/form-data

2004-05-17 Thread Rick Faircloth
Hi, Matt, and thanks for the reply...

This was a technique that I read about on this list that someone
was using.Since I'm not a _javascript_er it allowed validation
without CFFORM or CFINPUT's and not having the user leave the
form entry page.

The form does submit back to the same page, then runs through
the cftry's and then, if everything passes validation, I convert the
form variables to session variables and send them via cflocation
to an action page for processing.I could have the
processing (inserting, updating, etc.) happen on the same page
as the validation and then send the user to a Submission Successful page
that doesn't process anything, but just let's the user know that everything
went through without a problem.

That way I could avoid using the session variables, which is not a problem,
but more coding, and could also solve the problem of specifying the
multipart/form-data
specification for the submission, since it would be submitted to the
processing page.

Sounds like your idea of keeping the processing on the same page
as the submission is much simpler...

Any other thoughts?

Thanks for your help...

Rick

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 4:35 PM
To: CF-Talk
Subject: Re: How to validate form variables with this method including
Encoding: multi-part/form-data

Rick,

Why are you doing that cflocation to finish processing?Why not do your
form processing right then and there on the current template?

Not that everyone has to do it this way, but I typically build a form
where it submits to itself and, 1)validates 2)processes and 3)proceeds (i.e.
[b]thanks for filling out the form.We love you.[/b].

If I had form processing code that needed to be shared with something else
(maybe thats why you're doing the cflocation?) I would use an include or a
cfmodule call.

--
---
Matt Robertson,[EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
---

--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ColdFusion installation issue

2004-05-17 Thread Doug White
I know how to do the WSCONFIG but how do I enable the Jrun server?

 That is all the page says.Since Admin will not run, the 
 scripts required to complete the install have also not yet 
 run.Consequently CFM pages will not run either
 
 The install log shows no errors - all stopped services are 
 restarted as they should be.
 
 The install was NOT a standalone but on IIS/JRUN

I would recommend that you enable the JRun web server, then finish the
installation process using that. Then, run the web server configuration
tool, remove the existing configuration, and recreate it.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




DataDirect 3.3 bug with Oracle? (was RE: Maxing out running requests...)

2004-05-17 Thread Dave Carabetta
  We had similar problems that were resolved by reverting the
  6.1 database drivers to the 6.0+ version available at the
  related TechNote
  (http://www.macromedia.com/support/coldfusion/ts/documents/cfm
  x61_sqlserver_cpu.htm).
  Unfortunately, MM has removed the 6.0+ drivers in that
  TechNote and replaced the download to point to the new
  DataDirect 3.3 drivers. Perhaps you'll have luck with those,
  but we continued to have problems, so we're still on the 6.0+
  drivers.

Out of curiosity, are you having the same problems with the 3.3 drivers 
that
you were with the 3.2 drivers? What database server are you using?

For our SQL Server clients, we've successfully deployed the MS JDBC drivers
in some cases.


Just as a quick follow-up, I have isolated down the scenario that creates 
the removeOnExceptions warning. If I use the cftransaction tag around my 
queries, the warning is thrown. If I don't, no warning appears. Any idea 
what the issue might be? Is this a bug I need to follow up with Macromedia?

As a test with Oracle 8i/9i:

cftransaction action="">
cfquery name=get datasource=myDSN
SELECT sysdate
FROM dual
/cfquery

cfquery name=get2 datasource=myDSN
SELECT sysdate
FROM dual
/cfquery
/cftransaction

cfdump var=#get# expand=Yes /
cfdump var=#get2# expand=Yes /

This will throw the following warning to my log file:

removeOnExceptions is true for myDSN, closed the physical Connection

If I comment out the cftransaction tags, nothing is thrown.

As I said, over time and under load this eventually brings the instance to a 
grind.

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ColdFusion installation issue

2004-05-17 Thread Dave Watts
 I know how to do the WSCONFIG but how do I enable the 
 Jrun server?

http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_
webserver/

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




  1   2   >