count()
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
|
