Re: [mv] displaying key value from arbitrary database

[Ed LaFrance <edlafrance@printexusa.com>]

******    message to minivend-users from Ed LaFrance <edlafrance@printexusa.com>     ******

>******  Ramsey French <rammjet@mindspring.com> WROTE     ******
>
>[item-code]
>
- AND -

****** "Gideon van Gelder" <gideon@swingmaster.nl>   WROTE  ******

That's funny.

Your key-column is probably called "code" and so you can access
that column by [data base=mybase col=code key=whatever] or
[item-data myfile code], just like any other column in the db.

This should work, I'm sure.

AND THE WINNER IS RAMSEY FRENCH!
[item-code] dispays the contents of the key field in an arbitrary database.
The column name in the database does not have to be "code"; I tried it with
several fieldnames for my key column and it works everytime.  Apparently
[item-code] is a *universal* reference to the key field of any database
currently being read.  I did not gleen this from the docs.  NONE of the
other syntaxes work: [item-data myfile code], [item-data code], [item-data
myfile keyfieldname].  I didn't test [data base=mybase col=code
key=whatever] because it does not fit the context of my application.

Thanks for your input - hope this saves someone else some time!

- Ed L.



>On 1/31/00 6:05 PM, Ed LaFrance at edlafrance@printexusa.com wrote:
>
>> ******    message to minivend-users from Ed LaFrance
>> <edlafrance@printexusa.com>     ******
>>
>> Can anyone explain how to display the key value from a record in an
>> arbitrary database?  I have a page that returns the results of an [area
>> scan...] tag and lists some of the contents of a database using [item-data
>> filename fieldname] tags for each iteration of the search list.  Everything
>> works fine, except that the contents of each record's key field don't
>> display using this method.  Does anyone know why?  Is there a special
>> syntax for displaying the key field of an arbitrary database. I have
>> scanned and searched the vast docs and list archive and have not come up
>> with anything definitive.  My ISP is running a UNIX server with Perl 5.004
>> and Sun OS 5.7, I am running Minivend 3.12.
>>
>> Thanks for any input!
>>
>> - Ed L.
>>
>> -
>> PRINTEX Marking Technologies
>> 12113 Kirkham Rd.
>> Poway, CA  92064  U.S.A.
>> (858) 513-2418
>> (800) 982-1928
>> (858) 513-2419 fax
>> edlafrance@printexusa.com
>> http://www.printexusa.com
>>
>>
>> -
>> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>> email with 'UNSUBSCRIBE minivend-users' in the body to
>>Majordomo@minivend.com.
>> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list


-
PRINTEX Marking Technologies
12113 Kirkham Rd.
Poway, CA  92064  U.S.A.
(858) 513-2418
(800) 982-1928
(858) 513-2419 fax
edlafrance@printexusa.com
http://www.printexusa.com


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list