RE: SQL HELP!

2004-05-21 Thread Pascal Peters
Ascension day.

> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED] 
> Sent: vrijdag 21 mei 2004 3:07
> To: CF-Talk
> Subject: RE: SQL HELP!
> 
> what holiday?
> 
> tony
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




XPath Help

2004-05-21 Thread Tony Pimm
Hi, I'm trying to get some XPath to work with respect to a navigation tree.



	
		
		
		
		
		
	
	
	
		
		
		
	
	
	


I can use Xpath to return all the child nodes within a node using 
//[EMAIL PROTECTED]"3"]

However, how can I do this in reverse?  How can I retrieve the node that is the parent of a particular node?  How can I get the objectid of the parent of 2134?

Any help you could share would be great!
Thanks
Tony
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Homesite Resource Window

2004-05-21 Thread Tangorre, Michael
My resource window in homesite became undocked somehow.. anyone know how to
dock it?

 
Thanks,

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




RE: Homesite Resource Window

2004-05-21 Thread Nando
Try View > Resource Tab?

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 1:08 PM
To: CF-Talk
Subject: Homesite Resource Window

My resource window in homesite became undocked somehow.. anyone know how to
dock it?

Thanks,

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




Selecting by row or CurrentRow

2004-05-21 Thread Nando
Could someone remind me of the syntax to select by row? I don't remember where to find
that. Thanx

Select * From qProduct
Where CurrentRow = #theRowIWant#
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Homesite Resource Window

2004-05-21 Thread d.a.collie
>> My resource window in homesite became undocked somehow.. anyone know
how to dock it?

Double clicking the title bar works in CF Studio if you undock any of
tabs, if that helps

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




RE: Homesite Resource Window

2004-05-21 Thread Tangorre, Michael
Nope... That won't re-dock it.  :-(

It is so annoying. It would be nice if you dragged it to the edge and it
snapped in place, but that is just wishful thinking.

Mike 

