it will overlook user a (he is already in the dbase) but it wont insert user b (he is not in dbase and should get put in)
-----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:00 AM To: CF-Talk Subject: RE: insert question are you getting an error? is the user just not getting inserted? christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -----Original Message----- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 8:29 AM To: CF-Talk 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists