I have a multi module ListX question for a beginner. I have a list of records that I am linking to a detailed record in another module. I am looking for a way to pass two variables using LXFetch if possible. I have it setup like this but it is not working:

List of records has this in the List Item Detail
<TD><a href="lxFetch(516,0,'photo_date=[photo_date]','event_id=[event_id]');">[photo_date]</a></TD>

In the other module mid=516 I have the two variables set up in the variables tab like this:
Variable Type:QueryString Source:photo_date Target:@photo_date
Variable Type:QueryString Source:event_id Target:@event_id

My Query looks like this: Select DISTINCT camera, photo_location, photographer from tbl_photos where event_id = @event_id and photo_date = @photo_date order by camera ASC

The Line Item Detail looks like this:
<TR bgcolor="#bbbbbb">
<TD>[camera]</td>
<TD>[photo_location]</TD>
<TD>[photographer]</TD>
</TR>

This is not working. Is there another way of doing this?

change your lxFetch Like

lxFetch(516,0,'photo_date=[photo_date]&event_id=[event_id]');

Thanks,
DP

Thanks for your help. Sometimes the obvious is well hidden.

No Problem, let us know if you need further help