ASP Update max 1248 characters memo field

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

ASP Update max 1248 characters memo field

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> ASP Update max 1248 characters memo field

Page: [1]


patricksims Posts: 37 Joined: 7/7/2005 Status: offline	ASP Update max 1248 characters memo field - 3/24/2008 15:58:15 I have an ASP page that runs an update query, however the maximum number of characters I am able to update in a memo field in an Access database table is exactly 1248 (including spaces and commas) 1097 (non space characters including commas). If I have 1249/1098 characters I get an error telling me IE (7) cannot display the page (the asp page executing the update query). The same thing happens if I just write out the query instead of actually executing it on the asp update page. It should be noted that I can insert the data directly into the memo field in the database table. Also, when querying the record and populating a form in an edit page, it pulls all of the characters and displays them in the form field. The problem only occurs when I use an ASP page to run an update query (again, update works fine as long as I have 1248/1097 characters or less). Any help, suggestions would be appreciated. < Message edited by patricksims -- 3/24/2008 16:12:56 >


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 16:10:39 How are you inserting the data and with what type of connection? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to patricksims)


patricksims Posts: 37 Joined: 7/7/2005 Status: offline	RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 16:19:01 quote: ORIGINAL: Spooky How are you inserting the data and with what type of connection? Connection: Set conntemp=Server.CreateObject("ADODB.Connection") conntemp.Provider="Microsoft.Jet.OLEDB.4.0" conntemp.Mode=3 Running update query: MyQuery="update [table] set [field]='value' where ([ID]="&ID&")" conntemp.execute(MyQuery) field is a memo field with single quotes surrounding data string and ID is a number field primary key indexed with no duplicates thus no surrounding quotes. Thank you! (in reply to Spooky)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 16:30:51 Does this give a true error? http://www.frontpagewebmaster.com/m-235653/tm.htm _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to patricksims)


patricksims Posts: 37 Joined: 7/7/2005 Status: offline	RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 17:03:05 Friendly errors is turned off. Gives the IE error page when network connection is not connected. The update query works as long as I don't exceed a number of characters so I'm wondering if it has to do with the connection method. Also, there is no problem with network connectivity. < Message edited by patricksims -- 3/24/2008 17:12:13 > (in reply to Spooky)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 17:14:55 quote: If I have 1249/1098 characters Is that 1249th character a special as in an apostrophe or something? </$.02> EDIT: Ooops, sorry didn't see you were on at the moment Spooky... _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to patricksims)

patricksims

Posts: 37
Joined: 7/7/2005
Status: offline

RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 17:30:56

quote:

ORIGINAL: rdouglass

quote:

If I have 1249/1098 characters

Is that 1249th character a special as in an apostrophe or something?

</$.02>

EDIT: Ooops, sorry didn't see you were on at the moment Spooky...

quote:

Ooops, sorry didn't

The string is nothing more than all of the counties in the states of Missouri and Kansas. No special characters - just a-z alphabet, commas for seperation, and periods on abreviation of Saint (i.e. St. Louis). The 1249th character happens to be the letter a which comes after the letter e in the spelling of Geary (Geary County in Kansas). Quite simply, if I submit the string all the way to the 'e' in Geary, it works. If I include the a (or any further characters) it fails. This happens when trying to simply response.write the query:
MyQuery="update [table] set [field]='value' where ([ID]="&ID&")"
//conntemp.execute(MyQuery)
response.write(MyQuery)

(in reply to rdouglass)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 18:22:14 How is the value actually being passed from the form page to the process page? You are using POST and not GET? Why does your error page show Microsoft?? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to patricksims)


patricksims Posts: 37 Joined: 7/7/2005 Status: offline	RE: ASP Update page error 1097 characters in memo field... - 3/24/2008 19:20:05 quote: ORIGINAL: Spooky How is the value actually being passed from the form page to the process page? You are using POST and not GET? Why does your error page show Microsoft?? Eureeka!! Thank you Spooky. The problem was the form was get instead of post. As far as why the sample image showed a Microsoft URL - I just used a google image to show the error page instead of doing a screenshot and hosting it temporarily. My apologies. Thank you again for your help, even if it was kicking me in the #@@ to wake me up to the form method. (in reply to Spooky)