> -Original Message-
> From: Nando [mailto:[EMAIL PROTECTED] 
> Sent: Friday, May 21, 2004 7:09 AM
> To: CF-Talk
> Subject: RE: Homesite Resource Window
> 
> Try View > Resource Tab?
> 
> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 21, 2004 1:08 PM
> To: CF-Talk
> Subject: Homesite Resource Window
> 
> 
> My resource window in homesite became undocked somehow.. 
> anyone know how to dock it?
> 
> Thanks,
> 
> Mike
> 
> 
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Homesite Resource Window

2004-05-21 Thread Tangorre, Michael
> Double clicking the title bar works in CF Studio if you 
> undock any of tabs, if that helps

Nope. That does not work either.  :-(
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Homesite Resource Window

2004-05-21 Thread Nando
It's happened to me several times ... i got it back somehow.

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 1:17 PM
To: CF-Talk
Subject: RE: Homesite Resource Window

Nope... That won't re-dock it.  :-(

It is so annoying. It would be nice if you dragged it to the edge and it
snapped in place, but that is just wishful thinking.

Mike

> -Original Message-
> From: Nando [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 21, 2004 7:09 AM
> To: CF-Talk
> Subject: RE: Homesite Resource Window
>
> Try View > Resource Tab?
>
> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 21, 2004 1:08 PM
> To: CF-Talk
> Subject: Homesite Resource Window
>
>
> My resource window in homesite became undocked somehow..
> anyone know how to dock it?
>
> Thanks,
>
> Mike
>
>
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread Nathan R. Jessop
Could you give an example?

On Thu, 20 May 2004 15:08:40 -0400, Philip Arnold wrote:

>> From: Nathan R. Jessop
>> 
>> I don't want to use a database because of oeverhead.
>
>In which case, keep a list of items as you write them out, and before
>you do the next one, check that it's not in the list
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Homesite Resource Window (SOLVED)

2004-05-21 Thread Tangorre, Michael
Left click in the floating window. Hold down shift while right clicking...
Select the "move to" option (top, bottom, left, right). Do that for each
resource tab What a stupid way of doing it!!!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread d.a.collie
>In which case, keep a list of items as you write them out, and before 
>you do the next one, check that it's not in the list

Jumping in here so ignore if this does help you



	
		
	


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




RE: CSS 'focus' in IE

2004-05-21 Thread Sandy Clark
IE6 doesn't support focus in CSS.  However Dean Edwards Beta of IE7
(Internet Extensions) which is a set of behaviors for IE6 to make it more
CSS 2 compliant does support it.  You can find the behaviors at
http://dean.edwards.name/IE7/

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 20, 2004 11:51 AM
To: CF-Talk
Subject: OT: CSS 'focus' in IE

Hello

I've been looking at
http://www.w3.org/TR/CSS21/selector.html#pseudo-elements and the
pseudo-class 'focus'

When I've got 


.input { background: #CC; color: #00; }
.input:focus { background: #FF; color: #FF; }
It works in Firebird 0.8 ok... but not in IE 6... anybody know a hack to achieve it keeping it all in the CSS for IE 6?  Or do we need to wait for IE 7? I've had a root about google but can't see anything that would help me. (it's a external development done in UNIFACE so got no control over the generation of the HTML code of the input elements) Cheers if anyone can help. -- David Collie   _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: SOT - Last nights NYCFUG meeting.

2004-05-21 Thread Cutter (CF-Talk)
This is a bit unfair to those of us who live in remote enough locations 
that there are no close MMUGs and our seasonal work environments don't 
allow much travel during this time of year...

Cutter

Ben Forta wrote:
> No, that was not specifically mentioned. I can't comment on this feature
> specifically, but I do plan on discussing this on tour stops.
> 
> 
> --- Ben
> 
>   _  
> 
> From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 20, 2004 12:37 PM
> To: CF-Talk
> Subject: Re: SOT - Last nights NYCFUG meeting.
> 
>  >I didn't sign an NDA ;)
>  >
>  >If NYCFUG was in on the MM Breeze presentation, it was basically a
>  >high level overview of MM's plans for the rest of the year and into
>  >next.
>  >
>  >Some teaser demos of BlackStone, including very nifty CFFORM & FLASH
>  >integration. Also CFDOCUMENT TYPE="PDF" (or something to that effect).
>  >~ Ubqtous ~
> 
> I missed it last night.  Talking about BlackStone, anything about code
> protection?
>   _
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CSS 'focus' in IE

2004-05-21 Thread d.a.collie
>> IE6 doesn't support focus in CSS.  However Dean Edwards Beta of IE7
(Internet Extensions) 

Cheers, will look into it... users wanting the input boxes to change
color and you know how it goes, gotta get it working for them

Cheers everyone :-)

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




CF in montreal (quebec) ?

2004-05-21 Thread CFDEV
Hi there, does anyone of you knows if there is a big community of CF
programmer in montreal... I always see on this list conference and stuff in
the States and in Toronto for Canada..

 
Thanks

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




Re: XPath Help

2004-05-21 Thread Ian Sheridan
I found this site to be an excellent eye opener for xPath.

http://www.zvon.org/xxl/XPathTutorial/General/examples.html

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XPath Help

2004-05-21 Thread Ian Sheridan
I shot that off to fast here is a more focused link. the site is a 
little confusing.

http://www.zvon.org/xxl/XPathTutorial/Output/example1.html

On May 21, 2004, at 7:56 AM, Ian Sheridan wrote:

> I found this site to be an excellent eye opener for xPath.
>
> http://www.zvon.org/xxl/XPathTutorial/General/examples.html

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SOT - Last nights NYCFUG meeting.

2004-05-21 Thread Ben Forta
We're planning an online Breeze based sessions for user groups not visited,
but I don't have the details yet. I'll post them as soon as I do.

 
--- Ben

  _  

From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 7:50 AM
To: CF-Talk
Subject: Re: SOT - Last nights NYCFUG meeting.

This is a bit unfair to those of us who live in remote enough locations 
that there are no close MMUGs and our seasonal work environments don't 
allow much travel during this time of year...

Cutter

Ben Forta wrote:
> No, that was not specifically mentioned. I can't comment on this feature
> specifically, but I do plan on discussing this on tour stops.
> 
> 
> --- Ben
> 
>   _  
> 
> From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 20, 2004 12:37 PM
> To: CF-Talk
> Subject: Re: SOT - Last nights NYCFUG meeting.
> 
>  >I didn't sign an NDA ;)
>  >
>  >If NYCFUG was in on the MM Breeze presentation, it was basically a
>  >high level overview of MM's plans for the rest of the year and into
>  >next.
>  >
>  >Some teaser demos of BlackStone, including very nifty CFFORM & FLASH
>  >integration. Also CFDOCUMENT TYPE="PDF" (or something to that effect).
>  >~ Ubqtous ~
> 
> I missed it last night.  Talking about BlackStone, anything about code
> protection?
>   _
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XPath Help

2004-05-21 Thread Alexander Sherwood
At 07:04 AM 5/21/2004, you wrote:
>Hi, I'm trying to get some XPath to work with respect to a navigation tree.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>I can use Xpath to return all the child nodes within a node using 
>//[EMAIL PROTECTED]"3"]

Couple of things here, Tony.

1) You can "chain" xpaths together.
2) Learn all of the Xpaths Axes (sp?)!

In this case, you could grab the objectID of the node element with an objectID of 2134 like this:

//[EMAIL PROTECTED]/parent::node

Notice the reference to the exact node, and then a reference to the "parent" axis, asking for a "node" element.

Hope this helps.

--
Alex Sherwood
PHS Collection Agency
THE COLLECTORS
P:   813-283-4579
F:   301.664.6834
W: www.phs-net.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: oracle unique id or identity

2004-05-21 Thread Deanna Schneider
Daniel,
Can you create the sequence and then just run a test on it outside the
trigger. In other words, just try this:

SELECT uniqueNum_s.nextval FROM dual;

Does this work?

Here's an example of a trigger that I use for updates/inserts. On insert, it
"auto-increments" the id field. On update, it checks to make sure someone
isn't trying to change the primary key and raises an error if they do.

-- Start of DDL script for TRG_CFS_BREAKFASTDATAID
-- Generated 21-May-04  7:31:40 am
-- from t817a-FLPWEB:1

-- Trigger TRG_CFS_BREAKFASTDATAID

CREATE OR REPLACE TRIGGER flpweb.trg_cfs_breakfastdataid
BEFORE INSERT  OR UPDATE
ON flpweb.cfs_breakfastdata
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
    iCounter cfs_breakfastdata.breakfastdataid%TYPE;
    cannot_change_counter EXCEPTION;
BEGIN
    IF INSERTING THEN
Select SEQ_cfs_breakfastdataid.NEXTVAL INTO iCounter FROM Dual;
:new.breakfastdataid := iCounter;

    END IF;

    IF UPDATING THEN
IF NOT (:new.breakfastdataid = :old.breakfastdataid) THEN
RAISE cannot_change_counter;
END IF;
    END IF;

EXCEPTION
 WHEN cannot_change_counter THEN
 raise_application_error(-2, 'Cannot Change Counter Value');
END;
/

-- End of DDL script for TRG_CFS_BREAKFASTDATAID

- Original Message - 
From: "daniel kessler"

> well I still can't get it to work.  I am trying to auto-increment the "id"
field in the table "hhp_calendar", using:
>
> I get an error stating that dpch: uniqueNum_s is invalid and can't be
initialized.
> Any thoughts getting this to work or can anyone recommend a more
appropriate forum?
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




new member: web fetching

2004-05-21 Thread techmike
Hello all, I'm new to the group and coldfusion in general.  I've been 
tinkering around with server side scripting for awhile but coldfusion is 
all new to me.  My employer got me involved with some free classes, and 
I'm very intrigued at how easy this is to learn.

Anyway, now my question.  How would one fetch content from another webpage 
on the server.

For example, grab a weather map from weather.com and cache it on my 
server.  I can figure out the display and updating part.  Just not sure 
how to grab the file to save it in the first place.

I'm running MX 6 if it makes any difference.

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




RE: Ignoring duplicates in

2004-05-21 Thread Nathan R. Jessop
I added the "list" attribute to my  and now I get an error.
What am I doing wrong?

Here is my code:



	
	
		Seq: #sValNoComma#  Folio: #sDisp##spacer1#
		
	



On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote:

>>In which case, keep a list of items as you write them out, and before 
>>you do the next one, check that it's not in the list
>
>Jumping in here so ignore if this does help you
>
>
>
>	
>		
>	
>
>
>-- 
>dc
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: new member: web fetching

2004-05-21 Thread Whittingham, P
cfhttp.

 
Pat

-Original Message-
From: techmike [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 8:39 AM
To: CF-Talk
Subject: new member: web fetching

Hello all, I'm new to the group and coldfusion in general.  I've been 
tinkering around with server side scripting for awhile but coldfusion is 
all new to me.  My employer got me involved with some free classes, and 
I'm very intrigued at how easy this is to learn.

Anyway, now my question.  How would one fetch content from another webpage 
on the server.

For example, grab a weather map from weather.com and cache it on my 
server.  I can figure out the display and updating part.  Just not sure 
how to grab the file to save it in the first place.

I'm running MX 6 if it makes any difference.

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




Selecting records from form fields

2004-05-21 Thread Spectrum WebDesign
Hi all

our application have an form with dynamic fields... like this... After user choices that options i need to select 
Form Fields:
CHECK_QUESTIONID=8,11,10
STEP=1
FIELDNAMES=STEP2,CHECK_QUESTIONID,SELECT_ATRIB_8,SELECT_ATRIB_11,SELECT_ATRIB_10,SUBMIT
SELECT_ATRIB_10=4
SELECT_ATRIB_11=5
SELECT_ATRIB_8=2

In the action page i need to show the Question Description from the CHECK_QUESTIONID and SELECT the SELECT_ATRIB_X, where X is the user choice (QUESTIONID = 10 ; SELECT_ATRIB = 4)...

Any tips? Comments?

Thanx for your time.
-- 
___
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: new member: web fetching

2004-05-21 Thread Monique Boea
More specifically please...

 
:)

-Original Message-
From: Whittingham, P [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 8:45 AM
To: CF-Talk
Subject: RE: new member: web fetching

cfhttp.

Pat

-Original Message-
From: techmike [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 8:39 AM
To: CF-Talk
Subject: new member: web fetching

Hello all, I'm new to the group and coldfusion in general.  I've been 
tinkering around with server side scripting for awhile but coldfusion is 
all new to me.  My employer got me involved with some free classes, and 
I'm very intrigued at how easy this is to learn.

Anyway, now my question.  How would one fetch content from another webpage 
on the server.

For example, grab a weather map from weather.com and cache it on my 
server.  I can figure out the display and updating part.  Just not sure 
how to grab the file to save it in the first place.

I'm running MX 6 if it makes any difference.

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




RE: Ignoring duplicates in

2004-05-21 Thread Adkins, Randy
What error are you getting?

-Original Message-
From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 8:45 AM
To: CF-Talk
Subject: RE: Ignoring duplicates in 

I added the "list" attribute to my  and now I get an error.
What am I doing wrong?

Here is my code:





Seq: #sValNoComma#  Folio:
#sDisp##spacer1#





On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote:

>>In which case, keep a list of items as you write them out, and before 
>>you do the next one, check that it's not in the list
>
>Jumping in here so ignore if this does help you
>
>
>
> 
> 
> 
>
>
>-- 
>dc
>
>
>
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread Adkins, Randy
Actually now I look at it when you do a LIST the syntax is:

 


 
There is no from and to attributes

-Original Message-
From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 8:45 AM
To: CF-Talk
Subject: RE: Ignoring duplicates in 

I added the "list" attribute to my  and now I get an error.
What am I doing wrong?

Here is my code:





Seq: #sValNoComma#  Folio:
#sDisp##spacer1#





On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote:

>>In which case, keep a list of items as you write them out, and before 
>>you do the next one, check that it's not in the list
>
>Jumping in here so ignore if this does help you
>
>
>
> 
> 
> 
>
>
>-- 
>dc
>
>
>
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: new member: web fetching

2004-05-21 Thread Tangorre, Michael
A good link to bookmark is that of the "livedocs" at Macromedia's website.
It comes in very handy and even has examples, although I'd take them with a
grain of salt.  :-)

http://livedocs.macromedia.com/coldfusion/6.1/index.html

Welcome aboard and I think you will find this list more useful than
cf-community.

Mike

> More specifically please...
>> cfhttp.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CF in montreal (quebec) ?

2004-05-21 Thread Claude Schneegans
>>Hi there, does anyone of you knows if there is a big community of CF programmer in montreal...

YEHHH ! ;-)

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread Nathan R. Jessop

	
	
		Seq: #sValNoComma#  Folio: #sDisp##spacer1#
		
	


After making the change to the  I get the following error:

An error occurred while evaluating the _expression_.

not listFindNoCase(i, duplist)

On Fri, 21 May 2004 08:53:05 -0400, Adkins, Randy wrote:

>What error are you getting?
>
>-Original Message-
>From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] 
>Sent: Friday, May 21, 2004 8:45 AM
>To: CF-Talk
>Subject: RE: Ignoring duplicates in 
>
>
>I added the "list" attribute to my  and now I get an error.
>What am I doing wrong?
>
>Here is my code:
>
>
>
>
>
>Seq: #sValNoComma#  Folio:
>#sDisp##spacer1#
>
>
>
>
>
>On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote:
>
>>>In which case, keep a list of items as you write them out, and before 
>>>you do the next one, check that it's not in the list
>>
>>Jumping in here so ignore if this does help you
>>
>>
>>
>> 
>> 
>> 
>>
>>
>>-- 
>>dc
>>
>>
>>
>> 
>  _  
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: new member: web fetching

2004-05-21 Thread techmike
I thought cfhttp would be the correct route, but was skeptical after 
reading the man page for it..

-mike

-Original Message-
From: "Monique Boea" <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Fri, 21 May 2004 08:51:52 -0400
Subject: RE: new member: web fetching

> More specifically please...
>  
> :)
> 
> -Original Message-
> From: Whittingham, P [mailto:[EMAIL PROTECTED] 
> Sent: Friday, May 21, 2004 8:45 AM
> To: CF-Talk
> Subject: RE: new member: web fetching
> 
> 
> cfhttp.
> 
> 
> Pat
> 
> -Original Message-
> From: techmike [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 21, 2004 8:39 AM
> To: CF-Talk
> Subject: new member: web fetching
> 
> Hello all, I'm new to the group and coldfusion in general.  I've been 
> tinkering around with server side scripting for awhile but coldfusion
> is 
> all new to me.  My employer got me involved with some free classes, and
> I'm very intrigued at how easy this is to learn.
> 
> Anyway, now my question.  How would one fetch content from another
> webpage 
> on the server.
> 
> For example, grab a weather map from weather.com and cache it on my 
> server.  I can figure out the display and updating part.  Just not sure
> how to grab the file to save it in the first place.
> 
> I'm running MX 6 if it makes any difference.
> 
> -mike 
>   _ 
>   _  
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread d.a.collie
You are looping over an array, you will need to set your values within
the loop, it would be something like this



	
	
		
		Seq:
#sValNoComma#  Folio: #sDisp##spacer1#
	


I haven't ran it but it _should_ work.

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




RE: Ignoring duplicates in

2004-05-21 Thread Philip Arnold
> From: Nathan R. Jessop
> 
> 
> 	
> 	
> 		Seq: 
> #sValNoComma#  Folio: #sDisp##spacer1#
> 		
> 	
> 

The LIST attribute loops over a delimited list, ArrayLen returns one
number, so you're looping over one item

If you're going to loop over an Array, you have to use FROM and TO
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Ignoring duplicates in

2004-05-21 Thread d.a.collie
Oops as Philip said it would need to be



	
	
		
		Seq:
#sValNoComma#  Folio: #sDisp##spacer1#
	


was more concerned with what was going on in the loop rats :-)

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




excel files

2004-05-21 Thread George Abraham
Hi,
I asked a question sometime back about reading excel files with CFMX 
without using a defined datasource. No answers yet, but is there another 
forum I could be asking this question?

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




Re: excel files

2004-05-21 Thread Ray Champagne
I don't know if this would help, but if you can export the files to a csv 
file via Excel, you could then read the file using cffile (read) - no 
datasource

But, you would have to change the file, and I don't know if that is 
possible for you or not.

Ray

At 09:20 AM 5/21/2004, George Abraham wrote:
>Hi,
>I asked a question sometime back about reading excel files with CFMX
>without using a defined datasource. No answers yet, but is there another
>forum I could be asking this question?
>
>Thanks,
>George
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Ignoring duplicates in

2004-05-21 Thread Nathan R. Jessop
It's now displaying my list but its still duplicating. I think it has something to do with the extra lines of code that I stripped out before I posted this.

Something is conflicting. I'm reading in an external file that looks like this:

001>folio:  2201 . . . 274.00 points free
002>folio:  2251 . . . 021.00 points free
003>folio:  2252 . . . 001.00 points free
004>folio:  2253 . . . 011.00 points free
005>folio:  2254 . . . 001.00 points free
006>folio:  2201 . . . 006.50 points free
007>folio:  2251 . . . 230.50 points free
008>folio:  2252 . . . 000.00 points free
009>folio:  2253 . . . 001.00 points free
010>folio:  2254 . . . 202.50 points free

Here is ALL the code in the 




"))>
"))>




 Seq: #sValNoComma#  Folio: #sDisp##spacer1#
  


This is the output I'm getting now:

Seq: 1  Folio:  2201
Seq: 2  Folio:  2251
Seq: 3  Folio:  2252
Seq: 4  Folio:  2253
Seq: 5  Folio:  2254
Seq: 6  Folio:  2201
Seq: 7  Folio:  2251
Seq: 8  Folio:  2252
Seq: 9  Folio:  2253
Seq: 10  Folio:  2254

I want it to about like this. Ignoring the duplicates:

Seq: 1  Folio:  2201
Seq: 2  Folio:  2251
Seq: 3  Folio:  2252
Seq: 4  Folio:  2253
Seq: 5  Folio:  2254

On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote:

>Oops as Philip said it would need to be
>
>
>
>	
>	
>		
>		Seq:
>#sValNoComma#  Folio: #sDisp##spacer1#
>	
>
>
>was more concerned with what was going on in the loop rats :-)
>
>-- 
>dc
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: excel files

2004-05-21 Thread George Abraham
I toyed with that idea, but the users really shouldn't be saddled with 
something like that. Besides, the querying of Excel files using SQL is 
easier to code and debug.

George

At 09:26 AM 5/21/2004, Ray Champagne wrote:
>I don't know if this would help, but if you can export the files to a csv
>file via Excel, you could then read the file using cffile (read) - no
>datasource
>
>But, you would have to change the file, and I don't know if that is
>possible for you or not.
>
>Ray
>
>At 09:20 AM 5/21/2004, George Abraham wrote:
> >Hi,
> >I asked a question sometime back about reading excel files with CFMX
> >without using a defined datasource. No answers yet, but is there another
> >forum I could be asking this question?
> >
> >Thanks,
> >George
> >
> >
> >
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: excel files

2004-05-21 Thread Rick Root
George Abraham wrote:
> Hi,
> I asked a question sometime back about reading excel files with CFMX
> without using a defined datasource. No answers yet, but is there another
> forum I could be asking this question?

There may be an easier solution, but the Jakarta POI project allows you 
to read and write Excel files in Java.  I'm sure you could use it within 
CFMX.

http://jakarta.apache.org/poi/

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




Re: excel files

2004-05-21 Thread George Abraham
Rick,
Ultimately that is probably what I will end up doing. Before asking the 
forum, I did some research into POI and decided as a long-term solution, 
that is probably what is best for manipulating Word and Excel Files. I was 
hoping for an easier solution though, as you said. :-)

By the way, is there any URL that details how exactly to use POI within a 
CFMX environment?

George

At 09:31 AM 5/21/2004, you wrote:
>George Abraham wrote:
> > Hi,
> > I asked a question sometime back about reading excel files with CFMX
> > without using a defined datasource. No answers yet, but is there another
> > forum I could be asking this question?
>
>There may be an easier solution, but the Jakarta POI project allows you
>to read and write Excel files in Java.  I'm sure you could use it within
>CFMX.
>
>http://jakarta.apache.org/poi/
>
>   - Rick
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




What causes this sporadic error?

2004-05-21 Thread Mark Leder
Hi all,
This appears every once in a while when clicking a link or using the
browser's back button.  I have cookies enabled on my Win XP machine, using
IE 6.  Do I have a setting wrong in the  tag?  I presently do
not have a #URLSessionFormat()# or other similar function on the links, and
the error appears when just clicking a normal 
=

Error Occurred While Processing Request  
CFID, CFTOKEN contains invalid characters.  
This exception is caused by either broken links, or security attacks. The
invalid id is 2847bbb19bdbaac9-9aé÷N466-3048-282E-34D24869A0974CAC  
  
The error occurred in C:\Inetpub\mysite\Application.cfm: line 16

 
14 : clientmanagement="No"
15 : sessionmanagement="Yes"
16 : setclientcookies="Yes"
17 : sessiontimeout="#CreateTimeSpan(0,0,20,0)#"
18 : applicationtimeout="#CreateTimeSpan(2,0,0,0)#">

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




Re: Ignoring duplicates in

2004-05-21 Thread Nathan R. Jessop
I just noticed the matching is being done on the ValNoComma but it should be on the "sDisp"

On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote:

>Oops as Philip said it would need to be
>
>
>
>	
>	
>		
>		Seq:
>#sValNoComma#  Folio: #sDisp##spacer1#
>	
>
>
>was more concerned with what was going on in the loop rats :-)
>
>-- 
>dc
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread Philip Arnold
That's because you're checking on the Seq number, not the Folio

> 
> 

Should be

> 
> 

> -Original Message-
> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] 
> Sent: 21 May 2004 09:32
> To: CF-Talk
> Subject: Re: Ignoring duplicates in 
> 
> 
> It's now displaying my list but its still duplicating. I 
> think it has something to do with the extra lines of code 
> that I stripped out before I posted this.
> 
> Something is conflicting. I'm reading in an external file 
> that looks like this:
> 
> 001>folio:  2201 . . . 274.00 points free
> 002>folio:  2251 . . . 021.00 points free
> 003>folio:  2252 . . . 001.00 points free
> 004>folio:  2253 . . . 011.00 points free
> 005>folio:  2254 . . . 001.00 points free
> 006>folio:  2201 . . . 006.50 points free
> 007>folio:  2251 . . . 230.50 points free
> 008>folio:  2252 . . . 000.00 points free
> 009>folio:  2253 . . . 001.00 points free
> 010>folio:  2254 . . . 202.50 points free
> 
> Here is ALL the code in the 
> 
> 
> 
> 
> "))>
> "))>
> 
> 
> 
> 
>  Seq: 
> #sValNoComma#  Folio: #sDisp##spacer1#
>   
> 
> 
> This is the output I'm getting now:
> 
> Seq: 1  Folio:  2201
> Seq: 2  Folio:  2251
> Seq: 3  Folio:  2252
> Seq: 4  Folio:  2253
> Seq: 5  Folio:  2254
> Seq: 6  Folio:  2201
> Seq: 7  Folio:  2251
> Seq: 8  Folio:  2252
> Seq: 9  Folio:  2253
> Seq: 10  Folio:  2254
> 
> 
> I want it to about like this. Ignoring the duplicates:
> 
> Seq: 1  Folio:  2201
> Seq: 2  Folio:  2251
> Seq: 3  Folio:  2252
> Seq: 4  Folio:  2253
> Seq: 5  Folio:  2254
> 
> On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote:
> 
> >Oops as Philip said it would need to be
> >
> >
> >
> >	
> >	
> >		
> >		Seq:
> >#sValNoComma#  Folio: #sDisp##spacer1#
> >	
> >
> >
> >was more concerned with what was going on in the loop rats :-)
> >
> >--
> >dc
> >
> >
> >
> >
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread Nathan R. Jessop
Doh...yea...I got it to work.

