Gossamer Forum
Home : Products : DBMan : Customization :

Multiple Fancy Select Field MOD v.2.0

Quote Reply
Multiple Fancy Select Field MOD v.2.0
Can anyone tell me where to get this MOD. The link in the resource center comes up error.

------------------
Regards,

Richard Bilger, Publisher
mailto:RBilger@MERGInet.com
__________________________________________________
MERGInet Medical Resources
http://www.MERGInet.com
mailto:info@MERGInet.com
__________________________________________________
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
It shouldn't....

Go here:

http://www.anthrotech.com/.../mult_select_mod.txt

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------








Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Don't know what your problem is, but when I click on the link in the Resource Center, it goes to the page I WROTE!

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------








Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Tried your link as well as the link in the Resource center and all I get is:

Cannot find server or DNS Error
Internet Explorer

I even tried to dial up your web site separately.

------------------
Regards,

Richard Bilger, Publisher
mailto:RBilger@MERGInet.com
__________________________________________________
MERGInet Medical Resources
http://www.MERGInet.com
mailto:info@MERGInet.com
__________________________________________________
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Hmm..That is strange...I can access it fine.

What version are you using?

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. Smile
----------------------










[This message has been edited by Eliot (edited February 01, 2000).]

[This message has been edited by Eliot (edited February 01, 2000).]
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Version MS IE 5.0 under Win98 Second Edition. I can access everything else just fine. I have no idea what the problem is.

------------------
Regards,

Richard Bilger, Publisher
mailto:RBilger@MERGInet.com
__________________________________________________
MERGInet Medical Resources
http://www.MERGInet.com
mailto:info@MERGInet.com
__________________________________________________
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
It MUST be your browser! I am using all sorts of browsers and versions....AND I CAN access the page via MIE 5.0!!!!!!!

The problem could also be that a segment of the Internet network you are connected to may be down, which is not allowing you to access some sites.

But I can access the page just fine!!!!!!!

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------








Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Since you experiencing PROBLEMS with accessing the page...here is the Mod:

################################################################################
# #
# MULTIPLE SELECT MOD v.2.0 #
# #
# --------------------------------------------------------------- #
# Multiple Select Mod for Adding, Modifying, and Deleting Records #
# --------------------------------------------------------------- #
# This Mod allows you to create drop-down menus for selecting multiple values #
# for fields in your database. This version also works for search forms in #
# your databases. #
# #
# #
# Co-written by Eliot Lee and Carol Hall (JPDeni, DBMAN Forum Moderator). #
# #
# For technical assistance, please post messages in the DBMAN Discussion Forum#
# #
# http://www.gossamer-threads.com/scripts/forum/ #
################################################################################


(1) Add the following sub-routine to your html.pl file:

===============================================================================================

sub build_fancy_mult_field {
# --------------------------------------------------------
#
# To call this subroutine from html_record_form, use the following syntax:
#
# print &build_fancy_mult_field("FieldName",$rec{'FieldName'});
#
# Be sure to express the field name *exactly* as it is defined in your .cfg file.
#
$size = "5";
my $field = $_[0];
my $compare = $_[1];
my %selector = (
'FieldName1' => [
['---','Choose as many that apply:'],
['Value1','Value1'],
['Value2','Value2'],
['Value3','Value3'],
['Value4','Value4'],
['Value5','Value5'],
],
'FieldName2' => [
['---','Choose as many that apply:'],
['Value1','Value1'],
['Value2','Value2'],
['Value3','Value3'],
['Value4','Value4'],
['Value5','Value5'],
],
);

$output = qq|<SELECT NAME="$field" MULTIPLE SIZE="$size">\n|;
$i = 0;
while ( $selector{$field}[$i][0] ) {
$compare =~/$selector{$field}[$i][0]/ ?
($output .= qq|<OPTION VALUE="$selector{$field}[$i][0]" SELECTED>$selector{$field}[$i][1]\n|) :
($output .= qq|<OPTION VALUE="$selector{$field}[$i][0]">$selector{$field}[$i][1]\n|);
++$i;
}
if ($i) {
$output .= "</SELECT>";
}
else {
$output = "Incorrect field definition";
}
return $output;
}

