Re: SQL Error 22003 : Found the workaround

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39335
interpreted = N
texte = We found the bug in Webcat. It appears that WebCat chokes on Money data types. When we change the stored procedure to return those values as nvarchar, it doesn't throw errors. Webcat doesn't care what format these are for display, but evidently it has some issues with it beneath the covers. --- trevor crist wrote: > I should also state that this query works just fine > when it is run in SQL's Query Analyzer. Just appears > that WebCat chokes when it tries to receive the > results. > > > --- trevor crist wrote: > > 4.0.2 rc2 > > --- Scott Anderson > wrote: > > > 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/ > > > > > > __________________________________________________ > > 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/ > > > __________________________________________________ > 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/ __________________________________________________ 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)
We found the bug in Webcat. It appears that WebCat chokes on Money data types. When we change the stored procedure to return those values as nvarchar, it doesn't throw errors. Webcat doesn't care what format these are for display, but evidently it has some issues with it beneath the covers. --- trevor crist wrote: > I should also state that this query works just fine > when it is run in SQL's Query Analyzer. Just appears > that WebCat chokes when it tries to receive the > results. > > > --- trevor crist wrote: > > 4.0.2 rc2 > > --- Scott Anderson > wrote: > > > 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/ > > > > > > __________________________________________________ > > 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/ > > > __________________________________________________ > 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/ __________________________________________________ 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:

URL for Discussion Archive (1997) Help formatting search results w/ table (1997) PCS Frames-Default page is solution! (1997) b12 cannot limit records returned and more. (1997) Great product and great job ! (1997) Been meaning to ask... (1997) Blocking off access (2005) WebCatalog can't find database (1997) [addlineitems] display (1997) ExclusiveLock (2000) Location of Webcat site in folder hierarchy (1997) shipping code (1998) [OT] Bandwidth Choking (2005) raw=T is broken in [include] (1997) Country & Ship-to address & other fields ? (1997) Showif Or (2000) [convertChars] and in a textarea on a form (1998) Calculating Standard Deviation (2005) wrong authentication (1998) ShowIf variables (1997)