who's an SQL wizzard, or knows one?? - Computer music & technology forums

Forums - Computer music & technology

Subject: who's an SQL wizzard, or knows one??

Viewing all 8 messages - View by pages of 10: 1

Original Message 1/8 05-Sep-00 @ 07:23 AM - who's an SQL wizzard, or knows one??

Posts:

Link?: No link

File?: No file

seeking help with one SQL query - anyone wanna go ?

[ back to forum ] [quote]

Message 2/8 05-Sep-00 @ 08:07 AM - RE: who's an SQL wizzard, or knows one??

yams

Posts: 83

Link?: No link

File?: No file

go ahead.

[ back to forum ] [quote]

Message 3/8 05-Sep-00 @ 10:36 AM - RE: who's an SQL wizzard, or knows one??

99devils

Posts:

Link?: No link

File?: No file

I can help you with that too. Post it up.

-Craig

[ back to forum ] [quote]

Message 4/8 05-Sep-00 @ 11:01 AM - RE: who's an SQL wizzard, or knows one??

formant

Posts: 316

Link?: Link

File?: No file

yeah post it k...

we are all eagerly awaiting the challenge.

jamey

[ back to forum ] [quote]

Message 5/8 05-Sep-00 @ 11:53 AM - RE: who's an SQL wizzard, or knows one??

99devils

Posts:

Link?: No link

File?: No file

Look at all the pathetic geeks

Unfortunately, it's probably more interesting than what I'm working on right now... Health insurance... Puuukkkkeeee

-Craig

[ back to forum ] [quote]

Message 6/8 05-Sep-00 @ 01:16 PM - RE: who's an SQL wizzard, or knows one??

Posts:

Link?: No link

File?: No file

right !! - try this one then -

i have an MS database... it has a table for members - in the members table is a feild called for the sake of arguement: 'member_category_id'

right, this feild is a text feild, it contains at least ONE number (one or two digits/places) - it can also contain multiple numbers... when more than one number is allocated the feild contains a comma delimited list - eg: 2,4,5,8,11,13,15,21,24

now, i want to query this table with an SQL query -

i want the query to search each row, look in EACH rows' delimited list ('member_category_id')

IF the calling ID number (carried to the query as a variable) is present in that Feild's delimited list, it return the record/row

i need to add an 'AND' statement at the end of this query, so it seeks out the variable from each rows' list/feild, then if that variable is present i can also search by further criteria inside the same SQL query -

ok... go to it !! - answers by mail please - kilo@realitycom.com - to make it more interesting, i'll offer a 'mystery prize' to the winner - i've wanted to get an answer for this for a while but never had time -

[ back to forum ] [quote]

Message 7/8 06-Sep-00 @ 12:28 PM - RE: who's an SQL wizzard, or knows one??

Posts:

Link?: No link

File?: No file

aha.. Craig fixed it... tha Don !!

[ back to forum ] [quote]

Message 8/8 06-Sep-00 @ 12:31 PM - RE: who's an SQL wizzard, or knows one??

99devils

Posts:

Link?: No link

File?: No file

Who's your daaaaddddyyyyyyyyyy!?!?!?

-C

[ back to forum ] [quote]

Viewing all 8 messages - View by pages of 10: 1

There are 8 total messages for this topic

Reply to Thread

You need to register/login to use the forum.

Click here to Signup or Login !

[you'll be brought right back to this point after signing up]

Back to Forum