SQL Error 22003

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39324
interpreted = N
texte = Hi,I am trying to implement a stored procedure with WebCat.Here is the code: [SQL DSN=Inntopia_Dev&Statement=exec ipvReservation_get_flexible @MinStatus = 1, @MaxStatus = 1, @SupplierID = 20692] [Founditems] Results go here [/FoundItems] [/Search]And what I get is: SQL Error: 22003 [Microsoft][ODBC SQL Server Driver]Numeric value out of range If I remove [FoundItems][/FoundItems] I get no error (but obviously that doesn't let me see the results of the query).I searched the archives and see that this issues has been brought up twice before without a reply from Smith Micro. So, what is the exact problem here? Is this a bug in the SQL implementation? If so, what is the workaround?FYI I am using WebCat 4 on NT and MS SQL 2000.Thanks.- Trevor__________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL Error 22003 : Found the workaround (Scott Anderson 2001)
  2. Re: SQL Error 22003 : Found the workaround (John Peacock 2001)
  3. Re: SQL Error 22003 : Found the workaround (trevor crist 2001)
  4. Re: SQL Error 22003 (trevor crist 2001)
  5. Re: SQL Error 22003 (trevor crist 2001)
  6. Re: SQL Error 22003 (Scott Anderson 2001)
  7. SQL Error 22003 (trevor crist 2001)
Hi,I am trying to implement a stored procedure with WebCat.Here is the code: [SQL DSN=Inntopia_Dev&Statement=exec ipvReservation_get_flexible @MinStatus = 1, @MaxStatus = 1, @SupplierID = 20692] [founditems] Results go here [/FoundItems] [/Search]And what I get is: SQL Error: 22003 [Microsoft][ODBC SQL Server Driver]Numeric value out of range If I remove [founditems][/FoundItems] I get no error (but obviously that doesn't let me see the results of the query).I searched the archives and see that this issues has been brought up twice before without a reply from Smith Micro. So, what is the exact problem here? Is this a bug in the SQL implementation? If so, what is the workaround?FYI I am using WebCat 4 on NT and MS SQL 2000.Thanks.- Trevor__________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ trevor crist

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[WebDNA] cant't restart webcatalog missing libcrypto.so.0.9.8 (2014) Spamming this list! (2000) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Mass download. (2003) WebCat chatroom (1997) [WebDNA] Domain upgrade questions (2009) Date in IF ELSE Comparison (2004) Text vs. Math (2000) Frustration with formulas.db (1999) Interfacing WebMerchant to www.fedex.com (1997) taxTotal, grandTotal (1997) international time (1997) Country & Ship-to address & other fields ? (1997) quantity minimum problem (1997) color and size options / ARCHIVES (1997) Summ=T Problem (1997) Multi-Row Tables from a search. (1997) Force leading zeros (1998) plugin-acgi, different results (1997) Cancel Subscription (1996)