1 用left函数可以实现截取
<cfquery name="cars" datasource="#v_ds#">
SELECT carId, carModel, carShape, carPassenger, carOilConsumption, carPicture, left(carText,10) as carText, carTime
FROM dbo.tb_cars</cfquery>
SELECT carId, carModel, carShape, carPassenger, carOilConsumption, carPicture, left(carText,10) as carText, carTime
FROM dbo.tb_cars</cfquery>
2 在表格显示时需要做判断
<cfif cars.carText GT 0>
#cars.carText# ...
</cfif>
</cfif>