Skip to content

Instantly share code, notes, and snippets.

@GiancarloGomez

GiancarloGomez/invalid_cfsqltype.regex

Last active September 28, 2021 13:53
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save GiancarloGomez/7c0bb39a7e100378253ca422769211d3 to your computer and use it in GitHub Desktop.
Save GiancarloGomez/7c0bb39a7e100378253ca422769211d3 to your computer and use it in GitHub Desktop.
Download ZIP
Find Invalid CF SQL Types using this RegEx search in you IDE - set to case insensitive
Raw
invalid_cfsqltype.regex
cfsqltype(\s)?(=|:)(\s)?('|")(?!(cf_sql_bigint|cf_sql_bit|cf_sql_char|cf_sql_blob|cf_sql_clob|cf_sql_date|cf_sql_decimal|cf_sql_double|cf_sql_float|cf_sql_idstamp|cf_sql_integer|cf_sql_longnvarchar|cf_sql_longvarchar|cf_sql_money|cf_sql_money4|cf_sql_nchar|cf_sql_nclob|cf_sql_nvarchar|cf_sql_numeric|cf_sql_real|cf_sql_refcursor|cf_sql_smallint|cf_sql_sqlxml|cf_sql_time|cf_sql_timestamp|cf_sql_tinyint|cf_sql_varchar|bigint|bit|char|blob|clob|date|decimal|double|float|idstamp|integer|longnvarchar|longvarchar|money|money4|nchar|nclob|nvarchar|numeric|real|refcursor|smallint|sqlxml|time|timestamp|tinyint|varchar)('|"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment