It should be "Votes int NULL" instead of Votes varchar(4) NULL
-----Original Message-----
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 2:49 PM
To: CF-Talk
Subject: SQL Create Table
I'm trying to run a SQL query to create a table ... locally, I'm
creating in access, but when I'm ready to move to the production server, it
needs to work in Oracle.
At any rate, the following works, but it's not what I need:
CREATE TABLE Test (
TestID Counter NOT NULL CONSTRAINT PrimConstraint PRIMARY
KEY,
TestName varchar(100) NULL,
Background varchar(250) NULL,
DetailLink varchar(25) NULL,
Votes varchar(4) NULL )
What I need is for Votes to be a number, an integer, a num or an int
(all of which I've tried as keywords and none of them work). How do I
create a column name that is a number in access? And how would that differ
in oracle, if at all.
And what a about a boolean (yes/no) column in access/oracle?
Thanks.
H.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
