data view parameters

[Tom Brophy]

I am trying to show only specific records in a data view based on information
passed from a previous page. I try to click on filter and add the field
'OppID' and pick 'Input Parameter' but when I click OK it shows 'The Query
you are trying to execute contains syntax errors'. The query portion that I
see is below. I don't have much experience in ASP or SQL but I do have a lot
in VB. Any help or code samples would be fantastic - or other
recommendations.

Thanks,

Tom Brophy


<dsp:Query>
<dsp:Fields>
<dsp:Field Name="Date"/>
<dsp:Field Name="ActionTakenBy"/>
<dsp:Field Name="Note"/>
<dsp:Field Name="ID"/>
<dsp:Field Name="OppID"/>
<dsp:Field Name="ActionTaken"/>
<dsp:Field Name="FollowupDate"/>
<dsp:Field Name="Contact"/>
<dsp:Field Name="FollowupBy"/>
<dsp:Field Name="NextAction"/>
</dsp:Fields>
<dsp:OrderBy
xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp">
<dsp:OrderField Name="Date" Type="xsd:string"
Direction="ASC"/>
</dsp:OrderBy>
<dsp:Where
xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp">
<dsp:Eq>
<dsp:FieldRef Name="OppID"/>
<dsp:Value
Type="x:int"><udc:ClientParameterValue
xmlns:udc="http://schemas.microsoft.com/data/udc"
Name="filterParam"/></dsp:Value>
</dsp:Eq>
</dsp:Where>
</dsp:Query>