Report builder charset?

2008-10-14 Thread bert db
Hi,

I have some report created with the report builder MX7. I am running into some 
problems with the charset it uses. Some of my users have put some exotic 
caracters in text fields (principally the '€' sign). I have no problems 
within my coldfusion pages but in the generated pdf, it prints out as a '?'. 

I was wondering if anybody knows how to specify the charset that the builder 
should use, or if anybody knows the charset used by the report builder (there 
is always a way to change the charset returned by the DB). I have looked in the 
docs but could not find anything about this.

Thanks,
B.

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313837
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Report builder charset?

2008-10-14 Thread Paul Hastings
bert db wrote:
 I have some report created with the report builder MX7. I am running into
 some problems with the charset it uses. Some of my users have put some exotic

exotic? not to them i imagine.

 caracters in text fields (principally the '€' sign). I have no problems
 within my coldfusion pages but in the generated pdf, it prints out as a '?'.

plain cf/html works ok?

 I was wondering if anybody knows how to specify the charset that the builder
 should use, or if anybody knows the charset used by the report builder (there
 is always a way to change the charset returned by the DB). I have looked in
 the docs but could not find anything about this.

press F8 to get the preferences dialog (for some strange reason it's under the 
edit menu), the PDF character encoding value should be Identity-H not 
windows codepage 1252 (cp-1252 which i think doesn't contain the euro).


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313838
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Creating a datasource against sql 2005 express on fly for coldfusion8

2008-10-14 Thread Dave Watts
 Per another thread and based on Andy Allan's pointer and Nasir Ghaznavi's 
 additional
 input, creating a datasource against a sql 2000 db was successful (did that a 
 while ago),
 however, I think the Macromedia's JDBC does not support connection to a sql 
 2005
 express database, for I've tried both manual and automatic ds setup to no 
 avail.

The SQL Server driver that comes with CF can connect to any version of
SQL Server 2005 including Express.

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

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

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313844
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOT: Apache and Windows resources

2008-10-14 Thread Dave Watts
 Trying to setup some Alias paths, within Apache, exposing resources
 available on a Storage Area Network. These are primarily media type
 resources (site.com/images, site.com/media, etc.)

 When working with IIS, you set these up as Virtual Directories, and
 apply any user permissions within that directory's Properties. Access
 permissions are defined by a Domain Controller.

 So, the question is, how do you cover the same directory authorization
 within an Apache configuration? I've done Aliases to UNC resources in
 the past, but never had to worry about the DC authorization before.
 Anyone have an idea as to how this authorization is configured?

Since Apache isn't capable of user impersonation as IIS is, you will
need to run Apache as a user with access to those remote resources.

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

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

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313845
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOT: Apache and Windows resources

2008-10-14 Thread Cutter (CFRelated)
Thanks Dave. I was afraid of that, as those resources reside in a 
different domain. I'll have to hack through some testing. Thanks again 
for your response.

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Dave Watts wrote:
 Trying to setup some Alias paths, within Apache, exposing resources
 available on a Storage Area Network. These are primarily media type
 resources (site.com/images, site.com/media, etc.)

 When working with IIS, you set these up as Virtual Directories, and
 apply any user permissions within that directory's Properties. Access
 permissions are defined by a Domain Controller.

 So, the question is, how do you cover the same directory authorization
 within an Apache configuration? I've done Aliases to UNC resources in
 the past, but never had to worry about the DC authorization before.
 Anyone have an idea as to how this authorization is configured?
 
 Since Apache isn't capable of user impersonation as IIS is, you will
 need to run Apache as a user with access to those remote resources.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313848
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Can you reload a page with a PDF in it?

2008-10-14 Thread Andrew Fandre
I have a frameset layout (hey it works for this instance!). 

The larger frame gets loaded with a pdf from the smaller frame. The smaller 
frame has some user variables that make up the dynamic pdf. The javascript call 
loads the initial page just fine, but subsequent calls don't reload the page.

parent._largeFrame.document.location.replace(url + variables);

It works great until the page is loaded with a pdf, then the javascript doesn't 
reload the page with new variables. Is there a way to make javascript reload 
the frame when a PDF is already on the page? 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313849
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Loathe
We already have a PDF solution in place.  Which is great if they just 
need to print the document.  They also want to be able to save, edit and 
pass around the document.

I'm just doing what the client has told me, word is what they want.

Tom Chiverton wrote:
 On Monday 13 Oct 2008, Loathe wrote:
 I have to create very large (sometimes hundreds of pages) word documents
 from CF with some pretty specific formatting and layout rules.
 
 Is PDF not an option ? You've jumped straight to a technology specific answer 
 twice now, with out explain the actual intent of your application.
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313843
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Report builder charset?

2008-10-14 Thread bert db
bert db wrote:
 I have some report created with the report builder MX7. I am running into
 some problems with the charset it uses. Some of my users have put some exotic

exotic? not to them i imagine.

Probably not to them ;-) If only everybody used only ASCII chars our job would 
be a lot easier ;-)


 caracters in text fields (principally the '€' sign). I have no problems
 within my coldfusion pages but in the generated pdf, it prints out as a '?'.

plain cf/html works ok?

the cfr is called from a simple cf page where I define the query, and when in 
that page I do a simple cfoutput of the info it prints correctly.


 I was wondering if anybody knows how to specify the charset that the builder
 should use, or if anybody knows the charset used by the report builder (there
 is always a way to change the charset returned by the DB). I have looked in
 the docs but could not find anything about this.

