This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C0458B.5EE2DAB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
OK here is what I have so far:
CREATE Table #userid#
(
ID TEXT(40) NOT NULL PRIMARY KEY,
userid TEXT(40) NOT NULL,
category TEXT(10) NOT NULL,
quant TEXT(10) NOT NULL,
startprice TEXT(10) NOT NULL,
duration TEXT(2) NOT NULL,
auction_id TEXT(25) NOT NULL,
title TEXT(45) NOT NULL,
auction_date DATE NOT NULL,
ebaybidarea MEMO NOT NULL
);
This creates a table for the user with 10 fields. However I still have 2
problems.
1) The Primary Key is not set to auto number, how can I set this? Should I
be using something in place of TEXT(40) I tried using AutoNumber but that
returned errors.
2) I can't get the auction_date field to work. If I add the DEFAULT Date()
to the SQL statement I get errors.
Thanks,
Rich
------=_NextPart_000_0000_01C0458B.5EE2DAB0
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IgYQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCwADAAsALAAAAAUAIQEB
A5AGAPwGAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAFQAAAFJFOiBDcmVhdGUgVGFibGUgU1FMAAAAAAIBcQABAAAAFgAAAAHARbVFxlHiaAhYm02M
rFWE3byy24EAAAIBHQwBAAAAGAAAAFNNVFA6SUJUT0FEQFBVTktBU1MuQ09NAAsAAQ4AAAAAQAAG
DgAIFUS1RcABAgEKDgEAAAAYAAAAAAAAANaQ1++mswRGj2g2rkmyT1nCgAAACwAfDgEAAAACAQkQ
AQAAAI4CAACKAgAA9QMAAExaRnUvQwIcAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj
aArAc7BldDAgBxMCgH0KgZJ2CJB3awuAZDQMYA5jAFALAwu1IE9LIJJoBJBlIAQAIHcQ8CUFQEkT
8GF2FDBzb3QgZgrAOgqiCoQKgEOAUkVBVEUgVAGgMmwUMCN1ESAFEGQjxRW0KBW0SUQgGLoWsEBY
VCg0MCkHsE8CVAewVUxMIFBSAElNQVJZIEtFfFksFbQXVBj/GgcbVWPpFKBlZwWweRxKD0AdL3xx
dQBwBUAcLB9/CoBz6wGQACBwBRBjFDAhXx2JtmQIcBSgaQIgHEoyGfBtHT5hEsAlwl8cBSZ0NXsk
fyXAdBcRHC0pTyfnZDseQRixRBaiGLIdTWVimGF5YheQCsBlYRiyME1FTU8aBxW0KTv5FbpUaBRR
BQAv0B5QBCBfL+ABkRcRAhAFwHQUACDnF1IUcCpwaCAPQBVgCJAQbGRzLhiwSG93/mUVEAXAFNAj
EAMQAyAU89QyICNgbxcBbTUwFbTuMRnwMkAUMFAFEADAHpHMS2UeoBRRbm8FQBEhzzMgFVAn8Dmx
bnUG0ASQ/iwT8DWAMoADkTXxOYIyUfY/BgA6sHU1EBTBOmA0Af0LgGcVMQeAO5E84QuANtCzC2Aj
kW9mHKgU0HQIgescEDy0QTnxTjpDPHA58KszwRShIAlwdAhwbj9R/wSQA2AREDdlFbQmwRTQOvH6
JwVAZztjFDAs2zTjOaJqdwWwazVBST5QFNBhhmRFMTPhREVGQRpgdRowRB5BKBnwObEz0lP+URqA
IxEeUAeAINEU0EOip0HPMiIAcGtzG1VSDeAWaBW0EeEATEAAAAsAAYAIIAYAAAAAAMAAAAAAAABG
AAAAAAOFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAeACCAGAAAAAADA
AAAAAAAARgAAAABShQAAJ2oBAB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADku
MAAeAAqACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgALgAggBgAAAAAAwAAA
AAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4ADIAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAA
AQAAAAAAAAALAA2ACCAGAAAAAADAAAAAAAAARgAAAACChQAAAQAAAAsAOoAIIAYAAAAAAMAAAAAA
AABGAAAAAA6FAAAAAAAAAwA8gAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADAD2ACCAGAAAA
AADAAAAAAAAARgAAAAAYhQAAAAAAAAsAW4AIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAAwBc
gAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAACAfgPAQAAABAAAADWkNfvprMERo9oNq5Jsk9Z
AgH6DwEAAAAQAAAA1pDX76azBEaPaDauSbJPWQIB+w8BAAAAnwAAAAAAAAA4obsQBeUQGqG7CAAr
KlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4AQCqADfZbgAAAEQ6XERvY3VtZW50cyBhbmQg
U2V0dGluZ3NcQWRtaW5pc3RyYXRvclxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1p
Y3Jvc29mdFxPdXRsb29rXG91dGxvb2sucHN0AAADAP4PBQAAAAMADTT9NwAAAgF/AAEAAAAyAAAA
PEFFRUdJUEdJT0FET0pPRk5PSk9LTUVEUENCQUEuaWJ0b2FkQHB1bmthc3MuY29tPgAAAAMABhBk
gH7wAwAHED0CAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAAT0tIRVJFSVNXSEFUSUhBVkVT
T0ZBUjpDUkVBVEVUQUJMRSNVU0VSSUQjKElEVEVYVCg0MClOT1ROVUxMUFJJTUFSWUtFWSxVU0VS
SURURVhUKDQwKU5PVE5VTEwsQ0FURUdPUgAAAAB3lQ==
------=_NextPart_000_0000_01C0458B.5EE2DAB0--
------------------------------------------------------------------------------------------------
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]
