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 ....IMPORTAINTok 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 |
|
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 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"= |
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 |