Re: cfbreak in cfswitch in CFMX 7?

[Barney Boisvert]

That's seriously a bug?  Undoubtedly falls under the same train of
though as not having a CFCONTINUE tag?

Both of those constructs are very valuable to have in certain
situations.  Nothing you can't avoid with conditionals (or recursion,
in the case of CFCONTINUE), but you can certainly make code far less
maintainable and harder to read with a buttload of nested conditionals
that solving the problem can require.

cheers,
barneyb

On 7/11/05, Sean Corfield <[EMAIL PROTECTED]> wrote:
> On 7/11/05, Johnny Le <[EMAIL PROTECTED]> wrote:
> > CFbreak doesn't seem to work in cfswitch in CF 7 any more.
> 
> Correct. Allowing it was a bug in CFMX 6.x. If you tried it in CF5, it
> was illegal.
> 
> >  What tag do you use to break out of cfswitch now?
> 
> You don't need a tag.  ends at the  tag.
> 
> I blogged about this - because it bit the Macromedia Web Team when we
> upgraded to CFMX 7...
> --
> Sean A Corfield -- http://corfield.org/
> Team Fusebox -- http://fusebox.org/
> Got Gmail? -- I have 50, yes 50, invites to give away!

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

Got Gmail? I have 50 invites.

~|
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:211605
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: cfbreak in cfswitch in CFMX 7?

[Sean Corfield]

On 7/11/05, Johnny Le <[EMAIL PROTECTED]> wrote:
> CFbreak doesn't seem to work in cfswitch in CF 7 any more.

Correct. Allowing it was a bug in CFMX 6.x. If you tried it in CF5, it
was illegal.

>  What tag do you use to break out of cfswitch now?

You don't need a tag.  ends at the  tag.

I blogged about this - because it bit the Macromedia Web Team when we
upgraded to CFMX 7...
-- 
Sean A Corfield -- http://corfield.org/
Team Fusebox -- http://fusebox.org/
Got Gmail? -- I have 50, yes 50, invites to give away!

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~|
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:211604
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: cfbreak in cfswitch in CFMX 7?

[Barney Boisvert]

No, he means to abort the current case, without having to put the
remainder inside a conditional.

switch (myval) {
   case "one":
  ...
  if (condition) break;
  ...
  break;
   case "two":
   ...
}


   
  ...
  
 
  
  ...
   


cheers,
barneyb

On 7/11/05, Matthew Walker <[EMAIL PROTECTED]> wrote:
> Do you mean to stop each successive cfcase from executing? You don't need to
> do that in cfswitch, only in the cfscript switch().
> 
> 
> -Original Message-
> From: Johnny Le [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 12 July 2005 2:12 p.m.
> To: CF-Talk
> Subject: cfbreak in cfswitch in CFMX 7?
> 
> Hi,
> 
> CFbreak doesn't seem to work in cfswitch in CF 7 any more.  What tag do you
> use to break out of cfswitch now?
> 
> Johnny
> 

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

Got Gmail? I have 50 invites.

~|
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:211603
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: cfbreak in cfswitch in CFMX 7?

[Matthew Walker]

Do you mean to stop each successive cfcase from executing? You don't need to
do that in cfswitch, only in the cfscript switch().


-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 12 July 2005 2:12 p.m.
To: CF-Talk
Subject: cfbreak in cfswitch in CFMX 7?

Hi,

CFbreak doesn't seem to work in cfswitch in CF 7 any more.  What tag do you
use to break out of cfswitch now?

Johnny



~|
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:211602
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

cfbreak in cfswitch in CFMX 7?

[Johnny Le]

Hi,

CFbreak doesn't seem to work in cfswitch in CF 7 any more.  What tag do you use 
to break out of cfswitch now?

Johnny

~|
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:211601
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: query sum or group by

[Eddie Awad]

> SELECT p.si_id,s.food_store_id,s.gs_price, SUM(s.gs_price) AS total_price
> FROM fsnep_food_store_purchases p, fsnep_food_store 
> s,fsnep_food_store_game_info g
> WHERE p.food_store_id = s.food_store_id
>AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
> GROUP BY p.si_id,s.food_store_id,s.gs_price

Remove the s.gs_price from the select clause and the group by clause
if you want a sum on this column:

SELECT p.si_id,s.food_store_id, SUM(s.gs_price) AS total_price
FROM fsnep_food_store_purchases p, fsnep_food_store
s,fsnep_food_store_game_info g
WHERE p.food_store_id = s.food_store_id
   AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
GROUP BY p.si_id,s.food_store_id
-- 
Eddie Awad.
http://awads.net/

~|
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:211600
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: Newbie Question

[Matthew Walker]

Here's what I'd suggest...

1) Learn how to use CFCs properly. Place your business logic in CFCs and
then build your display pages to call your CFCs. 

2) Next learn how to write custom tags with start and end tags like this:

...content...

And use them to build layout elements such as boxes and columns (this might
not be very useful depending what you are doing). The trick to this is
understanding thisTag.executionMode and thisTag.generatedContent.

3) Run your entire site through one file (index.cfm) with a parameter passed
in the URL that controls what happens. Place a big cfswitch in this file. 

That may be all the framework you need. If not, it's a good point to begin
at. 



