****HAPPY NEW YEAR****

First time using this function can someone please check my syntax

Thanks

<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>

---
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/

Reply via email to