RE: Measuring bandwidth used per user

2010-02-01 Thread brad

> is it possible to measure how many times an attachment was succesfully 
> accessed (either opened in browser or downloaded)?

If you serve up the files via a .cfm template and cfcontent, you can log
every time they download something.  That won't detect if they cancel
the download though.

~Brad



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330330
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Measuring bandwidth used per user

2010-02-01 Thread derekf

Greetings everybody.

I have a website that allows people to upload and access attachments.

 Naturally they need to access these once uploaded. I need to measure bandwidth 
used because this is how I charge. Uploading is fine to measure, but is it 
possible to measure how many times an attachment was succesfully accessed 
(either opened in browser or downloaded)?

Cheers
Derek
Sent via my BlackBerry from Vodacom - let your email find you!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330329
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfmapitem

2010-02-01 Thread Paul Hastings

On 2/2/2010 6:46 AM, Tim Do wrote:
> The value of the CENTERLONGITUDE attribute is invalid. The value specified, 
> -117.8529534, must be greater than -90.0.

sure you didn't swap latitude (y) & longitude (x)? latitudes range from +90 (N) 
to -90 (S) degrees. google maps functions usually want lat,long (that is y,x). 
to this day, that always trips me up.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330328
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


ColdFusion reports and currency symbols

2010-02-01 Thread Andrew Scott

I am tryng to figure out why, all other currency symbols work in a report
generated with Report Builder, except the Yen.

I thought it might be a font problem, but seem to have had no luck.

Anyone know what is needed when using lscurrencyformat and reports, all
currencies are fine if done to the browser via html.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330327
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: DatePart Function Missing

2010-02-01 Thread Will Swain

MySQL has a Year() function which would achieve what you want by the looks
of it:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function
_year

Will

-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: 02 February 2010 02:30
To: cf-talk
Subject: Re: DatePart Function Missing


