Re: Struct Insert

2004-09-14 Thread Andrew Grosset
>Isn't that what the Allow Overwrite is for?
>To overwrite the key if it exists?
>
>Ricardo.
>
>
>Douglas Knudsen wrote:
>
>>

I think you need to change it to "true" instead of "false" to allow the key to be overwritten (I'm not 100% sure on this but it would be easy to set up a test template to try it out).
  As I understand it the default value is false which prevents overwriting the key.
   Alternatively do a StructKeyExists and if it does use StructUpdate(structure, key, value) to update its value.

Andrew.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Struct Insert

2004-09-14 Thread Pascal Peters
Yes, but you have to set it to true. If you set it to false, it will
throw an error if the key already exists. If you don't care, set it to
true.

Personally I always use:

 
(if I want to insert if it exists or not)

OR




Or

value="#tmpFieldList.defaultvalue#">
(if I only want to insert if it doesn't exist)

Pascal

> -Original Message-
> From: Ricardo Russon [mailto:[EMAIL PROTECTED]
> Sent: 15 September 2004 07:28
> To: CF-Talk
> Subject: Re: Struct Insert
> 
> Isn't that what the Allow Overwrite is for?
> To overwrite the key if it exists?
> 
> Ricardo.
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Struct Insert

2004-09-14 Thread Ricardo Russon
Isn't that what the Allow Overwrite is for?
To overwrite the key if it exists?

Ricardo.

Douglas Knudsen wrote:

> keys must be unique.  Does  show a
> unique list of ids?
>
> Doug
>
> - Original Message -
> From: Ricardo Russon <[EMAIL PROTECTED]>
> Date: Wed, 15 Sep 2004 09:49:55 +1000
> Subject: Re: Struct Insert
> To: CF-Talk <[EMAIL PROTECTED]>
>
> Ok, now i have the try catch working again. dunno what
> happened, but i am using the exact same code.
>
> but that is a very slow process. why can't i use the structInsert ?
>
> Thanks
> Ricardo.
>
> Ricardo Russon wrote:
>
> > this is weird, on my dev box this code works
> >
> > 
> > tmpFieldList.defaultvalue, false)>
> >
> > but on the production box, it tells me :
> >
> > "Cannot insert item with key 1. This key already exists. "
> >
> > This happens from time to time, i don't know why, but when it does
> > i usually put a   around it.
> >
> > 
> >  
> >   
> >   
> > tmpFieldList.defaultvalue, false)>
> >
> > 
> >
> > but it is still giving me the same error. wtf??
> >
> > I know that cf has troubles with variable names that start with numbers.
> > but up
> > until a few weeks ago it didn't seem to care to much.
> >
> > TIA
> > Ricardo.
> >
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: [solved] flash remoting on osx

2004-09-14 Thread Pete Freitag
The problem was that I set my cfmx context path to /, and I had JRun's 
flash remoting installed, this caused a conflict between cf flash 
remoting and jrun flash remoting!

__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Read directory

2004-09-14 Thread Asim Manzur
I think I resolved it.

 
select UPPER(name) as fsort, * from eng1
where eng1.name in ('#replace(valuelist(fre1.name), ",", "','","all")#') 
ORDER by fsort ASC
 

is that right?


> one more thing I have to resove in this issue is I need those filename 
> sorted alphabetically.
> 
> I try to use the ORDER BY eng1.name ASC
> 
> but in the middle of the page somewhere its finished on 'Z' and then 
> start again from 'A' (that start is unique, i.e. not repeating).
> 
> I don't know where I am doing wrong, also could you please mentioned 
> that which query should I output to get the filenames which are in 
> both directory?
> 
> 
> 
> 
> 
> 
> sort="name"> 
> 
> sort="name"> 
> 
>  
> select * from eng1, fre1
> where fre1.name = eng1.name 
>  
>  
> select * from eng1
> where eng1.name in ('#replace(valuelist(fre1.name), ",", "','",
> "all")#') 
> ORDER by eng1.name ASC
>  
> 
>  
> select * from fre1
> where fre1.name in ('#replace(valuelist(eng1.name), ",", "','",
> "all")#')
> ORDER by fre1.name ASC 
>  
> 
> and then I output the query "f_notin_e" ( I've dump both and it looks 
> both are generating the same output i.e. "f_notin_e" & "e_notin_f"
> 
> please advise that which query should I output and the filenames are 
> not sorted.
> 
> thanks
> 
> 
> 
> 
> > Thank alot for help.
> > it was a map drive and I was trying to access that directory from my 
> 
> > local machine, in that case the structure was empty.
> > When I put the codes on server(then it becomes a local drive) and it 
> 
> > gave me the required output.
> > 
> > thanks once again.
> > - 
Asim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: any java cf'ers online?

2004-09-14 Thread Spike
Yep,

Did you have a particular question or were you running a poll ;)

Spike


Stephen Milligan
Code poet for hire
http://www.spike.org.uk

Do you cfeclipse? http://cfeclipse.tigris.org 


>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of Lori
>Sent: Tuesday, September 14, 2004 8:17 PM
>To: CF-Talk
>Subject: Fw: any java cf'ers online?
>
>Anyone out there right now that uses java with cf?
>
>-Lori
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Fw: any java cf'ers online?

2004-09-14 Thread Dave Jones
Yes. Any particular question?

Dave Jones
NetEffect

At 08:17 PM 9/14/04, you wrote:
>Anyone out there right now that uses java with cf?
>
>-Lori
>
>--
>[Todays 
>Threads] 
>[This 
>Message] 
>[Subscription] 
>[Fast 
>Unsubscribe] [User 
>Settings] 
>[Donations 
>and Support]
>
>--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Fw: any java cf'ers online?

2004-09-14 Thread Ricardo Russon
I am currently writing a mail client using javamail.
??
Ricardo.

Lori wrote:

> Anyone out there right now that uses java with cf?
>
> -Lori
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: any java cf'ers online?

2004-09-14 Thread Michael Dinowitz
If you check out cflib.org you'll find many UDFs that use Java for their work.

> Anyone out there right now that uses java with cf?
>
> -Lori
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




cffile write question, sending but not parsing cf code

2004-09-14 Thread mayo
I'm using cffile to allow a magazine site to publish articles and not have a
db call everytime an article is selected. Is there anyway (aside from
includes) that I can use send up cf code such as CGI.path_info without it
being parsed when the cffile is being written?

Example:

For example /admin/createFile.cfm creates a file called
/stories/2004-1234.cfm

I would like CGI.path_info to display

/stories/2004-1234.cfm not /admin/createFile.cfm

I also would like to be able to have

 etc... processed when the article is requested by the user and not
when the CFFILE is executed.

thx, hope this is understandable

Gil
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Read directory

2004-09-14 Thread Asim Manzur
one more thing I have to resove in this issue is I need those filename sorted alphabetically.

I try to use the ORDER BY eng1.name ASC

but in the middle of the page somewhere its finished on 'Z' and then start again from 'A' (that start is unique, i.e. not repeating).

I don't know where I am doing wrong, also could you please mentioned that which query should I output to get the filenames which are in both directory?




 
 

 
select * from eng1, fre1
where fre1.name = eng1.name 
 
 
select * from eng1
where eng1.name in ('#replace(valuelist(fre1.name), ",", "','","all")#') 
ORDER by eng1.name ASC
 

 
select * from fre1
where fre1.name in ('#replace(valuelist(eng1.name), ",", "','","all")#')
ORDER by fre1.name ASC 
 

and then I output the query "f_notin_e" ( I've dump both and it looks both are generating the same output i.e. "f_notin_e" & "e_notin_f"

please advise that which query should I output and the filenames are not sorted.

thanks


> Thank alot for help.
> it was a map drive and I was trying to access that directory from my 
> local machine, in that case the structure was empty.
> When I put the codes on server(then it becomes a local drive) and it 
> gave me the required output.
> 
> thanks once again.
> - 
Asim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Ewok
I don’t see anything about the “Browse” button for a file type form field on
there. Any other button is pretty easy to set styles or use images for. Any
elements onclick could SUBMIT a form.

   _  

From: dave [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 5:35 PM
To: CF-Talk
Subject: RE: SOT: How to apply a style sheet to a file upload bottom.

i guess u could try this
http://dreamweaverfever.com/grow/

Form Button Fever!

This behavior will make any object a Submit or Reset button for your form.
It allows you to easily use a rollover image as a form button over even just
a text link. It was created especially for those Drumbeat users moving over
to UltraDev. I got bored of answering the question "how do I make
such-and-such a submit button" so I got busy with a behavior. 

-- Original Message --
From: "Ciliotta, Mario" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 14 Sep 2004 22:24:45 +0100

>Dave,
> 
>It is sort of what I am trying to do but I need to change the color of the
>button to match the rest of the buttons on the site.  The users want the
>buttons to be a form of blue and when you the file upload dialogue the
problem
>is that you get a gray browse button by default.
> 
>Mario
>-Original Message-
>From: dave [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 14, 2004 5:16 PM
>To: CF-Talk
>Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
>
>
>i missed most of this as well but are u talking about doing this?
>http://www.yockeys.com/test/b.cfm
>only works in ie though
>also there is an extention that turns images into submit buttons called
submit
>form fever (i think)
>
>-- Original Message --
>From: "Bryan Stevenson" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>Date:  Tue, 14 Sep 2004 13:31:20 -0700
>
>>Sorry...late to this thread...but AFAIK there is no way (I've tried hard
in
>the past) to change the style of the BROWSE button that is produced using
an
>input of type "file"
>>
>>If there is a way of changing it...I'm all ears ;-)
>>
>>Bryan Stevenson B.Comm.
>>VP & Director of E-Commerce Development
>>Electric Edge Systems Group Inc.
>>phone: 250.480.0642
>>fax: 250.480.1264
>>cell: 250.920.8830
>>e-mail: [EMAIL PROTECTED]
>>web: www.electricedgesystems.com
>>
>> 
>  _  
>
>
>
>

   _  

[HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads]
[HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:178394"This
Message] [HYPERLINK
"http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK
"http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast
Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings]
[HYPERLINK
"https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus
iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation
s and Support] 

   _  

HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=11" \n

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Fw: any java cf'ers online?

2004-09-14 Thread Qasim Rasheed
do you have any specific question in mind? I have developed some small
application using Java within CF.

Thanks

- Original Message -
From: Lori <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 23:17:14 -0400
Subject: Fw: any java cf'ers online?
To: CF-Talk <[EMAIL PROTECTED]>

Anyone out there right now that uses java with cf?

-Lori
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Fw: any java cf'ers online?

2004-09-14 Thread Lori
Anyone out there right now that uses java with cf?

-Lori
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Turn relative links to absolute links

2004-09-14 Thread Jim McAtee
For anyone that's interested, this is what I came up with.  This might be 
handy if you want to use CFINCLUDEs using absolute paths instead of 
relative paths.  It gives the application more directory path 
independence, allowing you to relocate the directory that the application 
resides in without changing any code.

Example:




/*
 *  Return a relative path from the current page to an
 *  absolute URL on the same site.
 */
function PathTo(t) {
  var fa = ListToArray(cgi.script_name, '/\');
  var ta = ListToArray(t, '/\');
  var flen = ArrayLen(fa);
  var tlen = ArrayLen(ta);
  var rpath = '';
  var i = 0;
  var j = 0;

  // Find common branch point in paths
  for (i=1; i lte Min(flen, tlen); i=i+1)
    if (fa[i] is not ta[i]) break;

  // Path back to branch
  rpath = RepeatString('../', flen - i);

  // Append remainder of path to target
  for (j=i; j lte tlen; j=j+1)
    rpath = rpath & IIf(j neq i, DE('/'), DE('')) & ta[j];

  return rpath;
}


- Original Message - 
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 13, 2004 1:17 PM
Subject: Turn relative links to absolute links

> I'm in the process of restructuring a fairly complex Intranet site -
> moving applications, directories, content, and menus around to give the
> site a bit more of a logical organization.
>
> The CF files and tags which use relative addressing are causing the most
> work, especially if I decide re-reorganize and move something for a 
> second
> time.
>
> Simple stuff like:
>
> 
>
> I believe I've seen techniques (or UDFs?) posted on how to reform the 
> tag
> using an absolute address.  Assuming that the 'include' directory is
> hanging off of the site root and that I have a template in an arbitrary
> directory, as show below, how would this be done?
>
> /
> ../include/header.cfm
> ../applications/myapp/index.cfm
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Struct Insert

2004-09-14 Thread Douglas Knudsen
keys must be unique.  Does  show a
unique list of ids?

Doug

- Original Message -
From: Ricardo Russon <[EMAIL PROTECTED]>
Date: Wed, 15 Sep 2004 09:49:55 +1000
Subject: Re: Struct Insert
To: CF-Talk <[EMAIL PROTECTED]>

Ok, now i have the try catch working again. dunno what
happened, but i am using the exact same code.

but that is a very slow process. why can't i use the structInsert ?

Thanks
Ricardo.

Ricardo Russon wrote:

> this is weird, on my dev box this code works
>
> 
> tmpFieldList.defaultvalue, false)>
>
> but on the production box, it tells me :
>
> "Cannot insert item with key 1. This key already exists. "
>
> This happens from time to time, i don't know why, but when it does
> i usually put a   around it.
>
> 
>  
>   
>   
> tmpFieldList.defaultvalue, false)>
>
> 
>
> but it is still giving me the same error. wtf??
>
> I know that cf has troubles with variable names that start with numbers.
> but up
> until a few weeks ago it didn't seem to care to much.
>
> TIA
> Ricardo.
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: SQL Question

2004-09-14 Thread Tangorre, Michael
I think I solved it Join the document table in twice and in the join
clause added the condition

SELECT 
	R.TEAMING_AGREEMENT_ID,
	R.ROUTE_GROUP_ID,
	B.BUSINESS_NAME,
	T.OPPORTUNITY_ID,
	D.DOCUMENT_NAME AS TEAMING_AGREEMENT_DOCUMENT,
	D.DOCUMENT_EXTENSION AS TEAMING_AGREEMENT_DOCUMENT_EXTENSION ,
	D.DOCUMENT_TYPE_ID AS TEAMING_AGREEMENT_DOCUMENT_ID,
	D2.DOCUMENT_NAME AS ATTACHMENT_A_DOCUMENT,
	D2.DOCUMENT_EXTENSION AS ATTACHMENT_A_DOCUMENT_EXTENSION,
	D2.DOCUMENT_TYPE_ID AS ATTACHMENT_A_DOCUMENT_ID,
FROM
	TEAMING_AGREEMENT_ROUTING R 
	INNER JOIN TEAMING_AGREEMENT T
		ON (R.TEAMING_AGREEMENT_ID = T.TEAMING_AGREEMENT_ID)
	INNER JOIN COMMUNITY_BUSINESS B
		ON (T.COMMUNITY_BUSINESS_ID = B.COMMUNITY_BUSINESS_ID)
	INNER JOIN TEAMING_AGREEMENT_TYPE TAT
		ON (T.TEAMING_AGREEMENT_TYPE_ID =
TAT.TEAMING_AGREEMENT_TYPE_ID)
	INNER JOIN TEAMING_AGREEMENT_DOCUMENT D
		ON (T.TEAMING_AGREEMENT_ID = D.TEAMING_AGREEMENT_ID AND
D.DOCUMENT_TYPE_ID = 1)
	INNER JOIN TEAMING_AGREEMENT_DOCUMENT D2
		ON (T.TEAMING_AGREEMENT_ID = D2.TEAMING_AGREEMENT_ID AND
D2.DOCUMENT_TYPE_ID = 2)
WHERE
	T.OPPORTUNITY_ID = 33
GROUP BY
	B.BUSINESS_NAME,
	R.TEAMING_AGREEMENT_ID,
	R.ROUTE_GROUP_ID,
	T.OPPORTUNITY_ID,
	D.DOCUMENT_NAME,
	D.DOCUMENT_EXTENSION,
	D.DOCUMENT_TYPE_ID,
	D2.DOCUMENT_NAME,
	D2.DOCUMENT_EXTENSION,
	D2.DOCUMENT_TYPE_ID

Mike

> Given the following:
>  
> SELECT
>  R.TEAMING_AGREEMENT_ID,
>  R.ROUTE_GROUP_ID,
>  B.BUSINESS_NAME,
>  T.OPPORTUNITY_ID,
>  D.DOCUMENT_NAME,
>  D.DOCUMENT_EXTENSION
> FROM
>  TEAMING_AGREEMENT_ROUTING R
>  INNER JOIN TEAMING_AGREEMENT T
>   ON (R.TEAMING_AGREEMENT_ID = T.TEAMING_AGREEMENT_ID)  INNER 
> JOIN COMMUNITY_BUSINESS B
>   ON (T.COMMUNITY_BUSINESS_ID = B.COMMUNITY_BUSINESS_ID)  
> INNER JOIN TEAMING_AGREEMENT_TYPE TAT
>   ON (T.TEAMING_AGREEMENT_TYPE_ID = 
> TAT.TEAMING_AGREEMENT_TYPE_ID)  INNER JOIN 
> TEAMING_AGREEMENT_DOCUMENT D
>   ON (T.TEAMING_AGREEMENT_ID = D.TEAMING_AGREEMENT_ID) WHERE  
> T.OPPORTUNITY_ID = 33 GROUP BY  B.BUSINESS_NAME,  
> R.TEAMING_AGREEMENT_ID,  R.ROUTE_GROUP_ID,  T.OPPORTUNITY_ID, 
>  D.DOCUMENT_NAME,  D.DOCUMENT_EXTENSION
>  
> If I need to get two of documents from the 
> TEAMING_AGREEMENT_DOCUMENT table (different types: DOC_TYPE = 
> 1 and DOC_TYPE =2), how can I do this and get the desired 
> number of records returned. If I remove the joined in 
> TEAMING_AGREEMENT_DOCUMENT table I return 5 records, which is 
> correct, but when I try and get the two documents associated 
> I return 10 records. Is there anyway to qualify the selection 
> of the documents? I hope this makes sense grouping? sub query?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Currently running page requests

2004-09-14 Thread Douglas Knudsen
When this part of the JSP runs
for (int i=0;i
out.println("i: " + i + "");
	try 
	{
		jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
		jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
		out.println(endPoint.getServerName() + endPoint.getRequestURI() + "");
	} 
	catch (Exception e) { }
}

I get 
i:1
i:2
.
.
.

that's it.  The try/catch is catching an exception.  When I remove the
try/catch I get this in the cfusion-event log

java.lang.ClassCastException
	at jrun__admintools__cfthreads2ejsp19._jspService(jrun__admintools__cfthreads2ejsp19.java:59)
	at jrun.jsp.runtime.HttpJSPServlet.service(HttpJSPServlet.java:43)
	at jrun.jsp.JSPServlet.service(JSPServlet.java:119)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:447)
	at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:417)
	at jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:61)
	at coldfusion.license.JspLicenseServlet.service(JspLicenseServlet.java:31)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

looks like its this line that is having issue with the caste
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];

