paul_y3k

if anyones' interested in fornt ends etc, then I'd recommend a visit to http://www.digital-car.co.uk - and would further recommmend freeice as a front end. Not as complicated as RR but still does a great job.

or if you're with the AA .. phone them. They have a tool and do it all for you

I also got connection problems ... after speaking to rockstar it turned out that i needed to open a few more ports on the firewall. Even though it was set to allow ingoing and outgoing traffic !

An Expense of Supra's ? they may all be individual but surely thats a common item among them all

nail polish remover ...... i think.

cheers guys, i'm glad it's not just me thats getting confused with this. yep it's a legacy system so I can't change it. All I'm trying to do it get item1 and item3 for each job id. but yep the table doesn't really support it. and yep I've taken the adivce and has several beers and a curry

I'm going to ... but i dont understand where you are getting table two from ??

Dont think so. i know I'm not exapling this very well at all so thanks for bearing with me. lets try again ... the table is defined with the following columns : REF A_data b_data Each row consists of the job reference (REF), a work item (a_data) and it's associated value (b_data). We can have multiple items and values per job. So we see a table with the following contents REF a_data b_data 1 ITEM1 widget 1 ITEM2 doodahs 1 ITEM3 sprockett 2 ITEM1 big widget 2 ITEM2 big doodah 2 ITEM3 big sprockett 3 ITEM1 small widget etc etc I need to select the b_data for ITEM1 and ITEM3 for a given reference. i.e SELECT b_data where REF=1 and a_data=ITEM1 and a_data=ITEM3. to get a returrn of 1 widget sprockett However that piece of sql returns no rows, and using OR doesn't seem to help either. So my problem is in the where clause ? or is it due to a poor table structure ?

i think my second example has confused things. so lets forget about the second table stuff for the moment. All I want is the values from the table where name = first and name = third. ie. 1 FRED DOG but the and keyword doesn't work.

yep thats right, i think. I'm going to create a second table, lets call it test. which will be populated from this select. i.e REF ... FIRST ... THIRD 1 Fred Dog

i know there's a few dba's on the site, and once again I need some help. i've inherited a sql table that is structured as ref name value ------------------ 1 first fred 1 second hello 1 third dog 1 fourth cat so basically a set of values for a reference. i'm trying to pull out a couple of those values, for a given reference, but my sql isn't up to much. i.e ref value 1 fred,cat select name where ref=1 and value='first' and value='third' doesn't work, and I dont think I should be using or. from reading my limited library I'm not sure it's acually possible ?

or try maplins ?

i like to play FPS type games on the pc, but I find im really struggling to adapt to the ps/3 controller. why cant i just plugin a mouse and keyboard to the ps/3 for these games !

Had to join in ... the view from the 'rents back garden, Spain rather the greece though.

It's getting quite out of hand in Swindon at the moment. http://www.adver.co.uk/display.var.1675590.0.dont_drive_us_down_say_car_modifiers.php and http://www.topsecretcruising.co.uk/forums/index.php?showtopic=17836&hl=adver&st=40

Nope ... but why does that sound like the first line to a really dodgy joke !

fraid not. you have to get a form from the post office, fill it in and send it off to the DVLA. cant remember the exact rules but if you send it and it arrives on the 2nd of the month then that month wont be refunded. i.e if you have Jan feb and Mar outstanding, send it in dec, but it arrives in Jan. you will only get feb and March refunded.

I guess you mean 6 flags in Arlington ? If so i used to live in Arlington and i know the place you mean. Rather than do that one, go to one of the places in Fort Worth by the Rodeo. OR if you even more meat then go to ..... http://www.fogodechao.com/dining.htm it's an argentinian steak house, where you get a little two sided card, red and green. when the card is green, the constantly serve you different cuts of meat !

not only is Torchwood an anagram of Doctor Who, it's what used to be written on the Dr Who film cans to stop them being nicked.

There is some sort of prof qualification that you get ... something like crba ? the msce of the HR world as it were. As soon as my mate gets home from work I'll ask her as she has it.

well 90% of my friends partners are from outside of Swindon.

in Swindon .. they normaly have their own teeth, but the problem is they also have other people imbeded n their handbags. You need to look for the girls with the scar on the shoulder that shows the 2nd head was removed.

my id is paul_y3k only got Motostrom, Dirt and Tiger woods at the moment. Can you play COD4 etc with a keyboard and mouse plugged into the usb ports ?

why did i expect the Death Star to come up in the youtube demo !

it was only one vulcan that went all the way. They did repair the runway, but it was not a great repair and the runway was incabaple of supporting the heavy jets which thus had to fly out of argentina and by the time they were on station they didn't have enough fuel to loiter ... soo not really a waste of time then.