<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var WADADynListCategories_cmd = Server.CreateObject ("ADODB.Command"); WADADynListCategories_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; WADADynListCategories_cmd.CommandText = "SELECT CatId, Category FROM Categories ORDER BY Category"; WADADynListCategories_cmd.Prepared = true; var WADADynListCategories = WADADynListCategories_cmd.Execute(); var WADADynListCategories_numRows = 0; %> <% var rsJewelCat_cmd = Server.CreateObject ("ADODB.Command"); rsJewelCat_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsJewelCat_cmd.CommandText = "SELECT * FROM JewelryCategories"; rsJewelCat_cmd.Prepared = true; var rsJewelCat = rsJewelCat_cmd.Execute(); var rsJewelCat_numRows = 0; %> <% WA_DFP_SetupUploadStatusStruct("WA_UploadResult1"); if(String(WA_DFP_UploadObj.Form("Insert.x")) != "undefined"){ WA_DFP_UploadFile("WA_UploadResult1", "InvThumb", "", "../Art/Tn/", "[FileName]", "2", "[FileName]_[Increment]", "0", "false", "0", "0"); }%> <% WA_DFP_SetupUploadStatusStruct("WA_UploadResult2"); if(String(WA_DFP_UploadObj.Form("Insert.x")) != "undefined"){ WA_DFP_UploadFile("WA_UploadResult2", "InvDetail", "", "../Art/Detail/", "[FileName]", "2", "[FileName]_[Increment]", "0", "false", "0", "0"); } %> <% // WA Application Builder Insert if (Request.ServerVariables("Request_Method") == "POST") { var WA_connection = MM_cnMAINVIEWDB_STRING; var WA_table = "Inventory"; var WA_sessionName = "WADA_Insert_Inventory"; var WA_redirectURL = "Inventory_Detail.asp"; var WA_keepQueryString = false; var WA_indexField = "InvID"; var WA_fieldNamesStr = "InvArtistUsername"; var WA_fieldValuesStr = "name"; var WA_columnTypesStr = "',none,''"; var WA_comparisonStr = " LIKE "; var WA_fieldNames = WA_fieldNamesStr.split("|"); var WA_fieldValues = WA_fieldValuesStr.split("|"); var WA_columns = WA_columnTypesStr.split("|"); var WA_comparisons = WA_comparisonStr.split("|"); var insertParamsObj = WA_AB_generateInsertParams(WA_fieldNames, WA_columns, WA_fieldValues); var MM_editCmd = Server.CreateObject('ADODB.Command'); MM_editCmd.ActiveConnection = WA_connection; MM_editCmd.CommandText = "INSERT INTO " + WA_table + " (" + insertParamsObj.WA_tableValues + ") VALUES (" + insertParamsObj.WA_dbValues + ")"; MM_editCmd.Execute(); MM_editCmd.ActiveConnection.Close(); var obj = WA_AB_generateWhereClause(WA_fieldNames, WA_columns, WA_fieldValues, WA_comparisons); var sqlstr = "SELECT " + WA_indexField + " FROM " + WA_table + " WHERE " + obj.sqlWhereClause + " ORDER BY " + WA_indexField + " DESC"; var WA_AppBuilderRecordset = Server.CreateObject("ADODB.Recordset"); WA_AppBuilderRecordset.ActiveConnection = WA_connection; WA_AppBuilderRecordset.Source = sqlstr; WA_AppBuilderRecordset.CursorType = 0; WA_AppBuilderRecordset.CursorLocation = 2; WA_AppBuilderRecordset.LockType = 1; WA_AppBuilderRecordset.Open(); if (!WA_AppBuilderRecordset.EOF) { Session(WA_sessionName) = WA_AppBuilderRecordset.Fields.Item(WA_indexField).Value; } WA_AppBuilderRecordset.Close(); if (WA_redirectURL != "") { if (WA_keepQueryString && WA_redirectURL != "" && Request.QueryString && Request.QueryString.Count > 0) { WA_redirectURL += ((WA_redirectURL.indexOf('?') == -1)?"?":"&") + Request.QueryString; } Response.Redirect(WA_redirectURL); } } %> Insert Inventory

Mainview Gallery Scottsdale, AZ

   

7120 E. Main Street
Scottsdale, AZ 85251

(480)990-1515

E-MAIL:

MAINVIEWGALLERY@AOL.COM

MAINVIEW
GALLERY
 
  Home Artists About Events Contact Tour
Resale
Insert Record
Category ">
Jewelry Category (Jewelry Only)
Title
Medium
H
W
D
Price
Description
Thumbnail
Detail Image
Cancel
  Home Artists About Events Contact Tour Resale
 
 
copyright 2009-2011 MAINVIEW GALLERY L.L.C.
<% WADADynListCategories.Close(); %> <% rsJewelCat.Close(); %>