Doug

- Original Message -
From: Lee Howard <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 18:26:04 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

If you are using jrun for your J2EE server I don't know what the
problem could be.
What kind of error message are you getting?
Can you compile the code I posted?

- Original Message -
From: Douglas Knudsen <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 16:12:23 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

hmmm, I am using the enterprise version, J2EE install, and I can not
see the script names.

This part bombs.
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();

maybe there is something missing in my classpath or maybe a differnet JVM

Doug

- Original Message -
From: Lee Howard <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 15:24:51 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

I like that.  It worked great for me, but if you are not using
enterprise it will not work.  For those people you can also do the
same thing with a servlet.  Here is the java code.

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class threads extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException{
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();

int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];

count = threadGroup.enumerate(threads);
out.println("Thread Count: " + count + "");
for (int i=0;i
try 
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
out.println("i: " + i + ": ");
out.println(endPoint.getServerName() + endPoint.getRequestURI() + "
:" + endPoint.getRemoteHost() + "");
} 
catch (Exception e) {
}
}
}
}

compile and put in the WEB-INF/classes folder.
I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar
call it using 
http://webserver.com/servlet/thread

- Original Message -
From: Douglas Knudsen <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 11:54:05 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

there was some JSP code for this floating around abit ago.  IIRC,
credit goes to Pete Frietag.  I never got this to work for me though. 
Some sort of caste error and I'm far from a Java guru.  Anyone get
this to work?

<%
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();
int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];
count = threadGroup.enumerate(threads);
out.println("Thread Count: " + count + "");

for (int i=0;i
out.println("i: " + i + "");
try 
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servl

New custom tag

2004-09-14 Thread Claude Schneegans
Hi,

I just released a new custom tag that generates colored maps from a GIF template and according to data in a database.
see http://www.contentbox.com/claude/customtags/mapData/viewmapData.cfm?p=md

--
___
REUSE CODE! Use custom tags;
See 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]
 [Donations and Support]




Re: Data Visualization

2004-09-14 Thread Claude Schneegans
>>Has anyone worked on data visualization technique(s) with CF/CFMX?

Hi, just released a new tag today, and I think it falls in this category.
See CFX_mapData here:
http://www.contentbox.com/claude/customtags/mapData/viewmapData.cfm?p=hf

--
___
REUSE CODE! Use custom tags;
See 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]
 [Donations and Support]




SOT: SQL Question

2004-09-14 Thread Tangorre, Michael
Given the following:

 
SELECT 
 R.TEAMING_AGREEMENT_ID,
 R.ROUTE_GROUP_ID,
 B.BUSINESS_NAME,
 T.OPPORTUNITY_ID,
 D.DOCUMENT_NAME,
 D.DOCUMENT_EXTENSION
FROM
 TEAMING_AGREEMENT_ROUTING R
 INNER JOIN TEAMING_AGREEMENT T
  ON (R.TEAMING_AGREEMENT_ID = T.TEAMING_AGREEMENT_ID)
 INNER JOIN COMMUNITY_BUSINESS B
  ON (T.COMMUNITY_BUSINESS_ID = B.COMMUNITY_BUSINESS_ID)
 INNER JOIN TEAMING_AGREEMENT_TYPE TAT
  ON (T.TEAMING_AGREEMENT_TYPE_ID = TAT.TEAMING_AGREEMENT_TYPE_ID)
 INNER JOIN TEAMING_AGREEMENT_DOCUMENT D
  ON (T.TEAMING_AGREEMENT_ID = D.TEAMING_AGREEMENT_ID)
WHERE
 T.OPPORTUNITY_ID = 33
GROUP BY
 B.BUSINESS_NAME,
 R.TEAMING_AGREEMENT_ID,
 R.ROUTE_GROUP_ID,
 T.OPPORTUNITY_ID,
 D.DOCUMENT_NAME,
 D.DOCUMENT_EXTENSION

 
If I need to get two of documents from the TEAMING_AGREEMENT_DOCUMENT
table (different types: DOC_TYPE = 1 and DOC_TYPE =2), how can I do this
and get the desired number of records returned. If I remove the joined
in TEAMING_AGREEMENT_DOCUMENT table I return 5 records, which is
correct, but when I try and get the two documents associated I return 10
records. Is there anyway to qualify the selection of the documents? I
hope this makes sense grouping? sub query?

 
Thanks!

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




Re: Intel HyperThreading