On Fri, 21 May 2004 09:54:37 -0400, Philip Arnold wrote:

>That's because you're checking on the Seq number, not the Folio
>
>> 
>> 
>
>Should be
>
>> 
>> 
>
>
>> -Original Message-
>> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] 
>> Sent: 21 May 2004 09:32
>> To: CF-Talk
>> Subject: Re: Ignoring duplicates in 
>> 
>> 
>> It's now displaying my list but its still duplicating. I 
>> think it has something to do with the extra lines of code 
>> that I stripped out before I posted this.
>> 
>> Something is conflicting. I'm reading in an external file 
>> that looks like this:
>> 
>> 001>folio:  2201 . . . 274.00 points free
>> 002>folio:  2251 . . . 021.00 points free
>> 003>folio:  2252 . . . 001.00 points free
>> 004>folio:  2253 . . . 011.00 points free
>> 005>folio:  2254 . . . 001.00 points free
>> 006>folio:  2201 . . . 006.50 points free
>> 007>folio:  2251 . . . 230.50 points free
>> 008>folio:  2252 . . . 000.00 points free
>> 009>folio:  2253 . . . 001.00 points free
>> 010>folio:  2254 . . . 202.50 points free
>> 
>> Here is ALL the code in the 
>> 
>> 
>> 
>> 
>> "))>
>> "))>
>> 
>> 
>> 
>> 
>>  Seq: 
>> #sValNoComma#  Folio: #sDisp##spacer1#
>>   
>> 
>> 
>> This is the output I'm getting now:
>> 
>> Seq: 1  Folio:  2201
>> Seq: 2  Folio:  2251
>> Seq: 3  Folio:  2252
>> Seq: 4  Folio:  2253
>> Seq: 5  Folio:  2254
>> Seq: 6  Folio:  2201
>> Seq: 7  Folio:  2251
>> Seq: 8  Folio:  2252
>> Seq: 9  Folio:  2253
>> Seq: 10  Folio:  2254
>> 
>> 
>> I want it to about like this. Ignoring the duplicates:
>> 
>> Seq: 1  Folio:  2201
>> Seq: 2  Folio:  2251
>> Seq: 3  Folio:  2252
>> Seq: 4  Folio:  2253
>> Seq: 5  Folio:  2254
>> 
>> On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote:
>> 
>> >Oops as Philip said it would need to be
>> >
>> >
>> >
>> >	
>> >	
>> >		
>> >		Seq:
>> >#sValNoComma#  Folio: #sDisp##spacer1#
>> >	
>> >
>> >
>> >was more concerned with what was going on in the loop rats :-)
>> >
>> >--
>> >dc
>> >
>> >
>> >
>> >
>> 
>> 
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: What causes this sporadic error?

2004-05-21 Thread Paul Vernon
You generally get this error if you have the CFID and CFTOKEN in your URL
querystring twice. This can happen if you have not set addtoken="no" in a
cflocation and you are manually adding the CFID and CFTOKEN to your url

eg 

 


 
 should work OK

 
 - should
work OK

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




RE: excel files

2004-05-21 Thread Nathan C. Smith
How many people will be querying the excel file?  

 
Could you create an Excel DSN with a file of a given name, but copy the
active file to the DSN file and name as it was being used?

 
Somebody else may be able to jump in here, but I think there is a way to
stop and restart a DSN programmatically, so perhaps you could stop the DSN,
copy the file and then access the DSN...

 
Maybe you've already been down this road?

 
-Nate

 
-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 8:20 AM
To: CF-Talk
Subject: excel files

Hi,
I asked a question sometime back about reading excel files with CFMX 
without using a defined datasource. No answers yet, but is there another 
forum I could be asking this question?

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




RE: excel files

2004-05-21 Thread George Abraham
I did the DSN thing, but I was not aware that you could restart a DSN 
programmatically. If that is possible, whew, it would save me some work for 
the time being at least!

George

At 10:00 AM 5/21/2004, you wrote:
>How many people will be querying the excel file?
>
>Could you create an Excel DSN with a file of a given name, but copy the
>active file to the DSN file and name as it was being used?
>
>Somebody else may be able to jump in here, but I think there is a way to
>stop and restart a DSN programmatically, so perhaps you could stop the DSN,
>copy the file and then access the DSN...
>
>Maybe you've already been down this road?
>
>-Nate
>
>-Original Message-
>From: George Abraham [mailto:[EMAIL PROTECTED]
>Sent: Friday, May 21, 2004 8:20 AM
>To: CF-Talk
>Subject: excel files
>
>
>Hi,
>I asked a question sometime back about reading excel files with CFMX
>without using a defined datasource. No answers yet, but is there another
>forum I could be asking this question?
>
>Thanks,
>George
>   _
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF in montreal (quebec) ?

2004-05-21 Thread Stacy Young
<- Montreal !!  :)

-Stace

  _  

From: CFDEV [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 7:53 AM
To: CF-Talk
Subject: CF in montreal (quebec) ?

Hi there, does anyone of you knows if there is a big community of CF
programmer in montreal... I always see on this list conference and stuff
in
the States and in Toronto for Canada..

Thanks

Pat

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




Re: SOT - Last nights NYCFUG meeting.

2004-05-21 Thread Don
Thanks, this is good to know.  If you've tried BD yourself probably you would have an idea about the following questions: 
*) Could BD co-exist with CFMX and/or preCFMX on a same win OS box for dev?
*) Does BD support both CFMX and preCFMX or only CFMX?
Of course, I'll look into more detail about BD via its own web site as well.  But these questions seems high level and it would be beneficial to know asap.

TIA.

>Not to put a damper on anything in the new version of CF, but Blue Dragon does
>offer very good code protection.  It seems as though the CFML templates can be
>precompiled and encrypted.
> 
>The templates are no longer human readable.  There is no way to return the
>COML. templates to there original COML. form.  They also state that they run
>faster since they are pre-complied??
> 
>It seems to be key based and the key is specific to your application and if
>some tries to run your app on another installation of Blue Dragon, it will
>fail since it does not have the key.
> 
>Seems like this is a pretty cool feature.
> 
>Mario
>-Original Message-
>From: Chunshen Li [mailto:[EMAIL PROTECTED]
>Sent: Thursday, May 20, 2004 12:37 PM
>To: CF-Talk
>Subject: Re: SOT - Last nights NYCFUG meeting.
>
>
>
>I missed it last night.  Talking about BlackStone, anything about code
>protection? 
>  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ignoring duplicates in

2004-05-21 Thread Nathan R. Jessop
Oh no...another problem.

If my imput file list looks likes this (arrows just indicate extra folios)

001>folio:  2201 . . . 274.00 points free
002>folio:  2251 . . . 021.00 points free
003>folio:  2252 . . . 001.00 points free
004>folio:  2253 . . . 011.00 points free
005>folio:  2254 . . . 001.00 points free
006>folio:  2201 . . . 006.50 points free
007>folio:  2202 . . . 006.50 points free <--
008>folio:  2203 . . . 006.50 points free <--
009>folio:  2251 . . . 230.50 points free
0010>folio:  2252 . . . 000.00 points free
011>folio:  2253 . . . 001.00 points free
010>folio:  2254 . . . 202.50 points free

When I run it through the code I get this:

001>folio:  2201 . . . 006.50 points free
002>folio:  2251 . . . 230.50 points free
003>folio:  2252 . . . 000.00 points free
004>folio:  2253 . . . 001.00 points free
005>folio:  2254 . . . 202.50 points free
006>folio:  2202 . . . 006.50 points free <--
007>folio:  2203 . . . 006.50 points free <--

How can I get it to output in the correct order?

>>> -Original Message-
>>> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] 
>>> Sent: 21 May 2004 09:32
>>> To: CF-Talk
>>> Subject: Re: Ignoring duplicates in 
>>> 
>>> 
>>> It's now displaying my list but its still duplicating. I 
>>> think it has something to do with the extra lines of code 
>>> that I stripped out before I posted this.
>>> 
>>> Something is conflicting. I'm reading in an external file 
>>> that looks like this:
>>> 
>>> 001>folio:  2201 . . . 274.00 points free
>>> 002>folio:  2251 . . . 021.00 points free
>>> 003>folio:  2252 . . . 001.00 points free
>>> 004>folio:  2253 . . . 011.00 points free
>>> 005>folio:  2254 . . . 001.00 points free
>>> 006>folio:  2201 . . . 006.50 points free
>>> 007>folio:  2251 . . . 230.50 points free
>>> 008>folio:  2252 . . . 000.00 points free
>>> 009>folio:  2253 . . . 001.00 points free
>>> 010>folio:  2254 . . . 202.50 points free
>>> 
>>> Here is ALL the code in the 
>>> 
>>> 
>>> 
>>> 
>>> "))>
>>> "))>
>>> 
>>> 
>>> 
>>> 
>>>  Seq: 
>>> #sValNoComma#  Folio: #sDisp##spacer1#
>>>   
>>> 
>>> 
>>> This is the output I'm getting now:
>>> 
>>> Seq: 1  Folio:  2201
>>> Seq: 2  Folio:  2251
>>> Seq: 3  Folio:  2252
>>> Seq: 4  Folio:  2253
>>> Seq: 5  Folio:  2254
>>> Seq: 6  Folio:  2201
>>> Seq: 7  Folio:  2251
>>> Seq: 8  Folio:  2252
>>> Seq: 9  Folio:  2253
>>> Seq: 10  Folio:  2254
>>> 
>>> 
>>> I want it to about like this. Ignoring the duplicates:
>>> 
>>> Seq: 1  Folio:  2201
>>> Seq: 2  Folio:  2251
>>> Seq: 3  Folio:  2252
>>> Seq: 4  Folio:  2253
>>> Seq: 5  Folio:  2254
>>> 
>>> On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote:
>>> 
>>> >Oops as Philip said it would need to be
>>> >
>>> >
>>> >
>>> >	
>>> >	
>>> >		
>>> >		Seq:
>>> >#sValNoComma#  Folio: #sDisp##spacer1#
>>> >	
>>> >
>>> >
>>> >was more concerned with what was going on in the loop rats :-)
>>> >
>>> >--
>>> >dc
>>> >
>>> >
>>> >
>>> >
>>> 
>>> 
>>
>>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Executing an ASX file on ColdFusion Server?

