UPDATE paintings SET name= '#form.name#', galleryID= #form.galleryID#, dimensions_x= #form.dimensions_x#, dimensions_y= #form.dimensions_y#, price= #form.price#, active= #form.active#, sold= #form.sold#, rank= #form.rank# WHERE ID = #URL.ID# INSERT INTO paintings (name, galleryID, dimensions_x, dimensions_y, price, active, sold, rank) VALUES ('#form.name#', #form.galleryID#, #form.dimensions_x#, #form.dimensions_y#, #form.price#, #form.active#, #form.sold#, #form.rank# ) SELECT @@IDENTITY AS newID SELECT ID, name FROM gallery WHERE ID = #form.galleryID# <cfif URL.action is "edit"> Admin: Painting Updated <cfelse> Admin: Painting Added </cfif>
paintings galleries giclees nancy
   
checked="checked" />
 Yes! This painting is currently active
checked="checked" />
 This painting has been sold
   
Rank:
 #form.rank#
Name:
#name#
Gallery:
#findGallery.name#
Price:
$#price#
Width:
#dimensions_x#"
Height:
#dimensions_y#"