baseportal (message board) - free and easy web-based database

baseportal

baseportal message board
Welcome to the baseportal message board... Please read the FAQ.

Selected message:

To the list

Message from Randy M. on 10/13 2003, 15:56 +00:00
EMail: randy1583@yahoo.com

Re: sum field 41/51/50

Your reply:

Name:	EMail: WWW:
Subject:
Text:
Timezone:

Post a new message

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/50

<html><head><title>baseportal - Password Protected Database</title> </head><body bgcolor=ffffff> <br><ul> <table cellpadding=2 cellspacing=0 border=0><tr><td></td><td bgcolor=c0d0f0 align=center> <b>All</b> </td><td></td><td bgcolor=e0e0e0 align=center> <a href="baseportal.pl?name_in=RM&password_in=service&htx=/searsdvdtech/PRODUCTION&cmd=do_add">New</a> </td><td></td><td bgcolor=e0e0e0 align=center> <a href="baseportal.pl?name_in=RM&password_in=service&htx=/searsdvdtech/PRODUCTION&cmd=do_search">Search</a> </td><td></td><td bgcolor=e0e0e0 align=center> <a href="/cgi-bin/baseportal.pl?htx=/searsdvdtech/PRODUCTION">Selection</a> </td><td></td><td bgcolor=e0e0e0 align=center> Modify </td><td></td><td bgcolor=e0e0e0 align=center> Details </td><td></td></tr><tr><td></td><td bgcolor=c0d0f0 colspan=11><table border=0 cellpadding=0 cellspacing=0><tr><td height=1></td></tr></table></td></tr></table><p><p>1 entry in all: <p><table cellpadding=0 cellspacing=0 border=0 bgcolor=f0f0f0><tr><td><table border=0 cellspacing=2 cellpadding=4><tr bgcolor=c0d0f0><td>Action</td><td>date</td><td>Name</td><td>S.O. Number</td><td>41/51/50 (complete)</td><td>15 (part order)</td></tr><tr><td bgcolor=e0e0e0><font size=1><a href="baseportal.pl?name_in=RM&password_in=service&htx=/searsdvdtech/PRODUCTION&cmd=list&range=0,20&Id=1&cmd=do_mod">Modify</a> | <a href="baseportal.pl?name_in=RM&password_in=service&htx=/searsdvdtech/PRODUCTION&cmd=list&range=0,20&Id=1&cmd=del" onclick="return confirm('Are you sure to delete this entry: 2003.10.07,00:00.00#2#+09:00?')">Delete</a></font></td><td align=right bgcolor=e0e0e0><a href="baseportal.pl?name_in=RM&password_in=service&htx=/searsdvdtech/PRODUCTION&cmd=list&range=0,20&cmd=all&Id=1">10/7/2003</a></td><td bgcolor=e0e0e0><a href="baseportal.pl?htx=/searsdvdtech/PRODUCTION&db=/searsdvdtech/names&Id=0&cmd=all&relation=on">RM</a></td><td bgcolor=e0e0e0>93346905</td><td bgcolor=e0e0e0>X</td><td bgcolor=e0e0e0> </td></tr></table></td></tr></table><br><br>

<br><center><font face=arial,helvetica size=1>powered by <a href="http://baseportal.com" target="_blank">baseportal.com</a></font></center><br>

Post a reply

Message from Christoph Bergmann on 10/11 2003, 20:16 +01:00
EMail: info@baseportal.com

Re: sum field 41/51/50

<loop db=yourdatabase> $sum+=$Cash; </loop>
The sum of "Cash" is $sum

where "Cash" is the name of the field you want to know the sum of...

Ok? ;-)

Post a reply

Message from Randy M. on 10/13 2003, 14:25 +00:00

Re: sum field 41/51/50

<html><head><title>baseportal - Password Protected Database</title> </head><body bgcolor=ffffff> <br><ul> <perl>

