> How can I get CF to process tsql statements? I've automated the > creation of scripts for generating a SQL Server table for my content > management system using CF. Basically, for a type of content, I can > automatically generate the tsql statement in CF needed to create the > table. My problem is how do I initiate the statement so the table will > be generated? I've tried wrapping <cfquery> around the statement, but > that produces an error. Any help would be appreciated.
Let me see the statement and the error and I can probably help... off-list if you like, it's up to you... Personally, I wouldn't recommend adding new tables for new types of content -- for a host of reasons -- it is your call, however... My recommendation would be to use wddx or some other xml format to store the content in a single table -- if you need to search on the data in a specific column, add a 2nd table with a contentid column, a propertyname column and a propertyvalue column. The reason for this 2nd table is 2-fold -- 1) it's faster than searching on the xml column and 2) it prevents you running into problems with writing search criteria like WHERE xmlcolumn LIKE '%<myxml>%#searchvalue#%</myxml>%' which is liable to return results which don't actually match on the xml node you want. Technically I'm probably a competitor of yours, but I'm still willing to offer advice. :) It's up to you to decide whether you want to trust me or not. :) Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
