|
-
Feb 17th, 2000, 08:41 PM
#1
Thread Starter
New Member
hi,
i got a user database with a field which contains several attributes formatted like ' 1 1 1 1'
1 means available, and the position referers to the attribute (eg. position 3 means telephone)
i'd like to be able to do a selection like:
get all with phone + fax
the query would be (where mid(attr,3,1) ='1' and mid(attr,5,1)='1')
ok - but now the problem.
i have a stored procedure and need a variable option to feed it with the attributes required.
eg.
procedure1:
get all with phone + fax + email
-> result -> procedure2
i can't set up usual parameters as i need to have optional parameters.
how can this be done?
thanks,
.tOm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|