On May 5, 11:18 pm, bry...@[EMAIL PROTECTED]
wrote:
> Hi all.
>
> The following query
> displays the information I need in the gridview for a single record.
>
> SELECT OE_HDR.ORD_NO, OE_HDR.CUST_NAM, OE_HDR.SLS_MAN_NO,
> OE_HDR.SLS_MAN_INITIALS, OE_HDR.ORD_DAT, OE_HDR.****P_DAT
> FROM OE_HDR WHERE (OE_HDR.ORD_NO='174310')
>
> I also have DropDownList2 working properly. For the WHERE ****tion of
> the query I would like to pass avariablethat references the value
> of
> DropDownList2
>
> SELECT OE_HDR.ORD_NO, OE_HDR.CUST_NAM, OE_HDR.SLS_MAN_NO,
> OE_HDR.SLS_MAN_INITIALS, OE_HDR.ORD_DAT, OE_HDR.****P_DAT
> FROM OE_HDR WHERE (OE_HDR.ORD_NO= @[EMAIL PROTECTED]
)
>
> Here is the code that is erroring out:
>
> <asp:SqlDataSource runat="server" ID="SqlDataSource2"
> ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
> ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
> SelectCommand="SELECT OE_HDR.ORD_NO, OE_HDR.CUST_NAM,
> OE_HDR.SLS_MAN_NO, OE_HDR.SLS_MAN_INITIALS, OE_HDR.ORD_DAT,
> OE_HDR.****P_DAT FROM OE_HDR WHERE OE_HDR.ORD_NO= @[EMAIL PROTECTED]
">
> <SelectParameters>
> <asp:ControlParameter ControlID="DropDownList2" Name="ORD_NO"
> PropertyName="SelectedValue"
> Type="Int32" />
> </SelectParameters>
> </asp:SqlDataSource>
>
> Here is the error I get on the webpage:
>
> ERROR [42000] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC
> Engine Interface]SyntaxError: SELECT OE_HDR.ORD_NO, OE_HDR.CUST_NAM,
> OE_HDR.SLS_MAN_NO, OE_HDR.SLS_MAN_INITIALS, OE_HDR.ORD_DAT,
> OE_HDR.****P_DAT FROM OE_HDR WHERE OE_HDR.ORD_NO= @[EMAIL PROTECTED]
??? >>ORD_NO
>
> Seems like thesyntaxfor thevariablein the WHERE ****tion of my
> query is wrong. Any suggestions/help would be much appreciated.
>
> Thank you!
I cant take credit for figuring this our, the answer can be found in
an original post of mine on the asp boards
http://groups.google.com/group/microsoft.public.dotnet.framework.aspnet/browse_thread/thread/023b39064067e2c9/c8b936cf3bbe8f9a?hl=en#c8b936cf3bbe8f9a
|
