Trying to assign result of query to a variable

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

    know this sounds very basic, but it doesn't work the way I am used to coding web pages. First time I am using expression web. 

I was to assign the result of a query to a variable so I can test the result, and if true, display something, if false, not display anything. 

Query is this : 

<asp:AccessDataSource runat="server" ID="VenueLookup" DataFile="App_Data/PublicHousePromotions.mdb" 
SelectCommand="SELECT * FROM [Venue] WHERE ([venueCode] = ?)"> 
<SelectParameters> 
<asp:querystringparameter Type="Int32" DefaultValue="1" Name="venueCode" QueryStringField="MyRef" /> 
</SelectParameters> 
</asp:AccessDataSource> 

What I am trying to do is this : 

<script> 
<% 
Dim JoinedDate as String 
JoinedDate = [venueDateSignedAgt] 
if JoinedDate <> "" then 
%> 
<span class="style32">Joined:</span><asp:Label Text='<%# Bind("[venueDateSignedAgt]","{0:d}") %>' runat="server" id="lblJoined" Font-Names="Comic Sans MS" /> 
<br/> 
<% end if %> 
</script> 

Any help would be hugely appreciated. 