Adobe Community : All Content - All Communities

Batch processing images of various sizes

forums_noreply@adobe.com — Thu, 20 Dec 2012 04:14:26 GMT

I'm trying to create 125 pixel square thumbnail images using a batch process and I'm having trouble getting it to work consistently with images that have different aspect ratios. I think I know why it's working the way it is, but I don't know how to work around the function. Here is what I'm doing that doesn't work when the image proportions change:

1. Resize image to 125 pixels high using the "constrain proportions" option.

2. Resize canvas to 125 pixels wide, thus cropping the sides to create the square image.

Then I have another process that does the same thing with images in portrait orientation. The problem is, I have some images that are 640x480, for example, and some that are 640x360. If I create the command using a 640x480 image, the 640x360 images are skewed when run through the batch because the "resize image" step is actually setting the dimensions of the image, rather than maintaining the proportions of that particular image. I thought about setting the canvas to a square first, but since not all my images are the same dimensions, I'm not sure how to account for that.

Anyone have any thoughts? I also have Photoshop, but as a novice, I've found Fireworks to be a little more intuitive for some of these basic commands, particularly batch processes.

Any help would be appreciated. Thanks so much!

Jeremy

cfinput datefield alignment

forums_noreply@adobe.com — Tue, 12 Feb 2013 23:26:19 GMT

I've seen a couple posts about this on a couple different sites/blogs, but no solutions, so I figured I'd post the question myself and see if anyone's come up with any workarounds or alternatives.

I love the functionality of the cfinput type="datefield", but I'm having the common problem that I cannot get it to display inline. For example, I'm working on a calendar, and on the create_event.cfm page, I want to use these inputs for the dates and for repeating event options. The line I'm trying to have on the page is:

Repeat daily until <cfinput type="datefield" name="repeatuntil">

However, when the page loads, because of the <div> tag and css that CF automatically generates, it aligns the datefield to the left, as if it was written like this:

<cfinput type="datefield" name"repeatuntil"> Repeat daily until

Does anyone know a way to override the automatically generated css to get it to display where I want it? If not, does anyone know of a good alternative where I can still have the input field with a poput calendar to choose a date?

Would appreciate any help. Thanks so much!

JAW

Problem looping insert query

forums_noreply@adobe.com — Mon, 11 Feb 2013 02:12:29 GMT

I'm working on inserting a recordset up Google Calendar entries into my site database. I have a form set up that allows me to insert new entries into the data table, but when I try to loop the insert query over the Google recordset, I get nothing (no errors, but no entries added to database).

Here's my form, which both displays the values from the Google query and populates fields (mostly hidden) with those values to submit to the Insert query. There's also a line that checks to make sure the event hasn't been canceled (canceled events are still listed, the start and end times are just set to null values):

<form method="post" action="<cfoutput>#CurrentPage#</cfoutput>">

<tr>

<td>#thisRow#</td>

<td><input name="creator#thisRow#" type="hidden" value="#authoremail#" />#authoremail#</td>

<td><input name="starttime#thisRow#" type="hidden" value="#starttime#" />#starttime#</td>

<td><input name="endtime#thisRow#" type="hidden" value="#endtime#" />#endtime#</td>

<td><input name="title#thisRow#" type="hidden" value="#title#" />#title#</td>

<td><input name="content#thisRow#" type="hidden" value="#content#" />#content#</td>

<td><input name="location#thisRow#" type="hidden" value="#where#" />#where#</td>

<td><input name="published#thisRow#" type="hidden" value="#ISOToDateTime(published)#" />#ISOToDateTime(published)#</td>

<td><input name="updated#thisRow#" type="hidden" value="#ISOToDateTime(updated)#" />#ISOToDateTime(updated)#</td>

</tr>

</cfoutput>

</cfif>

</cfloop>

</table>

</form>

Here's the action script. There's some extra code in there to convert some of the date formats Google uses, and to account for the differences in time zones between the Google values and local time:

</cfif>

