Re: SQL Error 22003

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39332
interpreted = N
texte = 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/ 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)
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/ 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:

locking variables? (2000) Date Range search (1997) Listfiles on OSX (2002) supressing math results (1997) Major NT problem Interruption of service (1998) [WebDNA] Chatroom with Webcatalog (2011) question: search return in order (1997) Merging databases (1997) international time (1997) To Use Cookies or Not To Use Cookies (2003) wild question (1998) Mac v. NT (1998) PCS Frames (1997) newcart (1997) Max Record length restated as maybe bug (1997) Math (1997) PCS Customer submissions ? (1997) math on date? (1997) Help! WebCat2 bug (1997) sendmail spaces (1997)