-Original Message-
From: Kevin Rosenthal [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 5 July 2005 1:14 p.m.
To: CF-Talk
Subject: Newbie Question

Greetings,

 

I am new to ColdFusion and just started to learn. Before I get set in my
ways, I have read many posts about things like Fuse Builder and other module
building blocks for creating applications. My question is which one would be
the easiest to learn and is it a good practice to use one or would creating
my own components and such would be just as good?

 

Thanks,

Kevin

 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.12/46 - Release Date: 7/11/2005
 




~|
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:211599
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

FW: CF-Talk: Digest every hour

[daniel kessler]

I see, thanks.

>first ooops:
>
>> RETURNING ID
>>  INTO newid;
>
>should be
>
>> RETURNING GI_ID
>>  INTO newid;
>
>(obviously)
>
>/t
>
>>

~|
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:211597
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

Newbie Question

[Kevin Rosenthal]

Greetings,

 

I am new to ColdFusion and just started to learn. Before I get set in my
ways, I have read many posts about things like Fuse Builder and other module
building blocks for creating applications. My question is which one would be
the easiest to learn and is it a good practice to use one or would creating
my own components and such would be just as good?

 

Thanks,

Kevin

 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.12/46 - Release Date: 7/11/2005
 


~|
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:211598
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

query sum or group by

[daniel kessler]

I am trying to SUM a column in oracle.  The query works fine until I add the 
SUM.  It seems from the error, that I then have to have a GROUP BY.  I guess I 
don't understand how to use the GROUP BY in this instance or choose which 
column to GROUP BY.  I have googled around.

SELECT p.si_id,s.food_store_id,s.gs_price, SUM(s.gs_price) AS total_price
FROM fsnep_food_store_purchases p, fsnep_food_store 
s,fsnep_food_store_game_info g
WHERE p.food_store_id = s.food_store_id
AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
GROUP BY p.si_id,s.food_store_id,s.gs_price

If I use all the columns listed in the SELECT, then I don't receive an error 
but it doesn't seem to be the type of SUM that I'm expecting.  For 15 records 
listing their price I receive:
0.60
0.60
0.60
0.69
0.69
0.89
0.99
1.39
1.39
1.39
1.39
0.79
0.79
0.79
0.79
total price:0.60

~|
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:211596
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: retrieve ID from db insert

[Aaron Rouse]

On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> 
> On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> >
> > How many times would it really matter if it did? I have seen sometimes
> > where
> > a "new app" would start off at say ID value of 143 just because of all 
> the
> > testing and not resetting the sequence never seemed to be an issue 
> though.
> 
> 
> I suppose if the seq value has some real meaning, yo umight need to fuss
> around with a way to ensure things are 'in sequence' so to speak. 
> Typically
> I could care less, the sequence is usually a PK and has no real meaning to
> the end user/gui. IIRC, there is no guarantee a numerical sequence in 
> Oracle
> is always one apart. You could get 1,2,3,4,10,11,20. That is what I've 
> been
> told at least.


When I have noticed this happening it usually ended up the trigger was setup 
with some caching. That is not to say it may or does happen in other 
situations. I too could really care less what the ID value is, not sure how 
many people out there really would care since never ran into a customer who 
did but I am sure there are many out there that do.


> If your SQL has only one insert, why use a transaction? Vacuously its
> considered a transaction I suppose. Further, if a single SQL fails in CF, 
> a
> commit is never issued for it. I have always understood transactions to be 
> a
> group of SQL statements that you want to execute in concert.


I was referring to a single insert statement followed by a single select 
statement to grad the ID of that inserted record, not just one insert and 
nothing more.


~|
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:211595
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: retrieve ID from db insert

[Douglas Knudsen]

On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> 
> How many times would it really matter if it did? I have seen sometimes 
> where
> a "new app" would start off at say ID value of 143 just because of all the
> testing and not resetting the sequence never seemed to be an issue though.


I suppose if the seq value has some real meaning, yo umight need to fuss 
around with a way to ensure things are 'in sequence' so to speak. Typically 
I could care less, the sequence is usually a PK and has no real meaning to 
the end user/gui. IIRC, there is no guarantee a numerical sequence in Oracle 
is always one apart. You could get 1,2,3,4,10,11,20. That is what I've been 
told at least.



Guess I just look at it differently, because the way I look at it is if the
> CFTRANSACTION is not going to hurt anything to be used then why the heck 
> not
> use it around even something so simple as the basic insert vs lots of
> inserts/updates. Seems like the only difference is one way saves you from
> typing the opening/closing transaction tags. But if less typing were the
> goal then I'd say the SP would lead to the least amount of typing, at 
> least
> within the CFM files.



If your SQL has only one insert, why use a transaction? Vacuously its 
considered a transaction I suppose. Further, if a single SQL fails in CF, a 
commit is never issued for it. I have always understood transactions to be a 
group of SQL statements that you want to execute in concert.


On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> >
> >
> > note a rollback does not effect sequences.
> >
> > DK
> >
> >
> 
> 
> 

~|
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:211594
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

Java class called from CF errors

[Taco Fleur]

I have a Java class that runs fine as an application with main(), but
when I call it form CF it errors, I made sure the right constructor is
called - I just cannot figure out what the difference is and why it
errors.

 

The error is:

There was an error reading the Input Stream. The error is Connection has
been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found

 

Any help is greatly appreciated.

 

/* Author: Taco Fleur ([EMAIL PROTECTED]) */

package edge;

import java.io.*;

import java.net.UnknownHostException;

import java.security.*;

import java.util.regex.Matcher;

import java.util.regex.Pattern;

 

import javax.net.ssl.*;

 

public class CFSSLTransportLayer

{

final String host = "edge.asic.gov.au";

final int port = 5608;

private static SSLSocket sslServerSocket;

static boolean debug = true;

final String keyStoreLocation ="C:\\Documents and
Settings\\Administrator\\.keystore";

final String password = "x";

final int socketTimeout = 6; // Set timeout to one
minute as per specs.

SSLSocketFactory factory;

PrintWriter pw;

BufferedReader in = null;

String error = "";

 

 

public CFSSLTransportLayer()

{

try

{

KeyStore myKeyStore =
KeyStore.getInstance( "JKS" );

myKeyStore.load( new
FileInputStream( keyStoreLocation ), password.toCharArray() );

TrustManagerFactory myTrustFactory =
TrustManagerFactory.getInstance( "SunX509", "SunJSSE" );

myTrustFactory.init( myKeyStore );

TrustManager[] myTrustManager =
myTrustFactory.getTrustManagers();

SSLContext ctx =
SSLContext.getInstance( "SSL" );

ctx.init( null, myTrustManager, null
);

factory = ctx.getSocketFactory();

}

catch ( Exception e )

{

String myError = "Error creating SSL
objects.";

System.err.println( myError );

setError( myError );

e.printStackTrace( System.out );

}

 

try

{

sslServerSocket = ( SSLSocket )
factory.createSocket( host, port );

// Set the timeout

sslServerSocket.setSoTimeout(
socketTimeout );

if ( debug )

{

System.out.println(
"*" );

System.out.println(
"***Secure socket made" );

System.out.println(
"*" );

System.out.println();

}

pw = new PrintWriter(
sslServerSocket.getOutputStream() );

}

catch ( UnknownHostException e )

{

String myError = "Unknown host.";

System.err.println( myError );

setError( myError );

}

catch ( java.net.SocketTimeoutException e )

{

String myError = "The Socket waited
" + socketTimeout / 1000 + " seconds for a response.";

System.err.println( myError );

setError( myError );

}

catch  ( IOException e )

{

String myError = "I/O Exception.";

System.err.println( myError );

setError( myError );

}

catch ( Exception e )

{

String myError = "An exception has occurred, error message:
" + e.getMessage();

System.err.println( myError );

setError( myError );

}

}

 



private void setError( String error )

{

this.error = this.error + error + "\n";

}



private String getError()

{

return this.error;

  

Re: Where is the web root stored?

[Matt Robertson]

Thanks.  We wound up finding an admin with more permissions than the
one I am working with and he squared us away.  I didn't have access to
the xml files, either.

-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com

~|
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:211592
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: Change AD password via LDAP/JNDI - HELP!!

[Dave Watts]

> The first thing that comes to mind is "permissions". When you 
> run it from the command line, what account are you using? Does 
> this account have permissions to change the password?
> 
> Then, what about ColdFusion?  Are you running the CF service(s) 
> with an account that has permission to change the password?

As a followup to these excellent suggestions, you might see if you can run
your Java class from CF via CFEXECUTE. This might help you diagnose whether
it's a permissions issue or something else.

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!


~|
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:211591
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: Data Binding Question

[Adam Haskell]

If you are trying to select a value in your dropdown based on the
input box vsomething like this should do the trick:

funtion correctSelect(inputBoxValue,selectBoxObject)
{
   var i=0;
 for(i;i wrote:
> I have a text box for client number and a drop down box for client name.
> 
> Using data binding, when you choose a client name from the drop down
> box, the client number is populated.
> 
> How can I make the drop down box move to the appropriate name when a
> clientnum is entered in the text box?
> 
> To summarize, If you enter or select a value in one control, I want the
> other control to automatically update. It works in one direction, but
> not the other.
> 
> TIA,
> Tim
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please delete it from 
> your system.
> 
> This footnote also confirms that this email message has been swept for
> the presence of computer viruses.
> 
> Thank You,
> Viahealth
> **
> 
> 
> 

~|
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:211590
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: retrieve ID from db insert

[S . Isaac Dealey]

Well that's not the only reason to avoid cftransaction where it's not
needed... You can't nest cftransactions, so if for some (who knows)
reason you found yourself needing to cfinclude two separate templates
within a cftransaction (or different method calls or whatever) you'd
get an error if the included template (or method call) has its own
cftransaction. Most of the time it's not an issue, and usually when it
does it's not a large issue, but it's something to consider.

> How many times would it really matter if it did? I have
> seen sometimes where
> a "new app" would start off at say ID value of 143 just
> because of all the
> testing and not resetting the sequence never seemed to be
> an issue though.
>  Guess I just look at it differently, because the way I
>  look at it is if the
> CFTRANSACTION is not going to hurt anything to be used
> then why the heck not
> use it around even something so simple as the basic insert
> vs lots of
> inserts/updates. Seems like the only difference is one way
> saves you from
> typing the opening/closing transaction tags. But if less
> typing were the
> goal then I'd say the SP would lead to the least amount of
> typing, at least
> within the CFM files.

>  On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]>
>  wrote:
>>
>>
>> note a rollback does not effect sequences.


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
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:211589
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: Query to text file.

[Jeff Waris]

Good point... 

Jeff


> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 11, 2005 4:44 PM
> To: CF-Talk
> Subject: Re: Query to text file.
> 
> 
> Jeff Waris wrote:
> > project. DTS also seems like trying to kill a fly with a 
> sledgehammer. 
> > So I was hoping a more simple solution could be found for a 
> plain text 
> > file dump.
> 
> considering your "fly" is choking your server to death, i 
> think you're 
> looking at this the wrong way.
> 
> 
> 

~|
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:211588
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: Another one for the RegEx-Gurus

[Ben Doom]

No worries.  Glad to be of service.

If you want more help with RegEx, I suggest subscribing to the HoF regex
list.  It's very low-traffic, but if you post a question, it WILL get
answered.  Sometimes in more detail than you actually needed!  And
everyone on it is happy to help you learn.

--Ben

Patric Stumpe wrote:
> Thanks Ben,
> 
> it really seems to work. Now I have to crawl the source html
> backwards and have a look at what happens :)
> 
> Thanks a lot!


~|
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:211587
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: Query to text file.

[Lee]

Speaking of DTS, the DTS on the new SQL 2005 looks pretty 
cool. The sledgehammer beta is out.

Lee Surma



On Mon, 11 Jul 2005 16:16:37 -0400
  Jeff Waris <[EMAIL PROTECTED]> wrote:
> I am running SQL7. I have actually thought about using 
>DTS to a text file
> but I would run into other issues that I don't want to 
>tackle for this
> project. DTS also seems like trying to kill a fly with a 
>sledgehammer. So I
> was hoping a more simple solution could be found for a 
>plain text file dump.
> 
> Jeff
> 
> 
>> -Original Message-
>> From: Paul Hastings [mailto:[EMAIL PROTECTED] 
>> Sent: Monday, July 11, 2005 4:20 PM
>> To: CF-Talk
>> Subject: Re: Query to text file.
>> 
>> 
>> > What is the best way to dump a HUGE query to a text 
>>file.
>> 
>> the db itself?
>> 
>> 
> 
> 

~|
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:211586
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: Query to text file.

[Paul Hastings]

Jeff Waris wrote:
> project. DTS also seems like trying to kill a fly with a sledgehammer. So I
> was hoping a more simple solution could be found for a plain text file dump.

considering your "fly" is choking your server to death, i think you're 
looking at this the wrong way.


~|
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:211585
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: retrieve ID from db insert

[Aaron Rouse]

How many times would it really matter if it did? I have seen sometimes where 
a "new app" would start off at say ID value of 143 just because of all the 
testing and not resetting the sequence never seemed to be an issue though.
 Guess I just look at it differently, because the way I look at it is if the 
CFTRANSACTION is not going to hurt anything to be used then why the heck not 
use it around even something so simple as the basic insert vs lots of 
inserts/updates. Seems like the only difference is one way saves you from 
typing the opening/closing transaction tags. But if less typing were the 
goal then I'd say the SP would lead to the least amount of typing, at least 
within the CFM files.

 On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: 
> 
> 
> note a rollback does not effect sequences.
> 
> DK
> 
>


~|
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:211584
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: Change AD password via LDAP/JNDI - HELP!!

[Dawson, Michael]

The first thing that comes to mind is "permissions".  When you run it
from the command line, what account are you using?  Does this account
have permissions to change the password?

Then, what about ColdFusion?  Are you running the CF service(s) with an
account that has permission to change the password?

What platform and what LDAP server are you using?

M!ke 

-Original Message-
From: Dimo Michailov [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 11, 2005 12:12 PM
To: CF-Talk
Subject: Change AD password via LDAP/JNDI - HELP!!

Hello all-

I have spent many sleepless nights on this one and I feel like I am
getting close to the solution, but I will need some help as my Java
experience is *very* limited.

I found some Java code that resets the AD password via LDAP/SSL. The
code works successfully and the password is changed when I compile it
with javac.exe and then execute it with java.exe. However, when I run
the same code via ColdFusion, I get message that the password has been
changed, but in fact it remains unchanges.

The setpass.java file is below. Again, once compiled into .class run
from the command line using "java -cp . setpass" the password change
works. However, if I run the same code via ColdFusion, I get a "success"
message in coldfusion-out.log but the password does not change.

Because it runs when executed via command line and doesn't seem to do
anything when called from ColdFusion, I am stumped. Can anyone please
help?



Execution code in ColdFusion,
=


zz = ArrayNew(1);
zz[1]="1";
zz[2]="2";
zz[3]="3";
x.main(zz);




setpass.java (placed in a classes path under CFMX7 tree)

import java.util.Hashtable;
import javax.naming.*;
import javax.naming.ldap.*;
import javax.naming.directory.*;
import java.io.*;
 
public class setpass
{
public static void main (String[] args)
{   
Hashtable env = new Hashtable();
String adminName = "CN=Cold Fusion AD
Manager,CN=Users,DC=subdomain,DC=domain,DC=domain";
String adminPassword = "myADadminPassword";
String userName = "CN=Test User To Have Password
Changes,OU=Test,DC=subdomain,DC=domain,DC=domain";
String newPassword = "newPassword12345";

String keystore =
"C:/CFusionMX7/runtime/jre/lib/security/cacerts";
System.setProperty("javax.net.ssl.trustStore",keystore);
 

env.put(Context.INITIAL_CONTEXT_FACTORY,"com.sun.jndi.ldap.LdapCtxFactor
y");
 
//set security credentials, note using simple cleartext
authentication
env.put(Context.SECURITY_AUTHENTICATION,"simple");
env.put(Context.SECURITY_PRINCIPAL,adminName);
env.put(Context.SECURITY_CREDENTIALS,adminPassword);
 
//specify use of ssl
env.put(Context.SECURITY_PROTOCOL,"ssl");

//connect to my domain controller
String ldapURL = "ldaps://law.georgetown.edu:636";
env.put(Context.PROVIDER_URL,ldapURL);

try {
 
// Create the initial directory context
LdapContext ctx = new
InitialLdapContext(env,null);

//set password is a ldap modfy operation
ModificationItem[] mods = new
ModificationItem[1];
 
//Replace the "unicdodePwd" attribute with a new
value
//Password must be both Unicode and a quoted
string
String newQuotedPassword = "\"" + newPassword +
"\"";
byte[] newUnicodePassword =
newQuotedPassword.getBytes("UTF-16LE");
 
mods[0] = new
ModificationItem(DirContext.REPLACE_ATTRIBUTE, new
BasicAttribute("unicodePwd", newUnicodePassword));
 
// Perform the update
ctx.modifyAttributes(userName, mods);

System.out.println("Reset Password for: " +
userName);  
ctx.close();
 
} 
catch (NamingException e) {
System.out.println("Problem resetting password:
" + e);
}
catch (UnsupportedEncodingException e) {
System.out.println("Problem encoding password: "
+ e);
}
}
}

~|
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://ww

RE: Query to text file.

[Jeff Waris]

I am running SQL7. I have actually thought about using DTS to a text file
but I would run into other issues that I don't want to tackle for this
project. DTS also seems like trying to kill a fly with a sledgehammer. So I
was hoping a more simple solution could be found for a plain text file dump.

Jeff


> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 11, 2005 4:20 PM
> To: CF-Talk
> Subject: Re: Query to text file.
> 
> 
> > What is the best way to dump a HUGE query to a text file.
> 
> the db itself?
> 
> 

~|
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:211582
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: retrieve ID from db insert

[Douglas Knudsen]

i see no reason to use it in Daniels case. once you get the next value from 
a sequence in Oracle, no other request will get that id. 

Now, if Daniel needed to perform several inserts, updates, etc in one 
request based on this id, then yes, by all means use cftransaction. In his 
case he had only one.

note a rollback does not effect sequences.

DK

On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> 
> Is there a reason to want to avoid using cftransaction?
> 
> On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> >
> > and you do not need cftansaction either. once query 1 executes, you have
> > the
> > id in hand. if another request came in it would get a differnt id. 
> simply
> > based on the uniqueness of the sequence.
> >
> > DK
> >
> >
> 
> 
> 

~|
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:211581
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: Query to text file.

[Paul Hastings]

> What is the best way to dump a HUGE query to a text file.

the db itself?

~|
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:211580
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: Another one for the RegEx-Gurus

[Patric Stumpe]

Thanks Ben,

it really seems to work. Now I have to crawl the source html
backwards and have a look at what happens :)

Thanks a lot!

Patric

> More or less.  I would probably skip the backreferences and rewrite the
> img tag from scratch, or specify which attributes I want to keep. But
> if you want to keep all additional attributes (style, alt, title, etc.)
> then you're right -- that'd be how to go about it.

> --Ben

> Patric Stumpe wrote:
>> Hi Ben,
>> 
>> thanks for the quick reply.
>> Am I right that I could embrace the different parts of that regex for
>> simple back-reference? I have to grab the complete URL of the
>> src-attribute (need to work with that a bit) and replace it with a
>> known string:
>> 
>> e.g.:
>> 
>> 
>> would lead to:
>> cid:inlineImage01"; height="25" width="20">
>> 
>> So something like that could work?
>> (]*src=")([^"]+)("[^>]*>)
>> 
>> => \1cid:inlineImage01\3
>> 
>> Patric
>> 
>> 
>>>Finding the img tags should be easy.  Replacing them with inline tags
>>>is, unfortunately, something I'm not familiar with.
>> 
>> 
>>>To find an img tag, you would look for something like this:
>>>]*src="[^"]+"[^>]*>
>> 
>> 
>>>Hopefully, someone can help with the other half (9/10ths?) of the problem.
>> 
>> 
>>>--Ben
>> 
>> 
>> 
>> 


> 

~|
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:211579
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: Query to text file.

[David Manriquez Farias]

Did you tried to pass the Query Object to CFX using request and  then loop
over the query using the Query object.. (both from com.allaire.cfx)

-Mensaje original-
De: Jeff Waris [mailto:[EMAIL PROTECTED] 
Enviado el: Monday, July 11, 2005 3:18 PM
Para: CF-Talk
Asunto: Query to text file.

What is the best way to dump a HUGE query to a text file.

There used to be a CFX tag long ago called CFX_dumptext that did this.  This
doesn't work on MX6.1. 

I have rolled my own with little success on extremely large queries. Each
works below on small queries just fine. In no particular order:

I've written each line to a text file each loop through the query.
I've written chunks of the query at a time.
I've written one large variable using cfsavecontent.

My problem is even with a JVM heap size of 1024 and my JVM arguments to
-XX:MaxPermSize=256m I still get the java.lang.OutOfMemoryError on the
write.

Anyone have an enlightenment?

Thanks,
Jeff




~|
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:211578
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

how to.... Java Exception passed to CF struct

[David Manriquez]

i've working on some CFX tags and could be if i can
 pass the Java Exception captured by try catch statement to CF using query or 
structs or something , but dont know how do it cause
 Exception getStackTrace() method return Throwable  and i cant see that in CF 
only in console... but cant run this class in console cause implements CustomTag


Coldfusion version : 5

Any ideas?...

~|
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:211577
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

how to.... Java Exception passed to CF struct

[David Manriquez]

i've working on some CFX tags and could be if i can
 pass the Java Exception captured by try catch statement to CF using query or 
structs or something , but dont know how do it cause
 Exception getStackTrace() method return Throwable  and i cant see that in CF 
only in console... but cant run this class in console cause implements CustomTag


Any ideas?...

~|
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:211576
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

Query to text file.

[Jeff Waris]

What is the best way to dump a HUGE query to a text file.

There used to be a CFX tag long ago called CFX_dumptext that did this.  This
doesn't work on MX6.1. 

I have rolled my own with little success on extremely large queries. Each
works below on small queries just fine. In no particular order:

I've written each line to a text file each loop through the query.
I've written chunks of the query at a time.
I've written one large variable using cfsavecontent.

My problem is even with a JVM heap size of 1024 and my JVM arguments to
-XX:MaxPermSize=256m I still get the java.lang.OutOfMemoryError on the
write.

Anyone have an enlightenment?

Thanks,
Jeff


~|
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:211575
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: Another one for the RegEx-Gurus

[Ben Doom]

More or less.  I would probably skip the backreferences and rewrite the
img tag from scratch, or specify which attributes I want to keep.  But
if you want to keep all additional attributes (style, alt, title, etc.)
then you're right -- that'd be how to go about it.

--Ben

Patric Stumpe wrote:
> Hi Ben,
> 
> thanks for the quick reply.
> Am I right that I could embrace the different parts of that regex for
> simple back-reference? I have to grab the complete URL of the
> src-attribute (need to work with that a bit) and replace it with a
> known string:
> 
> e.g.:
> 
> 
> would lead to:
> cid:inlineImage01"; height="25" width="20">
> 
> So something like that could work?
> (]*src=")([^"]+)("[^>]*>)
> 
> => \1cid:inlineImage01\3
> 
> Patric
> 
> 
>>Finding the img tags should be easy.  Replacing them with inline tags
>>is, unfortunately, something I'm not familiar with.
> 
> 
>>To find an img tag, you would look for something like this:
>>]*src="[^"]+"[^>]*>
> 
> 
>>Hopefully, someone can help with the other half (9/10ths?) of the problem.
> 
> 
>>--Ben
> 
> 
> 
> 


~|
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:211574
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: Another one for the RegEx-Gurus

[Patric Stumpe]

Hi Howie,

I did already solve that part. Manually geneerated messages are
properly sent. So now I (hopefully) only need to concentrate on that
replacment for the WYSIWYG-submitted mailbody.

Greets

Patric

> FYI - Even if you replace the source with a CID you still need to
> encode the image into the email using that same CID
> as a reference.

> Regards,

> Howie


-- 
Patric Stumpe
mailto:[EMAIL PROTECTED]



~|
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:211573
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 Scheduler - What if the server is down at the time of a scheduled event?

[Mosh Teitelbaum]

Thanks Mike.

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


Mike Chabot wrote:
> The scheduled event would be missed entirely.

Mosh Teitelbaum wrote:
> > Quick question concerning the CF Scheduler... what happens if the server
> > is down during the time when an event is scheduled to occur? Does the
> > Scheduler just ignore the event and wait until the next recurrence or
does
> > it fire the event whenever the server is restarted?



~|
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:211572
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: Another one for the RegEx-Gurus

[Howie Hamlin]

FYI - Even if you replace the source with a CID you still need to encode the 
image into the email using that same CID as a reference.

Regards,

Howie

--- On Monday, July 11, 2005 2:41 PM, Patric Stumpe scribed: ---
>
> Hi Ben,
> 
> thanks for the quick reply.
> Am I right that I could embrace the different parts of that regex for
> simple back-reference? I have to grab the complete URL of the
> src-attribute (need to work with that a bit) and replace it with a
> known string:
> 
> e.g.:
> 
> 
> would lead to:
> cid:inlineImage01"; height="25" width="20">
> 
> So something like that could work?
> (]*src=")([^"]+)("[^>]*>)
> 
> => \1cid:inlineImage01\3
> 
> Patric
> 

~|
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:211571
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: Another one for the RegEx-Gurus

[Patric Stumpe]

Hi Ben,

thanks for the quick reply.
Am I right that I could embrace the different parts of that regex for
simple back-reference? I have to grab the complete URL of the
src-attribute (need to work with that a bit) and replace it with a
known string:

e.g.:


would lead to:
cid:inlineImage01"; height="25" width="20">

So something like that could work?
(]*src=")([^"]+)("[^>]*>)

=> \1cid:inlineImage01\3

Patric

> Finding the img tags should be easy.  Replacing them with inline tags
> is, unfortunately, something I'm not familiar with.

> To find an img tag, you would look for something like this:
> ]*src="[^"]+"[^>]*>

