[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