Search results for query: *

YEEEESSSSS!!! http://www.restorer2000.com This program is excellent and I now have all my data back. I really appreciate the link. I had searched for hours and tried lots of dubious programs but that one is excellent and worth the price. Recommended for anyone with similar problems. I've...

Hi, Hope someone can help, think I may have lost lots of data. I needed to create some more space for Vista SP1 so I thought I would delete a partition that I never used. I have about 9 partitions set up and I clicked on the 7th one (when looking left to right in disk management) and clicked...

Thanks for your reply DonQuichote, I'm going to look into all this today and see if I can get it to work. I have a test server available to use so I will attempt anything on that first! It looks like it's not going to be straight forward to get putty working so it might be a little while...

Sorry, I meant mysql_dump, not mysql_admin in my first post! that wouldn't have done much eh :) Yes I am working on a mac, do I need to use putty or can I just do all this from shell? if I set up a tunnel between my local machine and a certain port on the remote server: - Can I transfer...

Hi, I need to copy a database from a remote server where I have ssh access to my local computer. Can anyone tell me how to do this? I was thinking something like this: - login to ssh $mysql_admin database_name | local_pc (very simplified) Any help would be appreciated. Thanks. Chris...

Hi, I need to copy a database from a remote server where I have ssh access to my local computer. Can anyone tell me how to do this? I was thinking something like this: - login to ssh $mysql_admin database_name | local_pc (very simplified) Any help would be appreciated. Thanks. Chris MacPherson

Hi, I'm just starting Java development and am looking for a nudge in the right direction. I'm going to be using J2ME and I want to create a menu which is structured as a grid with each cell holding a button. I want a full screen app and so would like the menu to resize itself for different...

Hi, I think I have solved my problem. I think it does what I want normally anyway, the link does not appear in preview. Probably a very newbie oversight :) Chris MacPherson

Hello, Does anyone know if I can include a subreport on another report so that it actually shows it's data instead of a link to the subreport. Been having a search but can't find any relevant posts. Chris MacPherson

hi, thanks for quick reply. No the sql hasn't been changed in any way. I am running version 4.1.7. I have actually tried to complete my solution using a different path now (which I should probably have been using anyway) because I cant find any information on this problem. Instead of dumping...

Hello, I am getting going with transactions too at the moment. If you look at his part of the manual it explains it quite well. http://dev.mysql.com/books/mysqlpress/mysql-tutorial/ch10.html Especially these lines in your case: I would understand this to mean that if the user closed the...

Hi All, I have been using mysqldump for a while now, but have just come across a problem. I am using the mysqldump program from PHP to dump the database into a file. This works fine. I then try to feed that sql from the file back into mysql to recreate the database, like a backup procedure...

No exceptions do not stop program execution straight away. They are useful as they allow the opposite and therefore you can deal with any exceptions (errors) that are thrown(triggered). You use exceptions by writing try/catch blocks in your code: try { // Do something here } catch...

Thanks for the link however I was hoping there would be something free to use. I dont really have funds for this type of thing. Chris MacPherson

I dont have an apple computer but I know my web site designs will be affected by the browsers used on these computers. Is there any tools I can use that will show me what my site looks like on a mac? Chris MacPherson

Thanks, that sounds pretty certain! :) Cheers for you help Chris MacPherson

Thanks r937, That works fine. Would you say this is an overcomplicated query now. Do you think it would be better programming to do this last issue with a new query? I only ask as I am still a relative beginner in SQL and want to go the right way. Thanks for your help. Chris MacPherson

Ok, the above problem was sorted. Nice one:) I do however want to add one more column to the resulting table though. I'm not sure if this is possible as I have been trying to do it and researching joins for a while today now. Anyway, here is what i want to add: I have another table called...

I think I've solved it, not sure if it's the best method though. Below is my SQL: select projects.title , sum(case when bugs.pId = projects.pId then 1 else 0 end) as bugs , sum(case when status=1 then 1 else 0 end)...

Some extra information... I just tried the same SQL as above but altered the bug status in the database so it was a '1'. like below table bugs ---------------------------- bId pId status 1 1 1 ---------------------------- This gave me the following results...