> Hopefully, someone can help with the other half (9/10ths?) of the problem.

> --Ben



-- 
Patric Stumpe
mailto:[EMAIL PROTECTED]



~|
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:211570
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

Data Binding Question

[Claremont, Timothy]

I have a text box for client number and a drop down box for client name.

Using data binding, when you choose a client name from the drop down
box, the client number is populated.

How can I make the drop down box move to the appropriate name when a
clientnum is entered in the text box?

To summarize, If you enter or select a value in one control, I want the
other control to automatically update. It works in one direction, but
not the other.

TIA,
Tim

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
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:211569
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: Where is the web root stored?

[Steve Brownlee]

The location of the default web root depends on how you're set up.  For
instance, on Jboss, it's located in the file WEB-INF/jboss-web.xml.  If
you're running Jrun, it's in WEB-INF/jrun-web.xml.  However, the error
handlers are located in the WEB-INF/web.xml file.  You need to add an
 attribute after all of your servlet mappings. 

Here's an example


403;14
/index.cfm?site=lost


> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 11, 2005 1:15 PM
> To: CF-Talk
> Subject: Where is the web root stored?
> 
> There's an xml file that stores where the default web root is, right?
> 
> I need to install a site-wide error handler and I'm 
> confronted with a server admin who doesn't seem to know where 
> that is.  I know there's a way to pull it out but I haven't 
> found it offhand.
> 
> --
> --mattRobertson--
> Janitor, MSB Web Systems
> mysecretbase.com
> 
> 

