1. Set a CFTRANSACTION block. 2. Inside the block, do a CFQUERY to put the survey information into the DB. 3. Inside the block, do a CFQUERY to get the ID of the last survey put in. Using the ID, do the following:
<!--- The ID returned from the DB for the survey just entered ---> <CFSET nSurveyID=71> <!--- The amount of sales reps. This can be gotten from a list, DB or somewhere else ---> <CFSET lSalesRep=7> <!--- The rep you want to send to will be gotten by doing a MOD on the survey ID. ---> <CFSET nSendToRep=id mod list> <!--- If the result is 0, it means the sales rep is the last one, i.e. 7 in this case ---> <CFIF nSendToRep EQ 0><CFSET nSendToRep=lSalesRep></CFIF> <!--- Use the results ---> <CFOUTPUT>#nSendToRep#</CFOUTPUT> I wrote this to be as explanative as possible. Other ways may be better or tighter, but this will tell you exactly what's going on. At 11:28 AM 5/23/02, you wrote: >Hi all, > >I am a new member to this list and was wondering if I could ask for some >help. > >Here is what i need to do: >I have a survey that is on the web (duh) and when someone fills it out, i >want to insert into an access 2k db (no prob here) and then evenly >distribute (ie email) to sales reps. > >so, for the first survey filled out, it goes to rep 1, second survey goes to >rep 2, so on and so forth and when the amount of surveys exceed the reps, >then i go back to the first rep. > >i will send code if someone knows how to do this. > >Thanks a million! >Big T > > ______________________________________________________________________ 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