In the sample you posted, DatePart() is not surrounded by hashes (#).  This
means that you are calling the database's DatePart() function.  Apparently
MySQL does not have such a function, which is why you are receiving the
error message.  (I do not use MySQL, so you'd have to check their
documentation to find the appropriate function(s) to use.)

Conversely, if the code is actually #DatePart()#, then you would be calling
a CF function.




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330326
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: DatePart Function Missing

2010-02-01 Thread Matt Quackenbush

In the sample you posted, DatePart() is not surrounded by hashes (#).  This
means that you are calling the database's DatePart() function.  Apparently
MySQL does not have such a function, which is why you are receiving the
error message.  (I do not use MySQL, so you'd have to check their
documentation to find the appropriate function(s) to use.)

Conversely, if the code is actually #DatePart()#, then you would be calling
a CF function.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330325
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: DatePart Function Missing

2010-02-01 Thread Chad Veldhouse

>I think you may be missing some pound symbols as I am not aware that  
>MySql has a datepart function.
>
>Cheers,
>Dan
>
>On Feb 1, 2010, at 6:44 PM, Chad Veldhouse   
>wrote:
>
>>

Maybe I am mis-understanding the functions. Is DatePart a function of MS 
Access? Is that why it wont work?
If I use "Extract" it works. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330324
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: DatePart Function Missing

2010-02-01 Thread Chad Veldhouse

>I think you may be missing some pound symbols as I am not aware that  
>MySql has a datepart function.
>
>Cheers,
>Dan
>
>On Feb 1, 2010, at 6:44 PM, Chad Veldhouse   
>wrote:
>
>>I may be misunderstanding you but the DatePart is a ColdFusion function (I 
>>believe)?. I copied the code from another working cfm.doc that is working on 
>>CFMX6 & Windows with MS Access. I changed the variables but that is it. Am I 
>>missing something? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330323
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: DatePart Function Missing

2010-02-01 Thread Daniel Baughman

I think you may be missing some pound symbols as I am not aware that  
MySql has a datepart function.

Cheers,
Dan

On Feb 1, 2010, at 6:44 PM, Chad Veldhouse   
wrote:

>
> I am working on a simple query using DatePart.
> I am running CF9 on a Mac with MySQL.
>
> The code looks like this:
> 
> SELECT SoldID, LeadID, AgentID, ProfileID, FirstName, LastName,  
> Price, Viewed, SoldDate
> FROM SoldLeads
> Where AgentID = #Session.AgentID# AND DatePart("",SoldDate) 
> ='#SearchYear#'
> 
>
> The code responds with "FUNCTION Data.DatePart does not exist ".  
> Very similar code works with CFMX6 & Access on a Windows machine.
> I have tried DatePart(,SoldDate)-'#SearchYear#' & atePart 
> ('',SoldDate)-'#SearchYear#'.
> Nothing seems to work.
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330322
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


DatePart Function Missing

2010-02-01 Thread Chad Veldhouse

I am working on a simple query using DatePart. 
I am running CF9 on a Mac with MySQL. 

The code looks like this:

SELECT SoldID, LeadID, AgentID, ProfileID, FirstName, LastName, Price, Viewed, 
SoldDate
FROM SoldLeads
Where AgentID = #Session.AgentID# AND DatePart("",SoldDate)='#SearchYear#'


The code responds with "FUNCTION Data.DatePart does not exist ". Very similar 
code works with CFMX6 & Access on a Windows machine.
I have tried DatePart(,SoldDate)-'#SearchYear#' & 
atePart('',SoldDate)-'#SearchYear#'.
Nothing seems to work. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330321
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfmapitem

2010-02-01 Thread Raymond Camden

According to Google, longitude goes from -180 to 180, so. that
seems wrong. :) I'd check for something else wrong.

On Mon, Feb 1, 2010 at 5:46 PM, Tim Do  wrote:
>
> ah, you're right!  thanks!
>
> so I went and geocoded all the records, now I'm seeing this message often...
>
> The value of the CENTERLONGITUDE attribute is invalid. The value specified, 
> -117.8529534, must be greater than -90.0.
>
> did the geocoder do it incorrectly??
>
>
>
> -Original Message-
> From: Raymond Camden [mailto:rcam...@gmail.com]
> Sent: Monday, February 01, 2010 1:03 PM
> To: cf-talk
> Subject: Re: cfmapitem
>
>
> Are you sure it is bad addresses? If you use too many, Google will
> block you for trying to geolocate too much. See this blog entry:
>
> http://www.coldfusionjedi.com/index.cfm/2009/12/15/Having-trouble-with-too-many-map-markers-and-CFMAP
>
>
> On Mon, Feb 1, 2010 at 2:59 PM, Tim Do  wrote:
>>
>> I'm looping through a query with addresses, some good some not so good.  
>> When I try to to map all the points, the bad addresses prompt that it can't 
>> be mapped.  I'm using  addresses instead of lat/lons so I can't really check 
>> to see if they're valid.  I'm trying not to geocode all the records and 
>> maintain it.  How do I have the bad address prompt not show??
>>
>> Thanks!
>> Tim
>>
>>
>>
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330320
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfmapitem

2010-02-01 Thread Tim Do

ah, you're right!  thanks!

so I went and geocoded all the records, now I'm seeing this message often...

The value of the CENTERLONGITUDE attribute is invalid. The value specified, 
-117.8529534, must be greater than -90.0.

did the geocoder do it incorrectly??



-Original Message-
From: Raymond Camden [mailto:rcam...@gmail.com] 
Sent: Monday, February 01, 2010 1:03 PM
To: cf-talk
Subject: Re: cfmapitem


Are you sure it is bad addresses? If you use too many, Google will
block you for trying to geolocate too much. See this blog entry:

http://www.coldfusionjedi.com/index.cfm/2009/12/15/Having-trouble-with-too-many-map-markers-and-CFMAP


On Mon, Feb 1, 2010 at 2:59 PM, Tim Do  wrote:
>
> I'm looping through a query with addresses, some good some not so good.  When 
> I try to to map all the points, the bad addresses prompt that it can't be 
> mapped.  I'm using  addresses instead of lat/lons so I can't really check to 
> see if they're valid.  I'm trying not to geocode all the records and maintain 
> it.  How do I have the bad address prompt not show??
>
> Thanks!
> Tim
>
>
> 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330319
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Link test.

2010-02-01 Thread Maureen

Mozilla 3.5.7 - Windows XP - JS displays on screen in browser.

On Mon, Feb 1, 2010 at 7:52 AM, Ian Skinner  wrote:
>
> Can a few of you out there in CF-Talk land test this link and tell me if
> you get the expect JavaScript file or something else?
>
> http://apps.cdpr.ca.gov/cfscripts/cfform.js

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330318
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


REReplaceNoCase and dynamic query columns

2010-02-01 Thread Andy Matthews

I have a query containing multiple columns (30 or so). It's always a single
record.

I have a string which contains a key, wrapped in double %% symbols, that
needs to be replace with the value of the same key from the query. For
example, the string might have %%color%% which would correspond the color
column from the query. I'm trying to use REReplaceNoCase to find the key,
and replace it with the value. It "almost" works, but I can't seem to get it
the last 5%. Here's some sample code 



















Is it possible to do this in one line? I'm SO close, but it's just not
working. Is it possible to dynamically evaluate the temp variable from the
regular expression and use it as a ColdFusion variable?



Andy matthews



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330317
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfmapitem

2010-02-01 Thread Raymond Camden

Are you sure it is bad addresses? If you use too many, Google will
block you for trying to geolocate too much. See this blog entry:

http://www.coldfusionjedi.com/index.cfm/2009/12/15/Having-trouble-with-too-many-map-markers-and-CFMAP


On Mon, Feb 1, 2010 at 2:59 PM, Tim Do  wrote:
>
> I'm looping through a query with addresses, some good some not so good.  When 
> I try to to map all the points, the bad addresses prompt that it can't be 
> mapped.  I'm using  addresses instead of lat/lons so I can't really check to 
> see if they're valid.  I'm trying not to geocode all the records and maintain 
> it.  How do I have the bad address prompt not show??
>
> Thanks!
> Tim
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330316
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfmapitem

2010-02-01 Thread Tim Do

I'm looping through a query with addresses, some good some not so good.  When I 
try to to map all the points, the bad addresses prompt that it can't be mapped. 
 I'm using  addresses instead of lat/lons so I can't really check to see if 
they're valid.  I'm trying not to geocode all the records and maintain it.  How 
do I have the bad address prompt not show??

Thanks!
Tim


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330315
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Leigh

> I'm just curious: don't you need to separate the statements
> with semicolons?

I do not think it is technically required with SQL Server. Though it may be in 
the ANSI specs. In which case, it is probably not a bad idea to use them. 


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330314
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Sean Corfield

I'm just curious: don't you need to separate the statements with
semicolons? I've never seen multiple SQL statements without semicolons
before.

As others have noted tho', this behavior is driver-specific anyway...

Sean

On Mon, Feb 1, 2010 at 4:29 AM, Dominic Watson
 wrote:
>
> I recently switched to using the latest Microsoft JDBC Driver for MSSQL 2005
> and immediately saw a performance increase (over using the standard driver
> w/ ColdFusion 8.01). However, all our queries that have multiple statements
> are failing so I've had to switch back. e.g.
>
> 
>  UPDATE foo SET bar = 1
>
>  SELECT bar FROM foo
> 
>
> With the standard built in driver I can reference my-query.bar, with the MS
> JDBC Driver I cannot (get a 'bar is undefined in my-query' error).
>
> Has anyone experienced this? Is there a way to enable multiple statements
> using the jdbc driver? I've checked this page out and couldn't see anything
> that fit the bill:
>
> http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_11.html
>
> TIA
>
> Dominic

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330313
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Leigh

> Yup, spot on Leigh, they're not working right with the jDTS
> driver either :O

Ugh. Is this with CF8 or CF9? A lot of the weirdness I saw in CF8 had to do 
with INSERT/VALUES statements in particular, due to the generated keys feature 
of the "result" attribute. 

http://www.mischefamily.com/nathan/index.cfm/2008/1/28/Problems-with-CF-8s-Generated-Keys-Feature

I am not sure if anything has changed in CF9. But if you are modifying the code 
anyway, you might want to experiment a little. Try using the result attribute, 
cfqueryparam, etcetera and see what works best and is the cleanest code.


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330312
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Link test.

2010-02-01 Thread Ian Skinner

>I believe you need a Deny All in there.

Actually not, because we don't want this directory denied.  But that was the 
block of code I inherited, and I wanted to understand how it was working before 
I monkeyed with it.

We actually do want to allow all on that particular directory, so I rewrote the 
block to clearly state that is what we are asking. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330311
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Link test.

2010-02-01 Thread Matt Quackenbush

I believe you need a Deny All in there.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330310
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Link test.

2010-02-01 Thread Ian Skinner

> 
> Order deny,allow
> Allow from .apps.cdpr.ca.gov
> 

To answer my own question -- I think>  Upon a third and forth reading of the 
documentation I think I understand what is happening here, which is basically 
nothing.

Order deny, allow 
This says process all deny directives then process all allow directives and 
then allow anybody who is not covered by either of them.

Allow from .apps.cdpr.ca.gov.  
If you are from the apps.cdpr.ca.gov domain you are allowed in.

There are *no* deny directives so nobody is denied.

Everybody left (which is everybody) are allowed in.



This is actually what we want for this directory, but I think I will rewrite 
this  block to make it a bit clearer that this is the desired 
result.

Thanks for listening
Ian



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330309
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: var scoping cfscript in a CFC

2010-02-01 Thread Chad Gray

Sure, that would read better.

Thanks!


-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Monday, February 01, 2010 11:54 AM
To: cf-talk
Subject: Re: var scoping cfscript in a CFC


Why wouldn't you simply do...


 var foo = "bar";


?

But yes, you still have to var scope them.

Sent from my iPhone



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330308
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: var scoping cfscript in a CFC

2010-02-01 Thread Matt Quackenbush

Why wouldn't you simply do...


 var foo = "bar";


?

But yes, you still have to var scope them.

Sent from my iPhone

On Feb 1, 2010, at 10:46, "Chad Gray"  wrote:

>
> When putting cfscript in a CFC function do you need to use  var foo = ""> on variables created in the cfscript?
>
> Thanks,
> Chad
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330307
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


var scoping cfscript in a CFC

2010-02-01 Thread Chad Gray

When putting cfscript in a CFC function do you need to use  
on variables created in the cfscript?

Thanks,
Chad


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330306
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Link test.

2010-02-01 Thread Ian Skinner

>
>I got it.
>
>Dave Watts, CTO, Fig Leaf Software

Thanks everybody who checked.  It is good that you got the file, but I am 
curious.

Would those of you who are experienced with Apache httpd.conf configurations 
have expected to have successfully connected with this Directory block.


  Order deny,allow
  Allow from .apps.cdpr.ca.gov


>From my reading of the Apache documentation for the Order, Allow, and Deny 
>directives, I would have expected that this Directory block would only allow 
>users from the apps.cdpr.ca.gov domain to connect.  

But apparently that is not what is happening.  Unless all of you who tested 
this are somehow working from our building today? :-P 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330305
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Dominic Watson

Yup, spot on Leigh, they're not working right with the jDTS driver either :O

Wrapping the whole statement with BEGIN .. END, or indeed SET NOCOUNT ON/OFF
does make them work though. Looks like I'm going to have to bite the bullet
and get coding; the performance issues with the default CF driver are too
big to ignore, unfortunately.

Thanks

Dominic

On 1 February 2010 15:03, Leigh  wrote:

>
> You may also want to check for multiple queries with @@IDENTITY and
> SCOPE_IDENTITY(). I remember seeing very different (and sometimes bizarre)
> results with CF8 across the different drivers.
>
>


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330304
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Link test.

2010-02-01 Thread Dave Watts

> Can a few of you out there in CF-Talk land test this link and tell me if
> you get the expect JavaScript file or something else?
>
> http://apps.cdpr.ca.gov/cfscripts/cfform.js

I got it.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330303
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Link test.

2010-02-01 Thread Scott Stewart

File download prompt

-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com] 
Sent: Monday, February 01, 2010 10:52 AM
To: cf-talk
Subject: Link test.


