Update the DBS - Posted (899 Views)
Advanced Member
JJenson
Posts: 2121
2121
I am trying to write 2 siple scripts to go into the alternate mod setup. the first one is just supposed to keep adding one to the number everytime it is downloaded. would that be something like this?
[ALTER] MEMBERS
ADD#M_DOWNLOADED#int#NULL#1
[END]
The second one is just supposed to keep the last date something was downloaded would that be something like this?
[ALTER] MEMBERS
ADD#M_LASTDOWNLOAD#int#NULL#9\7\07
[END]
I don't want to add it in till I am sure but I think it is something like this?
Thanks<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Advanced Member
JJenson
Posts: 2121
2121
Nevermind got it the first one worked and the 2nd needed to be changed to

[ALTER] MEMBERS
ADD#M_LASTDOWNLOAD#VARCHAR(50)##
[END] <
Posted
Support Moderator
Shaggy
Posts: 6780
6780
You only really need 14 characters to hold a date; yyyymmddhhmmss.
<
Search is your friend “I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Posted
Advanced Member
JJenson
Posts: 2121
2121
Thanks Shaggy smile<
Posted
Advanced Member
JJenson
Posts: 2121
2121
No worries I ended up getting it. smile<
 
You Must enter a message