Search Issue
22 posts by 3 authors in: Forums > CMS Builder
Last Post: June 9, 2010 (RSS)
By thenetgirl - June 7, 2010
& just doesnt produce the list of who go what trust.
<td width="118" align="right"><font face="Arial"><b>Trust Names:</b></td>
<td><font face="Arial">
<select name="trust_name" style="font-family: Arial; font-size: 10pt; width: 200px;" size="1">
<option value="" ></option>
<?php foreach ($trustsRecords as $record): ?>
<option value="<?php echo $record['trust_id'] ?>"><?php echo $record['trust_id'] ?>
</option>
<?php endforeach ?></select></td>
www.thenetgirl.com
By Jason - June 7, 2010
Okay, if the name is being stored in the grantees table, change the name of the <select> back to whatever the name of the "Trust Name" field is.
So if the it's the name being stored, not the id, then the value of the <option> tags needs to be the name.
Try this:
<td width="118" align="right"><font face="Arial"><b>Trust Names:</b></td>
<td><font face="Arial">
<select name="trust_name" style="font-family: Arial; font-size: 10pt; width: 200px;" size="1">
<option value="" ></option>
<?php foreach ($trustsRecords as $record): ?>
<option value="<?php echo $record['trust_name'] ?>"><?php echo $record['trust_name'] ?>
</option>
<?php endforeach ?></select></td>Note: it's very important that the name of the <select> field is the same as the name of the field in the grantee table, not the trustee table.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Search Issue
By thenetgirl - June 7, 2010 - edited: June 7, 2010
on the trust database is
trust_id
trust_name
trust_desc
trust_active
on the granteees database is
g_id
trust_id
g_year_awarded
g_amount
g_term
g_name
g_contact
g_contact_title
g_address
g_phone
g_email
g_website
g_mission
I need to say get the trust id give it a name on the pulldown list (which I had) working
and produce a list of clients that have that grant <-----this I dont have
www.thenetgirl.com
By Jason - June 8, 2010
Okay. So we're compiling a list of trustees from the trust table (id, and name) and are trying to retrieve a list of grantees from the grantee database that have that same trust_id. Correct?
The correct way to do this then would be as follows:
<td width="118" align="right"><font face="Arial"><b>Trust Names:</b></td>
<td><font face="Arial">
<select name="trust_id" style="font-family: Arial; font-size: 10pt; width: 200px;" size="1">
<option value="" ></option>
<?php foreach ($trustsRecords as $record): ?>
<option value="<?php echo $record['trust_id'] ?>"><?php echo $record['trust_name'] ?>
</option>
<?php endforeach ?></select></td>It is important that the <select> field have the same name as the field you are trying to search on in the grantees table (trust_id). It will search using the value of the option selected (trust_id).
Give this a try. If this doesn't work, please email me your CMS Login and FTP details to jason@interactivetools.com and I'll take a closer look for you.
Thanks.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Search Issue
By thenetgirl - June 8, 2010
In stead of everything now we have - No records were found! for all of them. I know levi has stuff not sure about all the others
www.thenetgirl.com
By Jason - June 8, 2010
The problem is not in how we're searching, but the actual values in the database.
For example, if you select "Auto Advertising Fund", it will correctly return 1 record.
I took a look at the "Levi Strauss" record. In the trusts table, it has a trust id of 8. If you do an Search for records in the grantee table that have a trust_id of 8, you'll find none. This is why we're getting the message "No Records Found".
trust_id value of 3, belongs to "Community Collaborative Fund", which correctly returns a large number of records.
What I think happened was a mixup when manually entering trust_id's into the grantee table. The easiest way to get around this, is to set up the trust_id field in the be a list that takes it's values from the trusts table. It should use "trust_id" for the option values and "trust_name" as the option labels. This will help stop mix ups in the future.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Search Issue
By thenetgirl - June 8, 2010
www.thenetgirl.com
By Jason - June 8, 2010
You can still make the change to the list field. That way it may be easier to spot which ones need to be changed.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Search Issue
By thenetgirl - June 8, 2010
[/#000000]
I am not sure what your mean here?[/#000000]
www.thenetgirl.com
By thenetgirl - June 8, 2010
www.thenetgirl.com