Questions tagged [in-function]
10 questions
78
votes
4 answers
MySQL ORDER BY IN()
I have a PHP array with numbers of ID's in it. These numbers are already ordered.
Now i would like to get my result via the IN() method, to get all of the ID's.
However, these ID's should be ordered like in the IN method.
For example:
IN(4,7,3,8,9) …
Henk Denneboom
- 1,573
- 3
- 15
- 18
51
votes
16 answers
SQL Server using wildcard within IN
Since I believe this should be a basic question I know this question has probably been asked, but I am unable to find it. I'm probably about to earn my Peer Pressure badge, but I'll ask anyway:
Is there a way in SQL Server that I am not aware of for…
Dusty
- 4,667
- 3
- 29
- 35
2
votes
2 answers
linq where clause not in select statement
Can someone help me to convert from SQL Query to LINQ VB.NET:
select rls.* from Roles rls(nolock)
where rls.id not in (
select r.ID from usersRole ur (nolock)
inner join Roles r(nolock) on ur.RoleID = r.ID
where user_id = 'NY1772')
Thanks
Annie
1
vote
6 answers
Python if...in.. statement. Check for vowel in word
I'm trying to check if the user input contains a vowel or not. However, I've only found how to check for one vowel at a time, but not all.
vowel = ("a")
word = input("type a word: ")
if vowel in word:
print (f"There is the vowel {vowel} in your…
Jean-Philippe Defrenne
- 21
- 1
- 2
1
vote
1 answer
Hide the in-function plot from R package
I am using the R package "GeoDE". When I use the function "chdirAnalysis", a figure will be plotted automatically, since there is a command "plot" in the source code of "chdirAnalysis". But I don't want that. How can I stop this?
A similar problem…
Xiaokang
- 331
- 1
- 11
0
votes
0 answers
Python reading text file and using the in function
I am learning how to program in python for school and I apologize if my question is very basic. But I am attempting to have python read a txt file on my macbook that is called word.txt for an exercise for a book called think_python for class. Below…
Tien
- 1
0
votes
2 answers
python function in function call on variable
this is the assignment
Write a function partial that takes another function and a value as in data.
Partial should return a new function with the same function as the given function but there the first argument to the given functuin is bound to a…
Jim
- 61
- 1
- 8
0
votes
2 answers
SQL Server 2008 NOT IN() seems to fail
I am building a suggestive tagging system (sounds seedy), I pass in a string to the db and if there is a match it sends back that tag. I want to stop duplicate tags, so if one tag is WEB, I only want it to be returned once. So if I had WEB as a tag…
jamesmhaley
- 44,484
- 11
- 36
- 49
0
votes
4 answers
MySQL IN problem
I'm trying to use the value of another field inside an IN.
SELECT types.id, title, auth_users.types
FROM types
LEFT JOIN auth_users ON auth_users.id IN (8,9)
WHERE types.id IN (1,2,3)
GROUP BY types.id
Works
SELECT types.id, title,…
Henk Denneboom
- 1,573
- 3
- 15
- 18
-1
votes
3 answers
Oracle: IN function within an IF block
I have a cursor c2, with one column 'note', containing numbers.
I want to check, whether the column contains 5 and change my local variable if so.
this:
CREATE OR REPLACE PROCEDURE proc
IS
result varchar(50);
cursor c2 is
SELECT note
FROM …
IAM
- 895
- 2
- 13
- 30