65536 limitationon drop down?

	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

Free FrontPage Templates

Search Forums

Recent Posts

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

65536 limitationon drop down?

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 >> 65536 limitationon drop down?

Page: [1]


dzirkelb1 Posts: 1315 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	65536 limitationon drop down? - 3/8/2007 12:17:38 I have a drop down that displays all of our inventory master data using access 97...when the query is run that houses the data, it displays 66794 records. When I go to the drop down, it stops displaying at the 65536 record...it appears there are a bunch of white spaces after that. Anyone know why this is or how to correct it?


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: 65536 limitationon drop down? - 3/8/2007 14:08:54 you dont seriously place 65000 items in a drop down list? _____________________________ 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 dzirkelb1)


dzirkelb1 Posts: 1315 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: 65536 limitationon drop down? - 3/8/2007 15:54:55 Hehe, I didn't create it...it was made about 7 years ago or so. It lists every part number we have...they start typing and it narrows down on the list until they can select it. At that time it puts data in other fields. I found the max to be that number in a combo box in access. I found some code that will take the search string and only search after one character is entered, which will take it from 65k down to about 100 or so...so that should work :) http://allenbrowne.com/ser-32.html There is the link I found. If anyone else has any suggestions, please give me to me! :) (in reply to Spooky)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: 65536 limitationon drop down? - 3/8/2007 17:23:39 Its the kind of thing that AJAX would be good for, but yes, I would use a criteria to define smaller subsets. The code for displaying that many options would be over a megabyte surely! _____________________________ 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 dzirkelb1)


Mike54 Posts: 4791 Joined: 3/26/2001 From: Way Up Over Status: offline	RE: 65536 limitationon drop down? - 3/8/2007 17:25:25 quote: you dont seriously place 65000 items in a drop down list? Actually he said "66794" _____________________________ Who was the first guy that looked at a cow and said, "I think that I'll drink whatever comes out of those things when I squeeze them"? New photogalleries, stop by sometime. (in reply to Spooky)