if($name_in ne "") {
get "Name==!$name_in", "users";

  if($Password ne "" && $Password eq $password_in)
  {
    do_all "", "name_in", "password_in";
  } else
  {
    out "<b>Access denied!</b>";
    $name_in="";
  }

} if($name_in eq "") {

out <<EOF; <h2>Sign in</h2>Please sign in: <form action="/cgi-bin/baseportal.pl?htx=$htx" method="post" enctype="multipart/form-data"> <input type=hidden name="htx=" value="$htx"> <table> <tr><td>Name:</td><td><input type="text" name="name_in="></td></tr> <tr><td>Passwort:</td><td><input type="password" name="password_in="></td></tr> <tr><td></td><td><input type=submit value="Sign in"></td></tr> </table></form>
EOF

}

</perl>

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)

<loop db=production> $sum+=$41/51/50 (complete); </loop>

if i put in lines after the </perl> i get the following errors...

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 ]

if i put the line in before </perl>

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

<html> <loop db=production> $sum+=$41/51/50 (complete); </loop> </html>
still get error...

does the fact that the field is a checked box type of form matter...

thanks for your help

Randy Migacz

Post a reply

Message from Christoph Bergmann on 10/13 2003, 15:58 +01:00
EMail: info@baseportal.com

Re: sum field 41/51/50

<loop db=production code=perl> $sum+=$_loop{"41/51/50"}; </loop>

But: Since you use the password protection example its a bit more complex. This code should work:

