running this command in mysql control centre in winxp gives me back the value - '28':

select count(trip_details.trip_id) from trip_details INNER JOIN trip_master on (trip_details.trip_id = trip_master.trip_id) where trip_master.regular_trip <> 'Cancelled'

but in asp,

<%
total_segments = "select count(trip_details.trip_id) from trip_details INNER JOIN trip_master on (trip_details.trip_id = trip_master.trip_id) where trip_master.regular_trip <> 'Cancelled'"
response.write "Total Segments = " & total_segments & "<br>"
%>

gives me:

Total Segments = select count(trip_details.trip_id) from trip_details INNER JOIN trip_master on (trip_details.trip_id = trip_master.trip_id) where trip_master.regular_trip <> 'Cancelled'

any ideas?

Picco

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

You need to create a recordset using your query & then get the value from the field "count(trip_details.trip_id)"
It might be easier to change the query to select count(trip_details.trip_id) AS total ...etc and then you can use myRecordsetName("total").Value to get the value.

HTH,

Chris

dont understand chris mate,

as it stands:

total_segments = ("select count(trip_details.trip_id) from trip_details INNER JOIN trip_master on (trip_details.trip_id = trip_master.trip_id) where trip_master.regular_trip <> 'Cancelled'")