date:20070109

Thanks Charlie. That did it.

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 09, 2007 4:20 PM
To: CF-Talk
Subject: Re: JS and Radio Button Issue

few things i can see would be a problem.

you have multiple elements with ids "with" and "without" (the radio
buttons and the divs).

the code below should work.


function toggle(divToShow) {
if (document.getElementById) {
if (divToShow == "with") {

document.getElementById('withdiv').style.display = "inline";

document.getElementById('withoutdiv').style.display = "none";
} else {

document.getElementById('withdiv').style.display = "none";

document.getElementById('withoutdiv').style.display = "inline";
}
}
}


 With

 Without




With vote by mail options here


without vote by mail options here


On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> I have a form that has two radio buttons. Their function is to show one of
> two hidden divs.
> The JS is this:
> 
> function toggle('with', 'without')
> {
> if (document.getElementById) {
> withvbm= document.getElementById('with');
> withoutvbm= document.getElementById('without');
> }
>
> if (withvbm.style.display == "none"){
> withvbm.style.display = "";
> withoutvbm.style.display = "none";
> }
>
> else if (withoutvbm.style.display == "none"){
> withoutvbm.style.display = "";
> withvbm.style.display = "none";
> }
> }
> 
> The radio buttons look like this:
>  With
> onclick="toggle('without', 'with')">With Out
>
> And the divs look like this:
>  
>  With vote by mail options here
>  
>  
>  without vote by mail options here
>  
> When I click either button, I get an error that and Object is expected.
The
> error is on the radio buttons. From what I can tell everything looks OK.
Can
> anyone see any issues with this? Also, I tried changing the first div's
> style to display:block assuming that the page needed to see one of them
and
> of it did not work, but then I though no, that cannot be it since I want
> both div's hidden until the user clicks one of the buttons.
>
> Thanks,
> --
> Bruce Sorge
>
>
> 



~|
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:266107
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Getting changed fields from database using an audit table

Thanks - I'll give that a try.

-Original Message-
From: "Richard Kroll" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: 1/9/07 5:03 PM
Subject: RE: Getting changed fields from database using an audit table

Doug,
After seeing your intended output the query will need to change a bit,
but I think I understand what you are after.

Could you do something like this: (beware this SQL psudeo-code it's
untested)

declare @User_modify table(
UserID int,
FieldName nvarchar(50),
NewValue nvarchar(50)
)
declare @col sysname 

declare colList cursor local fast_forward for
select  COLUMN_NAME
fromINFORMATION_SCHEMA.COLUMNS
WHERE   TABLE_NAME = 'USER_UPDATED'

open colList

-- loop over the column list @col will hold the current column
fetch next from colList into @col
while (@@fetch_status = 0) begin
-- insert matching records into the temp table
insert into @User_Modify(UserId, FieldName, newValue)
SELECT userid, @col,
cast(@col as sysname) as newValue
FROM users where @col > 

fetch next from colList into @col
end 

close colList 
deallocate colList

select * from @user_modify

This way you could offload a lot of the processing onto the SQL server.

HTH,

Rich Kroll


> -Original Message-
> From: Doug Bezona [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 1:59 PM
> To: CF-Talk
> Subject: RE: Getting changed fields from database using an audit table
> 
> Thanks
> 
> Unfortunately, simply having the two tables joined doesn't help.
> 
> The issue isn't getting the correct data, it's simply that to get the
> output I need, I have to loop over each column in each record to see
> which column has been updated in a given time period, and output the
> info about that column.
> 
> USERS has a single "lastupdated" column, just so we know when it was
> updated. USER_UPDATED has most of the same columns as USERS, but each
> column just holds a date stamp of the last time the corresponding
field
> was updated in USERS
> 
> The data looks something like this:
> 
> USERS:
> 
> UserIDFirstnameLastname
> ------
>   1 John  Doe
>   2 Jane  Smith
> 
> 
> USER_UPDATE:
> 
> UserIDFirstnameLastname
> ----   ---
>   1   07/08/2005   10/31/2006
>   2   05/10/20067/15/2006
> 
> 
> The output I am looking for is this, given an input date of
01/01/2006:
> 
> UserID   FieldNameValue
> ---  ---  ---
>1 Lastname  Doe
>2 Firstname Jane
>2 Lastname  Smith
> 
> 
> The code produces the exact output I need, so the basic logic is fine
> (if not as fast as I need it to be).
> 
> The queries run in a few milliseconds, so they aren't the bottleneck.
> 
> It's the looping through each column in each record of the resultset
to
> check the updated date of each field when it's 12000 records x 89
> columns that's the bottleneck.
> 



~|
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:266106
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Itext-Coldfusion Error

2007-01-09 Thread Trying2 Survive

I am trying to use the iText with coldfusion to dynamically generate a PDF on 
the fly (cfdocument is way too limited). I have no problem setting the images 
at absolute positions, however when I try to set text at absolute positions 
using various methods, I get an error that says "Class 
coldfusion.runtime.java.JavaProxy can not access a member of class 
com.lowagie.text.pdf.PdfWriter with modifiers "protected".Does anyone have any 
insight on this? Need help desperately. Thanks!

~|
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:266105
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: FarCry and TinyMCE issue

2007-01-09 Thread Adrian Wagner

Jon,
 
I actually lodged a bug report on sourceforge. This is the reply I
got:
IE:s selection gets lost sometimes if you focus another iframe inside
thesame document. The inline popup plugin has this issue but it's
resolvedusing the following method: Use the var b =
inst.selection.getBookmark();and inst.selection.moveToBookmark(b);
functions before and after a insert.It will store away the current
selection and then restore it. Consult theAPI docs for details.I'm
currently trying to apply this - but all attempts have failed so far.
;)Adrian


~|
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:266104
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: JS and Radio Button Issue

2007-01-09 Thread Charlie Griefer

few things i can see would be a problem.

you have multiple elements with ids "with" and "without" (the radio
buttons and the divs).

the code below should work.


function toggle(divToShow) {
if (document.getElementById) {
if (divToShow == "with") {

document.getElementById('withdiv').style.display = "inline";

document.getElementById('withoutdiv').style.display = "none";
} else {

document.getElementById('withdiv').style.display = "none";

document.getElementById('withoutdiv').style.display = "inline";
}
}
}


 With

 Without




With vote by mail options here


without vote by mail options here


On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> I have a form that has two radio buttons. Their function is to show one of
> two hidden divs.
> The JS is this:
> 
> function toggle('with', 'without')
> {
> if (document.getElementById) {
> withvbm= document.getElementById('with');
> withoutvbm= document.getElementById('without');
> }
>
> if (withvbm.style.display == "none"){
> withvbm.style.display = "";
> withoutvbm.style.display = "none";
> }
>
> else if (withoutvbm.style.display == "none"){
> withoutvbm.style.display = "";
> withvbm.style.display = "none";
> }
> }
> 
> The radio buttons look like this:
>  With
> onclick="toggle('without', 'with')">With Out
>
> And the divs look like this:
>  
>  With vote by mail options here
>  
>  
>  without vote by mail options here
>  
> When I click either button, I get an error that and Object is expected. The
> error is on the radio buttons. From what I can tell everything looks OK. Can
> anyone see any issues with this? Also, I tried changing the first div's
> style to display:block assuming that the page needed to see one of them and
> of it did not work, but then I though no, that cannot be it since I want
> both div's hidden until the user clicks one of the buttons.
>
> Thanks,
> --
> Bruce Sorge
>
>
> 

~|
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:266103
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

JS and Radio Button Issue

I have a form that has two radio buttons. Their function is to show one of
two hidden divs.
The JS is this:

function toggle('with', 'without')
{
if (document.getElementById) {
withvbm= document.getElementById('with');
withoutvbm= document.getElementById('without');
}

if (withvbm.style.display == "none"){
withvbm.style.display = "";
withoutvbm.style.display = "none";
}

else if (withoutvbm.style.display == "none"){
withoutvbm.style.display = "";
withvbm.style.display = "none";
}
}

The radio buttons look like this:
 With
   With Out

And the divs look like this:
 
 With vote by mail options here
 
 
 without vote by mail options here
 
When I click either button, I get an error that and Object is expected. The
error is on the radio buttons. From what I can tell everything looks OK. Can
anyone see any issues with this? Also, I tried changing the first div's
style to display:block assuming that the page needed to see one of them and
of it did not work, but then I though no, that cannot be it since I want
both div's hidden until the user clicks one of the buttons.

Thanks,
-- 
Bruce Sorge


~|
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:266102
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Help with CFXML and Flash 8

2007-01-09 Thread Aaron Roberson

I have a flash menu that is being dynamically created using an XML
file with the navigation schema. The XML file is currently hard coded,
but I would like to make the url path attributes dynamic so that I
don't have to maintain two different xml files (one for my local
environment and one for the remote).

Is it possible to use the CFXML tag to generate XML markup and have
Flash 8 treat that file as XML?

Here is what the template would look like that would generate my XML:












#ToString(theXML)#


The only apparent problem is that the file would have a .cfm extension
and not a .xml extension, which I'm not sure if Flash will accept.

Thanks in advance,
Aaron

~|
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:266101
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

I hope I'm understanding you correctly; but I'm assuming you mean that the
form data, taken together, essentially constitutes a "record" in your data
source. If so, I think you want to use a "transfer object" that receives and
carries that data along.

While I'm not educated enough to give you a good explanation of transfer
objects, value objects and beans, they can all provide an object that lets
you move the data around. And you'll find lots of discussion of them on the
CFC-DEV list, and on the lists for Model-Glue, Mach-II, Reactor, Transfer,
et al.

In your case, you'd need to place the form data into the transfer object (if
it's a bean, it would have methods like getHeadline() and setHeadline(), for
instance). Some frameworks like Model-Glue and Mach-II can populate these
objects automatically as long as the form field names match the names in the
bean.

Once you have the object populated, you can do anything you want: you can
save it to your database (by passing to a DAO), you can turn around and feed
it to a page that displays a preview, or you can send it to an Edit form for
revision.

