From: Robert Klemme <shortcutter@...>
Date: 2008-07-05T01:01:45+09:00
Subject: Re: Stored Procedure + sql server 2005 + insertion

On 04.07.2008 13:11, Sumanta Das wrote:
> Sumanta Das wrote:
>> hi..... can any body help me?
>> i want to insert data into sql server(2005)database...
>> i have a int value to pass......
>> how can i send it to the stored procedure
>> .....
>> here IndID is the integer value but when i want to pass it... it is
>> showing the follwing error:
>>
>>
>> DBI::DatabaseError: Execute
>> OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server
>> Error converting data type varchar to int   //// here also showing
>> scalar
>>                                             variable must be declared if
>> single
>>                                             quote taken off
>> HRESULT error code:0x80020009
>> Exception occurred.: exec SP_peopleinsert
>> '@fname','@mname','@lname','@sex','@dob','@IndID'
>>
>>
>>
>>
>> thanx for helping... in advance
> 
> 
> 
> i need it urgently.... plz helppp

Don't push people.  All of us do this for the fun of it.

Where is your Ruby code?

	robert