you can always derive the number of points from the field used to store the no of events.
select user, events/5 as 'reward points' from user_event_table;
hope this helps,
Sreekanth Reddy Bandi,
Persistent Systems Pvt. Ltd.,
(http://www.persistent.co.in)
Hi,
You can use built-in functions push and pop on arrays to get the behaviour of a stack.
The following code may help you
my @stack; #its an array
#push some elements
push @stack,1;
push @stack,2;
#get the length of the stack
$len=$#stack+1;
#pop the elements
for ($i=0;$i<$len;$i++) {...
hi,
look alter table syntax. you can add/delete or modify column definition.
hth,
sreekanth Sreekanth Reddy Bandi,
Persistent Systems Pvt. Ltd.,
(http://www.persistent.co.in)
It looks like, you need to convert one xml(gml/pc) doc into another xml doc. You can use XSLT to do the same. Sreekanth Reddy Bandi,
Persistent Systems Pvt. Ltd.,
(http://www.persistent.co.in)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.