2004-05-21 Thread Greg Landers
Hello.

I have an issue with getting an ASX file to properly execute on a CF server (MX) ... on the same machine using apache's web server the ASX file execute in the browser causing it to stream the media as expected. However, when running it throught the CF server it pulls up a blank page in the browser. Viewing source on the blank page you see all of the ASX code sitting there - but the browser seems to not want anything to do with it.

Has anyone out there ran accross an issue like this - if so, have you found a solution?

I can send example links if anyone wants to see it happening.

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




RE: Ignoring duplicates in

2004-05-21 Thread Philip Arnold
> From: Nathan R. Jessop
> 
> How can I get it to output in the correct order?

What does your data look like?

Can you sort it with ArraySort()?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: What causes this sporadic error?

2004-05-21 Thread Mark Leder
But what I don't understand is why this is happening in normal 
tags, I'm not using or clicking a cflocation tag??

Thanks, Mark 

  _  

From: Paul Vernon [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 10:00 AM
To: CF-Talk
Subject: RE: What causes this sporadic error?

You generally get this error if you have the CFID and CFTOKEN in your URL
querystring twice. This can happen if you have not set addtoken="no" in a
cflocation and you are manually adding the CFID and CFTOKEN to your url

eg 



 should work OK

 - should
work OK

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




RE: excel files

2004-05-21 Thread George Abraham
So I did some quick looking around and here is something that could be helpful:

http://www.macromedia.com/support/coldfusion/ts/documents/dynamic_dsn_cfmx.htm

George

At 10:00 AM 5/21/2004, you wrote:
>How many people will be querying the excel file?
>
>Could you create an Excel DSN with a file of a given name, but copy the
>active file to the DSN file and name as it was being used?
>
>Somebody else may be able to jump in here, but I think there is a way to
>stop and restart a DSN programmatically, so perhaps you could stop the DSN,
>copy the file and then access the DSN...
>
>Maybe you've already been down this road?
>
>-Nate
>
>-Original Message-
>From: George Abraham [mailto:[EMAIL PROTECTED]
>Sent: Friday, May 21, 2004 8:20 AM
>To: CF-Talk
>Subject: excel files
>
>
>Hi,
>I asked a question sometime back about reading excel files with CFMX
>without using a defined datasource. No answers yet, but is there another
>forum I could be asking this question?
>
>Thanks,
>George
>   _
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Problem with CFC web service & Flash

2004-05-21 Thread Rick Root
I've got a web service that I use to authorize users against our DB2 
Mainframe, and I recently changed it up to return an array of CFC 
datatypes instead of a structure.

The WSDL generates fine... I can call the methods from the browser 
directly.  But when Flash tries to access it, it simply says there was 
an error accessing the URL.

There is nothing logged in any of the coldfusion logs that I can find.. 
all I can find is a 500 server error in the web server's access logs.

this is making things difficult to debug =)

Any suggestions?

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




RE: Executing an ASX file on ColdFusion Server?

2004-05-21 Thread Paul Vernon
I run CFMX 6.1 and Windows Media services without any problems, send some
more information and I'll see what I can do to help.

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




Passing a webservice a file

2004-05-21 Thread David Adams
My understanding of webservices are weak but is it possible to pass a webservice a file (as opposed to a string) and have it processed and returned?

I am not concerned about how it is processed or returned but whether or not a webservice accepts binary files.

Thanks in advance.
DA
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Passing a webservice a file

2004-05-21 Thread Tony Weeg
an xml file?

sure.

tw 

-Original Message-
From: David Adams [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 10:33 AM
To: CF-Talk
Subject: Passing a webservice a file

My understanding of webservices are weak but is it possible to pass a
webservice a file (as opposed to a string) and have it processed and
returned?

I am not concerned about how it is processed or returned but whether or not
a webservice accepts binary files.

Thanks in advance.
DA
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: What causes this sporadic error?

2004-05-21 Thread Paul Vernon
Sorry, I missed out an important point when I looked at your error

 
The CFID and CFTOKEN that you give in your example are definately corrupt...

The first place I look when I see errors like this is page and server
enconding settings...

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




ColdFusion TechNote Notification: "ColdFusion MX 6.1: IBM WebSphe re 5.1 support"

2004-05-21 Thread Debbie Dickerson
Check out the new TechNote at:
http://www.macromedia.com/support/coldfusion/ts/documents/was51_support.htm

Intro:
IBM WebSphere Application Server (WAS) 5.1 is generally supported with
ColdFusion MX 6.1; however, there are certain configurations that are not.
WAS 5.1 Base Edition is supported with ColdFusion MX 6.1. WAS 5.1 Network
Deployment clusters are not supported with ColdFusion MX 6.1.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Active Directory

2004-05-21 Thread Coleman, Brian
I'm not sure why you wouldn't be able to take off the OUs...but maybe
there's something above the OUs you can use?

My queries I'm playing with to use AD based authentication look like
this

***first query to connect to ldap and query the username entered***



SERVER="server"

PORT="389"

ACTION="">

ATTRIBUTES="samaccountname"

START="CN=Users,DC=root,DC=domain,DC=com"

SCOPE="subtree"

FILTER="samaccountname=#user#"

USERNAME="[EMAIL PROTECTED]"

PASSWORD="password">

***then a second query to connect as the user and test password***



SERVER="server"

PORT="389"

ACTION="">

ATTRIBUTES="samaccountname"

START="CN=Users,DC=root,DC=domain,DC=com"

SCOPE="subtree"

FILTER="samaccountname=#user#"

username="[EMAIL PROTECTED]"

password="#password#">

I don't know if the first query is really needed, but if the first query
fails, you know its not a valid username and if the second fails you
know its not a valid password

I used this tool to see more into ldap and copied out some of the DN
stuff it found to get my start string 

http://www.iit.edu/~gawojar/ldap/



-Original Message-
From: Ray Hamann [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 20, 2004 8:17 AM
To: CF-Talk
Subject: Active Directory

I need to use CFLDAP to match a form submitted username and password to
Active Directory not knowing what OU's the user may be in. I have to use
a special account to bind to AD with so the username and password
attributes are already utilized. I can successfully pull back a users
information using the code below, however, I must know the entire OU
already, as there doesn't seem to be a wildcard search, AND, I can not
filter on username and password.

This works:

cfldap name="authenticate"
server="myschoolsad.edu" 
action="" 
attributes="cn,sn,givenName,mail"
start="OU=department,OU=group,DC=branch,DC=ad,DC=school,DC=edu"
filter="cn=JohnSmith"
sort="sn"
sortcontrol="nocase"
maxrows="100"
username="bindAccountUsername"
password="bindAccountPassword"

However, I can not drop the OU references from the start or it fails and
I can not add a filter like:

(&(cn=#attributes.username#)(Password=#attributes.password

Is anyone doing this or can anyone offer a possible direction.

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




Don't mean to be picky

2004-05-21 Thread Don
In the quest for the separation of business logic layer and presentation layer, went to fusebox.org site, interesting stuff, just for the heck of it, tried an invalid value for a parameter, "fuse" threw a cf error, it's sort of interesting that "fuse" threw its err msg, however, it also included CF server native error msg that revealed full template path, I would hope that wasn't intended.

Agree 100% framework and methodology is extremely important, meantime, if there's a better/systematic approach to Data Validation in addition to what's already available(try/catch/throw etc.), that would improve application security alot well, imho.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: excel files

2004-05-21 Thread Joe Tseng
I don't know if anyone would be interested in this but I'm doing something right now using CF and Excel but I'm using XML and SOAP rather than DSNs (my questions in this list earlier were regarding this little effort of mine).  I created a CFMX web service that would pass an XML string via SOAP to an Excel spreadsheet and the XML would be parsed by VBA to populate a worksheet.

I figured the benefits to this method are:
1 - You can output the results to anything that's SOAP-enabled
2 - Access to the data using this WS can be restricted to only registered users of my associated portal
3 - I wanted to see if it could be done :)

I'd be happy to share what I've got so far if anyone's interested.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Problem with CFC web service & Flash

2004-05-21 Thread Rick Root
Rick Root wrote:

> I've got a web service that I use to authorize users against our DB2
> Mainframe, and I recently changed it up to return an array of CFC
> datatypes instead of a structure.
> 
> The WSDL generates fine... I can call the methods from the browser
> directly.  But when Flash tries to access it, it simply says there was
> an error accessing the URL.
> 
> There is nothing logged in any of the coldfusion logs that I can find..
> all I can find is a 500 server error in the web server's access logs.

I invoked the web service using coldfusion and got the world's ugliest 
error.

"Dependent CFC(s) have been modified"?  seems to be a key issue...

Anyone want to take a stab at this?

  - Rick

"Error","jrpp-202","05/21/04","10:54:16","ADSWEB","Could not perform web 
service invocation ""authByUsername"" because AxisFault   faultCode: 
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException 
faultSubcode:    faultString: [org.apache.axis.AxisFault : ; nested 
exception is:  	coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have 
been modified. Please refresh your web service client.]]; nested 
exception is:  	coldfusion.xml.rpc.CFCInvocationException: 
[org.apache.axis.AxisFault : ; nested exception is: 
coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have 
been modified. Please refresh your web service client.]]   faultActor: 
   faultNode:    faultDetail: 
{http://xml.apache.org/axis/}stackTrace: AxisFault   faultCode: 
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException 
faultSubcode:    faultString: [org.apache.axis.AxisFault : ; nested 
exception is:   	coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.Inco... The specific sequence of files included or processed 
is: E:\Inetpub\wwwroot\components\authorization\authtest.cfm "
coldfusion.xml.rpc.ServiceProxy$ServiceInvocationException: Could not 
perform web service invocation "authByUsername" because AxisFault
  faultCode: 
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
  faultSubcode:
  faultString: [org.apache.axis.AxisFault : ; nested exception is:
	coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have 
been modified. Please refresh your web service client.]]; nested 
exception is:
	coldfusion.xml.rpc.CFCInvocationException: [org.apache.axis.AxisFault : 
; nested exception is:
	coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have 
been modified. Please refresh your web service client.]]
  faultActor:
  faultNode:
  faultDetail:
	{http://xml.apache.org/axis/}stackTrace: AxisFault
  faultCode: 
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
  faultSubcode:
  faultString: [org.apache.axis.AxisFault : ; nested exception is:
	coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have 
been modifie...
	at coldfusion.xml.rpc.ServiceProxy.invokeImpl(ServiceProxy.java:219)
	at coldfusion.xml.rpc.ServiceProxy.invoke(ServiceProxy.java:132)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1582)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:372)
	at 
cfauthtest2ecfm225933356.runPage(E:\Inetpub\wwwroot\components\authorization\authtest.cfm:4)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
	at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:105)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
	at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
	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:294)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
 [Todays Threads] 
 [This Message] 
 [Sub

Re: excel files

2004-05-21 Thread George Abraham
Definitely share. I am not well-versed in XML, SOAP or VBA, but for a 
long-term solution, I could be persuaded to get my butt in gear.

George

At 10:54 AM 5/21/2004, Joe Tseng wrote:
>I don't know if anyone would be interested in this but I'm doing something 
>right now using CF and Excel but I'm using XML and SOAP rather than DSNs 
>(my questions in this list earlier were regarding this little effort of 
>mine).  I created a CFMX web service that would pass an XML string via 
>SOAP to an Excel spreadsheet and the XML would be parsed by VBA to 
>populate a worksheet.
>
>I figured the benefits to this method are:
>1 - You can output the results to anything that's SOAP-enabled
>2 - Access to the data using this WS can be restricted to only registered 
>users of my associated portal
>3 - I wanted to see if it could be done :)
>
>I'd be happy to share what I've got so far if anyone's interested.
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: How does Amazon do that?

