[cfaussie] Re: refindnocase - trouble returning array
reFindNoCase() only returns the first match; it does not return an array of all matches. When you pass the returnsubexpressions=true argument, it does what it says on the box: it returns an array of any subexpressions *of the regex*. http://livedocs.adobe.com/coldfusion/7/htmldocs/0607.htm Java regexes work the same way (not surprising as CF regex are just wrapped up Java ones). http://java.sun.com/j2se/1.4.2/docs/api/java/util/regex/Matcher.html You'll need to do the looping approach as suggested, or a regex replace of *everything else* in the string that doesn't match your requirements. -- Adam --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] @#$!! queryparam
I think its to do with the binding or the caching of the query plan but when we change a table in the DB, like remove a column or change the length of a varchar, all the queries that use that table and have a queryparam break. We get messages like [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. on queries as simple as a Select * from table where id = cfqueryparam cfsqltype=cf_sql_integer value=#id# and we didnt even change the id column (obviously) At the moment the only way we can find of making it all work again is to remove all the params or to restart cf or sql. All of which are bad in their own way even though its only on the dev box. Strangely I havent come across this before, previous installations havent had this, but I have just moved to inherit some software and dev boxes and I cant work out why this is going on. All the settings in the cfadmin db connection are the defaults. Anyone else have this problem / have a solution? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
Duncan, The query is only cached when you tell it to be cached. But are you using any other framework like reactor or transfer or even MG:U, or even have this in a cfc that might be stored in a session or application scope. One other thing I would like to point out that a lot of people do not take for granted, but tend to just do it anyway. I chose not to, but that is my choice. If the query is in a cfc, and that function uses arguments that will be used in the query for example cffunction name=getEmployee cfargument name=EmployeeId type=numeric required=true / cfset var Record = '' / cfquery name=Record datasource= Select * from Employees where EmployeeId = #Arguments.EmployeeId# /cfquery /cffunction I will never ever use the cfqueryparam, and the reason being is that the function itself will take care of the validation for me. However, although I did say never a string is a different story and will use it for a string. I know this has nothing to do with your problem, but just wanted to make that statement because I still see people use the cfqueryparam in places I know it is not necessary to use. If you would like to post a more detailed example on how you are using this, whether it is in any of my original methods then we can help you further but one thing to also take into consideration is the caching of the coldfusion class files too, this should never be switched on for development purposes. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 2 March 2007 11:23 AM To: cfaussie Subject: [cfaussie] @#$!! queryparam I think its to do with the binding or the caching of the query plan but when we change a table in the DB, like remove a column or change the length of a varchar, all the queries that use that table and have a queryparam break. We get messages like [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. on queries as simple as a Select * from table where id = cfqueryparam cfsqltype=cf_sql_integer value=#id# and we didnt even change the id column (obviously) At the moment the only way we can find of making it all work again is to remove all the params or to restart cf or sql. All of which are bad in their own way even though its only on the dev box. Strangely I havent come across this before, previous installations havent had this, but I have just moved to inherit some software and dev boxes and I cant work out why this is going on. All the settings in the cfadmin db connection are the defaults. Anyone else have this problem / have a solution? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] @#$!! queryparam
Andrew, I disagree. Although cfqueryparam performs vailidation, it is not the reason you should be using it. cfqueryparam makes the database engine use parameter binding on your queries. For example your query below would look different to the db engine every time it is run eg: Select * from Employees where EmployeeId = 1 Select * from Employees where EmployeeId = 2 Select * from Employees where EmployeeId = 3 so your database engine builds different query execution plans for each of these queries (in addition to validating the query, checking\casting the parameter types etc) etc But with parameter binding the databse engine is executing something that looks more like a stored procedure, Select * from Employees where EmployeeId = @var1 Here is an example from a SQL profile trace on my server: declare @P1 int set @P1=30 exec sp_prepexec @P1 output, N'@P1 decimal(38,0)', N'SELECT IsNull(COUNT(ITEM.SB_INVOICE_ITEM_ID),0) AS CNT, IsNull(SUM(ITEM.SB_INVOICE_COST),0) AS TOT_COST, IsNull(SUM(CASE WHEN ITEM.SB_ITEM_STATUS_CODE = ''ER'' THEN 1 ELSE 0 END),0) AS ERR_COUNT FROM SB_INVOICE_ITEM ITEM WHERE ITEM.SB_INV_BATCH_ID = @P1 ', 1387 select @P1 Andrew Scott [EMAIL PROTECTED] 02/03/2007 11:57 am Duncan, The query is only cached when you tell it to be cached. But are you using any other framework like reactor or transfer or even MG:U, or even have this in a cfc that might be stored in a session or application scope. One other thing I would like to point out that a lot of people do not take for granted, but tend to just do it anyway. I chose not to, but that is my choice. If the query is in a cfc, and that function uses arguments that will be used in the query for example cffunction name=getEmployee cfargument name=EmployeeId type=numeric required=true / cfset var Record = '' / cfquery name=Record datasource= Select * from Employees where EmployeeId = #Arguments.EmployeeId# /cfquery /cffunction I will never ever use the cfqueryparam, and the reason being is that the function itself will take care of the validation for me. However, although I did say never a string is a different story and will use it for a string. I know this has nothing to do with your problem, but just wanted to make that statement because I still see people use the cfqueryparam in places I know it is not necessary to use. If you would like to post a more detailed example on how you are using this, whether it is in any of my original methods then we can help you further but one thing to also take into consideration is the caching of the coldfusion class files too, this should never be switched on for development purposes. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 2 March 2007 11:23 AM To: cfaussie Subject: [cfaussie] @#$!! queryparam I think its to do with the binding or the caching of the query plan but when we change a table in the DB, like remove a column or change the length of a varchar, all the queries that use that table and have a queryparam break. We get messages like [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. on queries as simple as a Select * from table where id = cfqueryparam cfsqltype=cf_sql_integer value=#id# and we didnt even change the id column (obviously) At the moment the only way we can find of making it all work again is to remove all the params or to restart cf or sql. All of which are bad in their own way even though its only on the dev box. Strangely I havent come across this before, previous installations havent had this, but I have just moved to inherit some software and dev boxes and I cant work out why this is going on. All the settings in the cfadmin db connection are the defaults. Anyone else have this problem / have a solution? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFCENTRAL Still Show my Email
Andrew, No that's not correct, it's not part of the message it's just the email address to the group after a couple replies. And google groups does not show this on their web version. As it's a simple email address, steve could simply apply a regex before the cfoutput of the content to ensure any such email addresses are removed. Regards Dale Fraser http://dale.fraser.id.au/blog/ _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Friday, 2 March 2007 1:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email Dale, Although I see your point, but that's not really Steve's fault as it is part of the original message and will also be on the google groups as well. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Friday, 2 March 2007 12:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CFCENTRAL Still Show my Email I could write you a regex. http://www.cfcentral.com.au/cfaussiePosts.cfm?discussion=Problem%20creating% 20PDF%20from%20CFMX7%20output Regards Dale Fraser http://dale.fraser.id.au/blog/ http://dale.fraser.id.au/blog/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFCENTRAL Still Show my Email
Thanks for bringing it up anyway All email addresses have been removed from the output now and have been replaced with [EMAIL PROTECTED] Steve _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Friday, 2 March 2007 1:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email Dale, Although I see your point, but that's not really Steve's fault as it is part of the original message and will also be on the google groups as well. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Friday, 2 March 2007 12:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CFCENTRAL Still Show my Email I could write you a regex. http://www.cfcentral.com.au/cfaussiePosts.cfm?discussion=Problem%20creating% 20PDF%20from%20CFMX7%20output Regards Dale Fraser http://dale.fraser.id.au/blog/ http://dale.fraser.id.au/blog/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
Scott, Well although I know what you said, I see no reason to add overhead to my application to provide a stop measure for SQL injection when I have already taken care of it before my code ever reaches there in a cffunction. As far as making sure it is an integer instead of numeric, I couldn't care less it's not an overhead I will put into my applications. And to be honest, I would prefer to write SP's and have it on the DB side if that to be the case. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 2 March 2007 12:25 PM To: cfaussie@googlegroups.com Subject: [cfaussie] @#$!! queryparam Andrew, I disagree. Although cfqueryparam performs vailidation, it is not the reason you should be using it. cfqueryparam makes the database engine use parameter binding on your queries. For example your query below would look different to the db engine every time it is run eg: Select * from Employees where EmployeeId = 1 Select * from Employees where EmployeeId = 2 Select * from Employees where EmployeeId = 3 so your database engine builds different query execution plans for each of these queries (in addition to validating the query, checking\casting the parameter types etc) etc But with parameter binding the databse engine is executing something that looks more like a stored procedure, Select * from Employees where EmployeeId = @var1 Here is an example from a SQL profile trace on my server: declare @P1 int set @P1=30 exec sp_prepexec @P1 output, N'@P1 decimal(38,0)', N'SELECT IsNull(COUNT(ITEM.SB_INVOICE_ITEM_ID),0) AS CNT, IsNull(SUM(ITEM.SB_INVOICE_COST),0) AS TOT_COST, IsNull(SUM(CASE WHEN ITEM.SB_ITEM_STATUS_CODE = ''ER'' THEN 1 ELSE 0 END),0) AS ERR_COUNT FROM SB_INVOICE_ITEM ITEM WHERE ITEM.SB_INV_BATCH_ID = @P1 ', 1387 select @P1 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFCENTRAL Still Show my Email
Thanks Steve. Regards Dale Fraser http://dale.fraser.id.au/blog/ _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Friday, 2 March 2007 1:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email Thanks for bringing it up anyway All email addresses have been removed from the output now and have been replaced with [EMAIL PROTECTED] Steve _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Friday, 2 March 2007 1:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email Dale, Although I see your point, but that's not really Steve's fault as it is part of the original message and will also be on the google groups as well. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Friday, 2 March 2007 12:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CFCENTRAL Still Show my Email I could write you a regex. http://www.cfcentral.com.au/cfaussiePosts.cfm?discussion=Problem%20creating% 20PDF%20from%20CFMX7%20output Regards Dale Fraser http://dale.fraser.id.au/blog/ http://dale.fraser.id.au/blog/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFCENTRAL Still Show my Email
Dale, Actually you are wrong it is part of the message, the person who was replying to your message has that setup in their email client to add it to reply. I know I switched that off on outlook as it used to be on by default when replying to an email. Dale here is an example of googlegroups doing it. http://groups.google.com/group/cfaussie/browse_thread/thread/e9122da3aa85f11 4/fca5882ba3f7a882?lnk=gst http://groups.google.com/group/cfaussie/browse_thread/thread/e9122da3aa85f1 14/fca5882ba3f7a882?lnk=gstq=cfdocumentrnum=3#fca5882ba3f7a882 q=cfdocumentrnum=3#fca5882ba3f7a882 Btw Steve well done in preventing it. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Friday, 2 March 2007 1:45 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email Andrew, No that's not correct, it's not part of the message it's just the email address to the group after a couple replies. And google groups does not show this on their web version. As it's a simple email address, steve could simply apply a regex before the cfoutput of the content to ensure any such email addresses are removed. Regards Dale Fraser http://dale.fraser.id.au/blog/ _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Friday, 2 March 2007 1:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email Dale, Although I see your point, but that's not really Steve's fault as it is part of the original message and will also be on the google groups as well. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Friday, 2 March 2007 12:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CFCENTRAL Still Show my Email I could write you a regex. http://www.cfcentral.com.au/cfaussiePosts.cfm?discussion=Problem%20creating% 20PDF%20from%20CFMX7%20output Regards Dale Fraser http://dale.fraser.id.au/blog/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
I should add to this that the queries are not using any caching, they are not in a cfc, and are not loaded into any scopes like the application. Simple, inline, straightforward queries. On 3/2/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Scott - thats precisely why we use cfqueryparam - and the performance increase is marked, especially on inserts. There is a performance hit on the first time the query is put together, but after that you save time. Andrew - I thought the cached templates could be it - but its not, we just ran a control test: turn off cache, restart cf, change column, try query. And it still errors. On Mar 2, 1:33 pm, Andrew Scott [EMAIL PROTECTED] wrote: Scott, Well although I know what you said, I see no reason to add overhead to my application to provide a stop measure for SQL injection when I have already taken care of it before my code ever reaches there in a cffunction. As far as making sure it is an integer instead of numeric, I couldn't care less it's not an overhead I will put into my applications. And to be honest, I would prefer to write SP's and have it on the DB side if that to be the case. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd.www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 2 March 2007 12:25 PM To: cfaussie@googlegroups.com Subject: [cfaussie] @#$!! queryparam Andrew, I disagree. Although cfqueryparam performs vailidation, it is not the reason you should be using it. cfqueryparam makes the database engine use parameter binding on your queries. For example your query below would look different to the db engine every time it is run eg: Select * from Employees where EmployeeId = 1 Select * from Employees where EmployeeId = 2 Select * from Employees where EmployeeId = 3 so your database engine builds different query execution plans for each of these queries (in addition to validating the query, checking\casting the parameter types etc) etc But with parameter binding the databse engine is executing something that looks more like a stored procedure, Select * from Employees where EmployeeId = @var1 Here is an example from a SQL profile trace on my server: declare @P1 int set @P1=30 exec sp_prepexec @P1 output, N'@P1 decimal(38,0)', N'SELECT IsNull(COUNT(ITEM.SB_INVOICE_ITEM_ID),0) AS CNT, IsNull(SUM(ITEM.SB_INVOICE_COST),0) AS TOT_COST, IsNull(SUM(CASE WHEN ITEM.SB_ITEM_STATUS_CODE = ''ER'' THEN 1 ELSE 0 END),0) AS ERR_COUNT FROM SB_INVOICE_ITEM ITEM WHERE ITEM.SB_INV_BATCH_ID = @P1 ', 1387 select @P1 -- Duncan I Loxton [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
Yes, as Scott later said, Andrew, you don't want to confuse caching of the query with what Duncan said, which was caching of the query plan. And as Scott clarified, you definitely don't want to spread the misconception that cfqueryparam is just for security. The value in query plan caching can be greater, for performance sake. Still, you're right that a query inside a CFC or UDF whose variables are all validated with CFARGUMENT just doesn't need the security aspect of CFQueryParam, but it's still typically valuable for performance. (I am giving a talk to the Atlanta SQL Server group on the subject of query plan caching, and some important changes in SQL 2005, as well as how to measure the impact of doing it or not. I've been planning to make a variation of that talk for CF audiences, focusing on MySQL and perhaps Oracle as well.) Anyway, Scott also got to the point of Duncan's problem below. It's your use of Select *. That's a notorious problem when using CFQUERYPARAM. The simple solution is to stop using that. That's good practice for all manner of reasons, not the least of which this. /Charlie http://www.carehart.org/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, March 01, 2007 7:58 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: @#$!! queryparam Duncan, The query is only cached when you tell it to be cached. But are you using any other framework like reactor or transfer or even MG:U, or even have this in a cfc that might be stored in a session or application scope. One other thing I would like to point out that a lot of people do not take for granted, but tend to just do it anyway. I chose not to, but that is my choice. If the query is in a cfc, and that function uses arguments that will be used in the query for example cffunction name=getEmployee cfargument name=EmployeeId type=numeric required=true / cfset var Record = '' / cfquery name=Record datasource= Select * from Employees where EmployeeId = #Arguments.EmployeeId# /cfquery /cffunction I will never ever use the cfqueryparam, and the reason being is that the function itself will take care of the validation for me. However, although I did say never a string is a different story and will use it for a string. I know this has nothing to do with your problem, but just wanted to make that statement because I still see people use the cfqueryparam in places I know it is not necessary to use. If you would like to post a more detailed example on how you are using this, whether it is in any of my original methods then we can help you further but one thing to also take into consideration is the caching of the coldfusion class files too, this should never be switched on for development purposes. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
Goodness, too many caches! Now you're talking about cached templates, Duncan. It sure seems to me that Andrew was referring to query caching, since he said, The query is only cached when you tell it to be cached and later mentioned storing data in shared scopes. And then of course Scott was referring to the database's query plan caching. In fact, this is a good place to remind that my talk at WebDU is going to be on 'Caching In on CF Performance', and it will be specifically about trying to bring clarity to this jumble of caching (and there are several more) that often confuse even experienced developers. Of course, we won't have time in an hour to go into depth on any one, but I will certainly strive to help get folks on the same page in understanding these and some other little-known caching aspects in CFML and related things (database, web server, browser). Caching's a very good thing, usually. It's just always enabled by default (and sometimes one can go crazy with it and cost more resources than are saved). /Charlie http://www.carehart.org/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, March 01, 2007 10:01 PM To: cfaussie Subject: [cfaussie] Re: @#$!! queryparam Scott - thats precisely why we use cfqueryparam - and the performance increase is marked, especially on inserts. There is a performance hit on the first time the query is put together, but after that you save time. Andrew - I thought the cached templates could be it - but its not, we just ran a control test: turn off cache, restart cf, change column, try query. And it still errors. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
The suggestions I had mentioned, I didnt think of Trusted Cache but I never have that ticked for development but that might cause it and the other is Save Class Files but you will also need to delete the class files that are generated there as well. The other option is Maximum number of cache queries, but I think and am not 100% sure that this is for the actual attribute cache for query tags! Now if you have done the above, we need more info about your environment that might cause this. Is the query in a cfc, that might be used in a scope like session or application or using a framework like MG:U, fusebox, Mach-II that might implement its own form of caching of queries and or components. Other than these, I cannot see any other reason without seeing the code that might be causing this. And are you using standard, coldfusion database connection and not a JDBC alternative? HTH in some way. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 2 March 2007 2:01 PM To: cfaussie Subject: [cfaussie] Re: @#$!! queryparam Scott - thats precisely why we use cfqueryparam - and the performance increase is marked, especially on inserts. There is a performance hit on the first time the query is put together, but after that you save time. Andrew - I thought the cached templates could be it - but its not, we just ran a control test: turn off cache, restart cf, change column, try query. And it still errors. On Mar 2, 1:33 pm, Andrew Scott [EMAIL PROTECTED] wrote: Scott, Well although I know what you said, I see no reason to add overhead to my application to provide a stop measure for SQL injection when I have already taken care of it before my code ever reaches there in a cffunction. As far as making sure it is an integer instead of numeric, I couldn't care less it's not an overhead I will put into my applications. And to be honest, I would prefer to write SP's and have it on the DB side if that to be the case. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd.www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 2 March 2007 12:25 PM To: cfaussie@googlegroups.com Subject: [cfaussie] @#$!! queryparam Andrew, I disagree. Although cfqueryparam performs vailidation, it is not the reason you should be using it. cfqueryparam makes the database engine use parameter binding on your queries. For example your query below would look different to the db engine every time it is run eg: Select * from Employees where EmployeeId = 1 Select * from Employees where EmployeeId = 2 Select * from Employees where EmployeeId = 3 so your database engine builds different query execution plans for each of these queries (in addition to validating the query, checking\casting the parameter types etc) etc But with parameter binding the databse engine is executing something that looks more like a stored procedure, Select * from Employees where EmployeeId = @var1 Here is an example from a SQL profile trace on my server: declare @P1 int set @P1=30 exec sp_prepexec @P1 output, N'@P1 decimal(38,0)', N'SELECT IsNull(COUNT(ITEM.SB_INVOICE_ITEM_ID),0) AS CNT, IsNull(SUM(ITEM.SB_INVOICE_COST),0) AS TOT_COST, IsNull(SUM(CASE WHEN ITEM.SB_ITEM_STATUS_CODE = ''ER'' THEN 1 ELSE 0 END),0) AS ERR_COUNT FROM SB_INVOICE_ITEM ITEM WHERE ITEM.SB_INV_BATCH_ID = @P1 ', 1387 select @P1 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
Did you delete any cached templates in the CFIDE folder? On 02/03/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Scott - thats precisely why we use cfqueryparam - and the performance increase is marked, especially on inserts. There is a performance hit on the first time the query is put together, but after that you save time. Andrew - I thought the cached templates could be it - but its not, we just ran a control test: turn off cache, restart cf, change column, try query. And it still errors. On Mar 2, 1:33 pm, Andrew Scott [EMAIL PROTECTED] wrote: Scott, Well although I know what you said, I see no reason to add overhead to my application to provide a stop measure for SQL injection when I have already taken care of it before my code ever reaches there in a cffunction. As far as making sure it is an integer instead of numeric, I couldn't care less it's not an overhead I will put into my applications. And to be honest, I would prefer to write SP's and have it on the DB side if that to be the case. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd.www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 2 March 2007 12:25 PM To: cfaussie@googlegroups.com Subject: [cfaussie] @#$!! queryparam Andrew, I disagree. Although cfqueryparam performs vailidation, it is not the reason you should be using it. cfqueryparam makes the database engine use parameter binding on your queries. For example your query below would look different to the db engine every time it is run eg: Select * from Employees where EmployeeId = 1 Select * from Employees where EmployeeId = 2 Select * from Employees where EmployeeId = 3 so your database engine builds different query execution plans for each of these queries (in addition to validating the query, checking\casting the parameter types etc) etc But with parameter binding the databse engine is executing something that looks more like a stored procedure, Select * from Employees where EmployeeId = @var1 Here is an example from a SQL profile trace on my server: declare @P1 int set @P1=30 exec sp_prepexec @P1 output, N'@P1 decimal(38,0)', N'SELECT IsNull(COUNT(ITEM.SB_INVOICE_ITEM_ID),0) AS CNT, IsNull(SUM(ITEM.SB_INVOICE_COST),0) AS TOT_COST, IsNull(SUM(CASE WHEN ITEM.SB_ITEM_STATUS_CODE = ''ER'' THEN 1 ELSE 0 END),0) AS ERR_COUNT FROM SB_INVOICE_ITEM ITEM WHERE ITEM.SB_INV_BATCH_ID = @P1 ', 1387 select @P1 -- Peter Tilbrook ColdGen Internet Solutions President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA http://www.coldgen.com/ http://www.actcfug.com/ Tel: +61-2-6284-2727 Mob: +61-0432-897-437 Email: [EMAIL PROTECTED] MSN Messenger Live: Desktop General --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFCENTRAL Still Show my Email
Must admit I like googles approach to emails that are inside email messages. But Steve I would not expect you to go to those lengths. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: @#$!! queryparam
Charlie, I didnt think that would be affecting it, I am more than aware that its bad practice, and as it happens the queries in question do have *, column1, column2 etc in them. I know that you are pulling more data than necessary with a * therefore slowing down processing with data processing an transfer. That's good practice for all manner of reasons Would you care to spell out other reasons? Duncan On 3/2/07, Charlie Arehart [EMAIL PROTECTED] wrote: Yes, as Scott later said, Andrew, you don't want to confuse caching of the query with what Duncan said, which was caching of the query plan. And as Scott clarified, you definitely don't want to spread the misconception that cfqueryparam is just for security. The value in query plan caching can be greater, for performance sake. Still, you're right that a query inside a CFC or UDF whose variables are all validated with CFARGUMENT just doesn't need the security aspect of CFQueryParam, but it's still typically valuable for performance. (I am giving a talk to the Atlanta SQL Server group on the subject of query plan caching, and some important changes in SQL 2005, as well as how to measure the impact of doing it or not. I've been planning to make a variation of that talk for CF audiences, focusing on MySQL and perhaps Oracle as well.) Anyway, Scott also got to the point of Duncan's problem below. It's your use of Select *. That's a notorious problem when using CFQUERYPARAM. The simple solution is to stop using that. That's good practice for all manner of reasons, not the least of which this. /Charlie http://www.carehart.org/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, March 01, 2007 7:58 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: @#$!! queryparam Duncan, The query is only cached when you tell it to be cached. But are you using any other framework like reactor or transfer or even MG:U, or even have this in a cfc that might be stored in a session or application scope. One other thing I would like to point out that a lot of people do not take for granted, but tend to just do it anyway. I chose not to, but that is my choice. If the query is in a cfc, and that function uses arguments that will be used in the query for example cffunction name=getEmployee cfargument name=EmployeeId type=numeric required=true / cfset var Record = '' / cfquery name=Record datasource= Select * from Employees where EmployeeId = #Arguments.EmployeeId# /cfquery /cffunction I will never ever use the cfqueryparam, and the reason being is that the function itself will take care of the validation for me. However, although I did say never a string is a different story and will use it for a string. I know this has nothing to do with your problem, but just wanted to make that statement because I still see people use the cfqueryparam in places I know it is not necessary to use. If you would like to post a more detailed example on how you are using this, whether it is in any of my original methods then we can help you further but one thing to also take into consideration is the caching of the coldfusion class files too, this should never be switched on for development purposes. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone:+613 8676 4223 Mobile: 0404 998 273 -- Duncan I Loxton [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] FineNoCase Problem
Hi, I have been using FindNoCase(x,'OPPO,OPSNC,OPVAN,OPGEN,INP') gt 0 for a while but only noticed today that if the value of x is OPVA it would match on the value OPVAN. Not what I was expecting. I have changed the statement to use multiple comparison eg x=oppo or x=opsnc and so on, but was wondering if there was a solution using a function like that above? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: FineNoCase Problem
Scott, Well that is a doosy, but maybe you should be looking at contains and not FindNoCase. Because x = opva will always return true as will x=op I suggest using cfif StringToCompareAgainst contains 'OPPO,OPSNC,OPVAN,OPGEN,INP' Of you could do something like this cfswitch expression=#x# cfcase value=OPVAN /cfcase cfcase value=OPPO,OPP /cfcase /cfswitch Notice I threw an extra OPP to show multiple checks, to run same code! Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] FineNoCase Problem
oops. I have used both in the application. ta. Adam Chapman [EMAIL PROTECTED] 02/03/2007 3:03 pm ListFindNoCase('OPPO,OPSNC,OPVAN,OPGEN,INP', x) gt 0 Cheers, Adam -Original Message- From: Scott Thornton [mailto:[EMAIL PROTECTED] Sent: Friday, 2 March 2007 2:48 PM To: cfaussie@googlegroups.com Subject: [cfaussie] FineNoCase Problem Hi, I have been using FindNoCase(x,'OPPO,OPSNC,OPVAN,OPGEN,INP') gt 0 for a while but only noticed today that if the value of x is OPVA it would match on the value OPVAN. Not what I was expecting. I have changed the statement to use multiple comparison eg x=oppo or x=opsnc and so on, but was wondering if there was a solution using a function like that above? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: FineNoCase Problem
ListFindNoCase('OPPO,OPSNC,OPVAN,OPGEN,INP', x) gt 0 Cheers, Adam -Original Message- From: Scott Thornton [mailto:[EMAIL PROTECTED] Sent: Friday, 2 March 2007 2:48 PM To: cfaussie@googlegroups.com Subject: [cfaussie] FineNoCase Problem Hi, I have been using FindNoCase(x,'OPPO,OPSNC,OPVAN,OPGEN,INP') gt 0 for a while but only noticed today that if the value of x is OPVA it would match on the value OPVAN. Not what I was expecting. I have changed the statement to use multiple comparison eg x=oppo or x=opsnc and so on, but was wondering if there was a solution using a function like that above? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: refindnocase - trouble returning array
Thanks Steve - works like a charm. On 3/1/07, Steve Onnis [EMAIL PROTECTED] wrote: Here you go Duncan cfsavecontent variable=str digging around in sitebr#11245 - ant build scripts cfeclipse w/garrybrticketing tixbradd job drop box to ticketing #11249 working according to #12345, #99587, #55352 or simply just the ticket number #11466 /cfsavecontent cfset reg = ##[0-9]* / cfset start = 1 / cfif REfindNoCase(reg, str, start) cfloop condition=REfindNoCase(reg, str, start) cfset tic = REfindNoCase(reg, str, start, true) / cfoutput#MID(str, tic.pos[1], tic.len[1])#/cfoutputbr / cfset start = tic.pos[1] + tic.len[1] / /cfloop /cfif Regards Steve Onnis -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Sent: Thursday, 1 March 2007 4:10 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: refindnocase - trouble returning array Thanks steve - they wont always come through in between br tags. Other examples might be: digging around in sitebr#11245 - ant build scripts cfeclipse w/garrybrticketing tixbradd job drop box to ticketing #11249 working according to #12345, #99587, #55352 or simply just the ticket number #11466 On 3/1/07, Steve Onnis [EMAIL PROTECTED] wrote: !--- a comment with 3 ticket numbers inside --- cfset PeriodNote = #11453br#11467br#11500 cfset tickets = ListToArray(REReaplceNoCase(PeriodNote, [^]*, , ALL), ##) / That should return all the number sections for you. I think that's what your trying to do Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, 1 March 2007 3:44 PM To: cfaussie Subject: [cfaussie] refindnocase - trouble returning array I am having trouble getting refindnocase to return an array - I know there are more than one match. I am parsing the text in the notes field on our ticketing system and hoping to link up the tix # to the URL for it. Here is my code: !--- a comment with 3 ticket numbers inside --- cfset PeriodNote = #11453br#11467br#11500 cfset post = ReFindNoCase(##\d+,PeriodNote,1,True) cfdump var=#post# I tried this stuff about parenteses that the livedocs has - cfset post = ReFindNoCase((##\d+)[ ]+(\1),PeriodNote,1,True) but that simply returns nothing - not even one match - what am I missing? Thanks -- Duncan I Loxton [EMAIL PROTECTED] -- Duncan I Loxton [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] FineNoCase Problem
thanks. Andrew Scott [EMAIL PROTECTED] 02/03/2007 3:01 pm Scott, Well that is a doosy, but maybe you should be looking at contains and not FindNoCase. Because x = opva will always return true as will x=op I suggest using cfif StringToCompareAgainst contains 'OPPO,OPSNC,OPVAN,OPGEN,INP' Of you could do something like this cfswitch expression=#x# cfcase value=OPVAN /cfcase cfcase value=OPPO,OPP /cfcase /cfswitch Notice I threw an extra OPP to show multiple checks, to run same code! Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] FineNoCase Problem
thanks. Andrew Scott [EMAIL PROTECTED] 02/03/2007 3:01 pm Scott, Well that is a doosy, but maybe you should be looking at contains and not FindNoCase. Because x = opva will always return true as will x=op I suggest using cfif StringToCompareAgainst contains 'OPPO,OPSNC,OPVAN,OPGEN,INP' Of you could do something like this cfswitch expression=#x# cfcase value=OPVAN /cfcase cfcase value=OPPO,OPP /cfcase /cfswitch Notice I threw an extra OPP to show multiple checks, to run same code! Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion Hosting
What's your budget, I have a site hosted with http://www.hostingatoz.com/ technically not Australian as the servers are hosted offshore but have found them to be not too bad and reasonably cheap for what they offer. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Allan Browning Sent: Friday, 2 March 2007 3:10 PM To: cfaussie Subject: [cfaussie] ColdFusion Hosting HI, Are there any recomendations for coldfusion (MX 7) hosting in Australia. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion Hosting
Check out http://www.fasthit.com.au/ They have been good for me. On 3/2/07, Allan Browning [EMAIL PROTECTED] wrote: HI, Are there any recomendations for coldfusion (MX 7) hosting in Australia. -- If you are not living on the edge, You are taking up too much space. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion Hosting
Alan We can do your CF7 hosting for around $35 a month including a MSSQL database. Servers are local (Melbourne) Need to know any more just let me know ([EMAIL PROTECTED]) or have a look at www.inevative.com.au Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Allan Browning Sent: Friday, 2 March 2007 3:10 PM To: cfaussie Subject: [cfaussie] ColdFusion Hosting HI, Are there any recomendations for coldfusion (MX 7) hosting in Australia. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion Hosting
Mike Kear (www.apwebworks.com) offers great deals too. Servers are based in Washington so if most of your traffic is from US then even better. On 02/03/07, Steve Onnis [EMAIL PROTECTED] wrote: Alan We can do your CF7 hosting for around $35 a month including a MSSQL database. Servers are local (Melbourne) Need to know any more just let me know ([EMAIL PROTECTED]) or have a look at www.inevative.com.au Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Allan Browning Sent: Friday, 2 March 2007 3:10 PM To: cfaussie Subject: [cfaussie] ColdFusion Hosting HI, Are there any recomendations for coldfusion (MX 7) hosting in Australia. -- Peter Tilbrook ColdGen Internet Solutions President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA http://www.coldgen.com/ http://www.actcfug.com/ Tel: +61-2-6284-2727 Mob: +61-0432-897-437 Email: [EMAIL PROTECTED] MSN Messenger Live: Desktop General --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion Hosting
Try AFPWebworks.com. I hear the person running the show is a great guy. We are directed at ColdFusion developers. The only things you pay for are disk space and bandwidth - anything else comes in teh deal. you can have as many email accounts, domains, sub domains, domain aliases etc as you like. You get a control panel so you can set up most of your own things. Because we're mostly develoers, we have very few tag restrictions, so you can use us for staging sites, development sites, testing as well as live production sites under shared hosting. Oh and when you phone us you will never hear press 1 for sales, press 2 for support, press 3 for bilings, press 4 to get cut off and we'll never call you back. When you phone us you get a live human on the phone. Check us out. http://afpwebworks.com . Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/2/07, Allan Browning [EMAIL PROTECTED] wrote: HI, Are there any recomendations for coldfusion (MX 7) hosting in Australia. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion Hosting
oops On 02/03/07, Mike Kear [EMAIL PROTECTED] wrote: Try AFPWebworks.com. I hear the person running the show is a great guy. We are directed at ColdFusion developers. The only things you pay for are disk space and bandwidth - anything else comes in teh deal. you can have as many email accounts, domains, sub domains, domain aliases etc as you like. You get a control panel so you can set up most of your own things. Because we're mostly develoers, we have very few tag restrictions, so you can use us for staging sites, development sites, testing as well as live production sites under shared hosting. Oh and when you phone us you will never hear press 1 for sales, press 2 for support, press 3 for bilings, press 4 to get cut off and we'll never call you back. When you phone us you get a live human on the phone. Check us out. http://afpwebworks.com . Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/2/07, Allan Browning [EMAIL PROTECTED] wrote: HI, Are there any recomendations for coldfusion (MX 7) hosting in Australia. -- Peter Tilbrook ColdGen Internet Solutions President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA http://www.coldgen.com/ http://www.actcfug.com/ Tel: +61-2-6284-2727 Mob: +61-0432-897-437 Email: [EMAIL PROTECTED] MSN Messenger Live: Desktop General --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFCENTRAL Still Show my Email
Steve, I personally think it's not worth your efforts given it's already available online through the new Google Groups interface which is quite nice. I guess you will know what kind of traffic it gets and if it's worth maintaining. I can understand it's benefits back in the daemon days. Regards Dale Fraser http://dale.fraser.id.au/blog/ _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Friday, 2 March 2007 2:27 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email What I have is more of an archive. I think my message archive goes back about 4-5 years. Still deciding if I am going to keep it up to date or not. What do you guys think? _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Friday, 2 March 2007 2:10 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCENTRAL Still Show my Email Must admit I like googles approach to emails that are inside email messages. But Steve I would not expect you to go to those lengths. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---