Re: SQL Error 22003

This WebDNA talk-list message is from

2001


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

Unable to view next 101-200 (1997) [WebDNA] Extracting contents of a div (2012) Eudora Plugin (1999) Search inside Include (1998) HomePage Caution (1997) webcat and OS 8 (1997) [WriteFile] problems (1997) [format xs] freeze (1997) temporary database? an aside (2000) [group] ? (1997) WebCatalog NT beta 18 now available (1997) Bug Report, maybe (1997) service stop and restart (1997) Some pointers please (2008) Bug Report, maybe (1997) Happy Easter ... and grep string request ... (2004) Silly Question (1997) [WebDNA] =?windows-1252?Q?Re=3A_=5BWebDNA=5D_Re=3A_=5BWebDNA=5D_=5BWebDNA?= (2012) post (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997)