2004-05-21 Thread Jeff Langevin
Assuming you have an "orders" table and an "orderDetails" table 
(containing orderID and productID of each item in the order) it would be 
simple.  Query the orderDetails table for any order containing the 
product ID of the item that the customer is looking at.  At the same 
time, pull the other items in those orders that are in the same 
category.  You'd might also want to pull a count of the number of times 
that product was bought at the same time so you can rank them from most 
to least often bought.

--Jeff

Qasim Rasheed wrote:

> I guess they have some sort of Recommendation and Referral  mechanism in
> place. It could be an attributes-based, item-to-item correlation and
> person-to-person correlation (Collaborative Filtering).
> 
> 
> Thanks
> 
> 
> Qasim
> 
> -Original Message-
> From: Tim Blair [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 19, 2004 5:22 AM
> To: CF-Talk
> Subject: RE: How does Amazon do that?
> 
>  > When you look around Amazon.com, and show an interest in
>  > something, there's always a part of the page that says
>  > "people who bought this also bought that
>  > .."   
> 
> The solution I came up with uses two tables - the product table (guess
> what that is?) and a product_link table.  The product_link allows me to
> store, well, links between products in an arbitrary way.
> 
> The link table has a 3-way PK of product ID, associated product ID and
> product link "type" - the type is just a numeric field which represents
> the type of link between the products which in my case includes "similar
> too", "related too", "cross sell with" and "also bought".  The first
> three are set via the admin.
> 
> The final field in the link table is a generic "data" field, which in
> the case of the "also bought" type is a count.  In this way I can grab
> the most popular "also bought" products with a nice simple query by
> ordering by the data field.
> 
> The "also bought" data is not generated on-the-fly - it could take
> wy too long to increment the appropriate counters for each
> product link when someone checks out, so instead it's done nightly (or
> whenever) on a schedule.
> 
> That's just one solution though...
> 
> Tim.
> 
> --
> ---
> 
> Maze Solver - http://tech.badpen.com/cfcontest/
> ---
> RAWNET LTD - Internet, New Media and ebusiness Gurus.
> WE'VE MOVED - for our new address, please visit our
> website at http://www.rawnet.com/ or call us any time
> on 0800 294 24 24.
> ---
> This message may contain information which is legally
> privileged and/or confidential.  If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of rawnet limited,
> unless otherwise explicitly and independently indicated
> by an authorised representative of rawnet limited.
> ---
>   _
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Passing a webservice a file

2004-05-21 Thread David Adams
I am thinking more of a image or doc file.

Is this possible or am I confusing the concept of web services?