2004-09-14 Thread Donna French
Thanks Jim,

I am now considering dual processors - just not sure and want to get
as much feedback as possible before diving into putting the new system
together. I am hoping to order parts Thursday and build this weekend.

If anyone has ANY comments on their system and what kind of
performance you get please feel free to post - or email me off list.

Thanks again,
Donna

- Original Message -
From: Jim Davis <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 19:04:07 -0400
Subject: RE: Intel HyperThreading
To: CF-Talk <[EMAIL PROTECTED]>

I like it - it definitely improves performance response time when using
multiple applications.   But really only for those applications tuned to
multi-processor performance to begin with.

CF won't benefit nearly as much as it will from dual CPUs (a dual PIII 1000
would I think give a single P4 3Gh HT at least a run for it's money if not
beat it outright under load - and probably costs about the same), but it
will definitely benefit.  My workstation is a P4 3.06 GHz with HT enabled
and my development server is a Dual PIII 1000 (running at 1100).

This doesn't really have anything to do with memory however - just
performance.  HT won't do anything to help a memory hog - only more memory
will do that.  If it's a choice for CF always go with with more memory
rather than a faster processor (in general).

Jim Davis

From: Donna French [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 6:20 PM
To: CF-Talk
Subject: OT: Intel HyperThreading

Okay - I fried my motherboard last weekend and have decided to build a
new system instead of replacing the old one. I've been running a
950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some
speed now.

I had in mind to build a P4 3.0GHz and have been looking at the
HyperThreading technology. Heard it's great for memory hawgs like CFMX
and the like.

Anyone else using Intel HT technology? Any comments/suggestions
welcome.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Ewok
Yes, please do show any cross-browser solution you might have :-)

I’ve came extremely close, but never close enough to even consider using it
live on user end



   _  

From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 12:48 PM
To: CF-Talk
Subject: RE: SOT: How to apply a style sheet to a file upload bottom.

Asim,

How do you actually do that?  I have tried it before and it did not work.
The
code was unable to actually do the upload.

I am assuming that you need to write a _javascript_ routine to do that?

Is it possible to post an example?

Thanks
Mario
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 12:43 PM
To: CF-Talk
Subject: Re: SOT: How to apply a style sheet to a file upload bottom.

I would recommend that you use your own graphics for the buttons. I usually
use my own graphics button in place of the browse button.

>All that does is turn the background of the field a color.  CSS limitation,
>this can't be done currently.
>
>-Original Message-
>From: Asim Manzur [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 14, 2004 11:33 AM
>To: CF-Talk
>Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
>
>
> 
> 
>Untitled 
>
>.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
>sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
> > > > > > >enctype="multipart/form-data"> > >It also needs to have a file selection control: > > > > > >>Hi, >> >>I am in the process of creating  a page for my endusers to upload files and >>the first thing that they complained about is that the button is not the >same >>style as the rest of the buttons in the applications.  All of the buttons >are >>usually a form of blue (We use IE6.0 only - internal), but the BROWSE >button >  _   _    _   [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:178331"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support]    _   HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=39" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Struct Insert

2004-09-14 Thread Ricardo Russon
Ok, now i have the try catch working again. dunno what
happened, but i am using the exact same code.

but that is a very slow process. why can't i use the structInsert ?

Thanks
Ricardo.

Ricardo Russon wrote:

> this is weird, on my dev box this code works
>
> 
> tmpFieldList.defaultvalue, false)>
>
> but on the production box, it tells me :
>
> "Cannot insert item with key 1. This key already exists. "
>
> This happens from time to time, i don't know why, but when it does
> i usually put a   around it.
>
> 
>  
>   
>   
> tmpFieldList.defaultvalue, false)>
>
> 
>
> but it is still giving me the same error. wtf??
>
> I know that cf has troubles with variable names that start with numbers.
> but up
> until a few weeks ago it didn't seem to care to much.
>
> TIA
> Ricardo.
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Variable names stored in database

2004-09-14 Thread Ewok
Store this block in the database…

div.template1

{
width: [**divtemplateWidth**];
height: [**divtemplateHeight**];
border: 1px solid black;
background-color : [**divTempalteBgColor**];

}



Also store your divTemplateBGColor, divTemplateWidth, divTemplateHeight in
the database 

Query for your style blocks

Then query for all of your values

Now replace the key strings in the Style block with the values




ValueQuery.divTemplateWidth, “ALL”)>


ValueQuery.divTemplateHeight, “ALL”)>


“[**divTemplateBgColor**]”, ValueQuery.divTemplateBgColor, “ALL”)>


#SyleBlockFinal#

I haven’t used this but I’ve been kicking around the idea for a skinned message board I have. Right now Im just storing the directory names in the database Each directory has a style.css in it. The style being used for the skin depends on an ACTIVE status in the database Each of the directories also has an “images” directory with the buttons for that skin. I’d like to hear other’s thoughts on dynamic skins and styles myself. In my case, the above example (style code in the database) could get rather large and probably way too much overhead for a skin feature.    _   From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:19 AM To: CF-Talk Subject: Variable names stored in database I would like to store style sheet information in a database but need to be able to change some of the parameters on the fly.  If a straight file doing the variable substitutions is no big deal.    SELECT   color    FROM   spec_table    WHERE   customer = 42    
  div.template1{
   width: 300;
   height: 250;
   border: 1px solid black;
   background-color : #variables.bgcolor#;
  }
    Yes I know I don't need to use the extra step in this case but if it is stored in a DB I need constant names in string. So is it possible to store the style block in  a DB and then do the variable replacement? Shawn McKee Mgr., Web Development http://www.newsstand.com    _   [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:178273"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support]    _   HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=34" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Struct Insert

2004-09-14 Thread Ricardo Russon
this is weird, on my dev box this code works


tmpFieldList.defaultvalue, false)>

but on the production box, it tells me :

"Cannot insert item with key 1. This key already exists. "

This happens from time to time, i don't know why, but when it does
i usually put a   around it.


 
  
  
tmpFieldList.defaultvalue, false)>
   
 

but it is still giving me the same error. wtf??

I know that cf has troubles with variable names that start with numbers. 
but up
until a few weeks ago it didn't seem to care to much.

TIA
Ricardo.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Data Visualization

2004-09-14 Thread Don
Thank you very much, it looks interesting, I'll take a better look later.

>you might want to get in touch with this guy, he seems to read the
>list and does some REALLY amazing stuff
>
>http://marcosweskamp.marumushi.com/
>
>Regards
>
>Mark Drew
>
>
>On Tue, 14 Sep 2004 16:03:59 -0400, Don Chunshen Li
><[EMAIL PROTECTED]> wrote:
>> Not line/bar chart type with cfgraph or cfchart, ah, it's a futile question.
>> 
>> >Has anyone worked on data visualization technique(s) with CF/CFMX?
>> >If so, pls share your experience.
>> 
>>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CFMX 6.1 updater

2004-09-14 Thread Dave Watts
> I didn't have any luck applying the updater to an expanded 
> ear. I had to apply it to a archived one before it agreeded I 
> was 'valid'.

That's odd. I didn't have any trouble applying it to existing expanded EARs
on JRun. Is there anything unusual about your configuration?

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




Re: Quad Character Unicode?

2004-09-14 Thread Jochem van Dieten
Jochem van Dieten wrote:
> Jeff Chastain wrote:
>> 
>> I have an encoded text string that I am needing to decode.  The string is in
>> the format ...
>> 
>> http%u003A%u002F%u002Fwww%u002Egoogle%u002Ecom 
>> 
>>  which I am being told is called Quad Character Unicode.  I have played
>> with all of the different character sets in CFMX and I cannot get this
>> string to decode properly.  Does anybody have any suggestions?
> 
> It is just hex with a weird delimiter (% instead of /). The quick 
> and dirty fix is to use:
> URLDecode(REReplaceNoCase(string,"%(u00)[0-7][0-9a-z]","","ALL"))

I messed up that regex. The intention is to transform %u003A to 
%3A, for which the following will work better:
URLDecode(REReplaceNoCase(string,"%u00([0-7][0-9a-z])","%\1","ALL"))

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




RE: Intel HyperThreading

2004-09-14 Thread Jim Davis
I like it - it definitely improves performance response time when using
multiple applications.   But really only for those applications tuned to
multi-processor performance to begin with.

CF won't benefit nearly as much as it will from dual CPUs (a dual PIII 1000
would I think give a single P4 3Gh HT at least a run for it's money if not
beat it outright under load - and probably costs about the same), but it
will definitely benefit.  My workstation is a P4 3.06 GHz with HT enabled
and my development server is a Dual PIII 1000 (running at 1100).

This doesn't really have anything to do with memory however - just
performance.  HT won't do anything to help a memory hog - only more memory
will do that.  If it's a choice for CF always go with with more memory
rather than a faster processor (in general).

Jim Davis

