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