Re: number of active sessions in memory of CF
Nobody has an idea? KR, Pierre ~| 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:340460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Show time in field on click
I was thinking the same thing. But nevermind.
On Tue, Jan 4, 2011 at 6:48 PM, Russ Michaels r...@michaels.me.uk wrote:
Still missing the point, but nevermind.
-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz]
Sent: 04 January 2011 18:21
To: cf-talk
Subject: Re: SOT: Show time in field on click
Right. But it's not the use of getElementById that fixed your code. It's
the fact you actually spelled the item correctly. Had you simply changed
mydate to myDate with your original code it would have worked fine.
On Tue, Jan 4, 2011 at 1:14 PM, Orlini, Robert rorl...@hwwilson.com
wrote:
Michael,
I have to agree despite my limited experience. My code below with the ID
and the getElementById() works fine. Nonetheless, I appreciated your
assistance. All suggestions worked to the final solution. I included the
toLocaleTimeString();
code just to get the time and no date.
Thanks agin.
RO
HWW
script type=text/javascript
function show_now() {
var my_time = new Date();
document.getElementById('myDate').value = my_time.toLocaleTimeString();
}
/script
form name=myForm
input type=text name=myDate id=myDate size=9
input type=button value=Bounce Start Time onclick=show_now();
/form
-Original Message-
From: Russ Michaels r...@michaels.me.uk
Sent: Tuesday, January 4, 2011 1:05pm
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: SOT: Show time in field on click
Michael,
you do indeed need an ID to be defined to use getElementById(), the clue
is
in the function itself, it gets the DOM reference for an object by its
ID,
if you do not have such an ID then it will not find the object.
Feel free to look it up on the w3c site or similar.
Russ
On Tue, Jan 4, 2011 at 3:44 PM, Michael Grant mgr...@modus.bz wrote:
That's not true at all. You don't need id defined.
The following code is completely functional.
html
head
script type=text/javascript
function show_now() {
var my_time = new Date();
document.myForm.myDate.value = my_time;
}
/script
/head
body
form name=myForm
input name=myDate type=text size=10 /
input type=button value=Show Time onclick=show_now();
/form
/body
/html
On Tue, Jan 4, 2011 at 10:36 AM, Russ Michaels r...@michaels.me.uk
wrote:
try this
document.getElementById('myDate').value = my_time;
your field must have an id of myDate
e.g.
input type=text name=myDate id=myDate
Russ
On Tue, Jan 4, 2011 at 3:27 PM, Michael Grant mgr...@modus.bz
wrote:
No, they refer to the name attribute.
Otherwise it's document.getElementById(myDate).
On Tue, Jan 4, 2011 at 10:26 AM, Ian Skinner h...@ilsweb.com
wrote:
On 1/4/2011 7:16 AM, Orlini, Robert wrote:
Still not showing when I click the button. I also tried putting
my_time
into the field.
RO
document.myForm.myDate.value = my_time;
IIRC, I believe that those refer to the ID's of DOM elements, not
names.
Try changing your form to.
form id=myForm
input id=myDate type=text size=10 /
~|
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:340461
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Steve, I'm personally not sure if yet another framework is needed, we have quite a few now from simple (cfwheels or FW/1) for all singing all dancing OOP behemoths (ColdBox) but kudos for trying and I hope it works out for you. While I think all these security concerns are valid, and it would be gr8 if your framework handled these automatically, I think perhaps other are being a bit harsh and jumping on your back a bit quick. I wonder if the other frameworks and popular open source apps have been scrutinised like this and cover all these security bases and are this secure, I wouldn't like to bet any money on it, and I certainly know that some of the ones I have used really do little more than use CFPARAM or CFQUERYPARAM to protect against injection, and there is certainly no consideration for the temp file execution scenario. I have not read the entire conversation so I do not know the context of the file uploads inside webroot, but if this is only for installation/setup then I would not consider this a security concern as only the admin will be doing this and then presumably this feature will be disabled anyway. The most popular apps in the world with web based installers do not even cater for this scenario, such as wordpress for example, they simply make sure that the installer/setup no longer works once you have completed the process so that a hacker cannot get in and mess with your site. If that is not the context for this issue and it is uploads in general, then I guess that is a moot point. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~| 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:340462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFC binding to multiple cfselects
Hi guys im having trouble with this setup.
Let me explain - I have three cfselect fields and each one of them is related
so we have category / sub-category / products.
I keep getting and Internal Server Error when i initially browse to the page.
yet the cfselects all work correctly producing the correct information and if i
was to change the category or the sub category then again they all work without
any error messages, it just happens when i go to the page for the first time so
i think the problem might be when the cfc loads.
Attached below is the CFC and also the cfm page with trimmed down.
Thanks
CFC
cfcomponent output=false
cfset THIS.dsn=#application.dsn#
!--- Get array of media types ---
cffunction name=getCategory access=remote returnType=array
!--- Define variables ---
cfset var data=
cfset var result=ArrayNew(2)
cfset var i=0
!--- Get data ---
cfquery name=data datasource=#THIS.dsn#
SELECT ID as categoryid, PROD_CATEGORY as category
FROM PRODUCT_CATEGORY
ORDER BY category
/cfquery
!--- Convert results to array ---
cfloop index=i from=1 to=#data.RecordCount#
cfset result[i][1]=data.categoryid[i]
cfset result[i][2]=data.category[i]
/cfloop
!--- And return it ---
cfreturn result
/cffunction
!--- Get art by media type ---
cffunction name=getsubcategory access=remote returnType=array
cfargument name=categoryid type=numeric required=true
!--- Define variables ---
cfset var data=
cfset var result=ArrayNew(2)
cfset var i=0
!--- Get data ---
cfquery name=data datasource=#THIS.dsn#
SELECT dbo.PROD_SUB_CATEGORY.SUB_CATEGORY as product,
dbo.PROD_SUB_CATEGORY.ID as productid
FROM dbo.PRODUCT_CATEGORY INNER JOIN
dbo.PROD_SUB_CATEGORY ON dbo.PRODUCT_CATEGORY.ID =
dbo.PROD_SUB_CATEGORY.REL_PRODUCT_CATEGORY
WHERE (dbo.PROD_SUB_CATEGORY.REL_PRODUCT_CATEGORY = #ARGUMENTS.categoryid#)
/cfquery
cfloop index=i from=1 to=#data.RecordCount#
cfset result[i][1]=data.productid[i]
cfset result[i][2]=data.product[i]
/cfloop
!--- And return it ---
cfreturn result
/cffunction
!--- Get art by media type ---
cffunction name=getproducts access=remote returnType=array
cfargument name=categoryid type=numeric required=true
cfargument name=subcategoryid type=numeric required=true
!--- Define variables ---
cfset var data=
cfset var result=ArrayNew(2)
cfset var i=0
!--- Get data ---
cfquery name=data datasource=#THIS.dsn#
SELECT ID as productid, DESCRIPTION as product
FROM PRODUCTS
WHERE REL_PROD_CATEGORY = #ARGUMENTS.categoryid# AND
(REL_PROD_SUB_CATEGORY = #ARGUMENTS.subcategoryid#)
ORDER BY product
/cfquery
!--- Convert results to array ---
cfloop index=i from=1 to=#data.RecordCount#
cfset result[i][1]=data.productid[i]
cfset result[i][2]=data.product[i]
/cfloop
!--- And return it ---
cfreturn result
/cffunction
/cfcomponent
CFM
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titleUntitled Document/title
/head
bodycfform name=form1 id=form1
table width=678 height=125 border=0 align=center cellpadding=0
cellspacing=0 class=normal_text
tr
td width=86nbsp;/td
td width=218 class=field_labelnbsp;/td
td width=25nbsp;/td
td width=349nbsp;/td
/tr
tr
tdnbsp;/td
td class=field_labelProduct Category/td
tdnbsp;/td
tdcfselect bind=cfc:products.getcategory() bindonload=true
name=categoryid class=field_medium id=categoryid //td
/tr
tr
td height=28nbsp;/td
td class=field_labelProduct Sub Category/td
tdnbsp;/td
tdcfselect bind=cfc:products.getsubcategory({categoryid})
name=subcategoryid class=field_medium id=subcategoryid //td
/tr
tr
td height=28nbsp;/td
td class=field_labelProduct/td
tdnbsp;/td
tdcfselect bind=cfc:products.getproducts({categoryid},{subcategoryid})
name=search1 class=field_xlarge id=search1 //td
/tr
tr
td height=38nbsp;/td
td class=field_labelemTip:/em Enter search criteria and click show
records, clicking show records./td
tdnbsp;/td
tdinput type=button name=button2 style=width:100px class=style4
id=button2 onclick=BtnSearch() value=Show Records //td
/tr
/table
/cfform
/body
/html
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Re: (ot) jQuery Facebook Wall Display
Justin, Are you looking for the Recent Activity as shown on this site: http://www.campuscircle.com/ Dan On Tue, Jan 4, 2011 at 8:04 AM, Justin Scott jsc...@gravityfree.com wrote: Is anyone aware of a jQuery plugin (or script which uses jQuery) to pull a Facebook feed from their graph API and display it on the page in a manner similar to how the Facebook wall is displayed? We have a client who would like to display a Facebook stream on their home page similar to how many people display their Twitter feed on their home pages. Unfortunately it appears as though all of the social plugins that Facebook makes available revolve around the like button or showing what a visitor's friends have liked or shared on a site. Essentially they want to take what they post to their wall and have it show up on their homepage as well. Any suggestions? My Google-fu is failing me this morning. -Justin PS: Yes, we can roll our own but would prefer something we can drop in before we spend a lot of time reinventing the wheel if it exists somewhere already. Thanks! ~| 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:340464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Grid Suggestion
Hi All- Currently i have a grid with around 25 to 30 columns. a)The first 5 columns are frozen columns. The data for these columns are text values or simple numbers b) The values for other 25 columns are images. c) Also implementing highlight row functionality on hover and on click of the row. d) The database queries are very fast, but the UI rendering is very sluggish. The above table is right now implemented using HTML, css, javascript. Tried using alternatives like jqgrid, but it does not have column freezing functionality. Are there any other grids out there which would be a much better choice. Is using Flex a good idea? Thanks ~| 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:340465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grid Suggestion
Not sure about column freezing but I'd take a look at SlickGrid: https://github.com/mleibman/SlickGrid/wiki On Wed, Jan 5, 2011 at 10:05 AM, fun and learning funandlrnn...@gmail.comwrote: Hi All- Currently i have a grid with around 25 to 30 columns. a)The first 5 columns are frozen columns. The data for these columns are text values or simple numbers b) The values for other 25 columns are images. c) Also implementing highlight row functionality on hover and on click of the row. d) The database queries are very fast, but the UI rendering is very sluggish. The above table is right now implemented using HTML, css, javascript. Tried using alternatives like jqgrid, but it does not have column freezing functionality. Are there any other grids out there which would be a much better choice. Is using Flex a good idea? Thanks ~| 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:340466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Calling local web service, AXIS error
Hi, I'm trying to call a local web service and I receive an AXIS error each time. I'm running WinXP, CF 8.01, Apache 2.2, and Java 1.6.0_04. My paths are correct in my vhsots as I can invoke components, but not when I call a web service. I even tried manually entering it in the admin and clearing my webservice cache and I still get the same error. Any ideas? Here is the error: AXIS error Sorry, something seems to have gone wrong... here are the details: Exception - java.lang.NoClassDefFoundError: javax/wsdl/extensions/AttributeExtensible java.lang.NoClassDefFoundError: javax/wsdl/extensions/AttributeExtensible at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:620) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) at java.net.URLClassLoader.defineClass(URLClassLoader.java:260) at java.net.URLClassLoader.access$000(URLClassLoader.java:56) at java.net.URLClassLoader$1.run(URLClassLoader.java:195) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.java:221) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at com.ibm.wsdl.factory.WSDLFactoryImpl.newDefinition(Unknown Source) at org.apache.axis.wsdl.fromJava.Emitter.createDefinition(Emitter.java:730) at org.apache.axis.wsdl.fromJava.Emitter.getWSDL(Emitter.java:473) at org.apache.axis.wsdl.fromJava.Emitter.emit(Emitter.java:331) at coldfusion.xml.rpc.CFCProvider.generateWSDL(CFCProvider.java:186) at org.apache.axis.strategies.WSDLGenStrategy.visit(WSDLGenStrategy.java:33) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.generateWSDL(SimpleChain.java:104) at org.apache.axis.handlers.soap.SOAPService.generateWSDL(SOAPService.java:319) at org.apache.axis.server.AxisServer.generateWSDL(AxisServer.java:482) at org.apache.axis.transport.http.QSWSDLHandler.invoke(QSWSDLHandler.java:68) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.axis.transport.http.AxisServlet.processQuery(AxisServlet.java:1217) at org.apache.axis.transport.http.AxisServlet.doGet(AxisServlet.java:249) at coldfusion.xml.rpc.CFCServlet.doAxisGet(CFCServlet.java:244) at coldfusion.filter.AxisFilter.invoke(AxisFilter.java:39) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.CFCFlushFilter.invoke(CFCFlushFilter.java:26) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:138) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at
Re: Grid Suggestion
Not sure about column freezing but I'd take a look at SlickGrid: https://github.com/mleibman/SlickGrid/wiki On Wed, Jan 5, 2011 at 10:05 AM, fun and learning funandlrnn...@gmail.comwrote: Hi Michael, Thanks for the suggestion. is there an example of using slickgrid with coldfusion for dynamically loading data? ~| 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:340468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grid Suggestion
I don't have any examples here at the office but I have used it on personal projects without much trouble. View source is your friend here. Look at the examples and you'll see the JSON used to pass data in and you can recreate it based on that. On Wed, Jan 5, 2011 at 11:13 AM, fun and learning funandlrnn...@gmail.comwrote: Not sure about column freezing but I'd take a look at SlickGrid: https://github.com/mleibman/SlickGrid/wiki On Wed, Jan 5, 2011 at 10:05 AM, fun and learning funandlrnn...@gmail.comwrote: Hi Michael, Thanks for the suggestion. is there an example of using slickgrid with coldfusion for dynamically loading data? ~| 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:340469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Russ, Thanks for your comment and encouragement. The scrutiny is certainly valid. I don't think the problem is as serious as it first appeared, but it is with regard to all uploaded files handled by the framework so it is a pretty significant area of concern and definitely something I am glad to have others help me think through. As to the need for another framework, I think I have heard that point raised about every ColdFusion framework released since Fusebox came out (We already have Fusebox, why do we need another framework?). In this case, I think Neptune is quite a bit different from what is out there already. For one thing, all the other major frameworks route all requests through index.cfm and Neptune doesn't. Assuming I am not the only one who dislike this paradigm then it is worth offering it for that. For another, I think (keeping in mind that I am biased) that it is much easier than any other framework. Almost every time I read about how to something in another framework I think It is easier than that for us. For anyone even a little curious, I would recommend reading the Getting Started section. It includes links to how to do the same thing in ModelGlue:Unity and in CFWheels. You can imagine it in other frameworks as well. See for yourself which you think is easier. http://www.bryantwebconsulting.com/docs/neptune/installation.cfm I'm not trying to knock other frameworks here (easier often depends on the problems being solved, for example) - just to point out that I think Neptune does have something different to offer than what exists already. Thanks, Steve Steve, I'm personally not sure if yet another framework is needed, we have quite a few now from simple (cfwheels or FW/1) for all singing all dancing OOP behemoths (ColdBox) but kudos for trying and I hope it works out for you. While I think all these security concerns are valid, and it would be gr8 if your framework handled these automatically, I think perhaps other are being a bit harsh and jumping on your back a bit quick. I wonder if the other frameworks and popular open source apps have been scrutinised like this and cover all these security bases and are this secure, I wouldn't like to bet any money on it, and I certainly know that some of the ones I have used really do little more than use CFPARAM or CFQUERYPARAM to protect against injection, and there is certainly no consideration for the temp file execution scenario. I have not read the entire conversation so I do not know the context of the file uploads inside webroot, but if this is only for installation/setup then I would not consider this a security concern as only the admin will be doing this and then presumably this feature will be disabled anyway. The most popular apps in the world with web based installers do not even cater for this scenario, such as wordpress for example, they simply make sure that the installer/setup no longer works once you have completed the process so that a hacker cannot get in and mess with your site. If that is not the context for this issue and it is uploads in general, then I guess that is a moot point. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~| 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:340470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Beta Tester Wanted for new CF (MVC) Framework
I can certainly see the advantage in NOT routing everything through index.cfm, it is more SEO friendly without having to use URL rewriting etc, plus I would expect the pages to be more editable. This is one annoying thing with frameworks in general, if you are not using a CMS then editing content can be a real pain as you can't just pop the page open in Dreamweaver and edit the layout as it won't display properly due to the missing formatting and CSS which is in another file. And congrats for coming up with a name that does not have cf cold fusion or fuse in the the name :-) Russ -Original Message- From: Steve Bryant [mailto:st...@bryantwebconsulting.com] Sent: 05 January 2011 17:39 To: cf-talk Subject: Re: Beta Tester Wanted for new CF (MVC) Framework Russ, Thanks for your comment and encouragement. The scrutiny is certainly valid. I don't think the problem is as serious as it first appeared, but it is with regard to all uploaded files handled by the framework so it is a pretty significant area of concern and definitely something I am glad to have others help me think through. As to the need for another framework, I think I have heard that point raised about every ColdFusion framework released since Fusebox came out (We already have Fusebox, why do we need another framework?). In this case, I think Neptune is quite a bit different from what is out there already. For one thing, all the other major frameworks route all requests through index.cfm and Neptune doesn't. Assuming I am not the only one who dislike this paradigm then it is worth offering it for that. For another, I think (keeping in mind that I am biased) that it is much easier than any other framework. Almost every time I read about how to something in another framework I think It is easier than that for us. For anyone even a little curious, I would recommend reading the Getting Started section. It includes links to how to do the same thing in ModelGlue:Unity and in CFWheels. You can imagine it in other frameworks as well. See for yourself which you think is easier. http://www.bryantwebconsulting.com/docs/neptune/installation.cfm I'm not trying to knock other frameworks here (easier often depends on the problems being solved, for example) - just to point out that I think Neptune does have something different to offer than what exists already. Thanks, Steve Steve, I'm personally not sure if yet another framework is needed, we have quite a few now from simple (cfwheels or FW/1) for all singing all dancing OOP behemoths (ColdBox) but kudos for trying and I hope it works out for you. While I think all these security concerns are valid, and it would be gr8 if your framework handled these automatically, I think perhaps other are being a bit harsh and jumping on your back a bit quick. I wonder if the other frameworks and popular open source apps have been scrutinised like this and cover all these security bases and are this secure, I wouldn't like to bet any money on it, and I certainly know that some of the ones I have used really do little more than use CFPARAM or CFQUERYPARAM to protect against injection, and there is certainly no consideration for the temp file execution scenario. I have not read the entire conversation so I do not know the context of the file uploads inside webroot, but if this is only for installation/setup then I would not consider this a security concern as only the admin will be doing this and then presumably this feature will be disabled anyway. The most popular apps in the world with web based installers do not even cater for this scenario, such as wordpress for example, they simply make sure that the installer/setup no longer works once you have completed the process so that a hacker cannot get in and mess with your site. If that is not the context for this issue and it is uploads in general, then I guess that is a moot point. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~| 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:340471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Exactly! No need to set up URL rewriting and if you want to edit content for the URL /my-folder/my-file.cfm then just open the file at that location and edit it. If you want to set up some URL rewriting so that the URL is /my-folder/my-file/ (or anything else) instead, nothing in the framework will get in your way. Oh yeah, no need to modify your traffic reporting software. It was tempting to follow those CF naming conventions, but I managed to resist. :-) Steve I can certainly see the advantage in NOT routing everything through index.cfm, it is more SEO friendly without having to use URL rewriting etc, plus I would expect the pages to be more editable. This is one annoying thing with frameworks in general, if you are not using a CMS then editing content can be a real pain as you can't just pop the page open in Dreamweaver and edit the layout as it won't display properly due to the missing formatting and CSS which is in another file. And congrats for coming up with a name that does not have cf cold fusion or fuse in the the name :-) Russ ~| 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:340472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) jQuery Facebook Wall Display
Are you looking for the Recent Activity as shown on this site: http://www.campuscircle.com/ Not exactly. That plugin shows what other people are doing with the content on the site (i.e. so-and-so shared such-and-such page) and would be customized to the visitor if they were logged in to Facebook and one of their friends had shared something on the site. The client in this case is looking to have their wall posts (status updates and the like) show up on the page similar to how people post their own Twitter posts on their site. I'm baffled, but there doesn't seem to be anything out there that does this. The data is all available through the graph API and we're this close to rolling our own. Thanks for looking though. -Justin ~| 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:340473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL 2008 standard vs. web
There are a few different versions of SQL 2008. One of them is billed as SQL server web which is focused on being the backend for a data driven website. Has anyone used this and have they had any problems? Any real differences between this and SQL 2008 standard? I'm inclined to go with the web version based on what I've read but first hand feedback is best. Thanks Michael ~| 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:340474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL 2008 standard vs. web
They're close, but not quite the same. The primary difference is the licensing . The other differences are around mirroring (web can only serve as a witness), publishing (web can only subscribe), and perf (web does not come with SQL Profiler). There are more differences when you get out of the SQL Engine and into SSIS, SSAS, and SSRS. Full comparison of all editions here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels ~| 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:340475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL 2008 standard vs. web
There are a few different versions of SQL 2008. One of them is billed as SQL server web which is focused on being the backend for a data driven website. Has anyone used this and have they had any problems? The engine itself should be essentially the same between editions, the main differences will be in the cost and licensing (how many CPUs, memory it can use, etc.). My understanding is that the Web edition is targeted at larger web hosting companies that need to offer SQL server as a back-end, or for larger single customers who have a large web infrastructure. It is only available under a volume licensing plan, so if you just want one copy you're likely better off purchasing standard (assuming that SQL Express doesn't meet your needs for free). -Justin ~| 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:340476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL 2008 standard vs. web
There are a few different versions of SQL 2008. One of them is billed as SQL server web which is focused on being the backend for a data driven website. Has anyone used this and have they had any problems? Any real differences between this and SQL 2008 standard? I'm inclined to go with the web version based on what I've read but first hand feedback is best. If you're just setting up a standalone web application, the Web edition will work fine. If you need replication, mirroring, etc, you need at least Standard. 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:340477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Auto Complete
Hello All, I am running CF8 and I would like to implement a text box that would auto-complete with a drop down. I would like it to work as if I was using Outlook to look up a person in the Data-base. ~| 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:340478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto Complete
On Wed, Jan 5, 2011 at 12:32 PM, George Campbell gtc1...@gmail.com wrote: Hello All, I am running CF8 and I would like to implement a text box that would auto-complete with a drop down. I would like it to work as if I was using Outlook to look up a person in the Data-base. http://jqueryui.com/demos/autocomplete/ Works a treat. I just implemented it for a customer running CF 7. -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of succes ~| 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:340479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) passing URL parameters
Not strictly CF but at least it's in a CF program... a href=AnotherPage.cfm?id=4duh=somethingdit=else In AnotherPage.cfm are references #URL.id#, etc. If everything (at least as far as the URL references) is correct, I get a page not found error. If I intentionally cause an error, say by leaving out dit=else, then the page is found and the error is displayed. If germaine, the page I'm calling outputs an Excel file... I'm at a loss. Larry Stephens ~| 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:340480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can CF catch this specific error?
I want to try and catch this and only this specific error with CF. Possible? and if so how exactly would I do that? coldfusion.tagext.io.FileUtils$InvalidUploadTypeException: The MIME type of the uploaded file image/pjpeg was not accepted by the server. ~| 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:340481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto Complete
It's actually built-in to ColdFusion 8's cfinput tag. cfinput autosuggest=... / http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_07.html -Adam On Wed, Jan 5, 2011 at 2:42 PM, Charlie Griefer charlie.grie...@gmail.comwrote: On Wed, Jan 5, 2011 at 12:32 PM, George Campbell gtc1...@gmail.com wrote: Hello All, I am running CF8 and I would like to implement a text box that would auto-complete with a drop down. I would like it to work as if I was using Outlook to look up a person in the Data-base. http://jqueryui.com/demos/autocomplete/ Works a treat. I just implemented it for a customer running CF 7. -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of succes ~| 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:340482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto Complete
Ooh nice. I (obviously) hadn't used the built-in functionality. Did a quick google before answering, but all I saw in the results (at a quick glance) were using the jQuery autocomplete in conjunction with CF, so I assumed it wasn't there (built-in). My bad :) On Wed, Jan 5, 2011 at 2:12 PM, Adrocknaphobia adrocknapho...@gmail.com wrote: It's actually built-in to ColdFusion 8's cfinput tag. cfinput autosuggest=... / http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_07.html -Adam On Wed, Jan 5, 2011 at 2:42 PM, Charlie Griefer charlie.grie...@gmail.comwrote: On Wed, Jan 5, 2011 at 12:32 PM, George Campbell gtc1...@gmail.com wrote: Hello All, I am running CF8 and I would like to implement a text box that would auto-complete with a drop down. I would like it to work as if I was using Outlook to look up a person in the Data-base. http://jqueryui.com/demos/autocomplete/ Works a treat. I just implemented it for a customer running CF 7. -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of succes ~| 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:340483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can CF catch this specific error?
Sure can, this is untested and it will depend on whether it is the details
or message. And this is CF9 script so you can easily translate this back to
tags.
Catch(Any e) {
If(e.details contains ' MIME type of the uploaded file image/pjpeg was not
accepted by the server ') {
//... Do error
Abort;
}
}
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: Don [mailto:danfar...@hotmail.com]
Sent: Thursday, 6 January 2011 8:03 AM
To: cf-talk
Subject: Can CF catch this specific error?
I want to try and catch this and only this specific error with CF.
Possible? and
if so how exactly would I do that?
coldfusion.tagext.io.FileUtils$InvalidUploadTypeException: The MIME type
of the uploaded file image/pjpeg was not accepted by the server.
~~
~~~|
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:340481
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-
talk/unsubscribe.cfm
~|
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:340484
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL 2008 standard vs. web
A primary question to answer is whether you need the business intelligence tools that are part of the SQL Server platform, notably SSIS, which is not available in the Web edition. I use SSIS and SSRS extensively, so I have to use at least the Standard edition. You can always start with a cheap version and switch to the more expensive version later on, unless there is a feature of the Standard version that you know is essential, such as the disaster recovery features that only exist in the more expensive versions. -Mike Chabot On Wed, Jan 5, 2011 at 2:16 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: There are a few different versions of SQL 2008. One of them is billed as SQL server web which is focused on being the backend for a data driven website. Has anyone used this and have they had any problems? Any real differences between this and SQL 2008 standard? I'm inclined to go with the web version based on what I've read but first hand feedback is best. Thanks Michael ~| 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:340485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What's the best way to investigate a Jrun.exe spike?
Occasionally Jrun spikes on my Windows CF9 box. This causes the server to die until I restart ColdFusion. The site receives moderate traffic..some spikes but nothing huge. Ancient question, but what's the best way to investigate this? Thanks ~| 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:340486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the best way to investigate a Jrun.exe spike?
Use cfstart to run coldfusion command line, and then do stack dumps using ctrl-pausebreak when it spikes. There is an adobe tech note on how to do that. In addition to that, Process Monitor from Mark Russinovich is also very good ( and free). On Wed, Jan 5, 2011 at 4:31 PM, Philip Kaplan pkap...@gmail.com wrote: Occasionally Jrun spikes on my Windows CF9 box. This causes the server to die until I restart ColdFusion. The site receives moderate traffic..some spikes but nothing huge. Ancient question, but what's the best way to investigate this? Thanks ~| 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:340487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Accessing Specific CF8 Instances
Is there a way to access particular instances that are running on a load balanced CF8 Enterprise server? If so, how is that done? thanks in advance. ~| 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:340488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFQuery to mdb
I want to output the results to a MSAccess database file. I can output the results to a xls file pretty easily but I need to create a database and save the results to a table. I thought about creating a temp blank database and then creating the table, writing the data to it then copy the database down, deleting the database and writing a blank one just seems like more than I need to do. Rick ~| 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:340489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Accessing Filezilla Server on a EC2 Windows 2008 Server
I've successfully installed Filezilla server and it connects to our EC2 Windows 2008 Server 127.0.0.1. However, Our public ip address assigned by Amazon's elastic ip , works for the website, but not for ftp. I've added Filezilla to the Windows Firewall exception list. Not sure what else to try. Thanks in advance. ~| 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:340490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQuery to mdb
just seems like more than I need to do. I do not think so. It is not like exporting html/excel. An Access database consists of more than just the data itself (system tables, etcetera). So I am not sure there is a simpler way. Maybe using ms sql's export tools .. But why does it need to be a full Access database? Providing a delimited file users could import is simpler and more flexible. As it could be imported into both Excel and Access. ~| 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:340491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing Specific CF8 Instances
You can access the administrator for a particular instance using the internal JRun webserver port. If you want to get to your apps on a particular instance you'll have to manipulate cookies (assuming you're using sticky sessions) so that the session ID starts with the the correct prefix for the instance you want. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 6 January 2011 08:13, Richard Steele r...@photoeye.com wrote: Is there a way to access particular instances that are running on a load balanced CF8 Enterprise server? If so, how is that done? thanks in advance. ~| 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:340492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFHTTP ad DNS servers that do not return error status codes
I'm running into a problem with CFHTTP. I like to use it on some projects to verify a URL before allowing it to be used. The problem I have is that on my local development environment, my DNS servers (Buckeye Express) don't return failure codes if an invalid URL is tested. My DNS instead forwards the request to a BEX web page that has a few ads and links and a search. Think of it like what openDNS does. Is there anything I can do to start getting validations working? If I have CFHTTP checking a site I want to know if I get anything other than a 200 OK return. I could just post the code to production, which is not on BEX servers and works like I want it to, but I really detest the idea of coding and unit testing in a production environment. ~| 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:340493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFQuery to mdb
You can seed a database with the schema then access it through passthrough file syntax... .a single prepared temp DB could do the trick. Basically you have a dummy access DSN setup, then you copy your prepped access file to a temp location, load it with data using the passthrough method, and then allow the user to download it (I usually zip it first). Here's a link to a post on the passthrough method. http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx While I agree with you about a CSV file in many cases, Leigh, sometimes this is useful for exactly the reasons you are suggesting - that extra access stuff allows you to create form interfaces, premade queries etc - enhancing off line data mining for the user. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, January 05, 2011 7:17 PM To: cf-talk Subject: Re: CFQuery to mdb just seems like more than I need to do. I do not think so. It is not like exporting html/excel. An Access database consists of more than just the data itself (system tables, etcetera). So I am not sure there is a simpler way. Maybe using ms sql's export tools .. But why does it need to be a full Access database? Providing a delimited file users could import is simpler and more flexible. As it could be imported into both Excel and Access. ~| 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:340494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
