[ic] Using username to search another table

Philip Alves interchange-users@icdevgroup.org
Thu Oct 24 09:13:00 2002


Hello all,

I'm trying to use username from userdb as the search string for another
database.  I'm doing this in an attempt to add multiple shipping addresses
in a seperate database.  Here is the last attempt I've made:

[calc]$Config->{NoSearch} = ''[/calc]
   [if data shiptos::username::[data session username]]
   [loop search="
    fi=shiptos
  sf=username
  se=[data session username]
  op=eq
  co=yes
  rf=Code,Name
   "][on-match]
  <tr>
     <td style="contentbar1" colspan=2><img src="bg.gif" alt="" height=3>
  </tr>
   [/on-match]
   [list]<tr>
     <td style="contentbar1">
       <B>[loop-param Code]:</b>
     </td>
     <td>
       [loop-param Name]
     </td>
   </tr>
   [/list]
   [on-match]
  <tr>
     <td style="contentbar1" colspan=2><img src="bg.gif" alt="" height=3>
  </tr>
   [/on-match]
   [/loop]
   [/if]

This doesn't work, and I get this error in error.log:

192.168.1.250 dXY5WICp:192.168.1.250 - [24/October/2002:21:13:23 -0400] dev
/cgi-bin/dev/process.html Bad if 'data shiptos::username::[data session
username': syntax error at (eval 457) line 2, near "q{} session username

I've searched the mail archives, but no luck.  Any shove towards the proper
documentation, or any thoughts on what's going wrong would help me a ton!!!

TIA

Phil