press F8 to get the preferences dialog (for some strange reason it's under the 
edit menu), the PDF character encoding value should be Identity-H not 
windows codepage 1252 (cp-1252 which i think doesn't contain the euro).

I tried this option, it did remove the '?' character, but unfortunately it does 
not print anything.

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313846
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Weird performance issue with cluster

2008-10-14 Thread David Stockton
Brad's steps would be a great place to start looking. I work for Intergral - 
the makers of FusionReactor (http://www.fusion-reactor.com/) - it's an 
alternative to SeeFusion.

Usually when we see this behaviour it's due to sticky sessions being enabled 
and the busy sessions are simply hitting the same instance.

There's plenty of data the FusionReactor interface and logs can give you about 
this and we also have a consultancy service which handles this type of problem. 
As Brad suggests, it would be worth checking your CF  JVM settings are equal 
on both instances. Are you running on JRun or another server? Are you using 
session sharing? As this can sometimes cause one server to perform badly. 
FusionReactor also captures additional metrics which could be of use in this 
case.

Additionally, if this is an intermittent issue, with FusionReactor you could 
use the AIR dashboard to sit in your system tray to alert you when a problem 
start to occur. That way you don't have to actively monitor your servers by 
checking a web-page - it will alert you when the problem starts to occur.

Feel free to get in touch on (678) 389 9499 (US) for some advice. Alternatively 
you can call me direct in our UK office 011 44 207 193 1212.

Good luck,
David Stockton 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313839
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Tom Chiverton
On Monday 13 Oct 2008, Loathe wrote:
 I have to create very large (sometimes hundreds of pages) word documents
 from CF with some pretty specific formatting and layout rules.

Is PDF not an option ? You've jumped straight to a technology specific answer 
twice now, with out explain the actual intent of your application.

-- 
Tom Chiverton
Helping to confidentially conquer networks





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;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313842
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 you reload a page with a PDF in it?

2008-10-14 Thread Jason Fisher
Try using

parent._largeFrame.document.location.href = url + variables;

You need to make it actually run the whole page request in that target frame, 
not just refresh.  If you pull up your dynamic PDF in a simple window, for 
example, and then hit F5, you'll see the binary output ... the headers don't 
re-render or something.  I'm guessing it's the same in a frameset.

Worth a shot :)


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313850
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Simple regex question...

2008-10-14 Thread Che Vilnonis
Morning all. I need a RegEx to strip all of the characters that appear after
the *last* dash in a string (the last dash needs to be stripped as well).
How would I do something like that? Sample data is below. Thanks!

2995,2818-5
33054--2
3320-4
7789-4(1)
3641-45-1

Che Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com 




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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313851
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Simple regex question...

2008-10-14 Thread Adrian Lynch
ListLast(theString, -)

Adrian
Building a database of ColdFusion errors at http://cferror.org/

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: 14 October 2008 15:27
To: cf-talk
Subject: Simple regex question...


Morning all. I need a RegEx to strip all of the characters that appear after
the *last* dash in a string (the last dash needs to be stripped as well).
How would I do something like that? Sample data is below. Thanks!

2995,2818-5
33054--2
3320-4
7789-4(1)
3641-45-1

Che Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313852
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Tom Chiverton
On Tuesday 14 Oct 2008, Loathe wrote:
 We already have a PDF solution in place.  Which is great if they just
 need to print the document.  They also want to be able to save, edit and
 pass around the document.

Perfectly possible in a PDF file format. Sometimes without paying Adobe 
(OpenOffice v3, for example).

-- 
Tom Chiverton
Helping to appropriately deploy segments





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;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313854
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Info box Question

2008-10-14 Thread Austin Band
I am using the info attribute for cf_if_field. My issue is that the info box 
positions at the top of the form and not by the area being referred to. Is 
there a simple way to reposition? 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313855
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Simple regex question...

2008-10-14 Thread Che Vilnonis
Adrian, Azadi... Thanks, that worked.  

-Original Message-
From: Azadi Saryev [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 14, 2008 10:35 AM
To: cf-talk
Subject: Re: Simple regex question...

how about just
left(string, len(string)-len(listlast(string, -))-1) ?

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



Che Vilnonis wrote:
 Morning all. I need a RegEx to strip all of the characters that appear 
 after the *last* dash in a string (the last dash needs to be stripped as
well).
 How would I do something like that? Sample data is below. Thanks!

 2995,2818-5
 33054--2
 3320-4
 7789-4(1)
 3641-45-1

 Che Vilnonis
 Application Developer
 Advertising Systems Incorporated
 8470C Remington Avenue
 Pennsauken, NJ 08110
 p: 856.488.2211
 f: 856.488.1990
 www.asitv.com

   



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313856
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Simple regex question...

2008-10-14 Thread Azadi Saryev
how about just
left(string, len(string)-len(listlast(string, -))-1) ?

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



Che Vilnonis wrote:
 Morning all. I need a RegEx to strip all of the characters that appear after
 the *last* dash in a string (the last dash needs to be stripped as well).
 How would I do something like that? Sample data is below. Thanks!

 2995,2818-5
 33054--2
 3320-4
 7789-4(1)
 3641-45-1

 Che Vilnonis
 Application Developer
 Advertising Systems Incorporated
 8470C Remington Avenue
 Pennsauken, NJ 08110
 p: 856.488.2211
 f: 856.488.1990
 www.asitv.com 

   

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313853
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Creating a datasource against sql 2005 express on fly for coldfusion8

2008-10-14 Thread Don L
  Per another thread and based on Andy Allan's pointer and Nasir 
 Ghaznavi's additional
  input, creating a datasource against a sql 2000 db was successful 
 (did that a while ago),
  however, I think the Macromedia's JDBC does not support connection 
 to a sql 2005
  express database, for I've tried both manual and automatic ds setup 
 to no avail.
 
 The SQL Server driver that comes with CF can connect to any version 
 of
 SQL Server 2005 including Express.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

Thanks, Dave, but it's a bit odd.  Previously I've tried to use the MS SQL 
Server driver that comes with cf8 to no avail, but just now, it works, I think 
I used same setting/parameters, maybe I wasn't careful enough, possible.  Now, 
a problem, when referencing a sql server 2005's instance, one has to use the 
exact machine name but not (local) nor (localhost), but I need to use a generic 
one -- OS = XP w/ SP3. Tring to find the computer's name may likely be blocked 
for security reason. Further thought?


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313858
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Jim Davis
 -Original Message-
 From: Tom Chiverton [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 14, 2008 10:36 AM
 To: cf-talk
 Subject: Re: docx (office 2007) from CF? (Cross)
 
 On Tuesday 14 Oct 2008, Loathe wrote:
  We already have a PDF solution in place.  Which is great if they just
  need to print the document.  They also want to be able to save, edit
 and
  pass around the document.
 
 Perfectly possible in a PDF file format. Sometimes without paying Adobe
 (OpenOffice v3, for example).

I'm just a poor country chicken... but this here OpenOffice don't seem
like it's Word.

Seriously tho' - the requirement is to do this in Word.  It's nonsensical to
suggest non-Word alternatives.  The client-side requirements are immutable.

That said, Loath, the link provided should give all the information about
the format. I'm sure you've thought of this but I'll say it anyway: don't
try to build the doc from scratch.  What you've described seems pretty
formulaic (complex, but formula) - create a template that contains all the
elements and look to add/edit new nodes as needed rather than build from
scratch.

In my experience with formats like this (I've not done DocX, but I have
dealt with similar) the key is to let the native tool do as much of the work
as possible.  Doing small changes natively then comparing (diffing) that doc
to the previous one can be invaluable.

While developing test CONSTANTLY because even small changes can have
dramatic effects.  I also strongly urge to have the output checked out by
multiple people: in docs like this there are so many little things to go
wrong.  The more eyeballs the better.

Sorry I can't be more specific.

Jim Davis


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313862
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Creating a datasource against sql 2005 express on fly for coldfusion8

2008-10-14 Thread Jason Fisher
You can use the IP address, if that's an available option for you.  Even 
127.0.0.1, if you're (horrors) running MSSQL and CF on the same box.



 Thanks, Dave, but it's a bit odd.  Previously I've tried to use the MS 
 SQL Server driver that comes with cf8 to no avail, but just now, it 
 works, I think I used same setting/parameters, maybe I wasn't careful 
 enough, possible.  Now, a problem, when referencing a sql server 
 2005's instance, one has to use the exact machine name but not (local) 
 nor (localhost), but I need to use a generic one -- OS = XP w/ SP3. 
 Tring to find the computer's name may likely be blocked for security 
 reason. Further thought?


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313861
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


SOT: Jquery VISTA (IE)

2008-10-14 Thread Qasim Rasheed
Apologies for slightly off topic post but based on number of JQuery guru on
this list, I thought someone might be able to shed some light. Here is the
message that I posted on jQuery list few moments ago
I am having a strange problem with performing a simple AJAX call on a Vista
machine using IE as the browser. The same request work fine with Firefox on
the same machine. Here is the sample code

script src=jquery.js/script
script
$(function(){
$(#temp).load(test2.cfm);
});
/script
div id=temp
/div

The error I get in the script window will be Automation Server can't create
object. Any idea?


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313864
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 you reload a page with a PDF in it?

2008-10-14 Thread s. isaac dealey
 parent._largeFrame.document.location.replace(url + variables);

You might try this: 

framset
frame name=_smallFrame /
frame name=_largeFrame id=_largeFrame /
/frameset

And JS: 

parent.document.getElementById('_largeFrame').src = url + variables; 

I don't think it will have quite the same effect as replace() but it
should get around whatever issue is going on with the pdf plugin not
supporting the javascript. 

I think you might be able to use removeNode() and appendNode() as an
alternative if you built a new frame with document.createElement(). 


-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 781.769.0723

http://onTap.riaforge.org/blog



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313857
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: checking for the existence of a dynamic variable

2008-10-14 Thread Scott Stewart
Thank you sir,

that worked like a champ :)

sas

Azadi Saryev wrote:
 cfif structkeyexists(form, 'MGMT_HEADER_'  i)

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



 Scott Stewart wrote:
   
 cfloop index=Counter from=#i# to=#structCount(session.eformadmin)#
 cfif #form[MGMT_HEADER_i]# is not 
 cfset headerId = #form[MGMT_HEADER_i]#/
 cfelse
 /cfif   
 cfset i = i+1/
 /cfloop


 Hey all,

 the above code returns the error  Element MGMT_HEADER_2 is undefined in 
 a Java object of type class coldfusion.filter.FormScope.

 How would I code the IsDefined for this?


   
 

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313865
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Simple regex question...

2008-10-14 Thread Peter Boughton
I need a RegEx to strip all of the characters that appear after
the *last* dash in a string (the last dash needs to be stripped as well).

To match the last dash and everything after it, you want:
-[^-]*$

So to use that to strip of that segment of the string, just do:
dashless = rereplace( dashed , '-[^-]*$' , '' ) 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Creating a datasource against sql 2005 express on fly for coldfusion8

2008-10-14 Thread Don L
 You can use the IP address, if that's an available option for you.  
 Even 127.0.0.1, if you're (horrors) running MSSQL and CF on the same 
 box.
 

Beautiful, thanks.  Previously I also tried it to no avail, maybe then my 
network security/firewall/anti-virus program setup etc. messed it up. 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: checking for the existence of a dynamic variable

2008-10-14 Thread Peter Boughton
cfloop index=Counter from=#i# to=#structCount(session.eformadmin)#
cfif #form[MGMT_HEADER_i]# is not 
cfset headerId = #form[MGMT_HEADER_i]#/
cfelse
/cfif   
cfset i = i+1/
/cfloop

What's up with that odd looping? :/


It seems like your code could be simplified...

cfloop index=i from=1 to=#StructCount(session.eformadmin)#
cfif StructKeyExists( form , MGMT_HEADER_i )
AND form[MGMT_HEADER_i] is not 
cfset headerId = form[MGMT_HEADER_i]/
/cfif
/cfloop

(with the structkeyexists added where I assume you want it)



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Report builder charset?

2008-10-14 Thread Paul Hastings
bert db wrote:

 I tried this option, it did remove the '?' character, but unfortunately it 
 does not print anything.

got the right font (ie one that supports those chars)? what's the app's 
intended 
encoding?


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313869
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Jim Davis
 -Original Message-
 From: Shannon Peevey [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 14, 2008 12:41 PM
 To: cf-talk
 Subject: Re: docx (office 2007) from CF? (Cross)
 
 
 
  
   Perfectly possible in a PDF file format. Sometimes without paying
 Adobe
   (OpenOffice v3, for example).
 
  I'm just a poor country chicken... but this here OpenOffice don't
 seem
  like it's Word.
 
  Seriously tho' - the requirement is to do this in Word.  It's
 nonsensical
  to
  suggest non-Word alternatives.  The client-side requirements are
 immutable.
 
 
 OpenOffice can convert between Microsoft Office and other document
 formata,
 (server-side).  (It's really probably the best there is at this).
 OpenDocument Format is the original standard for file representation, (
 ISO/IEC 26300:2006 Open Document Format for Office Applications
 (OpenDocument) v1.0), so I don't know why Microsoft pursued a second
 standard...  Last but not least, Microsoft Office will soon support
 OpenDocument Format, (
 http://www.microsoft.com/Presspass/press/2008/may08/05-
 21ExpandedFormatsPR.mspx).

And it could turn water to wine, heal the sick and offer sexual favors for
free... but it's not what the client uses.

Also remember: the MS XML format was first released with Office 2003 and
refined for Office 2007 - the OpenFormat wasn't approved until 2005.  Even
Open Office itself still isn't (last I heard) in full compliance.

There are also several problems with the standard that further explain MS's
decision.  The released version of the standard, for example, doesn't
support tables in presentations (a staple of PowerPoint).  There's no
standardized way to include programmatic functionality (macros,
accelerators, Smart Tags, etc - staples of Office).  There are other
features of Office not supported by the standard as well.

Even the open source community can't decide... support ODF or CDF?  And, of
course, nearly all the documentation on this stuff is available in PDF (a
format more closed than OOXML).

But in the end you're absolutely correct: any format that gains significant
critical mass is going to be supported by nearly everything.

To be honest I'd be happy to see either on in day-to-day use.  My (large,
unwieldy and sluggish) company is still standardized on Office 2000 and a
9-year old version of DocuMaker Studio for online forms and letters.  XML?
What's that?

We're far from alone in that... and I guarantee that one of the side-effects
of the financial crisis will be a propensity to delay new software adoption
among large companies.  So this whole argument will be going on for at least
another few years.

 I see your point, though :)

Oh... then nevermind. ;^)

Jim Davis


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313870
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


checking for the existence of a dynamic variable

2008-10-14 Thread Scott Stewart
cfloop index=Counter from=#i# to=#structCount(session.eformadmin)#
cfif #form[MGMT_HEADER_i]# is not 
cfset headerId = #form[MGMT_HEADER_i]#/
cfelse
/cfif   
cfset i = i+1/
/cfloop


Hey all,

the above code returns the error  Element MGMT_HEADER_2 is undefined in 
a Java object of type class coldfusion.filter.FormScope.

How would I code the IsDefined for this?


-- 
Scott Stewart
ColdFusion Developer

Office of Research Information Systems
Research amp; Economic Development
University of North Carolina at Chapel Hill

Phone:(919)843-2408
Fax: (919)962-3600
Email: [EMAIL PROTECTED]



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313859
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CF_IF_FIELD Question

2008-10-14 Thread Austin Band
I am using the info attribute for cf_if_field. My issue is that the info box 
positions at the top of the form and not by the area being referred to. Is 
there 
a simple way to reposition? 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF_IF_FIELD Question

2008-10-14 Thread Raymond Camden
cf_if_field? What is that?

On Tue, Oct 14, 2008 at 1:03 PM, Austin Band [EMAIL PROTECTED] wrote:
 I am using the info attribute for cf_if_field. My issue is that the info box
 positions at the top of the form and not by the area being referred to. Is 
 there
 a simple way to reposition?




-- 
===
Raymond Camden, VP of Software Dev, Broadchoice

Email: [EMAIL PROTECTED]
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313872
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF_IF_FIELD Question

2008-10-14 Thread Peter Boughton
cf_if_field? What is that?

It is so tempting to write a patronising reply about custom tags. ;)


But anyway, Google suggests it's part of iFrame (short for Internet 
Framework):
http://cfiframe.sourceforge.net/

