>>>Hi, I am having trouble establishing select parameters in a query in VB asp.net.
>>>Here is what I have so far but looking for the right way to do it.
>>>
>>> VDataSourceG.SelectParameters.Clear()
>>> VDataSourceG.SelectParameters.Add("mnoun", TypeCode.String)
>>> VDataSourceG.SelectCommand = "SELECT l_nbr,cust_name,noun,
>>> office from FY2010 WHERE NOUN like ?mnoun"
>>>
>>>But I get errors, anything obviously wrong?
>>
>>Funny, so it was you in ASP.NET forums? :) I haven't figured this out.
>>
>>Are you saying it doesn't work?
>>
>> VDataSourceG.SelectParameters("mnoun").Value = "%Something%" ' we may need this line too
>
>Hi, my buddy orig started that profile and uses it from time to time, that's him, better looking.
>But if you try that syntax, it's illegal.
I think Sergey nailed it, but now it's not clear how to set multiple parameters?
If it's not broken, fix it until it is.
My Blog