Sorry guys, this is working... I was doing something wrong... Sorry if I've
taken up any of your time... :)
Saturday
On 18/4/05 9:43 pm, "Stuart Kidd" <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> I've created a bit of code which is inserting to a few tables. I've
> implemented the @@identity and am having problems as an error is being
> returned saying:
>
> Element INTERVIEWERUSERID is undefined in INSERTNEWINTERVIEWER.
>
> That particular line it the one I have put asterisks around.
>
> Does anyone know why it's not working? I guess I haven't implemented the
> @@identity properly.
>
> Any help would be great. Thanks.
>
> Saturday
>
> ps: my code is below.
>
>
> <cfif IsDefined("Form.question1")>
>
> <!-- Check database to see if INTERVIEWER User already exists -->
> <cfquery name="CheckInterviewerUser" datasource="user020">
> SELECT userID, emailAddress, password
> FROM tbl_020publicUsers
> WHERE emailAddress = '#form.interviewerEmail#'
> </cfquery>
>
> <cfif CheckInterviewerUser.recordCount eq 0>
>
> <!-- Create a ranodm password because INTERVIEWER doesn't have
> one yet and then put details in database -->
> <cf_RandomPassword
> CharacterSet="alphanumeric"
> Case="mixed"
> Symbols="no"
> Length="8"
> ReturnVariable="NewPassword">
>
> <cfquery name="InsertNewInterviewer" datasource="user020">
> SET NOCOUNT ON
> INSERT INTO tbl_020publicUsers (emailAddress, password)
> VALUES ('#Form.interviewerEmail#', '#NewPassword#')
> SELECT @@IDENTITY as interviewerUserID
> SET NOCOUNT OFF
> </cfquery>
>
> </cfif>
>
> <!-- Check database to see if INTERVIEWEE User already exists -->
> <cfquery name="CheckIntervieweeUser" datasource="user020">
> SELECT userID, emailAddress, password
> FROM tbl_020publicUsers
> WHERE emailAddress = '#form.intervieweeEmail#'
> </cfquery>
>
> <cfif CheckIntervieweeUser.recordCount eq 0>
>
> <!-- Create a random password because INTERVIEWEE doesn't have
> one yet and then put details in database -->
> <cf_RandomPassword
> CharacterSet="alphanumeric"
> Case="mixed"
> Symbols="no"
> Length="8"
> ReturnVariable="NewPassword">
>
> <cfquery name="InsertNewInterviewee" datasource="user020">
> SET NOCOUNT ON
> INSERT INTO tbl_020publicUsers (emailAddress, password)
> VALUES ('#Form.intervieweeEmail#', '#NewPassword#')
> SELECT @@IDENTITY as IntervieweeUserID
> SET NOCOUNT OFF
> </cfquery>
>
> </cfif>
>
> <!-- Insert interview details -->
> <cfquery name="InsertInterviewDetails" datasource="user020">
> SET NOCOUNT ON
> INSERT INTO tbl_020publicInterviews (interviewTitle, interviewerID,
> intervieweeID)
> VALUES ('#Form.interviewTitle#',
> #InsertNewInterviewer.interviewerUserID#,
> #InsertNewInterviewee.intervieweeUserID#)
> SELECT @@IDENTITY as InterviewID
> SET NOCOUNT OFF
> </cfquery>
>
> <!-- insert questions -->
> <cfloop index="i" from="1" to="#form.numberOfQuestions#">
> <cfquery name="InsertQuestion" datasource="user020">
> INSERT INTO tbl_020publicQuestions (interviewID, question)
> VALUES (#InsertInterviewDetails.interviewID#,
> '#Evaluate('form.question' & i)#')
> </cfquery>
> </cfloop>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203438
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