And based on this screenshot...
http://cfiframe.sourceforge.net/screenshots/sc4.jpg
...the infobox *does* appear to display next to the appropriate field.

Which would lead me to think that there's a JavaScript error higher up the page 
which is preventing it working for the OP.

Austin: Check if you've got any JavaScript errors? 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313875
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: checking for the existence of a dynamic variable

2008-10-14 Thread Scott Stewart
grinding code out quickly

Peter Boughton wrote:
 cfloop index=Counter from=#i# to=#structCount(session.eformadmin)#
cfif #form[MGMT_HEADER_i]# is not 
cfset headerId = #form[MGMT_HEADER_i]#/
cfelse
/cfif   
cfset i = i+1/
 /cfloop
 

 What's up with that odd looping? :/


 It seems like your code could be simplified...

 cfloop index=i from=1 to=#StructCount(session.eformadmin)#
 cfif StructKeyExists( form , MGMT_HEADER_i )
   AND form[MGMT_HEADER_i] is not 
   cfset headerId = form[MGMT_HEADER_i]/
 /cfif
 /cfloop

 (with the structkeyexists added where I assume you want it)



 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313876
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF_IF_FIELD Question

2008-10-14 Thread Peter Boughton
I am referring to:
CF_if_Field
CAPTION = Test
NAME = eXAMPLE
INFO = POPUP INFO

This is a third-party custom tag, part of the iFrame framework I linked in my 
other post.
Anything starting cf_ is NOT part of ColdFusion, but is an extension written 
by someone else.

Somewhere in your webroot you will have an if_field.cfm file, which contains 
the CFML code which executes when this tag is used - there might be clues in 
there as to why the info box is not working for you. 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313877
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF_IF_FIELD Question

2008-10-14 Thread Gerald Guido
It looks like you are using this. That is the only thing that CF_if_Field
returned on google.
http://cfiframe.sourceforge.net/

This is not standard CF tag, it is custom tag. You will have to ask the ppl
that wrote the tag.

G