INSERT INTO Events (Calendar, Created_By, All_Day, Event_Start, Event_End, Title, Content, Location, ID, Published, Updated) Values (

<cfqueryparam value="#thisCalendar#" cfsqltype="cf_sql_varchar">,

<cfqueryparam value="#thisCreator#" cfsqltype="cf_sql_varchar">,

<cfqueryparam value="#thisAllDay#" cfsqltype="cf_sql_integer">,

<cfqueryparam value="#thisStarttime#" cfsqltype="cf_sql_timestamp">,

<cfqueryparam value="#thisEndtime#" cfsqltype="cf_sql_timestamp">,

<cfqueryparam value="#thisTitle#" cfsqltype="cf_sql_varchar">,

<cfqueryparam value="#thisContent#" cfsqltype="cf_sql_clob">,

<cfqueryparam value="#thisLocation#" cfsqltype="cf_sql_varchar">,

<cfqueryparam value="#thisID#" cfsqltype="cf_sql_varchar">,

<cfqueryparam value="#thisPublished#" cfsqltype="cf_sql_timestamp">,

<cfqueryparam value="#thisUpdated#" cfsqltype="cf_sql_timestamp">)

</cfquery>

</cfloop>

</cfif>

I'm thinking there must be something pretty obvious I've screwed up, but I can't for the life of me find it. Any help would be appreciated!

JAW

Integrate custom css in Google Calendar

forums_noreply@adobe.com — Sat, 30 Jun 2012 01:04:41 GMT

I'm a teacher and I'm building a web site for my school band. I have a calendar on my site now that's just a standard Google Calendar. I'd like to be able to customize the css, but I know you can't really do that with the standard <iframe> embed that Google uses. I've found some places that describe how it can be done, but they seem to either require php (I'm guessing that's what Google uses?) rather than coldfusion, or, they utilize the xml output, which I have not been able to figure out how to format back into a standard calendar layout. Anyone have any experience doing this with Coldfusion? Anyone know of any tutorials that might help out a newbie?

Thanks!

JAW

Multiple timeout lengths depending on Authorization

forums_noreply@adobe.com — Sun, 24 Jun 2012 14:56:24 GMT

I have multiple User Authorization settings (Administrator, Editor, Member, etc.) for my site. I'm not familiar with scope settings or anything like that, so I've used Dreamweaver to set those up. What I'd like to do is set a different timeout setting for Administrators and Editors because when performing site updates and things, I'm often on one page longer than the current setting. Is there a way to set the timeout setting conditionally? Something like this:

</cfif>

Will that work?

Jeremy

Problem creating list of changed entries

forums_noreply@adobe.com — Fri, 08 Jun 2012 16:47:49 GMT

I've got a form that calls a list of file names and other details from a data table. There is a checkbox to select whether or not each item will appear on another page, and I'm trying to keep track of which records are changed each time the form is submitted. For example, if all items are selected (checked) and you uncheck the first 4, I'd like to create a variable that will save the ids of those items in a list so I can call it on a confirmation page. I'm having trouble getting my sql to populate the list properly though, and I'm not sure exactly why. In order to run the loop, I've collected a list of all the items displayed in a hidden form field called "listofIDs." That should be the starting point. What I've tried to do is as the loop is processed, compare the original value of the checkbox (displayOld) to the new value of the checkbox (displayNew) and if they are the same, remove that id from the original list. Then I could call that list as a url parameter and use it on the confirmation page. Unfortunately, it usually works properly when I go from all items selected to deselecting a couple, but once I've got some selected and some not at the starting point, it's not giving me the right IDs as the changed records. Could anyone please check my sql below and let me know what the issue is? I've included comments as to my thought process.

</cfif>

</cfif>

UPDATE Files

SET Display = #displayNew#

WHERE ID = #currentID#

</cfquery>

</cfloop>

</cfif>

Problem with mdb data type

forums_noreply@adobe.com — Wed, 13 Jun 2012 04:16:21 GMT

I'm working with an mdb database and I've got a form with a <cftextarea> field set to rich text. When I try to update the data table I'm getting the following error:

Application uses a value of the wrong type for the current operation.

It's fine with a short entry, even with a link, but when I enter a longer string, I'm getting the error. The field in the database is a memo field set to allow rich text, and I've got the data type in the update query set to "cf_sql_longvarchar". Should I be using a different data type for this? I know for the purpose of what I'm doing I should probably be using an include instead of a database field, but I'm hoping this will work for the time being until I get more familiar with CF.

Thanks in advance for any help you could offer!

Jeremy

Question about
forums_noreply@adobe.com — Tue, 05 Jun 2012 20:36:53 GMT

