Skip to content

Instantly share code, notes, and snippets.

@zarkosusnjar
Created August 26, 2010 08:05
Show Gist options
  • Save zarkosusnjar/551029 to your computer and use it in GitHub Desktop.
Save zarkosusnjar/551029 to your computer and use it in GitHub Desktop.
<!--- SQL Server 2008 --->
<cfquery name="test" datasource="#this.dsn#" result="testResult">
INSERT INTO contacts (
firstname
,lastname
)
VALUES
(
( <cfqueryparam cfsqltype="cf_sql_varchar" value="Marko">
, <cfqueryparam cfsqltype="cf_sql_varchar" value="Simic">),
( <cfqueryparam cfsqltype="cf_sql_varchar" value="Boris">
, <cfqueryparam cfsqltype="cf_sql_varchar" value="Huskic">
)
</cfquery>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment