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 help


      If 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"=

    Your reply:

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

    Post a new message


 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 help


      I 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
     Post a reply

    Message from Christoph Bergmann on 11/29 2003, 19:18 +01:00
    EMail: info@baseportal.com

    Re: Christoph Bergmann ... I need your help


      You 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?
     Post a reply

    Message from Qasem Alsaleh on 11/30 2003, 14:29 +00:00
    EMail: qalsaleh@hotmail.com

    Re: Christoph Bergmann ... I need your help


      I 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
     Post a reply

    Message from Christoph Bergmann on 11/30 2003, 22:44 +01:00
    EMail: info@baseportal.com

    Re: Christoph Bergmann ... I need your help


      If 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"=

     Post a reply


    Message from Qasem Alsaleh on 12/1 2003, 04:42 +00:00
    EMail: qalsaleh@hotmail.com

    Re: Christoph Bergmann ... I need your help


      I 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 ? :)
     Post a reply

    Message from Christoph Bergmann on 12/1 2003, 18:30 +01:00
    EMail: info@baseportal.com

    Re: Christoph Bergmann ... I need your help


      You 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:

      <loop db=olddatabase code=perl>
      ($day,$month,$year)=split /-/,$_loop{theDate};
      $_loop{theDate}="$year-$month-$day";
      put %_loop, "newdatabase";
      </loop>


      and start it... The new-formatted date should now be saved in the new database... Not tested, I hope it works ;-)

     Post a reply


    Message from Christoph Bergmann on 12/6 2003, 07:26 +01:00
    EMail: info@baseportal.com

    Re: Christoph Bergmann ... I need your help


      Oops, 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:

      <loop db=olddatabase code=perl>
      ($day,$month,$year)=split /\//,$_loop{theDate};
      $_loop{theDate}="$year/$month/$day";
      put %_loop, "newdatabase";
      </loop>

      hope this works ;-)

     Post a reply

    Message from Qasem Alsaleh on 12/11 2003, 06:23 +00:00
    EMail: qalsaleh@hotmail.com

    Re: Christoph Bergmann ... I need your help


      Still 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 :)
     Post a reply
     
 Messages from 3000 to 3150: 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