Re: [CFCDev] Application Data Source Names

[Bill Rawlinson]

Joe,

Just an FYI you can do, what I think your trying to do in your example of two queries as follows:



<cfquery name="qtContact_INS" datasource="#Arguments.DSN#" >
      SET NOCOUNT ON

      INSERT INTO dbo.tContact            
           (
           [ContactTypesID],
           [StatusID],
           [TimeZoneID]
           )
           VALUES
           (
           <cfqueryparam value="#theParams.$ContactTypesID#" cfsqltype="CF_SQL_smallint" >,
           <cfqueryparam value="#theParams.$StatusID#" cfsqltype="CF_SQL_smallint" >,
           <cfqueryparam value="#theParams.$TimeZoneID#" cfsqltype="CF_SQL_smallint" >
           )
         
        SELECT @@identity AS id
        SET NOCOUNT OFF
</cfquery>


Bill
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm

An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org