baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from sergey on 4/27 2003, 23:07 +00:00

    random?


      I have made a database of quotes. Now I want these quotes to be randomly generated on my webpage. How do I do that? What code do I use?

    Your reply:

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

    Post a new message


 All messages from this thread: To the list 
    Message from Warren on 4/28 2003, 18:23 +00:00
    WWW: baseportal.com/baseportal/research/WW1

    Date Range limitation


      Hello,

      I am testing a historical database with date values in the range 1914 to 1921.

      I used a field input mask of 'August 21, 2000' and a field output mask of '08/02/2000' and my imported data was translated into incorrect dates e.g 'August 1, 1917' becomes 4/2003/1928 (which seems a form of todays date).

      I then tried a user input mask of 'August 21, 2000' and this produced blank fields. I have now deleted the date column and replaced it with a text one (which is not as good for searching).

      I am wondering if baseportal databases can handle historical dates, because the search form only gives a year range limited to 1920 to 2003.

      Any one have any ideas or experience of this issue?

      Regards,

      Warren Lawless
     Post a reply

    Message from Christoph Bergmann on 4/28 2003, 21:38 +01:00
    EMail: info@baseportal.de

    Re: Date Range limitation


      This is difficult... (Date & Time is always difficult ;-) ).

      Basically baseportal can handle years from 0000 to 9999. The problem is the import function which seems to have a bug concerning Month/Day notations. This will be fixed someday but I cannot promise when, sorry.

      What you can do now: Do you have a possibility to reformat your date values i.g. with Excel? If so pls. convert it to "Day.Month.Year" - then import it and it should work...

      Best regards,

      Christoph...
     Post a reply

    Message from Warren on 4/29 2003, 11:51 +00:00
    WWW: baseportal.com/baseportal/research/WW1

    Re: Date Range limitation


      Thank you very much for your prompt response Christoph.

      I reformated my dates in Excel to 'D.Month.YYYY' and used the same input mask in BasePortal. While the dates did import, on the search form, I am still only allowed select years starting in 1920.

      Also, the dates are displayed as 'YY/Mon/D' instead of 'D/Mon/YY'. Oh well.

      However, I would like to add that your product is incredible in its accessibility and ease of use. You have cut through all the hassle of putting dataabases on the web and I will definitely be telling my friends about the virtues of baseportal. Well done.

      Hopefully when it becomes available, the cost of banner-free space will be affordable for private individuals.

      Regards,

      Warren
     Post a reply

    Message from Christoph Bergmann on 4/30 2003, 15:22 +01:00
    EMail: info@baseportal.de

    Re: Date Range limitation


      Thanks for the kind words ,-)

      > I am still only allowed select years starting in 1920.

      This is just a limitation of the search form. With a little effort you could provide your own search form without limitations. You have to do this:

       - Go to the search page and view the HTML source code. Extract the portion between <form ...> and </form>

       - Insert the following code in front of <do action=all ....> in front of your template:

      <perl>
      if($cmd eq "do_search")
      {
      out <<EOF;
      ...put the form code from above in here....
      EOF

      $_get{cmd}="";
      }
      </perl>

      - Now extend the <option>1920<option>1921...etc. with the years you need, i.g. <option>1919 etc.

      ok? ;-)

      > Also, the dates are displayed as 'YY/Mon/D' instead of 'D/Mon/YY'. Oh well.

      If you change the output format of the date field as well?

      > Hopefully when it becomes available, the cost of banner-free space will be affordable for private individuals.

      Definitely. The lowest price for the rental version in germany is about $3.00 per month ;-)

     Post a reply
     
 Messages from 3150 to 3300: To the input form 
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>


Back to the homepage

© baseportal.com. All rights reserved. Terms of use



baseportal.com