RE: any idea how to

[Jaime Metcher]

LOL.  I miss those perl days, when hackers were real hackers and the top
line of the keyboard was nervous.

> -Original Message-
> From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 9 August 2007 12:57 PM
> To: CF-Talk
> Subject: Re: any idea how to
>
>
>  "([\d]{4})([\d]{2})([\d]{2})","\2/\3/\1","ALL")/>
>
> On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> > Convert 20060523
> >
> >
> >
> > Into 5/23/2006
> >
> >
> >
> > I'm at a loss.
> >
> >
> >
> > Thanks in advance
> >
> >
> >
> > sas
> >
> >
> >
> > --
> >
> > Scott Stewart
> >
> > ColdFusion Developer
> >
> >
> >
> > SSTWebworks
> >
> > 4405 Oakshyre Way
> >
> > Raleigh, NC. 27616
> >
> > (703) 220-2835
> >
> >
> >
> > http://www.sstwebworks.com
> >
> >  
> > http://www.linkedin.com/in/sstwebworks
> >
> >
> >
> >
> >
> >
> >
> >
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: any idea how to

[Zaphod Beeblebrox]

On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> Convert 20060523
>
>
>
> Into 5/23/2006
>
>
>
> I'm at a loss.
>
>
>
> Thanks in advance
>
>
>
> sas
>
>
>
> --
>
> Scott Stewart
>
> ColdFusion Developer
>
>
>
> SSTWebworks
>
> 4405 Oakshyre Way
>
> Raleigh, NC. 27616
>
> (703) 220-2835
>
>
>
> http://www.sstwebworks.com
>
>  
> http://www.linkedin.com/in/sstwebworks
>
>
>
>
>
>
>
> 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285788
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 problem getting records within date range

[C. W. B.]

Ah Ha!  I figured out the problem with the query.  This following seems to work 
as expected:

SELECT 
  dbo.tblSubscribers.SID, 
  dbo.tblSubscribers.Username, 
  max(dbo.tblUserTransactionLog.Processed) AS LastTransaction
FROM 
  dbo.tblSubscribers,
  dbo.tblUserTransactionLog
WHERE
  dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID AND
  (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) >= 
\'08/01/2007\')  AND 
  (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) <= \'08/01/2007\')
GROUP BY 
  dbo.tblSubscribers.SID, 
  dbo.tblSubscribers.Username

Thanks to Janet and Josh for their help!

Thanks, - cwb


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: DW8 download?

[Dave Watts]

> I would like to know why they took it off the adobe site.

Because Dreamweaver CS3 is the current version. Adobe is very aggressive
about only providing the latest version, it seems. For example, they
recently removed the Captivate 2 trial in anticipation of the release of
Captivate 3.

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!

This email has been processed by SmoothZap - www.smoothwall.net


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: any idea how to

[Claude Schneegans]

 >>Convert 20060523
Into 5/23/2006

See ConvertDate():
http://www.contentbox.com/claude/customtags/convertDate/viewConvertDate.cfm

It would be:


-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Re: Application-wide SQL Injection prevention?

[Dinner]

On 8/7/07, Paul Vernon wrote:

> I guess I should qualify that and say, use HTMLEditFormat() and
> HTMLCodeFormat() on any *untrusted* user submitted content.

What's this "trust" thing of which you speak? :-)

I was trying to find a catch-all for cfquery cuz I just whent thru this
same deal a few months ago.  Finally got all the public, most the
private (as I refactor, I get it all) paramed- and in comes a bunch
more.

It would be bad enough it was only private facing stuff...

> If you are using an admin area for your users to add content using a WYSIWYG
> then the use of these techniques is out for the WYSIWYG content. However, if
> you are allowing anonymous users to submit content through the front end,
> HTMLEditFormat() and HTMLCodeFormat() will kill all XSS attempts dead!

I aim (but have so much code to maintain- it's insane) for security, even on
the inside.  So this begs the question-  How does one secure incoming HTML
content?  Guess the mainstays there, are: you don't.  You use meta-markup.
And a customized version of FCKEditor.

Eh.  What ever man builds (or woman builds), can be de-built, I reckon.

And yet... with the right regular expression(s) :-P

I wonder, with this server-side JS, perhaps we could have a parser that
would tell us if the content tried to "do" anything.  Hmmm?  Bah.
I'm gonna go play with my kid.

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: cfquery: quotes vs queryparam

[Dinner]

> But what exactly would this tag do, if not create a bound parameter? It
> sounds like what you really want is an off switch.

Or, hey, crazy idea: Format the output so homecheese can read it!

Actually, I bet that's doable, right now, if you mess with stuff, since
I'm pretty sure that all the info he's asking about is available.

But I like his idea of having it built-in-  why should we always have
to remember to bind them, when in most cases, you'd only want
to have "special" places that aren't bound, right?

Hell, I'd like to see an inbuilt ORM type deal that gets used more
than not.

Yup, go wish, I know- guess I don't want one /that/ bad...

If it were easy, it would be done, right?  ;-)

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285783
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 problem getting records within date range

[Josh Nathanson]

C. W.,

I don't know much about SQL server in particular, but try using 'date' 
instead of 'datetime' in your CONVERT function, if that's possible.  I've 
run across this before in MySQL.

This is because a value like '2007-08-02 14:00:00' is greater than 
'2007-08-02', so that won't be picked up by less than or equal to.

-- Josh


- Original Message - 
From: "C. W. B." <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 08, 2007 5:37 PM
Subject: Re: SQL Server problem getting records within date range


