Yeah - everything is a string field in this table because it has to be -
OWSID and siteid could both be alphanumeric.
----- Original Message -----
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 3:03 PM
Subject: RE: Insert INTO syntax error - HELP
: > SQL = "INSERT INTO OWS (owsid, type, date, capacity, length,
: > width, height, manufacturer, serial, discharge, repairs,
: > repairdates, cleaning1, cleaning2, contractorname,
: > contractoraddress, contractorPOC, contractorphone, license,
: > sludge, sample, locationid, siteid) VALUES ('1', 'jkl',
: > 'jkl', 'jkl', 'jk', 'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk',
: > 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
: > '02', '27A25')"
:
: Are the owsid and siteid fields string fields? If not, that's probably
your
: problem.
:
: Dave Watts, CTO, Fig Leaf Software
: http://www.figleaf.com/
: voice: (202) 797-5496
: fax: (202) 797-5444
:
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.