Ok. Here goes. There's gonna be a lot of text here, and I can understand if nobody wants to look through but I can't figure out what's wrong so I thought I'd just post everything. What I'm trying to achive is to have th CF 2nd CF page to check the data entered in the form to see if the essential info is there, if not it will return to the form and explain what is wrong. here is the form part from the first page which will post to another CF page.
-------------------------------------------------------
<FORM METHOD="Post" ACTION="NewMemberDetails.cfm" ENCTYPE="Multipart/Form-Data">
<TABLE BORDER=0>
<TR><td>Contact Name:</td><td><INPUT TYPE="Text" Name="ContactName"></td></TR>
<TR><td>Your Business' Name:</td><td><INPUT TYPE="Text" Name="OrgName">*</td></TR>
<TR><td>Organisation:</td><td><SELECT Name="Organisation">
<OPTION VALUE="PADI">PADI</OPTION>
<OPTION VALUE="BSAC">BSAC</OPTION>
<OPTION VALUE="Other">Other. Please Give Details</Option>
</SELECT>*</td></TR>
<TR><td VALIGN=Top>Brief Summary:</td><td><TEXTAREA ROWS=3 NAME="Description"></TEXTAREA></td></TR>
<TR><td>City:</td><td><INPUT TYPE="Text" NAME="City">*</td></TR>
<TR><td>Address 1:</td><td><INPUT TYPE="Text" Name="Address1"></td></TR>
<TR><td>Address 2:</td><td><INPUT TYPE="Text" Name="Address2"></td></TR>
<TR><td>Post/Zip code:</td><td><INPUT TYPE="Text" Name="PostCode"></td></TR>
<TR><td>Country:</td><td><InPUT TYPE="Text" Name="Country">*</td></TR>
<TR><td>Tel:</td><td><INPUT TYPE="Text" Name="Tel"></td></TR>
<TR><td>Fax:</td><td><INPUT TPYE="Text" Name="Fax"></td></TR>
<TR><td>E-Mail:</td><td><INPUT TYPE="Text" Name="Email">*</td></TR>
<TR><td>WebSite:</td><td><INPUT TYPE="Text" Name="Website"></td></TR>
<TR><td>Facilites:</td><td><INPUT TYPE="Text" Name="Facilities"></td></TR>
<TR><td>Password: </td><td><INPUT TYPE="Password" Name="Password">*</td></TR>
<TR><td>Confirm Password </td><td><INPUT TYPE="Password" Name="Password2">*</td></TR>
<TR><td VALIGN=top>Dive Logo:</td><td><INPUT TYPE="File" NAME="Logo"><br>
<I>Please keep it smaller than 10k.</I></td></TR>
<TR><TD COLSPAN=2 ALIGN=Center>
<br><INPUT Type="Submit" VALUE="Send It!">
<INPUT TYPE="Reset" VALUE="Reset Details">
</td></TR>
</TABLE><p>
</FORM>
-------------------------------------
This is the full code the CF page:
<HTML>
<!---Validation Code--->
<CFIF Password NEQ Password2 OR
LEN(TRIM(Form.Password)LTE 0)>
<CFSET Error1="Please Check Password.<br>">
</CFIF>
<CFIF LEN(FindNoCase("@",Form.Email)LTE 0) OR
LEN(FindNoCase(".",Form.Email)LTE 0) OR
LEN(Trim(Form.Email)LT 8)>
<CFSET Error2="Invalid E-Mail address.<br>">
</CFIF>
<CFIF LEN(Trim(Form.Country)LTE 0)>
<CFSET Error3="You did not specify Country.<br>">
</CFIF>
<CFIF LEN(Trim(Form.City)LTE 0)>
<CFSET Error4="You did not specify City.<br>">
</CFIF>
<CFIF LEN(Trim(Form.OrgName)LTE 0)>
<CFSET Error5="You did not specify your company name.<br>">
</CFIF>
<CFSET TotalError="#Error1# #Error2# #Error3# #Error4# #Error5#">
<!---End Validation. Continue in Head of page.--->
<CFIF Logo is not "">
<CFFILE ACTION="Upload" FILEFIELD="Form.Logo"
Destination="C:\CFusionMX\
NAMECONFLICT="Overwrite" ACCEPT= "image/gif, image/jpg, image/pjpeg, image/jpeg">
<CFSET NewLogo = File.Clientfile>
<CFQUERY DATASOURCE="DiveSchools" Name="NewImage">
INSERT INTO DiveData(Logo, ContactName, OrgName, Organisation, Description, City, Address1,
Address2, PostCode, Country, Tel, Fax, Email, Website, Facilities)
VALUES ('#NewLogo#','#ContactName#','#OrgName#','#Organisation#','#Description#','#City#',
'#Address1#','#Address2#','#PostCode#','#Country#','#Tel#','#Fax#','#Email#',
'#Website#','#Facilities#')
</CFQUERY>
<CFQUERY DATASOURCE="DiveSchools" Name="LogoQuery">
Select *
From DiveData
Where Logo='#NewLogo#' AND OrgName='#OrgName#'
</CFQUERY>
<CFELSE>
<CFQUERY DATASOURCE="DiveSchools" Name="NewImage">
INSERT INTO DiveData(Logo, ContactName, OrgName, Organisation, Description, City, Address1,
Address2, PostCode, Country, Tel, Fax, Email, Website, Facilities)
VALUES ('NoLogo.jpg', '#ContactName#','#OrgName#','#Organisation#','#Description#','#City#',
'#Address1#','#Address2#','#PostCode#','#Country#','#Tel#','#Fax#','#Email#',
'#Website#','#Facilities#')
</CFQUERY>
<CFSET NewLogo = "NoLogo.jpg">
<CFQUERY DATASOURCE="DiveSchools" Name="LogoQuery">
Select *
From DiveData
Where OrgName='#OrgName#' AND Email='#Email#'
</CFQUERY>
</CFIF>
<HEAD>
<TITLE>AAAARGH</TITLE>
<CFIF LEN(#TotalError#)GT 5>
<META HTTP-EQUIV="Refresh" Content= URL="NewMember.cfm?TotalError=<CFOUTPUT>'#TotalError#'</CFOUTPUT>>
</CFIF>
</HEAD>
<BODY>
<CFOUTPUT QUERY="LogoQuery">
<CENTER><H2>Welcome #ContactName#<br></H2>
and thankyou for helping help in building what will hopefully become the worlds<br>
most detailed Dive Database.<p>
Your ID Number is DC#ID_CODE#. Please quote this number if you need to
contact me.<p><HR></CENTER>
<B>Your Current Details are as follows:</B><br>
<TABLE BORDER=0 Width=75%>
<TR><td WIDTH=80>Contact Name:</td><td VALIGN=Top>#ContactName#</td>
<td ROWSPAN=14 ALIGN=Center VALIGN=Top>
<IMG SRC="C:\CFusionMX\
Border=0><br>
Please ensure your logo is small and doesn't exceed 10 kilobytes.<br>
Thank you again for your time. Dive Happy.

</td></TR>
<TR><td VALIGN=Top>Business Name:</td><td VALIGN=Top>#OrgName#</td></TR>
<TR><td VALIGN=Top>Organisation:</td><td VALIGN=Top>#Organisation#</td></TR>
<TR><td VALIGN=Top>Summary of Business:</td><td VALIGN=Top>#Description#</td></TR>
<TR><td VALIGN=Top>City:</td><td VALIGN=Top>#City#</td></TR>
<TR><td VALIGN=Top>Address 1:</td><td VALIGN=Top>#Address1#</td></TR>
<TR><td VALIGN=Top>Address 2:</td><td VALIGN=Top>#Address2#</td></TR>
<TR><td VALIGN=Top>Post/Zip Code:</td VALIGN=Top><td>#Postcode#</td></TR>
<TR><td VALIGN=Top>Country:</td><td VALIGN=Top>#Country#</td></TR>
<TR><td VALIGN=Top>Tel:</td><td VALIGN=Top>#Tel#</td></TR>
<TR><td VALIGN=Top>Fax:</td><td VALIGN=Top>#Fax#</td></TR>
<TR><td VALIGN=Top>E-Mail:</td><td VALIGN=Top>#Email#</td></TR>
<TR><td VALIGN=Top>Website:</td><td VALIGN=Top>#Website#</td></TR>
<TR><td VALIGN=Top>Facilities:</td><td VALIGN=Top>#Facilities#</td></TR>
</TABLE><HR>
</CFOUTPUT>
<br><A HREF="NavigationPage.htm">Return to Navigation Page</A>
</BODY>