> Hello again Janet...
>
> I am so sorry to be bugging you again on this, but I am having trouble 
> with this new query - not doubt it's something I just don't understand.
>
> If I set the dates in this query to 08/01/2007 and 08/02/2007 I only get 
> results from 08/01/2007.  And, if I have them both set to 08/02/2007, I 
> don't get no results at all - but I would expect to set the results from 
> 8/2, which do indeed exist.
>
> Note that I am using >= and <= in the query.
>
> What am I missing here?
>
> Feeling kinda dumb today :(
>
>
>>Yes, that looks correct.
>
> 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: DW8 download?

[Eric Roberts]

I would like to know why they took it off the adobe site.  The latest
version of Eclipse/CfEclipse is working fine for me...so I think I am just
going to stick with it.  Thanks!

Eric

-Original Message-
From: Matt Williams [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 5:10 PM
To: CF-Talk
Subject: Re: DW8 download?

I have the exe installer (windows) and the 8.02 updaters. I don't
think there would be any reason I couldn't send it to you somehow.

On 8/8/07, Eric Roberts <[EMAIL PROTECTED]> wrote:
> I couldn't find it either when I reinstalled the OS on my laptop...which
> forced me to go get eclipse...
>
> Eric
>
> -Original Message-
> From: Adkins, Randy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 10:09 AM
> To: CF-Talk
> Subject: DW8 download?
>
> Anyone have a link to the Dreamweaver 8 downloads? I need to get that
> version.
> We have our own key for it just need to re-install.
>
>
>
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: cfquery: quotes vs queryparam

[Dave Watts]

> That seems like a lame argument to me.  If you want to stick 
> to defining cfqueryparam that way then I might as well 
> request a new tag, cfqueryparmthatdoesntusebinding, that does 
> everything that I want it to do without doing parameter 
> binding. Then we could both have our way but somehow that 
> doesn't feel like the spirit of what a high-level language 
> like CF should be.

All of the functionality of CFQUERYPARAM is completely dependent on the fact
that it creates a bound parameter. Type-checking, security, performance, all
of those things come from the database, not from CF. So, yes, that's how
I'll define CFQUERYPARAM - it's a tag that creates a bound parameter. If you
want a tag that does something else, that's all well and good, but that has
nothing to do with what CFQUERYPARAM actually does.

> I completely conceed that it would be difficult to guarantee 
> perfect security the way that a bound parameter would.  My 
> essential point is that it would be better for everyone if 
> all code could be written with cfqueryparam and the benefits 
> of query binding could be enjoyed in every case except those 
> few times where it gets in the way, even if that meant not 
> having 100% perfect security during those few moments when it 
> was disabled.  That does not seem like an unreasonable point 
> of view to me.

But what exactly would this tag do, if not create a bound parameter? It
sounds like what you really want is an off switch.

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!

This email has been processed by SmoothZap - www.smoothwall.net


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285780
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 problem getting records within date range

[C. W. B.]

Hello again Janet...

I am so sorry to be bugging you again on this, but I am having trouble with 
this new query - not doubt it's something I just don't understand.

If I set the dates in this query to 08/01/2007 and 08/02/2007 I only get 
results from 08/01/2007.  And, if I have them both set to 08/02/2007, I don't 
get no results at all - but I would expect to set the results from 8/2, which 
do indeed exist.  

Note that I am using >= and <= in the query.

What am I missing here?

Feeling kinda dumb today :(


>Yes, that looks correct. 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: cfquery: quotes vs queryparam

[Gaulin, Mark]

>You could, but that's irrelevant; whether you know how something works has
nothing to do with how it works. What CFQUERYPARAM does is create bound
parameters. All of those other features are the side-effects.

That seems like a lame argument to me.  If you want to stick to defining 
cfqueryparam that way then I might as well request a new tag, 
cfqueryparmthatdoesntusebinding, that does everything that I want it to do 
without doing parameter binding. Then we could both have our way but somehow 
that doesn't feel like the spirit of what a high-level language like CF should 
be.
 
I completely conceed that it would be difficult to guarantee perfect security 
the way that a bound parameter would.  My essential point is that it would be 
better for everyone if all code could be written with cfqueryparam and the 
benefits of query binding could be enjoyed in every case except those few times 
where it gets in the way, even if that meant not having 100% perfect security 
during those few moments when it was disabled.  That does not seem like an 
unreasonable point of view to me. 
 
Thanks 
 Mark
 


From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wed 8/8/2007 6:35 PM
To: CF-Talk
Subject: RE: cfquery: quotes vs queryparam



> You could look at cfqueryparam as providing lots of features
> (security, type and length checking, handling of lists, etc)
> without ever knowing that the implementation was done via
> parameter binding.

You could, but that's irrelevant; whether you know how something works has
nothing to do with how it works. What CFQUERYPARAM does is create bound
parameters. All of those other features are the side-effects.

> You would think that for all the seriousness of the security
> hacks everyone is talking about that CF would want to make it
> a complete no-brainer that we should all use cfqueryparam. 

The security benefit of CFQUERYPARAM is that bound parameters don't allow
execution of commands. By using bound parameters, you are preventing the
execution of any commands embedded in your data values. If CFQUERYPARAM did
something other than create bound parameters, it would not be able to
guarantee prevention of SQL injection attacks.

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!

This email has been processed by SmoothZap - www.smoothwall.net




~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Re: About the GotCFM.com Site List

[Michael Dinowitz]

On a related note, the ColdFusion Community Search is past 2500
ColdFusion sites. I'd like more, so if you see a site of interest to
the community, please contribute it to the search engine.

http://www.google.com/coop/manage/cse/invitation?invid=Dn2tUIKcnFExmvAeyA74lWQwgeGYN4I_K8Ms&invauth=py4gfBPOIdppu30z

The search engine can be seen at the top of all House of Fusion pages
and has a number of sub-categories for more specific searches.

If you would like to add the search to your own site, email me off
list and I'll send you either the standard code or the advanced code
that I use in the HoF top search.

-- 
Michael Dinowitz
President: House of Fusion(http://www.houseoffusion.com)
Publisher: Fusion Authority(http://www.fusionauthority.com)
Adobe Community Expert / Advanced Certified ColdFusion Professional

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: Eclipse/CFEclispe

[Loathe]

Their site still says 3.2 but it's running fine for me.

-Original Message-
From: lists [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 6:45 PM
To: CF-Talk
Subject: RE: Eclipse/CFEclispe

Is Aptana compatible with Eclipse 3.3 yet? 

-Original Message-
From: Dan Vega [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 7:52 AM
To: CF-Talk
Subject: Re: Eclipse/CFEclispe

You can also look at Aptana, I use that plugin and it has a lot of nice
features.

http://www.aptana.org

On 8/8/07, Dawson, Michael <[EMAIL PROTECTED]> wrote:
>
> Yeah, that's a good question.
>
> I have the WTP build, but I don't really see any other features, such 
> as CSS, when I'm editing .css files or even styles within an HTML page.
>
> M!ke
>
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 9:40 AM
> To: CF-Talk
> Subject: RE: Eclipse/CFEclispe
>
> It does CSS?  I wonder which one I installed, because I have never 
> gotten CSS and that is the missing link to get me off of Dreamweaver.
>
> 





~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: About the GotCFM.com Site List

[Eric Roberts]

Glad to know that you don't have to be the site owner ;-)  I will be adding
away...

Eric



-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 1:08 PM
To: CF-Talk
Subject: About the GotCFM.com Site List

Hi Everyone,

Of late, I've been seeing a number of questions as to why specific sites 
are not on the GotCFM list. The easy answer is that they haven't been 
submitted. I review and approve sites fairly quickly so its not a delay 
from that perspective.

With that said, if you see a CF site that is not part of the list, 
please feel free to submit it. The form is on the homepage of GotCFM.com 
and its as easy as it gets. You don't need to be the site owner to 
submit it so please take the initiative and send the site over for review.

I also get emails asking me to submit sites for people. Like everyone 
else, I'm fairly busy with work so I really don't have time to do that. 
In the time it takes someone to email me about a new site, they could've 
submitted it themselves.

This is a resource for the CF community so a little effort on everyone's 
part will definitely help make the site more effective.

Thanks,

Rey...



~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: Eclipse/CFEclispe

[lists]

Is Aptana compatible with Eclipse 3.3 yet? 

-Original Message-
From: Dan Vega [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 7:52 AM
To: CF-Talk
Subject: Re: Eclipse/CFEclispe

You can also look at Aptana, I use that plugin and it has a lot of nice
features.

http://www.aptana.org

On 8/8/07, Dawson, Michael <[EMAIL PROTECTED]> wrote:
>
> Yeah, that's a good question.
>
> I have the WTP build, but I don't really see any other features, such 
> as CSS, when I'm editing .css files or even styles within an HTML page.
>
> M!ke
>
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 9:40 AM
> To: CF-Talk
> Subject: RE: Eclipse/CFEclispe
>
> It does CSS?  I wonder which one I installed, because I have never 
> gotten CSS and that is the missing link to get me off of Dreamweaver.
>
> 



~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: query of queries and column aliasing

[Rick Root]

Idiot alert, idiot alert!

My alias name was "DESC"... short for "description"

Also a reserved word =)

Funny how things work fine when you don't use reserved words.

Rick

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Re: running jrockit with CFusionMX7 to find memory leak

[Erik ahlin]

1 think this is the easiest way to use memleak.

1) Copy the license file to your JRE-directory. See:
http://dev2dev.bea.com/jrockit/tools.html

2) Start JRockit with
-Xmanagement:port=7091,ssl=false,authenticate=false

3) Start Mission Control and click new connection in the JRockit Browser 
toolbar. Set the host(localhost) and port(7091).

4) Right click on the connection you've just created and select Memleak.


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: cfquery: quotes vs queryparam

[Dave Watts]

> You could look at cfqueryparam as providing lots of features 
> (security, type and length checking, handling of lists, etc) 
> without ever knowing that the implementation was done via 
> parameter binding.

You could, but that's irrelevant; whether you know how something works has
nothing to do with how it works. What CFQUERYPARAM does is create bound
parameters. All of those other features are the side-effects.

> You would think that for all the seriousness of the security 
> hacks everyone is talking about that CF would want to make it 
> a complete no-brainer that we should all use cfqueryparam.  

The security benefit of CFQUERYPARAM is that bound parameters don't allow
execution of commands. By using bound parameters, you are preventing the
execution of any commands embedded in your data values. If CFQUERYPARAM did
something other than create bound parameters, it would not be able to
guarantee prevention of SQL injection attacks.

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!

This email has been processed by SmoothZap - www.smoothwall.net


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: query of queries and column aliasing

[Gaulin, Mark]

Try "col_alias = expression"
Mark

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 6:17 PM
To: CF-Talk
Subject: query of queries and column aliasing

So, it looks like column aliasing isn't valid in query of queries.

For example, the following works:

select foo + ' - ' + foo2 from qry

But this does not:

select foo + ' - ' + foo2 as newfoo from qry

Coldfusion seems to automatically alias the dynamic columns .. as
"Column_1" in the case above.

But.. is there any way to do column aliasing in QoQ that I'm missing, or
is it just not supported?

(BTW I'm using CFMX 7.0.2)

--
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: cfquery: quotes vs queryparam

[Gaulin, Mark]

Hi Dave
You could look at cfqueryparam as providing lots of features (security,
type and length checking, handling of lists, etc) without ever knowing
that the implementation was done via parameter binding.  Because all of
those features could be implemented without parameter binding (do the
checking in CF and produce "raw" SQL), I would argue that the binding
part is an implementation detail, and one that could be disabled without
affecting much of usefulness of cfqueryparam (for security and type
checking, etc).

Why would I want to disable binding? That depends on the situation, but
SQL profiling (even on/especially on a production system) is really,
really useful.  Sure, binding may be slightly faster in some cases (and
maybe lots faster in others, but I wouldn't be too sure about that), but
I would bet that most slow DB queries are due to query/table/index
design or the effects of query load, not on the time it takes to compile
the query (which is where binding is helpful). In those situations I
would prefer to see the "real" SQL, and not the cryptic execution of a
precompiled statement.  

Another angle has to do with the way bad SQL is reported in a CF error:
With binding you see the query but not the values inserted into the
query. Without binding the error reports exactly what was executed.  I
have every CF error on my web site emailed to me and sometimes these
little details are the only way to track down and fix subtle bugs so
they never happen again.

You would think that for all the seriousness of the security hacks
everyone is talking about that CF would want to make it a complete
no-brainer that we should all use cfqueryparam.  You may not agree on
the value of the things I don't want to go without, but I hope you can
see that they are at least potentially real to someone, somewhere,
sometime.  Being able to flip a switch to "revert" to non-bound
parameters would make that possible, so why treat it like a dumb idea?

Thanks
Mark


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 5:16 PM
To: CF-Talk
Subject: RE: cfquery: quotes vs queryparam

> I wish CF could allow the use of the cfqueryparam tag without all of 
> the other side-effects (using binding, disabling
> caching) so that we really could say *always* use it... 

Binding is not a side-effect, it is exactly what CFQUERYPARAM does.
CFQUERYPARAM creates bound parameters.

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!

This email has been processed by SmoothZap - www.smoothwall.net




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

query of queries and column aliasing

[Rick Root]

So, it looks like column aliasing isn't valid in query of queries.

For example, the following works:

select foo + ' - ' + foo2 from qry

But this does not:

select foo + ' - ' + foo2 as newfoo from qry

Coldfusion seems to automatically alias the dynamic columns .. as
"Column_1" in the case above.

But.. is there any way to do column aliasing in QoQ that I'm missing,
or is it just not supported?

(BTW I'm using CFMX 7.0.2)

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: DW8 download?

[Matt Williams]

I have the exe installer (windows) and the 8.02 updaters. I don't
think there would be any reason I couldn't send it to you somehow.

On 8/8/07, Eric Roberts <[EMAIL PROTECTED]> wrote:
> I couldn't find it either when I reinstalled the OS on my laptop...which
> forced me to go get eclipse...
>
> Eric
>
> -Original Message-
> From: Adkins, Randy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 10:09 AM
> To: CF-Talk
> Subject: DW8 download?
>
> Anyone have a link to the Dreamweaver 8 downloads? I need to get that
> version.
> We have our own key for it just need to re-install.
>
>
>
>
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Re: cfquery: quotes vs queryparam

[Jochem van Dieten]

Bryan Stevenson wrote:
>> Have you played with characters your database considers escape
>> characters? Do you know which characters that are? Do you know which
>> characters that will be for every database your application will ever
>> run on?
>> Have you played with characters CF does not consider escape characters
>> because CF evaluates their Unicode version, but your database considers
>> escape characters because your database considers their ASCII version?
>> Do you know which characters that are? Do you know which characters that
>> will be for every database your application will ever run on?
>>
>>
>> Do you expect a hacker to know more about these issues then you do?
>> Do you like to take chances?
> 
> I'm sensing a theme Jochemperhaps you think the poster should use 
> cfqueryparam?? ;-) 

Using character set conversions for SQL attacks is very real:
http://lists.mysql.com/announce/364
http://www.postgresql.org/docs/techdocs.50

It gets even more fun when you use a custom escape clause:
http://msdn2.microsoft.com/en-us/library/aa933232(SQL.80).aspx


I'm not even going to try to comprehend what happens when you combine 
these issues or evaluate the potential for abuse this gives in a mixed 
(Java and C) environment. I would be very interested in reading the 
opinion of somebody who understands all aspects of these issues, but I 
can't imagine anybody convincing me not to use cfqueryparam.

Jochem

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: DW8 download?

[Eric Roberts]

I couldn't find it either when I reinstalled the OS on my laptop...which
forced me to go get eclipse...

Eric

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 10:09 AM
To: CF-Talk
Subject: DW8 download?

Anyone have a link to the Dreamweaver 8 downloads? I need to get that
version. 
We have our own key for it just need to re-install.




~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Re: cfquery: quotes vs queryparam

[Bryan Stevenson]

>I hear you, but cfqueryparm was historically not "all good"... It
> disables query caching via cachedwithin.  This was always a frustrating
> limitation and my understanding is that is has been fixed in CF8 but I
> haven't played with cf8 yet to know for sure.

Not once have I needed to cache a query since I started January of 1998 version 
3.1.  It's probabaly just the types of apps I have built (more complex business 
apps than high traffic thus needing caching).  So no skin off my nose on that 
one

> Query parameter binding also has down-sides... It makes debugging via
> SQL query profiling much harder (can't see the actual query & parameters
> in an easy-to-read way); I don't recall if the query as seen in a
> CF-generated error message looks different too.

Well...that's a bit of grasping at straws IMHO.  A pain for sure, but I'd 
rather 
have the performance all the time than the occasional PITA debugging a query ;-)

Anyways...I think this is marks the 1 millionth time I've had this 
discussiondo I get a door prize?? ;-)

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

Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments. 



~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: cfquery: quotes vs queryparam

[Dave Watts]

> > Are you kidding???  I just replace form.lastname
> > with:   " test'; DROP TABLE table; "
> > Poof, your data'z are gone
> 
> ColdFusion would escape that single quote, rendering this 
> attempt pretty much useless and "data'z" would still be 
> there.  I'm not suggesting that you shouldn't use 
> CFQUERYPARAM wherever possible, but it's not so simple to 
> inject with a quoted string as it may seem at first glance 
> (it can certainly be done).  Now, if this were ASP.Net...

While you're absolutely correct about this specific example not working, you
should read Jochem's most recent post very carefully. It is very difficult
to guarantee that there is no character sequence that will "break out" of
your single-quoted string, and there are people much smarter than me whose
job (or hobby) it is to find these sequences and use them. I can spend my
time worrying about that, or I can use CFQUERYPARAM. It's an easy choice,
and it conforms to the security dictum "deny, then allow" - rather than
identifying every potentially dangerous sequence, I can just use
CFQUERYPARAM to prevent any possible SQL injection. CFQUERYPARAM tells the
database that input values are not executable code. It denies the
possibility of execution for any value.

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!

This email has been processed by SmoothZap - www.smoothwall.net


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: Eclipse/CFEclispe

[Eric Roberts]

Welcome to the dark side Robert :-D  hehehe

Pretty soon I will be running that with Windows Server 2008 Beta...they just
shipped that out with the Microsoft Action pack Quarterly update.  I love
SQL Server 2005...very nice interface.  It took a lil bit to get used
to...first time I used it it was sprung on us at a client...we were
expecting 2k.  

You can also just get the Eclipse SDK and then get CFEclipse and whatever
other plugins you want.  There are also several different packaged distros
that you can download.  One of them allows you to configure what packages
you want on their website and then you download the whole shebang.



Eric

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 9:31 AM
To: CF-Talk
Subject: RE: Eclipse/CFEclispe

Thank You. I'll give it a try... downloading now! 

I'm figuring since I have a new kick-butt machine and I still have my old
machine and environment, I'm going bleeding edge on the new one. 

IIS7, CF8, SQL Server 2005, CFECLISPE, etc. Why not for once be on the lead?
Normally I wouldn't try that so boldly but my development platform is still
intact on the old machine and production won't be in jeopardy. Keep your
fingers crossed. So far I've gotten through the glitches as they've shown
themselves.

Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be &.






~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: cfquery: quotes vs queryparam

[Dave Watts]

> I wish CF could allow the use of the cfqueryparam tag without 
> all of the other side-effects (using binding, disabling 
> caching) so that we really could say *always* use it... 

Binding is not a side-effect, it is exactly what CFQUERYPARAM does.
CFQUERYPARAM creates bound parameters.

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!

This email has been processed by SmoothZap - www.smoothwall.net


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: Quick Question about "upgrading" to CF 8

[Eric Roberts]

It's always better to do a clean install...but CF 8 will also import setting
from CF7 (and I believe 6).

Eric

-Original Message-
From: LHWH Interactive [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 8:37 AM
To: CF-Talk
Subject: Quick Question about "upgrading" to CF 8

I've looked on Adobe and I just can't find the answer to a really easy
question regarding upgrading to CF8. If I've got CF 7 installed on our
internal development server, and I wanna upgrade it, is it better for
me to uninstall 7 before installing 8? Or should I just get the
upgrade and install it over top of 7? I have no problem just upgrading
8 over 7, thinking that it will just update all relevant parts, but I
just wanted to see what the consensus was, or if there's actually a
somewhat "official" position...

Any ideas?



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Re: cfquery: quotes vs queryparam

[Jochem van Dieten]

Gaulin, Mark wrote:
> I hear you, but cfqueryparm was historically not "all good"... It
> disables query caching via cachedwithin.  This was always a frustrating
> limitation and my understanding is that is has been fixed in CF8 but I
> haven't played with cf8 yet to know for sure.

It is.


> I wish CF could allow the use of the cfqueryparam tag without all of the
> other side-effects (using binding, disabling caching) so that we really
> could say *always* use it... 

Caching is fixed. What functionality is left if binding is removed?

Jochem

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: Develop an ecommerce site in CFMX 7 using Paypal

[Rey Bango]

The PayPal SDK can be daunting to work with. I would recommend 
contacting Jared Rypka-Hauer about his PayPalMX components. You can get 
more info here including Jared's email:

http://www.web-relevant.com/blogs/cfobjective/index.cfm?mode=entry&entry=83AEB42F-BDB9-5320-E0207DD531806BA8

Rey...

Prema Sekar wrote:
> Hi All,
> 
> This is my first ecommerce application using Paypal in CFMX7. I am
>  using Ben Forta's CFWACK book as my reference. I have downloaded the
>  PayflowPro SDK by creating a test account in PayPal. But I couldnot download
>  the .jar file.
> 
> Could anybody please help me with the steps to be followed in
>  developing a ecommerce application in CFMX 7.
> 
> Thanks
> -kpltpj 
> 
> 
> 
> 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: cfquery: quotes vs queryparam

[Rick Schmitty]

Oh no, I agree (the null is my fav of cfqueryparam).

This was just a case of inheriting a large pile of code w/o
cfqueryparams and the guy used '#quotedvars#' for his strings (and IDs
for the matter) and me wanting to feel better about not trying to
convert it all over... :)

On 8/8/07, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> OKlet's all agree to disagree about added security from CFQUERYPARAM (even
> though it does add security...na na na boo boo) ;-)
>
> Just remember it also:
> -allows for additional maxlength validation (beyond your form inputs)
> -uses BIND vars with DBs that support them to speed up queries
> -adds additional data type checking (beyond your form validation)
> -can insert a NULL in 1 line of code instead of:
>
>  NULL,
>
> #MyVar#
>
>
> So is that about enough said folks...not just for security...can we put this 
> one
> to bedjust use the dang tag and it's all good ;-)
>
> 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
>
> Notice:
> This message, including any attachments, is confidential and may contain
> information that is privileged or exempt from disclosure. It is intended
> only for the person to whom it is addressed unless expressly authorized
> otherwise by the sender. If you are not an authorized recipient, please
> notify the sender immediately and permanently destroy all copies of this
> message and attachments.
>
>
>
> 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: cfquery: quotes vs queryparam

