Try this...
INSERT INTO tableName (name,email) VALUE ('joe','[EMAIL PROTECTED]')
SQL expects single quotes to delimit text.
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Savan Thongvanh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 9: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
