%@ Language=VBScript %>
<%
Dim rsNameCheck, adoCmd, rsCountry, rsNewID
Dim sFullName, sEmail, sAdd1, sAdd2, sCity, iCountry, sPostcode, sPhone, sResidence
Dim sNationality, sPassportNo, sAge, sWebsite, sAKA1, sAKA2, iService, sWhy, sNotes
Dim sFile, sFrom, sTo, iNewID, sGov, sIntel, sMilitary, sSecretSoc
Dim sAdditional, sDateFrom, sDateTo
Dim sErrorMsg, sUpdateString, sGetIDString
Dim sFileExt, blnPicture
Dim byteCount
Dim RequestBin
Dim UploadRequest
Dim contentType,filepathname,filename,value
Dim strDestFileName
Dim sDebugger
sErrorMsg = ""
Set adoCmd = Server.CreateObject("ADODB.Command")
With adoCmd
.ActiveConnection = sRegConnectionString
.CommandType = 1
.CommandText = "SELECT * FROM tblCountry ORDER BY Country"
.NamedParameters = False
Set rsCountry = .Execute
End With
If Request.QueryString("Action") = "Update" Then
'Check validity of user
byteCount = Request.TotalBytes
RequestBin = Request.BinaryRead(byteCount)
Set UploadRequest = CreateObject("Scripting.Dictionary")
BuildUploadRequest RequestBin
filepathname = UploadRequest.Item("uplPic").Item("FileName")
If Trim(filepathname) = "" Then
blnPicture = False
sFileExt = "none"
contentType = "none"
Else
blnPicture = True
contentType = UploadRequest.Item("uplPic").Item("ContentType")
filename = Right(filepathname,Len(filepathname)-InstrRev(filepathname,"\"))
'value = UploadRequest.Item("uplPic").Item("Value")
If contentType = "image/pjpeg" Then
sFileExt = "jpg"
Else
sFileExt = "gif"
End IF
End If
'--------------GET VARIABLE VALUES------------------------
sFullName = UploadRequest.Item("txtFullName").Item("Value")
sEmail = UploadRequest.Item("txtEmail").Item("Value")
sAdd1 = UploadRequest.Item("txtAdd1").Item("Value")
sAdd2 = UploadRequest.Item("txtAdd2").Item("Value")
sCity = UploadRequest.Item("txtCity").Item("Value")
iCountry = UploadRequest.Item("slCountry").Item("Value")
sPostcode = UploadRequest.Item("txtZip").Item("Value")
sPhone = UploadRequest.Item("txtPhone").Item("Value")
sResidence = UploadRequest.Item("txtResidence").Item("Value")
sNationality = UploadRequest.Item("txtNat").Item("Value")
sPassportNo = UploadRequest.Item("txtPas").Item("Value")
sAge = UploadRequest.Item("txtFullName").Item("Value")
sWebsite = UploadRequest.Item("txtFullName").Item("Value")
sAKA1 = UploadRequest.Item("txtAka1").Item("Value")
sAKA2 = UploadRequest.Item("txtAka2").Item("Value")
sAge = Cint(UploadRequest.Item("txtAge").Item("Value"))
iService = Cint(UploadRequest.Item("slServices").Item("Value"))
sWhy = Replace(UploadRequest.Item("txtWhy").Item("Value"),vbCrLf,"
")
sNotes = Trim(UploadRequest.Item("txtNotes").Item("Value"))
sWebsite = UploadRequest.Item("txtWebsite").Item("Value")
sGov = Trim(UploadRequest.Item("txtGov").Item("Value"))
sIntel = Trim(UploadRequest.Item("txtIntel").Item("Value"))
sMilitary = Trim(UploadRequest.Item("txtMilitary").Item("Value"))
sSecretSoc = Trim(UploadRequest.Item("txtSecretSoc").Item("Value"))
sAdditional = Trim(UploadRequest.Item("txtAdditional").Item("Value"))
sDateFrom = UploadRequest.Item("FromDay").Item("Value") & " " & UploadRequest.Item("FromMonth").Item("Value") & " " & UploadRequest.Item("FromYear").Item("Value")
sDateTo = UploadRequest.Item("ToDay").Item("Value") & " " & UploadRequest.Item("ToMonth").Item("Value") & " " & UploadRequest.Item("ToYear").Item("Value")
With adoCmd
.ActiveConnection = sRegConnectionString
.CommandType = 1
.CommandText = "SELECT Count(*) As SameCount FROM tblRegistration WHERE Email = '" & sEmail &"'"
.NamedParameters = False
Set rsNameCheck = .Execute
End With
If Not rsNameCheck.EOF Then
If Cint(rsNameCheck.Fields("SameCount")) > 0 Then
'Invalid Name or Email
sErrorMsg = "Sorry but that E-mail address has already been taken"
ElseIf blnPicture = True And (contentType <> "image/pjpeg" AND contentType <> "image/gif") Then
sErrorMsg = "The specified file is not a JPG or GIF file (" & contentType & ")"
Else
sErrorMsg = ""
'Update + redirect
sUpdateString = "INSERT INTO tblRegistration(FullName, Address1, Address2, City, Country, Postcode, Phone, Email, Nationality, PassportNo, Aka1, Aka2, Age, Why, Website, Residence, Service, AvailFrom, AvailTo, ImageType, Notes, Regdate, GovernmentWork, IntelligentsWork, MillitaryWork, SecretSoc, Additional) VALUES ("
sUpdateString = sUpdateString & "'" & Replace(sFullName,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sAdd1,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sAdd2,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sCity,"'","''") & "',"
sUpdateString = sUpdateString & iCountry & ","
sUpdateString = sUpdateString & "'" & Replace(sPostcode,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sPhone,"'","''") & "',"
sUpdateString = sUpdateString & "'" & sEmail & "',"
sUpdateString = sUpdateString & "'" & Replace(sNationality,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sPassportNo,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sAKA1,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sAKA2,"'","''") & "',"
sUpdateString = sUpdateString & sAge & ","
sUpdateString = sUpdateString & "'" & Replace(sWhy,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sWebsite,"'","''") & "',"
sUpdateString = sUpdateString & "'" & Replace(sResidence,"'","''") & "',"
sUpdateString = sUpdateString & iService & ","
sUpdateString = sUpdateString & "'" & sDateFrom & "',"
sUpdateString = sUpdateString & "'" & sDateTo & "',"
sUpdateString = sUpdateString & "'" & sFileExt & "',"
If sNotes <> "" Then
sUpdateString = sUpdateString & "'" & Replace(sNotes,"'","''") & "',"
Else
sUpdateString = sUpdateString & "NULL,"
End If
sUpdateString = sUpdateString & "'" & Date() & "',"
If sGov <> "" Then
sUpdateString = sUpdateString & "'" & Replace(sGov,"'","''") & "',"
Else
sUpdateString = sUpdateString & "NULL,"
End If
If sIntel <> "" Then
sUpdateString = sUpdateString & "'" & Replace(sIntel,"'","''") & "',"
Else
sUpdateString = sUpdateString & "NULL,"
End If
If sMilitary <> "" Then
sUpdateString = sUpdateString & "'" & Replace(sMilitary,"'","''") & "',"
Else
sUpdateString = sUpdateString & "NULL,"
End If
If sSecretSoc <> "" Then
sUpdateString = sUpdateString & "'" & Replace(sSecretSoc,"'","''") & "',"
Else
sUpdateString = sUpdateString & "NULL,"
End If
If sAdditional <> "" Then
sUpdateString = sUpdateString & "'" & Replace(sAdditional,"'","''") & "')"
Else
sUpdateString = sUpdateString & "NULL)"
End If
With adoCmd
.ActiveConnection = sRegConnectionString
.CommandType = 1
.CommandText = sUpdateString
.NamedParameters = False
.Execute
End With
'------------ GET THE NEW ID------------------------
sGetIDString = "SELECT [ID] FROM tblRegistration WHERE Email = '" & sEmail & "'"
With adoCmd
.ActiveConnection = sRegConnectionString
.CommandType = 1
.CommandText = sGetIDString
.NamedParameters = False
Set rsNewID = .Execute
End With
If Not rsNewID.EOF Then
iNewID = rsNewID("ID")
End If
If blnPicture = True Then
'------------ WHAT IS THE FILE NAME WE WANT TO USE
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject")
'---- WRITE THE FULLSIZE IMAGE
strDestFileName = CurrentFolder() & "\upload\" & iNewID & "." & sFileExt
Set myFile = ScriptObject.CreateTextFile( strDestFileName )
value = UploadRequest.Item("uplPic").Item("Value")
For i = 1 to LenB(value)
myFile.Write chr(AscB(MidB(value,i,1)))
Next
myFile.Close
End If 'pic True
Response.Redirect("./ThankYou.asp?sFullName=" & sFullName & "&txtEmail=" & sEmail & "&p10kID=" & iNewID & "&sResidence=" & sResidence & "&sDateFrom=" & sDateFrom & "&sDateTo=" & sDateTo )
End If
End If
Set rsNameCheck = Nothing
End If
Set adoCmd = Nothing
%>
![]() |
P10K Registration Form "How wonderful it is that nobody need wait a single moment before starting to improve the world." – Anne Frank |