[Gaulin, Mark]

I hear you, but cfqueryparm was historically not "all good"... It
disables query caching via cachedwithin.  This was always a frustrating
limitation and my understanding is that is has been fixed in CF8 but I
haven't played with cf8 yet to know for sure.

Query parameter binding also has down-sides... It makes debugging via
SQL query profiling much harder (can't see the actual query & parameters
in an easy-to-read way); I don't recall if the query as seen in a
CF-generated error message looks different too.

I wish CF could allow the use of the cfqueryparam tag without all of the
other side-effects (using binding, disabling caching) so that we really
could say *always* use it... 

To be honest, the only reason I even got into this conversation is
because someone was posting incorrect information about security, and
people have a way of picking up on sensational information, even when
(especially when!) it is wrong.

Mark

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 4:13 PM
To: CF-Talk
Subject: RE: cfquery: quotes vs queryparam

OKlet's all agree to disagree about added security from CFQUERYPARAM
(even though it does add security...na na na boo boo) ;-)

Just remember it also:
-allows for additional maxlength validation (beyond your form inputs)
-uses BIND vars with DBs that support them to speed up queries -adds
additional data type checking (beyond your form validation) -can insert
a NULL in 1 line of code instead of:
   
 NULL,
   
#MyVar#
   

So is that about enough said folks...not just for security...can we put
this one to bedjust use the dang tag and it's all good ;-)

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

Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.





~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285757
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 problem getting records within date range

[C. W. B.]

Hello again Janet, thank you for your help on this.  It suare has had me 
stumped.

So, like this?

SELECT 
  dbo.tblSubscribers.SID, 
  dbo.tblSubscribers.Username, 
  max(dbo.tblUserTransactionLog.Processed) AS LastTransaction
FROM 
  dbo.tblSubscribers,
  dbo.tblUserTransactionLog
WHERE
  dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID AND
  (dbo.tblUserTransactionLog.Processed >= CONVERT(datetime, '08/01/2007', 101)) 
 AND 
  (dbo.tblUserTransactionLog.Processed <= CONVERT(datetime, '08/07/2007', 101))
GROUP BY 
  dbo.tblSubscribers.SID, 
  dbo.tblSubscribers.Username

Thanks, CWB

