I need to create and call a store procedure that has a Select statement with an IN clause in the WHERE Condition.
The data type of the field is int.
How do I pass the variable to the IN clause?
Stored Procedure:
sp_GetRecords
@IDList
AS
SELECT *
FROM TABLE
WHERE IDField IN @IDList
The last time I checked (for Notes 4.6x) there is/was a product called Notes SQL which put an ODBC Inteface to Lotus Notes databases. The Product was made my Lotus; however, the problem is that access is/was VERY slow.
The method that I used was creating a Visual Basic Object with vb wrapper...
Thanks so much ... the following worked!
<asp:TextBox id="TextBox1" runat="server" style="text-align:right"></asp:TextBox>
John
I need to know how to right align or right justify an Input or ASP TextBox for data entry.
I have a form that has several lines that are monetary figures and the data entry would look like Figure 1.
Figure 1:
Line Item 1 12.34
Line Item 2 135
Line Item 3 0.50
Line Item 4...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.