Can a few of you out there in CF-Talk land test this link and tell me if 
you get the expect JavaScript file or something else?

http://apps.cdpr.ca.gov/cfscripts/cfform.js





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330302
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Link test.

2010-02-01 Thread DURETTE, STEVEN J (ATTASIAIT)

JS file downloaded for me.


-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com] 
Sent: Monday, February 01, 2010 10:52 AM
To: cf-talk
Subject: Link test.


Can a few of you out there in CF-Talk land test this link and tell me if

you get the expect JavaScript file or something else?

http://apps.cdpr.ca.gov/cfscripts/cfform.js





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Link test.

2010-02-01 Thread Ian Skinner

Can a few of you out there in CF-Talk land test this link and tell me if 
you get the expect JavaScript file or something else?

http://apps.cdpr.ca.gov/cfscripts/cfform.js



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330300
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Will Tomlinson

> I recently switched to using the latest Microsoft JDBC Driver for 
> MSSQL 2005
> and immediately saw a performance increase (over using the standard 
> driver
> w/ ColdFusion 8.01). However, all our queries that have multiple 
> statements
> are failing so I've had to switch back. e.g.

I know with MySQL, you can specify multiple queries right in your DSN setting. 

http://www.bennadel.com/blog/1542-MySQL-3-4-com-mysql-jdbc-Driver-And-allowMultiQueries-true.htm

