SQL Express and CF
Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
Works fine for me. (I think it has a 2GB database size limit.) It also doesn't support DTS and some other nice management functionality, but most of the features of Enterprise Manager are there. On 11/15/12 2:23 AM, Kevin Parker wrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
list delimiters question
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different oposition at any time.
i thought i could use a delimiter specifiying ,chapter_id= but that dosnt
seem to work.
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099;
/
cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=))
cfset Param2 = ListGetAt(FORM.some_url,2,)
Param2: chapter_id=12120 Right, but only some times.
getChapterId: 40099Wrong
thanks a bunch.
i googled every thing from listtoarray to cfdump
var=#getPageContext().getRequest().getParameterValues('FORM.some_url')#
Which dosnt seem to gel with cf7!!
thanks a bunch for clear out the cob webs this am..
-m
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353170
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
I'm sure there are several ways to do this
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset params = listgetat(FORM.some_url,2,?) /
cfset p = listtoarray(params, ) /
cfset chapter_id = 0 /
cfloop array=#p# index=i
cfif find(chapter_id=, i)
cfset chapter_id = listgetat(i, 2, =) /
/cfif
/cfloop
cfdump var=#chapter_id# /
On Thu, Nov 15, 2012 at 8:28 AM, morchella morchella.delici...@gmail.comwrote:
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different oposition at any time.
i thought i could use a delimiter specifiying ,chapter_id= but that dosnt
seem to work.
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=))
cfset Param2 = ListGetAt(FORM.some_url,2,)
Param2: chapter_id=12120 Right, but only some times.
getChapterId: 40099Wrong
thanks a bunch.
i googled every thing from listtoarray to cfdump
var=#getPageContext().getRequest().getParameterValues('FORM.some_url')#
Which dosnt seem to gel with cf7!!
thanks a bunch for clear out the cob webs this am..
-m
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353171
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
Can you just access through the url scope?
cfdump var=#url.chapter_id#
Best Regards,
*Marty Franklin*
/Information Technology/
*Asset Research Services, Inc.*
ma...@assetresearch.com mailto:ma...@assetresearch.com
On 11/15/2012 7:28 AM, morchella wrote:
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different oposition at any time.
i thought i could use a delimiter specifiying ,chapter_id= but that dosnt
seem to work.
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099;
/
cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=))
cfset Param2 = ListGetAt(FORM.some_url,2,)
Param2: chapter_id=12120 Right, but only some times.
getChapterId: 40099Wrong
thanks a bunch.
i googled every thing from listtoarray to cfdump
var=#getPageContext().getRequest().getParameterValues('FORM.some_url')#
Which dosnt seem to gel with cf7!!
thanks a bunch for clear out the cob webs this am..
-m
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353172
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
no need to convert it to a array (I was trying to go that route but keeping
it a list works fine too)
cfset params = listgetat(FORM.some_url,2,?) /
cfset chapter_id = 0 /
cfloop list=#params# delimiters= index=i
cfif find(chapter_id=, i)
cfset chapter_id = listgetat(i, 2, =) /
/cfif
/cfloop
cfdump var=#chapter_id# /
On Thu, Nov 15, 2012 at 8:40 AM, Greg Morphis gmorp...@gmail.com wrote:
I'm sure there are several ways to do this
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset params = listgetat(FORM.some_url,2,?) /
cfset p = listtoarray(params, ) /
cfset chapter_id = 0 /
cfloop array=#p# index=i
cfif find(chapter_id=, i)
cfset chapter_id = listgetat(i, 2, =) /
/cfif
/cfloop
cfdump var=#chapter_id# /
On Thu, Nov 15, 2012 at 8:28 AM, morchella
morchella.delici...@gmail.comwrote:
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different oposition at any time.
i thought i could use a delimiter specifiying ,chapter_id= but that
dosnt
seem to work.
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=))
cfset Param2 = ListGetAt(FORM.some_url,2,)
Param2: chapter_id=12120 Right, but only some times.
getChapterId: 40099Wrong
thanks a bunch.
i googled every thing from listtoarray to cfdump
var=#getPageContext().getRequest().getParameterValues('FORM.some_url')#
Which dosnt seem to gel with cf7!!
thanks a bunch for clear out the cob webs this am..
-m
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353173
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
its from a form field, not a url, but it is a url.
=]
On Thu, Nov 15, 2012 at 9:43 AM, Marty Franklin ma...@assetresearch.comwrote:
Can you just access through the url scope?
cfdump var=#url.chapter_id#
Best Regards,
*Marty Franklin*
/Information Technology/
*Asset Research Services, Inc.*
ma...@assetresearch.com mailto:ma...@assetresearch.com
On 11/15/2012 7:28 AM, morchella wrote:
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different oposition at any time.
i thought i could use a delimiter specifiying ,chapter_id= but that
dosnt
seem to work.
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=))
cfset Param2 = ListGetAt(FORM.some_url,2,)
Param2: chapter_id=12120 Right, but only some times.
getChapterId: 40099Wrong
thanks a bunch.
i googled every thing from listtoarray to cfdump
var=#getPageContext().getRequest().getParameterValues('FORM.some_url')#
Which dosnt seem to gel with cf7!!
thanks a bunch for clear out the cob webs this am..
-m
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353174
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
greg, that is perfect. Thank You.
just seems a little cludgy.
would be nice if i could just call the var like a url inside the object
returnd in the form.
any how, this will di it for me..
thanks again!
-paul
On Thu, Nov 15, 2012 at 9:43 AM, Greg Morphis gmorp...@gmail.com wrote:
no need to convert it to a array (I was trying to go that route but keeping
it a list works fine too)
cfset params = listgetat(FORM.some_url,2,?) /
cfset chapter_id = 0 /
cfloop list=#params# delimiters= index=i
cfif find(chapter_id=, i)
cfset chapter_id = listgetat(i, 2, =) /
/cfif
/cfloop
cfdump var=#chapter_id# /
On Thu, Nov 15, 2012 at 8:40 AM, Greg Morphis gmorp...@gmail.com wrote:
I'm sure there are several ways to do this
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset params = listgetat(FORM.some_url,2,?) /
cfset p = listtoarray(params, ) /
cfset chapter_id = 0 /
cfloop array=#p# index=i
cfif find(chapter_id=, i)
cfset chapter_id = listgetat(i, 2, =) /
/cfif
/cfloop
cfdump var=#chapter_id# /
On Thu, Nov 15, 2012 at 8:28 AM, morchella
morchella.delici...@gmail.comwrote:
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different oposition at any time.
i thought i could use a delimiter specifiying ,chapter_id= but that
dosnt
seem to work.
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=))
cfset Param2 = ListGetAt(FORM.some_url,2,)
Param2: chapter_id=12120 Right, but only some times.
getChapterId: 40099Wrong
thanks a bunch.
i googled every thing from listtoarray to cfdump
var=#getPageContext().getRequest().getParameterValues('FORM.some_url')#
Which dosnt seem to gel with cf7!!
thanks a bunch for clear out the cob webs this am..
-m
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353175
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
not sure what the listgetat 2 is doing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
It is treading your form.some_url value as a list separated by a question mark. The listgetat is retrieving the second value in the list, which are all the url name-value pairs. On Thu, Nov 15, 2012 at 9:53 AM, morchella morchella.delici...@gmail.com wrote: not sure what the listgetat 2 is doing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
gets the second item in the list (chapter_id=12345) using the = as a delimiter On Thu, Nov 15, 2012 at 8:53 AM, morchella morchella.delici...@gmail.comwrote: not sure what the listgetat 2 is doing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
and the first one is separating the parameters from the URL using the ? as a delimiter. On Thu, Nov 15, 2012 at 8:59 AM, Dean Lawrence dean...@gmail.com wrote: It is treading your form.some_url value as a list separated by a question mark. The listgetat is retrieving the second value in the list, which are all the url name-value pairs. On Thu, Nov 15, 2012 at 9:53 AM, morchella morchella.delici...@gmail.com wrote: not sure what the listgetat 2 is doing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Security Question(s)
I haven't done Coldfusion since CF4, however recently have been tasked to look at a CF7MX appilication that has 3 security issues they are looking to fix. 1. Cross Site Scripting - I believe I have this one figured out using the Admin Pannel's Enable global script protection 2. Format String Injection 3. Parameter Based Buffer Overflow I have been able to find generalized information on the other two issues, but nothing as it relates to CF itself. Will the Enable global script protection fix these other two as well or should I be looking elsewhere? Everything I am finding has to do with SQL injection and not Format String Injection, and I'm finding nothing on Parameter Based Buffer Overflow. Any help anyone could provide would be great. Thanks, Jamie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353180 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: query: how to return records that are increments of one year old?
Leigh and Greg and others who chimed in about this task: I was making
progress. Then, this morning, the client changed the scope of the task. (And
they might change it further.) Anyway, I no longer need to write a query we
discussed. But -- thank you very much, again. I might come back with a
question about CFSCHEDULE. Hope your day is going well.
Eric
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Wednesday, November 14, 2012 11:03 AM
To: cf-talk
Subject: Re: query: how to return records that are increments of one year
old?
cast(dateadd('y', -1, getdate()) as date) as -- getdate() in MSSQL
I do not think 2005 supports the date type. A CF alternative is using
dateAdd(, -1, now()) to get the date and time one year ago. Then use
cfqueryparam with type cf_sql_date which automatically drops any time
portion.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353181
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Security Question(s)
relying on enable script protection is like closing your front door and thinking you can't get burgled. It may stop the casual opportunist who sees your door open and decides to rob you, but a professional burglar wont walk in via the front door anyway, he will find another way in. In the same way global script protect only blocks the really basic most common attacks, it will do nothing for anything more sophisticated. This is not a topic specific to ColdFusion, you need to research the topic in general, it applies to all platforms. You can find many CF specific article son Google though. https://www.google.co.uk/search?q=how+to+secure+your+coldfusion+applicationoq=how+to+secure+your+coldfusion+applicationaqs=chrome.0.57.7359sugexp=chrome,mod=15sourceid=chromeie=UTF-8 I would suggest taking a look here for any recorded meetups on the topic http://www.meetup.com/coldfusionmeetup/ The quick and simple solution would probably be to use Fuseguard. http://foundeo.com/security/ On Thu, Nov 15, 2012 at 4:55 PM, Jamie Bowers jamiembow...@netscape.netwrote: I haven't done Coldfusion since CF4, however recently have been tasked to look at a CF7MX appilication that has 3 security issues they are looking to fix. 1. Cross Site Scripting - I believe I have this one figured out using the Admin Pannel's Enable global script protection 2. Format String Injection 3. Parameter Based Buffer Overflow I have been able to find generalized information on the other two issues, but nothing as it relates to CF itself. Will the Enable global script protection fix these other two as well or should I be looking elsewhere? Everything I am finding has to do with SQL injection and not Format String Injection, and I'm finding nothing on Parameter Based Buffer Overflow. Any help anyone could provide would be great. Thanks, Jamie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Security Question(s)
First thing is you will want o wrap all of your query variables with a cfqueryparam tag. I also wrap them with the XMLFormat() function as that will render strings non-executable. For example... Select x,y,z From tablename Where xx=cfqueryparam cfsqltype=CF_SQL_Integer value=#XMLFormat(variable.xxddrr) There are also other attributes to tighten it down further like if it is allowed to ne null, or a list, etc... The other big thing is to make sure your variables are scoped. This makes it so that you know exactly where it is coming from and prevents overriding from a source that s higher up in the order of operations. Local vars get the variables scope. Then ther is URL, form, application, session, etc... This will cover cross site scripting and SQL injection. Three Ravens Consulting Eric Roberts Owner/Developer ow...@threeravensconsulting.com tel: 630-486-5255 fax: 630-310-8531 http://www.threeravensconsulting.com -Original Message- From: Jamie Bowers [mailto:jamiembow...@netscape.net] Sent: Thursday, November 15, 2012 10:55 AM To: cf-talk Subject: Security Question(s) I haven't done Coldfusion since CF4, however recently have been tasked to look at a CF7MX appilication that has 3 security issues they are looking to fix. 1. Cross Site Scripting - I believe I have this one figured out using the Admin Pannel's Enable global script protection 2. Format String Injection 3. Parameter Based Buffer Overflow I have been able to find generalized information on the other two issues, but nothing as it relates to CF itself. Will the Enable global script protection fix these other two as well or should I be looking elsewhere? Everything I am finding has to do with SQL injection and not Format String Injection, and I'm finding nothing on Parameter Based Buffer Overflow. Any help anyone could provide would be great. Thanks, Jamie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cflocation not working
Hi All - I am using the following code to redirect a page cfif cgi.http_host EQ abc.com cfif cgi.http_url EQ /test/folder1 cflocation statuscode=301 addtoken=false url=http://abc.com/test/folder2; /cfif /cfif The second if statement does not work. if I do the redirect just using the first if statement, it works. ANy ideas on why this could be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cflocation not working
Hi All - I am using the following code to redirect a page cfif cgi.http_host EQ abc.com cfif cgi.http_url EQ /test/folder1 cflocation statuscode=301 addtoken=false url=http://abc.com/test/folder2; /cfif /cfif The second if statement does not work. if I do the redirect just using the first if statement, it works. ANy ideas on why this could be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation not working
So when you output cgi.http_url, what do you see? On Thu, Nov 15, 2012 at 11:31 AM, fun and learning funandlrnn...@gmail.comwrote: Hi All - I am using the following code to redirect a page cfif cgi.http_host EQ abc.com cfif cgi.http_url EQ /test/folder1 cflocation statuscode=301 addtoken=false url= http://abc.com/test/folder2; /cfif /cfif The second if statement does not work. if I do the redirect just using the first if statement, it works. ANy ideas on why this could be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Huge rowcounts in CFCLIENTS database
Hi Guys, I just decided to take a look at our CFCLIENTS database and was alarmed at the rowcounts: CDATA 30825485 rows CGLOBAL 34472178 rows Does this seem ridiculously high? We do have to restart CF from time to time due to issues with lots of file manipulations/image creation etc. So would this mean that the session data becomes orphaned from real sessions? And if the counts seem high what is the safe way to purge these tables? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation not working
I see /test/folder1 On Thu, Nov 15, 2012 at 11:32 AM, Raymond Camden raymondcam...@gmail.comwrote: So when you output cgi.http_url, what do you see? On Thu, Nov 15, 2012 at 11:31 AM, fun and learning funandlrnn...@gmail.comwrote: Hi All - I am using the following code to redirect a page cfif cgi.http_host EQ abc.com cfif cgi.http_url EQ /test/folder1 cflocation statuscode=301 addtoken=false url= http://abc.com/test/folder2; /cfif /cfif The second if statement does not work. if I do the redirect just using the first if statement, it works. ANy ideas on why this could be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Huge rowcounts in CFCLIENTS database
how often do you have it set to purge ? We use cookie a sthe default storage method for client variables for years, never had any issues with it so far. On Thu, Nov 15, 2012 at 5:33 PM, Ian Chapman ian.chap...@melodimedia.co.ukwrote: Hi Guys, I just decided to take a look at our CFCLIENTS database and was alarmed at the rowcounts: CDATA 30825485 rows CGLOBAL 34472178 rows Does this seem ridiculously high? We do have to restart CF from time to time due to issues with lots of file manipulations/image creation etc. So would this mean that the session data becomes orphaned from real sessions? And if the counts seem high what is the safe way to purge these tables? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation not working
And if you output some text before the cflocation, does it work? On Thu, Nov 15, 2012 at 11:34 AM, funand learning funandlrnn...@gmail.comwrote: I see /test/folder1 On Thu, Nov 15, 2012 at 11:32 AM, Raymond Camden raymondcam...@gmail.com wrote: So when you output cgi.http_url, what do you see? On Thu, Nov 15, 2012 at 11:31 AM, fun and learning funandlrnn...@gmail.comwrote: Hi All - I am using the following code to redirect a page cfif cgi.http_host EQ abc.com cfif cgi.http_url EQ /test/folder1 cflocation statuscode=301 addtoken=false url= http://abc.com/test/folder2; /cfif /cfif The second if statement does not work. if I do the redirect just using the first if statement, it works. ANy ideas on why this could be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cflocation not working
Your problem is the cgi vars. Test it without the if statements and see if it works. If it does, it's you cgi var statements that need some work. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Huge rowcounts in CFCLIENTS database
We're using a CFCLIENTS database as we run a load balanced cluster. Purge is set to 90 days which I *presume* was the default. Does maybe seem excessive? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 15 November 2012 17:36 To: cf-talk Subject: Re: Huge rowcounts in CFCLIENTS database how often do you have it set to purge ? We use cookie a sthe default storage method for client variables for years, never had any issues with it so far. On Thu, Nov 15, 2012 at 5:33 PM, Ian Chapman ian.chap...@melodimedia.co.ukwrote: Hi Guys, I just decided to take a look at our CFCLIENTS database and was alarmed at the rowcounts: CDATA 30825485 rows CGLOBAL 34472178 rows Does this seem ridiculously high? We do have to restart CF from time to time due to issues with lots of file manipulations/image creation etc. So would this mean that the session data becomes orphaned from real sessions? And if the counts seem high what is the safe way to purge these tables? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Huge rowcounts in CFCLIENTS database
Yes, 90 days is the default, and it is absolutely excessive! How long do you really need that data to stick around? 30 days? I doubt it. I bet 7 days is plenty long enough, 1 or 2 days is enough for any normal application. Often, the database cleanup doesn't actually happen, so you have to do it yourself. Also, transitioning away from client variables and into a more specific database structure (as opposed to the vertical storage [1 row per data element] that is used by client vars) would help you out a lot. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Thu, Nov 15, 2012 at 10:42 AM, Ian Chapman ian.chap...@melodimedia.co.uk wrote: We're using a CFCLIENTS database as we run a load balanced cluster. Purge is set to 90 days which I *presume* was the default. Does maybe seem excessive? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 15 November 2012 17:36 To: cf-talk Subject: Re: Huge rowcounts in CFCLIENTS database how often do you have it set to purge ? We use cookie a sthe default storage method for client variables for years, never had any issues with it so far. On Thu, Nov 15, 2012 at 5:33 PM, Ian Chapman ian.chap...@melodimedia.co.ukwrote: Hi Guys, I just decided to take a look at our CFCLIENTS database and was alarmed at the rowcounts: CDATA 30825485 rows CGLOBAL 34472178 rows Does this seem ridiculously high? We do have to restart CF from time to time due to issues with lots of file manipulations/image creation etc. So would this mean that the session data becomes orphaned from real sessions? And if the counts seem high what is the safe way to purge these tables? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation not working
I put this code in application.cfm, but when I put it in some other common include file it works. How to make this work in application.cfm file? On Thu, Nov 15, 2012 at 11:42 AM, Robert Harrison rob...@austin-williams.com wrote: Your problem is the cgi vars. Test it without the if statements and see if it works. If it does, it's you cgi var statements that need some work. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Huge rowcounts in CFCLIENTS database
Ok thanks, we'll look at lowering the purge time for now. -Original Message- From: Nathan Strutz [mailto:str...@gmail.com] Sent: 15 November 2012 18:00 To: cf-talk Subject: Re: Huge rowcounts in CFCLIENTS database Yes, 90 days is the default, and it is absolutely excessive! How long do you really need that data to stick around? 30 days? I doubt it. I bet 7 days is plenty long enough, 1 or 2 days is enough for any normal application. Often, the database cleanup doesn't actually happen, so you have to do it yourself. Also, transitioning away from client variables and into a more specific database structure (as opposed to the vertical storage [1 row per data element] that is used by client vars) would help you out a lot. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Thu, Nov 15, 2012 at 10:42 AM, Ian Chapman ian.chap...@melodimedia.co.uk wrote: We're using a CFCLIENTS database as we run a load balanced cluster. Purge is set to 90 days which I *presume* was the default. Does maybe seem excessive? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 15 November 2012 17:36 To: cf-talk Subject: Re: Huge rowcounts in CFCLIENTS database how often do you have it set to purge ? We use cookie a sthe default storage method for client variables for years, never had any issues with it so far. On Thu, Nov 15, 2012 at 5:33 PM, Ian Chapman ian.chap...@melodimedia.co.ukwrote: Hi Guys, I just decided to take a look at our CFCLIENTS database and was alarmed at the rowcounts: CDATA 30825485 rows CGLOBAL 34472178 rows Does this seem ridiculously high? We do have to restart CF from time to time due to issues with lots of file manipulations/image creation etc. So would this mean that the session data becomes orphaned from real sessions? And if the counts seem high what is the safe way to purge these tables? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
Works just like the full version, and it's what I use on my VPS. On Thu, Nov 15, 2012 at 5:23 AM, Kevin Parker tras...@internode.on.netwrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353196 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Security Question(s)
First thing is you will want o wrap all of your query variables with a cfqueryparam tag. I also wrap them with the XMLFormat() function as that will render strings non-executable. For example... Select x,y,z From tablename Where xx=cfqueryparam cfsqltype=CF_SQL_Integer value=#XMLFormat(variable.xxddrr) There are also other attributes to tighten it down further like if it is allowed to ne null, or a list, etc... The other big thing is to make sure your variables are scoped. This makes it so that you know exactly where it is coming from and prevents overriding from a source that s higher up in the order of operations. Local vars get the variables scope. Then ther is URL, form, application, session, etc... This will cover cross site scripting and SQL injection. Three Ravens Consulting Eric Roberts Owner/Developer ow...@threeravensconsulting.com tel: 630-486-5255 fax: 630-310-8531 http://www.threeravensconsulting.com I haven't done Coldfusion since CF4, however recently have been tasked to look at a CF7MX appilication that has 3 security issues they are looking to fix. 1. Cross Site Scripting - I believe I have this one figured out using the Admin Pannel's Enable global script protection 2. Format String Injection 3. Parameter Based Buffer Overflow I have been able to find generalized information on the other two issues, but nothing as it relates to CF itself. Will the Enable global script protection fix these other two as well or should I be looking elsewhere? Everything I am finding has to do with SQL injection and not Format String Injection, and I'm finding nothing on Parameter Based Buffer Overflow. Any help anyone could provide would be great. Thanks, Jamie Thanks. I know to use the cfparam and cfqueryparam tags to prevent sql injection and xss, will this also prevent these other two errors I listed? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Security Question(s)
I haven't done Coldfusion since CF4, however recently have been tasked to look at a CF7MX appilication that has 3 security issues they are looking to fix. 1. Cross Site Scripting - I believe I have this one figured out using the Admin Pannel's Enable global script protection 2. Format String Injection 3. Parameter Based Buffer Overflow I have been able to find generalized information on the other two issues, but nothing as it relates to CF itself. Will the Enable global script protection fix these other two as well or should I be looking elsewhere? Everything I am finding has to do with SQL injection and not Format String Injection, and I'm finding nothing on Parameter Based Buffer Overflow. First, no, enabling global script protection will not fix all three issues. In fact, it's not guaranteed to fix XSS issues; although it may block many XSS attacks, it doesn't prevent XSS attacks generally, it just filters data for known XSS attack strings. XSS attacks occur when an attacker can send client-side executable code (typically JavaScript, but it could be anything else that an HTML page can tell a local computer to do) to your server, and your server stores that and later delivers it to other users. The attack isn't really targeting the server specifically, but rather those other users. The other two things are attacks on your server, and are basically similar to SQL injection: the attacker sends a value that your code takes and passes directly to a function. XSS filtering has nothing to do with them. For example, let's say you have a line of code like this: cfinclude template=#form.nextpage#.cfm An attacker could inject a value there, because you're taking data directly from the browser and using it to do something. Now, that specific attack wouldn't be very helpful to an attacker in most cases, but it shows you what I mean, I guess. 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. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Huge rowcounts in CFCLIENTS database
I just decided to take a look at our CFCLIENTS database and was alarmed at the rowcounts: CDATA 30825485 rows CGLOBAL 34472178 rows Does this seem ridiculously high? Yes, that's quite high. Like others have said, the purge functionality in CF both has a very long default and doesn't work very well anyway. I recommend you create a database task to do this more frequently. We do have to restart CF from time to time due to issues with lots of file manipulations/image creation etc. So would this mean that the session data becomes orphaned from real sessions? First, it's important to differentiate Session from Client. They're two different things. So, I'll assume you're not actually using the CF Session scope, just the Client scope. Second, if my assumption above is correct, restarting CF will have no effect on users being orphaned from their Client data, as you're not storing that in memory, but rather in the database. Users will have access to the Client data as long as their cookies are intact. 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. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
the things cut out of the express version are the kinds of things we use coldfusion for anyway. I havent found any issues at all in connecting SQLexpress versions and Coldfusion. The only issues I've had are to do with things like the lack of SSIS which makes things like moving data to online more difficult that's all. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Nov 16, 2012 at 6:32 AM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: Works just like the full version, and it's what I use on my VPS. On Thu, Nov 15, 2012 at 5:23 AM, Kevin Parker tras...@internode.on.net wrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
Oh, and I don't think you can run scheduled backups either. Which is an issue when using it in production. On 11/15/12 1:32 PM, Mike Kear wrote: the things cut out of the express version are the kinds of things we use coldfusion for anyway. I havent found any issues at all in connecting SQLexpress versions and Coldfusion. The only issues I've had are to do with things like the lack of SSIS which makes things like moving data to online more difficult that's all. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Nov 16, 2012 at 6:32 AM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: Works just like the full version, and it's what I use on my VPS. On Thu, Nov 15, 2012 at 5:23 AM, Kevin Parker tras...@internode.on.net wrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
Oh, and I don't think you can run scheduled backups either. Which is an issue when using it in production. We use Tomahawk Backup on some of our web servers to back up the website code and images to both local and off-site storage. Tomahawk (and many other backup utilities) will interface with SQL Server (even the Express edition which we have deployed in production in a few places) and back up your databases locally and off-site as well. Works out pretty well. -Justin Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
You do get ssis and backups its just not in the sql management studio so you have to script it. Or downliad the full trial version with tools and get studio from there instead. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Nov 15, 2012 10:25 PM, Justin Scott leviat...@darktech.org wrote: Oh, and I don't think you can run scheduled backups either. Which is an issue when using it in production. We use Tomahawk Backup on some of our web servers to back up the website code and images to both local and off-site storage. Tomahawk (and many other backup utilities) will interface with SQL Server (even the Express edition which we have deployed in production in a few places) and back up your databases locally and off-site as well. Works out pretty well. -Justin Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
Or downliad the full trial version with tools and get studio from there instead. Yeah, what Russ said. I think the trial version is good for 6 months. IIRC you can also get the MSSQL developer edition for $40-$50. It is the equivalent of the Enterprise version. Not sure if the Licencing allows you to use Management Studio to push changes to production Databases. I don't see why not. You might be eligible to get the Web addition for free via the WebsiteSpark program http://www.microsoft.com/web/websitespark/ Web edition removes the Ram and Database size limitations. It might be worth a try. In any event, here is the feature matrix for the different versions. http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx HTH G! On Thu, Nov 15, 2012 at 6:03 PM, Russ Michaels r...@michaels.me.uk wrote: You do get ssis and backups its just not in the sql management studio so you have to script it. Or downliad the full trial version with tools and get studio from there instead. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Nov 15, 2012 10:25 PM, Justin Scott leviat...@darktech.org wrote: Oh, and I don't think you can run scheduled backups either. Which is an issue when using it in production. We use Tomahawk Backup on some of our web servers to back up the website code and images to both local and off-site storage. Tomahawk (and many other backup utilities) will interface with SQL Server (even the Express edition which we have deployed in production in a few places) and back up your databases locally and off-site as well. Works out pretty well. -Justin Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
When I last used that trick the management studio never stopped working, only sql server, so unlrss they have changed that, its a free way to get more features out of express edition. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Nov 15, 2012 11:54 PM, Gerald Guido gerald.gu...@gmail.com wrote: Or downliad the full trial version with tools and get studio from there instead. Yeah, what Russ said. I think the trial version is good for 6 months. IIRC you can also get the MSSQL developer edition for $40-$50. It is the equivalent of the Enterprise version. Not sure if the Licencing allows you to use Management Studio to push changes to production Databases. I don't see why not. You might be eligible to get the Web addition for free via the WebsiteSpark program http://www.microsoft.com/web/websitespark/ Web edition removes the Ram and Database size limitations. It might be worth a try. In any event, here is the feature matrix for the different versions. http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx HTH G! On Thu, Nov 15, 2012 at 6:03 PM, Russ Michaels r...@michaels.me.uk wrote: You do get ssis and backups its just not in the sql management studio so you have to script it. Or downliad the full trial version with tools and get studio from there instead. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Nov 15, 2012 10:25 PM, Justin Scott leviat...@darktech.org wrote: Oh, and I don't think you can run scheduled backups either. Which is an issue when using it in production. We use Tomahawk Backup on some of our web servers to back up the website code and images to both local and off-site storage. Tomahawk (and many other backup utilities) will interface with SQL Server (even the Express edition which we have deployed in production in a few places) and back up your databases locally and off-site as well. Works out pretty well. -Justin Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
Starting with SQL Server Express 2008 R2 (and maybe some prior versions), you can download an installer that includes the SSMS tools, which I think includes SSIS as well. -Carl V. On 11/15/2012 1:32 PM, Mike Kear wrote: the things cut out of the express version are the kinds of things we use coldfusion for anyway. I havent found any issues at all in connecting SQLexpress versions and Coldfusion. The only issues I've had are to do with things like the lack of SSIS which makes things like moving data to online more difficult that's all. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Nov 16, 2012 at 6:32 AM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: Works just like the full version, and it's what I use on my VPS. On Thu, Nov 15, 2012 at 5:23 AM, Kevin Parker tras...@internode.on.net wrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
