filtering dropdown with a Where Statement 1

[tamnet]

Is it possible to filter a dropdown by using a where statement I have the following code for my dropdown

	    <option value="<%=(RSdetails.Fields.Item("RepID").Value)%>"><%=(RSdetails.Fields.Item("Name").Value)%></option>

Couls someone explain the correct syntax to add in the code in red

	    <option value="<%=(RSdetails.Fields.Item("RepID").Value)%>"><%=(RSdetails.Fields.Item("Name").Value)%>[COLOR=red]Where <%=(RSdetails.Fields.Item("Type").Value)= E%>[/color]</option>

 

[DotNetGnat]

Why dont you do this at the query level....

SQL = Select blah from mytable Where Type='E'

-DNG

 

[DotNetGnat]

or at the dropdown level...you might be having something like this...

while not rs.eof
if RSdetails.Fields.Item("Type").Value="E" then
<option value="<%=(RSdetails.Fields.Item("RepID").Value)%>"><%=(RSdetails.Fields.Item("Name").Value)%>%=(RSdetails.Fields.Item("Type").Value)%></option>
end if
rs.movenext
wend

-DNG

 

[tamnet]

DNG,

Thanks for the reply

Sorry I probably did not explain myself fully this is my select

SELECT CustomerName, CustomerNameID, Address, tblCustomerDeliveryAddress.DeliveryAddress, RepID, Name, Type
FROM tblCustomerDetails, tblCustomerDeliveryAddress, tblReps
WHERE CustomerDetailsID = CustomerNameID AND tblCustomerDeliveryAddress.DeliveryAddress = 'AddID'

and RepID, Name and Type all come from tblReps, in the table there are 2 types of rep Internal & External.

Therefore in my select dropdown my value is RepID and my Label is Name but I would like to be able to only show External reps so I want to filter on type "E"

therefore that was the reason for my original question

I will then create another dropdown where the type will be "I" to filter by Internal Reps.

Any thoughts would be appreciated

Regards

Paul

 

[DotNetGnat]

did you try this:

for dropdown 1:

while not rs.eof
if RSdetails.Fields.Item("Type").Value="E" then
<option value="<%=(RSdetails.Fields.Item("RepID").Value)%>"><%=(RSdetails.Fields.Item("Name").Value)%></option>
end if
RSdetails.movenext
wend

for dropdown 2:

while not rs.eof
if RSdetails.Fields.Item("Type").Value="I" then
<option value="<%=(RSdetails.Fields.Item("RepID").Value)%>"><%=(RSdetails.Fields.Item("Name").Value)%></option>
end if
RSdetails.movenext
wend

what we are doing is we are looping through our entire recordset and populating the dropdown only when our condition is satisfied...

try it and let us know if you get any error...

-DNG

 

[tamnet]

DNG,
Worked a treat, Thanks so much, A star for you



Regards

Paul

 

[DotNetGnat]

no problem...glad to be of help...

-DNG