Solved

Parameter has no default value Error Message

Posted on 2012-03-29
15
697 Views
Last Modified: 2012-04-04
I have added some fields to a classic asp page that WAS working.  I seemed to have done something to stop it from working.  I am now getting the error:

Parameter ?_16 has no default value.

I have attached the file that this relates to.  Any assistance would be most appreciated.

(The file name has been given a .txt extension in order to be able to upload it)
index.txt
0
Comment
Question by:jalcadmin
  • 8
  • 7
15 Comments
 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37783365
can you just show the line(s) causing the error?

I suspect that you will need to do one of 2 things.

1, use @[name] instead ?. For instanace @ID

2, if you specified length, remove it. It has solved my problems before.

Also, double check to ensure you did not add a parameter that is not needed or required.
0
 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37783470
I was able to test your code as is but it worked for me.

Can you verify that your datatypes on the db are the same as defined in your code?
0
 

Author Comment

by:jalcadmin
ID: 37783794
Thanks for your response Sammy.  Just an FYI, we are working with Access for this database.  I thought that Access didn't support named instances (I believe that's what it's called).  The data types for all the fields are "text" with the exception of entryID which is an autonumber, a field called "response6" (which we aren't using) is a Memo field and entryDate is a Date/Time field.

If I remove the length, would I just write it like this:

	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param16", 202, 1, , Request.Form("dizzys")) ' adVarWChar

Open in new window



Here is the code that seems be causing the problem:

<%
If (CStr(Request("MM_insert")) = "form1") Then
  If (Not MM_abortEdit) Then
    ' execute the insert
    Dim MM_editCmd

    Set MM_editCmd = Server.CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_connDizContestJET_STRING
    MM_editCmd.CommandText = "INSERT INTO tblContest (entryDate, promoCode, firstName, lastName, address, city, [state], zip, email, ageRange, howHear, howOther, optIn, rose_allen, subscriptions, dizzys, jlco, hang_set, group_sales, jazzed_kids, jazzed_adults, jazzed_educators, venue_rentals, volunteering) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 135, 1, -1, MM_IIF(Request.Form("entryDate"), Request.Form("entryDate"), null)) ' adDBTimeStamp
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 25, Request.Form("promoCode")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 255, Request.Form("firstName")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 255, Request.Form("lastName")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 255, Request.Form("address")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 255, Request.Form("city")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 255, Request.Form("state")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 255, Request.Form("zip")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 202, 1, 255, Request.Form("email")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 202, 1, 255, Request.Form("ageRange")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 202, 1, 255, Request.Form("howHeard")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 202, 1, 255, Request.Form("howHearOther")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 202, 1, 5, MM_IIF(Request.Form("optIn"), "Y", "N")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param14", 202, 1, 5, Request.Form("rose_allen")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param15", 202, 1, 5, Request.Form("subscriptions")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param16", 202, 1, 5, Request.Form("dizzys")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param17", 202, 1, 5, Request.Form("jlco")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param18", 202, 1, 5, Request.Form("hang_set")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param19", 202, 1, 5, Request.Form("group_sales")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param20", 202, 1, 5, Request.Form("jazzed_kids")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param21", 202, 1, 5, Request.Form("jazzed_adults")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param22", 202, 1, 5, Request.Form("jazzed_educators")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param23", 202, 1, 5, Request.Form("venue_rentals")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param24", 202, 1, 5, Request.Form("volunteering")) ' adVarWChar
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    ' append the query string to the redirect URL
    Dim MM_editRedirectUrl
    MM_editRedirectUrl = "../dccc/tyContest.asp"
	 
    If (Request.QueryString <> "") Then
      If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
        MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
      Else
        MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
      End If
    End If
    Response.Redirect(MM_editRedirectUrl)
  End If
End If
%>

Open in new window

0
 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37783956
At what point do you get this error?

Ok, try the one I tested with.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
'itemid = 13
set MM_connDizContestJET_STRING = server.CreateObject("ADODB.Connection")
set objRS =server.CreateObject("ADODB.Recordset")
MM_connDizContestJET_STRING.ConnectionString= "Provider=microsoft.jet.oledb.4.0;Data source=" & server.mappath("Paging.mdb")
objRs.CursorLocation = 3
MM_connDizContestJET_STRING.Open

'Whether or not to show the Dizzy's version of this page; defaults to true
'To remove all Dizzy's-related content, load the page with ?dizzys=0 at the end of the URL
Dim dizzys
If Request.QueryString("dizzys")="0" Then dizzys = False Else dizzys = True

'Dim promoCode
'promoCode = Request.QueryString("promoCode")

Dim MM_editAction
MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
Dim MM_abortEdit
MM_abortEdit = false
%>
<%
' IIf implementation
Function MM_IIf(condition, ifTrue, ifFalse)
  If condition = "" Then
    MM_IIf = ifFalse
  Else
    MM_IIf = ifTrue
  End If
End Function
%>
<%
If (CStr(Request("MM_insert")) = "form1") Then
  If (Not MM_abortEdit) Then
    ' execute the insert
    Dim MM_editCmd

    Set MM_editCmd = Server.CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_connDizContestJET_STRING
    MM_editCmd.CommandText = "INSERT INTO tblContest (entryDate, promoCode, firstName, lastName, address, city, [state], zip, email, ageRange, howHear, howOther, optIn, rose_allen, subscriptions, dizzys, jlco, hang_set, group_sales, jazzed_kids, jazzed_adults, jazzed_educators, venue_rentals, volunteering) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 135, 1, -1, MM_IIF(Request.Form("entryDate"), Request.Form("entryDate"), null)) ' adDBTimeStamp
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 25, Request.Form("promoCode")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 255, Request.Form("firstName")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 255, Request.Form("lastName")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 255, Request.Form("address")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 255, Request.Form("city")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 255, Request.Form("state")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 255, Request.Form("zip")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 202, 1, 255, Request.Form("email")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 202, 1, 255, Request.Form("ageRange")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 202, 1, 255, Request.Form("howHeard")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 202, 1, 255, Request.Form("howHearOther")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 202, 1, 5, MM_IIF(Request.Form("optIn"), "Y", "N")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param14", 202, 1, 5, Request.Form("rose_allen")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param15", 202, 1, 5, Request.Form("subscriptions")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param16", 202, 1, 5, Request.Form("dizzys")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param17", 202, 1, 5, Request.Form("jlco")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param18", 202, 1, 5, Request.Form("hang_set")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param19", 202, 1, 5, Request.Form("group_sales")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param20", 202, 1, 5, Request.Form("jazzed_kids")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param21", 202, 1, 5, Request.Form("jazzed_adults")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param22", 202, 1, 5, Request.Form("jazzed_educators")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param23", 202, 1, 5, Request.Form("venue_rentals")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param24", 202, 1, 5, Request.Form("volunteering")) ' adVarWChar
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    ' append the query string to the redirect URL
    Dim MM_editRedirectUrl
    MM_editRedirectUrl = "../dccc/tyContest.asp"

    If (Request.QueryString <> "") Then
      If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
        MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
      Else
        MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
      End If
    End If
    Response.Redirect(MM_editRedirectUrl)
  End If
