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:

Calculating multiple shipping... (1997) Communigate+Webcat (2001) Pop-Up Redirects (1998) Fedora Core 3 and WebDNA (2005) fresh eyes needed. Append won't work. (2000) Help name our technology! (1997) Groups doesn't work (1997) Frames and WebCat (1997) Setting user and password (1999) Nested tags count question (1997) RE:DatabaseHelper (1997) authorize net (2001) version history page for webcat on the SM site? (2000) price formula (1999) Saving Text Areas with Orders (1997) Re[2]: Balancing randomness (2000) Credit Card Number checking (1997) WebCat2b15MacPlugin - [protect] (1997) If search results are blank... (2003) WC2.0 Memory Requirements (1997)