I'm trying to create a page that displays the results of a query, but will allow you to filter them by date, name, etc. I'm relatively new to this concept, but reading a bit online I found some examples that did what I'm trying to do. I have a few questions and a problem though, if someone is willing to provide a bit of guidance. If it matters, I'm using cf9.

First, can you use a <cfdiv bind to submit multiple url parameters? If so, do I just use a semicolon to separate them like this:

<cfdiv bind="url:mypage.cfm?param1={value1};param2={value2}" />

Second, if you can use this functionality, what's the best way to send dates as url parameters? URLEncodedFormat() and then URLDecode()? All the examples of those tags surround them with # to indicate variables, but since you don't use that notation in a cfdiv bind, do I just put the whole thing inside the {} like this (and then use URLDecode(mydate) on the action page):

<cfdiv bind="url:mypage.cfm?date1={URLEncodedFormat(mydate)} />

Third, I'm having trouble getting the <cfdiv bind to display at all. I have an action page set up (mypage.cfm) that loads fine in a browser, but when I try to add it to another page like this, it doesn't work:

<cfdiv bind="url:mypage.cfm" />

I'm assuming this is because I'm not submitting any parameters on this page to be processed on mypage.cfm, but I don't know if that's true. I'm trying to get the div to display first, then add the dynamic form to filter the results, but maybe it doesn't work that way?

Thanks for any help!

Jeremy

Missing semicolon (;) at end of SQL statement

forums_noreply@adobe.com — Sun, 03 Jun 2012 07:28:54 GMT

I'm getting this error on a form in which I'm trying to upload multiple files as well as populate a database with information about them all in one query. In addition, not every file field will be used every time the form is submitted, so I have some <cfif> tags to prevent errors in the event the fields are empty. I was able to get the form to work with only two file fields (leaving the second one blank to check that there would be no errors with blank fields), but when I expanded it to the full 15 (and all I did is copy and paste the code and update the field numbers), I get this error:

Error Executing Database Query.

Missing semicolon (;) at end of SQL statement.

The error occurred in C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 477

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 14

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 1

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 477

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 14

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 1

475: </cfif>)

476: </cfif>

477: <cfif IsDefined("FORM.File15") AND #FORM.File15# NEQ "">,

478: (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

479: <cfqueryparam value="#FORM.Ensemble# cfsqltype="cf_sql_clob" maxlength="255">

Here is my full SQL for this query. Any help would be greatly appreciated. Also, if there's a more streamlined way to handle this sort of situation, that would be great as well. (Sorry, it's pretty long, but most of it is repetitive):

<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>

<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "upload">

<cfquery datasource="ctband">

INSERT INTO Files (Ensemble, Category, Selection, Part, File_Name, Uploaded_By)

VALUES (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part1") AND #FORM.Part1# NEQ "">

<cfqueryparam value="#FORM.Part1#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File1") AND #FORM.File_Name1# NEQ "">

<cfqueryparam value="#FORM.File_Name1#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File1" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

<cfif IsDefined("FORM.File2") AND #FORM.File2# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part2") AND #FORM.Part2# NEQ "">

<cfqueryparam value="#FORM.Part2#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File2") AND #FORM.File_Name2# NEQ "">

<cfqueryparam value="#FORM.File_Name2#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File2" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File3") AND #FORM.File3# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part3") AND #FORM.Part3# NEQ "">

<cfqueryparam value="#FORM.Part3#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File3") AND #FORM.File_Name3# NEQ "">

<cfqueryparam value="#FORM.File_Name3#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File3" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File4") AND #FORM.File4# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part4") AND #FORM.Part4# NEQ "">

<cfqueryparam value="#FORM.Part4#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File4") AND #FORM.File_Name4# NEQ "">

<cfqueryparam value="#FORM.File_Name4#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File4" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File5") AND #FORM.File5# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part5") AND #FORM.Part5# NEQ "">

<cfqueryparam value="#FORM.Part5#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File5") AND #FORM.File_Name5# NEQ "">

<cfqueryparam value="#FORM.File_Name5#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File5" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File6") AND #FORM.File6# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part6") AND #FORM.Part6# NEQ "">

<cfqueryparam value="#FORM.Part6#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File6") AND #FORM.File_Name6# NEQ "">

