Microsoft JDBC Driver: Multiple SQL statements
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. cfquery datasource=my-datasource name=my-query UPDATE foo SET bar = 1 SELECT bar FROM foo /cfquery 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
Re: Microsoft JDBC Driver: Multiple SQL statements
cfquery datasource=my-datasource name=my-query UPDATE foo SET bar = 1 SELECT bar FROM foo /cfquery 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
Re: Microsoft JDBC Driver: Multiple SQL statements
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 cfsearch...@yahoo.com wrote: cfquery datasource=my-datasource name=my-query UPDATE foo SET bar = 1 SELECT bar FROM foo /cfquery 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
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
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 _ cfsearch...@yahoo.com 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: CF8 Advanced Status?
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 li...@commadelimited.com 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
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: Microsoft JDBC Driver: Multiple SQL statements
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
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: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: Link test.
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
RE: Link test.
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.
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: Microsoft JDBC Driver: Multiple SQL statements
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 cfsearch...@yahoo.com 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.
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. Directory /export/home/path/to/our/cfide/scripts Order deny,allow Allow from .apps.cdpr.ca.gov /Directory 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
var scoping cfscript in a CFC
When putting cfscript in a CFC function do you need to use cfset 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: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: var scoping cfscript in a CFC
Why wouldn't you simply do... cfscript var foo = bar; /cfscript ? But yes, you still have to var scope them. Sent from my iPhone On Feb 1, 2010, at 10:46, Chad Gray cg...@careyweb.com wrote: When putting cfscript in a CFC function do you need to use cfset 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
RE: var scoping cfscript in a CFC
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... cfscript var foo = bar; /cfscript ? 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: Link test.
Directory /export/home/path/to/our/cfide/scripts Order deny,allow Allow from .apps.cdpr.ca.gov /Directory 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 directory ... 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: Link test.
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.
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: Microsoft JDBC Driver: Multiple SQL statements
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: Microsoft JDBC Driver: Multiple SQL statements
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 watson.domi...@googlemail.com 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. cfquery datasource=my-datasource name=my-query UPDATE foo SET bar = 1 SELECT bar FROM foo /cfquery 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
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
cfmapitem
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: 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 t...@wng.com 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
REReplaceNoCase and dynamic query columns
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
!--- sample query ---
cfset REQUEST.myQ = QueryNew('vin,color')
cfset QueryAddRow(REQUEST.myQ, 1)
cfset QuerySetCell(REQUEST.myQ, 'vin', '1GNFC13C47J338994', 1)
cfset QuerySetCell(REQUEST.myQ, 'color', 'Blue', 1)
!--- the URL string ---
cfset REQUEST.theURL = 'http://www.mydomain.com/mq.p?a=spvin=%%VIN%%'
!--- correctly replaces %%VIN%% from the string, with just VIN---
cfset REQUEST.final = REReplaceNoCase(REQUEST.theURL, '%%(\w+)%%', \1,
'ALL')
!--- correctly replaces %%VIN%% with the value of VIN from the query---
cfset REQUEST.final = REReplaceNoCase(REQUEST.theURL, '%%(\w+)%%',
#REQUEST.myQ['VIN'][1]#, 'ALL')
!--- fails, with a Missing argument name error ---
cfset REQUEST.final = REReplaceNoCase(REQUEST.theURL, '%%(\w+)%%',
#REQUEST.myQ[/\1][1]#, 'ALL')
cfdump var=#REQUEST#
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: Link test.
Mozilla 3.5.7 - Windows XP - JS displays on screen in browser. On Mon, Feb 1, 2010 at 7:52 AM, Ian Skinner h...@ilsweb.com 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
RE: cfmapitem
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 t...@wng.com 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: cfmapitem
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 t...@wng.com 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 t...@wng.com 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
DatePart Function Missing
I am working on a simple query using DatePart.
I am running CF9 on a Mac with MySQL.
The code looks like this:
CFQUERY name=GetAgentLeads datasource=#Application.Data#
SELECT SoldID, LeadID, AgentID, ProfileID, FirstName, LastName, Price, Viewed,
SoldDate
FROM SoldLeads
Where AgentID = #Session.AgentID# AND DatePart(,SoldDate)='#SearchYear#'
/CFQUERY
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: DatePart Function Missing
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 cveldho...@vaagency.com
wrote:
I am working on a simple query using DatePart.
I am running CF9 on a Mac with MySQL.
The code looks like this:
CFQUERY name=GetAgentLeads datasource=#Application.Data#
SELECT SoldID, LeadID, AgentID, ProfileID, FirstName, LastName,
Price, Viewed, SoldDate
FROM SoldLeads
Where AgentID = #Session.AgentID# AND DatePart(,SoldDate)
='#SearchYear#'
/CFQUERY
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
Re: DatePart Function Missing
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 cveldho...@vaagency.com 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
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 cveldho...@vaagency.com 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
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
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
ColdFusion reports and currency symbols
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: cfmapitem
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
Measuring bandwidth used per user
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: Measuring bandwidth used per user
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
