Re: Deleting a Record in Database - Error Message

["TheRecruit"]

[b]Hello.

 Thanks very much for the response!

 I have searched more on the missing variable but still cant work out whats 
wrong.

 Not sure why its saying 'depart' specfically as that is the 3rd row in the 
table.

 Not too sure on where to go frm here. Could i ask for a bit more specific help?

 I have 3 an index page which displays the 7 rows + a link to edit any of the 
returned data : [/b]

 [i]          <td>#qArtists.CurrentRow#</td>
           <td>#qArtists.FirstName#</td>
           <td>#qArtists.LastName#</td>
           <td>#qArtists.Depart#</td>
           <td>#qArtists.Hotel#</td>
           <td>#qArtists.Board#</td>
           <td>#qArtists.Price#</td>
           <td><a 
href="updateartist.cfm?artistid=#qArtists.ArtistID#">Edit</a></td>[/i]
 [b]
 Then i have a :
 artist.cfc which i added the delete code to :[/b]

 [i]    <cffunction name="deleteArtist" access="public" returntype="void">
        <cfargument name="artistid" type="numeric" required="yes">
         
         <cfquery datasource="#application.datasource#">
                DELETE FROM artists
             WHERE ArtistID = #arguments.artistid#
         </cfquery>
         
     </cffunction>[/i]

 [b]then i have a delete.cfm file[/b]

 [i]<cfif IsDefined("form.artistid")>
        <cfinvoke 
      component="cf8essentials.cfc.Artist"
      method="deleteArtist">
         <cfinvokeargument name="artistid" value="#form.artistid#"/>
     </cfinvoke>
        <cflocation url="/cf8essentials/artists/index.cfm" addtoken="no">
 </cfif>

        <cfform>
        <cfinput type="submit" name="submit" value="Delete">
         <cfinput type="button" name="cancel" value="Cancel"
                onclick="history.back()">
         <cfinput type="hidden" name="artistid" value="#url.artistid#">
     </cfform>
 [/i]
 [b]
 really not sure what part im doing wrong as i have fllowed two different 
tutorials which do it different and both of theirs work but im not sure what 
ive done wrong. Could you advise further has ive been pulling my hair out over 
this for the past couple of days now! thanks very much in advance again![/b]