I would like to have the following code show only if Session("PostalCode") is not null. I suppose I should put it into an If statement?
I tried it as follows but it does nothing:
If Session("PostalCode")<>"" Then
WADbSearch1_whereClause=BuildFilterString("LATITUDE","" & cStr( Session("HighLatitude") ) & "","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LATITUDE","" & cStr( Session("LowLatitude") ) & "","AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LONGITUDE","" & cStr( Session("LowLongitude") ) & "","AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LONGITUDE","" & cStr( Session("HighLongitude") ) & "","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
End If
I tried it as follows but it does nothing:
If Session("PostalCode")<>"" Then
WADbSearch1_whereClause=BuildFilterString("LATITUDE","" & cStr( Session("HighLatitude") ) & "","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LATITUDE","" & cStr( Session("LowLatitude") ) & "","AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LONGITUDE","" & cStr( Session("LowLongitude") ) & "","AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LONGITUDE","" & cStr( Session("HighLongitude") ) & "","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
End If