date:20070116

Trying to import an Excel Spreadsheet into an ntext(16) field using the 
Enterprise manager.

Getting an error: "Row Number 22"
Data Source Column is too large for specified buffer size."

Looking at the Excel Sheet - it's less than a paragraph of text.

Going through my CF Admin form to add data to the same table - I can 
paste PAGES of stuff from Word into the same column with no problem.


I'm sorta stumped.

What could it be?

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266718
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 6.1 Session Variables and Stored Data Question

2007-01-16 Thread Dave Watts

> Hello everyone I am new to the house of fusion and look 
> forward to communicating with everyone.  I am using 
> coldfusion MX 6.1 and have noticed several references in many 
> articles that puzzle my mind.  The first one includes that 
> session variables are referred as shared data.  The second 
> one includes the statement Coldfusion Server will fail under 
> load if you do not utilize cflock around your session variables.

Those references may be somewhat out of date.

Session variables are specific to a single user (or more accurately, a
single browser), but they are shared in a sense - they are available
automatically for any requests made by that browser. It is quite possible
for the browser to submit more than one request simultaneously, so the
potential exists for concurrent access to those variables.

In CF 5 and earlier versions, it was very important to limit concurrent
access to these variables, along with Application and Server variables, so
you would need to use CFLOCK in many cases to prevent failure under load.
However, in CFMX 6 and higher, it is no longer necessary to use CFLOCK to
prevent this failure under load. The possibility of concurrent access
changing variables in potentially unexpected ways, which is generally called
a "race condition", still exists, so you may want to use CFLOCK to prevent
this.

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!


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: String Math Parser

2007-01-16 Thread Mark Mandel

I've been using the beta v3 of ANTLR to great effect for generating
language parsers, but there may already be a grammar in there that you
can use:

www.antlr.org

Mark

On 1/17/07, Richard Kroll <[EMAIL PROTECTED]> wrote:
> I am currently creating a wiki style parsing engine for the lack of a
> better description.  To date I have all the HTML elements parsing that I
> need, but one of the requirements that I have is to allow the end user
> to input variables from our system (kind of a merge field) and allow
> them to perform math operations on them.  I was hoping that someone
> might know of an existing CF math parsing engine / code that I might be
> able to get a foothold on how to accomplish this.
>
> Anyone know of an existing open source library?
>
> The current requirement is to allow for basic arithmetic but including
> nesting parenthesis for more complex equations.  I have some ideas for
> the basic math, but when getting into nesting equations is where I get a
> little fuzzy.
>
> This is what I am trying to achieve in wiki markup:
>
> [b]Welcome[/b]
> [p]
> Product Commission is
> [math]({product_price}-{product_credits})*{commission_rate}[/math]
> [/p]
>
> Using my existing code I can get it to generate the correct [math] like:
>
> (10-500)*.15
>
> I thought of simply tossing an eval() around this, but it seems like a
> major hack and does not allow for more complex equations that might come
> up later.
>
> Anyone have any ideas?
>
> Rich Kroll
>
> Senior Technical Lead
>
> SITE Manageware, Inc.
> 2841 West Cypress Creek Road
> Fort Lauderdale, Florida 33309
> 954-944-9020 EXT. 716
> 954-272-8916 Fax
>
>
>
> This communication is intended for use only by the individual(s) to whom
> it is specifically addressed and should not be read by, or delivered to,
> any other person.  Such communication may contain privileged or
> confidential information.  If you have received this message in error,
> please notify us immediately by returning the communication to the
> sender, or by sending it to [EMAIL PROTECTED]
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

String Math Parser

2007-01-16 Thread Richard Kroll

I am currently creating a wiki style parsing engine for the lack of a
better description.  To date I have all the HTML elements parsing that I
need, but one of the requirements that I have is to allow the end user
to input variables from our system (kind of a merge field) and allow
them to perform math operations on them.  I was hoping that someone
might know of an existing CF math parsing engine / code that I might be
able to get a foothold on how to accomplish this.  

Anyone know of an existing open source library?

The current requirement is to allow for basic arithmetic but including
nesting parenthesis for more complex equations.  I have some ideas for
the basic math, but when getting into nesting equations is where I get a
little fuzzy.

This is what I am trying to achieve in wiki markup:

[b]Welcome[/b]
[p]
Product Commission is
[math]({product_price}-{product_credits})*{commission_rate}[/math]
[/p]

Using my existing code I can get it to generate the correct [math] like:

(10-500)*.15

I thought of simply tossing an eval() around this, but it seems like a
major hack and does not allow for more complex equations that might come
up later.

Anyone have any ideas?

Rich Kroll

Senior Technical Lead

SITE Manageware, Inc.
2841 West Cypress Creek Road
Fort Lauderdale, Florida 33309
954-944-9020 EXT. 716
954-272-8916 Fax



This communication is intended for use only by the individual(s) to whom
it is specifically addressed and should not be read by, or delivered to,
any other person.  Such communication may contain privileged or
confidential information.  If you have received this message in error,
please notify us immediately by returning the communication to the
sender, or by sending it to [EMAIL PROTECTED]

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

CFMX 6.1 Session Variables and Stored Data Question

2007-01-16 Thread John Sterrett

Hello everyone I am new to the house of fusion and look forward to
communicating with everyone. I am using coldfusion MX 6.1 and have noticed
several references in many articles that puzzle my mind. The first one
includes that session variables are referred as shared data. The second one
includes the statement Coldfusion Server will fail under load if you do not
utilize cflock around your session variables.

