Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 26th, 2004, 11:51 PM
Authorized User
 
Join Date: Dec 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem Using Access as the database, please help!

Hi everyone, I'm new here. Hopefully someone can help me by to solve this problem.

I have an asp program using MS access database. However I have problem storing chunks of information in, which is suppose to update in the system. It updates when i keyed in 30 lines but after that it refused to update in the if i continue to key in the information in the textbox. I did not limit to any number of words.
This is part of the code
<tr>
<td align="center" colspan="6"><textarea name="tProcedure" style="font-family:arial; width:600px; height:200px"><%if bEditProc then response.write sDetails%></textarea></td>
</tr>

ANyone can help?

 
Old December 27th, 2004, 01:07 AM
Friend of Wrox
 
Join Date: Dec 2004
Posts: 307
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Vadivel Send a message via Yahoo to Vadivel
Default

Are you saying in the database you are not able to update after certains number of words? if yes .. just check the datatype/size you have mentioned for that particular field in your database.

It might be mostly because you are trying to insert more data than you have defined while designing your DB.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com
 
Old December 27th, 2004, 02:29 AM
Authorized User
 
Join Date: Dec 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Vadivel, thanks for the reply. I have already checked and the DataType i had was specified as a memo which is meant for lengthy text. There isn't anymore that I can choose from...is there an alternative to this?






Similar Threads
Thread Thread Starter Forum Replies Last Post
having problem in inserting in access database alto ASP.NET 2.0 Basics 4 May 24th, 2007 08:57 PM
Problem with Access Database retrieval. Perire ASP.NET 2.0 Basics 3 April 19th, 2006 11:07 AM
problem Accessing Access Database using JavaScript kumar_siva Javascript How-To 3 February 8th, 2006 01:45 PM
access database connection problem shaileshk ADO.NET 6 July 5th, 2005 03:30 AM
Compacting Access Database problem imaley SQL Language 1 April 23rd, 2004 11:28 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.