<cfqueryparam value="#FORM.File_Name6#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File6" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File7") AND #FORM.File7# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part7") AND #FORM.Part7# NEQ "">

<cfqueryparam value="#FORM.Part7#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File7") AND #FORM.File_Name7# NEQ "">

<cfqueryparam value="#FORM.File_Name7#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File7" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File8") AND #FORM.File8# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part8") AND #FORM.Part8# NEQ "">

<cfqueryparam value="#FORM.Part8#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File8") AND #FORM.File_Name8# NEQ "">

<cfqueryparam value="#FORM.File_Name8#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File8" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File9") AND #FORM.File9# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part9") AND #FORM.Part9# NEQ "">

<cfqueryparam value="#FORM.Part9#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File9") AND #FORM.File_Name9# NEQ "">

<cfqueryparam value="#FORM.File_Name9#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File9" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File10") AND #FORM.File10# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part10") AND #FORM.Part10# NEQ "">

<cfqueryparam value="#FORM.Part10#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File10") AND #FORM.File_Name10# NEQ "">

<cfqueryparam value="#FORM.File_Name10#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File10" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File11") AND #FORM.File11# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part11") AND #FORM.Part11# NEQ "">

<cfqueryparam value="#FORM.Part11#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File11") AND #FORM.File_Name11# NEQ "">

<cfqueryparam value="#FORM.File_Name11#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File11" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File12") AND #FORM.File12# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part12") AND #FORM.Part12# NEQ "">

<cfqueryparam value="#FORM.Part12#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File12") AND #FORM.File_Name12# NEQ "">

<cfqueryparam value="#FORM.File_Name12#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File12" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File13") AND #FORM.File13# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part13") AND #FORM.Part13# NEQ "">

<cfqueryparam value="#FORM.Part13#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File13") AND #FORM.File_Name13# NEQ "">

<cfqueryparam value="#FORM.File_Name13#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File13" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File14") AND #FORM.File14# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part14") AND #FORM.Part14# NEQ "">

<cfqueryparam value="#FORM.Part14#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File14") AND #FORM.File_Name14# NEQ "">

<cfqueryparam value="#FORM.File_Name14#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File14" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

<cfif IsDefined("FORM.File15") AND #FORM.File15# NEQ "">,

(<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

<cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.Part15") AND #FORM.Part15# NEQ "">

<cfqueryparam value="#FORM.Part15#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>

, <cfif IsDefined("FORM.File15") AND #FORM.File_Name15# NEQ "">

<cfqueryparam value="#FORM.File_Name15#" cfsqltype="cf_sql_clob" maxlength="255">

<cffile action="upload" filefield="File15" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

<cfelse>

''

</cfif>

, <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

<cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

<cfelse>

''

</cfif>)

</cfif>

</cfquery>

<cflocation url="/admin/upload_confirm.cfm">

</cfif>

How to make a conditional required form item

forums_noreply@adobe.com — Fri, 01 Jun 2012 18:25:03 GMT

I'm working with an old version of Dreamweaver (CS3) and I'm trying to create a user information registration form. I've got a field for a phone number and then a select box for phone type. I'd like to include an option for a second number and type, but I don't want to make it required. However, if the user enters a number there, I want the type selection box to be a required item. I'm just using the provided spry validation widgets, but I can't find that option anywhere. Is it possible to make that selection box required based upon whether or not the user has entered a value in another field?

Appreciate any help!

Jeremy

Problem with update record form

forums_noreply@adobe.com — Mon, 12 Dec 2011 05:38:19 GMT

I have an update record form that uses a <cfquery> function and has (among other fields) an optional file input field and two separate fields to specify the file name and file type. I don't get any errors when I submit the form, but it does not update the record and does not redirect to the page specified in the <cflocation> function. Instead, it simply reloads the update record page with all values removed. The cfquery function is copied below. Any ideas what I'm missing? I'm relatively new to cf and sql, but in comparing it to other update record forms I have for other tables, I can't find a problem.

<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ "content_edit">

<cfquery datasource="everettweb">UPDATE Content

SET Page_URL=<cfif IsDefined("FORM.Page_URL") AND #FORM.Page_URL# NEQ "">

#FORM.Page_URL#

<cfelse>

''

</cfif>

, Page_Category=<cfif IsDefined("FORM.Page_Category") AND #FORM.Page_Category# NEQ "">

