baseportal | ||
Start | ||
baseportal message board | |
Welcome to the baseportal message board... Please read the FAQ.
|
Selected message: | To the list |
Message from Christoph Bergmann on 11/30 2003, 22:44 +01:00 EMail: info@baseportal.com Re: Christoph Bergmann ... I need your helpIf you only want to search for the year then you could just use a field of type "option" and enter 2000, 2001, 2002 etc. (the years you need). Anyway, the problem seems to be that you import the data and its in a different format. Do you have the possibility to reformat the date so that it looks like "Year-Month-Day"= |
|
All messages from this thread: | To the list |
Message from Qasem Alsaleh on 11/29 2003, 16:10 +00:00 EMail: qalsaleh@hotmail.com Christoph Bergmann ... I need your helpI am trying to search my databse by the (Year only) and NOT the (full date) to get the result filtered to the requested year.But even if I am entering the full date (e.g. 28/05/03) I dont get the result for that particular date but rather I get results for both 28/05/03 and 28/01/03 (both have the 28th day of a month). If you dont mind to go to the page I am testing: http://baseportal.com/cgi-bin/baseportal.pl?htx=/qalsaleh/CME_Copy&cmd=do_search and view the source code of the page. You can use the following examples to test: TheDate: (e.g. I need only year 2002) Doctor Name:(please enter: Qasem A. Alsaleh) (OR) CME No: (please enter: 10118/M) I greatly appreciate your kind help. Qasem Alsaleh |
Message from Christoph Bergmann on 11/29 2003, 19:18 +01:00 EMail: info@baseportal.com Re: Christoph Bergmann ... I need your helpYou defined the appropriate field "TheDate" as a normal "text" field (sorted as a "number") - this can't work... You should use the "Date" field type instead... Or, alternately, sort this field as "text" and write the date like: Year/Month/Day... Ok? |
Message from Qasem Alsaleh on 11/30 2003, 14:29 +00:00 EMail: qalsaleh@hotmail.com Re: Christoph Bergmann ... I need your helpI tried changing the date to (Date) format field but I got strange results where I got all the date fields fixed in a certain date (30.11.2003). I reloaded the data and tried changing to text field format sorted as text but I am not getting any result based on date input in search mode. The other thing is that I need to search by the YEAR only, not a full date i.e.not to search the date as e.g. 30.11.2002 but rather as 2002 only. I really appreciate your help and appologize for the inconvenience. Qasem Alsaleh |
|
Message from Qasem Alsaleh on 12/1 2003, 04:42 +00:00 EMail: qalsaleh@hotmail.com Re: Christoph Bergmann ... I need your helpI have reformated the data (which is an imported one)so that the date field looks now like "Year-Month-Day" as you suggested. To enter the date as year only using a new field will be very difficult because this means that I have to re-enter the data again. What shall I do next ? :) |
Message from Christoph Bergmann on 12/1 2003, 18:30 +01:00 EMail: info@baseportal.com Re: Christoph Bergmann ... I need your helpYou could baseportal let it do for you: ,-) - Copy the existing database (in "Management") - Delete all content of the new database (in "Management") - Create a page with this code:
and start it... The new-formatted date should now be saved in the new database... Not tested, I hope it works ;-) |
Message from Qasem Alsaleh on 12/1 2003, 19:26 +00:00 EMail: qalsaleh@hotmail.com Re: Christoph Bergmann ... I need your helpI tried what you have suggested and created a copy of the existing database (name: CME_Copy_Copy), cleared it and added the text you mentioned in the page related to the (copy) database (page address: http://baseportal.com/cgi-bin/baseportal.pl?htx=/qalsaleh/CME_Copy_Copy) but it did not work. I am sure that the cause is my ignorance of perl language !! |
Message from Christoph Bergmann on 12/6 2003, 07:26 +01:00 EMail: info@baseportal.com Re: Christoph Bergmann ... I need your helpOops, did you changed the date format of the first field? I thought "-" was the delimiter, now it is "/" - then you must use the following code:
hope this works ;-) |
Message from Qasem Alsaleh on 12/11 2003, 06:23 +00:00 EMail: qalsaleh@hotmail.com Re: Christoph Bergmann ... I need your helpStill not working. Probably I am putting something wrong in the code. I am thinking of going to your first suggestion of having a separate "year" field. I am working on my database for that. Thank you so much for your kind help and your kind effort :) |
Messages from 3000 to 3150: | To the input form |
> Christoph Bergmann ... I need your help from Qasem Alsaleh on 11/29 2003, 16:10 +00:00 Re: Christoph Bergmann ... I need your help from Christoph Bergmann on 11/29 2003, 19:18 +01:00 Re: Christoph Bergmann ... I need your help from Qasem Alsaleh on 11/30 2003, 14:29 +00:00 |
Re: Christoph Bergmann ... I need your help from Christoph Bergmann on 11/30 2003, 22:44 +01:00 |
Re: Christoph Bergmann ... I need your help from Qasem Alsaleh on 12/1 2003, 04:42 +00:00 Re: Christoph Bergmann ... I need your help from Christoph Bergmann on 12/1 2003, 18:30 +01:00 Re: Christoph Bergmann ... I need your help from Qasem Alsaleh on 12/1 2003, 19:26 +00:00 Re: Christoph Bergmann ... I need your help from Christoph Bergmann on 12/6 2003, 07:26 +01:00 Re: Christoph Bergmann ... I need your help from Qasem Alsaleh on 12/11 2003, 06:23 +00:00 |
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >> |
© baseportal.com. All rights reserved. Terms of use |