<perl> if($name_in ne "") {
get "Name==!$name_in", "users";

  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?

Post a reply

Message from Randy M. on 10/13 2003, 15:56 +00:00
EMail: randy1583@yahoo.com

Re: sum field 41/51/50

Post a reply

Message from Christoph Bergmann on 10/14 2003, 07:31 +01:00
EMail: info@baseportal.com

Re: sum field 41/51/50

Post a reply

Message from Randy M. on 10/14 2003, 13:49 +00:00
EMail: randy1583@yahoo.com

Re: sum field 41/51/50

Post a reply

Message from Christoph Bergmann on 10/14 2003, 16:46 +01:00
EMail: info@baseportal.de

Re: sum field 41/51/50

Post a reply

Message from Randy M. on 10/14 2003, 15:57 +00:00
EMail: randy158@yahoo.com

Re: sum field 41/51/50

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.

Post a reply

Messages from 3300 to 3450:

To the input form

          Re: fixed decimal places from Pouraga on 10/19 2003, 20:39 +00:00
                  Re: fixed decimal places -- It works! Thanks! from Kelly on 10/20 2003, 04:09 +00:00
> message board parameter from edo on 10/15 2003, 12:17 +07:00
> Sorting a rational Field. from Randy on 10/13 2003, 14:43 +00:00
          Re: Sorting a rational Field. from Randy on 10/13 2003, 14:45 +00:00
          Re: Sorting a rational Field. from Christoph Bergmann on 10/13 2003, 15:52 +01:00
          Re: Sorting a rational Field. from Randy on 10/13 2003, 15:04 +00:00
> free member limitations? from Jeff on 10/12 2003, 15:26 +00:00
          Re: free member limitations? from Christoph Bergmann on 10/13 2003, 15:51 +01:00
                  Re: free member limitations? from kerry on 11/22 2003, 18:45 +00:00
> Can I make a membership database? from Ruchir on 10/11 2003, 07:11 +00:00
          Re: Can I make a membership database? from Christoph Bergmann on 10/11 2003, 20:19 +01:00
> pictures from Todd on 10/11 2003, 01:44 +00:00
          Re: pictures from Christoph Bergmann on 10/11 2003, 20:18 +01:00

> 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

> Date on records show yesterdays date when using date format from date on 10/7 2003, 20:35 +00:00
          Re: Date on records show yesterdays date when using date format from Christoph Bergmann on 10/8 2003, 15:29 +01:00
> Christoph, can you fix please? from TheOneRing on 10/7 2003, 05:27 +00:00
          Re: Christoph, can you fix please? from Christoph Bergmann on 10/8 2003, 15:04 +01:00
> Is this a Multi-user databases? from randy on 10/7 2003, 02:31 +00:00
          Re: Is this a Multi-user databases? from Christoph Bergmann on 10/8 2003, 15:25 +01:00
> Checking entries before submitting from Odysseus on 10/5 2003, 21:53 -08:00
          Re: Checking entries before submitting from Christoph Bergmann on 10/6 2003, 17:37 +01:00
> registration forms from Pualani on 10/3 2003, 01:24 -10:00
          Re: registration forms from Christoph Bergmann on 10/3 2003, 16:23 +01:00
          registration forms HELP!!! from marlon on 1/21 2006, 16:37 +08:00
> Need Help from fred on 10/2 2003, 21:45 +00:00
          Re: Need Help from Christoph Bergmann on 10/2 2003, 23:05 +01:00
> IP Check from John on 10/2 2003, 13:52 +00:00
          Re: IP Check from Christoph Bergmann on 10/2 2003, 16:18 +01:00
> Pictures from richard on 10/1 2003, 16:40 -08:00
          Re: Pictures - text field & HTML from Christoph Bergmann on 10/2 2003, 16:15 +01:00
> Password Protection with User Database from Thom on 10/1 2003, 05:26 +00:00
          Re: Password Protection with User Database from Christoph Bergmann on 10/1 2003, 18:19 +01:00
                  Re: Password Protection with User Database from Thom on 10/1 2003, 23:24 +00:00
                          Re: Password Protection with User Database from Christoph Bergmann on 10/2 2003, 16:06 +01:00
                  Re: Password Protection with User Database from Thom on 10/1 2003, 23:38 +00:00
                          Re: Password Protection with User Database from Christoph Bergmann on 10/2 2003, 16:13 +01:00
> PASSWORDS AND DATABASE help plz!!! from Greig on 9/30 2003, 14:34 +00:00
          Re: PASSWORDS AND DATABASE help plz!!! from Christoph Bergmann on 9/30 2003, 15:48 +01:00
> Christoph, where are you? from xagc on 9/28 2003, 22:38 +00:00
          Re: Christoph, where are you? from Christoph Bergmann on 9/30 2003, 04:14 +01:00
                  Re: Christoph, where are you? from xagc on 10/3 2003, 06:04 +00:00
                          Re: Christoph, where are you? from Christoph Bergmann on 10/3 2003, 16:17 +01:00
> can't get "mod" to work... from McQ on 9/28 2003, 16:03 -06:00
          Re: can't get "mod" to work... from Christoph Bergmann on 9/30 2003, 04:10 +01:00
                  Re: can't get "mod" to work... from McQ on 10/15 2003, 01:59 +00:00
> how do i use the sign in password with my data base from Greig on 9/28 2003, 12:43 +00:00
          Re: how do i use the sign in password with my data base from Christoph Bergmann on 9/30 2003, 04:09 +01:00
> User Sign Up and Restrictions from Echobat on 9/27 2003, 13:35 +10:00
          Re: User Sign Up and Restrictions from Kelly on 9/28 2003, 22:26 +00:00
> Working with multiple databases - how to manipulate fields from kelly on 9/23 2003, 19:31 +00:00
          Okay, I got it from Kelly on 9/28 2003, 22:31 +00:00
          Re: Working with multiple databases - how to manipulate fields from Christoph Bergmann on 9/30 2003, 04:08 +01:00
                  Re: Working with multiple databases - how to manipulate fields from Kelly on 10/3 2003, 06:06 +00:00
> Lost Data! from Morgan Madej on 9/22 2003, 21:32 +00:00
          Re: Lost Data! from Christoph Bergmann on 9/30 2003, 04:07 +01:00
                  Re: Lost Data! from Morgan Madej on 10/7 2003, 00:25 +00:00
                          Re: Lost Data! from Christoph Bergmann on 10/8 2003, 14:57 +01:00
> Make a field output wider from Kelly on 9/21 2003, 07:29 +00:00
          Re: Make a field output wider -- I Got it from Kelly on 9/22 2003, 01:24 +00:00
> remove the number showing how many records there are from Andrew on 9/19 2003, 16:10 +00:00
          Re: remove the number showing how many records there are from Christoph Bergmann on 9/30 2003, 04:01 +01:00
> Help with simple restricted search from Steve on 9/18 2003, 13:45 +00:00
          Re: Help with simple restricted search from Christoph Bergmann on 9/30 2003, 03:59 +01:00
> Image link - howto from Dave on 9/18 2003, 12:19 +00:00
> Dreamweaver from Malcolm Hutson on 9/17 2003, 15:25 +00:00
          Re: Dreamweaver from Christoph Bergmann on 9/30 2003, 03:51 +01:00
                  Re: Dreamweaver from Malcolm Hutson on 9/30 2003, 10:40 +00:00
> forum from alexis on 9/17 2003, 03:53 +00:00
          Re: forum from herb on 9/20 2003, 15:03 +00:00
> Imported csv file got truncated twice... from McQ on 9/15 2003, 22:07 -06:00
          Re: csv file - FOUND THE PROBLEM from McQ on 9/19 2003, 09:39 +00:00
> use of other langauges from CLAUDIA FRIGO on 9/15 2003, 10:48 +01:00
          Re: use of other langauges from herb on 9/20 2003, 15:01 +00:00
                  Re: use of other langauges from Rene_Rijnaars on 1/2 2004, 05:39 +00:00
> Modifying existing database fields using an HTML form from Kelly on 9/13 2003, 22:07 -06:00
          Re: Modifying existing database fields using an HTML form from merryn on 9/14 2003, 14:51 +10:00
                  Re: Modifying existing database fields using an HTML form from Kelly on 9/15 2003, 03:32 +00:00
> Outputting one field with commas, not Returns from Matt AG on 9/13 2003, 20:24 +00:00
> Email results? from Justin Seagraves on 9/12 2003, 12:20 -06:00
          Re: Email results? from Christoph Bergmann on 9/30 2003, 15:51 +01:00
> access a data from my database from Prof. R. K. Samanta on 9/11 2003, 13:06 +00:00
> adding a modify link to update an db item from the web page from merryn on 9/10 2003, 23:03 +10:00
          I can't help you but maybe you can help me from Kelly on 9/18 2003, 05:05 +00:00
          Re: adding a modify link to update an db item from the web page from John on 10/2 2003, 13:43 +00:00
                  Re: adding a modify link to update an db item from the web page from Kelly on 10/3 2003, 06:08 +00:00
                          gomychxdf zhkd from atgvnc cxitny on 8/7 2007, 07:07 -12:00
                          csogkifj eftlurw from fqnbk ujvhzb on 8/7 2007, 07:08 -12:00
> Template Alpha search bar goes off page from Morgan Madej on 9/6 2003, 09:58 +01:00
> Form template search problem from Dave on 9/5 2003, 09:43 +00:00
          Re: Form template search problem from herb on 9/20 2003, 15:12 +00:00
> Form template search problem from Dave on 9/4 2003, 14:57 +00:00
> Auto-Reponder to Sign Up from Abby on 9/3 2003, 15:47 -05:00
> Error when importing from Dave on 9/2 2003, 09:06 +00:00
> restrict search fileds from edo on 9/2 2003, 15:24 +07:00
          Re: restrict search fileds from Sander on 9/3 2003, 00:40 +01:00
                  Re: restrict search fileds (got it) from edo on 9/3 2003, 11:18 +07:00
> Date Align from Keith James on 9/1 2003, 15:29 +00:00
          Re: Date Align from Sander on 9/2 2003, 23:38 +00:00
> headers from andrew on 8/29 2003, 16:45 +00:00
> yet, another "date" problem to solve... from dAnUx on 8/29 2003, 04:38 +00:00
          Re: yet, another "date" problem to solve... from franz on 9/2 2003, 11:31 +10:00
                  Thank you so much!!! from dAnUx on 9/2 2003, 03:56 +00:00
                          Re: Thank you so much!!! from Sander on 9/2 2003, 23:33 +00:00
                                  Re: Thank you so much!!! from Sander on 9/2 2003, 23:34 +00:00
> translation from edo on 8/29 2003, 11:27 +07:00
> Removed from Bit on 8/26 2003, 12:30 +07:00
          Re: Removed from Christoph Bergmann on 8/28 2003, 20:16 +01:00
> Directory from Bit on 8/26 2003, 11:49 +07:00
> Single Mom desperatly seeking help from Taryn on 8/25 2003, 17:49 +00:00
> baseport directory link for my website from Trudy on 8/24 2003, 11:49 +00:00
> Restrict ADDING/NEW ENTRY from edo on 8/23 2003, 05:47 +00:00
          Re: Restrict ADDING/NEW ENTRY (GOT IT) from edo on 8/23 2003, 06:32 +00:00
> password protection from Andrew on 8/22 2003, 16:08 +00:00
          Re: password protection from Roy Taylor on 8/26 2003, 15:19 +00:00
> Database Showing Pictures Instead Of Links from richard on 8/21 2003, 11:50 +00:00
          Re: Database Showing Pictures Instead Of Links from richard on 8/21 2003, 12:12 +00:00
> formula field from edo on 8/21 2003, 17:09 +07:00
          Re: formula field from Christoph Bergmann on 8/28 2003, 20:42 +01:00
                  Re: formula field from mike on 10/24 2003, 09:40 +00:00
> Template table colours from Jack on 8/19 2003, 16:06 +00:00
> Error Loop from EComCon1 on 8/19 2003, 09:10 -06:00
          Re: Error Loop from Christoph Bergmann on 8/28 2003, 20:24 +01:00
> Month spelling incorrect from Kelly on 8/19 2003, 05:22 +00:00
          Re: Month spelling incorrect - thanks... from Christoph Bergmann on 8/28 2003, 20:22 +01:00
> our own script files from OGL_Happy5 on 8/15 2003, 12:25 -05:00
          Re: our own script files - depends... from Christoph Bergmann on 8/28 2003, 20:18 +01:00
> linking thumbnails to bigger pictures? from Asha on 8/15 2003, 02:02 +00:00
          Re: linking thumbnails to bigger pictures? from Sander on 8/15 2003, 13:02 +00:00
                  Re: linking thumbnails to bigger pictures? from Asha on 8/16 2003, 03:46 +00:00
                          Re: linking thumbnails to bigger pictures? from edo on 8/23 2003, 09:46 +07:00
> Restrict MODIFY/DELETE from edo on 8/14 2003, 13:11 +07:00
          Re: Restrict MODIFY/DELETE from Sander on 8/14 2003, 15:59 +00:00
                  Re: Restrict MODIFY/DELETE from edo on 8/15 2003, 13:14 +07:00
                          Re: Restrict MODIFY/DELETE from Sander on 8/15 2003, 12:57 +00:00
                                  YES! its work! Re: Restrict MODIFY/DELETE from edo on 8/19 2003, 18:11 +07:00
          Re: Restrict MODIFY/DELETE from Poul Tang on 9/4 2003, 21:05 +00:00
                  Re: Restrict MODIFY/DELETE from Sander on 9/5 2003, 00:17 +00:00
> skip a field from Kelly on 8/13 2003, 20:19 -06:00
> web page from robert chipman on 8/12 2003, 15:00 -05:00
> CONGRATULATION! from edo on 8/11 2003, 12:24 +07:00

<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>

Back to the homepage

baseportal.com