From: Donna French [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 6:20 PM
To: CF-Talk
Subject: OT: Intel HyperThreading

Okay - I fried my motherboard last weekend and have decided to build a
new system instead of replacing the old one. I've been running a
950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some
speed now.

I had in mind to build a P4 3.0GHz and have been looking at the
HyperThreading technology. Heard it's great for memory hawgs like CFMX
and the like.

Anyone else using Intel HT technology? Any comments/suggestions welcome.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: OT: Intel HyperThreading

2004-09-14 Thread Nathan Strutz
Personal experience, enabled or disabled, HyperThreading had no real 
effect on my server.

-nathan strutz
http://www.dopefly.com/

Donna French wrote:

> Okay - I fried my motherboard last weekend and have decided to build a
> new system instead of replacing the old one. I've been running a
> 950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some
> speed now.
> 
> I had in mind to build a P4 3.0GHz and have been looking at the
> HyperThreading technology. Heard it's great for memory hawgs like CFMX
> and the like.
> 
> Anyone else using Intel HT technology? Any comments/suggestions welcome.
> 
> Thanks,
> Donna
> 
> -- 
> 
> Donna French
> [EMAIL PROTECTED]
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Quad Character Unicode?

2004-09-14 Thread Jochem van Dieten
Jeff Chastain wrote:

> I have an encoded text string that I am needing to decode.  The string is in
> the format ...
>  
>  http%u003A%u002F%u002Fwww%u002Egoogle%u002Ecom 
>  
>  which I am being told is called Quad Character Unicode.  I have played
> with all of the different character sets in CFMX and I cannot get this
> string to decode properly.  Does anybody have any suggestions?

It is just hex with a weird delimiter (% instead of /). The quick 
and dirty fix is to use:
URLDecode(REReplaceNoCase(string,"%(u00)[0-7][0-9a-z]","","ALL"))

If the string has characters that are not in 7-bit ASCII this 
will fail and you will have to do a proper conversion.

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




Re: CFMX 6.1 updater

2004-09-14 Thread Adrocknaphobia
I didn't have any luck applying the updater to an expanded ear. I had
to apply it to a archived one before it agreeded I was 'valid'.

-Adam

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 18:24:32 -0400
Subject: RE: CFMX 6.1 updater
To: CF-Talk <[EMAIL PROTECTED]>

> We are running the updater on our dev box and when it comes 
> down to selecting the CFIDE directory, it states it is an 
> invalid directory.
> 
> Our directory is:
> 
> d:\Jrun4\servers\cfusion\cfusion-ear\cfusion-war\
> 
> here you will find both the CFIDE and the WEB-INF directory.
> 
> I have tried to specify the directory above with and without 
> the \CFIDE folder and both yield the same results.
> 
> Suggestions? 
> BTW:  This is a J2EE Configuration with CFMX and JRUN

You do need to specify the CFIDE directory. However, since you've tried
that, that's probably not the problem. Are you sure that the user account
you're using to run the installer has the appropriate permissions to the
CFIDE directory?

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




Re: Setting up Oracle datasource in MX

2004-09-14 Thread Adrocknaphobia
When oracle is installed you define a service name / SID for the
database. It would be the same value you put into your TNS file.

-Adam

- Original Message -
From: Bob Flynn <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 17:36:56 -0500
Subject: Setting up Oracle datasource in MX
To: CF-Talk <[EMAIL PROTECTED]>

I understand that you can set up an Oracle datasource on CFMX6.1 without
having the Oracle client tools installed on the server. I'm not CF server
admin, but am trying to walk my admins through it. It is much easier to get
them to add a datasource than it is to get them to download a package like
that and install it on the server.

The Oracle datasource screen in CF Admin asks for the SID name. Normally I
would point to the alias in my tsnames.ora file. If that file does not
exist, what do I fill in there?

Guidance and online resources appreciated.

Regards,

Bob
--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Setting up Oracle datasource in MX

2004-09-14 Thread Scott Mulholland
Bob,
Just use the value that you would find in the tnsnames.ora file if you
had one on the machine.  Make sense?

 
Scott

-Original Message-
From: Bob Flynn [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 5:37 PM
To: CF-Talk
Subject: Setting up Oracle datasource in MX

I understand that you can set up an Oracle datasource on CFMX6.1 without
having the Oracle client tools installed on the server. I'm not CF
server
admin, but am trying to walk my admins through it. It is much easier to
get
them to add a datasource than it is to get them to download a package
like
that and install it on the server.

The Oracle datasource screen in CF Admin asks for the SID name. Normally
I
would point to the alias in my tsnames.ora file. If that file does not
exist, what do I fill in there?

Guidance and online resources appreciated.

Regards,

Bob
-- 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: new to CFMX, can't default attributes scope variables

2004-09-14 Thread Ryan Stille
My bad, I had a typo.  I had double checked it, too...  Sorry!

-Ryan
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Quad Character Unicode?

2004-09-14 Thread Jeff Chastain
I have an encoded text string that I am needing to decode.  The string is in
the format ...

 http%u003A%u002F%u002Fwww%u002Egoogle%u002Ecom 

 
 which I am being told is called Quad Character Unicode.  I have played
with all of the different character sets in CFMX and I cannot get this
string to decode properly.  Does anybody have any suggestions?

 
Thanks
-- Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: .net remoting

2004-09-14 Thread Alvin Hom
Thanks! That did the trick!

>Alvin,
>
>Can you call the cfstart bat file to start cf?
>It calls
>
>@Echo off
>setlocal
>cd ..\runtime\bin
>jrun -start default
>endlocal
>
>so it looks like you you need to call jrun not the java.
>
>HTH
>Ricardo
>
>
>Alvin Hom wrote:
>
>>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




new to CFMX, can't default attributes scope variables

2004-09-14 Thread Ryan Stille
I'm new to CFMX, and I'm running into some problems.

I used to be able to default a variable like "Attributes.myvar" to something with this tag:



But that doesn't work now.  The reason I am setting a variable in the attributes scope is because we build things using fusebox (version 1), which uses the attributes scope for anything (so code works with data passed in from a form or on the URL).

Thanks for any help.
-Ryan
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Setting up Oracle datasource in MX

2004-09-14 Thread Bob Flynn
I understand that you can set up an Oracle datasource on CFMX6.1 without
having the Oracle client tools installed on the server. I'm not CF server
admin, but am trying to walk my admins through it. It is much easier to get
them to add a datasource than it is to get them to download a package like
that and install it on the server.

The Oracle datasource screen in CF Admin asks for the SID name. Normally I
would point to the alias in my tsnames.ora file. If that file does not
exist, what do I fill in there?

Guidance and online resources appreciated.

Regards,

Bob
--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CFMX 6.1 updater

2004-09-14 Thread Dave Watts
> We are running the updater on our dev box and when it comes 
> down to selecting the CFIDE directory, it states it is an 
> invalid directory.
> 
> Our directory is:
> 
> d:\Jrun4\servers\cfusion\cfusion-ear\cfusion-war\
> 
> here you will find both the CFIDE and the WEB-INF directory.
> 
> I have tried to specify the directory above with and without 
> the \CFIDE folder and both yield the same results.
> 
> Suggestions? 
> BTW:  This is a J2EE Configuration with CFMX and JRUN

You do need to specify the CFIDE directory. However, since you've tried
that, that's probably not the problem. Are you sure that the user account
you're using to run the installer has the appropriate permissions to the
CFIDE directory?

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




Trouble with Two Table Query - Doh!

2004-09-14 Thread Les Mizzell
Here's a two table query (SQL Server) that's giving me a problem...

Table 1: Articles (Couple hundred of these)
---
id
article_title
article_date
indus_id (each article is associated with an industry)

Table 2: Industry (and there's maybe 60 industries in the table)

industry_id
indus_name

Now, I've got no problem finding the associated articles and industries 
on an individual basis, but the client wants a single index page of 
articles grouped by industry, sorted alpha and then by article date like:

AUTOMOTIVE
 article #1 - May, 1994
 article #2 - April, 1994
 article #3 - March, 1994
HOUSING AND DEVELOPMENT
 article #1 - Jan, 1994
 article #2 - Dec, 1993
MEDICINE
 article #1 - June, 1993
 article #2 - May, 1992

I keep coming up with convoluted ways of maybe doing this, but none seem 
to work properly.

Pointers please?

-- 
Les Mizzell
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Currently running page requests

2004-09-14 Thread Lee Howard
If you are using jrun for your J2EE server I don't know what the
problem could be.
What kind of error message are you getting?
Can you compile the code I posted?

- Original Message -
From: Douglas Knudsen <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 16:12:23 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

hmmm, I am using the enterprise version, J2EE install, and I can not
see the script names.

This part bombs.
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();

maybe there is something missing in my classpath or maybe a differnet JVM

Doug

- Original Message -
From: Lee Howard <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 15:24:51 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

I like that.  It worked great for me, but if you are not using
enterprise it will not work.  For those people you can also do the
same thing with a servlet.  Here is the java code.

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class threads extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException{
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();

int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];

count = threadGroup.enumerate(threads);
out.println("Thread Count: " + count + "");
for (int i=0;i
try 
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
out.println("i: " + i + ": ");
out.println(endPoint.getServerName() + endPoint.getRequestURI() + "
:" + endPoint.getRemoteHost() + "");
} 
catch (Exception e) {
}
}
}
}

compile and put in the WEB-INF/classes folder.
I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar
call it using 
http://webserver.com/servlet/thread

- Original Message -
From: Douglas Knudsen <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 11:54:05 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

there was some JSP code for this floating around abit ago.  IIRC,
credit goes to Pete Frietag.  I never got this to work for me though. 
Some sort of caste error and I'm far from a Java guru.  Anyone get
this to work?

<%
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();
int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];
count = threadGroup.enumerate(threads);
out.println("Thread Count: " + count + "");

for (int i=0;i
out.println("i: " + i + "");
try 
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
out.println(endPoint.getServerName() + endPoint.getRequestURI() + "");
} 
catch (Exception e) { }
}

%>

- Original Message -
From: Adrocknaphobia <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 09:34:27 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

Well I've found the stack trace invaluable in terms of information.
But the fact that you have to have your server running through command
prompt makes its pretty useless.

For example in a production app, you have to shut down the server.
(not cool) Then restart it in a command window (not cool), then you
cannot log off! (not cool) Although I'm told this is a windows only
issue. Still, its great insight into problems... but you cant really
get it when you need it.

-Adam

- Original Message -
From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 14:26:01 +0100
Subject: RE: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

And its nigh on useless in my opinion.

   _  

