Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jai] Database Field Advice

Quote Reply
Re: [jai] Database Field Advice In reply to
It shouldn't be a problem. You'd probably need to add a resource id column in that case also that matches the record the dates are for, then on the modify page you could use the following query to get the dates back:

Code:
my @dates = $DB->table('new_table')->select('date_col', { record_id => $the_id })->fetchall_list;
my $string = join ',', @dates;

Then you have the dates ready to be modified in string format. Then you just split to insert into the database as in the example in my other post.

Let me know if that made no sense :)
Subject Author Views Date
Thread Database Field Advice jai 3857 Jan 21, 2003, 3:33 AM
Post Re: [jai] Database Field Advice
jaspercram 3713 Jan 21, 2003, 7:27 AM
Thread Re: [jai] Database Field Advice
Paul 3712 Jan 21, 2003, 8:44 AM
Thread Re: [Paul] Database Field Advice
jai 3688 Jan 24, 2003, 4:09 PM
Thread Re: [jai] Database Field Advice
Paul 3686 Jan 24, 2003, 4:14 PM
Thread Re: [Paul] Database Field Advice
jai 3683 Jan 24, 2003, 5:35 PM
Thread Re: [jai] Database Field Advice
Paul 3699 Jan 24, 2003, 5:46 PM
Post Re: [Paul] Database Field Advice
jai 3655 Jan 26, 2003, 11:15 PM
Post Re: [Paul] Database Field Advice
jai 3646 Jan 28, 2003, 8:59 PM