Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [MJ_] How to obtain the value of paylogs_time.

Quote Reply
Re: [MJ_] How to obtain the value of paylogs_time. In reply to
Hi,

Try this:

paiement_id
Code:
sub {
my $table = $DB->table('Payments');
my $cond = GT::SQL::Condition->new(payments_linkid => 'LIKE' => $_[0]);
$table->select_options("ORDER BY payments_last DESC");
return $table->select('payments_id' => $cond)->fetchrow;
}

..and call with:

<%set paiement_id = paiement_id($ID)%>

..then add a new global:

get_payment_time
Code:
sub {
return $DB->table('PaymentLogs')->select( ['paylogs_time'] , { payments_id => $_[0] } )->fetchrow || die $GT::SQL::error;
}


..and call with:

<%set payment_id = get_payment_time($paiement_id)%>

That should hopefully work :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread How to obtain the value of paylogs_time. MJ_ 7586 May 25, 2009, 10:52 AM
Thread Re: [MJ_] How to obtain the value of paylogs_time.
Andy 7432 May 25, 2009, 11:30 AM
Thread Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7402 May 25, 2009, 12:07 PM
Thread Re: [MJ_] How to obtain the value of paylogs_time.
Andy 7416 May 26, 2009, 12:21 AM
Thread Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7414 May 26, 2009, 3:40 AM
Thread Re: [MJ_] How to obtain the value of paylogs_time.
Andy 7458 May 26, 2009, 3:47 AM
Thread Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7374 May 26, 2009, 4:48 AM
Thread Re: [MJ_] How to obtain the value of paylogs_time.
Andy 7410 May 26, 2009, 5:10 AM
Thread Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7367 May 26, 2009, 5:32 AM
Thread Re: [MJ_] How to obtain the value of paylogs_time.
Andy 7423 May 26, 2009, 5:35 AM
Thread Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7390 May 26, 2009, 6:03 AM
Thread Re: [MJ_] How to obtain the value of paylogs_time.
Andy 7369 May 26, 2009, 6:05 AM
Thread Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7381 May 26, 2009, 6:10 AM
Thread Re: [MJ_] How to obtain the value of paylogs_time.
Andy 7453 May 26, 2009, 6:12 AM
Post Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7354 May 26, 2009, 6:22 AM
Thread Re: [Andy] BUG ? or How to obtain the value of paylogs_time.
MJ_ 7305 May 27, 2009, 7:01 AM
Thread Re: [MJ_] BUG ? or How to obtain the value of paylogs_time.
Andy 7359 May 27, 2009, 7:08 AM
Post Re: [Andy] BUG ? or How to obtain the value of paylogs_time.
MJ_ 7302 May 27, 2009, 7:23 AM
Post Re: [Andy] How to obtain the value of paylogs_time.
MJ_ 7395 May 25, 2009, 12:49 PM