CF_jscalendar & FileUpload.cfc

Posted At : October 21, 2008 12:13 AM | Posted By : Admin
Related Categories: JavaScript,ColdFusion,MS SQL SERVER,Open Sores

CF_jscalendar is a port of jscalendar from dynarch.com for CF 5 and above.

FileUpload.cfc is a very simple File Upload component that uploads a file and sanitizes the file name for Windows servers. It was tested on on CF 7 and above and should work on Railo 2+ and (Open) BlueDragon 6.x and above.

Update: Tuesday, 10/21/08 I added set_SQL_permissions.cfm.

It is just a little throw away script that creates the SQL need to grants SELECT, INSERT, DELETE, UPDATE permissions to tables for MSSQL. Setting permissions using the SQL Server Management Studio, in a word, sucks.

Comments (0) |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 618 Views

Setting Permissions after importing data into MS SQL Server.

Posted At : April 13, 2007 7:30 PM | Posted By : Admin
Related Categories: ColdFusion,MS SQL SERVER,Tools

At work we use MS SQL Server for our intranet. A lot of times we have to import data from the live server to development box do we can trouble shoot problems or need to copy tables from development to the live server for a launch. When you use the import/export function in SQL Server Enterprise Manager/ Management Studio you lose all your permissions and your Identity specifications. Setting permissions on Server Enterprise Manager/ Management Studio is a total pain in the ass. So I wrote this little script to help speed up the process

Notes:

These are all the permissions"

GRANT SELECT, INSERT, DELETE, REFERENCES, UPDATE, CONTROL, TAKE OWNERSHIP, ALTER, VIEW DEFINITION

I use EMS SQL Manager 2005 Lite for SQL Server to run to run the SQL. Enterprise Manager/ Management Studio doesn’t seem to want to execute the SQL statement for some reason.

<cfset tmp_user = "someuser,someotheruser">
<cfset tmp_Permissions = "SELECT, INSERT, DELETE, UPDATE">

<PRE >
<cfoutput>
<CFLOOp list="#tmp_user#" index="index1" >
<CFLOOp list="SomeTable,SomeOtherTable,YetOtherTable" index="indx2" >
GRANT #tmp_Permissions#
ON [dbo].[#indx2#]
TO [#index1#]
GO

</CFLOOp>
</CFLOOp>
</cfoutput>
</PRE>

Comments (0) |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 474 Views