Re: lookup problem
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36378
interpreted = N
texte = this makes no sense to me. The search I gave you to try and the lookup I gave you to try should have returned the exact same thing (if there was only 1 record belonging to federico).I would suggest submitting this as an official issue to SM tech support.Unless someone here is following along and can figure this out...Sorry, it makes no sense to me anymore.-JohnRodolfo de la Garza wrote:> John, > I get this: > > NotFoundAmigo > > -Rodolfo > > El 8/21/00 11:02 AM, John Butler john@feeling-goods.com escribió: > > > Now try this on that same page- > > > > [lookup > > db=autores.db&lookInField=user&value=federico&returnField=Nombre¬Found=NotF > > oundAmigo] > > > > (make sure that whole lookup tag is on one line) > > > > What do you get? > > > > -John > > > > Rodolfo de la Garza wrote: > > > >> John, > >> > >> I get this: > >> > >> numfound=1 > >> > >> 1-Federico > >> > >> _Rodolfo > >> > >> El 8/21/00 7:48 AM, John Butler john@feeling-goods.com escribió: > >> > >>> try this- > >>> > >>> [search db=autores.db&equserdatarq=federico] > >>>
numfound=[numfound] > >>> [founditems] > >>> [index]-[Nombre]
> >>> [/founditems] > >>> [/search] > >>> > >>> What do you get? > >>> > >>> -John > >>> > >>> Rodolfo de la Garza wrote: > >>> > >>>>>> Hi there, > >>>>>> > >>>>>> I'm try to use a lookup as before, I just change form WebCat 3 to WebCat > >>>>>> 4 > >>>>>> and I don't know if there are a problem with lookups. > >>>>>> I have this > >>>>>> > >>>>>> [search db=database.db&eqskudata=[sku]] > >>>>>> [founditems] > >>>>>> [autor]
> >>>>>> [Lookup > >>>>>> > >> db=autores.db&value=[autor]&lookInField=user&returnField=Nombre¬Found=No> > >>>>> t > >>>>>> Found] > >>>>>> [/founditems] > >>>>>> [/search] > >>>>>> > >>>>>> it shows this: > >>>>>> > >>>>>> federico > >>>>>> Not Found > >>>>>> > >>>>>> The field [autor] is OK because it shows federico but it don't find > >>>>>> anything in the autores.db. > >>>>>> I'm sure I have a field named user and Nombre in the autores.db and also > >>>>>> I'm > >>>>>> sure there are information in this fiels in the record of federico. > >>>>>> > >>>>>> any Idea Why this is happening. > >>>>>> > >>>>>> Thanks > >>>>>> -Rodolfo ------------------------------------------------------------- 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:
this makes no sense to me. The search I gave you to try and the lookup I gave you to try should have returned the exact same thing (if there was only 1 record belonging to federico).I would suggest submitting this as an official issue to SM tech support.Unless someone here is following along and can figure this out...Sorry, it makes no sense to me anymore.-JohnRodolfo de la Garza wrote:> John, > I get this: > > NotFoundAmigo > > -Rodolfo > > El 8/21/00 11:02 AM, John Butler john@feeling-goods.com escribió: > > > Now try this on that same page- > > > > [lookup > > db=autores.db&lookInField=user&value=federico&returnField=Nombre¬Found=NotF > > oundAmigo] > > > > (make sure that whole lookup tag is on one line) > > > > What do you get? > > > > -John > > > > Rodolfo de la Garza wrote: > > > >> John, > >> > >> I get this: > >> > >> numfound=1 > >> > >> 1-Federico > >> > >> _Rodolfo > >> > >> El 8/21/00 7:48 AM, John Butler john@feeling-goods.com escribió: > >> > >>> try this- > >>> > >>> [search db=autores.db&equserdatarq=federico] > >>> numfound=[numfound]
> >>> [founditems] > >>> [index]-[Nombre]
> >>> [/founditems] > >>> [/search] > >>> > >>> What do you get? > >>> > >>> -John > >>> > >>> Rodolfo de la Garza wrote: > >>> > >>>>>> Hi there, > >>>>>> > >>>>>> I'm try to use a lookup as before, I just change form WebCat 3 to WebCat > >>>>>> 4 > >>>>>> and I don't know if there are a problem with lookups. > >>>>>> I have this > >>>>>> > >>>>>> [search db=database.db&eqskudata=[sku]] > >>>>>> [founditems] > >>>>>> [autor]
> >>>>>> [Lookup > >>>>>> > >> db=autores.db&value=[autor]&lookInField=user&returnField=Nombre¬Found=No> > >>>>> t > >>>>>> Found] > >>>>>> [/founditems] > >>>>>> [/search] > >>>>>> > >>>>>> it shows this: > >>>>>> > >>>>>> federico > >>>>>> Not Found > >>>>>> > >>>>>> The field [autor] is OK because it shows federico but it don't find > >>>>>> anything in the autores.db. > >>>>>> I'm sure I have a field named user and Nombre in the autores.db and also > >>>>>> I'm > >>>>>> sure there are information in this fiels in the record of federico. > >>>>>> > >>>>>> any Idea Why this is happening. > >>>>>> > >>>>>> Thanks > >>>>>> -Rodolfo ------------------------------------------------------------- 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/
John Butler
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:
Quotation Marks in Database (1998)
Adding headers to email (1997)
duplicating cart items (1998)
2 easy questions re: [showif] and [sendmail] (1997)
WebCat with WebTen (1998)
[WebDNA] MACWORLD 09 SanFran (2009)
Echo? (2003)
Email Send Delay (2004)
RE: Formulas.db + Users.db (1997)
Commitdatabase tag (1998)
problems with 2 tags shakur (1997)
Web Delivery Page concept (1997)
WebCat2b15MacPlugin - [protect] (1997)
creating a 60 fields database (1997)
SSL data to/from webcatalog? (2000)
WebCat2: multiple currency support (1997)
If Empty ? (1997)
Pgp&emailer (1997)
Authorize.net settings (2007)
SKU (1997)