<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello, Perl Mongers,<br>
<br>
I'm working with someone who wants a fairly straightforward database
system to process web-based applications for people who aspire to
put on their stage shows in his theatre festivals.<br>
<br>
Here's the notice he posted on LinkedIn:<br>
<br>
<div class="popular-article">
<div class="user-contributed">
<h3 class="groups title">
Online database wanted
</h3>
<p class="summary">I produce theatre festivals in NYC. I use
Constant Contact for E-blasts. I created an online application
form using their survey tools, which is a step up from having
people print and fill out a paper application form, which we
then need to enter into a spreadsheet and share with our
staff. I'm looking to make another step up. I need the
following features:<br>
* Share application form on Web site.<br>
* Allow applicants to save their work and go back to it.<br>
* Maintain applicants' privacy (from each other).<br>
* Allow upload of supporting materials in PDF, DOC, JPEG, MP3,
etc. format.<br>
* Branching to different pages depending on input.<br>
* Pay different application fees depending on plan chosen,
preferably with PayPal interface.<br>
* Save results, supporting materials, and payment records in
manageable formats (spreadsheet, separate folders, master
file, etc.).<br>
<br>
Any and all suggestions welcome!<br>
John Chatterton<br>
Executive producer, Midtown International Theatre Festival,
Midwinter Madness Short Play Festival, Short Play Lab</p>
</div>
</div>
<br>
<br>
He also wants a kind of intranet access to the application data for
his various staff, each of which may need to narrow their view to
see a subset of the application fields.<br>
<br>
While working with him to redesign his web site
(midtownfestival.org), I proposed a Perl/mySQL solution, but he
seems to have an aversion to Perl, preferring a more direct use of
the SQL language. I frankly didn't understand what he was asking
for, but he was quite specific and seems to have had Perl
experience. So I'm passing this on to any of you who do understand.<br>
<br>
It might seem odd that I would propose a specifically non-Perl job
on this list, but I'm hoping some of you may have encountered an SQL
alternative that can be used for this purpose. I certainly have not.<br>
<br>
If you're interested, you can contact him at
<a class="moz-txt-link-abbreviated" href="mailto:midtownfestival@gmail.com">midtownfestival@gmail.com</a>. If you have questions, I'll be glad to
answer them.<br>
<br>
<div class="moz-signature">-- <br>
<div
style="font-family:verdana,arial;font-size:1em;line-height:110%;">
<p><strong>David Merrill, Clarient Solutions<br>
</strong></p>
<p style="font-size:.85em;"><i>"I am always doing that which I
cannot do, in order that I may learn how to do it."<br>
-- Pablo Picasso</i><br>
<br>
<i>"By three methods we may learn wisdom: First, by
reflection, which is noblest;<br>
Second, by imitation, which is easiest; and third by
experience, which is the bitterest."<br>
-- Confucius</i><br>
<br>
</p>
</div>
</div>
</body>
</html>