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:
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)