[thelist] Coldfusion & MS Access SQL Resource Wanted

Michael Efford efford at iinet.net.au
Sat May 11 11:49:01 CDT 2002


----- Original Message -----
From: "jon steele" <jjsteele22 at yahoo.com>
To: <thelist at lists.evolt.org>
Sent: Sunday, May 12, 2002 12:28 AM
Subject: Re: [thelist] Coldfusion & MS Access SQL Resource Wanted


> > I am after a comprehensive resource that covers what SQL is valid in
> > MS Access and how it's syntax works with Coldfusion.
>
> From my experience, any Access web resource would be good. I used to
search for "ColdFusion Access
> SQL" or something like that in google, but the "ColdFusion" keyword is
useless. Any Access SQL
> should work through coldfusion's cfquery. So microsoft's knowledge base
will also help.
>
> Hope this helps you on your searches! (you can always throw a question out
to the list if you get
> stuck :p)

Ok, I am stuck...heres my question...

I want to add a column to a table and set the default value of any new
record to 0....

so i tried...

<cfquery datasource="#application.dsn#" name="AlterTable">
ALTER TABLE ForumThreads
ADD NumberofViews INT
SET DEFAULT 0
</cfquery>

but i get errors saying invalid SQL syntax...

so does Access set defaults in some wierd way?

any1 help?

tia..


Michael Efford
SODA ::  http://internet.design.curtin.edu.au/soda
"Inspiring design students to discuss, critique and exhibit design."










More information about the thelist mailing list