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:00random?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? |
|
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 limitationHello, 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 |
Message from Christoph Bergmann on 4/28 2003, 21:38 +01:00 EMail: info@baseportal.de Re: Date Range limitationThis 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... |
Message from Warren on 4/29 2003, 11:51 +00:00 WWW: baseportal.com/baseportal/research/WW1 Re: Date Range limitationThank 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 |
Message from Christoph Bergmann on 4/30 2003, 15:22 +01:00 EMail: info@baseportal.de Re: Date Range limitationThanks 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:
...put the form code from above in here.... EOF
- 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 ;-) |
Messages from 3150 to 3300: | To the input form |
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >> |
© baseportal.com. All rights reserved. Terms of use |