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:

    
  1. Re: lookup problem (Rob Marquardt 2002)
  2. Re: lookup problem (Inkblot Media 2002)
  3. lookup problem (Gyuri 2002)
  4. Re: lookup problem (John Butler 2000)
  5. Re: lookup problem (Rodolfo de la Garza 2000)
  6. Re: lookup problem (John Butler 2000)
  7. Re: lookup problem (Rodolfo de la Garza 2000)
  8. Re: lookup problem (Rodolfo de la Garza 2000)
  9. Re: lookup problem (John Butler 2000)
  10. Re: lookup problem (Kenneth Grome 2000)
  11. lookup problem (Rodolfo de la Garza 2000)
  12. lookup problem (Rodolfo de la Garza 2000)
  13. Price lookup problem - was Re: Cart questions (Paul Winchester 1997)
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:

Fw: [SQL] and [index] mystery solved (2001) DON'T use old cart file! (1997) Just testing (2003) serial number generation (1997) Frames and WebCat (1997) [WebDNA] HTTP crashes (2010) So many lookers, hey smith micro (2003) Starting WebCat under linux (2000) My solution... (1996) [showif [numfound]=0]? (2000) RE: OK, here goes... (1997) suffix mapping for NT? (1997) WCS Newbie question (1997) NetSplat and WebCat2 (1997) [WebDNA] Timestamp Converter (2015) Encrypting userid for email (2000) Remove from list server (1997) RE: Automatic Forwarding using WebCat (1997) RE: Displaying Location (1997) Return records from another (1997)