baseportal | ||
Start | ||
baseportal message board | |
Welcome to the baseportal message board... Please read the FAQ.
|
Selected message: | To the list |
Message from date on 10/7 2003, 20:35 +00:00 EMail: searsdvdtech@yahoo.com Date on records show yesterdays date when using date formatThis is my second day using this ...it is great idea. i have been using quickbase. Anyway.. I selected date format for the field Date.. a another great idea.. LOL .. and used the modify and create options . Selected time for central USA.. but all records modified today show yesterdays date.. changed time zone to Tokyo.. and now shows date as today. |
|
All messages from this thread: | To the list |
Message from Randy M. on 10/9 2003, 21:58 +00:00 EMail: Randy1583@yahoo.com sum field 41/51/50What needs to be added to sum field 41/51/50 (complete) im not sure if i need java script, HTML code. i know excel , but do not know web design. Thanks Randy
|
Message from Christoph Bergmann on 10/11 2003, 20:16 +01:00 EMail: info@baseportal.com Re: sum field 41/51/50In baseportal the fields have names ;-) So, if you want to calculate the sum of a field you need s.th. like this:
where "Cash" is the name of the field you want to know the sum of... Ok? ;-) |
Message from Randy M. on 10/13 2003, 14:25 +00:00Re: sum field 41/51/50thank you for the help... since i have used the password protect type of data base.. does this affect the access of the loop ....here is the code applied that works good so far...
if($Password ne "" && $Password eq $password_in) { do_all "", "name_in", "password_in"; } else { out "<b>Access denied!</b>"; $name_in=""; }
end of woking code ... now here is what i have tried.... here is the code i need to apply to get the total (sum) of field 41/51/50 (complete)
Reason: The specified database is not approved for the desired access. Solution: Log into your private domain, choose the appropriate database, click on 'Management' and change the rights settings. ] [ Error: Permission denied to read /searsdvdtech/production Reason: The specified database is not approved for the desired access. Solution: Log into your private domain, choose the appropriate database, click on 'Management' and change the rights settings. ] [ Error: Unable to open /usr/local/httpd/baseportal_NOACCESS/searsdvdtech/production ] [ Error: Unable to lock /searsdvdtech/production ]
i get the following error [ Error: Perl error in : glob trapped by operation mask at (eval 268) line 32. ] so i tried to put the code after </perl> like this
does the fact that the field is a checked box type of form matter... thanks for your help Randy Migacz |
Message from Christoph Bergmann on 10/13 2003, 15:58 +01:00 EMail: info@baseportal.com Re: sum field 41/51/50Oops, "41/51/50" is the name of your field? I didn't thought that... ;-) I thought you meant the numbers of rows (like excel does it). Ok, in this case it should look like this:
But: Since you use the password protection example its a bit more complex. This code should work:
if($Password ne "" && $Password eq $password_in) { do_all "", "name_in", "password_in"; get "Id==*"; while(get_next) { $sum+=$_loop{"41/51/50"}; } out "sum of field 41/51/50: $sum"; } else { out "<b>Access denied!</b>"; $name_in=""; } ...etc. Ok? |
Message from Randy M. on 10/13 2003, 15:56 +00:00 EMail: randy1583@yahoo.com Re: sum field 41/51/50Thanks for the quick reply. Should i apply new code to both the db:Adress and db:production. Randy M. |
Message from Christoph Bergmann on 10/14 2003, 07:31 +01:00 EMail: info@baseportal.com Re: sum field 41/51/50This depends on what you want ;-) Do you have a field named "41/51/50" in both databases? Do you want the sum of this field from both databases? |
Message from Randy M. on 10/14 2003, 13:49 +00:00 EMail: randy1583@yahoo.com Re: sum field 41/51/50I do not have 41/51/50 fields in both databases. I noticed that since i used the password protected type database, that the page info for both the adresses database and the page info for the production database are the same. These datbases are relational for the user id and password lookup in the adresses database in order to password protect production database. I have tried to insert the aditional codes for the sum of the field 41/51/50 in the production database, but still have an error. So i thought i would ask if i need to apply code to both the adresses datbase and the production database, since they both have the same page info , before i tried it out. |
Message from Christoph Bergmann on 10/14 2003, 16:46 +01:00 EMail: info@baseportal.de Re: sum field 41/51/50Can you pls post the link to the page? ;-) |
Message from Randy M. on 10/14 2003, 15:57 +00:00 EMail: randy158@yahoo.com Re: sum field 41/51/50ok id RM password service. all i want to do is output total of fields named :"41/51/50", "15", "16", "O" by fields "name"(this field is relational) to db names. http://baseportal.com/cgi-bin/baseportal.pl?htx=/searsdvdtech/PRODUCTION. http://baseportal.com/cgi-bin/baseportal.pl?htx=/searsdvdtech/names. http://baseportal.com/cgi-bin/baseportal.pl?htx=/searsdvdtech/adresses. Thanks for your time in looking into this matter, i hope it doesn't take too much of your time.. i truely appreciate it . Randy M. |
Messages from 3300 to 3450: | To the input form |
> sum field 41/51/50 from Randy M. on 10/9 2003, 21:58 +00:00 Re: sum field 41/51/50 from Christoph Bergmann on 10/11 2003, 20:16 +01:00 Re: sum field 41/51/50 from Randy M. on 10/13 2003, 14:25 +00:00 Re: sum field 41/51/50 from Christoph Bergmann on 10/13 2003, 15:58 +01:00 Re: sum field 41/51/50 from Randy M. on 10/13 2003, 15:56 +00:00 Re: sum field 41/51/50 from Christoph Bergmann on 10/14 2003, 07:31 +01:00 Re: sum field 41/51/50 from Randy M. on 10/14 2003, 13:49 +00:00 Re: sum field 41/51/50 from Christoph Bergmann on 10/14 2003, 16:46 +01:00 Re: sum field 41/51/50 from Randy M. on 10/14 2003, 15:57 +00:00 |
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >> |
© baseportal.com. All rights reserved. Terms of use |