~|
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:211568
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: Another one for the RegEx-Gurus

[Ben Doom]

Finding the img tags should be easy.  Replacing them with inline tags
is, unfortunately, something I'm not familiar with.

To find an img tag, you would look for something like this:
]*src="[^"]+"[^>]*>

Hopefully, someone can help with the other half (9/10ths?) of the problem.

--Ben

Patric Stumpe wrote:
> Hi folks,
> 
> i did already search the web and the archives but without any success.
> I'm trying to build a HTML-Email-Interface which runs on an old CF4.5.
> 
> The input and some parts of the processing are running quite fine. But
> now I'm stuck on the img-tags, where I have to replace the relative
> image-URL with inline-attached images. The building of the attachments
> works but I've no clue how to replace (or better find) the
> src-attribute of the img-tags to extract and replace them with the
> proper inline reference.
> 
> Hope that some of you can help me out with that one.
> 
> 
> Cheers,
> Patric
> 


~|
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:211567
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 Scheduler - What if the server is down at the time of a scheduled event?

[Mike Chabot]

The scheduled event would be missed entirely. 
 -Mike Chabot
 On 7/11/05, Mosh Teitelbaum <[EMAIL PROTECTED]> wrote: 
> 
> All:
> 
> Quick question concerning the CF Scheduler... what happens if the server 
> is
> down during the time when an event is scheduled to occur? Does the
> Scheduler just ignore the event and wait until the next recurrence or does
> it fire the event whenever the server is restarted?
> 
> TIA
> 
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 942-5378
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/


~|
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:211566
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

Another one for the RegEx-Gurus

[Patric Stumpe]

Hi folks,

i did already search the web and the archives but without any success.
I'm trying to build a HTML-Email-Interface which runs on an old CF4.5.

The input and some parts of the processing are running quite fine. But
now I'm stuck on the img-tags, where I have to replace the relative
image-URL with inline-attached images. The building of the attachments
works but I've no clue how to replace (or better find) the
src-attribute of the img-tags to extract and replace them with the
proper inline reference.

Hope that some of you can help me out with that one.


Cheers,
Patric

-- 
Patric Stumpe
mailto:[EMAIL PROTECTED]



~|
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:211565
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

CF Scheduler - What if the server is down at the time of a scheduled event?

[Mosh Teitelbaum]

All:

Quick question concerning the CF Scheduler... what happens if the server is
down during the time when an event is scheduled to occur?  Does the
Scheduler just ignore the event and wait until the next recurrence or does
it fire the event whenever the server is restarted?

TIA

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




~|
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:211564
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: retrieve ID from db insert

[Aaron Rouse]

Is there a reason to want to avoid using cftransaction?

On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: 
> 
> and you do not need cftansaction either. once query 1 executes, you have 
> the
> id in hand. if another request came in it would get a differnt id. simply
> based on the uniqueness of the sequence.
> 
> DK
> 
>


~|
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:211563
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: Depth of a tree?

[Eddie Awad]

> I have a hierarchical set of data stored in tree format.  The tree may or
> may not be a binary tree ... i.e. each node could have 0 thru N sub-nodes.
> Now, I need to calculate the length of the longest branch, or otherwise, the
> depth of the tree.  My comp. sci. days are a long way behind me, so does
> anybody know how this would be calculated?

Here is an example of how I would do it in Oracle (assuming you have
the tree stored in a table in an Oracle database):

create table t (
   parent varchar2(20)
   ,title varchar2(20)
   ,left number
   ,right number
)
/
insert into t values (
null, 'Food', 1, 18  
);
insert into t values (
'Food', 'Fruit', 2, 11  
);
insert into t values (
'Fruit', 'Red', 3, 6 
);
insert into t values (
'Red', 'Cherry', 4, 5  
);
insert into t values (
'Fruit', 'Yellow', 7, 10  
);
insert into t values (
'Yellow',  'Banana', 8, 9  
);
insert into t values (
'Food','Meat', 12, 17  
);
insert into t values (
'Meat' ,   'Beef', 13, 14  
);
insert into t values (
'Meat' ,   'Pork', 15 , 16  
);

select max(depth)
from (
  select level as depth from t
  connect by parent = prior title
  start with parent is null
)

The above query returns 4.
-- 
Eddie Awad.
http://awads.net/

~|
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:211562
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: retrieve ID from db insert

[Douglas Knudsen]

and you do not need cftansaction either. once query 1 executes, you have the 
id in hand. if another request came in it would get a differnt id. simply 
based on the uniqueness of the sequence.

DK

On 7/11/05, Greg Morphis <[EMAIL PROTECTED]> wrote:
> 
> Like Doug suggested, I've found the best way to do this is 2 queries..
> First
> 
> select game_id.nextval as id from dual
> 
> 
> Then store that value in a session variable or however you want to.
> Then you can use that to insert into different queries.
> 
> 
> 
> On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> > I have yet to see a way of doing this in Oracle/CFQUERY that works in 
> all
> > situations. Actually I have yet to see it work, but have heard of it 
> working
> > which is why I put "situations"
> >
> > On 7/11/05, Russ <[EMAIL PROTECTED]> wrote:
> > >
> > > Why not just do something like this (sql server)
> > >
> > > Insert into table (cols) values (values)
> > > select @@IDENTITY as maxid
> > >
> > >
> >
> >
> >
> 
> 

~|
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:211561
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: retrieve ID from db insert

[Russ]

How would the NOCOUNT setting affect the @@IDENTITY being returned?  Doesn't
seem like it from the sql docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
set-set_3ed0.asp

SET NOCOUNT
Stops the message indicating the number of rows affected by a Transact-SQL
statement from being returned as part of the results.

Syntax
SET NOCOUNT { ON | OFF } 

Remarks
When SET NOCOUNT is ON, the count (indicating the number of rows affected by
a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the
count is returned.

The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.

SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client
for each statement in a stored procedure. When using the utilities provided
with MicrosoftR SQL ServerT to execute queries, the results prevent "nn rows
affected" from being displayed at the end Transact-SQL statements such as
SELECT, INSERT, UPDATE, and DELETE.

For stored procedures that contain several statements that do not return
much actual data, this can provide a significant performance boost because
network traffic is greatly reduced.

The setting of SET NOCOUNT is set at execute or run time and not at parse
time.


-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 11, 2005 1:22 PM
To: CF-Talk
Subject: RE: retrieve ID from db insert

Sometimes you need to fiddle with the "NOCOUNT" setting to make it work
reliably.  It depends on how the SQL server is configured.

SET NOCOUNT ON

   Insert into table (cols) values (values)
   select @@IDENTITY as maxid

SET NOCOUNT OFF

This is especially true if you are updating more than 1 statement inside the
SQL block.

-mk

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 12:07 PM
To: CF-Talk
Subject: Re: retrieve ID from db insert


I always just use triggers for when inserting, but it seemed like the worry
here was to know the ID after the insert to I'd guess display to the user.
How would a trigger help for that need?

On 7/11/05, Eddie Awad <[EMAIL PROTECTED]> wrote:
>
>
> Of course, you could also just create a "when-insert" trigger on the
> table to automatically populate the id column so you do not have to
> worry about it in your "insert" statements.
> --
> Eddie Awad.
> http://awads.net/
>
>






~|
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:211560
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: isLocked()

[Dan G. Switzer, II]

Steve,

>
>context = createObject("java", "coldfusion.runtime.NeoPageContext");
>isLocked = context.getNamedLock();
>
>
>
>
>
>
><< put some code that meets a race condition here >>
>
>
>
>

Even if you can figure out any locked statements, you wouldn't be able to
use the syntax you had posted. You'd need to do:



... code ...


... same code ...


My guess is if you dig deep enough, you could find where in memory the locks
are stored, but I doubt it be worth the extra work to do whatever you're
trying to do.

-Dan



~|
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:211559
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: retrieve ID from db insert

[Mark A Kruger]

Sometimes you need to fiddle with the "NOCOUNT" setting to make it work
reliably.  It depends on how the SQL server is configured.

SET NOCOUNT ON

   Insert into table (cols) values (values)
   select @@IDENTITY as maxid

SET NOCOUNT OFF

This is especially true if you are updating more than 1 statement inside the
SQL block.

-mk

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 12:07 PM
To: CF-Talk
Subject: Re: retrieve ID from db insert


I always just use triggers for when inserting, but it seemed like the worry
here was to know the ID after the insert to I'd guess display to the user.
How would a trigger help for that need?

On 7/11/05, Eddie Awad <[EMAIL PROTECTED]> wrote:
>
>
> Of course, you could also just create a "when-insert" trigger on the
> table to automatically populate the id column so you do not have to
> worry about it in your "insert" statements.
> --
> Eddie Awad.
> http://awads.net/
>
>




~|
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:211558
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: retrieve ID from db insert

[Eddie Awad]

On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> I always just use triggers for when inserting, but it seemed like the worry
> here was to know the ID after the insert to I'd guess display to the user.
> How would a trigger help for that need?

The trigger won't help for that need. I was just stating an idea
because that's how I would do it. And by the way, I forgot to put a
"commit" after the "insert" in the example procedure in my previous
e-mail.
-- 
Eddie Awad.
http://awads.net/

~|
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:211557
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

Where is the web root stored?

[Matt Robertson]

There's an xml file that stores where the default web root is, right?

I need to install a site-wide error handler and I'm confronted with a
server admin who doesn't seem to know where that is.  I know there's a
way to pull it out but I haven't found it offhand.

-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com

~|
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:211556
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

Change AD password via LDAP/JNDI - HELP!!

[Dimo Michailov]

Hello all-

I have spent many sleepless nights on this one and I feel like I am
getting close to the solution, but I will need some help as my Java
experience is *very* limited.

I found some Java code that resets the AD password via LDAP/SSL. The
code works successfully and the password is changed when I compile it
with javac.exe and then execute it with java.exe. However, when I run
the same code via ColdFusion, I get message that the password has been
changed, but in fact it remains unchanges.

The setpass.java file is below. Again, once compiled into .class run
from the command line using "java -cp . setpass" the password change
works. However, if I run the same code via ColdFusion, I get a
"success" message in coldfusion-out.log but the password does not
change.

Because it runs when executed via command line and doesn't seem to do
anything when called from ColdFusion, I am stumped. Can anyone please
help?



Execution code in ColdFusion,
=


zz = ArrayNew(1);
zz[1]="1";
zz[2]="2";
zz[3]="3";
x.main(zz);




setpass.java (placed in a classes path under CFMX7 tree)

import java.util.Hashtable;
import javax.naming.*;
import javax.naming.ldap.*;
import javax.naming.directory.*;
import java.io.*;
 
public class setpass
{
public static void main (String[] args)
{   
Hashtable env = new Hashtable();
String adminName = "CN=Cold Fusion AD
Manager,CN=Users,DC=subdomain,DC=domain,DC=domain";
String adminPassword = "myADadminPassword";
String userName = "CN=Test User To Have Password
Changes,OU=Test,DC=subdomain,DC=domain,DC=domain";
String newPassword = "newPassword12345";

String keystore = 
"C:/CFusionMX7/runtime/jre/lib/security/cacerts";
System.setProperty("javax.net.ssl.trustStore",keystore);
 

env.put(Context.INITIAL_CONTEXT_FACTORY,"com.sun.jndi.ldap.LdapCtxFactory");
 
//set security credentials, note using simple cleartext 
authentication
env.put(Context.SECURITY_AUTHENTICATION,"simple");
env.put(Context.SECURITY_PRINCIPAL,adminName);
env.put(Context.SECURITY_CREDENTIALS,adminPassword);
 
//specify use of ssl
env.put(Context.SECURITY_PROTOCOL,"ssl");

//connect to my domain controller
String ldapURL = "ldaps://law.georgetown.edu:636";
env.put(Context.PROVIDER_URL,ldapURL);

try {
 
// Create the initial directory context
LdapContext ctx = new InitialLdapContext(env,null);

//set password is a ldap modfy operation
ModificationItem[] mods = new ModificationItem[1];
 
//Replace the "unicdodePwd" attribute with a new value
//Password must be both Unicode and a quoted string
String newQuotedPassword = "\"" + newPassword + "\"";
byte[] newUnicodePassword = 
newQuotedPassword.getBytes("UTF-16LE");
 
mods[0] = new 
ModificationItem(DirContext.REPLACE_ATTRIBUTE, new
BasicAttribute("unicodePwd", newUnicodePassword));
 
// Perform the update
ctx.modifyAttributes(userName, mods);

System.out.println("Reset Password for: " + userName);  
ctx.close();
 
} 
catch (NamingException e) {
System.out.println("Problem resetting password: " + e);
}
catch (UnsupportedEncodingException e) {
System.out.println("Problem encoding password: " + e);
}
}
}

~|
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:211555
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: retrieve ID from db insert

[Aaron Rouse]

I always just use triggers for when inserting, but it seemed like the worry 
here was to know the ID after the insert to I'd guess display to the user. 
How would a trigger help for that need?

On 7/11/05, Eddie Awad <[EMAIL PROTECTED]> wrote: 
> 
> 
> Of course, you could also just create a "when-insert" trigger on the
> table to automatically populate the id column so you do not have to
> worry about it in your "insert" statements.
> --
> Eddie Awad.
> http://awads.net/
> 
>


~|
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:211554
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: retrieve ID from db insert

[Aaron Rouse]

That syntax is invalid for Oracle.
 As far as SQL Server, I believe it is fine but I have watched a couple of 
debates on it via this mailing list so as with all things best to just 
research over taking someones word. :)

 On 7/11/05, Russ <[EMAIL PROTECTED]> wrote: 
