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 Sander on 9/2 2003, 23:33 +00:00

Re: Thank you so much!!!

<perl> $this_month=datum("jetzt", "Monat0"); </perl> <loop db=birth Month=~$this_month>
Name: $Name 
Date: $Birthday

</loop>

in this case <loop> fetchs only the relevant entrys of this month. its more performant in big databases.

Sander

Your reply:

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

Post a new message

All messages from this thread:

To the list

Message from dAnUx on 8/29 2003, 04:38 +00:00
EMail: duteau@email.com

yet, another "date" problem to solve...

out datum("jetzt", "monat0")

This gives me 08 (which is te current month, August) but I can´t incorporate this perl code into the query. I have prove something like this (and many, many variants):

<loop db=birth&monat= ANYTHING>

In ANYTHING I have proved really anything: perl codes, scripts and variables from other databases...

I need your help ¿How can I do this?

Daniel

Post a reply

Message from franz on 9/2 2003, 11:31 +10:00
EMail: krauth@web.de

Re: yet, another "date" problem to solve...

<loop db=birth script=perl> if ($monat == (datum("jetzt", "monat0")){ out "Name: " <$FIELDNAME CONTAINING NAME > " "; out "Date: " <$FIELDNAME CONTAINING DATE > " "; } </loop>

note: its not testet!

Post a reply

Message from dAnUx on 9/2 2003, 03:56 +00:00
EMail: duteau@email.com

Thank you so much!!!

<loop db=birth code=perl> if ($Month == (datum("Jetzt", "Monat0"))){ out "Name: ", ($Name), " "; out "Date: ", ($Birthday), " "; } </loop>

Fantastic, great... thank you...

dnx

Post a reply

Message from Sander on 9/2 2003, 23:33 +00:00

Re: Thank you so much!!!

<perl> $this_month=datum("jetzt", "Monat0"); </perl> <loop db=birth Month=~$this_month>
Name: $Name 
Date: $Birthday

</loop>

in this case <loop> fetchs only the relevant entrys of this month. its more performant in big databases.

Sander

Post a reply

Message from Sander on 9/2 2003, 23:34 +00:00

Re: Thank you so much!!!

<loop db=birth Month~=$this_month>

Post a reply

Messages from 3300 to 3450:

To the input form

          Re: User moderation from Christoph Bergmann on 10/27 2003, 07:30 +01:00
> membership database with pictures of members. How? from James on 10/20 2003, 13:12 +00:00
          Re: membership database with pictures of members. How? from Christoph Bergmann on 10/27 2003, 07:31 +01:00
> ***POST A DATE from mike on 10/20 2003, 05:08 +00:00
          Re: ***POST A DATE from TheOneRing on 10/24 2003, 19:30 +00:00
                  Re: ***POST A DATE from mike on 10/26 2003, 09:46 +00:00
                          Re: ***POST A DATE from TheOneRing on 10/26 2003, 16:14 +00:00
> math in your baseportal from mike on 10/18 2003, 07:55 +00:00
          Re: math in your baseportal from Pouraga on 10/19 2003, 20:28 +00:00
          Re: one database and two forms from mike on 10/20 2003, 04:22 +00:00
          Re: math in your baseportal from mike on 10/20 2003, 04:37 +00:00
> To: Christoph Bergmann from Qasem A. Alsaleh on 10/17 2003, 01:04 +03:00
> fixed decimal places from Kelly on 10/16 2003, 05:59 +00:00
          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

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

Back to the homepage

powered in 0.02s by baseportal.com
Get your own Web Database - for FREE!