> <CFQUERY NAME="AddTable" DATASOURCE="#APPLICATION.DB#" > USERNAME="#APPLICATION.UN#" PASSWORD="#APPLICATION.PW#"> > CREATE TABLE VIPMembers (MemberID int[primary key] [NOT] NULL [,]) > > CREATE [unique/clustered] INDEX MemberID ON VIPMembers > (columnName(s)) > > UserID (integer identity), char(20), datetime, money, real, > double, smalldatetime, smallmoney, city. > </CFQUERY>
It doesn't look right to me (unless this is "pseudo code").. I would use Enterprise Manager to create a SQL Script to create the table -- easiest way I've found to do it. The only thing you will have to remove from it is the TSQL "GO" statements. You will also find that not all TSQL will work in one CFQUERY block, so you may need to split them up. Darryl To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group. A principal member of the Financial Planning Association. --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