> 
> This does work properly in SQL Server, right? I mean we haven't seen any
> issues, but I'd hate to think that we have a bug in our code...
> 
> Does the same syntax work in oracle? What kind of situations could cause
> this to not work properly?
> 
> Russ
> 
>


~|
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:211553
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: retrieve ID from db insert

[Greg Morphis]

Like Doug suggested, I've found the best way to do this is 2 queries.. 
First 

select game_id.nextval as id from dual


Then store that value in a session variable or however you want to.
Then you can use that to insert into different queries.



On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> I have yet to see a way of doing this in Oracle/CFQUERY that works in all
> situations. Actually I have yet to see it work, but have heard of it working
> which is why I put "situations"
> 
> On 7/11/05, Russ <[EMAIL PROTECTED]> wrote:
> >
> > Why not just do something like this (sql server)
> >
> > Insert into table (cols) values (values)
> > select @@IDENTITY as maxid
> >
> >
> 
> 
> 

~|
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:211551
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: Simple Directory Listing

[Jerry Johnson]

My bet as well would be that the cold fusion service does not have
access to those folders.

If you give the user that the cf service uses the proper rights, you
should be golden.

You might also want to look into ldap for a longer-term solution.

On 7/11/05, Claremont, Timothy <[EMAIL PROTECTED]> wrote:
> Thanks, Jerry,
> 
> I made a couple of syntax correction to your suggestion, but I get a
> "Connection Failure" on the result page.

~|
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:211552
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: retrieve ID from db insert

[Eddie Awad]

> I don't know SPs yet, but that's an interesting idea.  I'll have to look into 
> that when I get time.

Well, it's simple. Here is a working example of how you would do it in
Oracle using a stored procedure:

create table t (id number, colname varchar2(50))
/
create sequence t_seq
start with  1
increment by  1
minvalue  1
maxvalue  
/
create or replace procedure insert_into_t 
   (colname_in in t.colname%type, 
   id_out out t.id%type)
as
begin
   insert into t 
  (id, colname) 
   values 
  (t_seq.nextval, colname_in)
   returning id into id_out;
end;
/

Then in ColdFusion:






#id_out#

Of course, you could also just create a "when-insert" trigger on the
table to automatically populate the id column so you do not have to
worry about it in your "insert" statements.
-- 
Eddie Awad.
http://awads.net/

~|
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:211550
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: retrieve ID from db insert

[Russ]

This does work properly in SQL Server, right?  I mean we haven't seen any
issues, but I'd hate to think that we have a bug in our code...

Does the same syntax work in oracle? What kind of situations could cause
this to not work properly?

Russ 

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 11, 2005 11:45 AM
To: CF-Talk
Subject: Re: retrieve ID from db insert

I have yet to see a way of doing this in Oracle/CFQUERY that works in all 
situations. Actually I have yet to see it work, but have heard of it working

which is why I put "situations"

On 7/11/05, Russ <[EMAIL PROTECTED]> wrote: 
> 
> Why not just do something like this (sql server)
> 
> Insert into table (cols) values (values)
> select @@IDENTITY as maxid
> 
>




~|
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:211549
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

isLocked()

[Steve Brownlee]

I've been looking through many of the classes inside the ColdFusion Java
libraries trying to find something that would help me determine if the code
is currently inside a scoped or named lock.  Has anyone else run across
anything that relates to inspecting or determining lock status?

Basically, I want something like this.  Please don't ask why I want this...
you don't want to know.


context = createObject("java", "coldfusion.runtime.NeoPageContext");
isLocked = context.getNamedLock();






<< put some code that meets a race condition here >>





~|
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:211548
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: Simple Directory Listing

[Kerry]

Right, so Im assuming the webserver does not have access to the directory
and therefore you cant just use cfdirectory.

Some ideas:

Use frames

Use javascript to popup a window with no address bar

Setup a website with a home directory set to use that directory

Setup a share on the server e.g. so that users cant see the "real" share.
\\Viahealth08\Pharmacy\


