Re: lookup problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45108
interpreted = N
texte = Lookups are case-sensitive. Are the fields correct?Meaning that DB_Title, db_title, and DB_TITLE are all different fields to a lookup.----- Original Message ----- From: Gyuri
To: WebCatalog Talk Sent: Monday, November 11, 2002 3:47 PM Subject: lookup problem > Hi, All, > > I run into a strange problem: > > For some reason this doesn't work, > > [text]title=[lookup db=^oo/arc/Goods.db&value=a01234&lookInField=sku&returnField=DB_Title¬Fou nd=][/text] > > > While this does: > > [search db=^oo/arc/Goods.db&EQskuDATA=a01234&max=1] > [foundItems] > [text]title=[DB_Title][/text] > [/founditems] > [/search] > > Are these my eyes, is there any thing I don't see here? > > Thx, > Gy > > ps: it should return Desk, Plain > > -- > Gyuri Ordody > Objects Online, Inc. > > > > ------------------------------------------------------------- > 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:
Lookups are case-sensitive. Are the fields correct?Meaning that DB_Title, db_title, and DB_TITLE are all different fields to a lookup.----- Original Message ----- From: Gyuri To: WebCatalog Talk Sent: Monday, November 11, 2002 3:47 PM Subject: lookup problem > Hi, All, > > I run into a strange problem: > > For some reason this doesn't work, > > [text]title=[lookup db=^oo/arc/Goods.db&value=a01234&lookInField=sku&returnField=DB_Title¬Fou nd=][/text] > > > While this does: > > [search db=^oo/arc/Goods.db&EQskuDATA=a01234&max=1] > [founditems] > [text]title=[DB_Title][/text] > [/founditems] > [/search] > > Are these my eyes, is there any thing I don't see here? > > Thx, > Gy > > ps: it should return Desk, Plain > > -- > Gyuri Ordody > Objects Online, Inc. > > > > ------------------------------------------------------------- > 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/
Inkblot Media
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:
return missing item (was:WebCat Sales) (1997)
Sort Order on a page search (1997)
[WebDNA] Open Source CMS (2012)
Version f1 status (1997)
searching twice on same field (1998)
Stopping bad HTML propagation ? (1997)
trouble updating records in database (1998)
frames & carts (1997)
NT vs Mac (1997)
Unexceling (was I need a smart quote...) (1999)
[WebDNA] No more SQL in 7.1? (2012)
WebCatalog/WebMerchant 2.1 (1998)
setting a cookie for the whole server (2004)
Execute Applescript (1997)
Text data with spaces in them... (1997)
Multi-processor Mac info ... (1997)
Bug Report, maybe (1997)
WebCat2: Items xx to xx shown, etc. (1997)
WebDNA Server (2007)
Comments in db? (1997)