ColdFusion - Long Running Processes - Garbage Collection - structDelete

[Ryan Duckworth]

We used a trick in *ColdFusion 8* that does not seem to work in *ColdFusion
9*.

Inside of loops in heavy lifting / long running processes ( scheduled pages
), we would use:

structDelete( variables, "foo" );
This would, in theory, remove the pointer to the location in memory and
allow for garbage collection.

I have tried moving the processing inside of a cffunction and using a
similar trick on the local scope.
var objOrder = 

structDelete( local, "foo" );

structDelete on variables and local do *not work* in *ColdFusion 9*.

Another trick, that is less than ideal, and would require re-writing a
significant amount of code is to have 2 pages:
The 1st page would contain the loop and use cfhttp to call the 2nd page
that actually does the processing.

This, in theory, would be a solution if ColdFusion 9 only allows Garbage
Collection at the *end of each request*. ( I sure hope this isn't true )

Any Ideas?
Maybe cfthread?

I know that others out there must have encountered this same problem and
come up with a solid solution.
Please share your tricks.

Best,
Ryan


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349204
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ColdFusion Builder 2 - File - Open - Path with Forward Slashes from Stack Trace

[Ryan Duckworth]

You are the man. Thanks!

I think we have the backward slashes because we are using virtual drives.

If anyone else wants the solution:

Edit this file: F:\ColdFusion9\wwwroot\WEB-INF\exception\detail.cfm

line 142:
#s_error_in# #encodeForError(vcfml[1])#
#s_error_in# #replaceNoCase( encodeForError(vcfml[1] ), "&##x2f;", "\",
"all" )#

line 146:
#s_called_from# #encodeForError(vcfml[i])#
#s_called_from# #replaceNoCase( encodeForError( vcfml[i] ),
"&##x2f;", "\", "all" )#

line 294:
#encodeForError(vjava[i])#
#replaceNoCase( encodeForError( vjava[i] ), "&##x2f;", "\", "all" )#

Best,


Ryan Duckworth

Software Project Manager



Uhlig LLC

8455 Lenexa Drive

Overland Park, KS 66214



rduckwo...@uhlig.com

www.uhlig.com

On Wed, Nov 9, 2011 at 11:15 AM, Raymond Camden wrote:

>
> Btw -when I get an error on my WIn7 box, the slashes are right:
>
>
>
> Attribute validation error for tag CFSAVECONTENT.
>
> It does not allow the attribute(s) ARIABLE. The valid attribute(s) are
> VARIABLE.
>
> The error occurred in C:\websites\webroot\test.cfm: line 2
> 1 :
> 2 : 
> 3 : {"D":[{"D":" screen that "}]}
> 4 : 
>
> On Wed, Nov 9, 2011 at 9:04 AM, Ryan Duckworth
>  wrote:
> >
> > Does anyone know how to copy one of the paths below and open in
> ColdFusion
> > Builder 2…
> >
> > In ColdFusion Builder 1… File – Open – Paste Path – Enter…  would open
> the
> > file.
> >
> > I am not sure what caused paths in stack traces to change from back
> slashes
> > to forward slashes.
> >
> > Or, is there a way in the Local ColdFusion Admin to specify back slashes
> > instead of forward slashes in stack traces?
> > http://localhost/CFIDE/administrator/index.cfm
> >
> > Example Paths in Stack Trace:
> >
> > The error occurred in *G:/www/scripts/globalFunctions.cfm*: line 449
> > Called from *G:/www/com/server/Example.cfc*: line 5268
> >
> > Thanks,
> > Ryan
> >
> > Running ColdFusion 9 Developer Edition - 64 bit - Windo
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348552
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ColdFusion Builder 2 - File - Open - Path with Forward Slashes from Stack Trace

[Ryan Duckworth]

Jedi,

Thanks for the quick reply.  I don't quite have the back slash change
working yet.
I also wanted to say thanks for the free CFWACK book at CFUNITED a few
years ago. I was the one who won your blog tat contest.

*I think you are referring to this file*:

F:\ColdFusion9\wwwroot\WEB-INF\exception\java\lang\Exception.cfm





Editing this file doesn't seem to change anything.

Any ideas?

*I also looked at this file*:
F:\ColdFusion9\wwwroot\WEB-INF\exception\errorcontext.cfm







 
 
 












 
 
  try
  {
  firstLine = attributes.errorLocation.line - attributes.showcontext;
  lastLine  = attributes.errorLocation.line + attributes.showcontext;
  //create an instance of VFSFileFactory to fetch the intputstream
  vfsfilefactory = createObject("java", "coldfusion.vfs.VFSFileFactory");

  //get the input stream for the file
  inputStream =
vfsfilefactory.getInputStream(attributes.errorLocation.Template);

  //  Wrap a InputStreamReader in a LineNumberReader to read the CFML
template as text.
  inputStreamReaderClass = createObject("java",
"java.io.InputStreamReader");
  inputStreamReader = inputStreamReaderClass.init(inputStream);

  lineReaderClass = createObject("java", "java.io.LineNumberReader" );
  lineReader = lineReaderClass.init(inputStreamReader);
  currentLine = lineReader.readLine();
  while ( isDefined("currentLine") and lineReader.getLineNumber() lte
lastLine )
  {
   if ( lineReader.getLineNumber() gte firstLine )
   {
   lineInfoStruct= structNew();
lineInfoStruct.line   = currentLine;
lineInfoStruct.lineNumber = lineReader.getLineNumber();
ArrayAppend(result, lineInfoStruct);
   }
   currentLine = lineReader.readLine();
  }
  } catch ( "Any" ex) {
   lineInfoStruct = structNew();
   lineInfoStruct.line = s_unable;
   lineInfoStruct.lineNumber = -1;
   lineInfoStruct.diagnostic = ex;

   ArrayAppend(result, lineInfoStruct);
  }
  finally
  {
   if(isDefined("lineReader"))
   {
lineReader.close();
   }
  }
 
 






On Wed, Nov 9, 2011 at 9:42 AM, Raymond Camden wrote:

>
> The exception you see when an error occurs is actually driven by a CFM
> file, exception.cfm. In theory you can just edit that yourself.
>
>
> On Wed, Nov 9, 2011 at 9:04 AM, Ryan Duckworth
>  wrote:
> >
> > Does anyone know how to copy one of the paths below and open in
> ColdFusion
> > Builder 2…
> >
> > In ColdFusion Builder 1… File – Open – Paste Path – Enter…  would open
> the
> > file.
> >
> > I am not sure what caused paths in stack traces to change from back
> slashes
> > to forward slashes.
> >
> > Or, is there a way in the Local ColdFusion Admin to specify back slashes
> > instead of forward slashes in stack traces?
> > http://localhost/CFIDE/administrator/index.cfm
> >
> > Example Paths in Stack Trace:
> >
> > The error occurred in *G:/www/scripts/globalFunctions.cfm*: line 449
> > Called from *G:/www/com/server/Example.cfc*: line 5268
> >
> > Thanks,
> > Ryan
> >
>
> --
> ===
> Raymond Camden, Adobe Developer Evangelist
>
> Email : raymondcam...@gmail.com
> Blog : www.coldfusionjedi.com
> Twitter: cfjed
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348538
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

ColdFusion Builder 2 - File - Open - Path with Forward Slashes from Stack Trace

[Ryan Duckworth]

Does anyone know how to copy one of the paths below and open in ColdFusion
Builder 2…

In ColdFusion Builder 1… File – Open – Paste Path – Enter…  would open the
file.

I am not sure what caused paths in stack traces to change from back slashes
to forward slashes.

Or, is there a way in the Local ColdFusion Admin to specify back slashes
instead of forward slashes in stack traces?
http://localhost/CFIDE/administrator/index.cfm

Example Paths in Stack Trace:

The error occurred in *G:/www/scripts/globalFunctions.cfm*: line 449
Called from *G:/www/com/server/Example.cfc*: line 5268

Thanks,
Ryan

Running ColdFusion 9 Developer Edition - 64 bit - Windo

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348530
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

cfchart - cfchartseries - cfchartdata

[Ryan Duckworth]

I would like to change my cfchart to only show the label in my cfchartseries 
for the first and last data point.

I can turn on/off the labels for the entire cfchartseries using

on: datalabelstyle="value"
off: datalabelstyle="none"

How can I turn it on for the first and last data point, but off for all those 
in the middle?

The reason that I want to do this is I have several cfchartseries that overlap 
each other and the labels are not readable.

I believe that cfchartdata only has 2 attributes: item and value.

It would be nice if cfchartdata had a 3rd attribute displayLabel = true or 
false.

Anyone know how to do this?

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330152
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: load issue and SQL Server

[Ryan Duckworth]

Oh... I forgot to mention that ColdFusion caches IP addresses.

During down time, you need to:
1. Stop the ColdFusion Service
2. run ipconfig /flushdns
3. run ipconfig /registerdns
4. run ping yourSQLServer and you should get back the new IP
5. Start the ColdFusion Service

Make sure that in the ColdFusion Administrator you are using the name
of the SQL Server and not the old IP address.

I think this will solve your problem.
Ryan

On Tue, Jun 17, 2008 at 8:42 AM, Ryan Duckworth
<[EMAIL PROTECTED]> wrote:
> Does the web server have 1 or 2 network cards?  If only 1, it is
> contending with all the web traffic.
> 2 GB nics in the web server and 1 GB nic in the SQL Server should
> solve the problem.
>
> The default isolation level is READ COMMITTED, so that looks normal.
>
> When you find a thread in Fusion Reactor that is taking a really long
> time, capture the stack trace and email it to me.
>
> Hope this helps.
> Ryan
>
> On Mon, Jun 16, 2008 at 5:25 AM, Rick Root <[EMAIL PROTECTED]> wrote:
>> I've got a client who has asked me to move a SQL Server database from
>> one server (the web server) to a separate server.
>>
>> Everything is working well when they database is on the same machine.
>> However, when I moved the db and modified the DSN to point to the
>> remote SQL Server (different box in the same rack) I'm finding the
>> application is running really slow.
>>
>> I have the CF thread pool limit set to 10 threads right now but a lot
>> of the threads are running very slowly now and if I stack trace them
>> in Fusion Reactor, I see stuff like this:
>>
>> http://cfm.pastebin.com/d53dc3ada
>>
>> Particularly, if I stack trace a request over and over again I see
>> this line changing:
>>
>> waiting on <0x1372a7a> (a coldfusion.server.j2ee.sql.pool.JDBCPool
>> held by thread 373, jrpp-130
>>
>> So it would appear that something is blocking many of the requests but
>> I can't tell what.
>>
>> Additionally, if I go into SQL Server Enterprise Manager, I'm seeing
>> database locks for both CF processes that are connected to the db.
>>
>> If I look at the details of the database locks, the last SQL batch
>> transmitted is:  SET TRANSACTION ISOLATION LEVEL READ COMMITTED
>>
>> So maybe these database locks are causing it, but I'm not sure where
>> those are coming from
>>
>> NOTE:  This application is fairly active, even at 6:00 am EST.  It's
>> running on CF 8 *STANDARD* on Windows SErver 2003.
>>
>> Anyone have any suggestions for me for things to look for?
>>
>> --
>> Rick Root
>> New Brian Vander Ark Album, songs in the music player and cool behind
>> the scenes video at www.myspace.com/brianvanderark
>>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307604
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: load issue and SQL Server

[Ryan Duckworth]

Does the web server have 1 or 2 network cards?  If only 1, it is
contending with all the web traffic.
2 GB nics in the web server and 1 GB nic in the SQL Server should
solve the problem.

The default isolation level is READ COMMITTED, so that looks normal.

When you find a thread in Fusion Reactor that is taking a really long
time, capture the stack trace and email it to me.

Hope this helps.
Ryan

On Mon, Jun 16, 2008 at 5:25 AM, Rick Root <[EMAIL PROTECTED]> wrote:
> I've got a client who has asked me to move a SQL Server database from
> one server (the web server) to a separate server.
>
> Everything is working well when they database is on the same machine.
> However, when I moved the db and modified the DSN to point to the
> remote SQL Server (different box in the same rack) I'm finding the
> application is running really slow.
>
> I have the CF thread pool limit set to 10 threads right now but a lot
> of the threads are running very slowly now and if I stack trace them
> in Fusion Reactor, I see stuff like this:
>
> http://cfm.pastebin.com/d53dc3ada
>
> Particularly, if I stack trace a request over and over again I see
> this line changing:
>
> waiting on <0x1372a7a> (a coldfusion.server.j2ee.sql.pool.JDBCPool
> held by thread 373, jrpp-130
>
> So it would appear that something is blocking many of the requests but
> I can't tell what.
>
> Additionally, if I go into SQL Server Enterprise Manager, I'm seeing
> database locks for both CF processes that are connected to the db.
>
> If I look at the details of the database locks, the last SQL batch
> transmitted is:  SET TRANSACTION ISOLATION LEVEL READ COMMITTED
>
> So maybe these database locks are causing it, but I'm not sure where
> those are coming from
>
> NOTE:  This application is fairly active, even at 6:00 am EST.  It's
> running on CF 8 *STANDARD* on Windows SErver 2003.
>
> Anyone have any suggestions for me for things to look for?
>
> --
> Rick Root
> New Brian Vander Ark Album, songs in the music player and cool behind
> the scenes video at www.myspace.com/brianvanderark
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307602
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF8 Dev running very slow

[Ryan Duckworth]

Bill,

We are having the same problem on our newly installed CF 8 Servers.

Page requests that loaded in 100ms on CF7 are taking up to 30 seconds on CF8.

Please view the thread I created here:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:53667#289881

Have you installed CF 8 HotFix 1?

Are you using Application.cfm's or Application.cfc's?

Do you have Fusion Reactor installed so you can capture stack traces
of what the process is hanging on?

Hopefully we have the same problem and with Adobe's help can figure it out.

Thanks,
Ryan

On 10/4/07, Bill Betournay <[EMAIL PROTECTED]> wrote:
> Hi Jo
>
> Thank you, I did have those enabled and have now disabled both. It is better
> but still far from acceptable. Any other ideas??
>
> Bill
>
> -Original Message-
> From: João_Fernandes [mailto:[EMAIL PROTECTED]
> Sent: October 4, 2007 8:45 PM
> To: CF-Talk
> Subject: Re: CF8 Dev running very slow
>
> Hi Bill,
>
> did you enable memory tracking on the server monitor? And Report time
> executions in the debugging section? Those can considerably  reduce
> performance.
>
> --
> João Fernandes
> www.onflexwithcf.org
> www.riapt.org
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290258
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF 8 Load Time Problem

[Ryan Duckworth]

We may have found a problem... We create a bunch of functions and put
them in the request scope.  On that page, just before the createObject
calls was a call to one of those functions in the request scope but is
was missing the request scope.


Correctly Scoped Call:
request.param("form.action","");

Incorrectly Scoped Call:
param("form.action","");



Example request function:












request.param = param;




We were not getting an error because we were using the "onRequet"
instead of "onRequestStart" and "onRequestEnd" in the Application.cfc


Thanks,
Ryan


On 10/4/07, Tom Chiverton <[EMAIL PROTECTED]> wrote:
> On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
> > We are still having a huge problem with createObject calls in
> > ColdFusion 8 taking up to 300 seconds.  Please help!  Below is a stack
> > trace from Fusion Reactor.
>
> What are you creating ? What does the object do at startup ?
>
> --
> Tom Chiverton
> Helping to synergistically orchestrate turn-key communities
> on: http://thefalken.livejournal.com
>
> 
>
> This email is sent for and on behalf of Halliwells LLP.
>
> Halliwells LLP is a limited liability partnership registered in England and 
> Wales under registered number OC307980 whose registered office address is at 
> St James's Court Brown Street Manchester M2 2JF.  A list of members is 
> available for inspection at the registered office.  Any reference to a 
> partner in relation to Halliwells LLP means a member of Halliwells LLP.  
> Regulated by The Solicitors Regulation Authority.
>
> CONFIDENTIALITY
>
> This email is intended only for the use of the addressee named above and may 
> be confidential or legally privileged.  If you are not the addressee you must 
> not read it and must not use any information contained in nor copy it nor 
> inform any person other than Halliwells LLP or the addressee of its existence 
> or contents.  If you have received this email in error please delete it and 
> notify Halliwells LLP IT Department on 0870 365 8008.
>
> For more information about Halliwells LLP visit www.halliwells.com.
>
> 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290222
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF 8 Load Time Problem

[Ryan Duckworth]

scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)




On 10/1/07, Jayesh Viradiya <[EMAIL PROTECTED]> wrote:
> Hi,
>
> If you don't have your template compiled then at first time it will
> under go compilation which takes a few (mili)seconds depending upon your
> template size.
>
> If you clear the Template cache then CF will re-load templates into
> memory the next time they are requested and recompile them again if they
> have been modified. Once you have all the templated compiled, subsequent
> request should be smoother.
>
> In production environment it is recommended to check the "Save Class
> Files" option.
>
> Regards,
> Jayesh Viradiya
> Adobe CF Team
>
> -Original Message-
> From: Ryan Duckworth [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 01, 2007 3:31 PM
> To: CF-Talk
> Subject: CF 8 Load Time Problem
>
> We have been running CF 8 in our dev environment without any problems.
>  After upgrading to CF 8 on one of our production boxes, we are having
> lots of problems.
>
> The first page hit seems to take an extreme amount of time.  We have
> been watching these requests using Fusion Reactor and have seen the
> same stack traces repeatedly.  Most of them have to do with
> "TemplateClassLoader" or "java.lang.ClassLoader.loadClass"
>
> The requests seem to backup to the point where they take over a minute
> each.
>
> When we got our server to finally respond quickly we tried "Clear
> Template Cache Now" and this triggered the long request times again.
>
> Below are some of the sample stack traces.  Any ideas?
> _
> java.lang.Class.getDeclaredConstructors0(Class.java:???)[Native Method]
> java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
> java.lang.Class.getConstructor0(Class.java:2699)
> java.lang.Class.newInstance0(Class.java:326)
> java.lang.Class.newInstance(Class.java:308)
> coldfusion.runtime.TemplateClassLoader.newInstance
> .
> _
>
> java.io.WinNTFileSystem.getBooleanAttributes(WinNTFileSystem.java:???)[N
> ative
> Method]
> java.io.File.exists(File.java:733)
> sun.misc.URLClassPath$FileLoader.getResource(URLClassPath.java:983)
> sun.misc.URLClassPath.getResource(URLClassPath.java:168)
> java.net.URLClassLoader$1.run(URLClassLoader.java:192)
> java.security.AccessController.doPrivileged(AccessController.java:???)[N
> ative
> Method]
> java.net.URLClassLoader.findClass(URLClassLoader.java:188)
> coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader
> ..java:221)
> java.lang.ClassLoader.loadClass(ClassLoader.java:299)
> .
> ___
>
>
>
> 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290184
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF 8 Load Time Problem

[Ryan Duckworth]

We have been running CF 8 in our dev environment without any problems.
 After upgrading to CF 8 on one of our production boxes, we are having
lots of problems.

The first page hit seems to take an extreme amount of time.  We have
been watching these requests using Fusion Reactor and have seen the
same stack traces repeatedly.  Most of them have to do with
"TemplateClassLoader" or "java.lang.ClassLoader.loadClass"

The requests seem to backup to the point where they take over a minute each.

When we got our server to finally respond quickly we tried "Clear
Template Cache Now" and this triggered the long request times again.

Below are some of the sample stack traces.  Any ideas?
_
java.lang.Class.getDeclaredConstructors0(Class.java:???)[Native Method]
java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
java.lang.Class.getConstructor0(Class.java:2699)
java.lang.Class.newInstance0(Class.java:326)
java.lang.Class.newInstance(Class.java:308)
coldfusion.runtime.TemplateClassLoader.newInstance

_

java.io.WinNTFileSystem.getBooleanAttributes(WinNTFileSystem.java:???)[Native
Method]
java.io.File.exists(File.java:733)
sun.misc.URLClassPath$FileLoader.getResource(URLClassPath.java:983)
sun.misc.URLClassPath.getResource(URLClassPath.java:168)
java.net.URLClassLoader$1.run(URLClassLoader.java:192)
java.security.AccessController.doPrivileged(AccessController.java:???)[Native
Method]
java.net.URLClassLoader.findClass(URLClassLoader.java:188)
coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.java:221)
java.lang.ClassLoader.loadClass(ClassLoader.java:299)

___

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289874
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: var and queries with no name

[Ryan Duckworth]

Chad,

You should always var your query name and use a query name to make it
a local variable and avoid race conditions.

With that said, that is not the cause of your problem.

The deadlock is occurring at the database level.  Normally I can get
rid of deadlocks by tuning the query.  There are several ways to do
this.
1.  Get rid of columns not needed in select statements.
2.  Improve the query with a better where clause or less joins.
3.  Add indexes!  Your tables are probably not indexed properly for
the queries you are running.
4.  Run the queries that you are getting the deadlocks on through
Database Tuning Wizard / Advisor (SQL Server)
5.  If you just increased your server load a lot by adding customers
or an application, you may need to upgrade your SQL Server.  Look at
adding RAM or a faster processor.

Make sure that your primary keys have clustered indexes and your
foreign keys that you are joining on have non-clustered indexes.  It
is also good to create non-clustered indexes for items in your where
clauses.  Also, try to access resources in the same order.  If you
have two differerent pages that both use the Order Log and Order
tables, query them in the same order to avoid dead locks.

Hope this helps.
Thanks,
Ryan


On 10/1/07, gary gilbert <[EMAIL PROTECTED]> wrote:
> I don't believe so.
>
> You should check your lock type(s) you are using.  By default sql server
> uses row locking but you may be in a situation where page or table locking
> is taking place.
>
> Check out this
> http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx for some
> good advice.
>
>
>
> --
> Gary Gilbert
> http://www.garyrgilbert.com/blog
>
>
> 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289865
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Subversion and Eclipse - Version Rollback

[Ryan Duckworth]

After attending CFUnited we decided to investigate using Subversion
for Source Control for our ColdFusion applications.

I think this will meet our needs for Source Control, but we are also
interested in tracking versions of our software and having the option
of quickly rolling back to a previous version.

Obviously, most source/version control systems out there were built
for compiled languages, not ColdFusion, but there has to be a workable
solution for us web application developers that need to upload
quickly, but also have large version releases.

What is everyone out there doing to solve this problem?

We are looking at having every developer use CF Dev and work directly
on their own machine, while sharing a development SQL Server box.  All
of us developing in Eclipse or Homesite and using Subversion to commit
changes to our central repository.

Please help.
Thanks,
Ryan

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260210
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Fusion Reactor interfering with web services?

[Ryan Duckworth]

We had a problem with CFC web services that was intermittent and we
solved that by placing the CFC's in their own web service directory
and placing an Application.cfm file in that directory.

Basically the CFC web services when ran will look for an
Application.cfm file and go up the directory structure until they find
one to run.

Create a new Application.cfm file in that directory that only has the
CFC's and place this one line in it:



Hope this helps,
Ryan

On 9/21/06, Cedric Mollet <[EMAIL PROTECTED]> wrote:
> Thanks Ryan.
> The webservices are cfc's.
>
> I've got them working on dev environment, cfmx 6.1 updater.
>
> The only difference right now between dev and prod environments is a couple
> of extra hotfixes in production that I haven't yet put in place in dev. They
> were in dev, but I've since done a complete reinstall.
>
> I don't think FusionReactor is the culprit, but the behavior I've been
> seeing is pretty nutty. At this point, I'm looking at a complete reinstall
> in production environment to further troubleshoot the issue.
>
> They are .class files in my directory, but I'm not running mx 7.
>
> Thanks
> cedric
>
>
> -Original Message-
> From: Ryan Duckworth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 21, 2006 2:38 PM
> To: CF-Talk
> Subject: Re: Fusion Reactor interfering with web services?
>
> Are these web services created by CFC's or not?
>
> Are you getting a compiler error like this?
> coldfusion.jsp.CompilationFailedException: Errors reported by Java compiler
>
> Can you post the stack trace of the error message that you get?
>
> Also, in your WS directories under "\CFusionMX7\stubs" are there .java files
> or .class files?
>
> If there are .java files then there is a java compiler issue.
>
> Thanks,
> Ryan
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253798
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Fusion Reactor interfering with web services?

[Ryan Duckworth]

Are these web services created by CFC's or not?

Are you getting a compiler error like this?
coldfusion.jsp.CompilationFailedException: Errors reported by Java compiler

Can you post the stack trace of the error message that you get?

Also, in your WS directories under "\CFusionMX7\stubs" are there .java
files or .class files?

If there are .java files then there is a java compiler issue.

Thanks,
Ryan

On 9/21/06, Cedric Mollet <[EMAIL PROTECTED]> wrote:
> Hi everyone,
> My application has several web services that have been working just fine for
> the last year or so.
> Due to other server issues that were popping up, ( Jrun memory useage, mice
> in the server, etc...) I recently went through and installed all the CFMX
> 6.1 updater hotfixes that appeared to perhaps be involved in the issues I
> was having.
> I also installed Fusion-Reactor to help in debugging the issue.
>
> Since that time, my web services have all stopped working. I get the
> following error message:
>
> Could not generate stub objects for web service invocation.
>
> I've tried deleting the class files, reloading the webservices, and another
> fix that that refreshes web services
>action="Create"
>   name="factory"
>   class="coldfusion.server.ServiceFactory">
>
> 
>
> http://etc...";)>
>
> At this point I'm out of ideas, as the error still exists. There have been
> no changes to the code in the webservices so I'm confident that this is more
> of a server config issue.
>
> Thanks in advance
> cedric
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253767
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Could not perform Web service invocation

[Ryan Duckworth]

I tried that try/catch with the [coldfusion.server.ServiceFactory]
"refreshWebService" call and still can't get it to work.  The problem
occurs right after we restart our coldFusion servers.

This is the error message that I get when I call refreshWebService:

coldfusion.jsp.CompilationFailedException: Errors reported by Java
compiler: Found 1 syntax error in
"F:/CFusionMX7/stubs/WS-1575360704/com_achex_webservices/ExtendedDetail.java":
8. package .com_achex_webservices; <> *** Syntax: Unexpected symbol
ignored .


Thanks,
Ryan

On 9/11/06, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
> Have you tried resetting the webservice in the factory before making a call 
> to it. Basically it causes the stub object to be re-written (as far as I can 
> remember.)
>
> http://www.achex.com/ws/Authorization.wsdl"; />
>  "coldfusion.server.ServiceFactory").XmlRpcService.refreshWebService(wsdl) />
>
> I just wrap every delicate webservice call I make in a try/catch block, and 
> then reset it in case of an error and rerun. It eliminates a lot of the 
> problems I've had with calling webservices.
>
> Terrence Ryan
> Senior Systems Programmer
> Wharton Computing and Information Technology
> E-mail: [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Ryan Duckworth [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 11, 2006 10:30 AM
> To: CF-Talk
> Subject: Could not perform Web service invocation
>
> I recently integrated with TeleCheck to accept eChecks on our sites.
> Everything seems to work perfectly except for ColdFusion's ability to 
> generate and hold onto the stub code for the webservice.
>
> The worst kind of problem too... it is intermittent with no obvious pattern.
>
> The WSDL files look good.  TeleCheck web service calls will work great, but 
> after we restart a server SOMETIMES we receive the "Could not perform web 
> service invocation" error.
>
> Test Server:
> http://test.achex.com/ws/Authorization.wsdl
>
> Production Server:
> http://www.achex.com/ws/Authorization.wsdl
>
> I have tried to search forums for a possible solution, but can't seem to get 
> it to work.
>
> Personally, I believe this is a bug with ColdFusion.  Some forums have 
> mentioned that ColdFusion does not handle complex web service types very 
> well.  However, TeleCheck wrote the web service and I can not change their 
> data types.
>
> I have also read that ColdFusion "flushes" the stub objects from memory.  We 
> have installed Cumulative Hot Fix 7.0.2 which stated that it solved some web 
> service flushing problems.
>
> The only way we have been able to somewhat solve this problem temporarily is 
> to delete everything in the \CFusionMX7\stubs before restarting ColdFusion.  
> This solution is not acceptable for our production environment and I would 
> like a true solution to this problem.
>
> This problem has lasted for many months and it is critical that we be able to 
> restart our CF servers without messing with this problem.
>
> Any suggestions?
>
> Thanks,
> Ryan
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253617
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Could not perform Web service invocation

[Ryan Duckworth]

Terrence,

Thank you very much.  I think this will solve the problem.  I really
appreciate it.

Just a comment though: Shouldn't this "refreshWebService" function be
called from within ColdFusion's createObject function of type
'webservice'.  Why should we have to do this everywhere we make a web
service call when ColdFusion should not flush the stub component from
memory and then blow up.

I think this is a true ColdFusion bug that should have a hot fix.

Ryan

On 9/11/06, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
> Have you tried resetting the webservice in the factory before making a call 
> to it. Basically it causes the stub object to be re-written (as far as I can 
> remember.)
>
> http://www.achex.com/ws/Authorization.wsdl"; />
>  "coldfusion.server.ServiceFactory").XmlRpcService.refreshWebService(wsdl) />
>
> I just wrap every delicate webservice call I make in a try/catch block, and 
> then reset it in case of an error and rerun. It eliminates a lot of the 
> problems I've had with calling webservices.
>
> Terrence Ryan
> Senior Systems Programmer
> Wharton Computing and Information Technology
> E-mail: [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Ryan Duckworth [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 11, 2006 10:30 AM
> To: CF-Talk
> Subject: Could not perform Web service invocation
>
> I recently integrated with TeleCheck to accept eChecks on our sites.
> Everything seems to work perfectly except for ColdFusion's ability to 
> generate and hold onto the stub code for the webservice.
>
> The worst kind of problem too... it is intermittent with no obvious pattern.
>
> The WSDL files look good.  TeleCheck web service calls will work great, but 
> after we restart a server SOMETIMES we receive the "Could not perform web 
> service invocation" error.
>
> Test Server:
> http://test.achex.com/ws/Authorization.wsdl
>
> Production Server:
> http://www.achex.com/ws/Authorization.wsdl
>
> I have tried to search forums for a possible solution, but can't seem to get 
> it to work.
>
> Personally, I believe this is a bug with ColdFusion.  Some forums have 
> mentioned that ColdFusion does not handle complex web service types very 
> well.  However, TeleCheck wrote the web service and I can not change their 
> data types.
>
> I have also read that ColdFusion "flushes" the stub objects from memory.  We 
> have installed Cumulative Hot Fix 7.0.2 which stated that it solved some web 
> service flushing problems.
>
> The only way we have been able to somewhat solve this problem temporarily is 
> to delete everything in the \CFusionMX7\stubs before restarting ColdFusion.  
> This solution is not acceptable for our production environment and I would 
> like a true solution to this problem.
>
> This problem has lasted for many months and it is critical that we be able to 
> restart our CF servers without messing with this problem.
>
> Any suggestions?
>
> Thanks,
> Ryan
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252736
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Hosting companies

[Ryan Duckworth]

Which of these hosts offer remote desktop access?

On 9/9/06, B V <[EMAIL PROTECTED]> wrote:
> Like many others, I enjoy HostMySite... I have never had a more dedicated
> host, and pricing is good. They support MySql as Well as MSSQL, I believe on
> the same plan. I am in DC2, and I can tell you that despite what you've
> heard from DC1, DC2's uptime is almost 100%. But then again, everyone likes
> who they have, and that's just my opinion.
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252726
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Could not perform Web service invocation

[Ryan Duckworth]

I recently integrated with TeleCheck to accept eChecks on our sites.
Everything seems to work perfectly except for ColdFusion's ability to
generate and hold onto the stub code for the webservice.

The worst kind of problem too... it is intermittent with no obvious pattern.

The WSDL files look good.  TeleCheck web service calls will work
great, but after we restart a server SOMETIMES we receive the "Could
not perform web service invocation" error.

Test Server:
http://test.achex.com/ws/Authorization.wsdl

Production Server:
http://www.achex.com/ws/Authorization.wsdl

I have tried to search forums for a possible solution, but can't seem
to get it to work.

Personally, I believe this is a bug with ColdFusion.  Some forums have
mentioned that ColdFusion does not handle complex web service types
very well.  However, TeleCheck wrote the web service and I can not
change their data types.

I have also read that ColdFusion "flushes" the stub objects from
memory.  We have installed Cumulative Hot Fix 7.0.2 which stated that
it solved some web service flushing problems.

The only way we have been able to somewhat solve this problem
temporarily is to delete everything in the \CFusionMX7\stubs before
restarting ColdFusion.  This solution is not acceptable for our
production environment and I would like a true solution to this
problem.

This problem has lasted for many months and it is critical that we be
able to restart our CF servers without messing with this problem.

Any suggestions?

Thanks,
Ryan

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252723
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Subclipse... Subversion and Eclipse Integration Help

[Ryan Duckworth]

I am still having problems getting subclipse setup.

I have successfully added the new repository location and can view the
files under the "SVN Repository" perspective.

If I am under the "Navigator" tab I can view my project with the files
from the repository.

The problem that I am having is if I click on any of those files it
opens up, but if I type anything "Lock" displays and asks for a
comment.  After that I can not edit the file at all.  It just ignores
everything I type.

What am I doing wrong?  When I added the new project I tried New
project and selected "SVN", "Checkout Projects from SVN".  Then I
chose "Use Existing Repository Location" and selected a folder.

After removing and adding the project back several times I was able to
edit the file.  Now when I try to make changes and commit I get an
error:

"org.tigris.subversion.javahl.ClientException: RA layer request failed
svn: Commit failed (details follow):
svn: PUT of
'/svn/project1/!svn/wrk/[guid]/com/Person.cfc': 432 Locked
(http://127.0.0.1)

Should I just start over and create a new repository?

Please help.  Thanks,
Ryan


On 7/27/06, Angus Johnson <[EMAIL PROTECTED]> wrote:
> ->Add a new CVS Repository
>
> I think you are trying to add the repository using cvs. If you have the
> Subclipse plugin properly installed you should change perspective to SVN
> Repository Exploring and then create a new location. Should be
> straightforward from there.
>
> Let us know how you go.
>
> Angus
>
> On 28/07/06, Ryan Duckworth <[EMAIL PROTECTED]> wrote:
> >
> > After attending CFUnited we decided to investigate using Subversion
> > Source Control for our ColdFusion applications.
> >
> > I have Subversion up and running along with TortoiseSVN.  I have
> > successfully setup a repository and checked out a local working copy
> > from the repository.  I can also make changes and commit those back to
> > the repository.
> >
> > I am running Apache2 with the DAV svn settings in my httpd.conf file.
> >
> > Everything is working perfectly except integrating with Eclipse.
> >
> > I cannot get the "Add a new CVS Repository" to work.
> >
> > I can successfully navigate my Repository by viewing it in a browser
> > here: http://127.0.0.1/svn/project1/
> > I then enter my user and password and it works great.
> >
> >
> > Settings I am trying:
> >
> > Host: 127.0.0.1
> > Repository Path: svn/project1
> > I have also tried svnroot/project1
> >
> > My apache httpd.conf file specifies: 
> > My path to the repository is C:\svnroot\project1
> >
> > Same user and password I use when navigating to
> > http://127.0.0.1/svn/project1/
> >
> > Connection Type:  I have tried all 3: pserver, ext, extssh
> > Default port
> >
> > Every time I get this error:
> >
> > Error validating location: "Could not connect to
> > :ext:[EMAIL PROTECTED]:svn/project1: I/O exception occurred:
> > CreateProcess: ssh 127.0.0.1 -| rduckworth cvs server error=2"
> > Keep location anyway?  Yes/No
> >
> >
> > Please help!
> > Ryan
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248045
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Subclipse... Subversion and Eclipse Integration Help

[Ryan Duckworth]

After attending CFUnited we decided to investigate using Subversion
Source Control for our ColdFusion applications.

I have Subversion up and running along with TortoiseSVN.  I have
successfully setup a repository and checked out a local working copy
from the repository.  I can also make changes and commit those back to
the repository.

I am running Apache2 with the DAV svn settings in my httpd.conf file.

Everything is working perfectly except integrating with Eclipse.

I cannot get the "Add a new CVS Repository" to work.

I can successfully navigate my Repository by viewing it in a browser
here: http://127.0.0.1/svn/project1/
I then enter my user and password and it works great.


Settings I am trying:

Host: 127.0.0.1
Repository Path: svn/project1
I have also tried svnroot/project1

My apache httpd.conf file specifies: 
My path to the repository is C:\svnroot\project1

Same user and password I use when navigating to http://127.0.0.1/svn/project1/

Connection Type:  I have tried all 3: pserver, ext, extssh
Default port

Every time I get this error:

Error validating location: "Could not connect to
:ext:[EMAIL PROTECTED]:svn/project1: I/O exception occurred:
CreateProcess: ssh 127.0.0.1 -| rduckworth cvs server error=2"
Keep location anyway?  Yes/No


Please help!
Ryan

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247954
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

GUID in binary format

[Ryan Duckworth]

I am tying to setup a laptop with ColdFusion and SQL Server 2000
personal edition.

The datasources are setup in the CF Admin as an ODBC Socket
The problem is that all GUID's are returning in a query as binary.

Please help!


It must be SQL Server personal edition b/c it is Win 2k Professional
and SQL Server Standard and Enterprise won't install.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242159
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Catching bogus credit card numbers

[Ryan Duckworth]

We authorize the transaction at the time the order is placed using a
service called Authorize.net

http://www.authorize.net/

This would solve your problem b/c those transactions would be rejected
and the user would receive an "Invalid credit card number" error
message.

On 4/17/06, Mosh Teitelbaum <[EMAIL PROTECTED]> wrote:
> All:
>
> Does anyone have or know of a list of bogus credit card numbers that pass
> the LUHN test?  Specifically, I'm looking for a list of "test" credit card
> numbers that are never actually associated with a valid credit card but are
> often used when testing new credit card services.  For example,
> "5105105105105100" for MasterCard.
>
> A client has been receiving online orders using the above credit card number
> and would like to have these bogus orders removed automatically.
>
> TIA
>
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 942-5378
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237923
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

ColdFusion Cumulative HotFix List

[Ryan Duckworth]

Is there a way to be on a list with Adobe to be alerted when
Cumulative Hot Fixes are released?  We were having problems w/ web
services and started searching and noticed that ColdFusion MX 7.0.1
Cumulative Hot Fix 2 was released on March 2nd.  This Hot Fix solved
our problem, but we would rather have our sysadmins on this list to be
notified automatically.

Thanks,
Ryan

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237907
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Ability to kill requests and threads

[Ryan Duckworth]

I read about this new product on www.forta.com and thought I would
check it out.  I installed it on our development server and was able
to kill running requests and threads.  I thought this could be useful,
instead of restarting the whole CF service.  It also shows the memory
usage and has some server alerts.

The site I downloaded it from: http://www.fusion-reactor.com/


Has anyone else played with this tool?  Are there any other tools out
there that do the same thing for CF?

Forta blog:
http://www.forta.com/blog/index.cfm/2005/12/2/Check-Out-FusionReactor

Thanks,
Ryan

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226553
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfscript Common Functions and Best Practices

[Ryan Duckworth]

Currently we have many functions that we use within cfscript.  We are
storing them in the request scope (see 2 examples below).


Here is what I am don't like about this approach:  Every page hit from
every user is loading these common functions.  I personally am not
convinced that the request scope is the best place for these types of
functions.  I'm sure that many of you out there use functions of your
own and from www.cflib.org.  Is the server scope a better place for
these?  Should we only reload the functions if they are not already
defined in the server scope?

Thanks,
Ryan












request.abort = abort;
request.sleep = sleep;



Call from within cfscript tag:
request.sleep(3000);
request.abort();

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

java.awt.Robot Integration using createObject

[Ryan Duckworth]

I am getting a very strange result when I try to run some java screen
capture code from coldfusion.  When I simply run the .java file (#2
below)  I get a great .png screen shot stored here:
c:\screenshotFromJava.png

However, when I run the .cfm page (#1 below) using createObject I get
the same size .png file that is completely black.

To test this, compile the .java file below and place the .jar file in
the lib directory, then restart the cf service.

1.  ColdFusion page that calls the JAR
_

objMouse = createObject('java','robotScreenShot').init();
objMouse.screenShot("screenshotFromCF.png");


Screen shot created here: c:\screenshotFromCF.png
_

2.  .java file

import java.awt.Robot;
import java.awt.AWTException;
import java.awt.Rectangle;
import java.awt.Toolkit;
import java.awt.Dimension;
import java.awt.image.BufferedImage;
import javax.imageio.ImageIO;
import java.io.File;
import java.io.IOException;

public class robotScreenShot {

public static void main(String[] args)
throws AWTException{
screenShot("screenshotFromJava.png");
}

public static void screenShot(String pngFileName)
throws AWTException{
  try {
  Robot r = new Robot();
  String pngPath = "c:\\" + pngFileName;
  Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
  Rectangle rect = new Rectangle(0, 0, screenSize.width, screenSize.height);
  BufferedImage img = r.createScreenCapture(rect);
  ImageIO.write(img, "png", new File(pngPath));

  } catch (AWTException e) {
  System.err.println(e);
  } catch (IOException e) {
  System.err.println(e);
  }
}
}

I would really appreciate any help.  Thanks,

Ryan Duckworth
913.486.2611

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225164
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Could not unlock the named lock

[Ryan Duckworth]

Has anyone seen an error similar to this before?

Could not unlock the named lock 623068599CLIENTSCOPESERVICE because no
lock is known by that name.

CF7, Win 2003 Server

Thanks,

Ryan Duckworth
Macromedia ColdFusion Certified Professional

Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221529
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Faulting application jrun.exe faulting module jvm.dll .... what????????

[Ryan Duckworth]

We are having this problem on a Win 2003 Web Edition box running CF MX
6.1 updater 1 + hot fixes.  It will simply post this message to the
Application log and restart itself once every few days.  Anyone else
solve this problem or have any insights?

Error Message:
Faulting application jrun.exe, version 4.0.3.10455, faulting module
jvm.dll, version 0.0.0.0, fault address 0x0017353f.

Note: This box has a fresh install of everything by our SysAdmin
including OS and CF.
 
Log Entry:

Event Type:  Error
Event Source:   Application Error
Event Category:(100)
Event ID:  1000
Date:8/10/2005
Time:3:01:41 PM
User:N/A
Computer: WEBSTAGING
Description:

Application Failure  jrun.exe 4.0.3.10455 in jvm.dll 0.0.0.0 at 0040:
6f 66 66 73 65 74 20 30   offset 0017353f


Data:
: 41 70 70 6c 69 63 61 74   
0008: 69 6f 6e 20 46 61 69 6c   
0010: 75 72 65 20 20 6a 72 75   
0018: 6e 2e 65 78 65 20 34 2e   
0020: 30 2e 33 2e 31 30 34 35   
0028: 35 20 69 6e 20 6a 76 6d   
0030: 2e 64 6c 6c 20 30 2e 30   
0038: 2e 30 2e 30 20 61 74 20   
0048: 30 31 37 33 35 33 66  

Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214659
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Expected = instead of <(0x3C)

[Ryan Duckworth]

Daniel, Your data is bad.  I just ran the code that I posted below on
CF 6.1 & 7.

I just put some junk data (all numeric) in a test query and it graphs perfectly.

Send me this: I guarantee you have some non-numberic values in your query!!!


select * from QAnswerExp






Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272
































> > On 5/18/05, Daniel Kang <[EMAIL PROTECTED]> wrote:
> > > When I run cfcharts, I am getting the error below.   Please let me
> > > know how to debug this.
> > >
> > > tia
> > >
> > >
> > > Expected = instead of <(0x3C) In line:1 position:75. Stack:<6>
> > >  The error occurred in
> > > D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm: line 166
> > >
> > > 164 :   markerStyle = "diamond"
> > > 165 :   serieslabel="3 to 7 yrs"
> > > 166 :   paintStyle="raise">
> > > 167 : 
> > >
> > > Stack Trace at 
> > > cfStatChartQ212ecfm288395228.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm:166)
> > > at 
> > > cfStatChart2ecfm1445877973.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChart.cfm:101)
> > > java.lang.RuntimeException: Expected = instead of <(0x3C)
> > > In line:1 position:75. Stack:<6>
> > >at 
> > > com.gp.webcharts3D.xml.ExXmlParser.throwParseException(ExXmlParser.java)
> > >at com.gp.webcharts3D.xml.ExXmlParser.unexpected

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207158
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Expected = instead of <(0x3C)

[Ryan Duckworth]

Can you please post your entire cfchart tag.

Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272


On 5/18/05, Daniel Kang <[EMAIL PROTECTED]> wrote:
> When I run cfcharts, I am getting the error below.   Please let me
> know how to debug this.
> 
> tia
> 
> 
> Expected = instead of <(0x3C) In line:1 position:75. Stack:<6>
>  The error occurred in
> D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm: line 166
> 
> 164 :   markerStyle = "diamond"
> 165 :   serieslabel="3 to 7 yrs"
> 166 :   paintStyle="raise">
> 167 : 
> 
> Stack Trace at 
> cfStatChartQ212ecfm288395228.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm:166)
> at 
> cfStatChart2ecfm1445877973.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChart.cfm:101)
> java.lang.RuntimeException: Expected = instead of <(0x3C)
> In line:1 position:75. Stack:<6>
>at 
> com.gp.webcharts3D.xml.ExXmlParser.throwParseException(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlParser.unexpected(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlParser.unexpected(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlParser.nextAttr(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlParser.parseXmlToken(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlParser.parseToken(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlParser.parse(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlParser.build(ExXmlParser.java)
>at com.gp.webcharts3D.xml.ExXmlDocument.parse(ExXmlDocument.java)
>at com.gp.webcharts3D.xml.ExXmlDocument.parse(ExXmlDocument.java)
>at com.gp.webcharts3D.model.ExContents.setXmlContents(ExContents.java)
>at com.gp.webcharts3D.model.ExContents.(ExContents.java)
>at com.gp.webcharts3D.ChartApplet.setXmlContents(ChartApplet.java)
>at com.gp.image.server.IcDescription.setProperties(IcDescription.java)
>at com.gp.image.server.IcChartPool.pop(IcChartPool.java)
>at com.gp.image.server.IcImageServer.popChart(IcImageServer.java)
>at com.gp.image.server.cache.IcFileImage.(IcFileImage.java)
>at com.gp.image.server.IcImageServer.__newImage(IcImageServer.java)
>at com.gp.image.server.IcImageServer._newImage(IcImageServer.java)
>at com.gp.image.server.IcImageServer.newImage(IcImageServer.java)
>at com.gp.image.server.IcImageCache.getImage(IcImageCache.java)
>at com.gp.image.server.IcImageServer.getImage(IcImageServer.java)
>at com.gp.image.ExServerComponent.getImageTag(ExServerComponent.java)
>at 
> coldfusion.graph.GraphingServiceImpl$2.run(GraphingServiceImpl.java:319)
>at java.security.AccessController.doPrivileged(Native Method)
>at 
> coldfusion.graph.GraphingServiceImpl.generateGraph(GraphingServiceImpl.java:314)
>at coldfusion.tagext.io.ChartTag.doEndTag(ChartTag.java:428)
>at 
> cfStatChartQ212ecfm288395228.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm:166)
>at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
>at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
>at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
>at 
> cfStatChart2ecfm1445877973.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChart.cfm:101)
>at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
>at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
>at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
>at 
> coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
>at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
>at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
>at 
> coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
>at 
> coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
>at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
>at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
>at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
>at coldfusion.CfmServlet.service(CfmServlet.java:105)
>at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
>at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
>at 
> jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
>at 
> jrun.servlet.ServletEngineService.dispatch(ServletEngineSer

RE: Strange data mangling

[Ryan Duckworth]

This document explains the issue and solution:
https://www.uwex.edu/oraprod/cfquery.pdf


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 26, 2005 2:06 PM
To: CF-Talk
Subject: Strange data mangling

Can any one see why the following line of code would mangle a value such as 
"02" into "3LÀ002"?

TRAN_CODE = ,

I've tested the value just before this query and at that point it is correct 
and intact.  But once the query runs a seemingly random 3 char value is 
pre-pended to the value that is supposed to be inserted.

CF 6.1
Oracle 8i
Oracle Thin Client

If any of those matter.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204519
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Invalid method signature Error

[Ryan Duckworth]

Anyone seen this error before?

cferror.Diagnostics:

Invalid method signature: (Ljava/lang/Object;)V null

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203874
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Site (not Server) - wide Error Handler

[Ryan Duckworth]

In Application.cfm:




In errorHandler.cfm:


ERROR


CGI


FORM



SESSION







A possible error has been detected and reported to
the administrator.



Note: you need both the Exception and Request... The Request will catch
things the exception does not.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

  - Original Message - 
  From: Adkins, Randy 
  To: CF-Talk 
  Sent: Wednesday, April 20, 2005 6:28 PM
  Subject: Site (not Server) - wide Error Handler


  What's the best approach to using a site-wide (not server-wide)
  error handler as apposed to wrapping each piece with a CFTRY?
   
  An initial thought is some type of CFTRY statement within the
  Application tag, but wanted other opinions and approaches.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203683
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: macromedia and Adobe?!

[Ryan Duckworth]

I think that most ColdFusion programmers / managers are overreacting to this 
announcement.  

The programmers of CF 7 (BlackStone) are not likely to be let go because of 
this.

Let's suppose that I was a manager at Adobe, I would see ColdFusion as a great 
revenue stream, and I would want to retain those programmers and project 
managers that have grown the subscriber base.

I think we as a community would be best off to be optimistic about this because 
the individuals who built CF 6 & 7 are likely to still be in charge of future 
releases.

In addition, I think it would be in the best interest of Adobe to keep major 
players such as Ben Forta and many others actively involved in the CF community 
& releases.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Keith Gaughan [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 18, 2005 10:46 AM
To: CF-Talk
Subject: Re: macromedia and Adobe?!

Adam Haskell wrote:

>>The delays of PDF are not format related. They are software program
>>related. It is the set of extensions in Acrobat which makes PDF look
>>like a fat pig. The PDF format has potential, but lacks good software
>>for mobile devices.
> 
> 
> The rendering software is huge bulky and slow b/c of the PDF format. A
> PDF docuemnt contain nothing, but XML. This forces everything to be in
> the reader which cuases it to be a pig... Could the reader be
> re-written in a more streamline fashion and still provide all the
> functionality..maybe..time will tell.

Dude! XML? Far from it. The stuff you see when you open a PDF in a text
editor is a combination of commands for a stack-based virtual machine
(à la PostScript), and a bunch of compressed datastreams.

There's absolutely no reason whatsoever that PDFs can't be opened
quickly, even on small machines. There's much faster software for
reading PDFs out there than Acrobat Reader.

K.



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203285
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Help! brain dead?!

[Ryan Duckworth]

You probably have a query w/ the same name as the function.
This link will explain:
http://jehiah.com/archive/entity-has-incorrect-type
Good luck.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 11, 2005 2:09 PM
To: CF-Talk
Subject: Re: Help! brain dead?!

Well. its back to private and still no dice! aargh!

I shall have another look.. code blindness

MD

On Apr 11, 2005 8:12 PM, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Hmm.. its set as public .. would that do the trick?
> 
> No, public functions can be called by any other code.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
> 
> 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202244
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfqueryparam caching data

[Ryan Duckworth]

Here is how to fix your problem:

1.  Login to your CF Admin
2.  Go to the Data Source in question.
3.  Change "Max Pooled Statements" to 0.

We had this exact same problem when adding or removing columns to a DB
Table.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 25, 2005 3:16 PM
To: CF-Talk
Subject: RE: cfqueryparam caching data

> I have a query that returns one row from the DB which uses 
> cfqueryparam. I'd heard about a problem with caching so after 
> a puzzling 30 seconds asking myself where my new column had 
> gone I thought I'd remove the cfqp which worked. Now when I 
> put it back in I still get the cached data.
> 
> So the question is, how do I clear this cached data? I don't 
> want to restart anything but I don't mind running a SQL 
> statement. It's SQL Server 2K. So something like DBCC 
> FREEPROCCACHE but for statement.

I'm not sure it's the CFQUERYPARAM which is causing the problem.
Conceivably, you could have the same problem if you had a hardcoded
value in
your SQL, if your datasource is configured to generate prepared
statements,
and you might see the problem go away if you added a CFQUERYPARAM! If
you
add a column, and use "SELECT *", and the prepared statement is cached
on
the database server, your query often won't include the new column.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200057
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Combininig Datasources in 1 CFQUERY

[Ryan Duckworth]

Sounds like a mess!

1.  You could convert everything to SQL, then just export to Access when
you need to if you are simply reporting from Access.  Just a note,
access uses flat files and is much more inefficient compared to SQL
Server 2K.  I would highly recommend converting everything to SQL
Server.

2.  If this is not an option, then I think your only option is to use
query of queries.  Select the data you need from the Access table, then
select the data from the SQL table.  By using Query of Queries you could
get the data you need.
NOTE: QoQ does not support joins, so you are going to have to use a
"where" clause to get the data that you need.


SELECT ...



SELECT ...



SELECT ...
FROM qrySQL2K WHERE qrySQL2K.UserID = qryAccess.UserID


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Friday, March 25, 2005 7:42 AM
To: CF-Talk
Subject: Combininig Datasources in 1 CFQUERY

Hello,

Some of our Access tables are being moved to our SQL Server, while some
remain in Access.
I have two datasources that separate the SQL from Access.  However, I
run into some code
where tables from each of the datasources are in one CFQUERY within a
join.

Can I indicate multiple datasources within one CFQUERY?  If not what can
I do without having
to rewrite the SQL join?

Thanks

D


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199952
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

JSESSIONID - Help

[Ryan Duckworth]

In CF (6.1 - updater) we have "Use J2EE session variables" unchecked in
the CF Admin, but we are getting users who are getting JSESSIONID in
their cookies.

Check this out:

They are maintaining their session just fine, w/ this cookie
CFID=1259949;+CFTOKEN=67d6fb316d575646-A32F7B81-C388-E91F-C4B608E1B9949C
63

Then they get the JSESSIONID on the end, and they lose their session: 
CFID=1259949;+CFTOKEN=67d6fb316d575646-A32F7B81-C388-E91F-C4B608E1B9949C
63;+JSESSIONID=3030637c6aa5$F8E$8Ba

Has anyone seen this before?  This is happening on a number of different
pages and we really need our customers to not lose their sessions.
Please help.

Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199333
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Customers losing their session information - Help!!!!!!!

[Ryan Duckworth]

I think our sysAdmin figured it out.  They published a GPO (Group Policy
Object) with some crazy security settings.  Once they revoked the GPO,
they were able to use our site perfectly like everyone else.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Robert Redpath [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 04, 2005 10:08 AM
To: CF-Talk
Subject: RE: Spam:RE: Customers losing their session information -
Help!!!

I've had users with this problem and a few were using IE on a Mac, but
to make it weird others were using IE on Win98 - none were AOL users.



From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Fri 3/4/2005 10:52 AM
To: CF-Talk
Subject: Spam:RE: Customers losing their session information -
Help!!!



> From: Ryan Duckworth [mailto:[EMAIL PROTECTED]
> We have this problem with some customers who lose their
> session information.
>
> The strange part is that the CGI.HTTP_COOKIE variable has this info:
>
> CGI.HTTP_COOKIE =
> CFID=649959; CFTOKEN=81997144; JSESSIONID=30308be659fa$9B$E4P$ 
>
> Have any of you seen something like this before?  We have
> thousands of other customers that have no problem at all, but
> this one group of customers has this problem consistently.
>
> Has anyone encountered something like this?  It appears to be
> a select group of customers.  Have they changed their
> security settings in a certain way that we can detect?  Do
> they have some anti-spam-spy-ware software running?
>
> Please help!!!  Running CF 6.1 w/ all updates.

Do you know what browser they are using? Are they AOL users?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197457
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Customers losing their session information - Help!!!!!!!

[Ryan Duckworth]

No, they are not AOL users.  We use a product called BrowserHawk to
collect all of their data, so we know a lot about them:

OS: WinXP
Browser:IE 6.0
JS: 1.3
Acrobat:6
Flash:  6.4
MSN:NO
AOL:NO
Gecko:  NO
Cookies:YES
Resolve IP: rrcs-24-173-19-53.sw.bix.rr.com
Connection: LAN
Browser Size:   590 x 1004
DHTML   YES
Applets YES


We also know that they are not behind a proxy b/c our SysAdmin has been
in contact w/ them.

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 04, 2005 9:52 AM
To: CF-Talk
Subject: RE: Customers losing their session information - Help!!!

> From: Ryan Duckworth [mailto:[EMAIL PROTECTED] 
> We have this problem with some customers who lose their 
> session information.
> 
> The strange part is that the CGI.HTTP_COOKIE variable has this info:
> 
> CGI.HTTP_COOKIE =
> CFID=649959; CFTOKEN=81997144; JSESSIONID=30308be659fa$9B$E4P$  
> 
> Have any of you seen something like this before?  We have 
> thousands of other customers that have no problem at all, but 
> this one group of customers has this problem consistently.
> 
> Has anyone encountered something like this?  It appears to be 
> a select group of customers.  Have they changed their 
> security settings in a certain way that we can detect?  Do 
> they have some anti-spam-spy-ware software running?
> 
> Please help!!!  Running CF 6.1 w/ all updates.

Do you know what browser they are using? Are they AOL users?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197451
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Customers losing their session information - Help!!!!!!!

[Ryan Duckworth]

We have this problem with some customers who lose their session
information.

The strange part is that the CGI.HTTP_COOKIE variable has this info:

CGI.HTTP_COOKIE =
CFID=649959; CFTOKEN=81997144; JSESSIONID=30308be659fa$9B$E4P$  

Have any of you seen something like this before?  We have thousands of
other customers that have no problem at all, but this one group of
customers has this problem consistently.

Has anyone encountered something like this?  It appears to be a select
group of customers.  Have they changed their security settings in a
certain way that we can detect?  Do they have some anti-spam-spy-ware
software running?

Please help!!!  Running CF 6.1 w/ all updates.

Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197447
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Not requiring cookies

[Ryan Duckworth]

I am building an application where we do not want to require the user's
browser to accept cookies.  Like most applications out there we use the
session scope very heavily and want to continue to utilize it.

I have read the CFMX WACK Ben Forta book about this task and it
recommends passing one of these variables:
1. session.URLToken
Or 
2. client.URLToken

(this ensures the CFID, CFTOKEN, or JSESSIONID are available.)

Has anyone done this before?  What is the "best way" to accomplish this?

The application is almost complete and I am not currently passing
session.URLToken and am not sure what other people have done to
accomplish this in an effective and easy to implement way.


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195742
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: "null null The error occurred on line -1."

[Ryan Duckworth]

Setting Max Pooled Statements is a very good change b/c it solves other
problems too.  If you make a change to your DB and are using SQL Server
2K and it's driver, you will get errors if you change a tables structure
w/out resetting the data source in the CF Admin.

By setting the Max Pooled Statements to 0, you don't have to reset the
data source.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Bert Dawson [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 07, 2005 9:47 AM
To: CF-Talk
Subject: Re: "null null The error occurred on line -1."

We used to be plagued with null null errors, followed by server
hanging or restarting every hour during busy periods.
We "fixed" it by setting "Max Pooled Statements" on the advanced dsn
page in cfadmin to zero.
MM are still trying to figure out why we were getting this, so i
suppose its unlikely to be the same problem.
But its worth a try.
(preferably before embarking on weeks of tweaking around with various
java settings, garbage collection, trawling through a "5 years in the
making" codebase looking for problems)

Cheers
Bert

On Mon, 7 Feb 2005 09:26:24 -0500, Gaulin, Mark <[EMAIL PROTECTED]>
wrote:
> Anybody know what this error (reporting by error.Diagnostics) means?
> 
> null null
> The error occurred on line -1.
> 
> We got a four of them before a CFMX server stopped responding, but
they were spread out over a few minutes.  I don't know if it is directly
related to the seize up or not, but it sure looks funny.
> 
> Thanks
> Mark


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193367
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: email add verification (loose)

[Ryan Duckworth]

This is the regEx function that I use.  You may want to add more/remove
the suffix part.  






Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 01, 2005 3:36 PM
To: CF-Talk
Subject: email add verification (loose)

I have a user-populated DB with email addresses in it.  I am making a 
script to loop over a query and mail to those email addresses, but
wanted 
to know if there is a CF solution to loosely check an email address to
see 
if it is syntactically correct.  If it is, then I want to just send the 
email and move on to the next email address.  If it isn't, then I'd like
to 
not send the email, and move on to the next address.

I am using cftry and cfcatch right now, but the script will crap out if
I 
find a 'bad' email address.  I'd like it to handle the bad addresses 
gracefully.

I know that there are ways to do this using javascript, but I'd like to 
avoid the hassle of trying to integrate server side and client side
scripts.

Thanks!

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.
Thank you.





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192673
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Replacing variable text in a string

[Ryan Duckworth]

This works and is tested:

  
yourString = "set primary_assign_id = 123";



#REReplaceNoCase(yourString,"set primary_assign_id =
[[:digit:]]{3}","","ALL")#


Good luck.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 01, 2005 2:43 PM
To: CF-Talk
Subject: Re: Replacing variable text in a string

Hey Scott,

This is not working for me.  I corrected the typo from Palace to place
but
it is not working.  Any Ideas?

Thanks

Mike
- Original Message -
From: "Scott Stroz" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, February 01, 2005 2:04 PM
Subject: Re: Replacing variable text in a string


> RERepalce(yourString,"set primary_assign_id = [:digit:]{3}","","all")
>
> Should work, but has not been tested.
>
>
> On Tue, 1 Feb 2005 12:57:51 -0500, Mickael <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I would like replace a portion of a string that is a SQL statement
generated by my users via an interface that I have created.  I have
never
used Regular Expressions but from what I have heard about this task
sounds
like a candidate.
> >
> > I would like to update a SQL statement that is generated by my users
there is a portion of the string that says "set primary_assign_id = 123"
that I would like to remove the problem is that I am not sure what the
number is but I know that it always three numbers.
> >
> > How can I do this?
> >
> > Regards,
> >
> > Mike
> >
> >
>
> 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192655
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF Allows Negative Zero?

[Ryan Duckworth]

This function will solve your problem:  JavaCast('float',variableName)


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 05, 2005 11:12 AM
To: CF-Talk
Subject: Re: CF Allows Negative Zero?

Can you owe nothing? how about if I give you nothing is that +0?

hmmm.. abstract


On Wed, 5 Jan 2005 10:44:40 -0600, Dawson, Michael <[EMAIL PROTECTED]>
wrote:
> If you enter a negative zero (-0), CF keeps it as is and does not
strip
> the negative sign.
> 
> I would assume that is because CF may think this is a string, however,
> it passes the IsNumeric() function.
> 
> Should I just use the val() in my setter when I expect a numeric value
> to be passed?
> 
> Thanks
> M!ke
> 
> 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189434
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: QofQ: SELECT DISTINCT

[Ryan Duckworth]

I'm not sure if this will meet your specific needs, but... I have found
this function from CFLIB helpful:

http://www.cflib.org/udf.cfm?ID=758

QueryDeDupe(theQuery, keyColumn)

I would be very interested to see what the timing differences are!!!
Please post to the list or let me know directly.
Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Andrew Dixon [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 30, 2004 3:05 PM
To: CF-Talk
Subject: QofQ: SELECT DISTINCT

Hi All.

I have some code that does a SELECT DISTINCT on a QofQ and it is
really slow. For example, I have a dataset with about 150 records and
the SELECT DISINCT is taking anything from 2 - 5 seconds to excute.

Any ideas why and how to improve it?

Andrew.



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189028
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: breaking a line of code to two lines

[Ryan Duckworth]

Can't you just set the array up like this?








You also could use a key, value pair... such as just putting "1" in the
radio button then using a lookup for the array.  Passing the whole
string from the radio button does not seem necessary or practical in
this instance.  Good luck!


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272


-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 21, 2004 2:57 PM
To: CF-Talk
Subject: breaking a line of code to two lines

I need to break a line of code onto a second line while keeping it as 
a line of code.  I have the following array and when I use the value 
"Jerry Wrenn Scholarship" as a value in a radio button, when I 
retrieve the value from the db, it doesn't match the original value 
in an CFIF statement.  When I make it all on on line, the CFIF works 
fine.  How do I do this sort of soft-return?

http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188470
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: FEDEx tracking

[Ryan Duckworth]

FedEx has it's own API which you can interface with to track shipments
and create custom labels.  This may be more functionality than you need.

http://www.fedex.com/us/solutions/shipapi/faq.html?link=4


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 21, 2004 9:06 AM
To: CF-Talk
Subject: FEDEx tracking

A while ago somebody was talking about the fedex tracking shipments and
show the status in the custom application in coldfusion.

I am working on a project where I need to track the shipment and update
the status in local database.

I was googling from the last two days and couldn't find anything yet.

Can someone point me to the right direction?

Thanks



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188375
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Picky delete statement?

[Ryan Duckworth]

You can remove a column, not just set it to NULL.

Use the ALTER TABLE statement. Syntax:

ALTER TABLE [table]
DROP COLUMN [columnlist]

INSERT, DELETE, UPDATE are all built to change specific records.  ALTER
TABLE changes the structure of your table.

Good luck.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272


-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 09, 2004 6:30 PM
To: CF-Talk
Subject: Re: Picky delete statement?

Thats right. if you want to delete the columns of a record you have to
update the record and set the columns to null or to whatever the
default defined by the database

e.g.
Update mytable
Set col1 = null
, col2 = null 
Where id = 

Hope that helps

Regards
Mark Drew



On Thu, 9 Dec 2004 18:44:53 -0500, Phillip Perry
<[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I've read my sql book but I cant find what i'm looking for. According
to the
> book (as far as my understanding is) you cant specify which columns to
> delete, you can only delete the whole record. Is this true?
> 
> Phil
> 
> 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186981
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: How do I rewrite this as a join query?

[Ryan Duckworth]

Without subqueries, I think it is easiest just to use CF's Query of
Queries.
This is close to what you need:

The trick is the last query It uses both queries to filter the
results.


SELECT S.EmailAddress 
FROM staff S



SELECT CAL.EmailAddress
FROM classroom_access_list CAL



SELECT * 
FROM allEmail OUTER JOIN excludeStaffEmail
WHERE allEmail.EmailAddress != excludeStaffEmail.EmailAddress


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 17, 2004 8:25 AM
To: CF-Talk
Subject: How do I rewrite this as a join query?

Good morning, all...

I'm using MySQL (4.0) version, which doesn't support
subqueries, so I need to rewrite this as a join query...how would I do
that?

Select CAL.EmailAddress
   from classroom_access_list CAL
where CAL.EmailAddress
 not in (Select S.EmailAddress from staff S)

What I'm after is a query that gives me all the email addresses in the
classroom_access_list table and the staff table without duplicates...

I've been working on the join approach, but those things just
elude my logic for some reason...can't wait until I'm ready to move to
MySQL 4.1, which supports subqueries...

Thanks,

Rick
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.290 / Virus Database: 265.3.1 - Release Date: 11/15/2004




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184582
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CC Gateway question

[Ryan Duckworth]

2 possible solutions:

1. With authorize.net you can validate just the 5 digit zip code.  That
way, even if they mistype part of the address, it still gets authorized
and goes through.

2.  Use an address validation software to correct the address before it
is sent to authorize.net.  This is the approach that we took.  We used
ZP4/DPV (http://www.semaphorecorp.com/cgi/zp4.html) which costs $150
every 2 months and runs on our servers so we were able to scrub all of
our current addresses and validate all new incoming addresses.

Good luck!

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211 
(913) 754-4272

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 09, 2004 7:59 PM
To: CF-Talk
Subject: Re: CC Gateway question

As I understand it, once an Authorisation number has been issued
against your card, it remains until it either times out in 10-14 days
or until the transaction is completed and the merchant gets the money.

I bought some goods using 90% of my credit once, and the merchant
stuffed up the paperwork  and we couldn't put the paperwork through
again for two weeks.  I couldn't find anyone in the VISA system who
could tell me how the authorisation could be cancelled so a new one
could be issued.

Thats the way Visa and Mastercard at least do it.  Not sure about the
other cards.

Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year



On Tue, 9 Nov 2004 15:23:49 -0600, Mark A Kruger
<[EMAIL PROTECTED]> wrote:
> Ryan,
> 
> Thanks a lot - that's a helpful start!
> 
> -Mark
> 
> 
> 
> -Original Message-
> From: Ryan Duckworth [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 09, 2004 3:21 PM
> To: CF-Talk
> Subject: RE: CC Gateway question
> 
> Authorize.net is our current provider.  We have thought about
switching
> several times in the past as well due to outages.  I would recommend
> looking into https://www.yourpay.com/ which I have researched and has
> lots of CF sample code.  I don't know about your specific problem, but
> they may be able to help.
> 
> Good luck.
> 
> Ryan Duckworth



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183860
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CC Gateway question

[Ryan Duckworth]

Authorize.net is our current provider.  We have thought about switching
several times in the past as well due to outages.  I would recommend
looking into https://www.yourpay.com/ which I have researched and has
lots of CF sample code.  I don't know about your specific problem, but
they may be able to help.

Good luck.


Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 09, 2004 2:33 PM
To: CF-Talk
Subject: RE: CC Gateway question

Come on folks - I'm counting on a little insight here (pleading look).

-Original Message-


Among the online gateways out there - who does everyone like?

I'm having trouble with "Atuhorize.net".  Using an "auth_only" followed
by a
batch "previous auth capture".  Recenty we turned on Address
verification.

If I do an "auth only" and it comes back as declined due to AVS, it
turns
out that the "auth" is still created on the customers card.  It is up to
the
issuing bank to decline and remove it. Authorize.net provides no way to
VOID
an auth_only that has been declined due to AVS. My customer does high
dollar
transactions (usually between 500 and 1200 per transaction).  So if they
get
the Address wrong that auth sits on the card for days until the bank
"officially" declines the card.

Do all the gateways work this way?  Do any of them have a way to remove
an
auth from a card if it's declined via AVS?  The irony is, if they turn
off
the AVS they can often void the transaction before it's shipped (sigh).
Does
anyone out there have any ideas on this?  Any one know of a gateway that
works differently or gives different options?

-mark

Mark A. Kruger, CFG, MSCE
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183798
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Online Presentations

[Ryan Duckworth]

Flash com server w/ flash remoting, ColdFusion, and using Macromedia's
RoboDemo to create the presentation. Tom Muck has a great Flash Remoting
book out right now.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 02, 2004 8:55 AM
To: CF-Talk
Subject: Re: Online Presentations

Looking for LIVE demonstrations

Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com


- Original Message - 
From: "Hugo Ahlenius" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 02, 2004 2:52 AM
Subject: RE: Online Presentations


> Hi,
>
> I know that partners of us have used "Viewlet Builder" for this
purpose:
> http://www.qarbon.com/
>
>
>
> --
> Hugo Ahlenius
>
> -
> Hugo Ahlenius  E-Mail: [EMAIL PROTECTED]
> Project OfficerPhone:+46 8 230460
> UNEP GRID-Arendal  Fax:  +46 8 230441
> Stockholm Office   Mobile: +46 733 467111
>   WWW:   http://www.grida.no
> - 
>
>
>
> |-Original Message-
> |From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
> |Sent: Monday, November 01, 2004 20:24
> |To: CF-Talk
> |Subject: OT: Online Presentations
> |
> |I have a customer who has created some software and wants to
> |show it to a number of people.  What is the best way for him
> |to show the software online, in a demonstration mode.
> |
> |Basically they want to click around on their pc's and let the
> |other folks ask questions either via chat or on the conference phone.
> |
> |(THIS IS NOT A WEB PROJECT)
> |
> |Any suggestions?
> |
> |Paul Giesenhagen
> |QuillDesign
> |417-885-1375
> |http://www.quilldesign.com
> |
> |
> |
> |
> |
> |
>
> 



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183127
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfchart / cfgraph help please

[Ryan Duckworth]

-Login to your CF Administrator
-Click the charting Link.

Try these settings:

Disk Cache
50 
4
C:\CFusionMX\charting\cache

This should solve your problem.



Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Guy Bambury [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 28, 2004 9:27 AM
To: CF-Talk
Subject: cfchart / cfgraph help please

Hello, 

I am currently trying to generate some bar charts.
The server we are running is 
Version 6,0,0,48097 Professional 

On using cfchart or cfgraph the page that loads just shows the little
place holder as if you were missing a picture (the white square with a
red cross)

After looking in the server chart cache directory I can see the relevant
image files it generates witch are viewable.

Its as if the server was not generating the correct path for them to be
displayed when the page loads.

The code i used was

cfgraph 








and I tried cfchart

  

 

 
 
   
   
 


As I said both these generate the correct pictures representing the
graphs, they are just not posted back to the page.

Any Ideas Please

Kind Regards Guy




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182812
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Returning Random Records

[Ryan Duckworth]

DECLARE random_cursor SCROLL CURSOR FOR
SELECT * FROM Users
ORDER BY Login

DECLARE @randRow integer

SELECT @randRow = (CEILING(RAND() * (SELECT COUNT(login) FROM
Users)))

OPEN random_cursor

-- Perform the random fetch.
FETCH ABSOLUTE @randRow FROM random_cursor

CLOSE random_cursor
DEALLOCATE random_cursor





Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 26, 2004 4:59 PM
To: CF-Talk
Subject: Re: Returning Random Records

Barney Boisvert wrote:

>SELECT TOP 1  ...
>FROM ...
>WHERE ...
>ORDER BY rand()
>
Sheer genius!  Thank you Barney!
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 
<mailto:[EMAIL PROTECTED]>
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182705
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: what is it called..?

[Ryan Duckworth]

You are asking about encryption which is covered very well in the latest
CFDJ article by Wayne Graham.  It includes step by step implementation.

The areticle is here:

http://www.sys-con.com/story/?storyid=46359&DE=1#RES

(scroll down to 2nd page for article)

You can make calls like: 
encrypted = encrypted(password,symmetricKey);
decrypted = decrypted(encrypted,symmetricKey);


Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 21, 2004 10:26 AM
To: CF-Talk
Subject: what is it called..?

...when you have a value eg 22 which is made up of 2+4+16 so you know of
all your options valued 2,4,8,16,32 Etc only 2 and 4 and 16 apply.

I know there must be a mathematical name for this, but what?

Does anyone have some example CF code to 'decrypt' such numbers?

Are there other [simple] ways to do this to handle a large number of
options (>25, so I don't start having giant numbers?)  Something to do
with prime numbers perhaps?  

You can tell I'm not a mathmatician can't you!

THANKS!


--
Regards;

Richard Meredith-Hardy
-
r[dot]mh[at]flymicro[dot]com
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182192
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Need a functioning static CFCHART sample

[Ryan Duckworth]

  
   

  

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Sim, Charles [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 21, 2004 9:07 AM
To: CF-Talk
Subject: Need a functioning static CFCHART sample

I'm looking for a simple functioning static CFCHART sample so that I can
test our LINUX/MX 6.1 system.

Does anyone have a working sample they can send me, or can anyone write
and test something and send it to me. 

I have writen a test peice, but I have no idea if it's bad code, or a
bad server config that is crashing it. 

Thanks,

Charles


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182189
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SQL Deadlock

[Ryan Duckworth]

Does anyone have any ideas on how to prevent/handle database deadlock?

Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock
resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.

We get a message similar to the one above about once a week.

My guess is that the deadlock occurred b/c the same row was attempting
to be read and written to at the same time.


Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272


~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182009
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Cached Query and CFQUERYPARAM

[Ryan Duckworth]

Your problem sparked a thought about a different table caching problem
we had earlier this year. 

Make sure that in the "Advanced Settings" in the CF ADMIN you set "Max
pooled Statements to 0.

Otherwise, If you make a change to the table structure, it will be
cached until you re-submit the datasource in the CF ADMIN, and your
query will error out if you try to insert or update into your new
column.

Setting the max pooled statements to 0 solves this problem.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 2:42 PM
To: CF-Talk
Subject: Re: Cached Query and CFQUERYPARAM

Whoops.  Brain fart.  I had removed the cfqueryparam from the WHERE 
clause...  Makes sense now.


- Original Message - 
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 19, 2004 1:36 PM
Subject: Cached Query and CFQUERYPARAM


> If I've got a query using a CFQUERYPARAM in the WHERE clause and then
> attempt to cache that query, will the query remain in CF's cache when
> called with different values for the queryparam?
>
> For example, the table 'mytable' is a very small table with just 5
rows:
>
> 
> SELECT something, somethingsomething
> FROM mytable
> WHERE mytableid = 
> 
>
> And if I call that query alternately with different identifiers, 1, 2,

> 3,
> etc., will the query remain cached?  In CF's debugging output I'm
seeing
> 'Time=Cached Query', but I don't understand how CF could cache the
query
> unless it caches the query results for each possible queryparam value.




~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181931
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF developer numbers

[Ryan Duckworth]

http://www.macromedia.com/v1/handlers/index.cfm?Id=19865&method=full


Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 1:57 PM
To: CF-Talk
Subject: CF developer numbers

Anyone have any idea how many CF developers there are?  Or perhaps
certified CF developers?

Thanks,
barneyb

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/


~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181915
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Source Control

[Ryan Duckworth]

Any suggestions on source control products?

I have looked into:
- Visual Source Safe ($5000+)
-CVS
-CVS NT
-Tortoise
-WIN CVS

What is everyone using and how good is it???

Functionality I prefer:
-Ability to check-in / out files
-History of changes
-Integration w/ Homesite is a plus but not required.

The first time I tried MS Visual SS it was very easy to integrate with.
I have tried using CVS, but had problems getting everything setup
smoothly.
Management would rather take the free choice over the expensive one.

Suggestions please!!!


Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181914
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Help with Select Query

[Ryan Duckworth]

What are you trying to select?

The highest Quiz score for a certain customer?

Please clarify what you want back or we can't help.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 14, 2004 1:09 PM
To: CF-Talk
Subject: Re: Help with Select Query

Having problems with sending full post to list and problem with 
a query.

Try third time

SELECT MAX(QuizDate) as QuizDate, QuizID
FROM Test_Board_Biomed
WHERE Customer_ID = 21
GROUP BY QuizID

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

RE: JavaScript Enabled Stats

[Ryan Duckworth]

If all you need is the JS version, there is an easier way which I'm sure
you could google, but if you want more...

We use a service call http://www.browserhawk.com/  to do all of our
browser testing.  I wrote a CFC that interfaces w/ their code.

It is handy because we know on the fly what version of Flash, JS,
connection speed, ... and other junk.

We get back stats for all these vars:

OS, OSDetail, Browser, FullVersion, MSN, AOL, Gecko, GeckoBuildDate,
BrowserBuild, IPAddress, ResolveIP, Referrer, LanguageType,
ConnectionSpeed, ConnectionType, ResolutionHeight, ResolutionWidth,
BrowserHeight, BrowserWidth, ColorDepth, Flash, FlashSP2, FontSmoothing,
Cookies, _javascript_, _javascript_Ver, JavaApplets, ActiveXControls, DHTML,
IFrames, StyleSheets, FileUpload, MouseOver, ImagesEnabled,
Plugin_Acrobat, Plugin_AcrobatVerEx, ImagesEnabled.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Jason Lemahieu [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 13, 2004 2:44 PM
To: CF-Talk
Subject: _javascript_ Enabled Stats

I want to find out about how many of our users have _javascript_ enabled.
I think it'll be like 99%, but would like to know if it is, in fact,
something like 75%.

I can make a simple database that stores 2 values (Enabled, notEnabled)
to update with each session, but I'm not sure how to exactly check.

The plan would be just a simple addition to a site's Application.cfm.  I
want to set a var on the page, JSEnabled = false;  then use _javascript_
to set the var to true onLoad.  (which will obviously only happen if
they have JS enabled)

The problem then, is how do I get this information back, as the page is
not just a form.  They could click on any number of links which I don't
want to change.  Has anyone tried taking stats like this before?
Otherwise, is it available in some other way?  (For example, a
cgi.client_javascript??)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: JavaScript Enabled Stats

[Ryan Duckworth]

We use a service call http://www.browserhawk.com/  to do all of our
browser testing.  We get back stats for all these vars.  I wrote a CFC
that interfaces w/ their code.

It is handy because we know on the fly what version of Flash, JS,
connection speed, ... and other junk.

OS

OSDetail

Browser

FullVersion

MSN

AOL

Gecko

GeckoBuildDate

BrowserBuild

IPAddress

ResolveIP

Referrer

LanguageType

ConnectionSpeed

ConnectionType

ResolutionHeight

ResolutionWidth

BrowserHeight

BrowserWidth

ColorDepth

Flash

FlashSP2

FontSmoothing

Cookies

_javascript_

_javascript_Ver

JavaApplets

ActiveXControls

DHTML

IFrames

StyleSheets

FileUpload

MouseOver

ImagesEnabled

Plugin_Acrobat

Plugin_AcrobatVerEx

ImagesEnabled

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Jason Lemahieu [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 13, 2004 2:44 PM
To: CF-Talk
Subject: _javascript_ Enabled Stats

I want to find out about how many of our users have _javascript_ enabled.
I think it'll be like 99%, but would like to know if it is, in fact,
something like 75%.

I can make a simple database that stores 2 values (Enabled, notEnabled)
to update with each session, but I'm not sure how to exactly check.

The plan would be just a simple addition to a site's Application.cfm.  I
want to set a var on the page, JSEnabled = false;  then use _javascript_
to set the var to true onLoad.  (which will obviously only happen if
they have JS enabled)

The problem then, is how do I get this information back, as the page is
not just a form.  They could click on any number of links which I don't
want to change.  Has anyone tried taking stats like this before?
Otherwise, is it available in some other way?  (For example, a
cgi.client_javascript??)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: scheduling pages

[Ryan Duckworth]

I would probably re-evaluate the process overall, but this may help.

One idea is to have the process run more efficiently but using code similar to this:

    if(fileExists(locFilePath)){

createObject('java','java.io.File').init(locFilePath).delete();

        }

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Coleman, Brian [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 08, 2004 1:03 PM
To: CF-Talk
Subject: scheduling pages

I have a page that needs scheduling and may take something like 2 ½ to 3 hours to complete. I could break this same page down into 11-12 smaller pages and schedule them individually; it would probably take similar time for the entire process. Does anyone know if it's better to have shorter jobs run or one long job?

Thanks,
Brian

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

RE: .cgi conversion

[Ryan Duckworth]

The tool below will turn .class files to .java files.

.cgi files can be created from c, c++, java Many languages.  

If it is java byte code (like a class file) then you can use this
reverse engineering tool.

You can then use the .java source file that is generated to create your
.cfm or .asp page.  

It will take work to create the CF page from the java source, but it is
better than not having the source at all.

Also, you could hire or get a java consultant who could easily turn the
.java source file into CF or ASP.

http://members.fortunecity.com/neshkov/dj.html
 

Good luck.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 24, 2004 9:03 AM
To: CF-Talk
Subject: RE: .cgi conversion

> Is there any tool out there which is basically convert the 
> .cgi scripts to any other language like php or possibly cfm 
> or maybe asp

No, not to my knowledge. I think that generic CGI programs might be
written
in all sorts of languages - some of which may not be scripting languages
at
all. If I recall correctly, most CGI programs with a .cgi extension are
compiled.

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: JAVASCRIPT and textarea

[Ryan Duckworth]

Yes.  This is possible.  

1.  Create 2 hidden s on the page.

2.  Use code similar to this to copy to temp area, fix, then copy back
to original area.



fullCleanWorkSpace.innerHTML =  '' + aeObject.DOM.body.innerHTML +
'';

removeAllTags(fullCleanWorkSpace,fullCleanWorkSpace2);

aeObject.DOM.body.innerHTML = fullCleanWorkSpace2.innerHTML;

More DOM information can be found here: 

http://msdn.microsoft.com/library/default.asp?url="">
/reference/methods/removenode.asp

Good luck!

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Asim Manzur [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 23, 2004 11:08 AM
To: CF-Talk
Subject: Re: _javascript_ and textarea

here is the function. 
It like that fuction is working, but only problem I am having that I
need to change the value in the textarea as well so user can see that
what his output will be. 
And those textarea(s) are dynamic. 
so I am passing two values to the function. rcv=what ever they typed and

nm = the name of the textarea 

now when I do dest = removebr that should be 

document.theForm.story1.value = removebr 

and its not working. is there anyother way to do the same 

function Remove(rcv, nm){ 
dest = "document.theForm." + nm + ".value"; 
removebr = rcv.replace(/[\n\r]/g," "); 
dest = removebr; 
alert("this is dest\n" + dest); 
}
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: JAVASCRIPT and textarea

[Ryan Duckworth]

Yes.  This is possible.  

1.  Create 2 hidden s on the page.

2.  Use code similar to this to copy to temp area, fix, then copy back
to original area.



fullCleanWorkSpace.innerHTML =  '' + aeObject.DOM.body.innerHTML +
'';

removeAllTags(fullCleanWorkSpace,fullCleanWorkSpace2);

aeObject.DOM.body.innerHTML = fullCleanWorkSpace2.innerHTML;

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Asim Manzur [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 23, 2004 11:08 AM
To: CF-Talk
Subject: Re: _javascript_ and textarea

here is the function. 
It like that fuction is working, but only problem I am having that I
need to change the value in the textarea as well so user can see that
what his output will be. 
And those textarea(s) are dynamic. 
so I am passing two values to the function. rcv=what ever they typed and

nm = the name of the textarea 

now when I do dest = removebr that should be 

document.theForm.story1.value = removebr 

and its not working. is there anyother way to do the same 

function Remove(rcv, nm){ 
dest = "document.theForm." + nm + ".value"; 
removebr = rcv.replace(/[\n\r]/g," "); 
dest = removebr; 
alert("this is dest\n" + dest); 
} 

> Micheal will you please give me an example how to replace i.e. you 
> mean to do the server side validation???
> I need the client side validation.
> 
> Ryan, does DOM works in mac as well??
> 
> 
> thanks
> 
> >I agree.  Simply replace after the submit.
> >
> >Also, you can strip complicated things out using DOM.
> >
> >We use the DOM to strip out HTML tags such as: Removing FONT tag.
> >
> > 
> >
> >if(child.tagName.toUpperCase() == 'FONT'){
> >
> >child.removeNode();
> >
> >}
> >
> > 
> >
> >Good luck.
> >
> >Ryan Duckworth 
> >Macromedia ColdFusion Certified Professional
> >Uhlig Communications 
> >10983 Granada Lane 
> >Overland Park, KS 66211
> >(913) 754-4272
> >
> >  _  
> >
> >From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
> >Sent: Wednesday, September 22, 2004 3:58 PM
> >To: CF-Talk
> >Subject: RE: _javascript_ and textarea
> >
> > 
> >
> >
> >You handle the keyCode event but not the change (onChange) event 
> which
> >you need to check also to ensure that a copy past fires off the 
> routine
> >needed to validate the entry into the box.
> >
> >Michael T. Tangorre
> >
> >  
_

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

RE: JAVASCRIPT and textarea

[Ryan Duckworth]

I agree.  Simply replace after the submit.

Also, you can strip complicated things out using DOM.

We use the DOM to strip out HTML tags such as: Removing FONT tag.

if(child.tagName.toUpperCase() == 'FONT'){

child.removeNode();

}

Good luck.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 3:58 PM
To: CF-Talk
Subject: RE: _javascript_ and textarea

> From: Asim Manzur [mailto:[EMAIL PROTECTED] 
> I have form with TextArea  and _javascript_, which doesn't 
> allow user to hit enter key and "|".
> 
> The below code is working fine, but if user cut/paster from 
> word or notepad then textbox accept the enter key and pipe.
> 
> Can someone advise anyway to prevent that??

You handle the keyCode event but not the change (onChange) event which
you need to check also to ensure that a copy past fires off the routine
needed to validate the entry into the box.

Michael T. Tangorre

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

RE: Help!! CFHTTP failing

[Ryan Duckworth]

Problem Solved.  Just wanted to let everyone know how we fixed it.

Also, has anyone else had a similar problem to this?

This file became corrupt:

\CFusionMX\runtime\bin\jvm.config

We also know that the change was not made through CF Admin b/c the
backup had not changed.

After rebooting the first time, the ColdFusion service would not start
back up.

We copied the file from another production box and rebooted and it
worked fine.

Our only indication of a problem was a CFHTTP call failure.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Ryan Duckworth 
Sent: Monday, September 20, 2004 10:15 AM
To: CF-Talk
Subject: Help!! CFHTTP failing

Please help!

I am getting a timeout on a CFHTTP call.  This code has worked for over
6 months.

This weekend we had a planned power outage and everything got turned
off.

Any ideas?  Running CF 6.1 on Win 2000.

Thanks,

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

Help!! CFHTTP failing

[Ryan Duckworth]

Please help!

I am getting a timeout on a CFHTTP call.  This code has worked for over
6 months.

This weekend we had a planned power outage and everything got turned
off.

Any ideas?  Running CF 6.1 on Win 2000.

Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 20, 2004 10:08 AM
To: Ryan Duckworth; Justin Hansen; Pat Wenke; Arthur French
Subject: [CF DEBUG] Intranet

struct

Browser

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) 

DateTime

{ts '2004-09-20 10:07:30'} 

Diagnostics

The request has exceeded the allowable time limit Tag: cfhttp The
error occurred on line 165. 

GeneratedContent

   
 

HTTPReferer

http://intranet.uhlig.com/zTestFolder/pat/index.cfm 

Mailto

[empty string] 

Message

The request has exceeded the allowable time limit Tag: cfhttp 

QueryString

[empty string] 

RemoteAddress

192.168.3.6 

RootCause

[unknown type]

StackTrace

coldfusion.runtime.RequestTimedOutException: The request has exceeded
the allowable time limit Tag: cfhttp at
coldfusion.tagext.net.HttpTag.connHelper(HttpTag.java:868) at
coldfusion.tagext.net.HttpTag.doEndTag(HttpTag.java:990) at
cftest2ecfm1206061325.runPage(G:\www\intranet.uhlig.com\zTestFolder\pat\
test.cfm:165) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:
43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist
enceFilter.java:28) at
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.CfmServlet.service(CfmServlet.java:105) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252
) at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527
) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:
192) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j
ava:348) at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java
:451) at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav
a:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) 

TagContext

array 

1

struct

COLUMN

0 

ID

CFHTTP 

LINE

165 

RAW_TRACE

at
cftest2ecfm1206061325.runPage(G:\www\intranet.uhlig.com\zTestFolder\pat\
test.cfm:165) 

TEMPLATE

G:\www\intranet.uhlig.com\zTestFolder\pat\test.cfm 

TYPE

CFML 

Template

/zTestFolder/pat/test.cfm 

Type

coldfusion.runtime.CfErrorWrapper
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

cfx_imageflare transparent image - alpha property help

[Ryan Duckworth]

The code below correctly adds a color shade to a gray scale image.

I am having lots of problems keeping the image transparent though.  

It seems to create a white background which I can't make transparent.

Please help!







    Transparent Image







    locColor = "blue";

    locSourceFile = "transparent.gif";

    locDestinationFile = "transparent_#locColor#.gif";

    bgColor = "00";





    



    

    

    







Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Count Online Users Conundrum

[Ryan Duckworth]

I think you have a situation where the sessions are staying active long
after the user logs off.  Run that loop and let me know what you get
back.  Your problem will probably be obvious then. 

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Sung Woo [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 17, 2004 3:18 PM
To: CF-Talk
Subject: Count Online Users Conundrum

I got this little snippet from easycfm.com to keep track of online
users, but lately, it hasn't been working quite right.  What happens is
that at the end of the day (I run an intranet where there are about 200
peak users), around midnight, it still shows 80 or so users online!
What do you think could be causing this?



 
    
  
    



  
  




  
user_time)>





  
   Evaluate(DateDiff("n", StructFind(Application.UsersInfo, itmUser),
Now())) GT 15
  >
    
  





-




    
 Total Active Sessions : #StructCount(Application.UsersInfo)#
    


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

RE: Count Online Users Conundrum

[Ryan Duckworth]

  
StructFind(Application.UsersInfo, itmUser), Now()))>

  #userActiveTime#

 

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Sung Woo [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 17, 2004 3:18 PM
To: CF-Talk
Subject: Count Online Users Conundrum

I got this little snippet from easycfm.com to keep track of online
users, but lately, it hasn't been working quite right.  What happens is
that at the end of the day (I run an intranet where there are about 200
peak users), around midnight, it still shows 80 or so users online!
What do you think could be causing this?



 
    
  
    



  
  




  
user_time)>





  
   Evaluate(DateDiff("n", StructFind(Application.UsersInfo, itmUser),
Now())) GT 15
  >
    
  





-




    
 Total Active Sessions : #StructCount(Application.UsersInfo)#
    


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

RE: Java sleep method ties up no resources?

[Ryan Duckworth]

I personally have used this sleep method and looped over a query w/
100,000 records, calling sleep for each record to slow it down.  No one
would ever call this same page from 10 different browsers.  There would
be no point and yes you would deserve to have your server crash on you.
You would still have 9 available even with this batch process that you
want to run over a period of time... i.e. over night or one hour.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 10, 2004 4:52 PM
To: CF-Talk
Subject: Re: Java sleep method ties up no resources?

Thanks guys.  I figured this was way too good to be true.  

-- 
--Matt Robertson--
MSB Designs, Inc.
mysecretbase.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: CFMail

[Ryan Duckworth]

I am sure that the page refresh code works, however, I personally try to
avoid doing meta refreshes at all costs.  I prefer to have one batch
that sent all the emails and delayed the proper amount of time between
each batch.

A java thread (which ColdFusion code is converted to) is doing a NOP (no
operation) procedure during a java Sleep command which causes no
inefficiency.  The multiprocessing nature of the CPU handles this
functionality for you and will use those CPU cycles with other requests
during the sleep.

This guarantees that all of the emails will be sent.  

This sleep command will wait for 1 minute between each of the batches.

 

You can use the mod function to detect how many emails have been sent.





   



When you place this code inside you CFOUTPUT query statement it will
send all the email you have in your query and delay for the server to
allow them to go through.  

Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 09, 2004 2:21 PM
To: CF-Talk
Subject: Re: CFMail

The problem I had doing the sleep thing mentioned above is that it
ties up a thread during the whole deal.  My script is a different
operation on every mail run, so you don't blast CF with an attempt to
run a 60,000ms procedure.

As godawfully inefficient as it is, that script you've been pointed to
seems to be a pretty decent solution.  However one thing I have seen
requested frequently is failover recovery (i.e. power failure in the
middle of the run blasts the browser).  You could do that yourself
with a flag field in your mailing db that runs concurrently with each
mail batch.  I'll probably use a client var in the published script to
keep it generic.

Cheers,

-- 
--Matt Robertson--
MSB Designs, Inc.
mysecretbase.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: CFMail

[Ryan Duckworth]

Another way to do this is to simply sleep after a certain number of
emails have been sent.

Add this code within your CFOUTPUT query tag.

I personally prefer this method over meta refresh.



    

    
'java.lang.Thread').sleep(30)>



    

    
'java.lang.Thread').sleep(60000)>



Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Donna French [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 09, 2004 12:51 PM
To: CF-Talk
Subject: RE: CFMail

Got it and testing it out right now. Thanks Paul!

Anyone else using this script? If so, how do you like it? 

Thank you,

Donna French

-Original Message-
From: Paul Vernon [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 09, 2004 11:12 AM
To: CF-Talk
Subject: RE: CFMail

Matt Robertson has a great script for doing this on the following link!

http://mysecretbase.com/Slowing_Down_CFMAIL.cfm

Paul
  _

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

RE: Search 2 tables

[Ryan Duckworth]

There are many ways to do this.  Try this code:

Additional Query:


  SELECT *
  FROM products
  WHERE productname LIKE '%#Form.search#%'


Same 1st Search Query:


  SELECT *
  FROM dolls
  WHERE name LIKE '%#Form.search#%'


Display Results:



Products   






#






Dolls

    








Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Search 2 tables

[Ryan Duckworth]

There are many ways to do this.  Try this code:

Additional Query:


  SELECT *
  FROM products
  WHERE productname LIKE '%#Form.search#%'


Same 1st Search Query:


  SELECT *
  FROM dolls
  WHERE name LIKE '%#Form.search#%'


Display Results:



Products   






#






Dolls

    








Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Donna French [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 02, 2004 2:42 PM
To: CF-Talk
Subject: Search 2 tables

Okay, I must warn you all that when I first built this web app I was a
TOTAL newbie and had no idea what I was doing with CF or database
design.

With that said, I am attempting to patch the search feature so that it
can pull results from 2 tables while I redesign the app and database.

The current code is:


  SELECT *
  FROM dolls
  WHERE name LIKE '%#Form.search#%'







The problem is that I need to search 2 tables and display results
accordingly.

Table 2 info-

products(table)
productid(pk)
lanesid(text)
productname(text)

If results are found in this table, the link will need to be:
detailsProduct.cfm?productid=#productid#

I think I've given enough information, and I won't bother to send all
the different methods I've tried to get this to work.

If you have ANY ideas please send!

Greatly appreciate all of your help and patience.

TIA,
Donna

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

RE: GT 0 failing CFIF decision

[Ryan Duckworth]

Try This:  Use the COUNT SQL command to solve your problem.  This is
guaranteed to work.


SELECT COUNT(ce_orgname) AS NumInserts, ce_index, ce_orgname 

FROM careerexpo2004
WHERE ce_email = '#Form.ce_email#'




Your company information has been added.  Click to 
HREF="" target="_self">add another.

Your company information has been was not added.  Click to 
HREF="" target="_self">try again. 


Good luck!

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 

Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: daniel kessler [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 30, 2004 1:19 PM
To: CF-Talk
Subject: Re: GT 0 failing CFIF decision

Sorry, I should have put the query

> An insert statement (which is what I assume you are doing) doesn't 
> return a recordset.  

I am doing an insert, but I'm doing a Query after the insert to see if
it's been added.  In the code, "add_check" is the query name.  Here's
the query:


SELECT ce_index,ce_orgname FROM careerexpo2004
WHERE ce_email = '#Form.ce_email#'




add_check.recordcount:#add_check.recordcount#  


Your company information has been added.  Click to 
HREF="" target="_self">add another.

Your company information has been was not added.  Click to 
HREF="" target="_self">try again. 


>You might want to create a stored proc that 
> returns an output param back to CF indicating that the insert either 
> failed or succeeded.
> 
> HTH,
> 
> --
> Jeff Garza
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Allow End User to Save As Excel/CSV

[Ryan Duckworth]

Tim,

Put this code at the top of the page and it will do the trick:



You also need the start  and  tags.

It will prompt the user to Save or Open the Excel file.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Claremont, Timothy [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 30, 2004 10:01 AM
To: CF-Talk
Subject: Allow End User to Save As Excel/CSV

Can someone point me in the right direction on allowing the end user to
save query results as an Excel or CSV file on their local machine? I am
using the following code, but it just displays the table on screen, and
does not save the file:


 datasource="CombinedRaps">
Select Name, Provider, EncounterDate, EncounterMonth,
EncounterYear, SiteID 
FROM tblRyan
WHERE Provider = '#SelectedProviderName#'
AND EncounterMonth = '#SelectedServiceMonth#'
AND EncounterYear = '#SelectedServiceYear#'






Provider
Participant
EncounterDate
EncounterMonth
EncounterYear
SiteID




#Provider#
#Name#
#EncounterDate#
#EncounterMonth#
#EncounterYear#
#SiteID#




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

RE: cfm template gone, i have class file

[Ryan Duckworth]

Tony,

Try this tool.  It will convert your class file to a .java file.

I think that it will get you to a point where you can write the CFM page
from there with a little time.

It won't be extremely easy, but it can be done more easily with the java
source than recreating everything from memory.

http://members.fortunecity.com/neshkov/dj.html

It works...One of my co-workers used this when his hard drive crashed
and he lost all his java source code, but still had the class files on
the server.

Good luck!  

Since we are on the topic, we have been looking for a good (meaning
works and free) Source Control tool.

I looked into CVS and CVS-NT using tortoise, but I didn't like this and
would like to go with something similar to MS Visual Source Safe.

Anyone have any good recommendations.  We want something that would
integrate with HomeSite that has check-in / check-out functionality.



Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 29, 2004 2:38 PM
To: CF-Talk
Subject: Re: cfm template gone, i have class file

strange, in homestite i can go to other files, and ctrlz them now, but
not on this one?  wtf? is this a bug in homesite that you can ctrlz
some files but not others, depending on what you do?

this is nuts.

tw

On Thu, 29 Jul 2004 15:24:14 -0400, Tony Weeg <[EMAIL PROTECTED]>
wrote:
> it was a dev server, thats where we ran it.  (dumb, VERY dumb)
> 
> i dont use version control, i know i know i know
> 
> this is a lesson, i guess.
> 
> I AM ABOUT TO SHOOT MYSELF!
> 
> there has to be a reversal tool...if it can go from cfml to .class,
> why not .class to cfm?
> 
> tony
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: cfm template gone, i have class file

[Ryan Duckworth]

Tony,

Try this tool.  It will convert your class file to a .java file.

I think that it will get you to a point where you can write the CFM page
from there pretty easily.

http://members.fortunecity.com/neshkov/dj.html

It works...One of my co-workers used this when his hard drive crashed
and he lost all his java source code, but still had the class files on
the server.

Good luck!  

Since we are on the topic, We have been looking for a good (meaning
works and free) Source Control tool.

I looked into CVS and CVS-NT using tortoise, but I didn't like this and
would like to go with something similar to MS Visual Source Safe.

Anyone have any good recommendations.  We want something that would
integrate with HomeSite that has check-in / check-out functionality.

Thanks,

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 29, 2004 2:38 PM
To: CF-Talk
Subject: Re: cfm template gone, i have class file

strange, in homestite i can go to other files, and ctrlz them now, but
not on this one?  wtf? is this a bug in homesite that you can ctrlz
some files but not others, depending on what you do?

this is nuts.

tw

On Thu, 29 Jul 2004 15:24:14 -0400, Tony Weeg <[EMAIL PROTECTED]>
wrote:
> it was a dev server, thats where we ran it.  (dumb, VERY dumb)
> 
> i dont use version control, i know i know i know
> 
> this is a lesson, i guess.
> 
> I AM ABOUT TO SHOOT MYSELF!
> 
> there has to be a reversal tool...if it can go from cfml to .class,
> why not .class to cfm?
> 
> tony
> 
> 
> 
> 
> On Thu, 29 Jul 2004 12:13:36 -0700, Barney Boisvert
<[EMAIL PROTECTED]> wrote:
> > Nope, you can't go from CLASS to CFM.  You can get back the Java,
but
> > that's it, and it won't be very helpful.  Couple suggestions:
> >
> > 1) enable undo across saves in the HomeSite prefs (CF Studio had
this,
> > I assume HS does)
> > 2) start using version control
> > 3) can you download it from a production server, obviously without
the
> > newest changes
> >
> > cheers,
> > barneyb
> >
> >
> >
> > On Thu, 29 Jul 2004 15:05:45 -0400, Tony Weeg <[EMAIL PROTECTED]>
wrote:
> > > can i get my cfm back from the class file?
> > >
> > > is this possible?
> > >
> > > homesite wont let me ctrl+z to go back in the file editing, i
> > > accidentally ctrl + a, and deleted the contents, then saved, and
now
> > > its blank, can i recreate from the class file?
> > >
> > > thanks if you can help.
> > >
> > > --
> > > tony
> > >
> > > Tony Weeg
> > > human.
> > > email: tonyweeg [at] gmail [dot] com
> > > blog: http://www.revolutionwebdesign.com/blog/
> > >
> > > Check out http://www.antiwrap.com to send websites to your
friends.
> > >
> > >
> >
> >

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

RE: Dynamic variable assignment in CFSCRIPT?

[Ryan Duckworth]

Another method that can be used for nested dynamic structures:

someStruct['tab#arguments.firstStruct#'].packet['applicant#locApplicantI
D#'].valid = somevalue;

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272

  _  

From: Wes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 20, 2004 2:15 PM
To: CF-Talk
Subject: RE: Dynamic variable assignment in CFSCRIPT?

Or rather.

Temp = SetVariable("someStruct.#myVar#", "somevalue")

-Original Message-
From: Nikhil Madani [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 20, 2004 3:02 PM
To: CF-Talk
Subject: Dynamic variable assignment in CFSCRIPT?

How would one do this in CFSCRIPT-


TIA
Nikhil

  _

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

RE: cfmail problem

[Ryan Duckworth]

Another solution is to simply delay between each email to avoid a
connection problem.
This code will delay for 1 second.  Put it in your loop and I'm sure it
will work perfectly.
It will take under a minute to send out your entire batch and not fail.
It sounds like your mail server isn't spooling the outbox.

 


Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66207 
(913) 754-4272 

	-Original Message-
	From: Tim Do [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, July 07, 2004 4:55 PM
	To: CF-Talk
	Subject: RE: cfmail problem
	
	
	Yes.
	
	-Original Message-
	From: Jordan Michaels [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, July 07, 2004 2:50 PM
	To: CF-Talk
	Subject: Re: cfmail problem
	
	Curious, did you enable mail spooling?
	
	-- 
	Warm regards,
	Jordan Michaels
	Vivio Technologies
	http://www.viviotech.net/
	[EMAIL PROTECTED]
	
	Tim Do wrote:
	
	> Hello all,
	>
	>
	> I'm looping through a list of bout 50 email addresses and
doing a cfmail
	> inside each iteration.  It sends out successfully on most of
it, but there
	> are few that don't make it out.  The mail log says " Could not
connect to
	> SMTP host: wnpx, port: 25 " Then I retry each of the email
address 
	> that fell
	> out separately and they go through.  What could be causing
this?
	>
	>
	> Thanks,
	> Tim
	> 
	  _ 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Windows NT Error 2

[Ryan Duckworth]

Your path is wrong.  NT Error 2 means wrong path... Try outputting the
path.

Ryan Duckworth 
Macromedia ColdFusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66207 
(913) 754-4272 

	-Original Message-
	From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
	Sent: Tuesday, July 06, 2004 10:25 AM
	To: CF-Talk
	Subject: Windows NT Error 2
	
	
	Anyone familiar with this error as it pertains to running
gzip.exe on the server using 
	DATETIME 07/06/04 10:19:53 
	DETAIL Windows NT error 2 occurred. 
	DIAGNOSTICS Cannot execute GZIP.EXE Windows NT error 2 occurred.
	
	
	
	
	Greg Morphis
	Rapid Response Team
	Client Server Dev/Analyst I
	Armageddon Programmer/Support
	Desk: 501/905-2881
	Cell: 501/529-3691
	
	

**
	The information contained in this message, including
attachments, may contain 
	privileged or confidential information that is intended to be
delivered only to the 
	person identified above. If you are not the intended recipient,
or the person 
	responsible for delivering this message to the intended
recipient, ALLTEL requests 
	that you immediately notify the sender and asks that you do not
read the message or its 
	attachments, and that you delete them without copying or sending
them to anyone else. 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: sql question

[Ryan Duckworth]

>>is there a function in transact sql that allows something like the
cfmx insert() function?

 
To display it, just use mid and call your CFC function that returns the
decrypted CC number.

 
#mid(objCreditCard.getCcNumberDecrypted(),1,4)#-#mid(objCreditCard.getCc
NumberDecrypted(),5,4)#-#mid(objCreditCard.getCcNumberDecrypted(),9,4)#-
#mid(objCreditCard.getCcNumberDecrypted(),13,4)#

 
If you want to convert all of them from 1234567891234567 to
1234-5678-9123-4567 I would just:
1. Change the type of your DB field
2. Use a regular _expression_ to add the dashes
3. Run an update on each Credit Card number.  Even with 10,000 records,
CF would blaze through the list in a few minutes.

 
Note: Amex and a few other cards have different lengths, so be careful 

Ryan Duckworth 
Macromedia Coldfusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66207 
(913) 754-4272 

	-Original Message-
	From: Tony Weeg [mailto:[EMAIL PROTECTED] 
	Sent: Friday, July 02, 2004 10:42 AM
	To: CF-Talk
	Subject: sql question
	
	
	is there a function in transact sql that allows something like
the cfmx
	insert() function?
	
	I have a number field, 1236547852145632, that I want to display
like:
	
	1236-5478-5214-5632
	
	and don't want to do this...
	
	
	
	
	
	
	
	too many times in a 1 query recordset :)
	if I can pass it off to sql server, GREAT!
	
	thanks.
	
	...tony
	
	tony weeg
	senior web applications architect
	navtrak, inc.
	www.navtrak.net
	[EMAIL PROTECTED]
	410.548.2337
	
	visit www.antiwrap.com to send long url emails to your friends!
	
	-- dont mistake my perfection as arrogance
	anonymous 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: How to do this join? (MySQL 4.0 can't do subqueries...)

[Ryan Duckworth]

Newsletter_Series which don't have Subscriptions for a particular
Subscriber...

 

 SELECT  newsletter_series.Series_ID, newsletter_series.Series_Title
 FROM    newsletter_series
 WHERE newsletter_subscriptions.Subscriber_ID =
'#CurrentSubscriber.Subscriber_ID#'
 AND    newsletter_subscription.Series_ID is null  


I believe this query will solve your problem.  Can you send your table
desctriptions?
Also, If there is no subscription, I am assuming the
newsletter_subscription.Series_ID would be null.

Ryan Duckworth 
Macromedia Coldfusion Certified Professional 
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66207 
(913) 754-4272 

	-Original Message-
	From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, June 30, 2004 9:40 PM
	To: CF-Talk
	Subject: How to do this join? (MySQL 4.0 can't do subqueries...)
	
	
	Hi, all.
	
	I've tried for hours to figure this out, but can't get it...
	
	3 tables...
	
	Newsletter_Series, Newsletter_Subscribers,
Newsletter_Subscriptions
	
	I need to run a query to get all Newsletter_Series
	which don't have Subscriptions for a particular Subscriber...
	
	Primary Key Relationships:
	
	    - Newsletter_Series.Series_ID /
Newsletter_Subscriptions.Series_ID
	    - Newsletter_Subscriptions.Subscriber_ID /
	Newsletter_Subscribers.Subscriber_ID
	
	Can't do subqueries (aaargh!), so I'm left with a join.
	
	Something like,
	
	
	
	Select newsletter_series.Series_ID,
	  newsletter_series.Series_Title,
	   from newsletter_series
	
	left join
	
	 newsletter_subscriptions, newsletter_subscribers
	    on (newsletter_subscriptions.Subscriber_ID <>
	'#CurrentSubscriber.Subscriber_ID#'
	 and newsletter_subscription.Series_ID <>
	newsletter_series.Series_ID)
	where newsletter_series.Series_ID is null
	
	
	
	I've tried a lot of variations and read the documentation, but
can't get the
	results...
	
	Help, anyone?
	
	Rick
	
	
	Rick Faircloth
	WhiteStoneMedia.com
	
	--
	Outgoing mail is certified Virus Free.
	Checked by AVG Anti-Virus (http://www.grisoft.com).
	Version: 7.0.253 / Virus Database: 263.3.8 - Release Date:
6/30/2004 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]