-Original Message-
From: Claremont, Timothy [mailto:[EMAIL PROTECTED]
Sent: 11 July 2005 17:05
To: CF-Talk
Subject: RE: Simple Directory Listing


Thanks, Jerry,

I made a couple of syntax correction to your suggestion, but I get a
"Connection Failure" on the result page.

Note that if I merely copy and paste the URL into the browser it works
just fine, so I know I can "see" the URL.


Subject: Simple Directory Listing
From: Jerry Johnson <[EMAIL PROTECTED]>
Date: Mon, 11 Jul 2005 11:37:05 -0400
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid
=41104&forumid=4#211540

Crude, but...

  

then make a dir_listing.cfm page


 #cfhttp.fileContent#

Jerry Johnson







**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it
from your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**




~|
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:211547
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: Poor performing Oracle Query

[Ian Skinner]

I'm not sure.  As in the classic game of "phone," I probably have this wrong.  
But as I understood the explanation, the DBA thought the query was being 
restarted when new data was added to the underlying tables.  It seemed odd to 
me as well, but I'm just the web programmer.

Any the plan currently is to create views of this data that are updated nightly 
during a slow period.  Then use these views to create the summation data.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 09, 2005 1:44 AM
To: CF-Talk
Subject: Re: Poor performing Oracle Query

Ian Skinner wrote:
> Well we have more information on the problem.  The query that was
running fairly well at 30 seconds or so was being run against a
validation database where the data is static.
>
> The query that was performing poorly at 18 minutes was being run
against the production server where the data is very active.  Apparently
every time data was being added to the main tables, this query would be
started over.  So depending on the traffic sometime it performs
relatively well other times it performs very poorly.

That sounds rather vague. Does the DBA mean the database was
running out of rollback segments and instead of just returning an
error was somehow retrying the query?

Jochem



~|
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:211546
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: Query Problem.

[Jochem van Dieten]

James Smith wrote:
> 
> SELECT max(stockid) as stockid, data1, data2
> FROM   table
> HAVING data1 = 5
> 
> Unfortunately this is returning the following data
> 
> StockID | Data1 | Data2
> ---
> 3   | 5 | 2
> 
> Ie: the correct stockid and data1 but data2 from a diferent row!

The MySQL manual warns against that:
http://dev.mysql.com/doc/mysql/en/group-by-hidden-fields.html

They also document how it should be done:
http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html


> I have tried using a sub-query but it just crashes the server

Did you file a bug?


> (trying to do
> "WHERE StockID IN (over 7000 results from sub-query)".

> SELECTs.ItemID, s.ASIN, MAX(q.StockID) AS StockID, q.Condition,
> q.MaximumSalePrice, q.MinimumSalePrice, q.AddedToFile, q.CurrentAmazonPrice
> FROM  stockitemdetails s
>   JOIN stockquantities q ON (s.ItemID = q.ItemID)
> WHERE q.Quantity >  0
>   AND s.ASIN != ""
>   AND s.ASIN IS NOT NULL
>   AND s.ASIN != "N/A"
>   AND LEFT(s.ASIN,1) != "<"
> GROUP BY  s.ASIN
> HAVINGAddedToFile=  0
> ORDER BY  s.ItemID

Could you show us the query that would give the right results, 
but crashes your server? The result of this query is undetermined 
(which is why every database except MySQL will throw an error, 
MySQL will happily return the wrong answer) so it is a bit hard 
to suggest alternatives.

Jochem

~|
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:211545
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: Simple Directory Listing

[Claremont, Timothy]

Thanks, Jerry,

I made a couple of syntax correction to your suggestion, but I get a
"Connection Failure" on the result page.

Note that if I merely copy and paste the URL into the browser it works
just fine, so I know I can "see" the URL.


Subject: Simple Directory Listing
From: Jerry Johnson <[EMAIL PROTECTED]>
Date: Mon, 11 Jul 2005 11:37:05 -0400
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid
=41104&forumid=4#211540

Crude, but...

  

then make a dir_listing.cfm page

 
 #cfhttp.fileContent#

Jerry Johnson







**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
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:211544
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: Query Problem.

[James Smith]

> What RDBM are you using? Wouldn't this do it?
> 
> -- MySQL
> SELECT *
> FROM   table
> WHERE data1 = '5'
> ORDER BY DESC
> LIMIT 1

Unfortunately not.  If you view the larger query you will get a better idea,
and to explain the process...

The query returns about 7500 records. AddedToFile is a flag that is set by
this template from 0 (as shown in the query) to 1 (to indicate success).
While this template is running other things may reset this flag to 0 to
indicate a change to data, then once the program has finished it loops back
to the top and performs this query again, this time it should only receive
about 20-30 results (just the ones re-set).

If the "AddedToFile = 0" was moved from the HAVING section to the WHERE
section it would change the rows that were returned.

IE: if the data was such that the highest stockid had an addedtofile value
of 1, using HAVING means it is left out of the result set, moving it toe the
WHERE section would include the one below it instead which is not the
desired result.

Any other ideas?

BTW: It is MySQL 4.1.11-nt

--
Jay


~|
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:211543
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: retrieve ID from db insert

[Aaron Rouse]

I have yet to see a way of doing this in Oracle/CFQUERY that works in all 
situations. Actually I have yet to see it work, but have heard of it working 
which is why I put "situations"

On 7/11/05, Russ <[EMAIL PROTECTED]> wrote: 
> 
> Why not just do something like this (sql server)
> 
> Insert into table (cols) values (values)
> select @@IDENTITY as maxid
> 
>


~|
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:211542
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: retrieve ID from db insert

[Russ]

Why not just do something like this (sql server)

Insert into table (cols) values (values)
select @@IDENTITY as maxid

-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 11, 2005 11:32 AM
To: CF-Talk
Subject: Re: retrieve ID from db insert

I don't know SPs yet, but that's an interesting idea.  I'll have to look
into that when I get time.

>Or if you wanted to do it all in one "tag" you could just put it into a SP 
>and run it that way. There are of course various views as to the added 
>advantage of doing this, you can swearch through the list archives for all 
>of those. :)



~|
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:211541
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: Simple Directory Listing

[Jerry Johnson]

Crude, but...





then make a dir_listing.cfm page

 

#cfhttp.fileContent#

Jerry Johnson

On 7/11/05, Claremont, Timothy <[EMAIL PROTECTED]> wrote:
> I want to place a button on my form that brings up a directory listing.
> I am currently using the following method to merely open the directory
> on the end users machine:
> 
> 
> 
> 
> 
> This works great, but the manager wants the ADDRESS BAR in the new
> window to be hidden, so the 'not-computer-savvy' end users cannot see
> the real file locations.
> 
> I tried to make use of a javascript function that I found, but it does
> not seem to work without a http: address. I also tried a tree approach,
> but again, I must not be getting the syntax right for the directory.
> 
> Using CF7 on Win2k3
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please delete it from 
> your system.
> 
> This footnote also confirms that this email message has been swept for
> the presence of computer viruses.
> 
> Thank You,
> Viahealth
> **
> 
> 
> 

~|
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:211540
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: retrieve ID from db insert

[daniel kessler]

I don't know SPs yet, but that's an interesting idea.  I'll have to look into 
that when I get time.

>Or if you wanted to do it all in one "tag" you could just put it into a SP 
>and run it that way. There are of course various views as to the added 
>advantage of doing this, you can swearch through the list archives for all 
>of those. :)

~|
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:211539
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

FW: CF-Talk: Digest every hour

[RADEMAKERS Tanguy]

 first ooops:

> RETURNING ID
>  INTO newid;

should be

> RETURNING GI_ID
>  INTO newid;

(obviously)

/t

>-Original Message-
>From: RADEMAKERS Tanguy 
>Sent: Monday, July 11, 2005 5:19 PM
>To: 'cf-talk@houseoffusion.com'
>Subject: RE: CF-Talk: Digest every hour
>
>Hello,
>
>1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to 
>insert and one to get the value of the new ID.
>
>2) Write a stored procedure that returns the value of the 
>inserted id (see the SQL guide for the syntax of RETURNING INTO clause)
>
>start with this:
>
>CREATE OR REPLACE PROCEDURE insert_game (
>   fsnep_login  IN   VARCHAR2,
>   g_list   IN   VARCHAR2,
>   budget   IN   VARCHAR2,
>   the_monthIN   VARCHAR2,
>   the_num_people   IN   VARCHAR2,
>   the_weeksIN   VARCHAR2,
>   newidOUT  INT
>)
>AS
>BEGIN
>   INSERT INTO fsnep_food_store_game_info
>   (gi_id, login_id, date_added,
>date_modified, grocery_list, budget, MONTH, num_people,
>num_weeks
>   )
>VALUES (unique_food_store_game_info_s.NEXTVAL, 
>fsnep_login, SYSDATE,
>SYSDATE, g_list, budget, the_month, the_num_people,
>the_weeks
>   )
> RETURNING ID
>  INTO newid;
>EXCEPTION
>   WHEN OTHERS
>   THEN
>  ROLLBACK;
>  RAISE;
>END;
>/
>
>call it like this:
>datasource="[your_datasource_name]">
>   dbvarname="fsnep_login" value="#cookie.fsnep_login#" null="No">
>   dbvarname="g_list" value="#form.g_list#" null="No">
>   dbvarname="budget" value="#form.budget#" null="No">
>   dbvarname="the_month" value="#form.the_month#" null="No">
>   dbvarname="the_num_people" value="#form.the_num_people#" null="No">
>   dbvarname="the_weeks" value="#form.the_weeks#" null="No">
>   dbvarname="newid" variable="newid">
>
>
>and then do:
>
>
>
>
>/t
>
>ps: none of the above is tested.
>
>>-Original Message-
>>Subject: retrieve ID from db insert
>>From: Daniel Kessler <[EMAIL PROTECTED]>
>>Date: Mon, 11 Jul 2005 10:47:21 -0400
>>Thread: 
>>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>>&threadid=41103&forumid=4#211529
>>
>>I create a new game and insert it into my Oracle database.  From 
>>there I want to have the game ID and put it into a cookie. I've used 
>>NEXTVAL AND CURVAL for inserting the value into the db, but not for 
>>any external use, like my insert into a cookie.  I guess I can do a 
>>CFLock and then do a query after the insert for the last inserted 
>>item, but is that the best way?
>>
>>Here's the insert:
>>
>>
>>  INSERT INTO fsnep_food_store_game_info
>> (
>> gi_id,login_id,
>> date_added,date_modified,
>> grocery_list,budget,
>> month,num_people,
>> num_weeks
>> )
>>  VALUES
>> (
>> unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#,
>> SYSDATE,SYSDATE,
>> >cfsqltype="cf_sql_varchar">,>cfsqltype="cf_sql_varchar">,
>> >cfsqltype="cf_sql_varchar">,>value="#form.the_num_people#" cfsqltype="cf_sql_varchar">,
>> >cfsqltype="cf_sql_varchar">
>> 
>> )
>>
>>
>>
>>
>>thanks for any help.
>>
>>-- 
>>Daniel Kessler
>>
>>Department of Public and Community Health
>>University of Maryland
>>Suite 2387 Valley Drive
>>College Park, MD  20742-2611
>>301-405-2545 Phone
>>www.phi.umd.edu
>

~|
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:211538
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: retrieve ID from db insert

[daniel kessler]

thanks everyone for your help!

>search the archives, this has been discussed several times here. In short, 
>do two queries. query 1, get the next val in your sequence. now you have 
>your id in hand. query 2, do your insert using the id. do whatever you want 
>with the id.

~|
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:211537
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: retrieve ID from db insert

[Aaron Rouse]

Or if you wanted to do it all in one "tag" you could just put it into a SP 
and run it that way. There are of course various views as to the added 
advantage of doing this, you can swearch through the list archives for all 
of those. :)

On 7/11/05, daniel kessler <[EMAIL PROTECTED]> wrote: 
> 
> ok, this actually answers my question of how to assure that the 2nd query 
> actually returns the correct id and not allow another to be inserted until I 
> have it. That was my worry.
> 
> Thanks!
> 
> >In reference to the first email, you would do a CFTRANSACTION and not a
> >CFLOCK.
> 
>


~|
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:211536
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: retrieve ID from db insert

[daniel kessler]

ok, this actually answers my question of how to assure that the 2nd query 
actually returns the correct id and not allow another to be inserted until I 
have it.  That was my worry.

Thanks!

>In reference to the first email, you would do a CFTRANSACTION and not a 
>CFLOCK.

~|
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:211535
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-Talk: Digest every hour

[RADEMAKERS Tanguy]

Hello,

1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to insert and
one to get the value of the new ID.

2) Write a stored procedure that returns the value of the inserted id
(see the SQL guide for the syntax of RETURNING INTO clause)

start with this:

CREATE OR REPLACE PROCEDURE insert_game (
   fsnep_login  IN   VARCHAR2,
   g_list   IN   VARCHAR2,
   budget   IN   VARCHAR2,
   the_monthIN   VARCHAR2,
   the_num_people   IN   VARCHAR2,
   the_weeksIN   VARCHAR2,
   newidOUT  INT
)
AS
BEGIN
   INSERT INTO fsnep_food_store_game_info
   (gi_id, login_id, date_added,
date_modified, grocery_list, budget, MONTH, num_people,
num_weeks
   )
VALUES (unique_food_store_game_info_s.NEXTVAL, fsnep_login,
SYSDATE,
SYSDATE, g_list, budget, the_month, the_num_people,
the_weeks
   )
 RETURNING ID
  INTO newid;
EXCEPTION
   WHEN OTHERS
   THEN
  ROLLBACK;
  RAISE;
END;
/

call it like this:










and then do:




/t

