Search results for query: *

Tell you what, forget about it. I will go else where.

Yep "yum update pango" because I need to update/upgrade the current installation of Pango of my machine. I have tried both update and upgrade and neither update or upgrade the current installed version. yum search pango ? Not sure what this will do? man yum tells me that it is used to find...

Hi there I am trying to install Dia on my Fedora 7 laptop and when I run the configure it tells me the version of Pango is too low and I need 1.1.5 or higher. I am struggling to work out how to upgrate this, yum upgrade pango does not do anything, and looking at...

JarlH, thank you very much! This has helped me to solve my problem!!! In answer to your question, that is my typo it should have been results.votes not party.votes. Either way your info helped me. Now can I ask one more question..... I don't completely get it!!! I know this is terrible, but...

I have two tables, results and constits. In Constits I have area, in results I have party and votes. So results has, for each party the number of votes cast, and further to this an id col in results links it to constits. I want to see: SELECT constist.area, results.party, party.votes...

Yours is more succinct, Alex's helped me to remember and understand.

PHV, yes it does work. Alex's made me see the light, but yours is correct. Thank you.

Hi Alex Your answers helped a lot! This is what I am using: SELECT a.part_no FROM (SELECT DISTINCT part_no, city FROM leTable WHERE city = 'LONDON') a, (SELECT DISTINCT part_no, city FROM leTable WHERE city = 'FRANKFURT') b WHERE a.part_no = b.part_no Perfect!!!!

Hi there Been away from SQL for about a year and I am really struggling on something I think is rather basic. I have a table, PARTS, it contains the following two columns Part_No and City, I want to return all Part_No where the city for that Part_No is London and Frankfurt. See sample below...

funny you ask how I am coming to the conclusion. I am trying to prove to another guy that his suggestion, currently in place, to bcp out, drop, create table, and bcp in the data will reclaim space (that he can't "prove" needs to be reclaimed) at table level. The reason I ask is I know you can...

My tables are not parallel, but the deallocate is good for me. Is this as good as exporting, dropping, creating, and importing the table?

Hi there Could you tell me the best way to reclaim unused space in tables. Currently our process is to BCP the table out, drop the table, create the table, BCP the data in and create the indexes? I have tried searching for an artical on this, but am struggling to find anything concrete. Thanks

Hi there Could you tell me the best way to reclaim unused space in tables. Currently our process is to BCP the table out, drop the table, create the table, BCP the data in and create the indexes? Does DBCC save this procedure. I have tried searching for an artical on this, but am struggling to...

Perfect, thank you.

Sorry, 1 day.

I can't work out how to return a whole number from select sysdate-stamp from foo; where stamp is a timstamp column with a default value of sysdate. All I want ot do is minus the two and capture all rows where the difference is 1.

Hi there New to PHP and am struggling with a simple program I want to write. I have an HTML page which asks for a date (i.e. what date did you attend the course), I then get that data and populate a constant with it via $_POST['date_entered']. I now want to take that date and populate a...