Strewth, I've "created" and "dropped" tables before using CFML. Ages ago.
Have the code on CD somewhere (hey it is New Years Day ;)).
If it works in your database client it should work in ColdFusion although
your syntax may need adjusting.
Just be VERY careful with your permissions to the database when using
create/drop etc.
In fact read up on CFQUERYPARAM to be sure to be sure.
Happy New Year to all of us! Please be better than 2004!
Peter Tilbrook
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA
WWW 1: http://www.coldgen.com/
WWW 2: http://www.actcfug.com/
Telephone: +61-2-6284-2727
E-mail: [EMAIL PROTECTED]
>>
All of my external emails are scanned for viruses using the latest
available Norton AV signatures. Also I do NOT maintain an Address book or
Contact list to minimise the risk of infecting recipients of my messages for
viruses. I also prefer "plain text" emails for speed and efficiency.
Powered by Lookout:
Lookout is lightning-fast search for your email, files, and desktop works
with Microsoft Outlook.
http://www.lookoutsoft.com/Lookout/
>>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Ellem
Sent: Saturday, 1 January 2005 11:16 AM
To: CFAussie Mailing List
Subject: [cfaussie] CREATE TABLE SYNTAX?
****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/
---
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/