I don't know if there's an equivalent for the SQL Server driver. 

Will 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330299
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Leigh

> affected queries in our rather sprawling legacy application
> (getting less sprawled by the day) 

I hear you. For a legacy application, it is probably not worth the trouble to 
make all those changes. 

You may also want to check for multiple queries with @@IDENTITY and 
SCOPE_IDENTITY(). I remember seeing very different (and sometimes bizarre) 
results with CF8 across the different drivers.

-Leigh


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330298
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 Advanced Status?

2010-02-01 Thread Eric Cobb

I believe you're right, they supposedly did away with the "advanced" CF 
8 certification.  Now you're either certified or you're not, no 
distinction between "certified" and "advanced certified".

Thanks,

Eric Cobb
http://www.cfgears.com



Azadi Saryev wrote:
> didn't they drop the 'advanced' distinction in cf8 certification?
> i recall reading something like that a while ago... but i may be wrong.
>
> Azadi Saryev
>
>
>
> On 01/02/2010 12:00, Qing Xia wrote:
>   
>> Yeah, for CF7 it was 85% and 80% for CF6... but now I can't find what it is
>> for CF8.
>>
>> On Sun, Jan 31, 2010 at 10:55 PM, lists  wrote:
>>
>>   
>> 
>>> In the past it's been 85% I believe.
>>>
>>> -Original Message-
>>> From: Qing Xia [mailto:txiasum...@gmail.com]
>>> Sent: Sunday, January 31, 2010 9:18 PM
>>> To: cf-talk
>>> Subject: CF8 Advanced Status?
>>>
>>>
>>> Does anyone know what the % score needed to get the "Advanced Certified
>>> Status" in CF8 is? I went searching for it (high and low!) but no dice.
>>>
>>> Hmm, maybe the Pentagon needs to hire Adobe to guard its papers.
>>>
>>>
>>>
>>>
>>>
>>> 
>>>   
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330297
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Dominic Watson

