What's annoyed you today??

[Duffy1964]

The dog......

Was it the Dulux dog

[VTRDark]

Waiting around for parcels to turn up.

(:-})

[mattblackone]

RAIN was gonna take the bike out for a blast only done about 50 miles on it so far

Bill

[lloydie]

RAIN was gonna take the bike out for a blast only done about 50 miles on it so far

Bill

Ride in the rain :-)

[Virt]

My brother and Dad.

I'm trying to resist the temptation for something and they keep convincing me to go and do it. It's frustrating Really want to do it, but not sure if now is the ideal time :/

[Duffy1964]

My brother and Dad.

I'm trying to resist the temptation for something and they keep convincing me to go and do it. It's frustrating Really want to do it, but not sure if now is the ideal time :/

It's ok Virt, you can come out, your freinds on the forum will understand

[Virt]

It's ok Virt, you can come out, your freinds on the forum will understand

To hell with that! no one can know about my nocturnal, homos--

Nothing.

I really like ZXR400's. Loads. My brother and dad keep teasing me and telling me to get one. It's so hard to resist

[Duffy1964]

Nooooooo That is far worse than I thought, mentioning a Kwacker on a Storm forum.

Ban Him Carl

[Virt]

Ban Him Carl

This is general chat, Carl can't do sh1t

[Duffy1964]

Ban Him Carl

This is general chat, Carl can't do sh1t

Love it

He will get you though

[Virt]

Love it

He will get you though

Nah I don't enter the sales section enough for him to lord his power over me

Also, he's already blamed 1 thing on me in advance. This will probably use that advanced blame up, making it even

[VTRDark]

(:-})

[MacV2]

It's ok Virt, you can come out, your freinds on the forum will understand

To hell with that! no one can know about my nocturnal, homos--

Nothing.

I really like ZXR400's. Loads. My brother and dad keep teasing me and telling me to get one. It's so hard to resist

MAN up & tell then to F off.

But if you do lilly livered cave in get a green one, only proper colour for a Kwak.

[Virt]

I caved in. I'll look at getting one after y 19th I think. Wait until the trackday has been done.

The one I'm talking to the owner of is green. But I'm thinking of getting a custom paint job. Or one off a racing Kawi not sure. That's all for next year

I'm mostly getting it so I have to bike to wombles about with while still keeping one bike on the road. Everyone said the best way to learn was practice and exploring


Sent from my iPhone using Tapatalk

[Virt]

MySQL

So I've got a query, one of the columns I'm returning is dynamically created.

Code: Select all

 SELECT DISTINCT
...
COALESCE( GROUP_CONCAT( Tag.Name ),'' ) as 'Tags' 

Now when I'm looking for the column all is fine, however one of the functions I've had to implement into the table that uses the query is a search. Done that, easily. It will search on everything but the 'Tags'. Because 'Tags' have only recently been added ( basically this morning ) I need to now search and filter on them. However because this table is created with a GROUP_CONCAT I cannot think of any way that it's possible. Google doesn't help me either..

So basically I'm wombles

Fixed it now, huge query I dislike this fix but meh. It's only temporary