baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from kerru on 11/29 2003, 05:44 +00:00
    EMail: kerry.home@att.net

    Christoph Bergmann ....IMPORTAINT


      ok thats it now every time i signe in i signe in as a new user weather i want to ir not and it seems this son of a b00ch got into my web site to now i have to changr my account and delete mu current account i want every trace of info on me compleatly deleted from your ip ir server what ever it is and dont forget to delete info on my ip so he cant follow me. i cant say what i want to say because i know your not to blame it seems this somone dont like the questions i ask in the message board rad the message he left me that i pasted in another post. i dont need this

    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