coldfusion CRUD queries for existing table

cf - create crud from column names.sql

--good for quick coding cruds

--- CF-specific.   EDIT TO WORK WITH YOUR LANGUAGE

-- see http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html
-- for list of queryparam translations that might need to be done manually
declare @tablename varchar(50);
set @tablename =  '[INSERT YOUR TABLE NAME HERE]';

/***
SELECT *
FROM [your DB name].INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tablename
**/

/***
-- case-specific struct creation
-- change structname as needed
SELECT '[your DB name].'+Column_name + ','
FROM de_myCourses.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tablename
**/

/***
--- query params
-- note to change datatypes to cf-specific lingo
SELECT
'queryService.addParam(name="' +Column_Name + '",value=arguments.'+@tablename+'.get' +Column_Name + '(),cfsqltype="cf_sql_' + data_type + '");'
FROM de_myCourses.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tablename
**/

/***
SELECT
'arguments.[table name].set' +Column_Name + '(errorStruct.recordAsStruct.' +Column_Name + ');'
FROM de_myCourses.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tablename
**/

/**
SELECT Column_name + '= :'+Column_name + ','
FROM de_myCourses.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tablename




SELECT 'strUploaderInfo.'+Column_name +' = arguments.event.getArg("'+column_name+'");' --+ ','

FROM [your DB name].INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tablename



SELECT 'property name="'+Column_name +'" type="' + data_type + '"  required="false" default="0"  getter="true" setter="true";'

FROM [your DB name].INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tablename
**/

/**
-- get as a comma delimited list
-- good for queryNew("...") empty queries so function returns at least an empty query in case the ensuing query fails for some reason...
SELECT STUFF((
              Select ','+Column_name+''  AS [text()]
                FROM [your DB name].INFORMATION_SCHEMA.COLUMNS
                WHERE TABLE_NAME = @tablename
                     For XML PATH ('')
             ),1,1,'');

**/