Re: SQL Error 22003

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39327
interpreted = N
texte = What version of WebCatalog are you using (check your statistics page for the exact version)? There have been several fixes regarding the SQL context since 4.0 was released.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of trevor crist > Sent: Friday, October 12, 2001 11:24 AM > To: WebCatalog Talk > Subject: SQL Error 22003 > > > 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/------------------------------------------------------------- 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)
What version of WebCatalog are you using (check your statistics page for the exact version)? There have been several fixes regarding the SQL context since 4.0 was released.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of trevor crist > Sent: Friday, October 12, 2001 11:24 AM > To: WebCatalog Talk > Subject: SQL Error 22003 > > > 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/------------------------------------------------------------- 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/ Scott Anderson

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] mydatabase.db-oRiGiNaL- (2016) WebDNA Solutions ... sorry! (1997) [WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Authentication (1998) Targeting [redirect] to a frame? (1998) Simple way to create unique SKU (1997) syntax question, not in online refernce (1997) [WebDNA] minor changes (2016) Make sure I understand this??? (1997) [WebDNA] [BULK] WebDNA 7 and Mac OS X (10.6.7) Server Version [installation] (2011) Where's Cart Created ? (1997) a search based on ^(contains) (1998) More than one db with the same namn (was: WC2f3) (1997) webcatalog loosing serial number (1998) WebCommerce: Folder organization ? (1997) Protect vs Authenicate (1997) Quit revisited (1997) [search] and [shownext] Problem (2000) Web Catalog 2 demo (1997)