From: Tim Blair [mailto:[EMAIL PROTECTED] 
Sent: 14 September 2004 14:23
To: CF-Talk
Subject: RE: Currently running page requests

> Is there any way to get a list of currently running 
> page requests on the server so I can keep track or them?

You can perform a dump of the current stack trace, which will list
(amongst a big pile of other stuff) what's requests are currently being
processed by CF.  See the MM technote about it:
http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm

Tim.

--
---
Badpen Tech - CF and web-tech: http://tech.badpen.com/
---
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 co

OT: Intel HyperThreading

2004-09-14 Thread Donna French
Okay - I fried my motherboard last weekend and have decided to build a
new system instead of replacing the old one. I've been running a
950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some
speed now.

I had in mind to build a P4 3.0GHz and have been looking at the
HyperThreading technology. Heard it's great for memory hawgs like CFMX
and the like.

Anyone else using Intel HT technology? Any comments/suggestions welcome.

Thanks,
Donna

-- 

Donna French
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread dave
i guess u could try this
http://dreamweaverfever.com/grow/

Form Button Fever!

This behavior will make any object a Submit or Reset button for your form. It allows you to easily use a rollover image as a form button over even just a text link. It was created especially for those Drumbeat users moving over to UltraDev. I got bored of answering the question "how do I make such-and-such a submit button" so I got busy with a behavior. 

-- Original Message --
From: "Ciliotta, Mario" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 14 Sep 2004 22:24:45 +0100

>Dave,
> 
>It is sort of what I am trying to do but I need to change the color of the
>button to match the rest of the buttons on the site.  The users want the
>buttons to be a form of blue and when you the file upload dialogue the problem
>is that you get a gray browse button by default.
> 
>Mario
>-Original Message-
>From: dave [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 14, 2004 5:16 PM
>To: CF-Talk
>Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
>
>
>i missed most of this as well but are u talking about doing this?
>http://www.yockeys.com/test/b.cfm
>only works in ie though
>also there is an extention that turns images into submit buttons called submit
>form fever (i think)
>
>-- Original Message --
>From: "Bryan Stevenson" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>Date:  Tue, 14 Sep 2004 13:31:20 -0700
>
>>Sorry...late to this thread...but AFAIK there is no way (I've tried hard in
>the past) to change the style of the BROWSE button that is produced using an
>input of type "file"
>>
>>If there is a way of changing it...I'm all ears ;-)
>>
>>Bryan Stevenson B.Comm.
>>VP & Director of E-Commerce Development
>>Electric Edge Systems Group Inc.
>>phone: 250.480.0642
>>fax: 250.480.1264
>>cell: 250.920.8830
>>e-mail: [EMAIL PROTECTED]
>>web: www.electricedgesystems.com
>>
>> 
>  _  
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: 6.1 updater breaks cfdumping cfcatch, but this may help

2004-09-14 Thread Damien McKenna
Adam Churvis wrote:

>Unfortunately, I just found out while training the MX Master Class that the ColdFusion MX 6.1 Updater broke dumping CFCATCH,
>

So it wasn't just me!  It works if you do  but 
not , in the latter case it gives a blank 
value for cfcatch.
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 

The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Dynamically creating text docs

2004-09-14 Thread Barney Boisvert
When I'm building text content, I usually use a Java StringBuffer. 
It's really simple:








  

...




Do it this way and you can embed arbitrary logical constructs in your
code with no problem.  If you don't want to use the StringBuffer (or
you can't, because you're on CF5 or less, and don't have a JVM
installed), you can do the same type of thing with string
concatenation.  Just break it up wherever you need to add logic:



  



The StringBuffer method will give you better performance to some
degree, most notably where you have either a lot of separate
concatenation operations (count the ampersands, not the CFSET tags), a
lot of content, or both.

cheers,
barneyb

On Tue, 14 Sep 2004 14:17:35 -0700, Rebecca Wells
<[EMAIL PROTECTED]> wrote:
> A CF application I'm building needs a feature that will create documents
> using a form letter and data from a database, merging the form and the
> data similar to a MailMerge operation. The only way I've been able to
> get any results is by using cffile to read the form, then cfset ThisLtr
> = Evaluate(formLtr), then use cfoutput and pre to output the result.
> Constructing the form letter is a royal PITA because you have to asci
> encode everything like this:
> 
> #Ownername#  & #chr(13)# & #chr(10)# &
> #Attnline# & #chr(13)# & #chr(10)# &
> #Addrline# & #chr(13)# & #chr(10)# &
> #trim(CityState)# & " " & #ZipCode#
> 
> And doing it that way, I can't get any cf conditional logic to work,
> such as a cfif statement to not use the line for the Attnline if it's
> blank.
> 
> Any suggestions for a better approach?

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Ciliotta, Mario
Dave,

 
It is sort of what I am trying to do but I need to change the color of the
button to match the rest of the buttons on the site.  The users want the
buttons to be a form of blue and when you the file upload dialogue the problem
is that you get a gray browse button by default.

 
Mario
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 5:16 PM
To: CF-Talk
Subject: Re: SOT: How to apply a style sheet to a file upload bottom.

i missed most of this as well but are u talking about doing this?
http://www.yockeys.com/test/b.cfm
only works in ie though
also there is an extention that turns images into submit buttons called submit
form fever (i think)

-- Original Message --
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 14 Sep 2004 13:31:20 -0700

>Sorry...late to this thread...but AFAIK there is no way (I've tried hard in
the past) to change the style of the BROWSE button that is produced using an
input of type "file"
>
>If there is a way of changing it...I'm all ears ;-)
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: [EMAIL PROTECTED]
>web: www.electricedgesystems.com
>
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Dynamically creating text docs

2004-09-14 Thread Rebecca Wells
A CF application I'm building needs a feature that will create documents
using a form letter and data from a database, merging the form and the
data similar to a MailMerge operation. The only way I've been able to
get any results is by using cffile to read the form, then cfset ThisLtr
= Evaluate(formLtr), then use cfoutput and pre to output the result.
Constructing the form letter is a royal PITA because you have to asci
encode everything like this:

#Ownername#  & #chr(13)# & #chr(10)# & 
#Attnline# & #chr(13)# & #chr(10)# &
#Addrline# & #chr(13)# & #chr(10)# &
#trim(CityState)# & " " & #ZipCode#

And doing it that way, I can't get any cf conditional logic to work,
such as a cfif statement to not use the line for the Attnline if it's
blank. 

Any suggestions for a better approach?

This message has been scanned by the City of Renton's filtering gateway.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread dave
i missed most of this as well but are u talking about doing this?
http://www.yockeys.com/test/b.cfm
only works in ie though
also there is an extention that turns images into submit buttons called submit form fever (i think)

-- Original Message --
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 14 Sep 2004 13:31:20 -0700

>Sorry...late to this thread...but AFAIK there is no way (I've tried hard in the past) to change the style of the BROWSE button that is produced using an input of type "file"
>
>If there is a way of changing it...I'm all ears ;-)
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: [EMAIL PROTECTED]
>web: www.electricedgesystems.com
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Determining the size of a remote image

2004-09-14 Thread Massimo, Tiziana e Federica
> So I could do it when validating the form onsubmit.. interesting .. I 
> didn't know _javascript_ could do that.  I'll have to google for sample 
> code... (unless anyone would like to provide sample code before I get a 
> chance to do that tomorrow!)

I am going to bed, but this should at least get you started:

http://www.massimocorner.com/beta/img_reader.htm


Massimo Foti
http://www.massimocorner.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




SOLVED: cfexecute doesn't

2004-09-14 Thread Doug James
The executable 'html2ps' is a perl script so I used the following as a test:

arguments="/home/mike/bin/html2ps --output /home/mike/test.ps 
/home/mike/html2ps/html2ps.html">

And darn if it didn't work.

Doug

Doug James wrote:

>Help! My cfexecute call does not execute! I have the appropriate 
>permissions set.
>
>Here is my code:
>
>arguments="-h">
>I should get something like below in my file '/home/mike/test':
>Usage:
> html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding]
>  [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num]
>  [-o file] [-r path] [-s num] [-S string] [-W string] [-x num]
>  [file|URL [file|URL [...]]]
>
>The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html
>
>What I actually get is this:'' (yes, there is nothing there).
>
>I am running CFMX (6,0,0,58500) on RedHat 6.
>
>Any suggestions on how to get this to work?
>
>Thanks!
>
>Doug
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Bryan Stevenson
Sorry...late to this thread...but AFAIK there is no way (I've tried hard in the past) to change the style of the BROWSE button that is produced using an input of type "file"

If there is a way of changing it...I'm all ears ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Ciliotta, Mario
Asim,

 
I tried the code and I get a cf error - unable to open file - java i/o error.

 
I changed your code to display the browse button and file dialogue box along
with your css-styled button and if I use the form by clicking your button, the
file dialogue box will appear, I pick the file I want to upload, hit submit
and get an error.

 
But if I use the browser file dialogue and hit submit the file is uploaded
with out any problem exceot that the  button is not styled with CSS.

 
Here is the code as I changed it.  I cannot figure out what I did wrong.

 
Again, thanks for all the help.

 
Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Data Visualization

2004-09-14 Thread Mark Drew
you might want to get in touch with this guy, he seems to read the
list and does some REALLY amazing stuff

http://marcosweskamp.marumushi.com/

Regards

Mark Drew

On Tue, 14 Sep 2004 16:03:59 -0400, Don Chunshen Li
<[EMAIL PROTECTED]> wrote:
> Not line/bar chart type with cfgraph or cfchart, ah, it's a futile question.
> 
> >Has anyone worked on data visualization technique(s) with CF/CFMX?
> >If so, pls share your experience.
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Currently running page requests

2004-09-14 Thread Douglas Knudsen
hmmm, I am using the enterprise version, J2EE install, and I can not
see the script names.

This part bombs.
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();

maybe there is something missing in my classpath or maybe a differnet JVM

Doug

- Original Message -
From: Lee Howard <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 15:24:51 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

I like that.  It worked great for me, but if you are not using
enterprise it will not work.  For those people you can also do the
same thing with a servlet.  Here is the java code.

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class threads extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException{
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();

int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];

count = threadGroup.enumerate(threads);
out.println("Thread Count: " + count + "");
for (int i=0;i
try 
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
out.println("i: " + i + ": ");
out.println(endPoint.getServerName() + endPoint.getRequestURI() + "
:" + endPoint.getRemoteHost() + "");
} 
catch (Exception e) {
}
}
}
}

compile and put in the WEB-INF/classes folder.
I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar
call it using 
http://webserver.com/servlet/thread

- Original Message -
From: Douglas Knudsen <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 11:54:05 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

there was some JSP code for this floating around abit ago.  IIRC,
credit goes to Pete Frietag.  I never got this to work for me though. 
Some sort of caste error and I'm far from a Java guru.  Anyone get
this to work?

<%
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();
int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];
count = threadGroup.enumerate(threads);
out.println("Thread Count: " + count + "");

for (int i=0;i
out.println("i: " + i + "");
try 
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
out.println(endPoint.getServerName() + endPoint.getRequestURI() + "");
} 
catch (Exception e) { }
}

%>

- Original Message -
From: Adrocknaphobia <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 09:34:27 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

Well I've found the stack trace invaluable in terms of information.
But the fact that you have to have your server running through command
prompt makes its pretty useless.

For example in a production app, you have to shut down the server.
(not cool) Then restart it in a command window (not cool), then you
cannot log off! (not cool) Although I'm told this is a windows only
issue. Still, its great insight into problems... but you cant really
get it when you need it.

-Adam

- Original Message -
From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 14:26:01 +0100
Subject: RE: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

And its nigh on useless in my opinion.

   _  

From: Tim Blair [mailto:[EMAIL PROTECTED] 
Sent: 14 September 2004 14:23
To: CF-Talk
Subject: RE: Currently running page requests

> Is there any way to get a list of currently running 
> page requests on the server so I can keep track or them?

You can perform a dump of the current stack trace, which will list
(amongst a big pile of other stuff) what's requests are currently being
processed by CF.  See the MM technote about it:
http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm

Tim.

--
---
Badpen Tech - CF and web-tech: http://tech.badpen.com/
---
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

flash remoting on osx

2004-09-14 Thread Pete Freitag
Hey Folks,

I'm trying to get Flash remoting to work on OS X. Running CFMX 6.1 on 
top of JRun. The flash remoting can't find the components, even though I 
can invoke them using the same name from CF.

Here's the exception its throwing:
Service threw an exception during method invocation: No service named 
folder.ComponentName is known to Flash Remoting.
(stack trace)

I have set DISABLE_CFWS_ADAPTERS to false in my web.xml file.

A flash.log file was not generated, and there is nothing in the logs that point to where Flash remoting might be looking.

The code works fine on windows.

__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Data Visualization

2004-09-14 Thread Don
Not line/bar chart type with cfgraph or cfchart, ah, it's a futile question.

>Has anyone worked on data visualization technique(s) with CF/CFMX?
>If so, pls share your experience.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfexecute doesn't

2004-09-14 Thread Doug James
Thanks for the suggestion but I have successfully gotten other things to 
run.

outputfile="/home/mike/ls.txt">
Returns the appropriate information.

Doug

Barney Boisvert wrote:

>The proggy might output the usage info to the STDERR rather than
>STDOUT, so it's not going to your file.  That's just a shot in the
>dark though.
>
>Did you try a simple shell script that outputs a line of text (with
>echo) and see if that runs properly?
>
>cheers,
>barneyb
>
>
>On Tue, 14 Sep 2004 15:29:13 -0400, Doug James <[EMAIL PROTECTED]> wrote:
>  
>
>>Help! My cfexecute call does not execute! I have the appropriate
>>permissions set.
>>
>>Here is my code:
>>
>>arguments="-h">
>>I should get something like below in my file '/home/mike/test':
>>Usage:
>>html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding]
>> [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num]
>> [-o file] [-r path] [-s num] [-S string] [-W string] [-x num]
>> [file|URL [file|URL [...]]]
>>
>>The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html
>>
>>What I actually get is this:'' (yes, there is nothing there).
>>
>>I am running CFMX (6,0,0,58500) on RedHat 6.
>>
>>Any suggestions on how to get this to work?
>>
>>Thanks!
>>
>>Doug
>>
>>    
>>
>
>  
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Determining the size of a remote image

2004-09-14 Thread Rick Root
Massimo Foti wrote:
>  > I want to restrict the size, so that when people enter a remote URL to an
>  > image, it can't be any bigger than 100x100...
> 
> Have you considered using _javascript_ for the job? You can create a new image
> object out of the url entered by the user, then you read the dimensions out
> of it

So I could do it when validating the form onsubmit.. interesting .. I 
didn't know _javascript_ could do that.  I'll have to google for sample 
code... (unless anyone would like to provide sample code before I get a 
chance to do that tomorrow!)

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




CFMX 6.1 updater

2004-09-14 Thread Adkins, Randy
We are running the updater on our dev box and
when it comes down to selecting the CFIDE 
directory, it states it is an invalid directory.

Our directory is:

d:\Jrun4\servers\cfusion\cfusion-ear\cfusion-war\

here you will find both the CFIDE and the WEB-INF 
directory.

I have tried to specify the directory above with and
without the \CFIDE folder and both yield the same results.

Suggestions? 
BTW:  This is a J2EE Configuration with CFMX and JRUN
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Determining the size of a remote image

2004-09-14 Thread Barney Boisvert
You can load an image into a BufferedImage (the Java class that
undoubtedly backs the image.cfc you mentioned) from an arbitrary URL. 
Not sure the exact syntax, but a glimpse inside image.cfc and a
browser with javadocs should get you started.

cheers,
barneyb

