one caveat though, (to my lost post)... it gets a bit harder displaying
nice error messages that way.
oh hang on, did you want code to write the trigger with?
create trigger insertlog
on subscribetable
for insert as
declare @new_id as numeric
set @new_id = (select idcolumnname from inserted) -- "inserted" is the
sql table/var structure
insert into log (..) values ( @newid, 1)
if @@error > 0
rollback transaction
go
should work.
>>> [EMAIL PROTECTED] 28/01/2005 10:58:48 am >>>
Scott,
Can I setup the second table insert via a trigger using CF code or do
I
set them up in Enterprise Manager? MS SQL 2000.
Thoughts or simple syntax solution if you have time. Or is it better
using
the above solution?
Thanks Chris
Knowledge is only Power if it is used and applied.....
> Hi,
>
> In a single CFQuery
>
> <CFQUERY name="insert_stuff">
> insert into whatever
> (
> ..
> )
> values
> (
> ..
> )
> SELECT @@IDENTITY AS NEW_ID
> </CFQUERY>
>
> #insert_stuff.new_id#
>
> or if there are triggers on your table, use scope_identity()
>
> Using MS SQL 2000......
>
> >>> [EMAIL PROTECTED] 27/01/2005 7:49:03 pm >>>
> I want to insert the unique id generated by the first insert query
> into
> the same column (id_contact) in the third cfquery statement.
>
> Syntax from the second cfquery statement is throwing an error...
>
> has anyone got a better way of getting this done(or the proper way)?
>
> Thanks
>
> Chris
>
> *****************************************************************
>
> <cfquery name="sorted" datasource="#APPLICATION.DB#"
> USERNAME="#APPLICATION.UN#" PASSWORD="#APPLICATION.PW#">
> INSERT INTO #APPLICATION.DBPRE#Subscribe
> (FirstName,
> LastName,
> Company,
> StreetAddress,
> StreetAddress2,
> City,
> State,
> ZipCode,
> Country,
> PhoneNumber,
> SubscriberEmail,
> <!---UserLists,--->
> UserConfirmed,
> CreatedDate,
> IsEmValid)
> VALUES
> ('#Trim(form.FirstName)#',
> '#Trim(form.LastName)#',
> '#Trim(COMPANY)#',
> '#Trim(form.StreetAddress)#',
> '#Trim(STREETADDRESS2)#',
> '#Trim(form.City)#',
> '#Trim(form.State)#',
> '#Trim(form.ZipCode)#',
> '#Trim(form.Country)#',
> '#Trim(form.PhoneNumber)#',
> '#Trim(form.SubscriberEmail)#',
> <!---'#Trim(form.UserLists)#',--->
> 1,
> '#DateFormat(Now(), "yyyy-mm-dd")#',
> 1)
> </cfquery>
>
> <cfquery name="sorted2" datasource="#APPLICATION.DB#"
> USERNAME="#APPLICATION.UN#" PASSWORD="#APPLICATION.PW#">
> SELECT *
> FROM #APPLICATION.DBPRE#Subscribe
> WHERE id_contact = MAX(id_contact)
> </cfquery>
>
> <cfset same_id= #sorted2.id_contact#>
>
> <cfquery name="peace" datasource="#APPLICATION.DB#"
> USERNAME="#APPLICATION.UN#" PASSWORD="#APPLICATION.PW#">
> INSERT INTO #APPLICATION.DBPRE#ContactLog
> (#same_id#,
> id_campaign,)
> VALUES
> (#sorted.id_contact#,
> 1)
> </cfquery>
>
> ---
> You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
