try this, in your INSERT INTO Statement VALUE should be VALUES with and "S".
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "Savan Thongvanh" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 9:52 AM
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
