You just need to check if the school url in the database starts with "http://.."; then append "<a href=" <YOUR_DYNAMIC_ URL_OF_ SCHOOL"></a> else display the school as it is while looping through the results of CFQUERY in html table .
In case your url in the database starts with "www" then append http:// as well along with anchor a href tag and that's all you need to do to make urls appear as links. Thanks. -Sandy Vohra ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3041 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