On Tue, 14 Sep 2004 15:43:50 -0400, Rick Root <[EMAIL PROTECTED]> wrote:
> So, I've seen the image cfc that allows you to determine image size
> (among other things), but those images have to be local files.
> 
> Is there anyway to retrieve an image via a URL and determine it's size
> WITHOUT reading the file in from the local file system?   I would just
> like to avoid a bunch of file IO, but I want to restrict the size, so
> that when people enter a remote URL to an image, it can't be any bigger
> than 100x100...
> 
> Trying to avoid file I/O.
> 
>  - Rick
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Determining the size of a remote image

2004-09-14 Thread Massimo, Tiziana e Federica
> I want to restrict the size, so that when people enter a remote URL to an
> image, it can't be any bigger than 100x100...

Have you considered using _javascript_ for the job? You can create a new image
object out of the url entered by the user, then you read the dimensions out
of it


Massimo Foti
http://www.massimocorner.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Determining the size of a remote image

2004-09-14 Thread Howie Hamlin
You can get the physical size of the file from the web server without downloading it but not the height/width of the image.

Regards,

-- 
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
>>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm

  - Original Message - 
  From: Rick Root 
  To: CF-Talk 
  Sent: Tuesday, September 14, 2004 3:43 PM
  Subject: Determining the size of a remote image

  So, I've seen the image cfc that allows you to determine image size 
  (among other things), but those images have to be local files.

  Is there anyway to retrieve an image via a URL and determine it's size 
  WITHOUT reading the file in from the local file system?   I would just 
  like to avoid a bunch of file IO, but I want to restrict the size, so 
  that when people enter a remote URL to an image, it can't be any bigger 
  than 100x100...

  Trying to avoid file I/O.

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




Re: OT- NEWS - cfcertification.com

2004-09-14 Thread Matt Robertson
> This site is work-safe ;)

BOOoo!  Hi!

:-)

--Matt--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Determining the size of a remote image

2004-09-14 Thread Massimo Foti
> I want to restrict the size, so that when people enter a remote URL to an
> image, it can't be any bigger than 100x100...

Have you considered using _javascript_ for the job? You can create a new image
object out of the url entered by the user, then you read the dimensions out
of it


Massimo Foti
http://www.massimocorner.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Help Macromedia! MX service is crashing constantly!

2004-09-14 Thread Luis Menchu
Chad, 

In case you are subscribed to this posting...

did you find a specific cause or solution?

We are running into the same problem.

>We have run into a major problem with MX.  It will not stay running.  The 
>service shuts down then restarts under load.
>
>Im not sure if this is access database related, but we are getting a REALLY 
>bad error. If the pages are hit repeatedly i can replicate this 
>error.  This also happens for all of our web sites.  It is not code related.
>
>The web page sits and spins and displays this error:
>
>Server Error
>The server encountered an internal error and was unable to complete your
>request.
>
>Then i check the server event viewer and see this error:
>The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server )
>cannot be found. The local computer may not have the necessary registry
>information or message DLL files to display messages from a remote
>computer. The following information is part of the event: ColdFusion MX
>ODBC [EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset
>by peer.
>
>Then the service restarts with this error!
>
>The ColdFusion MX Application Server service for the "default" server is
>restarting.
>
>The ColdFusion MX Application Server service for the "default" server was 
>started.  PID is 1784.
>
>
>I can get the service to shut down and restart with a MySQL database also.
>
>I get this error:
>The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) 
>cannot be found. The local computer may not have the necessary registry 
>information or message DLL files to display messages from a remote 
>computer. You may be able to use the /AUXSOURCE= flag to retrieve this 
>description; see Help and Support for details. The following information is 
>part of the event: ColdFusion MX ODBC 
>[EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer.
>
>
>These errors are happening on two of our development servers.  Im not 
>taking MX on to a production server until i feel a heck of a lot more 
>comfortable.
>
>We upgraded from 4.5.1 to MX.  One box we upgraded then un-installed so we 
>could do a "Fresh" install of MX, not an upgrade.  This did not help
>
>here are some server details:
>P3 800
>500megs ram
>Win 2k Server
>IIS5
>
>If more detail is need i will be happy to provide it.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfexecute doesn't

2004-09-14 Thread Barney Boisvert
The proggy might output the usage info to the STDERR rather than
STDOUT, so it's not going to your file.  That's just a shot in the
dark though.

Did you try a simple shell script that outputs a line of text (with
echo) and see if that runs properly?

cheers,
barneyb

On Tue, 14 Sep 2004 15:29:13 -0400, Doug James <[EMAIL PROTECTED]> wrote:
> Help! My cfexecute call does not execute! I have the appropriate
> permissions set.
> 
> Here is my code:
> 
> arguments="-h">
> I should get something like below in my file '/home/mike/test':
> Usage:
> html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding]
>  [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num]
>  [-o file] [-r path] [-s num] [-S string] [-W string] [-x num]
>  [file|URL [file|URL [...]]]
> 
> The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html
> 
> What I actually get is this:'' (yes, there is nothing there).
> 
> I am running CFMX (6,0,0,58500) on RedHat 6.
> 
> Any suggestions on how to get this to work?
> 
> Thanks!
> 
> Doug
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Determining the size of a remote image

2004-09-14 Thread Rick Root
So, I've seen the image cfc that allows you to determine image size 
(among other things), but those images have to be local files.

Is there anyway to retrieve an image via a URL and determine it's size 
WITHOUT reading the file in from the local file system?   I would just 
like to avoid a bunch of file IO, but I want to restrict the size, so 
that when people enter a remote URL to an image, it can't be any bigger 
than 100x100...

Trying to avoid file I/O.

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




RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Adam,
I am thinking you may be right based on my last post regarding the
EXECUTE privilege.

 
Running it from SQL*PLUS has the same results:

 
SQL> exec test01.testpckg;
BEGIN test01.testpckg; END;

 
  *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTPCKG'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 
Scott

-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 1:05 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures

No, by default this package will be created under the user who
compiles it (the schema owner). Janet what are you thoughts on the
variable type? I haven't been able to return a ref cursour when its
specified as just OUT.

I still think the account they are giving you isnt kosher. Atleast if
you test it as the schema owner, it can rule that out.

-Adam

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




6.1 updater breaks cfdumping cfcatch, but this may help

2004-09-14 Thread Adam Churvis
Folks,

Unfortunately, I just found out while training the MX Master Class that the
ColdFusion MX 6.1 Updater broke dumping CFCATCH, which was a great help
during development when incorporating structured exception handling into
your code.  There is also a new problem introduced where at least some
type="Object" exceptions are no longer published as such, so they slip by
all CFCATCHes -- even type="Any".

To help people out, I have created a little Zip file containing HTML files
that display the details of CFDUMPs of the CFCATCH structures published by
each type of exception (except Object, which I can't seem to catch anymore).
You can use these during development to help you remember where keys and
subkeys are and what they contain so you can granularly test for them inside
your CFCATCH blocks.  I also included a note about the problem with
type="Object".

You can download it from http://www.ProductivityEnhancement.com.  I hope
this helps.

Respectfully,

Adam Phillip Churvis
Member of Team Macromedia

Advanced Intensive Training:
* C# & ASP.NET for ColdFusion Developers
* ColdFusion MX Master Class
* Advanced Development with CFMX and SQL Server 2000
http://www.ColdFusionTraining.com

Download CommerceBlocks V2.1 and LoRCAT from
http://www.ProductivityEnhancement.com

The ColdFusion MX Bible is in bookstores now!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Deanna,
It is not one of my DBA's, it's an outside vendor so I do not want to
post the code.  I have actually been changing the package name as well
for that reason in my posts.  They can run it on their side with no
issue using pl/sql developer.  I can also run the qry that the procedure
executes using a regular cfquery call as well.  It is only when I try to
run their procedure using CF that the issue arises.

 
Thanks,
Scott

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 1:48 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures 

Scott,
Are you sure that it's actually returning a ref cursor? You'll get this
error if you say that you are returning one, but for some reason one is
not
returned. For example, if you have error trapping in your procedure and
the
cursor never gets opened. Therefore, if I'm returning a cursor, I always
make sure that if I've trapped errors and not opened the intended
cursor,
that I open a "dummy" cursor and return that.

(This would probably be easier to debug if your DBA's would give you the
code to the cursor. Based on the name, it looks like it's not "real"
code
anyway. Think you could talk them into it?)

> >Janet,
> >I have the snippet now from them.  This is how it's currently defined
> >(which looks like it's in line with what you posted aside from In
Out):
> >
> >Type ReturnSet is ref cursor;
> >Procedure testpckg(curReturnSet Out Returnset);
> >
> >They had switched it before to be In Out for me and I still had the
same
> >error.  The one thing I did notice is they do not have it defined
with a
> >schema name, they just have:
> >
> >package Test01 is
> >
> >Type ReturnSet is ref cursor;
> >
> >Procedure testpckg(curReturnSet Out Returnset);
> >
> >Could that possible cause a permissions issue as Adam had alluded
too?
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




cfexecute doesn't

2004-09-14 Thread Doug James
Help! My cfexecute call does not execute! I have the appropriate 
permissions set.

Here is my code:

arguments="-h">
I should get something like below in my file '/home/mike/test':
Usage:
 html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding]
  [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num]
  [-o file] [-r path] [-s num] [-S string] [-W string] [-x num]
  [file|URL [file|URL [...]]]

The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html

What I actually get is this:'' (yes, there is nothing there).

I am running CFMX (6,0,0,58500) on RedHat 6.

Any suggestions on how to get this to work?

Thanks!

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




Data Visualization

2004-09-14 Thread Don
Has anyone worked on data visualization technique(s) with CF/CFMX?
If so, pls share your experience.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Janet/Adam, 
First off thank you guys for all your help thus far, it is greatly
appreciated.  They did switch it to IN OUT this morning for me and I had
the same results.

 
I checked the permissions using the queries Janet supplied:

 
For roles my user has CONNECT and CTXAPP.

 
For table privileges I ran

 
select * from user_tab_privs
where privilege = 'EXECUTE'

 
and the none of the results had the package or procedure name in the
TABLE_NAME field (which is where I assumed i'd see it).  None of the
TABLE_NAME's where the table I know the procedure runs against either.

 
Scott



-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 1:14 PM
To: CF-Talk
Subject: RE: Oracle Stored Procedures 

Scott -

I think you need the IN OUT that Adam mentioned.

When you connect via SQL*Plus and successfully run the procedure, are
you 
using the same username and password that is defined in the CF data 
source?  If so, then I do not think it is a permissions problem but I
could 
be wrong.  If not, it might be a permissions problem.  You could test
this 
by changing your CF code to specify the username and password in the
stored 
procedure call that you use when you successfully run the procedure in 
SQL*Plus.  I think this will override what is stored in the CF data
source 
definition (but I am not sure).

The only permission you need is EXECUTE on the package in Oracle.  If
you 
can connect to Oracle via SQL*Plus as the user running the stored 
procedure, you can execute 'select * from user_tab_privs' to see what 
privileges that user is granted.  If the user is granted execute
directly 
on the package, you will see an entry in that table.   If the user is 
granted execute via role, it is harder to figure out because you need to

look at the roles granted to the user (select * from user_role_privs)
and 
then what object privileges are granted to the roles (not a single SQL 
statement).

HTH.

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




Re: Currently running page requests

2004-09-14 Thread Lee Howard
I like that.  It worked great for me, but if you are not using
enterprise it will not work.  For those people you can also do the
same thing with a servlet.  Here is the java code.

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class threads extends HttpServlet{
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
	throws ServletException, IOException{
	resp.setContentType("text/html");
	PrintWriter out = resp.getWriter();
	Thread thread = Thread.currentThread();
	ThreadGroup threadGroup = thread.getThreadGroup();

	int count = threadGroup.activeCount();
	Thread[] threads = new Thread[count];

	count = threadGroup.enumerate(threads);
	out.println("Thread Count: " + count + "");
	for (int i=0;i
		try 
		{
			jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
			jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
			out.println("i: " + i + ": ");
			out.println(endPoint.getServerName() + endPoint.getRequestURI() + "
:" + endPoint.getRemoteHost() + "");
		} 
		catch (Exception e) {
		}
	}
	}
}

compile and put in the WEB-INF/classes folder.
I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar
call it using 
http://webserver.com/servlet/thread

- Original Message -
From: Douglas Knudsen <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 11:54:05 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

there was some JSP code for this floating around abit ago.  IIRC,
credit goes to Pete Frietag.  I never got this to work for me though. 
Some sort of caste error and I'm far from a Java guru.  Anyone get
this to work?

<%
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();
int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];
count = threadGroup.enumerate(threads);
out.println("Thread Count: " + count + "");

for (int i=0;i
out.println("i: " + i + "");
try 
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
out.println(endPoint.getServerName() + endPoint.getRequestURI() + "");
} 
catch (Exception e) { }
}

