%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
// *** Edit Operations: declare variables
Session("sessFreeChapterEmail")=String(Request("Email"))
// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
MM_editAction += "?" + Server.HTMLEncode(Request.QueryString);
}
// boolean to abort record edit
var MM_abortEdit = false;
%>
<%
// *** Redirect if username exists
var MM_flag = "MM_insert";
if (String(Request(MM_flag)) != "undefined") {
var MM_dupKeyRedirect = "ThankYou.asp";
var MM_dupKeyUsernameValue = String(Request.Form("email"));
var MM_rsKey_cmd = Server.CreateObject ("ADODB.Command");
MM_rsKey_cmd.ActiveConnection = MM_ArtistML1_STRING;
MM_rsKey_cmd.CommandText = "SELECT email FROM ArtistML WHERE email = ?";
MM_rsKey_cmd.Prepared = true;
MM_rsKey_cmd.Parameters.Append(MM_rsKey_cmd.CreateParameter("param1", 200, 1, 255, MM_dupKeyUsernameValue)); // adVarChar
var MM_rsKey = MM_rsKey_cmd.Execute();
if (!MM_rsKey.EOF || !MM_rsKey.BOF) {
// the username was found - can not add the requested username
var MM_qsChar = "?";
if (MM_dupKeyRedirect.indexOf("?") >= 0) MM_qsChar = "&";
MM_dupKeyRedirect = MM_dupKeyRedirect + MM_qsChar + "requsername=" + MM_dupKeyUsernameValue;
Response.Redirect(MM_dupKeyRedirect);
}
MM_rsKey.Close();
}
%>
<%
if (String(Request("MM_insert")) == "form1") {
if (!MM_abortEdit) {
// execute the insert
var MM_editCmd = Server.CreateObject ("ADODB.Command");
MM_editCmd.ActiveConnection = MM_ArtistML1_STRING;
MM_editCmd.CommandText = "INSERT INTO ArtistML (email, source) VALUES (?, ?)";
MM_editCmd.Prepared = true;
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param1", 202, 1, 255, Request.Form("email"))); // adVarWChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param2", 202, 1, 255, Request.Form("source"))); // adVarWChar
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();
// append the query string to the redirect URL
var MM_editRedirectUrl = "ThankYou.asp";
if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1) ? "?" : "&") + Request.QueryString;
}
Response.Redirect(MM_editRedirectUrl)
}
}
%>
<%
var rsFreeChapterEmail_cmd = Server.CreateObject ("ADODB.Command");
rsFreeChapterEmail_cmd.ActiveConnection = MM_ArtistML1_STRING;
rsFreeChapterEmail_cmd.CommandText = "SELECT * FROM ArtistML";
rsFreeChapterEmail_cmd.Prepared = true;
var rsFreeChapterEmail = rsFreeChapterEmail_cmd.Execute();
var rsFreeChapterEmail_numRows = 0;
%>
Xanadu Gallery | Contemporary Fine Art | Scottsdale, AZ
Xanadu Gallery - Gallery Representation - Scottsdale, AZ
In chapter 8 you learn about critical materials you need to produce as an artist to present yourself professionally to galleries. You will also learn how to save money by not wasting your efforts and resources on materials you do not need. Learn whether it's important to have an artist's business card, postcards and brochures. Learn how to format your artist's portfolio. Write a compelling artist's statement, biography and resume.
Hours of Operation
Monday - Sat 10:00 a.m. - 5:00 p.m.
Closed Sunday
Artwalk Every Thursday Evening
7-9 p.m.
Art
Services for Artists
Contact
About
copyright 2010 | Xanadu Gallery LLC |
7039 E. Main St. #101 - Scottsdale, AZ 85251 (Map) | 480.368.9929 - 866.483.1306
<%
rsFreeChapterEmail.Close();
%>