Hopefully, my understanding is incorrect. I understand that session variables
are unique towards a browser connection to a single given MX6.1 server.
Therefore, this term shared data confuses me as my understanding includes that
the data for session variables should be separated for all browser connections.
An example of my understanding would be the following. Two users are
connected, user1 session.var1=5 and user2 session.var2=10. They both have
their own independent variable var1. A change to one does not change the
other. Therefore, I do not understand why I would have to use cflock around
session variables or why it would cause the server to fail under load. For
example, say I am using session variables for login authentication. Why would
I want to lock someone out of the server while someone else is logging in?
Shouldnât their session variables be different as shown in my example?

I look forward you the groupâs replies.

Regards,
John Sterrett

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

2007-01-16 Thread Jim Wright

There are probably many ways to do this, but one thing you might find 
useful is to make use of a CROSS JOIN in your query...that way you can 
return one record for each combination of tbl1ID and service, and then 
use a LEFT JOIN to determine if there is a match in Table 2...something 
like...

SELECT  table_1.tb1ID,table_1.field1,table_1.field2,table_1.field3,
CASE WHEN table_2.tbl3ID IS NULL THEN 0 ELSE 1 END AS servyesno
,table_3.service
FROM tbl3 as table_3 CROSS JOIN tbl1 as table_1 LEFT JOIN
tbl2 as table_2 ON table_3.tbl3ID = table_2.tbl3ID AND table_2.tbl1ID = 
table_1.tb1ID
ORDER BY tb1ID,service

Then, when you output your records, you know you have a record for each 
spot in the grid



tb1ID
field1
field2




#service#



field3




#tbl1#
#field1#
#field2#

x

#tbl1#




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

Sorry for the delay.  I had some deliverables and a few meetings.  It was a
fun little code challenge that I put on myself to finish it under 25
minutes.

Teddy