#FORM.Page_Category#

<cfelse>

''

</cfif>

, Content_Description=<cfif IsDefined("FORM.Content_Description") AND #FORM.Content_Description# NEQ "">

#FORM.Content_Description#

<cfelse>

''

</cfif>

, Content_Heading=<cfif IsDefined("FORM.Content_Heading") AND #FORM.Content_Heading# NEQ "">

#FORM.Content_Heading#

<cfelse>

''

</cfif>

, Content=<cfif IsDefined("FORM.Content") AND #FORM.Content# NEQ "">

#FORM.Content#

<cfelse>

''

</cfif>

, Image_URL=<cfif IsDefined("FORM.Filename") AND #FORM.Filename# NEQ "">

/images/#FORM.Filename#.#FORM.File_type#

<cfelse>

''

</cfif>

WHERE ID=#FORM.ID#

</cfquery>

<cflocation url="#FORM.Page_URL#">

</cfif>

Thanks for any help you can provide!

Jeremy

Trying to change root directory in built-in server

forums_noreply@adobe.com — Sat, 26 Nov 2011 00:43:54 GMT

I am running the built-in server in ColdFusion 9 to test a web site I am building. My site is located in a subfolder of the wwwroot folder in the ColdFusion9 directory (C:\ColdFusion9\wwwroot\Everett\*). I am trying to use root-relative links, but I would like them to refer to this directory, not the wwwroot directory. For example, I would like the link "/index.cfm" to open the C:\ColdFusion9\wwwroot\Everett\index.cfm, as opposed to C:\ColdFusion9\wwwroot\index.cfm. It is my understanding that this can be done through virtual mapping.

I have added this code to the jrun-web.xml file in the WEB-INF directory:

<virtual-mapping>