On Tue, Oct 14, 2008 at 2:31 PM, Austin Band [EMAIL PROTECTED] wrote:

 I am referring to:
 CF_if_Field
 CAPTION = Test
 NAME = eXAMPLE
 INFO = POPUP INFO




 I am using the info attribute for cf_if_field. My issue is that the info
 box
 positions at the top of the form and not by the area being referred to. Is
 there
 a simple way to reposition?

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313878
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Weird performance issue with cluster

2008-10-14 Thread Rick Root
On Tue, Oct 14, 2008 at 12:07 AM, Brad Wood [EMAIL PROTECTED] wrote:
 Why don't you do what you're about to pay WebApper to do (Not that their
 expert advice isn't worth paying for :)?

 1) Install SeeFusion with JDBC URL wrappers

webapper has already done this. =)  They're using SeeFusion for their
consulting gig but we have licenced FusionReactor for our own
purposes.  Though so far they've been unable to tell me why instance 1
is slower than instance 2.

 Do you have sticky sessions enabled?

Yes, had them enabled.  Disabled them and restarted services about 10
minutes ago.  Also changed the weighting to 50/50  for some
reason, isntance 2 is still handling 3x the requests.

 What's the chance that one or more users running long reports are getting
 stuck on instance 1 and dragging up the average page request?

I'm looking at a graph of completed request time right now... and
the requests on instance 1 are completing in an average of 800ms right
now.. while on instance 2 (keep in mind, instance 2 is handling 3x as
many requests), the average completion time is about 250ms.

Nothing appears to be dragging up the average page request every
page on instance 1 seems to be running slower.

 Do you have any scheduled tasks on instance 1 that are not on instance 2
 that would affect the overall average?

No.  There is one on instance 1 that runs at 6:30am but it wouldn't
affect the ongoing page request time, and it certainly wouldn't affect
the number of requests being directed at instance 1 vs. instance 2.

 Are both instances using the same jvm.config file?

Yes.  Same settings all the way.

 Are save class files and trusted cache enabled for both instances?

save class files is enabled.  Trusted cache isn't (for reasons I won't go into)

Rick

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313879
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Running ColdFusion as a specific user in a Multiserver environment

2008-10-14 Thread Laura Norris
We are trying to reconfigure our CF server to run as a user instead of under 
the administrator account.  Does anyone know the steps to do this in a 
multiserver environment?  We have two instances running.

We followed the instructions in the TechNote, but it doesn't seem to work.

Any help would be appreciated.

Thanks,

Laura

TechNote: 
http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17279sliceId=1 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313880
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Creating a datasource against sql 2005 express on fly for coldfusion8

2008-10-14 Thread Jason Fisher
  You can use the IP address, if that's an available option for you.  
 
  Even 127.0.0.1, if you're (horrors) running MSSQL and CF on the same 
 
  box.
  
 
 Beautiful, thanks.  Previously I also tried it to no avail, maybe then 
 my network security/firewall/anti-virus program setup etc. messed it 
 up. 

Cool, glad that worked.  Also be careful of named instances, if you have any 
servers with more than one MSSQL instance on them: IP won't be sufficient in 
those cases since you'll also need the instance name (127.0.0.1\instance-name 
or whatever). 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313874
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFDocument? No Soup for YOU!

2008-10-14 Thread Andrew Fandre
 AppServer: JRun4
 version: CFMX7.0.2.142
 tag: CFDOCUMENT TYPE=PDF
 issue: I'm using a proxy file to pull a file from a directory not in 
 webroot to pull an image into my page. 
 
 The image is pulled out of the off-root directory with a CFHEADER 
 content-disposition value=attachment; filename=#filename# and a 
 CFCONTENT TYPE=octet-stream to make it a generic catch-all file 
 getter.
 
 When I pull images this way in a img src=#filename#/ in straight 
 CFML it works! But pull the image into a CFDOCUMENT and it gives me 
 the dreaded red-x.
 
 I'd appreciate any insight from brains bigger than mine, cause 
 there'snot many smaller... 

Decided to work around this problem by using CFFile action=copy to move the 
file with CGI and local variables to a webroot accessible folder. Not the best 
solution, but it got it done...


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313847
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Shannon Peevey


 
  Perfectly possible in a PDF file format. Sometimes without paying Adobe
  (OpenOffice v3, for example).

 I'm just a poor country chicken... but this here OpenOffice don't seem
 like it's Word.

 Seriously tho' - the requirement is to do this in Word.  It's nonsensical
 to
 suggest non-Word alternatives.  The client-side requirements are immutable.


