<%@LANGUAGE="VBSCRIPT"%> <%' on error resume next%> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form1") Then If Request("SVALIDO") <> Request("SVALID") Then Response.Redirect("failed.asp") End If MM_editConnection = MM_connTRAVELERS_STRING MM_editTable = "justfortravelers.tbllisting" MM_editRedirectUrl = "thankyou.html?s=sent" MM_fieldsStr = "sNAME|value|sDESC|value|sURL|value|sCAT|value|sKEYWORD|value|locCITY|value|locSTATE|value|locCOUNTRY|value|sEMAIL|value|sRECURL|value|sDATE|value" MM_columnsStr = "sNAME|',none,''|sDESC|',none,''|sURL|',none,''|sCATID|none,none,NULL|sKEYWORD|',none,''|locCITY|',none,''|locSTATE|',none,''|locCOUNTRY|',none,''|sEMAIL|',none,''|sRECURL|',none,''|sDATE|',none,NULL" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% Dim rsCAT Dim rsCAT_numRows Set rsCAT = Server.CreateObject("ADODB.Recordset") rsCAT.ActiveConnection = MM_connTRAVELERS_STRING rsCAT.Source = "SELECT sID, sNAME FROM tblcat ORDER BY sNAME ASC" rsCAT.CursorType = 0 rsCAT.CursorLocation = 2 rsCAT.LockType = 1 rsCAT.Open() rsCAT_numRows = 0 %> <% sDATE1 = date() sDATESPLIT = split(sDATE1,"/") sDATESPLITM = sDATESPLIT(0) sDATESPLITD = sDATESPLIT(1) sDATESPLITY = sDATESPLIT(2) sDATE = sDATESPLITY & "-" & sDATESPLITM & "-" & sDATESPLITD %> <% Dim intLowerBound Dim intUpperBound Dim intRangeSize Dim sngRandomValue Dim intRandomInteger intLowerBound = 1000000 intUpperBound = 10000000 If intLowerBound > intUpperBound Then Dim iTemp iTemp = intLowerBound intLowerBound = intUpperBound intUpperBound = iTemp End If Randomize() intRangeSize = intUpperBound - intLowerBound + 1 sngRandomValue = intRangeSize * Rnd() sngRandomValue = sngRandomValue + intLowerBound intRandomInteger = Int(sngRandomValue) strT1 =replace((intRandomInteger),"1","1.jpg") strT2 =replace(strT1,"2","2.jpg") strT3 =replace(strT2,"3","3.jpg") strT4 =replace(strT3,"4","4.jpg") strT5 =replace(strT4,"5","5.jpg") strT6 =replace(strT5,"6","6.jpg") strT7 =replace(strT6,"7","7.jpg") strT8 =replace(strT7,"8","8.jpg") strT9 =replace(strT8,"9","9.jpg") strT0 =replace(strT9,"0","0.jpg") strTOTAL = strT0 strS1 = Split(strTOTAL,".jpg") strS2 = strS1(0) strS3 = strS1(1) strS4 = strS1(2) strS5 = strS1(3) strS6 = strS1(4) strS7 = strS1(5) strS8 = strS1(6) if strS3 = "" then strS3 = "null" else strS3 = strS3 end if strIMG = ""&""&""&""&""&""&"" %> Travel | JustForTravelers.com
 


Company name:
Please use the title of your website.
Site Description:
Please use at least 15 words, and do not use exclamations or promotional language.

Site URL :

http://
Site Category:
Keywords:
Please use comma to seperate keywords.
Location:
City
Province/State
Country
Email Address:

Please copy and paste the following HTML code onto your travel related site and include its location in the window "Reciprocal URL" below.

Important: Please select code, then press crtl+c to copy it, or right-click, copy, then crtl+v to paste, or right-click paste.

JustForTravelers.com Travel Directory offers an online travel gateway to the best and most relevant travel websites to help you find the resources you need to plan your next trip.

 

Reciprocal URL:
EXACT location on your site of where we can find one of the above links. Be specific please, or we will no bother with it.
http://
Validation:
<%=strIMG%>  

 

Please forward any inquiries to the site administrator

 

<% rsCAT.Close() Set rsCAT = Nothing %>