The TEXT datatype should be as easy to use as the VARCHAR datatype you were using earlier... simply change the type of the field to TEXT and suddenly it will hold as much text as you want.
----------------------- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig > -----Original Message----- > From: John Munyan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 1 October 2002 4:33 PM > To: CF-Talk > Subject: RE: SQL Text question from a beginner > > > I took a look on msdn and books online and haven't been able to make > much sense of the situation. It appears that one can't > define their own > data type and accessing this data is less than intuitive. > Anyone out > there figured out a way to retrieve a couple of pages of > data from ms > sql? Or accomplish the insertion of dynamic text via some > other means? > > Thanks, > > John > > -----Original Message----- > From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 30, 2002 10:38 PM > To: CF-Talk > Subject: RE: SQL Text question from a beginner > > A whopping 16 characters? 8^) > > Actually, according to my SQL Server reference, the TEXT > datatype can > store > 2,147,483,647 bytes. > > -- > Mosh Teitelbaum > evoch, LLC > Tel: (301) 625-9191 > Fax: (301) 933-3651 > Email: [EMAIL PROTECTED] > WWW: http://www.evoch.com/ > > > > -----Original Message----- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 01, 2002 12:11 AM > > To: CF-Talk > > Subject: RE: SQL Text question from a beginner > > > > > > look at the datatype of "text" it holds 16 bytes of data, > i believe. > > > > hth > > > > tony > > > > -----Original Message----- > > From: John Munyan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 01, 2002 12:04 AM > > To: CF-Talk > > Subject: SQL Text question from a beginner > > > > > > I am new to web development (if I can call what I am doing web > > development) and have a sql question and was hoping someone could > point > > me in the right direction. I have put together this data driven > website > > and found access to be insufficient to hold as much text > as I wished > in > > a description field. Thus I moved to sql, but am finding the 4000 > > character limitation for varchar to be a hindrance and > not much better > > than the 255 character limit in access. I found a link a couple > minutes > > ago basically stating I was pretty much limited to 8000 > characters no > > matter the data type I pick save for some concatenation > maneuver. So > I > > am wondering how I can just put a blob of text into the > database. I > > can't be the only guy who wants to store a couple pages > of text in a > > field in a database so that it can be queried to populate > a web page > can > > I? On it's face it would seem that if I should be able > to define my > > own data type to accommodate my needs? What is the right > direction? > > > > > > > > Thanks, > > > > > > > > John > > > > > > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
