problems inserting into sql using SqlHelper.Execu teScalar

[Chad Dittmer via .NET 247]

I'm having problems inserting into Sql 2000 using SqlHelper.Execu teScalar.
When it inserts, it only takes the first character from the string?? Any help would be appreciated. Here is the code and the stored procedure I'm using.

Dim newRowId As Integer
newRowId = Convert.ToInt32 (SqlHelper.Exec uteScalar(Confi gurationSetting s.AppSettings(" ConnectionStrin g"), "ProcContactsIn sert", 1234, "hparameter 2", "parameter2 ", "tparamer2" , "pareter2", "ypameter2" , "parTitle", "parater2", 1, 0, 1, 0, "parameer2" ))

---------------------

CREATE PROCEDURE ProcContactsIns ert
@CustID int,
@Cont1FirstName nvarchar,
@Cont1LastName nvarchar,
@Cont1Phone nvarchar,
@Cont1PhoneExt nvarchar,
@Cont1Fax nvarchar,
@Title nvarchar,
@Email nvarchar,
@Presort bit,
@PresortMeter bit,
@LetterShop bit,
@Printing bit,
@CellPhone nvarchar
AS
INSERT INTO Contacts (CustID, Cont1FirstName, Cont1LastName, Cont1Phone, Cont1PhoneExt, Cont1Fax, Title, Email, Presort, PresortMeter, LetterShop, Printing, CellPhone)
VALUES (@CustID, @Cont1FirstName , @Cont1LastName, @Cont1Phone, @Cont1PhoneExt, @Cont1Fax, @Title, @Email, @Presort, @PresortMeter, @LetterShop, @Printing, @CellPhone)
SELECT CAST(scope_iden tity() AS INTEGER)
RETURN
GO

------
It returns the correct id number but the varchar fields are only recieving the first character of the values.

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>BV3JhSpJ+0W MFtGSqpPgGg==</Id>

[Hermit Dave]

please specify the length of varchars in your stored procedure

some thing like (the length of varchar should be less than or equal to
length of the column) i usually prefer equal - (dont see a reason why not)

CREATE PROCEDURE ProcContactsIns ert
@CustID int,
@Cont1FirstName nvarchar(25),
@Cont1LastName nvarchar(25),
@Cont1Phone nvarchar(10),
@Cont1PhoneExt nvarchar(4),
@Cont1Fax nvarchar(10),
@Title nvarchar(3),
@Email nvarchar(100),
@Presort bit,
@PresortMeter bit,
@LetterShop bit,
@Printing bit,
@CellPhone nvarchar(10)
AS
INSERT INTO Contacts (CustID, Cont1FirstName, Cont1LastName, Cont1Phone,
Cont1PhoneExt, Cont1Fax, Title, Email, Presort, PresortMeter, LetterShop,
Printing, CellPhone)
VALUES (@CustID, @Cont1FirstName , @Cont1LastName, @Cont1Phone,
@Cont1PhoneExt, @Cont1Fax, @Title, @Email, @Presort, @PresortMeter,
@LetterShop, @Printing, @CellPhone)
SELECT CAST(scope_iden tity() AS INTEGER)
RETURN
GO

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Chad Dittmer via .NET 247" <an*******@dotn et247.com> wrote in message
news:e#******** ******@tk2msftn gp13.phx.gbl...

I'm having problems inserting into Sql 2000 using SqlHelper.Execu teScalar.
When it inserts, it only takes the first character from the string?? Any help would be appreciated. Here is the code and the stored procedure I'm
using.
Dim newRowId As Integer
newRowId = Convert.ToInt32 (SqlHelper.Exec uteScalar(Confi gurationSetting s.AppSettings(" C
onnectionString "), "ProcContactsIn sert", 1234, "hparameter 2", "parameter2 ",
"tparamer2" , "pareter2", "ypameter2" , "parTitle", "parater2", 1, 0, 1, 0,
"parameer2" ))
---------------------

CREATE PROCEDURE ProcContactsIns ert
@CustID int,
@Cont1FirstName nvarchar,
@Cont1LastName nvarchar,
@Cont1Phone nvarchar,
@Cont1PhoneExt nvarchar,
@Cont1Fax nvarchar,
@Title nvarchar,
@Email nvarchar,
@Presort bit,
@PresortMeter bit,
@LetterShop bit,
@Printing bit,
@CellPhone nvarchar
AS
INSERT INTO Contacts (CustID, Cont1FirstName, Cont1LastName, Cont1Phone, Cont1PhoneExt, Cont1Fax, Title, Email, Presort, PresortMeter, LetterShop,
Printing, CellPhone) VALUES (@CustID, @Cont1FirstName , @Cont1LastName, @Cont1Phone, @Cont1PhoneExt, @Cont1Fax, @Title, @Email, @Presort, @PresortMeter,
@LetterShop, @Printing, @CellPhone) SELECT CAST(scope_iden tity() AS INTEGER)
RETURN
GO

------
It returns the correct id number but the varchar fields are only recieving the first character of the values.
-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>BV3JhSpJ+0W MFtGSqpPgGg==</Id>