Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

Re: [timbo] adding records - two select fields, one updates the other?

Dec 1, 2003, 10:14 AM
604
Staff / Moderator (733 posts)
Dec 1, 2003, 10:14 AM
Views: 10436
Shortcut
Quote Reply
Re: [timbo] adding records - two select fields, one updates the other? In reply to
Just simply create a relationship between Product_Category and Product by using Relationships feature. After that, you can use the code below:

my $results = $DB->table('Product_Category', 'Product')->select({ category_code => 'TA' }, ['Product_Category.product_code', 'product_name'])->fetchall_hashref;

Hope that helps,

TheStone.

B.
Subject Author Views Date
Thread adding records - two select fields, one updates the other? timbo 10651 Nov 18, 2003, 6:41 AM
Thread Re: [timbo] adding records - two select fields, one updates the other? 		assombracao 10483 Nov 19, 2003, 3:02 AM
Thread Re: [assombracao] adding records - two select fields, one updates the other? 		timbo 10507 Nov 27, 2003, 12:07 PM
Thread Re: [timbo] adding records - two select fields, one updates the other? 		604 10435 Nov 27, 2003, 1:30 PM
Thread Re: [TheStone] adding records - two select fields, one updates the other? 		timbo 10449 Nov 27, 2003, 10:45 PM
Thread Re: [timbo] adding records - two select fields, one updates the other? 		604 10491 Nov 28, 2003, 10:43 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other? 		timbo 10465 Nov 29, 2003, 12:47 AM
Thread Re: [timbo] adding records - two select fields, one updates the other? 		604 10436 Dec 1, 2003, 10:14 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other? 		TIF 9875 Nov 9, 2005, 9:02 PM
Thread Re: [TIF] adding records - two select fields, one updates the other? 		604 9879 Nov 10, 2005, 9:45 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other? 		TIF 9865 Nov 10, 2005, 9:01 PM
Post Re: [TIF] adding records - two select fields, one updates the other? 		TIF 9758 Nov 15, 2005, 5:52 AM
Thread Re: [TIF] adding records - two select fields, one updates the other? 		604 9724 Nov 17, 2005, 4:54 PM
Thread Re: [TheStone] adding records - two select fields, one updates the other? 		TIF 9681 Nov 21, 2005, 8:49 PM
Thread Re: [TIF] adding records - two select fields, one updates the other? 		604 9714 Nov 22, 2005, 12:43 PM
Post Re: [TheStone] adding records - two select fields, one updates the other? 		TIF 9779 Nov 25, 2005, 8:58 AM