Don't forget that there are limitations on how much text a user can cut and paste into a textbox or textarea field in a form. I believe that the limitations are browser dependant... around 8K for IE5+ I seem to remember.
At 11:47 PM 9/30/02, you wrote: >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 >> > >> > >> > >> > >> > >> > >> >> > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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