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 3853 Jan 21, 2003, 3:33 AM
Post Re: [jai] Database Field Advice
jaspercram 3710 Jan 21, 2003, 7:27 AM
Thread Re: [jai] Database Field Advice
Paul 3709 Jan 21, 2003, 8:44 AM
Thread Re: [Paul] Database Field Advice
jai 3685 Jan 24, 2003, 4:09 PM
Thread Re: [jai] Database Field Advice
Paul 3682 Jan 24, 2003, 4:14 PM
Thread Re: [Paul] Database Field Advice
jai 3680 Jan 24, 2003, 5:35 PM
Thread Re: [jai] Database Field Advice
Paul 3695 Jan 24, 2003, 5:46 PM
Post Re: [Paul] Database Field Advice
jai 3652 Jan 26, 2003, 11:15 PM
Post Re: [Paul] Database Field Advice
jai 3643 Jan 28, 2003, 8:59 PM