Bugged Out CFERROR : CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino


I got the following error when making a call to a custom tag.

Here are the facts:
  1. I know the tag works. Its been tested and other applications use.
  2. I have tried several methods of calling the tag including the
following:
 - calling from the same directory using both CFMODULE and
CF_customTag
 - calling from a subdirectory using CFMODULE
 - calling from coldfusions custom tag directory using CF_customTag
  3. Heres the strange one. A query is passed to the Custom Tag. The tag
works with the following query (its from of the applications using it):

  CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
SELECT Identifier AS ID, ParentNode AS
ParentID, Name AS Label
FROM Node
ORDER BY ParentNode, SortOrder
  /CFQUERY

  when I change the query to pull data from another table and
datasource it chokes. I know the data is pulling I tested it. Here is that
query:

  CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
SELECTIdentifier AS ID, Parent AS ParentID,
Name AS Label
FROMTopic
ORDER BY ParentID, SortOrder
  /CFQUERY

  4. Here is the error:

 Error Diagnostic Information
 unknown exception condition

 CFMLInterpreterImp::process

Any help on this one will be greatly appreciated. Thanks in advance.

Jerry T.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino

I got the following error when making a call to a custom tag.

Here are the facts:
  1. I know the tag works. Its been tested and other applications use.
  2. I have tried several methods of calling the tag including the
following:
 - calling from the same directory using both CFMODULE and
CF_customTag
 - calling from a subdirectory using CFMODULE
 - calling from coldfusions custom tag directory using CF_customTag
  3. Heres the strange one. A query is passed to the Custom Tag. The tag
works with the following query (its from of the applications using it):

  CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
SELECT Identifier AS ID, ParentNode AS
ParentID, Name AS Label
FROM Node
ORDER BY ParentNode, SortOrder
  /CFQUERY

  when I change the query to pull data from another table and
datasource it chokes. I know the data is pulling I tested it. Here is that
query:

  CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
SELECTIdentifier AS ID, Parent AS ParentID,
Name AS Label
FROMTopic
ORDER BY ParentID, SortOrder
  /CFQUERY

  4. Here is the error:

 Error Diagnostic Information
 unknown exception condition

 CFMLInterpreterImp::process

Any help on this one will be greatly appreciated. Thanks in advance.

Jerry


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Fred T. Sanders

get rid of the ,sortorder  it should just be a space and either ASC or DES
- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 9:54 AM
Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


 I got the following error when making a call to a custom tag.

 Here are the facts:
   1. I know the tag works. Its been tested and other applications use.
   2. I have tried several methods of calling the tag including the
 following:
  - calling from the same directory using both CFMODULE and
 CF_customTag
  - calling from a subdirectory using CFMODULE
  - calling from coldfusions custom tag directory using
CF_customTag
   3. Heres the strange one. A query is passed to the Custom Tag. The tag
 works with the following query (its from of the applications using it):

   CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
 SELECT Identifier AS ID, ParentNode AS
 ParentID, Name AS Label
 FROM Node
 ORDER BY ParentNode, SortOrder
   /CFQUERY

   when I change the query to pull data from another table and
 datasource it chokes. I know the data is pulling I tested it. Here is that
 query:

   CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
 SELECTIdentifier AS ID, Parent AS ParentID,
 Name AS Label
 FROMTopic
 ORDER BY ParentID, SortOrder
   /CFQUERY

   4. Here is the error:

  Error Diagnostic Information
  unknown exception condition

  CFMLInterpreterImp::process

 Any help on this one will be greatly appreciated. Thanks in advance.

 Jerry


 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Fred T. Sanders

and they don't always like you ordering by the alias, do it by the original
name instead.

- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 9:54 AM
Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


 I got the following error when making a call to a custom tag.

 Here are the facts:
   1. I know the tag works. Its been tested and other applications use.
   2. I have tried several methods of calling the tag including the
 following:
  - calling from the same directory using both CFMODULE and
 CF_customTag
  - calling from a subdirectory using CFMODULE
  - calling from coldfusions custom tag directory using
CF_customTag
   3. Heres the strange one. A query is passed to the Custom Tag. The tag
 works with the following query (its from of the applications using it):

   CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
 SELECT Identifier AS ID, ParentNode AS
 ParentID, Name AS Label
 FROM Node
 ORDER BY ParentNode, SortOrder
   /CFQUERY

   when I change the query to pull data from another table and
 datasource it chokes. I know the data is pulling I tested it. Here is that
 query:

   CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
 SELECTIdentifier AS ID, Parent AS ParentID,
 Name AS Label
 FROMTopic
 ORDER BY ParentID, SortOrder
   /CFQUERY

   4. Here is the error:

  Error Diagnostic Information
  unknown exception condition

  CFMLInterpreterImp::process

 Any help on this one will be greatly appreciated. Thanks in advance.

 Jerry


 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino

That has nothing to do with this error. ASC is the default sort type on
SQL. And just for the record I tried what you suggested and nothing
happened.

Jerry T.




"Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 09:59:45 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk [EMAIL PROTECTED]
cc:(bcc: Jerry Tolentino/SIAC)
Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




get rid of the ,sortorder  it should just be a space and either ASC or DES
- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 9:54 AM
Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


 I got the following error when making a call to a custom tag.

 Here are the facts:
   1. I know the tag works. Its been tested and other applications use.
   2. I have tried several methods of calling the tag including the
 following:
  - calling from the same directory using both CFMODULE and
 CF_customTag
  - calling from a subdirectory using CFMODULE
  - calling from coldfusions custom tag directory using
