Re: Flex3 and CF 8 connection problem

[Mike Chabot]

Quick questions.
1. Are you running CF 8.0.0 or 8.0.1
2. What do you get when you enter that URL in the error message
directly into your Web browser. Do you get a blank white page or
something else?
3. Is your CFC set to allow for remote access
4. Is Flex Remoting turned on inside of CF Admin?

What are some of the things you have tried so far that didn't work?

-Mike Chabot

On Fri, May 2, 2008 at 8:22 PM,  <[EMAIL PROTECTED]> wrote:
> Hi list,
> I try to get Flex3 to get to be working
> with CF8 and I can't figure out, why it is not working.
> I get:
>
>  faultCode = "Client.Error.MessageSend"
>  faultDetail = "Channel.Connect.Failed error
>  NetConnection.Call.Failed: HTTP: Failed: url: 
> 'http://www.abc.com/flex2gateway/'"
>  faultString = "Send failed"
>
> I google around tons of hints, but nothing worked.
> S.O. who knows how to get it to run under Win2k and IIS 6.x ?
>
> Uwe
>
>
>
>
>
> 

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

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

Flex3 and CF 8 connection problem

[cf-talk]

Hi list,
I try to get Flex3 to get to be working
with CF8 and I can't figure out, why it is not working.
I get:

  faultCode = "Client.Error.MessageSend"
  faultDetail = "Channel.Connect.Failed error
  NetConnection.Call.Failed: HTTP: Failed: url: 
'http://www.abc.com/flex2gateway/'"
  faultString = "Send failed"

I google around tons of hints, but nothing worked.
S.O. who knows how to get it to run under Win2k and IIS 6.x ?

Uwe





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

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

Re: Extending Application.cfc using mappings

[Geoff Bowers]

2008/5/3 marc -- <[EMAIL PROTECTED]>:
>  I googled and found this on 
> http://groups.google.com/group/farcry-beta/browse_thread/thread/7ec1c03df22675af
>  suggesting mappings don't work with the extend keyword.
>
>  Application Specific Mappings are a furphy and do not work as
>  advertised in CF8.  It appears that cfimport and "extends" do not
>  adhere to application specific mappings as defined in Application.cfc
>  in the same way they do to CFIDE based cf mappings.  The two types of
>  "mapping" despite having the same name are very different in practice.
>  As we use inheritance and cfimport a great deal in FarCry this makes
>  using this feature near impossible.
>

The original blog post is here:
Application Specific Mappings Are Horribly Broken
http://blog.daemon.com.au/go/blog-post/application-specific-mappings-are-horribly-broken

I've raised this as an issue with Adobe, but its not regarded as a
bug.  I've suggested the documentation might be changed to reflect the
reality behind application specific mappings limitations -- perhaps
that will happen some day.

Funnily enough BlueDragon apparently works as advertised, so it may
not be an impossible issue to address.  Just need more people
complaining about it I suspect.

-- 
geoff
http://www.daemon.com.au/

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

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

Re: CFdirectory under ColdFusion 8 (Standard)

[Barney Boisvert]

On Fri, May 2, 2008 at 3:46 PM, Don L <[EMAIL PROTECTED]> wrote:
>   type="file" sort="directory DESC">
>  the Sort attribute failed (it did not list files in z to a order).

'directory' is only for recursive CFDIRECTORY calls.  You want 'name'
field for files within the directory.

>   type="file" sort="size DESC">
>  output includes Thumbs.db (the Type Attribute is supposed to eliminate the 
> Thumbs.db or is it my misunderstanding?)

Thumbs.db is a file, not a directory, so it's matched.  You probably
want filter="*.jpg" or something.

cheers,
barneyb

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

Got Gmail? I have 100 invites.

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

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

jTDS and Coldfusion, scope identity

[Billy Jamme]

Hi All,

I'm wondering if anyone has any experience with the jTDS driver 
(http://jtds.sourceforge.net) and Coldfusion 8.  I'm running this on Win2003 
box (32 bit), Cf 8.0 and sql server 2005.

I've set up the driver, and can use it to successfully fetch queries with a 
substantial speed improvement, and even more so under load.  Unfortunately it's 
not 100% compatible with the existing data direct driver.  I'm unable to get a 
result for: 

select scope_identity() as id

The ID column returns an empty string.  However, if I switch back to the old 
data direct drivers the query returns an Id, as expected.

Any insight would be greatly appreciated.

-j 

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

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

CFdirectory under ColdFusion 8 (Standard)

[Don L]

Oddities with this tag (OS=XP Professional):


the Sort attribute failed (it did not list files in z to a order).



output includes Thumbs.db (the Type Attribute is supposed to eliminate the 
Thumbs.db or is it my misunderstanding?)

Thanks.



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

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

Re: Session variables expireation issue

[marc --]

Ok, I found the cause:

onSessionStart()

#THIS.sessionTimeout #

outputs 10. Which means 10 days since the createTimespan() function returns 
units of days (eg CreateTimespan(1,0,0,0)eq 1 and CreateTimespan(0,12,0,0) eq 
0.5)

onApplicationStart()
THIS.sessiontimeout=CreateTimeSpan(0,0,0,10)
#THIS.sessiontimeout#

outputs 0.000115740740741 which equals 10 secs.

Why the same variable (THIS.sessiontimeout) gives a different value in the 
onApplicationStart() and onSessionStart() handler is beyound me. If I cfdump 
the THIS scope in both handlers they are identical except for the value of 
sessiontimeout and applicationtimeout.
Marc 

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

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

Re: Can't_consume_SAP_web_service_w ith_ColdFusion

[Brian Niski]

First, thank you to Kris Jones and João Fernandes for your help.  Your 
assistance guided me towards my final solution.

I must complete this story for everyone who finds themselves as confused as I 
was.  I am now successful consuming my SAP web services.  There are so many 
pieces that were needed to make it happen; I am shocked that I couldn’t 
explicitly find answers to my problems.  Well here is what I did.

1st Issue – I used Dreamweaver > Application Panel > Web Services > plus-sign 
(+) to create a ColdFusion proxy to the SAP web service.  This is where I was 
first confused.  You see, in Dreamweaver you can drag and drop the web service 
proxy into your code and it creates a cfinvoke tag with associated arguments.  
Well, I knew that my web service only took two arguments, but the proxy created 
three.  Here is what it looked like:

http://...sap/ZSVC_EMPLOYEE_DATA?sap-client=090&wsdl=1.1";
 method="ZSVC_EMPLOYEE_DATA"
 returnvariable="aBAPIRETURN">



 

What is “RESULTS”?  Well, I will skip everything I did wrong and tell you 
what it is.  I am not an expert, so please forgive any mistakes in my 
explanation.  If you look at the WSDL for this file, you will notice that there 
is an input element named “results” and there is also an output element 
named “results”.  

- 
- 
- 
   
   
   
  
  
  
- 
- 
- 
   
   
  
  
  


This is called an “inout” variable.  I had never heard of this before.  I 
thought that the only way to get something returned from a webservice was if it 
came to you in the returnvariable.  This is incorrect.  A web service can take 
an inout variable that is passed to it and then write new values to it for use 
on the calling web page.

2nd Issue – Knowing about the existence of “inout” variables wasn’t 
enough.  I had a difficult time learning how to use it.  If you have an inout 
variable, you need to set the value equal to the name of the variable… but 
read carefully here – don’t include the customary pound signs (#) around 
the variable.  Using my example above:



Let me reiterate that you don’t see any pound signs in the above 
cfinvokeargument.  You will not be able to output your results if you 
mistakenly use pound signs.  Now you can see the results.



3rd Issue – So once I figured out issues 1 and 2, I was finally able to 
cfdump the results and see the available methods.  In my case, I needed to use 
a method “getItem()”.  So I added another cfdump for the getItem() method.  
This showed me an array, and the first item of the array was a function that 
contained methods for the data I was attempting to access.  I was getting close.



4th Issue - This was not the end of my struggles.  I had to figure out how to 
access the values.  My experiments kept failing.  How can I get the values?  I 
wasn’t comprehending that getItem() was a method to get the “Item” array. 
 And likewise inside the Item array, the methods were similarly written – the 
getEmail() was a method to get the “Email”.  I needed to get rid of the 
“get” to use the data values.  Here is the solution:



Done!

And as a note, I also learned that ColdFusion can consume inout variables, but 
it cannot publish them.

The following links are to some of the web page articles and discussions that 
were critical towards me finally figuring out what to do.

Connecting to a Lotus Notes WebService
http://www.sagewire.org/advanced-cfml-techniques/Connecting-to-Lotus-Notes-WebService-55190.aspx
 

Programming ColdFusion MX: Web Services
http://www.webreference.com/programming/coldfusion/1/5.html

Notes on Interfacing ColdFusion MX to External Web Services Requiring 
Complex-within-Complex XML Documents as Input
http://web.archive.org/web/20070309173903/http://hcc.musc.edu/research/shared_resources/xml_complex_types_to_cf_structure_notes.cfm

Handling complex data types
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=1554.htm

Axis User's Guide
http://ws.apache.org/axis/java/user-guide.html

Consume NET web service with complex arguments 
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:52942


>Hi Brian,
>
>we invoke SAP webservices with ColdFusion and we usually use this approach:
>
>
>
>
>
>
>
>
>
>
>-- 
>
>João Fernandes
>
>http://www.onflexwithcf.org
>http://www.riapt.org
>Portugal Adobe User Group (http://aug.riapt.org)

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304692
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusio

SQL GO keyword in cfquery

[Brad Wood]

This is really a question AND the answer, but I figured I would post it
here for the record, since it took me a while to dig up the answer on
Google, and to see if anyone had any additional pointers.

 

In MS SQL Server, you can use the GO keyword to indicate the end of a
SQL statement which is processed separately from the rest of the batch.

 

CREATE PROCEDURE x...

GO

 

GRANT EXECUTE ON x

GO

 

I couldn't get "GO" to work in a cfquery on MX 7.0.2 SQL Server 2005.  I
think it may be because it is a Microsoft thing...

Apparently using a semi-colon ";" after each statement instead of the
"GO" makes everything better again.

 

Please comment if you know more on how this works, and thanks to
http://www.kylehayes.info/blog/index.cfm/2006/7/10/Multiple-SQL-Statemen
ts for tipping me off.

 

~Brad

 



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

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

RE: SMTP Proxy for use in Testing CFMAIL

[Dave Watts]

> Really? Why?
> 
> I guess coming from a QA background and merging web 
> development into it, I perhaps do things differently. Why do 
> developers make bad QA people usually? They have familiarly 
> with the code and I would think they would have to test to 
> see if the code worked as part of the job.

Well, ok, where to start.

First, while developers may make lousy QA people, I wouldn't say that the
reverse is true. QA people can become good developers. In many
organizations, that's the standard path for a new hire.

But back to the main point, developers are generally bad at QA precisely
because they're familiar with the code, or with what the application is
supposed to do. Many developers would never think to throw data at an
application that falls outside the acceptable boundaries of what that
application should expect, because they know what kind of data should be
entered, and they assume without thinking that everyone else does as well.
Developers are very good at testing the code with acceptable values, and
they are very good at fixing compiler errors, but not as good at testing the
code with values that don't make sense to them.

I think the move toward test-driven development has changed that a bit, but
I wouldn't go so far as to say that it's no longer a problem.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

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

RE: Session variables expiration issue

[Dave Watts]

> Just a basic question about session variables.I can't get 
> them to 100% work as I want. Maybe I don't understand so 
> that's when it's time to turn to the list :) I want to use 
> session variables that expire a) when the user closes the 
> browser OR b) when a session times out,whatever comes first.

