SkipVought:
When I do F2, I can see the right date in the field, when I press 'Enter', it goes back to the number.
anotherhiggins:
Tried this, but to no effect. I noticed that any format I want to apply to any cell on this sheet is not working.
I will assume that something is 'dead' o this...
It meanS that I already reformated so many times.... but it doesn't do anything.
Well, I make it work. How I did iit....
I cut and paste the whole sheet and reinserted in another sheet. By miracle it is OK!!!!
I really would like to know why!
Thanks for your help, just got luky on my side...
Nothing.
If I type someting that looks like a date (ex:05/02/06) it will convert to the number.
If I type a number, it keep the number without try to convert to a date in thr uppper windows.
I use Excel all the time, but I never had this
Well,
I did what you said before and after you told me, but this doen't do anyhing!
This is very strange as usually it works without any problems.
For now my date 6/22/2007 will only shows as 39255. Whatever I do to it- Custom formatting, date formatting, etc.
It will show me the correct date tho.
I have a column with dates. They should show a date formates as 02/03/07, but they show a number such as 345664 (this is not the real corresponding number).
If I click on the field the right date will show in the top window, but not in the column field.
I went to reset the column formatting, and...
Oh!
Thanks for the full sample - i will try this shortly.
This PHP is new to me since i only use ASP. Therefore some obvious things are not always obvious.
Thanks again
Personnally PHP doesn't give me anything better than I have now. It is just interresting to see how it works, but a lot of work when I do not know all the little ways around.
For ex. I have a table with 120 name. I have a query that retrieve all the names(120).
I have a While ... statement that shows the name in the browser.
Each time if I use the statement mysql_num_rows($result), it will show that I have 120 names, but I only print 119 in the browser.
Cannot...
r937-
You are right, I just checked that I can use the Limit statement for my other db in ASp. Never have to use it before and I thought this have to do with MySql or PHP.
Thanks again.
I have a statement :
select * from T_Adherent limit 1, 10 where ....
It seems to be wrong.
Is there a way to have the limit statement followed by a where statement. If not how can I limit the query with a where statement?
thanks
I have a select query and I am using the == mysql_num_rows($result) that give a value that is always the number of row I see + 1.
How can I correct this?
thanks
I noticed that when you have a flash design in an HTML page, you need to first click on it to activate buttons and others. If you don't the flash is not responding.
Is there a way to avoid this ?
Thanks in advance
I need to convert an exsting MS Access db to an MySQL database.
The MySql is on a server maintained by my ISP. The Access db is on my PC.
What would be the best way to do this?
Thanks in advance for any, help, links or others.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.