Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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

  #2 (permalink)  
Old July 21st, 2007, 04:51 PM
Imar's Avatar
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #3 (permalink)  
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.

  #4 (permalink)  
Old July 23rd, 2007, 01:07 AM
Imar's Avatar
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 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.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 10:50 PM.


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