To answer your question a little further, yes, you would need another layer
(or two) to handle the form data, populate the bean, then decide what to do
with it. The DAO would just handle the INSERT or UPDATE when it was time to
do so.

--
Thanks,

Tom

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

~|
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:266100
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Damien McKenna

On 1/9/07 6:03 AM, Jochem van Dieten wrote:
> The only thing I miss in PostgreSQL is eager update-everywhere replication.
> There are commercial offerings for that, but all the community offerings are
> either lazy or master-slave.

I'll second that, I read through the manual and instantly wanted to elope
;-) but the lack of more solid replication / clustering abilities are a bit
limiting.  At the very least you can start off with the basic system and
migrate / upgrade to EnterpriseDB in the future if you need to, which'll
give you more flexible replication support.

-- 
Damien McKenna - Web Developer [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 

~|
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:266099
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Getting changed fields from database using an audit table

Doug,
After seeing your intended output the query will need to change a bit,
but I think I understand what you are after.

Could you do something like this: (beware this SQL psudeo-code it's
untested)

declare @User_modify table(
UserID int,
FieldName nvarchar(50),
NewValue nvarchar(50)
)
declare @col sysname 

declare colList cursor local fast_forward for
select  COLUMN_NAME
fromINFORMATION_SCHEMA.COLUMNS
WHERE   TABLE_NAME = 'USER_UPDATED'

open colList

-- loop over the column list @col will hold the current column
fetch next from colList into @col
while (@@fetch_status = 0) begin
-- insert matching records into the temp table
insert into @User_Modify(UserId, FieldName, newValue)
SELECT userid, @col,
cast(@col as sysname) as newValue
FROM users where @col > 

fetch next from colList into @col
end 

close colList 
deallocate colList

select * from @user_modify

This way you could offload a lot of the processing onto the SQL server.

HTH,

Rich Kroll


> -Original Message-
> From: Doug Bezona [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 1:59 PM
> To: CF-Talk
> Subject: RE: Getting changed fields from database using an audit table
> 
> Thanks
> 
> Unfortunately, simply having the two tables joined doesn't help.
> 
> The issue isn't getting the correct data, it's simply that to get the
> output I need, I have to loop over each column in each record to see
> which column has been updated in a given time period, and output the
> info about that column.
> 
> USERS has a single "lastupdated" column, just so we know when it was
> updated. USER_UPDATED has most of the same columns as USERS, but each
> column just holds a date stamp of the last time the corresponding
field
> was updated in USERS
> 
> The data looks something like this:
> 
> USERS:
> 
> UserIDFirstnameLastname
> ------
>   1 John  Doe
>   2 Jane  Smith
> 
> 
> USER_UPDATE:
> 
> UserIDFirstnameLastname
> ----   ---
>   1   07/08/2005   10/31/2006
>   2   05/10/20067/15/2006
> 
> 
> The output I am looking for is this, given an input date of
01/01/2006:
> 
> UserID   FieldNameValue
> ---  ---  ---
>1 Lastname  Doe
>2 Firstname Jane
>2 Lastname  Smith
> 
> 
> The code produces the exact output I need, so the basic logic is fine
> (if not as fast as I need it to be).
> 
> The queries run in a few milliseconds, so they aren't the bottleneck.
> 
> It's the looping through each column in each record of the resultset
to
> check the updated date of each field when it's 12000 records x 89
> columns that's the bottleneck.
> 

~|
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:266098
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Damien McKenna

On 1/8/07 8:40 PM, Jacob Munson wrote:
> I agree, I think every database has some non-standard SQL.  An example in MS
> SQL is the isNull() function, which is functionally equivalent to the ANSI
> standard coalesce().  Why did MS make their own?

Now() vs GetDate(), etc.

-- 
Damien McKenna - Web Developer [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 




~|
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:266097
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Damien McKenna

On 1/8/07 7:29 PM, Matt Quackenbush wrote:
> - non-standard sql

It is different to SQL Server, but that doesn't mean that SQL Server is
standard compliant either.  In 8.x they've made many tweaks to make it even
more standards compliant in its syntax, so please have him check his facts.

> - difficult to backup / migrate

The backup seems straight forward using pg_dump, what were his specific
issues? 

> - user authenication is weak

No it isn't, it just doesn't link into Active Directory :-P

> - difficult to setup

No it isn't :-P 

> - difficult to manage

Both PGAdmin III and phpPgAdmin (latest betas) are great, and then there's
the command-line tools, what else does he want?

> mentioned that I was unaware of that is pretty much an instant turn-off for
> me: cAsE sEnSiTiViTy.

It depends on how you write your code, please RTFM: pages 26 and 27 or
sections 4.1.2.1 and 4.1.2.2.

-- 
Damien McKenna - Web Developer [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 

~|
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:266096
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: PostgreSQL vs. MSSQL

> Are you aware of anyone who currently runs MS SQL in case 
> sensitive mode? I'd be curious to know how often that happens.

Quite a few people do this, in my experience. You can specify different
collations for each database within an instance. Collations determine other
things in addition to case sensitivity.

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:266095
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cfqueryparam and Oracle

2007-01-09 Thread Ian Skinner

When I use CFQUERYPARAM with an Oracle database, I receive the error "query not 
properly ended."

When I use CFQueryParam with several Oracle databases (8.x to 10g), it works 
exactly is it is supposed to.

Maybe more details about your code and the exact error and we could help.


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

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
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:266094
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Cfqueryparam and Oracle

2007-01-09 Thread Alton Chinn

When I use CFQUERYPARAM with an Oracle database, I receive the error "query not 
properly ended."

>ALWAYS use CFQUERYPARAM...it's not just for stopping SQL injection 
>attacksit 
>also increases query speed by using BIND variables (at least with Oracle and 
>MS 
>SQL Server.not Accessnot sure about mySQL).
>
>HTH
>
>Cheers
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: [EMAIL PROTECTED]
>web: www.electricedgesystems.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:266093
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Design Question.

2007-01-09 Thread Ian Skinner

I think this is a bit of an OOD type question.  I'm developing a project for 
managing structured news content that is currently done with the separate tools 
for different type of news.

I've created a front end I am fairly happy with that allows me to define the 
structure of each of the news types and a form for entering and editing the 
specific content is generated.  I then see using a DAO concept for storing the 
content, currently in XML files.  But I'm stuck in the middle on a "Preview" 
requirement that shows the content formatted as it will be displayed.

The trouble I'm having is with taking the form data and structuring it.  I 
envision this as a function of the DAO.  Is this a good assumption?  If it is, 
how do I use the DAO to structure the data for the preview step, before it is 
ready to be committed to data storage?  Or is this more a function belonging to 
a different layer?  Should I create a separate function to convert the form 
data to the storage structure?  Do I do this once and send the converted data 
to the DAO for committing after the preview or send the unstructured form data 
to the DAO for formatting and storage?

Is any of this understandable?


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

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
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:266092
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 and OOP - Controller

Matt,
Glad I could help.  Good luck on your project and the OO adventure!

Rich Kroll

~|
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:266091
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 Exam Certification Study Gruop

2007-01-09 Thread Elena Aminova

Same here, I am in NY, so definitly through the Adobe Connect, if that can
get set up.
A very good idea, by the way.

On 1/3/07, Dan Vega <[EMAIL PROTECTED]> wrote:
>
> If you get connect setup I would defiantly be interested in attending as
> long as it doesnt conflict with current user group meetings!
>
> Dan
>
> On 1/3/07, Nicholas M Tunney <[EMAIL PROTECTED]> wrote:
> >
> > Would anyone be interested in attending a ColdFusion MX 7 Developer
> > Certification
> > <
> >
> http://www.adobe.com/support/training/certified_professional_program/cfmx7_developer.html
> > >
> > exam study group^* ?
> >
> > There would be no cost to attend (unless we all chip in for pizza or
> > something). I am thinking it would be a three night class located
> > somewhere near Rockville/Bethesda MD (anyone who is willing to donate or
> > suggest a location let me know!). We would be concentrating on the 4
> > primary sections of the Adobe ColdFusion MX 7 Developer exam
> > <
> >
> http://www.adobe.com/support/training/certified_professional_program/cfmx7_developer.html
> > >
> > (Application Development, Database Concepts, Client State Management and
> > Data Exchange) as well as discussing common hang ups and testing
> > techniques.
> >
> > If I can get this set up via Adobe Connect, I will extend the invitation
> > to those not available to attend in person.
> >
> > If you are interested, please send me your contact information
> >  or
> > comment on this post.
> >
> > * - This is not an Adobe course
> >
> > --
> > Nicholas M Tunney
> > Senior Software Architect, AboutWeb LLC - http://www.AboutWeb.com
> >
> > Certified Advanced ColdFusion MX 7 Developer
> > Blog - http://www.nictunney.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:266090
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: capture a signature in a mobil web form

2007-01-09 Thread Kevin Aebig

I'm not sure whether or not the 8125 has Flash, but if it does, you can
capture the signature, save the bitmapData and convert it to an image with
CF than save it to a DB.

You'd have to be clear that the signature you get no matter the interface,
won't be as good as one captured by pen.

Cheers,

!k

-Original Message-
From: Keith McGee [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 08, 2007 10:13 AM
To: CF-Talk
Subject: capture a signature in a mobil web form 

Is there anyway to use the cingular 8125 to capture a signature in a mobil
web form and transfer it into database via coldfusion?

Thanks 
Keith



~|
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:266089
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 and OOP - Controller

Rich,

Thanks for the kick-ass reply.  Somehow it got buried beneath the piles of
email, and I just now saw it; sorry about that.  Your post is most
informative, and very helpful.

As of a couple of days ago, being 6+ weeks behind on a project that I was
going to run on my new framework has made me put it (framework development)
on hold, and I picked up MG:U and began studying it.  I have found precisely
what you were saying to be true.  By studying the MG:U framework, and by
working with it, many more things (including controllers, traffic cops, etc)
are becoming quite clear.  And, like you said, by focusing more on the model
itself, it's 1) alleviating most of the headaches, and 2) helping me
understand the other portions s much better.

Anyways, sorry for the delayed response!  Back to my OO adventure for now
:-)


Thanks,

Matt


~|
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:266088
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: GoDaddy Hosting Issue

So I need to retract the lack of support for CFDUMP. They do support it.
CFOBJECT though they do not. Not a problem though really. GoDaddy is pretty
good otherwise though. Inexpensive to host. The only complaint that I would
have is lack of support for using Enterprise Manager on the SQL Server. You
have to use their web client. I noticed though that a lot of sites are doing
this.

On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
>
> Thanks for the extra set of eyes Charlie. It works now.
>
> On 1/9/07, Charlie Griefer <[EMAIL PROTECTED]> wrote:
> >
> > ?  see if that works and if so, what it
> > displays.
> >
> > should the variable be spelled "exception" (as opposed to "exeption")?
> >
> > On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> > > So if I comment out the CFDUMP tag, then all works fine. If I put the
> > > #Arguments.Exeption# in a CFOUTPUT, I
> > > getcoldfusion.runtime.EventHandlerException: Event Handler Exception.
> > Any
> > > thoughts?
> > >
> > > Bruce
> > >
> > >
> > >
> >
> > 

~|
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:266087
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: GoDaddy Hosting Issue

Thanks for the extra set of eyes Charlie. It works now.

On 1/9/07, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> ?  see if that works and if so, what it
> displays.
>
> should the variable be spelled "exception" (as opposed to "exeption")?
>
> On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> > So if I comment out the CFDUMP tag, then all works fine. If I put the
> > #Arguments.Exeption# in a CFOUTPUT, I
> > getcoldfusion.runtime.EventHandlerException: Event Handler Exception.
> Any
> > thoughts?
> >
> > Bruce
> >
> >
> >
>
> 

~|
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:266086
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: GoDaddy Hosting Issue

I did what Charlie said and it worked. So there is someting else wrong. I am
working on it now.

On 1/9/07, Greg Morphis <[EMAIL PROTECTED]> wrote:
>
> do what Charlie said.. just do something like
> 
> 
>
> If that doesnt work, then it's a problem with Google.
>
> On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> > So if I comment out the CFDUMP tag, then all works fine. If I put the
> > #Arguments.Exeption# in a CFOUTPUT, I
> > getcoldfusion.runtime.EventHandlerException: Event Handler Exception.
> Any
> > thoughts?
> >
> > Bruce
> >
> >
> >
>
> 

~|
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:266085
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: GoDaddy Hosting Issue

2007-01-09 Thread Charlie Griefer

?  see if that works and if so, what it displays.

should the variable be spelled "exception" (as opposed to "exeption")?

On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> So if I comment out the CFDUMP tag, then all works fine. If I put the
> #Arguments.Exeption# in a CFOUTPUT, I
> getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any
> thoughts?
>
> Bruce
>
>
> 

~|
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:266084
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: GoDaddy Hosting Issue

2007-01-09 Thread Greg Morphis

do what Charlie said.. just do something like

If that doesnt work, then it's a problem with Google.

On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> So if I comment out the CFDUMP tag, then all works fine. If I put the
> #Arguments.Exeption# in a CFOUTPUT, I
> getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any
> thoughts?
>
> Bruce
>
>
> 

~|
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:266083
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: GoDaddy Hosting Issue

So if I comment out the CFDUMP tag, then all works fine. If I put the
#Arguments.Exeption# in a CFOUTPUT, I
getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any
thoughts?

Bruce


~|
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:266082
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: PostgreSQL vs. MSSQL

Jochem,

I was hoping that you would respond.  I've seen a number of your posts
regarding PostgreSQL, and certainly wanted your opinion.  :-)

We all know what opinions are like, which is why I didn't want to just take
my friend's opinion as the end-all official truth.  Thanks to you all, I
believe that I'm going to give Postgre a shot and see how I like it myself.

My intent is to have a dedicated db server (windows server 2003 - std ed.),
which will run only the db.  However, in a test/dev environment, I don't
have that luxury.  So, are there any issues that I need to be aware of when
running on XP Pro along with IIS and CF 7.x in my dev environment?


Thanks,

Matt


On 1/9/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>
> Matt Quackenbush wrote:
> > Thanks for the reply.  I forgot to post his specific gripes about
> it.  Here
> > is a quick summary:
> >
> > - non-standard sql
>
> I think that depends on what you call 'standard sql'. To me, standard SQL
> is what is defined in ISO/IEC 9075 and few do better then PostgreSQL in that
> respect. But if you take 'standard sql' to mean 'the SQL in product X', you
> may discover many differences.
>
>
> > - difficult to backup / migrate
>
> What is difficult about scheduling "pg_dumpall -f dumpfile"?
>
> For migration he may have a point. PostgreSQL will not allow you to shut
> down the database, pack up the data files, put them on another machine and
> start up there. While this technically is possible in some circumstances, it
> is not a documented procedure because it is guaranteed not to work when you
> move from for instance Windows to an AIX mainframe. Other products that only
> run on limited platforms and do not have to worry about memory alignment and
> the endianness of the host operating system do not have this limitation.
>
>
> > - user authenication is weak
>
> PostgreSQL allows the DBA to use anything from no authentication to
> Kerberos and you can even create single-signon with a Windows domain. User
> authentication is as weak as the DBA configured it to be.
>
> And if we extend this to security in general you might want to Google a
> bit. PostgreSQL is highly regarded for its security track record and is
> often an example to other databases. For instance, while many databases
> install themselves under an account with elevated privileges by default even
> when that is technically not necessary, PostgreSQL refuses to run if it has
> more permissions then it needs.
>
>
> > - difficult to setup
>
> http://www.suite101.com/article.cfm/oracle/115560
>
>
> > - difficult to manage
>
> To manage PostgreSQL you need to do a few things that are clearly spelled
> out in the manual:
> http://www.postgresql.org/docs/8.2/static/maintenance.html
> http://www.postgresql.org/docs/8.2/static/backup.html
> Again I would have to ask what is so hard about setting up a scheduled
> task.
>
> In short: you may want to ask him if he is not confusing PostgreSQL with
> some other database.
>
>
> > Your post was most informative, for sure.  But there's one thing that
> you
> > mentioned that I was unaware of that is pretty much an instant turn-off
> for
> > me: cAsE sEnSiTiViTy.
>
> PostgreSQL identifiers are only case sensite if you make them case
> sensitive by enclosing them between double quotes. The following code will
> run just fine:
>
> CREATE TABLE fOo (BaR INTEGER);
>
> SELECT bAr FROM foo;
>
> 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:266081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: PostgreSQL vs. MSSQL

Jon,

Thanks for the clarification.


Matt


On 1/9/07, Jon Clausen <[EMAIL PROTECTED]> wrote:
>
> On Jan 9, 2007, at 3:23 AM, Matt Quackenbush wrote:
>
> > Thanks for the reply.  Do you currently run MySQL and/or PostgreSQL on
> > Windows boxes?  If so, what version(s) for both the db server and
> > windows
> > servers?
>
> Both.  8.2 for Postgres and 5.1 for MySQL.XP Pro and Server 2003
> for the OS.
>
>
> > Also, just to clarify on the case-sensitivity point you made, am I
> > correctly
> > understanding that the following query **typically**
> > would not have any
> > issues?
> >
> > 
> > SELECT my_field
> >FROM my_table;
> > 
> >
> > Even if the field was named as 'my_Field' (minus the quotes) in the
> > database?
>
> Actually, the other way around.  When you convert your tables over to
> Postgres, you'll have to lowercase them.  Once again, though if you
> don't quote the table names in the script, Pg will automatically take
> care of lower casing that for you when you run the Create's.
>
> Then any queries you have with mixed case names for the table
> attributes will still run.
>
> If you uppercase any of the table/column names,  you will have to
> quote them.
>
> HTH,
>
> Jon
>


~|
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:266080
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: GoDaddy Hosting Issue

OK. I was mistaken. The error seems to be with the onApplicationStart
section of the Application.cfc. Funny thing is that it works on my laptop
and testing server. More troubleshooting. Gotta love it.

BTW, here is where you can see the error:

www.dalethemovie.com/Offers


On 1/9/07, Dan Vega <[EMAIL PROTECTED]> wrote:
>
> I would look into this a little deeper. There would be no reason for a
> host
> to block . The cfobject tag I understand though. Just so you  are
> aware Bruce, it is pretty common for hosts (not just GoDaddy) to block
> certain tags or take the route of implementing security sandboxes.
>
> Dan Vega
> http://www.danvega.org/blog
>
> On 1/9/07, Charlie Griefer <[EMAIL PROTECTED]> wrote:
> >
> > that seems...odd.
> >
> > can you just throw a template up there with a 
> > just for shits and giggles?
> >
> > On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> > > If anyone plans on using GoDaddy for CF hosting, be careful There are
> > some
> > > tags that they do not suport, like CFDUMP. I have in my
> Application.cfca
> > > cftry-catch block that does a query on a table on only the first row
> to
> > make
> > > sure that there is a connection to the database, and if not it throws
> a
> > > friendly error message to the user and sends me an email. I am dumping
> > the
> > > information into the mail. Well it works fine on my test server but
> > gives me
> > > a java.lang error message. I checked their support site for this and
> > there
> > > is nothing there. So I am assuming they do not support that tag just
> as
> > they
> > > do not support CFOBJECT and some others.
> > > No big deal since I am not using CFOBJECT anyway, but it sucks that I
> > cannot
> > > dump out variables and such if there is an error on the live site.
> > >
> > > --
> > > Bruce Sorge
> > >
> > >
> > >
> >
> >
>
> 

~|
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:266079
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: GoDaddy Hosting Issue

2007-01-09 Thread Dan Vega

I would look into this a little deeper. There would be no reason for a host
to block . The cfobject tag I understand though. Just so you  are
aware Bruce, it is pretty common for hosts (not just GoDaddy) to block
certain tags or take the route of implementing security sandboxes.

Dan Vega
http://www.danvega.org/blog

On 1/9/07, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> that seems...odd.
>
> can you just throw a template up there with a 
> just for shits and giggles?
>
> On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> > If anyone plans on using GoDaddy for CF hosting, be careful There are
> some
> > tags that they do not suport, like CFDUMP. I have in my Application.cfca
> > cftry-catch block that does a query on a table on only the first row to
> make
> > sure that there is a connection to the database, and if not it throws a
> > friendly error message to the user and sends me an email. I am dumping
> the
> > information into the mail. Well it works fine on my test server but
> gives me
> > a java.lang error message. I checked their support site for this and
> there
> > is nothing there. So I am assuming they do not support that tag just as
> they
> > do not support CFOBJECT and some others.
> > No big deal since I am not using CFOBJECT anyway, but it sucks that I
> cannot
> > dump out variables and such if there is an error on the live site.
> >
> > --
> > Bruce Sorge
> >
> >
> >
>
> 

~|
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:266078
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: GoDaddy Hosting Issue

2007-01-09 Thread Charlie Griefer

that seems...odd.

can you just throw a template up there with a 
just for shits and giggles?

On 1/9/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> If anyone plans on using GoDaddy for CF hosting, be careful There are some
> tags that they do not suport, like CFDUMP. I have in my Application.cfc a
> cftry-catch block that does a query on a table on only the first row to make
> sure that there is a connection to the database, and if not it throws a
> friendly error message to the user and sends me an email. I am dumping the
> information into the mail. Well it works fine on my test server but gives me
> a java.lang error message. I checked their support site for this and there
> is nothing there. So I am assuming they do not support that tag just as they
> do not support CFOBJECT and some others.
> No big deal since I am not using CFOBJECT anyway, but it sucks that I cannot
> dump out variables and such if there is an error on the live site.
>
> --
> Bruce Sorge
>
>
> 

~|
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:266077
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

GoDaddy Hosting Issue

If anyone plans on using GoDaddy for CF hosting, be careful There are some
tags that they do not suport, like CFDUMP. I have in my Application.cfc a
cftry-catch block that does a query on a table on only the first row to make
sure that there is a connection to the database, and if not it throws a
friendly error message to the user and sends me an email. I am dumping the
information into the mail. Well it works fine on my test server but gives me
a java.lang error message. I checked their support site for this and there
is nothing there. So I am assuming they do not support that tag just as they
do not support CFOBJECT and some others.
No big deal since I am not using CFOBJECT anyway, but it sucks that I cannot
dump out variables and such if there is an error on the live site.

-- 
Bruce Sorge


~|
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:266076
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Getting changed fields from database using an audit table

Thanks

Unfortunately, simply having the two tables joined doesn't help. 

The issue isn't getting the correct data, it's simply that to get the
output I need, I have to loop over each column in each record to see
which column has been updated in a given time period, and output the
info about that column.

USERS has a single "lastupdated" column, just so we know when it was
updated. USER_UPDATED has most of the same columns as USERS, but each
column just holds a date stamp of the last time the corresponding field
was updated in USERS

The data looks something like this:

USERS:

UserIDFirstnameLastname
------
  1 John  Doe 
  2 JaneSmith


USER_UPDATE:

UserIDFirstnameLastname
----   ---
  1   07/08/2005   10/31/2006
  2   05/10/20067/15/2006


The output I am looking for is this, given an input date of 01/01/2006:

UserID   FieldNameValue 
---  ---  ---
   1 Lastname  Doe
   2 Firstname Jane
   2 Lastname  Smith


The code produces the exact output I need, so the basic logic is fine
(if not as fast as I need it to be).

The queries run in a few milliseconds, so they aren't the bottleneck.

It's the looping through each column in each record of the resultset to
check the updated date of each field when it's 12000 records x 89
columns that's the bottleneck.




> -Original Message-
> From: Richard Kroll [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 1:26 PM
> To: CF-Talk
> Subject: RE: Getting changed fields from database using an audit table
> 
> In a SQL query without the dynamic column list, is this what you are
> trying to achieve?
> 
> SELECTu.id
> FROM  users u
> INNER JOINusers_updated up
>   ON  u.id = up.id AND up.lastupdated >=  cfsqltype="cf_sql_date" value="#since#">
> WHERE u.id IN (
>   SELECT  id
>   FROMUSER_UPDATE up1
>   WHERE
>   u.cola <> up1.cola OR
>   u.colb <> up1.colb OR
>   u.colc <> up1.colc OR
>   etc <> etc
>   )
> 
> Rich Kroll
> 
> 
> 

~|
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:266075
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC Question

2007-01-09 Thread Ryan, Terrence

My particular way around this is to set a CFC path variable in the application 
scope.  So I call CFC's like this:



Or 




Yeah it's extra typing, but is a lot easier to maintain.  If that option is 
palatable to you. 


Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 09, 2007 1:39 PM
To: CF-Talk
Subject: CFC Question

I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On
the live server though the root directory is SynergyDale. So of course my
CFC's cannot be found. Do I need to change the directory name on my laptop
to SynergyDale or is there a way for me to keep my directory the same name
and still reference the CFC. I am going to guess that I have to change my
local directory since the CFC is referenced as NASCAR.CFC.Queries?

-- 
Bruce Sorge

~|
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:266074
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFC Question

I figured it out. Just droped the SynergyDale and use CFC.Queries.

On 1/9/07, Jon Clausen <[EMAIL PROTECTED]> wrote:
>
> Bruce,
>
> Create a mapping in the CF Admin on your local machine for "/
> SynergyDale" pointing to the "/nascar/" directory.
>
> Then use "SynergyDale.cfc" as your cfc object reference.
>
> You can also do the reverse on the remote server if you wish.
>
> HTH,
>
> Jon
>
> On Jan 9, 2007, at 1:39 PM, Bruce Sorge wrote:
>
> > I have a site on my laptop under Nascar. The CFC directory is
> > Nascar.cfc. On
> > the live server though the root directory is SynergyDale. So of
> > course my
> > CFC's cannot be found. Do I need to change the directory name on my
> > laptop
> > to SynergyDale or is there a way for me to keep my directory the
> > same name
> > and still reference the CFC. I am going to guess that I have to
> > change my
> > local directory since the CFC is referenced as NASCAR.CFC.Queries?
> >
> > --
> > Bruce Sorge
> >
> >
> >
>
> 

~|
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:266073
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFC Question

2007-01-09 Thread Dan Vega

Straight from livedocs
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/buildi12.htm
Specifying the CFC location

When you instantiate or invoke a component, you can specify the component
name only, or you can specify a *qualified* path. To specify a qualified
path, separate the directory names with periods, not slashes; for example,
myApp.cfcs.myComponent specifies the component defined in
myApp\cfcs\myComponent.cfc.

ColdFusion uses the following rules to find the specified CFC.

- If you use a
cfinvokeor

cfobjecttag,
or the

CreateObjectfunction
to access the CFC from a CFML page, ColdFusion searches directories
in the following order:
1. Local directory of the calling CFML page
2. Directories specified on the ColdFusion Mappings page of the
ColdFusion MX Administrator
3. Web root
4. Directories specified on Custom Tag Paths page of the
Administrator

If you specify only a component name, ColdFusion searches each of
these directories, in turn, for the component.

*Note: *If you use only the component name to specify the CFC,
ColdFusion does not search the directories specified in the Administrator on
the ColdFusion Mappings page. If you specify a qualified path that starts
with a mapped directory name, ColdFusion does find the component.

If you specify a qualified path, such as myApp.cfcs.myComponent,
ColdFusion looks for a directory matching the first element of the path in
each of these directories (in this example, myApp). If it finds a matching
directory, it then looks for a file in the specified path beneath that
directory, such as myApp\cfcs\myComponent.cfc relative to each of these
directories.

*Note: *If ColdFusion finds a directory that matches the first path
element, but does not find a CFC under that directory, ColdFusion returns a
not found error and does *not* search for another directory.
- If you invoke a CFC method remotely, using a specific URL, form
field, Flash Remoting MX, or a web service invocation, ColdFusion looks in
the specified path relative to the web root. For form fields and URLs
specified directly on local web pages, ColdFusion also searches relative to
the page directory.

*Note: *On UNIX and Linux systems, ColdFusion MX attempts to match a CFC
name or Custom tag name with a filename as follows: First, it attempts to
find a file with the name that is all lowercase. If it fails, it then tries
to find a file whose case matches the CFML case. For example, if you specify
, ColdFusion first looks
for mycomponent.cfc and, if it doesn't find it, ColdFusion looks for
myComponent.cfc.

--
Thank You
Dan Vega
[EMAIL PROTECTED]
http://www.danvega.org

~|
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:266072
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFC Question

2007-01-09 Thread Jon Clausen

Bruce,

Create a mapping in the CF Admin on your local machine for "/ 
SynergyDale" pointing to the "/nascar/" directory.

Then use "SynergyDale.cfc" as your cfc object reference.

You can also do the reverse on the remote server if you wish.

HTH,

Jon

On Jan 9, 2007, at 1:39 PM, Bruce Sorge wrote:

> I have a site on my laptop under Nascar. The CFC directory is  
> Nascar.cfc. On
> the live server though the root directory is SynergyDale. So of  
> course my
> CFC's cannot be found. Do I need to change the directory name on my  
> laptop
> to SynergyDale or is there a way for me to keep my directory the  
> same name
> and still reference the CFC. I am going to guess that I have to  
> change my
> local directory since the CFC is referenced as NASCAR.CFC.Queries?
>
> -- 
> Bruce Sorge
>
>
> 

~|
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:266071
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFC Question

Nope. Cannot add mappings.

On 1/9/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Can you add mappings?
>
>
>
> "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: Bruce Sorge
> To: CF-Talk
> Sent: Tue Jan 09 18:39:16 2007
> Subject: CFC Question
>
> I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc.
> On
> the live server though the root directory is SynergyDale. So of course my
> CFC's cannot be found. Do I need to change the directory name on my laptop
> to SynergyDale or is there a way for me to keep my directory the same name
> and still reference the CFC. I am going to guess that I have to change my
> local directory since the CFC is referenced as NASCAR.CFC.Queries?
>
> --
>
> Bruce Sorge
>
>
>
>
> 

~|
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:266070
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFC Question

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

Can you add mappings?



"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: Bruce Sorge
To: CF-Talk
Sent: Tue Jan 09 18:39:16 2007
Subject: CFC Question

I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On
the live server though the root directory is SynergyDale. So of course my
CFC's cannot be found. Do I need to change the directory name on my laptop
to SynergyDale or is there a way for me to keep my directory the same name
and still reference the CFC. I am going to guess that I have to change my
local directory since the CFC is referenced as NASCAR.CFC.Queries?

-- 

Bruce Sorge




~|
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:266069
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFC Question

I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On
the live server though the root directory is SynergyDale. So of course my
CFC's cannot be found. Do I need to change the directory name on my laptop
to SynergyDale or is there a way for me to keep my directory the same name
and still reference the CFC. I am going to guess that I have to change my
local directory since the CFC is referenced as NASCAR.CFC.Queries?

-- 
Bruce Sorge


~|
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:266068
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: UPS Scripts

>I believe I have used this version for 6.1 and it works.  If you are
>interested how would you like me to send it to you?
>
>Steve LaBadie, Web Manager
>East Stroudsburg University
>200 Prospect St.
>East Stroudsburg, Pa 18301
>570-422-3999
>[EMAIL PROTECTED]
>http://www.esu.edu
>
>-Original Message-
>From: Chris Musial [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, January 09, 2007 12:05 PM
>To: CF-Talk
>Subject: Re: UPS Scripts
>
>>How old of a version are you looking for?  I have ups script for
>version
>
>
>
>Coldfusion 6.1



Thanks.  i appreciate it...you can email it to me: [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:266067
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Getting changed fields from database using an audit table

In a SQL query without the dynamic column list, is this what you are
trying to achieve?

SELECT  u.id
FROMusers u
INNER JOIN  users_updated up
ON  u.id = up.id AND up.lastupdated >= 
WHERE   u.id IN (
SELECT  id
FROMUSER_UPDATE up1
WHERE   
u.cola <> up1.cola OR
u.colb <> up1.colb OR
u.colc <> up1.colc OR
etc <> etc
)

Rich Kroll


~|
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:266066
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Remove datefield calendar icon

2007-01-09 Thread Jacob Munson

I'm making a flash form that contains an input field of type datefield,
which puts in that cool little flash calendar date selector.  The problem is
that I've got limited space in the form, and I would like to remove that
little calendar icon that shows up by the date.  Is this possible?  I've
googled and searched the archives with no success.

-- 
My Sites:
http://www.techfeed.net/blog/
http://www.cfquickdocs.com/
http://cfformprotect.riaforge.org/


~|
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:266065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: UPS Scripts

2007-01-09 Thread Steve LaBadie

I believe I have used this version for 6.1 and it works.  If you are
interested how would you like me to send it to you?

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Chris Musial [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 09, 2007 12:05 PM
To: CF-Talk
Subject: Re: UPS Scripts

>How old of a version are you looking for?  I have ups script for
version
>4 or 5
>
>Steve LaBadie, Web Manager
>East Stroudsburg University
>200 Prospect St.
>East Stroudsburg, Pa 18301
>570-422-3999
>[EMAIL PROTECTED]
>http://www.esu.edu
>-Original Message-
>From: Chris Musial [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, January 09, 2007 10:49 AM
>To: CF-Talk
>Subject: Re: UPS Scripts
>
>shipping
>
>
>where CF 7 isnt required...



Coldfusion 6.1



~|
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:266064
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: UPS Scripts

>How old of a version are you looking for?  I have ups script for version
>4 or 5
>
>Steve LaBadie, Web Manager
>East Stroudsburg University
>200 Prospect St.
>East Stroudsburg, Pa 18301
>570-422-3999
>[EMAIL PROTECTED]
>http://www.esu.edu
>-Original Message-
>From: Chris Musial [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, January 09, 2007 10:49 AM
>To: CF-Talk
>Subject: Re: UPS Scripts
>
>shipping
>
>
>where CF 7 isnt required...



Coldfusion 6.1

~|
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:266063
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 Server Error 8179: Could not find prepared statement with handle x

2007-01-09 Thread George Abraham

Thanks,
George

On 1/9/07, Richard Kroll <[EMAIL PROTECTED]> wrote:
>
> The drivers we used are located at http://jtds.sourceforge.net/
>
> Rich Kroll
>
>

~|
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:266062
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Getting changed fields from database using an audit table

Sorry if I was unclear: I'm not doing any single row queries...here's
the code which may make it clearer.
 
It's a bit "out of context", since this is part of a CFC which is being
called as a web service. I'm making it procedural for simplicity:

The queries (no performance issues here - they execute quite fast
enough):



select * from user_update
  






select #collist.columnlist# from USERS
where lastupdated >= 
order by userid 



  

select * from USERS_UPDATE
where userid IN (select userid from users
where lastupdated >= )




Now, the loops to generate what I need. I am doing this entirely in
cfscript, again for performance:


var since = arguments.sincedate;
var counter = 1;
getData(since); // calls the above queries  
// Loop over each record
for(x=1;x LTE variables.userRecords.recordCount;x=x+1) {
// Loop through each column
for (i=1;i LTE ArrayLen(variables.columns);i=i+1){
 if(variables.updatedRecords[variables.columns[i]][x]
gte createodbcdate(since)) {
counter = counter + 1; //just a counter - even
with this as the only output, it's WAY too slow.
 }  
}
}


> -Original Message-
> From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 12:10 PM
> To: CF-Talk
> Subject: RE: Getting changed fields from database using an audit table
> 
> Try joining the two user tables rather than doing tons of single-row
> queries on the updated table.  Unfortunately you will have to alias
all
> of the columns from one of the tables to get unique column names.
(You
> might do a single query of the users table that returns zero records
> just to get the column names... Then you could build the aliasing SQL
in
> code and then just execute it.)
> 
>   Mark


~|
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:266061
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: UPS Scripts

2007-01-09 Thread Steve LaBadie

How old of a version are you looking for?  I have ups script for version
4 or 5

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
From: Chris Musial [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 09, 2007 10:49 AM
To: CF-Talk
Subject: Re: UPS Scripts

>http://cfups.riaforge.org/
>
>On 1/9/07, Chris Musial <[EMAIL PROTECTED]> wrote:
>>
>> does anyone know of some good tags out there to get real time UPS
shipping
>> rates?  The tag i am currently using doesnt seem to be working well.
>>
>>


where CF 7 isnt required...



~|
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:266060
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: downloading a WSDL

2007-01-09 Thread Russ Michaels

nevermind, I sorted it :-)

~|
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:266059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Getting changed fields from database using an audit table

2007-01-09 Thread Gaulin, Mark

Try joining the two user tables rather than doing tons of single-row
queries on the updated table.  Unfortunately you will have to alias all
of the columns from one of the tables to get unique column names.  (You
might do a single query of the users table that returns zero records
just to get the column names... Then you could build the aliasing SQL in
code and then just execute it.)

Mark

-Original Message-
From: Doug Bezona [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 09, 2007 11:50 AM
To: CF-Talk
Subject: Getting changed fields from database using an audit table

Hi folks,
The environment is SQL Server 2000 and CFMX 7.0.1

Here's the scenario. I have two tables. One is the primary table of data
(let's call it USERS), the other is a table (say, USERS_UPDATED) with
identical columns that stores a date in each column representing the
last updated date of the corresponding column in the Users table.

The USERS table also has a single "lastupdated" field.

I am looking for the most efficient way to extract all changed fields
from USERS from a given date, using the date values in USERS_UPDATED.

Now, the issue isn't getting the information - I have working code to do
this. The issue is performance with large resultsets. 

Currently, I am 

1. selecting the records from USERS with lastupdated >= (some date) 2.
selecting the corresponding records from USERS_UPDATED 3. Looping over
the result of the USERS query 4. within the USERS loop, looping over the
list of columns, and comparing the date in USERS_UPDATED with (some
date) to build the output result.

Works fine until there are a lot of changed records in the USERS table
for the provided date. 

A couple of real numbers: 

USERS has 89 columns.
There are ~12000 updated records.

This means my current code does 12000*89 loop iterations or 1068000
total iterations. It's WAY too slow for our needs.

There has to be a better approach, but I am coming up blank. Anyone have
any ideas? 





~|
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:266058
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: UPS Scripts

>http://cfups.riaforge.org/
>
>On 1/9/07, Chris Musial <[EMAIL PROTECTED]> wrote:
>>
>> does anyone know of some good tags out there to get real time UPS shipping
>> rates?  The tag i am currently using doesnt seem to be working well.
>>
>>

where CF 7 isnt required...

~|
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:266057
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: UPS Scripts

2007-01-09 Thread Dan Vega

http://cfups.riaforge.org/

On 1/9/07, Chris Musial <[EMAIL PROTECTED]> wrote:
>
> does anyone know of some good tags out there to get real time UPS shipping
> rates?  The tag i am currently using doesnt seem to be working well.
>
> 

~|
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:266056
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

UPS Scripts

does anyone know of some good tags out there to get real time UPS shipping 
rates?  The tag i am currently using doesnt seem to be working well.  

~|
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:266055
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Getting changed fields from database using an audit table

Hi folks,
The environment is SQL Server 2000 and CFMX 7.0.1

Here's the scenario. I have two tables. One is the primary table of data
(let's call it USERS), the other is a table (say, USERS_UPDATED) with
identical columns that stores a date in each column representing the
last updated date of the corresponding column in the Users table.

The USERS table also has a single "lastupdated" field.

I am looking for the most efficient way to extract all changed fields
from USERS from a given date, using the date values in USERS_UPDATED.

Now, the issue isn't getting the information - I have working code to do
this. The issue is performance with large resultsets.

Currently, I am

1. selecting the records from USERS with lastupdated >= (some date)
2. selecting the corresponding records from USERS_UPDATED
3. Looping over the result of the USERS query
4. within the USERS loop, looping over the list of columns, and
comparing the date in USERS_UPDATED with (some date) to build the output
result.

Works fine until there are a lot of changed records in the USERS table
for the provided date.

A couple of real numbers:

USERS has 89 columns.
There are ~12000 updated records.

This means my current code does 12000*89 loop iterations or 1068000
total iterations. It's WAY too slow for our needs.

There has to be a better approach, but I am coming up blank. Anyone have
any ideas?

~|
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:266054
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

downloading a WSDL

2007-01-09 Thread Russ Michaels

I have a .net web service that I believe has an invalid WSDL.
I have been previously told (by Dave Watts) that you can download a WSDL 
locally and create a web service form that.
This seems like the solution for me to fix and test the WSDL, but how exactly 
does one do this.
Just saving the WSDL file and pointing to that doesn't work.

Russ

~|
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:266053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

App Organizational Question...

2007-01-09 Thread Rick Faircloth

Hi, all.

Would it be better to identify users of a common app by
CGI.HTTP_HOST and put in my Application.cfm (yes, .cfm. CF 4.5 here)
lines such as:



 



or

Should I automate the process of DSN identification by
using a MID function to select the domain name from the
CGI.HTTP_HOST variable.

(Pseudo code, because I can't remember right off how to 
select the string to the left of the last "." in the domain name).  :o/  )

http://bodafordhomes.com)>

With this second approach, I don't have to modify the .cfm every time I add
a new client to use the app.

The first approach requires a new  statement based on the domain name
and DSN that I set up.

Which way would be preferable?  Pitfalls to each?  Perhaps a better approach
than
either of these two?

(It's too bad CF 8 isn't out now so I could make this major shift in how I
develop apps
along with learning to employ CF8. but alas, I have to strike while the
iron's hot.)

Thanks,

Rick



~|
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:266052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Jordan Michaels

Hi Mark,

Thank you for the additional information there. I really appreciate it.
Are you aware of anyone who currently runs MS SQL in case sensitive
mode? I'd be curious to know how often that happens.

Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Blue Dragon Alliance Member
[EMAIL PROTECTED]


Mark A Kruger wrote:
> Jordan,
> 
> One note - MS SQL is not "case insensitive". In it's default collation it is
> case insensitive - but it can be either case sensitive  OR case insensitive
> depending on install options and collations.
> 
> -mark
>  
> 
> -Original Message-
> From: Jordan Michaels [mailto:[EMAIL PROTECTED] 
> Sent: Monday, January 08, 2007 6:10 PM
> To: CF-Talk
> Subject: Re: PostgreSQL vs. MSSQL
> 
> MS SQL is a fine database, and will get the job done. However, why pay for a
> database like that when you can get essentially the same thing for free?
> 
> I've got nothing but positive things to say about PostgreSQL, and I'd be
> very interested to hear what your friend has against it. In my experience,
> usually these kinds of opinions are derived from a lack of understanding
> about how something operates. With PostgreSQL, there are two items that
> generally end up as road blocks for most MS SQL users who try it out.
> 
> 1) User permissions: PostgreSQL is not forgiving as far as user/access
> permissions go. This is both good (for security purposes) and bad (because
> it can be frustrating to learn). However, like most things, once you
> understand how it's permission system works, it's not that difficult - it's
> just different.
> 
> 2) Case sensitivity: Unlike MS SQL, PostgreSQL is a case sensitive database.
> This can be the deciding factor when choosing to port an application from MS
> SQL to PostgreSQL. If you have a database called "User" in PostgreSQL, your
> queries will need to have that database name in quotes. Here's an example:
> 
> Database: User
> Field Names: ID, UserName, Password
> 
> MS SQL Query:
>  SELECT id, username, password
> FROM user 
> 
> PostgreSQL Query:
>  SELECT "ID", "UserName",
> "Password"
> FROM "User"
> 
> 
> In our shop we user lowercase names for everything in our databases, so I
> haven't had to do that for a long time when working with PostgreSQL.
> As such, I cannot remember if it was single quotes, or double-quotes that I
> had to use when dealing with names that had uppercase values in them. Still,
> you get the idea.
> 
> With the exception of those two items, PostgreSQL is wonderful. The price is
> great, the performance is great, and the community support is great. I would
> highly recommend PostgreSQL to *anyone* looking for a high-performance, low
> cost alternative to MS SQL.
> 
> Hope this helps!
> 
> Warm regards,
> Jordan Michaels
> Vivio Technologies
> http://www.viviotech.net/
> Blue Dragon Alliance Member
> [EMAIL PROTECTED]
> 
> 
> Matt Quackenbush wrote:
> 
>>Hello,
>>
>>I've always used MSSQL and quite frankly am quite fond of it - except 
>>for licensing costs.  I've read a few posts here and there where 
>>people have talked highly of PostgreSQL, so I'm thinking about giving 
>>it a shot on a new server (windows box).  I mentioned this to a buddy 
>>of mine who is a DBA, and he said to steer well clear of it.  While I 
>>value his opinion greatly, I was wondering if the users here would 
>>care to share their personal + vs. - arguments for PostgreSQL?
>>
>>
>>Thanks,
>>
>>Matt
>>
>>
>>
> 
> 
> 
> 
> 

~|
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:266051
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Werid error...

> If you submit a blank value, you get this error:
> 
> Invalid data for CFSQLTYPE CF_SQL_DOUBLE.

An empty value is not a number. Use the NULL attribute as Richard suggested,
if your database column accepts nulls.

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:266050
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: retrieve db into variables

2007-01-09 Thread Scott Weikert

Daniel Kessler wrote:
> I don't want do rewrite my variable scoping for this app, but I'll  
> consider having everything in Variables for the future as I write  
> this up as a general include.
>   
You wouldn't have to - his point is, every var called "variablename" is 
also referenceable as "variables[variablename]" and vice versa. So you 
could just rig your db-to-variables code to work like the example given, 
and still reference your variables straight up later on.

~|
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:266049
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: PostgreSQL vs. MSSQL

2007-01-09 Thread Andy Matthews

Coalesce is a WAY cooler name. Those guys at MS must have been smoking
crack! 



 
Andy Matthews
Senior Coldfusion Developer
 
Office:  877.707.5467 x747
Direct:  615.627.9747
Fax:  615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com
 

-Original Message-
From: Jacob Munson [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 08, 2007 7:41 PM
To: CF-Talk
Subject: Re: PostgreSQL vs. MSSQL

>
> > - non-standard sql
>
> Indeed. This is true in some rare cases (like case sensitivity) 
> however, it seems all databases take some liberties in regards to this.


I agree, I think every database has some non-standard SQL.  An example in MS
SQL is the isNull() function, which is functionally equivalent to the ANSI
standard coalesce().  Why did MS make their own?  Who knows, maybe because
they liked their name better?

Back to your regularly scheduled programming.  :)

--
My Sites:
http://www.techfeed.net/blog/
http://www.cfquickdocs.com/
http://cfformprotect.riaforge.org/




~|
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:266048
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Werid error...

Have you tried using the NULL attribute of CFQUERYPARAM?  I've done
something like NULL="#NOT
YesNoFormat(LEN(ARGUMENTS.prodconsignmentprice))#" to handle this type
of thing.

Rich Kroll


> -Original Message-
> From: Will Tomlinson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 8:28 AM
> To: CF-Talk
> Subject: Werid  error...
> 
> I've seen this before but just worked around it with a  in the
SQL.
> 
> SQL Server, smallmoney data type for this field.
> 
> Here's the SQL:
> 
> prodconsignmentprice =  value="#ARGUMENTS.prodconsignmentprice#">
> 
> If you submit a blank value, you get this error:
> 
> Invalid data for CFSQLTYPE CF_SQL_DOUBLE.
> 
> Umm ok... I'm not using any s with double. Just money.
It
> works fine, unless you submit an empty value. I usually just wrap it
with
> a .
> 
> Am I doing somethin wrong though?
> 
> Thanks,
> 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:266047
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 Server Error 8179: Could not find prepared statement with handle x

The drivers we used are located at http://jtds.sourceforge.net/

Rich Kroll


> -Original Message-
> From: George Abraham [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 10:02 AM
> To: CF-Talk
> Subject: Re: SQL Server Error 8179: Could not find prepared statement
with
> handle x
> 
> Hmm, we did have other problems with the current drivers we are using
that
> was shipped with the product by (then) Macromedia. Mayve we can look
at
> this
> driver you mention.
> 
> Thanks,
> George
> 


~|
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:266046
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Needed: opinions on use of reserved words

2007-01-09 Thread Kris Jones

I'm pretty sure you can use the brackets around the column name in
queries from Access tables also. Not so sure how far this fix would go
though--updates to the tables, etc.?

If it were me, I'd require them to rework to avoid the reserved words.
That's just plain bad practice.

> It would not be hard to grep or wingrep which template or queries use the
> wrong columns names and replace them with just a slight variation.  SQL
> Server does this nicely by putting square brackets around reserved word
> columns.  I am not sure that is Access compatible.  e.i. [year]

~|
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:266045
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 Server Error 8179: Could not find prepared statement with handle x

2007-01-09 Thread George Abraham

Hmm, we did have other problems with the current drivers we are using that
was shipped with the product by (then) Macromedia. Mayve we can look at this
driver you mention.

Thanks,
George

On 1/9/07, Richard Kroll <[EMAIL PROTECTED]> wrote:
>
> George,
> We ran into the same problem a few months ago.  What we found was the
> error was thrown on random queries that had CFQUERYPARAMs in them (which
> was almost every query in our application).  Somewhere on the net I
> found an article explaining that it had something to do with the
> drivers.  We switched our drivers to the jTDS JTDS drivers for MS SQL 2k
> and the problem went away.
>
> HTH
>
> Rich Kroll
>
> > -Original Message-
> > From: George Abraham [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, January 09, 2007 8:38 AM
> > To: CF-Talk
> > Subject: SQL Server Error 8179: Could not find prepared statement with
> > handle x
> >
> > Hi all,
> > One of our CFMX 7 applications (which was working fine before)
> suddenly
> > started throwing this error - SQL Server Error 8179: Could not find
> > prepared
> > statement with handle x. The funny part is, it throws the error at
> pretty
> > much any point in the application without any apparent reason in the
> > sequence of code. If I comment out that code, then the some other
> query
> > code
> > will malfunction the same way with a different value for x. I looked
> > around
> > for solutions, but could not get any usable ones. One thing that
> worked
> > for
> > us is to increase the maximum number of pooled statements by 1 in the
> > datasource and then the problem went away. However it would be nice to
> > know
> > why the heck it happened in the first place.
> >
> > Thanks,
> > George
> >
> >
> >
>
> 

~|
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:266044
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: FarCry and TinyMCE issue

2007-01-09 Thread Jon Clausen

Adrian,

Sorry,  I didn't get a chance to dig around the FarCry admin  
yesterday.  My "mission" for the day took me longer than I expected. :-)

I'll see if I can't help out today.

Jon

On Jan 9, 2007, at 2:01 AM, Adrian Wagner wrote:

> Just to keep you in the loop. We were actually using TinyMCE 2.0.6.  
> and
> I had a look at the 2.0.8 version of it. This version has been adapted
> to IE7 requirements (it's now sniffing for IE7 as well in the JS).
> However, it still loses the position when a link is inserted from the
> FarCry tree.
>
> and going back to it
>
> Adrian
>
 [EMAIL PROTECTED] 8/01/2007 3:14:12 pm >>>
>
> Adrian,
>
> I'll see if I can take a look at it tomorrow a bit more.  In the
> meantime,I dug through the javascript in the admin for a sec and
> there are two places, I would start to look;
>
> In /farcry_core/admin/includes/lib/tinymce/jscripts/tiny_mce/
> tiny_mce.jsthere is a whole lot of browser sniffing going on.  If
>
> your clients are using IE7, you may be able to redefine
> "this.isMSIE"  to get it to work since any unknown version is served
> the IE 5  stuff.
>
> The function "insertHTML( html )"  is delivered inline from  /
> farcry_core/admin/edittabedit.cfm.  It's the one that sends the
> commands to the TinyMCE  js functions on inserting HTML.  You may be
> able to dial down to the problem though the function calls in there.
>
> Regards,
> Jon
>
>
> On Jan 7, 2007, at 9:56 PM, Adrian Wagner wrote:
>
>> Jon,
>>
>> FarCry 3.01, TinyMCE 2.0.8.
>>
>> I just got an answer on the FarCry list - he has the same issue and
>> claims it's an IE JS bug - which my test seem to confirm. In
>> Firefox the
>> cursor position within TinyMCE is remembered, in IE 7 and 6 the
>> position
>> is not remembered. Argh..looks like I'll have to jump into the JS.
> Or
>> just tell them to use Firefox. ;)
>>
>> But, still any help would be appreciated - am not excactely the
>> biggest
>> JS guru.
>>
>> Adrian
>>
>>
> [EMAIL PROTECTED] 8/01/2007 11:43:55 am >>>
>>
>> Adrian,
>>
>> I just did a test on one of my live sites running FarCry v3.1 and
> one
>>
>> on my dev box running a beta of v4  with no problems.   The cursor
>> position seems to be remebered as long as you don't click on
> anything
>>
>> else between the textarea and right-clicking the site tree object.
>>
>>   Which version of TinyMCE and FarCry is this site on?
>>
>> Jon
>>
>>
>> On Jan 7, 2007, at 9:11 PM, Adrian Wagner wrote:
>>
>>> After trying the FarCry and the TinyMCE communities - without
>>> success, I
>>> now got to plead to the CF people. It might be a bit obscure though
>> -
>>> but who knows, maybe someone here does work with TinyMCE in FarCry
>> 3.
>>>
>>> We've implemented TinyMCE in our FarCry 3 CMS. Implementation and
>>> settings all work without a problem so far. There is one matter
>>> however,
>>> that derails some of our contributors.The FarCry Admin is built
> with
>>> frames. When editing the body of a document (with TinyMCE in the
>>> 'main'
>>> frame) the user can right-click a particular page in the navigation
>>
>>> tree
>>> ('navigation' frame) and choose 'insert' - which will add the link
>> to
>>> that page to the document body (TinyMCE). It basically works all
> ok,
>>> however when doing this the current cursor position within TinyMCE
>> is
>>> not being remembered and the link is simply added at the top of the
>>> page. This causes CSS class issues, which are a bit difficult to
>> deal
>>> with for the rather html/css-illiterate contributors.How can I
>> easily
>>> make TinyMCE 'remember' the cursor position when leaving the frame
>> so
>>> that the link will be inserted there? Has anyone come up with a
>>> solution
>>> to this? Is even anybody out there who works with the FarCry 3 /
>>> TinyMCE
>>> combination?Thanks for your help.
>>>
>>> Adrian Wagner
>>> Web Analyst Programmer
>>> Curtin Business School
>>> d: +61 (0) 8 9266 4220
>>> m: +61 (0) 40 110 3252
>>> e: [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:266043
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Jacob Munson

>
> SQL Server also supports COALESCE. And, while the two are very similar,
> they
> aren't identical in functionality. A Google search on "coalesce vs isnull"
> turns up all sorts of mildly interesting stuff.


You're right on both counts, Dave.  My main point was that MS even bothered
to make a non-standard function.  IIRC, Coalesce does more than isNull, but
the basic thing that most people use isNull() for is this:
isNull(mname,'blank') so you don't have nulls in your return values, and
this works the same as coalesce.  However, I can't justly bash MS for this,
because Oracle, MySQL and DB2 have proprietary functions for this as well.
I just wanted to point out that all the popular DB platforms have
non-standard SQL to some degree.

-- 
My Sites:
http://www.techfeed.net/blog/
http://www.cfquickdocs.com/
http://cfformprotect.riaforge.org/


~|
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:266042
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Jon Clausen

On Jan 9, 2007, at 3:23 AM, Matt Quackenbush wrote:

> Thanks for the reply.  Do you currently run MySQL and/or PostgreSQL on
> Windows boxes?  If so, what version(s) for both the db server and  
> windows
> servers?

Both.  8.2 for Postgres and 5.1 for MySQL.XP Pro and Server 2003  
for the OS.

> Also, just to clarify on the case-sensitivity point you made, am I  
> correctly
> understanding that the following query **typically**
> would not have any
> issues?
>
> 
> SELECT my_field
>FROM my_table;
> 
>
> Even if the field was named as 'my_Field' (minus the quotes) in the
> database?

Actually, the other way around.  When you convert your tables over to  
Postgres, you'll have to lowercase them.  Once again, though if you  
don't quote the table names in the script, Pg will automatically take  
care of lower casing that for you when you run the Create's.

Then any queries you have with mixed case names for the table  
attributes will still run.

If you uppercase any of the table/column names,  you will have to  
quote them.

HTH,

Jon

~|
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:266041
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Werid error...

2007-01-09 Thread Will Tomlinson

I've seen this before but just worked around it with a  in the SQL. 

SQL Server, smallmoney data type for this field. 

Here's the SQL: 

prodconsignmentprice = 

If you submit a blank value, you get this error:

Invalid data for CFSQLTYPE CF_SQL_DOUBLE. 

Umm ok... I'm not using any s with double. Just money. It works 
fine, unless you submit an empty value. I usually just wrap it with a . 

Am I doing somethin wrong though?

Thanks,
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:266040
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 Server Error 8179: Could not find prepared statement with handle x

George, 
We ran into the same problem a few months ago.  What we found was the
error was thrown on random queries that had CFQUERYPARAMs in them (which
was almost every query in our application).  Somewhere on the net I
found an article explaining that it had something to do with the
drivers.  We switched our drivers to the jTDS JTDS drivers for MS SQL 2k
and the problem went away.

HTH

Rich Kroll

> -Original Message-
> From: George Abraham [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 8:38 AM
> To: CF-Talk
> Subject: SQL Server Error 8179: Could not find prepared statement with
> handle x
> 
> Hi all,
> One of our CFMX 7 applications (which was working fine before)
suddenly
> started throwing this error - SQL Server Error 8179: Could not find
> prepared
> statement with handle x. The funny part is, it throws the error at
pretty
> much any point in the application without any apparent reason in the
> sequence of code. If I comment out that code, then the some other
query
> code
> will malfunction the same way with a different value for x. I looked
> around
> for solutions, but could not get any usable ones. One thing that
worked
> for
> us is to increase the maximum number of pooled statements by 1 in the
> datasource and then the problem went away. However it would be nice to
> know
> why the heck it happened in the first place.
> 
> Thanks,
> George
> 
> 
> 

~|
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:266039
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

SQL Server Error 8179: Could not find prepared statement with handle x

2007-01-09 Thread George Abraham

Hi all,
One of our CFMX 7 applications (which was working fine before) suddenly
started throwing this error - SQL Server Error 8179: Could not find prepared
statement with handle x. The funny part is, it throws the error at pretty
much any point in the application without any apparent reason in the
sequence of code. If I comment out that code, then the some other query code
will malfunction the same way with a different value for x. I looked around
for solutions, but could not get any usable ones. One thing that worked for
us is to increase the maximum number of pooled statements by 1 in the
datasource and then the problem went away. However it would be nice to know
why the heck it happened in the first place.

Thanks,
George


~|
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:266038
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: PostgreSQL vs. MSSQL

> I agree, I think every database has some non-standard SQL.  
> An example in MS SQL is the isNull() function, which is 
> functionally equivalent to the ANSI standard coalesce().  Why 
> did MS make their own?  Who knows, maybe because they liked 
> their name better?

SQL Server also supports COALESCE. And, while the two are very similar, they
aren't identical in functionality. A Google search on "coalesce vs isnull"
turns up all sorts of mildly interesting stuff.

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:266037
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Getting SQL Server onto XP Pro machine

> Of the four versions of SQL Server 2000 that are available, 
> only the personal version of SQL Server 2000 can be installed 
> on aWinXP machine. All other versions must be installed on a 
> Windows server system (Win2K, Win2K3, SBS, etc.)

No, you can also install SQL Server 2000 Developer on Windows XP. And, if
you're developing for SQL Server 2000 Standard or Enterprise, that's the
version you should use, as it's a closer match to those versions than is the
Personal version.

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:266036
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

retrieve db into variables

2007-01-09 Thread Daniel Kessler

Alright!  This works fine thanks.
I don't want do rewrite my variable scoping for this app, but I'll  
consider having everything in Variables for the future as I write  
this up as a general include.

> It may be helpful to know/recall that all local variables live in a  
> scope structure called Variables.
>  So you can just use that instead of the structure you create  
> yourself:
> 
>
> This should also be faster, because of the explicit scoping.
>
> The syntax mentioned in the other replies works just fine, though:
> 


-- 

Daniel Kessler

College of Health and Human Performance
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
Phone: 301-405-2545
http://hhp.umd.edu




~|
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:266035
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Paul Hastings

Jochem van Dieten wrote:
>> wondering if the users here would care to share their personal + vs. -
>> arguments for PostgreSQL?
> 
> + rich SQL support
> + easy to install / configure
> + portable
> + low resource usage
> + excellent documentation
> + great community support
> + many options for commercial support
> + liberal license
> + understandable source code

you forgot postGIS :-)

~|
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:266034
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Cfqueryparam on ALL values or just user definable ones?

Andy Matthews wrote:
>  
> A query has an incoming value which is the result of a previous query:
>  
> WHERE id = #Val(getsite.id)#
>  
> Should something like this be using a cfqueryparam or is it okay to leave as
> is?

What happens if getsite does not return any rows? If you have that covered and 
getsite.id is a numeric type in the database, it is technically OK to leave it 
in.

Performance is another issue. In general, if you want the DB to be able to 
reuse an execution plan, convert this to a cfqueryparam. If you don't want the 
database to reuse the execution plan, don't convert it. But without knowing a 
lot more about the schema and the usage pattern it is a bit hard to say whether 
execution plan reuse would be a win for you.

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:266033
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Cfqueryparam on ALL values or just user definable ones?

Russ wrote:
> In my experience, it only slowed things down.  Now, YMMV, but I've noticed
> that the more cfqueryparams you have in your query, the slower it will run.

What did you test? How did you test it? How many simultaneous users?


> Although theoretically the sql engine should have an easier time caching an
> execution plan for your query, the only reason I have found to use
> cfqueryparams is for security. And even then, I have not seen a way to
> create sql injection attacks with CF, unless you're doing something stupid,
> like preserveSingleQuotes().  

I have seen plenty.

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:266032
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: PostgreSQL vs. MSSQL

Matt Quackenbush wrote:
> I've always used MSSQL and quite frankly am quite fond of it - except for
> licensing costs.  I've read a few posts here and there where people have
> talked highly of PostgreSQL, so I'm thinking about giving it a shot on a new
> server (windows box).  I mentioned this to a buddy of mine who is a DBA, and
> he said to steer well clear of it.  While I value his opinion greatly, I was
> wondering if the users here would care to share their personal + vs. -
> arguments for PostgreSQL?

+ rich SQL support
+ easy to install / configure
+ portable
+ low resource usage
+ excellent documentation
+ great community support
+ many options for commercial support
+ liberal license
+ understandable source code

The only thing I miss in PostgreSQL is eager update-everywhere replication. 
There are commercial offerings for that, but all the community offerings are 
either lazy or master-slave.

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:266031
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: A question about CFCFactory objects as a singleton ....

2007-01-09 Thread Kevan Stannard

Hi Mike

I would take the approach of passing the user object in as part of your DAO
save (or create and update) method.

Just as you only need a singleton factory, you also only need singleton
DAOs.

Best regards

Kevan Stannard

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 9 January 2007 5:24 AM
To: CF-Talk
Subject: Re: A question about CFCFactory objects as a singleton 

yes as a matter of routine, my tables usually have fields for:

createdby   (the userid of the person who created this record)
datecreated  (timestamp)
updatedby  (The userid of the last person to alter this record)
dateupdated (timestamp)

So the methods in the DAOs that manipulate the records need to be told who's
doing it.  Since DAOs dont know anything about the application, request or
session scopes, they have to be told what they need to know.   In this case
they dont need to know the curent time (thats from the getdate() function in
the database) but they do need to know the userid of the person initiating
this action.My question was about the best way to pass this info in,
since the application doesnt .instantiate the dao directly, but through a
CFCFactory which knows everything it needs to know to instantiate any CFC
required.

When someone logs in, there is a userbean created in their session scope,
containing their name, userid, access rights and lots more depending on what
else happens in this site.

So the question is about this .if there is only one CFCFactory created
as a singleton in the Application scope, all the users on the site are using
the same instance of the CFC to instantiate whatever CFCS they need.  Each
time, the CFC being created will need to be told who's the user, so it can
update any records it needs to update correctly.   Or perhaps it's better to
pass the userID into each method as it's called rather than into the init
method of the DAO cfc.

The options in my first post were the ones that came to mind as i wrote it,
but there are probably other possibilities

What's brought this to mind now is that i'm working on an app that will have
maybe 150-200 concurrent users, all accessing, creating and updating
records.  In the past i've had plenty of reasonably high traffic sites, but
none with that many users creating and updating records simultaniously.  The
high traffic has all been in the read only category,with the write/update
being one or two people at a time max. Under those low traffic situations it
doesnt really matter to have everyone with their own CFCFactory.   One or
two fo them in RAM isnt a big deal   100-200 of them would definitely have a
performance hit on the site so i can't do that here.

Thats' the background to my question.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

On 1/9/07, Josh Nathanson <[EMAIL PROTECTED]> wrote:
>
> It seems like option [B] would use a lot less memory resources.
>
> A little more detail about how your objects are set up would be helpful to
> get a clearer picture.  Do you have multiple tables which each store which
> user/ when created?  It seems like you could have a userID property in
> each
> of your objects that needs to maintain the user info, then do:
>
> myObject.setUserID(session.userbean.getUserID())
>
> before commiting. Then have timestamp field in the db.
>
>
>

~|
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:266030
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: RDS in CFECLIPSE. What's Wrong?

2007-01-09 Thread Tom Chiverton

On Friday 05 January 2007 15:59, Dwayne Cole wrote:
> Thanks Tom for what ever help you can give.

Right. Try with Eclipse 3.2 and the new Flex 2.0.1 :-)

--
Tom Chiverton
Helping to efficiently administrate six-generation IPOs

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:266029
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: PostgreSQL vs. MSSQL

Matt Quackenbush wrote:
> Thanks for the reply.  I forgot to post his specific gripes about it.  Here
> is a quick summary:
> 
> - non-standard sql

I think that depends on what you call 'standard sql'. To me, standard SQL is 
what is defined in ISO/IEC 9075 and few do better then PostgreSQL in that 
respect. But if you take 'standard sql' to mean 'the SQL in product X', you may 
discover many differences.

> - difficult to backup / migrate

What is difficult about scheduling "pg_dumpall -f dumpfile"?

For migration he may have a point. PostgreSQL will not allow you to shut down 
the database, pack up the data files, put them on another machine and start up 
there. While this technically is possible in some circumstances, it is not a 
documented procedure because it is guaranteed not to work when you move from 
for instance Windows to an AIX mainframe. Other products that only run on 
limited platforms and do not have to worry about memory alignment and the 
endianness of the host operating system do not have this limitation.

> - user authenication is weak

PostgreSQL allows the DBA to use anything from no authentication to Kerberos 
and you can even create single-signon with a Windows domain. User 
authentication is as weak as the DBA configured it to be.

And if we extend this to security in general you might want to Google a bit. 
PostgreSQL is highly regarded for its security track record and is often an 
example to other databases. For instance, while many databases install 
themselves under an account with elevated privileges by default even when that 
is technically not necessary, PostgreSQL refuses to run if it has more 
permissions then it needs.

> - difficult to setup

http://www.suite101.com/article.cfm/oracle/115560

> - difficult to manage

To manage PostgreSQL you need to do a few things that are clearly spelled out 
in the manual:
http://www.postgresql.org/docs/8.2/static/maintenance.html
http://www.postgresql.org/docs/8.2/static/backup.html
Again I would have to ask what is so hard about setting up a scheduled task.

In short: you may want to ask him if he is not confusing PostgreSQL with some 
other database.

> Your post was most informative, for sure.  But there's one thing that you
> mentioned that I was unaware of that is pretty much an instant turn-off for
> me: cAsE sEnSiTiViTy.

PostgreSQL identifiers are only case sensite if you make them case sensitive by 
enclosing them between double quotes. The following code will run just fine:

CREATE TABLE fOo (BaR INTEGER);

SELECT bAr FROM foo;

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:266028
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfqueryparam on ALL values or just user definable ones?

2007-01-09 Thread Adrian

"even then, I have not seen a way to create sql injection attacks with CF"

Russ,
One particularly nasty example I have seen in action is an attack against
mssql db's using EXEC sp_cmdshell.
You can then run any dos command via mssql

I agree with Matt, - its better to err on the side of caution in this
situation.
(just in case you havent anticipated every possible form of attack that
might ever exist!)

On 08/01/07, Matt Robertson <[EMAIL PROTECTED]> wrote:
>
> I am all for reducing attack surfaces.  Even if cfqueryparam's sole
> purpose in life is to enhance security, its worth it.  Never mind the
> speed given under load.  Use it as a cheap way to bulletproof your
> code and minimize your own personal liability in case it turns out the
> hacker is smarter than you thought they would be.  That includes
> inputs like #getsite.ID#  Sure the input *should* come from where you
> think it does... but if some clown moves something into the middle of
> the picture then you have created a hole that someone can toss a
> grenade thru.
>
> --
> [EMAIL PROTECTED]
> Janitor, The Robertson Team
> mysecretbase.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:266027
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cracking the RDS protocol?

2007-01-09 Thread Tom Chiverton

On Monday 08 January 2007 20:42, Anthony Cole wrote:
> I started looking into this matter a little and the protocol is easy to
> crack. I only coded 3 functions, but I found many other operations by
> playing with IIS logs.

Cool.
What would rock would be writing up a list of which methods have been
enginered and how to constuct the URL and parameters for that method.

--
Tom Chiverton
Helping to quickly strategize total functionalities

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

CONFIDENTIALITY

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:266026
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: PostgreSQL vs. MSSQL