This will work if the users can produce all the sql. I'm hoping to give them
50/50 where they can browse a table and do simple gui updates like changing
info in a certain column without having to type out all the sql to do it. 

-----Original Message-----
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 29, 2007 5:24 PM
To: CF-Talk
Subject: RE: Access db interface

<cfquery name="myQry" datasource="myaccessdsn"> #form.query# </cfquery>

<cfdump var="#myQry#">

That should probably do the trick.  Of course it's very unsafe, and will
allow people to do anything they want to the db, which is sort of the idea,
I guess.  

Russ

> -----Original Message-----
> From: Scott Raley -ITC [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 29, 2007 4:57 PM
> To: CF-Talk
> Subject: Access db interface
> 
> is there any open source "admin" style interface from CF to an MS 
> access database to give access to raw tables information or a query 
> window or anything of this type?
> 
> Thanks
> 
> 
> 



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292339
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to