dbTalk Databases Forums  

Re: Optional select or enter data

mailing.database.msql-mysql-modules mailing.database.msql-mysql-modules


Discuss Re: Optional select or enter data in the mailing.database.msql-mysql-modules forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Greg Meckes
 
Posts: n/a

Default Re: Optional select or enter data - 08-27-2003 , 02:45 PM






Here's something that you might be able to use:
http://www.mattkruse.com/javascript/autocomplete/

You would just have to change the Perl script to populate the select menu, or use hidden fields.

Greg

--- Gerhard Weber <g.weber (AT) computer-manufaktur (DOT) de> wrote:
Quote:
hi Dan

Ideally, I'd like a text field that that auto-fills in as you type,
selecting the closest match from the existing authors so long
as a match
is found. (Hopefully, that's clear. The behavior is common but
somewhat difficult to describe.) HTML doesn't appear to support
anything near that level of sophistication. It should be possible to
write a script to create the behavior, but reloading the page
after each
key press seems like a non-starter in terms of performance.

Something like this *can* be done with Javascript. You would need to
dynamically generate a Javascript array with your authors' names, an
update-function and an event-handler in your input fields (e.g. onKeyUp)
calling the update function.
Since this is a bit off topic, I keep it short: I once tried something
similiar but the performance depended heavily a) the number of authors
and b) your browser, so in the end I did not use it.

The only alternative I can come up with my limited knowledge
is to have
both a text field for new entires and a select field for existing
entries. Surely there's a better way than that.

Sounds okay for me. Think of it as the price of a web application

Greetings,
gerhard

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gr...ahoo (DOT) com


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw



Reply With Quote
  #2  
Old   
Leif W
 
Posts: n/a

Default Re: Optional select or enter data - 08-27-2003 , 03:27 PM






Also, here's a page that shows how to do this in Mozilla as well as IE.

http://www.faqts.com/knowledge_base/view.phtml/aid/1174


----- Original Message -----
From: "Greg Meckes" <gregmeckes (AT) yahoo (DOT) com>
To: "Perl MySQL Mailing List" <perl (AT) lists (DOT) mysql.com>
Sent: Wednesday, August 27, 2003 3:14 PM
Subject: Re: Optional select or enter data


Quote:
Here's something that you might be able to use:
http://www.mattkruse.com/javascript/autocomplete/

You would just have to change the Perl script to populate the select menu,
or use hidden fields.

Greg

--- Gerhard Weber <g.weber (AT) computer-manufaktur (DOT) de> wrote:
hi Dan

Ideally, I'd like a text field that that auto-fills in as you type,
selecting the closest match from the existing authors so long
as a match
is found. (Hopefully, that's clear. The behavior is common but
somewhat difficult to describe.) HTML doesn't appear to support
anything near that level of sophistication. It should be possible to
write a script to create the behavior, but reloading the page
after each
key press seems like a non-starter in terms of performance.

Something like this *can* be done with Javascript. You would need to
dynamically generate a Javascript array with your authors' names, an
update-function and an event-handler in your input fields (e.g. onKeyUp)
calling the update function.
Since this is a bit off topic, I keep it short: I once tried something
similiar but the performance depended heavily a) the number of authors
and b) your browser, so in the end I did not use it.

The only alternative I can come up with my limited knowledge
is to have
both a text field for new entires and a select field for existing
entries. Surely there's a better way than that.

Sounds okay for me. Think of it as the price of a web application

Greetings,
gerhard

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=gr...ahoo (DOT) com



__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=wa... usa (DOT) net





--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.