Click here to Skip to main content
15,505,916 members
Home / Discussions / Database
   

Database

 
GeneralRe: Error when passing multiple values Pin
Mycroft Holmes15-Aug-16 14:02
professionalMycroft Holmes15-Aug-16 14:02 
QuestionHow do Coders Get Database Experts? For a project Pin
TheOnlyRealTodd8-Aug-16 21:58
professionalTheOnlyRealTodd8-Aug-16 21:58 
AnswerRe: How do Coders Get Database Experts? For a project Pin
Mycroft Holmes9-Aug-16 14:04
professionalMycroft Holmes9-Aug-16 14:04 
AnswerRe: How do Coders Get Database Experts? For a project Pin
Nathan Minier10-Aug-16 2:21
professionalNathan Minier10-Aug-16 2:21 
AnswerRe: How do Coders Get Database Experts? For a project Pin
jschell12-Aug-16 12:15
jschell12-Aug-16 12:15 
QuestionHow to pass varchar as WHERE field IN param Pin
Jassim Rahma5-Aug-16 6:14
Jassim Rahma5-Aug-16 6:14 
AnswerRe: How to pass varchar as WHERE field IN param Pin
Mycroft Holmes5-Aug-16 14:04
professionalMycroft Holmes5-Aug-16 14:04 
AnswerRe: How to pass varchar as WHERE field IN param Pin
David Mujica9-Aug-16 7:20
David Mujica9-Aug-16 7:20 
After looking at your code, are you sure the value of the "param_country" is a quoted, comma separated list of values ?

For example an IN clause would look like this: "select * from myTable where location in ('USA','CANADA','MEXICO')

Check the value of the sql_command.Parameters("param_country") right after you populate it with values.

BTW: There may be limitations to the number of values you can have in an "IN" clause. I remember from a while ago Oracle had a 1000 item limit, just something to think about.

david
QuestionIs this SQL query about getting information from all forum users' unread PMs? Pin
Member 1266244831-Jul-16 2:41
Member 1266244831-Jul-16 2:41 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen31-Jul-16 3:20
professionalEddy Vluggen31-Jul-16 3:20 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624481-Aug-16 3:04
Member 126624481-Aug-16 3:04 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen1-Aug-16 8:35
professionalEddy Vluggen1-Aug-16 8:35 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
User 1106097931-Jul-16 3:23
User 1106097931-Jul-16 3:23 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624481-Aug-16 3:01
Member 126624481-Aug-16 3:01 
QuestionRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
User 110609791-Aug-16 3:07
User 110609791-Aug-16 3:07 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 2:04
Member 126624485-Aug-16 2:04 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming1-Aug-16 3:21
mveRichard Deeming1-Aug-16 3:21 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen1-Aug-16 11:55
professionalEddy Vluggen1-Aug-16 11:55 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 2:21
Member 126624485-Aug-16 2:21 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming5-Aug-16 2:56
mveRichard Deeming5-Aug-16 2:56 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 2:20
Member 126624485-Aug-16 2:20 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming5-Aug-16 2:53
mveRichard Deeming5-Aug-16 2:53 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 10:14
Member 126624485-Aug-16 10:14 
QuestionSearching for the right database Pin
Kogs-7927-Jul-16 4:04
Kogs-7927-Jul-16 4:04 
SuggestionRe: Searching for the right database Pin
Richard MacCutchan27-Jul-16 5:56
mveRichard MacCutchan27-Jul-16 5:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.