%>

- Original Message -
From: Adrocknaphobia <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 09:34:27 -0400
Subject: Re: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

Well I've found the stack trace invaluable in terms of information.
But the fact that you have to have your server running through command
prompt makes its pretty useless.

For example in a production app, you have to shut down the server.
(not cool) Then restart it in a command window (not cool), then you
cannot log off! (not cool) Although I'm told this is a windows only
issue. Still, its great insight into problems... but you cant really
get it when you need it.

-Adam

- Original Message -
From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 14:26:01 +0100
Subject: RE: Currently running page requests
To: CF-Talk <[EMAIL PROTECTED]>

And its nigh on useless in my opinion.

   _  

From: Tim Blair [mailto:[EMAIL PROTECTED] 
Sent: 14 September 2004 14:23
To: CF-Talk
Subject: RE: Currently running page requests

> Is there any way to get a list of currently running 
> page requests on the server so I can keep track or them?

You can perform a dump of the current stack trace, which will list
(amongst a big pile of other stuff) what's requests are currently being
processed by CF.  See the MM technote about it:
http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm

Tim.

--
---
Badpen Tech - CF and web-tech: http://tech.badpen.com/
---
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]
 [Donations and Support]




Re: To lock or not to lock

2004-09-14 Thread Don
Thanks for sharing your thought.  I don't know how others do their coding, in my practice, I usually set application variables at the application.cfm template level, it's really global variables, rarely changed.

> In CF5 you're supposed to lock ALL shared scope access to avoid 
> memory
> corruption.  With CFMX you only have to lock for avoidance of race
> conditions, because the underlying java runtime deals the memory
> issues.
> 
> Clustered environment doesn't matter, because CFLOCK is local to the
> machine in question, not the cluster.
> 
> If application variables (including instance variables of any
> application-scope CFCs) are set to a value and never change
> (exceedingly rare), then yes, you can skip locking.  However, you may
> as well just set them into the request scope, since they're going to
> be set every request.  You can use CFLOCK in this situation to only
> load the variables once and improve performace.  If you're
> instantiating large CFCs, the performance increase can be huge.
> 
> cheers,
> barneyb
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




CF Temp Files

2004-09-14 Thread Barney Boisvert
I know there was a bug in CFMX where temp files generated by CFFILE
action="" weren't ever cleaned up.  It was resolved with a
hotfix.  What about temp files that are created by your application
(using getTempFile(getTempDirectory(), "pref")))?  Do those ever get
cleaned up automatically?

I can't seem to find any info on this either way.

thanks,
barneyb

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




[SOLVED] Timeout on files over 2mb using CFFILE

2004-09-14 Thread Burns, John D
FYI, I found the solution to this problem.  URL Scan was installed on
the server and it had a file upload size limit set to 2 MB.  I figured
I'd let everyone know the problem for future reference and for the
archives.  Thanks.

John Burns

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 12:54 PM
To: CF-Talk
Subject: Timeout on files over 2mb using CFFILE

I have a situation where a server (on a military base that we don't have
control over) will upload files fine that are under 2MB.  As soon as you
try uploading a file larger than 2MB the page thinks for about a second
and goes immediately to a page not found error.  We can do files that
are 1.9MB and they work fine, it seems to be something with going over
2MB.  The server is Windows 2000 Server with IIS as the web server and
it was recently upgraded to MX 6.1 and then this problem was noticed.
Is there some setting in CF that would effect the size of the upload
allowed?  Any suggestions or info to point me in the right direction
would be great.  Thanks!

 
John Burns
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Null null error ARGHHH!

