If I'm not mistaken it would be:
<cfquery datasource="#DataSourceName#">
CREATE TABLE
#Form.UserFirstName#_#Form.UserMiddleName#_#Form.UserLastName#
(
BookmarkID IDENTITY NOT NULL PRIMARY KEY,
BookmarkName VARCHAR(255),
BookmarkCategory VARCHAR(255),
BookmarkURL VARCHAR(255),
BookmarkDescription TEXT,
BookmarkAdded DATETIME,
BookmarkVisits INT,
BookmarkRating VARCHAR(50),
BookmarkLastVisit DATETIME
);
</cfquery>
At 11:56 AM 10/24/2002 +1000, you wrote:
>What would be the SQL Server equivalent of the following code (particularly
>the COUNTER attribute)?:
>
><cfquery datasource="#DataSourceName#">
> CREATE TABLE
>
>#Form.UserFirstName#_#Form.UserMiddleName#_#Form.UserLastName#
> (
> 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>
>
>Cheers!
>
>Peter Tilbrook
>Project Officer
>Strategic Development
>Australian Building Codes Board
>GPO Box 9839
>CANBERRA ACT 2600
>
>Telephone: (02) 6213 6731
>Facsimile: (02) 6213 7287
>
>
>
>**********************************************************************
>The information contained in this e-mail, and any attachments to it, is
>intended for the use of addressee and is confidential. If you are not
>the intended recipient, you must not use, disclose, read, forward, copy or
>retain any of the information. If you have received this e-mail in
>error, please delete it and notify the sender by return e-mail or telephone.
>The Commonwealth does not warrant that any attachments are free from
>viruses or any other defects. You assume all liability for any loss,
>damage, or
>other consequences which may arise from opening or using the attachments.
>
>**********************************************************************
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
