ok i have a query
SELECT TOP 100 PERCENT LEFT(dbo.NavTitle.titleName, PATINDEX('%[_]%',
dbo.NavTitle.titleName) - 1) AS title, dbo.NavAccessory.specs_partnum
FROM dbo.NavAccessory INNER JOIN
dbo.NavTitle ON dbo.NavAccessory.titleID =
dbo.NavTitle.titleID
WHERE (dbo.NavAccessory.aId IN (1, 4))
ORDER BY dbo.NavAccessory.titleID
the results are:
title specs_partnum
Base/Plinth Front and Rear 8601600, 8602600
TS8 3286300
i would like the reasults to display:
title specs_partnum
Base/Plinth Front and Rear 8601600
Base/Plinth Front and Rear 8602600
TS8 3286300
this is in a view in SQL2k
not in cf
thanks guys...
-m
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305327
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