Right, and thanks for the response btw. The main trouble is that we could
not afford the time to be checking through and changing all the possibly
affected queries in our rather sprawling legacy application (getting less
sprawled by the day) - the jTDC driver gives us the needed performance
improvement without having to touch our code. It wouldn't seem right either,
given that the SQL syntax was correct, to be editing all those queries to
work with the MS driver.

Dominic

On 1 February 2010 14:27, Leigh _  wrote:

>
> >It appears to be a limitation of the M$ jdbc driver.
>
> I do not know that it is a limitation of the driver.  From everything I
> have read, I have always felt it was due to CF's handling of multiple
> statements within cfquery, and the whole one query/resultset limitation.
> Though I prefer procedures, I have definitely used multiple statements
> within cfquery + the MS driver in the past (usually with SET NOCOUNT ON/OFF)
> .
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330296
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Leigh _

>It appears to be a limitation of the M$ jdbc driver. 

I do not know that it is a limitation of the driver.  From everything I have 
read, I have always felt it was due to CF's handling of multiple statements 
within cfquery, and the whole one query/resultset limitation. Though I prefer 
procedures, I have definitely used multiple statements within cfquery + the MS 
driver in the past (usually with SET NOCOUNT ON/OFF) .

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330295
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Dominic Watson

It appears to be a limitation of the M$ jdbc driver. Now using the jTDS
driver and all works well and with the same performance improvements
(specifically, reduced memory usage). Hoorah for OSS!


Dominic

On 1 February 2010 13:23, Leigh  wrote:

>
> > 
> >  UPDATE foo SET bar = 1
> >
> >  SELECT bar FROM foo
> > 
>
> Any difference if you surround the entire block with a SET NOCOUNT ON/OFF?
>
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330294
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Leigh

> 
>  UPDATE foo SET bar = 1
> 
>  SELECT bar FROM foo
> 

Any difference if you surround the entire block with a SET NOCOUNT ON/OFF?


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330293
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Microsoft JDBC Driver: Multiple SQL statements

2010-02-01 Thread Dominic Watson

I recently switched to using the latest Microsoft JDBC Driver for MSSQL 2005
and immediately saw a performance increase (over using the standard driver
w/ ColdFusion 8.01). However, all our queries that have multiple statements
are failing so I've had to switch back. e.g.


 UPDATE foo SET bar = 1

 SELECT bar FROM foo


With the standard built in driver I can reference my-query.bar, with the MS
JDBC Driver I cannot (get a 'bar is undefined in my-query' error).

Has anyone experienced this? Is there a way to enable multiple statements
using the jdbc driver? I've checked this page out and couldn't see anything
that fit the bill:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_11.html

TIA

Dominic


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330292
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4