ps: none of the above is tested.

>-Original Message-
>Subject: retrieve ID from db insert
>From: Daniel Kessler <[EMAIL PROTECTED]>
>Date: Mon, 11 Jul 2005 10:47:21 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41103&forumid=4#211529
>
>I create a new game and insert it into my Oracle database.  From 
>there I want to have the game ID and put it into a cookie. I've used 
>NEXTVAL AND CURVAL for inserting the value into the db, but not for 
>any external use, like my insert into a cookie.  I guess I can do a 
>CFLock and then do a query after the insert for the last inserted 
>item, but is that the best way?
>
>Here's the insert:
>
>
>  INSERT INTO fsnep_food_store_game_info
> (
> gi_id,login_id,
> date_added,date_modified,
> grocery_list,budget,
> month,num_people,
> num_weeks
> )
>  VALUES
> (
> unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#,
> SYSDATE,SYSDATE,
> cfsqltype="cf_sql_varchar">,cfsqltype="cf_sql_varchar">,
> cfsqltype="cf_sql_varchar">,value="#form.the_num_people#" cfsqltype="cf_sql_varchar">,
> cfsqltype="cf_sql_varchar">
> 
> )
>
>
>
>
>thanks for any help.
>
>-- 
>Daniel Kessler
>
>Department of Public and Community Health
>University of Maryland
>Suite 2387 Valley Drive
>College Park, MD  20742-2611
>301-405-2545 Phone
>www.phi.umd.edu

~|
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:211534
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

Simple Directory Listing

[Claremont, Timothy]

I want to place a button on my form that brings up a directory listing.
I am currently using the following method to merely open the directory
on the end users machine:





This works great, but the manager wants the ADDRESS BAR in the new
window to be hidden, so the 'not-computer-savvy' end users cannot see
the real file locations.

I tried to make use of a javascript function that I found, but it does
not seem to work without a http: address. I also tried a tree approach,
but again, I must not be getting the syntax right for the directory.

Using CF7 on Win2k3

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
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:211533
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: retrieve ID from db insert

[Aaron Rouse]

In reference to the first email, you would do a CFTRANSACTION and not a 
CFLOCK.

On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: 
> 
> search the archives, this has been discussed several times here. In short,
> do two queries. query 1, get the next val in your sequence. now you have
> your id in hand. query 2, do your insert using the id. do whatever you 
> want
> with the id.
> 
> DK
> 
>


~|
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:211532
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: Query Problem.

[Kevin Aebig]

What RDBM are you using? Wouldn't this do it?

-- MySQL
SELECT *
FROM   table
WHERE data1 = '5'
ORDER BY DESC
LIMIT 1

-- SQLServer
SELECT Top 1 *
FROM   table
WHERE data1 = '5'
ORDER BY DESC

- Original Message - 
From: "James Smith" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, July 11, 2005 8:09 AM
Subject: Query Problem.