<resource-path>/*</resource-path>

<system-path>C:/ColdFusion9/wwwroot/Everett/</system-path>

</virtual-mapping>

I then moved the CFIDE and cfdocs folders to the Everett subfolder.

Next, I restarted the ColdFusion server.

Now I'm getting the following error message:

404

java.io.FileNotFoundException

at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:94)

at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)

at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)

at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)

at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)

at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)

at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)

at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)

at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

When I go to http://localhost:8500/ I can see all the appropriate files and directories, so I can see that the root directory has been changed, I just cannot view any of the documents.

Any thoughts?

Jeremy

Problem with tag

forums_noreply@adobe.com — Wed, 16 Nov 2011 06:53:21 GMT

Basically, I'm trying to add some text to my header depending on whether or not the user is logged in. If they are, it will display one thing (Welcome, My Account, Logout), if they are not, it will display something else (Login/Register). I'm using Dreamweaver which I know can do some silly things with code, but being a CF and web design novice, the only way I could think of to do this is with a <cfif> tag. Here is what I've come up with, but I keep getting errors and I cannot figure out why. The first chunk of code is for the logout query, the second is a recordset to grab the first name of the current user, if they are logged in. Those appear to be working okay, the issues seem to be coming from the <cfif> tag in the <body>. The error I'm getting says I need a closing </cfif> tag, but it looks to me like it should be okay. Any thoughts on what I screwed up?

Thanks for any help you can give!

Jeremy

</cflock>

</cfif>

</cfif>

</cfif>

SELECT Users.[First Name]

FROM Users

WHERE Users.Email = Session.MM_Username

</cfquery>

</cfif>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

a.headerlink:link {color: #FFFFFF;}

a.headerlink:hover {color: #D7A05D;}

a.headerlink:visited {color: #FFFFFF;}

a.headerlink:active {color: #FFFFFF;}

-->

</style>

</head>

<body>

<p class="loginstatus"><cfoutput query="userinfo">Welcome, #[First Name]#!</cfoutput> <a href="../register_edit.cfm" class="headerlink">My Account</a> / <a href="<cfoutput>#CurrentPage#?MM_logout=1</cfoutput>">Logout</a><img src="../images/clear.gif" width="40" height="20" border="0" /></p>

<p class="loginstatus"><a href="../login.cfm" class="headerlink">Login</a> / <a href="../register.cfm" class="headerlink">Register</a><img src="../images/clear.gif" width="40" height="20" border="0" /></p>

</cfif>

</body>

</html>

Problem inserting record using INSERT INTO

forums_noreply@adobe.com — Fri, 04 Nov 2011 05:07:01 GMT

I am an amateur web builder using some ColdFusion functionality to access information on an Access database. I know very little about ColdFusion syntax, but I'm using Dreamweaver CS3 to help generate most of the code. I'm working on an insert record page to create a user database with login information. I'm not sure what the problem is, but I'm getting a syntax error referencing this particular portion of the code:

Syntax error in INSERT INTO statement.

The error occurred in C:\ColdFusion9\wwwroot\Everett\register.cfm: line 22

Below is the entire page with line 22 (referenced in the error message) in red. Any ideas?

<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "register">
<cfquery datasource="everettweb">
    INSERT INTO Users ([First Name], [Last Name], [Email Address], Password)
VALUES (<cfif IsDefined("FORM.first_name") AND #FORM.first_name# NEQ "">
<cfqueryparam value="#FORM.first_name#" cfsqltype="cf_sql_clob" maxlength="255">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.last_name") AND #FORM.last_name# NEQ "">
<cfqueryparam value="#FORM.last_name#" cfsqltype="cf_sql_clob" maxlength="255">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.email") AND #FORM.email# NEQ "">
<cfqueryparam value="#FORM.email#" cfsqltype="cf_sql_clob" maxlength="255">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.password") AND #FORM.password# NEQ "">
<cfqueryparam value="#FORM.password#" cfsqltype="cf_sql_clob" maxlength="255">
<cfelse>
''
</cfif>
)
</cfquery>
<cflocation url="register_success.cfm">
</cfif>
<!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>
<link href="main.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Everett Music Department, Everett, MA</title>

<style type="text/css">

</style>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<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>

<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<script src="SpryAssets/SpryValidationConfirm.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationConfirm.css" rel="stylesheet" type="text/css" />

<table width="960" align="center" border="0" cellpadding="0" cellspacing="0">
<tr>
    <td colspan="3"><img src="top_border.jpg" width="960" height="20" align="top" /></td>
</tr>
<tr align="center">
    <td colspan="3"><a href="index.php"><img src="e_oval_top.jpg" height="100" width="270" border="0" /></a><a href="index.php"><img src="header.jpg" height="100" width="690" border="0" /></a></td>
</tr>
<tr>
    <td height="35" width="301"><a href="index.php"><img src="e_oval_bottom.jpg" height="35" width="234" border="0" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('home','','menu_home_over.jpg',1)"><img src="menu_home.jpg" width="67" height="35" name="home" border="0" id="home" /></a></td>
    <td width="251"><ul id="MenuBar1" class="MenuBarHorizontal">
      <li><a class="MenuBarItemSubmenu" href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('about','','menu_about_over.jpg',1)"><img src="menu_about.jpg" width="71" height="35" name="about" border="0" id="about" /></a>
        <ul>
          <li><a href="#">News</a></li>
          <li><a href="#">History</a></li>
          <li><a href="#">Media</a></li>
        </ul>
      </li>
      <li><a class="MenuBarHorizontal" href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('ensembles','','menu_ensembles_over.jpg',1)"><img src="menu_ensembles.jpg" width="98" height="35" name="ensembles" border="0" id="ensembles" /></a>
        <ul>
          <li><a href="#">Band</a></li>
          <li><a href="#">Chorus</a></li>
          <li><a href="#">Strings</a></li>
        </ul>
      </li>
      <li><a class="MenuBarItemSubmenu" href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('schools','','menu_schools_over.jpg',1)"><img src="menu_schools.jpg" width="82" height="35" name="schools" border="0" id="schools" /></a>
        <ul>
          <li><a href="#">Everett High School</a></li>
          <li><a href="#">English School</a></li>
          <li><a href="#">Keverian School</a></li>
          <li><a href="#">Lafayette School</a></li>
          <li><a href="#">Parlin School</a></li>
          <li><a href="#">Webster School</a></li>
          <li><a href="#">Whittier School</a></li>
        </ul>
      </li>
    </ul>
    </td>
           <td width="408"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('events','','menu_events_over.jpg',1)"><img src="menu_events.jpg" width="74" height="35" name="events" border="0" id="events" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('faculty','','menu_faculty_over.jpg',1)"><img src="menu_faculty.jpg" width="79" height="35" name="faculty" border="0" id="faculty" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('links','','menu_links_over.jpg',1)"><img src="menu_links.jpg" width="66" height="35" name="links" border="0" id="links" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('login','','menu_login_over.jpg',1)"><img src="menu_login.jpg" name="login" width="69" height="35" border="0" id="login" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('contact','','menu_contact_over.jpg',1)"><img src="menu_contact.jpg" width="100" height="35" name="contact" border="0" id="contact" /></a><img src="menu_spacer_end.jpg" width="20" height="35" /></td>
</tr>
<tr height="10">
    <td colspan="3"><img src="menu_bottom_spacer.jpg" height="10" width="960" /></td>
</tr>
</table>
<table width="960" cellpadding="0" cellspacing="0" align="center">
<tr height="50">
    <td width="30" background="left_border.jpg"><img src="clear.gif" width="30" height="50" /></td>
    <td width="900" bgcolor="#FFFFFF">
      <table width="900" cellpadding="0" cellspacing="0">
        <tr>
          <td width="900" height="350" valign="top">
      <form action="<cfoutput>#CurrentPage#</cfoutput>" method="POST" name="register" preloader="no" id="register">
            <table width="100%">
              <tr>
                <td colspan="2" class="heading1">Fill in the information below to register for this site:</td>
              </tr>
              <tr>
                <td colspan="2"><img src="clear.gif" height="15" /></td>
              </tr>
              <tr>
                <td width="50%" class="form" align="right">First Name:</td>
                <td width="50%"><span id="sprytextfield1">
                  <input type="text" name="first_name" required="yes" id="first_name" width="150" typeahead="no" showautosuggestloadingicon="true" />
                  <span class="textfieldRequiredMsg">A value is required.</span></span></td>
              </tr>
              <tr>
                <td class="form" align="right">Last Name:</td>
                <td><span id="sprytextfield2">
                  <input type="text" name="last_name" required="yes" id="last_name" width="150" typeahead="no" showautosuggestloadingicon="true" />
                  <span class="textfieldRequiredMsg">A value is required.</span></span></td>
              </tr>
              <tr>
                <td class="form" align="right">Email Address:</td>
                <td><span id="sprytextfield3">
                <input type="text" name="email" validate="email" required="yes" id="email" width="150" typeahead="no" showautosuggestloadingicon="true" />
                <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td>
              </tr>
              <tr>
                <td class="form" align="right">Confirm Email Address:</td>
                <td><span id="sprytextfield4"><span id="ConfirmWidget">
                <input type="text" name="email_confirm" validate="email" required="yes" id="email_confirm" width="150" typeahead="no" showautosuggestloadingicon="true" />
                <span class="confirmInvalidMsg">The values do not match</span></span></span></td>
              </tr>
              <tr>
                <td class="form" align="right">Password:</td>
                <td><span id="sprytextfield5">
                  <input type="password" name="password" required="yes" id="password" width="150" />
                  <span class="textfieldRequiredMsg">A value is required.</span></span></td>
              </tr>
              <tr>
                <td class="form" align="right">Confirm Password:</td>
                <td><span id="sprytextfield6"><span id="ConfirmWidget">
                  <input type="password" name="password_confirm" required="yes" id="password_confirm" width="150" />
                  <span class="confirmInvalidMsg">The values do not match</span></span></span></td>
              </tr>
              <tr>
                <td> </td>
                <td><input name="submit" type="submit" id="submit" value="Register" /></td>
              </tr>
            </table>

      <input type="hidden" name="MM_InsertRecord" value="register" />
      </form>
      <script type="text/javascript">

</script>
<script type="text/javascript">
var ConfirmWidgetObject = new Spry.Widget.ValidationConfirm("sprytextfield4", "email");
var ConfirmWidgetObject = new Spry.Widget.ValidationConfirm("sprytextfield6", "password");
</script>
          </td>
        </tr>
      </table>
    </td>
    <td width="30" background="right_border.jpg"><img src="clear.gif" width="30" height="50" /></td>
</tr>
<tr>
    <td colspan="3" background="footer.jpg" class="footer" height="80"/>This website best viewed using:<br /><a href="http://www.firefox.com"><img src="firefox_logo.gif" width="110" height="40" border="0" /></a></td>
</tr>
</table>