Re: Deleting a Record in Database - Error Message
Thanks very much for the response!
I have searched more on the missing variable but still cant work out whats
Not sure why its saying 'depart' specfically as that is the 3rd row in the
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]
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">
DELETE FROM artists
WHERE ArtistID = #arguments.artistid#
[b]then i have a delete.cfm file[/b]
<cfinvokeargument name="artistid" value="#form.artistid#"/>
<cflocation url="/cf8essentials/artists/index.cfm" addtoken="no">
<cfinput type="submit" name="submit" value="Delete">
<cfinput type="button" name="cancel" value="Cancel"
<cfinput type="hidden" name="artistid" value="#url.artistid#">
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]