<% Set conn= server.createobject("adodb.connection") conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("newsletter\_db\newsletter.mdb") ' For security reasons you should move your database to a folder not accessable from the Internet ' and use the connection string below to connect to it. Just un-comment it, and change the path to your DB. 'conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\databases\newsletter.mdb;" If Session("MaxUsers") <> "No" Then Session("MaxUsers") = "No" End If %> Subscribe to eNOTES

The Fresno Philharmonic

<% If Request("Submit") <> "" Then If Request("email") = "" or Request("firstname") = "" Then Response.write "" Else SQLstmt = "INSERT INTO [list] (firstname,lastname,email,mygroup,status)" SQLstmt = SQLstmt & " VALUES (" SQLstmt = SQLstmt & "'" & request("firstname") & "'," SQLstmt = SQLstmt & "'" & request("lastname") & "'," SQLstmt = SQLstmt & "'" & request("email") & "'," SQLstmt = SQLstmt & "'" & request("group") & "'," SQLstmt = SQLstmt & "'subscribed'" SQLstmt = SQLstmt & ")" 'on error resume next Set RS = conn.execute(SQLstmt) Response.Write "

Thank-you for subscribing to eNOTES! eNOTES is typically published bi-weekly. Be sure to look for it in your inbox!

" & vbCRLF Set Rs = Nothing conn.Close Set conn = Nothing End If Else %>
<% If Request("e") = "1" Then %> <% End If %>

Subscribe to eNOTES!

Join our email club and get all the latest symphony information, special concert discounts and concert reminders.
* Your first name and email address are required.
*First Name
">
Last Name
">
*Email Address
">
* Required fields.
<% End If %>
559.261.0600

eNOTES Archive
Missed an eNOTES? Accidentally deleted it? No problem. We have them right here for you!

Volume 2 Issue 5 [published 11.29.07]
Holiday Jubilee - Five local music ensembles join the Fresno Philharmonic in concert this weekend.

Volume 2 Issue 4 [published 11.13.07]
All about Mozart's Magnificent Voyage.

Volume 2 Issue 3 [published 10.16.07]
Learn about our lastest concerts, new series packages and recieve a party invitation!

Volume 2 Issue 2 [published 10.12.07]
A brief look at Joshua Bell.

Volume 2 Issue 1 [published 06.14.07]
Information about the Philharmonic's new Beethoven Festival!