Re: SQL Error 22003 : Found the workaround

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39337
interpreted = N
texte = Thanks for the update.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of trevor crist > Sent: Friday, October 12, 2001 12:15 PM > To: WebCatalog Talk > Subject: Re: SQL Error 22003 : Found the workaround > > > 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/------------------------------------------------------------- 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)
Thanks for the update.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of trevor crist > Sent: Friday, October 12, 2001 12:15 PM > To: WebCatalog Talk > Subject: Re: SQL Error 22003 : Found the workaround > > > 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/------------------------------------------------------------- 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:

Math with Time (1997) Null Chars (1999) Using Plug-In while running 1.6.1 (1997) RE: Sorting error (1997) Change [cart] date (2002) off topic - dna snipets (1997) quantity minimum problem (1997) problem: search crashes webstar (1997) [SHOWIF] (1997) Autonumber in Table (2006) Sku numbers (1997) The beginning (1997) unsubscribe (1997) Help! WebCat2 bug (1997) Bug Report, maybe (1997) List of WebDNA users (2002) [WebDNA] Show next..... (2010) [WebDNA] WebDNA Roll Call (2013) Lookup command (1998) Normalizing Dates and Phone numbers (2000)