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 alookup.----- Original Message -----From: Gyuri
To: WebCatalog Talk Sent: Monday, November 11, 2002 3:47 PMSubject: lookup problem> Hi, All,>> I run into a strange problem:>> For some reason this doesn't work,>> [text]title=[lookupdb=^oo/arc/Goods.db&value=a01234&lookInField=sku&returnField=DB_Title¬Found=][/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 alookup.----- Original Message -----From: Gyuri To: WebCatalog Talk Sent: Monday, November 11, 2002 3:47 PMSubject: lookup problem> Hi, All,>> I run into a strange problem:>> For some reason this doesn't work,>> [text]title=[lookupdb=^oo/arc/Goods.db&value=a01234&lookInField=sku&returnField=DB_Title¬Found=][/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)