OpenOffice can convert between Microsoft Office and other document formata,
(server-side).  (It's really probably the best there is at this).
OpenDocument Format is the original standard for file representation, (
ISO/IEC 26300:2006 Open Document Format for Office Applications
(OpenDocument) v1.0), so I don't know why Microsoft pursued a second
standard...  Last but not least, Microsoft Office will soon support
OpenDocument Format, (
http://www.microsoft.com/Presspass/press/2008/may08/05-21ExpandedFormatsPR.mspx).

I see your point, though :)
speeves


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: OT CF 8 tag posters available to UK developers

2008-10-14 Thread Tom Chiverton
On Friday 10 Oct 2008, Will Swain wrote:
 You haven't sent me an email yet. :)

It left here:
CC: Will Swain [EMAIL PROTECTED]
Date: Friday 15:33:57
-- 
Tom Chiverton
Helping to conveniently foster mission-critical systems





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;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313841
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Running ColdFusion as a specific user in a Multiserver environment

2008-10-14 Thread Laura Norris
we are running CF 7 on Windows 2003 Server.

does that make any difference? 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313882
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Running ColdFusion as a specific user in a Multiserver environment

2008-10-14 Thread Jochem van Dieten
Laura Norris wrote:
 We are trying to reconfigure our CF server to run as a user instead of under 
 the administrator account.  Does anyone know the steps to do this in a 
 multiserver environment?  We have two instances running.
 
 We followed the instructions in the TechNote, but it doesn't seem to work.

The technote works if you have a default Windows configuration (since 
you say administrator account I presume Windows). It actually gives to 
many permissions to the new account, I typically restrict it a lot more:
http://jochem.vandieten.net/2008/04/06/windows-file-permissions-for-the-coldfusion-account/

Anyhow, to debug you problem check your *-out.log and if that doesn't 
have anything check the permissions on your *-out.log.

Jochem

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313883
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


GENERATED_KEY not in result

2008-10-14 Thread John Wilker
I've set result = 'result' in my CFQuery tag, but still get GENERATED_KEY is
undefined

cfquery datasource=#request.wpDSN# result=result
INSERT INTO #request.wpTablePrefix#terms VALUES


cfdump label='result' var='#result#'cfabort

it's not in the dump.

I had CFDynamics confirm MySQL 5, and not using the MySQL 3.51 driver

Are there other things to test? CFD doesn't have any more info they can
offer.


John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough to
stare up the steps; we must step up the stairs.
~Vaclev Havel


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313884
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Session Expiring...

2008-10-14 Thread Parrish McIntyre
Hello - I have an online store, where the session is expiring as soon as they 
attempt to submit their order - without it going through. It doesn't appear to 
have anything to do with an actual timeout, unless that is set incorrectly. I 
have checked the application.cfm file, which shows:

cfapplication
name=appname
sessionManagement=yes
sessionTimeout=#createTimespan(0,1,0,0)#

Is there anything in that code which may cause a premature expiration for the 
session? The actual checkout.cfm file has this code in it, which could be 
related.

cfif isDefined(url.session_key)
cfset session.session_key = url.session_key
cfelseif isDefined(form.session_key)
Cfset session.session_key = form.session_key
/cfif
cfif not isDefined(session.cart_key)
cflocation url=session_expired.cfm addtoken=yes
/cfif 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313885
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Loathe
Yeah, I'm working on finalizing the formatting requirements for a 
template now.

Then it's unzip the docx and tear it apart to see how I can have cf 
create the xml files.

Jim Davis wrote:
 -Original Message-
 From: Tom Chiverton [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 14, 2008 10:36 AM
 To: cf-talk
 Subject: Re: docx (office 2007) from CF? (Cross)

 On Tuesday 14 Oct 2008, Loathe wrote:
 We already have a PDF solution in place.  Which is great if they just
 need to print the document.  They also want to be able to save, edit
 and
 pass around the document.
 Perfectly possible in a PDF file format. Sometimes without paying Adobe
 (OpenOffice v3, for example).
 
 I'm just a poor country chicken... but this here OpenOffice don't seem
 like it's Word.
 
 Seriously tho' - the requirement is to do this in Word.  It's nonsensical to
 suggest non-Word alternatives.  The client-side requirements are immutable.
 
 That said, Loath, the link provided should give all the information about
 the format. I'm sure you've thought of this but I'll say it anyway: don't
 try to build the doc from scratch.  What you've described seems pretty
 formulaic (complex, but formula) - create a template that contains all the
 elements and look to add/edit new nodes as needed rather than build from
 scratch.
 
 In my experience with formats like this (I've not done DocX, but I have
 dealt with similar) the key is to let the native tool do as much of the work
 as possible.  Doing small changes natively then comparing (diffing) that doc
 to the previous one can be invaluable.
 
 While developing test CONSTANTLY because even small changes can have
 dramatic effects.  I also strongly urge to have the output checked out by
 multiple people: in docs like this there are so many little things to go
 wrong.  The more eyeballs the better.
 
 Sorry I can't be more specific.
 
 Jim Davis
 
 
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313886
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Loathe
It's gong to be in Word 07.  Thats the requirement.

Shannon Peevey wrote:

 Perfectly possible in a PDF file format. Sometimes without paying Adobe
 (OpenOffice v3, for example).
 I'm just a poor country chicken... but this here OpenOffice don't seem
 like it's Word.

 Seriously tho' - the requirement is to do this in Word.  It's nonsensical
 to
 suggest non-Word alternatives.  The client-side requirements are immutable.

 
 OpenOffice can convert between Microsoft Office and other document formata,
 (server-side).  (It's really probably the best there is at this).
 OpenDocument Format is the original standard for file representation, (
 ISO/IEC 26300:2006 Open Document Format for Office Applications
 (OpenDocument) v1.0), so I don't know why Microsoft pursued a second
 standard...  Last but not least, Microsoft Office will soon support
 OpenDocument Format, (
 http://www.microsoft.com/Presspass/press/2008/may08/05-21ExpandedFormatsPR.mspx).
 
 I see your point, though :)
 speeves
 
 
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313887
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Running ColdFusion as a specific user in a Multiserver environment

2008-10-14 Thread Ian Skinner
Laura Norris wrote:
 we are running CF 7 on Windows 2003 Server.

 does that make any difference? 

Just that the services name will be Macromedia ColdFusion 7 AS 
#instanceName#, instead of Adobe.

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313888
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: GENERATED_KEY not in result

2008-10-14 Thread Cutter (CFRelated)
And you're referencing it as result.GENERATED_KEY?

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

John Wilker wrote:
 I've set result = 'result' in my CFQuery tag, but still get GENERATED_KEY is
 undefined
 
 cfquery datasource=#request.wpDSN# result=result
 INSERT INTO #request.wpTablePrefix#terms VALUES
 
 
 cfdump label='result' var='#result#'cfabort
 
 it's not in the dump.
 
 I had CFDynamics confirm MySQL 5, and not using the MySQL 3.51 driver
 
 Are there other things to test? CFD doesn't have any more info they can
 offer.
 
 
 John Wilker
 360Conferences, Inc.
 twitter: jwilker
 www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com
 
 Vision is not enough; it must be combined with venture. It is not enough to
 stare up the steps; we must step up the stairs.
 ~Vaclev Havel
 
 
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313889
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Jquery VISTA (IE)

2008-10-14 Thread Adrian Lynch
It's not a jQuery problem but an IE and/or ActiveX problem. Googling that
error brings up a load of people who've encountered the same. Couldn't see a
solution in the two pages I looked at.

Adrian
Building a database of ColdFusion errors at http://cferror.org/

-Original Message-
From: Qasim Rasheed
Sent: 14 October 2008 17:51
To: cf-talk
Subject: SOT: Jquery  VISTA (IE)


Apologies for slightly off topic post but based on number of JQuery guru on
this list, I thought someone might be able to shed some light. Here is the
message that I posted on jQuery list few moments ago
I am having a strange problem with performing a simple AJAX call on a Vista
machine using IE as the browser. The same request work fine with Firefox on
the same machine. Here is the sample code

script src=jquery.js/script
script
$(function(){
$(#temp).load(test2.cfm);
});
/script
div id=temp
/div

The error I get in the script window will be Automation Server can't create
object. Any idea?


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313890
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Session Expiring...

2008-10-14 Thread Adrian Lynch
Change the end code to:

cfif not isDefined(session.cart_key)
pDamn!/p
cfabort
cflocation url=session_expired.cfm addtoken=yes
/cfif

See what happens ;)

Adrian
Building a database of ColdFusion errors at http://cferror.org/

-Original Message-
From: Parrish McIntyre
Sent: 14 October 2008 21:08
To: cf-talk
Subject: Session Expiring...


Hello - I have an online store, where the session is expiring as soon as
they attempt to submit their order - without it going through. It doesn't
appear to have anything to do with an actual timeout, unless that is set
incorrectly. I have checked the application.cfm file, which shows:

cfapplication
name=appname
sessionManagement=yes
sessionTimeout=#createTimespan(0,1,0,0)#

Is there anything in that code which may cause a premature expiration for
the session? The actual checkout.cfm file has this code in it, which could
be related.

cfif isDefined(url.session_key)
cfset session.session_key = url.session_key
cfelseif isDefined(form.session_key)
Cfset session.session_key = form.session_key
/cfif
cfif not isDefined(session.cart_key)
cflocation url=session_expired.cfm addtoken=yes
/cfif


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313891
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Inexpensive student/developer oriented CF hosting?

2008-10-14 Thread Meghna Chopra
Another vote to hostingatoz!

I would hate to host my commercial sites with a very cheap hosting company 
because I would like to have virtually 100% uptime therefore, I have a VPS with 
HMS but I do host 12 low traffic personal sites (10 my friends and 2 of mine).

They had some issues when they were with SoftLayer but since they moved to some 
other provider in California, the uptime is almost 100%.

I would say that they have improved a lot now.




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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313840
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: checking for the existence of a dynamic variable

2008-10-14 Thread Azadi Saryev
cfif structkeyexists(form, 'MGMT_HEADER_'  i)

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



Scott Stewart wrote:
 cfloop index=Counter from=#i# to=#structCount(session.eformadmin)#
 cfif #form[MGMT_HEADER_i]# is not 
 cfset headerId = #form[MGMT_HEADER_i]#/
 cfelse
 /cfif   
 cfset i = i+1/
 /cfloop


 Hey all,

 the above code returns the error  Element MGMT_HEADER_2 is undefined in 
 a Java object of type class coldfusion.filter.FormScope.

 How would I code the IsDefined for this?


   

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Wil Genovese
Ya know we do something here similar where we convert html to RTF  
which can be read by MS Word without any problems.

There is an htmltortf.exe program somewhere that we execute from CF5.   
Yeah, this is real old legacy code on an old server but the thing  
still works for the client. However, this requires Windows.

Part of moving them to CF8 we have to figure out how to replicate  
this. I've been digging for a Java RTF api.  I haven't found the grail  
yet, but I suspect I've just looked in the wrong places.

Anyways, this may be a valid way to solve your problem.


Wil Genovese

One man with courage makes a majority.
-Andrew Jackson

A fine is a tax for doing wrong. A tax is a fine for doing well.

On Oct 14, 2008, at 3:09 PM, Loathe wrote:

 Yeah, I'm working on finalizing the formatting requirements for a
 template now.

 Then it's unzip the docx and tear it apart to see how I can have cf
 create the xml files.

 Jim Davis wrote:
 -Original Message-
 From: Tom Chiverton [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 14, 2008 10:36 AM
 To: cf-talk
 Subject: Re: docx (office 2007) from CF? (Cross)

 On Tuesday 14 Oct 2008, Loathe wrote:
 We already have a PDF solution in place.  Which is great if they  
 just
 need to print the document.  They also want to be able to save,  
 edit
 and
 pass around the document.
 Perfectly possible in a PDF file format. Sometimes without paying  
 Adobe
 (OpenOffice v3, for example).

 I'm just a poor country chicken... but this here OpenOffice don't  
 seem
 like it's Word.

 Seriously tho' - the requirement is to do this in Word.  It's  
 nonsensical to
 suggest non-Word alternatives.  The client-side requirements are  
 immutable.

 That said, Loath, the link provided should give all the information  
 about
 the format. I'm sure you've thought of this but I'll say it anyway:  
 don't
 try to build the doc from scratch.  What you've described seems  
 pretty
 formulaic (complex, but formula) - create a template that contains  
 all the
 elements and look to add/edit new nodes as needed rather than build  
 from
 scratch.

 In my experience with formats like this (I've not done DocX, but I  
 have
 dealt with similar) the key is to let the native tool do as much of  
 the work
 as possible.  Doing small changes natively then comparing (diffing)  
 that doc
 to the previous one can be invaluable.

 While developing test CONSTANTLY because even small changes can have
 dramatic effects.  I also strongly urge to have the output checked  
 out by
 multiple people: in docs like this there are so many little things  
 to go
 wrong.  The more eyeballs the better.

 Sorry I can't be more specific.

 Jim Davis




 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313892
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Wil Genovese
Well this looks interesting.

It's a .docx Java API.

http://dev.plutext.org/trac/docx4j



Wil Genovese

One man with courage makes a majority.
-Andrew Jackson

A fine is a tax for doing wrong. A tax is a fine for doing well.

On Oct 14, 2008, at 3:09 PM, Loathe wrote:

 Yeah, I'm working on finalizing the formatting requirements for a
 template now.

 Then it's unzip the docx and tear it apart to see how I can have cf
 create the xml files.

 Jim Davis wrote:
 -Original Message-
 From: Tom Chiverton [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 14, 2008 10:36 AM
 To: cf-talk
 Subject: Re: docx (office 2007) from CF? (Cross)

 On Tuesday 14 Oct 2008, Loathe wrote:
 We already have a PDF solution in place.  Which is great if they  
 just
 need to print the document.  They also want to be able to save,  
 edit
 and
 pass around the document.
 Perfectly possible in a PDF file format. Sometimes without paying  
 Adobe
 (OpenOffice v3, for example).

 I'm just a poor country chicken... but this here OpenOffice don't  
 seem
 like it's Word.

 Seriously tho' - the requirement is to do this in Word.  It's  
 nonsensical to
 suggest non-Word alternatives.  The client-side requirements are  
 immutable.

 That said, Loath, the link provided should give all the information  
 about
 the format. I'm sure you've thought of this but I'll say it anyway:  
 don't
 try to build the doc from scratch.  What you've described seems  
 pretty
 formulaic (complex, but formula) - create a template that contains  
 all the
 elements and look to add/edit new nodes as needed rather than build  
 from
 scratch.

 In my experience with formats like this (I've not done DocX, but I  
 have
 dealt with similar) the key is to let the native tool do as much of  
 the work
 as possible.  Doing small changes natively then comparing (diffing)  
 that doc
 to the previous one can be invaluable.

 While developing test CONSTANTLY because even small changes can have
 dramatic effects.  I also strongly urge to have the output checked  
 out by
 multiple people: in docs like this there are so many little things  
 to go
 wrong.  The more eyeballs the better.

 Sorry I can't be more specific.

 Jim Davis




 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313893
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Running ColdFusion as a specific user in a Multiserver environment

2008-10-14 Thread Ian Skinner
 Any help would be appreciated.

You didn't say if you are doing this on Unix or Windows?  And what version of 
ColdFusion is always helpful.

My main experience is windows based.

The only difference with multi-home is that you have multiple Services, each 
service can have it's own login user.

So you just select the service... Adobe ColdFusion 8 AS general for one of 
our instances, named 'general'.  Then set the 'Log On As' to the desired user 
name and password.



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF_IF_FIELD Question

2008-10-14 Thread Austin Band
I am referring to:
CF_if_Field
CAPTION = Test
NAME = eXAMPLE
INFO = POPUP INFO




I am using the info attribute for cf_if_field. My issue is that the info box 
positions at the top of the form and not by the area being referred to. Is 
there 
a simple way to reposition? 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313873
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF_IF_FIELD Question

2008-10-14 Thread Austin Band
I did notice that when clicking on the image for the popup I see this message: 
javascript:void(0)


 cf_if_field? What is that?
 
 It is so tempting to write a patronising reply about custom tags. ;)
 
 
 But anyway, Google suggests it's part of iFrame (short for Internet 
 Framework):
 http://cfiframe.sourceforge.net/
 
 And based on this screenshot...
 http://cfiframe.sourceforge.net/screenshots/sc4.jpg
...
 the infobox *does* appear to display next to the appropriate field.
 
 Which would lead me to think that there's a JavaScript error higher up 
 the page which is preventing it working for the OP.
 
 Austin: Check if you've got any JavaScript errors? 


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313894
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Loathe
iText has done great for smallish documents.  As has just forcing mime 
type, and using CSS.

Wil Genovese wrote:
 Ya know we do something here similar where we convert html to RTF  
 which can be read by MS Word without any problems.
 
 There is an htmltortf.exe program somewhere that we execute from CF5.   
 Yeah, this is real old legacy code on an old server but the thing  
 still works for the client. However, this requires Windows.
 
 Part of moving them to CF8 we have to figure out how to replicate  
 this. I've been digging for a Java RTF api.  I haven't found the grail  
 yet, but I suspect I've just looked in the wrong places.
 
 Anyways, this may be a valid way to solve your problem.
 
 
 Wil Genovese
 
 One man with courage makes a majority.
 -Andrew Jackson
 
 A fine is a tax for doing wrong. A tax is a fine for doing well.
 
 On Oct 14, 2008, at 3:09 PM, Loathe wrote:
 
 Yeah, I'm working on finalizing the formatting requirements for a
 template now.

 Then it's unzip the docx and tear it apart to see how I can have cf
 create the xml files.

 Jim Davis wrote:
 -Original Message-
 From: Tom Chiverton [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 14, 2008 10:36 AM
 To: cf-talk
 Subject: Re: docx (office 2007) from CF? (Cross)

 On Tuesday 14 Oct 2008, Loathe wrote:
 We already have a PDF solution in place.  Which is great if they  
 just
 need to print the document.  They also want to be able to save,  
 edit
 and
 pass around the document.
 Perfectly possible in a PDF file format. Sometimes without paying  
 Adobe
 (OpenOffice v3, for example).
 I'm just a poor country chicken... but this here OpenOffice don't  
 seem
 like it's Word.

 Seriously tho' - the requirement is to do this in Word.  It's  
 nonsensical to
 suggest non-Word alternatives.  The client-side requirements are  
 immutable.

 That said, Loath, the link provided should give all the information  
 about
 the format. I'm sure you've thought of this but I'll say it anyway:  
 don't
 try to build the doc from scratch.  What you've described seems  
 pretty
 formulaic (complex, but formula) - create a template that contains  
 all the
 elements and look to add/edit new nodes as needed rather than build  
 from
 scratch.

 In my experience with formats like this (I've not done DocX, but I  
 have
 dealt with similar) the key is to let the native tool do as much of  
 the work
 as possible.  Doing small changes natively then comparing (diffing)  
 that doc
 to the previous one can be invaluable.

 While developing test CONSTANTLY because even small changes can have
 dramatic effects.  I also strongly urge to have the output checked  
 out by
 multiple people: in docs like this there are so many little things  
 to go
 wrong.  The more eyeballs the better.

 Sorry I can't be more specific.

 Jim Davis




 
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313895
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Running ColdFusion as a specific user in a Multiserver environment

2008-10-14 Thread Jennifer L. West
open the Services Panel (MMC) and find the instance you want to change.  On 
the properties tab enter the user id that you want the instance to use. 
Recycle it.


- Original Message - 
From: Jochem van Dieten [EMAIL PROTECTED]
To: cf-talk cf-talk@houseoffusion.com
Sent: Tuesday, October 14, 2008 12:50 PM
Subject: Re: Running ColdFusion as a specific user in a Multiserver 
environment


 Laura Norris wrote:
 We are trying to reconfigure our CF server to run as a user instead of 
 under the administrator account.  Does anyone know the steps to do this 
 in a multiserver environment?  We have two instances running.

 We followed the instructions in the TechNote, but it doesn't seem to 
 work.

 The technote works if you have a default Windows configuration (since
 you say administrator account I presume Windows). It actually gives to
 many permissions to the new account, I typically restrict it a lot more:
 http://jochem.vandieten.net/2008/04/06/windows-file-permissions-for-the-coldfusion-account/

 Anyhow, to debug you problem check your *-out.log and if that doesn't
 have anything check the permissions on your *-out.log.

 Jochem

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313896
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Inexpensive student/developer oriented CF hosting?

2008-10-14 Thread denstar
On Tue, Oct 14, 2008 at 3:39 AM, Meghna Chopra wrote:
 Another vote to hostingatoz!

+1!

You can't beat the price, and they (Hi W!) have been fast to respond
to all of the requests and questions I've had.

-- 
It is not what he had, or even what he does which expresses the worth
of a man, but what he is.
Henri Frederic Amiel

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313897
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: docx (office 2007) from CF? (Cross)

2008-10-14 Thread Loathe
Good catch.

Wil Genovese wrote:
 Well this looks interesting.
 
 It's a .docx Java API.
 
 http://dev.plutext.org/trac/docx4j
 
 
 
 Wil Genovese
 
 One man with courage makes a majority.
 -Andrew Jackson
 
 A fine is a tax for doing wrong. A tax is a fine for doing well.
 
 On Oct 14, 2008, at 3:09 PM, Loathe wrote:
 
 Yeah, I'm working on finalizing the formatting requirements for a
 template now.

 Then it's unzip the docx and tear it apart to see how I can have cf
 create the xml files.

 Jim Davis wrote:
 -Original Message-
 From: Tom Chiverton [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 14, 2008 10:36 AM
 To: cf-talk
 Subject: Re: docx (office 2007) from CF? (Cross)

 On Tuesday 14 Oct 2008, Loathe wrote:
 We already have a PDF solution in place.  Which is great if they  
 just
 need to print the document.  They also want to be able to save,  
 edit
 and
 pass around the document.
 Perfectly possible in a PDF file format. Sometimes without paying  
 Adobe
 (OpenOffice v3, for example).
 I'm just a poor country chicken... but this here OpenOffice don't  
 seem
 like it's Word.

 Seriously tho' - the requirement is to do this in Word.  It's  
 nonsensical to
 suggest non-Word alternatives.  The client-side requirements are  
 immutable.

 That said, Loath, the link provided should give all the information  
 about
 the format. I'm sure you've thought of this but I'll say it anyway:  
 don't
 try to build the doc from scratch.  What you've described seems  
 pretty
 formulaic (complex, but formula) - create a template that contains  
 all the
 elements and look to add/edit new nodes as needed rather than build  
 from
 scratch.

 In my experience with formats like this (I've not done DocX, but I  
 have
 dealt with similar) the key is to let the native tool do as much of  
 the work
 as possible.  Doing small changes natively then comparing (diffing)  
 that doc
 to the previous one can be invaluable.

 While developing test CONSTANTLY because even small changes can have
 dramatic effects.  I also strongly urge to have the output checked  
 out by
 multiple people: in docs like this there are so many little things  
 to go
 wrong.  The more eyeballs the better.

 Sorry I can't be more specific.

 Jim Davis




 
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313898
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: GENERATED_KEY not in result

2008-10-14 Thread John Wilker
actually as result[request.queryLastId]

In application.cfm

request.queryLastId = GENERATED_KEY;

John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough to
stare up the steps; we must step up the stairs.
~Vaclev Havel


On Tue, Oct 14, 2008 at 2:20 PM, Cutter (CFRelated) 
[EMAIL PROTECTED] wrote:

 And you're referencing it as result.GENERATED_KEY?

 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer
 _
 http://blog.cutterscrossing.com

 John Wilker wrote:
  I've set result = 'result' in my CFQuery tag, but still get GENERATED_KEY
 is
  undefined
 
  cfquery datasource=#request.wpDSN# result=result
  INSERT INTO #request.wpTablePrefix#terms VALUES
 
 
  cfdump label='result' var='#result#'cfabort
 
  it's not in the dump.
 
  I had CFDynamics confirm MySQL 5, and not using the MySQL 3.51 driver
 
  Are there other things to test? CFD doesn't have any more info they can
  offer.
 
 
  John Wilker
  360Conferences, Inc.
  twitter: jwilker
  www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com
 
  Vision is not enough; it must be combined with venture. It is not enough
 to
  stare up the steps; we must step up the stairs.
  ~Vaclev Havel
 
 
 

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313899
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFMX 7 - Oracle CLOB / cfstoredproc

2008-10-14 Thread pmolaro
I was having the same issue.  I was getting a clob back and then couldn't
figure out out to get the content to display.  One of our Java guys helped
me figure this out.   So what I learned is that a CLOB is an object and
there are a lot of attributes to it, including the actual character values
which is really what you want in the end.  That little output you saw is the
object's string identifier.  So in Coldfusion, to get the character set we
had to create a Java string object and pass the clob into the constructor. 
It seems the constructor recoginizes that the value is a clob and when it
creates the string it assigns the char set as the value.  The end code was
(using your example):

cfset x = CreateObject(java,java.lang.String).init(myXMLOutput)

cfoutput#x#/cfoutput

-


Gert Franz wrote:
 
 Did you check whether Oracle executes the storedproc? You could use the 
 monitorin tool for that while cfm executes. what happens if you call the 
 function directly inside a cfquery tag and dump the result?
 Just try to fill a variable without . notation eg myXMLOutput.
 After that, i have no ideas... :-)
 good luck
 
 Greetings / Grüsse
 Gert Franz
 Customer Care
 Railo Technologies GmbH
 [EMAIL PROTECTED]
 www.railo.ch
 
 Join our Mailing List / Treten Sie unserer Mailingliste bei:
 deutsch: http://de.groups.yahoo.com/group/railo/
 english: http://groups.yahoo.com/group/railo_talk/
 
 
 
 Mike Garner schrieb:
 I have been messing with this issue all day - searched around without
 much success.  Here's the issue, we are on Oracle 10g R2.  We upgraded
 our JDBC driver to 3.5.  I am now trying to get the following test code
 to work (test.xml is a simple xml file):

 **
 cffile action=Read 
 file=C:\testing\Test.xml 
 variable=variables.myXMLInput 

 cfstoredproc procedure=TESTCLOB datasource=MYDNS
  cfprocparam cfsqltype=CF_SQL_CLOB type=In
 value=#variables.myXMLInput#
  cfprocparam cfsqltype=CF_SQL_CLOB type=Out
 variable=variables.myXMLOutput
 /cfstoredproc

 cfoutput#variables.myXMLOutput#/cfoutput
 **

 The stored procedure is just copying the value passed in into the output
 variable.  I've tested the procedure through PL/SQL developer and it
 works fine.

 The output of the above test code is this:
 [EMAIL PROTECTED] 
 I realize what this is - the default ToString of a Java object - the
 address changes every time I refresh.  The question is, how do I get to
 the value of the CLOB from this variable?  I've tried to do a CFDUMP of
 the variable, but it actually causes CF to crash.  Through debugging I
 can see the input was handled correctly - just can't get to the output. 
 Any help would be appreciated.

 Regards,
 MG

 
 
 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313900
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: GENERATED_KEY not in result

2008-10-14 Thread cold.fusion

When you use the result attribute of cfquery, if you don't explicitly
scope it then it will be in the VARIABLES scope

cfquery name=VARIABLES.qry datasource=#APPLICATION.dsn#
result=VARIABLES.result

  !--- Some query here ---

/cfquery

The GENERATED_KEY value is a structure key of that variable. If you
want that within a different variable you'd have to assign it

cfset REQUEST.queryLastId = VARIABLES.result.GENERATED_KEY /

Steve 'Cutter' Blades
Adobe Certified Expert
Advanced Macromedia ColdFusion MX 7 Developer

http://blog.cutterscrossing.com

The best way to predict the future is to help create it

John Wilker wrote:

  actually as result[request.queryLastId]

In application.cfm

request.queryLastId = GENERATED_KEY;

John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough to
stare up the steps; we must step up the stairs.
~Vaclev Havel

On Tue, Oct 14, 2008 at 2:20 PM, Cutter (CFRelated) 
[EMAIL PROTECTED] wrote:

And you're referencing it as result.GENERATED_KEY?

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

John Wilker wrote:

  I've set result = 'result' in my CFQuery tag, but still get GENERATED_KEY

is

  undefined

cfquery datasource=#request.wpDSN# result=result
INSERT INTO #request.wpTablePrefix#terms VALUES

cfdump label='result' var='#result#'cfabort

it's not in the dump.

I had CFDynamics confirm MySQL 5, and not using the MySQL 3.51 driver

Are there other things to test? CFD doesn't have any more info they can
offer.

John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough

to

  stare up the steps; we must step up the stairs.
~Vaclev Havel



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313901
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: GENERATED_KEY not in result

2008-10-14 Thread John Wilker
Isn't VARIABLES the default scope?

I tried putting VARIABLES as the scope to make sure, same result.



John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough to
stare up the steps; we must step up the stairs.
~Vaclev Havel


On Tue, Oct 14, 2008 at 7:53 PM, cold.fusion 
[EMAIL PROTECTED] wrote:


 When you use the result attribute of cfquery, if you don't explicitly
 scope it then it will be in the VARIABLES scope

 cfquery name=VARIABLES.qry datasource=#APPLICATION.dsn#
 result=VARIABLES.result

  !--- Some query here ---

 /cfquery

 The GENERATED_KEY value is a structure key of that variable. If you
 want that within a different variable you'd have to assign it

 cfset REQUEST.queryLastId = VARIABLES.result.GENERATED_KEY /

 Steve 'Cutter' Blades
 Adobe Certified Expert
 Advanced Macromedia ColdFusion MX 7 Developer
 
 http://blog.cutterscrossing.com

 The best way to predict the future is to help create it

 John Wilker wrote:

  actually as result[request.queryLastId]

 In application.cfm

request.queryLastId = GENERATED_KEY;

 John Wilker
 360Conferences, Inc.
 twitter: jwilker
 www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

 Vision is not enough; it must be combined with venture. It is not enough
 to
 stare up the steps; we must step up the stairs.
 ~Vaclev Havel

 On Tue, Oct 14, 2008 at 2:20 PM, Cutter (CFRelated) 
 [EMAIL PROTECTED] wrote:

And you're referencing it as result.GENERATED_KEY?

 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer
 _
 http://blog.cutterscrossing.com

 John Wilker wrote:

  I've set result = 'result' in my CFQuery tag, but still get
 GENERATED_KEY

is

  undefined

 cfquery datasource=#request.wpDSN# result=result
INSERT INTO #request.wpTablePrefix#terms VALUES

 cfdump label='result' var='#result#'cfabort

 it's not in the dump.

 I had CFDynamics confirm MySQL 5, and not using the MySQL 3.51 driver

 Are there other things to test? CFD doesn't have any more info they can
 offer.

 John Wilker
 360Conferences, Inc.
 twitter: jwilker
 www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

 Vision is not enough; it must be combined with venture. It is not enough

to

  stare up the steps; we must step up the stairs.
 ~Vaclev Havel



 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313902
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: GENERATED_KEY not in result

2008-10-14 Thread cold.fusion

Rather than using your dynamic variable (I guess you have an app switch
for the db used?), did you use the straight variable
(result.GENERATED_KEY)  to test? Did you cfdump the result by itself,
to see if the key exists in the result struct? If your query is bombing
for some reason, and a record isn't created, then GENERATED_KEY would
never be present in the result.

Yes, VARIABLES is the default scope. If you don't var scope the
'result' in a cffunction then you'll have a CFC global variable (not
usually desired). In large apps, with thousands of vars, and thousands
of sessions a minute, it may be advantageous to scope even the
VARIABLES scoped variables, so that CF isn't performing scopeCheck() on
each variable reference (what's to check if you know where it is? plus
it's easy to track, and shows easy examples).

Steve 'Cutter' Blades
Adobe Certified Expert
Advanced Macromedia ColdFusion MX 7 Developer

http://blog.cutterscrossing.com

The best way to predict the future is to help create it

John Wilker wrote:

  Isn't VARIABLES the default scope?

I tried putting VARIABLES as the scope to make sure, same result.

John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough to
stare up the steps; we must step up the stairs.
~Vaclev Havel

On Tue, Oct 14, 2008 at 7:53 PM, cold.fusion 
[EMAIL PROTECTED] wrote:

When you use the result attribute of cfquery, if you don't explicitly
scope it then it will be in the VARIABLES scope

cfquery name=VARIABLES.qry datasource=#APPLICATION.dsn#
result=VARIABLES.result

 !--- Some query here ---

/cfquery

The GENERATED_KEY value is a structure key of that variable. If you
want that within a different variable you'd have to assign it

cfset REQUEST.queryLastId = VARIABLES.result.GENERATED_KEY /

Steve 'Cutter' Blades
Adobe Certified Expert
Advanced Macromedia ColdFusion MX 7 Developer

http://blog.cutterscrossing.com

The best way to predict the future is to help create it

John Wilker wrote:

 actually as result[request.queryLastId]

In application.cfm

   request.queryLastId = GENERATED_KEY;

John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough
to
stare up the steps; we must step up the stairs.
~Vaclev Havel

On Tue, Oct 14, 2008 at 2:20 PM, Cutter (CFRelated) 
[EMAIL PROTECTED] wrote:

   And you're referencing it as result.GENERATED_KEY?

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

John Wilker wrote:

 I've set result = 'result' in my CFQuery tag, but still get
GENERATED_KEY

   is

 undefined

cfquery datasource=#request.wpDSN# result=result
   INSERT INTO #request.wpTablePrefix#terms VALUES

cfdump label='result' var='#result#'cfabort

it's not in the dump.

I had CFDynamics confirm MySQL 5, and not using the MySQL 3.51 driver

Are there other things to test? CFD doesn't have any more info they can
offer.

John Wilker
360Conferences, Inc.
twitter: jwilker
www.johnwilker.com / www.360conferences.com / ignitedenver.blogspot.com

Vision is not enough; it must be combined with venture. It is not enough

   to

 stare up the steps; we must step up the stairs.
~Vaclev Havel



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313903
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Getting cfimage to read .eps file

2008-10-14 Thread Chuck Weidler
Does anyone know how to get CF to support reading a .eps file with cfimage?

I ran the function GetReadableImageFormats() on my server to what the server 
could read and .eps file format was not listed.

This is what my server can read:  BMP,GIF,JFIF,JPEG,JPEG 
2000,JPEG-LOSSLESS,JPEG-LS,JPEG2000,JPG,PNG,PNM,RAW,TIF,TIFF,WBMP 

My Sever is Windows 2003 R2 running CF 8,0,1,195765 Enterprise.

TIA

Chuck 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313904
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Sharing Data Between Applications

2008-10-14 Thread Ryan J. Heldt
Everyone-

I have a situation where we need to share a few pieces of data between 
applications. Essentially there's a core management application from 
which a handful of other sites are derived. Was wondering what you all 
thought would be a best practice solution to this would be. The data 
could change fairly regularly. My initial thought was to use the server 
scope for this, but for some reason that seems kind of dirty to me. 
Really, it's only going to be a few variables, so nothing major. Your 
thoughts?

Thanks!
Ryan
-- 
*Ryan J. Heldt*, Senior Web Developer
Global Reach Internet Productions
http://www.globalreach.com
Phone: 515-296-0792, Fax: 515-296-3748


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313905
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4