AFAIK You can't set defaults in access using CREATE TABLE
> -----Original Message-----
> From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 15 October 2002 12:30 p.m.
> 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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
