[thelist] Create table SQL and MSAccess syntax
Joshua Olson
joshua at alphashop.net
Sat Apr 21 20:39:44 CDT 2001
Jon,
The Access Syntax is a little complicated to explain. Here's a reference:
http://support.microsoft.com/support/kb/articles/Q209/0/37.ASP
HTH
-joshua
> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> Subject: [thelist] Create table SQL and MSAccess syntax
>
>
> Hi everyone,
>
> I am using the following as my create table syntax in
> the cfquery tag:
>
> CREATE TABLE #table_name#(
> id int PRIMARY KEY AUTO_INCREMENT,
> my_title text,
> my_text text
> );
>
> However, I am receiving a syntax error. I found out
> that the 'AUTO_INCREMENT' was giving the error. I took
> it out and it worked fine, but I need the
> AUTO_INCREMENT. How can I get my sql to set the field
> as AUTO_INCREMENT?
>
> Thanks in advance.
> Jon.
More information about the thelist
mailing list