>I have a problem I am sure is simple to solve but it has proved to be 
>beyond
> me.
>
> Imagine I have the following data...
>
> StockID | Data1 | Data2
> ---
> 1   | 1 | 2
> 2   | 3 | 4
> 3   | 5 | 6
>
> And I want a query to return
>
> StockID | Data1 | Data2
> ---
> 3   | 5 | 6
>
> I am trying to use
>
> SELECT max(stockid) as stockid, data1, data2
> FROM   table
> HAVING data1 = 5
>
> Unfortunately this is returning the following data
>
> StockID | Data1 | Data2
> ---
> 3   | 5 | 2
>
> Ie: the correct stockid and data1 but data2 from a diferent row!
>
> I have tried using a sub-query but it just crashes the server (trying to 
> do
> "WHERE StockID IN (over 7000 results from sub-query)".
>
> I am using MySQL and the actual query in question is below for your ref...
>
> SELECTs.ItemID, s.ASIN, MAX(q.StockID) AS StockID, q.Condition,
> q.MaximumSalePrice, q.MinimumSalePrice, q.AddedToFile, 
> q.CurrentAmazonPrice
> FROM  stockitemdetails s
>  JOIN stockquantities q ON (s.ItemID = q.ItemID)
> WHERE q.Quantity >  0
>  AND s.ASIN != ""
>  AND s.ASIN IS NOT NULL
>  AND s.ASIN != "N/A"
>  AND LEFT(s.ASIN,1) != "<"
> GROUP BY  s.ASIN
> HAVINGAddedToFile=  0
> ORDER BY  s.ItemID
>
> --
> Jay
>
>
> 

~|
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:211531
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: retrieve ID from db insert

[Douglas Knudsen]

search the archives, this has been discussed several times here. In short, 
do two queries. query 1, get the next val in your sequence. now you have 
your id in hand. query 2, do your insert using the id. do whatever you want 
with the id.

DK

On 7/11/05, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> 
> I create a new game and insert it into my Oracle database. From
> there I want to have the game ID and put it into a cookie. I've used
> NEXTVAL AND CURVAL for inserting the value into the db, but not for
> any external use, like my insert into a cookie. I guess I can do a
> CFLock and then do a query after the insert for the last inserted
> item, but is that the best way?
> 
> Here's the insert:
> 
> 
> INSERT INTO fsnep_food_store_game_info
> (
> gi_id,login_id,
> date_added,date_modified,
> grocery_list,budget,
> month,num_people,
> num_weeks
> )
> VALUES
> (
> unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#,
> SYSDATE,SYSDATE,
>  cfsqltype="cf_sql_varchar">, cfsqltype="cf_sql_varchar">,
>  cfsqltype="cf_sql_varchar">, value="#form.the_num_people#" cfsqltype="cf_sql_varchar">,
> 
> 
> )
> 
> 
> 
> 
> thanks for any help.
> 
> --
> Daniel Kessler
> 
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD 20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu 
> 
> 

~|
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:211530
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

retrieve ID from db insert

[Daniel Kessler]

I create a new game and insert it into my Oracle database.  From 
there I want to have the game ID and put it into a cookie. I've used 
NEXTVAL AND CURVAL for inserting the value into the db, but not for 
any external use, like my insert into a cookie.  I guess I can do a 
CFLock and then do a query after the insert for the last inserted 
item, but is that the best way?

Here's the insert:


  INSERT INTO fsnep_food_store_game_info
 (
 gi_id,login_id,
 date_added,date_modified,
 grocery_list,budget,
 month,num_people,
 num_weeks
 )
  VALUES
 (
 unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#,
 SYSDATE,SYSDATE,
 ,,
 ,,
 
 
 )




thanks for any help.

-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu

~|
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:211529
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: Poor performing Oracle Query

[RADEMAKERS Tanguy]

Hello,

I've never heard of oracle "restarting" a query because the underlying
data had changed. Oracle uses a multi-version view of data to show you
results consistent with what the database looked like at the start of
the query (at the very least - it can also do "consistent with the start
of the transaction"): if a row has been changed since the query started
then oracle will read the "old" value from rollback and use it in the
query. If you are executing a long running select query and making lots
of modifications to the underlying database at the same time, oracle
will eventually need to read info from a rollback segment that has been
flushed to disk and you will get the dreaded ORA 01555 error (snapshot
too old)... but Oracle won't restart the query. Of course, you could
have written your query in some kind of try-catch block (in either cf or
pl/sql) that just repeats whenver this error comes up, but i assume you
would have mentioned it.

Step 0 (if possible): export your live schema and import it to your
testing environment. You won't be able to recreate usage but you will
have "realistic" data.

The very first thing to do in investigating why this query takes so much
more time to execute in production than in development is to make sure
that you are comparing apples to apples: ie run the query using
coldfusion against both databases, and run the query using sql*plus
against both databases and check the results. In the past, i've seen
queries that ran much slower in cf than in TOAD because cf needed all
the results before it could return whereas TOAD only needed the first
rows. If your query returns a lot of records this is something to check
earlier rather than later.

If you see that the same query run from the same client still takes a
huge amount more time on the production database then the next step is
to do an EXPLAIN PLAN on both databases and make sure that the results
are identical. If they aren't, then ask yourself why not: different
volumes of data, lack of table stats in one of the databases, user
resource limitation, etc. 

Finally, if the plans are the same and the query is still taking
waay more time in production, then you need to turn on tracing and
use the tkprof utility to see exactly what is being done. This will slow
down your live db even more but will give you the definitive answer as
to what is happening in the db. 

/t

>-Original Message-
>Subject: Poor performing Oracle Query
>From: Dustin Tinney <[EMAIL PROTECTED]>
>Date: Sun, 10 Jul 2005 11:27:56 -0400
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41091&forumid=4#211507
>
>Does your query select any clob or blob data? 
>
>On 7/9/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>> Ian Skinner wrote:
>> > Well we have more information on the problem.  The query 
>that was running fairly well at 30 seconds or so was being run 
>against a validation database where the data is static.
>> >
>> > The query that was performing poorly at 18 minutes was 
>being run against the production server where the data is very 
>active.  Apparently every time data was being added to the 
>main tables, this query would be started over.  So depending 
>on the traffic sometime it performs relatively well other 
>times it performs very poorly.
>> 
>> That sounds rather vague. Does the DBA mean the database was
>> running out of rollback segments and instead of just returning an
>> error was somehow retrying the query?
>> 
>> Jochem

~|
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:211528
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

Query Problem.

[James Smith]

I have a problem I am sure is simple to solve but it has proved to be beyond
me.

Imagine I have the following data...

StockID | Data1 | Data2
---
1   | 1 | 2
2   | 3 | 4
3   | 5 | 6

And I want a query to return

StockID | Data1 | Data2
---
3   | 5 | 6

I am trying to use

SELECT max(stockid) as stockid, data1, data2
FROM   table
HAVING data1 = 5

Unfortunately this is returning the following data

StockID | Data1 | Data2
---
3   | 5 | 2

Ie: the correct stockid and data1 but data2 from a diferent row!

I have tried using a sub-query but it just crashes the server (trying to do
"WHERE StockID IN (over 7000 results from sub-query)".

I am using MySQL and the actual query in question is below for your ref...

SELECTs.ItemID, s.ASIN, MAX(q.StockID) AS StockID, q.Condition,
q.MaximumSalePrice, q.MinimumSalePrice, q.AddedToFile, q.CurrentAmazonPrice
FROM  stockitemdetails s
  JOIN stockquantities q ON (s.ItemID = q.ItemID)
WHERE q.Quantity >  0
  AND s.ASIN != ""
  AND s.ASIN IS NOT NULL
  AND s.ASIN != "N/A"
  AND LEFT(s.ASIN,1) != "<"
GROUP BY  s.ASIN
HAVINGAddedToFile=  0
ORDER BY  s.ItemID

--
Jay


~|
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:211527
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: Using FSO with CF

[Michel Deloux]

Thanx S. Isaac Dealey... Sun... i'll be there... ;-)

Cheers.

MD

2005/7/11, S. Isaac Dealey <[EMAIL PROTECTED]>:
> > Thank you S. Isaac... I'll be change our code to
> > Java.io.File
> > routines... Do you have any example about? Tutorials, how
> > to use that
> > Java classes?
> 
> > Thanks once more again.
> 
> Welcome,
> 
> I just read the API documentation on the sun site myself...
> 
> http://java.sun.com/j2se/1.4.2/docs/api/java/io/package-summary.html
> 
> java.io.File will handle basic file information (does it exist, is it
> a file, when was it modified, etc) ... to actually write files you
> need to use a couple other classes, in particular FileWriter and
> FileOutputStream -- you may also need an OutputStreamWriter. I'd
> expect you can probably come up with a tutorial or two by googling
> "java.io.FileWriter" or "java.io.FileOutputStream".
> 
> 
> s. isaac dealey 954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 

~|
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:211526
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: CFMX7 Integration with J2EE - How complete is the integration?

[Chris Norloff]

One possibility for "using CFMX Admin" is to not use the CFMX Admin GUI. You 
can edit the neo*.xml files then deploy them to configure CFMX, without using 
the CFMX Admin GUI. 

We did this on a WebSphere cluster because the CFMX Admin settings won't 
progagate across the cluster. However, a script can push the neo*.xml files out 
quite easily.

Chris Norloff


-- Original Message --
From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date:  Thu, 30 Jun 2005 16:43:51 -0400

>All:
>
>Thanks for the replies.
>
>I don't think the admin is a "CFMX hater," just someone who has enough on
>his hands managing their WebLogic boxes without having to learn another
>management interface (the CF Admin).  And, as someone who wishes he had more
>free time on his hands, I can't find fault with that.
>
>While I get the distinction between "pure" Java and an appserver-specific
>extension, I think I had been expecting a bit more in terms of deploying
>CFMX7 apps on J2EE servers.  I think it was back in February that BF wrote a
>CFDJ article basically saying that J2EE server admins would no longer have
>to jump through hoops to deploy CFMX7 apps.  Having read the document at the
>URL that Robert provided, I'm not sure that's entirely accurate.
>
>--
>Mosh Teitelbaum
>evoch, LLC
>Tel: (301) 942-5378
>Fax: (301) 933-3651
>Email: [EMAIL PROTECTED]
>WWW: http://www.evoch.com/
>
>
>> -Original Message-
>> From: Robert Munn [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, June 30, 2005 2:42 PM
>> To: CF-Talk
>> Subject: CFMX7 Integration with J2EE - How complete is the integration?
>>
>>
>> Technically, I believe your client's admin is correct. Take a
>> look at this page on installing CFMX 7 in J2EE mode with WebLogic.
>>
>> http://www.macromedia.com/support/coldfusion/j2ee/cfmx7j2ee_weblog
>> ic_deploy.html
>>
>> One component of ColdFusion is a J2EE servlet application that
>> compiles CFML into JSP files and executes them. That part of
>> ColdFusion could be called "pure Java". ColdFusion also contains
>> other components- the ODBC services and the Search service, for
>> instance, which are not pure Java- they aren't even Java at all.
>>
>> My re-collection from a conversation a couple of years ago at MAX
>> was that Macromedia was thinking about putting out a "pure J2EE"
>> implementation of ColdFusion without the non-Java components- an
>> edition that would deploy and run on any J2EE server on any
>> platform. I don't know if that plan ever came to fruition; I
>> don't see it listed as a product edition on the Macromedia site.
>>
>> Rob
>>
>> >All:
>> >
>> >I have a client that, for reasons that much matter, wants to move one of
>> >their CF apps to a J2EE server (running BEA WebLogic).  The server's
>> >administrator is adamant that only "pure" J2EE applications may
>> be deployed
>> >on this server.
>> >
>> >My understanding of CFMX7's capabilities with this respect is that the
>> >EAR/WAR files it creates are "pure."  However, the admin says
>> that CF still
>> >doesn't natively integrate with BEA's management console.
>> >
>> >So, what's the deal?  Does CFMX7 offer "true" integration or just better
>> >integration that its predecessor?
>> >
>> >TIA
>> >
>> >--
>> >Mosh Teitelbaum
>> >evoch, LLC
>> >Tel: (301) 942-5378
>> >Fax: (301) 933-3651
>> >Email: [EMAIL PROTECTED]
>> >WWW: http://www.evoch.com/
>>
>> 
>
>

~|
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:211525
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: CFMX7 Integration with J2EE - How complete is the integration?

[Chris Norloff]

CFMX *is* Java

In fact, it's Sun-certified J2EE compliant. That's pretty pure.


Chris Norloff


-- Original Message --
From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date:  Thu, 30 Jun 2005 14:17:36 -0400

>All:
>
>I have a client that, for reasons that much matter, wants to move one of
>their CF apps to a J2EE server (running BEA WebLogic).  The server's
>administrator is adamant that only "pure" J2EE applications may be deployed
>on this server.
>
>My understanding of CFMX7's capabilities with this respect is that the
>EAR/WAR files it creates are "pure."  However, the admin says that CF still
>doesn't natively integrate with BEA's management console.
>
>So, what's the deal?  Does CFMX7 offer "true" integration or just better
>integration that its predecessor?
>
>TIA
>
>--
>Mosh Teitelbaum
>evoch, LLC
>Tel: (301) 942-5378
>Fax: (301) 933-3651
>Email: [EMAIL PROTECTED]
>WWW: http://www.evoch.com/
>
>
>
>

~|
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:211524
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: Creating a breadcrumb trail

[Jerry Johnson]

Do you mean a true breadcrumb trail (a clicktrace, or where the user
has been) or do you mean a page heirarchy, or a drilldown path?

(page heirarchy)
Site: Section: Subsection: Page

(drilldown path)
Home: Books: Family Law: Probate and Family Court Handbook

(clicktrace)
Home: Top Stories: Home: Signup: Thanks for Subscribing

(step list)
Step 1 Basic Info | Step 2 Payment Info | [Step 3 Confirmation]

On 7/11/05, Larry Lyons <[EMAIL PROTECTED]> wrote:
> > I was trying to think of a good way to create a breadcrumb trail for
> > my users as they navigate through my app. The first thing that comes
> > to mind is setting a session variable in onRequestStart in App.cfc.
> > Then using that to create the links.

~|
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:211523
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: Using FSO with CF

[S . Isaac Dealey]

> Thank you S. Isaac... I'll be change our code to
> Java.io.File
> routines... Do you have any example about? Tutorials, how
> to use that
> Java classes?

> Thanks once more again.

Welcome,

I just read the API documentation on the sun site myself...

http://java.sun.com/j2se/1.4.2/docs/api/java/io/package-summary.html

java.io.File will handle basic file information (does it exist, is it
a file, when was it modified, etc) ... to actually write files you
need to use a couple other classes, in particular FileWriter and
FileOutputStream -- you may also need an OutputStreamWriter. I'd
expect you can probably come up with a tutorial or two by googling
"java.io.FileWriter" or "java.io.FileOutputStream".


s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
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:211522
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

Creating a breadcrumb trail

[Larry Lyons]

> I was trying to think of a good way to create a breadcrumb trail for 
> my users as they navigate through my app. The first thing that comes 
> to mind is setting a session variable in onRequestStart in App.cfc. 
> Then using that to create the links. 
> 
> Could someone expand on this? Or offer a better solution? I'm looking 
> for somethin' simple. Remember, it's Will here.  :)
> 
> Thanks,
> Will

Will there's a UDF at CFLib.org that does breadcrumb links

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

hth,
larry

~|
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:211521
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: Using FSO with CF

[Michel Deloux]

Thank you S. Isaac... I'll be change our code to Java.io.File
routines... Do you have any example about? Tutorials, how to use that
Java classes?

Thanks once more again.

MD

2005/7/7, S. Isaac Dealey <[EMAIL PROTECTED]>:
> > Thanks S. Isaac Dealey
> 
> > Yes. I need to use FSO with CF(CreateObject). But what I
> > need to setup
> > in our Win2003 Server. With Java I'll get best results?
> 
> > Thanx once more again.
> 
> I would expect the java classes like java.io.File to be more efficient
> when using ColdFusion version 6.1 or later. (On version 5 the windows
> scripting object might be more efficient.) But asside from efficiency,
> the java classes are more portable since they can be used on any CF
> app platform, whether that's windows, linux, solaris or some
> unsupported JBoss instance on a SCO Unix machine. Reflection of the
> java classes when using ColdFusion 6.1 or later is amazingly efficient
> in and of itself when you're not relying on the CF native tags like
> cfdirectory which returns a bunch of information you may or may not
> need / want about the collection of files in your directory.
> Cfdirectory is great for the sake of simplicity, but if you really
> need performance, digging out the underlying java classes is the way
> to go.
> 
> 
> s. isaac dealey   954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 
> 
> 

~|
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:211520
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: Coldfusion Switch Error - Hex Characters

[Kerry]

Thats an interesting bug! heres a sorta workaround:



function Hex7toStr(Char){
var newchar = "";
var asciiChar = "";
var i=0;

for(i=1;i lte len(char);i=i+1){
asciiChar = asciiChar&asc(mid(char,i,1));
}

switch (asciiChar)
{
case asc("0")&asc("0"):
newchar = "NUL";
break;
case asc("0")&asc("A"):
newchar = "LF";
break;
}
return newchar;
}




00:#Hex7toStr("00")#
0A:#Hex7toStr("0A")#



-Original Message-
From: AFM [mailto:[EMAIL PROTECTED]
Sent: 08 July 2005 17:39
To: CF-Talk
Subject: Coldfusion Switch Error - Hex Characters


Hello,

I have an odd error with a piece of code I'm migrating from CF5 to
MX6.1.  It is a simple switch statement that takes Hex7 values as a
string and spits out the ascii equivilent as a string.

Problem is, it is reading hex value '00' and '0A' as the same thing,
and returns a duplicate value error for 0.0.  I've tried chr codes,
changing it to IF statements, and more.  I was hoping an expert could
look at it and give me a hint to a fix.  Below is a small snippet of
the overall code.  Thanks.


function Hex7toStr(Char){
switch (Char)
{
case "00":
newchar = "NUL";
break;
case "0A":
newchar = "LF";
break;
case "30":
newchar = "0";
break;
case "41":
newchar = "A";
break;
case "EB":
newchar = "a";
break;
}
return Trim(newchar);
}















#hexChar1##hexStr1#
#hexChar2##hexStr2#
#hexChar3##hexStr3#
#hexChar4##hexStr4#
#hexChar5##hexStr5#





~|
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:211519
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