CF_customTag
   3. Heres the strange one. A query is passed to the Custom Tag. The tag
 works with the following query (its from of the applications using it):

   CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
 SELECT Identifier AS ID, ParentNode AS
 ParentID, Name AS Label
 FROM Node
 ORDER BY ParentNode, SortOrder
   /CFQUERY

   when I change the query to pull data from another table and
 datasource it chokes. I know the data is pulling I tested it. Here is
that
 query:

   CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
 SELECTIdentifier AS ID, Parent AS ParentID,
 Name AS Label
 FROMTopic
 ORDER BY ParentID, SortOrder
   /CFQUERY

   4. Here is the error:

  Error Diagnostic Information
  unknown exception condition

  CFMLInterpreterImp::process

 Any help on this one will be greatly appreciated. Thanks in advance.

 Jerry



--

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.






--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Fred T. Sanders

Fair enough, I didn't read it thoroughly, no coffee yet.

Okay need more info.

OS on the server
version of CFAS running
version and brand of database.

Also is that the complete error or are there other sorid details being
displayed that you didn't cut and paste for us.

Fred

- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 10:55 AM
Subject: Re: Bugged Out CFERROR - CFMLInterpreterImp::process


 That has nothing to do with this error. ASC is the default sort type on
 SQL. And just for the record I tried what you suggested and nothing
 happened.

 Jerry T.




 "Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 09:59:45 AM

 Please respond to [EMAIL PROTECTED]

 To:   CF-Talk [EMAIL PROTECTED]
 cc:(bcc: Jerry Tolentino/SIAC)
 Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




 get rid of the ,sortorder  it should just be a space and either ASC or DES
 - Original Message -
 From: "Jerry Tolentino" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, October 02, 2000 9:54 AM
 Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


  I got the following error when making a call to a custom tag.
 
  Here are the facts:
1. I know the tag works. Its been tested and other applications use.
2. I have tried several methods of calling the tag including the
  following:
   - calling from the same directory using both CFMODULE and
  CF_customTag
   - calling from a subdirectory using CFMODULE
   - calling from coldfusions custom tag directory using
 CF_customTag
3. Heres the strange one. A query is passed to the Custom Tag. The tag
  works with the following query (its from of the applications using it):
 
CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
  SELECT Identifier AS ID, ParentNode AS
  ParentID, Name AS Label
  FROM Node
  ORDER BY ParentNode, SortOrder
/CFQUERY
 
when I change the query to pull data from another table and
  datasource it chokes. I know the data is pulling I tested it. Here is
 that
  query:
 
CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
  SELECTIdentifier AS ID, Parent AS ParentID,
  Name AS Label
  FROMTopic
  ORDER BY ParentID, SortOrder
/CFQUERY
 
4. Here is the error:
 
   Error Diagnostic Information
   unknown exception condition
 
   CFMLInterpreterImp::process
 
  Any help on this one will be greatly appreciated. Thanks in advance.
 
  Jerry
 
 
 
 --
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 

 --
-
 ---
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.






 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino


I found out what the problem was and it almost freaks me out. I don't know
if ColdFusion or SQL is to blame yet.

The problem seems to occurr when you pull data from a table whose column
identity seed is 0. Don't ask me why (at least not yet)? I just know that
did for me.

I changed the identity seed to 1 and it worked perferctly.





"Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 11:46:19 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk [EMAIL PROTECTED]
cc:(bcc: Jerry Tolentino/SIAC)
Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




Fair enough, I didn't read it thoroughly, no coffee yet.

Okay need more info.

OS on the server
version of CFAS running
version and brand of database.

Also is that the complete error or are there other sorid details being
displayed that you didn't cut and paste for us.

Fred

- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 10:55 AM
Subject: Re: Bugged Out CFERROR - CFMLInterpreterImp::process


 That has nothing to do with this error. ASC is the default sort type on
 SQL. And just for the record I tried what you suggested and nothing
 happened.

 Jerry T.




 "Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 09:59:45 AM

 Please respond to [EMAIL PROTECTED]

 To:   CF-Talk [EMAIL PROTECTED]
 cc:(bcc: Jerry Tolentino/SIAC)
 Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




 get rid of the ,sortorder  it should just be a space and either ASC or
DES
 - Original Message -
 From: "Jerry Tolentino" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, October 02, 2000 9:54 AM
 Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


  I got the following error when making a call to a custom tag.
 
  Here are the facts:
1. I know the tag works. Its been tested and other applications use.
2. I have tried several methods of calling the tag including the
  following:
   - calling from the same directory using both CFMODULE and
  CF_customTag
   - calling from a subdirectory using CFMODULE
   - calling from coldfusions custom tag directory using
 CF_customTag
3. Heres the strange one. A query is passed to the Custom Tag. The
tag
  works with the following query (its from of the applications using it):
 
CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
  SELECT Identifier AS ID, ParentNode AS
  ParentID, Name AS Label
  FROM Node
  ORDER BY ParentNode, SortOrder
/CFQUERY
 
when I change the query to pull data from another table and
  datasource it chokes. I know the data is pulling I tested it. Here is
 that
  query:
 
CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
  SELECTIdentifier AS ID, Parent AS ParentID,
  Name AS Label
  FROMTopic
  ORDER BY ParentID, SortOrder
/CFQUERY
 
4. Here is the error:
 
   Error Diagnostic Information
   unknown exception condition
 
   CFMLInterpreterImp::process
 
  Any help on this one will be greatly appreciated. Thanks in advance.
 
  Jerry
 
 
 

--
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 


--
-
 ---
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.







--

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.






--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.