On 7/24/06, Farrukh Nizami <
[EMAIL PROTECTED]> wrote:
Thanks for your prompt reply Peter. I got this solution from Oddur. I will check it out and hope it works.
Thanks & Regards
Farrukh Nizami
________________________________
From: Peter Mills [mailto:[EMAIL PROTECTED]]
Sent: Mon 7/24/2006 10:16 PM
To: [email protected]
Subject: Re: Problem calling stored procedure having no parameter
Hi Farrukh,
You can use an empty parameter map.
<parameterMap id="EmptyParam"></parameterMap>
<procedure id="GetAllOrders" parameterMap="EmptyParam"
resultMap="myResultMap">
GetBusinessCustomFields
</procedure>
Cheers,
Peter
Farrukh Nizami wrote:
> Hi,
>
> I have a simple stored procedure that returns all the rows
> from a table.
>
> CREATE PROCEDURE [dbo].[GetAllOrders]
>
> AS
>
> SELECT [OrderID]
>
> ,[CustomerID]
>
> ,[EmployeeID]
>
> ,[OrderDate]
>
> ,[RequiredDate]
>
> ,[ShippedDate]
>
> ,[ShipVia]
>
> ,CAST([Freight] AS Real) AS Freight
>
> ,[ShipName]
>
> ,[ShipAddress]
>
> ,[ShipCity]
>
> ,[ShipRegion]
>
> ,[ShipPostalCode]
>
> ,[ShipCountry]
>
> FROM [Northwind].[dbo].[Orders]
>
>
>
> How to call this stored procedure? Whenever I want to call this SP, it
> complains that it need parameterMap attribute in procedure tag. But I
> do not need any parameter to call this SP. Please help
>
>
>
> */Thanks & Regards
> /**/Farrukh Nizami/*
>
> *Axentis Software Private Limited
> Unit # 3, Ground Floor, Inventor Block,
> I T P B, **Whitefield Road,
> Bangalore: 560066, I N D I A*
> *P: 91-80-28416690 / 91 / 92 / 93 Ext. 2050
> F: 91-80-28412010
> M: 0-98867-32213*
> *Web:* www.axentis.com
> < file:///C:/Documents%20and%20Settings/fnizami/Application%20Data/Microsoft/Signatures/www.axentis.com>
>
--
"Hey you! Would you help me to carry the stone?" Pink Floyd