End If
%>
<%
Dim RecordsetStates
Dim RecordsetStates_cmd
Dim RecordsetStates_numRows

Set RecordsetStates_cmd = Server.CreateObject ("ADODB.Command")
RecordsetStates_cmd.ActiveConnection = MM_connDizContestJET_STRING
RecordsetStates_cmd.CommandText = "SELECT * FROM sales ORDER BY States"
RecordsetStates_cmd.Prepared = true

Set RecordsetStates = RecordsetStates_cmd.Execute
RecordsetStates_numRows = 0
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="cache-control" content="no-cache" />
<title>Jazz at Lincoln Center - Contest Entry Form</title>
<script type="text/javascript">
<!--
function MM_validateForm() { //v4.0
  if (document.getElementById){
    var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
    for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=document.getElementById(args[i]);
      if (val) { nm=val.name; if ((val=val.value)!="") {
        if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
          if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
        } else if (test!='R') { num = parseFloat(val);
          if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
          if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
            min=test.substring(8,p); max=test.substring(p+1);
            if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
      } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
    } if (errors) alert('The following error(s) occurred:\n'+errors);
    document.MM_returnValue = (errors == '');
} }
//-->
</script>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif}
-->
</style>
<style type="text/css">
<!--
.style7 {font-family: Verdana, verdana, helvetica, sans-serif; color: #464747;}
-->
</style>
<style type="text/css">
<!--
.style9 {color:#666666; font-family:Verdana, Arial, Helvetica, sans-serif; line-height: 15px;}
-->
</style>
<style type="text/css">
<!--
.style10 {color: #46747; line-height: 13px; font-family: Verdana, verdana, helvetica, sans-serif;}
-->
</style>
<link href="../jalc_styles09.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../p7pmm/p7PMMscripts.js"></script>
<link href="../p7pmm/p7PMMh03.css" rel="stylesheet" type="text/css" media="all" />
<link href="../p7pmm/p7PMMh_dizzys.css" rel="stylesheet" type="text/css" media="all" />
<script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>

<!-- CODE FOR RAPTIVE MEDIA EMBEDDING CAPABILITY -->
<script language="javascript" type="text/javascript">
	function seeTags(){
		//document.getElementById('RMPlayerFrame').style.width="900px";
		document.getElementById('RMPlayerFrame').style.height="400px";
		document.getElementById('programMenu').style.top="420px";
		document.getElementById('seeTagsLink').style.visibility="hidden";
		document.getElementById('hideTagsLink').style.visibility="visible";
		document.getElementById('controlPanel').style.left="300px";
	}
	function hideTags(){
		//document.getElementById('RMPlayerFrame').style.width="900px";
		document.getElementById('RMPlayerFrame').style.height="100px";
		document.getElementById('programMenu').style.top="120px";
		document.getElementById('seeTagsLink').style.visibility="visible";
		document.getElementById('hideTagsLink').style.visibility="hidden";
		document.getElementById('controlPanel').style.left="380px";
	}

</script>

<style type="text/css">
<!--
.seeTagsLink
{
	visibility:visible;
	text-decoration:none;
	font-family:"Courier New", Courier, monospace;
	font-size:12px;
	color:#999999;
}
.hideTagsLink
{
	visibility:hidden;
	text-decoration:none;
	font-family:"Courier New", Courier, monospace;
	color:#999999;
	font-size:12px;
}
.RMLinks
{
	text-decoration:none;
	font-family:"Courier New", Courier, monospace;
	color:#999999;
	font-size:14px;
}
-->
</style>
<!-- END OF RAPTIVE MEDIA EMBEDDING -->
</head>

<body onload="MM_preloadImages('../dccc/ccimages09/button_calendar_.gif','../dccc/ccimages09/button_after_hours_.gif','../dccc/ccimages09/button_menu_.gif','../dccc/ccimages09/button_reservations_.gif','../dccc/ccimages09/button_student_promos_.gif','../dccc/ccimages09/button_group_sales_.gif','../dccc/ccimages09/button_dizzy_birks_gillespie_.gif','../dccc/ccimages09/button_newsflash_.gif','../dccc/ccimages09/button_getting_here_.gif','../dccc/ccimages09/button_accessibility_.gif','../dccc/ccimages09/button_contact_us_.gif','../dccc/ccimages09/button_dizzys_xm_.gif','../dccc/ccimages09/button_special_menus_.jpg','../dccc/ccimages09/button_dizzys_gift_certs_.gif','../concerts/cimages09/button_ordertickets__03.gif','../dccc/ccimages09/right_hand_buttons_reviews_.gif','../dccc/ccimages09/right_hand_buttons_concert_group_sales_.gif')">
<div id="wrapper">
<% If dizzys Then %>
<a href="http://www.jalc.org">
<img src="../images/logos/logo_dizzys.jpg" name="logo" width="136" height="66" border="0" id="logo" alt="JALC Logo"/></a>
<% Else %>
<a href="http://www.jalc.org">
<img src="../images/logos/logo_concerts.jpg" name="logo" width="136" height="66" border="0" id="logo" alt="JALC Logo"/></a>
<% End If %>

    <!-- BEGIN: Constant Contact Basic Opt-in Email List Form -->

<div id="right">
<div id="search">
<table class="search" border="0" align="right" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF" style="border:0px solid #FFFFFF;">
<tr>
  <td align="center" style="border-top:2px solid #FFFFFF"><form action="http://www.jalc.org/about/adv_search09.html" id="cse-search-box">
  <div>
    <input type="hidden" name="cx" value="010467872811401749662:nnudbdagirq" />
    <input type="hidden" name="cof" value="FORID:11" />
    <input type="hidden" name="ie" value="UTF-8" />
    <input type="text" name="q" size="31" />
    <input type="submit" name="sa" value="Search" />
  </div>
</form>
<script type="text/javascript" src="http://www.google.com/cse/brand?form=cse-search-box&lang=en"></script>
  </td>
</tr>
</table>
</div><BR />


<!-- END: Constant Contact Basic Opt-in Email List Form -->
  </div><br />
<div id="navbar">
<div id="p7PMM_1" class="p7PMMh03">
  <ul class="p7PMM">
    <li><a href="http://jalc.org/concerts/c_calendar09.asp" class="p7PMM_img"><img src="../images/Home Banner Assets 10_11 Season/button_eventcalendar.gif" width="118" height="23" alt="Event Calendar" /></a>
      <div>
        <ul>
          <li><a href="http://jalc.org/concerts/c_calendar09.asp">Buy Tickets</a></li>
          <li><a href="http://jalc.org/concerts/c_order_tickets.html">Ticketing Information</a></li>
          <li><a href="http://jalc.org/concerts/c_calendar09.asp">Calendar of Events</a></li>
          <li><a href="http://jalc.org/concerts/c_rose-allen.asp">JALC Productions</a></li>
          <li><a href="http://jalc.org/dccc/index09.asp">Dizzy's Club Coca-Cola</a></li>
          <li><a href="http://jalc.org/concerts/c_orchestras09.html">Orchestra and Touring</a></li>
          <li><a href="http://jalc.org/concerts/c_group_sales09.html">Group Sales</a></li>
          <li><a href="http://jalc.org/subs/11_12/">Subscriptions</a></li>
          <li><a href="http://jalc.org/TheRoad/index.asp">Rhythm Road: American Music Abroad</a></li>
        </ul>
      </div>
    </li>
    <li><a href="http://jalc.org/jazzED/index09.html" class="p7PMM_img"><img src="../images/Home Banner Assets 10_11 Season/button_education.gif" width="90" height="23" alt="Education" /></a>
      <div>
        <ul>
          <li><a href="http://www.jalc.org/jazzED/s_index09.html">Students and Teachers</a></li>
          <li><a href="http://www.jalc.org/jazzED/g_index09.html">Kids and Families</a></li>
          <li><a href="http://www.jalc.org/jazzED/a_index09.html">Adult Education</a></li>
          <li><a href="http://www.jalc.org/jazzED/d_index09.html">Online Learning</a></li>
        </ul>
      </div>
    </li>
    <li><a href="http://www.jalc.org/jazzcast/index09.html" class="p7PMM_img"><img src="../images/Home Banner Assets 10_11 Season/button_multimedia.gif" width="93" height="23" alt="Multimedia" /></a>
      <div>
        <ul>
          <li><a href="http://www.jalc.org/jazzcast/releases.html">New Releases</a></li>
          <li><a href="http://www.jalc.org/jazzcast/j_screening09.html">Screening Room</a></li>
          <li><a href="http://www.jalc.org/jazzcast/jazz_player.html">Streaming Jazz Player</a></li>
          <li><a href="http://www.jalc.org/podcasts/">Podcasts</a></li>
          <li><a href="http://www.jalc.org/jazzcast/j_radio09.asp">Jazz Radio</a></li>
          <li><a href="http://jalc.org/jazzcast/j_schedule09.asp">Jazz Radio Schedule</a></li>
          <li><a href="http://jalc.org/jazzcast/j_stations09.asp">Jazz Radio Stations</a></li>
          <li><a href="http://jalc.org/jazzcast/archive09.asp">Jazz Radio Archives</a></li>
        </ul>
      </div>
    </li>
    <li><a href="http://www.jalc.org/visit/index09.html" class="p7PMM_img"><img src="../images/Home Banner Assets 10_11 Season/button_yourvisit.gif" width="82" height="23" alt="Your Visit" /></a>
      <div>
        <ul>
          <li><a href="http://www.jalc.org/visit/faq.html">Frequently Asked Questions</a></li>
          <li><a href="http://www.jalc.org/visit/getting_here09.html">Getting Here</a></li>
          <li><a href="http://www.jalc.org/visit/accessibility09.html">Accessibility</a></li>
          <li><a href="http://jalc.org/concerts/prognotes/notes09.asp">Program Notes</a></li>
          <li><a href="http://www.jalc.org/halloffame/">Visit the Nesuhi Ertegun Jazz Hall of Fame</a></li>
          <li><a href="http://www.jalc.org/exhibit/">Exhibitions</a></li>
          <li><a href="http://www.jalc.org/about/schaap_redirect2.html">Schaap Jazz Shop - Memorabilia</a></li>
        </ul>
      </div>
    </li>
    <li><a href="http://www.jalc.org/venues/index09.html" class="p7PMM_img"><img src="../images/Home Banner Assets 10_11 Season/button_venues.gif" width="117" height="23" alt="Venues & Rentals" /></a>
      <div>
        <ul>
          <li><a href="http://www.jalc.org/venues/allen/index09.html">The Allen Room</a></li>
          <li><a href="http://www.jalc.org/venues/rose/index09.html">Rose Theater</a></li>
          <li><a href="http://www.jalc.org/venues/atrium/index09.html">Atrium</a></li>
          <li><a href="http://www.jalc.org/venues/idec/index09.html">Irene Diamond Education Center</a></li>
          <li><a href="http://www.jalc.org/venues/recording/index09.html">Recording Studio</a></li>
          <li><a href="http://www.jalc.org/venues/dccc/index09.html">Dizzy's Club Coca-Cola</a></li>
          <li><a href="http://www.jalc.org/venues/ertegun/index09.html">Nesuhi Ertegun Jazz Hall of Fame</a></li>
          <li><a href="http://www.jalc.org/venues/tech_specs/cadfiles09.asp">Tech Specs</a></li>
          <li><a href="http://www.jalc.org/venues/rates/index09.html">Rates and Services</a></li>
          <li><a href="http://www.jalc.org/venues/access/index09.html">Access</a></li>
          <li><a href="http://www.jalc.org/venues/contact/index09.asp">Contact</a></li>
        </ul>
      </div>
    </li>
    <li><a href="http://www.jalc.org/about/index09.html" class="p7PMM_img"><img src="../images/Home Banner Assets 10_11 Season/button_aboutus.gif" width="77" height="23" alt="About Us" /></a>
      <div>
        <ul>
          <li><a href="http://www.jalc.org/about/a_profile09.html">Profile</a></li>
          <li><a href="http://supportjalc.org/mm5/merchant.mvc?Screen=SFNT&Store_Code=JALC">Support Jazz</a></li>
          <li><a href="http://www.jalc.org/about/a_newsflash09.asp">News Flash</a></li>
          <li><a href="http://www.jalc.org/about/a_press09.html">Press Room</a></li>
          <li><a href="http://www.jalc.org/about/special_events.html">Special Events</a></li>
          <li><a href="http://www.jalc.org/about/history.asp">Program History</a></li>
          <li><a href="http://www.jalc.org/about/a_careers09.asp">Careers at Jazz</a></li>
          <li><a href="http://www.jalc.org/about/a_leadership09.html">Leadership</a></li>
          <li><a href="http://www.jalc.org/about/a_board09.html">Board of Directors</a></li>
          <li><a href="http://www.jalc.org/about/a_staff09.html">Senior Management</a></li>
          <li><a href="http://www.jalc.org/about/a_sponsors09.html">Sponsors</a></li>
          <li><a href="http://www.jalc.org/about/a_contact09.html">Contact Us</a></li>
          <li><a href="http://www.jalc.org/about/a_credits09.html">Site Credits</a></li>
        </ul>
      </div>
    </li>
    <li><a href="http://visitor.constantcontact.com/manage/optin/ea?v=001VGGvr8xQIKhqefy-bTNNaA%3D%3D" class="p7PMM_img"><img src="../images/Home Banner Assets 10_11 Season/button_socialmedia.gif" width="95" height="23" alt="Social Media" /></a>
      <div>
        <ul>
          <li><a href="http://www.facebook.com/jazzatlincolncenter">Facebook</a></li>
          <li><a href="http://twitter.com/jalcnyc">Twitter</a></li>
          <li><a href="http://www.youtube.com/jazzatlincolncenter">YouTube</a></li>
        </ul>
      </div>
    </li>
  </ul>

<% If dizzys Then %>

	  <div class="p7pmmclearfloat">&nbsp;</div>
	  <!--[if lte IE 6]>
	<style>.p7PMMh03 ul ul li {float:left; clear: both; width: 100%;}.p7PMMh03 {text-align: left;}.p7PMMh03, .p7PMMh03 ul ul a {zoom: 1;}</style>
	<![endif]-->
	  <!--[if IE 5]>
	<style>.p7PMMh03, .p7PMMh03 ul ul a {height: 1%; overflow: visible !important;} .p7PMMh03 {width: 100%;}</style>
	<![endif]-->
	  <!--[if IE 7]>
	<style>.p7PMMh03, .p7PMMh03 a{zoom:1;}.p7PMMh03 ul ul li{float:left;clear:both;width:100%;}</style>
	<![endif]-->
	  <script type="text/javascript">
	<!--
	P7_PMMop('p7PMM_1',1,2,-5,-5,0,0,0,1,0,3,1,1,0);
	//-->
	  </script>
	</div>
	</div>
	<div id="banner"> <img src="../dccc/ccimages09/banner_blank_default_r1_c1.gif" alt="Banner" width="752" height="150" /> </div>
	<div id="main">
	  <table width="100%" border="0" cellpadding="0" cellspacing="0">
	  <tr>
		 <td align="left" valign="top" class="column_left">&nbsp;</td>
		 <td align="left" valign="top"><img src="../images/buffer.jpg" width="466" height="9" /></td>
		 <td rowspan="2" align="left" valign="top" class="column_right_details09"><img src="../images/buffer_right_column_edu.jpg" width="97" height="5" alt="buffer"/>


	<a href="http://www.yelp.com/biz/dizzys-club-coca-cola-new-york" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Reviews2','','../dccc/ccimages09/right_hand_buttons_reviews_.gif',1)" target="_blank"><img src="../dccc/ccimages09/right_hand_buttons_reviews.gif" alt="Read Dizzy's Reviews" name="Reviews2" width="97" height="69" border="0" id="Reviews2" /></a><br />

	<a href="http://jalc.org/dccc/index_food09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Gift_Certs','','../dccc/ccimages09/button_dizzys_gift_certs_.gif',1)"><img src="../dccc/ccimages09/button_dizzys_gift_certs.gif" alt="Gift Certificates" name="Gift_Certs" width="97" height="69" border="0" id="Gift_Certs" /></a><br />

	<a href="http://jalc.org/dccc/groups09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Concert','','../dccc/ccimages09/right_hand_buttons_concert_group_sales_.gif',1)"><img src="../dccc/ccimages09/right_hand_button_concert_group_sales.gif" alt="Concert Group Sales" name="Concert" width="97" height="69" border="0" id="Concert" /></a><a href="http://jalc.org/dccc/index_food09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Gift_Certs','','../dccc/ccimages09/button_dizzys_gift_certs_.gif',1)"></a>

	</td>
	  </tr>
	  <tr>
		 <td align="left" valign="top" class="column_left"><p><a href="http://jalc.org/concerts/c_order_tickets.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image28','','../concerts/cimages09/button_ordertickets__03.gif',1)"><img src="../concerts/cimages09/button_ordertickets_03.gif" alt="Order Tickets" name="Image28" width="142" height="21" border="0" id="Image28" /></a><a href="http://jalc.org/dccc/index09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Calendar','','../dccc/ccimages09/button_calendar_.gif',1)"><img src="../dccc/ccimages09/button_calendar.gif" alt="Calendar of Events" name="Calendar" width="142" height="31" border="0" id="Calendar" /></a><a href="http://www.jalc.org/dccc/c_afterhours09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('After Hours','','../dccc/ccimages09/button_after_hours_.gif',1)"><img src="../dccc/ccimages09/button_after_hours.gif" alt="After Hours" name="After_Hours" width="136" height="31" border="0" id="After_Hours" /></a><a href="http://www.jalc.org/dccc/menus09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Menu','','../dccc/ccimages09/button_menu_.gif',1)"><img src="../dccc/ccimages09/button_menu.gif" alt="Menu" name="Menu" width="136" height="31" border="0" id="Menu" /></a><a href="http://jalc.org/dccc/index_food09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('special_menus','','../dccc/ccimages09/button_special_menus_.jpg',1)"><img src="../dccc/ccimages09/button_special_menus.jpg" alt="Special Menus and Promotions" name="special_menus" width="143" height="32" border="0" id="special_menus" /></a><a href="http://www.jalc.org/dccc/c_reservations09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Reservations','','../dccc/ccimages09/button_reservations_.gif',1)"><img src="../dccc/ccimages09/button_reservations.gif" alt="Reservations and Information" name="Reservations" width="135" height="47" border="0" id="Reservations" /></a><a href="http://jalc.org/dccc/studentpromotions.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Student Promotions','','../dccc/ccimages09/button_student_promos_.gif',1)"><img src="../dccc/ccimages09/button_student_promos.gif" alt="Student Promotions" name="Student_Promotions" width="136" height="31" border="0" id="Student_Promotions" /></a><a href="http://jalc.org/dccc/groups09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Group Sales','','../dccc/ccimages09/button_group_sales_.gif',1)"><img src="../dccc/ccimages09/button_group_sales.gif" alt="Group Sales" name="Group_Sales" width="136" height="29" border="0" id="Group_Sales" /></a><a href="http://jalc.org/dccc/a_about09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Dizzy's Ethos','','../dccc/ccimages09/button_dizzys_ethos_.gif',1)"><img src="../dccc/ccimages09/button_dizzys_ethos.gif" alt="The Dizzy's Ethos" name="Dizzys_Ethos" width="136" height="30" border="0" id="Dizzys_Ethos" /></a><a href="http://jalc.org/dccc/a_gillespie09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('John Birks Gillespie','','../dccc/ccimages09/button_dizzy_birks_gillespie_.gif',1)"><img src="../dccc/ccimages09/button_dizzy_birks_gillespie.gif" alt="John Birks Gillespie" name="John_Birks_Gillespie" width="136" height="31" border="0" id="John_Birks_Gillespie" /></a><a href="http://jalc.org/dccc/a_newsflash09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Newsflash','','../dccc/ccimages09/button_newsflash_.gif',1)"><img src="../dccc/ccimages09/button_newsflash.gif" alt="Newsflash" name="Newsflash" width="136" height="29" border="0" id="Newsflash" /></a><a href="http://jalc.org/dccc/a_gettinghere09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Getting Here','','../dccc/ccimages09/button_getting_here_.gif',1)"><img src="../dccc/ccimages09/button_getting_here.gif" alt="Getting Here" name="Getting_Here" width="136" height="31" border="0" id="Getting_Here" /></a><a href="http://jalc.org/dccc/a_accessibility09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Accessibility','','../dccc/ccimages09/button_accessibility_.gif',1)"><img src="../dccc/ccimages09/button_accessibility.gif" alt="Accessibility" name="Accessibility" width="136" height="29" border="0" id="Accessibility" /></a><a href="http://jalc.org/dccc/a_contact09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Contact Us','','../dccc/ccimages09/button_contact_us_.gif',1)"><img src="../dccc/ccimages09/button_contact_us.gif" alt="Contact Us" name="Contact_Us" width="136" height="30" border="0" id="Contact_Us" /></a><a href="http://www.jalc.org/jazzcast/xm09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Dizzys XM','','../dccc/ccimages09/button_dizzys_xm_.gif',1)"><img src="../dccc/ccimages09/button_dizzys_xm.gif" alt="Dizzys XM" name="Dizzys_XM" width="136" height="44" border="0" id="Dizzys_XM" /></a></p></td>
		 <td align="left" valign="top" class="table_dizzys_center">

<% Else %>

  <div class="p7pmmclearfloat">&nbsp;</div>
  <!--[if lte IE 6]>
<style>.p7PMMh03 ul ul li {float:left; clear: both; width: 100%;}.p7PMMh03 {text-align: left;}.p7PMMh03, .p7PMMh03 ul ul a {zoom: 1;}</style>
<![endif]-->
  <!--[if IE 5]>
<style>.p7PMMh03, .p7PMMh03 ul ul a {height: 1%; overflow: visible !important;} .p7PMMh03 {width: 100%;}</style>
<![endif]-->
  <!--[if IE 7]>
<style>.p7PMMh03, .p7PMMh03 a{zoom:1;}.p7PMMh03 ul ul li{float:left;clear:both;width:100%;}</style>
<![endif]-->
  <script type="text/javascript">
<!--
P7_PMMop('p7PMM_1',1,2,-5,-5,0,0,0,1,0,3,1,1,0);
//-->
  </script>
</div>
</div>
<DIV id="banner"> <img src="../concerts/cimages09/banner_blank_orchestra_touring.jpg" alt="Jazz at Lincoln Center Orchestra" width="751" height="153" /></DIV>
<div id="main"><table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td align="left" valign="top" class="column_left">&nbsp;</td>
    <td align="left" valign="top"><img src="../images/buffer.jpg" width="466" height="9" border="0" /></td>
    <td rowspan="3" align="left" valign="top" background="../images/left_column_background09.jpg" class="column_right"><img src="../images/buffer_right_column_edu.jpg" width="97" height="5" /><BR /></td>
  </tr>
  <tr>
    <td align="left" valign="top" class="column_left"><p><a href="http://jalc.org/concerts/c_jazz_productions09a.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Jazz Productions','','../concerts/cimages09/button_jazz_prods_.gif',1)"><a href="c_order_tickets.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Order Tickets','','file:///OtherFiles/Webmaster/local_mirror/concerts/cimages09/button_ordertickets_.gif',1)"></a><a href="http://jalc.org/concerts/c_jazz_productions09a.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image25','','../concerts/cimages09/button_ordertickets__03.gif',1)"><a href="http://jalc.org/concerts/c_calendar09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image25','','file:///OtherFiles/Webmaster/local_mirror/concerts/cimages09/button_ordertickets__03.gif',1)"><img src="../concerts/cimages09/button_ordertickets_03.gif" alt="Buy Tickets" name="Image25" width="142" height="21" border="0" id="Image25" /></a><a href="http://jalc.org/concerts/c_order_tickets.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('ticketing_info','','../concerts/cimages09/button_ticketing_info_.gif',1)"><img src="../concerts/cimages09/button_ticketing_info.gif" name="ticketing_info" width="142" height="29" border="0" id="ticketing_info" /></a><a href="../c_calendar09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Calendar of Events','','../concerts/cimages09/button_calendar__09.gif',1)"><img src="../concerts/cimages09/button_calendar_09.gif" alt="Calendar of Events" name="Calendar of Events" width="142" height="29" border="0" id="Calendar of Events" /></a><a href="http://jalc.org/concerts/c_rose-allen.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image24','','../concerts/cimages09/button_jalc_productions_.jpg',1)"><img src="../concerts/cimages09/button_jalc_productions.jpg" alt="Jazz Productions" name="Image24" width="146" height="31" border="0" id="Image24" /></a><a href="http://jalc.org/dccc/index09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Dizzys','','../concerts/cimages09/button_dccc_.gif',1)"><img src="../concerts/cimages09/button_dccc.gif" alt="Dizzy's Club Coca-Cola" name="Dizzys" width="146" height="44" border="0" id="Dizzys" /></a><a href="http://jalc.org/concerts/c_jazzED09.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Education Events','','../concerts/cimages09/button_ed_events_.gif',1)"><img src="../concerts/cimages09/button_ed_events.gif" alt="Education Events" name="Education Events" width="146" height="31" border="0" id="Education Events" /></a><a href="http://jalc.org/concerts/c_orchestras09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Orchestra and Touring','','../concerts/cimages09/button_orch_touring_.gif',1)"><img src="../concerts/cimages09/button_orch_touring.gif" alt="Orchestra and Touring" name="Orchestra and Touring" width="146" height="31" border="0" id="Orchestra and Touring" /></a><a href="http://jalc.org/concerts/c_group_sales09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Group Sales','','../concerts/cimages09/button_group_sales_.gif',1)"><img src="../concerts/cimages09/button_group_sales.gif" alt="Group Sales" name="Group Sales" width="146" height="31" border="0" id="Group Sales" /></a><a href="http://jalc.org/subs/11_12/" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Subscriptions','','../concerts/cimages09/button_subs_.gif',1)"><img src="../concerts/cimages09/button_subs.gif" alt="Subscriptions" name="Subscriptions" width="146" height="28" border="0" id="Subscriptions" /></a><a href="http://jalc.org/concerts/c_getting_here09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Getting Here','','../concerts/cimages09/button_getting_here_.gif',1)"><img src="../concerts/cimages09/button_getting_here.gif" alt="Getting Here" name="Getting Here" width="146" height="30" border="0" id="Getting Here" /></a><a href="http://jalc.org/concerts/c_access09.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Accessibility','','../concerts/cimages09/button_accessibility_.gif',1)"><img src="../concerts/cimages09/button_accessibility.gif" alt="Accessibility" name="Accessibility" width="146" height="29" border="0" id="Accessibility" /></a><a href="http://jalc.org/TheRoad/index.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Rhythm Road','','../concerts/cimages09/button_rr_.gif',1)"><img src="../concerts/cimages09/button_rr.gif" alt="The Rhythm Road" name="Rhythm Road" width="146" height="47" border="0" id="Rhythm Road" /><br />
    </a><a href="http://jalc.org/TheRoad/index.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Rhythm Road','','../concerts/cimages09/button_rr_.gif',1)">    </a><a href="http://jalc.org/concerts/c_seating_charts.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image26','','../concerts/cimages09/button_seating_charts_.jpg',1)"><img src="../concerts/cimages09/button_seating_charts.jpg" alt="Seating Charts" name="Image26" width="140" height="39" border="0" id="Image26" /></a><a href="http://jalc.org/TheRoad/index.asp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Rhythm Road','','../concerts/cimages09/button_rr_.gif',1)"><br />
      </a></p></td>
    <td align="left" valign="top" class="table_concerts_center">

<% End If %>
<% If dizzys Then %>
			<img src="../dccc/ccimages09/sub_header_PROMOTIONS_ENTRY_FORM.png" alt="Promotions Entry Form" width="296" height="24" />
		<% Else %>
			<img src="../dccc/images/sub_header_PROMOTIONS_ENTRY_FORM_purple.png" alt="Promotions Entry Form">
      <% End If %>
		<form action="<%=MM_editAction%>" method="post" name="form1" id="form1" onsubmit="MM_validateForm('promoCode','','R','firstName','','R','lastName','','R','address','','R','city','','R','zip','','R','email','','RisEmail');return document.MM_returnValue">

		  <table border="0" cellpadding="0" cellspacing="15" class="CENTERCOPY">
		    <tr>
		      <td><span class="style7">Welcome and thank you for participating in&nbsp;this promotion.&nbsp; You may enter this promotion by  completing all&nbsp;required fields and inputting the promotion code provided  in the printed ad, email or radio announcement, in the &quot;Promotion  Code&quot; field.&nbsp;
		        </p>
		        </span>
		        <p><span class="style1">Un</span><span class="style7">less  otherwise noted,&nbsp;you must be 18 to enter all promotions.&nbsp; </span></p>
		        <span class="style7">Thanks again for participating.&nbsp; Good Luck.</span>
		        <input name="entryDate" type="hidden" id="entryDate" value="<% =Now() %>" />
		        <table width="100%" border="0" cellspacing="2" cellpadding="2">
		          <tr>
		            <td class="CENTERCOPY" scope="col">Promotion Code</td>
		            <td class="text_gray" scope="col"><input name="promoCode" type="text" id="promoCode" size="15" maxlength="100" /></td>
	              </tr>
		          <tr>
		            <td scope="col"><div align="left" class="CENTERCOPY">First Name</div></td>
		            <td scope="col"><div align="left">
		              <span class="text_gray">
		                <input name="firstName" type="text" id="firstName" size="25" />
		                </span></div></td>
	              </tr>
		          <tr>
		            <td><div align="left" class="CENTERCOPY">Last Name</div></td>
		            <td><div align="left">
		              <span class="text_gray">
		                <input name="lastName" type="text" id="lastName" size="25" />
		                </span></div></td>
	              </tr>
		          <tr>
		            <td><div align="left" class="CENTERCOPY">Address</div></td>
		            <td><div align="left">
		              <span class="text_gray">
		                <input name="address" type="text" id="address" size="40" />
		                </span></div></td>
	              </tr>
		          <tr>
		            <td><div align="left" class="CENTERCOPY">City</div></td>
		            <td><div align="left">
		              <p>
		                <span class="text_gray">
		                  <input name="city" type="text" id="city" size="25" />
		                  </span></p>
	                </div></td>
	              </tr>
		          <tr>
		            <td class="CENTERCOPY">State</td>
		            <td class="text_gray"><select name="state" id="state" class="text_gray">
		              <%
While (NOT RecordsetStates.EOF)
%>
		              <option value="<%=(RecordsetStates.Fields.Item("stateid").Value)%>" <%If (Not isNull((RecordsetStates_last))) Then If (CStr(RecordsetStates.Fields.Item("stateid").Value) = CStr((RecordsetStates_last))) Then Response.Write("selected=""selected""") : Response.Write("")%> ><%=(RecordsetStates.Fields.Item("stateid").Value)%></option>
		              <%
  RecordsetStates.MoveNext()
Wend
If (RecordsetStates.CursorType > 0) Then
  RecordsetStates.MoveFirst
Else
  RecordsetStates.Requery
End If
%>
	                </select></td>
	              </tr>
		          <tr>
		            <td class="CENTERCOPY">Zip</td>
		            <td class="text_gray"><input name="zip" type="text" id="zip" size="15" /></td>
	              </tr>
		          <tr>
		            <td><div align="left" class="CENTERCOPY">Email</div></td>
		            <td><div align="left">
		              <span class="text_gray">
		                <input name="email" type="text" id="email" size="50" />
		                </span></div></td>
	              </tr>
		          <tr>
		            <td class="CENTERCOPY">Age Range</td>
		            <td class="text_gray"><select name="ageRange" id="ageRange">
		              <option>Select ...</option>
		              <option value="under 21">under 21</option>
		              <option value="21-25">21-25</option>
		              <option value="25-35">25-35</option>
		              <option value="over 35">over 35</option>
		              </select>
	                &nbsp;&nbsp;</td>
	              </tr>
		          <tr>
		            <td class="CENTERCOPY">How did you hear of this promotion? </td>
		            <td><span class="CENTERCOPY"><select name="howHeard" id="howHeard">
		              <option>Select ...</option>
		              <option value="email">Dizzy's e-mail</option>
		              <option value="website">JALC website</option>
		              <option value="friend">A friend</option>
		              <option value="other">Other - please list</option>
		              </select>
		              <br />
		              </span><span class="style9">Other</span><span class="text_gray">
	                  <input name="howHearOther" type="text" id="howHearOther" size="35" />
                    </span></td>
	              </tr>
		          <tr>
		            <td colspan="2"><p><span class="text_gray">
		              <input name="optIn" type="checkbox" id="optIn" value="Yes" checked="checked" />
		              </span><span class="CENTERCOPY">I would like to receive special offers and information about<br>
		                <% If dizzys Then %>
		                Dizzy's Club <em>Coca-Cola.</em>
		                <% Else %>
		                Jazz at Lincoln Center
		                <% End If %>
		                </span></p>
		              <p><span class="CENTERCOPY">Please tell us more about your interests:<br />
		                </span>
	                  </p>
		              <p>
		                <input name="rose_allen" type="checkbox" id="rose_allen" value="Y" />
		                <label for="rose_allen">Concerts in Rose Theater / The Allen Room</label><br />
                        <input name="subscriptions" type="checkbox" id="subscriptions" value="Y" />
		                <label for="subscriptions">Subscriptions</label><br />
                        <input name="dizzys" type="checkbox" id="dizzys" value="Y" />
		                <label for="dizzys">Dizzy's Club Coca-Cola</label><br />
                        <input name="jlco" type="checkbox" id="jlco" value="Y" />
		                <label for="jlco">JLCO on Tour</label><br />
                        <input name="hang_set" type="checkbox" id="hang_set" value="Y" />
		                <label for="hang_set">Hang Set (for ages 21-40)</label><br />
                        <input name="group_sales" type="checkbox" id="group_sales" value="Y" />
		                <label for="group_sales">Group Sales</label><br />
                        <input name="jazz_ed_kids" type="checkbox" id="jazz_ed_kids" value="Y" />
		                <label for="jazz_ed_kids">Jazz Education for Kids & Families</label><br />
                        <input name="jazz_ed_adults" type="checkbox" id="jazz_ed_adults" value="Y" />
		                <label for="jazz_ed_adults">Jazz Education for Adults</label><br />
                        <input name="jazz_ed_educators" type="checkbox" id="jazz_ed_educators" value="Y" />
		                <label for="jazz_ed_educators">Jazz Education for Schools & Educators</label><br />
                        <input name="venue_rentals" type="checkbox" id="venue_rentals" value="Y" />
		                <label for="venue_rentals">Venue Rentals</label><br />
                        <input name="volunteering" type="checkbox" id="volunteering" value="Y"/>
		                <label for="volunteering">Volunteering</label><br />
                      </p>
		              <span class="CENTERCOPY">
		              </span></td>
	              </tr>
		          <tr>
		            <td colspan="2"><span class="CENTERCOPY"><a onclick="window.open('rules09.html', 'rulesWin', 'width=600,height=700,top=100,left=100,scrollbars=1')" href="#" class="link_red">Click here</a> to review promotion rules.<br />
		              Review your answers and</span><span class="text_gray">
	                  <input name="submit" type="submit" class="text_graySmall" id="submit" value="click here" />
                    .</span></td>
	              </tr>
		          <tr>
		            <td colspan="2" class="CENTERCOPY">&nbsp;</td>
	              </tr>
	            </table>
	          <input type="hidden" name="MM_insert" value="form1" />          </td>
	        </tr>
	      </table>
      </form></td>
    </tr>
  <tr>
    <td align="left" valign="top" class="column_left">&nbsp;</td>
    <td align="left" valign="top"><img src="../images/buffer.jpg" width="466" height="9" border="0" alt="buffer"/></td>
    </tr>
  <tr>
    <td colspan="3" align="left" valign="top" class="column_left"><div id="copyright"> <img src="../images/copy_right_footer_11_3_10.jpg" alt="Copyright" width="752" height="49" border="0" usemap="#Map" />
      <map name="Map" id="Map">
        <area shape="rect" coords="368,15,447,35" href="http://www.jalc.org/about/privacy.html" alt="Privacy Policy" />
        <area shape="rect" coords="592,15,664,36" href="http://www.jalc.org/about/a_contact09.html" alt="Contact Us" />
        <area shape="rect" coords="-4,5,37,43" href="http://www.facebook.com/jazzatlincolncenter" target="_blank" alt="Facebook" />
        <area shape="rect" coords="87,5,130,46" href="http://www.youtube.com/jazzatlincolncenter" target="_blank" alt="YouTube" />
        <area shape="rect" coords="42,5,84,46" href="http://twitter.com/jalcnyc" target="_blank" alt="Twitter" />
        <area shape="rect" coords="449,14,543,35" href="http://www.jalc.org/about/tos09.html" alt="Terms of Service" />
        <area shape="rect" coords="549,15,589,36" href="http://www.jalc.org/about/adv_search.html" alt="Search" />
        <area shape="rect" coords="664,15,734,36" href="http://visitor.r20.constantcontact.com/d.jsp?llr=v5dxh6cab&amp;p=oi&amp;m=1102640287701" target="_blank" />
      </map>
    </div></td>
    </tr>
</table>
  </div>

</div>
<!-- GOOGLE ANALYTICS -->

<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-4028452-1");
pageTracker._trackPageview();
} catch(err) {}</script>

<!-- END GOOGLE ANALYTICS -->
</body>
</html>

Open in new window


As you can see, I didn't change your code.

Only thing I removed was your connection string and added mine.

The name of my db is Paging.mdb.

Replace paging with your own db name. I am using the same table name as yours. so, nothing to change there.

Also, All the fieldnames are text except one I called ID which is autoNumber.

Try this code and let me know.
0
 

Author Comment

by:jalcadmin
ID: 37784014
I changed the connection string at the top to this:

set MM_connDizContestJET_STRING = server.CreateObject("ADODB.Connection")
set objRS =server.CreateObject("ADODB.Recordset")
MM_connDizContestJET_STRING.ConnectionString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\PEO\JALCdatabases\dccc\contest.mdb"
objRs.CursorLocation = 3
MM_connDizContestJET_STRING.Open

Open in new window


Then I get this error:

Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'sales'. Make sure it exists and that its name is spelled correctly.

/neworleansexperience/index.asp, line 100

This is referring to this code:

<%
Dim RecordsetStates
Dim RecordsetStates_cmd
Dim RecordsetStates_numRows

Set RecordsetStates_cmd = Server.CreateObject ("ADODB.Command")
RecordsetStates_cmd.ActiveConnection = MM_connDizContestJET_STRING
RecordsetStates_cmd.CommandText = "SELECT * FROM sales ORDER BY States"
RecordsetStates_cmd.Prepared = true

Set RecordsetStates = RecordsetStates_cmd.Execute
RecordsetStates_numRows = 0
%>
0
 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37784026
Sorry, I forgot that change.

You had it as States. So, change it back to States.

Also, where I had stateid, you had as abbr or something like that.

Please change those back as well.
0
 

Author Comment

by:jalcadmin
ID: 37784056
Now I'm getting this error when trying to load the page:

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/neworleansexperience/index.asp, line 100

Here is the code that references:

<%
Dim RecordsetStates
Dim RecordsetStates_cmd
Dim RecordsetStates_numRows

Set RecordsetStates_cmd = Server.CreateObject ("ADODB.Command")
RecordsetStates_cmd.ActiveConnection = MM_connDizContestJET_STRING
RecordsetStates_cmd.CommandText = "SELECT * FROM tblStates ORDER BY States"
RecordsetStates_cmd.Prepared = true

Set RecordsetStates = RecordsetStates_cmd.Execute
RecordsetStates_numRows = 0
%>

Open in new window

0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37784088
which line is line 100?

Did you make the additional changes I mentioned?

This line:

RecordsetStates_cmd.CommandText = "SELECT * FROM tblStates ORDER BY State"

change TO Order by State
0
 

Author Comment

by:jalcadmin
ID: 37784142
OK, I got the page to load after changing stateid back to Abbr.  However, I am still getting this error when trying to submit the form:

Microsoft JET Database Engine error '80040e10'
Parameter ?_15 has no default value.
/neworleansexperience/index.asp, line 72

Line 72 is the "execute" line of this code (line 35 below)

<%
If (CStr(Request("MM_insert")) = "form1") Then
  If (Not MM_abortEdit) Then
    ' execute the insert
    Dim MM_editCmd

    Set MM_editCmd = Server.CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_connDizContestJET_STRING
    MM_editCmd.CommandText = "INSERT INTO tblContest (entryDate, promoCode, firstName, lastName, address, city, [state], zip, email, ageRange, howHear, howOther, optIn, rose_allen, subscriptions, dizzys, jlco, hang_set, group_sales, jazzed_kids, jazzed_adults, jazzed_educators, venue_rentals, volunteering) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 135, 1, -1, MM_IIF(Request.Form("entryDate"), Request.Form("entryDate"), null)) ' adDBTimeStamp
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 25, Request.Form("promoCode")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 255, Request.Form("firstName")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 255, Request.Form("lastName")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 255, Request.Form("address")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 255, Request.Form("city")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 255, Request.Form("state")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 255, Request.Form("zip")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 202, 1, 255, Request.Form("email")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 202, 1, 255, Request.Form("ageRange")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 202, 1, 255, Request.Form("howHeard")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 202, 1, 255, Request.Form("howHearOther")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 202, 1, 5, MM_IIF(Request.Form("optIn"), "Y", "N")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param14", 202, 1, 5, Request.Form("rose_allen")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param15", 202, 1, 5, Request.Form("subscriptions")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param16", 202, 1, 5, Request.Form("dizzys")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param17", 202, 1, 5, Request.Form("jlco")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param18", 202, 1, 5, Request.Form("hang_set")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param19", 202, 1, 5, Request.Form("group_sales")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param20", 202, 1, 5, Request.Form("jazzed_kids")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param21", 202, 1, 5, Request.Form("jazzed_adults")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param22", 202, 1, 5, Request.Form("jazzed_educators")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param23", 202, 1, 5, Request.Form("venue_rentals")) ' adVarWChar
	MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param24", 202, 1, 5, Request.Form("volunteering")) ' adVarWChar
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    ' append the query string to the redirect URL
    Dim MM_editRedirectUrl
    MM_editRedirectUrl = "../dccc/tyContest.asp"

    If (Request.QueryString <> "") Then
      If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
        MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
      Else
        MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
      End If
    End If
    Response.Redirect(MM_editRedirectUrl)
  End If