> > I should have mentioned that I need to get only the most recent 
> > transaction for each user within the given time-frame.  That's why I 
> 
> > am using max().  Using this aggregate function, I think, requires I 
> 
> > use "having," no?.
> 
> No, if I'm understanding correctly its not required here.  The WHERE 
> clause restricts the results to the given time frame and the aggregate 
> + the GROUP BY gives you the max (per user)
> 
> Janet 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285754
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 problem getting records within date range

[Janet MacKay]

Yes, that looks correct. 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: cfquery: quotes vs queryparam

[Ian Skinner]

.just use the dang tag and it's all good  ;-) 

Cheers

I do, but that doesn't mean I don't want to know more how SQL injection 
actually works and how  is mitigating this risk.  Just to make 
myself a more knowledge person.


No it has nothing to do with that site that fired me in a most horrible manner 
in 2000 and I'm 80% sure has not improved their security in the past 7 years or 
so.  I'm just curious, really I am.

All jokes aside, I am actually interested in the knowledge.



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

Develop an ecommerce site in CFMX 7 using Paypal

[Prema Sekar]

Hi All,

This is my first ecommerce application using Paypal in CFMX7. I am
 using Ben Forta's CFWACK book as my reference. I have downloaded the
 PayflowPro SDK by creating a test account in PayPal. But I couldnot download
 the .jar file.

Could anybody please help me with the steps to be followed in
 developing a ecommerce application in CFMX 7.

Thanks
-kpltpj 



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Re: action pages

[koen darling]

Something like this should work:


#field#: #form.[field]#



Koen


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: cfquery: quotes vs queryparam

[Ian Skinner]

but it isn't like cfquery
without it is necessarily an open door (if you're consistent).

Mark

Well not that open, unless somebody has opened the door with 
preserveSingleQuotes() for some reason.  But one would hope that this was done 
with a clear purpose and understanding of the risks and appropriate action was 
taken to mitigate them.

But this also does not say that  is a closed, secure door either.  
It may take more effort to fool it, but I trust the experts when they say it 
can be fooled and that the consistent use of  makes it more 
secure.






~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: cfquery: quotes vs queryparam

[Ian Skinner]

http://localhost/test.cfm?name=rick%20or%201=1


Was this an invitation to demonstrate techniques?  If so, localhost ain't going 
to work for anybody else.  If not, never mind.

But I too would like to know more details about how this actually happens.  I 
trust that I should use  and do.  But I think it valuable to 
know the specifics and not just blindly follow.


~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: Data source 'source_name' verification failed.????

[Charles Love]

Thanks, Loathe...That did it!!

I got all the info I needed to solve the problem.  Turns out I had different 
data sources within the same cftransaction and that is a CF error.  I was 
catching the error but only showing the message.  The cfcatch.Detail shows the 
REAL reason for the error

Thanks again... Good save 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: cfquery: quotes vs queryparam

[Bryan Stevenson]

OKlet's all agree to disagree about added security from CFQUERYPARAM (even 
though it does add security...na na na boo boo) ;-)

Just remember it also:
-allows for additional maxlength validation (beyond your form inputs)
-uses BIND vars with DBs that support them to speed up queries
-adds additional data type checking (beyond your form validation)
-can insert a NULL in 1 line of code instead of:
   
 NULL,
   
#MyVar#
   

So is that about enough said folks...not just for security...can we put this 
one 
to bedjust use the dang tag and it's all good ;-)

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

Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.



~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: action pages

[Crow T. Robot]

i think you're looking for FORM.fieldnames ?

On 8/8/07, Katie Miller <[EMAIL PROTECTED]> wrote:
>
> I think this is mostly because I'm not thinking clearly today.  I have a
> form where the fields are generated by a query & a loop.  I want the results
> of the form emailed to someone but I'm having a little trouble how to get
> the list into the email form.
>
> Katie
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

action pages

[Katie Miller]

I think this is mostly because I'm not thinking clearly today.  I have a form 
where the fields are generated by a query & a loop.  I want the results of the 
form emailed to someone but I'm having a little trouble how to get the list 
into the email form.

Katie 



~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: cfquery: quotes vs queryparam

[Rick Schmitty]

Well thats the thing, I know I should use cfqueryparam but the quoted
string wont let commands through

I made a test table and tried to hack it (with something that wouldnt
delete but would prove sql injection)

http://localhost/test.cfm?name=rick%20or%201=1

etc, but query 2 will just return an empty set with any injection
attack I tried (using CF7 and MSSQL)  Query 3 is obviously the wide
open one




select * from dropme




select * from dropme
where Lname='#url.name#'





select * from dropme
where Lname=#url.name#




I guess at the end of the day I'd use queryparam on everything, but
I'd still like to see a quoted string break with injection

On 8/8/07, Peterson, Chris <[EMAIL PROTECTED]> wrote:
> Are you kidding???
>
> I just replace form.lastname with:   " test'; DROP TABLE table; "
>
> Poof, your data'z are gone
>
> Or, if you really wanna get tricky and someone has debugging turned on,
> or you can guess field / table names:
>
> Lets say you have a fName and lName column outputting a list, and I can
> figure that out
>
> Now I replace form.lastname with this:"  test'; SELECT
> credit_card_num as fName, expireDate as lName FROM creditCards;  "
>
> Now instead of seeing a firstname / lastname directory, I see a list of
> all your credit cards in the database =)
>
> ALWAYS use cfqueryparam, or clean the crap out of any incoming variables
> to ensure they are not being exploited.
>
>
> Chris Peterson
> Gainey IT
> Adobe Certified Advanced Coldfusion Developer
>
> -Original Message-
> From: Rick Schmitty [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 2:57 PM
> To: CF-Talk
> Subject: cfquery: quotes vs queryparam
>
> Is there anyway for someone to hack a quoted query?
>
> 
> select * from table where name='#form.lastname#'
> 
>
> vs
>
> 
> select * from table where name= maxlength="255" value="#form.lastname#"/> 
>
>
> Seems anything I throw at the quoted query gets escaped correctly...
>
>
>
> 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: cfquery: quotes vs queryparam

[Gaulin, Mark]

I'm not seeing how your example would do anything other than find zero
records...

Start with: 
select from table where lastname = '#form.lastname#'

Use your example:
Form.lastname = " test'; DROP TABLE table; "

So you get (with quote-doubling)
select from table where lastname = ' test''; DROP TABLE table; '

And you will return all records with a last name of " test'; DROP TABLE
table; ". 

If what you describe were true then you could never search for the name
"O'Connor".

My take-away is that all ## expanded variables in a query should be
quoted, even values that are "supposed to" always be numbers. Sure,
cfqueryparam is safe and good and all of that, but it isn't like cfquery
without it is necessarily an open door (if you're consistent).

Mark

-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 3:17 PM
To: CF-Talk
Subject: RE: cfquery: quotes vs queryparam

Are you kidding???

I just replace form.lastname with:   " test'; DROP TABLE table; "

Poof, your data'z are gone

Or, if you really wanna get tricky and someone has debugging turned on,
or you can guess field / table names:

Lets say you have a fName and lName column outputting a list, and I can
figure that out

Now I replace form.lastname with this:"  test'; SELECT
credit_card_num as fName, expireDate as lName FROM creditCards;  "

Now instead of seeing a firstname / lastname directory, I see a list of
all your credit cards in the database =)

ALWAYS use cfqueryparam, or clean the crap out of any incoming variables
to ensure they are not being exploited.


Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer

-Original Message-
From: Rick Schmitty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 2:57 PM
To: CF-Talk
Subject: cfquery: quotes vs queryparam

Is there anyway for someone to hack a quoted query?


select * from table where name='#form.lastname#'


vs


select * from table where name= 


Seems anything I throw at the quoted query gets escaped correctly...





~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: cfquery: quotes vs queryparam

[Justin Scott]

> Are you kidding???  I just replace form.lastname
> with:   " test'; DROP TABLE table; "
> Poof, your data'z are gone

ColdFusion would escape that single quote, rendering this attempt pretty
much useless and "data'z" would still be there.  I'm not suggesting that
you shouldn't use CFQUERYPARAM wherever possible, but it's not so simple
to inject with a quoted string as it may seem at first glance (it can
certainly be done).  Now, if this were ASP.Net...


-Justin Scott

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285742
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 problem getting records within date range

[Janet MacKay]

> I should have mentioned that I need to get only the most recent 
> transaction for each user within the given time-frame.  That's why I 
> am using max().  Using this aggregate function, I think, requires I 
> use "having," no?.

No, if I'm understanding correctly its not required here.  The WHERE clause 
restricts the results to the given time frame and the aggregate + the GROUP BY 
gives you the max (per user)

Janet 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: Error when using Java class in Cold Fusion

[Gaulin, Mark]

CF won't create the actual java object until you call it, so the lack of
an error on the  line may not mean that part went 100% right.

Things to check:
* The class itself needs to be declared as "public" (so, "public class
")
* Your class needs to have a public no-argument constructor (or no
constructors at all, which would also be fine). If the Search1 class
does have a constructor that requires arguments then call it using CF's
trick with the object "init(...)" method.
* I don't see any package name there, so that must mean that the Search1
class doesn't have a "package" line at the top of it.  This is
definitely a good idea to include but I don't think that is source of
the problem.

Hope that helps.
Mark


-Original Message-
From: Tripura Kondabala [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 4:17 PM
To: CF-Talk
Subject: Error when using Java class in Cold Fusion

Hello Every one
I am getting the following error in my Coldfusion code . The error is as
follow === Class coldfusion.runtime.java.JavaProxy can not access a
member of class Search1 with modifiers "" 


My cold fusion code is as follow ===



and its giving error for   line ...
Can anyone tell me  what is the reason 

I have a Java class named Search1 and there is a public method in it
with the following declaration ...
public int search() throws Exception 
{
...
...
...
...
}

Thankyou 



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: cfquery: quotes vs queryparam

[Andy Matthews]

Pete Freitag had an amazing session at CFUinted about things like this. It's
amazing what can be done using the query string. 

-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 2:17 PM
To: CF-Talk
Subject: RE: cfquery: quotes vs queryparam

Are you kidding???

I just replace form.lastname with:   " test'; DROP TABLE table; "

Poof, your data'z are gone

Or, if you really wanna get tricky and someone has debugging turned on, or
you can guess field / table names:

Lets say you have a fName and lName column outputting a list, and I can
figure that out

Now I replace form.lastname with this:"  test'; SELECT
credit_card_num as fName, expireDate as lName FROM creditCards;  "

Now instead of seeing a firstname / lastname directory, I see a list of all
your credit cards in the database =)

ALWAYS use cfqueryparam, or clean the crap out of any incoming variables to
ensure they are not being exploited.


Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer

-Original Message-
From: Rick Schmitty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 2:57 PM
To: CF-Talk
Subject: cfquery: quotes vs queryparam

Is there anyway for someone to hack a quoted query?


select * from table where name='#form.lastname#'


vs


select * from table where name= 


Seems anything I throw at the quoted query gets escaped correctly...





~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: cfquery: quotes vs queryparam

[Bryan Stevenson]

> Have you played with characters your database considers escape
> characters? Do you know which characters that are? Do you know which
> characters that will be for every database your application will ever
> run on?
> Have you played with characters CF does not consider escape characters
> because CF evaluates their Unicode version, but your database considers
> escape characters because your database considers their ASCII version?
> Do you know which characters that are? Do you know which characters that
> will be for every database your application will ever run on?
>
>
> Do you expect a hacker to know more about these issues then you do?
> Do you like to take chances?

I'm sensing a theme Jochemperhaps you think the poster should use 
cfqueryparam?? ;-) LOL

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

Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Error when using Java class in Cold Fusion

[Tripura Kondabala]

Hello Every one 
I am getting the following error in my Coldfusion code . The error is as follow 
===
Class coldfusion.runtime.java.JavaProxy can not access a member of class 
Search1 with modifiers "" 


My cold fusion code is as follow ===



and its giving error for   line ...
Can anyone tell me  what is the reason 

I have a Java class named Search1 and there is a public method in it with the 
following declaration ...
public int search() throws Exception 
{
..
..
..
..
}

Thankyou 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Re: CF8 & Commonspot (solved)

[Eric Hoffan]

RTFM.   Hmm.  Sorry about the list pollution.


On 8/8/07 2:14 PM, "Eric Hoffan" <[EMAIL PROTECTED]> wrote:

> Anyone have commonspot here htat upgraded to CF8and still have authoring
> capability?If so, could you shout back even offlist...quick problem I am
> seeing and want to make sure its just me.  LOL
> 
> 
> 
> 
> Eric J. Hoffman
> Managing Partner
> 1940 Greeley Street South
> Suite 102
> StillwaterMN55082
> mail: [EMAIL PROTECTED]
> www: http://www.ejhassociates.com
> tel: 651.717.4105
> fax: 651.717.4101
> mob: 651.245.2717
> Adobe Solutions Partner
> Microsoft Certified Partner
> 
> 
> 
> This message contains confidential information and is intended only for
> [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should
> not disseminate, distribute or copy this e-mail. Please notify
> [EMAIL PROTECTED] immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system. E-mail transmission
> cannot be guaranteed to be secure or error-free as information could be
> intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain
> viruses. Eric J. Hoffman therefore does not accept liability for any errors or
> omissions in the contents of this message, which arise as a result of e-mail
> transmission. If verification is required please request a hard-copy version.
> 
> 
> 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Setting session param in onRequestStart

[Josh Nathanson]

Hey all,

Had an interesting conundrum today.  I wanted to param a session variable in 
Application.cfc, so naturally I placed the  in onSessionStart.  I quickly realized that this does not 
catch people whose sessions are already in progress.  Since we pretty much 
have sessions running on our production server 24/7, there is never a time 
when I could post the updated Application.cfc and not get a bunch of "myvar 
not defined in session" errors.

Solutions would be to a) restart the server or otherwise end all sessions 
(not viable), b) use structKeyExists(session,"mvar") anywhere the variable 
is used, or c) place the  in onRequestStart. 
I chose c) as it is the most "DRY (Don't Repeat Yourself)" to implement, but 
I'm wondering if it is bad practice to param a session variable in 
onRequestStart, or if other folks have been in a similar situation and done 
anything differently.

