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:

PIXO Support (1997) database files in secure folder (1997) [WebDNA] To be or not to be friendly (URLs) (2011) Fwd: About WebCatalog and iTools 7 (2003) Banner Ad & Index.shtml (2000) Feature Request: DB Field manipulation (1998) small hairball -- stuck on [showif] for related db (1998) WebDNA-Talk Digest mode broken (1997) [WebDNA] Processor usage off the charts (2008) Webcat 3.0.7 & Webmerchant (2002) Exclude by date - multiple (1997) WebCat2 Append problem (B14Macacgi) (1997) searchable list archive (1997) OT: Advice (2003) japanese characters (1997) Too Much Rootbeer Free Offer (1997) Error, 101 a DNS problem ? (1997) [WebDNA] talklist archives don't search/find recent posts? (2008) Problems passing [SKU] with $Replace in 2.0 (1997) taxTotal, grandTotal (1997)