End If
%>

Open in new window

0
 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37784172
Do you have an AutoNumber?

If no, can you create one?

If you already have one, please send me the process page so I can test here too.
0
 

Author Comment

by:jalcadmin
ID: 37784194
I have an auto-number set up for the entryID.

The process page is attached.
tyContest.txt
0
 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37784208
I *THINK* I found the problem.

If you look at your insert, you have

    MM_editCmd.CommandText = "INSERT INTO tblContest (entryDate, promoCode, firstName, lastName, address, city, [state], zip, email, ageRange, howHear, howOther, optIn, rose_allen, subscriptions, dizzys, jlco, hang_set, group_sales, jazzed_kids, jazzed_adults, jazzed_educators, venue_rentals, volunteering) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

However, here you have:

    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 202, 1, 255, Request.Form("howHeard")) ' adVarWChar

is that right or should it be howHear?
0
 
LVL 28

Expert Comment

by:sammySeltzer
ID: 37784217
Nevermind, it is correct.
0
 

Accepted Solution

by:
jalcadmin earned 0 total points
ID: 37789015
Found the answer to this from my programmer:

Your issue was that checkbox fields don't get POSTed unless they were checked – so for example, Request.Form("rose_allen") is null rather than false.

Note how I changed each of the checkbox fields so it gets entered in the same way as the one that was already there (optIn), using the MM_IIF function:

    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 202, 1, 5, MM_IIF(Request.Form("optIn"), "Y", "N")) ' adVarWChar
      MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param14", 202, 1, 5, MM_IIF(Request.Form("rose_allen"), "Y", "N")) ' adVarWChar
      MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param15", 202, 1, 5, MM_IIF(Request.Form("subscriptions"), "Y", "N")) ' adVarWChar
0
 

Author Closing Comment

by:jalcadmin
ID: 37805197
Figured it out internally.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form.  And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…
So you have coded your own WordPress plugin and now you want to allow users to upload images to a folder in the plugin folder rather than the default media location? Follow along and this article will show you how to do just that!
In this Micro Tutorial users will learn how to embed custom fonts into websites using @font-face in CSS Select a font: Ensure the EULA allows you to use @font-face: Download the font: Get the browser-compatible files you need: Edit your CSS       - Name …
In this tutorial viewers will learn how to position items using CSS's three positioning types Create a new HTML document with an internal stylesheet.: Create another div in CSS and name it Absolute : Type "position:absolute;" and "top:10px; left:50p…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now