Try using single quotes:
INSERT INTO tableName (name,email) VALUE ('joe','[EMAIL PROTECTED]')
SQL doesn't like double quotes.
Jason
----
Jason Aden
Allaire Certified Developer
[EMAIL PROTECTED]
www.wwstudios.com
> -----Original Message-----
> From: Savan Thongvanh [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 11:52 AM
> To: CF-Talk
> Subject: email addresses
>
>
>
>
> 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
