To add CF_SQL_CLOB to the dropdown in Homesite and Dreamweaver, do the following..
-------------------------------------- I've noticed that CF_SQL_CLOB isnt in the dropdown for sql types in Homesite and Dreamweaver. It's no bother typing in CF_SQL_CLOB for for those who like to have it in the dropdown, for those who use CLOB datatypes in theie tables this will help.. You'll have to edit a couple files.. 1 for Dreamweaver, 1 for Homesite. If editing for Homesite.. In Windows Explorer browse to the following folder.. C:\Program Files\Macromedia\HomeSite+\Extensions\TagDefs\CFML\ In there you'll see a bunch of vtm files. The one you're looking for is cfqueryparam.vtm Right click and open it up in Notepad and you'll see some text. Starting on line 12, you'll see these <ITEM VALUE=""'s You'll notice that they're in alpahbetical order starting with CF_SQL_BIGINT (it you ignore the empty one). Copy the CF_SQL_CHAR line and insert it directly below the CF_SQL_CHAR line, you should have 2 of the same lines. Edit the second line to read <ITEM VALUE="CF_SQL_CLOB" CAPTION="CF_SQL_CLOB"/> Also further down the page you'll see an <ATTRIBUTES> section.. you'll want to edit this section as well. Below the CF_SQL_CHAR line add this line <ATTRIBOPTION VALUE="CF_SQL_CLOB"/>. Save the file and reload Homesite. You could also add a line for CF_SQL_BLOB as thats not present in the file either. For Dreamweaver Browse to the following folder.. C:\Program Files\Macromedia\Dreamweaver MX 2004\Configuration\TagLibraries\CFML You're looking for the same file here.. cfqueryparam.vtm Open it up with Notepad (or your favorite text editor) and look the the attributes section.. Below the <attriboption value="CF_SQL_CHAR"/> line add <attriboption value="CF_SQL_CLOB"/> Save the file and reload Dreamweaver. You'll see it in the dropdown list of options when you type in <cfqueryparam cfsqltype=". Like above, you could add the CF_SQL_BLOB as well. -- Auxilium meum a Domino ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54