just use [text]
There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Webmaster" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 04, 2001 4:25 PM Subject: Creating Text fields longer than 255 characters? > Ok, I have lost my train of thought. I know you can manually create the memo > field with Access, but I need to know the standard SQL format. I know that > there is the "Long Text" variable, but do not know what the SQL format is. > I tried VarChar, but that only goes to 255. What is the format I am looking > for to create a field that will support at least 500 characters? > > Any help would be appreciated. > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
