This is for sql, I am not real sure in regard to oracle. But the same logic. I think the problem is really in the use of the <CFIF> statements.
Doug ----- Original Message ----- From: "Yager, Brian T Contractor/NCCIM" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 16, 2001 8:29 AM Subject: RE: insert question > Doug, > > Is this for Oracle or SQL Server (or will it work for both)? > > Brian > > -----Original Message----- > From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 16, 2001 10:33 AM > To: CF-Talk > Subject: Re: insert question > > > It looks just like my create user account, take a look and hope it helps. > > <CFQUERY DATASOURCE="#application.dsn#" NAME="check_login"> > SELECT email, > password > FROM cust_contacts > WHERE email = '#email#' > AND password = '#password#' > </CFQUERY> > > <!--- CHECK TO SEE IF THE USER EXISTS IN THE DB AND IF THEY DO, REDIRECT > THEM TO > THE ERROR PAGE AND NOTIFY THEM TO LOGIN NORMALLY. //---> > > <CFIF CHECK_LOGIN.RECORDCOUNT GT 0> > <CFLOCATION URL="/index.cfm?fuseaction=error&message=1"> > <CFELSE> > > <!--- IF THE USER DOES NOT EXIST, INSERT THEM INTO THE DATABASE//---> > > <CFTRANSACTION> > <CFQUERY DATASOURCE="#application.dsn#" NAME="insert_cust_login"> > DECLARE @maxid int > BEGIN > SELECT @maxid = MAX(ID) > FROM cust_contacts > IF @maxid IS NULL > SELECT @maxid = 1 > ELSE > SELECT @maxid = @maxid + 1 > END > > INSERT INTO cust_contacts > VALUES ( '#custNum#', > @maxid, > '#f_name#', > '#l_name#', > '#email#', > '#password#' ) > </CFQUERY> > </CFTRANSACTION> > </CFIF> > > > > Doug > > > ----- Original Message ----- > From: "Jones, Becky" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, November 16, 2001 5: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. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