Like Bobby said, just enable J2EE session management in the CF
Administrator. You don't have to use CFCOOKIE or anything else in that case.

> For a) I do (all in Application.cfc):
> ...
> This makes that sessions expire when user closes browser.

No, it doesn't. It ensures that the browser will be disconnected from the
session, which has the same result for the user, but the session data will
still be consuming memory on the server. That's good enough if your session
timeout is short. If your session timeout isn't short, shorten it.

There really isn't an effective way to expire the session data on the server
when the user closes the browser, since the server doesn't know that the
user closed the browser. All the server knows is when you last requested a
page.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

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

RE: Session variables expireation issue

[Bobby Hartsfield]

Just use J2EE session variables within the CF administrator.

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: marc -- [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 02, 2008 4:53 PM
To: CF-Talk
Subject: Session variables expireation issue

Hello,
Just a basic question about session variables.I can't get them to 100% work
as I want. Maybe I don't understand so that's when it's time to turn to the
list :)
I want to use session variables that expire a) when the user closes the
browser OR b) when a session times out,whatever comes first. For a) I do
(all in Application.cfc):



and





This makes that sessions expire when user closes browser.
For b) add the expires tag to CFCOOKIE with the value specified in
THIS.sessiontimeout: if the user does a request _after_the specified timeout
period, the CFID/CFTOKEN cookies are not valid anymore (expires has a
datetime value that is in the past) so coldfusion will create new values for
SESSION.CFID and SESSION.CFTOKEN and call onSessionStart. Setting 2 new
cookies with new values for value and expires.







To test this I added

to the onRequest() function.
It turned out that the values displayed in the dump did never change after a
2nd whether that request was within the timespan OR after. That's strange. I
thought that if the 2nd request is after the timepout period new values for
CFID/CFTOKEn are generated. Am I wrong? And if so, is it possible what I
want?

Marc 



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

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

Session variables expireation issue

[marc --]

Hello,
Just a basic question about session variables.I can't get them to 100% work as 
I want. Maybe I don't understand so that's when it's time to turn to the list :)
I want to use session variables that expire a) when the user closes the browser 
OR b) when a session times out,whatever comes first. For a) I do (all in 
Application.cfc):



and





This makes that sessions expire when user closes browser.
For b) add the expires tag to CFCOOKIE with the value specified in 
THIS.sessiontimeout: if the user does a request _after_the specified timeout 
period, the CFID/CFTOKEN cookies are not valid anymore (expires has a datetime 
value that is in the past) so coldfusion will create new values for 
SESSION.CFID and SESSION.CFTOKEN and call onSessionStart. Setting 2 new cookies 
with new values for value and expires.







To test this I added

to the onRequest() function.
It turned out that the values displayed in the dump did never change after a 
2nd whether that request was within the timespan OR after. That's strange. I 
thought that if the 2nd request is after the timepout period new values for 
CFID/CFTOKEn are generated. Am I wrong? And if so, is it possible what I want?

Marc 

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

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

Session variables expiration issue

[marc --]

Hello,
Just a basic question about session variables.I can't get them to 100% work as 
I want. Maybe I don't understand so that's when it's time to turn to the list :)
I want to use session variables that expire a) when the user closes the browser 
OR b) when a session times out,whatever comes first. For a) I do (all in 
Application.cfc):



and





This makes that sessions expire when user closes browser.
For b) add the expires tag to CFCOOKIE with the value specified in 
THIS.sessiontimeout: if the user does a request _after_the specified timeout 
period, the CFID/CFTOKEN cookies are not valid anymore (expires has a datetime 
value that is in the past) so coldfusion will create new values for 
SESSION.CFID and SESSION.CFTOKEN and call onSessionStart. Setting 2 new cookies 
with new values for value and expires.







To test this I added

to the onRequest() function.
It turned out that the values displayed in the dump did never change after a 
2nd whether that request was within the timespan OR after. That's strange. I 
thought that if the 2nd request is after the timepout period new values for 
CFID/CFTOKEn are generated. Am I wrong? And if so, is it possible what I want?

Marc 

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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Nathan Wells]

We would like to avoid making changes to the database if possible, because that 
alters the test platform.  The less similar pre-production and production are, 
the less applicable QA testing on pre-production is.  In this particular case, 
removing the data from the database is simply not an option. 

We have true SMTP servers that we can use and configure them to block email to 
the outside by simply disabling relay from our ColdFusion server.  I was hoping 
for a more elegant solution though.  I figured someone in the ColdFusion 
community might have ran into a problem like this, where they wanted their 
application to use the CFMAIL tag, but be able to capture the email messages 
generate leaving the server. 

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

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

Re: SMTP Proxy for use in Testing CFMAIL

[denstar]

On Fri, May 2, 2008 at 1:59 PM, Phillip Vector
<[EMAIL PROTECTED]> wrote:
> Remove most of the users from the pre-production database and those
>  that are left (2 or 3 or however many you need to test your app),
>  replace those with Yahoo or gmail addresses.

Or, I wrote a little deal to use wiser (SubEthaSMTP):

http://subethasmtp.tigris.org/wiser.html

I set up a little tester, that seems to be working-- I can put the
code up somewhere if you'd like.

So in my test environment, I send to localhost:, and then "check"
my local email after sending something.

Seems to be working, too.

Funny someone would ask about this so shortly after I messed with it.

Sorta.  ;-)

It's only like 20 lines of code or something.

  Denny

--
"We do not believe in ourselves until someone reveals that deep inside
us something is valuable, worth listening to, worthy of our trust,
sacred to our touch. Once we believe in ourselves we can risk
curiosity, wonder, spontaneous delight or any experience that reveals
the human spirit."
 jodynla
 E. E. Cummings

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

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

Re: Update multiple Records

[Matt Robertson]

I wrote up a complete tutorial on how to do this over at easyCFM a few
years ago.

http://tutorial214.easycfm.com/

Don't hate me for using evaluate()  :-)

-- 
[EMAIL PROTECTED]
Janitor, The Robertson Team
mysecretbase.com

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

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

Re: JBoss'n it (was: Re: CFMX8 - Standard vs. Enterprise)

[denstar]

On Fri, May 2, 2008 at 9:19 AM, Larry Lyons <[EMAIL PROTECTED]> wrote:
> >I've been waiting till we get some more CF8's to do clustering on JBoss.
>  >That sounds amazingly simple.
>  >
>  >Hmmm... now to find a good way to keep the file systems in sync, since I've
>  >started generating a lot of static content...  :-P
>
>  Drop your war or ear file in the /server/all/farm directory on one of the 
> JBoss instances, that takes care of it for you. It will deploy the file to 
> all the members of the cluster.
>
>  However if you're generating files using CFFile etc., you're going to have 
> to have roll out your own or see if there are any commercial apps that can do 
> that.

Yeah, some rolling is required.  I'm thinking a load balanced Apache
cluster and either NFS or Rsync...

[...]
>  Most frameworks run on BlueDragon for J2EE. If any framework uses
> some of the "undocumented" CF API's (ie., the java objects associated
> with coldfusion.server.serviceFactory) then obviously it won't work.
> Also there has been some problems with the latest version of Transfer
> and BD.

All I'm using for ORMs is Reactor and hibernate.  It sounds like MG
runs fine, which is swell.

>  >JBoss is freaking insane tho.  Wow, talk about a lot of cool stuff.  I've
>  >really enjoyed using it.  Plus, lots of nifty plugins for Eclipse ;-)
>  >
>  >It would be interesting to fire up another cf engine, and see if much of my
>  >stuff runs on it... I've never really taken any of the others out for a
>  >spin.
>
>  So download BlueDragon for J2EE and Railo and try them out.

I will, when I get the chance.  Right now I'm trying to focus on only
100 things or so.  :-)

OBD will be next, I think, as I'd like to tie into a cf engine within Eclipse.

[...]
>  You might want to check out this: 
> http://groups.google.com/group/openbd/browse_thread/thread/9dad1cdf68bde2e1?hl=en
>
>  Its instructions on how to download the Open Bluedragon source code and 
> compile it.
>
>  Myself I'm waiting for the official release in about 3 days.
[...]

Thank you!  I hadn't found where/how to get it yet.  Excellent.

>  You may also want to check out Steve Brownlee's blog on setting up CF8

Steve's entries were a great (and the sole) resource when I was
getting into JBoss!

This link was helpful in tuning JBoss (v4, v5 seems a bit different):

http://wiki.jboss.org/wiki/JBossASTuningSliming

Now my dev instance fires up quite a bit quicker.

Out of curiosity, are you running 4 or 5?

Again, thanks for the link/advice, I'm enjoying JBoss mucho so far.

  Denny

--
"To be nobody but yourself in a world that's doing its best to make
you somebody else, is to fight the hardest battle you are ever going
to fight. Never stop fighting."
 E. E. Cummings

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

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

RE: Update multiple Records

[Bobby Hartsfield]

Or again... just use the same loop that you used to build the fields... to
read them.


..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Azadi Saryev [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 02, 2008 2:25 PM
To: CF-Talk
Subject: Re: Update multiple Records

if your fields are named something like newcost_#id#:

loop through form.fieldnames => get each field's name
if field name matches a pattern (i.e. left(fieldname, 7) eq "newcost_"),
treat it as _-delimited list to get the id from it

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Jason Congerton wrote:
> Hi All
>
> Sorry i think i  am being a bit thick here!! but how do i get the id from
the form name as i can only access the value of the form field in my action
page.
>
> Jason
>
>
>   



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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Phillip Vector]

Remove most of the users from the pre-production database and those
that are left (2 or 3 or however many you need to test your app),
replace those with Yahoo or gmail addresses.

When you roll it out, make sure before you do, you copy the users
table from the production DB to the pre-production DB.

I mean, if you are dead set on using a separate SMTP, I can provide
one for you, but it will cost your company money. I'm just saying that
there is a much cheaper way.

On Fri, May 2, 2008 at 12:53 PM, Nathan Wells <[EMAIL PROTECTED]> wrote:
> > Sorry, not tryingto be rude, but I guess I don't understand what the
>  > purpose of such a thing would be.
>
>  No need to apologize.  Let avoid the whole QA vs. Developer issue and lay 
> out the ugly details of the situation.
>
>  The specific incident that started my search was that during testing, our 
> pre-production environment sent out emails to real customers.  The database 
> in pre-production starts out as a copy of our production database, and then 
> has any alterations applied to it that are required by the release being 
> tested (which is in itself a partial test of the roll-out plan).  When the 
> scheduled jobs that are part of this application were enabled, they started 
> sending emails using the contact information in the database.
>
>  My initial reaction was to simply disable CFMAIL by pointing it to a bogus 
> SMTP server.  That would have, however, prevented QA from testing the email 
> functionality of the application, hence my search for a proxy that would 
> capture the emails for later inspection / validation.
>
>  

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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Nathan Wells]

> Sorry, not tryingto be rude, but I guess I don't understand what the
> purpose of such a thing would be.

No need to apologize.  Let avoid the whole QA vs. Developer issue and lay out 
the ugly details of the situation. 

The specific incident that started my search was that during testing, our 
pre-production environment sent out emails to real customers.  The database in 
pre-production starts out as a copy of our production database, and then has 
any alterations applied to it that are required by the release being tested 
(which is in itself a partial test of the roll-out plan).  When the scheduled 
jobs that are part of this application were enabled, they started sending 
emails using the contact information in the database.

My initial reaction was to simply disable CFMAIL by pointing it to a bogus SMTP 
server.  That would have, however, prevented QA from testing the email 
functionality of the application, hence my search for a proxy that would 
capture the emails for later inspection / validation.  

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

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

RE: Television: Mythbusters and CBS

[Eric Roberts]

That would be awesome...I don't have cable anymore either and miss the show.

Eric