>an xml file?
>
>sure.
>
>tw 
>
>-Original Message-
>From: David Adams [mailto:[EMAIL PROTECTED] 
>Sent: Friday, May 21, 2004 10:33 AM
>To: CF-Talk
>Subject: Passing a webservice a file
>
>My understanding of webservices are weak but is it possible to pass a
>webservice a file (as opposed to a string) and have it processed and
>returned?
>
>I am not concerned about how it is processed or returned but whether or not
>a webservice accepts binary files.
>
>Thanks in advance.
>DA
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Extracting an email address out of a text file

2004-05-21 Thread Ben Densmore
I have about 1800 text files that I exported from outlook that are all
bounced emails. I need to extract the email addresses that were bounced
back. Unfortunately not all mail servers bounce messages that look
alike. I was thinking I could just read through each text file and find
where the email address is but in a lot of the files there will be the
email address of the person who the email was originally from, the email
address of the server that bounced the email and the email address who
it was originally sent to.

The only time these files are consistent is when they were bounced by
the same mail server software. I was thinking maybe I will loop through
the ones that are in the same format, i.e. the email address that was
bad looks like ([EMAIL PROTECTED]) and strip out everything but
the email address.

That's the only method I can come up with at the moment, has anyone done
something similar or maybe have a better solution? I really don't want
to manually go through each text file and copy and paste the email
address.

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




RE: Active Directory

2004-05-21 Thread Coleman, Brian
I'm not sure why you wouldn't be able to take off the OUs...but maybe
there's something above the OUs you can use?

My queries I'm playing with to use AD based authentication look like
this 

***first query to connect to ldap and query the username entered***



SERVER="server"

PORT="389"

ACTION="">

  ATTRIBUTES="samaccountname"

  START="CN=Users,DC=root,DC=domain,DC=com"

  SCOPE="subtree"

  FILTER="samaccountname=#user#"

  USERNAME="[EMAIL PROTECTED]"

  PASSWORD="password">

***then a second query to connect as the user and test password***



SERVER="server"

  PORT="389"

  ACTION="">

  ATTRIBUTES="samaccountname"

  START="CN=Users,DC=root,DC=domain,DC=com"

  SCOPE="subtree"

  FILTER="samaccountname=#user#"

  username="[EMAIL PROTECTED]"

  password="#password#">

I don't know if the first query is really needed, but if the first query
fails, you know its not a valid username and if the second fails you
know its not a valid password

I used this tool to see more into ldap and copied out some of the DN
stuff it found to get my start string 

http://www.iit.edu/~gawojar/ldap/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Extracting an email address out of a text file

2004-05-21 Thread Claude Schneegans
>> I really don't want
to manually go through each text file and copy and paste the email

For this I would try to use CF_REextract to extract the address in its context.
The address is variable, but the context is not.
See CF_REextract at
http://www.contentbox.com/claude/customtags/tagstore.cfm

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Extracting an email address out of a text file

2004-05-21 Thread Bryan F. Hogan
I can vouch for cf_reextract. I use it as a spider for a web cvs I wrote 
and it works wonderfully.

Claude Schneegans wrote:

>  >> I really don't want
> to manually go through each text file and copy and paste the email
> 
> For this I would try to use CF_REextract to extract the address in its 
> context.
> The address is variable, but the context is not.
> See CF_REextract at
> http://www.contentbox.com/claude/customtags/tagstore.cfm
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Don't mean to be picky

2004-05-21 Thread Greg Luce
Yeah, IMHO FB 4/MVC is the ultimate in business logic/presentation later
separation. I just finished my first FB4/MVC project, and I'm very happy
with the way it turned out. A widely adapted methodology. Great support
community.

You're right, that error on fusebox.org is careless.

Greg

-Original Message-
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 10:54 AM
To: CF-Talk
Subject: Don't mean to be picky

In the quest for the separation of business logic layer and presentation
layer, went to fusebox.org site, interesting stuff, just for the heck of it,
tried an invalid value for a parameter, "fuse" threw a cf error, it's sort
of interesting that "fuse" threw its err msg, however, it also included CF
server native error msg that revealed full template path, I would hope that
wasn't intended.

Agree 100% framework and methodology is extremely important, meantime, if
there's a better/systematic approach to Data Validation in addition to
what's already available(try/catch/throw etc.), that would improve
application security alot well, imho.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Comma in price

2004-05-21 Thread Robert Orlini
I'm using dollarformat to convert prices. However, if I user inputs a large price with a comma, such as 1,200.00 it generates a "cannot convert number" error. To save time, what is the best way to allow a user to enter a comma and still be able to calculate the price against a quantity.

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




RE: Don't mean to be picky

2004-05-21 Thread Lofback, Chris
> A widely adapted methodology.

"adapted" = great typo/pun!

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




'Select' statement question!

2004-05-21 Thread cf coder
The following code is in a stored procedure. Can
somebody please just confirm if this is a valid SQL
Statement. I appreciate this is not a SQL Forum. I'm a
ColdFusion developer and am trying to query the db.

SET @SQLStatement = @SQLStatement + 'SELECT * From
Employee where Employee.asstetID IN (select distinct
Employee.callNo from Employee where Employee.asst_id
IN (select Assets.asst_id from Assets where bar_code =
' + char(39) + @asset + char(39) + '))'

Thanks in advance

	
		
__
Do you Yahoo!?
Yahoo! Domains – Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Comma in price

2004-05-21 Thread Claude Schneegans
Just remove any comma from the string first:


--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Comma in price

2004-05-21 Thread Rick Root
Robert Orlini wrote:

> I'm using dollarformat to convert prices. However, if I user inputs a 
> large price with a comma, such as 1,200.00 it generates a "cannot 
> convert number" error. To save time, what is the best way to allow a 
> user to enter a comma and still be able to calculate the price against a 
> quantity.

How about:

#Replace(inputVar,",","","ALL")#

Just remove the commas

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




Re: 'Select' statement question!

2004-05-21 Thread Alexander Sherwood
At 11:42 AM 5/21/2004, you wrote:
>The following code is in a stored procedure. Can
>somebody please just confirm if this is a valid SQL
>Statement. I appreciate this is not a SQL Forum. I'm a
>ColdFusion developer and am trying to query the db.
>
>SET @SQLStatement = @SQLStatement + 'SELECT * From
>Employee where Employee.asstetID IN (select distinct
>Employee.callNo from Employee where Employee.asst_id
>IN (select Assets.asst_id from Assets where bar_code =
>' + char(39) + @asset + char(39) + '))'
>
>Thanks in advance

May not be able to nest sub-queries.

You using MS SQL Server?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Extracting an email address out of a text file

2004-05-21 Thread Jochem van Dieten
Ben Densmore wrote:

> I have about 1800 text files that I exported from outlook that are all
> bounced emails. I need to extract the email addresses that were bounced
> back. Unfortunately not all mail servers bounce messages that look
> alike. I was thinking I could just read through each text file and find
> where the email address is but in a lot of the files there will be the
> email address of the person who the email was originally from, the email
> address of the server that bounced the email and the email address who
> it was originally sent to.
> 
> The only time these files are consistent is when they were bounced by
> the same mail server software. I was thinking maybe I will loop through
> the ones that are in the same format, i.e. the email address that was
> bad looks like ([EMAIL PROTECTED]) and strip out everything but
> the email address.

That is indeed the way to go. In some cases it is easy, for 
instance if you want to get all AOL bounces you can do a simple 
regex replace on your email:
REReplaceNoCase(email,"^.*- The following addresses had 
permanent fatal errors -(.+)- Transcript of session 
follows -.*$","\1")
Simple patterns like these should find you most of the addresses, 
just look for 5xx (permanent) error codes next to an email 
address. But it is a case of diminishing returns and at some 
point it is easier to do the rest by hand.

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




Re: 'Select' statement question!

2004-05-21 Thread cf coder
Sorry, I made a typo mistake. This is the correct sql

SET @SQLStatement = @SQLStatement + 'SELECT * From
Employee where Employee.callNo IN (select distinct
Employee.callNo from Employee where Employee.asst_id
IN (select Assets.asst_id from Assets where bar_code =
' + char(39) + @asset + char(39) + '))'

I'll try and explain what I'm trying to do

I have two tables.

Employee and Assets

The Employee Table has two columns:

CallNo and Asst_id

The Assets table contains all the asset information, the primary key being Asst_ID.

I want to return distinct Employee records. The CallNo column in the employee table can more than one callNo with the same value.

Ex:

Employee Table:

Asst_ID   CallNo

1 0BRC
2 0BRC
3 0BRC0001

I want to only return distince employee records. Hope this is making sense
>The following code is in a stored procedure. Can
>somebody please just confirm if this is a valid SQL
>Statement. I appreciate this is not a SQL Forum. I'm a
>ColdFusion developer and am trying to query the db.
>
>SET @SQLStatement = @SQLStatement + 'SELECT * From
>Employee where Employee.asstetID IN (select distinct
>Employee.callNo from Employee where Employee.asst_id
>IN (select Assets.asst_id from Assets where bar_code =
>' + char(39) + @asset + char(39) + '))'
>
>Thanks in advance
>
>
>	
>		
>__
>Do you Yahoo!?
>Yahoo! Domains – Claim yours for only $14.70/year
>http://smallbusiness.promotions.yahoo.com/offer
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: 'Select' statement question!

2004-05-21 Thread cf coder
yes I am using MS SQL Server
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




retreive the FORM name?

2004-05-21 Thread Claude Schneegans
Hi,

Any one knows if it is possible to retreive the form name from the template fired by a form?

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: 'Select' statement question!

2004-05-21 Thread Jochem van Dieten
cf coder wrote:

> The following code is in a stored procedure. Can
> somebody please just confirm if this is a valid SQL
> Statement. I appreciate this is not a SQL Forum. I'm a
> ColdFusion developer and am trying to query the db.
> 
> SET @SQLStatement = @SQLStatement + 'SELECT * From
> Employee where Employee.asstetID IN (select distinct
> Employee.callNo from Employee where Employee.asst_id
> IN (select Assets.asst_id from Assets where bar_code =
> ' + char(39) + @asset + char(39) + '))'

I don't think it is valid because the use of "Employee" in the 
predicate of the subquery is ambiguous. Further the DISTINCT is 
superfluous. Try something like:
SELECT	*
FROM	Employee E1
WHERE	E1.asstetID IN (
	SELECT	E2.callNo
	FROM	Employee E2
	WHERE	E2.asst_id IN (
		SELECT	Assets.asst_id
		FROM	Assets
		WHERE	bar_code =' + char(39) + @asset + char(39) + '
		)
	)

I have no idea about all the + and char() functions because that 
obviously is not standard SQL and you didn't tell which DBMS you 
are using. But I would flatten out the subqueries and rewrite the 
whole thing as:
SELECT	E1.*
FROM	Employee E1 INNER JOIN Employee E2
		ON E1.AsstetID = E2.callNo INNER JOIN Assets A
			ON E2.asst_id = A.asst_id
WHERE	A.bar_code =' + char(39) + @asset + char(39) + '

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




Re: retreive the FORM name?

2004-05-21 Thread Charlie Griefer
not via CF.  you'd need to put it in a hidden form field.

just out of curiousity...why would you need the form name?

- Original Message - 
From: "Claude Schneegans" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 21, 2004 8:56 AM
Subject: retreive the FORM name?

> Hi,
>
> Any one knows if it is possible to retreive the form name from the
template fired by a form?
>
> --
> ___
> See some cool custom tags here:
> http://www.contentbox.com/claude/customtags/tagstore.cfm
> Please send any spam to this address: [EMAIL PROTECTED]
> Thanks.
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Comma in price

2004-05-21 Thread Robert Orlini
Thanks Rick and Claude. It worked.

 
RO

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 11:44 AM
To: CF-Talk
Subject: Re: Comma in price

Just remove any comma from the string first:


--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks. 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: retreive the FORM name?

2004-05-21 Thread Bryan F. Hogan
Try this, just a thought.


	


function checkForm(theForm) {
document.forms[theForm.name].theFormsName.value=theForm.name;
return true;
}
checkForm(this)"> Claude Schneegans wrote: > Any one knows if it is possible to retreive the form name from the > template fired by a form? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Extracting an email address out of a text file

2004-05-21 Thread Scott Weikert
There's also a tag on the DevEx, "StripEmail" - you pass it a string and 
it'll pull out email addresses and return them as a list. Works great for me.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: retreive the FORM name?

2004-05-21 Thread Guy Rish
Claude,

Since only one form can post per request it is presumed that you will know
because of the form's linkage to the ACTION.  
If you are using one uber ACTION handler then create a hidden INPUT that
contains the name of the form.  This can lead to problems though and it not
the better choice.  If your uber ACTION handler is handling so much stuff
that such a thing matters then you should consider breaking it out into
multiple templates.

rish

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 10:56 AM
To: CF-Talk
Subject: retreive the FORM name?

Hi,

Any one knows if it is possible to retreive the form name from the template
fired by a form?

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Extracting an email address out of a text file

2004-05-21 Thread Ben Densmore
Thanks Claude, I bought the tag and it seems to work ok. I'm wondering
if someone can help me with a reg ex. Just playing around with the tag I
was trying:



INPUTMODE="File"

INPUT="c:\cfusionmx\wwwroot\email_blast\#name#"

OUTPUTMODE="output"

RE1="([[:alnum:]_\.\-]+@([[:alnum:]_\.\-]))"

RE2="\.+[[:alpha:]]{2,4}"

>

Which I thought would extract email addresses but it doesn't seem to be
working. Since I suck at them I'm sure I'm doing something wrong with
it. Can anyone modify this reg ex a little for me?

Thanks,

Ben

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 21, 2004 11:19 AM
To: CF-Talk
Subject: Re: Extracting an email address out of a text file

>> I really don't want
to manually go through each text file and copy and paste the email

For this I would try to use CF_REextract to extract the address in its
context.
The address is variable, but the context is not.
See CF_REextract at
http://www.contentbox.com/claude/customtags/tagstore.cfm

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.


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




Re: Problem with CFC web service & Flash

2004-05-21 Thread Rick Root
Here is my WSDL:

https://www.ads.duke.edu/components/authorization/authorize.cfc?WSDL

and a sample HTTP invocation...

https://www.ads.duke.edu/components/authorization/authorize.cfc?method=authByUsername&UNAME=foo&PWORD=foo&SPECIFICLOGINS=&SPECIFICGROUPS=&APPNAME=ENTITY_LOOKUP

But it will NOT invoke via CFINVOKE or via Flash

HELP!

Rick Root wrote:

> Rick Root wrote:
> 
>  > I've got a web service that I use to authorize users against our DB2
>  > Mainframe, and I recently changed it up to return an array of CFC
>  > datatypes instead of a structure.
>  >
>  > The WSDL generates fine... I can call the methods from the browser
>  > directly.  But when Flash tries to access it, it simply says there was
>  > an error accessing the URL.
>  >
>  > There is nothing logged in any of the coldfusion logs that I can find..
>  > all I can find is a 500 server error in the web server's access logs.
> 
> I invoked the web service using coldfusion and got the world's ugliest
> error.
> 
> "Dependent CFC(s) have been modified"?  seems to be a key issue...
> 
> Anyone want to take a stab at this?
> 
>   - Rick
> 
> "Error","jrpp-202","05/21/04","10:54:16","ADSWEB","Could not perform web
> service invocation ""authByUsername"" because AxisFault   faultCode:
> {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
> faultSubcode:    faultString: [org.apache.axis.AxisFault : ; nested
> exception is:   coldfusion.xml.rpc.CFCInvocationException:
> [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have
> been modified. Please refresh your web service client.]]; nested
> exception is:   coldfusion.xml.rpc.CFCInvocationException:
> [org.apache.axis.AxisFault : ; nested exception is:
> coldfusion.xml.rpc.CFCInvocationException:
> [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have
> been modified. Please refresh your web service client.]]   faultActor:
>    faultNode:    faultDetail:
> {http://xml.apache.org/axis/}stackTrace: AxisFault   faultCode:
> {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
> faultSubcode:    faultString: [org.apache.axis.AxisFault : ; nested
> exception is:    coldfusion.xml.rpc.CFCInvocationException:
> [java.lang.Inco... The specific sequence of files included or processed
> is: E:\Inetpub\wwwroot\components\authorization\authtest.cfm "
> coldfusion.xml.rpc.ServiceProxy$ServiceInvocationException: Could not
> perform web service invocation "authByUsername" because AxisFault
>   faultCode:
> {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
>   faultSubcode:
>   faultString: [org.apache.axis.AxisFault : ; nested exception is:
> coldfusion.xml.rpc.CFCInvocationException:
> [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have
> been modified. Please refresh your web service client.]]; nested
> exception is:
> coldfusion.xml.rpc.CFCInvocationException: [org.apache.axis.AxisFault :
> ; nested exception is:
> coldfusion.xml.rpc.CFCInvocationException:
> [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have
> been modified. Please refresh your web service client.]]
>   faultActor:
>   faultNode:
>   faultDetail:
> {http://xml.apache.org/axis/}stackTrace: AxisFault
>   faultCode:
> {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
>   faultSubcode:
>   faultString: [org.apache.axis.AxisFault : ; nested exception is:
> coldfusion.xml.rpc.CFCInvocationException:
> [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have
> been modifie...
> at coldfusion.xml.rpc.ServiceProxy.invokeImpl(ServiceProxy.java:219)
> at coldfusion.xml.rpc.ServiceProxy.invoke(ServiceProxy.java:132)
> at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1582)
> at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:372)
> at
> cfauthtest2ecfm225933356.runPage(E:\Inetpub\wwwroot\components\authorization\authtest.cfm:4)
> at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
> at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
> at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
> at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
> at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
> at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
> at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
> at
> coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
> at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
> at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
> at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
> at coldfusion.CfmServlet.service(CfmServlet.java:105)
> at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
> at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
> at
> jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
> at
> jrun.servlet.Ser

Re: retreive the FORM name?

2004-05-21 Thread Claude Schneegans
>>Since only one form can post per request it is presumed that you will know
because of the form's

Sure, but a template can contain several forms which all call the same template, even if only one is submitted.
My question is then to detect the one that fired the template.

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Problem with CFC web service & Flash

2004-05-21 Thread Rick Root
More info... this definately has something to do with my CFC datatypes..

Here's the code where I'm invoking the CFC datatypes:
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: 'Select' statement question!

2004-05-21 Thread cf coder
Thanks Jochem, but your sql returns duplicate callNo's. I tried both your queries.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: retreive the FORM name?

2004-05-21 Thread Claude Schneegans
>>Try this, just a thought.

Ok, but it is precisely what I'm looking a simpler solution for.

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT: Javacript Onclick Question

2004-05-21 Thread Casey C Cook
I would like to know if this is possible, I know very little about 
_javascript_, but if if someone could point me in the right direction I can 
do the research. Heres what Im trying to do.

I have my main display page which calls a custom header. This custom 
header has an  link that logs the user off when clicked. What I 
want to do now is to add a pop-up box that prompts the user to confirm 
that they are logging off. Heres the kicker, I cant modify the customer 
header, so how do I write _javascript_ from my main display page to add the 
pop-up box on the link in the custom header?

Thanks for you help!
Casey Cook
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Extracting an email address out of a text file

2004-05-21 Thread Claude Schneegans
>> I bought the tag

Congratulations: you're on the right track ! ;-)

>>if someone can help me with a reg ex. Just playing around with the tag I
was trying:

Sure, try the REWizard, same author, same address, and this one is on line and free.
Make sure you work with the CF syntax, not the _javascript_.

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: retreive the FORM name?

2004-05-21 Thread GFSCold
What if you give the submit buttons unique names.  That way you can check
which form you are processing by the name of the submit button that was
pressed.

Jim Audette
Website Administrator
Garrison Forest School
300 Garrison Forest Road
Owings Mills, MD 21117
[EMAIL PROTECTED]
410-559-3128
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Javacript Onclick Question

2004-05-21 Thread Barney Boisvert
You'll need to get a reference to the link object, and then you can add a
custom onClick handler to the object.  If the A tag has an id attribute,
then it's simple, just use document.getElementById(id_of_anchor) to get the
object.  If it doesn't, then you'll have to us document.links (I don't know
how portable that is), or do a parse of the node tree and identify the link
from the mess, probably by checking the href or innerHTML property.

Cheers,
barneyb

> -Original Message-
> From: Casey C Cook [mailto:[EMAIL PROTECTED] 
> Sent: Friday, May 21, 2004 9:33 AM
> To: CF-Talk
> Subject: SOT: Javacript Onclick Question
> 
> I would like to know if this is possible, I know very little about 
> _javascript_, but if if someone could point me in the right 
> direction I can 
> do the research. Heres what Im trying to do.
> 
> I have my main display page which calls a custom header. This custom 
> header has an  link that logs the user off when 
> clicked. What I 
> want to do now is to add a pop-up box that prompts the user 
> to confirm 
> that they are logging off. Heres the kicker, I cant modify 
> the customer 
> header, so how do I write _javascript_ from my main display 
> page to add the 
> pop-up box on the link in the custom header?
> 
> Thanks for you help!
> Casey Cook
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Selecting by row or CurrentRow

2004-05-21 Thread Pascal Peters
qProduct.field[theRowIWant] 

> -Original Message-
> From: Nando [mailto:[EMAIL PROTECTED] 
> Sent: vrijdag 21 mei 2004 13:11
> To: CF-Talk
> Subject: Selecting by row or CurrentRow
> 
> Could someone remind me of the syntax to select by row? I 
> don't remember where to find that. Thanx
> 
> Select * From qProduct
> Where CurrentRow = #theRowIWant#
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




  1   2   >