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:

Dumb Question about Docs (1997) [WebDNA] WebDNA and MAMP/Apache (Mac) (2018) three cart questions (1997) WebCat2 - Getting to the browser's username/password data (1997) Generating Report Totals (1997) Navigator 4.01 (1997) [WebDNA] [OT] Google redirect or not (2014) Re:2nd WebCatalog2 Feature Request (1996) Country & Ship-to address & other fields ? (1997) Pre-flight public flag (1997) Not really WebCat (1997) Copy, Move, Create Folders (1998) [WebDNA] WebDNA 8.5 speed (2016) [/application] error? (1997) hmmm (2006) [OT] 'Email this story to a friend' (2003) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Completed order filename problem (2002) using showpage and showcart commands (1996) WebCat2 - [format thousands] (1997)