===============================================================================================

NOTE: You will have to make the following changes to this sub-routine:

1. Change FieldName1 and FieldName2 to the field names that you want to have this
multiple selection drop-down menu.

2. Change the "Value*" to the values of your fields.

3. Change the value of $size variable to the number of rows that you want to
appear in the drop-down menu. It should look like the following:

$size = "5";

Replace the number between the double quotes.

(2) Add the following codes to the following sub-routines in your html.pl file:
sub html_record_form, sub html_record, and/or sub html_html_record_long.


print &build_fancy_mult_field("FieldName",$rec{'FieldName'});


NOTE: Replace FieldName with the field name that you defined in the sub build_fancy_mult_field
routine.

(3) Replace the following codes in your sub query routine in the db.cgi file:

my ($i, $column, @search_fields, @search_gt_fields, @search_lt_fields, $maxhits, $numhits, $nh,
$field, @regexp, $line, @values, $key_match, @hits, @sortedhits, $next_url, $next_hit, $prev_hit,
$first, $last, $upper, $lower, $left, $right, $restricted);

with the following codes:

my ($i, $column, @search_fields, @search_gt_fields, @search_lt_fields, $maxhits, $numhits, $nh,
$field, @regexp, $line, @values, $key_match, @hits, @sortedhits, $next_url, $next_hit, $prev_hit,
$first, $last, $upper, $lower, $left, $right, $restricted, $key);

(4) Add the following codes in your sub query routine in the db.cgi file:

foreach $key (keys %in) {
if ($in{$key} =~ /~~/) {
$in{$key} =~ s/~~/|/g;
$in{'re'} = 1;
}
}

AFTER the following codes:

local (%sortby);

(5) Add the following codes in your sub html_record routine or search form
routine in the html.pl file:

|; print &build_fancy_mult_field("FieldName",$rec{'FieldName'}); print qq|

Replace FieldName with the name of your multiple select field name.

Note: You also might want to add hints in your search form, like the
following:

"To choose multiple options, hold your Ctrl key and mouse button."


THIS IS THE LAST TIME I AM POSTING THIS MOD IN THIS FORUM! I HAVE ALREADY POSTED THE MOD ABOUT THREE TIMES OVER THE PAST TWO MONTHS!

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------








Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Hi Eliot, just tried connecting to your server and also received a "Could not connect with the server error." MSIE 4.07

------------------
~ ~ ~ ~ ~
Karen
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Eliot:

Thank you for posting the MOD. You certainly didn't have to do that but it is greatly appreciated.

I tried to open up your web site using Netscape as well and got the same type of error. Sounds like it may be a problem on your end with Karen also not able to open it up with a different version of IE.

Thanks again. Take care.

------------------
Regards,

Richard Bilger, Publisher
mailto:RBilger@MERGInet.com
__________________________________________________
MERGInet Medical Resources
http://www.MERGInet.com
mailto:info@MERGInet.com
__________________________________________________
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Uh...now I am at home and I am able to access the site. (Using a totally different Internet Service Provider...with Netscape 3.0, Netscape 4.05, MIE 3.02, MIE 4.0...and I can connect.)

To help me....Why don't you try to ping my site or do a traceroute. This will help me to pinpoint the problem.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. Smile
----------------------










[This message has been edited by Eliot (edited February 01, 2000).]
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Eliot, I tried accessing your site through my browser (IE 4.51 - Mac) and got the following error message "The specified server could not be found." I did a traceroute and it returned "•Can't resolve host name: www.anthrotech.com•". A whois through InterNIC tells me the domain name is available.

Dunno why you can access and I can't through any means, but something seems screwed up.

Melanie
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Really? Because when I go through various whois sites and also through www.networksolutions.com (Internic), the domain (www.anthrotech.com) is NOT available. And the registration information shows up as me! I have contacted my hosting company and they state that everything in terms of redirection and DNS is fine. And I am able to access my site through two totally different networks with 10 different browsers and versions!