/*-Original Message-
/*From: Ian Skinner [mailto:[EMAIL PROTECTED]
/*Sent: Friday, May 02, 2008 11:20 AM
/*To: CF-Talk
/*Subject: Television: Mythbusters and CBS
/*
/*Does anybody know if there is something going on here?  Are Jamie and
/*Adam perchance coming to a broadcast channel near me?
/*
/*I have not had cable for about a year now and I am not up on my current
/*Mythbusters.  I had CSI on in the background last night and looked up
/*just in time to see Mr. Hynerman and Mr. Savege make a brief,
/*non-speaking cameo.  Gave me a laugh.  Then later, during a commercial
/*break, a spot for CBS news played.  One of these 'Asking Questions...
/*Getting Answers' themed ones CBS has been doing for awhile.  This spot
/*again featured the Mythbusters with the small twist of 'Asking
/*Questions... Getting Answers... Blowing things up'.
/*
/*This made me wonder if maybe CBS might be bringing Mythbusters to their
/*line up.  But I can not find any hint of it on-line.
/*
/*
/*
/*

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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Phillip Vector]

Right... Then my previous example of getting some new users with email
addresses and use the app is valid. :)

On Fri, May 2, 2008 at 1:26 PM, Dave Francis <[EMAIL PROTECTED]> wrote:
> It's because they are familiar with the code - they have preconceptions, and
>  knowledge of the application that a first-time user does not have. To give a
>  trivial example - the app might expect a date field to be m/d/y because the
>  developer "knows" that everyone knows this. Except a user from the uk who
>  likes d/m/y or a use with a little computer background who believes y/m/d is
>  easeier on computers.
>
>
>  -Original Message-
>  From: Phillip Vector [mailto:[EMAIL PROTECTED]
>  Sent: Friday, May 02, 2008 1:44 PM
>  To: CF-Talk
>  Subject: Re: SMTP Proxy for use in Testing CFMAIL
>
>
>  Really? Why?
>
>  I guess coming from a QA background and merging web development into
>  it, I perhaps do things differently. Why do developers make bad QA
>  people usually? They have familiarly with the code and I would think
>  they would have to test to see if the code worked as part of the job.
>
>  On Fri, May 2, 2008 at 11:40 AM, Dave Watts <[EMAIL PROTECTED]> wrote:
>  > > Usually, as I've seen it, QA is the same as Developers.
>  >
>  >  You should see it some other way. It's a lot nicer that other way.
>  >  Developers, by and large, make lousy QA people.
>  >
>  >  Dave Watts, CTO, Fig Leaf Software
>  >  http://www.figleaf.com/
>  >
>  >  Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
>  >  http://training.figleaf.com/
>  >
>  >  WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
>  >  http://www.webmaniacsconference.com/
>  >
>  >
>
>
>
>  

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

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

RE: SMTP Proxy for use in Testing CFMAIL

[Dave Francis]

It's because they are familiar with the code - they have preconceptions, and
knowledge of the application that a first-time user does not have. To give a
trivial example - the app might expect a date field to be m/d/y because the
developer "knows" that everyone knows this. Except a user from the uk who
likes d/m/y or a use with a little computer background who believes y/m/d is
easeier on computers.

-Original Message-
From: Phillip Vector [mailto:[EMAIL PROTECTED]
Sent: Friday, May 02, 2008 1:44 PM
To: CF-Talk
Subject: Re: SMTP Proxy for use in Testing CFMAIL


Really? Why?

I guess coming from a QA background and merging web development into
it, I perhaps do things differently. Why do developers make bad QA
people usually? They have familiarly with the code and I would think
they would have to test to see if the code worked as part of the job.

On Fri, May 2, 2008 at 11:40 AM, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Usually, as I've seen it, QA is the same as Developers.
>
>  You should see it some other way. It's a lot nicer that other way.
>  Developers, by and large, make lousy QA people.
>
>  Dave Watts, CTO, Fig Leaf Software
>  http://www.figleaf.com/
>
>  Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
>  http://training.figleaf.com/
>
>  WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
>  http://www.webmaniacsconference.com/
>
>



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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Phillip Vector]

Really? Why?

I guess coming from a QA background and merging web development into
it, I perhaps do things differently. Why do developers make bad QA
people usually? They have familiarly with the code and I would think
they would have to test to see if the code worked as part of the job.

On Fri, May 2, 2008 at 11:40 AM, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Usually, as I've seen it, QA is the same as Developers.
>
>  You should see it some other way. It's a lot nicer that other way.
>  Developers, by and large, make lousy QA people.
>
>  Dave Watts, CTO, Fig Leaf Software
>  http://www.figleaf.com/
>
>  Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
>  http://training.figleaf.com/
>
>  WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
>  http://www.webmaniacsconference.com/
>
>  

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

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

RE: SMTP Proxy for use in Testing CFMAIL

[Dave Watts]

> Usually, as I've seen it, QA is the same as Developers.

You should see it some other way. It's a lot nicer that other way.
Developers, by and large, make lousy QA people.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

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

Re: Update multiple Records

[Azadi Saryev]

if your fields are named something like newcost_#id#:

loop through form.fieldnames => get each field's name
if field name matches a pattern (i.e. left(fieldname, 7) eq "newcost_"),
treat it as _-delimited list to get the id from it

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Jason Congerton wrote:
> Hi All
>
> Sorry i think i  am being a bit thick here!! but how do i get the id from the 
> form name as i can only access the value of the form field in my action page.
>
> Jason
>
>
>   

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

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

Re: Update multiple Records

[Josh Nathanson]

> Sorry i think i  am being a bit thick here!! but how do i get the id from 
> the form name as i can only access the value of the form field in my 
> action page.

You can access the form field name by either looping over the form as a 
collection, or looping over the property FIELDNAMES.  Here is what the 
former might look like:









-- Josh 


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

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

Re: Update multiple Records

[Jason Congerton]

Hi All

Sorry i think i  am being a bit thick here!! but how do i get the id from the 
form name as i can only access the value of the form field in my action page.

Jason

> Hi
> 
> I need to update the price of multiple products using one form  i.e
> 
> Product  Price
> ShoesUpdateable Text Field
> Trainers Updateable Text Field
> etc
> 
> I was going to name the text field newCost and loop through the list, 
> but i obviously need to pass the id as well. Would it be best to name 
> the text box with the id paramenter so each text box is unique? And 
> then loop through the form results matching the id before inserting 
> the form value??
> 
> Jason 


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

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

Re: insert /delet problem in coldfusion

[Tom McNeer]

There's a lot in your code that should probably be changed -- first, I'm
assuming that the form/database code at the bottom of your post is NOT part
of the same page as the form -- but you don't need the cfoutput tags in the
processing code, or most of the hash signs, and you could avoid the use of
Evaluate.

But most importantly, there are two big problems in the database code if
this is supposed to be an "update" (you say the user is modifying the
answers.



> 
>
> insert into survey_results (surveyidfk, empID) values (#url.survey#,
> #session.EmpID#)


Here you're always doing an "insert" -- creating a new survey result record.
Is that what you're really trying to do? You said "modify," but you're
saving a new record.

Then ...


> 
>
>
> dbtype="odbc">
>delete from SurveyResultsDetail where idfk
> =#qryInsert.newID#
>insert into SurveyResultsDetail
> (answer,surveyID,idfk) values
> (#ListLast(Evaluate("Form.#field#"),"_")#,#url.survey#,#qryInsert.newID#)
>
>  
>
>  
> 


. you are trying to delete records from the Detail table based on the ID
of the new record, and there aren't any in the first iteration of the loop.
You just created the Results record. Then you're immediately inserting a
record into the Details table. But you are doing this within the loop of
the  fieldnames, so the next iteration of the loop deletes the record you
just created. At the end you have one Detail record, from the last iteration
of the loop, and it's related to the new Result record you just created.





-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Phillip Vector]

Oh.

Usually, as I've seen it, QA is the same as Developers.

If QA is testing out the functionality of your app, then why do they
need a special SMTP. Just have them get a google mail account and go
through the forms or whatever and put that in as their emails.

If they do more then what users would do, why would they have trouble
with the CFAdmin log files?

Sorry, not tryingto be rude, but I guess I don't understand what the
purpose of such a thing would be.

On Fri, May 2, 2008 at 10:22 AM, Nathan Wells <[EMAIL PROTECTED]> wrote:
> >Can't you just log the messages and check CF administrator to see if
>  >they "went out"?
>  >
>
>  Yes, we could check the mailsent log, but it's not always viable to give our 
> QA testers access to the log files, and it's not real warm and fuzzy either.
>
>  

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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Nathan Wells]

>Can't you just log the messages and check CF administrator to see if
>they "went out"?
>

Yes, we could check the mailsent log, but it's not always viable to give our QA 
testers access to the log files, and it's not real warm and fuzzy either.  

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

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

RE: Retrieve the auto generated key from a MySQL resultset

[Bobby Hartsfield]

Add result="myResults"

I also hope you weren't fond of that password. 

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: marc -- [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 02, 2008 12:22 PM
To: CF-Talk
Subject: Retrieve the auto generated key from a MySQL resultset

>From the docs @ cfquery
-
The cfquery tag also returns the following result variables in a structure.
You can access these variables with a prefix of the name you specified in
the result attribute."[...]
result_name.GENERATED_KEY
MySQL only. The ID of an inserted row. MySQL 3 does not support this
feature.
-

So I try this in MySQL client version: 5.0.45:

INSERT INTO authors(
firstname,
lastname,
title,
gender,
pseudonym,
notes)
VALUES(
'',
'',
'',
'',
'',
'');




I get 
"Variable QINSERTAUTHORS is undefined."
Also after I add AlwaysReportTriggerResults=true to the connection string of
the dsn (mentioned in the comments section of the page).
As far as I can see this feature works not as advertised. 



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

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

Re: Screen cap via http

[Nathan Wells]

> Hey, 
> 
> I'm looking for a CF extension (or other), which will allow me to 
> programmatically capture screen shots of a website and save it as a 
> jpg.  You know, something as simple as feeding it a url, and having it 
> save a jpeg on the server?
> 
> Thanks - 
> Geoff B 
> 

There is a free program called WebShot that has a command-line interface.  
Might not be exactly what you're looking for.  There is a paid server edition 
that allows you to create a DLL for it, which could be turned into a CFX tag. 
  http://www.websitescreenshots.com/ 

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

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

RE: Screen cap via http

[Dave Watts]

> I'm looking for a CF extension (or other), which will allow 
> me to programmatically capture screen shots of a website and 
> save it as a jpg.  You know, something as simple as feeding 
> it a url, and having it save a jpeg on the server?

If you have CF8, you can actually do this using CFDOCUMENT, in a roundabout
way, using CFDOCUMENTSECTION to point to a URL. This will give you a PDF
from which you can easily extract jpgs for each page. Here's an example
straight from the "Moving to ColdFusion 8" course authored by Fig Leaf
Software:













   




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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

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

Re: SMTP Proxy for use in Testing CFMAIL

[Phillip Vector]

Can't you just log the messages and check CF administrator to see if
they "went out"?

On Fri, May 2, 2008 at 10:00 AM, Nathan Wells <[EMAIL PROTECTED]> wrote:
> We have a ColdFusion-based application that makes use of CFMAIL.  Nothing too 
> fancy, mostly just HTML emails with no attachments.  We are looking for an 
> SMTP server (or an SMTP proxy, if you will) that we could point our 
> development and pre-production environments to.  This SMTP server would need 
> a level of configuration that would allow us to filter, or re-direct, the 
> messages it receives instead of relaying them on out to the internet.
>
>  It would be great to find something that would dump the messages into a 
> database that we could interface with to verify the emails are being sent 
> correctly by the application during development and testing.
>
>  SMTP is a fairly simple protocol, at least when attachments aren't involved, 
> so I am guessing this would be fairly easy to build.  It also seems like 
> someone, somewhere, has probably ran into a similar situation and probably 
> solved it too, but I've been asking colleagues and Google without any luck.
>
>  Does anyone have any suggestions?
>
>  Thanks in advance;
>
>  Nate
>
>  

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

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

insert /delet problem in coldfusion

[erik tom]

OK. I got really stumpped the solution seems to be very simple, but anyway. in 
my survey form I need . answer question . and then click save. Then If the user 
go in the modyfy the question i want to delete the prevoius choices and insert 
the new ones.

I have to 2 tables to do that .()
Survey_result: id,surveyidfk,empId, subjectID,completiondate 
SurveyResultsDetail: id, answer,surveyid,idfk(foreing key from the previous 
table).

So what i am doing is everytime i go in I wanto delete all records from 
SurveyresultsDetail table where idfk is = id from the Survey_result. bUt it 
does not work 

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml";>


Untitled Document



 Select * from surveys where id=#url.survey#


 
select * from questions where surveyidfk=#url.survey# order by sortOrder


 



 


 
  
  #UCase(name)#

Description:#description#
 

   
#header#

#qryQuestionReview.currentrow#.#question#



select * from  questionOptions  where questionID=#qryQuestionReview.id# order 
by sortOrder

 
 
 
select * from  surveyResultsDetail where idfk=#results#

 
 
 

 
  
checked /> #options#

 
 #options#
 

 
 checked/>   
#Options#
  
   

 
   #options#

 




' & options & ''>
 



 



   

 
 
 
 


 

#footer#

 
  
 #selectOptions#
  
   




 

   
   










 
insert into survey_results (surveyidfk, empID) values (#url.survey#, 
#session.EmpID#)
select @@Identity as newID from survey_results
 



 


delete from SurveyResultsDetail where idfk =#qryInsert.newID#
insert into SurveyResultsDetail (answer,surveyID,idfk) 
values (#ListLast(Evaluate("Form.#field#"),"_")#,#url.survey#,#qryInsert.newID#)

  
  
 

 



 




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

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

Re: Television: Mythbusters and CBS

[Ian Skinner]

Gerald Guido wrote:
> Did you try:
>
> 
>
> 

Hey, I already fessed up my idiotness twenty minutes ago.  Ok, I blamed 
it on mythical, pointy eared beings.  But the thread has been replicated 
on the more appropriate 'Community' list.

I'll now drop it here.





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

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

SMTP Proxy for use in Testing CFMAIL

[Nathan Wells]

We have a ColdFusion-based application that makes use of CFMAIL.  Nothing too 
fancy, mostly just HTML emails with no attachments.  We are looking for an SMTP 
server (or an SMTP proxy, if you will) that we could point our development and 
pre-production environments to.  This SMTP server would need a level of 
configuration that would allow us to filter, or re-direct, the messages it 
receives instead of relaying them on out to the internet. 

It would be great to find something that would dump the messages into a 
database that we could interface with to verify the emails are being sent 
correctly by the application during development and testing.  

SMTP is a fairly simple protocol, at least when attachments aren't involved, so 
I am guessing this would be fairly easy to build.  It also seems like someone, 
somewhere, has probably ran into a similar situation and probably solved it 
too, but I've been asking colleagues and Google without any luck. 

Does anyone have any suggestions? 

Thanks in advance;

Nate 

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

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

Screen cap via http

[G. Brown]

Hey, 

I'm looking for a CF extension (or other), which will allow me to 
programmatically capture screen shots of a website and save it as a jpg.  You 
know, something as simple as feeding it a url, and having it save a jpeg on the 
server?

Thanks - 
Geoff B 



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

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

Re: Television: Mythbusters and CBS

[Gerald Guido]

Did you try:







On Fri, May 2, 2008 at 12:19 PM, Ian Skinner <[EMAIL PROTECTED]> wrote:

> Does anybody know if there is something going on here?  Are Jamie and
> Adam perchance coming to a broadcast channel near me?
>
> I have not had cable for about a year now and I am not up on my current
> Mythbusters.  I had CSI on in the background last night and looked up
> just in time to see Mr. Hynerman and Mr. Savege make a brief,
> non-speaking cameo.  Gave me a laugh.  Then later, during a commercial
> break, a spot for CBS news played.  One of these 'Asking Questions...
> Getting Answers' themed ones CBS has been doing for awhile.  This spot
> again featured the Mythbusters with the small twist of 'Asking
> Questions... Getting Answers... Blowing things up'.
>
> This made me wonder if maybe CBS might be bringing Mythbusters to their
> line up.  But I can not find any hint of it on-line.
>
>
>
> 

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

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

RE: Television: Mythbusters and CBS

[Andy Matthews]

I'ts unlikely that they'd bring the MB show to CBS as I'm sure that
copyright is owned by Discovery (isn't that where MB plays?).

That'd be cool though. 

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 02, 2008 11:20 AM
To: CF-Talk
Subject: Television: Mythbusters and CBS

Does anybody know if there is something going on here?  Are Jamie and Adam
perchance coming to a broadcast channel near me?

I have not had cable for about a year now and I am not up on my current
Mythbusters.  I had CSI on in the background last night and looked up just
in time to see Mr. Hynerman and Mr. Savege make a brief, non-speaking cameo.
Gave me a laugh.  Then later, during a commercial break, a spot for CBS news
played.  One of these 'Asking Questions... 
Getting Answers' themed ones CBS has been doing for awhile.  This spot again
featured the Mythbusters with the small twist of 'Asking Questions...
Getting Answers... Blowing things up'. 

This made me wonder if maybe CBS might be bringing Mythbusters to their line
up.  But I can not find any hint of it on-line.





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

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

RE: Television: Mythbusters and CBS

[Rick Faircloth]

Uh... I like Mythbusters, too... but "CF-Talk"?  :o)

Rick

> -Original Message-
> From: Ian Skinner [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 02, 2008 12:20 PM
> To: CF-Talk
> Subject: Television: Mythbusters and CBS
> 
> Does anybody know if there is something going on here?  Are Jamie and
> Adam perchance coming to a broadcast channel near me?
> 
> I have not had cable for about a year now and I am not up on my current
> Mythbusters.  I had CSI on in the background last night and looked up
> just in time to see Mr. Hynerman and Mr. Savege make a brief,
> non-speaking cameo.  Gave me a laugh.  Then later, during a commercial
> break, a spot for CBS news played.  One of these 'Asking Questions...
> Getting Answers' themed ones CBS has been doing for awhile.  This spot
> again featured the Mythbusters with the small twist of 'Asking
> Questions... Getting Answers... Blowing things up'.
> 
> This made me wonder if maybe CBS might be bringing Mythbusters to their
> line up.  But I can not find any hint of it on-line.



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

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

Re: Television: Mythbusters and CBS

[Ian Skinner]

I swear I sent this to Community.  Who is crossing my wires out there?  
Fess up, I don't believe in elves.

Moving to Community now.


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

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

RE: Retrieve the auto generated key from a MySQL resultset

[Dave Watts]

> From the docs @ cfquery
> -
> The cfquery tag also returns the following result variables 
> in a structure. You can access these variables with a prefix 
> of the name you specified in the result attribute."[...] 
> result_name.GENERATED_KEY MySQL only. The ID of an inserted 
> row. MySQL 3 does not support this feature.
> -
> 
> So I try this in MySQL client version: 5.0.45:
>  username="www" password="gHe6i2Gyi">

You haven't specified a RESULT attribute for your CFQUERY tag, as described
in the documentation:



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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

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

Retrieve the auto generated key from a MySQL resultset

[marc --]

>From the docs @ cfquery
-
The cfquery tag also returns the following result variables in a structure. You 
can access these variables with a prefix of the name you specified in the 
result attribute."[...]
result_name.GENERATED_KEY
MySQL only. The ID of an inserted row. MySQL 3 does not support this feature.
-

So I try this in MySQL client version: 5.0.45:

INSERT INTO authors(
firstname,
lastname,
title,
gender,
pseudonym,
notes)
VALUES(
'',
'',
'',
'',
'',
'');




I get 
"Variable QINSERTAUTHORS is undefined."
Also after I add AlwaysReportTriggerResults=true to the connection string of 
the dsn (mentioned in the comments section of the page).
As far as I can see this feature works not as advertised. 

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

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

Television: Mythbusters and CBS

[Ian Skinner]

Does anybody know if there is something going on here?  Are Jamie and 
Adam perchance coming to a broadcast channel near me?

I have not had cable for about a year now and I am not up on my current 
Mythbusters.  I had CSI on in the background last night and looked up 
just in time to see Mr. Hynerman and Mr. Savege make a brief, 
non-speaking cameo.  Gave me a laugh.  Then later, during a commercial 
break, a spot for CBS news played.  One of these 'Asking Questions... 
Getting Answers' themed ones CBS has been doing for awhile.  This spot 
again featured the Mythbusters with the small twist of 'Asking 
Questions... Getting Answers... Blowing things up'. 

This made me wonder if maybe CBS might be bringing Mythbusters to their 
line up.  But I can not find any hint of it on-line.



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

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

RE: CFPDF - Watermark Like Effect

[Dave Watts]

> I've look at a good process to do this with CF801, and 
> haven't found a nice, simple, workflow. I even thought of 
> creating a PDF in memory holding the text, and watermarking 
> that to the existing pdf, but the watermark function doesn't 
> take in memory pdf for the watermark text, only for the 
> document to watermark onto.

You can place watermarks with DDX, which might let you use a PDF in memory.
You can invoke DDX commands using CFPDF ACTION="ProcessDDX".



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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

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

Re: CFPDF Formatting

[Tom Chiverton]

On Thursday 01 May 2008, Mark Phillips wrote:
> Any ideas?

Known problem, as far as I can tell.
Maybe when this CF9 public bug database appears we can get some visibility on 
it.

In the mean time, we use UJAC.

-- 
Tom Chiverton
Helping to synergistically entrench interdependent bandwidth
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

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

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

Re: Update multiple Records

[Jason Congerton]

Excellent thanks for the prompt responses

> Hi
> 
> I need to update the price of multiple products using one form  i.e
> 
> Product  Price
> ShoesUpdateable Text Field
> Trainers Updateable Text Field
> etc
> 
> I was going to name the text field newCost and loop through the list, 
> but i obviously need to pass the id as well. Would it be best to name 
> the text box with the id paramenter so each text box is unique? And 
> then loop through the form results matching the id before inserting 
> the form value??
> 
> Jason 


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

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

RE: mail attachments prob

[Richard Meredith-Hardy]

Don't worry, found it.  

In this case I was copying a file from one with a uuid name to one with a
sensible name to send, sending it in cfmail, and then deleting it.

In CF5 this was fine, but the copy was clearly being deleted in cf8 before
cfmail got round to actually dealing with the attached file, hence the
error.

Richard

> -Original Message-
> From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] 
> Sent: 02 May 2008 12:29
> To: CF-Talk
> Subject: mail attachments prob
> 
> Sending a mail with an attachment. (works fine without)
> 
> Can someone explain why code which works fine in CF5 won't 
> work in CF8?
> 
> Error in mail log is: IOException while sending message
> 
> I can't see anything immediately obvious from the 
> documentation, a mime type or something?  (these attachments 
> are always pdf's)
> 
> Thanks
> 
> Richard
> 
> 
> 
> 
> 

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

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

Re: JBoss'n it (was: Re: CFMX8 - Standard vs. Enterprise)

[Larry Lyons]

>I've been waiting till we get some more CF8's to do clustering on JBoss.
>That sounds amazingly simple.
>
>Hmmm... now to find a good way to keep the file systems in sync, since I've
>started generating a lot of static content...  :-P

Drop your war or ear file in the /server/all/farm directory on one of the JBoss 
instances, that takes care of it for you. It will deploy the file to all the 
members of the cluster.

However if you're generating files using CFFile etc., you're going to have to 
have roll out your own or see if there are any commercial apps that can do that.

>> If you need load balancing and failover then you can add Apache and mod_jk
>> to handle that.
>
>
>AJP is where it's at, hombre.  :-)
>
>I'm really loving having static stuff just served up by apache and only
>ringing CF when there's some thinking to be done.
>

[snip]

> At this point, so much is being handled by specialized software, I could
>probably use just about anything.  I do like model-glue and ORMs, so that
>would be swell... but after getting into hibernate, I'm wondering about
>where to keep my model.  The tools for Java are so nice...  so I'm left with
>like a front-end controller... *sigh* *shrug*.


Most frameworks run on BlueDragon for J2EE. If any framework uses some of the 
"undocumented" CF API's (ie., the java objects associated with 
coldfusion.server.serviceFactory) then obviously it won't work. Also there has 
been some problems with the latest version of Transfer and BD.

>
>JBoss is freaking insane tho.  Wow, talk about a lot of cool stuff.  I've
>really enjoyed using it.  Plus, lots of nifty plugins for Eclipse ;-)
>
>It would be interesting to fire up another cf engine, and see if much of my
>stuff runs on it... I've never really taken any of the others out for a
>spin.

So download BlueDragon for J2EE and Railo and try them out. 

>
>I've got a certain loyalty to the original, and none of the open source ones
>really seemed open source...  still, as someone heatedly pointed out a while
>back, it's the decent thing to do.  If I have something nifty, I guess I
>don't want to lock the other engines out...

You might want to check out this: 
http://groups.google.com/group/openbd/browse_thread/thread/9dad1cdf68bde2e1?hl=en

Its instructions on how to download the Open Bluedragon source code and compile 
it.

Myself I'm waiting for the official release in about 3 days.

>
>At any rate, with CF8 and JBoss, I've been happy.  Now I can run
>jasperserver and whatnot in the same setup (easy, vs. sorta hard w/jrun).
>And I have to say it again... the stuff you can plug into jboss... wow.
>
>Ok, enough happy-happy joy-joy, I reckon.  Just wanted to voice a "CF8 and
>JBoss are the bee's knees" me too type-of-comment. 

You may also want to check out Steve Brownlee's blog on setting up CF8 as an 
exploded war in JBoss (http://www.fusioncube.net/?p=94). He also has other good 
suggestions for running CF and JBoss.

regards,
larry



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

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

RE: Update multiple Records

[Bobby Hartsfield]

Oops, those cfparams need the values to be #price#




..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 02, 2008 10:57 AM
To: CF-Talk
Subject: RE: Update multiple Records

You got the idea. Just cfloop the ids into field names











Then use the same query and loop to parse them in the action template









Update table 
Set price = 



This has nothing to do with your problem but I would consider changing the
price datatype from text to some kind of numeric or currentcy type.

...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Jason Congerton [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 02, 2008 10:34 AM
To: CF-Talk
Subject: Update multiple Records

Hi

I need to update the price of multiple products using one form  i.e

Product  Price
ShoesUpdateable Text Field
Trainers Updateable Text Field
etc

I was going to name the text field newCost and loop through the list, but i
obviously need to pass the id as well. Would it be best to name the text box
with the id paramenter so each text box is unique? And then loop through the
form results matching the id before inserting the form value??

Jason 





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

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

RE: Update multiple Records

[Bobby Hartsfield]

You got the idea. Just cfloop the ids into field names











Then use the same query and loop to parse them in the action template









Update table 
Set price = 



This has nothing to do with your problem but I would consider changing the
price datatype from text to some kind of numeric or currentcy type.

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Jason Congerton [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 02, 2008 10:34 AM
To: CF-Talk
Subject: Update multiple Records

Hi

I need to update the price of multiple products using one form  i.e

Product  Price
ShoesUpdateable Text Field
Trainers Updateable Text Field
etc

I was going to name the text field newCost and loop through the list, but i
obviously need to pass the id as well. Would it be best to name the text box
with the id paramenter so each text box is unique? And then loop through the
form results matching the id before inserting the form value??

Jason 



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

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

Re: Extending Application.cfc using mappings

[marc --]

sorry for the double posting - it takes a while before posts get through here 
so I thought it got lost somehow (or I didn't post at all...).
I googled and found this on 
http://groups.google.com/group/farcry-beta/browse_thread/thread/7ec1c03df22675af
 suggesting mappings don't work with the extend keyword.

Application Specific Mappings are a furphy and do not work as
advertised in CF8.  It appears that cfimport and "extends" do not
adhere to application specific mappings as defined in Application.cfc
in the same way they do to CFIDE based cf mappings.  The two types of
"mapping" despite having the same name are very different in practice.
As we use inheritance and cfimport a great deal in FarCry this makes
using this feature near impossible. 

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

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

Re: Update multiple Records

[Azadi Saryev]

i would have the product id in the text field name for sure, like
newcost_#prod_id#.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Jason Congerton wrote:
> Hi
>
> I need to update the price of multiple products using one form  i.e
>
> Product  Price
> ShoesUpdateable Text Field
> Trainers Updateable Text Field
> etc
>
> I was going to name the text field newCost and loop through the list, but i 
> obviously need to pass the id as well. Would it be best to name the text box 
> with the id paramenter so each text box is unique? And then loop through the 
> form results matching the id before inserting the form value??
>
> Jason 
>
> 

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

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

Re: Update multiple Records

[Greg Morphis]

Yeah..  that's how I'd do it..
the text field's name would include a _#id# and use the '_' to find the ID..
Good job

On Fri, May 2, 2008 at 9:33 AM, Jason Congerton
<[EMAIL PROTECTED]> wrote:
> Hi
>
>  I need to update the price of multiple products using one form  i.e
>
>  Product  Price
>  ShoesUpdateable Text Field
>  Trainers Updateable Text Field
>  etc
>
>  I was going to name the text field newCost and loop through the list, but i 
> obviously need to pass the id as well. Would it be best to name the text box 
> with the id paramenter so each text box is unique? And then loop through the 
> form results matching the id before inserting the form value??
>
>  Jason
>
>  

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

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

Update multiple Records

[Jason Congerton]

Hi

I need to update the price of multiple products using one form  i.e

Product  Price
ShoesUpdateable Text Field
Trainers Updateable Text Field
etc

I was going to name the text field newCost and loop through the list, but i 
obviously need to pass the id as well. Would it be best to name the text box 
with the id paramenter so each text box is unique? And then loop through the 
form results matching the id before inserting the form value??

Jason 

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

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

Re: Foundry ServerIron

[Kevan Kern]

>We are trying to load balance our cold fusion servers with a Foundry 
>Serveriron 
>GT350. We are experiencing a delay when we connect through the VIP(4-5 
>seconds). 
>If we go straight to the real server we have no delay . Initially, the problem 
>appears to be with the Serveriron. We sniffed the connection and it appears 
>that 
>the Serveriron sends a "get", the real server sends and acknowledgment, but 
>then 
>takes 4-5 seconds to serve up the page. If you take the Serveriron out of the 
>picture it works fine but a capture shows that the Serveriron seems to be 
>waiting on the real server. To complicate things further stats from the 
>Coldfusion server show response times in milliseconds.  We are using 
>ColdFusion8, Apache and Foundry ServerIron GT350 (running code 9.5.02k). Has 
>anyone experienced similar issues?


Update...Turned out to be a DNS issue. Health checks were delayed and causing 
issues. Fixed DNS issues and restarted servers. After doing we no longer have 
the delay. 

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

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

Extending Application.cfc using mappings

[marc --]

Hello,
I want to extend ApplicationCMS.cfc I have in an off-webroor folder. I am on a 
shared hosting environment so I want to create my mappings in Application.cfc, 
not in Cfadministrator. The mappings are not recognized this way. When I create 
a mapping in the administrator (locally) it works. Here is the setup:

D:/www/components/ApplicationCMS.cfc
will be extended by
D:/www/wwwroot/ApplicationA/Application.cfc and 
D:/www/wwwroot/ApplicationB/Application.cfc

In D:/www/wwwroot/ApplicationA/Application.cfc I put:








If I request /ApplicationA/index.cfm I get 
 "Could not find the ColdFusion Component or Interface 
components.ApplicationCMS."
Apparently the mappping is not working. Does anyone know how it can be fixed?

Marc 

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

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

Extending Application.cfc using a mapping question

[marc --]

Hello,
I have a folder "components" off the webroot. I have 2 applications, A and B, 
both in their own webroot. I want both of them to extend the Application.cfc in 
the folder "components". So:
D:www/components/ApplicationRoot.cfc
is extended by
D:/www/wwwroot/ApplicationA/Application.cfc and 
D:/www/wwwroot/ApplicationB/Application.cfc.

To get this working I put this in D:/www/wwwroot/ApplicationA/Application.cfc:







But when I request /ApplicationA/nidex.cfm all I get is 

 Could not find the ColdFusion Component or Interface components.ApplicationCMS.

Am I doing somehing wrong here?
Thanks,
Marc 

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

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

Foundry ServerIron

[Kevan Kern]

We are trying to load balance our cold fusion servers with a Foundry Serveriron 
GT350. We are experiencing a delay when we connect through the VIP(4-5 
seconds). 
If we go straight to the real server we have no delay . Initially, the problem 
appears to be with the Serveriron. We sniffed the connection and it appears 
that 
the Serveriron sends a "get", the real server sends and acknowledgment, but 
then 
takes 4-5 seconds to serve up the page. If you take the Serveriron out of the 
picture it works fine but a capture shows that the Serveriron seems to be 
waiting on the real server. To complicate things further stats from the 
Coldfusion server show response times in milliseconds.  We are using 
ColdFusion8, Apache and Foundry ServerIron GT350 (running code 9.5.02k). Has 
anyone experienced similar issues? 

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

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

RE: CSS page calls and image calls from a CFC

[Scott Stewart]

Thanks Dominic, 

I really got thrown into components last year, because the project that I
was on was built with components, and they had the headers, footers and
common layout objects in components. So, I rolled with it.

I'm really making sure that my data layer is separated, as I start making
more sense out of design patterns (Doug from Allagad did a fantastic
presentation on this at the last TACFUG meeting) I'll revise my
methodologies.

What makes sense to me right now, is use components as much as possible
where applicable, and separate out data, layout and "widgets". I stole the
concept of act_ files (form actions) from Fusebox, and the unique content is
loaded in cfm files...

Probably more information than anyone wanted to know, but that's my current
state of development.
-- 
Scott Stewart
ColdFusion Developer
 
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(919) 874-6229 (home)
(703) 220-2835 (cell)

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 01, 2008 5:21 PM
To: CF-Talk
Subject: Re: CSS page calls and image calls from a CFC

>
> Why not? (asked looking for a legitimate reason, IE: x or y won't work
> properly if you do)


There's no solid reason *not* to, that I'm aware of, other than design
choice. I have built a display framework like this in the past and after it
launched I found that there was no real reason *to* put this kind of display
logic in a cfc because regular templates and custom tags handle this
perfectly (and were designed for this purpose). The design choice is in
separating logic from display; components for logic, custom tags and
coldfusion templates for display; clean.

Having said that, having an object that is an 'html framework' doesn't
present a particular problem if it is separated from business logic. Perhaps
someone can chime in with solid disadvantages to the display cfc approach -
for me, it is as simple as a) going with consensus b) making separation of
logic and display very clear.

I realised that changing framework isn't realistic halfway through (or more)
a project and I'm *not* saying *DONT* do what you are doing" Just raising it
as something to check out, if you weren't already aware, as you said you
were starting to write apps using cfcs. I personally found using an MVC
framework answered all the questions I had about creating apps utilizing
cfcs.

HTH

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk




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

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

RE: cfmail multipart emails and googlemail

[Will Swain]

Casey you are a star!!

That was exactly the problem and all fixed now.

Thanks so much and have a great weekend.

Will


-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED] 
Sent: 02 May 2008 13:01
To: CF-Talk
Subject: Re: cfmail multipart emails and googlemail

On Fri, May 2, 2008 at 6:54 AM, Will Swain <[EMAIL PROTECTED]> wrote:

> Update - it's displaying the plain text version  of the multipart 
> email, but without _some_ line breaks so the formatting is shot.
>
> Can google mail not display HTML emails then?
>

Yes it can but if you do not place mailpart text before mailpart html it
acts funky... see if that is your issue. Should be setup like below.














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

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

Re: cfmail multipart emails and googlemail

[Casey Dougall]

On Fri, May 2, 2008 at 6:54 AM, Will Swain <[EMAIL PROTECTED]> wrote:

> Update - it's displaying the plain text version  of the multipart email,
> but
> without _some_ line breaks so the formatting is shot.
>
> Can google mail not display HTML emails then?
>

Yes it can but if you do not place mailpart text before mailpart html it
acts funky... see if that is your issue. Should be setup like below.












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

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

mail attachments prob

[Richard Meredith-Hardy]

Sending a mail with an attachment. (works fine without)

Can someone explain why code which works fine in CF5 won't work in CF8?

Error in mail log is: IOException while sending message

I can't see anything immediately obvious from the documentation, a mime
type or something?  (these attachments are always pdf's)

Thanks

Richard




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

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

RE: cfmail multipart emails and googlemail

[Will Swain]

Update - it's displaying the plain text version  of the multipart email, but
without _some_ line breaks so the formatting is shot. 

Can google mail not display HTML emails then? 

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED] 
Sent: 02 May 2008 11:32
To: CF-Talk
Subject: cfmail multipart emails and googlemail

Hello list,
 
A number of my clients use an emailing tool we have built for them to send
multipart emails to their (opt in) mailing lists. These work very well in
general and they are happy.
 
However, there seem to be some issues with Google mail and the emails sent
out. It's almost as if the html version is displayed, but with all the
formatting and images removed, or the plain text version but with no line
breaks where they should be. Has anyone else come across this and is there a
simple solution? (I'm thinking probably not)
 
Thanks
 
Will




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

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

cfmail multipart emails and googlemail

[Will Swain]

Hello list,
 
A number of my clients use an emailing tool we have built for them to send
multipart emails to their (opt in) mailing lists. These work very well in
general and they are happy.
 
However, there seem to be some issues with Google mail and the emails sent
out. It's almost as if the html version is displayed, but with all the
formatting and images removed, or the plain text version but with no line
breaks where they should be. Has anyone else come across this and is there a
simple solution? (I'm thinking probably not)
 
Thanks
 
Will


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

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

RE: closing JDBC recordsets

[Richard Meredith-Hardy]

No, it's a SAGE proprietary db format, I forget its actual name, the ODBC
driver is theirs too. Suffice to say if you do a search for SAGE line 100
and ODBC and 'flaky' you get quite a few results

These days I think SAGE are using mssql or mysql as the core of their
accounts systems but despite my efforts to get my client to upgrade, so far
he has no desire to, so I'm stuck with the thing.

I think I'll stick with using the jdbc:odbc bridge which at least seems to
work in CF8;  previously I could only communicate with the thing via CF5.
As suggested, my CFC always converts the jdbc recordset into a cf query even
if in some cases there is an unnecessary overhead, and then the jdbc
recordsets can always be closed gracefully.

As an aside, it doesn't help that in line 100 a lot of the column names have
# in them, as in ADDRESS_LINE#1 

Thanks for all your suggestions anyway.

Richard



> -Original Message-
> From: denstar [mailto:[EMAIL PROTECTED] 
> Sent: 02 May 2008 07:40
> To: CF-Talk
> Subject: Re: closing JDBC recordsets
> 
> Is there any possibility that the database file format is DBASE?
> 
> That's the jdbc driver I was using for clipper, I think.
> 
> Maybe it's foxpro or something?
> 
> You might be able to find a more native driver, is what I'm, 
> um, driving at.
> 
> --
> Time is bunk.
> Douglas Adams
> 
> On Thu, May 1, 2008 at 8:40 AM, Richard Meredith-Hardy 
> <[EMAIL PROTECTED]> wrote:
> > In fact I'd tried this combination, but I tried again, and 
> no, doesn't 
> > work,  same as many other variants I've tried.
> >
> >  I've studied the two neos you suggest, the most 
> interesting thing I 
> > found is  in neo-query.xml where jdbc-odbc-bridge has an attribute 
> > 'handler' with a  value pointing at jdbcodbc.cfm which is in 
> > CFIDE\administrator\datasources\
> >
> >  I thought this might contain some interesting clues, but this cfm 
> > file is  encrypted...
> >
> >
> >  Richard
> >
> >  > -Original Message-
> >  > From: Dave Watts [mailto:[EMAIL PROTECTED]
> >
> > > Sent: 01 May 2008 13:44
> >  > To: CF-Talk
> >  > Subject: RE: closing JDBC recordsets  >
> >
> >
> > > > You're right, a standard datasource would be much 
> better, my direct
> >  > > access code which works (CF 8.1) is:
> >  > >
> >  > >  >  > > class="java.lang.Class">  >  > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")>
> >  > >  >  > > class="java.sql.DriverManager">
> >  > >  DriverManager.getConnection("jdbc:odbc:SAGE1;UID=xxx;
> >  > > PWD=yyy;")>
> >  > > 
> >  > > 
> >  > >
> >  > > Any suggestions what should go where in the administrator?
> >  > > I've tried quite a few combinations of settings for an 
> 'other' type
> >  > > datasource, some 'verify', but if you run a query 
> against the DS I
> >  > > always get: "Error Executing Database Query.  Option 
> out of range"
> >  >
> >  > If you take a look at neo-query.xml and neo-datasources.xml,
> >  > you should see the values used when you create a normal
> >  > datasource. You should be able to reverse-engineer that a bit
> >  > to figure out which values go where. That said, I think these
> >  > would be the right values:
> >  >
> >  > JDBC URL: jdbc:odbc:SAGE1;
> >  > Driver Class: sun.jdbc.odbc.JdbcOdbcDriver Driver Name: 
> JdbcOdbcDriver
> >  > Username: whatever you're putting in UID above
> >  > Password: whatever you're putting in PWD above
> >  >
> >  > Dave Watts, CTO, Fig Leaf Software
> >  > http://www.figleaf.com/
> >  >
> >  > Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> >  > http://training.figleaf.com/
> >  >
> >  > WebManiacs 2008: the ultimate conference for CF/Flex/AIR 
> developers!
> >  > http://www.webmaniacsconference.com/
> >  >
> >  >
> >
> >  
> 
> 

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

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

veiws (was: Re: CSS page calls and image calls from a CFC)

[denstar]

On Thu, May 1, 2008 at 3:21 PM, Dominic Watson
<[EMAIL PROTECTED]> wrote:
> >
> > Why not? (asked looking for a legitimate reason, IE: x or y won't work
> > properly if you do)
>
> There's no solid reason *not* to, that I'm aware of, other than design
> choice. I have built a display framework like this in the past and after it
> launched I found that there was no real reason *to* put this kind of display
> logic in a cfc because regular templates and custom tags handle this
> perfectly (and were designed for this purpose). The design choice is in
> separating logic from display; components for logic, custom tags and
> coldfusion templates for display; clean.

There didn't used to be CFCs... /memories  :]

It's cool this came up, because I've always had a problem with the
"throw away" attitude I seem to see about views, or user interfaces,
and MVCs.

Like, with MG2, adding view mappings help me not have do a lot of
cutting and pasting for standard display things.

CSS is a great way of having generic views... I love it.

So I'm starting to think, "what about ui components?"  Maybe decorators?

Like, I want to release some action packs some day (ha ha), and it
would be pretty cool if it was easy to have them work across
frameworks.

It's sorta seeming to me like that would be easiest if I handled some
of the views/UI "outside" the frameworks themselves.

I don't want to have to maintain 5 different versions of the calendar
view, ya know?  "People" is another object that gets used mostly the
same across projects... one "pretty print toString()" with a some CSS*
tags could take care of 99% of your person "views".  But it's all a
matter of balance... and keeping UI and Core code distinct is of
course always good, as distinction of concerns usually is.
*maybe your own meta-langage, instead of CSS, so you could use advice
and format for various outputs...

So long as you keep your UI components loosely coupled to your core
components, couldn't they be a Good Thing?

:>e/\/

--
A wind has blown the rain away and blown the sky away and all the
leaves away, and the trees stand. I think, I too, have known autumn
too long.
e. e. cummings

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

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

RE: CFPDF - Watermark Like Effect

[Stephen Cassady]

Update - I'm an idiot for not proof checking: 
Bottom left to Top left (run along the left hand edge).
Everything else is the same issue. LOL

Stephen 



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

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

JBoss'n it (was: Re: CFMX8 - Standard vs. Enterprise)

[denstar]

On Thu, May 1, 2008 at 9:12 AM, Larry Lyons <[EMAIL PROTECTED]> wrote:


> If you're running CF8 under JBoss then you're running the enterprise
> version. To get the jboss to cluster is very easy, just make sure you're
> running the all services version of JBoss, (run - c all when starting up
> JBoss). The jboss instance will check the subnet that its on for any other
> running jboss instances and if there, it will either create or join a
> cluster at that point. Then to deploy, all you need to do is to drop your
> war or ear file into the farm directory in the
> //servers/all/farm directory. The Jboss instance will then
> deploy the war or ear file to the remaining JBoss instances in the cluster.


I've been waiting till we get some more CF8's to do clustering on JBoss.
That sounds amazingly simple.

Hmmm... now to find a good way to keep the file systems in sync, since I've
started generating a lot of static content...  :-P


> If you need load balancing and failover then you can add Apache and mod_jk
> to handle that.


AJP is where it's at, hombre.  :-)

I'm really loving having static stuff just served up by apache and only
ringing CF when there's some thinking to be done.


> As an alternative to CF8 Enterprise, if you do not need the CF8 specific
> stuff, you may want to consider Open Blue Dragon - the open source version
> of BlueDragon for J2EE. The cost is very good, (open source ie free as in
> speech and beer), and its simple to setup and deploy. Just war up your files
> along with the bd files and drop it into the deploy directory of your jboss
> instance.


 At this point, so much is being handled by specialized software, I could
probably use just about anything.  I do like model-glue and ORMs, so that
would be swell... but after getting into hibernate, I'm wondering about
where to keep my model.  The tools for Java are so nice...  so I'm left with
like a front-end controller... *sigh* *shrug*.

JBoss is freaking insane tho.  Wow, talk about a lot of cool stuff.  I've
really enjoyed using it.  Plus, lots of nifty plugins for Eclipse ;-)

It would be interesting to fire up another cf engine, and see if much of my
stuff runs on it... I've never really taken any of the others out for a
spin.

I've got a certain loyalty to the original, and none of the open source ones
really seemed open source...  still, as someone heatedly pointed out a while
back, it's the decent thing to do.  If I have something nifty, I guess I
don't want to lock the other engines out...

At any rate, with CF8 and JBoss, I've been happy.  Now I can run
jasperserver and whatnot in the same setup (easy, vs. sorta hard w/jrun).
And I have to say it again... the stuff you can plug into jboss... wow.

Ok, enough happy-happy joy-joy, I reckon.  Just wanted to voice a "CF8 and
JBoss are the bee's knees" me too type-of-comment.  =]

|Denny

--
I thank you God for this most amazing day, for the leaping greenly spirits
of trees, and for the blue dream of sky and for everything which is natural,
which is infinite, which is yes.
 e. e. cummings


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

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

CFPDF - Watermark Like Effect

[Stephen Cassady]

Hi all,
Here's what I would like to do, and I've not found a good process yet to do
this.

I would like to take a PDF that is already loaded onto the server, and then
run a strip of, say 10 point text, from the bottom left corner towards the
top right corner on each page. The text to run would be dynamically
generated (though the same text for each page).

I've look at a good process to do this with CF801, and haven't found a nice,
simple, workflow. I even thought of creating a PDF in memory holding the
text, and watermarking that to the existing pdf, but the watermark function
doesn't take in memory pdf for the watermark text, only for the document to
watermark onto.

Does anybody have suggestions on a good approach to this issue?
Thanks - 
Stephen



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

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