[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