-- Josh 


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: cfquery: quotes vs queryparam

[Peterson, Chris]

Are you kidding???

I just replace form.lastname with:   " test'; DROP TABLE table; "

Poof, your data'z are gone

Or, if you really wanna get tricky and someone has debugging turned on,
or you can guess field / table names:

Lets say you have a fName and lName column outputting a list, and I can
figure that out

Now I replace form.lastname with this:"  test'; SELECT
credit_card_num as fName, expireDate as lName FROM creditCards;  "

Now instead of seeing a firstname / lastname directory, I see a list of
all your credit cards in the database =)

ALWAYS use cfqueryparam, or clean the crap out of any incoming variables
to ensure they are not being exploited.


Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer

-Original Message-
From: Rick Schmitty [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 2:57 PM
To: CF-Talk
Subject: cfquery: quotes vs queryparam

Is there anyway for someone to hack a quoted query?


select * from table where name='#form.lastname#'


vs


select * from table where name= 


Seems anything I throw at the quoted query gets escaped correctly...



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285734
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 problem getting records within date range

[C. W. B.]

Hello Janet - thanks for the reply.

I should have mentioned that I need to get only the most recent transaction for 
each user within the given time-frame.  That's why I am using max().  Using 
this aggregate function, I think, requires I use "having," no?.

Thanks, CWB


>Use the WHERE not HAVING clause. Try something like
>
>SELECT ...
>FROM   ... 
>WHERE  dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID
>ANDdbo.tblUserTransactionLog.Processed >= convert(datetime, '08/01/2007', 
>101)
>AND   dbo.tblUserTransactionLog.Processed <= convert(datetime, '08/07/2007', 
>101)
>GROUP BY
>  dbo.tblSubscribers.SID,
>  dbo.tblSubscribers.Username, 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

CF8 & Commonspot

[Eric Hoffan]

Anyone have commonspot here htat upgraded to CF8and still have authoring
capability?If so, could you shout back even offlist...quick problem I am
seeing and want to make sure its just me.  LOL




Eric J. Hoffman
Managing Partner
1940 Greeley Street South
Suite 102
StillwaterMN55082
mail: [EMAIL PROTECTED]
www: http://www.ejhassociates.com
tel: 651.717.4105
fax: 651.717.4101
mob: 651.245.2717
Adobe Solutions Partner
Microsoft Certified Partner



This message contains confidential information and is intended only for [EMAIL 
PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, 
distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by 
e-mail if you have received this e-mail by mistake and delete this e-mail from 
your system. E-mail transmission cannot be guaranteed to be secure or 
error-free as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does 
not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Re: cfquery: quotes vs queryparam

[Jochem van Dieten]

Rick Schmitty wrote:
> Is there anyway for someone to hack a quoted query?
> 
> 
> select * from table where name='#form.lastname#'
> 

Depends on the database and the configuration.


> Seems anything I throw at the quoted query gets escaped correctly...

Have you played with characters your database considers escape 
characters? Do you know which characters that are? Do you know which 
characters that will be for every database your application will ever 
run on?
Have you played with characters CF does not consider escape characters 
because CF evaluates their Unicode version, but your database considers 
escape characters because your database considers their ASCII version? 
Do you know which characters that are? Do you know which characters that 
will be for every database your application will ever run on?


Do you expect a hacker to know more about these issues then you do?
Do you like to take chances?

Jochem

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

cfquery: quotes vs queryparam

[Rick Schmitty]

Is there anyway for someone to hack a quoted query?


select * from table where name='#form.lastname#'


vs


select * from table where name=



Seems anything I throw at the quoted query gets escaped correctly...

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Lynda.com released the first official CF8. Thank you Lynda!

[Ali Majdzadeh]

Hi:
Just wanted to inform you about something.
I was searching for a good CF8 video tutorial and found out Lynda.com released 
an essential traning. It seems it covers many basic subjects. I hope they 
release the intermediate and advanced DVDs soon.
Thank you LYNDA.COM :)
i hope you folks find it interesting too.
Thanks
Benign 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: How would I go by doing this?

[Andy Chen]

Steve,

You are da man! Never head of Firebug but I will give it a shot. I am pretty 
much developing for IE so I never thought about installing Firefox. 

Thanks,
Andy

> Andy,
> 
> Move the JS to the form_test1.cfm page. It works when you do that.
> 
> Here it is:
> 
> http://demo.thinksys.com/cf8/cfwindow/form_test1.cfm
> 
> Are you using Firebug? As Ray Camden has told me many times, use 
> Firebug. It is really great for this stuff. You would see that the 
> actual error was updateit() is not defined.
> 
> But just move the JS to form_test1.cfm and you should be good.
> 
> -Steve
> 
> 
> > Steve, that is it. Similar to what I want to do but something is 
> weird. 
> > I still get the Javascript: Object Expected error. This means I did 
> 
> > something stupid like typed something wrong however I don't see it, 
> 
> > and I simplified it a lot already. This test is just to copy what is 
> 
> > typed in the Window onto the main form.
> > 
> >  (form_test1.cfm)
> > 
> > 
> > 
> > 
> > 
> >  > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> > http://www.w3.org/1999/xhtml";>
> > 
> >  />
> > Input Test
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  
> 
> > 
> > 
> > 
> > 
> >  (form_test1_win.cfm)
> > 
> > 
> > function updateit() {
> > document.mainform.test1.value = document.winform.wintxt.value;
> > }
> > 
> > 
> > 
> > TYPE SOMETHING:  > onkeyup="javascript: updateit();"> 
> > 
> > 
> > 
> > 
> > > If you are using cfwindow than the window is on the same page. You 
> 
> > > should be able to use JS to control the value on the original form. 
> 
> > 
> > > Like:
> > > 
> > > document.formName.name.value;
> > > 
> > > Check out this demo I did:
> > > 
> > > http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm
> > > 
> > > I think the concept is kind of the same. Click the new company 
> link 
> > 
> > > and a cfwindow opens. After the new company is inserted there is a 
> 
> > > close button that uses JS to update the company picklist on the 
> > > original form. It then closes the window.
> > > 
> > > I hope this helps.  
> > > 
> > 


~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285728
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 problem getting records within date range

[Janet MacKay]

Use the WHERE not HAVING clause. Try something like

SELECT ...
FROM   ... 
WHERE  dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID
ANDdbo.tblUserTransactionLog.Processed >= convert(datetime, '08/01/2007', 
101)
AND   dbo.tblUserTransactionLog.Processed <= convert(datetime, '08/07/2007', 
101)
GROUP BY
  dbo.tblSubscribers.SID,
  dbo.tblSubscribers.Username,


~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: Quick Question about "upgrading" to CF 8

[Jochem van Dieten]

LHWH Interactive wrote:
> I've looked on Adobe and I just can't find the answer to a really easy
> question regarding upgrading to CF8. If I've got CF 7 installed on our
> internal development server, and I wanna upgrade it, is it better for
> me to uninstall 7 before installing 8?

Install CF 8 next to it so you can use them both. Or install a CF 8 EAR 
in a CF 7 instance and run CF 8 on top of CF 7.

Jochem

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: How would I go by doing this?

[Steve Sequenzia]

Andy,

Move the JS to the form_test1.cfm page. It works when you do that.

Here it is:

http://demo.thinksys.com/cf8/cfwindow/form_test1.cfm

Are you using Firebug? As Ray Camden has told me many times, use Firebug. It is 
really great for this stuff. You would see that the actual error was updateit() 
is not defined.

But just move the JS to form_test1.cfm and you should be good.

-Steve


> Steve, that is it. Similar to what I want to do but something is weird. 
> I still get the Javascript: Object Expected error. This means I did 
> something stupid like typed something wrong however I don't see it, 
> and I simplified it a lot already. This test is just to copy what is 
> typed in the Window onto the main form.
> 
>  (form_test1.cfm)
> 
> 
>   
> 
> 
>  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> http://www.w3.org/1999/xhtml";>
> 
> 
> Input Test
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  
> 
> 
> 
> 
>  (form_test1_win.cfm)
> 
> 
> function updateit() {
>   document.mainform.test1.value = document.winform.wintxt.value;
> }
> 
> 
> 
> TYPE SOMETHING:  onkeyup="javascript: updateit();"> 
> 
> 
> 
> 
> > If you are using cfwindow than the window is on the same page. You 
> > should be able to use JS to control the value on the original form. 
> 
> > Like:
> > 
> > document.formName.name.value;
> > 
> > Check out this demo I did:
> > 
> > http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm
> > 
> > I think the concept is kind of the same. Click the new company link 
> 
> > and a cfwindow opens. After the new company is inserted there is a 
> > close button that uses JS to update the company picklist on the 
> > original form. It then closes the window.
> > 
> > I hope this helps.  
> > 
> 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

About the GotCFM.com Site List

[Rey Bango]

Hi Everyone,

Of late, I've been seeing a number of questions as to why specific sites 
are not on the GotCFM list. The easy answer is that they haven't been 
submitted. I review and approve sites fairly quickly so its not a delay 
from that perspective.

With that said, if you see a CF site that is not part of the list, 
please feel free to submit it. The form is on the homepage of GotCFM.com 
and its as easy as it gets. You don't need to be the site owner to 
submit it so please take the initiative and send the site over for review.

I also get emails asking me to submit sites for people. Like everyone 
else, I'm fairly busy with work so I really don't have time to do that. 
In the time it takes someone to email me about a new site, they could've 
submitted it themselves.

This is a resource for the CF community so a little effort on everyone's 
part will definitely help make the site more effective.

Thanks,

Rey...

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: Data source 'source_name' verification failed.????

[Loathe]

Try catch the query that is throwing the error

Dump the cfcatch return you'll have additional information in there like
oracle error code.








Something like that should work.


-Original Message-
From: Charles Love [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 2:43 PM
To: CF-Talk
Subject: Data source 'source_name' verification failed.

I have a ColdFusion page that is accessing two different ColdFusion data
sources from the same page.  I have many queries that are using the first
source and they all work.  I have TWO queries that access the second source
and one of them works and the other doesn't.  They are using the same data
source definition and point to the same ORACLE schema.  The second one
errors off giving the error: 'Data source 'source_name' verification
failed.'  

I have removed the actual source name for security purposes.  Has anyone
ever seen this?  Can you suggest a way to debug or isolate?  Any help would
be appreciated.  I am at the end of my ideas.





~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: How would I go by doing this?

[Andy Chen]

Steve, that is it. Similar to what I want to do but something is weird. I still 
get the Javascript: Object Expected error. This means I did something stupid 
like typed something wrong however I don't see it, and I simplified it a lot 
already. This test is just to copy what is typed in the Window onto the main 
form.

 (form_test1.cfm)





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


Input Test












 




 (form_test1_win.cfm)


function updateit() {
document.mainform.test1.value = document.winform.wintxt.value;
}



TYPE SOMETHING:  




> If you are using cfwindow than the window is on the same page. You 
> should be able to use JS to control the value on the original form. 
> Like:
> 
> document.formName.name.value;
> 
> Check out this demo I did:
> 
> http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm
> 
> I think the concept is kind of the same. Click the new company link 
> and a cfwindow opens. After the new company is inserted there is a 
> close button that uses JS to update the company picklist on the 
> original form. It then closes the window.
> 
> I hope this helps.  
> 



~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Data source 'source_name' verification failed.????

[Charles Love]

I have a ColdFusion page that is accessing two different ColdFusion data 
sources from the same page.  I have many queries that are using the first 
source and they all work.  I have TWO queries that access the second source and 
one of them works and the other doesn't.  They are using the same data source 
definition and point to the same ORACLE schema.  The second one errors off 
giving the error: 'Data source 'source_name' verification failed.'  

I have removed the actual source name for security purposes.  Has anyone ever 
seen this?  Can you suggest a way to debug or isolate?  Any help would be 
appreciated.  I am at the end of my ideas.



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285721
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 problem getting records within date range

[C. B.]

Hello all...

I could use a little help here.  I am trying to get the latest
 transaction date from all users within a specified date range.  But the query
 below is giving me records from the date range for this year and last
 year.  What the heck am I doing wrong?

SELECT 
  dbo.tblSubscribers.SID,
  dbo.tblSubscribers.Username,
  max(dbo.tblUserTransactionLog.Processed) 
FROM 
  dbo.tblSubscribers, 
  dbo.tblUserTransactionLog
WHERE 
  (dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID)
GROUP BY
  dbo.tblSubscribers.SID,
  dbo.tblSubscribers.Username,
HAVING
  (CONVERT(varchar, MAX(dbo.tblUserTransactionLog.Processed),101) >=
 '08/01/2007') AND 
  (CONVERT(varchar, MAX(dbo.tblUserTransactionLog.Processed),101) <=
 '08/07/2007')

Thanks, CWB


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Re: any idea how to

[Alan Rother]

Coolio.. Make sure I got the MID function right, I tossed it together
real quick and it might be 5, not 4.

=]

On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> Alan,
>
> This worked...
>
> Thanks
>
> sas
>
> --
> Scott Stewart
> ColdFusion Developer
>
> SSTWebworks
> 4405 Oakshyre Way
> Raleigh, NC. 27616
> (703) 220-2835
>
> http://www.sstwebworks.com
> http://www.linkedin.com/in/sstwebworks
>
> -Original Message-
> From: Alan Rother [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 12:11 PM
> To: CF-Talk
> Subject: Re: any idea how to
>
> LEFT MID AND RIGHT
>
> 
>
>  CreateDate(LEFT(variables.myDateString, 4),  (variables.myDateString,
> 4, 2),  RIGHT(variables.myDateString, 2))>
>
> =]
>
> On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> > Convert 20060523
> >
> >
> >
> > Into 5/23/2006
> >
> >
> >
> > I'm at a loss.
> >
> >
> >
> > Thanks in advance
> >
> >
> >
> > sas
> >
> >
> >
> > --
> >
> > Scott Stewart
> >
> > ColdFusion Developer
> >
> >
> >
> > SSTWebworks
> >
> > 4405 Oakshyre Way
> >
> > Raleigh, NC. 27616
> >
> > (703) 220-2835
> >
> >
> >
> > http://www.sstwebworks.com
> >
> >  
> > http://www.linkedin.com/in/sstwebworks
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: any idea how to

[Scott Stewart]

Alan, 

This worked...

Thanks

sas

-- 
Scott Stewart
ColdFusion Developer
 
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(703) 220-2835
 
http://www.sstwebworks.com
http://www.linkedin.com/in/sstwebworks
 
-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 12:11 PM
To: CF-Talk
Subject: Re: any idea how to

LEFT MID AND RIGHT





=]

