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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Text question from a beginner
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
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 __ 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
RE: SQL Text question from a beginner
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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: SQL Text question from a beginner
My understanding of TEXT type fields is that there is only 16 bytes stored in the database, because the rest of the field's contents are stored elsewhere. And the 16 bytes are only a pointer to it. A TEXT field in SQl can hold up to 2,147,483,647 characters and cannot be used as variables or parameters in stored procedures. Not sure of the exact amount, but it's a WHOLE LOT of info. It's like a MEMO field in Access. A VARCHAR field is limited to 255 characters max, but as I understand it, a TEXT field is unlimited for most practical purposes. Other than setting up the table, and some considerations of searching large amounts of data, once you set the fields up, you access TEXT fields just the same way you access VARCHAR fields and there is no difference to how you work with them. But hold disk space allocations in mind, so dont just go and set up a whole bunch of TEXT fields rather than defining lengths in VARCHAR fields - you'll find your disk space gets out of control real fast. (or so I've been led to believe) Cheers Mike Kear AFP Webworks Windsor, NSW, Australia -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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: SQL Text question from a beginner
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Text question from a beginner
Well, that is the highest signed integer you can represent with a 16-bit byte, isn't it? -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Text question from a beginner
Hi, John. I use Access 2000 and when I need more than 255 characters, I use the Memo datatype in Acess...I forget the limit for that datatype, but it's quite large and always enough for everything I've needed... HTH, Rick -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:33 AM 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Text question from a beginner
hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Re: SQL Text question from a beginner
It is the pointer that points to the data that is 16 bytes long :) Jeremy - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 1:30 PM Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
RE: SQL Text question from a beginner
No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- 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 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM 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
RE: SQL Text question from a beginner
s'all good mang.too bad I cant jive to well with java kinda prefer mahuang and good old thc :) ..tony -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:02 PM To: CF-Talk Subject: RE: SQL Text question from a beginner No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- 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 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: SQL Text question from a beginner
Actually, I'm a Coke and Mountain Dew coder. Hot caffeine just doesn't do it for me. But than, this is off topic, isn't it? 8^) -- 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 2:04 PM To: CF-Talk Subject: RE: SQL Text question from a beginner s'all good mang.too bad I cant jive to well with java kinda prefer mahuang and good old thc :) ..tony -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:02 PM To: CF-Talk Subject: RE: SQL Text question from a beginner No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- 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 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM 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 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: SQL Text question from a beginner
yeah. but. so is a lot on this list ;) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 4:26 PM To: CF-Talk Subject: RE: SQL Text question from a beginner Actually, I'm a Coke and Mountain Dew coder. Hot caffeine just doesn't do it for me. But than, this is off topic, isn't it? 8^) -- 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 2:04 PM To: CF-Talk Subject: RE: SQL Text question from a beginner s'all good mang.too bad I cant jive to well with java kinda prefer mahuang and good old thc :) ..tony -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:02 PM To: CF-Talk Subject: RE: SQL Text question from a beginner No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- 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 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM 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 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
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
