You've pretty much got it....try using text instead of varchar as the
datatype for the charachter fields.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Will Ryan [mailto:[EMAIL PROTECTED]]
Sent: 13 November 2000 14:36
To: CF-Talk
Subject: Create Table Question
Greeting Guru's
I'm trying to create a table in Access via CF. I need to create an
AutoNumber field for an ID. I don't want to create it through access as I
would have to upload a 60 meg DB to our offsite server. Any suggestions for
the SQL Statement?
create table T_AddBook (
AddID autonumber,
Name varchar (20),
Add1 varchar (40),
Add2 varchar (40)
)
Thanks,
Will
Will Ryan
[EMAIL PROTECTED]
http://www.zerotoeighty.com
w: 410-327-9152
f: 410-327-4086
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
