p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 (http://p2p.wrox.com/forumdisplay.php?f=252)
-   -   bug base/DAL (http://p2p.wrox.com/showthread.php?t=60354)

ursinho99 July 21st, 2007 02:51 PM

bug base/DAL
 
Imar,

I am attempting to use the VB version of your three part article building layered web applications with the BugBase as a foundation.

I have an insert procedure that adds a new customer to the database. Upon the initial log in the insert works fine, when i go to add a second customer i get an error;

String or binary data would be truncated.
The statement has been terminated.
The 'bus_RCustomerInsertUpdate' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

If i log out and back in again the insert works fine. Any idea what could be causing this error.

If you want me to post some code let me know.

EC


Imar July 21st, 2007 04:51 PM

Hi EC,

Indeed hard to tell without seeing any code. Can you post the code for bus_RCustomerInsertUpdate and the code that calls this procedure? In addition, some background on why this code is being called, and what you're trying to accomplish would help as well.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

ursinho99 July 22nd, 2007 05:51 PM

All figured out, simple error in SP.

Appreciate it greatly your articles and that you do respond on these forums. Make it much easier to learn.


Imar July 23rd, 2007 01:07 AM

You're welcome.....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.


All times are GMT -4. The time now is 06:35 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.