UPDATE pierre_paintings SET name= '#form.name#', galleryID= #form.galleryID#, dimensions_x= #form.dimensions_x#, dimensions_y= #form.dimensions_y#, price= #form.price#, active= #form.active#, archive= #form.archive#, viewlarger= #form.viewlarger#, sold= #form.sold#, rank= #form.rank# WHERE ID = #URL.ID# INSERT INTO pierre_paintings (name, galleryID, dimensions_x, dimensions_y, price, active, sold, rank, archive, viewlarger) VALUES ('#form.name#', #form.galleryID#, #form.dimensions_x#, #form.dimensions_y#, #form.price#, #form.active#, #form.sold#, #form.rank#, #form.archive#, #form.viewlarger#) SELECT @@IDENTITY AS newID SELECT ID, name FROM pierre_gallery WHERE ID = #form.galleryID# <cfif URL.action is "edit"> Admin: Painting Updated <cfelse> Admin: Painting Added </cfif>
paintings Archival Prints writings gallery pierre
   
yes
 Has a "View Larger" version
yes
 Yes! This painting is currently active
yes
 This painting has been sold
yes
 Archive this painting (this will remove the painting from current paintings)
   
Rank:
 #form.rank#
Name:
#name#
Price:
$#price#
Width:
#dimensions_x#"
Height:
#dimensions_y#"