I would do this in a stored proc
I am not this is absolutely the most efficient but works well for me (this
is sql server)
You would then call stored proc each step of loop ove form list.
I actually have built some stored procs and functions for looping over lists
but for this application
probably just as simple to do the looping in cf.
HTH
Don
create procedure usp_update_app_listing
@appID int, (or whatever types you are using)
@listing_id int
AS
DECLARE @foo int
set @foo=(select AppId from tblAppIAUsers where appId = @appId and
listing_id = @listing_id )
IF @foo is null
insert into tblAppIAUsers
(appId, listing_id)
VALUES (@appId,@listing_id)
----- Original Message -----
From: "Jones, Becky" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 16, 2001 6:28 AM
Subject: insert question
> i have a list of users that you can choose from on a form to assign to an
> application(s).
> if the user is already assigned to a certain app however, i dont want that
> user to re-insert into the database. (infact, the dbase wont let that
happen
> because of duplicate indexes) but if the second user isnt already assigned
> to the app...i do want him to insert. but it doesnt seem to be working
out.
> any ideas?
> my qryPeople is this:
> <CFIF USERS NEQ "No Users">
> <cfquery name="qryPeople" datasource="#dsn#">
> SELECT *
> FROM qryAppToEmp2
> WHERE UserID IN (#form.Users#)
> AND AppID IN (#form.appID#)
> </cfquery>
> </cfif>
> my insert:
> <cfif isdefined("qryPeople.recordcount") AND qryPeople.RecordCount IS 0 OR
> qryPeople.UserID neq "No Users">
> <cfloop list="#form.Users#" index="i" delimiters=",">
> <cfloop list="#form.appid#" index="p" delimiters=",">
> <cfquery datasource="#dsn#" name="addUser">
> INSERT INTO tblAppIAUsers
> (
> AppID,
> Listing_ID
>
> )
> VALUES
> (
>
> #p#,
> #i#
> )
> </cfquery>
> </cfloop>
> </cfloop>
> </cfif>
>
>
> *************************************************
> This e-mail, including any attachments, is intended for the
> receipt and use by the intended addressee(s), and may contain
> confidential and privileged information. If you are not an intended
> recipient of this e-mail, you are hereby notified that any unauthorized
> use or distribution of this e-mail is strictly prohibited.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
