varChar
and your SQL shoukd read:
INSERT INTO tableName (name,email) VALUE ('joe','[EMAIL PROTECTED]')
single quotes...
At 10:52 AM -0600 3/15/01, Savan Thongvanh wrote:
>Which string type are you supposed to use to store email addresses?
>I try
>
>INSERT INTO tableName (name,email) VALUE ("joe","[EMAIL PROTECTED]")
>
>i get an error about invalid bracketing of the second parameter. any ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
