Login Register |
|
|
|
|
 |
Site-Deploy
Project Home • Blog • Forums • Wiki • Known Issues • Screenshots • Contact Project
Author: Reinhard Jung (All RIAForge projects by this author)
Description:
Example: SQL-Statement
USE {database}; GO /*** User Table ***/ IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='User' AND COLUMN_NAME='CountryCode') ALTER TABLE MANDATES DROP COLUMN CountryCode; ALTER TABLE MANDATES ADD CountryCode NVARCHAR(2); GO UPDATE User SET CountryCode = CASE WHEN MandateID = '{Mandant_1:ID}' THEN '{Mandant_1:Code}' WHEN MandateID = '{Mandant_2:ID}' THEN '{Mandant_2:Code}' WHEN MandateID = '{Mandant_3:ID}' THEN '{Mandant_3:Code}' END GO Example: INI-VAR-Syntax [Mandant_3] ID=B93A1B2D-1C25-9A75-848012ACCFB302A8 Code=M14
Requirements:
ColdFusion MX 7
testet on MS SQL Server 2000-2008 Every Statement must by closed with a GO, which must be on its own line! So the Code could also be Copy&Pasted into the SQL-Studio. Issue Tracker: There are no issues for this project. To enter issues for this (or any other) project, you must be logged in. Subversion Access: You may access this project's Subversion repository with your client here: http://svn.riaforge.org/sitedeploy. To view files and changelists associated with this repository, go here: http://sitedeploy.riaforge.org/index.cfm?event=page.svnbrowse. Anonymous users have read access to the repository while the administrator has write access. This project is sharing its code via Subversion. Subversion is an open source source control method. You may find more information about Subversion here: http://subversion.tigris.org/ |
Adobe and the Adobe product names are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.
