Hi - I was hoping someone has attempted to do this and has been successfuly in getting it to work. I need to be able to produce a list of NAMES from my database, to be included in a separate page (not one that is generated by DBMAN). I have attempted to use the SSI mod that is in the support forum but quite honestly, the document is written in a strange format that makes it difficult to read and understand.

I did follow the instruction as best I could. However, when I attempt to access "the list" by typing in the url; for example: http://www.###.com/...;view_search_short=1

I receive this:

<form action="http://www.###.com/cgi-bin/dbman/db.cgi" method="GET">
<input type=hidden name="db" value="default">
<input type=hidden name="uid" value="default">
<TABLE WIDTH="490" CELLPADDING=0 CELLSPACING=0 BORDER=0 BGCOLOR="#FFFFFF">
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><Font face="Arial">ID:</FONT></TD>
<TD VALIGN="TOP" WIDTH="450">&nbsp;<INPUT TYPE="TEXT" NAME="ID" VALUE="" SIZE="3" MAXLENGTH="3"></TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><Font face="Verdana, Arial, Helvetica" Size=1 Color=#003399>Category: </FONT></TD>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><Font face="Verdana, Arial, Helvetica" Size=1 Color=#003399>Organization Name:</FONT></TD>
<TD VALIGN="TOP" WIDTH="450">&nbsp;<INPUT TYPE="TEXT" NAME="Name" VALUE="" SIZE="40" MAXLENGTH="255"></TD></TR>
</TABLE>
</center>

<p>
<INPUT TYPE="SUBMIT" NAME="view_records" VALUE="View Records">
<INPUT TYPE="RESET" VALUE="Reset Form">
</p></form>


....rather than the actual form. Is there another mod that would help me with accomplishing what I want or is there someone that can assist me? Thanks in advance.

Are you wanting an external search form with the values filled in? I think that is the mod you were trying below, which I never got to work either.

Or do you just want a list of values from one specific field? If so, you could use the category list mod.

If not, then please check the FAQ and look for threads related to "SSI", and you may find something that will work for what you are wanting to do.

Perhaps if you explained exactly what you are trying to do and provide an example others may also have suggestions.

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/

I only want a list from one specific field, with the <option></option> commands.

In my shtml file I have:

<select size="1" name="Charity_Name">
<option selected>Type First Letter of Charity Name Here</option>
<!--#exec cgi="http://www.###.com/...;view_search_short=1"-->
</select>

Note: in the html.pl file under sub html_short_search_form, I have:

my (%rec) = @_;
($db_auto_generate and print &build_html_record_form(%rec) and return);

if ($in{'add_form'}) {
unless ($rec{'UserID'}) {
$rec{'UserID'} = $db_userid;
}
}

print qq|
<option>$rec{'Name'}</option>
|;
}

So basically, when a user accesses the shtml file from the website, they will be prompted with a listing of "Name" that they can select from a drop down list.

I have not tried the other mod you were referring to, I will take a look to see if that is what I need.

Thanks