Re: [mv] Problem with Arbitrary database

[bjordan@sover.net (bob jordan)]

******    message to minivend-users from bjordan@sover.net (bob jordan)     ******

On Nov 1,  1:21pm, Ashimava Bhowmick wrote:
> Subject: [mv] Problem with Arbitrary database
> ******    message to minivend-users from "Ashimava Bhowmick"
<ashimava@hotmail.com>     ******
>
> Since I didn't hear from anyone -- I guess my problem is too simple to be
> paid heed to -- but then, I'm stuck on this.. Someone please please please
> -- help me out.
>
> I have an arbitrary database group.asc
> group.asc has fields grp, category .. it goes like
>
> grp category
> electronics soundsystem
> electronics TV
> electronics camera
> ....

Unless specified otherwise, the first field (column) must be a unique key.
If you have multiple instances of the same key, the last value defined is the
value used - in your case, camera.

Either add a key field (code as in products.asc) or reverse your fields
since category appears to be unique.  Either of these would work with your
existing searchspec:

code grp         category
1    electronics soundsystem
2    electronics TV
3    electronics camera

or

category    grp
soundsystem electronics
TV          electronics
camera      electronics


- bj
>
> the catalog.cfg has an entry
> Database group group.asc TAB
>
> my search goes like
> [area scan
> 	 fi=group.asc
> 	 sf=grp
> 	 se=electronics
>          sp=results2
> 	 ]"
>
> and the results2 page has
> [search-list]
> <B>[item-increment].</B>
> [item-data group category]<BR>
>
> [/search-list]
>
> But My output comes as
> 1.camera
> 2.camera
> 3.camera
>
> Instead of
> 1.soundsystem
> 2.TV
> 3.camera
>
> I've even tried using
> [search-list]
> <B>[item-increment].</B>
> [data group category electronics]<BR>
> [/search-list]
>
> but that too shows the same results. I'll really appreciate if
> someone helped me out with this
> thanks
> Ashimava
>
> Minivend version that I use is 3.14..
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.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
>-- End of excerpt from Ashimava Bhowmick


-
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