Re: [mv] category conversion

["Bill Randle" <billr@exgate.tek.com>]

******    message to minivend-users from "Bill Randle" <billr@exgate.tek.com>     ******

With 34 entries (10-340), I'd probably just put them in a seperate file
(db) and lookup the title using the category number as the index.
	[on-change]
	...
	[data table="cattitles" colum="title" key="[loop-data products cat]"]
	...
	[/on-change]

where "cattitles" is a simple two column db withe the category number
and title:
	code	title
	10	Supplies
	20	Hardware
	etc.

and [loop-data products cat] picks up the category number picked from the
database record currently being processed.

Alternatively, you put in all inline by initializing a perl hash table
with the category names and titles. It would be faster (probably not
really an issue), not as easy to add new categories to as the
seperate db.

    -Bill


On Jul 9,  5:40am, Victor Nolton wrote:
} Subject: [mv] category conversion
} ******    message to minivend-users from Victor Nolton <ven@pragakhan.com>
    ******
}
} customer has given me a database. Each category is a number
} (10,20,30,...all the way up to 340).
}
} I want to do a browse page and of course a custom results page.
}
} How can I customize the pages so that [on-change] i can convert the
} 10,20.. into titles like Supplies, Hardware, Software.
}
} I dont want it to say
}
}          10
} Mousepad
} wristpad
}
}         20
} monitor
} keyboard
}
} I'd like the 10 to be converted to  Supplies, 20 to be converted to hardware.
} I DO NOT want to do a bunch of If category eq "10" then print
} Supplies (not real code...
}
} Suggestions?
}
} Ven
-
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