UPDATE pierre_prints SET name= '#form.name#', edition= '#form.edition#', galleryID= #form.galleryID#, website= '#form.website#', price= '#form.price#', viewlarger= #form.viewlarger#, dimensions_x= #form.dimensions_x#, dimensions_y= #form.dimensions_y#, type1= '#form.type1#', active= #form.active# WHERE ID = #URL.ID# INSERT INTO pierre_prints ( name, edition, galleryID, website, dimensions_x, dimensions_y, type1, active, viewlarger, price ) VALUES ( '#form.name#', '#form.edition#', #form.galleryID#, '#form.website#', #form.dimensions_x#, #form.dimensions_y#, '#form.type1#', #form.active#, #form.viewlarger#, #form.price#) SELECT @@IDENTITY AS newID SELECT ID, name FROM pierre_gallery WHERE ID = #form.galleryID# <cfif URL.action is "edit"> Admin: Print Updated <cfelse> Admin: Print Added </cfif>
paintings Archival Prints writings gallery pierre
   
yes
 Has a "View Larger" version
yes
 Yes! This print is currently active
   
Name:
#form.name#
Edition:
#form.edition#
Gallery:
#findGallery.name#
Website:
#form.website#
Type:
#form.type1#
Price:
$#price#
Width:
#form.dimensions_x#"
Height:
#form.dimensions_y#"