<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% WA_DFP_SetupUploadStatusStruct("WA_UploadResult1"); if(String(WA_DFP_UploadObj.Form("Save")) != "undefined"){ WA_DFP_UploadFile("WA_UploadResult1", "Thumbnail", "", "../Art/", "[FileName]", "0", "[FileName]_[Increment]", "0", "true", "0", "0"); }%> <% WA_DFP_SetupUploadStatusStruct("WA_UploadResult2"); if(String(WA_DFP_UploadObj.Form("Save")) != "undefined"){ WA_DFP_UploadFile("WA_UploadResult2", "Detail", "", "../Art/", "[FileName]", "0", "[FileName]_[Increment]", "0", "true", "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|InvCategory|InvTitle|InvMedium|InvHeight|InvWidth|InvDepth|InvPrice|InvDescription|InvThumb|InvDetail"; var WA_fieldValuesStr = "" + String(WA_DFP_UploadObj.Form("hiddenField")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Category")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Title")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Medium")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Height")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Width")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Depth")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Price")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Description")) + "" + "|" + "" + String(WA_DFP_UploadStatus["WA_UploadResult1"].serverFileName) + "" + "|" + "" + String(WA_DFP_UploadStatus["WA_UploadResult2"].serverFileName) + ""; var WA_columnTypesStr = "',none,''|none,none,NULL|',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|',none,''|',none,''|',none,''"; var WA_comparisonStr = " LIKE | = | LIKE | LIKE | LIKE | LIKE | LIKE | = | LIKE | LIKE | 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); } } %> MAINVIEW GALLERY | SCOTTSDALE, ARIZONA

Mainview Gallery Scottsdale, AZ

   

7137 E. Main Street
Scottsdale, AZ 85251

(480)990-1515

E-MAIL:

MAINVIEWGALLERY@AOL.COM

MAINVIEW
GALLERY
 
Home
Artists
About
Events
Contact
Tour
Category
Medium
Height
Width
Depth
Price $
Description
   
Thumbnail
Detail
   
 
  Home Artists About Events ContactTour
 
 
copyright 2009 MAINVIEW GALLERY L.L.C.