On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> Convert 20060523
>
>
>
> Into 5/23/2006
>
>
>
> I'm at a loss.
>
>
>
> Thanks in advance
>
>
>
> sas
>
>
>
> --
>
> Scott Stewart
>
> ColdFusion Developer
>
>
>
> SSTWebworks
>
> 4405 Oakshyre Way
>
> Raleigh, NC. 27616
>
> (703) 220-2835
>
>
>
> http://www.sstwebworks.com
>
>  
> http://www.linkedin.com/in/sstwebworks
>
>
>
>
>
>
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: How would I go by doing this?

[Steve Sequenzia]

If you are using cfwindow than the window is on the same page. You should be 
able to use JS to control the value on the original form. Like:

document.formName.name.value;

Check out this demo I did:

http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm

I think the concept is kind of the same. Click the new company link and a 
cfwindow opens. After the new company is inserted there is a close button that 
uses JS to update the company picklist on the original form. It then closes the 
window.

I hope this helps.  

> The only way I know of doing what you've indicated below is to use a 
> JavaScript.
> 
> You can reference the "parent" or "opener" window by using the 
> "opener" keyword:
> opener.document.parentForm.pf1.value = document.childForm.cf1.value;
> 
> A good example of how to do this from a JavaScript can be seen here: 
> http://www.rgagnon.com/jsdetails/js-0066.html
> 
 
> -- Original message --
> From: "Andy Chen" <[EMAIL PROTECTED]>
> > Here's a situation:
> > 
> > Basically there is a form (CFFORM) which there are various fields. 
> One of the 
> > field would be a basic CFINPUT text field where an image ID can be 
> entered. The 
> > user will be able to click on a button to preview available images 
> (CFWINDOW). 
> > Whatever image they select in the Window (via radio button or drop 
> down), it 
> > will populate the main form with the value.
> > 
> > I can't figure out how to pass a variable from the Window back to 
> the parent 
> > form. To use some of the UI features, the Window will need to have a 
> CFFORM 
> > also. I tried binding but it would only work if it is in the same 
> form (or 
> > section). Most commands support FORMNAME.FORMFIELD naming to apply a 
> function 
> > but is there a WINDOW.FORMNAME.FORMFIELD naming scheme?
> > 
> > I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence 
> guide for 
> > pointers but I can't seem to find out what to use. It seem pretty 
> straight 
> > forward so I figure I must be missing something obvious... please 
> help.
> > 
> > Thanks,
> > Andy 
> > 
> > 


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Re: How would I go by doing this?

