RE: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

Yes dad. (FWIW, my kids know that is the answer to many if not most questions.) Cheryl D Wise MS MVP FrontPage http://by-expression.com Online instructor led training http://starttoweb.com -Original Message- From: r937 > One things that frustrates me, is how am I supposed to figure

RE: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

Rudy's in Canada. Where I can assure there is beer. And to my (almost) horror I can actually follow what Rudy is doing. To me that is scary since I do NOT like to write code. Cheryl D Wise MS MVP FrontPage http://by-expression.com Online instructor led training http://starttoweb.com -Ori

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

And I've got it... (well, it'd be close to say you've got it, but you know ;-p ) I've learnt another little string to the sql bow, cheers again Rudy.. Now if I can just remember it!!! ;-p On 04/12/06, r937 <[EMAIL PROTECTED]> wrote: > Ok, So when I put my WHERE clause, just before GROUP BY,

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

Ok, So when I put my WHERE clause, just before GROUP BY, it gets an error... unfortunately, my crystal ball is down at the moment (it does this often, because it runs on windows) therefore you will have to show me the query oh, and please don't forget to mention what the error was What was

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

Ok, So when I put my WHERE clause, just before GROUP BY, it gets an error... What was SELECT 1 all about, I've never seen that before... Trying to tweak! Yoda man still! On 04/12/06, r937 <[EMAIL PROTECTED]> wrote: > I tried to adda region filter, which is in a table jsut liek the > opt

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

I tried to adda region filter, which is in a table jsut liek the option select.. no, sorry asset-to-assetPropertyOption is one-to-many if you add another join to the query with a ~different~ one-to-many relationship, you will end up with cross join effects (each of three regions will join w

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

I know I know ;-p So.. I tried to adda region filter, which is in a table jsut liek the option select.. assetRegion: assetId regionId Using this: (but if I search for more than one region, I get nothing, searching for ONE region, I get correct results.. :-( ) It looks the SAME to me!!! WAAA

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

One things that frustrates me, is how am I supposed to figure this stuffout on my own without someone in the know to hand hold me :-( practice, practice, practice! ;o) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the w

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

Wow.. kewl!! I'm playing making t all dynamic, and adding some more filters I need. ( i didn't tell you bout all of the options, cause I wanna do it myself...) It's looking GREAT though. One things that frustrates me, is how am I supposed to figure this stuffout on my own without someone in the

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

I need to say, optionId = 1 AND (4 or 6 or 6) etc... that's what the HAVING clause does ;o) I don't understand whats happening at teh bottom of the query.. can you dumb it down for me? use the ON clause of the join to select only those rows you're interested in -- and assetPro

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

yoda man.. again... So, help me learn ? pretty please... ? I need to say, optionId = 1 AND (4 or 6 or 6) etc... I get how you've redone the latest aset version call, nice one.. I don't understand whats happening at teh bottom of the query.. can you dumb it down for me? Whee do you live? an

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

select asset.id , asset.naturalName , assetVersion.fileName , assetVersion.fileNameThumb , assetVersion.dateCreated , assetVersion.size , asset.assetVersionId from asset inner join assetVersion on assetVersion.assetId = asset.id on assetVersion.versionNumber =

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

On 12/4/06, Tris <[EMAIL PROTECTED]> wrote: LOL... funny cause it's true.. he's pretty much saved my arse too any time sthis month.. MUST repay him soon!!! rudy's helped a lot of us. He must be pretty much in his cups most of the time on all the virtual beer he's earned. • The WDVL Disc

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

LOL... funny cause it's true.. he's pretty much saved my arse too any time sthis month.. MUST repay him soon!!! On 04/12/06, Drew Trusz <[EMAIL PROTECTED]> wrote: On 12/4/06, Tris <[EMAIL PROTECTED]> wrote: > I wanna holiday!!! > > I've an asset table: > id > name > fileSize > date > > > and a

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

On 12/4/06, Tris <[EMAIL PROTECTED]> wrote: I wanna holiday!!! I've an asset table: id name fileSize date and an options table: id name and finally a table to match them up assetPropertyOption: assetId optionId I want to pull all assets that appear in the match table, based on what options