2004-09-14 Thread Mark W. Breneman
Just to update the list.  Looks like there are two bugs that MM has
confirmed that will cause a Null Null error. (per
http://www.talkingtree.com/blog/index.cfm?data="">

Bug numbers 51579 and 45343.

ColdFusion MX 6.1 Updater may contain one fixfor the (45343) NULL NULL
error.

Bug 45343: "The cfapplication tag generated exceptions if the browser sent
an incomplete CFID/CFTOKEN pair." 

This description seems to describe what I am seeing. Guess it is time to
install the ColdFusion MX 6.1 Updater.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com  
  608.270.9770



From: Al Everett [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 12:38 PM
To: CF-Talk
Subject: Re: Null null error ARGHHH!

See: http://www.talkingtree.com/blog/index.cfm?data="">

--- Alisa Thomson <[EMAIL PROTECTED]> wrote:

> I am getting the same error except mine is pointing to a CFQUERY.  I am
> running CFMX 6.1 Updater 3 on Solaris with Sybase 12.5 and jConnect
> 5.5.
> 
> 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: OT- NEWS - cfcertification.com

2004-09-14 Thread bsimmons
>Did anyone recently visit 
>http://www.cfcertification.com/

Just as an FYI to all:
This website USED to be ColdFusion related.  I believe it was run by several ColdFusioners.  They had a PDF file as study material for the ColdFusion 4.5 exam.  I don't think they ever updated their material for CF 5.0 and know for a fact they didn't update it for CFMX.

Basically, the site owners let the site die and didn't renew/keep the domain name.  Some spammer realized that the website ranked well in Google and had a large page linkage presence thru-out the Net, and they scooped up the domain name and put up their p0rn0 site in its place.  Happens all the time.

That being said, if you're looking ColdFusion Certification prep materials, check CFMX Exam Buster at:
http://centrasoft.com

This site is work-safe ;)

Thanks,
Brian
--
Brian Simmons
[EMAIL PROTECTED]
The ultimate ColdFusion MX Certification Exam testing tool:
Check out CFMX Exam Buster at: http://www.centrasoft.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Variable names stored in database - SOLVED

2004-09-14 Thread Shawn McKee



135px;font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;font-size:
10px;text-align: left;padding: 5 5 5 5;color : #variables.txtcolor##")>


   SELECT * FROM FRED


 


 
#Evaluate(DE(chris.text))#

-Original Message-
From: Shawn McKee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 9:19 AM
To: CF-Talk
Subject: Variable names stored in database

I would like to store style sheet information in a database but need to be
able to change some of the parameters on the fly.  If a straight file doing
the variable substitutions is no big deal.


   SELECT
  color
   FROM
  spec_table
   WHERE
  customer = 42





   
  div.template1{
   width: 300;
   height: 250;
   border: 1px solid black;
   background-color : #variables.bgcolor#;
  }
    Yes I know I don't need to use the extra step in this case but if it is stored in a DB I need constant names in string. So is it possible to store the style block in  a DB and then do the variable replacement? Shawn McKee Mgr., Web Development http://www.newsstand.com   _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: To lock or not to lock

2004-09-14 Thread Barney Boisvert
In CF5 you're supposed to lock ALL shared scope access to avoid memory
corruption.  With CFMX you only have to lock for avoidance of race
conditions, because the underlying java runtime deals the memory
issues.

Clustered environment doesn't matter, because CFLOCK is local to the
machine in question, not the cluster.

If application variables (including instance variables of any
application-scope CFCs) are set to a value and never change
(exceedingly rare), then yes, you can skip locking.  However, you may
as well just set them into the request scope, since they're going to
be set every request.  You can use CFLOCK in this situation to only
load the variables once and improve performace.  If you're
instantiating large CFCs, the performance increase can be huge.

cheers,
barneyb

On Tue, 14 Sep 2004 14:40:25 -0400, Don Chunshen Li
<[EMAIL PROTECTED]> wrote:
> This seems to be a timeless question of possible confusion.  This is my understanding of cf5.x and cf6.x, for a single cf server (not clustered) environment, application and server variables do not need to be locked when none of them needs to be modified in the course of applications execution, why? they are always the same for all users, so why lock them?
> while session variables is totally different.  Any one disagree?
> 
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Oracle Stored Procedures

2004-09-14 Thread Deanna Schneider
Scott,
Are you sure that it's actually returning a ref cursor? You'll get this
error if you say that you are returning one, but for some reason one is not
returned. For example, if you have error trapping in your procedure and the
cursor never gets opened. Therefore, if I'm returning a cursor, I always
make sure that if I've trapped errors and not opened the intended cursor,
that I open a "dummy" cursor and return that.

(This would probably be easier to debug if your DBA's would give you the
code to the cursor. Based on the name, it looks like it's not "real" code
anyway. Think you could talk them into it?)

> >Janet,
> >I have the snippet now from them.  This is how it's currently defined
> >(which looks like it's in line with what you posted aside from In Out):
> >
> >Type ReturnSet is ref cursor;
> >Procedure testpckg(curReturnSet Out Returnset);
> >
> >They had switched it before to be In Out for me and I still had the same
> >error.  The one thing I did notice is they do not have it defined with a
> >schema name, they just have:
> >
> >package Test01 is
> >
> >Type ReturnSet is ref cursor;
> >
> >Procedure testpckg(curReturnSet Out Returnset);
> >
> >Could that possible cause a permissions issue as Adam had alluded too?
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




To lock or not to lock

2004-09-14 Thread Don
This seems to be a timeless question of possible confusion.  This is my understanding of cf5.x and cf6.x, for a single cf server (not clustered) environment, application and server variables do not need to be locked when none of them needs to be modified in the course of applications execution, why? they are always the same for all users, so why lock them?
while session variables is totally different.  Any one disagree?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Asim Manzur
Revised Code
-


	









  style="font-style:veranda; font-size:12px; font-weight:bold;text-transform:lowercase;color:white;background-color:#557799;height:22px;border-style:ridge;text-align:center;" 
   
  value="Select a File...">



  value="Submit The Form Now!"
  style="font-style:veranda; font-size:12px;">  






 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Asim Manzur
The below is the code which swap the button to a graphic image.
but thats not the solution, its not uploading the file.

Bob, 
The article I was talking about, that girl actually explained it that how it could possible.
Anyway, I will go home and check my notes again to find out that URL and will post later sometime this week.

- Asim



	









  style="font-style:veranda; font-size:12px; font-weight:bold;text-transform:lowercase;color:white;background-color:#557799;height:22px;border-style:ridge;text-align:center;" 
   
  value="Select a File...">



  value="Submit The Form Now!"
  style="font-style:veranda; font-size:12px;">  






 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SuSE Linux Enterprise Server 9 anyone?

2004-09-14 Thread Lawrence Ng
thank you.

>>> [EMAIL PROTECTED] 9/14/2004 11:16:32 AM >>>
Lawrence Ng wrote:

> Thanks Jordan...
>
> do u have the url to blue dragon for more info?

Sure. =)

http://www.newatlanta.com/products/bluedragon/index.cfm 

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/ 
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Oracle Stored Procedures

2004-09-14 Thread Janet Schmitt
At 02:04 PM 9/14/2004 -0400, you wrote:
>No, by default this package will be created under the user who
>compiles it (the schema owner). Janet what are you thoughts on the
>variable type? I haven't been able to return a ref cursour when its
>specified as just OUT.

Adam -

You are correct.  The package is owned by the user who creates it and they 
are the only ones who can execute a procedure in the package until they 
'grant execute on the package' to the user executing it or to a role 
granted to the user or to public (which most DBA's will frown upon).

I also think the variable type needs to be of type IN OUT as mentioned 
previously.

Janet.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SuSE Linux Enterprise Server 9 anyone?

2004-09-14 Thread Jordan Michaels
Lawrence Ng wrote:

> Thanks Jordan...
>
> do u have the url to blue dragon for more info?

Sure. =)

http://www.newatlanta.com/products/bluedragon/index.cfm

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Oracle Stored Procedures

2004-09-14 Thread Janet Schmitt
Scott -

I think you need the IN OUT that Adam mentioned.

When you connect via SQL*Plus and successfully run the procedure, are you 
using the same username and password that is defined in the CF data 
source?  If so, then I do not think it is a permissions problem but I could 
be wrong.  If not, it might be a permissions problem.  You could test this 
by changing your CF code to specify the username and password in the stored 
procedure call that you use when you successfully run the procedure in 
SQL*Plus.  I think this will override what is stored in the CF data source 
definition (but I am not sure).

The only permission you need is EXECUTE on the package in Oracle.  If you 
can connect to Oracle via SQL*Plus as the user running the stored 
procedure, you can execute 'select * from user_tab_privs' to see what 
privileges that user is granted.  If the user is granted execute directly 
on the package, you will see an entry in that table.   If the user is 
granted execute via role, it is harder to figure out because you need to 
look at the roles granted to the user (select * from user_role_privs) and 
then what object privileges are granted to the roles (not a single SQL 
statement).

HTH.

Janet.

At 01:49 PM 9/14/2004 -0400, you wrote:
>Janet,
>I have the snippet now from them.  This is how it's currently defined
>(which looks like it's in line with what you posted aside from In Out):
>
>Type ReturnSet is ref cursor;
>Procedure testpckg(curReturnSet Out Returnset);
>
>They had switched it before to be In Out for me and I still had the same
>error.  The one thing I did notice is they do not have it defined with a
>schema name, they just have:
>
>package Test01 is
>
>Type ReturnSet is ref cursor;
>
>Procedure testpckg(curReturnSet Out Returnset);
>
>Could that possible cause a permissions issue as Adam had alluded too?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Oracle Stored Procedures

2004-09-14 Thread Adrocknaphobia
No, by default this package will be created under the user who
compiles it (the schema owner). Janet what are you thoughts on the
variable type? I haven't been able to return a ref cursour when its
specified as just OUT.

I still think the account they are giving you isnt kosher. Atleast if
you test it as the schema owner, it can rule that out.

-Adam

- Original Message -
From: Scott Mulholland <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 13:49:52 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk <[EMAIL PROTECTED]>

Janet,
I have the snippet now from them.  This is how it's currently defined
(which looks like it's in line with what you posted aside from In Out):

Type ReturnSet is ref cursor;

Procedure testpckg(curReturnSet Out Returnset);

They had switched it before to be In Out for me and I still had the same
error.  The one thing I did notice is they do not have it defined with a
schema name, they just have:

package Test01 is

Type ReturnSet is ref cursor;

Procedure testpckg(curReturnSet Out Returnset);

Could that possible cause a permissions issue as Adam had alluded too?

Thanks,
Scott

-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 11:11 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures 

It might be something to do with the way the refcursor is defined in the

package.  Would they be willing to change the package so the refcursor
is 
defined like this?

CREATE OR REPLACE
PACKAGE schemaname.testpckg
IS
TYPE curreturnset_type_ref_cursor IS REF CURSOR;

PROCEDURE testpckg(
curreturnset IN OUT curreturnset_type_ref_cursor);
END;

At 10:57 AM 9/14/2004 -0400, you wrote:
>Here is the new specification:
>
>   PROCEDURE TESTPCKG
> Argument NameType IN/OUT
>Default?
>   
>
> CURRETURNSET REF CURSOR   IN/OUT
>
>
>The code I'm using to call it is:
>
>
>
>   dataSource = "#ds#">
> 
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SuSE Linux Enterprise Server 9 anyone?

2004-09-14 Thread Lawrence Ng
Thanks Jordan...

do u have the url to blue dragon for more info?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SuSE Linux Enterprise Server 9 anyone?

2004-09-14 Thread Jordan Michaels
Lawrence Ng wrote:

> hello all,
>
> Are/Have any of you installed SuSE Linux Enterprise Server 9 which was
> just released last month and see how it is with MX?
>
> We are still deciding if we want to install version 9 or current
> version 8.
>
> The key is the verity search tool for files which currently does not
> work under our Nix platform. Hopefully Blackstone would improve on
> things even under version 9.
>
> feedbacks appreciated.

The Blue Dragon CFML engine uses Lucene, which is from the apache 
foundation and is written entirely in java. So, it's pretty safe to say 
that it works in *nix environments. Also, while SuSE isn't an officially 
supported OS of Blue Dragon, I've had great success getting it to run 
smoothly on SuSE 8.2 Professional. (I have plans to try it on 9.1, just 
haven't gotten around to it yet)

At any rate, I believe it's a viable option if you're looking to run a 
CF-Based search enginein a *nix environment.

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Janet,
I have the snippet now from them.  This is how it's currently defined
(which looks like it's in line with what you posted aside from In Out):

 
Type ReturnSet is ref cursor;

 
Procedure testpckg(curReturnSet Out Returnset);

 
They had switched it before to be In Out for me and I still had the same
error.  The one thing I did notice is they do not have it defined with a
schema name, they just have:

 
package Test01 is

 
Type ReturnSet is ref cursor;

 
Procedure testpckg(curReturnSet Out Returnset);

Could that possible cause a permissions issue as Adam had alluded too?

 
Thanks,
Scott

-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 11:11 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures 

It might be something to do with the way the refcursor is defined in the

package.  Would they be willing to change the package so the refcursor
is 
defined like this?

CREATE OR REPLACE
PACKAGE schemaname.testpckg
IS
TYPE curreturnset_type_ref_cursor IS REF CURSOR;

PROCEDURE testpckg(
curreturnset IN OUT curreturnset_type_ref_cursor);
END;

At 10:57 AM 9/14/2004 -0400, you wrote:
>Here is the new specification:
>
>   PROCEDURE TESTPCKG
> Argument NameType IN/OUT
>Default?
>   
>
> CURRETURNSET REF CURSOR   IN/OUT
>
>
>The code I'm using to call it is:
>
>
>
>   dataSource = "#ds#">
> 
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Null null error ARGHHH!

2004-09-14 Thread Al Everett
See: http://www.talkingtree.com/blog/index.cfm?data="">

--- Alisa Thomson <[EMAIL PROTECTED]> wrote:

> I am getting the same error except mine is pointing to a CFQUERY.  I am
> running CFMX 6.1 Updater 3 on Solaris with Sybase 12.5 and jConnect
> 5.5.
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: [Spam?] Re: Regex help

2004-09-14 Thread Pascal Peters
I think you are missing a ]

REReplace(ThisTag.GeneratedContent, "\[[^\]]*\]", "", "All")

Or maybe even "\[[^]]*\]"

On cfmx, you could use non-greedy matches: "\[.*?\]"

Pascal

> -Original Message-
> From: Dirk De Bock - Listclient [mailto:[EMAIL PROTECTED]
> Sent: 14 September 2004 19:14
> To: CF-Talk
> Subject: [Spam?] Re: Regex help
> 
> This is working ok in CF5 but apparently not in CFMX
> 
> Malformed regular _expression_ "\[[^\]*\]".
> Reason: Unmatched [] in _expression_..
> 
> REReplace(ThisTag.GeneratedContent, "\[[^\]*\]", "", "All")
> 
> it's supposed to strip all [] with everyting inbetween the brackets
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
We are using the Oracle drivers that ship with MX Enterprise so
according to that technote we should be ok with ref cursors.

 
Thanks for the info Janet, I'm currently looking into having the cursor
defined along the lines of your last post.

 
Scott

-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 11:21 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures

Scott -

The other thing you might want to look at is what Oracle drivers are
being 
used.  I know there are issues with some of the drivers and Oracle
stored 
procedures.

Here is  a technote regarding one Oracle driver that mentions support
for 
Oracle refcursors:

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

Janet. 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Question about processing a CSV file.

2004-09-14 Thread Ryan Emerle
I have done a lot of work with file imports, you can check out cfx_text2query:

http://www.emerle.net/programming/display.cfm/t/cfx_text2query

Though, your CSV seems simple enough to parse as a list, without
anything fancy.. unless that file is huge..

-R

On Mon, 13 Sep 2004 22:36:19 +0100, Ciliotta, Mario
<[EMAIL PROTECTED]> wrote:
> 
> Hi,
> 
> I was wondering if anyone could help me out as I am stuck on this part.  I
> have a csv file that I would like to read and then issue an update query based
> on the contents.
> 
> Basically I would like to read the file and then loop over the file and issue
> and update query for each line (maybe I could convert it to stored procedure
> later).
> 
> The file looks like this:
> 
> "5388120","12345678IL"
> "5388150","FDX123FD45"
> "5388165","RT6789"
> "5388198","12345HY890"
> "5388204","123SEDFRT"
> "5388205","1ASEFFBH6"
> "5388209","12890HFS23"
> "5388212","124300HGFS"
> "5388231","123567UHJK"
> "5388235","12WWE4DD45"
> "5388281","1234RFGT76"
> "5388284","313SFFS67"
> "5388361","23DS45"
> "5388366","4422442242"
> "5388372","42242FDFSF"
> "5388403","FDXUPSDELD"
> "5388409","1234567890"
> "5388414","ASWDERF455"
> "5388415","123EDCVBH6"
> "5388417","12WSED56YH"
> "5388424","12WSC56HBN"
> "5388428","123WSE456H"
> "5388510","313DADDADA"
> "5388511","HFH678947S"
> "5388597","3131ADADAD"
> "5388654","ADA5DFA5RD"
> "5388655","AD4242DDAA"
> "5388661","1331XSSA4D"
> 
> And what I want to do is loop over it and issue an update:
> PUSEDOCODE:
> 
> 
>    update table
>set track_nbr = '2345678il'
>    where header_id = 5388120
> 
> 
> What is the best way to do this.  I can process the file but I am lost as to
> what to do.
> 
> This is what I have so far:
> 
> 
> 
> 
> 
> variable = "Variables.SourceFile">
> 
> 
> delimiters="#RecordDelimiter#">
>   
> 
>   
>   
>  
> 
> Thanks
> Mario
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SOT: How to apply a style sheet to a file upload bottom.

2004-09-14 Thread Asim Manzur
I couldn't find that link yet, but I still had an idea that what was mentioned in that article.

I have posted the link for you guys to review and advise.
in this link, i have play with a trick to swap the browse button, and then post it to the .cfm file, through _javascript_ I am putting the value in the field.

Let me know if that make sense so, I will post the codes on my next thread.

http://www.logikzone.com/temp/upload.cfm

Thanks

>> I have seen that trick somewhere on web awhile ago,
>> I am trying to find the link and will post.
>
>You can do the "trick" using CSS and _javascript_ and the GUI can be
>stylized as you want. The file upload function however won't work -- a
>0 bit file is what's uploaded. That's due to a security measure built
>into the browser.
>
>I've gone down this road before as have others. It's been a while
>though. If you find a solution, which doesn't break the upload
>functionality, please post. I'd be interested to see it. Thanks.
>
>
>-
>Regards,
>Bob Haroche
>O n P o i n t  S o l u t i o n s
>www.OnPointSolutions.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




  1   2   >