RE: sql for creating access memo field?

[Dave Babbitt]

<cfquery datasource="#DataSourceName#">
        CREATE TABLE TESTTABLE (
                BookmarkID COUNTER NOT NULL PRIMARY KEY,
                BookmarkName TEXT(255),
                BookmarkCategory TEXT(255),
                BookmarkURL TEXT(255),
                BookmarkDescription MEMO,
                BookmarkAdded DATETIME DEFAULT GETDATE(),
                BookmarkVisits NUMBER,
                BookmarkRating TEXT(50),
                BookmarkLastVisit DATETIME DEFAULT GETDATE()
                )
</cfquery>

-----Original Message-----
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 7:30 PM
To: CF-Talk
Subject: RE: sql for creating access memo field?


How do I set my DATETIME fields to default to "=Now()" when creating the
following table:

<cfquery datasource="#DataSourceName#">
CREATE TABLE
TESTTABLE
(
BookmarkID COUNTER NOT NULL PRIMARY KEY,
BookmarkName TEXT(255),
BookmarkCategory TEXT(255),
BookmarkURL TEXT(255),
BookmarkDescription MEMO,
BookmarkAdded DATETIME,
BookmarkVisits NUMBER,
BookmarkRating TEXT(50),
BookmarkLastVisit DATETIME
);
</cfquery>

Thanks.

Peter Tilbrook
Project Officer
Strategic Development
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2600

Telephone: (02) 6213 6731
Facsimile: (02) 6213 7287


-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 15 October 2002 4:56 AM
To: CF-Talk
Subject: RE: sql for creating access memo field?


desc is a reserved word [desc] is okay.

Joshua Tipton

-----Original Message-----
From: Les Irvin [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 2:35 PM
To: CF-Talk
Subject: sql for creating access memo field?


Can anyone tell me the sql for creating a memo field in a table (Access
database)?
This obviously does not work:

<CFQUERY NAME="create" DATASOURCE="#ds#">
        CREATE TABLE temp (tapeid number PRIMARY KEY, Title char(255), Desc
memo)
</cfquery>

Thanks,
Les





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm