Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 21st, 2007, 02:51 PM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

 
Old July 21st, 2007, 04:51 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old July 22nd, 2007, 05:51 PM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

 
Old July 23rd, 2007, 01:07 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Bug Base In C# vasancer BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 October 22nd, 2008 01:20 PM
Bug Base jackandjo BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 2 January 22nd, 2008 02:31 PM
Bug or no to bug learning C using VS.Net to compil tesh All Other Wrox Books 0 February 14th, 2007 01:06 PM
Bug Base Query cf2006 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 7 December 23rd, 2006 10:55 AM
Editing Bug Base cf2006 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 6 August 19th, 2006 05:56 PM





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