Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1569011813336-d68bcaeb-64a3-5db9-e962-10c6d3f79eb3.cfm

Created September 20, 2019 20:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save trycf/3f3ce789c5f8a7ac81d23561108b77e3 to your computer and use it in GitHub Desktop.
Save trycf/3f3ce789c5f8a7ac81d23561108b77e3 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1569011813336-d68bcaeb-64a3-5db9-e962-10c6d3f79eb3.cfm
<cfscript>
q = queryNew("name", "CF_SQL_VARCHAR");
//data = listToArray("A,B,C,-A,-B,-C,- A,- B,- C,@A,@B,@C,*A,*B,*C,1A,1B,1C");
data = listToArray("Copay Plan With Wellness,Copay Plan Without Wellness");
count = arrayLen(data);
for (i = 1; i <= count; i++)
queryAddRow(q, {name: data[i]});
q = queryExecute("SELECT * FROM q ORDER BY name", {}, {dbType: "query"});
writeDump(var=q, metainfo=0);
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment