No... but scanning is second nature to me... ;-)
At 12:08 AM 10/1/02, you wrote:
>Thanks, you are a mind reader!
>
>-----Original Message-----
>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, October 01, 2002 12:09 AM
>To: CF-Talk
>Subject: RE: SQL Text question from a beginner
>
>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
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
