If any of your values evaluate to NULL you will not form a valid insert string. You'll
end up with:
INSERT tblA (A,B) VALUES (1,)
Ypu'll need to check for NULL and make appropriate substitions:
INSERT tblA (A,B) VALUES (1,NULL)
Also I see your not using a field list? So all table fields must be account for, in
one way or another.
Also, it doesn't appear that ypur adding quoute to your insert statement? If data is
character type will might have to?
Bill
Willow Gold
http://www.willowgold.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