[Andy Chen]

Thanks you for the Javascript. That will work with a whole new Window - 
childWindow=open(file,window,'resizable=no,width=200,height=400') and not with 
the CFWindow tag. 

Using the script with CFWindow, I will get a Javascript (Object expected) error 
(tried it with parent and opener). 

I think it has to be controlled through AJAX. I tried the 
ColdFusion.getElementValue but it has to be within the same form (since it 
doesn't have a container parameter).

Any other ideas?


> The only way I know of doing what you've indicated below is to use a 
> JavaScript.
> 
> You can reference the "parent" or "opener" window by using the 
> "opener" keyword:
> opener.document.parentForm.pf1.value = document.childForm.cf1.value;
> 
> A good example of how to do this from a JavaScript can be seen here: 
> http://www.rgagnon.com/jsdetails/js-0066.html
> 
 
> -- Original message --
> From: "Andy Chen" <[EMAIL PROTECTED]>
> > Here's a situation:
> > 
> > Basically there is a form (CFFORM) which there are various fields. 
> One of the 
> > field would be a basic CFINPUT text field where an image ID can be 
> entered. The 
> > user will be able to click on a button to preview available images 
> (CFWINDOW). 
> > Whatever image they select in the Window (via radio button or drop 
> down), it 
> > will populate the main form with the value.
> > 
> > I can't figure out how to pass a variable from the Window back to 
> the parent 
> > form. To use some of the UI features, the Window will need to have a 
> CFFORM 
> > also. I tried binding but it would only work if it is in the same 
> form (or 
> > section). Most commands support FORMNAME.FORMFIELD naming to apply a 
> function 
> > but is there a WINDOW.FORMNAME.FORMFIELD naming scheme?
> > 
> > I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence 
> guide for 
> > pointers but I can't seem to find out what to use. It seem pretty 
> straight 
> > forward so I figure I must be missing something obvious... please 
> help.
> > 
> > Thanks,
> > Andy 
> > 
> > 


~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: How would I go by doing this?

[kcundick_list]

The only way I know of doing what you've indicated below is to use a JavaScript.

You can reference the "parent" or "opener" window by using the "opener" keyword:
opener.document.parentForm.pf1.value = document.childForm.cf1.value;

A good example of how to do this from a JavaScript can be seen here: 
http://www.rgagnon.com/jsdetails/js-0066.html

 -- Original message --
From: "Andy Chen" <[EMAIL PROTECTED]>
> Here's a situation:
> 
> Basically there is a form (CFFORM) which there are various fields. One of the 
> field would be a basic CFINPUT text field where an image ID can be entered. 
> The 
> user will be able to click on a button to preview available images 
> (CFWINDOW). 
> Whatever image they select in the Window (via radio button or drop down), it 
> will populate the main form with the value.
> 
> I can't figure out how to pass a variable from the Window back to the parent 
> form. To use some of the UI features, the Window will need to have a CFFORM 
> also. I tried binding but it would only work if it is in the same form (or 
> section). Most commands support FORMNAME.FORMFIELD naming to apply a function 
> but is there a WINDOW.FORMNAME.FORMFIELD naming scheme?
> 
> I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence guide for 
> pointers but I can't seem to find out what to use. It seem pretty straight 
> forward so I figure I must be missing something obvious... please help.
> 
> Thanks,
> Andy 
> 
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Re: any idea how to

[Ian Skinner]

Scott Stewart wrote:
> Convert 20060523
>
>  
>
> Into 5/23/2006
>
>  
>
> I'm at a loss.
>
>  
>
> Thanks in advance
>
>  
>
> sas
>
>  
>
>   
createDate(left('20060523'),mid('20060523',5,2),right('20060523')) is 
how I have done this in the past, you will probably want to use a 
variable here and there.



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: any idea how to

[Porter, Benjamin L.]

Using SQL

CONVERT(VARCHAR,CONVERT(DATETIME,'20060523'),101)

Using CF

Mid('20060523',5,2) & '/' & Right('20060523',2) & '/' &
Left('20060523',4)

-Original Message-
From: Loathe [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 11:10 AM
To: CF-Talk
Subject: RE: any idea how to

Date format?

Left, mid, right?

-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 12:05 PM
To: CF-Talk
Subject: any idea how to

Convert 20060523

 

Into 5/23/2006

 

I'm at a loss.

 

Thanks in advance

 

sas

 

-- 

Scott Stewart

ColdFusion Developer

 

SSTWebworks

4405 Oakshyre Way

Raleigh, NC. 27616

(703) 220-2835

 

http://www.sstwebworks.com

 
http://www.linkedin.com/in/sstwebworks

 

 







~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Re: any idea how to

[Jerry Johnson]

There is probably a trick i don't know, but something like...

dTemp=createODBCDate(mid(date,3,2)&right(date,2)&left(date,4))
sDate=dateFormat(dTemp,"m/d/")

On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> Convert 20060523
> Into 5/23/2006
> I'm at a loss.

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Re: any idea how to

[Crow T. Robot]

crude, but it works consistently:





#CreateDate(year,month,day)#

On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
>
> Convert 20060523
>
>
>
> Into 5/23/2006
>
>
>
> I'm at a loss.
>
>
>
> Thanks in advance
>
>
>
> sas
>
>
>
> --
>
> Scott Stewart
>
> ColdFusion Developer
>
>
>
> SSTWebworks
>
> 4405 Oakshyre Way
>
> Raleigh, NC. 27616
>
> (703) 220-2835
>
>
>
> http://www.sstwebworks.com
>
> 
> http://www.linkedin.com/in/sstwebworks
>
>
>
>
>
>
>
> 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: any idea how to

[Alan Rother]

LEFT MID AND RIGHT





=]

On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> Convert 20060523
>
>
>
> Into 5/23/2006
>
>
>
> I'm at a loss.
>
>
>
> Thanks in advance
>
>
>
> sas
>
>
>
> --
>
> Scott Stewart
>
> ColdFusion Developer
>
>
>
> SSTWebworks
>
> 4405 Oakshyre Way
>
> Raleigh, NC. 27616
>
> (703) 220-2835
>
>
>
> http://www.sstwebworks.com
>
>  
> http://www.linkedin.com/in/sstwebworks
>
>
>
>
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: any idea how to

[Loathe]

Date format?

Left, mid, right?

-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 12:05 PM
To: CF-Talk
Subject: any idea how to

Convert 20060523

 

Into 5/23/2006

 

I'm at a loss.

 

Thanks in advance

 

sas

 

-- 

Scott Stewart

ColdFusion Developer

 

SSTWebworks

4405 Oakshyre Way

Raleigh, NC. 27616

(703) 220-2835

 

http://www.sstwebworks.com

 
http://www.linkedin.com/in/sstwebworks

 

 





~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

any idea how to

[Scott Stewart]

Convert 20060523

 

Into 5/23/2006

 

I'm at a loss.

 

Thanks in advance

 

sas

 

-- 

Scott Stewart

ColdFusion Developer

 

SSTWebworks

4405 Oakshyre Way

Raleigh, NC. 27616

(703) 220-2835

 

http://www.sstwebworks.com

 
http://www.linkedin.com/in/sstwebworks

 

 



~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

How would I go by doing this?

[Andy Chen]

Here's a situation:

Basically there is a form (CFFORM) which there are various fields. One of the 
field would be a basic CFINPUT text field where an image ID can be entered. The 
user will be able to click on a button to preview available images (CFWINDOW). 
Whatever image they select in the Window (via radio button or drop down), it 
will populate the main form with the value.

I can't figure out how to pass a variable from the Window back to the parent 
form. To use some of the UI features, the Window will need to have a CFFORM 
also. I tried binding but it would only work if it is in the same form (or 
section). Most commands support FORMNAME.FORMFIELD naming to apply a function 
but is there a WINDOW.FORMNAME.FORMFIELD naming scheme?

I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence guide for 
pointers but I can't seem to find out what to use. It seem pretty straight 
forward so I figure I must be missing something obvious... please help.

Thanks,
Andy 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

DW8 download?

[Adkins, Randy]

Anyone have a link to the Dreamweaver 8 downloads? I need to get that
version. 
We have our own key for it just need to re-install.


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Re: One form with two submit buttons in <cflayoutarea>

[Andy Chen]

>So i did a test when I changed your cfform to post to test2.cfm, and
>dumped the form scope there, and I saw the same - it doesn't recognize
>the second button. I mean the button works, but the value is the same.
>
>
>> >

Yeah, experienced the same problem too. I used a CFDUMP var="#form#" and 
couldn't get the 2nd submit form field to show up. I am thinking it would need 
to be a button and use the Coldfusion.navigation tag to make it work. I posted 
another problem regarding that. 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285705
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 8 SW Maintenance Plan

[Rick Root]

Here at Duke, we got our CF8 subscription licenses last week.

Rick

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

Help with CFNavigate

[Andy Chen]

I am going to try it here since no one from the Adobe support forum knew...

Now maybe I am doing it wrong but with CFNavigate, it has the parameter for a 
"container" to refresh. What if I want the whole page to refresh with the form 
fields passed into it? Based on the CFML Reference Guide (pg 127) all I have to 
do is... "If you omit this argument, the link is treated as a normal URL and 
the entire page is refreshed."

So here's the basic thing I am trying to do... use CFLAYOUTAREA which has a 
form in it and I have a link which should pass the form variables from myform 
to the test_submit.cfm page. Here's the basic code I am using:

Submit
 it

If I leave the container field out of it... (no quotes), I get: Syntax Error.
If I enter a '' (no space), I get: Error replacing HTML, element not found.
If I enter a ' ' (with a space), I get the same error as above: Error replacing 
HTML, element not found.

Am I using it wrong? is there a _root or something I need to put in the 
container field for it to work?

Thanks,
Andy 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

Re: Eclipse/CFEclispe

[Dan Vega]

Well i only use aptana when I am editing .css, .js, .html. When I am editing
cfm or cfc I use CFEclipse of course!

Dan

On 8/8/07, Chad Gray <[EMAIL PROTECTED]> wrote:
>
> I tried aptana, but then I lost the ability to autocomplete CF tags... it
> was like I had to choose one or the other.  CSS or CF.. I could not get
> autocomplete to work for each language at the same time.
>
> Is there anyway for me to "upgrade" my eclipse so I get this "WTP all in
> one package" features???  Or do I have to re-install and loose all my custom
> keys and plugins?
>
>
>
>
>
> -Original Message-
> From: Loathe [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 10:44 AM
> To: CF-Talk
> Subject: RE: Eclipse/CFEclispe
>
> Look at Aptana.
>
> Best CSS and JS plugin around far as I am concerned.
>
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 10:40 AM
> To: CF-Talk
> Subject: RE: Eclipse/CFEclispe
>
> It does CSS?  I wonder which one I installed, because I have never gotten
> CSS and that is the missing link to get me off of Dreamweaver.
>
>
>
> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 10:14 AM
> To: CF-Talk
> Subject: Re: Eclipse/CFEclispe
>
> On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote:
> > that it. So, first which version of Eclipse should I install? There are
> > several on page http://www.eclipse.org/downloads/
>
> 'WTP all in one' from
>
> http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303
> /
> It has a few extra bits like CSS and HTML editing and CFEclipse will drop
> right in.
>
> --
> Tom Chiverton
>
> 
>
> 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.
>
>
>
>
>
>
>
>
> 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: Eclipse/CFEclispe

[Tom Chiverton]

On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote:
> Is there anyway for me to "upgrade" my eclipse so I get this "WTP all in
> one package" features???  Or do I have to re­install and loose all my
> custom keys and plugins?

Just add the WTP URL to your plugin finder.
If you have Eclipse 3.3, it should be findable already.


-- 
Tom Chiverton



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.


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Re: Eclipse/CFEclispe

[Dan Vega]

You can also look at Aptana, I use that plugin and it has a lot of nice
features.

http://www.aptana.org

On 8/8/07, Dawson, Michael <[EMAIL PROTECTED]> wrote:
>
> Yeah, that's a good question.
>
> I have the WTP build, but I don't really see any other features, such as
> CSS, when I'm editing .css files or even styles within an HTML page.
>
> M!ke
>
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 08, 2007 9:40 AM
> To: CF-Talk
> Subject: RE: Eclipse/CFEclispe
>
> It does CSS?  I wonder which one I installed, because I have never
> gotten CSS and that is the missing link to get me off of Dreamweaver.
>
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: Eclipse/CFEclispe

[Chad Gray]

I tried aptana, but then I lost the ability to autocomplete CF tags... it was 
like I had to choose one or the other.  CSS or CF.. I could not get 
autocomplete to work for each language at the same time.

Is there anyway for me to "upgrade" my eclipse so I get this "WTP all in one 
package" features???  Or do I have to re-install and loose all my custom keys 
and plugins?





-Original Message-
From: Loathe [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 10:44 AM
To: CF-Talk
Subject: RE: Eclipse/CFEclispe

Look at Aptana.

Best CSS and JS plugin around far as I am concerned.

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 10:40 AM
To: CF-Talk
Subject: RE: Eclipse/CFEclispe

It does CSS?  I wonder which one I installed, because I have never gotten
CSS and that is the missing link to get me off of Dreamweaver.



-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 10:14 AM
To: CF-Talk
Subject: Re: Eclipse/CFEclispe

On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote:
> that it. So, first which version of Eclipse should I install? There are
> several on page http://www.eclipse.org/downloads/

'WTP all in one' from 
http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303
/
It has a few extra bits like CSS and HTML editing and CFEclipse will drop 
right in.

-- 
Tom Chiverton



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.








~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

RE: Eclipse/CFEclispe

[Loathe]

Look at Aptana.

Best CSS and JS plugin around far as I am concerned.

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 10:40 AM
To: CF-Talk
Subject: RE: Eclipse/CFEclispe

It does CSS?  I wonder which one I installed, because I have never gotten
CSS and that is the missing link to get me off of Dreamweaver.



-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 10:14 AM
To: CF-Talk
Subject: Re: Eclipse/CFEclispe

On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote:
> that it. So, first which version of Eclipse should I install? There are
> several on page http://www.eclipse.org/downloads/

'WTP all in one' from 
http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303
/
It has a few extra bits like CSS and HTML editing and CFEclipse will drop 
right in.

-- 
Tom Chiverton



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.






~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: Eclipse/CFEclispe

[Dawson, Michael]

Yeah, that's a good question.

I have the WTP build, but I don't really see any other features, such as
CSS, when I'm editing .css files or even styles within an HTML page.

M!ke 

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 9:40 AM
To: CF-Talk
Subject: RE: Eclipse/CFEclispe

It does CSS?  I wonder which one I installed, because I have never
gotten CSS and that is the missing link to get me off of Dreamweaver.

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: Eclipse/CFEclispe

[Chad Gray]

It does CSS?  I wonder which one I installed, because I have never gotten CSS 
and that is the missing link to get me off of Dreamweaver.



-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 10:14 AM
To: CF-Talk
Subject: Re: Eclipse/CFEclispe

On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote:
> that it. So, first which version of Eclipse should I install? There are
> several on page http://www.eclipse.org/downloads/

'WTP all in one' from 
http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303/
It has a few extra bits like CSS and HTML editing and CFEclipse will drop 
right in.

-- 
Tom Chiverton



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.




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: Eclipse/CFEclispe

[Robert Harrison]

Thank You. I'll give it a try... downloading now! 

I'm figuring since I have a new kick-butt machine and I still have my old
machine and environment, I'm going bleeding edge on the new one. 

IIS7, CF8, SQL Server 2005, CFECLISPE, etc. Why not for once be on the lead?
Normally I wouldn't try that so boldly but my development platform is still
intact on the old machine and production won't be in jeopardy. Keep your
fingers crossed. So far I've gotten through the glitches as they've shown
themselves.

Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be &.




~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Re: ColdFusion 8 cfgrid and formatting

[Dan Vega]

Thanks for the reply Bhakti!

Dan

On 8/8/07, Bhakti Pingale <[EMAIL PROTECTED]> wrote:
>
> Sorry for the late reply.
> Yes, the mask attribute applies only if format is flash. If you want to
> format the data in an html grid, you will have to write your query
> accordingly so that it returns the date in the required format.
> This was specifically for the date.
> However we can take this up as an enhancement. I shall file it for you.
> Thanks for the inputs. If you have any doubts feel free to ask
>
> Regards,
> Bhakti
> Adobe ColdFusion team
>
> -Original Message-
> From: Dan Vega [mailto:[EMAIL PROTECTED]
> Sent: Sunday, August 05, 2007 11:25 PM
> To: CF-Talk
> Subject: ColdFusion 8 cfgrid and formatting
>
> I am having a hard time finding an answer to this riddle so maybe
> someone
> here can help. I have a grid with columns show below. The livedocs say
> the
> mask attribute for cfgridcolumn is only used in when the format is
> flash. If
> this is correct then how do i format data in html? This would not just
> be
> dates but really any data, does anyone know how to format data?
>
> 
>  autowidth="true" pagesize="30" bgcolor="black" textcolor="white"
> bind="cfc:clients.getClients
> ({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})
> ">
> 
> 
> 
> 
>  mask="[MM/DD/]">
> 
> 
> 
> 
> 
>
> --
> Thank You
> Dan Vega
> [EMAIL PROTECTED]
> http://www.danvega.org
>
>
>
>
> 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: ColdFusion 8 cfgrid and formatting

[Bhakti Pingale]

Sorry for the late reply.
Yes, the mask attribute applies only if format is flash. If you want to
format the data in an html grid, you will have to write your query
accordingly so that it returns the date in the required format.
This was specifically for the date.
However we can take this up as an enhancement. I shall file it for you.
Thanks for the inputs. If you have any doubts feel free to ask

Regards,
Bhakti
Adobe ColdFusion team

-Original Message-
From: Dan Vega [mailto:[EMAIL PROTECTED] 
Sent: Sunday, August 05, 2007 11:25 PM
To: CF-Talk
Subject: ColdFusion 8 cfgrid and formatting

I am having a hard time finding an answer to this riddle so maybe
someone
here can help. I have a grid with columns show below. The livedocs say
the
mask attribute for cfgridcolumn is only used in when the format is
flash. If
this is correct then how do i format data in html? This would not just
be
dates but really any data, does anyone know how to format data?














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




~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: Eclipse/CFEclispe

[Tom Chiverton]

On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote:
> that it. So, first which version of Eclipse should I install? There are
> several on page http://www.eclipse.org/downloads/

'WTP all in one' from 
http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303/
It has a few extra bits like CSS and HTML editing and CFEclipse will drop 
right in.

-- 
Tom Chiverton



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.


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285692
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 8 SW Maintenance Plan

[Andy Matthews]

We bought licenses for 7 a few months ago with subscription. We just got our
8 licenses a few days ago, last week maybe? 

-Original Message-
From: Howell, Craig H Civ WRALC/ITMS [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 8:35 AM
To: CF-Talk
Subject: SOT: CF 8 SW Maintenance Plan

Just a quick survey..has anyone with an Adobe SW Maintenance Plan
received an upgrade coupon/code or key for CF 8?



~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: ColdFusion 8 & CachedWithin Issue

[Adrian Lynch]

Have you managed to get the SQL statement that runs when it falls over? What
does it look like?

Adrian

-Original Message-
From: Jason Fill
Sent: 08 August 2007 15:26
To: CF-Talk
Subject: ColdFusion 8 & CachedWithin Issue


I am getting very strange behaviors while using CachedWithin on CF8.  All
the sudden, something that has been working without fail for months in CF7
is giving odd errors.  On CF8 I will get intermittent errors that say
"corrupt table null". If I remove the cachedwithin attribute the query runs
fine.  For example, I can pass in the state argument of AL and it works
fine, but when I pass in CO it blows up.  Any thoughts?


SELECT  State,StateName,Country,TimeZone,BorderingStates
FROMdbo.States
WHERE   0=0

AND State = '#trim(Arguments.State)#'


AND TimeZone = '#trim(Arguments.TimeZone)#'


AND Country NOT IN ('#trim(Arguments.ExcludeCountries)#')

ORDER BY #trim(Arguments.OrderBy)#



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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