On 1/16/07, Teddy Payne <[EMAIL PROTECTED]> wrote:
>
> Richard,
> I did not like the TSQL dynamic SQl that I created.  I always hate
> defeating an execution plan.  Here is a CF way:
>
>
> 
>
> 
>  select
>   entryID
>   , entryCol1
>  from
>   dbo.tblEntry
> 
>
> 
>  select
>   e.entryID
>   , s.serviceCol1
>  from
>   dbo.tblEntry e
>   join dbo.tblEntryService es
>on e.entryID = es.entryID
>join tblService s
> on es.serviceID = s.serviceID
> 
>
> 
>  select
>   serviceID
>   , serviceCol1
>  from
>   dbo.tblService
> 
>
>
> 
>
> 
>
> 
>
>  
>  
>  
>
>  
>
>   
>
>  
>
> 
>
> 
>
> 
>
>  
>
>  
>
>   
>
>   
>
>  
>
>  
>
>  
>
>  
>
> 
>
> 
> My schema was:
>
> CREATE TABLE [tblEntry] (
>  [entryID] [int] IDENTITY (1, 1) NOT NULL ,
>  [entryCol1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>  CONSTRAINT [PK_tblEntry] PRIMARY KEY  CLUSTERED
>  (
>   [entryID]
>  )  ON [PRIMARY]
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [tblEntryService] (
>  [entryServiceID] [int] IDENTITY (1, 1) NOT NULL ,
>  [entryID] [int] NULL ,
>  [serviceID] [int] NULL ,
>  CONSTRAINT [PK_tblEntryService] PRIMARY KEY  CLUSTERED
>  (
>   [entryServiceID]
>  )  ON [PRIMARY]
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [tblService] (
>  [serviceID] [int] IDENTITY (1, 1) NOT NULL ,
>  [serviceCol1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>  CONSTRAINT [PK_tblService] PRIMARY KEY  CLUSTERED
>  (
>   [serviceID]
>  )  ON [PRIMARY]
> ) ON [PRIMARY]
> GO
>
>
> On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
> >
> > That'd be great. I'm using SQL Server 2000.
> >
> > 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

2007-01-16 Thread Robertson-Ravo, Neil (RX)

you are never really defeating the plan.

"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Teddy Payne
To: CF-Talk
Sent: Tue Jan 16 21:49:57 2007
Subject: Re: SQL Join & Data group output

Richard,
I did not like the TSQL dynamic SQl that I created.  I always hate defeating
an execution plan.  Here is a CF way:

 select
  entryID
  , entryCol1
 from
  dbo.tblEntry

 select
  e.entryID
  , s.serviceCol1
 from
  dbo.tblEntry e
  join dbo.tblEntryService es
   on e.entryID = es.entryID
   join tblService s
on es.serviceID = s.serviceID

 select
  serviceID
  , serviceCol1
 from
  dbo.tblService

My schema was:

CREATE TABLE [tblEntry] (
 [entryID] [int] IDENTITY (1, 1) NOT NULL ,
 [entryCol1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 CONSTRAINT [PK_tblEntry] PRIMARY KEY  CLUSTERED
 (
  [entryID]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [tblEntryService] (
 [entryServiceID] [int] IDENTITY (1, 1) NOT NULL ,
 [entryID] [int] NULL ,
 [serviceID] [int] NULL ,
 CONSTRAINT [PK_tblEntryService] PRIMARY KEY  CLUSTERED
 (
  [entryServiceID]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [tblService] (
 [serviceID] [int] IDENTITY (1, 1) NOT NULL ,
 [serviceCol1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 CONSTRAINT [PK_tblService] PRIMARY KEY  CLUSTERED
 (
  [serviceID]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO

On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> That'd be great. I'm using SQL Server 2000.
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Looking for CF7 hosting (with some requirements)

2007-01-16 Thread mcollins

As far as 3 domains on 1 IP, you could add some code in an application.cfc to 
include templates from a directory based on cgi.http_host.  Or you might do a 
cflocation to a subdirectory off the webroot.  Works for 2 sites I have on 
CrystalTech, who I am happy with.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

Richard,
I did not like the TSQL dynamic SQl that I created.  I always hate defeating
an execution plan.  Here is a CF way:





 select
  entryID
  , entryCol1
 from
  dbo.tblEntry



 select
  e.entryID
  , s.serviceCol1
 from
  dbo.tblEntry e
  join dbo.tblEntryService es
   on e.entryID = es.entryID
   join tblService s
on es.serviceID = s.serviceID



 select
  serviceID
  , serviceCol1
 from
  dbo.tblService









 
 
 

 

  

 







 

 

  
   
  

 

 

 

 




My schema was:

CREATE TABLE [tblEntry] (
 [entryID] [int] IDENTITY (1, 1) NOT NULL ,
 [entryCol1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 CONSTRAINT [PK_tblEntry] PRIMARY KEY  CLUSTERED
 (
  [entryID]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [tblEntryService] (
 [entryServiceID] [int] IDENTITY (1, 1) NOT NULL ,
 [entryID] [int] NULL ,
 [serviceID] [int] NULL ,
 CONSTRAINT [PK_tblEntryService] PRIMARY KEY  CLUSTERED
 (
  [entryServiceID]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [tblService] (
 [serviceID] [int] IDENTITY (1, 1) NOT NULL ,
 [serviceCol1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 CONSTRAINT [PK_tblService] PRIMARY KEY  CLUSTERED
 (
  [serviceID]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO


On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> That'd be great. I'm using SQL Server 2000.
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Problem with Adobe Acrobat8 and ColdFusion FORM struct

2007-01-16 Thread mcollins

This is an Acrobat 8.0 issue - 1407473.

This all worked in 7 as you found.

It is already fixed within the 8.1 release, which is not out yet.



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266708
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 patch installation problems

2007-01-16 Thread Maya Tulchinsky

Another error on install - single server installation, MX 7.02, 2003 Server:
==
java -Dtrace.ci=1 -jar wsconfig.jar -upgrade -v
Exception in thread "main" java.lang.NullPointerException
at 
jrunx.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java, 
Compiled Code)
===
Should be no problem with wsconfig.jar - was able to install it on Windows XP.
Any ideas?

Thanks,

Maya Tulchinsky

Dave Watts <[EMAIL PROTECTED]> wrote: > 
http://www.adobe.com/support/security/bulletins/apsb07-02.html
> 
> I shut down all of the services that the instruction say to.  
> CF, IIS, and Windows Management Instrumentation service.
> 
> I rename the current wsconfig.jar to wsconfig.jar.bu, copy 
> the downloaded jar to the folder and run this command and get 
> this error.
> 
> C:\CFusionMX7\runtime\lib>java -Dtrace.ci=1 -jar wsconfig.jar 
> -upgrade -v Invalid or corrupt jarfile wsconfig.jar
> 
> I re-downloaded the file several times and still get the error.
> 
> Any ideas?

Rename the wsconfig.jar file to wsconfig.zip, and see if you can open it up
with the unzip tool of your choice. My guess is that, in fact, it's corrupt
and you'll see that when you do this.

In that case, download the file from another machine, or using another
download tool - wget is a good choice for this.

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!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

2007-01-16 Thread Jochem van Dieten

Les Mizzell wrote:
> Is there a way to compare a complete record in one table (all columns) 
> to another record in another table without having to specify each 
> individual column? 

SELECT ...
FROM a NATURAL JOIN b
WHERE ROW(a.*) = ROW(b.*)

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: application.cfc onError

2007-01-16 Thread Raymond Camden

One tip - maybe do a structkeyexists on your exception values like
type and tagcontext within rootcause. I see you using it for rootcause
itself, but not the others. (Although message should always exist
afaik.)

Worse comes to worse - just mail a dump of the exception object and
see the keys there. :)

On 1/16/07, Chad Gray <[EMAIL PROTECTED]> wrote:
> I have started using application.cfc and sending an email when an error 
> occurs by placing a CFMail tag in the onError function.
>
> I have one user that when she is doing an insert on a table and is taken back 
> to the display page I get this error emailed to me.
>
>
> Event Name:
>
> Error Info:
> Message:
> Detail:
> Root Cause:
> Type: java.lang.NullPointerException
> Template: /catalogs/index.cfm?action=displayElements&CatalogID=49
> Tag Context:
>
>
> Here is the code that I have in the function (I think I borrowed it from one 
> of Ray Camden's applications).
>
>  subject="Error" type="html">
>
> 
> Event Name: #arguments.eventname#
> 
> Error Info:
> Message:#arguments.exception.message#
> Detail: #arguments.exception.detail#
> Root Cause: 
>  var="#arguments.exception.rootcause#">
> Type:   #arguments.exception.type#
> Template:   #cgi.script_name#?#cgi.query_string#
> Tag Context:
>  var="#arguments.exception.rootcause.tagcontext#">
>
> 
>
> Anyone know what this java.lang.NullPointerException is?  There is nothing in 
> the CF logs to help me figure out what this error is.
>
> Chad
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: application.cfc onError

2007-01-16 Thread Will Tomlinson

> I have started using application.cfc and sending an email when an 
> error occurs by placing a CFMail tag in the onError function.
> 
> I have one user that when she is doing an insert on a table and is 
> taken back to the display page I get this error emailed to me.

I think this was a bug. I know it happened to me when I redirected a user after 
login. 

Here's some good info about it on ray's blog. 

http://ray.camdenfamily.com/index.cfm?mode=entry&entry=ED9D4058-E661-02E9-E70A41706CD89724

Will

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

Les,
I would probably advocate that you use a stored procedure to compare the
values.  It will execute quicker.

You may want to create a geenrational ID on the log table similar to date
time stamp, so you can compare how far back you want to check.

A CFC or UDF that compares generations against one another through the use
of stored procedures can make you dev life easier.  I had a CFC API that I
would use to load a generation and then compare against the current state of
the data.  I could ask the CFC to tell me how many generations existed and
give a place in time generation.

Teddy

On 1/16/07, Les Mizzell <[EMAIL PROTECTED]> wrote:
>
> Is there a way to compare a complete record in one table (all columns)
> to another record in another table without having to specify each
> individual column? Or would you basically have to do a  record1.column1 NEQ record2.column1> for every column in a table?
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

2007-01-16 Thread Robertson-Ravo, Neil (RX)

This is where the power of tools like RedGate Compare and Apex SQL Diff come
into play.

  







"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Les Mizzell
To: CF-Talk
Sent: Tue Jan 16 17:36:08 2007
Subject: Re: Method - Logging Database Changes?

Is there a way to compare a complete record in one table (all columns) 
to another record in another table without having to specify each 
individual column? Or would you basically have to do a  for every column in a table?



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266702
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 on Apache (resolved)

2007-01-16 Thread Cutter (CFRelated)

Mad props to Adrian for pointing me in the right direction on this, as 
well as everyone else that tried to assist. Been a long time since I've 
dealt with flat file configs (outside of xml configs for web apps). This 
wasn't the total answer to my issues, but definitely pointed me in the 
right direction, and I will blog it in the next day or two.

Cutter
___
http://blog.cutterscrossing.com

Adrian Moreno wrote:
> There are some differences between Apache 2.0 and 2.2
> 
> Instead of Apache.exe, it's now httpd.exe
> 
> Also, there's a new file used to configure virtual hosts. Open up httpd.conf 
> and find this line:
> 
> # Virtual hosts
> #Include conf/extra/httpd-vhosts.conf
> 
> Uncomment the Include and use that file for virtual host configurations.
> 
> And make sure you get the update for Coldfusion in order to use Apache 2.2: 
> http://www.adobe.com/go/8001e97
> 
> HTH, 
> 
> Adrian
> 
> 
>>OK, trying something new here and hit a minor road block. Going to put 
>>CF on top of Apache on a WinXP Pro box. Following the directions of the 
>>ACME guide, while installing the multiserver instance of CF 7 I am to 
>>put the following into the "Directory and file name of server binary" field:
>>
>>C:\Program Files\Apache
>>Group\Apache2\bin\Apache.exe
>>
>>Just one little problem. Apache 2.2.4 doesn't have an 'apache.exe' file 
>>in it's bin folder. Any ideas? All help is appreciated.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

Is there a way to compare a complete record in one table (all columns) 
to another record in another table without having to specify each 
individual column? Or would you basically have to do a  for every column in a table?

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: application.cfc onError

2007-01-16 Thread Josh Nathanson

> Anyone know what this java.lang.NullPointerException is?  There is nothing 
> in the CF logs to help me figure out
> what this error is.

I have found that this error often pops up when you try to use a date 
function such as DateDiff or DateFormat, and the value you are passing to 
the function is empty string rather than a date.

Just a guess though, it could easily be something else.

-- Josh 


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

Craig Drabik wrote:
> What database are you using?

SQL Server

Looking like setting up a duplicate and populating it with triggers when 
somebody makes a change. Reading up on how to do that now.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

2007-01-16 Thread Craig Drabik

What database are you using?


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

application.cfc onError

2007-01-16 Thread Chad Gray

I have started using application.cfc and sending an email when an error occurs 
by placing a CFMail tag in the onError function.

I have one user that when she is doing an insert on a table and is taken back 
to the display page I get this error emailed to me.


Event Name: 

Error Info:
Message: 
Detail: 
Root Cause: 
Type: java.lang.NullPointerException
Template: /catalogs/index.cfm?action=displayElements&CatalogID=49
Tag Context:


Here is the code that I have in the function (I think I borrowed it from one of 
Ray Camden's applications).




Event Name: #arguments.eventname#

Error Info:
Message:#arguments.exception.message#
Detail: #arguments.exception.detail#
Root Cause: 

Type:   #arguments.exception.type#
Template:   #cgi.script_name#?#cgi.query_string#
Tag Context:




Anyone know what this java.lang.NullPointerException is?  There is nothing in 
the CF logs to help me figure out what this error is.

Chad


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: float in DB becomes integer in CF

2007-01-16 Thread Dave Watts

> I have a weird problem..
> 
> In my database (MS SQL Server) I have the valus 12,53131 in a 
> field of type float.
> 
> When I retrieve the value using a query and output it, the 
> values is 12!
> 
> I have tried running the SQL using the MS SQL Server 
> Management Studio and here I get the correct value of 12,53131.
> 
> Can anyone shed some ligth on this please?!?  (I am running CF7)

First, if you're running CF 7, you might want to either upgrade to 7.0.2, or
install the newest DataDirect drivers available here:

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_17883

Second, if that doesn't fix your problem, you might try an alternative SQL
Server JDBC driver. My assumption is that you're using SQL Server 2005;
Microsoft has their own JDBC driver that you might try:

http://msdn.microsoft.com/data/ref/jdbc/

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!


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Announcement - Flex 2 conference, 25-26 June, Washington DC

2007-01-16 Thread Dave Watts

Hi, everyone! I apologize for the slightly OT nature of this post, but I
think it might be useful enough to justify your forbearance.

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!

Join Fig Leaf Software, Adobe. and Carahsoft for the highly anticipated Flex

2 Developers Conference on June 25-26 in Washington, DC.

LEARN ABOUT DEVELOPING WEB 2.0 APPLICATIONS WITH FLEX 2, ACTIONSCRIPT 3, and
"APOLLO" !

With two full days of 60 minute lectures and 90 minute HANDS-ON practice
sessions dedicated to Flex 2 and developing Rich Internet Applications
(RIA), you're sure to get all of the information you need.

With sessions for project managers, beginner, intermediate, and advanced
developers, the FlexManiacs conference is poised to deliver maximum return
for your training dollar.

Confirmed FlexManiac speakers include:

Ted Patrick
Flex Evangelist, Adobe Systems

Dan Blackman
Certified Flex 2 Instructor, Fig Leaf Software

Mike Nimer
Former ColdFusion Engineer for Adobe, now a principal of Tapper, Nimer, and
Associates

Jeff Tapper
Certified Adobe Flex instructor and Author of Adobe Flex 2: Training from
the Source. Principal of Tapper, Nimer, and Associates

Jason Perry
Certified Adobe Flex instructor, Fig Leaf Software

Keenan Keeling
Certified Adobe Flex instructor, CEO, Automata Studios

Branden Hall
CTO, Automata Studios

Dave Watts
CTO and Certified Flex instructor, Fig Leaf Software

Find out more about the conference at http://flex2conference.figleaf.com

If you would like to speak at the conference, please fill out our call for
papers application at
http://flex2conference.figleaf.com/Sessions/callforpapers.cfm


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Flash remoting and onRequestEnd.cfm

2007-01-16 Thread Andy Matthews

Oh..

So assuming a CFC is hit via Flash Remoting, then that string would appear?
That seems easy enough. Thanks.


Andy matthews 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 16, 2007 9:37 AM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

Here's what I dug up... basically just make sure the call isn't originating
from the remoting gateway.


  // PROCEED AS NORMAL...


Cheers,

!k

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 16, 2007 8:08 AM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

A sample would help out. In this case, the page is all Flash and we're
needing to find out how onRequestEnd is getting called multiple times from
within this particular app.

Thanks for the help Kevin. 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 6:28 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

If you dump the current calling page and filter out pages coming from
/flashservices/gateway than you shouldn't be triggering the onRequestEnd.cfm
page anymore.

I've got a sample at work I'll post tomorrow when I get in...

Cheers,

!k

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 3:55 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

Kevin...

I'm not familiar with remoting at all. Can you clarify how I can filter out
processes coming from remoting in the onRequestEnd.cfm?


andy 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 3:47 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

AMF is an encoded RPC and extremely similar to the idea of web services. You
can learn about AMF at the Red5 project site or the AMFPHP site...

If you ask your developer, he should be able to tell you why unless it's
being called elsewhere that doesn't have anything to do with the CFC.

Are you guys using authentication for your CFC? 
Is this happening with other CFC's? 
Has this been confirmed through the NetConnection Debugger (Flash tool)?

At bare minimum you could ignore anything coming from the gateway within
your onRequestEnd.cfm.

Cheers,

Kevin






~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Flash remoting and onRequestEnd.cfm

2007-01-16 Thread Kevin Aebig

Here's what I dug up... basically just make sure the call isn't originating
from the remoting gateway.

 
  // PROCEED AS NORMAL...


Cheers,

!k

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 16, 2007 8:08 AM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

A sample would help out. In this case, the page is all Flash and we're
needing to find out how onRequestEnd is getting called multiple times from
within this particular app.

Thanks for the help Kevin. 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 15, 2007 6:28 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

If you dump the current calling page and filter out pages coming from
/flashservices/gateway than you shouldn't be triggering the onRequestEnd.cfm
page anymore.

I've got a sample at work I'll post tomorrow when I get in...

Cheers,

!k

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 3:55 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

Kevin...

I'm not familiar with remoting at all. Can you clarify how I can filter out
processes coming from remoting in the onRequestEnd.cfm?


andy 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 3:47 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

AMF is an encoded RPC and extremely similar to the idea of web services. You
can learn about AMF at the Red5 project site or the AMFPHP site...

If you ask your developer, he should be able to tell you why unless it's
being called elsewhere that doesn't have anything to do with the CFC.

Are you guys using authentication for your CFC? 
Is this happening with other CFC's? 
Has this been confirmed through the NetConnection Debugger (Flash tool)?

At bare minimum you could ignore anything coming from the gateway within
your onRequestEnd.cfm.

Cheers,

Kevin




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

That'd be great. I'm using SQL Server 2000.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

What Database are you using for this?  I can whip this out in a quick stored
procedure using SQL Server using table variables.

Teddy

On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> Unfortunately, yes
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

Unfortunately, yes

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: SQL Join & Data group output

Will the number of services be dynamic?

Teddy


On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> This explanation is a bit long but it kind of needed it to explain what I
> was trying to achieve.
>
> I have three tables which I would like to join for use within creating a
> table of results
>
> Table 1: has several entries
> Table 3: has a list of services
> Table 2: join these two table using the primary keys
>
> Table: 1
> | tb1ID | field1  | field2 | field3 |
> --
> |   1   |  blah   |  asdf  |  asdf  |
> |   2   |  1234   |  asdf  |  asdf  |
> |   3   |     |  asdf  |  asdf  |
> |   4   |     |  asdf  |  asdf  |
>
> Table: 2
> | tbl2ID | tbl1ID | tbl3ID |
> 
> |   1|   1|   1|
> |   2|   1|   2|
> |   3|   1|   3|
> |   4|   2|   2|
> |   5|   2|   4|
> |   6|   3|   1|
> |   7|   4|   2|
> |   8|   4|   3|
>
> Table: 3
> | tbl3ID | service |
> 
> |   1|  serv1  |
> |   2|  serv2  |
> |   3|  serv3  |
> |   4|  serv4  |
>
>
> I would like it to spit out the results like this:
>
> Output:
> | tb1ID | field1 | field2 | serv1 | serv2 | serv3 | serv4 | field3 |
> ---
> |   1   |  blah  | asdf   |   x   |   x   |   x   |   |  asdf  |
> |   2   |  1234  | asdf   |   |   x   |   |   x   |  asdf  |
> |   3   |    | asdf   |   x   |   |   |   |  asdf  |
> |   4   |    | asdf   |   |   x   |   x   |   |  asdf  |
>
>
>
> The example code I was thinking should be along the lines of:
>
> 
>SELECT  table_1.tb1ID
>,table_1.field1
>,table_1.field2
>,table_1.field3
>,table_3.tbl3ID
>,table_3.service
>FROMtbl3 as table_3
>LEFT OUTER JOIN
>tbl2 as table_2
>ON  table_3.tbl3ID = table_2.tbl3ID
>LEFT OUTER JOIN
>tbl1 as table_1
>ON  table_2.tbl1ID = table_1.tbl1ID
> 
>
> 
> 
>
>tb1ID
>field1
>field2
>
>#service#
>
>field3
>
> 
> 
>
>#tbl1#
>#field1#
>#field2#
>
>x
>
>#tbl1#
>
> 
> 
>
>
> The problem is the services are being repeated in the table head and are
> therefore not unique. Ideally I'd like it such that they always occur and
> could even be ordered etc.
>
> I really can't get my head round this so help is much needed.
> Thanks,
>
> R
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: What is Ruby on Rails?

2007-01-16 Thread John Paul Ashenfelter

On 1/14/07, John C. Bland II <[EMAIL PROTECTED]> wrote:
> Ruby is a programming language (from the 90's or so) that was used a lot as
> an alternative to perl server scripts. A few years back a framework was
> built that gave RoR tons of publicity. I think some of the shine came off
> when they had a gaping security hole in which they demanded that people
> upgrade to the latest revision (was kinda funny the way they approached it).
> In 2 or 3 days they pushed out like 2 or 3 patches. Regardless of that it is
> still a very lightweight, fast, and speedy (to dev' in) language/framework.

That's a bizarre piece of FUD. It's like saying "I think some of the
shine came off ColdFusion when that ToysRUs site performed so poorly"
or "Now that Adobe/Macromedia/whoever owns CF it's doomed" etc. Or all
the FUD about poorly written PHP/CF/whatever apps that are vulnerable
to cross-site scripting attacks and/or SQL injection (heck, even
*gMail* has had a significant security issue if you feel like your
contact list should be private).

For anyone who cares about the details surround this particular issue,
it's summarized here
http://weblog.rubyonrails.org/2006/8/10/rails-1-1-6-backports-and-full-disclosure

I'll also point out that the Rails folks can't *force* anyone to
upgrade -- what they did was refuse to point out the specific problem
or release demo code of the exploit until people had a chance to
patch, but since the project is open source and the SVN repository is
publically available, it's easy enough to run a diff and see what
changed.

I'd suggest that the whole process in general was a good example of
the *point* of open source -- major problem was identified, code was
*quickly* patched to prevent problem, other problems were identified,
and code was patched again, not to mention that the community feedback
on the process was incorporated into the way future incidents are/were
handled.

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: What is Ruby on Rails?

2007-01-16 Thread John Paul Ashenfelter

On 1/14/07, Doug Brown <[EMAIL PROTECTED]> wrote:
> Is there any comparisons to CF and ROR? How fast is the dev time compared to
> CF?

If you're at the Frameworks conference, I'm doing a talk on Rails and
can answer that. But like one of the other posts in the thread, you
have to compare it to a *framework*, like how fast is it compared to
ModelGlue on CF, Fusebox on CF, Struts on Java, Django on Python, etc.
Rails is a framework, Ruby is a language.

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

float in DB becomes integer in CF

2007-01-16 Thread M C

I have a weird problem..

In my database (MS SQL Server) I have the valus 12,53131 in a field of type 
float.

When I retrieve the value using a query and output it, the values is 12!

I have tried running the SQL using the MS SQL Server Management Studio and here 
I get the correct value of 12,53131.

Can anyone shed some ligth on this please?!?  (I am running CF7)

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

2007-01-16 Thread John Paul Ashenfelter

On 1/16/07, Teddy Payne <[EMAIL PROTECTED]> wrote:
> For 1, 2 and 3, you will typically enter records into the database during
> the login process and the logout process that you create.
>
> You will need to put something in onSessionEnd for when sessions expire just
> in case they don't use your logout portion of the code.
>
> As for the data changes, I would recommend letting the DB handle this for
> you.  Most modern databases have triggers.  Use triggers to copy the record
> that was changed or edited into a duplicate log table or log database.

Seconded. If you do a little searching on audit and trigger for your
particular database, you should find some examples to help automate
the process.

As an aside, you need to be pretty careful if you *already* use a lot
of triggers in the app. And of course you need to link the user to the
data that changed, but you might be able to make that easier by adding
a lastUserId or something to each audited table so when the trigger
copies it, the data is already there about the user that goes with the
data.

One more aside, paging through the data in a meaningful way is a pain
-- but a simple history table (recent first) handles the basics for
tracking changes.

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

SQL Join & Data group output

Hi all,

This explanation is a bit long but it kind of needed it to explain what I was 
trying to achieve.

I have three tables which I would like to join for use within creating a table 
of results

Table 1: has several entries
Table 3: has a list of services
Table 2: join these two table using the primary keys

Table: 1 
| tb1ID | field1  | field2 | field3 |
--
|   1   |  blah   |  asdf  |  asdf  |
|   2   |  1234   |  asdf  |  asdf  |
|   3   |     |  asdf  |  asdf  |
|   4   |     |  asdf  |  asdf  |

Table: 2
| tbl2ID | tbl1ID | tbl3ID |

|   1|   1|   1| 
|   2|   1|   2| 
|   3|   1|   3| 
|   4|   2|   2| 
|   5|   2|   4| 
|   6|   3|   1| 
|   7|   4|   2| 
|   8|   4|   3| 

Table: 3
| tbl3ID | service |

|   1|  serv1  |
|   2|  serv2  |
|   3|  serv3  |
|   4|  serv4  |


I would like it to spit out the results like this:

Output: 
| tb1ID | field1 | field2 | serv1 | serv2 | serv3 | serv4 | field3 | 
---
|   1   |  blah  | asdf   |   x   |   x   |   x   |   |  asdf  |
|   2   |  1234  | asdf   |   |   x   |   |   x   |  asdf  |
|   3   |    | asdf   |   x   |   |   |   |  asdf  |
|   4   |    | asdf   |   |   x   |   x   |   |  asdf  |



The example code I was thinking should be along the lines of:


SELECT  table_1.tb1ID
,table_1.field1
,table_1.field2
,table_1.field3
,table_3.tbl3ID
,table_3.service
FROMtbl3 as table_3
LEFT OUTER JOIN
tbl2 as table_2
ON  table_3.tbl3ID = table_2.tbl3ID 
LEFT OUTER JOIN
tbl1 as table_1
ON  table_2.tbl1ID = table_1.tbl1ID



 

tb1ID
field1
field2
   
#service#

field3

 


#tbl1#
#field1#
#field2#

x

#tbl1#





The problem is the services are being repeated in the table head and are 
therefore not unique. Ideally I'd like it such that they always occur and could 
even be ordered etc.

I really can't get my head round this so help is much needed.
Thanks,

R

 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

2007-01-16 Thread Tom Chiverton

On Tuesday 16 January 2007 14:18, Les Mizzell wrote:
> What's "best practice" here to keep up with this?

Copy the row of data you are about to alter before you alter it.
Either to a log file, or what rapidly becomes a very large table.

--
Tom Chiverton
Helping to vitalistically develop granular experiences

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

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at St
James's Court Brown Street Manchester M2 2JF. A list of members is available
for inspection at the registered office. Any reference to a partner in relation
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law
Society.

CONFIDENTIALITY

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

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

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Required Fields

2007-01-16 Thread Joshua Cyr

Try installing http://www.getfirebug.com/ in FF and then see what JS errors
are thrown. 


Joshua Cyr
Savvy Software
866.870.6358
www.besavvy.com

-Original Message-
From: Teddy Payne [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 16, 2007 9:24 AM
To: CF-Talk
Subject: Re: Required Fields

I tested all sorts of inputs yesterday and I could not recreate what you
acheived IBS.

Charlie has it right by asking for a code snippet to see if other developers
experience the same issue of their version of CF.

What is your CF 7 version?  For isntance, mine is 7,0,2,142559.

Teddy


On 1/16/07, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> On 1/15/07, ibs <[EMAIL PROTECTED]> wrote:
> > Any Comments? Thanks.
>
> Sure.
>
> post some code.  view the source of the page and see what the JS looks 
> like (make sure it's even there).  state whether or not you're using 
> any other JS on the page.  use Mozilla and the firebug plugin for 
> debugging.  or make sure IE is set to provide notifications for all 
> scripting errors and see if you get any JS errors.  provide the URL so 
> somebody else can look at it and possibly debug if you don't have the 
> tools.
>
> posting a generic statement ("i have a cfform and the required fields 
> aren't working") really doesn't give anybody here a lot to go on.
>
> --
> Charlie Griefer
>
> 
> "...All the world shall be your enemy, Prince with a Thousand Enemies, 
> and whenever they catch you, they will kill you. But first they must 
> catch you, digger, listener, runner, prince with a swift warning.
> Be cunning and full of tricks and your people shall never be destroyed."
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Method - Logging Database Changes?

For 1, 2 and 3, you will typically enter records into the database during
the login process and the logout process that you create.

You will need to put something in onSessionEnd for when sessions expire just
in case they don't use your logout portion of the code.

As for the data changes, I would recommend letting the DB handle this for
you.  Most modern databases have triggers.  Use triggers to copy the record
that was changed or edited into a duplicate log table or log database.  I
tend to create a copy of the entire schema into a database seperately.
Example, CircusDB and CircusDB_Log.  The exact same table exist in each and
copying data from one DB to another on the same server is a trivial
overhead.

Teddy

On 1/16/07, Les Mizzell <[EMAIL PROTECTED]> wrote:
>
> Client want a complete log of *everything* that happens to within CF
> database admin system
>
> No problem:
> 1. Who logged in
> 2. When they logged in
> 3. When they logged out
> 4. If they changed/added anything
>
> Problem:
> 2. EXACTLY what they changed/added
>
> This is a fairly large multi-page application consisting of 7 pages of
> long forms. They didn't mention this until *after* I completed everything.
>
> What's "best practice" here to keep up with this?
>
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Required Fields

I tested all sorts of inputs yesterday and I could not recreate what you
acheived IBS.

Charlie has it right by asking for a code snippet to see if other developers
experience the same issue of their version of CF.

What is your CF 7 version?  For isntance, mine is 7,0,2,142559.

Teddy


On 1/16/07, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> On 1/15/07, ibs <[EMAIL PROTECTED]> wrote:
> > Any Comments? Thanks.
>
> Sure.
>
> post some code.  view the source of the page and see what the JS looks
> like (make sure it's even there).  state whether or not you're using
> any other JS on the page.  use Mozilla and the firebug plugin for
> debugging.  or make sure IE is set to provide notifications for all
> scripting errors and see if you get any JS errors.  provide the URL so
> somebody else can look at it and possibly debug if you don't have the
> tools.
>
> posting a generic statement ("i have a cfform and the required fields
> aren't working") really doesn't give anybody here a lot to go on.
>
> --
> Charlie Griefer
>
> 
> "...All the world shall be your enemy, Prince with a Thousand Enemies,
> and whenever they catch you, they will kill you. But first they must catch
> you, digger, listener, runner, prince with a swift warning.
> Be cunning and full of tricks and your people shall never be destroyed."
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Method - Logging Database Changes?

Client want a complete log of *everything* that happens to within CF 
database admin system

No problem:
1. Who logged in
2. When they logged in
3. When they logged out
4. If they changed/added anything

Problem:
2. EXACTLY what they changed/added

This is a fairly large multi-page application consisting of 7 pages of 
long forms. They didn't mention this until *after* I completed everything.

What's "best practice" here to keep up with this?




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Digg-like software

2007-01-16 Thread Rey Bango

Anyone know of Digg-like software thats open source (and preferably 
CF-based)?

I know of Pligg but was wondering what other options exist.

Rey...

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Flash remoting and onRequestEnd.cfm

2007-01-16 Thread Andy Matthews

A sample would help out. In this case, the page is all Flash and we're
needing to find out how onRequestEnd is getting called multiple times from
within this particular app.

Thanks for the help Kevin. 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 15, 2007 6:28 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

If you dump the current calling page and filter out pages coming from
/flashservices/gateway than you shouldn't be triggering the onRequestEnd.cfm
page anymore.

I've got a sample at work I'll post tomorrow when I get in...

Cheers,

!k

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 3:55 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

Kevin...

I'm not familiar with remoting at all. Can you clarify how I can filter out
processes coming from remoting in the onRequestEnd.cfm?

andy 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 3:47 PM
To: CF-Talk
Subject: RE: Flash remoting and onRequestEnd.cfm

AMF is an encoded RPC and extremely similar to the idea of web services. You
can learn about AMF at the Red5 project site or the AMFPHP site...

If you ask your developer, he should be able to tell you why unless it's
being called elsewhere that doesn't have anything to do with the CFC.

Are you guys using authentication for your CFC? 
Is this happening with other CFC's? 
Has this been confirmed through the NetConnection Debugger (Flash tool)?

At bare minimum you could ignore anything coming from the gateway within
your onRequestEnd.cfm.

Cheers,

Kevin

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: problem with a file extension

2007-01-16 Thread alex poyaoan

Yes Rich
thanks i added the jpg on the filename and it resolved everything and on the 
properties it gives me the filename right.. 

again thanks

>Did you try removing the seemingly extra single quote mark before
>.jpg? This will be added to your file name and it may be that you
>don't need this?
>
>If there is no error, is there a blank image placeholder where the
>image should be? If there is, right click on it and select properties
>and it should tell you the path and image name that has been output
>and this may give you more clues as to what is going wrong with the
>file name.
>
>On 1/16/07, alex poyaoan <[EMAIL PROTECTED]> wrote:
>>

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: using a query from createobject