filter criteria

Hi Joe & All,

I have a filter criteria that is behaving unusually.  I'm thinking its 
something really simple but cant figure it out.  

The first page asks for your first name, this is the second page and this 
code works fine (displays all variables properly and the correct db entry):

<CUSTOM ESCAPED="no">
<br>
hi {$first$} whats happening?
<br>
</CUSTOM>
                                                                               
                                                                               
                                         
<IMPORT
        CAPTION="Imported fields"
        DBIDSN="DBI:Pg:dbname=test"
        DBIUSER="jono"
        DBIPASS=""
        DBITABLE="people"
        VISIBLE="yes">
    <VARIABLE CAPTION="Last Name"   NAME="lname" FIELD="lname" WRITABLE="no"
     UPDATE="no" />
    <VARIABLE CAPTION="First Name"  NAME="fname" FIELD="fname" WRITABLE="no"
     UPDATE="no" />
    <VARIABLE CAPTION="Current Job" NAME="job"   FIELD="job"   WRITABLE="no"
     UPDATE="no" />
    <FILTER CRITERIA="fname='melanie'" />
</IMPORT>
                                                                               
                                                                               
                                         
<CUSTOM ESCAPED="no">
<br>
{$fname$} {$lname$} {$job$}
<br>
</CUSTOM>
                                                                               
                                                                               
                                         
  <SEQUENCE SELFINCLUDE="yes">
    <FILE FILENAME="index.survey" />
    <FILE FILENAME="index2.survey" />
  </SEQUENCE>

The filter criteria with a string match (melanie) works as expected, but when
I use:

<FILTER CRITERIA="fname={$first$}" />

I get no db results (submitting 'melanie' on the first page).

I'm sure I got this going correctly after my mid July posts about import, 
but now that I've come back to it it doesnt work.

Thanks, Jono



Skickat av jono price <[email protected]>
till survey-discussion