Quote:
WHOIS OUTPUT
Registrant:
Anthrotech (ANTHROTECH-DOM)
3860 Sioux Drive
Apt. 9A
Flagstaff, AZ 86001
US
Domain Name: ANTHROTECH.COM
Administrative Contact:
Lee, Eliot (EL1586) ekl@DANA.UCC.NAU.EDU
520.527.5047
Technical Contact, Zone Contact:
Hostmaster, Web2010 (JS1795) HOSTMASTER@WEB2010.COM
407-445-3033 (FAX) 407-445-2427
Billing Contact:
Lee, Eliot (EL1586) ekl@DANA.UCC.NAU.EDU
520.527.5047
Record last updated on 02-Dec-1997.
Record created on 02-Dec-1997.
Database last updated on 31-Jan-2000 14:44:43 EST.
Domain servers in listed order:
NS.WEB2010.COM 209.235.31.149
NS2.WEB2010.COM 209.196.60.253
web2010.com

Uh..this is me!

This is quite odd, indeed....Please COPY the exact traceroute report.

I have also reserved www.anthrotech.org through my hosting company.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------








Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
I agree it's very odd. I did copy the exact traceroute message earlier. It simply says: "Can't resolve hostname: www.anthrotech.com" Same result with www.anthrotech.org. Same thing without the "www".

I did the InterNIC whois at www.networksolutions.com and just returned and tried it again. The result says: "NO MATCH: This domain is available!" Also tried www.anthrotech.org with the same results.

I tried pinging with no success (message "can't resolve host name". And I just tried accessing your site with Netscape 4.7 (again, Mac version) with the message that Netscape is unable to locate the server.

Can't get there from here.

Melanie
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
As a followup, I realized I erred in the whois lookup by adding the "www". I went back and tried without it and get appropriate whois results through internic. However, I still cannot access your site and traceroute still can't resolve the hostname. But sorry to cause you more concern than necessary.

Melanie
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Just so you know, I clicked on the link and I get the DNS error also, I am on ie5.0 on win2k.
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
That is funny, now it is working for me. Smile Oh well, computers are nutz.
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
I just tried and am still getting the DNS error, "Cannot connect to server" using both the link in this thread and copy/paste directly to the address line. Frown
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
I get "Host Not Found" using IE 5.0 and Netscape 4.6 and Netscape 3.0 under Windows NT 4.0

I also get the same message using the same set of browsers under Windows98 and Windows95.

-------------
donm

[This message has been edited by donm (edited February 02, 2000).]
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Well, thanks to a new KVM, I testing the url on every machine I have. So far, it has bombed with DNS errors on Win 98, NT 4.0, Win 2k Pro, Redhat 6.1, Debian Linux, and FreeBSD. I have tried both Explorer and Navigator, and even took the extra time to try a few other browsers as well. Traceroute yields no results, since it will not recognize the Domain name. Eliot, you are not the one at fault, and yes, you DO have the domain registered. But somewhere along the line, the Nameserver that you have your domain set to resolve to is dropping the ball. Too many people having errors here for it to be just coincidence.

LadyFire
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Hi

It's dropped from DNS servers in the UK as far as I can work out - I have tried on 3 different networks with nslookup and they all get this message:

can't find www.anthrotech.com: Non-existent host/domain

Chris
Quote Reply
Re: Multiple Fancy Select Field MOD v.2.0 In reply to
Really odd, Eliot. Your post on Feb 1 indicates no changes on your records since 02-Dec-1997. A check at Internic today indicates
Quote:
Record last updated on 31-Jan-2000. Record created on 02-Dec-1997.
Database last updated on 3-Feb-2000 14:29:53 EST.
Domain servers in listed order: NS.WEB2010.COM 209.235.31.149
NS2.WEB2010.COM 209.196.60.253

Sometime between "Database last updated on 31-Jan-2000 14:44:43 EST" (from your post) and before RBilger's post "posted 02-01-00 01:14 PM PST" your service provider has had some major DNS routing problems.

Unfortunately, I just tried accessing your site again and it is still down. Frown


------------------
~ ~ ~ ~ ~
Karen