Re: [mv] displaying key value from arbitrary database

["Gideon van Gelder" <gideon@swingmaster.nl>]

******    message to minivend-users from "Gideon van Gelder" <gideon@swingmaster.nl>     ******

I'm sorry.
I just re-read my e-mail and realised that was really stupid
of me: why would you pull the item-code with the USE of KEY?
If you know key, you obviously do not need to pull it from the DB.

That's what you get for answering emails in the middle of the night...

-Gideon


> ******    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


-
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